Subject Re: Change install directory on HP-UX 11.11
Author cedric_maucourt
> Hi Paul,
>
> I was finally able to try your solution and... it works! Now I'm able
> to launch isql and create databases.
> However there is another problem, still linked to the installation of
> Firebird I think : I can no longer use Firebird with the Java batch I
> developed.
> I'm using JayBird JDBC driver v2.0.1 and "pure Java" URLs, like :
>
jdbc:firebirdsql:localhost:/users2/docbackup/lsp00/envoi/master/AFDZ.FDB?lc_ctype=UNICODE_FSS
> (the batch is running on the server)
> When my Java classes try to connect to the database, I've got this
> exception :
> org.firebirdsql.jdbc.FBSQLException: GDS Exception. 335544421.
> connection rejected by remote interface
> Reason: connection rejected by remote interface
>
> It's strange because it worked fine with the standard installation of
> Firebird in /usr/local (I checked one again to be sure).
>
> Here are some elements of the server configuration :
> - Firebird installed in the /soft/fbd152 directory;
> - the line "gds_db 3050/tcp # Firebird SQL Database Remote Protocol"
> is present in /etc/services;
> - the line "gds_db stream tcp nowait.30000 firebird
> /soft/fbd152/bin/fb_inet_server fb_inet_server # Firebird Database
> Remote Server" is present in /etc/inetd.conf;
> - the file /etc/hosts.equiv exists with the entries
> "localhost.localdomain" and "beahbh" (e.g. `hostname`).

Hi Paul,

Actually it's still a problem of firebird.conf. When you try to
connect locally to a database, everything works fine. But when you try
to connect to a database using network layers, the SQL client seems to
lost the FIREBIRD environnement variable and cannot find the
firebird.conf file in which the RootDirectory property is defined.
I try this with isql, Firebird installed in /soft/fbd152 and the
environnement variable FIREBIRD set to /soft/fbd152 :
1/
"SQL> CONNECT '/users2/docbackup/lsp00/envoi/master/AFDZ.FDB' user
'SYSDBA' password 'ced';
Database: '/users2/docbackup/lsp00/envoi/master/AFDZ.FDB', User: SYSDBA"
Everything is OK.
2/
"SQL> CONNECT
'localhost/3051:/users2/docbackup/lsp00/envoi/master/AFDZ.FDB' user
'SYSDBA' password 'ced';
Statement failed, SQLCODE = -902

Unable to complete network request to host "localhost".
-Failed to establish a connection."
3/
I create the /usr/local/firebird directory and copy the file
firebird.conf (with RootDirectory=/soft/fbd152) into it.
"SQL> CONNECT
'localhost/3051:/users2/docbackup/lsp00/envoi/master/AFDZ.FDB' user
'SYSDBA' password 'ced';
Database:
'localhost/3051:/users2/docbackup/lsp00/envoi/master/AFDZ.FDB', User:
SYSDBA"
Everything OK.
4/
I change the RootDirectory property of
/usr/local/firebird/firebird.conf to a dumb value.
"SQL> CONNECT
'localhost/3051:/users2/docbackup/lsp00/envoi/master/AFDZ.FDB' user
'SYSDBA' password 'ced';
Statement failed, SQLCODE = -902

operating system directive open failed
-No such file or directory"

C├ędric