mysql db has nothing to do with the smtp auth. smtp auth is handled by making a connection to the server specified in the config as the smtp server. also it uses the settings in the config that specify the username and password to be
$rcmail_config['smtp_user'] = '%u'; $rcmail_config['smtp_pass'] = '%p';
so what ever the use enters in as the username and password during the login is what is used to auth against the smtp server.
Christine Kluka wrote:
Hi,
I've been reading your forum posts on this issue, and they point to a permissions failure in the database. MySQL is populating new users in the users table, but no privileges are listed for them on SHOW GRANTS. So I granted all privileges on the roundcube database to a primary user and verified that this user has all privileges:
mysql> SHOW GRANTS FOR user1; +-----------------------------------------------------------------------+ | Grants for user1@%
+-----------------------------------------------------------------------+ | GRANT USAGE ON *.* TO 'user1'@'%'
| GRANT ALL PRIVILEGES ONroundcubemail.roundcubemailTO 'user1'@'%' | +-----------------------------------------------------------------------+ 2 rows in set (0.00 sec)This seems like overkill, since user1 only cares about user1's settings (not those for user2, 3, 4 etc), but I read that db permissions might be the problem, so I opened everything to user1 to test this.
I set the smtp_auth_type to LOGIN (also tried PLAIN and DIGEST-MD5), but sending mail fails (for user1 and all other users) with an SMTP authentication failure.
Finally, not knowing whether I have a PHP mail() problem, I alternately tried 'mail.mydomain.com' and 'localhost' for the smtp_server setting, but that also makes no difference :(
I can send mail from Linux and Windows POP3 and IMAP clients on my LAN, but not Roundcube!
I am using SASL with Cyrus IMAP, and an LDAP database. What to look for?
The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete this material from any computer.
In accordance with industry regulations, all messages are retained and are subject to monitoring.
This message has been scanned for viruses and dangerous content and is believed to be clean.
Securities offered through Cantella & Co., Inc., Member NASD/SIPC. Home Office: 2 Oliver Street, 11th Floor, Boston, MA 02109 Telephone: (617)521-8630