kolab-syncroton - no SSL connection

Thu Feb 20 18:59:11 CET 2014

On Wednesday, February 19, 2014 06:11:08 PM you wrote:

On Tuesday, February 18, 2014 10:46:34 AM you wrote:

https://[myserver.domain or IP]/Microsoft-Server-ActiveSync

returns connection refused without asking for credentials

http://[myserver.domain or IP]/Microsoft-Server-ActiveSync

returns a blank page again without requesting authentication

This is a new Ubuntu Server 12.04 LTS install using Kolab 3.2 from OBS 
repositories. setup-kolab continued falling back to 127.0.0.1 on this 2nd 
installation attempt where domain fqdn was not correct [oops], but seemed 
to work once fqdn was corrected while first error message was still displayed 
in setup.

I attempted to re-initialize SQL data with mysql -p roundcube < 
/usr/share/doc/kolab-syncroton/syncroton.sql returned no such file or 
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 
are) it errored with 1062 (23000) at line 115 as a duplicate entry. This would seem t mean the DB is already initialized.
I had to manually update the sql schemata:

mysql> ALTER TABLE `kolab_cache_contact` ADD `name` VARCHAR(255) NOT NULL,

    ->   ADD `firstname` VARCHAR(255) NOT NULL,

    ->   ADD `surname` VARCHAR(255) NOT NULL,

    ->   ADD `email` VARCHAR(255) NOT NULL;

Without this, roundcube doesn't show contacts but logs errors:

[19-Feb-2014 18:36:35,000000 +0100]: DB Error: [1054] Unknown column 'surname' I had to manually update the sql schemata:

mysql> ALTER TABLE `kolab_cache_contact` ADD `name` VARCHAR(255) NOT NULL,

    ->   ADD `firstname` VARCHAR(255) NOT NULL,

    ->   ADD `surname` VARCHAR(255) NOT NULL,

    ->   ADD `email` VARCHAR(255) NOT NULL;

Without this, roundcube doesn't show contacts but logs errors:

[19-Feb-2014 18:36:35,000000 +0100]: DB Error: [1054] Unknown column 'surname' 

in 'order clause' (SQL Query: SELECT * FROM kolab_cache_contact WHERE 

folder_id='11'  AND `type` = 'contact' ORDER BY surname, email LIMIT 50) ...

[19-Feb-2014 18:48:52,000000 +0100]: DB Error: [1054] Unknown column 'name' in 

'field list' (SQL Query: INSERT INTO kolab_cache_contact  (folder_id, msguid, 

uid, created, changed, data, xml, tags, words , type, name, firstname, surname, 

email) VALUES (...)

in 'order clause' (SQL Query: SELECT * FROM kolab_cache_contact WHERE 

folder_id='11'  AND `type` = 'contact' ORDER BY surname, email LIMIT 50) ...

[19-Feb-2014 18:48:52,000000 +0100]: DB Error: [1054] Unknown column 'name' in 

'field list' (SQL Query: INSERT INTO kolab_cache_contact  (folder_id, msguid, 

uid, created, changed, data, xml, tags, words , type, name, firstname, surname, 

email) VALUES (...)
I attempted to #apt-get --reinstall install kolab-syncroton no help no errors.

I am an integrator, not some Apache or Roundcube genius, so I could use 
some help on this. The only other defects I have seen with the install are 
some oddities importing contacts from vcf file through Roundcube. All other

observed issues have been getting a newer version of Kontact 
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

Should I scrap the server and reinstall kolab from scratch l or am I missing 
something simple? ln -s /etc/ssl/certs/ca-certificates.crt domain.com.cert

-- 
Lyle Sharp,

Advotech, LLC
1515 Shadle Rd. Poolville, Tx. 76487
Email: lyle.sharp at advotechllc.com
Web: http://www.advotechllc.com ln -s /etc/ssl/certs/ca-certificates.crt domain.com.cert
Phone: (817) 886-0035
FAX: (817) 886-2710

Resolved SSL with:

# mkdir -p /etc/pki/tls/certs

# mkdir -p /etc/pki/tls/private

# ln -s /etc/ssl/certs/ca-certificates.crt domain.com.cert

# ln -s /etc/ssl/certs/ca-certificates.crt 

# ln -s /etc/ssl/private/ssl-cert-snakeoil.key domain.com.key

# a2enmod rewrite ssl

# a2ensite default-ssl

# service apache2 restart

Now https://myserver/Microsoft-Server-ActiveSync

delivers a blank page without requesting authentication and Apache2 errors with:

PHP Fatal error: Class 'Zend_Log' not found in /usr/share/kolab-syncroton/lib/kolab_sync_logger.php on line 29

Some help, please?

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:

I had to manually update the sql schemata:

mysql> ALTER TABLE `kolab_cache_contact` ADD `name` VARCHAR(255) NOT NULL,

-> ADD `firstname` VARCHAR(255) NOT NULL,

-> ADD `surname` VARCHAR(255) NOT NULL,

-> ADD `email` VARCHAR(255) NOT NULL;

Without this, roundcube doesn't show contacts but logs errors:

[19-Feb-2014 18:36:35,000000 +0100]: DB Error: [1054] Unknown column 'surname' 

in 'order clause' (SQL Query: SELECT * FROM kolab_cache_contact WHERE 

folder_id='11' AND `type` = 'contact' ORDER BY surname, email LIMIT 50) ...

[19-Feb-2014 18:48:52,000000 +0100]: DB Error: [1054] Unknown column 'name' in 

'field list' (SQL Query: INSERT INTO kolab_cache_contact (folder_id, msguid, 

uid, created, changed, data, xml, tags, words , type, name, firstname, surname, 

email) VALUES (...)

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.

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.kolab.org/pipermail/users/attachments/20140220/a057706b/attachment.html>