Hello Mark, >> Downloaded build 31353 today, copied all files from the zip into a >folder, >> security3.fdb included. >> >> Server is not running, as I googled from last time, it shouldn’t >> ( >> >http://markmail.org/message/nulij7djq4gxhxro#query:+page:1+mid:q6qhmuwtpjdevrwu+state:results >> ) >> >> When using the following gsec command: >> >> gsec -add SYSDBA -pw masterkey >> >> I get this error: >> >> An error occurred while attempting to add the user. >> unsuccessful metadata update >> CREATE TABLE PLG$SRP failed >> There is no privilege for this operation >> >> >> Any clue? > >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? >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 " ? With regards, Martijn Tonies Upscene Productions http://www.upscene.com Download Database Workbench for Oracle, MS SQL Server, Sybase SQL Anywhere, MySQL, InterBase, NexusDB and Firebird! ------------------------------------------------------------------------------ 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
