BY
LANF, source: http://www.linuxaid.com.cn/forum/
BY JAWA from LinuxAid Forum 1 The Redhatlinux 9 Personal Simplified Chinese version is completely installed (5GB), after the installation is completed, Mysql 3 and Mozilla 1.2.1 and other software have been installed in Linux. This note is aimed at the original MySQL comes with Linux, and Mysql is not installed. In order to automatically load the above software and open the necessary port when the system starts, log in and runs in the root user and runs: 1. Select the FireWall Configuration item, select the Customize item, then select the WWW (HTTP) item After determining it. This allows the system to open HTTP's 80-port feature. (You must select it) 2. Select the NetWork Configuration item to fill in the corresponding network address (eg 192.168.1.11) at the IP AddRES, fill in the corresponding mask at Netmask (eg 255.255.25 5.0) ), Determine the exit. This has a fixed IP address. 3. This note is directed to the Apache server in Linux, select the System Services item, do not select the [] httpd item, and then exit. This allows the system not automatically launch Apache software when starting next time. 4. Use Linux original mysql as a database: Select the mysqld (system database) item, select the mysqld item, and then exit. This allows the system automatically launches MySQL software when starting next time. 2 Development and application software: 1. Redhat Linux 9.0 Simplified Chinese Personal (Redhat's Linux operating system) 2. Java 2 Platform, Enterprise Edition 1.4 (Sun's Enterprise Java Application Server [included J2SE SDK 1.4.2 and Web Server Wait]) 3. MySQL version 4.0.17 (MySQL database management system) 4. MySQL Connector / J 3.0.10 (MySQL JDBC driver) 5. James 2.1.3 (Apache's E-Mail Mail Server) 6. Mozilla 1.6 (Mozilla's web browser) 7. Mysqlcc version 0.9.4 (MySQL database control center) 8. J2ME MIDP version 1.0 (J2ME mobile device outline) 9. J2ME CLDC version 1.0 (J2ME connection limited device configuration 10. J2ME Wireless Toolkit 1.0 (J2ME Wireless Device Development Kit) 3 Main Software Download: 1. J2EESDK-1_4-Dr-Linux-Eval.bin at http://java.sun.com/j2ee/1.4/downloadload -dr.html download. 2. MySQLCC-0.9.4-Linux-glibc23.tar.gz Download at http://www.mysql.com. 3. MySQL-Standard-4.0.17-PC-Linux-i686.tar.gz Download at http://www.mysql.com/downloads. 4. MySQL-Connector-Java-3.0.10-stable.tar.gz is downloaded at http://www.mysql.com/downloads.
5. Mozilla-i686-PC-Linux-gnu-1.6-sea.tar.gz Download at http://www.mozilla.org. 6. James-2.1.3.tar.gz Download at http://james.apache.org. 4 Main software installation: 1. J2EE SDK 1.4 Installation: 1) #CP J2EESDK-1_4-DR-Linux-Eval.bin / usr / local // copies the J2EE SDK 1.4 to the / usr / local directory. 2) #CD / usr / local // Enter this directory. 3) #. / J2eesdk-1_4-dr-linux-eval.bin // Run the program, the system will automatically install it into the / OPT / SUNWAPServer directory, fill in: admin and its password, admin port: 4848, http Port: 80, https port: 1043, select "Don't Prompt for Admin User Name," If you encounter "XXXX Port May Be in Use.Specify A Different Port", indicating that this port is being used, please change to other ports. number. (Including J2SE SDK 1.4.2, Application Un One Message Queue 3.5, PointBase Server 4.6) 2. MySQL 3 Settings: Log in with root, in SETUP SYSTEM Services item, to select the mysqld item, determine it. The system will automatically start MYSQL software. #mysql_install_db // First Run: Create a MySQL Authorization Form
Add:
#mysql -u root mysql // Enter MySQL with root users and open the mysql database
MySQL> Set Password for root = password ('password');
Enter MySQL in the future: "# mysql -uroot -p password" mode. 3. MYSQLCC installation:
#CP mysqlcc-0.9.4-linux-glibc23.tar.gz / usr / local
// copy mysqlcc 0.9.4 to the / usr / local directory.
#CD / USR / LOCAL
#tar -xvzf mysqlcc-0.9.4-linux-glibc23.tar.gz
// Decompose this file and automatically generate the /usr/local/mysqlcc-0.9.4-linux-glibc23 directory.
// Run /usr/local/mysqlcc23/mysqlcc file in the KDE environment,
/ You can execute the Mysql console program.
#LN -S /USR / LOCAL /MYSQLCC-0.9.4-Linux-glibc23 mysqlcc // Generate connection quick directory
4. MySQL Connector / J Installation: Simply extract MySQL-Connector-Java-3.0.10-stable.tar.gz to find the mysql-connector-java-3.0.10-stable-bin.jar file and copy it to / Opt / sunwappserver / lib directory. 5. James installation:
#CP james-2.1.3.tar.gz / usr / local // copies the james-2.1.2.tar.gz to the / usr / local directory.
#CD / USR / LOCAL
#tar-xvzf james-2.1.3.tar.gz
// Decompose this file and automatically generate the /usr/local/james-2.1.3 directory.
#LN -s /usr/local/james-2.1.3 James
// Generate a connection quick directory.
#CD / USR / Local / James / Bin
#CHMOD X run.sh
// Change the run.sh file properties.
#CHMOD X Phoenix.sh
// Change the Phoenix.sh file properties.
5 Main software configuration: (Note: The following configuration files can only be edited with the command line to edit, remove excess space, especially the "^ @" and other characters of the row!) 1. #VI / ETC / profile Editing System Environment Profiles, add the following lines:
PATH = $ PATH: / OPT / SUNWAPSERVER / JDK / BIN: / OPT / SUNWAPSERVER / BIN: / USR / local / james / bin
Export Path
Java_Home = / OPT / SUNWAPSERVER / JDK
Export java_home
2. #vi / etc / bashrc Editing the system automatic batch file, add the following:
Run.sh
/ / Means that the James service is also started when the system is self-start, pay attention: POP3 (110), SMTP (25), IMAP (143),
// NNTP (119), Sockets (1024), Telnet (4555) cannot have conflicts.
/ OPT / SUNWAPSERVER / BIN / Asadmin Start-Domain Domain1
/ / Means that the J2EE Application Server service is also started when the system is boosted.
// Note: Stop service / opt / sunwappserver / bin / asadmin stop-domain domain1
Note: The above configuration files can only be edited with the command line to edit, remove excess space, especially the characters such as "^ @"! Otherwise, J2EE Application Server cannot start normally. 3. You can modify the Domain.xml and default-web.xml of the / OPT / SUNWAPSERVER / DOMAINS / DOMAIN1 / CONFIG directory: ... After installing and configuring, you need to restart Linux. When you enter Linux again, the system will automatically start J2EE Application Server, James, and MySQL, you can use Vi /opt/sunwappserver/domains/domain1/logs/server.log to view the startup situation. 6 Introduction to the main software: 1. J2EE Application Server: 1) Execute directory: / OPT / sunwappserver / bin. 2) J2se SDK directory: / opt / sunwappserver / jdk. 3) User web root directory: / OPT / sunwappserver / domains / domain1 / doch. 4) Public Class library directory: / OPT / sunwappserver / lib. 5) User Class library directory: / opt / sunwappserver / domains / domain1 / docroot / user web directory / web-inf / classes. 6) Profile: / OPT / SunwappServer / Domains / Domain1 / Config Directory Domain.xml and Default-Web.xml. 7) Store user JSP SERVLET files automatically compiled: / opt / sunwappserver / domains / domain1 / generated / jsp / j2ee-modules / default-web-module-server / org / apache / jsp / user web directory name /. 8) Super User Management Interface: http: // localhost: 4848 / asamin / index.html. 9) Notes: The J2EE Application Server needs to be restarted when there is a change in the public CLASS library. 2. Mysql: 1) Mysql Database Backup: #mysqldump Database Name [| Gzip]> Backup file name [.gz] (such as: *. Sql) 2) MySQL database recovery: #mysql -u root
MySQL> CREATE DATABASE Database name;
Mysql> quit
[#TAR XVZF Backup file name .gz] (decompression)
#mysql database 3) Mysql database deletion: mysql> DROP DATABASE database name; 4) deletion of mysql database table: mysql> Drop tables table name; 5) Mysql database record deletion: mysql> delete from table name where field name [= | < |>] Value; 6) Mysql database record Query: mysql> select field list from the name of the WHERE field name [= | <|>] value ORDER BY [DESC | ASC]; 7) MySQL Database Usage: MySQL> USE Database name; 8) Mysql database display: mysql> show databases; 9) Mysql database table display: mysql> use database name; mysql> show tables; 10) MySQL database version: mysql> select version (); 11) The permissions of the mysql database: #mysql -u root / / Add or modify the password for root users Mysql> USE Mysql; MySQL> Set Password for root = password ('password'); 12) The user's MySQL database is put on the / var / lib / mysql / user database name. 13) /etc/my.cnf file is a MySQL profile, a username and password containing a database.
