Hello: I have a working hMail setup running under Windows Server 2008R2.
Adding Webmail, I first installed WAMPServer. I have used this before. This gives me Apache 2.4.41, PHP7.4 and MYSQL 8.0.18
I have placed a Roundcube folder into the Wamp Server web directory 'www'. All the contents of this folder are from the roundcube download.
In PHPMYADMIN I have created a MYSQL database called roundcubemail, and a user in this database called roundcube. This user has a pa55w0rd 'XXXXX'.
I have also imported the initial SQL file 'mysql.initial.sql' so all the required columns etc. appear in the roundcubemail database.
The roundcube webmail installer process checks things before it starts. It always says 'NOT OK' for my database. EVERYTHING else works fine.
The error I always get is: DSN (write): NOT OK (SQLSTATE[HY000][1045] Access denied for user 'roundcube'@'localhost' (using password: YES))
In the roundcube 'config' folder. there is a config.inc.php file. (there is no db.inc.php file).
Can someone advise the correct format for the line: $config['db_dsnw']?? Should this include the pa55w0rd 'XXXXX' somewhere? Or is the pa55w0rd in a different config.inc.php line??
I find documentation examples on here etc. apply to older versions of SQL and Roundcube. I have created (and dropped) many databases in an attempt to get this right.
Any information would be welcome. Thank you for your time. If you need any more info, please reply.
The database information should be in the <RC root>/config/config.inc.php file with the format shown below:
// Database connection string (DSN) for read+write operations
// Format (compatible with PEAR MDB2): db_provider://user:password@host/database
// Currently supported db_providers: mysql, pgsql, sqlite, mssql, sqlsrv, oracle
// For examples see http://pear.php.net/manual/en/package.database.mdb2.intro-dsn.php
// NOTE: for SQLite use absolute path (Linux): 'sqlite:////full/path/to/sqlite.db?mode=0646'
// or (Windows): 'sqlite:///C:/full/path/to/sqlite.db'
$config['db_dsnw'] = 'mysql://roundcube:pass@localhost/roundcubemail';