1 Topic by djfake

  • djfake
  • Member
  • Offline
  • Registered: 2013-06-28
  • Posts: 61

Topic: error with new mail user

==== REQUIRED BASIC INFO OF YOUR IREDMAIL SERVER ====
- iRedMail version (check /etc/iredmail-release): 0.9.2
- Deployed with iRedMail Easy or the downloadable installer?
- Linux/BSD distribution name and version: 16.04
- Store mail accounts in which backend (LDAP/MySQL/PGSQL): Mysql
- Web server (Apache or Nginx): Apache2
- Manage mail accounts with iRedAdmin-Pro? No
- [IMPORTANT] Related original log or error message is required if you're experiencing an issue.
====
Newly created user cannot log into Roundcubemail v1.3.8

This is from syslog:

DB Error: [1364] Field 'alias' doesn't have a default value (SQL Query: INSERT INTO `users` (`created`, `last_login`, `username`, `mail_host`, `language`) VALUES (now(), now(), 'user@host', '127.0.0.1', 'en_US')) in /usr/share/apache2/roundcubemail-0.8.6/program/lib/Roundcube/rcube_db.php on line 543 (POST /mail/?_task=login&_action=login)

thank you for insights.

----

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,091

Re: error with new mail user

Seems your Roundcube SQL table has some issue.

- How about try to upgrade Roundcube to the latest 1.3.9?
- How did you upgrade Roundcube?

3 Reply by djfake

  • djfake
  • Member
  • Offline
  • Registered: 2013-06-28
  • Posts: 61

Re: error with new mail user

Updated to 1.3.9.
It went OKAY, but tThis error during upgrade:
Updating database schema (2013011000)... [FAILED]
Error 500: Error in DDL upgrade 2013011000: [1142] CREATE command denied to user 'roundcube'@'localhost' for table 'system'

Note older users can still log in just fine. Only newly created user cannot log into roundcubemail:

Error from syslog:
Apr 30 08:40:00: <s0sc8e50> DB Error: [1364] Field 'alias' doesn't have a default value (SQL Query: INSERT INTO `users` (`created`, `last_login`, `username`, `mail_host`, `language`) VALUES (now(), now(), 'user@domain', '127.0.0.1', 'en_US')) in /usr/share/apache2/roundcubemail-0.8.6/program/lib/Roundcube/rcube_db.php on line 543 (POST /mail/?_task=login&_action=login)

4 Reply by ZhangHuangbin

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

Re: error with new mail user

djfake wrote:

It went OKAY, but tThis error during upgrade:
Updating database schema (2013011000)... [FAILED]

Try to import SQL file "2013011000.sql" under /usr/share/apache2/roundcubemail-0.8.6/SQL/mysql/ (i suppose "roundcubemail-0.8.6" is actually 1.3.9 now?), also all SQL files under same directory which are newer than 2013011000.sql (the file names contain YEAR-MONTH-DAY, it's easy to recognize which ones are newer).