PDA

View Full Version : "Fatal error" : mysql_pconnect


Clubmaxima
Wed 13th Feb '02, 10:52am
I am only giving the error in anticpation of someone coming here and having a simular problem.

The Story:

PC: 1 gig Athlon w/ 512 RAM running Redhat 7.1

I arrived at the jelsoft site on Sunday (4 days ago) and decided before i purchased the software, i wanted to install it on my home machine and play around with it for a few days to understand how it affected the PC and if i went with hosting from a company to run my web board i would fully understand the errors and problems. This site was for testing purposes. However i had light experience with Linux, no experience with PHP, no experience with SQL (mysql) and no experience with PERL

I downloaded vblite and i was on my way.

I setup a php testing webpage i got off the net

<html><head><title>PHP Test</title></head>
<body>
<?php echo "Hello World<p>"; ?>
</body></html>

to my dismay i did not have PHP installed. I then downloaded php from http://www.php.net and decided to configure it. I got the compile and configuration infromation from the following website

http://www.e-gineer.com/instructions/install-php4x-for-apache1xx-on-linux.phtml

I also noted i did not have mysql installed ither. I then downloaded mysql from http://www.mysql.com and decided to configure it. I got the compile and configuration information from the following website.

http://www.e-gineer.com/instructions/install-mysql3xx-on-linux.phtml

I edited my config file for vblite and i was on my way. During the config process i got my famed "Fatal error: Call to undefined function: mysql_pconnect() in /var/www/html/vblite/admin/db_mysql.php on line 31"
I contacted my friend who knows about this stuff because he runs http://www.preludeonline.com and he did a very good thing.. he did not help, he made me go out and try to fix it myself and i appreciated that.
my next step was to try to play with the Privilages on the sql server to see if that would help with my problem. I played with the sql server for 2 days straight, and i got no where. I even took some time away from it because it became very frustrating.
I decided to go back to the root of the issue where i started in the first place. http://www.jelsoft.com and what i found was this forum.
I did a search http://www.vbulletin.com/forum/search.php?action=showresults&searchid=235977&sortby=lastpost&sortorder=descending and in almost every thread all i could hear from people were please compile mysql with php over and over again. I thought i did that, however I kept reading.. same solution.
I found this testing webpage in my searche that would tell me what configuration my apache server was running.
<html><head><title>PHP Test</title></head>
<body>
<?php

// Show all information, defaults to INFO_ALL
phpinfo();

// Show just the module information.
// phpinfo(8) yields identical results.
phpinfo(INFO_MODULES);

?>

</body></html>
when i viewed the page.. sure enough .. my configuration for php said --without-mysql
I went back to my original php compile config webpage http://www.e-gineer.com/instructions/install-php4x-for-apache1xx-on-linux.phtml and i decided to becareful, take note and try to compile it again
Ah ha.. i was getting an error on config
./configure --with-mysql=/usr/local/mysql --with-config-file-path=/www/conf --with-apache=../httpd --enable-track-vars
the error was that could not find httpd.h .. i searched my server long and hard and i could not find this file for the life of me..
so i headed to google to find out more about httpd.h
i found this very interesting bit of information
http://www.phpbuilder.com/forum/read.php3?num=3&id=108742&thread=107000
it appears that my strip down verison of apache that came with Redhat 7.0 is not the full version and did not have httpd.h
so i was off to download the full version of apache http://www.apache.org and i configured it with the following page.
http://www.e-gineer.com/instructions/install-apache1xx-on-linux.phtml
downloaded recomipiled and re-configured php and mysql
I tried to run the config again.. but then i noticed the vblite config page would not come up.. I went to the following site to see what my webserver was running..
http://uptime.netcraft.com/up/graph/
then i noticed that my modules were not configured for php.
loaded modules and tried to run the vblite configuration again.. I worked like a charm.. no problems..
So i would like to thank all the people on this site for helping me fix problem.. unfortunately i believe in searchign a website before posting a question.. as the answer may have already been there, so without this first post.. you people would not have really known how much I appreciated your help.

- Thanks Again