Installation Steps
Pantera was developed on Windows XP SP2, so it's right at home on the Windows platform. These instructions should work for Window XP or Windows 2003 Server (any edition).
Be sure that you have already installled the Windows operating system and all of its necessary security patches.
Unzip Pantera's installation source. The default installation directory will be C:\Pantera_Release. Make sure that you keep the directory structure intact.
Note: An installer is in the TODO task list ;)
MySQL's installation is next. The most recent and stable version of MySQL at the time of this writing was version 5.0.27. If there's new version available, or if MySQL changes how it packages its database components, there's a chance the specific file names might be different.
The MySQL Community Server comes in two flavors:
- Essential: This package contains the bare minimum to run MySQL. It's contained in a file called something like mysql-essential-5.0.27-win32.msi.
- Complete: This contains everything in the essential package, plus additional components like benchmarking tools and a configuration wizard. You can find it in a file named something like mysql-5.0.27-win32.zip.
Pantera will work fine with either version. If you just intend MySQL to support Pantera, use the Essential package to conserve disk space.
Go to MySQL's website and download the package of your choice. These instructions will assume the essentials package (mysql-essential-5.0.27-win32.msi). Execute this package (it's a Windows installer) and adjust the defaults as needed. The default installation will go into C:\Program Files\MySQL\MySQL Server 5.0.
During installation, you'll specify a root password. Be sure to make a note of it; you'll need that in a few moments.
After installation's complete, you should add the MySQL bin directory to your system PATH. To do that, follow these steps:
- Right-click on My Computer
- Click on Properties
- Click on Advanced
- Click on the button labeled Environmental Variables
- In the System variables listbox, find PATH and click on it
- Click on Edit
- Scroll to the far right and enter C:\Program Files\MySQL\MySQL Server 5.0\bin
- Click OK three times
You should close any open MS DOS prompts and reopen them so they're recognize the new PATH. From an open MS DOS prompt, follow these steps to create the Pantera database and user:
- Open the MySQL command prompt: mysql -uroot -p<password you specified for root> mysql
- Clear out the TEST database: DROP DATABASE test;
- Create the Pantera database: CREATE DATABASE panteradb;
- Create the ID for pantera to use: GRANT ALL ON panteradb.* TO 'pantera'@'localhost' IDENTIFIED BY '<password>';
- Tell MySQL to start using the new permissions you just set: FLUSH PRIVILEGES;
- Quit MySQL and test your new ID and password: mysql -upantera -p<password> panteradb
If you get into MySQL, you're ready for the next step. Quit the MySQL client. Change to Pantera's doc directory (probably C:\Pantera_Release\doc). Create the Pantera tables with this command:
mysql -upantera -p<password> panteradb < pantera_sql_create_script.txt
Use these steps to install Python, OpenSSL, and the Python Interface to the OpenSSL Library:
- Download python-2.4.4.msi
- Run the program and accept its defaults. It should install to C:\Python24.
- Using procedures similar to adding MySQL's bin directory to the path (see above), add the Python installation directory to the PATH.
- Close and reopen your MS DOS prompt to be sure it sees the new PATH.
- Download MySQL for Python (MySQL-python.exe-1.2.1_p2.win32-py2.4.exe).
- Run the program and accept its defaults.
- Download OpenSSL (Win32OpenSSL-0_9_8d.exe).
- Run the program and accept its installation defaults.
- Download Python's interface to OpenSSL (pyOpenSSL-0.4.win32-py2.0.exe).
- Run the program and accept the installation defaults.
At this point, the environment's ready for Pantera. There's just one more step to go before Pantera's ready to run. Copy C:\Pantera_Release\panteracfg.xml to panteracfg.xml.original. That gives you a backup copy in case things go terribly wrong. Edit panteracfg.xml and navigate to the very bottom. You should see some tags like <db_login> and <db_password>. Change them to look like this:
<db_login>pantera</db_login>
<db_password>password</db_password>
<db_host>localhost</db_host>
<dbname>panteradb</db_name>
It's time to see if all of your hard work paid off! From C:\Pantera_Release, run this command:
runme.bat
If the screen pauses before displaying something like Pantera UI V 0.2.1 Started, then you're ready to start work!
Now run pantera as usual.