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

["William L Thomson Jr" <webmaster@xxxxxxxxxxxxxxxxxxxx>]

I really appreciate all the info.  One more question though, you mentioned
the inetd.conf file & this entry

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

Did you have to uncomment that entry?  In my inetd.conf file my last line
looks like

#gds_db  stream  tcp     nowait.30000      root
        /usr/local/sbin/gds_inet_server
        gds_inet_server # InterBase Database Remote Server

Do you think my problem is the nowait.30000?  When this line is processed by
inetd, the Interbase server is started but blocks all ports.
Have you experienced that problem?

Thanks Again,
William L. Thomson Jr.
CEO
Obsidian-Studios Inc.

----- Original Message -----
From: "Adam Clarke" <Adam.Clarke@xxxxxxxxxxxxxxxxxxxx>
To: <cobalt-developers@xxxxxxxxxxxxxxx>
Sent: Tuesday, October 24, 2000 6:37 AM
Subject: Re: [cobalt-developers] Starting INterbase 6 SQL Server


> ----- 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
>
>
> _______________________________________________
> cobalt-developers mailing list
> cobalt-developers@xxxxxxxxxxxxxxx
> http://list.cobalt.com/mailman/listinfo/cobalt-developers
>