Re: [cobalt-developers] Starting INterbase 6 SQL Server

["Adam Clarke" <Adam.Clarke@xxxxxxxxxxxxxxxxxxxx>]

----- Original Message -----
From: "William L Thomson Jr" <webmaster@xxxxxxxxxxxxxxxxxxxx>
To: <cobalt-developers@xxxxxxxxxxxxxxx>

Hi William.

> Do you think my problem is with the kill portion did I need to
reinitialize
> it instead of stopping & starting.

Ideally just "kill -1" inetd like the following (this is on my Qube2 with IB
6 running). This sends a signal to idetd which tells it to re-read it's
config file without exiting.

You should then be able to connect as below.

---8<------------8<------------8<------------8<---------
    [root@bluey /root]# ps ax | grep ine
      335  ?  S    0:00 inetd
    15376  p0 S    0:00 grep ine
    [root@bluey /root]# kill -1 335
    [root@bluey /root]# /usr/local/interbase/bin/isql
        bluey:/usr/local/interbase/examples/employee.gdb
        -u sysdba -p masterkey

    Database:  bluey:/usr/local/interbase/examples/employee.gdb, User:
sysdba
    SQL> show tables;
           COUNTRY                                CUSTOMER
           DEPARTMENT                             EMPLOYEE
           EMPLOYEE_PROJECT                       JOB
           PHONE_LIST                             PROJECT
           PROJ_DEPT_BUDGET                       SALARY_HISTORY
           SALES
    SQL>
---8<------------8<------------8<------------8<---------

The above connect syntax (which is split across 3 lines but really is 1)
should make a connection via a port rather than locally. To prove it, here's
the edited output of netstat.

---8<------------8<------------8<------------8<---------

    [root@bluey /root]# netstat
    Active Internet connections (w/o servers)
    Proto Recv-Q Send-Q Local Address           Foreign Address
State
    tcp        0   1660 bluey.domainname:gds_db bluey.domainname:2707
ESTABLISHED

---8<------------8<------------8<------------8<---------

The gds_db port listed above is interbase (see /etc/service/)...

    gds_db  3050/tcp  # InterBase Database Remote Protocol

> How did you start the interbase server?  Did you have to modify any files?

As above. Here's my /etc/inetd.conf entry for interbase (once again split
over lines).

    gds_db  stream  tcp     nowait.200      root
        /usr/interbase/bin/gds_inet_server
        gds_inet_server # InterBase Database Remote Server

Cheers
Adam