Re: [cobalt-users] Problem with PHP4 mysql support

["Steven Werby" <steven-lists@xxxxxxxxxxxx>]

Moritz Julian Ehlenz | M2Soft Systemhaus GbR <mjehlenz@xxxxxxxxxx> wrote:
> I have installed php4 from the sources, but now I am
> running into a problem with the mysql support. Currently
> I am using the built in mysql support PHP4 has. But
> obviously that doesn't work since I am also using
> mod_perl.

Do you mean you're using Perl to access MySQL?  Then you need to install the
Perl DBI/DBD and the MySQL drivers.

> Trying to configure PHP4 --with-mysql=/usr/share/mysql
> or --with-mysql=/usr/lib/mysql or --with-mysql=/usr/include/mysql
> doesn't work. All I am getting is an error message saying
> "configure: error: Cannot find header files under ..."

Was MySQL also installed from source?  The path for --with-mysql will either be
/usr/local or /usr/local/mysql (I don't recall which) unless you specified a
path using --prefix when you installed MySQL from source.  If you installed it
from RPM, PHP may not be able to find the MySQL files it needs.

> If anybody has any idea how to solve this, I'd really
> appreciate to hear from you.

Use "locate mysql" to find the path to your MySQL installation and then try
reconfiguring PHP.  If it doesn't work you're probably best off re-installing
MySQL from source and explicitly specifying the path using something
like --prefix=/home/mysql.

--
Steven Werby {steven-lists@xxxxxxxxxxxx}