Hi Josh,

> I checked network traffic using a packet tracer and yes it is using TCP
> port 3050. So I modified my iptables to allow traffic in and out that
> port. However I'm still getting the same -923 error. After that, I tried
> disabling my firewall but still got the same error.

Hmmm. It's definitely not the firewall then, unless of course, there are
multiple firewalls between your client and the database server? It's
possible, but most unlikely I suspect.

> I get the same error when I access the database using a web based GUI
> Firebird db manager that I installed on the same machine. This web app
> is even installed locally and should be able to access the database no
> problem but for some reason it considers the web application as a remote
> source???

I wonder if it's not using localhost:database_alias to connect and is
hitting the network rather than missing it out and just going local?
Strange.

> I'm a bit stumped at the moment.

I'm wondering if maybe there's something in /etc/hosts.deny or
/etc/hosts.allow or /etc/hosts.equiv that might possibly be preventing
you from connecting. I'm not a network guru by a long chalk, so I could
be talking complete nonsense.

A couple of questions:

Do you have an alias set up for the database? If so, what is it set up
as in aliases.conf?

Do you use the alias locally and remotely?

Which database are you connecting to, I mean, what is the database
"name" in the connection details?

There may be a clue in your answers.


Cheers,
Norm.

--
Norman Dunbar
Dunbar IT Consultants Ltd

Registered address:
Thorpe House
61 Richardshaw Lane
Pudsey
West Yorkshire
United Kingdom
LS28 7EL

Company Number: 05132767