Recent

Author Topic: Cannot install sqlite3 package  (Read 13890 times)

GuiGuy

  • New member
  • *
  • Posts: 8
Cannot install sqlite3 package
« on: December 16, 2006, 05:59:45 am »
Hi,
I'm an experienced Delphi developer coming from Windows to Linux (Ubuntu 6.10)

I would like to use the Sqlite3 db engine but am unable to install the required packages into Lazarus

When I attempt the package "sqlite3laz.lpk" install it fails on linking, ld complaining that it cannot find -lsqlite3:

Quote

"Compile IDE (without linking)" completed
/usr/bin/ld: cannot find -lsqlite3
/usr/lib/lazarus/ide/lazarus.pp(117,1) Error: Error while linking
make[2]: *** [lazarus] Error 1


http://wiki.lazarus.freepascal.org/Lazarus_Database_Tutorial states I require "sqlite runtime library 3.2.1 or above (get from www.sqlite.org)" and that it must be in the path.

OK, since I need to guess what the runtime library might be called I took a stab at "sqlite-3.3.8.so" - Can someone confirm that that is what is needed? Incidentally, Sqlite3 is definitely installed in the PC.

I have also edited "ld.so.conf" and added the /usr/lib which is the directory where I have placed sqlite-3.3.8.so

But it's not working. Clearly I am missing something in the instructions.

Any help, anyone?

TIA

The GUIGuy.
The GuyGui

Kknd

  • New Member
  • *
  • Posts: 14
    • http://rpgfrontier.awardspace.com
RE: Cannot install sqlite3 package
« Reply #1 on: December 23, 2006, 04:23:29 pm »
You need to install the sqlite lib. On Debian-like you can apt-get it!

pfranchuk

  • New Member
  • *
  • Posts: 19
Cannot install sqlite3 package
« Reply #2 on: December 23, 2006, 04:43:49 pm »
You are probably right about the name of the .so package. But Lazarus is looking for another name. Check the FAQ's I believe you will see that you need to create a symbolic link in /usr/lib to get Lazarus to find the library.

GuiGuy

  • New member
  • *
  • Posts: 8
Cannot install sqlite3 package
« Reply #3 on: December 24, 2006, 12:13:49 am »
Quote from: "pfranchuk"
You are probably right about the name of the .so package. But Lazarus is looking for another name. Check the FAQ's I believe you will see that you need to create a symbolic link in /usr/lib to get Lazarus to find the library.


That would probably be "lsqlite3" (?)

Anyway, doesn't matter for now. Too much other nonsense happening at this tome of the year. I'll have another go when time permits.

BTW, one of the things I am noticing about dev tools under linux is that documentation is not a strong point. I've been a bit spoiled over the last few years using Developer Express and similar.

All the best

The GuiGuy
The GuyGui

pfranchuk

  • New Member
  • *
  • Posts: 19
Cannot install sqlite3 package
« Reply #4 on: December 24, 2006, 01:55:39 am »
Something like that.

You would do a symbolic link to libsqlite3.so and the libsqlite-3.x.x.so that you have in the /usr/lib

Peter

bkv

  • New member
  • *
  • Posts: 8
Cannot install sqlite3 package
« Reply #5 on: April 24, 2007, 10:03:02 pm »
Quote from: "pfranchuk"
Something like that.

You would do a symbolic link to libsqlite3.so and the libsqlite-3.x.x.so that you have in the /usr/lib

Peter

I too cannot get Lazarus built with  sqlite. I tried with some symbolic links, but it did not work. Does someone know what this link should be called? Or is it something else missing.? I'm on Kubuntu Dapper and I have installedthe sqlite package

bwinfrey

  • New Member
  • *
  • Posts: 13
Install Development Libraries
« Reply #6 on: January 11, 2008, 11:15:33 pm »
None of the posted resolutions worked for me; however, this did.

sudo apt-get install libsqlite3-dev

Awesome Programmer

  • Sr. Member
  • ****
  • Posts: 451
  • Programming is FUN only when it works :)
    • Cool Technology
Re: Install Development Libraries
« Reply #7 on: March 23, 2016, 04:51:35 am »
None of the posted resolutions worked for me; however, this did.

sudo apt-get install libsqlite3-dev

This worked for me instantly .... I didn't even have to separately install the design package for sqlite.... thank you.

cdbc

  • Hero Member
  • *****
  • Posts: 1025
    • http://www.cdbc.dk
Re: Cannot install sqlite3 package
« Reply #8 on: March 23, 2016, 08:02:37 am »
Hi
My install looks like this:
Code: Pascal  [Select][+][-]
  1. lrwxrwxrwx 1 root root     19 nov 13 14:52 /usr/lib/libsqlite3.so -> libsqlite3.so.0.8.6*
meaning you have to create a symlink in /usr/lib:
Code: Pascal  [Select][+][-]
  1. sudo ln -s sqlite-3.3.8.so libsqlite3.so
Should work, but maybe you have to fiddle a bit with it  :)
Hth - Regards Benny
« Last Edit: March 23, 2016, 08:08:58 am by cdbc »
If it ain't broke, don't fix it ;)
PCLinuxOS(rolling release) 64bit -> KDE5 -> FPC 3.2.2 -> Lazarus 2.2.6 up until Jan 2024 from then on it's: KDE5/QT5 -> FPC 3.3.1 -> Lazarus 3.0

C#R#

  • New Member
  • *
  • Posts: 45
Re: Cannot install sqlite3 package
« Reply #9 on: August 19, 2016, 08:27:58 pm »
instaling a dev package works fine, but the application need this package to work, tink about this when you go to distribute your app    :|

LuizAmérico

  • Sr. Member
  • ****
  • Posts: 457
Re: Cannot install sqlite3 package
« Reply #10 on: August 20, 2016, 12:18:07 am »
The compiled program will not need the dev package, which is only required to compile

 

TinyPortal © 2005-2018