Metadata.db can't be found

[nchcalvin]

Nice to meet you all. COPS is a great add-on for my synology nas. COPS works well before I update the MariaDB and COPS (update form SynoCommunity) . One day, when I update the MariaDB and COPS, the COPS show me that the metadata.db cannot be found. I have tried to modify the permission of metadata.db to 'http' group, but the problem is still here. How should I fix this problem. Please help

The detail of my setting are as follow:

1. The permission of metadata.db is 'http'.
2. The open_basedir path has been added and it is right.
3. The metadata.db path of 'config_local.php ' is consistent with open_basedir.
4. The location of metadata.db is '/volume1/Books/metadata.db'
5. The Web Station and php services has been launched.
6. Synology Model DS 713+ (DSM 5.0-4482)

Thank you very much!!

[vlad59]

Does the directory containing your metadata.db also have the http permission ?

[nchcalvin]

Originally Posted by vlad59

Does the directory containing your metadata.db also have the http permission ?

Thank you for your reply. I have also modified the permission of the directory (volume1/Books) that open all of permission to "user", "administrator" and "http" group. The problem is still here.

COPS CONFIGURATION CHECK

You've been redirected because COPS is not configured properly
Database error

Check if GD is properly installed and loaded
OK

Check if Sqlite is properly installed and loaded
OK

Check if libxml is properly installed and loaded
OK

Check if the rendering will be done on client side or server side
Client side rendering

Check if Calibre database path is not an URL
OK

Check if Calibre database file exists and is readable
File /volume1/Books/metadata.db not found, Please check

Value of $config['calibre_directory'] in config_local.php Value of
open_basedir
in your php.ini The access rights of the Calibre Database Synology users please read
this

[nzrunner]

I am encountering exactly the same issue. Any resolution?

[vlad59]

Can you both tell me your exact open_basedir ?

[nchcalvin]

Originally Posted by vlad59

Can you both tell me your exact open_basedir ?

open_basedir:

/etc.defaults:/etc:/usr/syno/synoman:/tmp:/var/services/tmp:/var/services/web:/var/services/homes:/volume1/Books/


Thanks!

[redlob]

Same problem here after upgrade to the latest COPS package on DSM 4.3

Thanks!

[vlad59]

That's really strange could you try to see if https://github.com/seblucas/cops/issues/157 helps ?

[redlob]

there is no /etc/php/conf.d/com.synocommunity.packages.cops.ini on my Synology. Maybe it's a DSM 5.0 only thing?

[nchcalvin]

Originally Posted by vlad59

That's really strange could you try to see if https://github.com/seblucas/cops/issues/157 helps ?

The problem still here. I has modified both "/etc/php/conf.d/com.synologycommunity.packages.cops.ini" and "/etc.default/php/conf.d/user-setting.ini"

Error message from COPS
Check if Calibre database file exists and is readable
File /volume1/Books/metadata.db not found, Please check

The open_dir setting has been detected by COPS, but it seem to be that the metadata.db cannot be found.

[nchcalvin]

Originally Posted by redlob

there is no /etc/php/conf.d/com.synocommunity.packages.cops.ini on my Synology. Maybe it's a DSM 5.0 only thing?

You have to login root ac via telnet or ssh

[redlob]

Lol, yes I know that /etc/php doesn't even exist on my box....

[nchcalvin]

Hey guys, I have fixed this problem. This problem seem to be caused by MariaDB. Please try to update the newest version of MariaDB and DSM (DSM 5.0-4993 Update 2).

[redlob]

But MariaDB is DSM5.0 only right? It's still an issue on my DSM 4.3 box.

[nchcalvin]

Originally Posted by redlob

But MariaDB is DSM5.0 only right? It's still an issue on my DSM 4.3 box.

Did you install the MariaDB addon? If you did, you should have received the update message of MariaDB recently.