{"id":473,"date":"2017-01-21T20:36:28","date_gmt":"2017-01-21T13:36:28","guid":{"rendered":"http:\/\/www.otakudang.org\/?p=473"},"modified":"2017-01-26T17:56:37","modified_gmt":"2017-01-26T10:56:37","slug":"tips-error-pada-saat-create-database-untuk-opensips","status":"publish","type":"post","link":"https:\/\/www.otakudang.org\/?p=473","title":{"rendered":"[tips] Error Pada Saat Create Database Untuk OpenSIPS"},"content":{"rendered":"<p>Pas lagi\u00a0<em>create<\/em> database untuk OpenSIPS, saya mendapati error berikut:<\/p>\n<pre># opensipsdbctl create\r\n MySQL password for root:\r\n INFO: test server charset\r\n INFO: creating database opensips ...\r\n INFO: Using table engine InnoDB.\r\n INFO: Core OpenSIPS tables successfully created.\r\n Install presence related tables? (y\/n): y\r\n INFO: creating presence tables into opensips ...\r\n ERROR 1101 (42000) at line 2: BLOB, TEXT, GEOMETRY or JSON column 'extra_hdrs' can't have a default value\r\n ERROR: Failed to create presence tables!<\/pre>\n<p>Setelah baca sana sini ternyata ini berhubungan dengan setting MySQL yang terlalu\u00a0<em>strict<\/em>. Untuk mengakali sementara, edit file\u00a0<strong>my.cnf<\/strong> dan tambahkan baris berikut:<\/p>\n<pre>[mysqld]\r\n sql-mode = \"\"<\/pre>\n<p>kemudian restart layanan MySQL. Ulangi lagi proses penambahan database OpenSIPS, jika lancar akan seperti ini:<\/p>\n<pre># opensipsdbctl create\r\n MySQL password for root:\r\n INFO: test server charset\r\n INFO: creating database opensips ...\r\n INFO: Using table engine InnoDB.\r\n INFO: Core OpenSIPS tables successfully created.\r\n Install presence related tables? (y\/n): y\r\n INFO: creating presence tables into opensips ...\r\n INFO: Presence tables successfully created.\r\n Install tables for imc cpl siptrace domainpolicy carrierroute userblacklist b2b cachedb_sql registrant call_center fraud_detection emergency? (y\/n): y\r\n INFO: creating extra tables into opensips ...\r\n INFO: Extra tables successfully created.<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>Pas lagi\u00a0create database untuk OpenSIPS, saya mendapati error berikut: # opensipsdbctl create MySQL password for root: INFO: test server charset INFO: creating database opensips &#8230; INFO: Using table engine InnoDB. INFO: Core OpenSIPS tables successfully created. Install presence related tables? (y\/n): y INFO: creating presence tables into opensips &#8230; ERROR 1101 (42000) at line 2: &hellip; <\/p>\n<p class=\"link-more\"><a href=\"https:\/\/www.otakudang.org\/?p=473\" class=\"more-link\">Continue reading<span class=\"screen-reader-text\"> &#8220;[tips] Error Pada Saat Create Database Untuk OpenSIPS&#8221;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-473","post","type-post","status-publish","format-standard","hentry","category-telephony","entry"],"_links":{"self":[{"href":"https:\/\/www.otakudang.org\/index.php?rest_route=\/wp\/v2\/posts\/473","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.otakudang.org\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.otakudang.org\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.otakudang.org\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.otakudang.org\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=473"}],"version-history":[{"count":2,"href":"https:\/\/www.otakudang.org\/index.php?rest_route=\/wp\/v2\/posts\/473\/revisions"}],"predecessor-version":[{"id":494,"href":"https:\/\/www.otakudang.org\/index.php?rest_route=\/wp\/v2\/posts\/473\/revisions\/494"}],"wp:attachment":[{"href":"https:\/\/www.otakudang.org\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=473"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.otakudang.org\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=473"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.otakudang.org\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=473"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}