{"id":611,"date":"2014-03-07T14:29:41","date_gmt":"2014-03-07T17:29:41","guid":{"rendered":"http:\/\/blog.abratel.com.br\/?p=611"},"modified":"2014-03-07T14:48:50","modified_gmt":"2014-03-07T17:48:50","slug":"reparar-um-banco-em-sqlite3-asterisk-astdb","status":"publish","type":"post","link":"https:\/\/blog.abratel.com.br\/?p=611","title":{"rendered":"Reparar um banco em sqlite3 asterisk astdb"},"content":{"rendered":"<p>Ao tentar conectar no asterisk tenho a mensagem:<br \/>\n[root@ ~]# asterisk -r<br \/>\nUnable to connect to remote asterisk (does \/var\/run\/asterisk\/asterisk.ctl exist?)<\/p>\n<p>Quando tendo acessar com asterisk -vvvvvvvvvvgc tenho a mensagem abaixo.<\/p>\n<p><strong>Erro deparado ap\u00f3s um pique de energia:<\/strong><br \/>\n[Mar  7 11:21:09] WARNING[2320]: db.c:135 init_stmt: Couldn&#8217;t prepare statement &#8216;CREATE TABLE IF NOT EXISTS astdb(key VARCHAR(256), value VARCHAR(256), PRIMARY KEY(key))&#8217;: disk I\/O error<br \/>\n[Mar  7 11:21:09] WARNING[2320]: db.c:210 db_create_astdb: Couldn&#8217;t create astdb table: disk I\/O error <\/p>\n<p><strong>Solu\u00e7\u00e3o:<\/strong><br \/>\nFoi necess\u00e1rio reparar o bando de dados do asterisk utilizando<\/p>\n<p>echo .dump | sqlite3 \/var\/lib\/asterisk\/astdb.sqlite3 > \/var\/lib\/asterisk\/astdb.sqlite3_DUMP<\/p>\n<p>sqlite3 -init \/var\/lib\/asterisk\/astdb.sqlite3_DUMP \/var\/lib\/asterisk\/astdb.sqlite3_FIXED;<\/p>\n<p>mv \/var\/lib\/asterisk\/astdb.sqlite3 \/var\/lib\/asterisk\/astdb.sqlite3_error<\/p>\n<p>mv \/var\/lib\/asterisk\/astdb.sqlite3_FIXED \/var\/lib\/asterisk\/astdb.sqlite3<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Ao tentar conectar no asterisk tenho a mensagem: [root@ ~]# asterisk -r Unable to connect to remote asterisk (does \/var\/run\/asterisk\/asterisk.ctl exist?) Quando tendo acessar com asterisk -vvvvvvvvvvgc tenho a mensagem abaixo. Erro deparado ap\u00f3s um pique de energia: [Mar 7 11:21:09] WARNING[2320]: db.c:135 init_stmt: Couldn&#8217;t&#8230;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":[],"categories":[1,2],"tags":[],"_links":{"self":[{"href":"https:\/\/blog.abratel.com.br\/index.php?rest_route=\/wp\/v2\/posts\/611"}],"collection":[{"href":"https:\/\/blog.abratel.com.br\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.abratel.com.br\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.abratel.com.br\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.abratel.com.br\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=611"}],"version-history":[{"count":3,"href":"https:\/\/blog.abratel.com.br\/index.php?rest_route=\/wp\/v2\/posts\/611\/revisions"}],"predecessor-version":[{"id":614,"href":"https:\/\/blog.abratel.com.br\/index.php?rest_route=\/wp\/v2\/posts\/611\/revisions\/614"}],"wp:attachment":[{"href":"https:\/\/blog.abratel.com.br\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=611"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.abratel.com.br\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=611"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.abratel.com.br\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=611"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}