Re: [firebird-support] port requirements for Firebird Services API - IBAnalyst
Follow-up on this issue... The problem was that an old copy of gdb32.dll was sitting in C:\Windows\SysWOW64. That was loaded before IBAnalyst tried to use fbclient.dll, and it was not suitable. The solution was to copying the recent 32-bit fbclient.dll to gds32.dll in the same folder as IBAnalyst.exe. There was no mysterious firewall issue whatsoever. Many thanks to Alexey at IBSurgeon for all the off-list emails and remote support to resolve this. Ann
[firebird-support] port requirements for Firebird Services API - IBAnalyst
Hi Firebird users and experts... Which ports need to be open for the Firebird Services API and which settings in firebird.conf control them? In general, I can connect to the database just fine. I wanted to follow up on the recent article ( http://ib-aid.com/en/articles/firebird-performance-degradation-tests-myths-and-truth/ ) so that is why I'm testing the IBAnalyst utility. I have port 3050 open and IBAnalyst gives an error connection rejected by remote interface when I click the [Run] button. I'm guessing the services API uses the randomly assigned RemoteAuxPort. I would like confirmation on that before changing the firewall configuration. I tried writing to support at ibanalyst.com but have not heard back after 2 days. I am thinking that RemoteServicePort defaults to 3050 and that I should configure RemoteAuxPort to the port of my choice, say 3051, and then let that through the firewall for LAN requests. Is that correct? I have *not* yet set RemoteServicePort nor RemoteAuxPort in Firebird.conf, so they are going by the defaults. Server -- running Firebird 2.5.2 on CentOS Linux. Client -- running IBAnalyst on Windows 7. Thank you in advance. Ann Lynnworth HREF Tools Corp. www.href.com
Re: [firebird-support] port requirements for Firebird Services API - IBAnalyst
Hi Ann, Unfortunately, we did not receive your email to supp...@ib-aid.com or to ibanal...@ib-aid.com. Services API works through the same port (3050 by default), as all connections. Regarding IBAnalyst connection - most likely you don't have correct version of client library in path, and IBAnalyst loads some old version. The easiest way to fix it is to copy fbclient.dll (it should be 32bit) to its folder C:\Program Files (x86)\IBAnalyst27 Regards, Alexey Kovyazin IBSurgeon PS Our main support email is supp...@ib-aid.com, please feel free to contact us. Hi Firebird users and experts... Which ports need to be open for the Firebird Services API and which settings in firebird.conf control them? In general, I can connect to the database just fine. I wanted to follow up on the recent article ( http://ib-aid.com/en/articles/firebird-performance-degradation-tests-myths-and-truth/ ) so that is why I'm testing the IBAnalyst utility. I have port 3050 open and IBAnalyst gives an error connection rejected by remote interface when I click the [Run] button. I'm guessing the services API uses the randomly assigned RemoteAuxPort. I would like confirmation on that before changing the firewall configuration. I tried writing to support at ibanalyst.com but have not heard back after 2 days. I am thinking that RemoteServicePort defaults to 3050 and that I should configure RemoteAuxPort to the port of my choice, say 3051, and then let that through the firewall for LAN requests. Is that correct? I have *not* yet set RemoteServicePort nor RemoteAuxPort in Firebird.conf, so they are going by the defaults. Server -- running Firebird 2.5.2 on CentOS Linux. Client -- running IBAnalyst on Windows 7. Thank you in advance. Ann Lynnworth HREF Tools Corp. www.href.com
Re: [firebird-support] port requirements for Firebird Services API - IBAnalyst
Hi Alexey, Thank you for the quick reply. I copied that support@ address from http://ib-aid.com/en/articles/ibanalyst-how-to-get-statistics-from-interbase-firebird-database-in-right-way/ at the very bottom. I just tried putting fbclient.dll (32-bit) into the same directory as the IBAnalyst.exe and I still get the same error. I took the fbclient.dll from Firebird-2.5.2.26540-0_Win32.zip so it is definitely the latest one. I installed to a custom path on d:\Apps\IBSurgeon... not c:\Program Files (x86)\ by the way. IBAnalyst Help shows version 2.7.5.15. When I click [Run], I see the working icon for 1-2 seconds and then the error message. I triple-checked the host name and database name; they are the usual ones that I use in other utilities. I don't mind continuing this off-list, or on-list. Maybe the final answer will help some other potential customers for you. Ann