Re: [firebird-support] Firebird 2.5 rejecting connections
On Mon, August 7, 2017 11:03 pm, 'livius' liviusliv...@poczta.onet.pl [firebird-support] wrote: > Hi, > put fbclient.dll / and/or/ gds32.dll into your application folder. That is standard practice, I do it at each installation. I have found several mentions of conflicts with antivirus sw such as NIS or NOD32. I will take a closer look at installed applications to see if there's anything suspicious
Re: [firebird-support] Firebird 2.5 rejecting connections
Hi, put fbclient.dll / and/or/ gds32.dll into your application folder. Remember that you need 32bit dll’s if your app is 32bit and 64bit dll if you have 64bit app (bitness of the server does not matter) Check if you have not Interbase installed on you computer side (some apps can install it) regards, Karol Bieniaszewski
RE: [firebird-support] Firebird 2.5 rejecting connections
>>>Can you connect locally by using TCP/IP(i.e.: using localhost or the >>> server's own IP)? > > Just my 2c. We have also experienced this on a few PC's. > > A connection string of: > > localhost:c:\MyFolder\MyData.fdb > > gives the connection rejected error. > > Changing to: > > c:\MyFolder\MyData.fdb > > resolves the problem. > I believe this switches the connection protocol to XNET and not TCP/IP so I don't think it would fix the issue should I need to connect from another machine. Here is an excerpt of the firebird log file when attempting a connection with ibmanager: XS001 (Client) Mon Aug 07 15:58:12 2017 INET/inet_error: read errno = 10054 XS001 Mon Aug 07 15:58:12 2017 inet server err: setting KEEPALIVE socket option XS001 Mon Aug 07 15:58:12 2017 inet server err: setting NODELAY socket option XS001 Mon Aug 07 15:58:12 2017 INET/select_wait: found "not a socket" socket : 236 XS001 Mon Aug 07 15:58:12 2017 INET/inet_error: select in packet_receive errno = 10038 XS001 Mon Aug 07 15:58:12 2017 Unable to complete network request to host "XS001". Error reading data from the connection. This is the error returned: Connection rejected by remote interface. SQL code: -923 IB error #: 335544421 Thanks!
RE: [firebird-support] Firebird 2.5 rejecting connections
>>Can you connect locally by using TCP/IP(i.e.: using localhost or the >>server's own IP)? Just my 2c. We have also experienced this on a few PC's. A connection string of: localhost:c:\MyFolder\MyData.fdb gives the connection rejected error. Changing to: c:\MyFolder\MyData.fdb resolves the problem. We haven't managed to get to the bottom of it yet, we usually just end up using the local connection string, but it would be nice to finally know what's causing it instead of using the workaround. Unfortunately, once the workaround is in effect, we then don't end up with much time to scrutinise the person's PC to find out what the problem was.
Re: [firebird-support] Firebird 2.5 rejecting connections
> Monday, August 7, 2017, 5:54:06 AM, you wrote: > > > > On the remote client box, same story. Match the client to the bitness > of the application and driver, not the remote server. If you > installed a 32-bit kit, you would not get a copy of the 64-bit client. > In the 64-bit kits you get both, with the 64-bit one in $firebird\bin > directory and the 32-bit one in $firebird\WOW64. I looked in system directories to make sure there wasn't anything that could cause the issue (I was thinking of some 3rd party application using fb embedded). The only DLL present on the system is the one that comes from the firebird installer. > > Also, considering the problem with localhost on the server box, have > you checked your system variables to make sure FIREBIRD is > pointing to the right place? It's just a stray thought, as I've > never heard of connection problems associated with that variable > being missing or bad. I'd think it would only be a problem if it was > set previously for an older version; while the newer version is > located in a different subdir. I'll look into that today, worst case scenario I should be able to retrieve firebird log files.
Re: [firebird-support] Firebird 2.5 rejecting connections
Monday, August 7, 2017, 5:54:06 AM, you wrote: >> >> Did you actually replace the client lib on the remote box with the >> appropriate-bitness one from the installation? > System is x64 but x86 version of firebird is required due to legacy UDF. > I have tried deleting the DLLs from System32 and SysWOW64 to avoid PATH > issues but that didn't have any effect. So what are you talking about here? You're running 32-bit Firebird on a 64-bit box. That's fine. Still talking about the server box: you want the 32-bit client to run the Fb system utilities because you installed 32-bit utilities. For your own applications, running them on the server through TCP/IP local loopback, you want the Fb client's bitness matching your *application*, regardless of what bitness the Fb server is; likewise any driver layers such as ODBC. On the remote client box, same story. Match the client to the bitness of the application and driver, not the remote server. If you installed a 32-bit kit, you would not get a copy of the 64-bit client. In the 64-bit kits you get both, with the 64-bit one in $firebird\bin directory and the 32-bit one in $firebird\WOW64. Also, considering the problem with localhost on the server box, have you checked your system variables to make sure FIREBIRD is pointing to the right place? It's just a stray thought, as I've never heard of connection problems associated with that variable being missing or bad. I'd think it would only be a problem if it was set previously for an older version; while the newer version is located in a different subdir. Helen
Re: [firebird-support] Firebird 2.5 rejecting connections
> Hi, > > At August 6, 2017, 4:07 AM, 'C' ch...@vp44.net [firebird-support] wrote: > >> On a brand new install for Firebird 2.5.7 (x86) I am having issues >> connecting to the server via TCP/IP. >> The error message is always the same "Connection rejected by remote >> interface" however I have tried several DB utilities and I can connect >> fine via local protocol but not via network address. > > Can you connect locally by using TCP/IP(i.e.: using localhost or the > server's own IP)? > No. The only way I am able to connect to the DB is via XNET.
Re: [firebird-support] Firebird 2.5 rejecting connections
Hi, At August 6, 2017, 4:07 AM, 'C' ch...@vp44.net [firebird-support] wrote: > On a brand new install for Firebird 2.5.7 (x86) I am having issues > connecting to the server via TCP/IP. > The error message is always the same "Connection rejected by remote > interface" however I have tried several DB utilities and I can connect > fine via local protocol but not via network address. Can you connect locally by using TCP/IP(i.e.: using localhost or the server's own IP)? -- Best regards, Daniel Rail Senior Software Developer ACCRA Solutions Inc. (www.accra.ca) ACCRA Med Software Inc. (www.filopto.com)
Re: [firebird-support] Firebird 2.5 rejecting connections
> Sunday, August 6, 2017, 7:07:02 PM, you wrote: > Hi Helen >> On a brand new install for Firebird 2.5.7 (x86) I am having issues >> connecting to the server via TCP/IP. >> The error message is always the same "Connection rejected by remote >> interface" however I have tried several DB utilities and I can connect >> fine via local protocol but not via network address. > >> I'm suspecting a library issue (conflicting fbclient.dll or gds32.dll) >> but >> for the love of God I have been unable to find it anywhere on the >> system. > >> Anyone have any tips on the issue? > > To ask the obvious, is port 3050 open on the server? Yes, port 3050 is correctly open and listening on all local interfaces. I have tried changing the port to 30500 but I'm still getting the same message. > > How would you recognise "a conflicting fbclient.dll or gds32.dll"? I believe the error message is returned by the firebird server itself, meaning the connection was established successfully but something else is failing further down. I'm not sure exactly what though: authentication process, fdb file or other? > > Did you actually replace the client lib on the remote box with the > appropriate-bitness one from the installation? System is x64 but x86 version of firebird is required due to legacy UDF. I have tried deleting the DLLs from System32 and SysWOW64 to avoid PATH issues but that didn't have any effect.
Re: [firebird-support] Firebird 2.5 rejecting connections
Sunday, August 6, 2017, 7:07:02 PM, you wrote: > Hi all. > On a brand new install for Firebird 2.5.7 (x86) I am having issues > connecting to the server via TCP/IP. > The error message is always the same "Connection rejected by remote > interface" however I have tried several DB utilities and I can connect > fine via local protocol but not via network address. > I'm suspecting a library issue (conflicting fbclient.dll or gds32.dll) but > for the love of God I have been unable to find it anywhere on the system. > Anyone have any tips on the issue? To ask the obvious, is port 3050 open on the server? How would you recognise "a conflicting fbclient.dll or gds32.dll"? Did you actually replace the client lib on the remote box with the appropriate-bitness one from the installation? Helen