Install

Requirements

- Python 2.4 or later (www.python.org)
- OpenSSL / pyOpenSSL (www.openssl.org | http://pyopenssl.sourceforge.net/)

You need this if you want to use the Project Session Mode. (see Pantera Operational Modes)

- MYSQL 5.0 (Due to the use of TRIGGERS.)
- Python MYSQL wrapper (http://sourceforge.net/projects/mysql-python be sure to download it from sourceforge)

Installation Steps

1. Unzip pantera.zip leaving the directory structure.
2. Install MySQL 5.0 and python MYSQL wrapper (you only need to do this once if you want Pantera unmatched features available to you :)
3. Not necessary in later version of the Python Mysql wrapper: Modify the MYSQL 5.0 to use "MYSQL old-password style" (http://dev.mysql.com/doc/refman/5.0/en/old-client.html)
4. Use mysql client to create Pantera database. (Optional - you can create a user and password to use in panteradb):
   mysql> CREATE DATABASE panteradb;
5. Execute pantera sql script "pantera_sql_create_script.txt"
6. Use mysql client from command line:
   mysql -u <username> -p panteradb < pantera_sql_create_script.txt
7. Now run pantera as usually.
8. Hack :)

MySQL Install

Thanks to Rick for the Linux install steps:

cd /usr ; /usr/bin/mysqld_safe &
run mysql_install_db
PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
To do so, start the server, then issue the following commands:
/usr/bin/mysqladmin -u root password 'new-password'
/usr/bin/mysqladmin -u root -h changeling password 'new-password'
:passw0rd!
First, use the mysql program to connect to the server as the MySQL root
user:
shell> mysql --user=root mysql
If you have assigned a password to the root account, you'll also need to
supply a --password or -p option for this mysql command and also for
those later in this section.
After connecting to the server as root, you can add new accounts. The
following statements use GRANT to set up four new accounts:
mysql> GRANT ALL PRIVILEGES ON *.* TO 'monty'@'localhost'
-> IDENTIFIED BY 'some_pass' WITH GRANT OPTION;
mysql has 2 default anonymous accounts. to remove those:
Anonymous Account Removal
If you prefer to remove the anonymous accounts instead, do so as follows:
shell> mysql -u root
mysql> DELETE FROM mysql.user WHERE User = '';
mysql> FLUSH PRIVILEGES;

Home

2006 (C) http://www.roseslabs.com