{"id":3122,"date":"2011-08-08T01:05:38","date_gmt":"2011-08-08T07:05:38","guid":{"rendered":"http:\/\/gregsowell.com\/?p=3122"},"modified":"2011-08-05T22:07:29","modified_gmt":"2011-08-06T04:07:29","slug":"cacti-syslog-ng-duplicate-entry-for-key","status":"publish","type":"post","link":"https:\/\/gregsowell.com\/?p=3122","title":{"rendered":"Cacti &#8211; Syslog-NG &#8211; Duplicate Entry For Key"},"content":{"rendered":"<p>If you notice that your alerts stop coming in from syslog or notice that your syslog isn&#8217;t showing any results, then check to make sure the syslog-ng service is running.<\/p>\n<pre class=\"gs-code\"><code class=\"language-plaintext\">service syslog-ng status<\/code><\/pre>\n<p>If it is running, then try restarting it.<\/p>\n<pre class=\"gs-code\"><code class=\"language-plaintext\">service syslog-ng restart<\/code><\/pre>\n<p>If you are having the same issues I have, then you will see the following<\/p>\n<pre class=\"gs-code\"><code class=\"language-plaintext\">[root@cacti ~]# service syslog-ng start\r\nERROR 1062 (23000) at line 1: Duplicate entry &#039;4294967295&#039; for key 1<\/code><\/pre>\n<p>The incoming table has some kind of key issue&#8230;and it looks like the table has maxed out.  Lets simply reset it.<\/p>\n<p><strong>From the CLI, do the following:<\/strong><br \/>\nEnter mysql and clear the syslog incoming table:<\/p>\n<pre class=\"gs-code\"><code class=\"language-plaintext\">mysql\r\nuse syslog\r\ndelete from syslog_incoming;<\/code><\/pre>\n<p>Now I reset the auto increment value:<\/p>\n<pre class=\"gs-code\"><code class=\"language-plaintext\">mysql&gt; alter table syslog_incoming AUTO_INCREMENT=1;\r\nQuery OK, 0 rows affected (0.00 sec)\r\nRecords: 0  Duplicates: 0  Warnings: 0<\/code><\/pre>\n<p>Then try starting the service:<\/p>\n<pre class=\"gs-code\"><code class=\"language-plaintext\">[root@cacti ~]# service syslog-ng start\r\nStarting system logger:                                    [  OK  ]<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"<p>If you notice that your alerts stop coming in from syslog or notice that your syslog isn&#8217;t showing any results, then check to make\u2026<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[9,14,13],"tags":[],"class_list":["post-3122","post","type-post","status-publish","format-standard","hentry","category-cacti","category-linux","category-server"],"_links":{"self":[{"href":"https:\/\/gregsowell.com\/index.php?rest_route=\/wp\/v2\/posts\/3122","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/gregsowell.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/gregsowell.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/gregsowell.com\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/gregsowell.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=3122"}],"version-history":[{"count":6,"href":"https:\/\/gregsowell.com\/index.php?rest_route=\/wp\/v2\/posts\/3122\/revisions"}],"predecessor-version":[{"id":3128,"href":"https:\/\/gregsowell.com\/index.php?rest_route=\/wp\/v2\/posts\/3122\/revisions\/3128"}],"wp:attachment":[{"href":"https:\/\/gregsowell.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=3122"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/gregsowell.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=3122"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/gregsowell.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=3122"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}