Re: [firebird-support] Suddenly, Firebird stop accepting remote connections.
On 17/7/18 12:13 am, Marcelo Guimaraes mfguimar...@gmail.com [firebird-support] wrote: Affected versions identified: 2.5.8, 2.5.7 and 2.5.5 all as SuperClassic running on dedicated server with Debian distribution. I'm going through a situation where applications can not connect to Firebird. At a certain point, suddenly, Firebird does not accept remote connections. Connecting locally, via isql, it is possible to access Firebird and perform queries normally, but not remote. No error messages are identified in the Firebird log or operating system logs. As a workaround, we only restart Firebird and it works normally, receiving local and remote connections. We bserve that if we return Firebird to version 2.5.0 these issue stop happening. I have enabled the audit to try to identify what is happening at the time of the freeze, however in each freeze I observe a different set of sql commands, there is not indicating what can be causing the issue and also there are no error or warning messages on audit log. Has anyone gone through this or have any suggestions on how can I identify what might be causing this freeze? I saw similar behaviour in 2.5.8 on Linux. It is reported as bug CORE-5757 (http://tracker.firebirdsql.org/browse/CORE-5757?subTaskView=unresolved) and is fixed for 2.5.9. For me it seemed to be related to using database events, but the comments on the bug from the developers suggest it is not related. I have patched 2.5.8 packages for Debian stretch which you could try. Hamish
[firebird-support] Losing Firebird connection into a VPS
Hello: My background with Firebird has been mostly to use it for a local desktop application. A few years ago we started to experiment with a remote connection on a website and I have had no issues with that other than the speed. Recently, we plan to use FB 3 and a database as a remote application authorization process. We shifted to a VPS hosting and what I have been seeing is that while using IBExpert to connect, after maybe a couple of minutes it is disconnected from the database. I have not tried to connect through the application yet, but use IBExpert to do maintenance on the remote database. I have reviewed the Firebird conf file and cannot find any settings which would cause this, nor can I find any settings (the connection timeout is set for 0, which I assume means indefinite connection) in IBExpert, nor are there any settings in the server windows firewall. We also asked the hosting company about this and they did not seem to know. Does anyone have any ideas on what I need to do to keep connected to the remote (VPS) Firebird server? Thank you! Chuck --- This email has been checked for viruses by Avast antivirus software. https://www.avast.com/antivirus
Re: [firebird-support] LOCALTIME and LOCALTIMESTAMP
On 18-7-2018 15:42, liviuslivius liviusliv...@poczta.onet.pl [firebird-support] wrote: > >>I suggest you take this question to the firebird-devel mailing list as > >>it concerns an unreleased version. Questions on FB4 are off topic here. > > >>Mark > > Yes, but as local_time and local_timestamp was forwarded to FB3 it is > important to know if we need also Local_date as replacement to > Current_date in FB3. Then we must know FB4 TZ configuration details like > is it retrived from system or from firebird config LOCALTIME and LOCALTIMESTAMP are not available in any **released** Firebird 3 version, so technically questions about the presence of those functions in Firebird 3 should also go to firebird-devel. In any case, you were asking about the behavior and implications of time zone config in Firebird 4. That is not the same as asking about the introduction of LOCALTIME and LOCALTIMESTAMP as aliases for CURRENT_TIME and CURRENT_TIMESTAMP in Firebird 3. Again, these questions should go to the firebird-devel list. Mark -- Mark Rotteveel
Re: [firebird-support] LOCALTIME and LOCALTIMESTAMP
18.07.2018 15:42, liviuslivius liviusliv...@poczta.onet.pl [firebird-support] wrote: > Yes, but as local_time and local_timestamp was forwarded to FB3 it is > important to know if > we need also Local_date as replacement to Current_date in FB3. Then we must > know FB4 TZ > configuration details like is it retrived from system or from firebird config doc/README.time_zone_forward_compatibility.md was created in Firebird 3 branch. Documentation for Firebird 4 is in respective brach as well AFAICS. -- 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] LOCALTIME and LOCALTIMESTAMP
>>I suggest you take this question to the firebird-devel mailing list as >>it concerns an unreleased version. Questions on FB4 are off topic here. >>Mark Yes, but as local_time and local_timestamp was forwarded to FB3 it is important to know if we need also Local_date as replacement to Current_date in FB3. Then we must know FB4 TZ configuration details like is it retrived from system or from firebird configĀ Regards,Karol Bieniaszewski null
Re: [firebird-support] LOCALTIME and LOCALTIMESTAMP
On 18/07/18 09:50, Mark Rotteveel m...@lawinegevaar.nl [firebird-support] wrote: > I suggest you take this question to the firebird-devel mailing list as > it concerns an unreleased version. Questions on FB4 are off topic here. Although the corner cutting being taken in the current implementation should be more widely known! Timezone information will be restricted to minute accuracy and not able to handle all transitions correctly! This is a major limitation in my book and makes it useless for my own historic material! -- Lester Caine - G8HFL - Contact - http://lsces.co.uk/wiki/?page=contact L.S.Caine Electronic Services - http://lsces.co.uk EnquirySolve - http://enquirysolve.com/ Model Engineers Digital Workshop - http://medw.co.uk Rainbow Digital Media - http://rainbowdigitalmedia.co.uk
Re: [firebird-support] LOCALTIME and LOCALTIMESTAMP
On 2018-07-17 18:39, 'livius' liviusliv...@poczta.onet.pl [firebird-support] wrote: > But how timezone settup is configured in FB4? > Time zone is set in fbconfig (preffered) or is retrived from system? > If from config, then CURRENT_DATE and LOCAL_TIMESTAMP will get > different date when different timezone setting is in config and on the > server. I suggest you take this question to the firebird-devel mailing list as it concerns an unreleased version. Questions on FB4 are off topic here. Mark