Emails not showing

[hazell20 (Rhys Hazell)]

hi guys i have auto updates on and loooks like update was done last night now i cant start mysql server and cant view new emails in sogo roundcube

regards
Rhys

[hazell20 (Rhys Hazell)]

Dec 4 15:24:30 mail mariadb-prepare-db-dir: Socket file /var/lib/mysql/mysql.sock exists.
Dec 4 15:24:30 mail mariadb-prepare-db-dir: Is another MySQL daemon already running with the same unix socket?
Dec 4 15:24:30 mail systemd: mysqld.service: control process exited, code=exited status=1
Dec 4 15:24:30 mail systemd: Unit mysqld.service entered failed state.
Dec 4 15:24:30 mail systemd: mysqld.service failed.

[hazell20 (Rhys Hazell)]

socket: ‘/var/lib/mysql/mysql.sock’ port: 3306 MariaDB Server
181204 16:01:42 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
181204 16:01:42 [Note] /usr/libexec/mysqld (mysqld 5.5.60-MariaDB) starting as process 18233 …
181204 16:01:42 InnoDB: The InnoDB memory heap is disabled
181204 16:01:42 InnoDB: Mutexes and rw_locks use GCC atomic builtins
181204 16:01:42 InnoDB: Compressed tables use zlib 1.2.7
181204 16:01:42 InnoDB: Using Linux native AIO
181204 16:01:42 InnoDB: Initializing buffer pool, size = 128.0M
181204 16:01:42 InnoDB: Completed initialization of buffer pool
181204 16:01:42 InnoDB: highest supported file format is Barracuda.
InnoDB: The log sequence number in ibdata files does not match
InnoDB: the log sequence number in the ib_logfiles!
InnoDB: Restoring possible half-written data pages from the doublewrite buffer…
181204 16:01:43 InnoDB: Waiting for the background threads to start
181204 16:01:44 Percona XtraDB (http://www.percona.com) 5.5.59-MariaDB-38.11 started; log sequence number 50658084446
181204 16:01:44 [Note] Plugin ‘FEEDBACK’ is disabled.
181204 16:01:44 [Note] Server socket created on IP: ‘0.0.0.0’.
181204 16:01:44 [Note] Event Scheduler: Loaded 0 events
181204 16:01:44 [Note] /usr/libexec/mysqld: ready for connections.

[davidep (Davide Principi)]

Please attach the output of

yum history info
rpm -q mariadb
systemctl status mariadb mysqld
systemctl | grep -E '(maria|mysql)'
grep NsReleaseLock /var/log/messages*
grep nethserver-check-nsreleaselock /var/log/cron*

This could be a possible workaround:

NethServer 7.6.1810 beta development

It is now possible to upgrade to NethServer 7.6.1810 beta with the following commands config setprop subscription NsRelease 7.6.1810 Then go to Software Center and run system upgrade set the Software updates origin to “Locked” until 7.6 final has been released Check for open issues again here: https://github.com/NethServer/dev/issues

[Keith_Haines]

I have the same problem with Sogo and WebTop. I’m also unable to connect via IMAP.

Error in sogo.log:

>     Dec 06 22:18:55 sogod [5354]: SOGoRootPage successful login from '192.168.20.70' for user 'redacted' - expire = -1  grace = -1
>     Dec 06 22:18:55 sogod [5354]: [WARN] <0x0x559dd1299ee0[SOGoWebDAVAclManager]> entry '{DAV:}write' already exists in DAV permissions table
>     Dec 06 22:18:55 sogod [5354]: [WARN] <0x0x559dd1299ee0[SOGoWebDAVAclManager]> entry '{DAV:}write-properties' already exists in DAV permissions table
>     Dec 06 22:18:55 sogod [5354]: [WARN] <0x0x559dd1299ee0[SOGoWebDAVAclManager]> entry '{DAV:}write-content' already exists in DAV permissions table
>     Dec 06 22:18:55 sogod [5354]: 192.168.20.70 "POST /SOGo/connect HTTP/1.1" 200 42/60 0.199 - - 8M
>     Dec 06 22:18:56 sogod [5354]: 192.168.20.70 "GET /SOGo/redacted HTTP/1.1" 302 0/0 0.005 - - 0
>     Dec 06 22:18:56 sogod [5354]: 192.168.20.70 "GET /SOGo/redacted/view HTTP/1.1" 302 0/0 0.003 - - 0
>     Dec 06 22:18:56 sogod [5354]: 192.168.20.70 "GET /SOGo/so/redacted/Mail HTTP/1.1" 302 0/0 0.003 - - 0
>     Dec 06 22:18:56 sogod [5354]: 192.168.20.70 "GET /SOGo/so/redacted/Mail/view HTTP/1.1" 200 18628/0 0.066 79428 76% 140K
>     Dec 06 22:18:56 sogod [5354]: 192.168.20.70 "GET /SOGo/so/redacted/Calendar/alarmslist?browserTime=1544163536 HTTP/1.1" 200 63/0 0.022 - - 0
>     Dec 06 22:18:56 sogod [5366]: [ERROR] <0x0x559dd132e710[NGImap4ConnectionManager]> IMAP4 login failed:
>       host=localhost, user=redacted@redacteddomain.com, pwd=yes
>       url=imap://redacted%40redacteddomain.com@localhost/
>       base=(null)
>       base-class=(null))
>       = <0x0x559dd1290350[NGImap4Client]: login=redacted@redacteddomain.com(pwd) address=<0x0x559dd120c660[NGInternetSocketAddress]: host=localhost port=143>>

IMAP Log:

> Dec  6 22:38:53 www dovecot: imap-login: Login: user=<redacted>, method=PLAIN, rip=192.168.20.70, lip=192.168.20.1, mpid=10697, TLS, session=<sMtp3mh8vs7AqBRG>
> Dec  6 22:38:53 www dovecot: imap(redacted@redacteddomain.com): Error: Couldn't load required plugin /usr/lib64/dovecot/lib90_antispam_plugin.so: Module is for different ABI version 2.2.ABIv10(2.2.10) (we have 2.2.ABIv36(2.2.36))
> Dec  6 22:38:53 www dovecot: imap(redacted@redacteddomain.com): Error: Internal error occurred. Refer to server log for more information.

This is a new error that has filled my imap log file since the update.

I don’t have any issues with mysql (MariaDB).

[Keith_Haines]

It looks like this is directly related to: Rebuild or replace dovecot plugins · Issue #5646 · NethServer/dev · GitHub

I’m trying to install dovecot-antispam-0.0.49-3.2.g4c6e244.ns7.x86_64.rpm per Rebuild or replace dovecot plugins · Issue #5646 · NethServer/dev · GitHub

However I’m getting the error

file /usr/lib64/dovecot/lib90_antispam_plugin.so from install of dovecot-antispam-0.0.49-3.2.g4c6e244.ns7.x86_64 conflicts with file from package dovecot-antispam-0.0.49-3.ns7.x86_64

How can I update my install?
Do I need to switch to 7.6 beta, or 7.5 testing for updates?

[davidep (Davide Principi)]

I’d go by completing the update of 7.6 beta.

I edited the workaround procedure linked here Emails not showing

[Keith_Haines]

That worked perfectly! Thanks!