Unable to connect a database created through an input SQL file
--------------------------------------------------------------
Key: CORE-6132
URL: http://tracker.firebirdsql.org/browse/CORE-6132
Project: Firebird Core
Issue Type: Bug
Affects Versions: 3.0.4
Environment: Windows 10 Pro (x64)
Firebird 3.0.4 (x64)
Reporter: Luciano Mendes
Priority: Critical
Attachments: ARAS.FDB, ERROR.png, FB30_CREATE.bat
===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;
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
