602SQL Documentation Index  

602SQL Installation under Linux

602SQL for Linux is distributed in rpm packages format. Their installation must be executed by root:

rpm -ih /path_to_file/602sql11-xxx.rpm
Uninstallation is executed:
rpm -e 602sql11

rpm package name can differ according to the distribution mode: At SourceForge, the packages are marked by the date of issue, to differ from the older ones, e.g. 602sql11-2007-09-13.rpm; they can appear under the original identification 602sql11-server-1-0.i586.rpm.

The 602SQL package (602sql11-xxx.rpm file contains i.a. the following files:

Installation of the 602SQL basic package executes, apart from copying, following actions:

The sample configuration file /etc/602sql contains registration of a database named testdb located in /var/lib/602sql11/testdb directory, or a database named 602Office_db located in /var/lib/602sql11/602Office_db directory. Actual database file comes into being at the first server start. You can read more about start and operation of the SQL server on Linux here.

Drivers, header files and libraries for access via standard interface are not included in the 602sql package (with the exception of the odbc driver) and can be downloaded separately (some of them even in the source format). The SDBC driver installation is done manually from the OpenOffice.org environment.

Linux distribution without the rpm system

On Linux installations that do not include rpm (Ubuntu, Debian, Slackware), necessary 602SQL files can be unpacked from the 602sql11-binary-xx.tar.gz compressed archive that is available at vendorīsite.

Files, including their location, can be listed from the rpm package, e.g.

rpm2cpio 602sql11-*.rpm | cpio -t
and unpack and copy them using, e.g., commands
rpm2cpio 602sql11-*.rpm | cpio -idv
or using Midnight Commander.

Programs with graphical interface

The 602gcliXX program - 602SQL Development Client is used for SQL server management and configuration, application development and for editing data in tables. Server Manager is used for start and stop of SQL servers. Programs are identical to those for Windows.