1 Topic by RoddYcK

  • RoddYcK
  • Member
  • Offline
  • Registered: 2015-09-02
  • Posts: 5

Topic: /iredadmin/login?msg=INVALID_CREDENTIALS mysql no

==== Required information ====
- iRedMail version: 0.9.2.
- Store mail accounts in which backend (LDAP/MySQL/PGSQL): MySQL
- Linux/BSD distribution name and version: Ubuntu server
- Related log if you're reporting an issue:
====

Hello in this forum (http://www.iredmail.org/forum/topic5230 … tials.html) I saw the solution for invalid user mistake is to update a MySQL user and password postmaster, but When trying to run MySQL Gives me the following Error

ERROR 1045 (28000): Access denied for user 'root' @ 'localhost' (using password: NO)

If anyone can help I would be eternally grateful. Excuse my English is horrible XD

----

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

Re: /iredadmin/login?msg=INVALID_CREDENTIALS mysql no

RoddYcK wrote:

ERROR 1045 (28000): Access denied for user 'root' @ 'localhost' (using password: NO)

Did you type root password? for example:

$ mysql -uroot -p

It will prompt you to type root password. Otherwise you cannot login to sql server and execute further sql commands.

3 Reply by RoddYcK

  • RoddYcK
  • Member
  • Offline
  • Registered: 2015-09-02
  • Posts: 5

Re: /iredadmin/login?msg=INVALID_CREDENTIALS mysql no

if it works, thanks, I have another problem when trying to do an update to the postmaster user and password, according to the other post is:
mysql> USE vmail;
mysql> UPDATE mailbox SET password='{PLAIN}123456' WHERE username='postmaster@[your_domain]';

I do not understand is "{PLAIN}123456" That's the example password or {PLAIN} is a command?

Running this command

mysql> mysql> UPDATE mailbox SET password='contraseña' WHERE username='postmaster@midominio.cl';
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'mysql> UPDATE mailbox SET password='contraseña' WHERE username='postmaster@acti' at line 1

help me pls ;<

4 Reply by ZhangHuangbin

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

Re: /iredadmin/login?msg=INVALID_CREDENTIALS mysql no

RoddYcK wrote:

I do not understand is "{PLAIN}123456" That's the example password or {PLAIN} is a command?

{PLAIN} is the password scheme name, a prefix for password.

Please read our tutorial: http://www.iredmail.org/docs/password.hashes.html

RoddYcK wrote:

mysql> UPDATE mailbox SET password='contraseña' WHERE username='postmaster@midominio.cl';
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'mysql> UPDATE mailbox SET password='contraseña' WHERE username='postmaster@acti' at line 1

Please don't use NON-ASCII characters in password.

5 Reply by RoddYcK (edited by RoddYcK 2015-09-03 11:43:50)

  • RoddYcK
  • Member
  • Offline
  • Registered: 2015-09-02
  • Posts: 5

Re: /iredadmin/login?msg=INVALID_CREDENTIALS mysql no

Ok, then in this case the new password is 123456?

sql> UPDATE mailbox SET password='{PLAIN}123456' WHERE username='xx@xx';

Because I still sent Error: Username or password is incorrect.

Sorry try to read the tutorial but my English is very bad.

6 Reply by ZhangHuangbin

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

Re: /iredadmin/login?msg=INVALID_CREDENTIALS mysql no

RoddYcK wrote:

Ok, then in this case the new password is 123456?
sql> UPDATE mailbox SET password='{PLAIN}123456' WHERE username='xx@xx';

Yes, the password is 123456.

RoddYcK wrote:

Because I still sent Error: Username or password is incorrect.

Please turn on debug mode in Dovecot to see why it doesn't work:
http://www.iredmail.org/docs/debug.dovecot.html

Please do turn on below two:

auth_debug_passwords = yes
auth_verbose_passwords = yes

7 Reply by RoddYcK

  • RoddYcK
  • Member
  • Offline
  • Registered: 2015-09-02
  • Posts: 5

Re: /iredadmin/login?msg=INVALID_CREDENTIALS mysql no

I already did ... and now what? I run this command?
Dovecot -c /etc/dovecot/dovecot.conf

Result: Segmentation fault (core dumped)

P.D: Already made service dovecot restart
P.D2: Thank you for the help big_smile

8 Reply by ZhangHuangbin

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

Re: /iredadmin/login?msg=INVALID_CREDENTIALS mysql no

After you have debug option enabled, restart dovecot, try to reproduce this issue, then check Dovecot log file to see why you cannot login.

9 Reply by RoddYcK

  • RoddYcK
  • Member
  • Offline
  • Registered: 2015-09-02
  • Posts: 5

Re: /iredadmin/login?msg=INVALID_CREDENTIALS mysql no

Is this?

Sep 01 20:10:54 master: Info: Dovecot v2.2.9 starting up (core dumps disabled)
Sep 01 20:10:55 ssl-params: Warning: Regenerating /var/lib/dovecot/ssl-parameters.dat for ssl_dh_parameters_length=2048
Sep 01 20:10:55 ssl-params: Info: Generating SSL parameters
Sep 01 20:18:59 ssl-params: Info: SSL parameters regeneration completed
Sep 01 21:42:22 pop3-login: Info: Disconnected (no auth attempts in 1 secs): user=<>, rip=198.20.69.98, lip=104.131.183.90, session=<9Wsgx7keawDGFEVi>
Sep 01 23:54:59 lmtp(1163): Warning: Killed with signal 15 (by pid=1 uid=0 code=kill)
Sep 01 23:54:59 lmtp(1162): Warning: Killed with signal 15 (by pid=1 uid=0 code=kill)
Sep 01 23:54:59 lmtp(1161): Warning: Killed with signal 15 (by pid=1 uid=0 code=kill)
Sep 01 23:54:59 lmtp(1160): Warning: Killed with signal 15 (by pid=1 uid=0 code=kill)
Sep 01 23:54:59 lmtp(1156): Warning: Killed with signal 15 (by pid=1 uid=0 code=kill)
Sep 01 23:54:59 anvil: Warning: Killed with signal 15 (by pid=1 uid=0 code=kill)
Sep 01 23:54:59 log: Warning: Killed with signal 15 (by pid=1 uid=0 code=kill)
Sep 01 23:54:59 master: Warning: Killed with signal 15 (by pid=1 uid=0 code=kill)
Sep 02 01:11:44 master: Info: Dovecot v2.2.9 starting up (core dumps disabled)
Sep 02 01:37:31 lmtp(1181): Warning: Killed with signal 15 (by pid=1 uid=0 code=kill)
Sep 02 01:37:31 lmtp(1180): Warning: Killed with signal 15 (by pid=1 uid=0 code=kill)
Sep 02 01:37:31 lmtp(1179): Warning: Killed with signal 15 (by pid=1 uid=0 code=kill)
Sep 02 01:37:31 lmtp(1175): Warning: Killed with signal 15 (by pid=1 uid=0 code=kill)
Sep 02 01:37:31 anvil: Warning: Killed with signal 15 (by pid=1 uid=0 code=kill)
Sep 02 01:37:31 log: Warning: Killed with signal 15 (by pid=1 uid=0 code=kill)
Sep 02 01:37:31 master: Warning: Killed with signal 15 (by pid=1 uid=0 code=kill)
Sep 02 01:37:31 lmtp(1182): Warning: Killed with signal 15 (by pid=1 uid=0 code=kill)
Sep 02 12:49:51 master: Info: Dovecot v2.2.9 starting up (core dumps disabled)
Sep 02 13:24:30 lmtp(1157): Warning: Killed with signal 15 (by pid=1 uid=0 code=kill)
Sep 02 13:24:30 lmtp(1155): Warning: Killed with signal 15 (by pid=1 uid=0 code=kill)
Sep 02 13:24:30 lmtp(1151): Warning: Killed with signal 15 (by pid=1 uid=0 code=kill)
Sep 02 13:24:30 lmtp(1156): Warning: Killed with signal 15 (by pid=1 uid=0 code=kill)
Sep 02 13:24:30 anvil: Warning: Killed with signal 15 (by pid=1 uid=0 code=kill)
Sep 02 13:24:30 log: Warning: Killed with signal 15 (by pid=1 uid=0 code=kill)
Sep 02 13:24:30 master: Warning: Killed with signal 15 (by pid=1 uid=0 code=kill)
Sep 02 13:24:30 lmtp(1158): Warning: Killed with signal 15 (by pid=1 uid=0 code=kill)
Sep 02 23:04:08 master: Info: Dovecot v2.2.9 starting up (core dumps disabled)
Sep 02 23:59:56 lmtp(1186): Warning: Killed with signal 15 (by pid=1 uid=0 code=kill)
Sep 02 23:59:56 lmtp(1190): Warning: Killed with signal 15 (by pid=1 uid=0 code=kill)
Sep 02 23:59:56 lmtp(1193): Warning: Killed with signal 15 (by pid=1 uid=0 code=kill)
Sep 02 23:59:56 lmtp(1194): Warning: Killed with signal 15 (by pid=1 uid=0 code=kill)
Sep 02 23:59:56 master: Warning: Killed with signal 15 (by pid=1 uid=0 code=kill)
Sep 02 23:59:56 log: Warning: Killed with signal 15 (by pid=1 uid=0 code=kill)
Sep 02 23:59:56 lmtp(1191): Warning: Killed with signal 15 (by pid=1 uid=0 code=kill)
Sep 03 01:33:10 master: Info: Dovecot v2.2.9 starting up (core dumps disabled)
Sep 03 01:38:36 lmtp(1181): Warning: Killed with signal 15 (by pid=1 uid=0 code=kill)
Sep 03 01:38:36 log: Warning: Killed with signal 15 (by pid=1 uid=0 code=kill)
Sep 03 01:38:36 lmtp(1180): Warning: Killed with signal 15 (by pid=1 uid=0 code=kill)
Sep 03 01:38:36 master: Warning: Killed with signal 15 (by pid=1 uid=0 code=kill)
Sep 03 01:38:36 lmtp(1179): Warning: Killed with signal 15 (by pid=1 uid=0 code=kill)
Sep 03 01:38:36 anvil: Warning: Killed with signal 15 (by pid=1 uid=0 code=kill)
Sep 03 01:38:36 lmtp(1174): Warning: Killed with signal 15 (by pid=1 uid=0 code=kill)
Sep 03 01:38:36 lmtp(1182): Warning: Killed with signal 15 (by pid=1 uid=0 code=kill)
Sep 03 01:38:36 master: Info: Dovecot v2.2.9 starting up (core dumps disabled)
Sep 03 01:40:56 lmtp(2370): Warning: Killed with signal 15 (by pid=1 uid=0 code=kill)
Sep 03 01:40:56 lmtp(2369): Warning: Killed with signal 15 (by pid=1 uid=0 code=kill)
Sep 03 01:40:56 lmtp(2368): Warning: Killed with signal 15 (by pid=1 uid=0 code=kill)
Sep 03 01:40:56 lmtp(2367): Warning: Killed with signal 15 (by pid=1 uid=0 code=kill)
Sep 03 01:40:56 lmtp(2363): Warning: Killed with signal 15 (by pid=1 uid=0 code=kill)
Sep 03 01:40:56 anvil: Warning: Killed with signal 15 (by pid=1 uid=0 code=kill)
Sep 03 01:40:56 log: Warning: Killed with signal 15 (by pid=1 uid=0 code=kill)
Sep 03 01:40:56 master: Warning: Killed with signal 15 (by pid=1 uid=0 code=kill)
Sep 03 01:40:56 master: Info: Dovecot v2.2.9 starting up (core dumps disabled)
Sep 03 01:45:33 lmtp(2404): Warning: Killed with signal 15 (by pid=1 uid=0 code=kill)
Sep 03 01:45:33 lmtp(2403): Warning: Killed with signal 15 (by pid=1 uid=0 code=kill)
Sep 03 01:45:33 lmtp(2402): Warning: Killed with signal 15 (by pid=1 uid=0 code=kill)
Sep 03 01:45:33 lmtp(2401): Warning: Killed with signal 15 (by pid=1 uid=0 code=kill)
Sep 03 01:45:33 anvil: Warning: Killed with signal 15 (by pid=1 uid=0 code=kill)
Sep 03 01:45:33 log: Warning: Killed with signal 15 (by pid=1 uid=0 code=kill)
Sep 03 01:45:33 lmtp(2397): Warning: Killed with signal 15 (by pid=1 uid=0 code=kill)
Sep 03 01:45:33 master: Warning: Killed with signal 15 (by pid=1 uid=0 code=kill)

10 Reply by ZhangHuangbin

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

Re: /iredadmin/login?msg=INVALID_CREDENTIALS mysql no

There's no login related log at all...

Please turn to login to webmail, and paste related log in dovecot log file.