Title: Working on perl/mysql stuff
Subject: Setup nort center

 perl -e '
   use DBI; 
   $data_source="DBI:mysql:"; 
   $user_name=mysql_root; 
   $password="mysql-root-passwd"; 
   $dbh = DBI->connect ($data_source $user_name, $password [, \%attr]);

+----------+
| Database |
+----------+ 
| cacti    |
| mambo    |
| mysql    |
| recipedb |
| rogue    |
| test     |
+----------+
6 rows in set (0.06 sec)

 mysql> CREATE DATABASE phpaga;
 mysql> GRANT ALL PRIVILEGES ON dotproject.*
        TO dotproject@localhost IDENTIFIED BY
        "yourpassword" WITH GRANT OPTION;

% mysqladmin -uroot -pmy-passwd create phpaga
mysql -uroot -pmy-passwd
% mysql -uroot -pmy-passwd 
>GRANT ALL PRIVILEGES ON phpaga.* TO phpaga@localhost IDENTIFIED BY "phpaga" WITH GRANT OPTION ;
% mysql -uroot -pmy-passwd mysql < sql/phpagauser.sql
% mysql -uphpaga -pphpaga phpaga < sql/phpaga.sql
vi sql/phpagaadmin.sql
     # this user will have admin rights!  
     YOUR LAST NAME      # Last name
     YOUR FIRST NAME     # First name
     YOUR COMPANY NAME   # Set this to your name if you don't have a company
     YOUR_LOGIN          # Your phpaga (not db!) username     --- admin
     YOUR_PASSWORD       # Your phpaga (not db!) password     --- password
mysql -uphpaga -pphpaga phpaga < sql/phpagaadmin.sql
mysql -uroot -pmy-passwd mysql
mysql> flush privileges;
------------------------------------------------------------------------------------------
perl -MCPAN -e 'install  Net::SSLeay'

tar xzf adodbxxx.tgz
cp -R ./adodb/ /www-root/snortcenter/
echo 'CREATE DATABASE snortcenter;' | mysql -u root -p
#Note:  select, insert, update, delete must be granted to database, instert and delete for the install, but I don't know the syntax
echo 'GRANT ALL ON snortcenter.* TO snortcenter@localhost IDENTIFIED BY  "snort" WITH GRANT OPTION;' |mysql -uroot -p snortcenter

#Edit config.php
	$DBlib_path = "./adodb/";        #Path to ADODB directory e.g. "./adodb/" if you copied adodb into snortcenter dir
	$curl_path = "";                 #Path to curl binary if not defined in your default search path e.g. "/usr/local/bin/"
	$DBtype = "mysql";               #
	$DB_dbname   = "snortcenter";    
	$DB_host     = "localhost";
	$DB_user     = "snortcenter";
	$DB_password = "snortcenter";
	$DB_port     = "";
	$hidden_key_num = "286753";      #Random number for security e.g. "1562564"

mysql -usnortcenter  -psnortcenter snortcenter < /usr/local/httpd/www/snortcenter_db.mysql