[PHP] Installing PHP with MySQL RPM version

[Mark McCulligh]

Thanks,

If you just use --with-mysql it will use PHP's built-in mysql client lib
3.23.49, but I have MySQL 4.0.14 installed. Won't this make a difference. I
want to make sure PHP is compiled this the right libraries for MySQL.

Mark.


"Ray Hunter" <bigdog@venticon.com> wrote in message
news:1063133321.11538.8.camel@bigdog.info.trw.com. ..

> > In the configure line --with-mysql=/path/to/mysql were is the path for

RPM

> > versions of MySQL. I have search the computer but it looks like the

mysql

> > files are all over the place. Database files are in /var/lib/mysql

BIN

> > files are in /usr/bin/, etc...

>
> use --with-mysql or --with-mysql-sock
>
> example:
>
> ./configure --with-mysql
> ./configure --with-mysql-sock=/var/lib/mysql/mysql.sock
>
> hth
>
> --
> BigDog

[Ray Hunter]

mark,

from what i understand of the configuration script it will go out and
look in various locations for the mysql libraries. If you want to
specify something then I would suggest using the --with-mysql-sock and
pass the socket file. I like to use the socket file and have always had
great success with it even for mysql 4.0

--
BigDog


On Tue, 2003-09-09 at 12:59, Mark McCulligh wrote:

> Thanks,
>
> If you just use --with-mysql it will use PHP's built-in mysql client lib
> 3.23.49, but I have MySQL 4.0.14 installed. Won't this make a difference. I
> want to make sure PHP is compiled this the right libraries for MySQL.
>
> Mark.
>
>
> "Ray Hunter" <bigdog@venticon.com> wrote in message
> news:1063133321.11538.8.camel@bigdog.info.trw.com. ..

> > > In the configure line --with-mysql=/path/to/mysql were is the path for

> RPM

> > > versions of MySQL. I have search the computer but it looks like the

> mysql

> > > files are all over the place. Database files are in /var/lib/mysql

> BIN

> > > files are in /usr/bin/, etc...

> >
> > use --with-mysql or --with-mysql-sock
> >
> > example:
> >
> > ./configure --with-mysql
> > ./configure --with-mysql-sock=/var/lib/mysql/mysql.sock
> >
> > hth
> >
> > --
> > BigDog

[Brad Pauly]

Mark McCulligh wrote:

> when I compiled with --with-mysql only, phpinfo() said:
> Client API version: 3.23.49
>
> I will recompile PHP with --with-mysql-sock instead.

I don't think this will change the client version. It is my
understanding that this will just tell the client to look in a specific
place for the socket file.

> I want to make sure PHP is using the right MySQL Client version.

I think you will need to specify the location using --with-mysql=[dir].
It is just a guess, but try --with-mysql=/usr

If you can't find where it is, one thing that might be worth considering
is whether or not you need the 4.0 client lib. Take a look at this link:

[url]http://www.mysql.com/doc/en/Upgrading-from-3.23.html[/url]

- Brad