[OpenSIPS-Users] db_text for domain table

[Bogdan-Andrei Iancu]

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
> Users at lists.opensips.org
> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>