The Linux installation process is pretty simple. Just type make, then make install. If you want to remove the packages type make uninstall.
tar zxf librexxmysql-1.0.1.tar.gz
cd librexxmysql-1.0.1/src
make
make install
The Makefile uses libtool to handle creating the library, installing it, and uninstalling it.
Please note that you need to have the following software installed before compiling this package.
ooRexx 3.0.0 or greater
MySQL Client 4.0 or greater
Pthreads is also needed but most Linux distro's come with it installed.
Please skip to the POST INSTALLATION step.
To install this package on Windows you have two choices. The easy option which is to use the precompiled binaries from the Sourceforge site. The harder option is to get the source and compile it on Windows.
Have Open Object Rexx 3.0 or greater installed on your system. Also have MySQL 4.0 or greater installed on your system.
This method is the easiest and is recommeded if you just want to use the library.
1.) Download the project files from Sourceforge
2.) Unzip them.
3.) In the winxp directory is a binary dll, that I compiled on my Windows XP machine.
4.) Place that anywhere in the windows PATH and you should have access to the library.
** HINT ** popular locations for PATH ( c:\windows\system32\, or the working directory )
This should work on most versions of Windows. I don't know about the older versions like Windows 95, 98, or ME. I've only checked XP.
This method is only harder because it requires you have Visual Studios Installed. I've included a Visual Studios Solution file in the src directory. Just load that in Visual Studios. I have configured the project to look for required libraries and header files based on the standard location for files, so this *should* work out of the box. However, it may not so here's a list of where it is looking, change them if you need to.
mysql.h --> c:\mysql\include\mysql\mysql.h
libmySQL.lib --> c:\mysql\lib\opt ( Release ) or c:\mysql\lib\debug ( Debug )
rexx.h --> c:\Program Files\ooRexx\api
rexx.lib --> c:\Program Files\ooRexx\api
rexxapi.lib --> c:\Program Files\ooRexx\api
To build the library, go to 'Build' menu, select 'Build Solution'. The compiled files will be placed in either the 'Debug' or 'Release' directory depending on which version you built. Grab the 'rexx_mysql.dll' file and proceed with the instructions for the binary installation.
This section is not OS dependant and should be always be run. It will test that the libraries are installed properly and working.
In a terminal / command shell go the librexxmysql-X.X.X/scripts directory. Then we are going to run the test REXX scripts.
The first script is the connection_test.rex script. It will test that the library can load and that a connection can be made to a MySQL server. To run the script type 'rexx connection_test.rex'. The script will prompt your for the information it needs. Follow it's instructions.
After the first script succeeds, we need to run the complete test. This is the comprehensive_test.rex script. It will test all of the functions available through the library. Please read through the output of the script carefully as some error messages are expected ( testing mysql_error & mysql_errno ). To run the script type 'rexx comprehensive_test.rex' and follow the prompts. The script will gather all the information it needs. Please also note that the user / password you give this script must have root priviliges, as it needs to create a database, some tables, add some data to them, run some searches, delete the data, drop the tables and drop the database. If the script runs completely it should not leave any data on your server.
If both of these scripts run successfully, the your installation is successful and complete.