Cmd Php Error Sql Assoc Failed
Contents |
ERROR: SQL Assoc Failed Moderators: Moderators, Developers Page 1 of 2 [ 16 posts ] cacti mysql password Go to page 1, 2 Next Previous topic | Next
Mysql Error 2006
topic Author Message mistery Post subject: CMDPHP: Poller[0] ERROR: SQL Assoc FailedPosted: Sat Oct 21, 2006 3:45 am mysql repair database Joined: Tue May 02, 2006 1:03 amPosts: 3 Hello, I have upgraded Cacti to 0.8.6i and now when I run the rebuild poller cache script I get the following mysql repair table error in the log: 10/21/2006 10:41:14 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed "select snmp_query_graph_rrd.snmp_field_name, data_template_rrd.id as data_template_rrd_id from (snmp_query_graph_rrd,data_template_rrd) where snmp_query_graph_rrd.data_template_rrd_id=data_template_rrd.local_data_template_rrd_id and snmp_query_graph_rrd.snmp_query_graph_id= and snmp_query_graph_rrd.data_template_id=41 and data_template_rrd.local_data_id=90" Does anyone know how to fix this issue ? Thanks A. Top TheWitness Post subject: Posted: Sat Oct 21, 2006 2:00 pm Developer Joined: Tue May 14, 2002 5:08 pmPosts: 14862Location: MI, USA Can you verify you MySQL version please? TheWitness _________________True understanding begins only when we realize how little we truly understand...Life is an adventure, let yours begin with Cacti!Author of MacTrack, Boost, CLog, SpikeKill, Platform RTM, DSStats, maintainer of Spine, lot's of unpublished work and most of Cacti's bugs._________________Official Cacti DocumentationGandalfs Official Debugging HelpCentral Plugin RepositoryCentral Templates Repository Top mistery Post subject: Posted: Sun Oct 22, 2006 1:06 am Joined: Tue May 02, 2006 1:03 amPosts: 3 TheWitness wrote:Can you verify you MySQL version please?TheWitness # rpm -q mysql mysql-4.1.20-1.RHEL4.1 Thanks A. Top TheWitness Post subject: Posted: Sun Oct 22, 2006 7:03 pm Developer Joined: Tue May 14, 2002 5:08 pmPosts: 14862Location: MI, USA I suspect a damaged database. TheWitness _________________True understanding begins only when we realize how little we truly understand...Life is an adventure, let yours begin with Cacti!Author of MacTrack, Boost, CLog, SpikeKill, Platform RTM, DSStats, maintainer of Spine, lot's of unpublished work and most of Cacti's bugs._________________Official Cacti DocumentationGandalfs Official De
Introduction Cacti on Gutsy snmpd setup Installing Cacti on Ubuntu 6.06 LTS (Dapper Drake) Caveats Install MySQL server Install Cacti Setup Cacti Recommended: Create a root password for MySQL Installing Cacti on https://help.ubuntu.com/community/Cacti Ubuntu Server 6.06 (Dapper Drake) Setup Cacti Recommended: Create a root password for MySQL Previous Documentation on Installing Cacti Installing Cacti for Ubuntu - Part 1 Installing Cacti for Ubuntu - Part 2 Installing Cacti for Ubuntu - Part 3: Errors FAQ (Work In Progress) Introduction Cacti is a complete network graphing solution designed to harness the power of RRDTool's data mysql repair storage and graphing functionality. Cacti provides a fast poller, advanced graph templating, multiple data acquisition methods, and user management features out of the box. All of this is wrapped in an intuitive, easy to use interface that makes sense for LAN-sized installations up to complex networks with hundreds of devices. Cacti on Gutsy snmpd setup apt-get install snmp snmpd snmpconf -g basic_setup cmd php error Installing Cacti on Ubuntu 6.06 LTS (Dapper Drake) Caveats These instructions are for the graphical installer. Server installation instructions are found below. If this procedure doesn't work for you, try the previous procedure which is documented below. Install MySQL server To install MySQL server you need to install the mysql-server package Install Cacti You can get the cacti package from the Universe Repository. Click "Forward" on the warning titled "Configuring libphp-adodb" If you have entered a root password for MySQL, enter it on the window titled "Password of your database's administrative user:". If the root password is blank, just hit enter and continue. Leave the question "MySQL application password for Cacti" blank and hit "Forward". Note: The system will create a random password for you, so you don't need to enter one On the "Webserver type" question, select "Apache2" and then click "Forward" Setup Cacti Visit the website of your Cacti server, should be similar to "http://localhost/cacti/" This should automatically initiate the "Cacti Installation Guide" in your web-browser Click "Next", "Next", and "Finish" to complete this guide Login to Cacti with the default u