Re: [firebird-support] Firebird client connection timeout
On 2020-03-10 20:14, Andrei Luís compuvale.softw...@gmail.com [firebird-support] wrote: > Hummm, I think Dimitry is right. I made some tests here on client > side: > > server IP: 10.0.2.2 > path: d:\database.fdb > > Using connection string: 10.0.2.2:d:\database.fdb Correct IP and > correct path, the connect is made instantly > > Using connection string: 10..0.2.2:d:\data.fdb Correct IP and wrong > path, instantly my application recognizes the error, and a error > message appears. > > Using connection string: 10.0.2.21:d:\database.fdb Wrong IP and > correct path, the application freezes for about 45 seconds, and just > after that the error message appears. > > So, even though this is not a Firebird issue, do anyone has a tip to > solve this delay on windows? Should it be set on the server or on the > clients? > > Thanks in advance. Maybe this can help: https://serverfault.com/questions/193160/which-is-the-default-tcp-connect-timeout-in-windows Mark
Re: [firebird-support] Firebird client connection timeout
I do not remember from memory but look for "netsh" commandRegards,Karol Bieniaszewski null
Re: [firebird-support] Firebird client connection timeout
Hummm, I think Dimitry is right. I made some tests here on client side: server IP: 10.0.2.2 path: d:\database.fdb Using connection string: 10.0.2.2:d:\database.fdb Correct IP and correct path, the connect is made instantly Using connection string: 10.0.2.2:d:\data.fdb Correct IP and wrong path, instantly my application recognizes the error, and a error message appears. Using connection string: 10.0.2.21:d:\database.fdb Wrong IP and correct path, the application freezes for about 45 seconds, and just after that the error message appears. So, even though this is not a Firebird issue, do anyone has a tip to solve this delay on windows? Should it be set on the server or on the clients? Thanks in advance. []s Andrei Em ter., 10 de mar. de 2020 às 13:44, Dimitry Sibiryakov s...@ibphoenix.com [firebird-support] escreveu: > 10.03.2020 15:57, Mark Rotteveel m...@lawinegevaar.nl [firebird-support] > wrote: > > On 10-03-2020 15:46, Andrei Luís compuvale.softw...@gmail.com > > [firebird-support] wrote: > > > No, there wasn't. I copied fbclient.dll and firebird to the > application > > > folder. Still the same! > > > > Well, as far as I know, this should work. > >No, it shouldn't and never could. TCP connection timeout is a > completely OS thing, no > Firebird settings can change it. > > -- >WBR, SD. > > > > Posted by: Dimitry Sibiryakov > > > ++ > > Visit http://www.firebirdsql.org and click the Documentation item > on the main (top) menu. Try FAQ and other links from the left-side menu > there. > > Also search the knowledgebases at > http://www.ibphoenix.com/resources/documents/ > > ++ > > > Yahoo Groups Links > > > >
Re: [firebird-support] Firebird client connection timeout
10.03.2020 18:32, Mark Rotteveel m...@lawinegevaar.nl [firebird-support] wrote: > Then the setting shouldn't be called ConnectionTimeout in my opinion. In > any case, why can't Firebird do this, when for example Java has no > problem with using a connection timeout for sockets? Java can pretend to do anything and the usual trick for it is using of select() and then close socket after timeout but closing of the socket does not guarantee nor even promise to abort the connection in progress neither in Win32 nor POSIX. Whole TCP has no such mechanic AFAIK. -- WBR, SD. ++ Visit http://www.firebirdsql.org and click the Documentation item on the main (top) menu. Try FAQ and other links from the left-side menu there. Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ ++ Yahoo Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/firebird-support/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/firebird-support/join (Yahoo! ID required) <*> To change settings via email: firebird-support-dig...@yahoogroups.com firebird-support-fullfeatu...@yahoogroups.com <*> To unsubscribe from this group, send an email to: firebird-support-unsubscr...@yahoogroups.com <*> Your use of Yahoo Groups is subject to: https://info.yahoo.com/legal/us/yahoo/utos/terms/
Re: [firebird-support] Firebird client connection timeout
On 10-03-2020 17:44, Dimitry Sibiryakov s...@ibphoenix.com [firebird-support] wrote: > 10.03.2020 15:57, Mark Rotteveel m...@lawinegevaar.nl [firebird-support] > wrote: >> On 10-03-2020 15:46, Andrei Luís compuvale.softw...@gmail.com >> [firebird-support] wrote: >> > No, there wasn't. I copied fbclient.dll and firebird to the application >> > folder. Still the same! >> >> Well, as far as I know, this should work. > > No, it shouldn't and never could. TCP connection timeout is a completely > OS thing, no > Firebird settings can change it. Then the setting shouldn't be called ConnectionTimeout in my opinion. In any case, why can't Firebird do this, when for example Java has no problem with using a connection timeout for sockets? Mark -- Mark Rotteveel
Re: [firebird-support] Firebird client connection timeout
10.03.2020 15:57, Mark Rotteveel m...@lawinegevaar.nl [firebird-support] wrote: > On 10-03-2020 15:46, Andrei Luís compuvale.softw...@gmail.com > [firebird-support] wrote: > > No, there wasn't. I copied fbclient.dll and firebird to the application > > folder. Still the same! > > Well, as far as I know, this should work. No, it shouldn't and never could. TCP connection timeout is a completely OS thing, no Firebird settings can change it. -- WBR, SD.
Re: [firebird-support] Firebird client connection timeout
Hi Mark, Application is 32bits Server side is running Win 64 and Firebird 32 bits Client side is running Win 32 Yes, I removed # in firebird.conf I'm using IBObjects and fbclient.dll. Well, in a few hours I'll try with a physical client wachine, instead into VirtualBox, maybe there something conflicting in virtual machine. Many thanks for your time Mark. []s Andrei Em ter., 10 de mar. de 2020 às 11:57, Mark Rotteveel m...@lawinegevaar..nl [firebird-support] escreveu: > On 10-03-2020 15:46, Andrei Luís compuvale.softw...@gmail.com > [firebird-support] wrote: > > No, there wasn't. I copied fbclient.dll and firebird to the application > > folder. Still the same! > > Well, as far as I know, this should work. Is your Windows 32 bit or 64 > bit, and is your application 32 bit or 64 bit? If your windows is 64 > bit, but your application is 32 bit, it will probably be using a > fbclient.dll in C:\Windows\SysWOW64 (which is for 32 bit libraries on > Windows 64 bit), and in that case you will need to put the firebird.conf > there. > > Also make sure that the setting is not prefixed with a #, which would > make it a comment. > > And a final check question: is your application actually using > fbclient.dll (and not for example Jaybird or the Firebird ADO.net > provider, or some other connection library that doesn't use fbclient.dll).. > > Mark > > -- > Mark Rotteveel > > > > Posted by: Mark Rotteveel > > > ++ > > Visit http://www.firebirdsql.org and click the Documentation item > on the main (top) menu. Try FAQ and other links from the left-side menu > there. > > Also search the knowledgebases at > http://www.ibphoenix.com/resources/documents/ > > ++ > > > Yahoo Groups Links > > > >
Re: [firebird-support] Firebird client connection timeout
On 10-03-2020 15:46, Andrei Luís compuvale.softw...@gmail.com [firebird-support] wrote: > No, there wasn't. I copied fbclient.dll and firebird to the application > folder. Still the same! Well, as far as I know, this should work. Is your Windows 32 bit or 64 bit, and is your application 32 bit or 64 bit? If your windows is 64 bit, but your application is 32 bit, it will probably be using a fbclient.dll in C:\Windows\SysWOW64 (which is for 32 bit libraries on Windows 64 bit), and in that case you will need to put the firebird.conf there. Also make sure that the setting is not prefixed with a #, which would make it a comment. And a final check question: is your application actually using fbclient.dll (and not for example Jaybird or the Firebird ADO.net provider, or some other connection library that doesn't use fbclient.dll). Mark -- Mark Rotteveel
Re: [firebird-support] Firebird client connection timeout
No, there wasn't. I copied fbclient.dll and firebird to the application folder. Still the same! []s Andrei Em ter., 10 de mar. de 2020 às 11:44, Mark Rotteveel m...@lawinegevaar..nl [firebird-support] escreveu: > On 10-03-2020 15:40, Andrei Luís compuvale.softw...@gmail.com > [firebird-support] wrote: > > Just did that. Still the same. > > Check if your client application has its own fbclient.dll, and put a > firebird.conf in the same directory as that fbclient.dll. > > Mark > -- > Mark Rotteveel > > > > Posted by: Mark Rotteveel > > > ++ > > Visit http://www.firebirdsql.org and click the Documentation item > on the main (top) menu. Try FAQ and other links from the left-side menu > there. > > Also search the knowledgebases at > http://www.ibphoenix.com/resources/documents/ > > ++ > > > Yahoo Groups Links > > > >
Re: [firebird-support] Firebird client connection timeout
On 10-03-2020 15:40, Andrei Luís compuvale.softw...@gmail.com [firebird-support] wrote: > Just did that. Still the same. Check if your client application has its own fbclient.dll, and put a firebird.conf in the same directory as that fbclient.dll. Mark -- Mark Rotteveel
Re: [firebird-support] Firebird client connection timeout
Just did that. Still the same. []s Andrei Em ter., 10 de mar. de 2020 às 11:35, Mark Rotteveel m...@lawinegevaar..nl [firebird-support] escreveu: > On 10-03-2020 15:33, Andrei Luís compuvale.softw...@gmail.com > [firebird-support] wrote: > > > > > > Server side > > fbclient.dll = C:\Program Files (x86)\Firebird\Firebird_2_5\bin and > > c:\Windows\SysWOW64 > > firebird.conf = C:\Program Files (x86)\Firebird\Firebird_2_5 > > > > > > Client side > > fbclient.dll = C:\Program Files\Firebird\Firebird_2_5\bin and > > c:\Windows\System32 > > firebird.conf = C:\Program Files\Firebird\Firebird_2_5 > > Put a firebird.conf with the timeout setting in C:\Windows\System32. > Your client application is unlikely to use the fbclient.dll in your > Firebird install, but instead will use the fbclient.dll in > C:\Windows\System32, and so the firebird.conf file needs to be in that > location. > > Mark > -- > Mark Rotteveel > > > > Posted by: Mark Rotteveel > > > ++ > > Visit http://www.firebirdsql.org and click the Documentation item > on the main (top) menu. Try FAQ and other links from the left-side menu > there. > > Also search the knowledgebases at > http://www.ibphoenix.com/resources/documents/ > > ++ > > > Yahoo Groups Links > > > >
Re: [firebird-support] Firebird client connection timeout
On 10-03-2020 15:33, Andrei Luís compuvale.softw...@gmail.com [firebird-support] wrote: > > > Server side > fbclient.dll = C:\Program Files (x86)\Firebird\Firebird_2_5\bin and > c:\Windows\SysWOW64 > firebird.conf = C:\Program Files (x86)\Firebird\Firebird_2_5 > > > Client side > fbclient.dll = C:\Program Files\Firebird\Firebird_2_5\bin and > c:\Windows\System32 > firebird.conf = C:\Program Files\Firebird\Firebird_2_5 Put a firebird.conf with the timeout setting in C:\Windows\System32. Your client application is unlikely to use the fbclient.dll in your Firebird install, but instead will use the fbclient.dll in C:\Windows\System32, and so the firebird.conf file needs to be in that location. Mark -- Mark Rotteveel
Re: [firebird-support] Firebird client connection timeout
Server side fbclient.dll = C:\Program Files (x86)\Firebird\Firebird_2_5\bin and c:\Windows\SysWOW64 firebird.conf = C:\Program Files (x86)\Firebird\Firebird_2_5 Client side fbclient.dll = C:\Program Files\Firebird\Firebird_2_5\bin and c:\Windows\System32 firebird.conf = C:\Program Files\Firebird\Firebird_2_5 []s Andrei Em ter., 10 de mar. de 2020 às 11:23, Mark Rotteveel m...@lawinegevaar..nl [firebird-support] escreveu: > On 10-03-2020 15:21, Andrei Luís compuvale.softw...@gmail.com > [firebird-support] wrote: > > Sorry for my lack of infos, I read your previous message before post my > > message here. I'm testing this in the my dev machine, I configured > > ConnectionTimeout in the firebird.conf file in the physical machine, and > > configured it in the virtual machine I use (VirtualBox) too. > > > > In this scenario the physical machine is the server, and the virtual > > machine is the client, right? Well, I tested again now, and running my > > application in the server, the 5 secs timeout is working fine. But > > inside the virtual machine, the timeout is not working as I set. It is > > taking about 45 secs to timeout. > > > > Is there something I'm doing wrong? Thanks for your time. > > Where is your libfbclient.so (or fbclient.dll), and where is the > firebird.conf file? > > Mark > -- > Mark Rotteveel > > > > Posted by: Mark Rotteveel > > > ++ > > Visit http://www.firebirdsql.org and click the Documentation item > on the main (top) menu. Try FAQ and other links from the left-side menu > there. > > Also search the knowledgebases at > http://www.ibphoenix.com/resources/documents/ > > ++ > > > Yahoo Groups Links > > > >
Re: [firebird-support] Firebird client connection timeout
On 10-03-2020 15:21, Andrei Luís compuvale.softw...@gmail.com [firebird-support] wrote: > Sorry for my lack of infos, I read your previous message before post my > message here. I'm testing this in the my dev machine, I configured > ConnectionTimeout in the firebird.conf file in the physical machine, and > configured it in the virtual machine I use (VirtualBox) too. > > In this scenario the physical machine is the server, and the virtual > machine is the client, right? Well, I tested again now, and running my > application in the server, the 5 secs timeout is working fine. But > inside the virtual machine, the timeout is not working as I set. It is > taking about 45 secs to timeout. > > Is there something I'm doing wrong? Thanks for your time. Where is your libfbclient.so (or fbclient.dll), and where is the firebird.conf file? Mark -- Mark Rotteveel
Re: [firebird-support] Firebird client connection timeout
Hi Mark, thanks for your answer. Sorry for my lack of infos, I read your previous message before post my message here. I'm testing this in the my dev machine, I configured ConnectionTimeout in the firebird.conf file in the physical machine, and configured it in the virtual machine I use (VirtualBox) too. In this scenario the physical machine is the server, and the virtual machine is the client, right? Well, I tested again now, and running my application in the server, the 5 secs timeout is working fine. But inside the virtual machine, the timeout is not working as I set. It is taking about 45 secs to timeout. Is there something I'm doing wrong? Thanks for your time. []s Andrei Em ter., 10 de mar. de 2020 às 10:54, Mark Rotteveel m...@lawinegevaar..nl [firebird-support] escreveu: > On 10-03-2020 14:41, Andrei Luís compuvale.softw...@gmail.com > [firebird-support] wrote: > > I'm having the same problem. Already set ConnectionTimeout = 5 in > > firebird.conf, restarted the FB service, and the connect try is going so > > far from that. I'm using FB 2.5. Is there anything else to set? > > To repeat my previous post: > > """ > ConnectionTimeout isn't a server setting, it is in the section with the > header "Client Connection Settings (Basic)". > > However, to apply to a fbclient, it must be configured in a > firebird.conf in the same directory as the fbclient.dll/libfbclient.so > """ > > Or in other words: changing the config on the *server* has no effect, > because you must change the config of the *client*. > > The settings in firebird.conf are not only for the server, but some of > them are (also or only) configuration options for the client. However, > for those settings to apply to the client, they must be in a > firebird.conf that is actually read by the client, which usually is not > the firebird.conf of the server. > > Mark > -- > Mark Rotteveel > > > > Posted by: Mark Rotteveel > > > ++ > > Visit http://www.firebirdsql.org and click the Documentation item > on the main (top) menu. Try FAQ and other links from the left-side menu > there. > > Also search the knowledgebases at > http://www.ibphoenix.com/resources/documents/ > > ++ > > > Yahoo Groups Links > > > >
Re: [firebird-support] Firebird client connection timeout
On 10-03-2020 14:41, Andrei Luís compuvale.softw...@gmail.com [firebird-support] wrote: > I'm having the same problem. Already set ConnectionTimeout = 5 in > firebird.conf, restarted the FB service, and the connect try is going so > far from that. I'm using FB 2.5. Is there anything else to set? To repeat my previous post: """ ConnectionTimeout isn't a server setting, it is in the section with the header "Client Connection Settings (Basic)". However, to apply to a fbclient, it must be configured in a firebird.conf in the same directory as the fbclient.dll/libfbclient.so """ Or in other words: changing the config on the *server* has no effect, because you must change the config of the *client*. The settings in firebird.conf are not only for the server, but some of them are (also or only) configuration options for the client. However, for those settings to apply to the client, they must be in a firebird.conf that is actually read by the client, which usually is not the firebird.conf of the server. Mark -- Mark Rotteveel
Re: [firebird-support] Firebird client connection timeout
Hello, I'm having the same problem. Already set ConnectionTimeout = 5 in firebird.conf, restarted the FB service, and the connect try is going so far from that. I'm using FB 2.5. Is there anything else to set? []s Andrei Em qua., 1 de jan. de 2020 às 05:33, Mark Rotteveel m...@lawinegevaar.nl [firebird-support] escreveu: > On 31/12/2019 12:40, Nagy Szilveszter nagy_szilvesz...@yahoo.com > [firebird-support] wrote: > > Is there a way to set _connection timeout_ for firebird _at client side_? > [..] > > At server side there is a ConnectionTimeout parameter, but it does not > > help me in this case (when i try to connect to an inexistent server, > > caused by wrong configuration). > > ConnectionTimeout isn't a server setting, it is in the section with the > header "Client Connection Settings (Basic)". > > However, to apply to a fbclient, it must be configured in a > firebird.conf in the same directory as the fbclient.dll/libfbclient.so > > Alternatively, in Firebird 3 and higher, you should be able to pass the > value in the DPB item isc_dpb_config (which basically takes a > linebreak-separated list of key=value with the firebird.conf clientside > configuration. > > There is also isc_dpb_connect_timeout, but as far as I know that only > governs the attach handshake, as it is only applied after establishing > the socket connection, which makes it unsuitable. > > Mark > -- > Mark Rotteveel > > > > Posted by: Mark Rotteveel > > > ++ > > Visit http://www.firebirdsql.org and click the Documentation item > on the main (top) menu. Try FAQ and other links from the left-side menu > there. > > Also search the knowledgebases at > http://www.ibphoenix.com/resources/documents/ > > ++ > > > Yahoo Groups Links > > > >
Re: [firebird-support] Firebird client connection timeout
On 31/12/2019 12:40, Nagy Szilveszter nagy_szilvesz...@yahoo.com [firebird-support] wrote: > Is there a way to set _connection timeout_ for firebird _at client side_? [..] > At server side there is a ConnectionTimeout parameter, but it does not > help me in this case (when i try to connect to an inexistent server, > caused by wrong configuration). ConnectionTimeout isn't a server setting, it is in the section with the header "Client Connection Settings (Basic)". However, to apply to a fbclient, it must be configured in a firebird.conf in the same directory as the fbclient.dll/libfbclient.so Alternatively, in Firebird 3 and higher, you should be able to pass the value in the DPB item isc_dpb_config (which basically takes a linebreak-separated list of key=value with the firebird.conf clientside configuration. There is also isc_dpb_connect_timeout, but as far as I know that only governs the attach handshake, as it is only applied after establishing the socket connection, which makes it unsuitable. Mark -- Mark Rotteveel
Re: [firebird-support] Firebird client connection timeout
It sounds like connection pooling is being used such as odbc, keeping 5 connections open for reuse. To avoid this, you must change the connection string to contain something new. This avoids the connection pooling process. Example adding something as simple as time with seconds to a connection string bypasses the connection pool process strictly because the connection string is recongnized as new and not in the current connection pool. In odbc I used a connection string parameter that is simply ignored such as mytime=hhmmss Sent from Yahoo Mail for iPhone On Tuesday, December 31, 2019, 6:40 AM, Nagy Szilveszter nagy_szilvesz...@yahoo.com [firebird-support] wrote: Hi all! Is there a way to set connection timeout for firebird at client side? The default value is somewhere around 50 seconds and if i have wrong IP address set up in connection parameters then the application will freeze for almost a minute before it gives an error message that it couldn't connect. I'd like to reduce this waiting time to 5 seconds. At server side there is a ConnectionTimeout parameter, but it does not help me in this case (when i try to connect to an inexistent server, caused by wrong configuration). In real world example i have 2 servers configurations in a priority list (the development server and the production one). The production server is the highest priority one, so my clients have quick connection when they use the application. But when i'm in development environment (where the production server is not reachable) the application would first try the prod server then after failing it will try next server and my connection takes about a minute. I'd like this to be 5 seconds or less. (I know i could create connection definition files on each computer and rely on those files - but that would bring more administration issues which i don't want for this simple app) Can you help me? Thank you and have a happy new year! #yiv3450127990 #yiv3450127990 -- #yiv3450127990ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv3450127990 #yiv3450127990ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv3450127990 #yiv3450127990ygrp-mkp #yiv3450127990hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv3450127990 #yiv3450127990ygrp-mkp #yiv3450127990ads {margin-bottom:10px;}#yiv3450127990 #yiv3450127990ygrp-mkp .yiv3450127990ad {padding:0 0;}#yiv3450127990 #yiv3450127990ygrp-mkp .yiv3450127990ad p {margin:0;}#yiv3450127990 #yiv3450127990ygrp-mkp .yiv3450127990ad a {color:#ff;text-decoration:none;}#yiv3450127990 #yiv3450127990ygrp-sponsor #yiv3450127990ygrp-lc {font-family:Arial;}#yiv3450127990 #yiv3450127990ygrp-sponsor #yiv3450127990ygrp-lc #yiv3450127990hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv3450127990 #yiv3450127990ygrp-sponsor #yiv3450127990ygrp-lc .yiv3450127990ad {margin-bottom:10px;padding:0 0;}#yiv3450127990 #yiv3450127990actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv3450127990 #yiv3450127990activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv3450127990 #yiv3450127990activity span {font-weight:700;}#yiv3450127990 #yiv3450127990activity span:first-child {text-transform:uppercase;}#yiv3450127990 #yiv3450127990activity span a {color:#5085b6;text-decoration:none;}#yiv3450127990 #yiv3450127990activity span span {color:#ff7900;}#yiv3450127990 #yiv3450127990activity span .yiv3450127990underline {text-decoration:underline;}#yiv3450127990 .yiv3450127990attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv3450127990 .yiv3450127990attach div a {text-decoration:none;}#yiv3450127990 .yiv3450127990attach img {border:none;padding-right:5px;}#yiv3450127990 .yiv3450127990attach label {display:block;margin-bottom:5px;}#yiv3450127990 .yiv3450127990attach label a {text-decoration:none;}#yiv3450127990 blockquote {margin:0 0 0 4px;}#yiv3450127990 .yiv3450127990bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv3450127990 .yiv3450127990bold a {text-decoration:none;}#yiv3450127990 dd.yiv3450127990last p a {font-family:Verdana;font-weight:700;}#yiv3450127990 dd.yiv3450127990last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv3450127990 dd.yiv3450127990last p span.yiv3450127990yshortcuts {margin-right:0;}#yiv3450127990 div.yiv3450127990attach-table div div a {text-decoration:none;}#yiv3450127990 div.yiv3450127990attach-table {width:400px;}#yiv3450127990 div..yiv3450127990file-title a, #yiv3450127990 div.yiv3450127990file-title a:active, #yiv3450127990 div.yiv3450127990file-title a:hover, #yiv3450127990 div.yiv3450127990file-title a:visited {text-decoration:none;}#yiv3450127990 div.yiv3450127990photo-title a, #yiv3450127990 div.yiv3450127990photo-title a:active, #yiv3450127990 div.yiv3450127990photo-title a:hover, #yiv3450127990