You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
but after remove the Engine12 from the list of the providers the following error message is displayed when it tried to connect with a existing database (e.g.: LOCALHOST:CHRONOS_CIN):
- 335545106 - Error occurred during login, please check server firebird.log for details
===firebird.log===
THUNDERBOY Sun May 17 11:19:07 2020
Authentication error
unavailable database
summary: Unable to disable embedded connections following the Firebird 3.0 Quick Start Guilde => Unable to disable embedded connections following the Firebird 3.0 Quick Start Guide
Suggested method
Providers = Remote,Loopback
obviously works only on client, on server it should not be used.
The best way is to correctly assign access rights to database files - they should be accessible only to firebird server, not to users, connecting to databases locally. Also one can use xnet:// prefix before database name.
Submitted by: @luronumen
Attachments:
ERRO_MESSAGE.png
According to the Firebird 3.0 Quick Start Guide (https://firebirdsql.org/file/documentation/reference_manuals/user_manuals/html/qsg3-config.html) to disable embedded connections you need to define the following list of providers on firebird.conf file:
Providers = Remote,Loopback
instead of the default value:
Providers = Remote,Engine12,Loopback
but after remove the Engine12 from the list of the providers the following error message is displayed when it tried to connect with a existing database (e.g.: LOCALHOST:CHRONOS_CIN):
- 335545106 - Error occurred during login, please check server firebird.log for details
===firebird.log===
THUNDERBOY Sun May 17 11:19:07 2020
Authentication error
unavailable database
ENVIRONMENT SETUP
===firebird.conf===
#SETUP
AuthClient = Legacy_Auth, Srp, Win_Sspi
AuthServer = Legacy_Auth, Srp, Win_Sspi
ServerMode = Super
UserManager = Legacy_UserManager, Srp
WireCrypt = Enabled
Providers = Remote,Loopback
#PERFORMANCE
DefaultDbCachePages = 30K
FileSystemCacheThreshold = 2M
LockHashSlots = 30011
LockMemSize = 15M
RemoteServicePort = 3050
TempBlockSize = 2M
TempCacheLimit = 3000M
#SECURITY
SecurityDatabase = $(dir_secDb)/security3.fdb
The text was updated successfully, but these errors were encountered: