Attempting to use Legacy_Auth directly after install doesn't work, restart of
service is required
-------------------------------------------------------------------------------------------------
Key: CORE-4153
URL: http://tracker.firebirdsql.org/browse/CORE-4153
Project: Firebird Core
Issue Type: Bug
Components: Engine, Installation, Security
Affects Versions: 3.0 Alpha 1
Environment: Windows 7 64 bit
WI-T3.0.0.30566 Firebird 3.0 Alpha 1 (64 bit)
Jaybird 2.2.3 (Java 7)
Reporter: Mark Rotteveel
I installed Firebird 3.0 alpha 1 with the legacy authentication enabled in the
installer. Connecting directly after installation with for example Flamerobin
(which uses fbclient) works. But connecting using Jaybird 2.2.3 (with
sysdba/masterkey as I configured in the installer) yields an exception:
Exception in thread "main" org.firebirdsql.jdbc.FBSQLException: GDS Exception.
335544472. Your user name and password are not defined. Ask your database
administrator to set up a Firebird login.
at
org.firebirdsql.jdbc.FBDataSource.getConnection(FBDataSource.java:123)
After restarting the Firebird service everything works as expected. It looks
like the modifications to the firebird.conf are only written to disk after the
service has been started and the installer has exited (file is not properly
closed?). If I look in the firebird.conf just before clicking 'Finish' on the
'Completing the Firebird Setup Wizard' page with 'Start firebird now?' enabled,
the authentication section contains:
# Per-database configurable.
#
#AuthServer = Srp, Win_Sspi
#
# Per-connection and per-database configurable.
#
#AuthClient = Srp, Win_Sspi, Legacy_Auth
After I click finish it is changed to:
# Per-database configurable.
#
#AuthServer = Srp, Win_Sspi
AuthServer = Srp, Win_Sspi, Legacy_Auth
#
# Per-connection and per-database configurable.
#
#AuthClient = Srp, Win_Sspi, Legacy_Auth
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
------------------------------------------------------------------------------
Get your SQL database under version control now!
Version control is standard for application code, but databases havent
caught up. So what steps can you take to put your SQL databases under
version control? Why should you start doing it? Read more to find out.
http://pubads.g.doubleclick.net/gampad/clk?id=49501711&iu=/4140/ostg.clktrk
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
