[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,
Chen-Che

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

(file)/etc/opensips/domain
id(int) domain(str) last_modified(str,null)
1:siptest.com::

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
0x7f14717155f8
DBG:core:db_allocate_rows: allocate 48 bytes for result rows and values at
0x7f1471715480
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