[Firebird-devel] Firebird 3, adding users via gsec, again

2014-10-06 Thread Martijn Tonies (Upscene Productions)
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

Re: [Firebird-devel] Firebird 3, adding users via gsec, again

2014-10-06 Thread Dimitry Sibiryakov
06.10.2014 11:34, Martijn Tonies (Upscene Productions) wrote: Any clue? Add -user SYSDBA -- WBR, SD. -- Slashdot TV. Videos for Nerds. Stuff that Matters.

Re: [Firebird-devel] Firebird 3, adding users via gsec, again

2014-10-06 Thread Martijn Tonies (Upscene Productions)
06.10.2014 11:34, Martijn Tonies (Upscene Productions) wrote: Any clue? Add -user SYSDBA Same error: C:\Program Files\Firebird\Firebird_3_0gsec -add SYSDBA -pw masterkey -user SYSDBA An error occurred while attempting to add the user. unsuccessful metadata update CREATE TABLE PLG$SRP failed

Re: [Firebird-devel] Firebird 3, adding users via gsec, again

2014-10-06 Thread Mark Rotteveel
On Mon, 6 Oct 2014 11:34:34 +0200, Martijn Tonies (Upscene Productions) m.ton...@upscene.com 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 (

Re: [Firebird-devel] Firebird 3, adding users via gsec, again

2014-10-06 Thread Martijn Tonies (Upscene Productions)
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

Re: [Firebird-devel] Firebird 3, adding users via gsec, again

2014-10-06 Thread Vlad Khorsun
06.10.2014 12:48, Martijn Tonies (Upscene Productions) wrote: 06.10.2014 11:34, Martijn Tonies (Upscene Productions) wrote: Any clue? Add -user SYSDBA Same error: C:\Program Files\Firebird\Firebird_3_0gsec -add SYSDBA -pw masterkey -user SYSDBA An error occurred while attempting to add

Re: [Firebird-devel] Firebird 3, adding users via gsec, again

2014-10-06 Thread Mark Rotteveel
On Mon, 6 Oct 2014 12:03:07 +0200, Martijn Tonies (Upscene Productions) m.ton...@upscene.com 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.

Re: [Firebird-devel] Firebird 3, adding users via gsec, again

2014-10-06 Thread Martijn Tonies (Upscene Productions)
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

Re: [Firebird-devel] Firebird 3, adding users via gsec, again

2014-10-06 Thread Mark Rotteveel
On Mon, 6 Oct 2014 12:25:59 +0200, Martijn Tonies (Upscene Productions) m.ton...@upscene.com wrote: 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

Re: [Firebird-devel] Firebird 3, adding users via gsec, again

2014-10-06 Thread Martijn Tonies (Upscene Productions)
An error message along the lines of No (SYSDBA) account has been initialized, cannot add users. would certainly help to put a user on the right track. It could be that you are confronted with an entirely different problem, because most of my attempts yesterday lead to an error message that

Re: [Firebird-devel] Firebird 3, adding users via gsec, again

2014-10-06 Thread Mark Rotteveel
On Mon, 6 Oct 2014 12:52:54 +0200, Martijn Tonies (Upscene Productions) m.ton...@upscene.com wrote: An error message along the lines of No (SYSDBA) account has been initialized, cannot add users. would certainly help to put a user on the right track. It could be that you are confronted with

Re: [Firebird-devel] Firebird 3, adding users via gsec, again

2014-10-06 Thread Martijn Tonies (Upscene Productions)
I think this needs to be addressed, because if we get confused by this, then it is even going to be a bigger hurdle for users who just want to get up and running quickly without spending an hour on google, or getting frustrated by trying out all possible combinations of gsec command line

Re: [Firebird-devel] Firebird 3, adding users via gsec, again

2014-10-06 Thread Mark Rotteveel
On Mon, 6 Oct 2014 13:34:43 +0200, Martijn Tonies (Upscene Productions) m.ton...@upscene.com wrote: I think this needs to be addressed, because if we get confused by this, then it is even going to be a bigger hurdle for users who just want to get up and running quickly without spending an hour on

Re: [Firebird-devel] Firebird 3, adding users via gsec, again

2014-10-06 Thread Martijn Tonies (Upscene Productions)
I think this needs to be addressed, because if we get confused by this, then it is even going to be a bigger hurdle for users who just want to get up and running quickly without spending an hour on google, or getting frustrated by trying out all possible combinations of gsec command line

Re: [Firebird-devel] Firebird 3, adding users via gsec, again

2014-10-06 Thread Mark Rotteveel
On Mon, 6 Oct 2014 13:56:22 +0200, Martijn Tonies (Upscene Productions) m.ton...@upscene.com wrote: I think this needs to be addressed, because if we get confused by this, then it is even going to be a bigger hurdle for users who just want to get up and running quickly without spending an hour on

Re: [Firebird-devel] Firebird 3, adding users via gsec, again

2014-10-06 Thread Martijn Tonies (Upscene Productions)
But yeah, zip kit, should it be made available, once v3 is ready, then? If the issues are addressed, it clearly points to instructions etc, this shouldn't be a problem, should it? Yes, just like it is now for earlier versions of Firebird. Then I expect things will go smoothly. With

Re: [Firebird-devel] error on restore

2014-10-06 Thread Frank Schlottmann-Gödde
On 02.10.2014 20:49, Dmitry Yemanov wrote: 02.10.2014 20:18, Frank Schlottmann-Gödde wrote: I'm getting gbak: ERROR:action cancelled by trigger (3) to preserve data integrity gbak: ERROR:object has non-SQL security class defined gbak:Exiting before completion due to errors when trying