New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
Cannot connect to a database which have own security database without security3.fdb [CORE5032] #5319
Comments
Modified by: @AlexPeshkoffassignee: Alexander Peshkov [ alexpeshkoff ] |
Commented by: @AlexPeshkoff Tried the following: 1. added appropriate lines to databases.conf - in my case it's as follows: .... <std heading from install> 2. Created database. # ./isql 3. Started server. 4. Make sure that std security database is bad: # ./isql -user sysdba -password masterkey localhost:employee 5. Successfully attached to MYDB: # ./isql -user myadmin -password mypassword 192.168.1.2:MYDB |
Commented by: Gabor Boros (gaborboros) Rename security3.fdb to security3_fdb and try step 5 again. The result is: Statement failed, SQLSTATE = 08006 Is this works as expected? The error message is correct? |
Commented by: @AlexPeshkoff It works - no problems. But provided server is started _before_ renaming security db. Are you sure you have firebird server started? Try to switch to classic mode and repeat that test. |
Modified by: @AlexPeshkoffstatus: Resolved [ 5 ] => Reopened [ 4 ] resolution: Cannot Reproduce [ 5 ] => |
Commented by: Gabor Boros (gaborboros) I have more informations. With Super, Guardian restarting the server endless without any error in firebird.log(not exists and not created) if security3.fdb renamed, deleted or have wrong permissions before server started. Independently from security3.fdb exists in databases.conf or not. Same error with SuperClassic. No error with Classic, I can connect to MYDB without security3.fdb exists and the databases.conf contains only the MYDB alias(all other text removed from it before server start). So, the problem is Super* specific. Got same results with snapshot 3.0.0.32221 from today. Used Ubuntu 14.04.3 Live (ubuntu-14.04.3-desktop-amd64.iso) for the tests. |
Commented by: @AlexPeshkoff Added analysis for a case of missing main security database. |
Modified by: @AlexPeshkoffstatus: Reopened [ 4 ] => Resolved [ 5 ] resolution: Fixed [ 1 ] Fix Version: 3.0 RC2 [ 10048 ] |
Commented by: Gabor Boros (gaborboros) The problem still exists with snapshot 3.0.0.32227. |
Commented by: @AlexPeshkoff Please try tomorrow snapshot, should work |
Commented by: Gabor Boros (gaborboros) Works like a charm with 3.0.0.32233. But see some installer trouble: Please enter new password for SYSDBA user: blabla Starting Firebird server: Install completed |
Modified by: @pavel-zotovstatus: Resolved [ 5 ] => Resolved [ 5 ] QA Status: No test => Cannot be tested |
Submitted by: Gabor Boros (gaborboros)
The whole databases.conf:
MYDB = /home/DB/MYDB.FDB
{
SecurityDatabase = MYDB
}
MYDB initialized correctly(users created) and works like a charm but only when security3.fdb exists and initialized. Got "Statement failed, SQLSTATE = 08006
Unable to complete network request to host..." error at remote connection (isql -user MYADMIN -password mypassword 192.168.0.1:MYDB). security3.fdb touched only by the installer(MYADMIN not exist in it), SYSDBA password is a random value and SYSDBA never used.
Commits: fde2d8f 3c3dbf6 FirebirdSQL/fbt-repository@61fba47 FirebirdSQL/fbt-repository@f290aaf
The text was updated successfully, but these errors were encountered: