Topic: Connect iRedMail+roundcube to mysql
Hi there...
I've just installed iRedMail+Roundecube on my server Debian Lenny, and, since in my server already exists a working mysql database, i couldn't let the instalation changes my dg config. I did everything i could think to conect them to mysql, however i can't make it work. In Roundcube webmail, i recieve this message "Username or password invalid" or something like that... On Roundcube database exists the user, but has no pass, and in the vmail database existis the user and the pass (both created using the sql scripts provided by the instalation of iRedMail) but i can't link them two, as i imagine it should be.
my db connection string: $rcmail_config['db_dsnw'] = 'mysql://roundcube:pass@localhost/roundcubemail'; - where pass is my actual password -
my two schemas:
mysql> select * from information_schema.TABLES where TABLE_SCHEMA = 'vmail';
+---------------+--------------+----------------------+------------+--------+---------+------------+------------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+---------------------+------------+-----------------+----------+----------------+---------------+
| TABLE_CATALOG | TABLE_SCHEMA | TABLE_NAME | TABLE_TYPE | ENGINE | VERSION | ROW_FORMAT | TABLE_ROWS | AVG_ROW_LENGTH | DATA_LENGTH | MAX_DATA_LENGTH | INDEX_LENGTH | DATA_FREE | AUTO_INCREMENT | CREATE_TIME | UPDATE_TIME | CHECK_TIME | TABLE_COLLATION | CHECKSUM | CREATE_OPTIONS | TABLE_COMMENT |
+---------------+--------------+----------------------+------------+--------+---------+------------+------------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+---------------------+------------+-----------------+----------+----------------+---------------+
| NULL | vmail | admin | BASE TABLE | MyISAM | 10 | Dynamic | 1 | 108 | 108 | 281474976710655 | 11264 | 0 | NULL | 2011-10-11 16:14:42 | 2011-10-11 16:14:42 | NULL | utf8_general_ci | NULL | | |
| NULL | vmail | alias | BASE TABLE | MyISAM | 10 | Dynamic | 1 | 128 | 128 | 281474976710655 | 14336 | 0 | NULL | 2011-10-11 16:14:42 | 2011-10-11 16:14:42 | NULL | utf8_general_ci | NULL | | |
| NULL | vmail | alias_domain | BASE TABLE | MyISAM | 10 | Dynamic | 0 | 0 | 0 | 281474976710655 | 4096 | 0 | NULL | 2011-10-11 16:14:42 | 2011-10-11 16:14:42 | NULL | utf8_general_ci | NULL | | |
| NULL | vmail | domain | BASE TABLE | MyISAM | 10 | Dynamic | 1 | 72 | 72 | 281474976710655 | 11264 | 0 | NULL | 2011-10-11 16:14:42 | 2011-10-11 16:14:42 | NULL | utf8_general_ci | NULL | | |
| NULL | vmail | domain_admins | BASE TABLE | MyISAM | 10 | Dynamic | 1 | 68 | 68 | 281474976710655 | 12288 | 0 | NULL | 2011-10-11 16:14:42 | 2011-10-11 16:14:42 | NULL | utf8_general_ci | NULL | | |
| NULL | vmail | mailbox | BASE TABLE | InnoDB | 10 | Compact | 1 | 16384 | 16384 | 0 | 311296 | 53477376 | NULL | 2011-10-14 16:40:58 | NULL | NULL | utf8_general_ci | NULL | | |
| NULL | vmail | recipient_bcc_domain | BASE TABLE | MyISAM | 10 | Dynamic | 0 | 0 | 0 | 281474976710655 | 4096 | 0 | NULL | 2011-10-11 16:14:42 | 2011-10-11 16:14:42 | NULL | utf8_general_ci | NULL | | |
| NULL | vmail | recipient_bcc_user | BASE TABLE | MyISAM | 10 | Dynamic | 0 | 0 | 0 | 281474976710655 | 4096 | 0 | NULL | 2011-10-11 16:14:42 | 2011-10-11 16:14:42 | NULL | utf8_general_ci | NULL | | |
| NULL | vmail | sender_bcc_domain | BASE TABLE | MyISAM | 10 | Dynamic | 0 | 0 | 0 | 281474976710655 | 4096 | 0 | NULL | 2011-10-11 16:14:42 | 2011-10-11 16:14:42 | NULL | utf8_general_ci | NULL | | |
| NULL | vmail | sender_bcc_user | BASE TABLE | MyISAM | 10 | Dynamic | 0 | 0 | 0 | 281474976710655 | 4096 | 0 | NULL | 2011-10-11 16:14:42 | 2011-10-11 16:14:42 | NULL | utf8_general_ci | NULL | | |
| NULL | vmail | share_folder | BASE TABLE | MyISAM | 10 | Dynamic | 0 | 0 | 0 | 281474976710655 | 4096 | 0 | NULL | 2011-10-11 16:14:42 | 2011-10-11 16:14:42 | NULL | utf8_general_ci | NULL | | |
+---------------+--------------+----------------------+------------+--------+---------+------------+------------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+---------------------+------------+-----------------+----------+----------------+---------------+
mysql> select * from information_schema.TABLES where TABLE_SCHEMA = 'roundcubemail';
+---------------+---------------+---------------------+------------+--------+---------+------------+------------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+-------------+------------+-------------------+----------+--------------------+---------------+
| TABLE_CATALOG | TABLE_SCHEMA | TABLE_NAME | TABLE_TYPE | ENGINE | VERSION | ROW_FORMAT | TABLE_ROWS | AVG_ROW_LENGTH | DATA_LENGTH | MAX_DATA_LENGTH | INDEX_LENGTH | DATA_FREE | AUTO_INCREMENT | CREATE_TIME | UPDATE_TIME | CHECK_TIME | TABLE_COLLATION | CHECKSUM | CREATE_OPTIONS | TABLE_COMMENT |
+---------------+---------------+---------------------+------------+--------+---------+------------+------------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+-------------+------------+-------------------+----------+--------------------+---------------+
| NULL | roundcubemail | cache | BASE TABLE | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 32768 | 53477376 | 1 | 2011-10-13 15:03:04 | NULL | NULL | utf8_general_ci | NULL | | |
| NULL | roundcubemail | contactgroupmembers | BASE TABLE | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 16384 | 53477376 | NULL | 2011-10-13 15:03:04 | NULL | NULL | latin1_swedish_ci | NULL | | |
| NULL | roundcubemail | contactgroups | BASE TABLE | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 16384 | 53477376 | 1 | 2011-10-13 15:03:04 | NULL | NULL | utf8_general_ci | NULL | | |
| NULL | roundcubemail | contacts | BASE TABLE | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 16384 | 53477376 | 1 | 2011-10-13 15:03:04 | NULL | NULL | utf8_general_ci | NULL | | |
| NULL | roundcubemail | identities | BASE TABLE | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 16384 | 53477376 | 1 | 2011-10-13 15:03:04 | NULL | NULL | utf8_general_ci | NULL | | |
| NULL | roundcubemail | messages | BASE TABLE | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 49152 | 53477376 | 1 | 2011-10-13 15:03:04 | NULL | NULL | utf8_general_ci | NULL | | |
| NULL | roundcubemail | session | BASE TABLE | InnoDB | 10 | Compact | 4 | 4096 | 16384 | 0 | 16384 | 53477376 | NULL | 2011-10-13 15:03:04 | NULL | NULL | utf8_general_ci | NULL | | |
| NULL | roundcubemail | users | BASE TABLE | InnoDB | 10 | Compact | 1 | 16384 | 16384 | 0 | 32768 | 53477376 | 2 | 2011-10-14 17:41:07 | NULL | NULL | utf8_general_ci | NULL | row_format=DYNAMIC | |
+---------------+---------------+---------------------+------------+--------+---------+------------+------------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+-------------+------------+-------------------+----------+--------------------+---------------+
Please advise...
----
Spider Email Archiver: On-Premises, lightweight email archiving software developed by iRedMail team. Supports Amazon S3 compatible storage and custom branding.