<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0//EN" "http://www.w3.org/TR/REC-html40/strict.dtd">
<html><head><meta name="qrichtext" content="1" /><style type="text/css">
p, li { white-space: pre-wrap; }
</style></head><body style=" font-family:'Sans Serif'; font-size:9pt; font-weight:400; font-style:normal;">
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0;">On Wednesday, February 19, 2014 06:11:08 PM you wrote:<br /></p>
<p style=" margin-top:12px; margin-bottom:0px; margin-left:40px; margin-right:40px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0;">On Tuesday, February 18, 2014 10:46:34 AM you wrote:<br /></p>
<p style=" margin-top:12px; margin-bottom:0px; margin-left:80px; margin-right:80px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0;">https://[myserver.domain or IP]/Microsoft-Server-ActiveSync</p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:80px; margin-right:80px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0;">returns connection refused without asking for credentials</p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:80px; margin-right:80px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0;">http://[myserver.domain or IP]/Microsoft-Server-ActiveSync</p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:80px; margin-right:80px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0;">returns a blank page again without requesting authentication<br /><br />This is a new Ubuntu Server 12.04 LTS install using Kolab 3.2 from OBS <br />repositories. setup-kolab continued falling back to 127.0.0.1 on this 2nd <br />installation attempt where domain fqdn was not correct [oops], but seemed <br />to work once fqdn was corrected while first error message was still displayed <br />in setup.<br /><br />I attempted to re-initialize SQL data with mysql -p roundcube < <br />/usr/share/doc/kolab-syncroton/syncroton.sql returned no such file or <br />directory (https://kolab.org/blog/tobru/2013/03/19/kolab-3-and-activesync). When pointed from /usr/share/doc/kolab-syncroton/SQL/mysql.initial.sql (where I believe the new initialization data <br />are) it errored with 1062 (23000) at line 115 as a duplicate entry. This would seem t mean the DB is already initialized.<br /><span style=" font-size:12px; color:#1f1c1b;">I had to manually update the sql schemata:</span><span style=" font-size:12px; color:#1f1c1b; background-color:#ffffff;"><br /></span></p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0;"><span style=" font-size:12px; color:#1f1c1b;">mysql> ALTER TABLE `kolab_cache_contact` ADD `name` VARCHAR(255) NOT NULL,</span></p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0;"><span style=" font-size:12px; color:#1f1c1b;"> -> ADD `firstname` VARCHAR(255) NOT NULL,</span></p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0;"><span style=" font-size:12px; color:#1f1c1b;"> -> ADD `surname` VARCHAR(255) NOT NULL,</span></p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0;"><span style=" font-size:12px; color:#1f1c1b;"> -> ADD `email` VARCHAR(255) NOT NULL;</span><span style=" font-size:12px; color:#1f1c1b; background-color:#ffffff;"><br /></span></p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0;"><span style=" font-size:12px; color:#1f1c1b;">Without this, roundcube doesn't show contacts but logs errors:</span><span style=" font-size:12px; color:#1f1c1b; background-color:#ffffff;"><br /></span></p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0;"><span style=" font-size:12px; color:#1f1c1b;">[19-Feb-2014 18:36:35,000000 +0100]: DB Error: [1054] Unknown column 'surname' I had to manually update the sql schemata:</span><span style=" font-size:12px; color:#1f1c1b; background-color:#ffffff;"><br /></span></p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0;"><span style=" font-size:12px; color:#1f1c1b;">mysql> ALTER TABLE `kolab_cache_contact` ADD `name` VARCHAR(255) NOT NULL,</span></p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0;"><span style=" font-size:12px; color:#1f1c1b;"> -> ADD `firstname` VARCHAR(255) NOT NULL,</span></p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0;"><span style=" font-size:12px; color:#1f1c1b;"> -> ADD `surname` VARCHAR(255) NOT NULL,</span></p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0;"><span style=" font-size:12px; color:#1f1c1b;"> -> ADD `email` VARCHAR(255) NOT NULL;</span><span style=" font-size:12px; color:#1f1c1b; background-color:#ffffff;"><br /></span></p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0;"><span style=" font-size:12px; color:#1f1c1b;">Without this, roundcube doesn't show contacts but logs errors:</span><span style=" font-size:12px; color:#1f1c1b; background-color:#ffffff;"><br /></span></p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0;"><span style=" font-size:12px; color:#1f1c1b;">[19-Feb-2014 18:36:35,000000 +0100]: DB Error: [1054] Unknown column 'surname' </span></p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0;"><span style=" font-size:12px; color:#1f1c1b;">in 'order clause' (SQL Query: SELECT * FROM kolab_cache_contact WHERE </span></p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0;"><span style=" font-size:12px; color:#1f1c1b;">folder_id='11' AND `type` = 'contact' ORDER BY surname, email LIMIT 50) ...</span><span style=" font-size:12px; color:#1f1c1b; background-color:#ffffff;"><br /></span></p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0;"><span style=" font-size:12px; color:#1f1c1b;">[19-Feb-2014 18:48:52,000000 +0100]: DB Error: [1054] Unknown column 'name' in </span></p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0;"><span style=" font-size:12px; color:#1f1c1b;">'field list' (SQL Query: INSERT INTO kolab_cache_contact (folder_id, msguid, </span></p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0;"><span style=" font-size:12px; color:#1f1c1b;">uid, created, changed, data, xml, tags, words , type, name, firstname, surname, </span></p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0;"><span style=" font-size:12px; color:#1f1c1b;">email) VALUES (...)</span></p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0;"><span style=" font-size:12px; color:#1f1c1b;">in 'order clause' (SQL Query: SELECT * FROM kolab_cache_contact WHERE </span></p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0;"><span style=" font-size:12px; color:#1f1c1b;">folder_id='11' AND `type` = 'contact' ORDER BY surname, email LIMIT 50) ...</span><span style=" font-size:12px; color:#1f1c1b; background-color:#ffffff;"><br /></span></p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0;"><span style=" font-size:12px; color:#1f1c1b;">[19-Feb-2014 18:48:52,000000 +0100]: DB Error: [1054] Unknown column 'name' in </span></p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0;"><span style=" font-size:12px; color:#1f1c1b;">'field list' (SQL Query: INSERT INTO kolab_cache_contact (folder_id, msguid, </span></p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0;"><span style=" font-size:12px; color:#1f1c1b;">uid, created, changed, data, xml, tags, words , type, name, firstname, surname, </span></p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0;"><span style=" font-size:12px; color:#1f1c1b;">email) VALUES (...)</span><br />I attempted to #apt-get --reinstall install kolab-syncroton no help no errors.<br /><br />I am an integrator, not some Apache or Roundcube genius, so I could use <br />some help on this. The only other defects I have seen with the install are <br />some oddities importing contacts from vcf file through Roundcube. All other</p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:80px; margin-right:80px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0;">observed issues have been getting a newer version of Kontact <br />functional on an Ubuntu a test desktop. ln -s /etc/ssl/certs/ca ln -s /etc/ssl/certs/ca-certificates.crt domain.com.cert-certificates.crt domain.com.cert<br /><br />Should I scrap the server and reinstall kolab from scratch l or am I missing <br />something simple? ln -s /etc/ssl/certs/ca-certificates.crt domain.com.cert</p>
<p style=" margin-top:12px; margin-bottom:12px; margin-left:80px; margin-right:80px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0;">-- <br />Lyle Sharp,<br /><br />Advotech, LLC<br />1515 Shadle Rd. Poolville, Tx. 76487<br />Email: lyle.sharp@advotechllc.com<br />Web: http://www.advotechllc.com ln -s /etc/ssl/certs/ca-certificates.crt domain.com.cert<br />Phone: (817) 886-0035<br />FAX: (817) 886-2710</p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:40px; margin-right:40px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0;">Resolved SSL with:</p>
<p style="-qt-paragraph-type:empty; margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; "> </p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:40px; margin-right:40px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0;"># mkdir -p /etc/pki/tls/certs</p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:40px; margin-right:40px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0;"># mkdir -p /etc/pki/tls/private</p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:40px; margin-right:40px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0;"># ln -s /etc/ssl/certs/ca-certificates.crt domain.com.cert</p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:40px; margin-right:40px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0;"># ln -s /etc/ssl/certs/ca-certificates.crt </p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:40px; margin-right:40px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0;"># ln -s /etc/ssl/private/ssl-cert-snakeoil.key domain.com.key</p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:40px; margin-right:40px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0;"># a2enmod rewrite ssl</p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:40px; margin-right:40px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0;"># a2ensite default-ssl</p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:40px; margin-right:40px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0;"># service apache2 restart</p>
<p style="-qt-paragraph-type:empty; margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; "> </p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:40px; margin-right:40px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0;">Now https://myserver/Microsoft-Server-ActiveSync</p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:40px; margin-right:40px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0;">delivers a blank page without requesting authentication and Apache2 errors with:</p>
<p style="-qt-paragraph-type:empty; margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; "> </p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:40px; margin-right:40px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0;"><span style=" font-family:'Courier New,courier';">PHP Fatal error: Class 'Zend_Log' not found in /usr/share/kolab-syncroton/lib/kolab_sync_logger.php on line 29</span></p>
<p style="-qt-paragraph-type:empty; margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; "> </p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:40px; margin-right:40px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0;">Some help, please?<br /><br /></p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0;">I found I had this issue too and am including it here to publicly share my many issues found and resolved with Kolab 3.2 on Ubuntu 12.04 LTS:</p>
<p style="-qt-paragraph-type:empty; margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; "> </p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0;">I had to manually update the sql schemata:</p>
<p style="-qt-paragraph-type:empty; margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; "> </p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0;">mysql> ALTER TABLE `kolab_cache_contact` ADD `name` VARCHAR(255) NOT NULL,</p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0;"> -> ADD `firstname` VARCHAR(255) NOT NULL,</p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0;"> -> ADD `surname` VARCHAR(255) NOT NULL,</p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0;"> -> ADD `email` VARCHAR(255) NOT NULL;</p>
<p style="-qt-paragraph-type:empty; margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; "> </p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0;">Without this, roundcube doesn't show contacts but logs errors:</p>
<p style="-qt-paragraph-type:empty; margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; "> </p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0;">[19-Feb-2014 18:36:35,000000 +0100]: DB Error: [1054] Unknown column 'surname' </p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0;">in 'order clause' (SQL Query: SELECT * FROM kolab_cache_contact WHERE </p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0;">folder_id='11' AND `type` = 'contact' ORDER BY surname, email LIMIT 50) ...</p>
<p style="-qt-paragraph-type:empty; margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; "> </p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0;">[19-Feb-2014 18:48:52,000000 +0100]: DB Error: [1054] Unknown column 'name' in </p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0;">'field list' (SQL Query: INSERT INTO kolab_cache_contact (folder_id, msguid, </p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0;">uid, created, changed, data, xml, tags, words , type, name, firstname, surname, </p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0;">email) VALUES (...)</p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0;"><br /><br />Thank you Hede and the rest of the list users for sharing the solutions that resolved nearly every issue I encountered on this little adventure.</p>
<p style="-qt-paragraph-type:empty; margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; "> </p>
<p style="-qt-paragraph-type:empty; margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; "> </p></body></html>