Emails not showing

mysql

(Rhys Hazell) #1

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


(Rhys Hazell) #2

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.


(Rhys Hazell) #3

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.


(Davide Principi) #4

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:


(Keith Haines) #5

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) #6

It looks like this is directly related to: https://github.com/NethServer/dev/issues/5646

I’m trying to install dovecot-antispam-0.0.49-3.2.g4c6e244.ns7.x86_64.rpm per https://github.com/NethServer/dev/issues/5646#issuecomment-439890766

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?


(Davide Principi) #7

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

I edited the workaround procedure linked here Emails not showing


(Keith Haines) #8

That worked perfectly! Thanks!