Aug 5, 2024: iRedMail-1.7.1 has been released.

**oermolaev** · 2021-10-14 18:39:05

oermolaev
Member
Offline

Registered: 2012-01-21
Posts: 12

Topic: The new user cannot login in to the roundcube

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

Oct 21 09:18:35 mail roundcube: <23kcqdii> DB Error: [1364] Field 'alias' doesn't have a default value (SQL Query: INSERT INTO `users` (`created`, `last_login`, `username`, `mail_host`, `language`, `preferences`) VALUES (now(), now(), 'newusername@mydomain.com', '127.0.0.1', 'ru_RU', 'a:0:{}')) in /opt/www/roundcubemail-1.5.0/program/lib/Roundcube/rcube_db.php on line 566 (POST /mail/?_task=login&_action=login)
Oct 21 09:18:35 mail roundcube: <23kcqdii> PHP Error: Failed to create new user in /opt/www/roundcubemail-1.5.0/program/lib/Roundcube/rcube_user.php on line 726 (POST /mail/?_task=login&_action=login)
Oct 21 09:18:35 mail roundcube: <23kcqdii> PHP Error: Failed to create a user record. Maybe aborted by a plugin? in /opt/www/roundcubemail-1.5.0/program/include/rcmail.php on line 799 (POST /mail/?_task=login&_action=login)

====

The new user cannot login in to the roundcube

----

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

**Cthulhu** · 2021-10-16 01:18:59

Cthulhu
Member
Offline

Registered: 2019-06-04
Posts: 907

Re: The new user cannot login in to the roundcube

you should update to latest, since there were some database related changes

**ZhangHuangbin** · 2021-10-19 10:39:20

ZhangHuangbin
iRedMail Developers
Offline

Registered: 2009-05-06
Posts: 31,088

Re: The new user cannot login in to the roundcube

Seems you didn't correctly update Roundcube package?

**oermolaev** · 2021-10-19 22:23:44

oermolaev
Member
Offline

Registered: 2012-01-21
Posts: 12

Re: The new user cannot login in to the roundcube

ZhangHuangbin wrote:

Seems you didn't correctly update Roundcube package?

Perhaps .. I performed ./bin/installto.sh <target-folder> according to HowTo.
Old users are freely logging in Roundcube, but the newly created is not logined: "Unsuccessful login attempt"

**oermolaev** · 2021-10-21 14:32:08

oermolaev
Member
Offline

Registered: 2012-01-21
Posts: 12

Re: The new user cannot login in to the roundcube

Cthulhu wrote:

you should update to latest, since there were some database related changes

Updated all components to the latest versions. I also updated the post.

**ZhangHuangbin** · 2021-11-02 11:39:23

ZhangHuangbin
iRedMail Developers
Offline

Registered: 2009-05-06
Posts: 31,088

Re: The new user cannot login in to the roundcube

FYI: https://github.com/roundcube/roundcubemail/issues/5717

Did you check the console output when performing upgrade? It should report whether the SQL structure were successfully updated or failed.

**oermolaev** · 2021-11-02 15:07:04

oermolaev
Member
Offline

Registered: 2012-01-21
Posts: 12

Re: The new user cannot login in to the roundcube

ZhangHuangbin wrote:

FYI: https://github.com/roundcube/roundcubemail/issues/5717
Did you check the console output when performing upgrade? It should report whether the SQL structure were successfully updated or failed.

I updated iredmail a long time ago. This March. I don't remember the details, but I was pleased with the results of the update. Adding new users was not checked as there was no need.
Solution on your link? "The workaround would be to allow null values"?

**ZhangHuangbin** · 2021-11-09 09:42:55

ZhangHuangbin
iRedMail Developers
Offline

Registered: 2009-05-06
Posts: 31,088

Re: The new user cannot login in to the roundcube

It seems your upgrade missed some SQL structure in Roundcube sql db.

**oermolaev** · 2021-11-11 19:30:02

oermolaev
Member
Offline

Registered: 2012-01-21
Posts: 12

Re: The new user cannot login in to the roundcube

ZhangHuangbin wrote:

It seems your upgrade missed some SQL structure in Roundcube sql db.

Is it possible to recreate the SQL roundcubemail structure from scratch?
Or add the new user record to the SQL table manually?
Or can you suggest another direction?

**ZhangHuangbin** · 2021-11-12 18:03:41

ZhangHuangbin
iRedMail Developers
Offline

Registered: 2009-05-06
Posts: 31,088

Re: The new user cannot login in to the roundcube

Try to upgrade the SQL structure manually:

cd /opt/www/roundcubemail/
./bin/updatedb.sh --dir=./SQL --package roundcube

Pay close attention to the console output. If it doesn't work, please copy the full console output and paste here for troubleshooting.

**oermolaev** · 2021-11-15 17:41:57

oermolaev
Member
Offline

Registered: 2012-01-21
Posts: 12

Re: The new user cannot login in to the roundcube

ZhangHuangbin, here is the console output

root@mail:/opt/www/roundcubemail# ./bin/updatedb.sh --dir=./SQL --package roundcube
Updating database schema (2018021600)... [FAILED]
ERROR: Error in DDL upgrade 2018021600: [1050] Table 'filestore' already exists

**ZhangHuangbin** · 2021-11-15 19:33:27

ZhangHuangbin
iRedMail Developers
Offline

Registered: 2009-05-06
Posts: 31,088

Re: The new user cannot login in to the roundcube

Try to update file 2018021600.sql manually:

cd /opt/www/roundcubemail/SQL/mysql/
mysql roundcubemail

# Now it enters MySQL command line, below are SQL commands.

SOURCE 2018021600.sql;

What's the output? If it goes well, please import (with SQL command `SOURCE xxx.sql`) other NEW sql files too.

**oermolaev** · 2021-11-15 22:16:02

oermolaev
Member
Offline

Registered: 2012-01-21
Posts: 12

Re: The new user cannot login in to the roundcube

root@mail:/opt/www/roundcubemail/SQL/mysql# mysql roundcubemail 
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 117592
Server version: 10.3.29-MariaDB-0+deb10u1 Debian 10

Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [roundcubemail]> SOURCE 2018021600.sql;
ERROR 1050 (42S01) at line 1 in file: '2018021600.sql': Table 'filestore' already exists
MariaDB [roundcubemail]>

**oermolaev** · 2021-11-17 17:32:23

oermolaev
Member
Offline

Registered: 2012-01-21
Posts: 12

Re: The new user cannot login in to the roundcube

Despite this and other errors, after

import (with SQL command `SOURCE xxx.sql`) other NEW sql files too

the problem of logging into Roundcube for a new user is gone.
Has the problem been resolved?

**oermolaev** · 2021-11-17 18:09:32

oermolaev
Member
Offline

Registered: 2012-01-21
Posts: 12

Re: The new user cannot login in to the roundcube

ZhangHuangbin, anyway, coffee for you from me

Aug 5, 2024: iRedMail-1.7.1 has been released.

[ Closed ] The new user cannot login in to the roundcube

Posts: 15

1 Topic by oermolaev 2021-10-14 18:39:05 (edited by oermolaev 2021-10-21 14:36:41)

Topic: The new user cannot login in to the roundcube

2 Reply by Cthulhu 2021-10-16 01:18:59

Re: The new user cannot login in to the roundcube

3 Reply by ZhangHuangbin 2021-10-19 10:39:20

Re: The new user cannot login in to the roundcube

4 Reply by oermolaev 2021-10-19 22:23:44

Re: The new user cannot login in to the roundcube

5 Reply by oermolaev 2021-10-21 14:32:08

Re: The new user cannot login in to the roundcube

6 Reply by ZhangHuangbin 2021-11-02 11:39:23

Re: The new user cannot login in to the roundcube

7 Reply by oermolaev 2021-11-02 15:07:04

Re: The new user cannot login in to the roundcube

8 Reply by ZhangHuangbin 2021-11-09 09:42:55

Re: The new user cannot login in to the roundcube

9 Reply by oermolaev 2021-11-11 19:30:02

Re: The new user cannot login in to the roundcube

10 Reply by ZhangHuangbin 2021-11-12 18:03:41

Re: The new user cannot login in to the roundcube

11 Reply by oermolaev 2021-11-15 17:41:57

Re: The new user cannot login in to the roundcube

12 Reply by ZhangHuangbin 2021-11-15 19:33:27

Re: The new user cannot login in to the roundcube

13 Reply by oermolaev 2021-11-15 22:16:02

Re: The new user cannot login in to the roundcube

14 Reply by oermolaev 2021-11-17 17:32:23

Re: The new user cannot login in to the roundcube

15 Reply by oermolaev 2021-11-17 18:09:32

Re: The new user cannot login in to the roundcube

Posts: 15