At 04:12 PM 7/01/2005 -0800, you wrote:

>Subject: Re: Linux 64 FB localhost connect trouble (re-posted from Support)
>
>Thanks, but I just double-checked and that doesn't seem to be it. iql
>behaves the same whether I'm logged in as firebird or as root - I can
>connect using "connect /path/db.fdb" syntax but not using "connect
>localhost:/path/db.fdb" syntax. This is getting frustrating...

Even though the OS user 'firebird' owns the process, it doesn't have any
rights as a Firebird user...(a Firebird user is one that is defined in
security.fdb). But don't do this!!!

root *does* have rights equivalent to sysdba without Firebird server
authentication, so I'm surprised if root can't open the database on those
grounds. But the Connect statement does need the right syntax.

The command-line and isql shell syntaxes are not the same...(note the
quotes inside the isql shell):

1---From the command shell:

cd /opt/firebird/bin
./isql localhost:/path/db.fdb -u sysdba -pass yourpwd
Note: root should be able to do this without the authentication switches if
it's using the proper client (libfbclient.so).

2--from within the isql shell, without prior authentication:

cd /opt/firebird/bin
./isql
SQL> connect 'localhost:/path/db.fdb' user 'sysdba' password 'yourpwd';

3--from within the isql shell, with prior authentication:
cd /opt/firebird/bin
./isql -user sysdba -pass yourpwd
SQL> connect 'localhost:/path/db.fdb';

I'm assuming that it's the Classic server you installed, since SS doesn't
install the libfbembed.so client and can't use the "direct connect" method
that you say was successful. That is, on Linux, *only* libfbembed.dll can
be used for a non-TCP/IP connection and *only* Classic can take such a
connection.

There could be something there, in that your installation didn't install
libfbclient.so or, if it did, isql is not finding it for its attempt to
make local loopback connection.

Have you studied the Quick Start Guide at all?

Helen