mysql_pconnect and adodb-mysql.inc.php on line 355

ihyln · Post by **ihyln** » Wed Mar 08, 2006 7:30 am

not just that but I had a SQL error when I imported the database using 5.0

BSOD2600 · Post by **BSOD2600** » Wed Mar 08, 2006 2:11 pm

ihyln wrote:not just that but I had a SQL error when I imported the database using 5.0

You must patch cacti 0.8.6h before importing the cacti.sql file.

joex51 · Post by **joex51** » Thu Mar 09, 2006 1:17 pm

IF I did this Once maybe twice I would say maybe I missed something on your directions.

But I have tried this Once before 2 or three times the server was formatted and now this is the second time I am attempting it, I have followed the Directions Under Installing under windows twice this time.
I will try this again with MySQL 4.
I will keep you posted.

BSOD2600 · Post by **BSOD2600** » Thu Mar 09, 2006 3:42 pm

In setting up cacti AGAIN last night (dont ask), I found that you do not want sql-strict mode enabled for MySQL 5.

joex51 · Post by **joex51** » Thu Mar 09, 2006 3:44 pm

OK just Installed MYSQL 4.0
And here the Issue I Still get the same error I dont Know what is going on
This is a little ridiculous now.
I must be nuts but I am gonna try this again using PHP 4 I dont know maybe next i will just unistall everything.

joex51 · Post by **joex51** » Thu Mar 09, 2006 6:32 pm

HEHEHEHE!!!!

Got finally used php4 it worked !!!

matguy · Post by **matguy** » Fri Mar 10, 2006 6:38 pm

So, 5 does not work now?

I was diong a test re-build of my cacti box (going from a VM that's getting pretty hammered over to a physical box) to test migrating it from one server to another and I get this same error. I used:

Windows 2003 Server (SP1/R2)
Cacti 0.8.6h
PHP 5.1.2
MySQL 4.1 (didn't see any strict mode options during setup)
IIS6

Would I need to I go to PHP 4? I had 5.05 on the old server and it worked. I have not migrated any data from the old server, as of now this is still a fresh install.

Post by **TheWitness** » Fri Mar 10, 2006 9:08 pm

It's likely not PHP 4 that fixed the problem, but something more or less aparent. PHP 4 included MySQL support out of the box. In PHP 5, you actually have to call it out as an extension.

TheWitness

joex51 · Post by **joex51** » Fri Mar 10, 2006 11:10 pm

If you got it working with 5.05, use it, I would if it worked for me I just could not get it working not matter what I did. Until I switched to php4. Even when I used PHP5 with the mysql.dll extension. I also had to give IUSR and IISwpg modify rights on the entire cacti folder with read an execute I kept getting permission denied on the cacti\include\config.php line 150 until I did that. I’m not saying that, will be the case for everyone just what was what happened to be what I needed to do to fix it.

matguy · Post by **matguy** » Sat Mar 11, 2006 1:33 am

joex51 wrote:If you got it working with 5.05, use it, I would if it worked for me I just could not get it working not matter what I did. Until I switched to php4. Even when I used PHP5 with the mysql.dll extension. I also had to give IUSR and IISwpg modify rights on the entire cacti folder with read an execute I kept getting permission denied on the cacti\include\config.php line 150 until I did that. I’m not saying that, will be the case for everyone just what was what happened to be what I needed to do to fix it.

This is a new box, the old one is going away. I use cacti to do a bunch of SNMP polling and some custom WMI calls and the polling is not working out well on a Virtual Machine (VMWare ESX Server.) I'm moving over to a new permanent physical box soon.

Right now I'm doing a test run to get an idea of how to make the installation go as smoothly as possible, mostly because of all the issues I had when setting up the first time, and from there the old server still has some issues, and I don't want to do a bunch of attempts at figuring out the issues on a new permanent box. I'd like to plan out the install for the permanent box to minimize errors that may have lasting effects.

Now, I didn't take enough notes when I first set this up and went through all sorts of re-working and version swapping of support software (install latest version, un-install, grab older version, wash, rinse, repeat) to remember how I came to the one I have that works, but also it doesn't work quite right either, so I'd like to get it right this time. Also, we have some VB WMI lookups for our windows clients that I'm polling, so I can't just go to Linux.

Basically, probably what I'm getting at: are there "lists" of what versions of support software works best which current versions? And/or possibly what considerations need to be taken with various versions? I know that would be quite a list, but otherwise, what's the best way to go about it?

BSOD2600 · Post by **BSOD2600** » Sat Mar 11, 2006 2:32 pm

Mysql 4.0 and greater.
PHP 4.3.6 and greater.
rrdtool 1.0 and greater.
cactid and cacti you want the latest versions.

NoaH · Post by **NoaH** » Thu Mar 30, 2006 4:55 am

I had this problem too and I solved it in using the php5ts.dll for ISAPI-Filter and php-cgi.exe for configure the home directory in the iis.

Try this...

magnetyk · Post by **magnetyk** » Mon Apr 03, 2006 2:48 am

I use cacti to do a bunch of SNMP polling and some custom WMI calls and the polling is not working out well on a Virtual Machine (VMWare ESX Server.)

My polling on a VMWare ESX Server, VMWare Workstation and VMWare GSX Server are working.

dnginc · Post by **dnginc** » Tue Apr 04, 2006 10:31 am

Nice job on the install guide. Worked great.

I used PHP 4.x, MySQL 4.1

undeaddemon · Post by **undeaddemon** » Sat May 13, 2006 2:20 am

Hi,

This is my second attempt at getting Cacti up.
Today 5/13/2006, I had download all the latest software:

cacti 0.8.6h + patched files
cactid 0.8.6g
mysql 5.0.21
php 5.1.4
rrdtool 1.2.12

The system is 2003 std. sp1.
I can't get past this:

Fatal error: Call to undefined function mysql_pconnect() in C:\Inetpub\wwwroot\CACTI\lib\adodb\drivers\adodb-mysql.inc.php on line 355

please help!

Thanks

Jesse

Cacti

mysql_pconnect and adodb-mysql.inc.php on line 355

error at line 355

Who is online