[tips] Error Pada Saat Create Database Untuk OpenSIPS

Pas lagi create database untuk OpenSIPS, saya mendapati error berikut:

# opensipsdbctl create
 MySQL password for root:
 INFO: test server charset
 INFO: creating database opensips ...
 INFO: Using table engine InnoDB.
 INFO: Core OpenSIPS tables successfully created.
 Install presence related tables? (y/n): y
 INFO: creating presence tables into opensips ...
 ERROR 1101 (42000) at line 2: BLOB, TEXT, GEOMETRY or JSON column 'extra_hdrs' can't have a default value
 ERROR: Failed to create presence tables!

Setelah baca sana sini ternyata ini berhubungan dengan setting MySQL yang terlalu strict. Untuk mengakali sementara, edit file my.cnf dan tambahkan baris berikut:

[mysqld]
 sql-mode = ""

kemudian restart layanan MySQL. Ulangi lagi proses penambahan database OpenSIPS, jika lancar akan seperti ini:

# opensipsdbctl create
 MySQL password for root:
 INFO: test server charset
 INFO: creating database opensips ...
 INFO: Using table engine InnoDB.
 INFO: Core OpenSIPS tables successfully created.
 Install presence related tables? (y/n): y
 INFO: creating presence tables into opensips ...
 INFO: Presence tables successfully created.
 Install tables for imc cpl siptrace domainpolicy carrierroute userblacklist b2b cachedb_sql registrant call_center fraud_detection emergency? (y/n): y
 INFO: creating extra tables into opensips ...
 INFO: Extra tables successfully created.

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes:

<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>