Skip to content
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

Jump to bottom

Unable to disable embedded connections following the Firebird 3.0 Quick Start Guide [CORE6373] #6612

Closed
firebird-automations opened this issue Jul 29, 2020 · 7 comments
Closed

Unable to disable embedded connections following the Firebird 3.0 Quick Start Guide [CORE6373] #6612

firebird-automations opened this issue Jul 29, 2020 · 7 comments
Labels
affect-version: 3.0.6 priority: major resolution: wontfix type: bug

Comments

@firebird-automations
Copy link
Collaborator

Submitted by: Alex (z003609k)

According to the Firebird 3.0 Quick Start Guide
=>Server configuration and management
=> Security
=> Disable embedded connections

Providers = Remote,Loopback

instead of

#⁠Providers = Remote,Engine12,Loopback

but, after that, the below error info. displayed when i try to connect to firebird server with isql tool.

Statement failed, SQLSTATE = 08006
Error occurred during login, please check server firebird\.log for details

====== record in firebird.log=======

AlexaPC	Wed Jul 29 09:53:20 2020
	Authentication error
	unavailable database

=========================
@firebird-automations
Copy link
Collaborator Author

Modified by: Alex (z003609k)

summary: Providers = Remote,Loopback doesn't work with erro info Authentication error unavailable database Statement failed, SQLSTATE = 08006 => Unable to disable embedded connections following the Firebird 3.0 Quick Start Guide

@firebird-automations
Copy link
Collaborator Author

Modified by: Alex (z003609k)

environment: Windows 10 version 1803 => Windows 10 x64
Firebird 3.0.6 (x64)

@firebird-automations
Copy link
Collaborator Author

Modified by: Alex (z003609k)

description: 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

=>

According to the Firebird 3.0 Quick Start Guide
=>Server configuration and management
=> Security
=> Disable embedded connections

Providers = Remote,Loopback

instead of

#⁠Providers = Remote,Engine12,Loopback

but, after that, the below error info. displayed when i try to connect to firebird server with isql tool.

Statement failed, SQLSTATE = 08006
Error occurred during login, please check server firebird\.log for details

====== record in firebird.log=======

AlexaPC	Wed Jul 29 09:53:20 2020
	Authentication error
	unavailable database

=========================

@firebird-automations
Copy link
Collaborator Author

Commented by: @hvlad

If you remove Engine12 from firebird.conf used by server - how do yo expect it (server) could access database ?

The trick you referes to is for client-side configuration, not for the server-side (or used by both client and server - if you run isql from common firebird folder).

@firebird-automations
Copy link
Collaborator Author

Commented by: @dyemanov

Have you tried "Providers = Loopback, Engine12, Remote" ? See here: https://ib-aid.com/en/articles/how-to-make-firebird-3-connect-like-2-5-with-embedded-connection-string/

@firebird-automations
Copy link
Collaborator Author

Modified by: @AlexPeshkoff

status: Open [ 1 ] => Resolved [ 5 ]

resolution: Won't Fix [ 2 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @pcisar

status: Resolved [ 5 ] => Closed [ 6 ]

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
affect-version: 3.0.6 priority: major resolution: wontfix type: bug
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
1 participant
@firebird-automations