At 05:39 PM 4/05/2005 +1000, you wrote:

>Hi all,
>
>Please forgive me as I dont really know the correct question to ask here.
>
>I am setting up a FB 1.5 Superserver DB to enable clients to remotely
>log into the DB and I am not sure as to which IP address to use in the
>connection string. Could someone have a look at the following and advise
>accordingly.
>
>The machine were the DB will reside is a Mac OS X 10.3.8 (7U16)
>
>The current network configuration is as follow (printed from the machine
>where the DB will reside however to protect the clients machine I have
>changed the actual numbers)
>
>Internal Modem
> Interface : modem
> Type : PPP (PPSerial)
>
>Built in Ethernet
> Interface : en0
> Type : Ethernet
> IP Address :162.178.0.9
> Subnet Mask : 255.255.255.0
> Broadcast Address : 162.178.0.245
> DNS Servers : 162.178.0.1.3.0.0.0
> Ethernet Address 00.0d.73.6f.f5.a6
>
>
>
>My understanding is that I supply the modem IP address as part of the
>connection string and then it will re-route the incoming data to the DB.
>
>Is that correct ?

No. Modem==telephony (Internet, faxing, etc.)

You supply the IP address of the Ethernet interface. Better still, avoid
DNS problems and set up the hostname in (the MacOS equivalent of)
/etc/hosts (sorry, I don't know Macs, but I think they do some un-Unixlike
things with filesystems and TCP/IP networks). You can use whatever
hostname you like but it makes sense to use the host machine's node name in
the LAN (IP mask 255.255.255.0 is the innermost level of TCP/IP
networking). If a networking boffin set up the LAN, the entry will already
be there.

>If not what do I need to do here ?

Let's suppose the hostname of the server is bigmac.

Make sure port 3050 is opened in the firewall to the LAN users.

Your remote clients will connect to a database on bigmac. Let's say that
the database, ourdata.fdb is located in /databases. OK, make an entry like
this in aliases.conf on the server:

homedb = /databases/aliases.conf

Your clients will connect to bigmac:homedb

That's it. Oh - as long as you remember to give the firebird user (or
whatever user owns the firebird server process on your host) the necessary
permissions in the filesystem.

./heLen