{"id":613,"date":"2017-12-09T23:07:50","date_gmt":"2017-12-09T16:07:50","guid":{"rendered":"http:\/\/www.otakudang.org\/?p=613"},"modified":"2017-12-09T23:12:11","modified_gmt":"2017-12-09T16:12:11","slug":"tips-error-create-database-opensips-dengan-opensipsdbctl-create","status":"publish","type":"post","link":"https:\/\/www.otakudang.org\/?p=613","title":{"rendered":"[TIPS] Error Create Database OpenSIPS Dengan &#8220;opensipsdbctl create&#8221;"},"content":{"rendered":"<p>Baru iseng-iseng nguprek OpenSIPS, pada saat create database dengan tool\u00a0<em>opensipsdbctl create<\/em>, saya mendapatkan error berikut:<\/p>\n<pre>error:\r\nRROR 1101 (42000) at line 2: BLOB, TEXT, GEOMETRY or JSON column 'extra_hdrs' can't have a default value\r\nERROR: Failed to create presence tables!<\/pre>\n<p>Setelah baca sana sini, ada petunjuk bahwa\u00a0<em>sql-mode\u00a0<\/em>di server memiliki setting STRICT_TRANS_TABLE (ndak tau juga ini apa, mau browse kok malah nanti repotnya jadi distraksi ke mana mana). Yang kemudian saya lakukan adalah masuk ke console\u00a0<em>mysql<\/em> dan menjalankan perintah berikut:<\/p>\n<pre>mysql> use mysql;\r\nReading table information for completion of table and column names\r\nYou can turn off this feature to get a quicker startup with -A\r\n\r\nDatabase changed\r\nmysql> SET @@GLOBAL.sql_mode ='';\r\nQuery OK, 0 rows affected, 1 warning (0.00 sec)<\/pre>\n<p>Sebagai catatan saja, sebelum saya kosongkan isi dari GLOBAL.sql_mode adalah:<\/p>\n<pre>mysql> SELECT @@GLOBAL.sql_mode;\r\n+-------------------------------------------------------------------------------------------------------------------------------------------+\r\n| @@GLOBAL.sql_mode                                                                                                                         |\r\n+-------------------------------------------------------------------------------------------------------------------------------------------+\r\n| ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION |\r\n+-------------------------------------------------------------------------------------------------------------------------------------------+\r\n1 row in set (0.00 sec)<\/pre>\n<p>Dan setelah dikosongkan:<\/p>\n<pre>+-------------------+\r\n| @@GLOBAL.sql_mode |\r\n+-------------------+\r\n|                   |\r\n+-------------------+\r\n1 row in set (0.00 sec)\r\n<\/pre>\n<p>Berikutnya dicoba lagi menjalakan perintah\u00a0<em>opensipsdbctl create<\/em> :<\/p>\n<pre>root# opensipsdbctl create\r\nMySQL password for root:\r\nINFO: test server charset\r\nINFO: creating database opensips ...\r\nINFO: Using table engine InnoDB.\r\nINFO: Core OpenSIPS tables successfully created.\r\nInstall presence related tables? (y\/n): y\r\nINFO: creating presence tables into opensips ...\r\nINFO: Presence tables successfully created.\r\nInstall tables for imc cpl siptrace domainpolicy carrierroute userblacklist b2b cachedb_sql registrant call_center fraud_detection emergency? (y\/n): y\r\nINFO: creating extra tables into opensips ...\r\nINFO: Extra tables successfully created.<\/pre>\n<p>Done.<\/p>\n<h3>Link:<\/h3>\n<ul>\n<li><a href=\"http:\/\/lists.opensips.org\/pipermail\/users\/2016-November\/036028.html\">http:\/\/lists.opensips.org\/pipermail\/users\/2016-November\/036028.html<\/a><\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>Baru iseng-iseng nguprek OpenSIPS, pada saat create database dengan tool\u00a0opensipsdbctl create, saya mendapatkan error berikut: error: RROR 1101 (42000) at line 2: BLOB, TEXT, GEOMETRY or JSON column &#8216;extra_hdrs&#8217; can&#8217;t have a default value ERROR: Failed to create presence tables! Setelah baca sana sini, ada petunjuk bahwa\u00a0sql-mode\u00a0di server memiliki setting STRICT_TRANS_TABLE (ndak tau juga ini &hellip; <\/p>\n<p class=\"link-more\"><a href=\"https:\/\/www.otakudang.org\/?p=613\" class=\"more-link\">Continue reading<span class=\"screen-reader-text\"> &#8220;[TIPS] Error Create Database OpenSIPS Dengan &#8220;opensipsdbctl create&#8221;&#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":[4,2],"tags":[],"class_list":["post-613","post","type-post","status-publish","format-standard","hentry","category-mntubuntu","category-telephony","entry"],"_links":{"self":[{"href":"https:\/\/www.otakudang.org\/index.php?rest_route=\/wp\/v2\/posts\/613","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=613"}],"version-history":[{"count":7,"href":"https:\/\/www.otakudang.org\/index.php?rest_route=\/wp\/v2\/posts\/613\/revisions"}],"predecessor-version":[{"id":620,"href":"https:\/\/www.otakudang.org\/index.php?rest_route=\/wp\/v2\/posts\/613\/revisions\/620"}],"wp:attachment":[{"href":"https:\/\/www.otakudang.org\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=613"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.otakudang.org\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=613"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.otakudang.org\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=613"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}