Providers = Remote,Loopback doesn't work with erro info Authentication error
unavailable database Statement failed, SQLSTATE = 08006
--------------------------------------------------------------------------------------------------------------------------------------
Key: CORE-6373
URL: http://tracker.firebirdsql.org/browse/CORE-6373
Project: Firebird Core
Issue Type: Bug
Affects Versions: 3.0.6
Environment: Windows 10 version 1803
Reporter: Alex
According to the Firebird-3-QuickStart.pdf, i try to disable embedded
connections, but doesn't work.
Server configuration and management
=> Security
=> Disable embedded connections
here is my detailed steps:
1. download Firebird-3.0.6.33328-0_x64.zip
2. unzip Firebird-3.0.6.33328-0_x64.zip to a directory
C:\Users\Alex\AppData\Local\Firebird
3. Initialize security database
isql -user sysdba employee
SQL> create user SYSDBA password 'SomethingCrytic';
SQL> commit;
SQL> quit;
4. Disable embedded connections
In firebird.conf, change below line
#Providers = Remote,Engine12,Loopback
Providers = Remote,Loopback
5. Start Firebird as a application
fbguard.exe -a
6. connect to firebird server with isql
isql
SQL> connect 127.0.0.1:employee
SQL> user SYSDBA
SQL> password 'SomethingCrytic'
SQL> ;
output message:
Statement failed, SQLSTATE = 08006
Error occurred during login, please check server firebird.log for
details
7. check the firebird.log
AlexaPC Wed Jul 29 09:53:20 2020
Authentication error
unavailable database
--
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
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
