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

[BSOD2600]

Please read this: http://forums.cacti.net/viewtopic.php?t=11747 . One of my FAQs covers this.

[undeaddemon]

Thanks BSOD2600,
However, my error is not EXACTLY the same output:

Your FAQ references line 338, my line is 355 (though I realize this could be a version diff. and the problem could be one and the same...)

Operating System: 2003 SP1
Webserver: IIS6
Cacti: 0.8.6h + pa5tches
Cactid: 0.8.6g
MySQL: 5.0.21
PHP: 5.14
RRDTool: from Cacti
Net-SNMP: no
Cygwin: no

Do I need to use different versions? I have found many ref. here for various verision issue with mysql/cacti/rrd, but I thought I had addressed these issues (old_password, etc.)

I have read and re-read you docs. It seems all is according to the plan.

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

Here is line 355:
$this->_connectionID = mysql_pconnect($argHostname,$argUsername,$argPassword,$this->clientFlags);

I can only guess that is a connection to mysql... but I am but a newbie.


Soon, I will start over fresh, perhaps I should try going back to mysql 4...


BTW BSOD2600, Thanks for the very detailed install doc. I had tried to get Cacti running about a year ago, and had only had the skills/luck? for routers2.cgi ... any win32 support was hard to come by for cacti... So again... thanks you and all those 'win32' folk! I want very much to learn and use this tool..

Thanks,
Jesse

[BSOD2600]

While the line number differs, the underlaying problem is still the same. Cacti, specifically PHP, uses the 'older' mysql client. In order to make it work, one must enable 'old-passwords' and then re-set the password for the user account(s) they wish to use.

1) stop the mysql service
2) edit my.ini and add: old-passwords. save the file
3) start the mysql service. Veryify old-password mode is enabled with MySQL Administrator (just in case).
4) Update the cacti mysql user account with the new (shorter) password style:
shell> mysql --user=root --password mysql
shell> UPDATE mysql.user SET Password = OLD_PASSWORD('cactipw') WHERE Host = 'localhost' AND User = 'cactiuser';
mysql> FLUSH PRIVILEGES;
5) Verify cacti is set to use the password in config.php and you should be set. Restart the server just in case it doesn't work.

[undeaddemon]

I tried... everything seems ok... but still the fatal error... so I will try mysql 4.1.19

[undeaddemon]

quick question...
my.ini has several sections in it.

[client]

[mysql]

[mysqld]

#does it matter where i enter

old-passwords

#I have tried mysqld (originally I just pasted that entry to the bottom) #client is next...

thanks...

[BSOD2600]

Nope, position doesn't matter. MySQL Admin puts all additional settings at the bottom...

[Dia]

Yep I get same errors on Windows XP. Running all the latest versions.

BSOD - How about a manual with screen shots? For us newbs.

[undeaddemon]

OK... so now I can SEE that I am having some password/user issue... But restarting the entire procedure ended me with the same result....

No connection. Trying to reconnect...
Connection id: 1
Current database: cacti

+-----------+------+-------------------------------------------+
| Host | User | Password |
+-----------+------+-------------------------------------------+
| localhost | root | *08AD3A68DD3F7884B04FDF0878C22EA5E7B21D4A |
+-----------+------+-------------------------------------------+
1 row in set (0.39 sec)

I can see I only have ONE user... and that is a LONG password.
based on this post:
http://forums.cacti.net/viewtopic.php?t=12506

not sure what to do... I feel like I can perform those same steps again and again... but I suspect something is mangled.

Thanks..

Jesse

[undeaddemon]

I reinstalled all... started with mysql 4... updated to 5... now I have this:

C:\>mysql --user=root --password mysql
Enter password: ********
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 2 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;
+-----------+-------+-------------------------------------------+
| Host | User | Password |
+-----------+-------+-------------------------------------------+
| localhost | cacti | *DAFF917B80E3314B1ABECBA9DF8785AFD342CE89 |
+-----------+-------+-------------------------------------------+
1 row in set (0.11 sec)

mysql>


I dont think this is any good either (I dont even know how I got that...I still have to use 'root'....where is that?)

Jesse

[undeaddemon]

ok... now I got this....... should i have "empty set' ?????

C:\>mysql --user=root --password mysql
Enter password: ********
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 3 to server version: 5.0.21-community-nt

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

mysql> UPDATE mysql.user SET Password = OLD_PASSWORD('cactipw') WHERE Host = 'lo
calhost' AND User = 'cacti';
Query OK, 1 row affected (0.03 sec)
Rows matched: 1 Changed: 1 Warnings: 0

mysql> FLUSH PRIVILEGES;
Query OK, 0 rows affected, 1 warning (0.02 sec)

mysql> exit
Bye

C:\>mysql --user=root --password mysql
Enter password: ********
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 4 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.02 sec)

mysql>


Jesse

[BSOD2600]

Dia: What parts are you having problems with? IMO my installation guide is fairly detailed.

undeaddemon: I'm not an mysql expert, so I don't know if an empty set is good/bad. It seems the cacti mysql account is using the sorter password now. Does cacti work?

[Dia]

Yes, your guide is detailed. I am having the exact error that this thread is about.

I have tried this on W2K3 and now trying WinXP and both recieved the same error.

One thing I did with the W2K3 was to downgrade to PHP4.4.2 and the error went away but then I had other issue that were in another posting of mine (poller log did not have data) nor did I have any graphs.

Anything different to do when installinig on WinXP?

[TheWitness]

I noted recently that even after setting the PHP_RC environment variable that I had to install php.ini in the Windows directory anyway. Then the problem went away. Go figure....

TheWitness

[undeaddemon]

undeaddemon: I'm not an mysql expert, so I don't know if an empty set is good/bad. It seems the cacti mysql account is using the sorter password now. Does cacti work?

I Installed the administration interface...

when highlighting (selecting) a (any) user, I get:

MySQL encountered an error. The message is:
Error while fetching user information.
The following error occured:Unknown Column'Create _view_priv' in 'field list' (1054)

I can see I need to reinstall MYSQL 5 FRESH... then go right to the administration interface.... I am now seeing all these command lines start to make sense with this tool in front of me! (win32 peeps will like)

I'll get more up when I reinstall....[/img]

[TheWitness]

Wow, that's a new one. The mysql system table was hosed!!!

TheWitness