1 Topic by mike0929

  • mike0929
  • Member
  • Offline
  • Registered: 2010-03-02
  • Posts: 11

Topic: Access Problems

I accidentally overwrote all mysql databases from another server and it broke all my access to roundcubemail and postfixadmin how can I manually restore just the mysql data, I have been able to restore the vmail and roundcubemail databases and tables but I'm struggling with the passwords set in the mysql->user table these passwords do not match, how were they inserted? was the password function used? I also see that when I open the sql files created with the iredmail installation those passwords are encrypted, any pointers?

Thank you!

BTW, I love this product I was able to use for two days before I messed it up and It was already making my life easier, thanks a lot!

----

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

2 Reply by mike0929 (edited by mike0929 2010-03-06 11:21:49)

  • mike0929
  • Member
  • Offline
  • Registered: 2010-03-02
  • Posts: 11

Re: Access Problems

I went ahead and uninstalled everything using the script clear_iredmail.sh and deleted the iredmail folder and I started over from scratch and I still cannot access anything:
Postfixadmin I get:
DEBUG INFORMATION:
Connect: Access denied for user 'vmailadmin'@'localhost' (using password: YES)
Please check the documentation and website for more information.

Roundcubemail I get:
Login Failed

SquirrelMail I get:
ERROR
Unknown user or password incorrect.

Awstats the same, I cannot authenticate.

I have triple checked all the passwords and they are the same I provided during installation, If I try to connect with an email client I cannot login to the default email either.

Please help!!

3 Reply by ZhangHuangbin

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

Re: Access Problems

Why not just update them in MYSQL?
Find out all passwords of each mysql accounts, and use 'UPDATE' command to update exist accounts?

4 Reply by mike0929

  • mike0929
  • Member
  • Offline
  • Registered: 2010-03-02
  • Posts: 11

Re: Access Problems

ZhangHuangbin wrote:

Why not just update them in MYSQL?
Find out all passwords of each mysql accounts, and use 'UPDATE' command to update exist accounts?

Thank you for your reply.  Which mysql function was used to insert the password? password, md5 or encrypt? Whenever I use one of these functions and restart mysql they still don't work.

5 Reply by ZhangHuangbin

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

Re: Access Problems

Well, iRedMail just creates new databases and grants privileges on them. password() should be OK.
Search 'GRANT' on this file:
http://iredmail.googlecode.com/hg/iRedM … s/mysql.sh

6 Reply by mike0929

  • mike0929
  • Member
  • Offline
  • Registered: 2010-03-02
  • Posts: 11

Re: Access Problems

ZhangHuangbin wrote:

Well, iRedMail just creates new databases and grants privileges on them. password() should be OK.
Search 'GRANT' on this file:
http://iredmail.googlecode.com/hg/iRedM … s/mysql.sh

Thank you Zhang I got the following from that file:

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

I edited:
/var/www/postfixadmin/config.local.php

Changed this

$CONF['database_password'] = "password";

And that dit it, I now have access to postfixadmin.

Now I added a new domain and then a new mailbox under this new domain using "password" as my password
but I cannot login to roundcubemail nor squirrelmail, if I try to use the www@mydomain.com that was created
by default during installation where all root mail gets forwarded to, it doesn't work either.

postfixadmin does add the new mailbox because I can see it using phpmyadmin.

Do I have to restart a service after adding the new mailbox? I restarted postfix, dovecot and nothing works.

My firewall is not blocking these services all the ports are open

ACCEPT     tcp  --  0.0.0.0/0            0.0.0.0/0           tcp dpt:80
ACCEPT     tcp  --  0.0.0.0/0            0.0.0.0/0           tcp dpt:443
ACCEPT     tcp  --  0.0.0.0/0            0.0.0.0/0           tcp dpt:25
ACCEPT     tcp  --  0.0.0.0/0            0.0.0.0/0           tcp dpt:110
ACCEPT     tcp  --  0.0.0.0/0            0.0.0.0/0           tcp dpt:20
ACCEPT     tcp  --  0.0.0.0/0            0.0.0.0/0           tcp dpt:465
ACCEPT     tcp  --  0.0.0.0/0            0.0.0.0/0           tcp dpt:995
ACCEPT     tcp  --  0.0.0.0/0            0.0.0.0/0           tcp dpt:143
ACCEPT     tcp  --  0.0.0.0/0            0.0.0.0/0           tcp dpt:993
ACCEPT     tcp  --  0.0.0.0/0            0.0.0.0/0           tcp dpt:587
ACCEPT     tcp  --  0.0.0.0/0            0.0.0.0/0           tcp dpt:465
ACCEPT     tcp  --  0.0.0.0/0            0.0.0.0/0           tcp dpt:22
ACCEPT     tcp  --  0.0.0.0/0            0.0.0.0/0           tcp dpt:53
ACCEPT     udp  --  0.0.0.0/0            0.0.0.0/0           udp dpt:53
ACCEPT     tcp  --  0.0.0.0/0            0.0.0.0/0           tcp dpt:953
ACCEPT     udp  --  0.0.0.0/0            0.0.0.0/0           udp dpt:953

Trying with an email client I cannot login either, please help!!

Thank you.

7 Reply by ZhangHuangbin

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

Re: Access Problems

Webmail uses IMAP protocol, so you should troubleshoot dovecot first.

8 Reply by mike0929

  • mike0929
  • Member
  • Offline
  • Registered: 2010-03-02
  • Posts: 11

Re: Access Problems

ZhangHuangbin wrote:

Webmail uses IMAP protocol, so you should troubleshoot dovecot first.

Thank you again for your reply, the first time I uninstalled during the uninstallation I didn't remove certain stuff but I tried uninstalling again and this time I removed EVERYTHING and started over fresh, everything is working fine now.

I want to thank you for this wonderful software I love it. I'm going to test it a bit further and more than likely I will be buying the Full-featured Edition.