1 Topic by mangaan

  • mangaan
  • Member
  • Offline
  • Registered: 2010-10-29
  • Posts: 16

Topic: Change iredadmin password

==== Required information ====
- iRedMail version: 0.8.3
- Store mail accounts in which backend (LDAP/MySQL/PGSQL): MySQL
- Linux/BSD distribution name and version: Centos 6.3
- Related log if you're reporting an issue:  ssl_error_log
[Mon Dec 17 15:03:41 2012] [error] [client xx.xxx.8.131]     return p(lambda: process(processors))
[Mon Dec 17 15:03:41 2012] [error] [client xx.xxx.8.131]   File "/usr/lib/python2.6/site-packages/web/session.py", line 82, in _processor
[Mon Dec 17 15:03:41 2012] [error] [client xx.xxx.8.131]     self._cleanup()
[Mon Dec 17 15:03:41 2012] [error] [client xx.xxx.8.131]   File "/usr/lib/python2.6/site-packages/web/session.py", line 168, in _cleanup
[Mon Dec 17 15:03:41 2012] [error] [client xx.xxx.8.131]     self.store.cleanup(timeout)
[Mon Dec 17 15:03:41 2012] [error] [client xx.xxx.8.131]   File "/usr/lib/python2.6/site-packages/web/session.py", line 315, in cleanup
[Mon Dec 17 15:03:41 2012] [error] [client xx.xxx.8.131]     self.db.delete(self.table, where="$last_allowed_time > atime", vars=locals())
[Mon Dec 17 15:03:41 2012] [error] [client xx.xxx.8.131]   File "/usr/lib/python2.6/site-packages/web/db.py", line 906, in delete
[Mon Dec 17 15:03:41 2012] [error] [client xx.xxx.8.131]     db_cursor = self._db_cursor()
[Mon Dec 17 15:03:41 2012] [error] [client xx.xxx.8.131]   File "/usr/lib/python2.6/site-packages/web/db.py", line 566, in _db_cursor
[Mon Dec 17 15:03:41 2012] [error] [client xx.xxx.8.131]     return self.ctx.db.cursor()
[Mon Dec 17 15:03:41 2012] [error] [client xx.xxx.8.131]   File "/usr/lib/python2.6/site-packages/web/db.py", line 507, in _getctx
[Mon Dec 17 15:03:41 2012] [error] [client xx.xxx.8.131]     self._load_context(self._ctx)
[Mon Dec 17 15:03:41 2012] [error] [client xx.xxx.8.131]   File "/usr/lib/python2.6/site-packages/web/db.py", line 518, in _load_context
[Mon Dec 17 15:03:41 2012] [error] [client xx.xxx.8.131]     ctx.db = self._connect(self.keywords)
[Mon Dec 17 15:03:41 2012] [error] [client xx.xxx.8.131]   File "/usr/lib/python2.6/site-packages/web/db.py", line 546, in _connect
[Mon Dec 17 15:03:41 2012] [error] [client xx.xxx.8.131]     return self.db_module.connect(**keywords)
[Mon Dec 17 15:03:41 2012] [error] [client xx.xxx.8.131]   File "/usr/lib64/python2.6/site-packages/MySQLdb/__init__.py", line 81, in Connect
[Mon Dec 17 15:03:41 2012] [error] [client xx.xxx.8.131]     return Connection(*args, **kwargs)
[Mon Dec 17 15:03:41 2012] [error] [client xx.xxx.8.131]   File "/usr/lib64/python2.6/site-packages/MySQLdb/connections.py", line 187, in __init__
[Mon Dec 17 15:03:41 2012] [error] [client xx.xxx.8.131]     super(Connection, self).__init__(*args, **kwargs2)
[Mon Dec 17 15:03:41 2012] [error] [client xx.xxx.8.131] OperationalError: (1045, "Access denied for user 'iredadmin'@'localhost' (using password: YES)")
[Mon Dec 17 15:03:41 2012] [error] [client xx.xxx.8.131]
====

Hello Try to change iredadmin password in console because I forgot it after a change in de webgui.

First I change it for the user iredadmin in de mysql database iredadmin

But now when I want to access the web interface I get a internal server error

Think it was to easy to change it like that

----

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: Change iredadmin password

mangaan wrote:

Hello Try to change iredadmin password in console because I forgot it after a change in de webgui.

How did you change it? Detailed shell/SQL commands please.

mangaan wrote:

First I change it for the user iredadmin in de mysql database iredadmin
But now when I want to access the web interface I get a internal server error

Did you update it in iRedAdmin config file /var/www/iredadmin/settings.ini? For example:

[iredadmin]
# Database used to store iRedAdmin data. e.g. sessions, log.
host = 127.0.0.1
port = 5432
db = iredadmin
user = iredadmin
passwd = [NEW_PASSWORD_HERE]

3 Reply by mangaan (edited by mangaan 2012-12-19 01:06:58)

  • mangaan
  • Member
  • Offline
  • Registered: 2010-10-29
  • Posts: 16

Re: Change iredadmin password

I change it via an sql update command

mysql -uroot -p
use iredadmin;
UPDATE mysql.user SET Password=PASSWORD('new-password') WHERE User='iredadmin' AND Host='host-name';

I change the password as you suggest in :

/var/www/iredadmin/settings.ini

And hurray the web interface returned back, but still not possible to login with the new password :-(((((

Pulling al my hair out !!!!

Is there any way to solve my problem??

4 Reply by mangaan

  • mangaan
  • Member
  • Offline
  • Registered: 2010-10-29
  • Posts: 16

Re: Change iredadmin password

Can I reinstall the software and keep the users mailboxes?

5 Reply by ZhangHuangbin

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

Re: Change iredadmin password

mangaan wrote:

And hurray the web interface returned back, but still not possible to login with the new password :-(((((

The password you reset is not used for logging into iRedAdmin web interface. You can find username/password in your iRedMail installation directory, for example, /root/iRedMail-0.8.3/iRedMail.tips.

6 Reply by mangaan (edited by mangaan 2012-12-27 01:34:12)

  • mangaan
  • Member
  • Offline
  • Registered: 2010-10-29
  • Posts: 16

Re: Change iredadmin password

Yes there you can find the initial installation account information
But that was not where I'm looking for because I change that in the gui, and now I can't login anymore.

DO you offer paid support to solved my problem?