Hi Chen-Che,
Which OpenSIPS version are you using ? maybe you have an old one where
the domain module is not compatible with the db_text driver. In 1.11
definitely is.
Regards,
Bogdan-Andrei Iancu
OpenSIPS Founder and Developer
http://www.opensips-solutions.com
On 06.10.2014 10:44, microx wrote:
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.
_______________________________________________
Users mailing list
[email protected]
http://lists.opensips.org/cgi-bin/mailman/listinfo/users
_______________________________________________
Users mailing list
[email protected]
http://lists.opensips.org/cgi-bin/mailman/listinfo/users
