Re: [firebird-support] Connection issues
At 01:25 p.m. 28/05/2015, 'seanspcpower IT Services' t...@seanspcpower.com [firebird-supp wrote: >The issue is lately the 1 client can no longer connect to the database using >the client application. > > >The application Ostendo and we have the Firebird database runs on an sbs2008 >box. > >It is a domain controller. >Exchange server. >DHCP >DNS >File and printer sharing. >Vipre Business Premium console dashboard >Vipre client runs on the server and the firewall policy is disabled. >Windows firewall is running but I have ports 3050 and 9050 open. > > >It was working fine until a few days ago. > >The user says he was using Friday ok and came in Monday morning and when he >launches the ostendo client gets the following error (see attached). You can't post attachments in this list. Report the error message and also check the latest entries in firebird.log. >We spoke to Ostendo support and they said to just reinstall the client but >that made no difference. What "client" did you try to reinstall? My suspicion (and possibly theirs) is that someone installed something that overwrote the Firebird 1.5 client. Check again with Ostendo support. Ask them (1) where the application expects to find the Firebird client when running with a local user and (2) whether it expects to load fbclient.dll or gds32.dll. >I am just understanding the error message not sure how to troubleshoot as I >know nothing about Ostendo and Firebird databases. Post the text of the error message and also paste the entries from firebird.log that correspond to the times of the failed connection attempts. And please remove all that signature guff from your future postings to these lists. Helen Borrie, Support Consultant, IBPhoenix (Pacific) Author of "The Firebird Book" and "The Firebird Book Second Edition" http://www.firebird-books.net __
[firebird-support] Connection issues
Hi, I currently manage a small business that is running a Firebird database version 1.5.3. I know this is probably very old and it needs updating but the trouble is the business owners only have 1 user that uses it and it has been running without fail for years. The issue is lately the 1 client can no longer connect to the database using the client application. The application Ostendo and we have the Firebird database runs on an sbs2008 box. It is a domain controller. Exchange server. DHCP DNS File and printer sharing. Vipre Business Premium console dashboard Vipre client runs on the server and the firewall policy is disabled. Windows firewall is running but I have ports 3050 and 9050 open. It was working fine until a few days ago. The user says he was using Friday ok and came in Monday morning and when he launches the ostendo client gets the following error (see attached). We spoke to Ostendo support and they said to just reinstall the client but that made no difference. I am just understanding the error message not sure how to troubleshoot as I know nothing about Ostendo and Firebird databases. Please advise. Regards, Sean Wright New Computer Systems for Business & Home Managed Services Microsoft Small Business Server Client Server Networks Workgroup Networks Network Maintenance & Support Mobile 0448521413 t...@seanspcpower.com PO Box 415 Jesmond NSW 2299 LeftBiz P/L TA seanspcpower ABN 21217108398 [Non-text portions of this message have been removed]
[firebird-support] How to show all relations for "table.column" over foreign key
Hello All, How to build up SQL query over system tables to find out which tables are depending to exact table and column I am searching for. Thanks in advance. -- Best regards, TRoland http://www.rotursoft.sk http://exekutor.rotursoft.sk
Odp: [firebird-support] Re: losing connection with server on a local PC
Hi, Maybe first check db with gfix against corruption Regards, Karol Bieniaszewski - Reply message - Od: "hv...@users.sourceforge.net [firebird-support]" Do: Temat: [firebird-support] Re: losing connection with server on a local PC Data: śr., maj 27, 2015 12:51 ---In firebird-support@yahoogroups.com, wrote : > > BARO (Client) Tue May 12 12:20:20 2015> "C:\Program > Files\Firebird\Firebird_2_5\bin\fbserver.exe": terminated abnormally > (4294967295) It means that Firebird crashes, unfortunately. Could you provide me with full memory dump when (if) next crash happens ? Regards, Vlad
Odp: [firebird-support] Database restore speed with IBExpert and Gbak
Yes, full restore of normall database with indexes, keys ... and on the same computer os hardware is the same. All 64 bit with 256GB Ram Regards, Karol Bieniaszewski - Reply message - Od: "'Thomas Steinmaurer' t...@iblogmanager.com [firebird-support]" Do: Temat: Odp: [firebird-support] Database restore speed with IBExpert and Gbak Data: śr., maj 27, 2015 09:58 > ---In firebird-support@yahoogroups.com, wrote : > >> From a throughput perspective, this would mean: > > >> IB XE3 => 0,918 MB/s >> IB XE7 => 1,896 MB/s >> FB 3 => 3,282 MB/s > > >> To be honest, astonishing low numbers in 2015, for all three. > > To be even more honest, measure time of restore without building indices and > non-table metadata objects. Else your statement is about nothing, sorry Ehm, just did some math on Karol's results. ;-) And I guess his numbers present the entire restore time or did I miss something? > Regards, > Vlad > > PS I don't say Firebird is able to restore at full speed of HDD sequential > write, but your > conclusion is very far from truth. IMHO, of course. Well, I haven't said that a Firebird restore is that slow in GENERAL as shown with the numbers above. It is in Karol's environment. -- With regards, Thomas Steinmaurer http://www.upscene.com Professional Tools and Services for Firebird FB TraceManager, IB LogManager, Database Health Check, Tuning etc.
[firebird-support] Re: losing connection with server on a local PC
---In firebird-support@yahoogroups.com, wrote : > > BARO (Client) Tue May 12 12:20:20 2015 > "C:\Program > Files\Firebird\Firebird_2_5\bin\fbserver.exe": terminated abnormally > (4294967295) It means that Firebird crashes, unfortunately. Could you provide me with full memory dump when (if) next crash happens ? Regards, Vlad
Re: Odp: [firebird-support] Database restore speed with IBExpert and Gbak
> ---In firebird-support@yahoogroups.com, wrote : > >> From a throughput perspective, this would mean: > > >> IB XE3 => 0,918 MB/s >> IB XE7 => 1,896 MB/s >> FB 3 => 3,282 MB/s > > >> To be honest, astonishing low numbers in 2015, for all three. > > To be even more honest, measure time of restore without building indices and > non-table metadata objects. Else your statement is about nothing, sorry Ehm, just did some math on Karol's results. ;-) And I guess his numbers present the entire restore time or did I miss something? > Regards, > Vlad > > PS I don't say Firebird is able to restore at full speed of HDD sequential > write, but your > conclusion is very far from truth. IMHO, of course. Well, I haven't said that a Firebird restore is that slow in GENERAL as shown with the numbers above. It is in Karol's environment. -- With regards, Thomas Steinmaurer http://www.upscene.com Professional Tools and Services for Firebird FB TraceManager, IB LogManager, Database Health Check, Tuning etc.
Re: Odp: [firebird-support] Database restore speed with IBExpert and Gbak
---In firebird-support@yahoogroups.com, wrote : > From a throughput perspective, this would mean: > > IB XE3 => 0,918 MB/s > IB XE7 => 1,896 MB/s > FB 3 => 3,282 MB/s > > To be honest, astonishing low numbers in 2015, for all three. To be even more honest, measure time of restore without building indices and non-table metadata objects. Else your statement is about nothing, sorry Regards, Vlad PS I don't say Firebird is able to restore at full speed of HDD sequential write, but your conclusion is very far from truth. IMHO, of course.