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
Unable to disable embedded connections following the Firebird 3.0 Quick Start Guide [CORE6307] #2328
Comments
Modified by: @luronumenAttachment: ERRO_MESSAGE.png [ 13435 ] |
Modified by: @luronumensummary: 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 |
Commented by: @AlexPeshkoff Suggested method 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. |
Modified by: @pcisarstatus: Resolved [ 5 ] => Closed [ 6 ] |
Commented by: @livius2 You can also use on connect trigger and prohibit there some protocols SELECT RDB$GET_CONTEXT('SYSTEM', 'NETWORK_PROTOCOL') FROM RDB$DATABASE |
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: