fatal error mysql_pconnect

Post support questions that relate to the Windows 2003/2000/XP operating systems.

Moderators: Developers, Moderators

Post Reply
christianprice
Posts: 2
Joined: Thu May 11, 2006 2:12 pm

fatal error mysql_pconnect

Post by christianprice »

Hi all -

I am new to cacti and just loaded it on a 2000 server. I thought I followed all steps correctly for installation, but I am getting the following error. Any ideas on how I can fix this???

thanks!!!!!!!!

Fatal error: Call to undefined function mysql_pconnect() in c:\Inetpub\wwwroot\cacti\lib\adodb\drivers\adodb-mysql.inc.php on line 355
Christian M Price
Network Engineer - ACSD
CCNP
User avatar
BSOD2600
Cacti Moderator
Posts: 12171
Joined: Sat May 08, 2004 12:44 pm
Location: USA

Post by BSOD2600 »

Take a read: http://forums.cacti.net/viewtopic.php?t=11747

This problem is covered in my FAQ.
christianprice
Posts: 2
Joined: Thu May 11, 2006 2:12 pm

benn there, done that

Post by christianprice »

sorry, I should have included this in my original posting. I have done all the old password configurations and still recieve the error. When I checked on the passwords with the query, I don't get any that meet the criteria:

Enter password: ********
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 1 to server version: 5.0.21-community-nt

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> SELECT Host, User, Password FROM mysql.user
-> WHERE LENGTH(Password) > 16;
Empty set (0.00 sec)

mysql>
Christian M Price
Network Engineer - ACSD
CCNP
User avatar
BSOD2600
Cacti Moderator
Posts: 12171
Joined: Sat May 08, 2004 12:44 pm
Location: USA

Post by BSOD2600 »

hmm, not sure. I thought mysql was strict about the syntax. After adding "old-passwords" to your my.ini, do:

shell> mysql --user=root --password mysql
shell> UPDATE mysql.user SET Password = OLD_PASSWORD('cactipw') WHERE Host = 'localhost' AND User = 'cactiuser';
mysql> FLUSH PRIVILEGES;

Another option is enabling old-passwords in mysql administrator, then manually re-settting the password for the cacti account.
rdiederik
Posts: 1
Joined: Tue May 23, 2006 12:27 pm

RE: Fatal error: Call to undefined function mysql_pconnect()

Post by rdiederik »

I wrestled with this problem for a little while until I found out what I did wrong.

My problem was with the installation of PHP. You actually need to run PHP installer first and then ADD the PHP zip file (adding and overwriting some files). In my case I used:

php-5.1.4-install.exe
php-5.1.4-win32.zip

If you omit the first step, you don't install the mysql_pconnect() function
Post Reply

Who is online

Users browsing this forum: No registered users and 2 guests