1 Topic by insanadair (edited by insanadair 2011-07-13 01:43:53)

  • insanadair
  • Member
  • Offline
  • Registered: 2010-07-29
  • Posts: 37

Topic: [SOLVED] internal server error

I use iredmail version 0.7.2 and Mysql backend

I installed iRedAdmin-0.1.5 and I opened web browser wrote this link -> https://mail.xxx.com/iredadmin then press enter and view login screen than entering user name : postmaster@xxx.com and pass = xxx click OK.

I have error. Error information is "internal server error"

I set to debug mode and mail_error_to_webmaster  is TRUE on setting.ini

I use user name : postmaster@xxx.com and pass = xxx Is my username and pasword have a wrong ? Where can I change ?

When I look at the error mail from server Error message information is below

Error information

<class '_mysql_exceptions.OperationalError'> at /login
(1045, "Access denied for user 'vmailadmin'@'localhost' (using password: YES)")

----

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

Re: [SOLVED] internal server error

insanadair wrote:

(1045, "Access denied for user 'vmailadmin'@'localhost' (using password: YES)")

As it mentioned here, you don't have correct password of MySQL user 'vmailadmin' in iRedAdmin config file 'settings.ini'. Please fix it first.

[vmaildb]
...
user = vmailadmin
passwd = plain_password           # <-- This password is incorrect.

3 Reply by insanadair (edited by insanadair 2011-07-13 16:32:02)

  • insanadair
  • Member
  • Offline
  • Registered: 2010-07-29
  • Posts: 37

Re: [SOLVED] internal server error

I changed vmaildb password on setting.ini but I try join this username : vmailadmin and password : xxxx than login  have a warning 

"Error : Username must be an valid email address"

When I look to iredadmin tables privilege  on Mysql 

I didint see vmailadmin

and than insert a vmailadmin below code

Add MySQL user and grant privileges:

        mysql> GRANT SELECT,INSERT,UPDATE,DELETE ON iredadmin.* TO vmailadmin@localhost IDENTIFIED BY 'my_passwd';
        mysql> FLUSH PRIVILEGES;

Try Again look to user privilege and I saw this bellow 

User             Host           Type                        Privileges           Grant
vmailadmin    localhost     database-specific     SELECT, INSERT, UPDATE, DELETE     No

But I Didn'nt join this username : vmailadmin  and password : my_password  Have a warning 

"Error : Username must be an valid email address"


How can I do please help me ?

4 Reply by ZhangHuangbin

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

Re: [SOLVED] internal server error

insanadair wrote:

"Error : Username must be an valid email address"

You're using incorrect username. Admin username must be an valid email address.
You can find a default one in iRedMail installation directory, for example, /root/iRedMail-0.7.2/iRedMail.tips, username is postmaster@[YOUR_DOMAIN].

5 Reply by insanadair (edited by insanadair 2011-07-13 18:35:56)

  • insanadair
  • Member
  • Offline
  • Registered: 2010-07-29
  • Posts: 37

Re: [SOLVED] internal server error

I didin't use iredadmin pro I want use iredadmin 0.5 version

I found my admin username  and password  on iRedMail.tips

I try use ( username :postmaster@[My_Domain]  and Password : My Password ) But have a error 

 internal server error

and Mail log is bellow

<class '_mysql_exceptions.OperationalError'> at /login
(1044, "Access denied for user 'vmailadmin'@'localhost' to database 'vmail'")

Now I didin't join postfixadmin same error

DEBUG INFORMATION:
Connect: Access denied for user 'vmailadmin'@'localhost' (using password: YES)

Please check the documentation and website for more information.

Postfix Admin
Forums

6 Reply by insanadair (edited by insanadair 2011-07-13 21:09:50)

  • insanadair
  • Member
  • Offline
  • Registered: 2010-07-29
  • Posts: 37

Re: [SOLVED] internal server error

I Added user acount on Mysql show below

GRANT SELECT,INSERT,DELETE,UPDATE ON vmail.* TO vmailadmin@localhost IDENTIFIED BY "password";
FLUSH PRIVILEGES;

I joined to iredadmin no problem but now I didn't join postfixadmin

I try login postfixadmin  show below 

DEBUG INFORMATION:
Connect: Access denied for user 'vmailadmin'@'localhost' (using password: YES)

Please check the documentation and website for more information.

Postfix Admin
Forums

What is problem ! How can I join postfixadmin ?

7 Reply by ZhangHuangbin

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

Re: [SOLVED] internal server error

insanadair wrote:

GRANT SELECT,INSERT,DELETE,UPDATE ON vmail.* TO vmailadmin@localhost IDENTIFIED BY "password";

You changed password of MySQL user 'vmailadmin', so you should update PostfixAdmin config file with new password too.

8 Reply by insanadair

  • insanadair
  • Member
  • Offline
  • Registered: 2010-07-29
  • Posts: 37

Re: [SOLVED] internal server error

Works!
Thanks!

ZhangHuangbin wrote:
insanadair wrote:

GRANT SELECT,INSERT,DELETE,UPDATE ON vmail.* TO vmailadmin@localhost IDENTIFIED BY "password";

You changed password of MySQL user 'vmailadmin', so you should update PostfixAdmin config file with new password too.