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.

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 passwordbut I cannot login to roundcubemail nor squirrelmail, if I try to use the www@mydomain.com that was createdby 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.

]]>http://www.iredmail.org/forum/user1708.html2010-03-06T19:47:06Zhttp://www.iredmail.org/forum/post2908.html#p2908Well, 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]]>http://www.iredmail.org/forum/user2.html2010-03-06T14:40:51Zhttp://www.iredmail.org/forum/post2905.html#p2905ZhangHuangbin 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.

]]>http://www.iredmail.org/forum/user1708.html2010-03-06T14:34:16Zhttp://www.iredmail.org/forum/post2904.html#p2904Why not just update them in MYSQL?Find out all passwords of each mysql accounts, and use 'UPDATE' command to update exist accounts?]]>http://www.iredmail.org/forum/user2.html2010-03-06T10:53:29Zhttp://www.iredmail.org/forum/post2903.html#p2903I 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:ERRORUnknown 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!!

]]>http://www.iredmail.org/forum/user1708.html2010-03-06T03:20:16Zhttp://www.iredmail.org/forum/post2902.html#p2902I 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!