If anyone can help me that would be great.
I have just uncommented the line on a default raq4 which enables Interbase. Now what? I have a client who wants to use Interbase on a shared server and I really have no clue on how to go about this.

(this is the first client who has ever asked for this)

Is it the same way as in setting up a Mysql Database?

What is the next step? how do i create a database/users for Interbase for a virtual site?

Please help =(

If they just need a db, then I'd personally set up mySQL. I've read the interbase is better (somewhere), but I had no luck with it, and it seems there is much more info, scripts, etc., for mySQL. Doesn't answer the question, I know, sorry...

This is what I found out..........................seems to work....


On most Cobalt Raq4 systems if you do locate isql you'll get this

[root /etc]# locate isql
/home/opt/interbase/bin/isql
/usr/include/pgsql/iodbc/isql.h
/usr/include/pgsql/iodbc/isqlext.h

So it looks like isql is located at /home/opt/interbase/bin

so

cd /home/opt/interbase/bin

*might want to be root for this*

./isql

** this is what should appear

[root bin]# ./isql
Use CONNECT or CREATE DATABASE to specify a database
SQL>

so now your in the SQL for interbase. now you need to CREATE a database!

so type the following

create database '/home/site/home/sample.gdb';

should look somthign like:

SQL> create database '/home/site/home/sample.gdb';

now you created it.. now exit by typing

exit;

** should look like

SQL> quit;

now you need to change the permissions on it.
so type:

chmod 0666 /home/sites/home/sample.gdb

now that you have the database setup, you need to make it so windows clients can access it.

So cd /etc

pico services <ENTER>

and hit and type CTRL+W

then type gds_db

and hit enter, it should take you down and the line should look like this.

gds_db 3050/tcp # InterBase Database Remote Protocol

if you don't see that line, then add it to the bottom

hit CTRL+O and save it

then CTRL+X and exit the file

now you also need to edit /etc/inetd.conf

do the CTRL+W and type in gds_db and hit enter, you should see somthing that looks like the next line, but it should have a # infront of it.. if it does delete the # and save it(CTRL+O) and exit (CTRL+X)


gds_db stream tcp nowait.30000 root /opt/interbase/bin/gds_inet_server gds_inet_server # InterBase Database

now you need to type killall -HUP inetd this should restart inetd and start up the interbase server

and voila.......

I have heard from a friend who has recently bought delphi that it comes with a special interbase program that you use to connect to the interbase server and create databases with it ...

Hoot