Problems during installation

[bgbearcatfan]

I am experiencing issues getting roundcube up and running with MySQL.

During the install process everything goes well until the very end.  I receive an error message during the process of checking my installation:



main.inc.php: OK
db.inc.php: OK

Check if directories are writable

RoundCube may need to write/save files into these directories

temp/: OK
logs/: OK

Check configured database settings
DSN (write): NOT OK (MDB2 Error: connect failed)

Make sure that the configured database exists and that the user has write privileges
DSN: mysql://root:password@localhost/roundcubemail



If i try to get to the log in page, i get the following error:



DATABASE ERROR: CONNECTION FAILED!

Unable to connect to the database!
Please contact your server-administrator.



I have no idea what is going on... The database 'roundcubemail' exists and user 'root' has full access to the database.  Below are the specs of the server.

Windows Server 2008
MySQL 5.1.46 running on port 3306 @ localhost
PHP 5.3.2 via FastCGI on IIS 7

The prefix option wouldn't let me select the latest roundcube version so i am using .4 but have also tried the stable 3.1 version and get the same error.

Any ideas what my problem is? Am I using an incompatible version of any of the above?

[dziobak]

create new user and assingn him privileges. dont use root to access databases. IMO the root access should be disabled

[bgbearcatfan]

We were using root only as a troubleshooting step, in regards to a possible permissions issue.

The problem ended up being that the new version of php acts funky with windows server 2008 and ipv6.  Instead of using "localhost" as the mysql server address, i needed to use "127.0.0.1".

All is working now.  Thanks for the reply.