1 Topic by 2otherjobs

  • 2otherjobs
  • Member
  • Offline
  • Registered: 2019-03-03
  • Posts: 5

Topic: LDAP backend, Mariadb errors during installation -> iredadmin failure

==== REQUIRED BASIC INFO OF YOUR IREDMAIL SERVER ====
- iRedMail version (check /etc/iredmail-release): iRedMail-1.3.2.tar.gz
- Deployed with iRedMail Easy or the downloadable installer? downloadable installer
- Linux/BSD distribution name and version: FreeBSD jail, iocage, 12.2-RELEASE
- Store mail accounts in which backend (LDAP/MySQL/PGSQL): LDAP
- 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.
====
I have changed items in the log file that would identify my site.  Note the mariadb errors (I found two).

Also the log file /var/log/mysql/mysql.err is filled with:

2021-01-27  9:02:00 97 [Warning] Access denied for user 'sogo'@'name.example.com' (using password: YES)
2021-01-27  9:02:12 98 [Warning] Access denied for user 'iredapd'@'name.example.com' (using password: YES)
2021-01-27  9:02:12 99 [Warning] Access denied for user 'amavisd'@'name.example.com'

There is a second error, have not tried to track it down:

root@name:/var/log/mysql # service dovecot restart
doveconf: Fatal: Error in configuration file /usr/local/etc/dovecot/dovecot.conf line 405: Unknown setting: metric { event_name
doveconf: Error: managesieve-login: dump-capability process returned 89
doveconf: Fatal: Error in configuration file /usr/local/etc/dovecot/dovecot.conf line 405: Unknown setting: metric { event_name
==Error==
Configuration file check failed.
# 2.3.13 (89f716dc2): /usr/local/etc/dovecot/dovecot.conf
# Pigeonhole version 0.5.13 (cdd19fe3)
doveconf: Fatal: Error in configuration file /usr/local/etc/dovecot/dovecot.conf line 405: Unknown setting: metric { event_name
doveconf: Error: managesieve-login: dump-capability process returned 89
doveconf: Fatal: Error in configuration file /usr/local/etc/dovecot/dovecot.conf line 405: Unknown setting: metric { event_name

Hope you can help.

Post's attachments

runtime:install.log.txt 24.33 kb, 2 downloads since 2021-01-27 

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: 31,088

Re: LDAP backend, Mariadb errors during installation -> iredadmin failure

MariaDB root password was not correctly set/reset. I will check later.

3 Reply by 2otherjobs

  • 2otherjobs
  • Member
  • Offline
  • Registered: 2019-03-03
  • Posts: 5

Re: LDAP backend, Mariadb errors during installation -> iredadmin failure

Thank you.  That assessment makes sense.  FWIW, I have tried reinstallation two additional times with exactly the same result.

4 Reply by ZhangHuangbin

  • ZhangHuangbin
  • ZhangHuangbin
  • iRedMail Developers
  • Offline
  • Registered: 2009-05-06
  • Posts: 31,088

Re: LDAP backend, Mariadb errors during installation -> iredadmin failure

Working fine withOUT jail, didn't test Jail yet.

5 Reply by 2otherjobs

  • 2otherjobs
  • Member
  • Offline
  • Registered: 2019-03-03
  • Posts: 5

Re: LDAP backend, Mariadb errors during installation -> iredadmin failure

Your jail directions installed iRedMail using EzJail and I used Iocage - for me, it is easier to use. 12.2-RELEASE.  Latest ports tree.  Also, the network stack is VNET.  Not sure any of that would make a difference.  I have MySQL, pgsql and OpenLDAP in other jails.   I do not have any good ideas as to why MariaDB does not install.

6 Reply by Funzi

  • Funzi
  • Member
  • Offline
  • Registered: 2021-02-01
  • Posts: 2

Re: LDAP backend, Mariadb errors during installation -> iredadmin failure

I was able to fix it by replacing

metric imap_command_finished {
  event_name = imap_command_finished
}

with

metric imap_command_finished {
  filter = event=imap_command_finished
}

(only the filter line). I've created https://github.com/iredmail/iRedMail/pull/108 for that.

7 Reply by ZhangHuangbin

  • ZhangHuangbin
  • ZhangHuangbin
  • iRedMail Developers
  • Offline
  • Registered: 2009-05-06
  • Posts: 31,088

Re: LDAP backend, Mariadb errors during installation -> iredadmin failure

Dear @Funzi,

Dovecot issue is not related this topic which is about MariaDB root password.

8 Reply by Funzi (edited by Funzi 2021-02-01 22:15:05)

  • Funzi
  • Member
  • Offline
  • Registered: 2021-02-01
  • Posts: 2

Re: LDAP backend, Mariadb errors during installation -> iredadmin failure

OP said "There is a second error, have not tried to track it down:" and I was referring to the second one. smile

9 Reply by 2otherjobs

  • 2otherjobs
  • Member
  • Offline
  • Registered: 2019-03-03
  • Posts: 5

Re: LDAP backend, Mariadb errors during installation -> iredadmin failure

Thanks to Funzi for providing the fix for the Dovecot problem.  Would be happy to answer any more questions about how I installed iRedMail in case that might help fix  the MariaDB password problem.