having trouble compiling: SQLite not found <solved>

You can get help here if Freeciv doesn't start on your computer, or if you keep getting fatal errors while playing etc.
Post Reply
drgerg
Veteran
Posts: 61
Joined: Sun Nov 15, 2015 4:05 pm

having trouble compiling: SQLite not found <solved>

Post by drgerg »

OS:Ubuntu22.04 64bit on an Intel NUC
fully patched (or as best I can)

Code: Select all

checking for SQLite3 library >= 3.0.0... not found
configure: error: sqlite3 not found
Configure failed
crgadmin@Nuc7:~/FreeCiv$ 
full log attached.
Note, I did reboot the machine after "apt install sqlite3", just in case there was a daemon that needed to be started.
sqlite3 --version reports 3.45.1
Attachments
311_install_log.txt
(9.46 KiB) Downloaded 2587 times
Last edited by drgerg on Sun Jun 30, 2024 7:52 pm, edited 1 time in total.
drgerg
Veteran
Posts: 61
Joined: Sun Nov 15, 2015 4:05 pm

Re: having trouble compiling: SQLite not found

Post by drgerg »

same problem with Raspberry Pi OS 64bit fully patched on a pi4 w/8mb ram
Wouldn't surprise me if both machines need some sqlite3 library other than just the one I installed.
drgerg
Veteran
Posts: 61
Joined: Sun Nov 15, 2015 4:05 pm

Re: having trouble compiling: SQLite not found

Post by drgerg »

thoughts
did at apt-cache search libsqlite3 and found a reference to libsqlite3-dev
so I did a sudp apt install libsqlite3-dev and got past it on the Pi. will followup with ubuntu

Solution:
#sudo apt install libsqlite3
sudo apt install libsqlite3-dev

edit:
further testing on another rasp pi, I only needed "sudo apt instal libsqlite3-dev". I did not need the first of the two lines.
cazfi
Elite
Posts: 3335
Joined: Tue Jan 29, 2013 6:54 pm

Re: having trouble compiling: SQLite not found <solved>

Post by cazfi »

Would it be clearer if the error message said "sqlite3 development files not found", like the message is for some other dependencies?
Elefant
Hardened
Posts: 239
Joined: Sat May 28, 2022 3:55 am

Re: having trouble compiling: SQLite not found <solved>

Post by Elefant »

Maybe the error message should include the name of the apt package that needs to be installed?
Civ 3 tileset: viewtopic.php?t=92953
3d Irrlicht desktop client development: viewtopic.php?t=92289&start=20
cazfi
Elite
Posts: 3335
Joined: Tue Jan 29, 2013 6:54 pm

Re: having trouble compiling: SQLite not found <solved>

Post by cazfi »

Elefant wrote: Mon Jul 01, 2024 5:38 pm Maybe the error message should include the name of the apt package that needs to be installed?
The error message is same on all platforms, not Debian (& derivatives) specific. We can't list solution for all the different packaging systems (and package names) different distributions use.
Elefant
Hardened
Posts: 239
Joined: Sat May 28, 2022 3:55 am

Re: having trouble compiling: SQLite not found <solved>

Post by Elefant »

Ok. Your previous suggestion is a good idea, but maybe the build instructions could have a bit more information about this error? Something like "If building errors with * not found, ensure you have the development files installed and not just the runtime..." continuing with instructions for how to find the dev files for various common systems?
Civ 3 tileset: viewtopic.php?t=92953
3d Irrlicht desktop client development: viewtopic.php?t=92289&start=20
cazfi
Elite
Posts: 3335
Joined: Tue Jan 29, 2013 6:54 pm

Re: having trouble compiling: SQLite not found <solved>

Post by cazfi »

INSTALL has this:
Note that most Linux systems have separate library packages for "runtime"
library support and for development support (for compiling programs
which use those libraries). To compile Freeciv on such systems you
will need to have the appropriate "development" packages installed.
Improvements welcome.
cazfi
Elite
Posts: 3335
Joined: Tue Jan 29, 2013 6:54 pm

Re: having trouble compiling: SQLite not found <solved>

Post by cazfi »

cazfi wrote: Mon Jul 01, 2024 5:25 am Would it be clearer if the error message said "sqlite3 development files not found", like the message is for some other dependencies?
-> https://redmine.freeciv.org/issues/753
stradally
Posts: 2
Joined: Mon Dec 16, 2024 8:07 am

Re: having trouble compiling: SQLite not found <solved>

Post by stradally »

Elefant wrote: Wed Jul 03, 2024 2:50 am Ok. Your previous suggestion is a good idea, but maybe the build instructions could have a bit more information about this error? Something like "If building errors with * not found, ensure you have the development files installed and not just the runtime..." continuing with instructions for how to find the dev files for various common systems?
Updating the error message to include the missing package name and suggesting the installation of development files (e.g., sudo apt install libxyz-dev) improves usability. Additionally, build instructions should guide users in identifying and installing dev files for their system. Providing examples for common Linux distributions ensures a smoother troubleshooting process and saves time.

Edited by geometry dash 1 day ago - 8:15 PM
Post Reply