Re: [OpenSIPS-Users] db_text for domain table
Hi Bogdan-Andrei, I tried to copy the domain and db_text modules from 1.11 to 1.9 and ran ``make deb''. Unfortunately, it failed to create the deb with the following error message. Do I need to copy all the modules from 1.11 to 1.9 rather than only the domain/db_text modules? If so, it seems that I should install OpenSIPS 1.11 instead of 1.9 for addressing this issue. Best wishes, Chen-Che make[3]: Entering directory `/home/test/opensips-1.9.2-tls/modules/domain' Compiling api.c Compiling domain.c Compiling domain_mod.c Compiling hash.c Compiling mi.c mi.c: In function ‘mi_domain_dump’: mi.c:67:26: error: ‘MI_IS_ARRAY’ undeclared (first use in this function) mi.c:67:26: note: each undeclared identifier is reported only once for each function it appears in make[3]: *** [mi.o] Error 1 -- View this message in context: http://opensips-open-sip-server.1449251.n2.nabble.com/db-text-for-domain-table-tp7593779p7593849.html Sent from the OpenSIPS - Users mailing list archive at Nabble.com. ___ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users
Re: [OpenSIPS-Users] db_text for domain table
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@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users ___ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users
Re: [OpenSIPS-Users] db_text for domain table
Hi Bogdan-Andrei, I use OpenSIPS 1.9.2. I hope the version is not too old for the domain table. Best wishes, Chen-Che -- View this message in context: http://opensips-open-sip-server.1449251.n2.nabble.com/db-text-for-domain-table-tp7593779p7593827.html Sent from the OpenSIPS - Users mailing list archive at Nabble.com. ___ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users
Re: [OpenSIPS-Users] db_text for domain table
Hello Chen-Che, 1.9 does not have that fix (to support db_text), neither 1.10 . Only 1.11 has it. That fix is combined with adding attr support for domains: https://github.com/OpenSIPS/opensips/commit/57ec0f399438b383b031535dc27a1e253ca78bec Of course, you can try and copy the whole module (+db schema) from 1.11 to 1.9. Regards, Bogdan-Andrei Iancu OpenSIPS Founder and Developer http://www.opensips-solutions.com On 07.10.2014 16:46, microx wrote: Hi Bogdan-Andrei, I use OpenSIPS 1.9.2. I hope the version is not too old for the domain table. Best wishes, Chen-Che -- View this message in context: http://opensips-open-sip-server.1449251.n2.nabble.com/db-text-for-domain-table-tp7593779p7593827.html Sent from the OpenSIPS - Users mailing list archive at Nabble.com. ___ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users ___ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users
[OpenSIPS-Users] db_text for domain table
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@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users