Joe Morris (NTM) wrote:

Tom Miller wrote:

...

I am trying to get Firebird database server running on my computer.

If I try to connect to the server in local mode (doesn't use IP at all), it works fine.

If I then try to connect with IP locally using 127.0.0.1 the connection is actively refused.

Refused does not sound like a firewall. It sounds like your configuration of firebird, though I am not familiar with it. What interfaces is it listening on? What does your syslog say when it loads?

TCP/IP is its main / default interface. There is a second interface for local connections only, but I can't remember what it is called.

...

I do not have the openSuse firewall active. So I don't have any idea what is blocking it.

I don't think it is being blocked, firebird is refusing the connection. If it was blocked, it would not be refused, it would just timeout since it would never connect.

Thanks, good to know.

...

This is an Xen Guest (DomU), but I am not sure that has anything to do with it.

I would suggest checking your Firebird config to see if you can determine what interface(s) it is listening on.

By default it listens to IP on 3050 and the local one I talked about. I one time NetBuei was an option, but that may have been removed from the system. -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org

Joachim Schrod wrote:

Tom Miller wrote:

...

I am trying to get Firebird database server running on my computer.

If I try to connect to the server in local mode (doesn't use IP at all), it works fine.

If I then try to connect with IP locally using 127.0.0.1 the connection is actively refused.

Are you sure that Firebird accepts IP connections at all?

What does lsof -c firebird | grep TCP say? (I assume that the firebird daemon name starts with "firebird", otherwise you need a different -c argument.)

Joachim

Nothing came back. It is actually listening through xinetd. My understanding is that nothing loads until the first connection is made. There is a config file for it ================================= # default: on # description: FirebirdSQL server # # Be careful when commenting out entries in this file. Active key entry should # be the first as some scripts (CSchangeRunUser.sh in particular) use sed # scripting to modify it. service gds_db { disable = no flags = REUSE socket_type = stream wait = no user = firebird # These lines cause problems with Windows XP SP2 clients # using default firewall configuration (SF#1065511) # log_on_success += USERID # log_on_failure += USERID server = /opt/firebird/bin/fb_inet_server } ======================================== # ---------------------------- # TCP Protocol Settings # # The TCP Service name/Port number to be used for client database # connections. # # It is only necessary to change one of the entries, not both. The # order of precendence is the 'RemoteServiceName' (if an entry is # found in the 'services.' file) then the 'RemoteServicePort'. # # Type: string, integer # #RemoteServiceName = gds_db #RemoteServicePort = 3050 # # The TCP Port Number to be used for server Event Notification # messages. The value of 0 (Zero) means that the server will choose # a port number randomly. # # Type: integer # #RemoteAuxPort = 0 # # TCP/IP buffer size for send and receive buffers of both the client # and server. The engine reads ahead of the client and can send # several rows of data in a single packet. The larger the packet size, # the more data is sent per transfer. Range is 1448 to 32767 (MAX_SSHORT). # # Type: integer # #TcpRemoteBufferSize = 8192 # # Either enables or disables Nagle algorithm (TCP_NODELAY option of # socket) of the socket connection. # # Note: Currently is a default for classic and super servers. # # Type: boolean # #TcpNoNagle = 1 # # Allows incoming connections to be bound to the IP address of a # specific network card. It enables rejection of incoming connections # through any other network interface except this one. By default, # connections from any available network interface are allowed. # # Type: string # #RemoteBindAddress = ========================================= Thse are all of the default settings and this normally works right out of the box. -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org

ianseeks wrote:

<snip>

...

# TCP Protocol Settings # # The TCP Service name/Port number to be used for client database # connections. # # It is only necessary to change one of the entries, not both. The # order of precendence is the 'RemoteServiceName' (if an entry is # found in the 'services.' file) then the 'RemoteServicePort'. # # Type: string, integer # #RemoteServiceName = gds_db #RemoteServicePort = 3050

Are you not supposed to remove the "#" on one of these options as it says "It is only necessary to change one of the entries, not both." in the paragraph above?

No, that's not necessary. As he worte, he wants to use xinetd, so firebird itself does no TCP listening at all. Joachim -- =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- Joachim Schrod Email: jschrod@acm.org Roedermark, Germany -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org

Tom Miller wrote:

Joachim Schrod wrote:

...

Tom Miller wrote:

...

I am trying to get Firebird database server running on my computer.

If I try to connect to the server in local mode (doesn't use IP at all), it works fine.

If I then try to connect with IP locally using 127.0.0.1 the connection is actively refused.

Are you sure that Firebird accepts IP connections at all?

What does lsof -c firebird | grep TCP say? (I assume that the firebird daemon name starts with "firebird", otherwise you need a different -c argument.)

Joachim

Nothing came back. It is actually listening through xinetd. My understanding is that nothing loads until the first connection is made.

Yes, that's right. I didn't know about usage of xinetd. You might want to check that xinetd listens for a connection, with netstat -an | grep 3050 There must be a line that looks like tcp 0 0 0.0.0.0:3050 0.0.0.0:* LISTEN If not, something gone astray in xinetd connection and start. If yes, do a telnet localhost 3050 and see if it outputs Trying 127.0.0.1... Connected to localhost. Escape character is '^]'. (You close the connection with Ctr-] q.) If that's OK, too, then you have a problem with the actual firebird inet server. It must accept requests on stdin and return the result on stdout. Then your most probable chance is to turn up logging and check the firebird logs carefully.

There is a config file for it

The xinetd config file is OK. The TCP configuration of firebird is not of interest if you're using xinetd. Then firebird does no TCP/IP handling at all. Good luck, Joachim -- =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- Joachim Schrod Email: jschrod@acm.org Roedermark, Germany -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org