Re: [Firebird-devel] fb3 access modes under windows
29.01.2014 21:30, Leyne, Sean wrote: OK, but some of the config options are not compatible for all installed modes -- so, how do we prevent a user make the wrong selections? If someone like Paul Reeves (who has been using FB since before it was FB) doesn't understand all of the intricacies, how will a less experienced user/developer? Especially, when the installed mode it not easily seen. Just a wild idea. We introduce a separate (very thin) fblistener.exe (fbremote or whatever) binary that acts similar to xinetd on posix. It will spawn firebird.exe per every user connection. firebird.exe will detect this situation and explicitly pass SharedCache = false and SharedDatabase = true via API into all connect calls, thus overriding any underlying config settings. firebird.exe alone will be always working in the multi-threaded mode (thus not requiring the -m switch) supporting either SC or SS, depending on the config settings. So, for CS one will need to install/run fblistener.exe and don't care about anything else. For SS/SC one will need to install/run firebird.exe and setup the config properly (SS by default). The installer will just ask about SharedDatabase/SharedCache (or about CS/SC/SS - although these terms become outdated with v3) and figure out what binary should be installed and whether it's needed to change the config. No eight possible options anymore. Not much harder to understand than for v2.5. Almost same for POSIX and Windows. If SC is going to be deprecated (at least at the installer level), then setup becomes even easier. Dmitry -- WatchGuard Dimension instantly turns raw network data into actionable security intelligence. It gives you real-time visual feedback on key security issues and trends. Skip the complicated setup - simply import a virtual appliance and go from zero to informed in seconds. http://pubads.g.doubleclick.net/gampad/clk?id=123612991iu=/4140/ostg.clktrk Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] fb3 access modes under windows
On Thursday 30 January 2014 09:56:50 Dmitry Yemanov wrote: We introduce a separate (very thin) fblistener.exe (fbremote or whatever) binary that acts similar to xinetd on posix. Or maybe we have finally found a reason to keep the guardian ? (At least on windows.) Paul -- Paul Reeves http://www.ibphoenix.com Supporting users of Firebird -- WatchGuard Dimension instantly turns raw network data into actionable security intelligence. It gives you real-time visual feedback on key security issues and trends. Skip the complicated setup - simply import a virtual appliance and go from zero to informed in seconds. http://pubads.g.doubleclick.net/gampad/clk?id=123612991iu=/4140/ostg.clktrk Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] fb3 access modes under windows
On 01/30/14 12:56, Dmitry Yemanov wrote: 29.01.2014 21:30, Leyne, Sean wrote: OK, but some of the config options are not compatible for all installed modes -- so, how do we prevent a user make the wrong selections? If someone like Paul Reeves (who has been using FB since before it was FB) doesn't understand all of the intricacies, how will a less experienced user/developer? Especially, when the installed mode it not easily seen. Just a wild idea. We introduce a separate (very thin) fblistener.exe (fbremote or whatever) binary that acts similar to xinetd on posix. It will spawn firebird.exe per every user connection. firebird.exe will detect this situation and explicitly pass SharedCache = false and SharedDatabase = true via API into all connect calls, thus overriding any underlying config settings. Agreed. I think passing that config settings will be good for posix too. It's good to be able to switch classic/super without need to touch firebird.conf. -- WatchGuard Dimension instantly turns raw network data into actionable security intelligence. It gives you real-time visual feedback on key security issues and trends. Skip the complicated setup - simply import a virtual appliance and go from zero to informed in seconds. http://pubads.g.doubleclick.net/gampad/clk?id=123612991iu=/4140/ostg.clktrk Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] fb3 access modes under windows
Just a wild idea. We introduce a separate (very thin) fblistener.exe (fbremote or whatever) binary that acts similar to xinetd on posix. It will spawn firebird.exe per every user connection. firebird.exe will detect this situation and explicitly pass SharedCache = false and SharedDatabase = true via API into all connect calls, thus overriding any underlying config settings. Agreed. I think passing that config settings will be good for posix too. It's good to be able to switch classic/super without need to touch firebird.conf. Generally speaking, i don't like to introduce new listener. Instead, i would think - if it is possible to make single common listener (firebird.exe\.so) to read (per-database) configuration and derive process\threaded mode from there. Technically it is possible to make single instance of firebird.exe to handle some attachment requests by forking new CS process and another attachment requests handling by itself (SS\SC). The question - if it is possible to let him know desired mode for given database... And, yes, it is also yet another wild idea (not a strong opposition\suggestion) ;) Regards, Vlad -- WatchGuard Dimension instantly turns raw network data into actionable security intelligence. It gives you real-time visual feedback on key security issues and trends. Skip the complicated setup - simply import a virtual appliance and go from zero to informed in seconds. http://pubads.g.doubleclick.net/gampad/clk?id=123612991iu=/4140/ostg.clktrk Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] fb3 access modes under windows
On Thursday 30 January 2014 10:43:49 Vlad Khorsun wrote: Generally speaking, i don't like to introduce new listener. Instead, i would think - if it is possible to make single common listener (firebird.exe\.so) to read (per-database) configuration and derive process\threaded mode from there. Yes, that would be my preference. No -m switch and remove SharedN options from fb.conf. Users would be able to set default SS or CS at server level and override at database level with SS, CS or exclusive single-user attachment. Paul -- Paul Reeves http://www.ibphoenix.com Supporting users of Firebird -- WatchGuard Dimension instantly turns raw network data into actionable security intelligence. It gives you real-time visual feedback on key security issues and trends. Skip the complicated setup - simply import a virtual appliance and go from zero to informed in seconds. http://pubads.g.doubleclick.net/gampad/clk?id=123612991iu=/4140/ostg.clktrk Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] fb3 access modes under windows
Technically it is possible to make single instance of firebird.exe to handle some attachment requests by forking new CS process and another attachment requests handling by itself (SS\SC). The question - if it is possible to let him know desired mode for given database... This would be in line with what I was trying to get at/propose. Sean -- WatchGuard Dimension instantly turns raw network data into actionable security intelligence. It gives you real-time visual feedback on key security issues and trends. Skip the complicated setup - simply import a virtual appliance and go from zero to informed in seconds. http://pubads.g.doubleclick.net/gampad/clk?id=123612991iu=/4140/ostg.clktrk Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] fb3 access modes under windows
30.01.2014 13:43, Vlad Khorsun wrote: Technically it is possible to make single instance of firebird.exe to handle some attachment requests by forking new CS process and another attachment requests handling by itself (SS\SC). Do you mean forking the worker after op_connect / op_attach are processed in the multi-server mode? Dmitry -- WatchGuard Dimension instantly turns raw network data into actionable security intelligence. It gives you real-time visual feedback on key security issues and trends. Skip the complicated setup - simply import a virtual appliance and go from zero to informed in seconds. http://pubads.g.doubleclick.net/gampad/clk?id=123612991iu=/4140/ostg.clktrk Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
[Firebird-devel] fb3 access modes under windows
I was playing with the different access configurations for FB 3 in firebird.conf. (with Alpha2) With this configuration: SharedCache = true SharedDatabase = true and server installed as SS. (ie, instsvc i ) Access via localhost is denied: C:\Program Files\Firebird\Firebird_3_0isql -user SYSDBA -password masterkey localhost:employee Statement failed, SQLSTATE = 28000 Your user name and password are not defined. Ask your database administrator to set up a Firebird login. Direct access produces this error: C:\Program Files\Firebird\Firebird_3_0isql -user SYSDBA -password masterkey employee Statement failed, SQLSTATE = 0A000 feature is not supported -SharedDatabase and SharedCache settings cannot be both enabled at once I got the same results after changing instsvc to use i -c (ie run as CS) There seems to be two separate issues here: - The error thrown when accessing host:db seems erroneous. un/pw are defined and correct. - direct access throws 'feature not supported' despite the fact that the combination is clearly documented as legal in firebird.conf. The reason I was trying this was to try and answer Pavel's question - how do you run SuperClassic under FB3 on Windows? AFAICT it is not possible. I don't mind - SuperClassic seems to share the worst features of SuperServer and ClassicServer, and we should officially deprecate in FB3 (imo.) But the questions will be asked - how can we run SC under FB3? and does it make any sense? Paul -- Paul Reeves http://www.ibphoenix.com Supporting users of Firebird -- WatchGuard Dimension instantly turns raw network data into actionable security intelligence. It gives you real-time visual feedback on key security issues and trends. Skip the complicated setup - simply import a virtual appliance and go from zero to informed in seconds. http://pubads.g.doubleclick.net/gampad/clk?id=123612991iu=/4140/ostg.clktrk Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] fb3 access modes under windows
The reason I was trying this was to try and answer Pavel's question - how do you run SuperClassic under FB3 on Windows? AFAICT it is not possible. Really ? :) I don't mind - SuperClassic seems to share the worst features of SuperServer and ClassicServer, and we should officially deprecate in FB3 (imo.) Probably. But the questions will be asked - how can we run SC under FB3? Isn't it was explained when shared page cache was committed ? Also, it was clearly stated that possible run modes could be changed before release, IIRC. Well, to run SuperClassic you should: a) set in firebird.conf SharedDatabase = true SharedCache = false and b) run listener in threaded mode firebird -m [-a] and does it make any sense? It depends on what is a sense :) As in v2.5 SC : - consumes less resources than CS - is able to utilize all CPUs\cores - allows another processes to access database - have same stability behaviour as SS Regards, Vlad -- WatchGuard Dimension instantly turns raw network data into actionable security intelligence. It gives you real-time visual feedback on key security issues and trends. Skip the complicated setup - simply import a virtual appliance and go from zero to informed in seconds. http://pubads.g.doubleclick.net/gampad/clk?id=123612991iu=/4140/ostg.clktrk Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] fb3 access modes under windows
On Wednesday 29 January 2014 15:03:02 Vlad Khorsun wrote: But the questions will be asked - how can we run SC under FB3? Isn't it was explained when shared page cache was committed ? Possibly - but I don't think it has been fully documented since then. I'm just an ordinary clueless user who blunders about, reading as little documentation as possible, trying whatever combination that works. :-) Well, to run SuperClassic you should: a) set in firebird.conf SharedDatabase = true SharedCache = false and b) run listener in threaded mode firebird -m [-a] and does it make any sense? Yes, that works. One of the problems here is that the -m switch needs to be documented better (there are other problems with the -m switch, but documentation is the biggest.) Basically this: instsvc i installs firebird to run with the -m switch and this: instsvc i -c installs it to run without the -m switch. Subsequent behaviour then depends on the configuration of firebird.conf, but there is no mention in firebird.conf as to how the two SharedN switches interact with -m So this line # SharedCache SharedDatabase Mode # falsetrueClassic with shared access // traditional CS/SC is entirely dependant upon the -m switch, or lack of it to launch either CS or SC. I guess what we really need is to document in firebird.conf how the -m switch affects the other two settings. There would seem to be a total of eight combinations. Perhaps we need something like this: # SharedCache SharedDatabase -m Mode # false false - CS single attach only # false false * # false true- Classic with shared access # false true* SuperClassic with shared access # truefalse - ? # truefalse * Super with exclusive access # truetrue- Super with shared access - illegal in A2 :-) # truetrue* Super with shared access - also illegal Paul -- Paul Reeves http://www.ibphoenix.com Supporting users of Firebird -- WatchGuard Dimension instantly turns raw network data into actionable security intelligence. It gives you real-time visual feedback on key security issues and trends. Skip the complicated setup - simply import a virtual appliance and go from zero to informed in seconds. http://pubads.g.doubleclick.net/gampad/clk?id=123612991iu=/4140/ostg.clktrk Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] fb3 access modes under windows
29.01.2014 18:37, Paul Reeves wrote: I guess what we really need is to document in firebird.conf how the -m switch affects the other two settings. There would seem to be a total of eight combinations. Lack of -m switch along with SharedDatabase = false means that only the first connection will be able to open the database. # SharedCache SharedDatabase -m Mode # false false - CS single attach only # false false * SC single attach only # false true- Classic with shared access # false true* SuperClassic with shared access # truefalse - ? SS single attach only # truefalse * Super with exclusive access # truetrue- Super with shared access - illegal in A2 :-) # truetrue* Super with shared access - also illegal Dmitry -- WatchGuard Dimension instantly turns raw network data into actionable security intelligence. It gives you real-time visual feedback on key security issues and trends. Skip the complicated setup - simply import a virtual appliance and go from zero to informed in seconds. http://pubads.g.doubleclick.net/gampad/clk?id=123612991iu=/4140/ostg.clktrk Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] fb3 access modes under windows
On Wednesday 29 January 2014 17:20:16 Dmitry Yemanov wrote: 29.01.2014 18:37, Paul Reeves wrote: I guess what we really need is to document in firebird.conf how the -m switch affects the other two settings. There would seem to be a total of eight combinations. Lack of -m switch along with SharedDatabase = false means that only the first connection will be able to open the database. OK, that makes sense. # SharedCache SharedDatabase -m Mode # false false * SC single attach only Interesting. Does that differ internally from # truefalse - ? SS single attach only I'm mainly concerned here that we document the combinations correctly and explain what the advantages and disadvantages are of each one. Paul -- Paul Reeves http://www.ibphoenix.com Supporting users of Firebird -- WatchGuard Dimension instantly turns raw network data into actionable security intelligence. It gives you real-time visual feedback on key security issues and trends. Skip the complicated setup - simply import a virtual appliance and go from zero to informed in seconds. http://pubads.g.doubleclick.net/gampad/clk?id=123612991iu=/4140/ostg.clktrk Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] fb3 access modes under windows
29.01.2014 20:51, Paul Reeves wrote: # SharedCache SharedDatabase -m Mode # false false * SC single attach only Interesting. Does that differ internally from # truefalse - ? SS single attach only Mostly it doesn't, except the fact that some config options may have different defaults in these cases. Dmitry -- WatchGuard Dimension instantly turns raw network data into actionable security intelligence. It gives you real-time visual feedback on key security issues and trends. Skip the complicated setup - simply import a virtual appliance and go from zero to informed in seconds. http://pubads.g.doubleclick.net/gampad/clk?id=123612991iu=/4140/ostg.clktrk Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] fb3 access modes under windows
29.01.2014 18:02, Dmitry Yemanov wrote: 29.01.2014 20:51, Paul Reeves wrote: # SharedCache SharedDatabase -m Mode # false false * SC single attach only Interesting. Does that differ internally from # truefalse - ? SS single attach only Mostly it doesn't, except the fact that some config options may have different defaults in these cases. How about difference latch only vs latch+lock? Does it still exist in v3? -- WBR, SD. -- WatchGuard Dimension instantly turns raw network data into actionable security intelligence. It gives you real-time visual feedback on key security issues and trends. Skip the complicated setup - simply import a virtual appliance and go from zero to informed in seconds. http://pubads.g.doubleclick.net/gampad/clk?id=123612991iu=/4140/ostg.clktrk Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] fb3 access modes under windows
29.01.2014 21:07, Dimitry Sibiryakov wrote: How about difference latch only vs latch+lock? Does it still exist in v3? Page locks are not used until the second connection appears. And other lock types don't affect single-threaded performance. Dmitry -- WatchGuard Dimension instantly turns raw network data into actionable security intelligence. It gives you real-time visual feedback on key security issues and trends. Skip the complicated setup - simply import a virtual appliance and go from zero to informed in seconds. http://pubads.g.doubleclick.net/gampad/clk?id=123612991iu=/4140/ostg.clktrk Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] fb3 access modes under windows
My last post got munged: It should have read: The reality is that there are only 2 set of options:: EngineMode/EngineType = Classic | SuperServer | SuperClassic DatabaseAccess = Shared | Single The install options should take their cue from the config settings, and not require inline switches. -- WatchGuard Dimension instantly turns raw network data into actionable security intelligence. It gives you real-time visual feedback on key security issues and trends. Skip the complicated setup - simply import a virtual appliance and go from zero to informed in seconds. http://pubads.g.doubleclick.net/gampad/clk?id=123612991iu=/4140/ostg.clktrk Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] fb3 access modes under windows
29.01.2014 21:10, Leyne, Sean wrote: EngineMode/EngineType = Classic | SuperServer | SuperClassic DatabaseAccess = Shared | Single The install options should take their cue from the config settings, and not require inline switches. Config options are database wise, so using them at the installer side (read: globally) is not a good idea. Dmitry -- WatchGuard Dimension instantly turns raw network data into actionable security intelligence. It gives you real-time visual feedback on key security issues and trends. Skip the complicated setup - simply import a virtual appliance and go from zero to informed in seconds. http://pubads.g.doubleclick.net/gampad/clk?id=123612991iu=/4140/ostg.clktrk Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] fb3 access modes under windows
On Wednesday 29 January 2014 17:20:16 Dmitry Yemanov wrote: 29.01.2014 18:37, Paul Reeves wrote: I guess what we really need is to document in firebird.conf how the -m switch affects the other two settings. There would seem to be a total of eight combinations. Lack of -m switch along with SharedDatabase = false means that only the first connection will be able to open the database. OK, that makes sense. # SharedCache SharedDatabase -m Mode # false false * SC single attach only Interesting. Does that differ internally from # truefalse - ? SS single attach only I'm mainly concerned here that we document the combinations correctly and explain what the advantages and disadvantages are of each one. I think that we need to re-define the way that the database and cache setting are defined -- the current method will only lead to confusion. Based on the discussion below, there are far too many combinations available through the various settings and install switches. The reality is that there are only 2 set of options:: EngineMode/EngineType = Classic | SuperServer | SuperClassic DatabaseAccess = Shared | Single The install options should take their cue from the config settings, and not require inline switches. Sean -- WatchGuard Dimension instantly turns raw network data into actionable security intelligence. It gives you real-time visual feedback on key security issues and trends. Skip the complicated setup - simply import a virtual appliance and go from zero to informed in seconds. http://pubads.g.doubleclick.net/gampad/clk?id=123612991iu=/4140/ostg.clktrk Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] fb3 access modes under windows
29.01.2014 21:10, Leyne, Sean wrote: EngineMode/EngineType = Classic | SuperServer | SuperClassic DatabaseAccess = Shared | Single The install options should take their cue from the config settings, and not require inline switches. Config options are database wise, so using them at the installer side (read: globally) is not a good idea. OK, but some of the config options are not compatible for all installed modes -- so, how do we prevent a user make the wrong selections? If someone like Paul Reeves (who has been using FB since before it was FB) doesn't understand all of the intricacies, how will a less experienced user/developer? Especially, when the installed mode it not easily seen. Sean -- WatchGuard Dimension instantly turns raw network data into actionable security intelligence. It gives you real-time visual feedback on key security issues and trends. Skip the complicated setup - simply import a virtual appliance and go from zero to informed in seconds. http://pubads.g.doubleclick.net/gampad/clk?id=123612991iu=/4140/ostg.clktrk Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] fb3 access modes under windows
29.01.2014 18:30, Leyne, Sean wrote: how will a less experienced user/developer? They will never change the settings from default which is optimal for most configurations. -- WBR, SD. -- WatchGuard Dimension instantly turns raw network data into actionable security intelligence. It gives you real-time visual feedback on key security issues and trends. Skip the complicated setup - simply import a virtual appliance and go from zero to informed in seconds. http://pubads.g.doubleclick.net/gampad/clk?id=123612991iu=/4140/ostg.clktrk Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] fb3 access modes under windows
On 01/29/14 21:35, Dimitry Sibiryakov wrote: 29.01.2014 18:30, Leyne, Sean wrote: how will a less experienced user/developer? They will never change the settings from default which is optimal for most configurations. In posix we have shell script making it possible to easily switch classic - super. May be a kind of same service will be useful on windows? (like CP applet) -- WatchGuard Dimension instantly turns raw network data into actionable security intelligence. It gives you real-time visual feedback on key security issues and trends. Skip the complicated setup - simply import a virtual appliance and go from zero to informed in seconds. http://pubads.g.doubleclick.net/gampad/clk?id=123612991iu=/4140/ostg.clktrk Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel