Re: [cobalt-users] Interbase on RaQ4

["Richard Abrams" <richard@xxxxxxxxxxxxxx>]

>  Do you just DL the client tools below ?
>  IBConsole, IBAccess, sql2gbd ?

The idea behind the client tools is that you can administer your databases
happily sat using a GUI on your Windows box... don't have anything against
command line interfaces, but trying to create and manage databases through
it is kinda like (IMHO) attempting to remove your toenails with pliers :-)

You can grab IBConsole from the Borland website - go straight to their
download page on http://www.borland.com/interbase/downloads/#ibconsole -
note that this is for donwloading the binaries though, not the compiled
proggy.

>  Do they have instructions for installing on the Raq4.

As they are client based and not server based, there is no installation on
the RaQ required. Interbase starts up automatically too, and shouldn't need
anything done to make it work. The only possibility is that you will have to
add an entry into your services file(s) on either / both your desktop
Windows machine and your server.

You can open the file through edit in a DOS prompt or any Word processor...
MAKE sure that you save it back as raw text though! The file on Win95/98 is
c:\windows\services. (no extension). In NT you can find it as
c:\winnt\system32\drivers\etc\services.

On the RaQ, you will need to log on as admin and then use the command "su -"
to log on as root. Then "cd /etc" and "pico services" to open the file for
editing.

The line that needs to be present in both files is:

gds_db    3050/tcp

You should now be all set up for client / server connectivity, so it only
remains to create a database. As Mike mentions you may be best installing
the Windows Interbase Server and Client onto your desktop and creating the
databases locally, alternatively follow these 5 easy steps to create one
directly on the RaQ which you should then be able to remotely connect to:

1. Log onto a Telnet prompt
2. "su -" to root
3. Type "cd /opt/interbase/bin"
4. Type "./isql"
5. Finally create your database with the string:
"create database /home/sites/<whereveryouwantdatabase>/<name>.gdb;"

This should happily create a new database in the specified location... to
connect to it, use whatever tool you downloaded. The username will be sysdba
and the password masterkey.

Finally, to enable you to create a DSN for your websites to use in
connecting to the database you have created, you will need to download an
update for Chili!ASP. Go to www.chilisoft.com/beta/linux/default.asp

Good luck!

        -Richard