Stream: pascal
Topic: DB connection ini
Jose Costa Teixeira (May 30 2020 at 22:33):
i have this in my ini
dbr4=type: mysql; server: 192.168.56.1; username: sa; password: notPassword; database: fhirDB; driver="MySQL ODBC 5.3 Unicode Driver"
but the connectionFactory initialization says that fdriver is ''
Grahame Grieve (May 30 2020 at 22:33):
: not = ?
Jose Costa Teixeira (May 30 2020 at 22:35):
of course. (Postprandial coding leads to silly errors)
Jose Costa Teixeira (May 30 2020 at 22:41):
one more for today
EODBC: [MySQL][ODBC 5.3(w) Driver][mysqld-5.5.5-10.2.13-MariaDB-log]Column length too big for column 'Scope' (max = 255); use BLOB or TEXT instead
Do you know what's happening? I'm trying to use mysql (SQLite was not working on DB init), and this is new
Grahame Grieve (May 30 2020 at 22:53):
oh.
Grahame Grieve (May 30 2020 at 22:53):
oh dear
Jose Costa Teixeira (May 30 2020 at 23:00):
I was just trying to get this back to work, it is not critical for me
Jose Costa Teixeira (May 31 2020 at 06:37):
this:
procedure TFHIRDatabaseInstaller.CreateOAuthLogins;
begin
FConn.ExecSQL('CREATE TABLE OAuthLogins( '+#13#10+
' Id nchar('+inttostr(ID_LENGTH)+') NOT NULL, '+#13#10+
' Client nchar(48) NOT NULL, '+#13#10+
' Scope nchar(1024) NOT NULL, '+#13#10+
Jose Costa Teixeira (May 31 2020 at 06:40):
in mysql/mariadb where nchar can have up to 255 characters.
Jose Costa Teixeira (May 31 2020 at 06:41):
I changed nchar(1024) to varchar(1024) CHARACTER SET utf8
Jose Costa Teixeira (May 31 2020 at 06:41):
it doesn't complain anymore
Jose Costa Teixeira (May 31 2020 at 06:42):
is there a common dialect? is varchar(1024) character set utf8 OK also for MSSQL and SQLITE?
Jose Costa Teixeira (May 31 2020 at 06:54):
...and i get here:
08:47:50 Exception stopping (EAccessViolation): Access violation at address 0000000000531C85 in module 'FHIRServer.exe'. Read of address 0000000000000040
(0000000000130C85){FHIRServer.exe} [0000000000531C85] System.Classes._ZN6System7Classes7TThread9TerminateEv + $5
(0000000005ADD772){FHIRServer.exe} [0000000005EDE772] JclDebug._ZN8Jcldebug17TJclStackInfoListC3EbiPvbS1_ (Line 5377, "JclDebug.pas" + 2) + $0
(0000000005ADF754){FHIRServer.exe} [0000000005EE0754] JclDebug._ZN8Jcldebug21GetExceptionStackInfoEPN6System16TExceptionRecordE (Line 7222, "JclDebug.pas" + 42) + $3B
(0000000000049A87){FHIRServer.exe} [000000000044AA87] System.SysUtils._ZN6System8Sysutils9Exception16RaisingExceptionEPNS_16TExceptionRecordE + $27
(000000000004A31B){FHIRServer.exe} [000000000044B31B] System.SysUtils._ZN6System8Sysutils18GetExceptionObjectEPNS_16TExceptionRecordE + $EB
(0000000005ACEC4C){FHIRServer.exe} [0000000005ECFC4C] JclHookExcept._ZN13Jclhookexcept14DoExceptFilterEPN6System16TExceptionRecordE (Line 314, "JclHookExcept.pas" + 19) + $D
(0000000005ACEF25){FHIRServer.exe} [0000000005ECFF25] JclHookExcept._ZN13Jclhookexcept19HookedExceptObjProcEPN6System16TExceptionRecordE (Line 387, "JclHookExcept.pas" + 1) + $9
(0000000000010CDE){FHIRServer.exe} [0000000000411CDE] System._ZN6System23_DelphiExceptionHandlerEPNS_16TExceptionRecordEyPvS2_ + $26E
(00000000000A01CF){ntdll.dll } [00007FFB2D6011CF] Unknown function at __chkstk + $11F
(0000000000069209){ntdll.dll } [00007FFB2D5CA209] Unknown function at RtlRaiseException + $399
(000000000009EE3E){ntdll.dll } [00007FFB2D5FFE3E] KiUserExceptionDispatcher + $2E
(0000000000130C85){FHIRServer.exe} [0000000000531C85] System.Classes._ZN6System7Classes7TThread9TerminateEv + $5
(0000000005AE7DAC){FHIRServer.exe} [0000000005EE8DAC] FHIR.Server.Kernel._ZN4Fhir6Server6Kernel12TFHIRService14StopRestServerEv (Line 1099, "FHIR.Server.Kernel.pas" + 2) + $0
(0000000005AE2951){FHIRServer.exe} [0000000005EE3951] FHIR.Server.Kernel._ZN4Fhir6Server6Kernel12TFHIRService6DoStopEv (Line 486, "FHIR.Server.Kernel.pas" + 5) + $0
(0000000005AE445A){FHIRServer.exe} [0000000005EE545A] FHIR.Server.Kernel._ZN4Fhir6Server6Kernel12TFHIRService4LoadEN6System13UnicodeStringES4_NS0_11Dbinstaller26TFHIRInstallerSecurityModeE (Line 714, "FHIR.Server.Kernel.pas" + 75) + $0
(0000000005AE10B9){FHIRServer.exe} [0000000005EE20B9] FHIR.Server.Kernel._ZN4Fhir6Server6Kernel17ExecuteFhirServerEv (Line 261, "FHIR.Server.Kernel.pas" + 81) + $28
(0000000005AEDF90){FHIRServer.exe} [0000000005EEEF90] FHIRServer._ZN10Fhirserver14initializationEv (Line 448, "FHIRServer.dpr" + 11) + $5
(0000000000016BD4){KERNEL32.DLL} [00007FFB2C287BD4] BaseThreadInitThunk + $14
(000000000006BE51){ntdll.dll } [00007FFB2D5CCE51] RtlUserThreadStart + $21
Grahame Grieve (Jun 01 2020 at 12:37):
hmm. where in the shut down process is that?
Jose Costa Teixeira (Jun 01 2020 at 17:32):
I will have to check in a few days when my computer is working again :(
Last updated: Apr 12 2022 at 19:14 UTC
