Re: [Firebird-devel] Running firebird.exe as application
On 6-5-2014 20:39, Dmitry Yemanov wrote: >> I have been unable to find anything regarding the commandline options of >> firebird.exe and I only thought of -m as it is also added to the >> commandline of the service executable. >> >> So: what is the meaning of -m, and why is it necessary? > > The same as for SuperClassic in v2.5: -m stands for multithreaded and > allows to separate Classic (process-based) from non-Classic > (thread-based). Config options don't work here because the > process/thread mode is driven by the remote server, not the engine. > > It has been discussed here a few times already, IIRC. I have a vague recollection as well, but a search through my firebird-devel mail folder didn't yield anything relevant. It probably doesn't like '-' in search queries. Running it with -a only (when SharedDatabase = false) leads to vague errors on authentication. I have seen "Your user name and password are not defined. Ask your database administrator to set up a Firebird login." (which led me to fights with gsec), but also "Invalid resultset interface" (although that might have been another problem). It was only when I looked at the firebird.log and saw an "unable to open database [...] The process cannot access the file because it is being used by another process." for security3.fdb that I had a clue on what the problem might be. I wonder if an explicit error (eg "Security database not available") in this case might be better. I also wonder if security3.fdb shouldn't be SharedDatabase=true by default (or always), this would also allow gsec to work without an explicit -database option when the server is running. Mark -- Mark Rotteveel -- Is your legacy SCM system holding you back? Join Perforce May 7 to find out: • 3 signs your SCM is hindering your productivity • Requirements for releasing software faster • Expert tips and advice for migrating your SCM now http://p.sf.net/sfu/perforce Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] Running firebird.exe as application
06.05.2014 22:32, Mark Rotteveel wrote: > I have been having some problems running Firebird 3 correctly from a > zip-kit (as Super Server). After much trial-and-error it looks like when > running as an application, that I need to start Firebird.exe with -a -m > (instead of only -a as documented in \docs\install_windows_manually.txt). Nobody updated those old docs yet. > I have been unable to find anything regarding the commandline options of > firebird.exe and I only thought of -m as it is also added to the > commandline of the service executable. > > So: what is the meaning of -m, and why is it necessary? The same as for SuperClassic in v2.5: -m stands for multithreaded and allows to separate Classic (process-based) from non-Classic (thread-based). Config options don't work here because the process/thread mode is driven by the remote server, not the engine. It has been discussed here a few times already, IIRC. Dmitry -- Is your legacy SCM system holding you back? Join Perforce May 7 to find out: • 3 signs your SCM is hindering your productivity • Requirements for releasing software faster • Expert tips and advice for migrating your SCM now http://p.sf.net/sfu/perforce Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] Running firebird.exe as application
06.05.2014 20:32, Mark Rotteveel wrote: > So: what is the meaning of -m, and why is it necessary? It stand for "multi-threaded". Without it firebird.exe works in classic mode and spawn separate processes for each connection. -- WBR, SD. -- Is your legacy SCM system holding you back? Join Perforce May 7 to find out: • 3 signs your SCM is hindering your productivity • Requirements for releasing software faster • Expert tips and advice for migrating your SCM now http://p.sf.net/sfu/perforce Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel