Sogo sql Error after install

Support
,
1

NethServer Version: nethserver-7.3.1611
Module: Sogo
I just install a new nethserver 7.
with these modules: OpenLDAP-Basic firewall-Email-MariaDB (MySQL) server-POP3 connector-POP3 proxy-SMTP proxy-SMTP proxy-Firewall-SOGo groupware .
But after Reboot the system i get this error in the sogo log.
2017-03-29 20:32:47.715 sogod[1202:1202] ERROR: could not open MySQL4 connection to database ‘sogo’: Can’t connect to local MySQL server through socket ‘/var/lib/mysql/mysql.sock’ (2)
2017-03-29 20:32:47.715 sogod[1197:1197] ERROR: could not open MySQL4 connection to database ‘sogo’: Can’t connect to local MySQL server through socket ‘/var/lib/mysql/mysql.sock’ (2)
Mar 29 20:32:47 sogod [1197]: [ERROR] <0x0x7fc797db4e40[GCSChannelManager]> could not open channel <MySQL4Channel[0x0x7fc797e027b0] connection=0x(null)> for mysql://localhost/sogo/sogo_user_profile
Mar 29 20:32:47 sogod [1202]: [ERROR] <0x0x7fc797db4e40[GCSChannelManager]> could not open channel <MySQL4Channel[0x0x7fc797e027b0] connection=0x(null)> for mysql://localhost/sogo/sogo_user_profile
Mar 29 20:32:47 sogod [1197]: [WARN] <0x0x7fc797db4e40[GCSChannelManager]> will prevent opening of this channel 5 seconds after 2017-03-29 20:32:47 +0200
Mar 29 20:32:47 sogod [1202]: [WARN] <0x0x7fc797db4e40[GCSChannelManager]> will prevent opening of this channel 5 seconds after 2017-03-29 20:32:47 +0200
2017-03-29 20:32:47.715 sogod[1201:1201] ERROR: could not open MySQL4 connection to database ‘sogo’: Can’t connect to local MySQL server through socket ‘/var/lib/mysql/mysql.sock’ (2)
Mar 29 20:32:47 sogod [1201]: [ERROR] <0x0x7fc797db4e40[GCSChannelManager]> could not open channel <MySQL4Channel[0x0x7fc797e027b0] connection=0x(null)> for mysql://localhost/sogo/sogo_user_profile

so I try to restart a few more time, and I try to reboot the system a few time.
but the error keeps coming.
Is there someone who can give an explanation, it is me who has popularized one or another wrong. I am a real beginner.

2

please what is the output

[root@NS7DEV ~]# rpm -qa *maria* *mysql*
[root@NS7DEV ~]# rpm -qa |grep sogo

and

[root@NS7DEV ~]# systemctl status mysqld

2 Likes
3

Hi
The output for this commad is rpm -qa *maria* *mysql*

[root@dahlgrennetmail ~]# rpm -qa *maria* *mysql* sope49-gdl1-mysql-4.9-20170216_2300.ns7.x86_64 nethserver-mysql-1.1.1-1.ns7.noarch mariadb-libs-5.5.52-1.el7.x86_64 mariadb-5.5.52-1.el7.x86_64 mariadb-server-5.5.52-1.el7.x86_64 [root@dahlgrennetmail ~]#
And for this command it is rpm -qa |grep sogo

[root@dahlgrennetmail ~]# rpm -qa |grep sogo sogo-activesync-3.2.7-1.ns7.x86_64 sogo-tool-3.2.7-1.ns7.x86_64 nethserver-sogo-1.6.5-1.ns7.noarch sogo-3.2.7-1.ns7.x86_64 [root@dahlgrennetmail ~]#
And for last one

[code][root@dahlgrennetmail ~]# systemctl status mysqld
● mysqld.service - MariaDB database server
Loaded: loaded (/usr/lib/systemd/system/mysqld.service; enabled; vendor preset: disabled)
Active: active (running) since Wed 2017-03-29 21:38:11 CEST; 2h 2min ago
Process: 818 ExecStartPost=/usr/libexec/mariadb-wait-ready $MAINPID (code=exited, status=0/SUCCESS)
Process: 720 ExecStartPre=/usr/libexec/mariadb-prepare-db-dir %n (code=exited, status=0/SUCCESS)
Main PID: 816 (mysqld_safe)
CGroup: /system.slice/mysqld.service
├─ 816 /bin/sh /usr/bin/mysqld_safe --basedir=/usr
└─1061 /usr/libexec/mysqld --basedir=/usr --datadir=/var/lib/mys…

Mar 29 21:38:07 dahlgrennetmail.XXX.ZZ systemd[1]: Starting MariaDB d…
Mar 29 21:38:08 dahlgrennetmail.XXX.ZZ mysqld_safe[816]: 170329 21:38…
Mar 29 21:38:08 dahlgrennetmail.XXX.ZZ mysqld_safe[816]: 170329 21:38…
Mar 29 21:38:11 dahlgrennetmail.XXX.ZZ systemd[1]: Started MariaDB da…
Hint: Some lines were ellipsized, use -l to show in full.
[root@dahlgrennetmail ~]#
[/code]
Hobe that it help:-)

4

can you connect to mysql

In your terminal do

mysqlshow

Tip for the output, you should use a gist

5

Yes

[root@dahlgrennetmail ~]# mysqlshow +--------------------+ | Databases | +--------------------+ | information_schema | | mysql | | performance_schema | | sogo | +--------------------+

6

did you change the password database of sogo ?

7

No, just a normale install

8

can u install another web application…like wordpress and see if the issue is reproducible ?

9

So, try it right away

1 Like
10

Humm,UPS I’m a newbie, where do I find wordpress

11

You can find instructions on the wiki
https://wiki.nethserver.org/doku.php?id=wordpress

12

:blush:

13

It is install

14

Ok, Wordpress is now install. And i have Reboot the system.
But i stil get the error from sogo.
https://gist.github.com/anonymous/066140d455f26ba3efa26a8857b72df7

15

an observation I have made is that:
if I restart sogo services, there is no error or warnings in the sogo log.

16

Ok so relative to sogo…when you restart the service you can connect to sogo. What is the status of sogod after the boot time ?

Reboot then

systemctl status sogod

1 Like
17

OK. before reboot: https://gist.github.com/anonymous/d91bced83583a5083821f933795c0971

And after Reboot: https://gist.github.com/anonymous/517f10f648ef73ef0085acb935afe2e5

And also a printout from the SOGo log :https://gist.github.com/anonymous/933fbb18309d5a6baf1792fdb39455e4

18

you should try to get your output well formatted, the first and the second are unreadable :’(

19

I’m very sorry. I hope that the new one is to read:https://gist.github.com/anonymous/59aac2a2eb76ffefbed8b3c8c263fe63

I can use sogo web interface, but I get these errors in the log sogo:https://gist.github.com/anonymous/0903e63eb05f58f1fecd3d4eca0aed85

i can also use an android phone (EAS), but again errors in the log:https://gist.github.com/anonymous/7f3de9d1c92f5f33bc68d5982db22f49

And outlook2016 seems to work, but there are some errors in the log:https://gist.github.com/anonymous/c70b970f2e164d6ea78597fed4544d75

I hope that it’s fairly ok this time:innocent:

20

Gist output is OK now :wink:

Unsure if it makes sense @stephdl, but is it possible that sogo is trying to use the mysql socket before it has been created, and thus showing those errors?

If it make sense you could crosscheck the timing between the mysqld ready for connections (/var/log/mariadb/mariadb.log) and the sogo errors (/var/log/sogo/sogo.log)?