Subject Re: [firebird-support] Re: Installing Firebird 2.0 on Xen AMD64
Author Helen Borrie
At 01:26 PM 22/01/2007, you wrote:
>Everything I have done has been as root on the server, except when I
>try to log in from DBW from my Windows workstation.
>
>So when I try to connect as local host, I am logged in as root.

You're not trying to connect as local host. Localhost is not a user,
it is the hostname of IP address 127.0.0.1. You are trying to
connect to connect the server through port 3050 as a remote client
and the centurion at the network gateway to the world doesn't
recognise you as having the privileges to do so. Hence it is
refusing or rejecting the attempt (you seem to have reported both at
various times).

>I am getting to the point, that I think fb_inet_server won't run under
>Xen and maybe this is a bug.

Not a Firebird bug; and it it's not a known issue to the Xen people
then that leaves it being a configuration or a privileges problem,
possibly both.

>It has been two weeks with lots of help
>and suggestions from this list and OpenSuse and Xen. You would think
>with all this brain power working on the problem, we would have
>figured it out by now.

If you've been providing information to those other forums that is as
gappy as your thread here, all that energy has been going up into the
ether. A problem solution is only as good as the problem
description. When you have 4 people interrogating you to get at the
parameters of the problem, it's a sure sign that you're not telling us enough.


>Should I take this to the developers list?

It would not be welcome, as it is a support issue, nothing to do with
either core development or creating a new platform port. Here is
where we hammer out solutions to eclectic configuration cases, if
there is a solution to be found. I'm telling you this as the list
admin, in case you weren't aware.

We now know (because you have told us) that some things are listening
to the low-numbered TCP/IP ports on the localhost server. For
example, Sendmail is listening on port 25. And we know that the
system at least knows about xinetd listening on port 3050, because we
saw gds_db in your tcpdump output in an earlier posting. What still
has to be figured out is why the connection request is being refused.

Is it a privileges problem, for example? That doesn't seem to have
been eliminated. Have a look at the location where you have the
database that you are trying to connect to. The firebird user - that
is, the system user named 'firebird" must have read/write privs to
the database file AND read, write and execute privileges to the
sub-directory that the file resides in and all of the subdirs above
it, right back to (but not including) root.

Do ls -l all the way to the file and find out if there is somewhere
in there that the firebird user doesn't have at least the required
group privileges.

You ought to check the /etc/services file also. We know that the
system knows *about* gds_db but there might be some localised reason
why it can't make the association between the symbol and the port.

If there is no entry in there looking like the following, then add it:

gds_db 3050/tcp #InterBase or Firebird server default port

You would need to stop and restart xinetd for it to be seen by xinetd.

> > do you have the proper permissions for the firebird user to access the
> > fdb file? Sometimes I like to su to the firebird user to make sure
>that
> > all of the directories leading up to the firebird databases have
>execute
> > access set up properly. Also what does your /etc/hosts file look like?
> >
> > -steve

Heck, you're even requoting these essential questions!! Why don't
you go back to the beginning of the entire thread, revisiting all of
the questions and suggestions? Get answers to all of them and I bet
you'll find the answer to the problem.

./heLen