Firebird Classic Server for AIX This release was compiled on AIX 4.2.1.0 using gcc version 2.95.2 19991024 (release). This is a test release of Firebird compiled from a download on Wednesday, January 17, 2001. This release has been tested with all TCS tests except: V4_EXCLUSIVE IDML_C_CHARSET Before starting, if you are running Interbase 3.3 or earlier then there are special procedures necessary to convert your current security database. You can check with the command '/usr/interbase/bin/gbak -z' and review the version string displayed. If you are running Interbase 3.3 or earlier please contact ib-support@egroups.com for more information. If you are currently running any releases of Interbase or Firebird you should first backup all databases using the version of gbak specific to that release. To install Firebird-0.9-4: Check to see if your distribution of Firebird has been compressed (for example Firebird-0.9-4.AIX.bff.Z) and if necessary use the uncompress command to expand the file. Check that the directory /usr/interbase is available, 'ls -al /usr/interbase' If this shows a link to an existing directory, for example '/usr/interbase -> /home/firebird/fbdev', then there is already a version installed. Stop all applications and processes that may be using Firebird and shutdown the lock manager with the command '/usr/interbase/bin/gds_drop -s' (Earlier AIX versions used the command '/usr/interbase/bin/gds_drop -a'.) If 'ls -al /usr/interbase' shows a directory with files, then shutdown any applications and the lock manager as shown above and rename the directory to another name. Please be careful not to delete this existing directory, it contains valuable files you may want to copy to your new Firebird directory. Check that the lock manager is not running with the command 'ps -ef | grep gds' and investigate any processes shown. Create a target directory to hold the Firebird server. Change to that target directory Change the permissions on that directory to be updateable by everyone 'chmod 777 .' Restore Firebird using a command like 'restore -xqvf /(pathtodownload)/Firebird-0.9-4.AIX.bff' where (pathtodownload) is the explicit path to the location holding the distribution. Create a link to the target directory with a command like 'ln -s /(targetdirectory) /usr/interbase' (Note: If this link already exists, use the -f option on the ln command to overwrite it.) Change to the Interbase directory 'cd /usr/interbase' Run the install script 'sh ./install' Notes: The files -rwsrwsrwx 1 root sys 217515 Jan 17 21:17 gds_drop -rwsrwsrwx 1 root sys 197340 Jan 17 22:07 gds_inet_server -rwsrwsrwx 1 root sys 215296 Jan 17 21:17 gds_lock_mgr -rwsrwsrwx 1 root sys 32869 Jan 17 21:48 gds_relay require the special permissions shown above. Please see the note at the bottom of this file regarding other permission bits on all Firebird executables. If you had a prior installation of either Firebird or Interbase, check that directory for the file isc4.gdb This file contains all of the user IDs and Passwords permitted to access your databases. Copy this file to your new Firebird directory. Review the file /usr/interbase/isc_config and change as necessary for your system. More information can be found about the Firebird database engine from: http://firebird.sourceforge.net or affiliated sites: http://www.ibphoenix.com http://www.interbase2000.com The Firebird database engine is derived from the InterBase(tm) product currently owned by Inprise. The documentation for InterBase v 6.0 applies also to the current FireBird release. InterBase documentation is available in Adobe Acrobat format from http://www.interbase.com. The following shows sample installation commands ls -al mkdir /usr/Firebird-0.9-4 cd /usr/Firebird-0.9-4 chmod 777 . restore -xqvf /home/greg/Firebird-0.9-4.bff cd /usr/interbase sh ./install When installation is complete the directory /usr/Interbase should contain: drwxrwsrwx 9 root sys 512 Jan 17 22:30 . drwxrwsrwx 7 griffin sys 1536 Jan 17 22:20 .. drwxr-sr-x 2 root sys 512 Jan 17 22:14 UDF drwxr-sr-x 2 root sys 512 Jan 17 22:14 bin drwxr-sr-x 5 root sys 512 Jan 17 22:14 examples drwxr-sr-x 2 root sys 512 Jan 17 22:14 help drwxr-sr-x 2 root sys 512 Jan 17 22:14 include -rw-r--r-- 1 root sys 861 Jan 17 22:06 inetd.conf.isc -rw-r--r-- 1 root sys 6943 Jan 17 22:06 install -rw-rw-rw- 1 root sys 130840 Jan 17 21:17 interbase.msg drwxr-sr-x 2 root sys 512 Jan 17 22:14 intl -rw-rw-rw- 1 root sys 618496 Jan 17 22:28 isc4.gdb -r--r--r-- 1 root sys 185 Jan 17 22:06 isc_config -rw-rw-rw- 1 griffin sys 32768 Jan 17 22:36 isc_event1.stuaix -rw-rw-rw- 1 root sys 0 Jan 17 22:14 isc_init1.stuaix -rw-rw-rw- 1 root sys 229376 Jan 17 23:22 isc_lock1.stuaix drwxr-sr-x 2 root sys 512 Jan 17 22:14 lib -rw-r--r-- 1 root sys 799 Jan 17 22:06 services.isc ./UDF: total 176 drwxr-sr-x 2 root sys 512 Jan 17 22:14 . drwxrwsrwx 9 root sys 512 Jan 17 22:30 .. -rwxr-xr-x 1 root sys 81109 Jan 17 21:48 ib_udf ./bin: total 7968 drwxr-sr-x 2 root sys 512 Jan 17 22:14 . drwxrwsrwx 9 root sys 512 Jan 17 22:30 .. -rwxrwxrwx 1 root sys 332179 Jan 17 22:06 gbak -rwxrwxrwx 1 root sys 453408 Jan 17 22:06 gdef -rwsrwsrwx 1 root sys 217515 Jan 17 21:17 gds_drop -rwsrwsrwx 1 root sys 197340 Jan 17 22:07 gds_inet_server -rwsrwsrwx 1 root sys 215296 Jan 17 21:17 gds_lock_mgr -rwxrwxrwx 1 root sys 210694 Jan 17 21:36 gds_lock_print -rwxrwxrwx 1 root sys 85338 Jan 17 22:07 gds_pipe -rwsrwsrwx 1 root sys 32869 Jan 17 21:48 gds_relay -rwxrwxrwx 1 root sys 96483 Jan 17 22:06 gfix -rwxrwxrwx 1 root sys 1003415 Jan 17 22:06 gpre -rwxrwxrwx 1 root sys 67212 Jan 17 22:07 gsec -rwxrwxrwx 1 root sys 58837 Jan 17 21:47 gsplit -rwxrwxrwx 1 root sys 67650 Jan 17 22:07 gstat -rw-rw-rw- 1 root sys 3072 Jan 17 22:07 isc4.gbak -rwxrwxrwx 1 root sys 404994 Jan 17 22:06 isql -rwxrwxrwx 1 root sys 590722 Jan 17 22:07 qli ./examples: total 40 drwxr-sr-x 5 root sys 512 Jan 17 22:14 . drwxrwsrwx 9 root sys 512 Jan 17 22:30 .. drwxr-sr-x 2 root sys 1536 Jan 17 22:14 v3 drwxr-sr-x 2 root sys 512 Jan 17 22:14 v4 drwxr-sr-x 2 root sys 1024 Jan 17 22:14 v5 ./examples/v3: total 2864 drwxr-sr-x 2 root sys 1536 Jan 17 22:14 . drwxr-sr-x 5 root sys 512 Jan 17 22:14 .. -rw-r--r-- 1 root sys 16889 Jan 17 22:08 array.e -rw-r--r-- 1 root sys 20992 Jan 17 22:08 atlas.gbak -rw-r--r-- 1 root sys 355328 Jan 17 22:08 atlas.gdb -rw-r--r-- 1 root sys 11813 Jan 17 22:08 atlas.gdl -rw-r--r-- 1 root sys 2048 Jan 17 22:08 c_guide.gbak -rw-r--r-- 1 root sys 1476 Jan 17 22:08 c_guide.gdl -rw-r--r-- 1 root sys 2991 Jan 17 22:08 city_pops.E -rw-r--r-- 1 root sys 2966 Jan 17 22:08 city_pops.e -rw-r--r-- 1 root sys 4120 Jan 17 22:08 city_pops.ef -rw-r--r-- 1 root sys 2874 Jan 17 22:08 dsql.E -rw-r--r-- 1 root sys 2795 Jan 17 22:08 dsql.e -rw-r--r-- 1 root sys 3257 Jan 17 22:08 dsql.ecbl -rw-r--r-- 1 root sys 3783 Jan 17 22:08 dsql.ef -rw-r--r-- 1 root sys 1750 Jan 17 22:08 dsql_blob.e -rw-r--r-- 1 root sys 2398 Jan 17 22:08 dsql_date1.e -rw-r--r-- 1 root sys 2807 Jan 17 22:08 dsql_date2.e -rw-r--r-- 1 root sys 1687 Jan 17 22:08 emp.e -rw-r--r-- 1 root sys 32256 Jan 17 22:08 emp.gbak -rw-r--r-- 1 root sys 546816 Jan 17 22:08 emp.gdb -rw-r--r-- 1 root sys 22314 Jan 17 22:08 emp.gdl -rw-r--r-- 1 root sys 3341 Jan 17 22:08 forms_ski.e -rw-r--r-- 1 root sys 3776 Jan 17 22:08 forms_state.e -rw-r--r-- 1 root sys 9728 Jan 17 22:08 full_dsql.e -rw-r--r-- 1 root sys 10081 Jan 17 22:08 gconf.e -rw-r--r-- 1 root sys 77741 Jan 17 22:08 gconv.e -rw-r--r-- 1 root sys 8924 Jan 17 22:08 gconv.readme -rw-r--r-- 1 root sys 6771 Jan 17 22:08 gdml.E -rw-r--r-- 1 root sys 6574 Jan 17 22:08 gdml.e -rw-r--r-- 1 root sys 8417 Jan 17 22:08 gdml.ecbl -rw-r--r-- 1 root sys 7715 Jan 17 22:08 gdml.ef -rw-r--r-- 1 root sys 69160 Jan 17 22:08 gdump.e -rw-r--r-- 1 root sys 1964 Jan 17 22:08 gdump.readme -rw-r--r-- 1 root sys 21772 Jan 17 22:08 gref.e -rw-r--r-- 1 root sys 1754 Jan 17 22:08 gref.readme -rw-r--r-- 1 root sys 2754 Jan 17 22:08 make.filter -rw-r--r-- 1 root sys 2879 Jan 17 22:08 make.udf -rw-r--r-- 1 root sys 1385 Jan 17 22:08 multi_db1.e -rw-r--r-- 1 root sys 1283 Jan 17 22:08 multi_db2.e -rw-r--r-- 1 root sys 2048 Jan 17 22:08 nc_guide.gbak -rw-r--r-- 1 root sys 1477 Jan 17 22:08 nc_guide.gdl -rw-r--r-- 1 root sys 7633 Jan 17 22:08 nr_filter.c -rw-r--r-- 1 root sys 1474 Jan 17 22:08 slides.e -rw-r--r-- 1 root sys 1024 Jan 17 22:08 slides.gbak -rw-r--r-- 1 root sys 1015 Jan 17 22:08 slides.gdl -rw-r--r-- 1 root sys 840 Jan 17 22:08 sources.gdl -rw-r--r-- 1 root sys 3656 Jan 17 22:08 sql.E -rw-r--r-- 1 root sys 3317 Jan 17 22:08 sql.e -rw-r--r-- 1 root sys 3868 Jan 17 22:08 sql.ecbl -rw-r--r-- 1 root sys 4058 Jan 17 22:08 sql.ef -rw-r--r-- 1 root sys 1443 Jan 17 22:08 sql_blob1.e -rw-r--r-- 1 root sys 1944 Jan 17 22:08 sql_blob2.e -rw-r--r-- 1 root sys 1293 Jan 17 22:08 sql_blob3.e -rw-r--r-- 1 root sys 2161 Jan 17 22:08 sql_date.e -rw-r--r-- 1 root sys 1034 Jan 17 22:08 sql_trans.e -rw-r--r-- 1 root sys 1530 Jan 17 22:08 stocks.e -rw-r--r-- 1 root sys 1024 Jan 17 22:08 stocks.gbak -rw-r--r-- 1 root sys 1180 Jan 17 22:08 stocks.gdl -rw-r--r-- 1 root sys 4216 Jan 17 22:08 udf.c -rw-r--r-- 1 root sys 3225 Jan 17 22:08 udf.sql -rw-r--r-- 1 root sys 11810 Jan 17 22:08 udflib.c ./help: total 984 drwxr-sr-x 2 root sys 512 Jan 17 22:14 . drwxrwsrwx 9 root sys 512 Jan 17 22:30 .. -rw-r--r-- 1 root sys 102400 Jan 17 22:07 help.gbak -rw-r--r-- 1 root sys 393216 Jan 17 22:07 help.gdb ./include: total 816 drwxr-sr-x 2 root sys 512 Jan 17 22:14 . drwxrwsrwx 9 root sys 512 Jan 17 22:30 .. -rw-r--r-- 1 root sys 212572 Jan 17 21:54 gds.h -rw-r--r-- 1 root sys 49964 Jan 17 21:54 gds.hxx -rw-r--r-- 1 root sys 978 Jan 17 21:54 ib_util.h -rw-r--r-- 1 root sys 93423 Jan 17 21:54 ibase.h -rwxr-xr-x 1 root sys 39628 Jan 17 20:06 iberror.h -rw-r--r-- 1 root sys 2623 Jan 17 21:54 perf.h ./intl: total 1440 drwxr-sr-x 2 root sys 512 Jan 17 22:14 . drwxrwsrwx 9 root sys 512 Jan 17 22:30 .. -rw-rw-rw- 1 root sys 728628 Jan 17 22:05 gdsintl ./lib: total 4744 drwxr-sr-x 2 root sys 512 Jan 17 22:14 . drwxrwsrwx 9 root sys 512 Jan 17 22:30 .. -rw-rw-rw- 1 root sys 690298 Jan 17 21:51 gds.a -rw-rw-rw- 1 root sys 1722049 Jan 17 22:06 gdsshr.a -rwxr-xr-x 1 root sys 2582 Jan 17 21:48 ib_util.a Please take careful note that as currently distributed the files in the directory /usr/interbase/bin have too many file permission bits turned on. These files do NOT need to be writeable by anyone other than root.