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

Unable to connect a database created through an input SQL file [CORE6132] #6381

Closed
firebird-automations opened this issue Sep 2, 2019 · 10 comments

Comments

@firebird-automations
Copy link
Collaborator

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;

@firebird-automations
Copy link
Collaborator Author

Modified by: @luronumen

Attachment: ERROR.png [ 13372 ]

Attachment: FB30_CREATE.bat [ 13373 ]

Attachment: ARAS.FDB [ 13374 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @luronumen

Attachment: STEP_1.SQL [ 13375 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @luronumen

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

- 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===
- 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;

=>

===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

- 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;

@firebird-automations
Copy link
Collaborator Author

Modified by: @luronumen

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

- 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;

=>

===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;

@firebird-automations
Copy link
Collaborator Author

Commented by: @hvlad

You trying to load 64-bit dll by 32-bit process (FlameRobin).

Note:
- error 193 is "%1 is not a valid Win32 application. "
- on Windows x64, "C:\Program Files\" contains 64-bit applications and DLL's
- FlameRobin is 32-bit application

@firebird-automations
Copy link
Collaborator Author

Commented by: @mrotteveel

Try connecting through localhost instead of trying to use Firebird Embedded.

@firebird-automations
Copy link
Collaborator Author

Modified by: Sean Leyne (seanleyne)

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

resolution: Won't Fix [ 2 ]

@firebird-automations
Copy link
Collaborator Author

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,
Luciano

@firebird-automations
Copy link
Collaborator Author

Commented by: @luronumen

Hi Vlad and Mark,

I could identify where the problem was.
Sorry for the inconvenience.

Best Regards,
Luciano

@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
Projects
None yet
Development

No branches or pull requests

1 participant