1 Topic by dsp3

  • dsp3
  • Member
  • Offline
  • Registered: 2015-12-23
  • Posts: 104

Topic: Sogo Contacts error

==== Required information ====
- iRedMail version (check /etc/iredmail-release): 0.9.7
- Linux/BSD distribution name and version: Centos 7
- Store mail accounts in which backend (LDAP/MySQL/PGSQL): MySQL
- Web server (Apache or Nginx): Nginx
- Manage mail accounts with iRedAdmin-Pro? Pro
- [IMPORTANT] Related original log or error message is required if you're experiencing an issue.
====
I've noticed recent errors with Sogo contacts. From sogo.log

Feb 06 17:07:32 sogod [28632]: <0x0x7f7d2d080060[GCSFolder]> ERROR(-[GCSFolder writeContent:fromComponent:container:toName:baseVersion:]): cannot insert content : <MySQL4Exception: 0x7f7d2cf5e030> NAME:ExecutionFailed REASON:Unknown column 'c_hascertificate' in 'field list'
Feb 06 17:07:32 sogod [28632]: [ERROR] <0x7f7d2d024880[SOGoContactGCSEntry]:6FD4-5A79B680-1-50C19780.vcf> write failed: <MySQL4Exception: 0x7f7d2cf5e030> NAME:ExecutionFailed REASON:Unknown column 'c_hascertificate' in 'field list'

It is not possible to add new contacts.

----

Spider Email Archiver: On-Premises, lightweight email archiving software developed by iRedMail team. Supports Amazon S3 compatible storage and custom branding.

2 Reply by dsp3

  • dsp3
  • Member
  • Offline
  • Registered: 2015-12-23
  • Posts: 104

Re: Sogo Contacts error

dsp3 wrote:

Unknown column 'c_hascertificate'

Seems this error is already known
https://sogo.nu/bugs/bug_relationship_g … h=relation
As iRemail uses Sogo nightly, I think others will run into this problem

3 Reply by dsp3

  • dsp3
  • Member
  • Offline
  • Registered: 2015-12-23
  • Posts: 104

Re: Sogo Contacts error

The fix

Login to your server and create a file in /tmp

 nano sql-update-3.2.10_to_4.0.0-mysql.sh

Paste the data from github into the file
https://github.com/inverse-inc/sogo/blo … 0-mysql.sh
Save the file and make it executabe

 chmod a+x sql-update-3.2.10_to_4.0.0-mysql.sh

Execute the file

 bash sql-update-3.2.10_to_4.0.0-mysql.sh

Input the following data when promted

Username (root): sogo
Hostname (127.0.0.1): 
Database (sogo): sogo
This script will ask for the database password twice
Converting c_content from TEXT to LONGTEXT in the sogo_user_profile table
Converting c_mail from VARCHAR(255) to TEXT in Contacts quick tables
Enter password: 
Enter password:

That should be all. Delete the file you created in /tmp