autotestnet Code
Status: Beta
Brought to you by:
hansyin
--- a +++ b/hlp/Env_install @@ -0,0 +1,115 @@ +1. copy all files in Env_support_software directory to local directory + +2. run "tar xzvf Active******" to install ActiveTcl + +3. run command below to change PATH + PATH="/usr/local/ActiveTcl/bin:$PATH" + export $PAT + or you can put it in user's .bash_profile. + +4.Install and start mysql database (this step is only for Server side) + +.You can select to install database and application in one machine. +.Prefer to use Fedora 4 and built-in mysql4.11. + +.For Redhat9.0, there is pre-installed mysql3.23, run below command to check: + #rpm -q mysql + mysql-3.23.54a-11 + Then don't need install mysql again, just start mysqld service: + #service mysqld start + Starting MySQL: [OK] + +.For Fedora 4, there is pre-installed mysql4.11. check and start mysqld by below command + #service mysqld start + Starting MySQL: [OK] + +.Create user/password. create user root and set password as 123456 + #/usr/bin/mysqladmin -u root password 123456 +.Create a user(test) and setup privillege by mysql_setpermission (built-in application) + #mysql_setpermission -u root + then select 7->*->test->y->123456->123456->%->yes->127.0.0.1->no->yes->0 + +6.Install tcl interface for mysql database + #rpm -Uvh mysqltcl-3.01-0.i386.rpm + +the command will install mysqltcl to build-in Tcl directory. For ActiveTcl, we just need copy the installed file in Tcl8.x directory to ActiveTcl directory. + #cp /usr/lib/mysqltcl-3.01 /usr/local/ActiveTcl/lib/mysqltcl-3.01/ -r +then it will works in ActiveTcl + + + However, if you want to use it with other mysql database version such as 5.0.18. Then, it is suggested + that you download the mysqltcl-3.02.tar.gz. + tar -zxvf mysqltcl-3.02.tar.gz + (If you are using Fedora Core 5's installation of mysql, then just use the following) + ./configure --with-tcl=/usr/local/ActiveTcl/lib/tcl8.4 --with-tclinclude=/usr/ local/ActiveTcl/include/tcl8.4 --with-mysql-include=/usr/include/mysql --with-mysql-lib=/var/lib/mysql + make + make install + + After the install, the file will be installed under /usr/local/ActiveTcl/lib/mysqltcl-3.02. So, you don't have + to copy it from other directory. + + +7.Checkout env_setup code from SVN server +[root@pc1 hans]# svn checkout --no-auth-cache svn://172.18.7.201/hans/env_setup +A env_setup/cfg +A env_setup/cfg/database.cfg +A env_setup/log +A env_setup/lib +A env_setup/lib/tree1.tcl +A env_setup/lib/lib_from_qingxu.tcl +A env_setup/lib/textprops.tcl +A env_setup/lib/common_access.tcl +A env_setup/lib/proc_lib.tcl +A env_setup/lib/.common_access.exp.swp +A env_setup/lib/runtest_lib.tcl +A env_setup/lib/common_variable.tcl +A env_setup/data +A env_setup/main_env_setup.tcl +A env_setup/tags +Checked out revision 42. + +.This command will create an env_setup directory in current directory. all env_setup application file will be saved in this directory. + +8.Create/Backup database + .Create database by mysql application + # mysql -u root -p + mysql>create database testdatabase; + mysql>exit; + + .Import database structure file + # mysql -u root -p testdatabase <testdatabase_structure.sql + Enter password: + + .Backup database manually + mysqldump testdatabase -u test --password=123456 -h 127.0.0.1 -c -d>table_structure.sql + mysqldump testdatabase -u test --password=123456 -h 127.0.0.1 -c -t>table_data.sql + mysqldump testdatabase -u test --password=123456 -h 127.0.0.1 -c >table_structure_and_data.sql + +9.Edit Configuration file + . edit env_setup/cfg/database.cfg for database connection + set DB_SERVER "127.0.0.1" + set DB_USER "test" + set DB_PASS "123456" + set DB_NAME "testdatabase" + . edit env_setup/cfg/options.cfg for operator_ip and operator_name + set operator_ip "172.18.7.201" + set operator "hans" + + +10.Enjoy it + #cd env_setup + #wish8.4 main_env_setup.tcl +or #./main_env_setup.tcl + +11.Need help +Please take below steps: + 1. Read this file again + 2. Read Notes_of_MySQL_and_TCL.doc in this directory (or check lastest version in http://172.18.7.223 ) + 3. Come to bother me + +Contact: + Hans Yin + Phone: 604-4301063(ext 984) or 604-4301297(ext 213) + Email: hyin@fortinet.com + Skype: hans_yin_vancouver +