cacti sql bug 0.8.6j

[research]

Hi all,

I'm trying to install cacti 0.8.6j from scratch but I get these messages at cacti.log file .

01/28/2007 04:20:34 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select poller_output.output, poller_output.time, poller_output.local_data_id, poller_item.rrd_path, poller_item.rrd_name, poller_item.rrd_num from (poller_output,poller_item) where (poller_output.local_data_id=poller_item.local_data_id and poller_output.rrd_name=poller_item.rrd_name) LIMIT 10000"
01/28/2007 04:20:34 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select poller_id,end_time from poller_time where poller_id = 0"
01/28/2007 04:20:34 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select poller_id,end_time from poller_time where poller_id = 0"
01/28/2007 04:20:34 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select poller_output.output, poller_output.time, poller_output.local_data_id, poller_item.rrd_path, poller_item.rrd_name, poller_item.rrd_num from (poller_output,poller_item) where (poller_output.local_data_id=poller_item.local_data_id and poller_output.rrd_name=poller_item.rrd_name) LIMIT 10000"
01/28/2007 04:20:34 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select poller_output.output, poller_output.time, poller_output.local_data_id, poller_item.rrd_path, poller_item.rrd_name, poller_item.rrd_num from (poller_output,poller_item) where (poller_output.local_data_id=poller_item.local_data_id and poller_output.rrd_name=poller_item.rrd_name) LIMIT 10000"


whats wrong with my cacti ?

[MPI]

Hi all,

I'm trying to install cacti 0.8.6j from scratch but I get these messages at cacti.log file .

01/28/2007 04:20:34 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select poller_output.output, poller_output.time, poller_output.local_data_id, poller_item.rrd_path, poller_item.rrd_name, poller_item.rrd_num from (poller_output,poller_item) where (poller_output.local_data_id=poller_item.local_data_id and poller_output.rrd_name=poller_item.rrd_name) LIMIT 10000"
01/28/2007 04:20:34 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select poller_id,end_time from poller_time where poller_id = 0"
01/28/2007 04:20:34 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select poller_id,end_time from poller_time where poller_id = 0"
01/28/2007 04:20:34 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select poller_output.output, poller_output.time, poller_output.local_data_id, poller_item.rrd_path, poller_item.rrd_name, poller_item.rrd_num from (poller_output,poller_item) where (poller_output.local_data_id=poller_item.local_data_id and poller_output.rrd_name=poller_item.rrd_name) LIMIT 10000"
01/28/2007 04:20:34 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select poller_output.output, poller_output.time, poller_output.local_data_id, poller_item.rrd_path, poller_item.rrd_name, poller_item.rrd_num from (poller_output,poller_item) where (poller_output.local_data_id=poller_item.local_data_id and poller_output.rrd_name=poller_item.rrd_name) LIMIT 10000"


whats wrong with my cacti ?

to me that looks like a regular query....when you're trying to install, what happens? does it exit with that code?

p.s. did you make a username and password for cacti>?

[research]

Hi,

Well I can login to cacti with new password and yes it says database exists

[research]

Referring to this topic:

http://forums.cacti.net/viewtopic.php?t ... sc&start=0

I have the same problem at 0.8.6j . Seems to be this topic should be reported to developers.

"@snmpgetnext is only available in PHP5, not in 4. "

I havent any issues with 0.8.6i before..

php -v output:

PHP 4.4.2 (cli) (built: Mar 15 2006 17:27:05)
Copyright (c) 1997-2006 The PHP Group
Zend Engine v1.3.0, Copyright (c) 1998-2004 Zend Technologies
with Zend Extension Manager v1.0.10, Copyright (c) 2003-2006, by Zend Technologies
with Zend Optimizer v3.0.2, Copyright (c) 1998-2006, by Zend Technologies

php -m output:

php -m
[PHP Modules]
ctype
gd
mysql
overload
pcre
posix
RRDTool
session
snmp
sockets
standard
tokenizer
xml
Zend Optimizer
zlib

[Zend Modules]
Zend Extension Manager
Zend Optimizer

[MPI]

yaa man i cant help you there,,,u should just wait for one of the developers to reply.

p.s. u might wanna take a look at the changelog to double check but i think the only difference between i & j was the mysql injection protection.

[TheWitness]

A patch is available from the website. Please check there.

TheWitness