Cacti Cmdphp Error Sql Assoc Failed
ERROR: SQL Assoc Failed Moderators: Moderators, Developers Page 1 of 2 [ 16 posts ] Go to page 1, 2 Next cacti mysql password Previous topic | Next topic Author Message mistery Post subject: CMDPHP: Poller[0] ERROR: mysql error 2006 SQL Assoc FailedPosted: Sat Oct 21, 2006 3:45 am Joined: Tue May 02, 2006 1:03 amPosts: 3 Hello, I have mysql repair database upgraded Cacti to 0.8.6i and now when I run the rebuild poller cache script I get the following error in the log: 10/21/2006 10:41:14 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed "select mysql repair table 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 Debugging HelpCentral Plugin RepositoryCentral Templates Repository Top trattos Post subject: Posted: Wed Oct 25, 2006 4:48 am Joined: Thu Sep 28, 2006 4:36 pmPosts: 5Location: Marseille (France) TheWitness wrote:I suspect a damaged database.TheWitnessI have MySQL 5 and there is the same problem
RTM; ELIM instance; "Enter a value for this filter" ; REGEXP; RLIKE; regular expression Technote (troubleshooting) Problem(Abstract) There are error messages in cacti.log like below, " 05/01/2014 05:05:05 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1139', http://forums.cacti.net/about16947.html SQL:"SELECT distinct host.id,host.hostname FROM host LEFT JOIN grid_clusters ON grid_clusters.clusterid=host.clusterid INNER JOIN grid_hostgroups ON grid_hostgroups.clusterid=host.clusterid AND grid_hostgroups.host=host.hostname WHERE grid_clusters.disabled='' AND grid_clusters.clusterid=5 AND (grid_hostgroups.groupName RLIKE '*')" " Symptom ELIM graph cannot be generated. Cause The operand of REGEXP/RLIKE http://www.ibm.com/support/docview.wss?uid=isg3T1020779 is not a valid regular expression. Resolving the problem Resolve this issue by the following procedure, 1 On Platform RTM WEB GUI navigate to Console -> ELIMs. 2 Edit the ELIM instance in question. 3 Modify field "Enter a value for this filter" to a valid regular expression. Cross reference information Segment Product Component Platform Version Edition IBM Spectrum Computing IBM Spectrum LSF RTM Server Document information More support for: Platform RTM Software version: 9.1.2 Operating system(s): Platform Independent Reference #: T1020779 Modified date: 2014-05-14 Site availability Site assistance Contact and feedback Need support? Submit feedback to IBM Support 1-800-IBM-7378 (USA) Directory of worldwide contacts Contact Privacy Terms of use Accessibility
times are UTC - 6 hours [ DST ]
Importance Assigned to Milestone cacti (Ubuntu) Edit Fix Released High Paul Gevers Edit You need to log in to change this bug's status. Affecting: cacti (Ubuntu) Filed here by: Paul Gevers When: 2016-06-03 Confirmed: 2016-06-03 Assigned: 2016-06-03 Started work: 2016-06-03 Completed: 2016-06-20 Target Distribution Baltix BOSS Juju Charms Collection Elbuntu Guadalinex Guadalinex Edu Kiwi Linux nUbuntu PLD Linux Tilix tuXlab Ubuntu Ubuntu Linaro Evaluation Build Ubuntu RTM Package (Find…) Project (Find…) Status Importance Fix Released High Assigned to Me Paul Gevers (paul-climbing) Comment on this change (optional) Email me about changes to this bug report Xenial Fix Released High Paul Gevers Edit You need to log in to change this bug's status. Affecting: cacti (Ubuntu Xenial) Filed here by: Paul Gevers When: 2016-06-03 Confirmed: 2016-06-03 Assigned: 2016-06-03 Started work: 2016-06-03 Completed: 2016-06-20 Package (Find…) Status Importance Fix Released High Assigned to Me Paul Gevers (paul-climbing) Comment on this change (optional) Email me about changes to this bug report Also affects project (?) Also affects distribution/package Nominate for series Bug Description [Impact] * Although bug 1578144 fixed the installability and the fundamental running of cacti, multiple functions of the cacti web-page do not work with the default MySQL 5.7 sql_mode. * The fix forces the sql_mode ONLY_FULL_GROUP_BY setting in the MySQL connection to be unset. [Test Case] [ Verify issue ] * Install cacti on a xenial system with mysql-server installed. Connect to http://localhost/cacti, pass through the install process (i.e. hit "Ok", log in with admin/admin credentials and provide a new admin password). Then go to the http://localhost/cacti/user_admin.php page. Check that the following line appears in the /var/log/cacti/cacti.log file: 06/03/2016 07:44:43 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1055', SQL:"SELECT id, user_auth.username, full_name, realm, enabled, policy_graphs, time, max(time) as dtime FROM user_auth LEFT JOIN user_log ON (user_auth.id = user_log.user_id) GROUP BY id ORDER BY username ASC LIMIT 0,30" [ Verify fix ] * Same as above, but now without the error appearing. [Regression Potential] * The change is ve