Lord Nouda

How do you access the database? I do via phpSQLiteAdmin and have no problem reading the it. No encryption, only a permission problem on some servers.

Try

https://github.com/oliviermaridat/kanboard-sqlite2mysql

or

https://github.com/huyng/database-tools/blob/master/sqlite2mysql.py

The plugin won’t run a conversion but will let you switch between MySQL and SQLite databases. There is a shell script that converts to SQLite. I haven’t tried it, though.

I created the database file with phpSQLiteAdmin and everything worked fine but one thing. I had to change the permissions of the file, such that the web server could access it.

I don’t understand. Why would you like to link to a remote database file? Don’t try it.

Anyhow, SQLite Integration uses PHP file system functions internally like opendir(), chdir(), unlink(), etc. Although those functions begin to support URL wrappers with FTP support for example, I’m sure the plugin was not intended to use that feature.

You could try two things:

1) change your code to use ftp://user:[email protected]/db.sqlite

or

2) if you’re on a linux server mount the remote folder with the database file via NFS, SSHFS or such.

Have you modified wp-config.php according to the installation instructions?

I don’t believe that you have to turn it on to make WordPress work.

However, activating the plugin adds a settings page for the plugin where you can

• read the docs
• view some system information including compatibility checks for installee plugins
• do maintenance task on the database like optimization and backup
• apply patches for incompatible plugins

It makes sense to activate the plugin.