<div dir="ltr"><div><div><div><div><div><div>Hi Mihai,<br><br></div>just for your knowledge: there is an easy way to update the database schema. The roundcube DB schema updates can be found at /usr/share/doc/roundcubemail-<version>/SQL/<br><br></div>and can be applied with a roundcube provided utility:<br><br>/usr/share/roundcubemail/bin/updatedb.sh --package=roundcube --dir=/usr/share/doc/roundcubemail-<version>/SQL/ --version=<version> (version the starting timestamp of the first .sql to apply, you have to do some research do discover it. Likely there is a clever way of discovering this, but I still have to find it).<br><br></div>For kolab and plugin DB update you can use something like<br><br>find /usr/share/roundcubemail/ -name *.sql<br><br></div>You can apply them again with the updatedb.sh utility. The contact problem, for example, is solved by the libkolab SQL schema update.<br><br></div>Best regards,<br></div>Enrico<br></div><div class="gmail_extra"><br><div class="gmail_quote">On 17 September 2014 15:58, Mihai Badici <span dir="ltr"><<a href="mailto:mihai@badici.ro" target="_blank">mihai@badici.ro</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">I moved kolab for a customer from an server to a new one.<br>
I have had the opportunity to try the new version, 3.3<br>
<br>
So I performed a clean install of 3.3 on the new server. (both servers are<br>
Debian Wheezy)<br>
<br>
The setup-kolab stoped once and failed to populate the sql database but the<br>
rest of configuration worked.<br>
I created the databases from my dump (<br>
<a href="http://mihai.badici.ro/linux/machinet/debian/kolab-3.1.sql" target="_blank">http://mihai.badici.ro/linux/machinet/debian/kolab-3.1.sql</a>) ; it worked but<br>
there are some minor changes from 3.1 to 3.3 , i added 3 or 4 fields manually;<br>
The multidomain patch from Timotheus Pokorra I used for 3.1 failed but I<br>
manage to manually adjust postfix and cyrus for multidomain.<br>
<br>
<br>
Because there are only few users, i created them again on the new server.<br>
After that I stopped postfix and cyrus and performed a rsync from the old<br>
server to the new one. ( I think is not the best ideea but is fast)<br>
<br>
After that, everything worked but I didn't see any contact.<br>
When I check folders in roundcube the content was correctly reported ( number<br>
of contacts).<br>
I created a new contact in "Personal Contacts" ( old contacts where in<br>
"Contacts") and move it in "Contacts". I think this forced an reindex (or<br>
cache expiration?) and all contacts appeared .<br>
<br>
After all it wasn't so hard :)<br>
<span class="HOEnZb"><font color="#888888"><br>
<br>
--<br>
Mihai Bădici<br>
<a href="http://mihai.badici.ro" target="_blank">http://mihai.badici.ro</a><br>
_______________________________________________<br>
users mailing list<br>
<a href="mailto:users@lists.kolab.org">users@lists.kolab.org</a><br>
<a href="https://lists.kolab.org/mailman/listinfo/users" target="_blank">https://lists.kolab.org/mailman/listinfo/users</a></font></span></blockquote></div><br></div>