Data Template saving issue

Post general support questions here that do not specifically fall into the Linux or Windows categories.

Moderators: Developers, Moderators

weirk
Posts: 11
Joined: Wed Mar 30, 2011 2:38 pm

Data Template saving issue

Post by weirk »

I've used cacti for several years, in any case I'm stuck I go to edit or create a data template. And after filling out the form I click "create" or "save" and it gives me a blank web page with "http://10.1.0.110/cacti/data_templates.php" in the address bar. I'm not very good at php, so I figured I got a bad data_templates file since that is the one doing what it looks like both the form and the saving. In any case that didn't resolve the issue.

Technical Support
General Information Date Wed, 30 Mar 2011 15:52:45 -0400 Cacti Version 0.8.7g Cacti OS unix SNMP Version NET-SNMP version: 5.4.3 RRDTool Version RRDTool 1.4.x Hosts 87 Graphs 193 Data Sources Script/Command: 9
SNMP: 127
SNMP Query: 88
Script Query: 3
Script - Script Server (PHP): 1
Total: 228 Poller Information Interval 60 Type cmd.php Items Action[0]: 303
Action[1]: 15
Action[2]: 1
Total: 319 Concurrent Processes 80 Max Threads 50 PHP Servers 5 Script Timeout 30 Max OID 60 Last Run Statistics Time:13.3083 Method:cmd.php Processes:80 Threads:N/A Hosts:88 HostsPerProcess:2 DataSources:111 RRDsProcessed:83 PHP Information PHP Version 5.3.3-1ubuntu9.3 PHP OS Linux PHP uname Linux cacti 2.6.35-27-server #48-Ubuntu SMP Tue Feb 22 21:53:16 UTC 2011 x86_64 PHP SNMP Installed max_execution_time 30 memory_limit 128M MySQL Table Information

Here is a link to a redacted copy of the database
https://docs.google.com/leaf?id=0B0M9qf ... y=CNuu6qYP

I created a screen capture for it, and shared it out:
Low Res version [2MB]
https://docs.google.com/leaf?id=0B0M9qf ... y=CLKKv7EG
Hi res Version [6MB]
https://docs.google.com/leaf?id=0B0M9qf ... y=CL78kcIK
Any help is appreciated.
Last edited by weirk on Fri Apr 01, 2011 11:22 am, edited 2 times in total.
User avatar
gandalf
Developer
Posts: 22383
Joined: Thu Dec 02, 2004 2:46 am
Location: Muenster, Germany
Contact:

Re: Data Template saving issue

Post by gandalf »

Are you able to dump the Cacti db and post a gzipped copy to my mail account?
R.
susan11
Posts: 1
Joined: Thu Mar 31, 2011 12:19 am

Re: Data Template saving issue

Post by susan11 »

gandalf wrote:Are you able to dump the Cacti db and post a gzipped copy to my mail account?
R.
I also wanna know
weirk
Posts: 11
Joined: Wed Mar 30, 2011 2:38 pm

Re: Data Template saving issue

Post by weirk »

Gandolf, you should have received a copy, and a copy is now part of the original post.
User avatar
gandalf
Developer
Posts: 22383
Joined: Thu Dec 02, 2004 2:46 am
Location: Muenster, Germany
Contact:

Re: Data Template saving issue

Post by gandalf »

I received the db and was able to install it.
But I'm sorry, I tried arbitrary Data Templates (edit, save) without any problem.
Please point me to an exact sequence of actions that is able to reproduce your problem.
R.
weirk
Posts: 11
Joined: Wed Mar 30, 2011 2:38 pm

Re: Data Template saving issue

Post by weirk »

I created a screen capture for it, and shared it out:
Low Res version [2MB]
https://docs.google.com/leaf?id=0B0M9qf ... y=CLKKv7EG
Hi res Version [6MB]
https://docs.google.com/leaf?id=0B0M9qf ... y=CL78kcIK

The basic is I go to "Data Templates" Select any template, and try to make a change, I go to save and it gives me a blank page. All of the other template editors work. I was trying to change the interface Traffic template to allow Per-data Source Value's so I could have some at 1 minute and most at 5 minutes.
weirk
Posts: 11
Joined: Wed Mar 30, 2011 2:38 pm

Re: Data Template saving issue

Post by weirk »

If this is not a database issue, other then the data_template.php file, what other files would be involved that I should try replacing? maybe one is corrupt or something.
User avatar
gandalf
Developer
Posts: 22383
Joined: Thu Dec 02, 2004 2:46 am
Location: Muenster, Germany
Contact:

Re: Data Template saving issue

Post by gandalf »

I tried this on 087g with some plugins (perhaps not the same you're using).
I used the very same template and did the very same change and all was fine.
Are you able to draw a cacti.log for this very actions only while in DEBUG logging verbosity?
R.
User avatar
gandalf
Developer
Posts: 22383
Joined: Thu Dec 02, 2004 2:46 am
Location: Muenster, Germany
Contact:

Re: Data Template saving issue

Post by gandalf »

weirk wrote:If this is not a database issue, other then the data_template.php file, what other files would be involved that I should try replacing? maybe one is corrupt or something.
This file for sure is the first bet. I would quickly scan httpd error log as well
R.
weirk
Posts: 11
Joined: Wed Mar 30, 2011 2:38 pm

Re: Data Template saving issue

Post by weirk »

Well I had two screens up, turned it up to dev logging, clicked save, and then turned off the logging, and I got this below. Which at least some of it seems like it should be updating something, but I'm not sure It wasn't the poller/weathermap

04/01/2011 03:41:52 PM - CMDPHP: Poller[0] DEVEL: SQL Exec: "replace into settings (name,value) values ('deletion_verification', 'on')"

04/01/2011 03:41:52 PM - CMDPHP: Poller[0] DEVEL: SQL Exec: "replace into settings (name,value) values ('reindex_method', '1')"

04/01/2011 03:41:52 PM - CMDPHP: Poller[0] DEVEL: SQL Exec: "replace into settings (name,value) values ('snmp_retries', '3')"

04/01/2011 03:41:52 PM - CMDPHP: Poller[0] DEVEL: SQL Exec: "replace into settings (name,value) values ('snmp_port', '161')"

04/01/2011 03:41:52 PM - CMDPHP: Poller[0] DEVEL: SQL Exec: "replace into settings (name,value) values ('snmp_timeout', '1000')"

04/01/2011 03:41:52 PM - CMDPHP: Poller[0] DEVEL: SQL Exec: "replace into settings (name,value) values ('snmp_priv_protocol', 'DES')"

04/01/2011 03:41:52 PM - CMDPHP: Poller[0] DEVEL: SQL Exec: "replace into settings (name,value) values ('snmp_priv_passphrase', '')"

04/01/2011 03:41:52 PM - CMDPHP: Poller[0] DEVEL: SQL Exec: "replace into settings (name,value) values ('snmp_auth_protocol', 'MD5')"

04/01/2011 03:41:52 PM - CMDPHP: Poller[0] DEVEL: SQL Exec: "replace into settings (name,value) values ('snmp_password', '')"

04/01/2011 03:41:52 PM - CMDPHP: Poller[0] DEVEL: SQL Exec: "replace into settings (name,value) values ('snmp_username', '')"

04/01/2011 03:41:52 PM - CMDPHP: Poller[0] DEVEL: SQL Exec: "replace into settings (name,value) values ('snmp_community', 'public;pass')"

04/01/2011 03:41:52 PM - CMDPHP: Poller[0] DEVEL: SQL Exec: "replace into settings (name,value) values ('snmp_ver', '2')"

04/01/2011 03:41:52 PM - CMDPHP: Poller[0] DEVEL: SQL Exec: "replace into settings (name,value) values ('rrdtool_version', 'rrd-1.4.x')"

04/01/2011 03:41:52 PM - CMDPHP: Poller[0] DEVEL: SQL Exec: "replace into settings (name,value) values ('snmp_version', 'net-snmp')"

04/01/2011 03:41:52 PM - CMDPHP: Poller[0] DEVEL: SQL Exec: "replace into settings (name,value) values ('log_perror', 'on')"

04/01/2011 03:41:52 PM - CMDPHP: Poller[0] DEVEL: SQL Exec: "replace into settings (name,value) values ('log_pwarn', 'on')"

04/01/2011 03:41:52 PM - CMDPHP: Poller[0] DEVEL: SQL Exec: "replace into settings (name,value) values ('log_pstats', 'on')"

04/01/2011 03:41:52 PM - CMDPHP: Poller[0] DEVEL: SQL Exec: "replace into settings (name,value) values ('log_verbosity', '1')"

04/01/2011 03:41:52 PM - CMDPHP: Poller[0] DEVEL: SQL Exec: "replace into settings (name,value) values ('log_export', '')"

04/01/2011 03:41:52 PM - CMDPHP: Poller[0] DEVEL: SQL Exec: "replace into settings (name,value) values ('log_graph', 'on')"

04/01/2011 03:41:52 PM - CMDPHP: Poller[0] DEVEL: SQL Exec: "replace into settings (name,value) values ('log_snmp', 'on')"

04/01/2011 03:41:52 PM - CMDPHP: Poller[0] DEVEL: SQL Exec: "replace into settings (name,value) values ('log_destination', '2')"

04/01/2011 03:41:52 PM - CMDPHP: Poller[0] DEVEL: SQL Assoc: "select user_auth_realm.realm_id from user_auth_realm where user_auth_realm.user_id='1' and user_auth_realm.realm_id='15'"

04/01/2011 03:41:52 PM - CMDPHP: Poller[0] DEVEL: SQL Cell: "select id from user_auth where username='guest'"

04/01/2011 03:41:52 PM - CMDPHP: Poller[0] DEVEL: SQL Assoc: "SELECT 1 AS id, ph.name, ph.file, ph.function FROM plugin_hooks AS ph LEFT JOIN plugin_config AS pc ON pc.directory=ph.name WHERE ph.status = 1 AND hook = 'auth_alternate_realms' AND ph.name IN ('settings', 'boost', 'dsstats') UNION SELECT pc.id, ph.name, ph.file, ph.function FROM plugin_hooks AS ph LEFT JOIN plugin_config AS pc ON pc.directory=ph.name WHERE ph.status = 1 AND hook = 'auth_alternate_realms' AND ph.name NOT IN ('settings', 'boost', 'dsstats') ORDER BY id ASC"

04/01/2011 03:41:52 PM - CMDPHP: Poller[0] DEVEL: SQL Cell: "select cacti from version"

04/01/2011 03:41:52 PM - CMDPHP: Poller[0] DEVEL: SQL Assoc: "SELECT 1 AS id, ph.name, ph.file, ph.function FROM plugin_hooks AS ph LEFT JOIN plugin_config AS pc ON pc.directory=ph.name WHERE ph.status = 1 AND hook = 'config_insert' AND ph.name IN ('settings', 'boost', 'dsstats') UNION SELECT pc.id, ph.name, ph.file, ph.function FROM plugin_hooks AS ph LEFT JOIN plugin_config AS pc ON pc.directory=ph.name WHERE ph.status = 1 AND hook = 'config_insert' AND ph.name NOT IN ('settings', 'boost', 'dsstats') ORDER BY id ASC"

04/01/2011 03:41:52 PM - CMDPHP: Poller[0] DEVEL: SQL Assoc: "SELECT 1 AS id, ph.name, ph.file, ph.function FROM plugin_hooks AS ph LEFT JOIN plugin_config AS pc ON pc.directory=ph.name WHERE ph.status = 1 AND hook = 'config_form' AND ph.name IN ('settings', 'boost', 'dsstats') UNION SELECT pc.id, ph.name, ph.file, ph.function FROM plugin_hooks AS ph LEFT JOIN plugin_config AS pc ON pc.directory=ph.name WHERE ph.status = 1 AND hook = 'config_form' AND ph.name NOT IN ('settings', 'boost', 'dsstats') ORDER BY id ASC"

04/01/2011 03:41:52 PM - CMDPHP: Poller[0] DEVEL: SQL Assoc: "SELECT 1 AS id, ph.name, ph.file, ph.function FROM plugin_hooks AS ph LEFT JOIN plugin_config AS pc ON pc.directory=ph.name WHERE ph.status = 1 AND hook = 'valid_host_fields' AND ph.name IN ('settings', 'boost', 'dsstats') UNION SELECT pc.id, ph.name, ph.file, ph.function FROM plugin_hooks AS ph LEFT JOIN plugin_config AS pc ON pc.directory=ph.name WHERE ph.status = 1 AND hook = 'valid_host_fields' AND ph.name NOT IN ('settings', 'boost', 'dsstats') ORDER BY id ASC"

04/01/2011 03:41:52 PM - CMDPHP: Poller[0] DEVEL: SQL Assoc: "select graph_tree.id, graph_tree.name, user_auth_perms.user_id from graph_tree left join user_auth_perms on (graph_tree.id=user_auth_perms.item_id and user_auth_perms.type=2 and user_auth_perms.user_id=1) where user_auth_perms.user_id is null order by graph_tree.name"

04/01/2011 03:41:52 PM - CMDPHP: Poller[0] DEVEL: SQL Row: "select policy_trees from user_auth where id=1"

04/01/2011 03:41:52 PM - CMDPHP: Poller[0] DEVEL: SQL Assoc: "SELECT 1 AS id, ph.name, ph.file, ph.function FROM plugin_hooks AS ph LEFT JOIN plugin_config AS pc ON pc.directory=ph.name WHERE ph.status = 1 AND hook = 'config_settings' AND ph.name IN ('settings', 'boost', 'dsstats') UNION SELECT pc.id, ph.name, ph.file, ph.function FROM plugin_hooks AS ph LEFT JOIN plugin_config AS pc ON pc.directory=ph.name WHERE ph.status = 1 AND hook = 'config_settings' AND ph.name NOT IN ('settings', 'boost', 'dsstats') ORDER BY id ASC"

04/01/2011 03:41:52 PM - CMDPHP: Poller[0] DEVEL: SQL Assoc: "SELECT id FROM plugin_realms WHERE plugin = 'weathermap' AND file = 'weathermap-cacti-plugin-mgmt.php'"

04/01/2011 03:41:52 PM - CMDPHP: Poller[0] DEVEL: SQL Assoc: "SELECT id FROM plugin_realms WHERE plugin = 'weathermap' AND file = 'weathermap-cacti-plugin.php'"

04/01/2011 03:41:52 PM - CMDPHP: Poller[0] DEVEL: SQL Assoc: "SELECT id FROM plugin_realms WHERE plugin = 'aggregate' AND file = 'aggregate_templates.php,aggregate_templates_items.php,color_templates.php,color_templates_items.php'"

04/01/2011 03:41:52 PM - CMDPHP: Poller[0] DEVEL: SQL Cell: "SELECT directory FROM plugin_config WHERE directory='boost' and status='1'"

04/01/2011 03:41:52 PM - CMDPHP: Poller[0] DEVEL: SQL Assoc: "SELECT * FROM plugin_realms ORDER BY plugin, display"

04/01/2011 03:41:52 PM - CMDPHP: Poller[0] DEVEL: SQL Assoc: "SELECT 1 AS id, ph.name, ph.file, ph.function FROM plugin_hooks AS ph LEFT JOIN plugin_config AS pc ON pc.directory=ph.name WHERE ph.status = 1 AND hook = 'config_arrays' AND ph.name IN ('settings', 'boost', 'dsstats') UNION SELECT pc.id, ph.name, ph.file, ph.function FROM plugin_hooks AS ph LEFT JOIN plugin_config AS pc ON pc.directory=ph.name WHERE ph.status = 1 AND hook = 'config_arrays' AND ph.name NOT IN ('settings', 'boost', 'dsstats') ORDER BY id ASC"

04/01/2011 03:41:42 PM - CMDPHP: Poller[0] DEVEL: SQL Assoc: "select user_auth_realm.realm_id from user_auth_realm where user_auth_realm.user_id='1' and user_auth_realm.realm_id='11'"

04/01/2011 03:41:42 PM - CMDPHP: Poller[0] DEVEL: SQL Cell: "select id from user_auth where username='guest'"

04/01/2011 03:41:42 PM - CMDPHP: Poller[0] DEVEL: SQL Assoc: "SELECT 1 AS id, ph.name, ph.file, ph.function FROM plugin_hooks AS ph LEFT JOIN plugin_config AS pc ON pc.directory=ph.name WHERE ph.status = 1 AND hook = 'auth_alternate_realms' AND ph.name IN ('settings', 'boost', 'dsstats') UNION SELECT pc.id, ph.name, ph.file, ph.function FROM plugin_hooks AS ph LEFT JOIN plugin_config AS pc ON pc.directory=ph.name WHERE ph.status = 1 AND hook = 'auth_alternate_realms' AND ph.name NOT IN ('settings', 'boost', 'dsstats') ORDER BY id ASC"

04/01/2011 03:41:42 PM - CMDPHP: Poller[0] DEVEL: SQL Cell: "select cacti from version"

04/01/2011 03:41:42 PM - CMDPHP: Poller[0] DEVEL: SQL Assoc: "SELECT 1 AS id, ph.name, ph.file, ph.function FROM plugin_hooks AS ph LEFT JOIN plugin_config AS pc ON pc.directory=ph.name WHERE ph.status = 1 AND hook = 'config_insert' AND ph.name IN ('settings', 'boost', 'dsstats') UNION SELECT pc.id, ph.name, ph.file, ph.function FROM plugin_hooks AS ph LEFT JOIN plugin_config AS pc ON pc.directory=ph.name WHERE ph.status = 1 AND hook = 'config_insert' AND ph.name NOT IN ('settings', 'boost', 'dsstats') ORDER BY id ASC"

04/01/2011 03:41:42 PM - CMDPHP: Poller[0] DEVEL: SQL Assoc: "SELECT 1 AS id, ph.name, ph.file, ph.function FROM plugin_hooks AS ph LEFT JOIN plugin_config AS pc ON pc.directory=ph.name WHERE ph.status = 1 AND hook = 'config_form' AND ph.name IN ('settings', 'boost', 'dsstats') UNION SELECT pc.id, ph.name, ph.file, ph.function FROM plugin_hooks AS ph LEFT JOIN plugin_config AS pc ON pc.directory=ph.name WHERE ph.status = 1 AND hook = 'config_form' AND ph.name NOT IN ('settings', 'boost', 'dsstats') ORDER BY id ASC"

04/01/2011 03:41:42 PM - CMDPHP: Poller[0] DEVEL: SQL Assoc: "SELECT 1 AS id, ph.name, ph.file, ph.function FROM plugin_hooks AS ph LEFT JOIN plugin_config AS pc ON pc.directory=ph.name WHERE ph.status = 1 AND hook = 'valid_host_fields' AND ph.name IN ('settings', 'boost', 'dsstats') UNION SELECT pc.id, ph.name, ph.file, ph.function FROM plugin_hooks AS ph LEFT JOIN plugin_config AS pc ON pc.directory=ph.name WHERE ph.status = 1 AND hook = 'valid_host_fields' AND ph.name NOT IN ('settings', 'boost', 'dsstats') ORDER BY id ASC"

04/01/2011 03:41:42 PM - CMDPHP: Poller[0] DEVEL: SQL Assoc: "SELECT 1 AS id, ph.name, ph.file, ph.function FROM plugin_hooks AS ph LEFT JOIN plugin_config AS pc ON pc.directory=ph.name WHERE ph.status = 1 AND hook = 'config_settings' AND ph.name IN ('settings', 'boost', 'dsstats') UNION SELECT pc.id, ph.name, ph.file, ph.function FROM plugin_hooks AS ph LEFT JOIN plugin_config AS pc ON pc.directory=ph.name WHERE ph.status = 1 AND hook = 'config_settings' AND ph.name NOT IN ('settings', 'boost', 'dsstats') ORDER BY id ASC"

04/01/2011 03:41:42 PM - CMDPHP: Poller[0] DEVEL: SQL Assoc: "SELECT id FROM plugin_realms WHERE plugin = 'weathermap' AND file = 'weathermap-cacti-plugin-mgmt.php'"

04/01/2011 03:41:42 PM - CMDPHP: Poller[0] DEVEL: SQL Assoc: "SELECT id FROM plugin_realms WHERE plugin = 'weathermap' AND file = 'weathermap-cacti-plugin.php'"

04/01/2011 03:41:42 PM - CMDPHP: Poller[0] DEVEL: SQL Assoc: "SELECT id FROM plugin_realms WHERE plugin = 'aggregate' AND file = 'aggregate_templates.php,aggregate_templates_items.php,color_templates.php,color_templates_items.php'"

04/01/2011 03:41:42 PM - CMDPHP: Poller[0] DEVEL: SQL Cell: "SELECT directory FROM plugin_config WHERE directory='boost' and status='1'"

04/01/2011 03:41:42 PM - CMDPHP: Poller[0] DEVEL: SQL Assoc: "SELECT * FROM plugin_realms ORDER BY plugin, display"

04/01/2011 03:41:42 PM - CMDPHP: Poller[0] DEVEL: SQL Assoc: "SELECT 1 AS id, ph.name, ph.file, ph.function FROM plugin_hooks AS ph LEFT JOIN plugin_config AS pc ON pc.directory=ph.name WHERE ph.status = 1 AND hook = 'config_arrays' AND ph.name IN ('settings', 'boost', 'dsstats') UNION SELECT pc.id, ph.name, ph.file, ph.function FROM plugin_hooks AS ph LEFT JOIN plugin_config AS pc ON pc.directory=ph.name WHERE ph.status = 1 AND hook = 'config_arrays' AND ph.name NOT IN ('settings', 'boost', 'dsstats') ORDER BY id ASC"

04/01/2011 03:41:37 PM - CMDPHP: Poller[0] DEVEL: SQL Assoc: "SELECT 1 AS id, ph.name, ph.file, ph.function FROM plugin_hooks AS ph LEFT JOIN plugin_config AS pc ON pc.directory=ph.name WHERE ph.status = 1 AND hook = 'top_header' AND ph.name IN ('settings', 'boost', 'dsstats') UNION SELECT pc.id, ph.name, ph.file, ph.function FROM plugin_hooks AS ph LEFT JOIN plugin_config AS pc ON pc.directory=ph.name WHERE ph.status = 1 AND hook = 'top_header' AND ph.name NOT IN ('settings', 'boost', 'dsstats') ORDER BY id ASC"

04/01/2011 03:41:37 PM - CMDPHP: Poller[0] DEVEL: SQL Cell: "select value from settings where name='deletion_verification'"

04/01/2011 03:41:37 PM - CMDPHP: Poller[0] DEVEL: SQL Assoc: "select value from `cacti`.`settings` where name='deletion_verification'"

04/01/2011 03:41:37 PM - CMDPHP: Poller[0] DEVEL: SQL Cell: "select value from settings where name='reindex_method'"

04/01/2011 03:41:37 PM - CMDPHP: Poller[0] DEVEL: SQL Assoc: "select value from `cacti`.`settings` where name='reindex_method'"

04/01/2011 03:41:37 PM - CMDPHP: Poller[0] DEVEL: SQL Cell: "select value from settings where name='other_header'"

04/01/2011 03:41:37 PM - CMDPHP: Poller[0] DEVEL: SQL Assoc: "select value from `cacti`.`settings` where name='other_header'"

04/01/2011 03:41:37 PM - CMDPHP: Poller[0] DEVEL: SQL Cell: "select value from settings where name='snmp_retries'"

04/01/2011 03:41:37 PM - CMDPHP: Poller[0] DEVEL: SQL Assoc: "select value from `cacti`.`settings` where name='snmp_retries'"

04/01/2011 03:41:37 PM - CMDPHP: Poller[0] DEVEL: SQL Cell: "select value from settings where name='snmp_port'"

04/01/2011 03:41:37 PM - CMDPHP: Poller[0] DEVEL: SQL Assoc: "select value from `cacti`.`settings` where name='snmp_port'"

04/01/2011 03:41:37 PM - CMDPHP: Poller[0] DEVEL: SQL Cell: "select value from settings where name='snmp_timeout'"

04/01/2011 03:41:37 PM - CMDPHP: Poller[0] DEVEL: SQL Assoc: "select value from `cacti`.`settings` where name='snmp_timeout'"

04/01/2011 03:41:37 PM - CMDPHP: Poller[0] DEVEL: SQL Cell: "select value from settings where name='snmp_priv_protocol'"

04/01/2011 03:41:37 PM - CMDPHP: Poller[0] DEVEL: SQL Assoc: "select value from `cacti`.`settings` where name='snmp_priv_protocol'"

04/01/2011 03:41:37 PM - CMDPHP: Poller[0] DEVEL: SQL Cell: "select value from settings where name='snmp_priv_passphrase'"

04/01/2011 03:41:37 PM - CMDPHP: Poller[0] DEVEL: SQL Assoc: "select value from `cacti`.`settings` where name='snmp_priv_passphrase'"

04/01/2011 03:41:37 PM - CMDPHP: Poller[0] DEVEL: SQL Cell: "select value from settings where name='snmp_auth_protocol'"

04/01/2011 03:41:37 PM - CMDPHP: Poller[0] DEVEL: SQL Assoc: "select value from `cacti`.`settings` where name='snmp_auth_protocol'"

04/01/2011 03:41:37 PM - CMDPHP: Poller[0] DEVEL: SQL Cell: "select value from settings where name='snmp_password'"

04/01/2011 03:41:37 PM - CMDPHP: Poller[0] DEVEL: SQL Assoc: "select value from `cacti`.`settings` where name='snmp_password'"

04/01/2011 03:41:37 PM - CMDPHP: Poller[0] DEVEL: SQL Cell: "select value from settings where name='snmp_username'"

04/01/2011 03:41:37 PM - CMDPHP: Poller[0] DEVEL: SQL Assoc: "select value from `cacti`.`settings` where name='snmp_username'"

04/01/2011 03:41:37 PM - CMDPHP: Poller[0] DEVEL: SQL Cell: "select value from settings where name='snmp_community'"

04/01/2011 03:41:37 PM - CMDPHP: Poller[0] DEVEL: SQL Assoc: "select value from `cacti`.`settings` where name='snmp_community'"

04/01/2011 03:41:37 PM - CMDPHP: Poller[0] DEVEL: SQL Cell: "select value from settings where name='snmp_ver'"

04/01/2011 03:41:37 PM - CMDPHP: Poller[0] DEVEL: SQL Assoc: "select value from `cacti`.`settings` where name='snmp_ver'"

04/01/2011 03:41:37 PM - CMDPHP: Poller[0] DEVEL: SQL Cell: "select value from settings where name='snmp_header'"

04/01/2011 03:41:37 PM - CMDPHP: Poller[0] DEVEL: SQL Assoc: "select value from `cacti`.`settings` where name='snmp_header'"

04/01/2011 03:41:37 PM - CMDPHP: Poller[0] DEVEL: SQL Cell: "select value from settings where name='rrdtool_version'"

04/01/2011 03:41:37 PM - CMDPHP: Poller[0] DEVEL: SQL Assoc: "select value from `cacti`.`settings` where name='rrdtool_version'"

04/01/2011 03:41:37 PM - CMDPHP: Poller[0] DEVEL: SQL Cell: "select value from settings where name='snmp_version'"

04/01/2011 03:41:37 PM - CMDPHP: Poller[0] DEVEL: SQL Assoc: "select value from `cacti`.`settings` where name='snmp_version'"

04/01/2011 03:41:37 PM - CMDPHP: Poller[0] DEVEL: SQL Cell: "select value from settings where name='versions_header'"

04/01/2011 03:41:37 PM - CMDPHP: Poller[0] DEVEL: SQL Assoc: "select value from `cacti`.`settings` where name='versions_header'"

04/01/2011 03:41:37 PM - CMDPHP: Poller[0] DEVEL: SQL Cell: "select value from settings where name='log_perror'"

04/01/2011 03:41:37 PM - CMDPHP: Poller[0] DEVEL: SQL Assoc: "select value from `cacti`.`settings` where name='log_perror'"

04/01/2011 03:41:37 PM - CMDPHP: Poller[0] DEVEL: SQL Cell: "select value from settings where name='log_pwarn'"

04/01/2011 03:41:37 PM - CMDPHP: Poller[0] DEVEL: SQL Assoc: "select value from `cacti`.`settings` where name='log_pwarn'"

04/01/2011 03:41:37 PM - CMDPHP: Poller[0] DEVEL: SQL Cell: "select value from settings where name='log_pstats'"

04/01/2011 03:41:37 PM - CMDPHP: Poller[0] DEVEL: SQL Assoc: "select value from `cacti`.`settings` where name='log_pstats'"

04/01/2011 03:41:37 PM - CMDPHP: Poller[0] DEVEL: SQL Cell: "select value from settings where name='log_verbosity'"

04/01/2011 03:41:37 PM - CMDPHP: Poller[0] DEVEL: SQL Assoc: "select value from `cacti`.`settings` where name='log_verbosity'"

04/01/2011 03:41:37 PM - CMDPHP: Poller[0] DEVEL: SQL Cell: "select value from settings where name='poller_header'"

04/01/2011 03:41:37 PM - CMDPHP: Poller[0] DEVEL: SQL Assoc: "select value from `cacti`.`settings` where name='poller_header'"

04/01/2011 03:41:37 PM - CMDPHP: Poller[0] DEVEL: SQL Cell: "select value from settings where name='log_export'"

04/01/2011 03:41:37 PM - CMDPHP: Poller[0] DEVEL: SQL Assoc: "select value from `cacti`.`settings` where name='log_export'"

04/01/2011 03:41:37 PM - CMDPHP: Poller[0] DEVEL: SQL Cell: "select value from settings where name='log_graph'"

04/01/2011 03:41:37 PM - CMDPHP: Poller[0] DEVEL: SQL Assoc: "select value from `cacti`.`settings` where name='log_graph'"

04/01/2011 03:41:37 PM - CMDPHP: Poller[0] DEVEL: SQL Cell: "select value from settings where name='log_snmp'"

04/01/2011 03:41:37 PM - CMDPHP: Poller[0] DEVEL: SQL Assoc: "select value from `cacti`.`settings` where name='log_snmp'"

04/01/2011 03:41:37 PM - CMDPHP: Poller[0] DEVEL: SQL Cell: "select value from settings where name='log_destination'"

04/01/2011 03:41:37 PM - CMDPHP: Poller[0] DEVEL: SQL Assoc: "select value from `cacti`.`settings` where name='log_destination'"

04/01/2011 03:41:37 PM - CMDPHP: Poller[0] DEVEL: SQL Cell: "select value from settings where name='logging_header'"

04/01/2011 03:41:37 PM - CMDPHP: Poller[0] DEVEL: SQL Assoc: "select value from `cacti`.`settings` where name='logging_header'"

04/01/2011 03:41:37 PM - CMDPHP: Poller[0] DEVEL: SQL Assoc: "SELECT id FROM plugin_realms WHERE plugin = 'weathermap' AND file = 'weathermap-cacti-plugin-mgmt.php'"

04/01/2011 03:41:37 PM - CMDPHP: Poller[0] DEVEL: SQL Assoc: "SELECT id FROM plugin_realms WHERE plugin = 'weathermap' AND file = 'weathermap-cacti-plugin.php'"

04/01/2011 03:41:37 PM - CMDPHP: Poller[0] DEVEL: SQL Assoc: "SELECT id FROM plugin_realms WHERE plugin = 'aggregate' AND file = 'aggregate_templates.php,aggregate_templates_items.php,color_templates.php,color_templates_items.php'"

04/01/2011 03:41:37 PM - CMDPHP: Poller[0] DEVEL: SQL Cell: "SELECT directory FROM plugin_config WHERE directory='boost' and status='1'"

04/01/2011 03:41:37 PM - CMDPHP: Poller[0] DEVEL: SQL Assoc: "SELECT * FROM plugin_realms ORDER BY plugin, display"

04/01/2011 03:41:37 PM - CMDPHP: Poller[0] DEVEL: SQL Assoc: "SELECT 1 AS id, ph.name, ph.file, ph.function FROM plugin_hooks AS ph LEFT JOIN plugin_config AS pc ON pc.directory=ph.name WHERE ph.status = 1 AND hook = 'config_arrays' AND ph.name IN ('settings', 'boost', 'dsstats') UNION SELECT pc.id, ph.name, ph.file, ph.function FROM plugin_hooks AS ph LEFT JOIN plugin_config AS pc ON pc.directory=ph.name WHERE ph.status = 1 AND hook = 'config_arrays' AND ph.name NOT IN ('settings', 'boost', 'dsstats') ORDER BY id ASC"

04/01/2011 03:41:37 PM - CMDPHP: Poller[0] DEVEL: SQL Assoc: "select realm_id from user_auth_realm where user_id=1"

04/01/2011 03:41:37 PM - CMDPHP: Poller[0] DEVEL: SQL Cell: "select username from user_auth where id=1"

04/01/2011 03:41:37 PM - CMDPHP: Poller[0] DEVEL: SQL Assoc: "SELECT 1 AS id, ph.name, ph.file, ph.function FROM plugin_hooks AS ph LEFT JOIN plugin_config AS pc ON pc.directory=ph.name WHERE ph.status = 1 AND hook = 'draw_navigation_text' AND ph.name IN ('settings', 'boost', 'dsstats') UNION SELECT pc.id, ph.name, ph.file, ph.function FROM plugin_hooks AS ph LEFT JOIN plugin_config AS pc ON pc.directory=ph.name WHERE ph.status = 1 AND hook = 'draw_navigation_text' AND ph.name NOT IN ('settings', 'boost', 'dsstats') ORDER BY id ASC"

04/01/2011 03:41:37 PM - CMDPHP: Poller[0] DEVEL: SQL Assoc: "select user_auth_realm.realm_id from user_auth_realm where user_auth_realm.user_id='1' and user_auth_realm.realm_id='107'"

04/01/2011 03:41:37 PM - CMDPHP: Poller[0] DEVEL: SQL Assoc: "select user_auth_realm.realm_id from user_auth_realm where user_auth_realm.user_id='1' and user_auth_realm.realm_id='2120'"

04/01/2011 03:41:37 PM - CMDPHP: Poller[0] DEVEL: SQL Assoc: "show columns from `host`"

04/01/2011 03:41:37 PM - CMDPHP: Poller[0] DEVEL: SQL Assoc: "show columns from `host`"

04/01/2011 03:41:37 PM - CMDPHP: Poller[0] DEVEL: SQL Assoc: "select realm_id from user_auth_realm where user_id=1"

04/01/2011 03:41:37 PM - CMDPHP: Poller[0] DEVEL: SQL Assoc: "SELECT 1 AS id, ph.name, ph.file, ph.function FROM plugin_hooks AS ph LEFT JOIN plugin_config AS pc ON pc.directory=ph.name WHERE ph.status = 1 AND hook = 'top_header_tabs' AND ph.name IN ('settings', 'boost', 'dsstats') UNION SELECT pc.id, ph.name, ph.file, ph.function FROM plugin_hooks AS ph LEFT JOIN plugin_config AS pc ON pc.directory=ph.name WHERE ph.status = 1 AND hook = 'top_header_tabs' AND ph.name NOT IN ('settings', 'boost', 'dsstats') ORDER BY id ASC"

04/01/2011 03:41:37 PM - CMDPHP: Poller[0] DEVEL: SQL Assoc: "SELECT 1 AS id, ph.name, ph.file, ph.function FROM plugin_hooks AS ph LEFT JOIN plugin_config AS pc ON pc.directory=ph.name WHERE ph.status = 1 AND hook = 'body_style' AND ph.name IN ('settings', 'boost', 'dsstats') UNION SELECT pc.id, ph.name, ph.file, ph.function FROM plugin_hooks AS ph LEFT JOIN plugin_config AS pc ON pc.directory=ph.name WHERE ph.status = 1 AND hook = 'body_style' AND ph.name NOT IN ('settings', 'boost', 'dsstats') ORDER BY id ASC"

04/01/2011 03:41:37 PM - CMDPHP: Poller[0] DEVEL: SQL Assoc: "SELECT 1 AS id, ph.name, ph.file, ph.function FROM plugin_hooks AS ph LEFT JOIN plugin_config AS pc ON pc.directory=ph.name WHERE ph.status = 1 AND hook = 'page_head' AND ph.name IN ('settings', 'boost', 'dsstats') UNION SELECT pc.id, ph.name, ph.file, ph.function FROM plugin_hooks AS ph LEFT JOIN plugin_config AS pc ON pc.directory=ph.name WHERE ph.status = 1 AND hook = 'page_head' AND ph.name NOT IN ('settings', 'boost', 'dsstats') ORDER BY id ASC"

04/01/2011 03:41:37 PM - CMDPHP: Poller[0] DEVEL: SQL Assoc: "SELECT 1 AS id, ph.name, ph.file, ph.function FROM plugin_hooks AS ph LEFT JOIN plugin_config AS pc ON pc.directory=ph.name WHERE ph.status = 1 AND hook = 'page_title' AND ph.name IN ('settings', 'boost', 'dsstats') UNION SELECT pc.id, ph.name, ph.file, ph.function FROM plugin_hooks AS ph LEFT JOIN plugin_config AS pc ON pc.directory=ph.name WHERE ph.status = 1 AND hook = 'page_title' AND ph.name NOT IN ('settings', 'boost', 'dsstats') ORDER BY id ASC"

04/01/2011 03:41:37 PM - CMDPHP: Poller[0] DEVEL: SQL Assoc: "SELECT 1 AS id, ph.name, ph.file, ph.function FROM plugin_hooks AS ph LEFT JOIN plugin_config AS pc ON pc.directory=ph.name WHERE ph.status = 1 AND hook = 'draw_navigation_text' AND ph.name IN ('settings', 'boost', 'dsstats') UNION SELECT pc.id, ph.name, ph.file, ph.function FROM plugin_hooks AS ph LEFT JOIN plugin_config AS pc ON pc.directory=ph.name WHERE ph.status = 1 AND hook = 'draw_navigation_text' AND ph.name NOT IN ('settings', 'boost', 'dsstats') ORDER BY id ASC"

04/01/2011 03:41:37 PM - CMDPHP: Poller[0] DEVEL: SQL Assoc: "SELECT 1 AS id, ph.name, ph.file, ph.function FROM plugin_hooks AS ph LEFT JOIN plugin_config AS pc ON pc.directory=ph.name WHERE ph.status = 1 AND hook = 'top_header' AND ph.name IN ('settings', 'boost', 'dsstats') UNION SELECT pc.id, ph.name, ph.file, ph.function FROM plugin_hooks AS ph LEFT JOIN plugin_config AS pc ON pc.directory=ph.name WHERE ph.status = 1 AND hook = 'top_header' AND ph.name NOT IN ('settings', 'boost', 'dsstats') ORDER BY id ASC"

04/01/2011 03:41:37 PM - CMDPHP: Poller[0] DEVEL: SQL Assoc: "select user_auth_realm.realm_id from user_auth_realm where user_auth_realm.user_id='1' and user_auth_realm.realm_id='15'"

04/01/2011 03:41:37 PM - CMDPHP: Poller[0] DEVEL: SQL Cell: "select id from user_auth where username='guest'"

04/01/2011 03:41:37 PM - CMDPHP: Poller[0] DEVEL: SQL Assoc: "SELECT 1 AS id, ph.name, ph.file, ph.function FROM plugin_hooks AS ph LEFT JOIN plugin_config AS pc ON pc.directory=ph.name WHERE ph.status = 1 AND hook = 'auth_alternate_realms' AND ph.name IN ('settings', 'boost', 'dsstats') UNION SELECT pc.id, ph.name, ph.file, ph.function FROM plugin_hooks AS ph LEFT JOIN plugin_config AS pc ON pc.directory=ph.name WHERE ph.status = 1 AND hook = 'auth_alternate_realms' AND ph.name NOT IN ('settings', 'boost', 'dsstats') ORDER BY id ASC"

04/01/2011 03:41:37 PM - CMDPHP: Poller[0] DEVEL: SQL Cell: "select cacti from version"

04/01/2011 03:41:37 PM - CMDPHP: Poller[0] DEVEL: SQL Assoc: "SELECT 1 AS id, ph.name, ph.file, ph.function FROM plugin_hooks AS ph LEFT JOIN plugin_config AS pc ON pc.directory=ph.name WHERE ph.status = 1 AND hook = 'config_insert' AND ph.name IN ('settings', 'boost', 'dsstats') UNION SELECT pc.id, ph.name, ph.file, ph.function FROM plugin_hooks AS ph LEFT JOIN plugin_config AS pc ON pc.directory=ph.name WHERE ph.status = 1 AND hook = 'config_insert' AND ph.name NOT IN ('settings', 'boost', 'dsstats') ORDER BY id ASC"

04/01/2011 03:41:37 PM - CMDPHP: Poller[0] DEVEL: SQL Assoc: "SELECT 1 AS id, ph.name, ph.file, ph.function FROM plugin_hooks AS ph LEFT JOIN plugin_config AS pc ON pc.directory=ph.name WHERE ph.status = 1 AND hook = 'config_form' AND ph.name IN ('settings', 'boost', 'dsstats') UNION SELECT pc.id, ph.name, ph.file, ph.function FROM plugin_hooks AS ph LEFT JOIN plugin_config AS pc ON pc.directory=ph.name WHERE ph.status = 1 AND hook = 'config_form' AND ph.name NOT IN ('settings', 'boost', 'dsstats') ORDER BY id ASC"

04/01/2011 03:41:37 PM - CMDPHP: Poller[0] DEVEL: SQL Assoc: "SELECT 1 AS id, ph.name, ph.file, ph.function FROM plugin_hooks AS ph LEFT JOIN plugin_config AS pc ON pc.directory=ph.name WHERE ph.status = 1 AND hook = 'valid_host_fields' AND ph.name IN ('settings', 'boost', 'dsstats') UNION SELECT pc.id, ph.name, ph.file, ph.function FROM plugin_hooks AS ph LEFT JOIN plugin_config AS pc ON pc.directory=ph.name WHERE ph.status = 1 AND hook = 'valid_host_fields' AND ph.name NOT IN ('settings', 'boost', 'dsstats') ORDER BY id ASC"

04/01/2011 03:41:37 PM - CMDPHP: Poller[0] DEVEL: SQL Assoc: "select graph_tree.id, graph_tree.name, user_auth_perms.user_id from graph_tree left join user_auth_perms on (graph_tree.id=user_auth_perms.item_id and user_auth_perms.type=2 and user_auth_perms.user_id=1) where user_auth_perms.user_id is null order by graph_tree.name"

04/01/2011 03:41:37 PM - CMDPHP: Poller[0] DEVEL: SQL Row: "select policy_trees from user_auth where id=1"

04/01/2011 03:41:37 PM - CMDPHP: Poller[0] DEVEL: SQL Assoc: "SELECT 1 AS id, ph.name, ph.file, ph.function FROM plugin_hooks AS ph LEFT JOIN plugin_config AS pc ON pc.directory=ph.name WHERE ph.status = 1 AND hook = 'config_settings' AND ph.name IN ('settings', 'boost', 'dsstats') UNION SELECT pc.id, ph.name, ph.file, ph.function FROM plugin_hooks AS ph LEFT JOIN plugin_config AS pc ON pc.directory=ph.name WHERE ph.status = 1 AND hook = 'config_settings' AND ph.name NOT IN ('settings', 'boost', 'dsstats') ORDER BY id ASC"

04/01/2011 03:41:37 PM - CMDPHP: Poller[0] DEVEL: SQL Assoc: "SELECT id FROM plugin_realms WHERE plugin = 'weathermap' AND file = 'weathermap-cacti-plugin-mgmt.php'"

04/01/2011 03:41:37 PM - CMDPHP: Poller[0] DEVEL: SQL Assoc: "SELECT id FROM plugin_realms WHERE plugin = 'weathermap' AND file = 'weathermap-cacti-plugin.php'"

04/01/2011 03:41:36 PM - CMDPHP: Poller[0] DEVEL: SQL Assoc: "SELECT id FROM plugin_realms WHERE plugin = 'aggregate' AND file = 'aggregate_templates.php,aggregate_templates_items.php,color_templates.php,color_templates_items.php'"

04/01/2011 03:41:36 PM - CMDPHP: Poller[0] DEVEL: SQL Cell: "SELECT directory FROM plugin_config WHERE directory='boost' and status='1'"

04/01/2011 03:41:36 PM - CMDPHP: Poller[0] DEVEL: SQL Assoc: "SELECT * FROM plugin_realms ORDER BY plugin, display"

04/01/2011 03:41:36 PM - CMDPHP: Poller[0] DEVEL: SQL Assoc: "SELECT 1 AS id, ph.name, ph.file, ph.function FROM plugin_hooks AS ph LEFT JOIN plugin_config AS pc ON pc.directory=ph.name WHERE ph.status = 1 AND hook = 'config_arrays' AND ph.name IN ('settings', 'boost', 'dsstats') UNION SELECT pc.id, ph.name, ph.file, ph.function FROM plugin_hooks AS ph LEFT JOIN plugin_config AS pc ON pc.directory=ph.name WHERE ph.status = 1 AND hook = 'config_arrays' AND ph.name NOT IN ('settings', 'boost', 'dsstats') ORDER BY id ASC"

04/01/2011 03:41:22 PM - WEBUI: Cacti Log Cleared from Web Management Interface

And here are some Apache logs:
0.40.0.12 - - [01/Apr/2011:15:51:01 -0400] "POST /cacti/data_templates.php HTTP/1.1" 200 500 "http://10.1.0.110/cacti/data_templates. ... edit&id=41" "Mozilla/5.0 (compatible; MSIE 9.0; Windows NT 6.1; WOW64; Trident/5.0)"
10.40.0.12 - - [01/Apr/2011:15:51:01 -0400] "GET /favicon.ico HTTP/1.1" 404 501 "-" "Mozilla/5.0 (compatible; MSIE 9.0; Windows NT 6.1; WOW64; Trident/5.0)"
10.40.0.12 - - [01/Apr/2011:15:51:03 -0400] "GET /cacti/data_templates.php?action=template_edit&id=41 HTTP/1.1" 200 4870 "http://10.1.0.110/cacti/data_templates.php" "Mozilla/5.0 (compatible; MSIE 9.0; Windows NT 6.1; WOW64; Trident/5.0)"
10.40.0.12 - - [01/Apr/2011:15:51:08 -0400] "GET /cacti/data_templates.php HTTP/1.1" 200 5386 "http://10.1.0.110/cacti/data_templates. ... edit&id=41" "Mozilla/5.0 (compatible; MSIE 9.0; Windows NT 6.1; WOW64; Trident/5.0)"
127.0.0.1 - - [01/Apr/2011:15:51:16 -0400] "OPTIONS * HTTP/1.0" 200 152 "-" "Apache/2.2.16 (Ubuntu) (internal dummy connection)"
127.0.0.1 - - [01/Apr/2011:15:51:17 -0400] "OPTIONS * HTTP/1.0" 200 152 "-" "Apache/2.2.16 (Ubuntu) (internal dummy connection)"
127.0.0.1 - - [01/Apr/2011:15:51:23 -0400] "OPTIONS * HTTP/1.0" 200 152 "-" "Apache/2.2.16 (Ubuntu) (internal dummy connection)"
10.40.0.12 - - [01/Apr/2011:15:52:01 -0400] "GET /cacti/utilities.php?action=view_logfile HTTP/1.1" 200 4972 "-" "Mozilla/5.0 (compatible; MSIE 9.0; Windows NT 6.1; WOW64; Trident/5.0)"
10.40.0.12 - - [01/Apr/2011:15:52:01 -0400] "GET /cacti/include/main.css HTTP/1.1" 304 212 "http://10.1.0.110/cacti/utilities.php?a ... ew_logfile" "Mozilla/5.0 (compatible; MSIE 9.0; Windows NT 6.1; WOW64; Trident/5.0)"
10.40.0.12 - - [01/Apr/2011:15:52:01 -0400] "GET /cacti/include/layout.js HTTP/1.1" 304 213 "http://10.1.0.110/cacti/utilities.php?a ... ew_logfile" "Mozilla/5.0 (compatible; MSIE 9.0; Windows NT 6.1; WOW64; Trident/5.0)"
10.40.0.12 - - [01/Apr/2011:15:52:01 -0400] "GET /cacti/plugins/mactrack/mactrack.js HTTP/1.1" 304 213 "http://10.1.0.110/cacti/utilities.php?a ... ew_logfile" "Mozilla/5.0 (compatible; MSIE 9.0; Windows NT 6.1; WOW64; Trident/5.0)"
10.40.0.12 - - [01/Apr/2011:15:52:01 -0400] "GET /cacti/images/tab_graphs.gif HTTP/1.1" 304 189 "http://10.1.0.110/cacti/utilities.php?a ... ew_logfile" "Mozilla/5.0 (compatible; MSIE 9.0; Windows NT 6.1; WOW64; Trident/5.0)"
weirk
Posts: 11
Joined: Wed Mar 30, 2011 2:38 pm

Re: Data Template saving issue

Post by weirk »

I also tried it with the developer debug on, and filtered just for things on the data template Id I was changing, this is what I got below:
It looks like it's just the queries on getting the data, when I actually click save where does that goto? I'm assuming somewhere in the data_templates.php file?

Log File [Total Lines: 20 - All Items Shown]

04/01/2011 04:16:12 PM - CMDPHP: Poller[0] DEVEL: SQL Row: "select t_value,value from data_input_data where data_template_data_id=41 and data_input_field_id=11"



04/01/2011 04:16:12 PM - CMDPHP: Poller[0] DEVEL: SQL Row: "select t_value,value from data_input_data where data_template_data_id=41 and data_input_field_id=9"



04/01/2011 04:16:12 PM - CMDPHP: Poller[0] DEVEL: SQL Row: "select t_value,value from data_input_data where data_template_data_id=41 and data_input_field_id=56"



04/01/2011 04:16:12 PM - CMDPHP: Poller[0] DEVEL: SQL Row: "select t_value,value from data_input_data where data_template_data_id=41 and data_input_field_id=55"



04/01/2011 04:16:12 PM - CMDPHP: Poller[0] DEVEL: SQL Row: "select t_value,value from data_input_data where data_template_data_id=41 and data_input_field_id=48"



04/01/2011 04:16:12 PM - CMDPHP: Poller[0] DEVEL: SQL Row: "select t_value,value from data_input_data where data_template_data_id=41 and data_input_field_id=10"



04/01/2011 04:16:12 PM - CMDPHP: Poller[0] DEVEL: SQL Row: "select t_value,value from data_input_data where data_template_data_id=41 and data_input_field_id=7"



04/01/2011 04:16:12 PM - CMDPHP: Poller[0] DEVEL: SQL Row: "select t_value,value from data_input_data where data_template_data_id=41 and data_input_field_id=8"



04/01/2011 04:16:12 PM - CMDPHP: Poller[0] DEVEL: SQL Row: "select t_value,value from data_input_data where data_template_data_id=41 and data_input_field_id=54"



04/01/2011 04:16:12 PM - CMDPHP: Poller[0] DEVEL: SQL Row: "select t_value,value from data_input_data where data_template_data_id=41 and data_input_field_id=57"



04/01/2011 04:16:12 PM - CMDPHP: Poller[0] DEVEL: SQL Row: "select t_value,value from data_input_data where data_template_data_id=41 and data_input_field_id=14"



04/01/2011 04:16:12 PM - CMDPHP: Poller[0] DEVEL: SQL Row: "select t_value,value from data_input_data where data_template_data_id=41 and data_input_field_id=13"



04/01/2011 04:16:12 PM - CMDPHP: Poller[0] DEVEL: SQL Row: "select t_value,value from data_input_data where data_template_data_id=41 and data_input_field_id=12"



04/01/2011 04:16:12 PM - CMDPHP: Poller[0] DEVEL: SQL Assoc: "select id,data_source_name from data_template_rrd where data_template_id=41 and local_data_id=0 order by data_source_name"



04/01/2011 04:16:12 PM - CMDPHP: Poller[0] DEVEL: SQL Assoc: "select rra_id as id,data_template_data_id from data_template_data_rra where data_template_data_id=41"



04/01/2011 04:16:12 PM - CMDPHP: Poller[0] DEVEL: SQL Row: "select * from data_template where id=41"



04/01/2011 04:16:12 PM - CMDPHP: Poller[0] DEVEL: SQL Row: "select * from data_template_data where data_template_id=41 and local_data_id=0"



04/01/2011 04:16:05 PM - CMDPHP: Poller[0] Host[148] DS[6387] SNMP: v2: 172.18.13.1, dsname: sonicwall_cpu, oid: .1.3.6.1.4.1.8741.1.3.1.3.0, output: U



04/01/2011 04:16:05 PM - CMDPHP: Poller[0] Host[148] DS[6386] SNMP: v2: 172.18.13.1, dsname: sonicwall_connects, oid: .1.3.6.1.4.1.8741.1.3.1.2.0, output: U



04/01/2011 04:16:05 PM - CMDPHP: Poller[0] DEVEL: SQL Exec: "update host set status = '3', status_event_count = '0', status_fail_date = '0000-00-00 00:00:00', status_rec_date = '0000-00-00 00:00:00', status_last_error = '', min_time = '0.36000', max_time = '156.35000', cur_time = '0.75', avg_time = '1.5419236644267', total_polls = '4762', failed_polls = '0', availability = '100' where hostname = '172.19.80.26'"
User avatar
gandalf
Developer
Posts: 22383
Joined: Thu Dec 02, 2004 2:46 am
Location: Muenster, Germany
Contact:

Re: Data Template saving issue

Post by gandalf »

weirk wrote:And here are some Apache logs:
0.40.0.12 - - [01/Apr/2011:15:51:01 -0400] "POST /cacti/data_templates.php HTTP/1.1" 200 500 "http://10.1.0.110/cacti
This is access.log, not error.log
R.
weirk
Posts: 11
Joined: Wed Mar 30, 2011 2:38 pm

Re: Data Template saving issue

Post by weirk »

Gandolf I'll double check but I think the error log was empty. And the cacti log I posted was from when I tried to change the data template.
weirk
Posts: 11
Joined: Wed Mar 30, 2011 2:38 pm

Re: Data Template saving issue

Post by weirk »

I'll also post the php file.
weirk
Posts: 11
Joined: Wed Mar 30, 2011 2:38 pm

Re: Data Template saving issue

Post by weirk »

Okay, well I've discovered my problem, aparently it's IE 9 x64 bit which I have on my PC. I am running IE 9.0.8080.16413 which is the latest and I didn't have it in compatibility mode. (Not sure what that has to do with the PHP code, but once I tried it in Firefox and in compatibility mode it works, go back to IE non compatibility mode. So I'm not sure what's going to be required in the long run, if it's a new PHP engine or if it's changes to the PHP code. But that's where the issue seems to be.
Post Reply

Who is online

Users browsing this forum: No registered users and 0 guests