Re: [firebird-support] Re: Proper way to configure Firebird startup on FreeBSD 10
http://www.firebirdsql.org/manual/qsg2-config.html#qsg2-config-security discusses some points you should consider. And where to place databases - now, there are some common locations such as /var, /usr/var or /opt - but there is no general authoritative answer possible, as it depends on how the system is configured and what are the needs of operating the db. https://www.freebsd.org/doc/handbook/security.html discusses general freebsd security and links to some more toppics. And as written before: firebird is the only user who needs access to the databases. stevef...@yahoo.com [firebird-support] wrote: If someone posts an authoritative answer here on the Firebird support group, then everyone who is running FreeBSD/Firebird who needs help can see the answer in future and be helped. That is the main reason I have posted the question here. By the way, I have searched the www high and low, but could not find an answer and hence this is the only place I could post. Maybe I should have posted on the FreeBSD forums.. [Non-text portions of this message have been removed]
Re: [firebird-support] Help!!! - Problem with Firebird Embeded
On 14-9-2014 03:05, Adam adam...@gmail.com [firebird-support] wrote: Hi Alan and thanks for your help. I checked the release notes and started again. This is my directory structure: D:\my_app\myapp.exe D:\my_app\myapp.FDB D:\my_app\fbclient.dll D:\my_app\firebird.conf D:\my_app\firebird.msg D:\my_app\IB_SQL.exe D:\my_app\ib_util.dll D:\my_app\icudt30.dll D:\my_app\icuin30.dll D:\my_app\icuuc30.dll D:\my_app\intl\fbintl.dll D:\my_app\intl\fbintl.conf D:\my_app\udf\fbudf.dll And still both myapp.exe and IB_SQL.exe give Database unavailable message (ISC ERROR CODE:335544375 in the cae of IB_SQL.exe) :( Ok, so you don't have the error with your own application (myapp.exe), but with IB_SQL.exe? Is your own application running at that time? What is IB_SQL.exe? Mark -- Mark Rotteveel
Re: [firebird-support] Help!!! - Problem with Firebird Embeded
On 14/09/14 09:25, Mark Rotteveel m...@lawinegevaar.nl [firebird-support] wrote: And still both myapp.exe and IB_SQL.exe give Database unavailable message (ISC ERROR CODE:335544375 in the cae of IB_SQL.exe) :( Ok, so you don't have the error with your own application (myapp.exe), but with IB_SQL.exe? Is your own application running at that time? What is IB_SQL.exe? IB_SQL is the IBObjects admin tool ... Adam - try Flamerobin http://www.flamerobin.org/ ... this is a little more helpful in it's error messages. But I do wonder if you have another fbclient.dll that is being found first. I only ever run server versions, but sometimes it plays up when an older client is found. -- 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
[firebird-support] Re: Help!!! - Problem with Firebird Embeded
D:\my_app\fbclient.dll What's this file? It should be fbembed.dll renamed to fbclient.dll. If it's not, then it's the regular client API and you're getting the error because there's no server. Yes this is fbembed.dll from the Firebird-2.5.2.26539-0_x64_embed.zip root folder renamed to fbclient.dll. Also I'd want to check that your application (either via path name or using an alias) is connecting to a database path and not an unqualified file name for the DB. The server is embedded but it's still a server, not a file jockey. The database path I am using in both my app and IB_SQL.exe is simply the atabase name myapp.FDB. When fb_inet_server.exe is running as a background process on the machine both my app and IB_SQL.exe connect to the server and the app runs as I would expect. Adam __
RE: [firebird-support] Re: Help!!! - Problem with Firebird Embeded
The database path I am using in both my app and IB_SQL.exe is simply the atabase name myapp.FDB. When fb_inet_server.exe is running as a background process on the machine both my app and IB_SQL.exe connect to the server and the app runs as I would expect. Adam __ Embedded needs to full path Alan
Re: [firebird-support] Help!!! - Problem with Firebird Embeded
Hi and thanks for jumping in Helen On Sun, Sep 14, 2014 at 1:44 PM, Helen Borrie hele...@iinet.net.au [firebird-support] firebird-support@yahoogroups.com wrote: At 01:05 p.m. 14/09/2014, Adam adam...@gmail.com [firebird-support] wrote: Hi Alan and thanks for your help. I checked the release notes and started again. This is my directory structure: D:\my_app\myapp.exe D:\my_app\myapp.FDB D:\my_app\fbclient.dll What's this file? It should be fbembed.dll renamed to fbclient.dll. If it's not, then it's the regular client API and you're getting the error because there's no server. Yes it's fbembed.dll (from the Firebird-2.5.3.26778-0_x64_embed.zip root folder) renamed to fbclient.dll. Also I'd want to check that your application (either via path name or using an alias) is connecting to a database path and not an unqualified file name for the DB. The server is embedded but it's still a server, not a file jockey. I have tried both fullpath (D:\my_app\myapp.FDB) and just filename (myapp.FDB) and in both cases cannot connect. Adam
Re: [firebird-support] Help!!! - Problem with Firebird Embeded
Hi Mark The error exists for BOTH my application and the IB_SQL.exe client app and I run these non-concurrently. IB_SQL is the Interbase Objects Firebird database desktop tool (see: http://www.ibobjects.com/) Ok, so you don't have the error with your own application (myapp.exe), but with IB_SQL.exe? Is your own application running at that time? What is IB_SQL.exe? Mark -- Mark Rotteveel
Re: [firebird-support] Help!!! - Problem with Firebird Embeded
Hi Lester On Sun, Sep 14, 2014 at 6:38 PM, Lester Caine les...@lsces.co.uk [firebird-support] firebird-support@yahoogroups.com wrote: On 14/09/14 09:25, Mark Rotteveel m...@lawinegevaar.nl [firebird-support] wrote: And still both myapp.exe and IB_SQL.exe give Database unavailable message (ISC ERROR CODE:335544375 in the cae of IB_SQL.exe) :( Ok, so you don't have the error with your own application (myapp.exe), but with IB_SQL.exe? Is your own application running at that time? What is IB_SQL.exe? IB_SQL is the IBObjects admin tool ... Yes that's right. Adam - try Flamerobin http://www.flamerobin.org/ ... this is a little more helpful in it's error messages. FlameRobin gave the following error message: IBPP::SQLException Context Database Connect Message =: isc_attach_database failed SQL Message: -902 can't format message 13:98 -- message file c:\WINOWS\firebird.msg not found Engine Code :335544721 Engine Message: Unable to complete network request to host localhost Failed to establish connection. So yes FlameRobin provides more information but still I cannot understand why But I do wonder if you have another fbclient.dll that is being found first. I only ever run server versions, but sometimes it plays up when an older client is found. Hmmm now this sounds interesting. I went searching for all other fbclient.dll files and yes found some older ones for a previous project and also in the C:|WINDOWS folder. I deleted these (the only one now left is D:\my_app\fbclient.dll, that is the one in myapp folder) and tried once again again. 1 - Running my app results in the following error message: [FireDAC][Phy][IB]-314. Cannot load vendor library [fbclient.dll]. Hint: check it is in the PATH or application EXE directories, nd has x86 bitness. 2 - Running IB_SQL connects :-) 3 - FlameRobin IBPP::SQLException Context Database Connect Message =: isc_attach_database failed SQL Message: -902 Unsuccessful execution caused by system error that precludes successful execution of subsequent statements Engine Code :335544721 Engine Message: Unable to complete network request to host localhost:3050 Failed to establish connection. No connection could be made because the target machine actively refused it. O interesting that IB_SQL connects but my app itself and FlameRobin don't. Nevertheless it seem that we are getting further at long last Lester :-) The question i what next? Adam
RE: [firebird-support] Help!!! - Problem with Firebird Embeded
I have tried both fullpath (D:\my_app\myapp.FDB) and just filename (myapp.FDB) and in both cases cannot connect. Adam And you are using cpLocal? Alan
RE: [firebird-support] Help!!! - Problem with Firebird Embeded
Engine Code :335544721 Engine Message: Unable to complete network request to host localhost Failed to establish connection. That means you are trying to use the TCP stack. Alan
Re: [firebird-support] Help!!! - Problem with Firebird Embeded
On Sun, Sep 14, 2014 at 9:53 PM, 'Alan McDonald' a...@meta.com.au [firebird-support] firebird-support@yahoogroups.com wrote: I have tried both fullpath (D:\my_app\myapp.FDB) and just filename (myapp.FDB) and in both cases cannot connect. Adam And you are using cpLocal? Alan If this means Protocol then yes I have set Protocol to Local.
Re: [firebird-support] Help!!! - Problem with Firebird Embeded
On 14/09/14 12:46, Adam adam...@gmail.com [firebird-support] wrote: Engine Code :335544721 Engine Message: Unable to complete network request to host localhost Failed to establish connection. So yes FlameRobin provides more information but still I cannot understand why This means that your machine does not have the network configured properly. Quite a common problem with windows these days. SO the next question is ... is this machine actually on a network? If so http://superuser.com/questions/713491/why-does-localhost-not-work-in-windows-8-1-but-127-0-0-1-does may help ... -- 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] Help!!! - Problem with Firebird Embeded
what is your connection string, don't use localhost:dbname format. Try use only the filename. Try ems sql manager for firebird, it has embeded protocol On 14 Sep 2014 19:01, Adam adam...@gmail.com [firebird-support] firebird-support@yahoogroups.com wrote: On Sun, Sep 14, 2014 at 9:55 PM, 'Alan McDonald' a...@meta.com.au [firebird-support] firebird-support@yahoogroups.com wrote: Engine Code :335544721 Engine Message: Unable to complete network request to host localhost Failed to establish connection. That means you are trying to use the TCP stack. Alan Sorry Alan but I'm not sure what this means.
Re: [firebird-support] Help!!! - Problem with Firebird Embeded
On 14-9-2014 14:11, Lester Caine les...@lsces.co.uk [firebird-support] wrote: On 14/09/14 12:46, Adam adam...@gmail.com [firebird-support] wrote: Engine Code :335544721 Engine Message: Unable to complete network request to host localhost Failed to establish connection. So yes FlameRobin provides more information but still I cannot understand why This means that your machine does not have the network configured properly. Quite a common problem with windows these days. A common problem? I don't actually think so. The question you link to below is also not very informative; and that is problem is probably more related to the fact that by default localhost resolves to ::1 (IPv6) instead of 127.0.0.1 (IPv4). SO the next question is ... is this machine actually on a network? If so http://superuser.com/questions/713491/why-does-localhost-not-work-in-windows-8-1-but-127-0-0-1-does may help ... The original question is about use of embedded. The fact that it is attempting to connect through localhost means that a hostname (localhost) is included in the connection string, which results in fbembed.dll acting as a normal fbclient, instead of using its internal server to access the database. The real question is if this happens because the application itself specifies the hostname, or because the connection component automatically adds localhost if no hostname is specified. Mark -- Mark Rotteveel
Re: [firebird-support] Help!!! - Problem with Firebird Embeded
On Sun, Sep 14, 2014 at 10:11 PM, Lester Caine les...@lsces.co.uk [firebird-support] firebird-support@yahoogroups.com wrote: On 14/09/14 12:46, Adam adam...@gmail.com [firebird-support] wrote: Engine Code :335544721 Engine Message: Unable to complete network request to host localhost Failed to establish connection. So yes FlameRobin provides more information but still I cannot understand why This means that your machine does not have the network configured properly. Quite a common problem with windows these days. SO the next question is ... is this machine actually on a network? If so http://superuser.com/questions/713491/why-does-localhost-not-work-in-windows-8-1-but-127-0-0-1-does may help ... This is a Standalone development machine.
Re: [firebird-support] Help!!! - Problem with Firebird Embeded
On Sun, Sep 14, 2014 at 10:15 PM, Iwan Cahyadi Sugeng
iwan.c.sug...@gmail.com [firebird-support] firebird-support@yahoogroups.com
wrote:
what is your connection string, don't use localhost:dbname format. Try use
only the filename. Try ems sql manager for firebird, it has embeded protocol
This is how I'm trying to connect:
fdbPath := ExtractFilePath(ParamStr(0))+'CrypticMania.FDB';
with ADConnection1.Params do begin
Clear;
Add('Database='+fdbPath);
Add('User_Name=SYSDBA');
Add('Password=masterkey');
Add('DriverID=IB');
end;
Re: [firebird-support] Help!!! - Problem with Firebird Embeded
On 14/09/14 13:20, Mark Rotteveel m...@lawinegevaar.nl [firebird-support] wrote: On 14-9-2014 14:11, Lester Caine les...@lsces.co.uk [firebird-support] wrote: On 14/09/14 12:46, Adam adam...@gmail.com [firebird-support] wrote: Engine Code :335544721 Engine Message: Unable to complete network request to host localhost Failed to establish connection. So yes FlameRobin provides more information but still I cannot understand why This means that your machine does not have the network configured properly. Quite a common problem with windows these days. A common problem? I don't actually think so. The question you link to below is also not very informative; and that is problem is probably more related to the fact that by default localhost resolves to ::1 (IPv6) instead of 127.0.0.1 (IPv4). That 'localhost' has been a recurring problem in the past is a simple fact. I've got notes on this list from many years back about trying the machines IP address rather than localhost when there are windows connection problems. SO the next question is ... is this machine actually on a network? If so http://superuser.com/questions/713491/why-does-localhost-not-work-in-windows-8-1-but-127-0-0-1-does may help ... The original question is about use of embedded. The fact that it is attempting to connect through localhost means that a hostname (localhost) is included in the connection string, which results in fbembed.dll acting as a normal fbclient, instead of using its internal server to access the database. The real question is if this happens because the application itself specifies the hostname, or because the connection component automatically adds localhost if no hostname is specified. Adam had switched to Flamerobin and it was this which gave the more useful error report. Flamerobin certainly defaults to using localhost so the alternative track IS the alternate ways of accessing 'embedded', and I thought Flamerobin tested them - but obviously I'm mistaken? I did think localhost would access a local embedded client? But it has been some considerable time since I actually used it. -- 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] Help!!! - Problem with Firebird Embeded
I think a status update may be helpful. After deleting all other than the one fbclient.dll in myapp folder 1 - Running my app results in the following error message: [FireDAC][Phy][IB]-314. Cannot load vendor library [fbclient.dll]. Hint: check it is in the PATH or application EXE directories, and has x86 bitness. I've checked and it is in both the PATH and app EXE directory. Not at all sure how to check that it has x86 bitness. 2 - IB_SQL gives this new error :( ISC ERROR CODE:335544379 ISC ERROR MESSAGE: unsupported on-disk structure for file D:\my_app\myapp.FDB; found 32779, support 15 3 - FlameRobin IBPP::SQLException Context Database Connect Message =: isc_attach_database failed SQL Message: -902 Unsuccessful execution caused by system error that precludes successful execution of subsequent statements Engine Code :335544721 Engine Message: Unable to complete network request to host localhost:3050 Failed to establish connection. No connection could be made because the target machine actively refused it.
Re: [firebird-support] Help!!! - Problem with Firebird Embeded
On 14/09/14 13:38, Adam adam...@gmail.com [firebird-support] wrote: 1 - Running my app results in the following error message: [FireDAC][Phy][IB]-314. Cannot load vendor library [fbclient.dll]. Hint: check it is in the PATH or application EXE directories, and has x86 bitness. I've checked and it is in both the PATH and app EXE directory. Not at all sure how to check that it has x86 bitness. OK the other windows problem creeping in ... You said originally 'Windows 8' which I would anticipate being 64 bit? If the test application was compiled as '64bit' then you will also need a 64bit version of Firebird. Otherwise you need the 32bit build ... which may account for your earlier results as the deleted versions may have been the right 'bittyness' and being picked up rather then the renamed embedded one in your folder :( -- 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] Help!!! - Problem with Firebird Embeded
On Sun, Sep 14, 2014 at 10:33 PM, Lester Caine les...@lsces.co.uk [firebird-support] firebird-support@yahoogroups.com wrote: On 14/09/14 13:20, Mark Rotteveel m...@lawinegevaar.nl [firebird-support] wrote: On 14-9-2014 14:11, Lester Caine les...@lsces.co.uk [firebird-support] wrote: On 14/09/14 12:46, Adam adam...@gmail.com [firebird-support] wrote: Engine Code :335544721 Engine Message: Unable to complete network request to host localhost Failed to establish connection. So yes FlameRobin provides more information but still I cannot understand why This means that your machine does not have the network configured properly. Quite a common problem with windows these days. A common problem? I don't actually think so. The question you link to below is also not very informative; and that is problem is probably more related to the fact that by default localhost resolves to ::1 (IPv6) instead of 127.0.0.1 (IPv4). That 'localhost' has been a recurring problem in the past is a simple fact. I've got notes on this list from many years back about trying the machines IP address rather than localhost when there are windows connection problems. SO the next question is ... is this machine actually on a network? If so http://superuser.com/questions/713491/why-does-localhost-not-work-in-windows-8-1-but-127-0-0-1-does may help ... The original question is about use of embedded. The fact that it is attempting to connect through localhost means that a hostname (localhost) is included in the connection string, which results in fbembed.dll acting as a normal fbclient, instead of using its internal server to access the database. The real question is if this happens because the application itself specifies the hostname, or because the connection component automatically adds localhost if no hostname is specified. Adam had switched to Flamerobin and it was this which gave the more useful error report. Flamerobin certainly defaults to using localhost so the alternative track IS the alternate ways of accessing 'embedded', and I thought Flamerobin tested them - but obviously I'm mistaken? I did think localhost would access a local embedded client? But it has been some considerable time since I actually used it. So am I right in my understanding here then that FlameRobin will not work with the FireBird embeded server and if this is correct then can I run the embeded server hile the full server is running as a background process?
Re: [firebird-support] Help!!! - Problem with Firebird Embeded
On Sun, Sep 14, 2014 at 10:56 PM, Lester Caine les...@lsces.co.uk [firebird-support] firebird-support@yahoogroups.com wrote: On 14/09/14 13:38, Adam adam...@gmail.com [firebird-support] wrote: 1 - Running my app results in the following error message: [FireDAC][Phy][IB]-314. Cannot load vendor library [fbclient.dll]. Hint: check it is in the PATH or application EXE directories, and has x86 bitness. I've checked and it is in both the PATH and app EXE directory. Not at all sure how to check that it has x86 bitness. OK the other windows problem creeping in ... You said originally 'Windows 8' which I would anticipate being 64 bit? If the test application was compiled as '64bit' then you will also need a 64bit version of Firebird. Otherwise you need the 32bit build ... which may account for your earlier results as the deleted versions may have been the right 'bittyness' and being picked up rather then the renamed embedded one in your folder :( Right on the money Lester ell done. As I just tried the win32 embeded and it works as expected. Although now I need to getFlame Robin working and I just posted in my previous reply a question on this.
Re: [firebird-support] Help!!! - Problem with Firebird Embeded
On Sun, Sep 14, 2014 at 11:00 PM, Adam adam...@gmail.com wrote: On Sun, Sep 14, 2014 at 10:56 PM, Lester Caine les...@lsces.co.uk [firebird-support] firebird-support@yahoogroups.com wrote: On 14/09/14 13:38, Adam adam...@gmail.com [firebird-support] wrote: 1 - Running my app results in the following error message: [FireDAC][Phy][IB]-314. Cannot load vendor library [fbclient.dll]. Hint: check it is in the PATH or application EXE directories, and has x86 bitness. I've checked and it is in both the PATH and app EXE directory. Not at all sure how to check that it has x86 bitness. OK the other windows problem creeping in ... You said originally 'Windows 8' which I would anticipate being 64 bit? If the test application was compiled as '64bit' then you will also need a 64bit version of Firebird. Otherwise you need the 32bit build ... which may account for your earlier results as the deleted versions may have been the right 'bittyness' and being picked up rather then the renamed embedded one in your folder :( Right on the money Lester ell done. As I just tried the win32 embeded and it works as expected. Although now I need to getFlame Robin working and I just posted in my previous reply a question on this. Yes but of course not concurrently!!
Re: [firebird-support] Help!!! - Problem with Firebird Embeded
On 14/09/14 14:00, Adam adam...@gmail.com [firebird-support] wrote: Otherwise you need the 32bit build ... which may account for your earlier results as the deleted versions may have been the right 'bittyness' and being picked up rather then the renamed embedded one in your folder :( Right on the money Lester ell done. As I just tried the win32 embeded and it works as expected. Although now I need to getFlame Robin working and I just posted in my previous reply a question on this. I'm not sure on that one so I'll leave it to someone else to answer. I only run with a server setup, and Firebird is normally on a Linux box these days, but there is no reason that an embedded client could not run with a database as long as the server is not also accessing the same database file. It's the access that is restricted to a single user in the embedded case. -- 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] Help!!! - Problem with Firebird Embeded
I saw a hint to the bitness of the client library - is you application 64-bit or 32-bit? The client library (embedded or not) should match the application.
Re: [firebird-support] Help!!! - Problem with Firebird Embeded
On Sun, Sep 14, 2014 at 11:26 PM, Lester Caine les...@lsces.co.uk [firebird-support] firebird-support@yahoogroups.com wrote: On 14/09/14 14:00, Adam adam...@gmail.com [firebird-support] wrote: Otherwise you need the 32bit build ... which may account for your earlier results as the deleted versions may have been the right 'bittyness' and being picked up rather then the renamed embedded one in your folder :( Right on the money Lester ell done. As I just tried the win32 embeded and it works as expected. Although now I need to getFlame Robin working and I just posted in my previous reply a question on this. I'm not sure on that one so I'll leave it to someone else to answer. I only run with a server setup, and Firebird is normally on a Linux box these days, but there is no reason that an embedded client could not run with a database as long as the server is not also accessing the same database file. It's the access that is restricted to a single user in the embedded case. Just tested it and all works fine. FlameRobin uses the FireBird running in background process and yes as long as the database is not being concurrently accessed all works fine. Thank you o much for giving your time to my problem, much appreciated. Yours antipodaly Adam
Re: [firebird-support] Help!!! - Problem with Firebird Embeded
On Sun, Sep 14, 2014 at 11:32 PM, em...@tot-consult.com [firebird-support] firebird-support@yahoogroups.com wrote: I saw a hint to the bitness of the client library - is you application 64-bit or 32-bit? The client library (embedded or not) should match the application. Yes the non matching of the server and my app was part of my problem Thanks to all that contributed to solving this nagging issue, mainly due to my clumsynes in the install of the latest version :( Cheers until we meet again Adam
Re: [firebird-support] Help!!! - Problem with Firebird Embeded
On 14/09/14 14:34, Adam adam...@gmail.com [firebird-support] wrote: Just tested it and all works fine. FlameRobin uses the FireBird running in background process and yes as long as the database is not being concurrently accessed all works fine. Thank you o much for giving your time to my problem, much appreciated. We do need to do some more up to date beginners guides for the windows stuff. My last one was done for 32 bit XP :) -- 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] Help!!! - Problem with Firebird Embeded
On Mon, Sep 15, 2014 at 12:12 AM, Lester Caine les...@lsces.co.uk [firebird-support] firebird-support@yahoogroups.com wrote: On 14/09/14 14:34, Adam adam...@gmail.com [firebird-support] wrote: Just tested it and all works fine. FlameRobin uses the FireBird running in background process and yes as long as the database is not being concurrently accessed all works fine. Thank you o much for giving your time to my problem, much appreciated. We do need to do some more up to date beginners guides for the windows stuff. My last one was done for 32 bit XP :) Yes a guide for beginner and/or novices would be very useful. Adam
RE: [firebird-support] Re: Help!!! - Problem with Firebird Embeded
What's this file? It should be fbembed.dll renamed to fbclient.dll. If it's not, then it's the regular client API and you're getting the error because there's no server. Yes this is fbembed.dll from the Firebird-2.5.2.26539-0_x64_embed.zip root folder renamed to fbclient.dll. Before we go on... Is your application 64bit? Is IB_SQL.exe 64bit? If not, you need to use the 32bit deployment, regardless of the bitness of the OS you are deploying to. 32bit DLLs only work with 32 bit applications, and vice-versa. Sean
[firebird-support] Re: Proper way to configure Firebird startup on FreeBSD 10
Thank you, Marcus. Your answer was very helpful. -- Steve Faleiro
Re: [firebird-support] Firebird Embedded corruptions
On Sat, Sep 13, 2014 at 12:22 PM, Jan Flyborg jan.pers...@gmail.com [firebird-support] firebird-support@yahoogroups.com wrote: We have shipped Firebird Embedded bundled together with our product for a few years now and the system is currently in production at several thousand of our customer's sites... All is well and Firebird has served us good so far with the exception of database corruptions that gets reported from a new set of customers every week. We are now at the planning stage for the next major release of our product and we are thus rethinking if Firebird really is a good choice, because of this. I can understand that. Lots of effort has gone into solving this problem on our side, so I think the normal prerequisites has already been put into place (e.g using forced writes and so forth), but our system needs to be up and running 24x7, which means that it is not possible to schedule periodic backup/restore cycles and my personal theory is that Firebird embedded gets corrupted over time if you are not doing this regularly. Nice theory, but if the database is physically corrupt, you can't back it up, and if it's logically corrupt, you can't restore it. I think it's worth looking elsewhere for the problem. So I have have a few questions that I would appreciate if someone could answer: 1. Is it feasible to run Firebird Embedded 24x7 in a setup where there are no scheduled backup/restore cycles. If not, how often should this be performed to ensure that the database does not get corrupted. It should be possible to run Firebird Embedded 24x7. Without knowing what you're seeing as corruptions, it's very hard to guess why they're occurring. What errors are your customers seeing? What do they (and you) do to correct the errors? 2. Most of our customers are not using a UPS. From my experiments I have not managed to create a corrupted database by turning of the power while doing a large set of writes (in a session running in VirtualBox). Could someone please confirm that this is indeed safe when you are running with synchronized writes turned on? A hard shutdown should not corrupt a database that has forced writes enabled. It might corrupt the file system, but again, without knowing what the errors and problem are, it's hard to guess. 3. Are there any operations on a live database that should be avoided to minimize the risk of corruptions? Dropping tables and altering tables to drop fields are pretty dangerous operations, but even if that is what's happening, the development group should be given a reproducible case that corrupts databases. 4. Just read a discussion about whether it is needed or not to call fb_shutdown to stop Firebird Embedded. Could this be the reason why we are getting corruptions? Should we change our service to perform this call when it is stopped? 5. I have also seen discussions of turning of automatic sweeps of the database (and doing them manually instead). Is this a likely source of corruptions for our setup? No. Sweeping the database is very much like backing it up without creating the backup file. When a sweep starts during heavy database usage, it can reduce performance but not corrupt the database. So, question back to you: what errors are you seeing and how have you fixed them? Good luck, Ann
Re: [firebird-support] Re: Help!!! - Problem with Firebird Embeded
On Mon, Sep 15, 2014 at 2:40 AM, 'Leyne, Sean' s...@broadviewsoftware.com [firebird-support] firebird-support@yahoogroups.com wrote: What's this file? It should be fbembed.dll renamed to fbclient.dll. If it's not, then it's the regular client API and you're getting the error because there's no server. Yes this is fbembed.dll from the Firebird-2.5.2.26539-0_x64_embed.zip root folder renamed to fbclient.dll. Before we go on... Is your application 64bit? Is IB_SQL.exe 64bit? If not, you need to use the 32bit deployment, regardless of the bitness of the OS you are deploying to. 32bit DLLs only work with 32 bit applications, and vice-versa. Sean Hi Sean, yes as per previous posts on this, that was part of the problem.
