1 Topic by Blisk

  • Blisk
  • Member
  • Offline
  • Registered: 2015-05-07
  • Posts: 106

Topic: Can not login to roundcubemail

==== REQUIRED BASIC INFO OF YOUR IREDMAIL SERVER ====
- iRedMail version (check /etc/iredmail-release): 1.3.2
- Deployed with iRedMail Easy or the downloadable installer? downloadable installer
- Linux/BSD distribution name and version: centos 8
- Store mail accounts in which backend (LDAP/MySQL/PGSQL): mysql
- Web server (Apache or Nginx): 2.4
- Manage mail accounts with iRedAdmin-Pro? no
- [IMPORTANT] Related original log or error message is required if you're experiencing an issue.
====

I can add new users in iredadmin but can not login into roundubemail.

I get this error.
auth-worker(63997): Warning: sqlpool(mysql): Query failed, retrying: Unknown column 'mailbox.mailboxformat' in 'field list'
auth-worker(63997): Error: conn unix:auth-worker (pid=63994,uid=97): auth-worker<1>: sql(info@mydomain.com): User query failed: Unknown column 'mailbox.mailboxformat' in 'field list'
Feb  1 08:06:46 vakciji dovecot[63991]: lda: Fatal: Internal error occurred. Refer to server log for more information.

----

Spider Email Archiver: On-Premises, lightweight email archiving software developed by iRedMail team. Supports Amazon S3 compatible storage and custom branding.

2 Reply by Blisk (edited by Blisk 2021-02-01 16:31:31)

  • Blisk
  • Member
  • Offline
  • Registered: 2015-05-07
  • Posts: 106

Re: Can not login to roundcubemail

I manage to solve this error adding mysql update from 0.9.9

Now I get this error and don't know why.
I checked vmailadmin password and it is ok.
mysql(127.0.0.1): Connect failed to database (vmail): Access denied for user 'vmailadmin'@'localhost' (using password: YES) - waiting for 5 seconds before retry
And I have the same password in dovecot MySQL and vmailadmin

3 Reply by Blisk (edited by Blisk 2021-02-01 16:38:08)

  • Blisk
  • Member
  • Offline
  • Registered: 2015-05-07
  • Posts: 106

Re: Can not login to roundcubemail

I found out where was problem.
In some parts in dovecot conf I have MySQL username vmail in some parts was vmail admin.
Now I changed all to the same and it works.

4 Reply by ZhangHuangbin

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

Re: Can not login to roundcubemail

Blisk wrote:

In some parts in dovecot conf I have MySQL username vmail in some parts was vmail admin.
Now I changed all to the same and it works.

This is not right.
We use "vmail" for read-only SQL queries, and "vmailadmin" for read+write, it's on purpose.
Your modification is wrong and i think you need to clearly understand which feature should be read-only and use "vmail" user.

5 Reply by Blisk

  • Blisk
  • Member
  • Offline
  • Registered: 2015-05-07
  • Posts: 106

Re: Can not login to roundcubemail

So postfix use vmail which is read only user?

6 Reply by ZhangHuangbin

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

Re: Can not login to roundcubemail

Yes.

Dovecot uses both vmail and vmailadmin.