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 connect a database created through an input SQL file [CORE6132] #6381
Comments
Modified by: @luronumenAttachment: ERROR.png [ 13372 ] Attachment: FB30_CREATE.bat [ 13373 ] Attachment: ARAS.FDB [ 13374 ] |
Modified by: @luronumenAttachment: STEP_1.SQL [ 13375 ] |
Modified by: @luronumendescription: ===ACTUAL RESULT=== ===EXPECTED RESULT:=== ==STEPS TO REPRODUCE DE ISSUE== - Create the FB30_CREATE.bat file adding the following instructions: - Verify that the ARAS.FDB database is created (960 KB) - Try to connect to the ARAS.FDB using the FlameRobin tools ===FIREBIRD 3.0.4 SETUP=== - Setup the Firebird 3.0.4 SYSDBA password using legacy plugin: => ===ACTUAL RESULT=== ===EXPECTED RESULT:=== ==STEPS TO REPRODUCE DE ISSUE== - Create the FB30_CREATE.bat file adding the following instructions: - Verify that the ARAS.FDB database is created (960 KB) - Try to connect to the ARAS.FDB using the FlameRobin tools ===IMPORTANT NOTES=== ===FIREBIRD 3.0.4 SETUP=== - Setup the Firebird 3.0.4 SYSDBA password using legacy plugin: |
Modified by: @luronumendescription: ===ACTUAL RESULT=== ===EXPECTED RESULT:=== ==STEPS TO REPRODUCE DE ISSUE== - Create the FB30_CREATE.bat file adding the following instructions: - Verify that the ARAS.FDB database is created (960 KB) - Try to connect to the ARAS.FDB using the FlameRobin tools ===IMPORTANT NOTES=== ===FIREBIRD 3.0.4 SETUP=== - Setup the Firebird 3.0.4 SYSDBA password using legacy plugin: => ===ACTUAL RESULT=== ===EXPECTED RESULT:=== ==STEPS TO REPRODUCE DE ISSUE== - Create the FB30_CREATE.bat file adding the following instructions: - Rum the FB30_CREATE.bat file: Verify that the ARAS.FDB database is created (960 KB) - Try to connect to the ARAS.FDB using the FlameRobin tools ===IMPORTANT NOTES=== ===FIREBIRD 3.0.4 SETUP=== - Setup the Firebird 3.0.4 SYSDBA password using legacy plugin: |
Commented by: @hvlad You trying to load 64-bit dll by 32-bit process (FlameRobin). Note: |
Commented by: @mrotteveel Try connecting through localhost instead of trying to use Firebird Embedded. |
Modified by: Sean Leyne (seanleyne)status: Open [ 1 ] => Resolved [ 5 ] resolution: Won't Fix [ 2 ] |
Commented by: @luronumen Hi Vlad and Mark, Thank you vey much for your promt reply! I have no control over what FlameRobin (x32) library is trying to load. I have other databases that I restored in Firebird 3.0.4 (x64) using gbak that open FlameRobin (x32) perfectly. It makes no sense that a database created using isql.exe cannot be opened by the same FlameRobin (x32) when it is called by localhost:<path>. Beside that, all x32 applications cannot connect with the database created like this isql procedure even using the localhost:<path> and Firebird Services started. Could you please help to identify the issue? Thanks in advance, |
Commented by: @luronumen Hi Vlad and Mark, I could identify where the problem was. Best Regards, |
Modified by: @pcisarstatus: Resolved [ 5 ] => Closed [ 6 ] |
Submitted by: @luronumen
Attachments:
ERROR.png
FB30_CREATE.bat
ARAS.FDB
STEP_1.SQL
===ACTUAL RESULT===
- Unable to connect a database created through an input SQL file (See ERROR.png):
Engine Code: 335545004
Engine Message: Error loading plugin Engine12
Module C:\Program Files\Firebird\Firebird_3_0\plugins/Engine12 exists but can not be loaded
unknown Win32 error 193
===EXPECTED RESULT:===
- User should be able to connect a database created through an input SQL file
==STEPS TO REPRODUCE DE ISSUE==
- Create the STEP_1.SQL file adding the following instructions:
SET SQL DIALECT 3;
CREATE DATABASE 'E:\LURONUMEN\GIT\SOLUTION\ARAS\DB\CLEAN\ARAS.FDB' PAGE_SIZE 4096 DEFAULT CHARACTER SET NONE;
- Create the FB30_CREATE.bat file adding the following instructions:
"%ProgramFiles%\Firebird\Firebird_3_0\isql.exe" -user SYSDBA -password SYSDBAPWD -quiet -input "%CD%\STEP_1.SQL"
pause
- Rum the FB30_CREATE.bat file: Verify that the ARAS.FDB database is created (960 KB)
- Try to connect to the ARAS.FDB using the FlameRobin tools
===IMPORTANT NOTES===
- This issue is NOT reproducible on Firebird 2.5.9
===FIREBIRD 3.0.4 SETUP===
- Firebird.conf file
#SETUP
AuthClient = Legacy_Auth, Srp, Win_Sspi
AuthServer = Legacy_Auth, Srp, Win_Sspi
ServerMode = Super
UserManager = Legacy_UserManager, Srp
WireCrypt = Enabled
#PERFORMANCE
DefaultDbCachePages = 100K
FileSystemCacheThreshold = 2M
LockHashSlots = 30011
LockMemSize = 15M
RemoteServicePort = 3050
TempBlockSize = 2M
TempCacheLimit = 1000M
TracePlugin = fbtrace
- Setup the Firebird 3.0.4 SYSDBA password using legacy plugin:
ALTER CURRENT USER SET PASSWORD 'SYSDBAPWD' USING PLUGIN LEGACY_USERMANAGER;
The text was updated successfully, but these errors were encountered: