[FIX] libsqlite3.dll is missing|To be added directly by TEAM

Problems with the Windows version of XAMPP, questions, comments, and anything related.

[FIX] libsqlite3.dll is missing|To be added directly by TEAM

Postby Neustradamus » 25. January 2021 07:40

Hello XAMPP Team,

When we install XAMPP and we start, error: libsqlite3.dll is missing.

After several months/years, the problem is always here in xampp-windows-x64-7.4.14-0-VC15 and other I think.

Can you solve this problem into all builds and do not remove it?
Can you fix the conf?

In \xampp\apache\conf\extra\httpd-xampp.conf

Search:
LoadModule php7_module "/xampp/php/php7apache2_4.dll"

Add after:
LoadFile "/xampp/php/libsqlite3.dll"

Thanks in advance.
Neustradamus
 
Posts: 12
Joined: 31. January 2007 22:32

Re: [FIX] libsqlite3.dll is missing|To be added directly by

Postby gonzalo » 27. January 2021 18:25

Hi Neustradamus,

Thank you for reporting this. Unfortunately, I haven't been able to reproduce your issue. Can you give us more details on this? Which filename are you using exactly? Which is your Windows version?

I tested all files from SourceForge without facing any issues starting Apache or MySQL and getting to the phpinfo page using the browser. I used Windows Server 2019 to test them
gonzalo
 
Posts: 40
Joined: 12. March 2019 08:52
XAMPP version: any
Operating System: any

Re: [FIX] libsqlite3.dll is missing|To be added directly by

Postby Neustradamus » 27. January 2021 18:57

Clean install on Windows, the \xampp\apache\conf\extra\httpd-xampp.conf has not:
- LoadFile "/xampp/php/libsqlite3.dll"

All installer must be solved.
Neustradamus
 
Posts: 12
Joined: 31. January 2007 22:32

Re: [FIX] libsqlite3.dll is missing|To be added directly by

Postby gonzalo » 28. January 2021 12:48

Hi,

According to the test I did, adding that line in the configuration was not necessary, as Apache started fine. I tested all files available in SourceForge for Windows version 7.4.14-0. Can you give us more info? We would like to reproduce the issue.
gonzalo
 
Posts: 40
Joined: 12. March 2019 08:52
XAMPP version: any
Operating System: any

Re: [FIX] libsqlite3.dll is missing|To be added directly by

Postby Neustradamus » 30. January 2021 18:57

I confirm that you must to delete all XAMPP data from you machine, install again, apache does not work, the solution is:

In \xampp\apache\conf\extra\httpd-xampp.conf

Search:
LoadModule php7_module "/xampp/php/php7apache2_4.dll"

Add after:
LoadFile "/xampp/php/libsqlite3.dll"

Thanks to solve the problem in all builds.
Neustradamus
 
Posts: 12
Joined: 31. January 2007 22:32

Re: [FIX] libsqlite3.dll is missing|To be added directly by

Postby gonzalo » 25. February 2021 13:08

Hi Neustradamus,

Sorry for the late reply. I have been trying to reproduce this issue but I couldn't. I launched a fresh new server in which no other XAMPP installation has been performed previously and starting Apache worked just fine. I also tried with a Windows 10 VM on my local computer without issues.

Just in case, can you double-check that you execute the setup_xampp.bat script before opening the control panel and trying to start the Apache process?

Can you give us any other information to try to reproduce it?
gonzalo
 
Posts: 40
Joined: 12. March 2019 08:52
XAMPP version: any
Operating System: any

Re: [FIX] libsqlite3.dll is missing|To be added directly by

Postby gsmith » 27. February 2021 08:47

Reproduce:
Load either of the php sqlite extensions.

Problem: (the web of depencies)
When I look at the php.ini files in xampp 7.3, 7.4 & 8.0 7z packages I see pdo_sqlite3 being loaded out of box.

This wasn't a problem in versions prior to 7.4 because the sqlite library was compiled into the extensions. Beginning with php 7.4 they are linking the extensions to a shared library (libsqlite3.dll) which becomes a dependency of php's. You can see the difference looking at the files sizes of the php extensions between 7.3 & 7.4.

Apache in xampp loads php as a module and like any other module in Apache (deflate, http2, lua, md, ssl, xml2enc), their dependencies need to be in Apache's bin folder, or using LoadFile, or in the system's path.
gsmith
 
Posts: 269
Joined: 29. November 2013 18:04
Location: San Diego
XAMPP version: 0.0.0
Operating System: Win 10/2012R VS 14,15,16


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 91 guests