On Mon, 6 Oct 2014 12:03:07 +0200, "Martijn Tonies (Upscene Productions)" <[email protected]> wrote: >>I had a similar problem yesterday. AFAIK you first need to start gsec with >>user and password explicitly: >> >>gsec -user sysdba -password masterkey >> >>Which will initialize and add the sysdba account. > > Ah, got it now -- you first need to do the above, and THEN add a new > account > for ... SYSDBA? > > But I just used that account?
First time use will setup the sysdba account, there is no need to add it explicitly (although you may need to repeat the process for the non-SRP sysdba account). > >>BTW: I mentioned a few months, but it is really annoying that using gsec >>is a hassle if your server is configured as SuperServer as gsec won't be >>able to open the file as it is already opened by the server process. I had >>to *stop* the server to get GSEC to work, which is really annoying. I know >>about the -database switch, but if you haven't yet created an account, >>then >>creating a database to connect through is not an option. The security3.fdb >>should be *shared* always (or at least by default). > > It also fails when there's -> another <- Firebird server instance running, > you > need to shut down all instances. > > I got a severe error when starting gsec, then entering "add" at the prompt > followed by <enter>, this crashed gsec. > > Also, for the love of whatever, if I'm using the incorrect commands or some > other issue occurs, why isn't there a decent error message instead of > > " CREATE TABLE PLG$SRP failed > There is no privilege for this operation " > > ? The problem AFAIK is that the first time init adds the tables and information necessary for SRP authentication, that part is failing due to normal Firebird privileges. Mark ------------------------------------------------------------------------------ Slashdot TV. Videos for Nerds. Stuff that Matters. http://pubads.g.doubleclick.net/gampad/clk?id=160591471&iu=/4140/ostg.clktrk Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
