Error Sql Assoc Failed
Contents |
ERROR: SQL Assoc Failed Moderators: Moderators, Developers Page 1 of 2 [ 16 posts ] Go to page 1, 2 mysql repair database Next Previous topic | Next topic Author Message mistery Post subject:
Mysql Repair Table
CMDPHP: Poller[0] ERROR: SQL Assoc FailedPosted: Sat Oct 21, 2006 3:45 am 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 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 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)
APAR status Closed as suggestion for future release. Error description There were errors in cacti.log as below: 07/02/2014 02:23:40 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1064', SQL:"SELECT *, IF (job_last_exited>job_last_ended,job_last_exited,job_last_ended) AS lastFinished FROM grid_summary WHERE clusterid=2 AND bhost_status='Closed-Busy' AND (hstatus & 131072)=0 AND numRun=0 AND numJobs=0 AND host not in (select host from grid_hostgroups LIMIT 1" Local fix As "the last where http://forums.cacti.net/about16947.html clause" is always cut off when generating default layout data, please rewrite the SQL query like below, select * from (
3 Child Category 4 Featured Health Childcare Doctors Uncategorized Sidebar Search for: Popular Posts Creating Graph for Mikrotik Queue Tree using Cacti It's a long title, isn't it http://karns79.blogspot.com/2009/12/no-graphs-sql-cell-errors-in-cactilog.html ? Okay, first thing first, You have to download all these files : http://www.networking-forum.com/viewtopic.php?t=27878 cacti_host_template_mikrotik_queue.xml cact... Brainwave Attract Wealth Setelah baca bukunya The Secret coba juga brainwave-nya. Saya sudah upload, terdiri dari 4 file, masing-masing dapat kamu download dibawah i... No graphs, SQL Cell errors in cacti.log Everything is okay, until the accident last nignt, when the electric was blackout. The cacti server was no graph. In mysql repair checking the cacti.log... Cacti Buat Mikrotik Ternyata sudah lengkap tool untuk monitoring Mikrotik dengan cacti. Jadi sekarang udah bisa menggrap : System HDD CPU Memory Uptime G... 24 Prinsip Miliarder Satu lagi e-book buat kamu.... "24 Prinsip Miliarder" Disini dibahas 24 Prinsip Miliarder yang dicerahkan yang ditulis oleh Tung ... Graphing Router OS Simple Queue Using Cacti I've searched the forum and the internet for tutorial on error sql assoc how to capture Router OS's simple queue OID using cacti, and haven't find any luck.... The Secret Ternyata apapun yang kamu inginkan didunia ini bisa dicapai dengan mudah.... kamu mau, tinggal minta... seperti kamu mempunyai seorang jin ... Mari Belajar BGP Apakah BGP? Border Gateway Protocol atau yang sering disingkat BGP merupakan salah satu jenis routing protocol yang ada di dunia komunika... BGP Finite State Machine: Troubleshooting 1. Idle Waiting for Start event, normally initiated by operator (establishing new BGP session or resetting an existing session). After error... How to Delete mailman archives from cPanel backend Go to "/usr/local/cpanel/3rdparty/mailman/archives/private" #cd /usr/local/cpanel/3rdparty/mailman/archives/private You ca... Recent Posts Categories Curhat Coret Motivasi Tutorial Pages Home Blog Archive ► 2016 (2) ► May (1) ► March (1) ► 2014 (1) ► February (1) ► 2013 (2) ► December (2) ► 2010 (4) ► March (1) ► January (3) ▼ 2009 (19) ▼ December (19) BGP Finite State Machine: Troubleshooting Tahukah Anda ... Kuliah Ke Jerman ... mimpi ? Creating Graph for Mikrotik Queue Tree using Cacti... Mari Belajar BGP Graphing Router OS Simple Queue Using Cacti /bin/rm: Argument list too long. Cacti Buat Mikrotik Export Graph Problem Error: Passwords do not match, ple
View active topics View new posts View your posts General technical discussions. Post a reply 16 posts Page 1 of 1 ZiPPy Ultimate Member Posts: 509 Joined: Mon Aug 24, 2009 3:04 pm Certs: CCNA Unable to login to Cacti Fri Nov 18, 2011 12:04 pm I've hit up the Cacti forums, but didn't find any answers on my issue with Cacti. I installed a fresh install of Cacti the other day successfully. I was troubleshooting an issue in Cacti where my graphs are showing blank, and in some cases not at all. But that's an entirely separate issue.I can no longer login to Cacti. I can't remember for the life of me what I did, but now when I attempt to login it just loops for a quick second and back at the login screen. I know my password is correct, as it doesn't throw back any errors.Has anybody encountered this before? I here so many good things about Cacti and I wanted to get it running, but I literally killed it right now.Any thoughts? ristau5741 Post Whore Posts: 10618 Joined: Tue Aug 21, 2007 2:15 pm Certs: Instanity Re: Unable to login to Cacti Fri Nov 18, 2011 12:42 pm if its fresh, reinstall, sure it's not a browser issue? Tips of the day:- The human mind is the ultimate creation invention.- I have so many customers, my customers have customers. - Sausage time- POP, stack, and store ZiPPy Ultimate Member Posts: 509 Joined: Mon Aug 24, 2009 3:04 pm Certs: CCNA Re: Unable to login to Cacti Fri Nov 18, 2011 1:13 pm I'm pretty sure it's not browser related, because after I made a change it kicked me out right away. It was to an admin setting though, and I just can't remember exactly where I did it. damn it! scottsee Post Whore Posts: 1804 Joined: Wed Feb 10, 2010 2:45 am Certs: NA:R&S, NA:Sec Re: Unable to login to Cacti Fri Nov 18, 2011 1:20 pm Try a System Restore.. ZiPPy Ultimate Member Posts: 509 Joined: Mon Aug 24, 2009 3:04 pm Certs: CCNA Re: Unable to login to Cacti Fri Nov 18, 2011 1:26 pm scottsee wrote:Try a System Restore..Running Cacti on Ubuntu. cjutting Post Whore Posts: 1081 Joined: Wed Sep 16, 2009 3:16 pm Re: Unable to login to Cacti Fri Nov 18, 2011 2:05 pm http://www.cacti.net/downloads/docs/htm ... ml#AEN2449Does that help?Edit: Sorry I didn't read the part where you knew your password is correct. It might be worth trying to reset your password anyways see if for some reason it