[OpenSIPS-Users] db_text for domain table

microx acmicrox at gmail.com
Mon Oct 6 09:44:09 CEST 2014

Dear all,

I use the db_text module for the dispatcher and domain tables. For the
dispatcher table, it works successfully. However, for the domain table, the
OpenSIP server always fails to read the domain table on startup. Please help
to take a look what listed below. Thanks for any comment.

Best wishes,

Related part of the OpenSIPS config
loadmodule "db_text.so"
loadmodule "domain.so"

modparam("db_text", "db_mode", 0)
modparam("domain", "db_url", "text:///etc/opensips")
modparam("domain", "domain_table", "domain")
modparam("domain", "db_mode", 1) # Use caching

id(int) domain(str) last_modified(str,null)

Log message
DBG:db_text:dbt_load_file: loading file [/etc/opensips/domain]
DBG:db_text:dbt_table_new: mtime is 1412576125
DBG:db_text:dbt_load_file: column[0] is INT!
DBG:db_text:dbt_load_file: column[1] is STR!
DBG:db_text:dbt_load_file: column[2] is STR!
DBG:db_text:dbt_query: new res with 1 cols
DBG:db_text:dbt_result_new: new res with 1 cols
DBG:core:db_new_result: allocate 48 bytes for result set at 0x7f14717152c8
DBG:core:db_allocate_columns: allocate 28 bytes for result columns at
DBG:core:db_allocate_rows: allocate 48 bytes for result rows and values at
DBG:domain:reload_domain_table: Number of rows in domain table: 1
*ERROR:domain:reload_domain_table: Database problem*

View this message in context: http://opensips-open-sip-server.1449251.n2.nabble.com/db-text-for-domain-table-tp7593779.html
Sent from the OpenSIPS - Users mailing list archive at Nabble.com.

More information about the Users mailing list