PHP4 src and MySQL RPM?

Anon

Hi all.

I have just installed RedHat6.2 with the build in Apache server (RPM I guess). I installed PHP4.0.4 as a "source install" with configure --with-mysql, make etc., and it all goes migthy fine. (if I try to include --with-apxs, I get an error:

checking for Apache module support via DSO through APXS...
./configure: /usr/bin/apxs: No such file or directory
Sorry, I was not able to successfully run APXS. Possible reasons:
1. Perl is not installed;
2. Apache was not compiled with DSO support (--enable-module=so);
3. 'apxs' is not in your path.
configure: error:

(This however, is not part of the question, but just to maybe give some input to an answer)

Now I like to include a database to the system, and I install MySQL3.22.32 as a RPM. It works fine from a command line.

PHPINFO() says, that MySQL support is enabled.
but when I try to connect to the MySQL server, I get the following:
Warning: MySQL Connection Failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (111) in /home/httpd/html/php/index.php on line 3

Now comes the big question:
How can I make PHP and MySQL talk together?

I have seen this question asked in a number of different newsgroups, but no-one seems to know the right answer.
Some say, that a path must be given to mysql when compiling php, but whereto when using MySQL RPM?

Should I just give in, and remove the MySQL RPM and make a source install?

Greetings
Rasmus

Anon

Just make sure that MySQL is running while you build your PHP. That way, PHP will be built to look for the MySQL socket in the correct directory.

As an answer to your last question: No. You should do the opposite: Drop compiling PHP yourself (and concentrate on learning the language well). You may find the following RPM packages useful:

php
mod_php
php-mysql

See http://rpms.arvin.dk/php/

Anon

I've downloaded your php-4.0.4pl1-10.arvin.i586.rpm and mod_php-4.0.4pl1-10.arvin.i586.rpm and i did a rpm -qa | grep php which found php-3.0.15-2 and also php-idap, php-imap, php-manual, php-pgsql and phpfi but i cannot find where they are and being a novice at linux i'm unsure how to remove them??? would you mind giving me the command(s) to remove them and also do i need to remove them all? Should i install your php-idap (i'm not sure what it does but your instructions say install it first? i assume that i need to install the openssl-0.9.5a-2.6.x.i386.rpm before i install the php4 rpms but should i do it before the php-idap??? i'm running redhat 6.2 on a amd166 intel machine with apache 1.3.12 hosting 5 domains thank you very much for putting those rpms up... i'm trying to learn but sometimes it's confusing!!!
terry

Anon

To remove an RPM package:

rpm -e packagename

Example:
rpm -e phpfi

Anon

excuse my stupidity but when i do the rpm -e php-3.0.15-2 it tells me
"removing these packages would break dependencies
php is needed by php-imap...
" " php-idap...
" " php-pgsql...
" " piranha-gui-0.4.12-4 ???
(what is piranha anyway???)
do i start at the bottom and work up???
thanks for your patience and help!!!
terry

Anon

Yes - the safest way is to start by removing software which depends on php3. You almost certainly do not need piranha-gui.

A quick - but potentially dangerous! - way to remove a lot of packages:
rpm -qa | grep ^php- | xargs rpm -e

(You need to uninstall piranha-gui first, though.)

Answer to "what is piranha anyway":
To find out what a package does, use the "-qi" argument to RPM. Example:
rpm -qi piranha-gui

Anon

i'm getting there... i removed piranha-gui, php-imap and php-pgsql, it says php-idap is not installed (that answers my question about whether i need it) but rpm -e php-3.0.15-2 still says it would break dependencies for php-idap??? is there a way to force it?? thanks for all the information!!!
terry

Anon

"php-idap" makes no sense at all. It looks like a spelling problem. Don't you think that it should be "php-imap"?

Anon

you're right i need glasses ldap :-) just got everything installed and it seems that i don't have libphp4.so on my system, just need to find and install it, i had to comment out LoadModule & AddModule so i could keep apache running... your rpms are great!!!

Anon

YEAHHHH.... OK FOLKS THIS IS RIPPING COOL!!!
OK I just changed the
LoadModule php4_module libexec/libphp4.so
to
LoadModule php4_module modules/libphp4.so
and i'm up and running
yeah!!!!
THANK YOU TROELS!!!!!

Anon

Question Troels, When I try to install
php-mysql-4.0.4pl1-10.arvin.i586.rpm it tells me that i need libmysqlclient.so.10 I installed MySQL-client-3.23.35-1.i386.rpm along with MySQL-3.23.35-1.i386.rpm MySQL-bench-3.23.35-1.i386.rpm and MySQL-devel-3.23.35-1.i386.rpm ... am i just totally screwing up here??? I tried <?phpinfo()?> and this is what comes up... no mysql reference???

http://www.getnby.com/~php.php
Terry (somewhat confused again???)

Anon

You need the MySQL-shared package, as mentioned at http://rpms.arvin.dk/php/install-ready/i686/?describe=php-mysql#descs

Anon

Back again... :-( sorry Troels,
when i did a test page calling a mysql table i get this...
Fatal error: Call to undefined function: mysql_connect() in /home/httpd/html/users/cc.php on line 4
the page is...

<body>
<?php
$db=mysql_connect("localhost", "root");
mysql_select_db ("test", "$db");
$result = mysql_query ("SELECT name, address FROM cc");
printf("Business Name: %s<br>\n", mysql_result($result,0,"name"));
printf("Address: %s<br>\n", mysql_result($result,0,"address"));
printf("City: %s<br>\n", mysql_result($result,0,"city"));
printf("Phone: %s<br>\n", mysql_result($result,0,"telephone"));
?>
</body>

i realize from trying to figure this out... "Fatal error: Call to unsupported or undefined function mysql_connect() in .." This means that your PHP version isn't compiled with MySQL support. You can either compile a dynamic MySQL module and load it into PHP or recompile PHP with built-in MySQL support. This is described in detail in the PHP manual.
I realize that I have done something wrong... please don't tell me to box up my computer and take it back because i'm too dumb to own one... :-)
any help would really be appreciated!!!
Terry

Anon

i have the exact same problems, phpinfo() still says '--without-mysql', however using mysql-3.23.32 and mysql-shared-3.23.32 i've been able to successfully install php-4.04 and php-mysql-4.04. ( it didn't complain about the mysql package not being there (after i downgraded the rpm) ) and i can connect to my database now. However, when i retrieve the query results ( mysql_fetch_array() ) i recieve the following error:
Warning: Supplied argument is not a valid MySQL result resource
in /var/www/html/test.php on line 25

Line 25 is the last line in my code snippet here:

mysql_select_db('mydb', $dbh);
print "Database selected";
$sql = "select username from auth_user";
$res = mysql_query( $sql, $dbh ) || die('bad sql');
while( $row = mysql_fetch_array($res) ) {

this query does work on sql command line, so i suspect the error is that php-mysql support has not been properly installed, right?

Anon

You are looking at the wrong part of phpinfo()'s output. The section with all the "--with-whatever" can't be trusted in a setup with loadable PHP modules.

Look further down the output from phpinfo(); there, you should be able to see the MySQL API version number, etc.

The fact that you get the "Supplied argument ..." error actually shows that you do have MySQL support in your PHP. However, there is a problem somewhere in your PHP code.

Anon

looking for idap could be mistaken for LDAP? Used with iplanet.