Yet Another Cacti Problem

[dev2dev]

Warning: mysql_connect() [function.mysql-connect]: Client does not support authentication protocol requested by server; consider upgrading MySQL client in d:\cacti\lib\adodb\drivers\adodb-mysql.inc.php on line 324


any body has idea?

this error i am gettting after fresh instalation of cacti in my system.

I dont know wether its a php problem or cacti

environment
win2k3
cacti 0.8.6b
php 502
iis6

[dev2dev]

as i already said, I dont know where exactly is problem is, after few tries of updating set password command rebooting system has done the trick.

but wait,

as i said earlier post, I have moved cacti to different location, it was in C drive of another machine which is now in different machine on D drive.

I updated all paths in settings tables, but may be I am missing few more steps for which graphs are not being generated.

Code: Select all

Warning:  popen(d:/rrdtool/rrdtool.exe graph -  --imgformat=PNG  --start=-86400  --end=-300  --title="Local Machine - CPU Utilization"  --rigid  --base=1000  --height=120  --width=500  --alt-autoscale-max  --lower-limit=0  --vertical-label="percent"  DEF:a="d\:\cacti/rra/local_machine_cpu_48.rrd":cpu:AVERAGE  AREA:a#FF0000:"CPU Utilization"   GPRINT:a:LAST:"Current\:%8.0lf"   GPRINT:a:AVERAGE:"Average\:%8.0lf"   GPRINT:a:MAX:"Maximum\:%8.0lf"  2>&1,rb) [function.popen]: No error in d:\cacti\lib\rrd.php on line 88

Warning:  fgets(): supplied argument is not a valid stream resource in d:\cacti\lib\rrd.php on line 111

[dev2dev]

here is latest error messages i got

D:\cacti>php d:\cacti\poller.php
11/26/2004 04:37:25 PM - POLLER: Poller[0] DEBUG: About to Spawn a Remote Proces
s [CMD: d:/cactid/cactid.exe, ARGS: 0 11]
Waiting on 1/1 pollers.
11/26/2004 04:37:26 PM - POLLER: Poller[0] CACTI2RRD: d:/rrdtool/rrdtool.exe update d:\cacti\rra\qmail_traffic_in_22.rrd --template traffic_out:traffic_in 1101465615:30643089:30643089
11/26/2004 04:37:26 PM - POLLER: Poller[0] CACTI2RRD: d:/rrdtool/rrdtool.exe update d:\cacti\rra\qmail_traffic_in_22.rrd --template traffic_out:traffic_in 1101465641:30656236:30656236
11/26/2004 04:37:26 PM - POLLER: Poller[0] CACTI2RRD: d:/rrdtool/rrdtool.exe update d:\cacti\rra\qmail_traffic_in_23.rrd --template traffic_in:traffic_out 1101465615:14481091:12832423
11/26/2004 04:37:26 PM - POLLER: Poller[0] CACTI2RRD: d:/rrdtool/rrdtool.exe update d:\cacti\rra\qmail_traffic_in_23.rrd --template traffic_in:traffic_out 1101465641:14484728:12835661
.
.
.
.
11/26/2004 04:37:26 PM - POLLER: Poller[0] CACTI2RRD: d:/rrdtool/rrdtool.exe update d:\cacti\rra\qmail_mem_free_32.rrd --template mem_free 1101465615:5162811/26/2004 04:37:26 PM - POLLER: Poller[0] CACTI2RRD: d:/rrdtool/rrdtool.exe upd
ate d:\cacti\rra\qmail_mem_free_32.rrd --template mem_free 1101465641:51212
OK
OK
OK
OK
OK
OK
OK
OK
OK
OK
OK
OK
11/26/2004 04:37:27 PM - POLLER: Poller[0] CACTI2RRD: d:/rrdtool/rrdtool.exe create d:\cacti/rra/local_machine_traffic_in_45.rrd --step 300 DS:traffic_in:COUNTER:600:0:100000000 DS:traffic_out:COUNTER:600:0:100000000 RRA:AVERAGE:0.5:1:600 RRA:AVERAGE:0.5:6:700 RRA:AVERAGE:0.5:24:775 RRA:AVERAGE:0.5:288:797 RRA:MAX:0.5:1:600 RRA:MAX:0.5:6:700 RRA:MAX:0.5:24:775 RRA:MAX:0.5:288:797
11/26/2004 04:37:27 PM - POLLER: Poller[0] CACTI2RRD: d:/rrdtool/rrdtool.exe update d:\cacti\rra\local_machine_traffic_in_45.rrd --template traffic_out:traffic_in N:8607017:8607017
11/26/2004 04:37:27 PM - POLLER: Poller[0] CACTI2RRD: d:/rrdtool/rrdtool.exe update d:\cacti\rra\local_machine_traffic_in_45.rrd --template traffic_out:traffic_in N:8659376:8659376
OK
OK
11/26/2004 04:37:27 PM - POLLER: Poller[0] CACTI2RRD: d:/rrdtool/rrdtool.exe create d:\cacti/rra/local_machine_traffic_in_46.rrd --step 300 DS:traffic_in:COUNTER:600:0:100000000 DS:traffic_out:COUNTER:600:0:100000000 RRA:AVERAGE:0.5:1:600 RRA:AVERAGE:0.5:6:700 RRA:AVERAGE:0.5:24:775 RRA:AVERAGE:0.5:288:797 RRA:MAX:0.5:1:600 RRA:MAX:0.5:6:700 RRA:MAX:0.5:24:775 RRA:MAX:0.5:288:797
11/26/2004 04:37:27 PM - POLLER: Poller[0] CACTI2RRD: d:/rrdtool/rrdtool.exe update d:\cacti\rra\local_machine_traffic_in_46.rrd --template traffic_out:traffic_in N:381840:879162
11/26/2004 04:37:27 PM - POLLER: Poller[0] CACTI2RRD: d:/rrdtool/rrdtool.exe update d:\cacti\rra\local_machine_traffic_in_46.rrd --template traffic_out:traffic_in N:385646:882995
OK
OK
OK
OK
OK
OK
OK
OK
OK
OK
ERROR: illegal attempt to update using time 1101467247 when last update time is1101467247 (minimum one second step)
OK
OK
OK
ERROR: illegal attempt to update using time 1101467247 when last update time is1101467247 (minimum one second step)
OK
Waiting on 1/1 pollers.
Waiting on 1/1 pollers.
Waiting on 1/1 pollers.
.
.
.

then again i type command
D:\cacti>php d:\cacti\poller.php
11/26/2004 04:41:15 PM - POLLER: Poller[0] DEBUG: About to Spawn a Remote Process [CMD: d:/cactid/cactid.exe, ARGS: 0 11]
Waiting on 1/1 pollers.
Waiting on 1/1 pollers.
Waiting on 1/1 pollers.
Waiting on 1/1 pollers.
Waiting on 1/1 pollers.
.
.
.

[TheWitness]

Check the poller_output table. How many rows are in it? If there are a lot, truncate it.

TheWitness

[dev2dev]

hi, i removed my old data, now I am trying with fresh installation,
i dont understand why cacti gives me different kind of errors(repetive)

now again its saying

Warning: mysql_connect() [function.mysql-connect]: Client does not support authentication protocol requested by server; consider upgrading MySQL client in d:\cacti\lib\adodb\drivers\adodb-mysql.inc.php on line 324

Cannot connect to MySQL server on 'localhost'. Please make sure you have specified a valid MySQL database name in 'include/config.php'.

[TheWitness]

MySQL 4.1 is not officially supported yet. Installation documentation is for MySQL 4.0.x or less. It can work with Cacti, but you will have to search the board for installation instructions.

TheWitness

[dev2dev]

but mama, You "Witnessed" cacti generating graphs, it was mysql 4.1

[TheWitness]

The post is out there somewhere. I am still just getting out of bed. I will be working half the day on 0.8.7. I don't expect that I will be working on documentation today. You'll get there. When you do, you might want to goto CVS and download the *.SGML file in CVS /Cacti/cacti/docs/build and update it for MySQL 4.1.x. I will committ once it's done.

TheWitness