When I want to run the PHP code i got the prolem was

The connection was refused when attempting the localhost

Then I'm trying to start the httpd server. But it gives one error.

That error is :

httpd failed. The error was: Starting httpd: Syntax error on line 6 of /etc/httpd/conf.d/auth_mysql.conf:
Cannot load /etc/httpd/modules/mod_auth_mysql.so into server: libmysqlclient.so.10: cannot open shared object file: No such file or directory
[FAILED]

any one help me.

I think you need to install MySQL and the Apache MySQL module. Or else if you don't need MySQL just remove the module from Apache configuration and try again.

What distro and version of Apache are you using by the way?

Moved: This thread is more suitable in Linux-Software and has been moved accordingly to help your thread/question get the exposure it deserves.

It looks you don't have MySQL installed. Please check it. Alternatively, if you don't want to use a database, you may remove MySQL support from Apache and use it in that configuration. Do you need MySQL or not?

It's not just mysql, but you need the myslq-shared-compat package. That package provides the libmysqlclient.so.10 file you're missing. There used to be 2 different shared library packages - mysql-shared-compat, and myslq-shared. If you installed the first, you didn't need to install the latter. If you get the packages from mysql directly, I believe that last linux rpm version that had that package was 4.1.13. 4.1.15 had the package also, but it looks like mysql changed their site and have taken the package out. It also looks like you won't be able to find previous versions of mysql on mysql's site.

the difference between mysql version 4.1.13 and the higher versions, is that the higher versions use glibc2.3, so if you're running an old rpm distro like redhat 7.3, you're last availbe version of mysql is 4.1.13. Although, it doesn't seem to matter now since the shared compat package is no longer listed.

Now bear in mind, I'm only talking about the packages from mysql's site. Your distro might package things up differently.

Of course, you can always try rebuilding the source.

Thanks for ur reply.

I reinstalled the mod_auth_mysql-20030510-4.1.src.rpm package, the connection was refused problem was gone. But I got another problem which is Call to undefined function: mysql_connect()


Any one help me.

you don't have a problem with mod_auth_mysql. You have a problem with not having mysql installed and in particular the shared-compat package.

look at http://www.mysql.com/ or your distros repository for mysql packages.

or disable loading that module in your httpd.conf, as was suggested in a previous post.

When i run php file without mysql content ,it runs properly.

When i connect mysql in bash terminal, it connects properly.

When i run php file with mysql content, i got Call to undefined

function:mysql_connect() error. I dont know which package i have to installed.

I installed follwoing mysql rpms:

MySQL-shared-5.0.16-0.glibc23

MySQL-client-5.0.16-0.glibc23

MySQL-devel-5.0.16-0.glibc23

MySQL-server-5.0.16-0.glibc23

MySQL-bench-5.0.16-0.glibc23

I installed follwoing php rpms:

php-ldap-4.3.2-8.ent

php-mysql-4.3.2-8.ent

php-odbc-4.3.2-8.ent

php-imap-4.3.2-8.ent

php-pgsql-4.3.2-8.ent

Where did i wrong? Help me.

I told you, you need the mysql-shared-compat package. It looks like mysql have taken that package out from their download site. Normally you wouldn't install MySQL-shared-5.0.16-0.glibc23 if you installed the MySQL-shared-compat package. The last version of MySQL I've seen that had the compatibility package was 4.1.13. Check the web if you can find that package. If not, give me a holler and I'll find out some way of getting it to you.

Verify in your php.ini file that the following line is not commented out.
extension=mysql.so

I assume that php was compiled with mysql

installing php from rpms, I don't know as I've always compiled php from source. The default php.ini file should work as is if compiled from source. Definately check your php.ini file, but if you want, uninstall the php rpms you installed and compile the source code instead. Things should definately work out better for you.

The ./configure command I used (note I couldn't figure out how to get snmp compiled in so that's omitted):

use the correct path to the base install directory of your apache install when using the --with-apx2 option.

*edit: also of note, there's a lot of options I use and you'll have to get the packages for things like the correct version of libxml (or libxml2), unixODBC, etc...

then type:

make
su
<enter root password>
make install

'make install' will install the correct libphp5.so and libphp5.la apache modules in the right location (/install/path/to/apache/modules) and will put in the correct load module line in httpd.conf.

With mysql, I do use the rpms, but with apache I always compile that from source, as well.

I installed mysql_shared_compat package. Still i couldnt connect mysql thru PHP.

I dont know where did i wrong? Help me.

run this command and paste the output.

rpm -qa | grep MySQL

I run this rpm -qa | grep MySQL.

I got following output.

MySQL-shared-compat-4.0.17-0
perl-DBD-MySQL-2.1021-3
MySQL-server-4.0.17-0
MySQL-shared-4.0.17-0
MySQL-client-4.0.17-0

Still i couldnt connect mysql thru PHP

Help me.

make sure that sql is running
make sure that you can connect to the sql server
http://www.linuxquestions.org/questi...d.php?t=230791

good call, although I'm pretty sure that after installing the rpms, it starts up mysqld and adds in an init service.