At 11:19 AM 12/08/2004 +0000, you wrote:

>I have problem with connection to Firebird server on Linux.
>
>1. I installed FirebirdCS-1.5.1.4481 on Linux successfully, and also
>JDK1.4.2_05 + FirebirdSQL-1.5.0Beta3JDK_1.4
>
>2. I run "fb_inet_server -start"
>
>3. By netstat I see that it is listening on port 3050
>
>4. I try to connect by java app (on the same machine) or by net by
>dbVisualizer app, using JDBC connection string like that
>"jdbc:firebirdsql:localhost/3050:/mnt/extra/data/hrmix.gdb"
>
>5. When I try to open connection it hangs for a long time. Then it
>throws exception "connection refused".
>
>What I know is that connection is being established. I see it on
>netstat and also when I shutdown fb_inet_server the connection does
>not hang but throws exception at once.
>
>I wanted to check if db works by using isql but it works somehow
>differently than in Windows. When I run isql I don't get prompt ">"
>but some information I cannot read because terminal scrolls. I hate
>this but I cannot read what it writes - "| more" doesn't help and I
>have no X windows on the server.
>
>How can I check what is wrong? How can I use isql to connect to my
>*.gdb file and run any simple SQL SELECT, just to check if it works?

For JDBC connection problems (including slowness) ask on firebird-java
(mailto:firebird-java-subscribe@yahoogroups.com)

You probably have permissions problems - see the Firebird 1.5 release
notes, Linux installation section. If you don't have these notes, download
from the Main Downloads page at www.ibphoenix.com

For isql you must either provide an absolute path:

/opt/firebird/bin/isql

or run isql directly from the bin directory:

bin]./isql

Otherwise you are like to get some other isql belonging to another database
package.

On linux, the isql interface looks exactly the same as the Windows one. If
it doesn't, you know you have the wrong one.

Check also that you are using the correct password. It is not
'masterkey'. You will find it in a textfile named SYSDBA.password in the
/opt/firebird directory.

You should be able to connect to the database
/opt/firebird/examples/employee.fdb without changing any permissions.

/heLen