1 Topic by christophk

  • christophk
  • Member
  • Offline
  • Registered: 2016-05-23
  • Posts: 54

Topic: Contacts don't sync and don't show up on Webbrowser

==== Required information ====
- iRedMail version (check /etc/iredmail-release): 0.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? no
- [IMPORTANT] Related original log or error message is required if you're experiencing an issue.
======== Required information ====
- iRedMail version (check /etc/iredmail-release):
- Linux/BSD distribution name and version:
- Store mail accounts in which backend (LDAP/MySQL/PGSQL):
- Web server (Apache or Nginx):
- Manage mail accounts with iRedAdmin-Pro?
- [IMPORTANT] Related original log or error message is required if you're experiencing an issue.
====

Hi, the contacts don't sync anymore from my iOS device.

When I am opening the web interface with SOGo, then the contacts don't load but they constantly have a "loading bar" without any results.

See attached picture.

What could be going on?

Greetings, Chris

Post's attachments

Screen Shot 2018-04-05 at 15.41.53.png 37.36 kb, file has never been downloaded. 

You don't have the permssions to download the attachments of this post.

----

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

2 Reply by ZhangHuangbin

  • ZhangHuangbin
  • ZhangHuangbin
  • iRedMail Developers
  • Offline
  • Registered: 2009-05-06
  • Posts: 30,792

Re: Contacts don't sync and don't show up on Webbrowser

Did you update SOGo package?

3 Reply by christophk

  • christophk
  • Member
  • Offline
  • Registered: 2016-05-23
  • Posts: 54

Re: Contacts don't sync and don't show up on Webbrowser

ZhangHuangbin wrote:

Did you update SOGo package?

I do "yum update" frequently.

The version that is shown in the SOGo Webinterface is 3.2.10

But I see that there is a SOGo 4.0.0!

Is there a tutorial how to update to that?

4 Reply by ZhangHuangbin

  • ZhangHuangbin
  • ZhangHuangbin
  • iRedMail Developers
  • Offline
  • Registered: 2009-05-06
  • Posts: 30,792

Re: Contacts don't sync and don't show up on Webbrowser

Upgrade tutorial:
https://docs.iredmail.org/upgrade.sogo.3.to.4.html

5 Reply by christophk

  • christophk
  • Member
  • Offline
  • Registered: 2016-05-23
  • Posts: 54

Re: Contacts don't sync and don't show up on Webbrowser

Thanks for that!

There is no backup_sogo.sh

Is that a problem?

[root@office ck]# bash /var/vmail/backup/backup_sogo.sh
bash: /var/vmail/backup/backup_sogo.sh: No such file or directory

[root@office ck]# ls -l /var/vmail/backup
total 8
-rwx------ 1 root root 7531 Nov 29  2016 backup_mysql.sh
drwxr-xr-x 5 root root   55 Jan  1 03:30 mysql

6 Reply by christophk

  • christophk
  • Member
  • Offline
  • Registered: 2016-05-23
  • Posts: 54

Re: Contacts don't sync and don't show up on Webbrowser

ZhangHuangbin wrote:

Upgrade tutorial:
https://docs.iredmail.org/upgrade.sogo.3.to.4.html


Thanks for that.

I did the update and restarted the sogo service.

On the website it still says Sogo 3.2.10 though.

Might be a cache thing.

7 Reply by christophk

  • christophk
  • Member
  • Offline
  • Registered: 2016-05-23
  • Posts: 54

Re: Contacts don't sync and don't show up on Webbrowser

ZhangHuangbin wrote:

Upgrade tutorial:
https://docs.iredmail.org/upgrade.sogo.3.to.4.html


Hi
I did the update and I rebooted the entire server of us but the number is still 3.2.10. In the web interface.

8 Reply by christophk (edited by christophk 2018-04-06 01:11:43)

  • christophk
  • Member
  • Offline
  • Registered: 2016-05-23
  • Posts: 54

Re: Contacts don't sync and don't show up on Webbrowser

ZhangHuangbin wrote:

Upgrade tutorial:
https://docs.iredmail.org/upgrade.sogo.3.to.4.html

The manual states to run this script

<bash /usr/share/doc/sogo-4.*/sql-update-3.2.10_to_4.0.0-mysql.sh

But the folder sogo4.* is not in the folder /usr/share/doc/:

< [ck@office]/usr/share/doc% ls -l
< total 336
< ...
< drwxr-xr-x. 2 root root    42 Dec 14  2016 shadow-utils-4.1.5.1
< drwxr-xr-x  2 root root    96 Sep 14  2017 shared-mime-info-1.8
< drwxr-xr-x. 2 root root  4096 Nov 29  2016 slang-2.2.4
< drwxr-xr-x. 2 root root    98 Nov 29  2016 snappy-1.1.0
< drwxr-xr-x  2 root root  4096 Feb 26 03:34 sogo-3.2.10.20180225
< drwxr-xr-x  2 root root    33 Feb 26 03:34 sogo-activesync-3.2.10.20180225
< drwxr-xr-x  2 root root    60 Nov 25 09:25 soxr-0.1.2
< drwxr-xr-x  2 root root  4096 Nov 29  2016 spamassassin-3.4.0
< ...

So something is wrong.

9 Reply by hws (edited by hws 2018-04-06 02:01:28)

  • hws
  • Member
  • Offline
  • Registered: 2017-01-19
  • Posts: 43

Re: Contacts don't sync and don't show up on Webbrowser

Since I did the upgrade myself I had the same problem. Using "yum sogo* sope*" unfortunately does not update the 4 sogo packages. I had to update the 4 sogo packages manually using "yum update sogo-activesync sogo-tool sogo sogo-ealarms-notify sope*" to get it done.

After you have updated to Sogo 4.0.0 you will have the database update script at your server.

Regarding the Sogo-Database Backup script: This needs to be installed as per the instructions seen in the iRedmail 0.9.7 update guide.

10 Reply by christophk

  • christophk
  • Member
  • Offline
  • Registered: 2016-05-23
  • Posts: 54

Re: Contacts don't sync and don't show up on Webbrowser

hws wrote:

Since I did the upgrade myself I had the same problem. Using "yum sogo* sope*" unfortunately does not update the 4 sogo packages. I had to update the 4 sogo packages manually using "yum update sogo-activesync sogo-tool sogo sogo-ealarms-notify sope*" to get it done.

After you have updated to Sogo 4.0.0 you will have the database update script at your server.

Regarding the Sogo-Database Backup script: This needs to be installed as per the instructions seen in the iRedmail 0.9.7 update guide.

Awesome hws!

Thanks a lot.

The Sogo update to 4.0.0 worked now.

I just got these error messages:

[root@office doc]# bash /usr/share/doc/sogo-4.*/sql-update-3.2.10_to_4.0.0-mysql.sh
Username (ck): root
Hostname (127.0.0.1):
Database (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:
ERROR 1060 (42S21) at line 1: Duplicate column name 'c_hascertificate'
ERROR 1060 (42S21) at line 1: Duplicate column name 'c_hascertificate'
ERROR 1060 (42S21) at line 1: Duplicate column name 'c_hascertificate'

11 Reply by hws

  • hws
  • Member
  • Offline
  • Registered: 2017-01-19
  • Posts: 43

Re: Contacts don't sync and don't show up on Webbrowser

christophk wrote:

I just got these error messages:

[root@office doc]# bash /usr/share/doc/sogo-4.*/sql-update-3.2.10_to_4.0.0-mysql.sh
Username (ck): root
Hostname (127.0.0.1):
Database (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:
ERROR 1060 (42S21) at line 1: Duplicate column name 'c_hascertificate'
ERROR 1060 (42S21) at line 1: Duplicate column name 'c_hascertificate'
ERROR 1060 (42S21) at line 1: Duplicate column name 'c_hascertificate'

Same with my update.

I had to run

% bash /usr/share/doc/sogo-4.*/sql-update-3.0.0-to-combined-mysql.sh

first and then

% bash /usr/share/doc/sogo-4.*/sql-update-3.2.10_to_4.0.0-mysql.sh

again.

12 Reply by ZhangHuangbin

  • ZhangHuangbin
  • ZhangHuangbin
  • iRedMail Developers
  • Offline
  • Registered: 2009-05-06
  • Posts: 30,792

Re: Contacts don't sync and don't show up on Webbrowser

i'm confused. Is it working now?

13 Reply by christophk

  • christophk
  • Member
  • Offline
  • Registered: 2016-05-23
  • Posts: 54

Re: Contacts don't sync and don't show up on Webbrowser

I have not done the last tip from hws because I was unsure what it does and if I should do it.

The initial problem is still not solved:

I made a new contact on my Macbook and on my iPhone, but they do not sync.

14 Reply by christophk

  • christophk
  • Member
  • Offline
  • Registered: 2016-05-23
  • Posts: 54

Re: Contacts don't sync and don't show up on Webbrowser

hws wrote:

Same with my update.

I had to run

% bash /usr/share/doc/sogo-4.*/sql-update-3.0.0-to-combined-mysql.sh

first and then

% bash /usr/share/doc/sogo-4.*/sql-update-3.2.10_to_4.0.0-mysql.sh

again.

When I ran command

% bash /usr/share/doc/sogo-4.*/sql-update-3.0.0-to-combined-mysql.sh

Then this message scared mew away:

[root@office ck]# bash /usr/share/doc/sogo-4.*/sql-update-3.2.10_to_4.0.0-mysql.sh
Username (ck): root
Hostname (127.0.0.1):
Database (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:
ERROR 1060 (42S21) at line 1: Duplicate column name 'c_hascertificate'
ERROR 1060 (42S21) at line 1: Duplicate column name 'c_hascertificate'
ERROR 1060 (42S21) at line 1: Duplicate column name 'c_hascertificate'
ERROR 1060 (42S21) at line 1: Duplicate column name 'c_hascertificate'
ERROR 1060 (42S21) at line 1: Duplicate column name 'c_hascertificate'
ERROR 1060 (42S21) at line 1: Duplicate column name 'c_hascertificate'
ERROR 1060 (42S21) at line 1: Duplicate column name 'c_hascertificate'
ERROR 1060 (42S21) at line 1: Duplicate column name 'c_hascertificate'
ERROR 1060 (42S21) at line 1: Duplicate column name 'c_hascertificate'
ERROR 1060 (42S21) at line 1: Duplicate column name 'c_hascertificate'
ERROR 1060 (42S21) at line 1: Duplicate column name 'c_hascertificate'
ERROR 1060 (42S21) at line 1: Duplicate column name 'c_hascertificate'
ERROR 1060 (42S21) at line 1: Duplicate column name 'c_hascertificate'
ERROR 1060 (42S21) at line 1: Duplicate column name 'c_hascertificate'
ERROR 1060 (42S21) at line 1: Duplicate column name 'c_hascertificate'
ERROR 1060 (42S21) at line 1: Duplicate column name 'c_hascertificate'
[root@office ck]# bash /usr/share/doc/sogo-4.*/sql-update-3.0.0-to-combined-mysql.sh

========================================================================
WARNING
========================================================================
This script modifies the SOGo database schema so that it complies to the
new optional 9-table model.  It is *not* part of a normal upgrade.

It is *strongly* recommended you backup your database before proceeding.

In other words, only run this if you absolutely know what you're doing.

Do you really want to proceed (yes/no)? ^C
[root@office ck]#

15 Reply by christophk

  • christophk
  • Member
  • Offline
  • Registered: 2016-05-23
  • Posts: 54

Re: Contacts don't sync and don't show up on Webbrowser

Stop!

I made a mistake.

The contacts sync work now!

The error message during the update still happened.

So I am not sure if all is good, but neither do I have any problems in this very moment.

I hope the error messages don’t mean anything bad ;-)

16 Reply by ZhangHuangbin

  • ZhangHuangbin
  • ZhangHuangbin
  • iRedMail Developers
  • Offline
  • Registered: 2009-05-06
  • Posts: 30,792

Re: Contacts don't sync and don't show up on Webbrowser

christophk wrote:

% bash /usr/share/doc/sogo-4.*/sql-update-3.0.0-to-combined-mysql.sh

Our tutorial doesn't mention this script at all. why you ran this ...

17 Reply by hws

  • hws
  • Member
  • Offline
  • Registered: 2017-01-19
  • Posts: 43

Re: Contacts don't sync and don't show up on Webbrowser

ZhangHuangbin wrote:
christophk wrote:

% bash /usr/share/doc/sogo-4.*/sql-update-3.0.0-to-combined-mysql.sh

Our tutorial doesn't mention this script at all. why you ran this ...

Because otherwise you get errors "Duplicate column name 'c_hascertificate'" when running sql-update-3.2.10_to_4.0.0-mysql.sh.

If you initially had Sogo 2 installed and upgraded to Sogo 3, you still have the old database scheme of Sogo 2. But the upgrade script to version 4 assumes that you have the new database scheme which you get when running "sql-update-3.0.0-to-combined-mysql.sh".

If your initial install was Sogo 3 you don't have this problem...

To stay future-proof, I recommend to run sql-update-3.0.0-to-combined-mysql.sh if you upgrade from Sogo 2.

18 Reply by hws

  • hws
  • Member
  • Offline
  • Registered: 2017-01-19
  • Posts: 43

Re: Contacts don't sync and don't show up on Webbrowser

christophk wrote:
hws wrote:

Same with my update.

I had to run

% bash /usr/share/doc/sogo-4.*/sql-update-3.0.0-to-combined-mysql.sh

first and then

% bash /usr/share/doc/sogo-4.*/sql-update-3.2.10_to_4.0.0-mysql.sh

again.

When I ran command

% bash /usr/share/doc/sogo-4.*/sql-update-3.0.0-to-combined-mysql.sh

Then this message scared mew away:

[root@office ck]# bash /usr/share/doc/sogo-4.*/sql-update-3.2.10_to_4.0.0-mysql.sh
Username (ck): root
Hostname (127.0.0.1):
Database (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:
ERROR 1060 (42S21) at line 1: Duplicate column name 'c_hascertificate'
ERROR 1060 (42S21) at line 1: Duplicate column name 'c_hascertificate'
ERROR 1060 (42S21) at line 1: Duplicate column name 'c_hascertificate'
ERROR 1060 (42S21) at line 1: Duplicate column name 'c_hascertificate'
ERROR 1060 (42S21) at line 1: Duplicate column name 'c_hascertificate'
ERROR 1060 (42S21) at line 1: Duplicate column name 'c_hascertificate'
ERROR 1060 (42S21) at line 1: Duplicate column name 'c_hascertificate'
ERROR 1060 (42S21) at line 1: Duplicate column name 'c_hascertificate'
ERROR 1060 (42S21) at line 1: Duplicate column name 'c_hascertificate'
ERROR 1060 (42S21) at line 1: Duplicate column name 'c_hascertificate'
ERROR 1060 (42S21) at line 1: Duplicate column name 'c_hascertificate'
ERROR 1060 (42S21) at line 1: Duplicate column name 'c_hascertificate'
ERROR 1060 (42S21) at line 1: Duplicate column name 'c_hascertificate'
ERROR 1060 (42S21) at line 1: Duplicate column name 'c_hascertificate'
ERROR 1060 (42S21) at line 1: Duplicate column name 'c_hascertificate'
ERROR 1060 (42S21) at line 1: Duplicate column name 'c_hascertificate'
[root@office ck]# bash /usr/share/doc/sogo-4.*/sql-update-3.0.0-to-combined-mysql.sh

========================================================================
WARNING
========================================================================
This script modifies the SOGo database schema so that it complies to the
new optional 9-table model.  It is *not* part of a normal upgrade.

It is *strongly* recommended you backup your database before proceeding.

In other words, only run this if you absolutely know what you're doing.

Do you really want to proceed (yes/no)? ^C
[root@office ck]#

You have to run "sql-update-3.0.0-to-combined-mysql.sh" first and after that "sql-update-3.2.10_to_4.0.0-mysql.sh".

Since you made a backup before running those scripts, you can always restore the old files if something goes wrong.

The first script will update your Sogo database to the new combined database scheme used by Sogo since version 3. We checked the SQL before running the script and everything worked well. After that we could run "sql-update-3.2.10_to_4.0.0-mysql.sh" without errors. The new combined database scheme does no longer create 3 extra tables for each user of Sogo which could be a problem if you have many users.

We now have the most recent version of Sogo with the most recent version of the database and everything works as it should work.