Hi Helen,

>>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!!!
>
>

I've been running as root except when I tried running as firebird (for
which I set up a linux user account). I felt it was worth a shot.
Please note that I've had none of these problems with a 32-bit install
of CS on 32-bit Suse 9.1 on a 32-bit machine.

>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).
>
>
>

This (#1) does not work. On my 32-bit machine, it does work.

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

This (#2) does not work, whether or not I use quotes. On my 32-bit
machine, it works, whether or not I use quotes.

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

#3 does not work on the 64-bit machine; it works on the 32-bit machine
whether or not I use quotes.

>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.
>
>

I was half hoping I wouldn't find it, but...libfbembed.so is in
/opt/firebird/lib/, as well as /usr/lib64/. libfbembed.so.1 is in
/opt/firebird/lib/ and in /usr/lib64/, and libfbembed.so1.5.2 is in both
directories as well. I don't know if this means anything or not.

>Have you studied the Quick Start Guide at all?
>
>
>

Yup, and read your book (well, parts of it - not that it's not good
reading!). Ping works, the server is running, but the 'localhost'
syntax doesn't work. I will be out of town for a few days, but when I
get back I suppose I'll try reinstalling everything. This is just a
test machine for now, but I hope to get it into shape soon to replace
our XP server.

Steve
_______________________________________________
Dr. Stephen T. Staneff
President, Construction Data and Research, Inc.
reply to: staneff@... <or>
staneff@...