Skip Navigation Links

Linux Software

The wxRegatta scoring program has been written to run on Linux as well. The program is distributed as a binary RPM file that should work on SUSE Linux 10.1. A Source RPM File (SRPM) is provided for those on other Linux distributions that wish to compile the source. The program has been tested with the PostgreSQL and MySQL databases on Linux. Sample scripts are provided by the install to build the databases for either of these environments.

The program requires a couple of external libraries besides wxWidgets. 1) Install Xerces-C version 2.6 or above and libtidy. Xerces provides the XML processing, and libtidy allows processing a web page via Document Object Model (DOM).

 

RPM(s) needed to install & execute wxRegatta:

RPM File Description
wxRegatta-2.3-1.x86_64.rpm This is the 64bit version of wxRegatta application for Linux compiled on a SUSE 10.1.
wxRegatta-2.3-1.i586.rpm This is the 32-bit version for linux compile on SuSE Linux 11.1.
The RPMs below are needed to either execute wxRegatta on Linux. These binaries were built on SUSE 10.1. You can go to the individual  sites and download newer versions or versions specific to your Linux distribution. These rpms are provided here as a convince.

wx-base-ansi-2.8.10-10.x86_64.rpm
wx-gtk2-ansi-2.8.10-10.x86_64.rpm
wx-gtk2-ansi-gl-2.8.10-10.x86_64.rpm
wx-i18n-2.8.10-10.x86_64.rpm
 This binary rpm provides the wxWidgets (wxWindows) runtime environment for the GTK+ version of the application. It is the base 2.8.10 release of wxWidgets that includes ODBC support.
wx-base-ansi-2.8.10-10.i586.rpm
wx-qtk2-ansi-2.8.10-10.i586.rpm
wx-gtk2-ansi-ql-2.8.10-10.i586.rpm
wx-i18n-2.8.10-10.i586.rpm		 These binary rpms provide the wxWidgets (wxWindows) runtime environment for 32-bit linux. These were complied on OpenSUSE 11.1 and include the ODBC options.

 

RPM(s) needed to compile & build wxRegatta:

Note: You will need some of binaries listed above in order to execute wxRegatta.

RPM File Description
wx-base-ansi-devel-2.8.10-10.x86_64.rpm
wx-gtk2-ansi-devel-2.8.10-10.x86_64.rpm		 This is the wxWidgets (wxWIndows) compile time environment for the 64-bit GTK version. It is needed if you intend to compile wxWindows applications on your machine. It will be needed if you are installing the SRPMS for wxRegatta.
wx-base-ansi-devel-2.8.10-10.i586.rpm
wx-gtk2-ansi-devel-2.8.10-10.i586.rpm		 This is the wxWidgets (wxWindows) compile time envrionment for the 32-bit GTK version. It is need if your machine is 32-bit and you will compile a wxWindows application.
wxRegatta-2.3-2.src.rpm This is the source only RPM file to build the wxRegatta application. You must have already have installed the wxGTK environment before attempting to build a binary rpm for this application as it requires wxGTK-devel to be installed before the build.

Change into your SPECS directory and issue the following command:

rpmbuild -bb wxRegatta-2.3.spec

Then change into the ../RPMS/i386 directory and install your binary RPM as described above.

 

Installation Procedures

Binary RPM(s)

You should install the wxGTK binaries first

  1. Open a console window to get to the command prompt
  2. Get to root user, "su"
  3. Install the wxGTK runtime

    rpm -Uvh wxGTK*.rpm
  4. Install the wxRegatta-2.1 binary rpm

    rpm -Uvh wxRegatta-*.rpm


Building and Populating the Database

  1. At this point, wxRegatta is installed /usr/wxRegatta directory. Sample sql for databases can be found in the /usr/wxRegatta/sql directory. Normally the root user is not used to build new databases in PostgreSQL or MySQL. So you might have to adjust the file permissions on the files in this /usr/wxRegatta/sql directory to allow a non root user access.

    For PostgreSQL do the following from a command line:

    su
    su postgres
    createdb regatta
    cd /usr/wxRegatta/sql
    ./build.sh
    exit
    exit

     
  2. For MySQL

    su
    cd /usr/wxRegatta/sql
    mysql -u root mysql
    mysql>grant all privileges on *.* to 'billy'@'%' identified by 'password' with grant option;
    mysql>grant all privileges on *.* to 'billy'@'localhost' identified by 'password' with grant option;
    mysql>\q
    exit (to return back to user billy)
    mysql  -u billy -p
    mysql>create database regatta;
    mysql>\q
    mysql -u billy -p -D regatta < regatta2_mysql.sql
    mysql -u billy -p -D regatta < mysql_import.sql

Setting up ODBC

  1. If you need to download ODBC drivers you can download them off the internet. There is a .odbc.ini file in your home directory "~/.odbc.ini" that configures ODBC datasources for a particular user. A sample odbc.ini file is provided in /usr/wxRegatta/sql that shows how to setup for both PostgreSQL or MySQL. For PostgreSQL, you need to download and install psqlodbc.so. For MySQL, the odbc driver is called libmyodbc.so.

    [ODBC Data Sources]
    Regatta = PostgreSQL Native
    RegattaMySQL = MySQL Version

    [Regatta]
    Driver = /usr/lib/psqlodbc.so or /usr/lib64/psqlodbc.so for x86_64
    Description = Using PostGres Driver
    Database = regatta
    Debug = 0
    FetchBufferSize = 99
    CommLog = 0
    Port = 5432
    Servername = localhost
    ReadOnly = No
    Trace = No
    TraceFile = /tmp/sql.log
    UserName = regatta
    Password = regatta

    [RegattaMySQL]
    Driver = /usr/llib/libmyodbc.so
    Description = MySQL Version
    database = regatta
    UserName = youruser
    password = yourpass

    [ODBC]
    Trace = 0
    TraceAutoStop = 1
    TraceFile = /tmp/sql.log