Koozali.org: home of the SME Server

Obsolete Releases => SME 9.x Contribs => Topic started by: calisun on December 29, 2020, 10:32:32 PM

Title: SQLite extension: Not Installed
Post by: calisun on December 29, 2020, 10:32:32 PM

I am trying to install an app in the iBay and I got a message that:
SQLite extension:   Not Installed

so I did:

Code: [Select]

yum -y install sqlite-devel
After I reconfigured and restarted the system, I still get the message:
SQLite extension:   Not Installed

What did I miss?

Title: Re: SQLite extension: Not Installed
Post by: mmccarn on December 30, 2020, 12:52:06 PM

I think what's missing is not sqlite itself but the php extension for sqlite.

Getting the php extension will depend on the version of php running in the ibay.

In an ibay of mine running php7.3, the 'sqlite3.so' extension came from 'php73-php-pdo'.

sqlite3.so for the SME-native php5.3 looks like it comes from 'php-pdo'.

Title: Re: SQLite extension: Not Installed
Post by: calisun on January 01, 2021, 08:54:35 PM

Thank you mmccarn for your reply.
I am using php7.3

Would you be able to explain how you got php extension for sqlite?

Title: Re: SQLite extension: Not Installed
Post by: mmccarn on January 01, 2021, 09:31:35 PM

Assuming you have the Remi-safe repository (https://wiki.contribs.org/Remi-safe) configured and enabled, you would use

Code: [Select]

yum install php73-php-pdo


Title: Re: SQLite extension: Not Installed
Post by: calisun on January 01, 2021, 11:29:11 PM

Looks like I already have it installed
While running above mentioned code, I see:

Quote

Package php73-php-pdo-7.3.25-1.el6.remi.x86_64 already installed and latest version
Nothing to do

So since I have already installed sqlite (as described in first post)
and since system tells me that php sqlite extension is installed,
what else could it be since I am still getting message:
SQLite extension:   Not Installed

---update------
I thought that default PHP install might be having an effect, so I tried installing extension for default PHP
so I did:

Code: [Select]

yum install php-pdobut no luck, I got a message:

Quote

Package php-pdo-5.3.3-50.el6_10.x86_64 already installed and latest version
Nothing to do

So hunt continues, any ideas?

Title: Re: SQLite extension: Not Installed
Post by: calisun on January 02, 2021, 02:33:04 AM

Another test, to make sure that the issue is not caused by PHP Software collections, I have disabled PHP Software collections for that iBay.
The installer confirmed that the default PHP is active and does not complain about old version, but it still complains:

Quote

PHP Version:   5.3.3
SQLite extension:   Not Installed

Title: Re: SQLite extension: Not Installed
Post by: ReetP on January 02, 2021, 11:47:52 AM

Probably needs loading via the php config.

You'll need a custom template.

Title: Re: SQLite extension: Not Installed
Post by: mmccarn on January 02, 2021, 02:56:00 PM

What is the app that you are trying to install?


On my system, phpinfo() reports that sqlite 3.7.17 is enabled on an uncustomized ibay running php73, based on the default content of /etc/opt/remi/php73/php.d/30-pdo_sqlite.ini.

Quote from: /etc/opt/remi/php73/php.d/30-pdo_sqlite.ini

; Enable pdo_sqlite extension module
extension=pdo_sqlite

Title: Re: SQLite extension: Not Installed
Post by: ReetP on January 02, 2021, 05:22:46 PM

:thumbsup:

Must be installed with the plugin then.