i'm trying to get RC installed on an icdsoft.com hosting account ... they support mysql connectivity like this (posted from the control panel):
MySQL 5 Connection Settings:
Local (web applications): Host: localhost | Socket: /tmp/mysql5.sock
Note: Most PHP applications/scripts will accept the following syntax:
MySQL Host: localhost:/tmp/mysql5.sock
Remote (MySQL clients): Host: mysql5.mywebsite.com | Port: 3307
When using "mysql5.mywebsite.com" as a MySQL Host, you need to enable "Remote Connections" for your MySQL user. (more info)
DB Master Username: xxxxx. User xxxxx has 3 of 10 maximum allowed DBs.
You can manipulate your DBs with phpMyAdmin (log in)
considering the above, i believe the connection string in the config file should be this:
$rcmail_config['db_dsnw'] = 'mysql://uname:pw@localhost:/tmp/mysql5.sock/xxxxx_rcmail';
but it doesnt work ... error log points to line 105 in rcube_db.inc
ive tried enabling remote client support and have also tried a variety of combinations including:
mysql://uname:pw@localhost:3306/xxxxx_rcmail
mysql://uname:pw@localhost:3307/xxxxx_rcmail
mysql://uname:pw@localhost/xxxxx_rcmail
mysql://uname:pw@localhost:3306/xxxxx_rcmail
mysql://uname:
[email protected]:3307/xxxxx_rcmail
mysql://uname:pw@localhost:3307/xxxxx_rcmail
i have also looked at the call to the PEAR db connect function in /program/include/rcube_db.inc
but so far have decided against a direct mod to that include file
my other 2 databases being connected from PHP work fine, but neither use the DSN-style connection syntax
SO ------- any ideas? oversight on my part? a fix?
thanks in advance
joel
No clue, but does the error log say anything more than what line the error occurs?
Try removing the "/tmp/mysql.sock" stuff... I think that may be mucking up the PEAR db stuff. Try it just as:
mysql://user:pass@localhost/database