{"id":269,"date":"2010-11-06T14:34:45","date_gmt":"2010-11-06T14:34:45","guid":{"rendered":"http:\/\/dhoytt.com\/mainblog\/2010\/11\/06\/fixed-mysql-issue-preventing-login-to-blogs\/"},"modified":"2010-11-06T14:34:45","modified_gmt":"2010-11-06T14:34:45","slug":"fixed-mysql-issue-preventing-login-to-blogs","status":"publish","type":"post","link":"http:\/\/dhoytt.com\/mainblog\/2010\/11\/fixed-mysql-issue-preventing-login-to-blogs\/","title":{"rendered":"Fixed MySql Issue Preventing Login to Blogs"},"content":{"rendered":"

I was logging into my blog trying to see what’s going on and make a post into the “Snakeice Radio House of Beats Blog” here on my site and was able to login but then kicked out as if mu session had expired.<\/p>\n

<\/div>\n
The first thing I did of course was go to the syslog and there I saw some “audispd: queue is full” message. This took me down the path to look at the “audispd” daemon and then Selinux. I tested and it didn’t seem that Selinux was preventing login and the audit log files didn’t show any lock outs even though the messages are annoying maybe these two utilities were not the issue.<\/div>\n
<\/div>\n
Well I then looked in the mysqld.log and there it listed the issue plain as can be ” [ERROR] \/usr\/libexec\/mysqld: Table ‘.\/mtdb\/mt_session’ is marked as crashed and should be repaired”!  <\/i>I then <\/i>went to MySQL administrator and repaired the table and all is well.<\/div>\n
<\/div>\n
I’ll come back and take care of the “audispd: queue is full – dropping event” error messages later, right now I have to go outside and do yard work while its day time my original plan of action today until I couldn’t stay logged into my blogs.<\/div>\n
<\/div>\n
\"Enhanced<\/a><\/span><\/div>\n","protected":false},"excerpt":{"rendered":"

I was logging into my blog trying to see what’s going on and make a post into the “Snakeice Radio House of Beats Blog” here on my site and was able to login but then kicked out as if mu … Continue reading →<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"wprm-recipe-roundup-name":"","wprm-recipe-roundup-description":"","_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[6],"tags":[156,155,153,152,49,154,150,151],"class_list":["post-269","post","type-post","status-publish","format-standard","hentry","category-whole-site-development","tag-audispd","tag-blogs","tag-kicked-out","tag-login","tag-movabletype","tag-mt_session","tag-mysql","tag-open-source"],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_likes_enabled":true,"_links":{"self":[{"href":"http:\/\/dhoytt.com\/mainblog\/wp-json\/wp\/v2\/posts\/269","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/dhoytt.com\/mainblog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/dhoytt.com\/mainblog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/dhoytt.com\/mainblog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/dhoytt.com\/mainblog\/wp-json\/wp\/v2\/comments?post=269"}],"version-history":[{"count":0,"href":"http:\/\/dhoytt.com\/mainblog\/wp-json\/wp\/v2\/posts\/269\/revisions"}],"wp:attachment":[{"href":"http:\/\/dhoytt.com\/mainblog\/wp-json\/wp\/v2\/media?parent=269"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/dhoytt.com\/mainblog\/wp-json\/wp\/v2\/categories?post=269"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/dhoytt.com\/mainblog\/wp-json\/wp\/v2\/tags?post=269"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}