Error: PDO SQLite driver is not available

Witzker · January 1, 2024, 4:49pm

Trying to finally get a working Nextcloud 18.0.1

In the logs I found:

Collectives full-text search is not operational, because the PDO SQLite driver is not available.

How to solve this?

Witzker · January 6, 2024, 11:56pm

Nothing Here!

Where can I ask?
On github?

rakekniven · January 7, 2024, 12:07am

Correct?

Did you install php-sqlite module?

Witzker · January 7, 2024, 12:21am

Many THX for taking care:

No !?
Pls tel me How-to

some of this?

rakekniven · January 7, 2024, 12:22am

This is a webserver module (extension).

Witzker · January 7, 2024, 12:24am

Ahh…
How to check?

Now I have this:

pls tell me what App’s has to be installed

and what has to be configured
many THX

rakekniven · January 7, 2024, 12:38am

I am not familiar with collectives app.

Please add all necessary information like Nextcloud version, webserver type and version, os version, related log file content.

This help other users to help you.

bb77 · January 7, 2024, 7:40am

The apps in your screenshots are meant to search through documents in the Files app. Collectives has its own (full-text) search, so you don’t need to install any additional apps to be able to search in Collectives. However, the php-sqlite module must be installed on your system in order for it to work.

See here: Nextcloud Collectives

…and here: GitHub - nextcloud/collectives: Collectives is a Nextcloud App for activist and community projects to organize together.

Witzker · January 7, 2024, 9:18am

Ahh…

THX for clearing.
But I get this:

  07/01/2024   10:11.13   /home/mobaxterm  apt install php8.1-sqlite3


DISCLAIMER:

This will download and install third-party software packages, distributed by
the Cygwin Project, from online Cygwin repositories.
These software packages are distributed under their own terms available here:
http://ctm.crouchingtigerhiddenfruitbat.org/pub/cygwin/circa/2022/07/30/123537/x86/release
Third-party software packages are neither developed nor distributed by Mobatek.
In no event shall Mobatek be liable for any direct, indirect, incidental,
special, exemplary, or consequential damages (including, but not limited to,
procurement of substitute goods or services, loss of data or profits, computer
virus infection, or business interruption) however caused and on any theory of
liability, whether in contract, strict liability, or tort (including negligence
or otherwise) arising in any way out of the use of these third-party software
packages, even if advised of the possibility of such damage.
By typing "y", you agree to use these third-party programs at your own risks.

Type "y" to continue or any other key to exit: y

Sorry, package php8.1-sqlite3 has not been found.

How to get this installed.

bb77 · January 7, 2024, 9:28am

Please tell me you are not using Cygwin to run Nextcloud on a Windows system Even if, for reasons I will never understand, you insist on using Windows to run your Nextcloud server, why not use HyperV / Windows Subsystem for Linux, which provides you with a native Linux environment?

Anyways, I never used cygwin, so I can’t really help. But you could try to find the correct package name with the apt list command:

apt list *php*sqlite*

Witzker · January 7, 2024, 10:19am

NO! - didn’t know that Nextcloud can be installed on Windows
I’m using this ISO to

Running in a ESXi VM
This is based on Debian.

Nothing happens here:

bb77 · January 7, 2024, 10:35am

I was confused by your screenshot, because Cygwin is (also) a UNIX-like command line interface for Windows. I have no idea if it’s possible to run Nextcloud with it, and honestly, I have no desire to find out

Ah ok. What’s the output of:

apt list *php* --installed

and:

apt list *php*sqlite*

Witzker · January 7, 2024, 1:36pm

THX for taking care
This output is from:

It was recommended to me as a beginner to use instead of putty!
What do you think?

root@nextcloud ~# apt list *php* --installed
Listing... Done
libapache2-mod-php8.1/now 8.1.17-1+0~20230316.37+debian11~1.gbp0c3ecb amd64 [installed,upgradable to: 8.1.27-1+0~20231221.58+debian11~1.gbp3895b2]
php-common/now 2:93+0~20221211.45+debian11~1.gbpdb4dcc all [installed,upgradable to: 2:93+0~20231125.47+debian11~1.gbpc7171d]
php-mysql/now 2:8.1 all [installed,local]
php-pear/now 1:1.10.13+submodules+notgz+2022032202-2+0~20221209.38+debian11~1.gbpfd4c1d all [installed,upgradable to: 1:1.10.13+submodules+notgz+2022032202-2+0~20230612.39+debian11~1.gbpfd4c1d]
php8.1-bcmath/now 8.1.17-1+0~20230316.37+debian11~1.gbp0c3ecb amd64 [installed,upgradable to: 8.1.27-1+0~20231221.58+debian11~1.gbp3895b2]
php8.1-cli/now 8.1.17-1+0~20230316.37+debian11~1.gbp0c3ecb amd64 [installed,upgradable to: 8.1.27-1+0~20231221.58+debian11~1.gbp3895b2]
php8.1-common/now 8.1.17-1+0~20230316.37+debian11~1.gbp0c3ecb amd64 [installed,upgradable to: 8.1.27-1+0~20231221.58+debian11~1.gbp3895b2]
php8.1-curl/now 8.1.17-1+0~20230316.37+debian11~1.gbp0c3ecb amd64 [installed,upgradable to: 8.1.27-1+0~20231221.58+debian11~1.gbp3895b2]
php8.1-gd/now 8.1.17-1+0~20230316.37+debian11~1.gbp0c3ecb amd64 [installed,upgradable to: 8.1.27-1+0~20231221.58+debian11~1.gbp3895b2]
php8.1-gmp/now 8.1.17-1+0~20230316.37+debian11~1.gbp0c3ecb amd64 [installed,upgradable to: 8.1.27-1+0~20231221.58+debian11~1.gbp3895b2]
php8.1-igbinary/now 3.2.13-1+0~20230207.37+debian11~1.gbp76ad09 amd64 [installed,upgradable to: 3.2.15-1+0~20231202.49+debian11~1.gbpe9ffe8]
php8.1-imagick/now 3.7.0-3+0~20221209.38+debian11~1.gbp8a8977 amd64 [installed,upgradable to: 3.7.0-4+0~20231125.43+debian11~1.gbpbf7e27]
php8.1-imap/now 8.1.17-1+0~20230316.37+debian11~1.gbp0c3ecb amd64 [installed,upgradable to: 8.1.27-1+0~20231221.58+debian11~1.gbp3895b2]
php8.1-intl/now 8.1.17-1+0~20230316.37+debian11~1.gbp0c3ecb amd64 [installed,upgradable to: 8.1.27-1+0~20231221.58+debian11~1.gbp3895b2]
php8.1-ldap/now 8.1.17-1+0~20230316.37+debian11~1.gbp0c3ecb amd64 [installed,upgradable to: 8.1.27-1+0~20231221.58+debian11~1.gbp3895b2]
php8.1-mbstring/now 8.1.17-1+0~20230316.37+debian11~1.gbp0c3ecb amd64 [installed,upgradable to: 8.1.27-1+0~20231221.58+debian11~1.gbp3895b2]
php8.1-mysql/now 8.1.17-1+0~20230316.37+debian11~1.gbp0c3ecb amd64 [installed,upgradable to: 8.1.27-1+0~20231221.58+debian11~1.gbp3895b2]
php8.1-opcache/now 8.1.17-1+0~20230316.37+debian11~1.gbp0c3ecb amd64 [installed,upgradable to: 8.1.27-1+0~20231221.58+debian11~1.gbp3895b2]
php8.1-readline/now 8.1.17-1+0~20230316.37+debian11~1.gbp0c3ecb amd64 [installed,upgradable to: 8.1.27-1+0~20231221.58+debian11~1.gbp3895b2]
php8.1-redis/now 5.3.7+4.3.0-2+0~20221210.45+debian11~1.gbp99917f amd64 [installed,upgradable to: 6.0.2-1+0~20231128.56+debian11~1.gbp9f3071]
php8.1-xml/now 8.1.17-1+0~20230316.37+debian11~1.gbp0c3ecb amd64 [installed,upgradable to: 8.1.27-1+0~20231221.58+debian11~1.gbp3895b2]
php8.1-zip/now 8.1.17-1+0~20230316.37+debian11~1.gbp0c3ecb amd64 [installed,upgradable to: 8.1.27-1+0~20231221.58+debian11~1.gbp3895b2]
webmin-phpini/bullseye,now 2.001-turnkey+0 all [installed]
root@nextcloud ~#

root@nextcloud ~# apt list *php*sqlite*
Listing... Done
php-sqlite3/oldstable 2:7.4+76 all
php5.6-sqlite3-dbgsym/bullseye 5.6.40-68+0~20230902.80+debian11~1.gbpa2012b amd64
php5.6-sqlite3/bullseye 5.6.40-68+0~20230902.80+debian11~1.gbpa2012b amd64
php7.0-sqlite3-dbgsym/bullseye 7.0.33-68+0~20230905.83+debian11~1.gbp571a08 amd64
php7.0-sqlite3/bullseye 7.0.33-68+0~20230905.83+debian11~1.gbp571a08 amd64
php7.1-sqlite3-dbgsym/bullseye 7.1.33-56+0~20230904.88+debian11~1.gbp4cb5d3 amd64
php7.1-sqlite3/bullseye 7.1.33-56+0~20230904.88+debian11~1.gbp4cb5d3 amd64
php7.2-sqlite3-dbgsym/bullseye 7.2.34-43+0~20230902.90+debian11~1.gbpc2a431 amd64
php7.2-sqlite3/bullseye 7.2.34-43+0~20230902.90+debian11~1.gbpc2a431 amd64
php7.3-sqlite3-dbgsym/bullseye 7.3.33-14+0~20230902.114+debian11~1.gbp764b27 amd64
php7.3-sqlite3/bullseye 7.3.33-14+0~20230902.114+debian11~1.gbp764b27 amd64
php7.4-sqlite3-dbgsym/bullseye 1:7.4.33-8+0~20230904.88+debian11~1.gbp87c414 amd64
php7.4-sqlite3/oldstable-security,oldstable 7.4.33-1+deb11u4 amd64
php8.0-sqlite3-dbgsym/bullseye 1:8.0.30-2+0~20230904.59+debian11~1.gbp806e95 amd64
php8.0-sqlite3/bullseye 1:8.0.30-2+0~20230904.59+debian11~1.gbp806e95 amd64
php8.1-sqlite3-dbgsym/bullseye 8.1.27-1+0~20231221.58+debian11~1.gbp3895b2 amd64
php8.1-sqlite3/bullseye 8.1.27-1+0~20231221.58+debian11~1.gbp3895b2 amd64
php8.2-sqlite3-dbgsym/bullseye 8.2.14-1+0~20231221.38+debian11~1.gbp698136 amd64
php8.2-sqlite3/bullseye 8.2.14-1+0~20231221.38+debian11~1.gbp698136 amd64
php8.3-sqlite3-dbgsym/bullseye 8.3.1-1+0~20231221.15+debian11~1.gbp28f2f4 amd64
php8.3-sqlite3/bullseye 8.3.1-1+0~20231221.15+debian11~1.gbp28f2f4 amd64
root@nextcloud ~#

bb77 · January 7, 2024, 2:06pm

Is it possible that you wern’t actually connected to your Nextcloud server, when you ran the command? Maybe that was also the reason why you got the Cygwin third party repo warning when you first tried it…

Now that you’re apperantly connected to your server, try again to run:

apt install php8.1-sqlite3

Sorry, I’ve been mainly a Linux user for many years now, so I have no idea what the best Windows SSH clients and terminal emulators are. However, since OpenSSH is officially available for Windows, I would probably just use that in Powershell: Get started with OpenSSH for Windows | Microsoft Learn

ernolf · January 7, 2024, 2:58pm

You are using it completely wrong!

Please start reading manuals instead of doing and doing without using your head!

You must create the ssh session within your MobaXterm. When you open MobaXterm, you only get a terminal at your windows host! That is not what you want!

You have to create a ssh session to your machine:

then you get a remote shell on your remote host.

Read the help and the manual pages!!!

Much luck,
ernolf

Witzker · January 7, 2024, 5:06pm

THX to join me in this “new for me Journey”
I got This:

root@nextcloud ~# apt install php8.1-sqlite3
Reading package lists... Done
Building dependency tree... Done
Reading state information... Done
The following packages were automatically installed and are no longer required:
  linux-image-5.10.0-21-amd64 linux-image-5.10.0-23-amd64
Use 'apt autoremove' to remove them.
The following additional packages will be installed:
  libapache2-mod-php8.1 php8.1-bcmath php8.1-cli php8.1-common php8.1-curl php8.1-gd php8.1-gmp php8.1-imap php8.1-intl php8.1-ldap php8.1-mbstring php8.1-mysql php8.1-opcache php8.1-readline
  php8.1-xml php8.1-zip
The following NEW packages will be installed:
  php8.1-sqlite3
The following packages will be upgraded:
  libapache2-mod-php8.1 php8.1-bcmath php8.1-cli php8.1-common php8.1-curl php8.1-gd php8.1-gmp php8.1-imap php8.1-intl php8.1-ldap php8.1-mbstring php8.1-mysql php8.1-opcache php8.1-readline
  php8.1-xml php8.1-zip
16 upgraded, 1 newly installed, 0 to remove and 58 not upgraded.
Need to get 5282 kB of archives.
After this operation, 175 kB of additional disk space will be used.
Do you want to continue? [Y/n] y

Do I want to continue?
I think Yes?!

What else should be done her?

bb77 · January 7, 2024, 5:20pm

Really?!?!

Sorry but I’m actually starting to doubt whether you should host your own Nextcloud server in the first place.

The following points are the bare minimum you need to be familiar with to even think about running Nextcloud on your own server:

How do I connect to my Linux server via SSH
How do I navigate the file system on my Linux server
How do I edit config files on my Linux server
How does the package manager work on my Linux server

Or do you really want to open a forum post for every click you’re supposed to do and every simple Y/N question your operating system asks you?