PhpWiki

On Wed, Jun 19, 2002 at 08:07:56PM +0100, John Kershaw wrote:

> >    'dsn' =3D> 'mysql://dbusername:=20
> >password@...',
> >
> >but get a bunch of errors which I presume come from phpwiki parsing=20
> >the hostname incorrectly out of the string.
> >
> >How do I get things working properly?
> >
> >(phpwiki 1.3.2)
>=20
> Anyone able to help me out with this?

It will help if you post the error messages. I myself, have never
played with phpwiki and a mysql, so I shouldn't really be answering
:), but if kershaw.org is your local computer (webserver and database
server on the same computer) and that kershaw.org dsn string works ok,
then I can't understand why just replacing kershaw.org with localhost
wouldn't work.

 'mysql://dbusername:password@...>'

--=20
___\ Jon =C5slund

> >     'dsn' =>
> >     'mysql://dbusername:password@...>
> >     ename',

After numerous (private) e-mails back and forth, John
and I have figured out the problem.  What it boils
down to is:

If you want/have to connect to your mysql server via
unix (rather than inet/tcp) sockets, you should:

 1. Make sure you are using recent Pear code,
    such as that which now ships with PhpWiki.
 2. Use DSNs like:
      'mysql://user:pw@...>'

Probably, using the ADODB backend (if your
PhpWiki is recent enough) instead of the Pear-based
backend would work, too.

With older Pear code (including that which ships
with most distributions of PHP), it seems that
it is not possible to use unix sockets --- at least
not without some serious hacking.