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(a)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