How to salvage calendar data from a failing owncloud installation

Server
1

Hi,

I am trying to rescue calendar data from a failing owncloud installation (v.9.1.0-1) on a small SOC system running arch linux.

I can no longer access the web interface of owncloud, caldav access also gives errors.

Logs (/var/log/httpd/owncloud.foo.info-error_log) are filled with errors like the following:

PHP Fatal error: Uncaught Doctrine\DBAL\DBALException: Failed to connect to the database: An exception occured in driver: SQLSTATE[HY000] [2002] No such file or directory in /usr/share/webapps/owncloud/lib/private/DB/Connection.php:58\nStack trace:\n#0 /usr/share/webapps/owncloud/3rdparty/doctrine /dbal/lib/Doctrine/DBAL/Connection.php(429): OC\DB\Connection->connect()\n#1 /usr/share/webapps/owncloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(389): Doctrine\DBAL\Conne ction->getDatabasePlatformVersion()\n#2 /usr/share/webapps/owncloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(328): Doctrine\DBAL\Connection->detectDatabasePlatform()\n#3 /us r/share/webapps/owncloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(621): Doctrine\DBAL\Connection->getDatabasePlatform()\n#4 /usr/share/webapps/owncloud/lib/private/DB/Connec tion.php(141): Doctrine\DBAL\Connection->setTransactionIsolation(2)\n#5 /usr/share/webapps/owncloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/DriverManager.php(172): OC\DB\Connection->__c on in /usr/share/webapps/owncloud/lib/private/DB/Connection.php on line 58

But I still can ssh into the machine: what would I have to backup, where exactly is the calendar data stored; is it possible to export it to ics files?

thanks for any help / ideas

Sur

2

Have a look at calcardbackup. It can do, what you are looking for:

2 Likes
3

Hi Bernie,

that worked just wonderful! Thanks a lot.
With only minimal options, didn’t go further than “Schnellinstallation”; tried to locate directory by

find / -iname owncloud

and chose from the results

/usr/share/webapps/owncloud

The user on my owncloud Server 9.1.0.15 was simply “http”, so command line was

sudo -u http ./calcardbackup “/usr/share/webapps/owncloud” -o /tmp

and with this little info, the script worked like a charm!

Thanks again and I shall certainly donate!

Sur.

3 Likes
5

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.