Recent

Author Topic: [SOLVED] Using SQLite on Ubuntu 19.04  (Read 1165 times)

JanRoza

  • Hero Member
  • *****
  • Posts: 521
    • http://www.silentwings.nl
[SOLVED] Using SQLite on Ubuntu 19.04
« on: May 02, 2019, 11:49:17 pm »
Being new on Linux I managed to install Lazarus 2.0.2 and FPC 3.0.4 and all the components I need, but trying to run one of my existing (windows) projects in Lazarus on Ubuntu I get an error the moment the database connection should be opened.
The message says: "/build/glibc-KRRWSm/glibc-2.29/elf/dl-error-skeleton.c was not found" (see sreenshot).

I already have installed sqlite3 and sqlite3-dev but apparently I missed something, can anyone tell me what more needs to be installed?
« Last Edit: May 06, 2019, 08:04:08 am by JanRoza »
OS: Windows 10 (64 bit) / Ubuntu 19.04 (64 bit)
Laz: Lazarus 2.0.2 FPC 3.0.4 i386-win32-win32/win64

JanRoza

  • Hero Member
  • *****
  • Posts: 521
    • http://www.silentwings.nl
Re: Using SQLite on Ubuntu 19.04
« Reply #1 on: May 04, 2019, 12:35:26 am »
Anyone?
OS: Windows 10 (64 bit) / Ubuntu 19.04 (64 bit)
Laz: Lazarus 2.0.2 FPC 3.0.4 i386-win32-win32/win64

john horst

  • Jr. Member
  • **
  • Posts: 52
Re: Using SQLite on Ubuntu 19.04
« Reply #2 on: May 04, 2019, 07:09:30 am »

JanRoza

  • Hero Member
  • *****
  • Posts: 521
    • http://www.silentwings.nl
Re: Using SQLite on Ubuntu 19.04
« Reply #3 on: May 04, 2019, 05:36:49 pm »
That message is about openssl.
Does opening a connection to a sqlite database file use openssl?
It is a non-encrypted unprotected sqlite database.
I don't want to install unnecessary programs or libraries, so that's why I ask.
OS: Windows 10 (64 bit) / Ubuntu 19.04 (64 bit)
Laz: Lazarus 2.0.2 FPC 3.0.4 i386-win32-win32/win64

lucamar

  • Hero Member
  • *****
  • Posts: 1797
Re: Using SQLite on Ubuntu 19.04
« Reply #4 on: May 04, 2019, 05:49:52 pm »
That message is about openssl.

That message is about the same problem you have, only in that case it happened while using OpenSSL, just as a previous one involved MySQL. It's a debugger problem, if I understood the post correctly.

Does opening a connection to a sqlite database file use openssl?

No: SQLite is a strictly local, embedded, self-contained DBMS.
« Last Edit: May 04, 2019, 05:52:18 pm by lucamar »
Turbo Pascal 3 CP/M - Amstrad PCW 8256 (512 KB !!!) :P
Lazarus 1.8.4 & 2.0.2 w/FPC 3.0.4 on:
(K|L)Ubuntu 12..16, Windows XP SP3, various DOSes.

john horst

  • Jr. Member
  • **
  • Posts: 52
Re: Using SQLite on Ubuntu 19.04
« Reply #5 on: May 04, 2019, 07:03:56 pm »
@lucamar correct.

@JanRoza that is GDB (the debugger itself) letting you know it can't find "dl-error-skeleton.c: No such file or directory". It's not your program itself, if that makes sense. Basically man, GDB needs to be told where to find dl-error-skeleton.c.
« Last Edit: May 04, 2019, 07:26:19 pm by john horst »

JanRoza

  • Hero Member
  • *****
  • Posts: 521
    • http://www.silentwings.nl
Re: Using SQLite on Ubuntu 19.04
« Reply #6 on: May 04, 2019, 09:52:05 pm »
I will try to locate it on my linux system and tell dbg where to find it. Didn't realize it was a debugger problem.
Does that mean that if I compile a release version without debugger that it should work? I will experiment some more this weekend.
Thanks John and Kucamar!
OS: Windows 10 (64 bit) / Ubuntu 19.04 (64 bit)
Laz: Lazarus 2.0.2 FPC 3.0.4 i386-win32-win32/win64

JanRoza

  • Hero Member
  • *****
  • Posts: 521
    • http://www.silentwings.nl
Re: Using SQLite on Ubuntu 19.04
« Reply #7 on: May 06, 2019, 08:03:43 am »
Thanks guys!
Running without debugger really works, so I can go on with my discovery of Lazarus in Linux.
Would be nice though is this debugger problem gets solved in the near future, until then I'll do the debugging on Windows.
OS: Windows 10 (64 bit) / Ubuntu 19.04 (64 bit)
Laz: Lazarus 2.0.2 FPC 3.0.4 i386-win32-win32/win64

Zvoni

  • Full Member
  • ***
  • Posts: 198
Re: [SOLVED] Using SQLite on Ubuntu 19.04
« Reply #8 on: May 07, 2019, 11:16:56 am »
I know. Marked solved, but since i had the same thing....
Let me guess: you single-stepped through your code, and that message popped up at the Codeline, where you connect to the DB (MyConnection.Open or MyConnection.Connected:=True).
I just put a Breakpoint at the NEXT codeline (after opening the Connection), and in the codeline prior to it, i hit RUN....
Voila! Can still debug and what not
One System to rule them all, One IDE to find them,
One Code to bring them all, and to the Framework bind them,
in the Land of Redmond, where the Windows lie
---------------------------------------------------------------------
People call me crazy, because i'm jumping out of perfectly fine aircrafts

JanRoza

  • Hero Member
  • *****
  • Posts: 521
    • http://www.silentwings.nl
Re: [SOLVED] Using SQLite on Ubuntu 19.04
« Reply #9 on: May 08, 2019, 12:25:34 pm »
Quote
Let me guess: you single-stepped through your code, and that message popped up at the Codeline, where you connect to the DB (MyConnection.Open or MyConnection.Connected:=True).
Correct.

Since Windows is still my main system, for me it is not a big problem. I debug in Windows and when all is working I compile in Linux.
OS: Windows 10 (64 bit) / Ubuntu 19.04 (64 bit)
Laz: Lazarus 2.0.2 FPC 3.0.4 i386-win32-win32/win64