Script Server Version of teMySQL stats and Host Template

Post by **TheWitness** » Thu Nov 16, 2006 4:25 pm

Edit the template and remove that field from it. It must be numeric and that setting was broken in prior versions of Cacti. By simply removing that value from the template, the Graph will be fixed.

TheWitness

CdG · Post by **CdG** » Sat Jan 13, 2007 10:10 am

Could someone please upload the new script and host template to this forum? The links in the first post appears to be down.

CdG

CdG · Post by **CdG** » Fri Jan 19, 2007 4:11 am

Just checked. The site was up-and-running again, so I'm uploading the files myself.

CdG

mahuani · Post by **mahuani** » Thu Jan 25, 2007 5:36 pm

Thanks, I've been meaning to upload them to the forums and not have the links rely on my server being up. I had a hdd crash and it took me a while to get it back up and running.

RCK · Post by **RCK** » Tue Feb 06, 2007 5:02 pm

First, I would like to thank you all for this server side conversion (especially TheWitness

)
It's amazing how this community is active!

Here is my problem: I could not import the cacti_host_template_temysql_host.xml file and I don't understand why.
The only things I get is a blank screen after the cacti import script timeout.
Then, I have the following error message each time I try to click again on "Import Templates" during the same session.
<see attached screenshot>
(Notice: Undefined index: dep in...)
(Fatal error: Only variables can be passed by reference in...)

If you have any idea, I'm interested

RCK.

Informations about my configuration:

- Operating system is Debian sarge (stable)
- Mysql version is 5.0.32
- Net-SNMP version is 5.1.2
- RRDtool version is 1.2.11
- PHP version is 5.2.0
-- php_value upload_max_filesize 20M
-- php_value post_max_size 20M
-- php_value memory_limit 32M
-- php_value max_execution_time 300

- Cacti install is the 0.8.6j release (manual install)
- I am running cactid version 0.8.6i with no problem
- I have the 3 official patches applied
-- ping_php_version4_snmpgetnext.patch
-- tree_console_missing_hosts.patch
-- thumbnail_graphs_not_working.patch)

- I have installed the following templates and scripts with no problem:
-- HP procurve 2600 series - http://forums.cacti.net/viewtopic.php?t=19060
-- CPU usage on 2, 4 and 8 way Linux devices - http://forums.cacti.net/viewtopic.php?t=15412
-- ApacheStats 0.64 (PHP Script Server Version) - http://forums.cacti.net/viewtopic.php?t=17995

number of new records into the database (after bugged import):

cdef: 2
cdef_items: 6

data_input: 18
data_input_data: 75
data_input_fields: 149

data_template: 22
data_template_data: 20
data_template_data_rra: 88
data_template_rrd: 98

graph_templates: 8
graph_templates_graph: 8
graph_templates_item: 48
graph_template_input: 40
graph_template_input_defs: 46

Post by **TheWitness** » Wed Feb 07, 2007 7:58 am

Something is definately messed up. This should not happen. Unfortunately, I am out of town and my development environment is there and not where I am.

Can you build a separate Cacti site (no polling required), just a database name and a functional web site and then try to import it into that site? Use the J build with patches.

TheWitness

RCK · Post by **RCK** » Wed Feb 07, 2007 10:52 am

Yes, this was the next step in my mind, I will do that this evening.

- setup a fresh new cacti 0.8.6j on the same box
- apply patches
- try to import this Template and pray

RCK · Post by **RCK** » Fri Feb 09, 2007 1:01 pm

There was a bug in the old PHP release (4.2.0-3 dotdeb for debian stable).
The new PHP 4.2.1 is importing the template with no problem !
I'm happy this bug was not caused by cacti, even if it was hard to catch (xml parser fault IMO).

MaffooClock · Post by **MaffooClock** » Thu Mar 15, 2007 9:44 pm

RCK wrote: Here is my problem: I could not import the cacti_host_template_temysql_host.xml file and I don't understand why.
The only things I get is a blank screen after the cacti import script timeout.
Then, I have the following error message each time I try to click again on "Import Templates" during the same session.
<see attached screenshot>
(Notice: Undefined index: dep in...)
(Fatal error: Only variables can be passed by reference in...)

I had this happen before with other imports, and I found the way to fix it is to remove all of the temporary sessions files created by PHP:
`rm /tmp/sess_*`
This will allow you to view the Import page again so you can try to re-import.

evert · Post by **evert** » Tue Jun 12, 2007 7:21 am

Hi all!

I'm having the same problem, with partial result-errors. The script runs fine from cli, but not from Cacti. Judging by the output all is parsed ok though...

Code: Select all

06/12/2007 02:10:09 PM - CMDPHP: Poller[0] Host[8] DS[85] WARNING: Result from SERVER not valid.  Partial Result: 
06/12/2007 02:10:09 PM - CMDPHP: Poller[0] Host[8] DS[85] SERVER: /usr/bin/php -q  /var/www/localhost/htdocs/cacti/scripts/ss_mysql_stats.php tevolatilequery localhost cactiuser password, output: U

When I run

Code: Select all

/usr/bin/php -q  /var/www/localhost/htdocs/cacti/scripts/ss_mysql_stats.php tevolatilequery localhost cactiuser password

from the cli, I get the correct reply:

Code: Select all

Com_delete:65401 Com_insert:48707 Com_insert_select:10 Com_truncate:2537 Com_update:15975 Com_update_multi:0

How can this be?

amsys · Post by **amsys** » Fri Jan 25, 2008 3:45 am

evert wrote:How can this be?

maybe you have apache2 binded to real interface address and MySQL running on localhost, so get fqdn from /etc/hosts for that real address and then GRANT privileges for cactiuser from this address.

fmangeant · Post by **fmangeant** » Tue Feb 12, 2008 8:17 am

Files seem no longer available...

Does anyone have a copy ?

Thanks in advance !

Post by **TheWitness** » Tue Feb 12, 2008 8:43 pm

What files Frederic?

Larry

fmangeant · Post by **fmangeant** » Wed Feb 13, 2008 2:23 am

Hi Larry

files on the 1st post, which were available here : http://mahuani.net/cacti/, but it dos not seem to be up anymore...

JFDionne · Post by **JFDionne** » Wed Feb 13, 2008 2:13 pm

Hi,
I just install the template with the last version of cacti 0.8.7b, I didn't check all the graph but I focus on the Threads/Abends, it seem to work, I got the graph, but I don't have all the data, it seem to miss the Aborted clients Aborted Connects and Threads Created, I put a gprint on each "fields" on the graph with the last value, and those fields are set at 0, but when I do the php cmd by hand, I got those:

Threads_cached:4 Threads_connected:1 Threads_created:5 Threads_running:1 Aborted_clients:0 Aborted_connects:9

but my gprint on the graph show it like:
Threads_cached:4 Threads_connected:1 Threads_created:0 Threads_running:1 Aborted_clients:0 Aborted_connects:0

I'm not an expert with Cacti and RRD, so I can't debug more myself, maybe someone can have an idea?

JFDionne

Cacti

Script Server Version of teMySQL stats and Host Template

Up again

Could not import cacti_host_template_temysql_host.xml

Bug founded !

Re: Could not import cacti_host_template_temysql_host.xml

WARNING: Result from SERVER not valid. Partial Result

Re: WARNING: Result from SERVER not valid. Partial Result

Who is online