[H-GEN] Installing Interbase on RH6.1

[Brent Wesley]

[ Humbug *General* list - semi-serious discussions about Humbug and  ]
[ Unix-related topics.  Please observe the list's charter.           ]
[ Worthwhile understanding: http://www.humbug.org.au/netiquette.html ]

David Duffy wrote:

> [ Humbug *General* list - semi-serious discussions about Humbug and  ]
> [ Unix-related topics.  Please observe the list's charter.           ]
> [ Worthwhile understanding: http://www.humbug.org.au/netiquette.html ]
>
> > > > > Hilton wrote:
> > > > > >I hear Interbase 6.01 and below have a wide open backdoor inserted by
> > > > > >Borland!  Hope you are using a later (or patched) version.
> > > > >
> > > > > Yes, I saw the BUG BUG BUG warnings all over their site!
> > > > > I've installed the rpm and added the lines to the various config
> > > > > files & re-booted but how do I tell if it's running? I'm still on a
> > > > > very steep learning curve with Linux so I will probably ask a
> > > > > few more dumb questions along the way. I do cruise the FAQ
> > > > > lists before I ask - I just don't always get it the first time! :-)
> > > > > Thanks to those who have helped me so far. The good lists
> > > > > are ones where everyone is given a fair go - even beginners.
> > >
> > > Brent wrote:
> > > >As the gds_db uses inetd it only runs when it gets a connection to
> > it's port
> > > >(3050). The easiest was it to use a port scanning program like nmap or to
> > > >telnet to port 3050 on the host machine.
> > >
> > > Hmmm... no response on that port number. Wait! Could the firewall rules
> > > be stopping access to that port even on the internal network?
> > > Regards...
> > >
> >
> >Yes, if the firewall is blocking port 3050 on the local interface.
> >
> >The best way is to check it on the machine that is running  interbase eg
> >telnet
> >localhost 3050.
> >
> >Another thing to check is you inetd.conf.
> >
> >make sure you have and entry something like this
> >gds_db  stream tcp nowait.30000  root  /usr/local/sbin/gds_inet_server
> >gds_inet_server
> >
> >also make sure you you have restarted inetd.
>
> OK, got that part working now. I can test the connection via IBConsole
> (Windows) or via Jason's netstat command on the Linux box.
> Now all I need to do is figure out how to create a Interbase database!
> It's all looking very foreign after using the BDE and Paradox tables.
> Might be time to read some more & ask on the ib-support list. :-)
> Thanks for your help so far...
>

The only real main pointer I can give you is when using interbase over a network
is when you use ibconsole you have to register a server and connection, log in and
then you can do query's.

When programming with delpi for instance you can use the internal interbase
objects. However there is a third part package called ibObjects.  When you use
these you do not have to register a server. When you specify a connection you only
need to pass it the username and password you specified when you created the
database (normally sysdba).

Sounds like you are going through what I just have completed.  We have just
converted from using paradox 4.0 databases to Interbase.  In my opinion Interbase
has shown itself to be one of the most sable and reliable databases I have seen in
a long time. With a fast and reliable database engine for Linux, I would recommend
it to anyone who is doing Linux/Windows database integration.

--
Brent Wesley
Systems Programmer
Scanning Systems (Aust.)
http://www.scanningsystems.com.au
PH: 07 3809 3333  FAX: 3809 3335                     http://www.humbug.org.au



--
* This is list (humbug) general handled by majordomo at lists.humbug.org.au .
* Postings to this list are only accepted from subscribed addresses of
* lists 'general' or 'general-post'.