Subject Install Firebird SuperServer on Solaris 7 with Ultra Spark Enterprise 450 Server
Author roederw@kabeldeutschland.de
Hello,

I've some problems to start the Firebird 1.0.0 databaseserver.
If I starting it some error ocours in the interbase.log:

IBSERVER (Client) Thu Sep 18 12:07:48 2003
INET/inet_error: connect errno = 146

IBSERVER (Client) Thu Sep 18 12:07:48 2003
/usr/interbase/bin/ibguard: guardian starting bin/ibserver


IBSERVER (Server) Thu Sep 18 12:07:48 2003
Open file limit increased from 64 to 1024

IBSERVER (Server) Thu Sep 18 12:07:50 2003
SERVER/process_packet: connection rejected for interbase

IBSERVER (Server) Thu Sep 18 12:07:50 2003
SERVER/process_packet: connection rejected for interbase

IBSERVER (Server) Thu Sep 18 12:07:50 2003
SERVER/process_packet: connection rejected for interbase

IBSERVER (Server) Thu Sep 18 12:07:51 2003
SERVER/process_packet: connection rejected for interbase

IBSERVER (Server) Thu Sep 18 12:07:51 2003
SERVER/process_packet: connection rejected for interbase

IBSERVER (Server) Thu Sep 18 12:07:51 2003
SERVER/process_packet: connection rejected for interbase

IBSERVER (Server) Thu Sep 18 12:07:52 2003
SERVER/process_packet: connection rejected for interbase

IBSERVER (Server) Thu Sep 18 12:07:53 2003
SERVER/process_packet: connection rejected for interbase

IBSERVER (Server) Thu Sep 18 12:07:53 2003
SERVER/process_packet: connection rejected for interbase

IBSERVER (Server) Thu Sep 18 12:07:54 2003
SERVER/process_packet: connection rejected for interbase

IBSERVER (Server) Thu Sep 18 12:07:54 2003
SERVER/process_packet: connection rejected for interbase

IBSERVER (Server) Thu Sep 18 12:07:54 2003
SERVER/process_packet: connection rejected for interbase

IBSERVER (Server) Thu Sep 18 12:07:55 2003
SERVER/process_packet: connection rejected for interbase

IBSERVER (Server) Thu Sep 18 12:07:55 2003
SERVER/process_packet: connection rejected for interbase

IBSERVER (Server) Thu Sep 18 12:07:55 2003
SERVER/process_packet: connection rejected for interbase

IBSERVER (Server) Thu Sep 18 12:07:56 2003
SERVER/process_packet: connection rejected for interbase

IBSERVER (Server) Thu Sep 18 12:07:56 2003
SERVER/process_packet: connection rejected for interbase

IBSERVER (Server) Thu Sep 18 12:07:56 2003
SERVER/process_packet: connection rejected for interbase

IBSERVER (Server) Thu Sep 18 12:07:57 2003
SERVER/process_packet: connection rejected for interbase

IBSERVER (Server) Thu Sep 18 12:07:57 2003
SERVER/process_packet: connection rejected for interbase

IBSERVER (Server) Thu Sep 18 12:07:57 2003
SERVER/process_packet: connection rejected for interbase

IBSERVER (Server) Thu Sep 18 12:07:58 2003
SERVER/process_packet: connection rejected for interbase

IBSERVER (Server) Thu Sep 18 12:07:58 2003
SERVER/process_packet: connection rejected for interbase

IBSERVER (Server) Thu Sep 18 12:07:58 2003
SERVER/process_packet: connection rejected for interbase

IBSERVER (Server) Thu Sep 18 12:07:59 2003
SERVER/process_packet: connection rejected for interbase

IBSERVER (Server) Thu Sep 18 12:07:59 2003
SERVER/process_packet: connection rejected for interbase

IBSERVER (Server) Thu Sep 18 12:07:59 2003
SERVER/process_packet: connection rejected for interbase

IBSERVER (Server) Thu Sep 18 12:08:00 2003
SERVER/process_packet: connection rejected for interbase

IBSERVER (Server) Thu Sep 18 12:08:00 2003
SERVER/process_packet: connection rejected for interbase

IBSERVER (Server) Thu Sep 18 12:08:00 2003
SERVER/process_packet: connection rejected for interbase

I've searching in FAQ's, Knowledgebase and so on. Only I found this:

KnowledgeBase Id: 243
Question:
I am getting Error 146 in my InterBase.log file.
Answer:
You can find the detailed message to this numeric error code in a file called
errno.h. This file can be found on most Unix systems under the
directory /usr/include/.

For Solaris,
it is in /usr/include/sys directory.

1. In the Solaris errno.h file, error 146 points to connection refused. This
usually means that no one is listening on the server side.
To see if gds_db process is listening, do the command:

netstat -a | grep gds_db

at the UNIX prompt. This command asks the system to show us the state of all
sockets. This includes server processes. This will show if gds_db was there.
We need to be sure that gds_db was in listen mode.
2. hosts.equiv file has to have localhost in it for InterBase V5.0.
3. Error number 146 is defined as connection reset in the InterBase source
code. This is equivalent to the TCP/IP error of 10054, in that the machine on
the other end is abnormally terminating the connection.
Abnormally terminating the connection could be such an occurrance as: the user
turning off the system or rebooting while being connected.
4. Check to be sure that the inetd.conf file is present and has the proper
information in it. It should have an entry for gds_db in it for InterBase 4.0.
5. Check and ensure that /etc/services has the entry of:
gds_db 3050
Firebird/InterBase Version: 5.x

@1 netstat shows me that gds_db is in listen mode -> *.gds_db *.* 0 0 0 0 LISTEN
@2 hosts.equiv enntie ist -> 127.0.0.1 localhost
@3 I don't know?????
@4 There is no entry in inetd.conf for gds_db -> for superserver I mean that no entry is OK?
@5 /etc/services has this entry -> gds_db 3050/tcp # Interbase

The user interbase is in the interbase and root group

Where is the error, what is wrong?

Best Regards

Walter Roeder, Germany



[Non-text portions of this message have been removed]