I think I originally switched because the authentication being used by MySQL wasn't supported by the old mysql library. You could switch the authentication scheme, but since I have all my stuff running on mysqli, phpbb, joomla, and mambo before that, I didn't see any reason to stop using it. Roundcube made it very easy through its DB abstraction.
Also, Roundcube uses mysql and not mysqli for MySQL be default. I didn't know if anybody else had tried it yet.
Adam
-----Original Message----- From: Joshua Layne [mailto:joshua@willowisp.net] Sent: Wednesday, October 26, 2005 1:36 PM To: RoundCube Dev Subject: Re: RoundCube with mysqli
Is there any particular reason that we are using the mysqli driver? I know that with PHP 5.0.3, the 'mysql' driver works fine against a MySQL 4.1.10+ db - they fixed the backwards compatibility issue. I don't know about php4, and I suppose for those people who are on php5 (<5.0.3) they might need it...
This wasn't particularly highly publicized, so not everyone is necessarily aware of it.
I guess if the db abstraction is handling it, it doesn't matter.
j.
On Wed, 26 Oct 2005 12:36:23 -0400, "Adam D. Oliver" Adam.Oliver@fblaw.com wrote:
I'm running the 20051021 build on PHP 5 and MySQLi. Working fine so far. I do not have a lot of people to test it. I had to make the following changes.
Insert the following after the mysql case ending on line 174 of rcube_db.inc
case 'mysqli': return mysqli_insert_id($this->db_handle->connection);
In db.inc.php make this change to line 21
$rcmail_config['db_dsnw'] = 'mysqli://user:pass@localhost/dbname';
If you have chrooted mysql and have to use TCP like me then remember
to
change the host accordingly.
$rcmail_config['db_dsnw'] = 'mysqli://user:pass@127.0.0.1/dbname';
If this was already posted by somebody then never mind. :-)
Adam