Hi,
on the same mashine i have working FB2.5 on port 3050
freshly downloaded windows snapshot Firebird-3.0.0.31855-0_x64
my config
AuthServer = Legacy_Auth
AuthClient = Legacy_Auth, Srp, Win_Sspi
UserManager = Legacy_UserManager
Providers = Remote,Engine12,Loopback
WireCrypt = Disabled
WireCompression = false
RemoteServicePort = 3051
output form CMD
C:\Program Files\Firebird\Firebird_3>install_super.bat Firebird3
instsvc version WI-T3.0.0.31855 Firebird 3.0 Beta 2
Service "Firebird Server - Firebird3" successfully created.
Service "Firebird Server - Firebird3" successfully started.
C:\Program Files\Firebird\Firebird_3>gsec -add SYSDBA -pw masterkey -admin yes
An error occurred while attempting to add the user.
no permission for INSERT access to TABLE PLG$VIEW_USERS
C:\Program Files\Firebird\Firebird_3>gsec -?
gsec utility - maintains user password database
command line usage:
gsec [ <options> ... ] <command> [ <parameter> ... ]
interactive usage:
gsec [ <options> ... ]
GSEC>
<command> [ <parameter> ... ]
available options:
-user <database administrator name>
-password <database administrator password>
-fetch_password <file to fetch password from>
-role <database administrator SQL role name>
-trusted (use trusted authentication)
-database <database to manage>
-z
available commands:
adding a new user:
add <name> [ <parameter> ... ]
deleting a current user:
delete <name>
displaying all users:
display
displaying one user:
display <name>
modifying a user's parameters:
modify <name> <parameter> [ <parameter> ... ]
changing admins mapping to RDB$ADMIN role in security database:
mapping {set|drop}
help:
? (interactive only)
help
displaying version number:
z (interactive only)
quit interactive session:
quit (interactive only)
available parameters:
-pw <password>
-uid <uid>
-gid <uid>
-fname <firstname>
-mname <middlename>
-lname <lastname>
-admin {yes|no}
C:\Program Files\Firebird\Firebird_3>gsec -display
C:\Program Files\Firebird\Firebird_3>gsec -display sysdba
C:\Program Files\Firebird\Firebird_3>gsec -add SYSDBA -pw masterkey -admin yes
An error occurred while attempting to add the user.
no permission for INSERT access to TABLE PLG$VIEW_USERS
C:\Program Files\Firebird\Firebird_3>gsec -add SYSDBA -pw masterkey
An error occurred while attempting to add the user.
no permission for INSERT access to TABLE PLG$VIEW_USERS
C:\Program Files\Firebird\Firebird_3>gsec -user sysdba -password masterkey -add
SYSDBA -pw masterkey
An error occurred while attempting to add the user.
violation of PRIMARY or UNIQUE KEY constraint "INTEG_2" on table "PLG$USERS"
Problematic key value is ("PLG$USER_NAME" = 'SYSDBA')
C:\Program Files\Firebird\Firebird_3>gsec -display
C:\Program Files\Firebird\Firebird_3>gsec -display sysdba
C:\Program Files\Firebird\Firebird_3>
How can i add sysdba? What are the reall steps?
regards,
Karol Bieniaszewski------------------------------------------------------------------------------
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
