Ad blocker detected: Our website is made possible by displaying online advertisements to our visitors. Please consider supporting us by disabling your ad blocker on our website.
I've read the other posts and checked the setting but cant get this to work.
I keep getting the following error:
Error
You have created a new database, but have not yet imported the 'cacti.sql' file. At the command line, execute the following to continue:
mysql -u root -p cacti < cacti.sql
This error may also be generated if the cacti database user does not have correct permissions on the cacti database. Please ensure that the cacti database user has the ability to SELECT, INSERT, DELETE, UPDATE, CREATE, ALTER, DROP, INDEX on the cacti database.
I've tried running the command line but keep getting:
ERROR 1064 (42000):
What is the correct command to run? MySQL is installed under program files.
I would also suggest re-installing mysql and this put it in c:/mysql rather than program files. I'm sure I have read something about mysql issues when installing in a path with spaces.
Jay
Cacti Version 0.8.7e, Spine 0.8.7e, Apache 2.2.15, Mysql 5.0.88, PHP 5.2.13, RRDTool 1.2.30, NET-SNMP 5.5
Quad Core AMD Opteron Processor 2384, 2.70Ghz, 2GB RAM , 1 CPU used
Windows Server 2003 (X64), VMWARE ESX
Plugins: Aggregate 0.75
SYSTEM STATS: Time:12.5140 Method:spine Processes:2 Threads:15 Hosts:400 HostsPerProcess:200 DataSources:2909 RRDsProcessed:1384
If using Cactid do the following for the host in question and post
cactid --verbosity 5 -f 79 -l 79
verbosity level = 5 (Debug) -f = first host which is 79 (you can find the host by clicking on the host you want under devices and looking at the url, e.g http://test/cacti/host.php?action=edit&id=79 -l - last host - i used the same host id as i only wanted to look at the one host.
08/24/2007 11:19:23 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select graph_templates_item.id as graph_templates_item_id, graph_templates_item.cdef_id, graph_templates_item.text_format, graph_templates_item.value, graph_templates_item.hard_return, graph_templates_item.consolidation_function_id, graph_templates_item.graph_type_id, graph_templates_gprint.gprint_text, colors.hex, data_template_rrd.id as data_template_rrd_id, data_template_rrd.local_data_id, data_template_rrd.rrd_minimum, data_template_rrd.rrd_maximum, data_template_rrd.data_source_name, data_template_rrd.local_data_template_rrd_id from graph_templates_item left join data_template_rrd on (graph_templates_item.task_item_id=data_template_rrd.id) left join colors on (graph_templates_item.color_id=colors.id) left join graph_templates_gprint on (graph_templates_item.gprint_id=graph_templates_gprint.id) where graph_templates_item.local_graph_id=8 order by graph_templates_item.sequence"
1) what versions of everything are you using?
2) did you patch cacti?
3) Did you properly get the cacti.sql file imported with NO errors?
4) post a rrdtool graph output, fully i.e. Go to graph mamagenemtn, click on a graph, click on enable graph debugging and post the output (for a broken graph).
Thanks for all your help.... I got the graphs generating, and some data in it... Issue was with windows permision to folders, and the schedule poll was not running correctly, still isn't running as well as it should... sometimes the schedule does not run, or when it runs the graphs refuse to update, but I'll look at the 2k3 server for that.
LAST:" Current\:%8.2lf %s" \
LAST:"Current\:%8.2lf %s" \