Topic: Problem installing sogo3 on a clean sme 9.1

[sfhwan]

Hi, I was trying to install sogo3 to replace horde webmail (although some feedbacks from the forum that roundcube may be preferred) by following the instructions on https://wiki.contribs.org/Sogo but encountered dependency problem as follows:

yum --skip-broken --enablerepo=stephdl,epel,sogo3,fws install smeserver-sogo
...
Resolving Dependencies
--> Running transaction check
---> Package smeserver-sogo.noarch 9:1.5-1.el6.sme will be installed
--> Processing Dependency: sogo >= 2.3.0 for package: 9:smeserver-sogo-1.5-1.el6.sme.noarch
--> Processing Dependency: sope49-gdl1-mysql for package: 9:smeserver-sogo-1.5-1.el6.sme.noarch
--> Processing Dependency: sogo-tool for package: 9:smeserver-sogo-1.5-1.el6.sme.noarch
--> Processing Dependency: sogo-ealarms-notify for package: 9:smeserver-sogo-1.5-1.el6.sme.noarch
--> Processing Dependency: sogo-activesync for package: 9:smeserver-sogo-1.5-1.el6.sme.noarch

Packages skipped because of dependency problems:
    9:smeserver-sogo-1.5-1.el6.sme.noarch from stephdl

Appreciate your help to solve this problem. Thanks.

[Stefano]

hi, welcome here

first of all, never use --skip-broken flag, it can seriously break your server.

all you need to installa sogo3 is here:
https://wiki.contribs.org/Sogo#Install_SOGO_3_.28ONLY_SME9.29
(be sure to setup correctly all the needed repos)

follow those instructions and come back here if you find yourself in trouble


BTW, if you just need a webmail, maybe sogo is a bit overkill for you; you'd install roundcube

[sfhwan]

Thanks Stefano.
In fact I had tried without the --skip-broken parameter first but got the following output:
...
--> Finished Dependency Resolution
Error: Package: 9:smeserver-sogo-1.5-1.el6.sme.noarch (stephdl)
           Requires: sogo-activesync
Error: Package: 9:smeserver-sogo-1.5-1.el6.sme.noarch (stephdl)
           Requires: sogo-tool
Error: Package: 9:smeserver-sogo-1.5-1.el6.sme.noarch (stephdl)
           Requires: sogo >= 2.3.0
Error: Package: 9:smeserver-sogo-1.5-1.el6.sme.noarch (stephdl)
           Requires: sogo-ealarms-notify
Error: Package: 9:smeserver-sogo-1.5-1.el6.sme.noarch (stephdl)
           Requires: sope49-gdl1-mysql
 You could try using --skip-broken to work around the problem
 You could try running: rpm -Va --nofiles --nodigest

so I added --skip-broken as instructed but the problem remained. (the repositories were setup as instructed in the wiki ...).

Btw, I would give roundcube a try and see which one is better for desktop and mobile devices. Tks.

[Stefano]

please, post the output of

Code: [Select]

db yum_repositories show sogo
db yum_repositories show sogo3


[sfhwan]

Hi Stefano, pls see the following output. Tks.

db yum_repositories show sogo
sogo=repository
    BaseURL=http://packages.inverse.ca/SOGo/nightly/2/rhel/6/$basearch
    EnableGroups=yes
    GPGCheck=no
    IncludePkgs=gnustep-base,gnustep-make,libmemcached,libwbxml,sogo*,sope49*
    Name=Inverse SOGo Repository
    Visible=yes
    status=disabled

db yum_repositories show sogo3
... blank ...

[Stefano]

unless you want to install SOGo2, you're using the wrong repo

infact you're using

Code: [Select]

yum --enablerepo=stephdl,epel,sogo3,fws install smeserver-sogo

command, but you don't have sogo3 repo configured (see above, your output)

so, if you want to install SOGo2:

Code: [Select]

yum --enablerepo=stephdl,epel,sogo,fws install smeserver-sogo

if you want to install SOGo3, configure the right repo (https://wiki.contribs.org/Sogo-repo#For_SME_Server_9.x_2)
then

Code: [Select]

yum --enablerepo=stephdl,epel,sogo3,fws install smeserver-sogo


[sfhwan]

Thanks Stefano! The installation was successful after setting up the sogo3 repo and re-running of the yum install command.

Installed:
  smeserver-sogo.noarch 9:1.5-1.el6.sme

Dependency Installed:
   ...   ... ...
Complete!

I can now login using sogo3 which looks very nice on both desktop and a 5.5" handphone. Hwvr, I could not login to roundcube which was installed shortly after your  advice (btw, it looks decent on desktop but the pages on mobile are not responsive...). The following error msg showed up while browsing <my domain>/roundcube. Not sure if it is caused by the sogo3 installation and how to get around it ... looks difficult to fix

DATABASE ERROR: CONNECTION FAILED!
Unable to connect to the database!
Please contact your server-administrator.

[Stefano]

no, the error you're reporting is not related to SOGo in any way, according to my experience.. and I can confirm that SOGo and Roundcube can live on the same machine with no issues..

[sfhwan]

The error might be caused by RoundCube running while the sme9.1 was being rebooted to Sogo3 installation. I found the following lines in the /var/log/messages:

mysql.init: ERROR 1556 (HY000) at line 145: You can't use locks with log tables.
mysql.init: Looking for 'mysql' as: /usr/bin/mysql
mysql.init: Looking for 'mysqlcheck' as: /usr/bin/mysqlcheck
mysql.init: This installation of MySQL is already upgraded to 5.1.73, use --force if you still need to run mysql_upgrade
mysql.init: waiting for mysqld to restart
smbd[2327]: [2017/05/08 18:30:29.498684,  0] smbd/server.c:1110(main)
smbd[2327]:   standard input is not a socket, assuming -D option
mysql.init: waiting for mysqld to restart
mysql.init: waiting for mysqld to restart

... and was trying to figure out the next step ...

[Stefano]

no, this log has nothing to do with your issue..

try:

Code: [Select]

yum remove smeserver-roundcube roundcubemail roundcubemail_plugins
config delete roundcube

then reinstall it

[sfhwan]

Hi Stefano, I re-installed roundcube successfully (ie no error message) using your instructions. Hwvr, the same "DATABASE ERROR: CONNECTION FAILED!" message showed up while visiting roundcube (despite using mysql-front to flush/check the roundcube db without problem ...)

The final portion of /var/log/message is attached and the line "May  8 21:55:42 smesvr mysql.init: ERROR 1556 (HY000) at line 145: You can't use locks with log tables." looks fishy to me, though I have no clue how to fix it.

May  8 21:54:42 smesvr yum[2734]: Installed: roundcubemail-1.1.3-101.el6.sme.noarch
May  8 21:54:43 smesvr yum[2734]: Installed: roundcubemail_plugins-1.2-2.el6.sme.noarch
May  8 21:54:44 smesvr /sbin/e-smith/db[2747]: /home/e-smith/db/configuration: OLD php=service|AllowUrlFopen|off|status|enabled
May  8 21:54:44 smesvr /sbin/e-smith/db[2747]: /home/e-smith/db/configuration: NEW php=service|AllowUrlFopen|On|status|enabled
May  8 21:55:22 smesvr /sbin/e-smith/db[2789]: /home/e-smith/db/configuration: OLD php=service|AllowUrlFopen|On|status|enabled
May  8 21:55:22 smesvr /sbin/e-smith/db[2789]: /home/e-smith/db/configuration: NEW php=service|AllowUrlFopen|off|status|enabled
May  8 21:55:22 smesvr yum[2734]: Installed: smeserver-roundcube-1.2-9.el6.sme.noarch
May  8 21:55:22 smesvr /sbin/e-smith/db[2812]: /home/e-smith/db/configuration: OLD UnsavedChanges=no
May  8 21:55:22 smesvr /sbin/e-smith/db[2812]: /home/e-smith/db/configuration: NEW UnsavedChanges=yes
May  8 21:55:38 smesvr esmith::event[2817]: Processing event: roundcube-update
May  8 21:55:38 smesvr esmith::event[2817]: Running event handler: /etc/e-smith/events/actions/generic_template_expand
May  8 21:55:38 smesvr esmith::event[2817]: expanding /usr/share/roundcubemail/plugins/managesieve/config.inc.php
May  8 21:55:38 smesvr esmith::event[2817]: expanding /usr/share/roundcubemail/plugins/sieverules/config.inc.php
May  8 21:55:38 smesvr esmith::event[2817]: ERROR: Cannot create output file //usr/share/roundcubemail/plugins/sieverules/config.inc.php.2818 No such file or directory
May  8 21:55:38 smesvr esmith::event[2817]:  at /etc/e-smith/events/actions/generic_template_expand line 56
May  8 21:55:38 smesvr esmith::event[2817]: expanding /etc/dovecot/dovecot.conf
May  8 21:55:38 smesvr esmith::event[2817]: expanding /etc/roundcubemail/config.inc.php
May  8 21:55:38 smesvr esmith::event[2817]: expanding /etc/httpd/conf/httpd.conf
May  8 21:55:40 smesvr esmith::event[2817]: expanding /etc/e-smith/sql/init/80roundcube
May  8 21:55:40 smesvr esmith::event[2817]: generic_template_expand=action|Event|roundcube-update|Action|generic_template_expand|Start|1494251738 550928|End|1494251740 833632|Elapsed|2.282704
May  8 21:55:40 smesvr esmith::event[2817]: Running event handler: /etc/e-smith/events/roundcube-update/S20qmail-update-user
May  8 21:55:41 smesvr esmith::event[2817]: S20qmail-update-user=action|Event|roundcube-update|Action|S20qmail-update-user|Start|1494251740 833935|End|1494251741 634244|Elapsed|0.800309
May  8 21:55:41 smesvr esmith::event[2817]: Running event handler: /etc/e-smith/events/actions/adjust-services
May  8 21:55:41 smesvr esmith::event[2817]: adjusting supervised dovecot (restart)
May  8 21:55:41 smesvr esmith::event[2817]: adjusting supervised dovecot (up)
May  8 21:55:41 smesvr esmith::event[2817]: adjusting supervised httpd-e-smith (sigusr1)
May  8 21:55:41 smesvr esmith::event[2817]: adjusting supervised httpd-e-smith (up)
May  8 21:55:41 smesvr esmith::event[2817]: adjusting non-supervised mysql.init (restart)
May  8 21:55:42 smesvr mysql.init: ERROR 1556 (HY000) at line 145: You can't use locks with log tables.
May  8 21:55:42 smesvr esmith::event[2817]: Loading restore_dumped_dbs into mysql #033[60G[#033[0;31mFAILED#033[0;39m]#015
May  8 21:55:42 smesvr esmith::event[2817]: Loading roundcube into mysql #033[60G[#033[0;32m  OK  #033[0;39m]#015
May  8 21:55:42 smesvr esmith::event[2817]: serviceControl: Couldn't system(/etc/rc.d/rc7.d/S99mysql.init, restart):
May  8 21:55:42 smesvr esmith::event[2817]: adjusting supervised qmail (restart)
May  8 21:55:42 smesvr esmith::event[2817]: adjusting supervised qmail (up)
May  8 21:55:42 smesvr esmith::event[2817]: adjust-services=action|Event|roundcube-update|Action|adjust-services|Start|1494251741 634621|End|1494251742 406523|Elapsed|0.771902

[stephdl]

Remove the mysql database of roundcube then reconfigure the server

[sfhwan]

Thanks Stephdl. I will give it a try when I am back to my computer screen a few hours later,  I am guessing that "reconfiguring the server" will not be too difficult ...

Re SOGo3 which is responsive, there may be issues that require some tuning (as per recommendations on the wiki page), eg. in my case, I have setup several folders with 2 or 3 levels of sub-folders which do not show up in SOGo3. I will check if the same issue shows up in RoundCube later.

[sfhwan]

As the roundcube db could not be dropped using mysql-front, I browsed for roundcube help for a while and then changed the following line in /etc/roundcubemail/config.inc.php :

$config['debug_level'] = 4;    // to show system error.  Original value is 1.

Running roundcube showed the error:
Error while trying to connect to the Mysql database:
SQLSTATE[28000] [1045] Access denied for user 'roundcube'@'localhost' (using password: YES)

which could be fixed by using the steps from the following link: (among many others I think)
https://support.plesk.com/hc/en-us/articles/213406909-How-to-get-MySQL-password-for-RoundCube-webmail

Now I could login to both SOGo3 and RoundCube successfully. The latter displayed all mail sub-folders correctly (which is a big plus).

Thanks for the help.

[Stefano]

happy to know you worked it out, but in this way you have some info not synced between your config db and your mysql db

moreover, since you manually edited some files that might be templated, you may loose your editing when you'll update your server

[sfhwan]

Thanks Stefano! That's a good reminder. I will use "config setprop  ..." to update the password in RoundCube to make sure the changes are stored in SME db.

After a brief comparison of SOGo3 and RoundCube, I think I will use the latter for the time being until the sub-folder issue in SOGo3 is resolved.

[janet]

sfhwan

...I am guessing that "reconfiguring the server" will not be too difficult ...

In koozali/sme server parlance this means
Issue the commands
signal-event post-upgrade
signal-event reboot

or you can menu select this function in one of the server manager panels

[stephdl]

After a brief comparison of SOGo3 and RoundCube, I think I will use the latter for the time being until the sub-folder issue in SOGo3 is resolved.

subfolders works with sogo

click on the icon of the inbox folder....think that nothing is real, all is javascript

[sfhwan]

Thanks Stephdl !
Clicking on the Inbox folder icon works - I can now access my mail sub-folders. This really is a subtle feature which is harmless once it is known As a result, I will switch to SOGo3 in view of its responsiveness on mobile devices (which I use more often nowadays).

[jameswilson]

is there a plan to have activesync in v10 with calander, contacts etc native?

[Stefano]

SME 10 is still in early alpha stage, and ATM he has horde 5.X groupware installed

if you can, try to check if horde framework offers such features and, if so, try to help us to add them to SME

[jameswilson]

I'm asking because id like it, I cant help with dev I'm too simple. All I can do is offer mirror

[jameswilson]

10 meg up

[janet]

jameswilson

....All I can do is offer mirror

There are instructions on the wiki (linked to from download page) you can follow to set up a mirror.
See
https://wiki.contribs.org/Mirrors

Just do it, no need to wait to be contacted.