<?xml version="1.0"?>
<feed xmlns="http://www.w3.org/2005/Atom" xml:lang="en">
	<id>https://www.heepy.net/index.php?action=history&amp;feed=atom&amp;title=Make_carddav_work_with_roundcube_1.2</id>
	<title>Make carddav work with roundcube 1.2 - Revision history</title>
	<link rel="self" type="application/atom+xml" href="https://www.heepy.net/index.php?action=history&amp;feed=atom&amp;title=Make_carddav_work_with_roundcube_1.2"/>
	<link rel="alternate" type="text/html" href="https://www.heepy.net/index.php?title=Make_carddav_work_with_roundcube_1.2&amp;action=history"/>
	<updated>2026-04-08T21:11:20Z</updated>
	<subtitle>Revision history for this page on the wiki</subtitle>
	<generator>MediaWiki 1.35.2</generator>
	<entry>
		<id>https://www.heepy.net/index.php?title=Make_carddav_work_with_roundcube_1.2&amp;diff=1403&amp;oldid=prev</id>
		<title>Morris: Created page with &quot;Install the carddav plugin: &lt;pre&gt; cd /var/lib/roundcube/plugins git clone https://github.com/blind-coder/rcmcarddav.git carddav chown -R www-data:www-data carddav &lt;/pre&gt;  Ther...&quot;</title>
		<link rel="alternate" type="text/html" href="https://www.heepy.net/index.php?title=Make_carddav_work_with_roundcube_1.2&amp;diff=1403&amp;oldid=prev"/>
		<updated>2016-08-04T00:57:48Z</updated>

		<summary type="html">&lt;p&gt;Created page with &amp;quot;Install the carddav plugin: &amp;lt;pre&amp;gt; cd /var/lib/roundcube/plugins git clone https://github.com/blind-coder/rcmcarddav.git carddav chown -R www-data:www-data carddav &amp;lt;/pre&amp;gt;  Ther...&amp;quot;&lt;/p&gt;
&lt;p&gt;&lt;b&gt;New page&lt;/b&gt;&lt;/p&gt;&lt;div&gt;Install the carddav plugin:&lt;br /&gt;
&amp;lt;pre&amp;gt;&lt;br /&gt;
cd /var/lib/roundcube/plugins&lt;br /&gt;
git clone https://github.com/blind-coder/rcmcarddav.git carddav&lt;br /&gt;
chown -R www-data:www-data carddav&lt;br /&gt;
&amp;lt;/pre&amp;gt;&lt;br /&gt;
&lt;br /&gt;
There is a bug in the db init stuff in the plugin.&lt;br /&gt;
In '''roundcube/plugins/carddav/dbmigrations/0000-dbinit/mysql.sql''',&lt;br /&gt;
in the &amp;quot;CREATE TABLE&amp;quot; for carddav_addressbooks, the field &amp;quot;last_update&amp;quot; is a&lt;br /&gt;
TIMESTAMP value but it tries to set the default to '0' which is invalid.&lt;br /&gt;
instead line 10 or thereabouts should read:&lt;br /&gt;
&amp;lt;pre&amp;gt;&lt;br /&gt;
        last_updated TIMESTAMP NOT NULL DEFAULT '1970-01-01 00:00:01', -- time stamp of the last update of the local database&lt;br /&gt;
&amp;lt;/pre&amp;gt;&lt;br /&gt;
&lt;br /&gt;
Connect to the database and drop all the '''carddav_*''' tables. They refer to each other&lt;br /&gt;
so you may need to SET FOREIGN_KEY_CHECKS=0 before dropping them.&lt;br /&gt;
&lt;br /&gt;
The plugin will try to initialize the tables the first time a user logs in, so log&lt;br /&gt;
in and wait for it to run all the dbmigration scripts.&lt;br /&gt;
&lt;br /&gt;
Once it shows your mailbox, go into settings-&amp;gt;carddav and enter a carddav account.&lt;br /&gt;
It will take a while to display the address book the first time as it has to fetch&lt;br /&gt;
all the records and populate a local cache in mysql, which gets updated at the&lt;br /&gt;
interval specified in the config.&lt;/div&gt;</summary>
		<author><name>Morris</name></author>
	</entry>
</feed>