On Mon, 6 Oct 2014 11:34:34 +0200, "Martijn Tonies (Upscene Productions)"
<[email protected]> wrote:
> Hi all,
> 
> 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. 

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).

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

Reply via email to