[OpenSIPS-Users] Errors on opensips 1.11.3 (Logging and db_text)

Bogdan-Andrei Iancu bogdan at opensips.org
Mon Feb 9 10:50:13 CET 2015


Hi Alfred,

Each table used by OpenSIPS has its own version. So, for each table, you 
need to have the corresponding record in the "version" table. The 
version table for dbtext comes pre-populated with all the tables.

Regards,

Bogdan-Andrei Iancu
OpenSIPS Founder and Developer
http://www.opensips-solutions.com

On 04.02.2015 20:45, Alfred Rudrapati wrote:
> Thanks Bogdan.
>
> You said initially that I need a version table too. How do I decide 
> the contents and the values in it?
>
> Is there a document/link for me to catch up?
>
> On Wed, Feb 4, 2015 at 10:30 AM, Alfred Rudrapati 
> <alfred5432 at gmail.com <mailto:alfred5432 at gmail.com>> wrote:
>
>     Hi Bogdan,
>
>     Thanks. That took care of it.
>
>     I have a few more questions:
>
>     1. Is there a way to change the delimiter from ":" (colon) to
>     something else? I am using the dispatcher dbtext and it would help
>     if the delimiter was not colon. Sip URIs have colons in them.
>     2. We are migrating from 1.7 opensips to 1.11.3. Is that the most
>     stable one to migrate too?
>     3. I have been able to get the servers up and running on 1.11.3.
>     Is this a production-grade opensips release?
>     4. Do you have any benchmarks/metrics that I can show to
>     management to justify the upgrade and the fact that it wont have
>     detrimental effects on our production environment.?
>     5. Is there a notls verion of the opensips rpm? I only see the tls
>     rpm for 1.11.3
>
>
>     On Tue, Feb 3, 2015 at 12:54 PM, Bogdan-Andrei Iancu
>     <bogdan at opensips.org <mailto:bogdan at opensips.org>> wrote:
>
>         Hi Alfred,
>
>         1) I suspect a configuration issue with your syslog daemon -
>         maybe the debug level is skipped for default log file.
>
>         2) in /tmp/opensipsdb you need to have the "version" table too.
>
>         Best regards,
>
>         Bogdan-Andrei Iancu
>         OpenSIPS Founder and Developer
>         http://www.opensips-solutions.com
>
>         On 03.02.2015 19:28, Alfred Rudrapati wrote:
>>
>>         I have 2 issues:
>>
>>         1.I have set my log to DEBUG but I don’t see then displayed.
>>         Notice that the below snipped shows INFOR and ERROR logs only.
>>
>>         debug=6
>>
>>         log_stderror=no
>>
>>         log_facility=LOG_LOCAL0
>>
>>         2.I am trying to use the dbtext module  and Here is the error
>>         I get:
>>
>>         Stopping opensips: not running [WARNING]
>>
>>         Starting opensips: [FAILED]
>>
>>         Feb  3 09:08:19 test_server opensips: INFO:core:shm_mem_init:
>>         allocating SHM block
>>
>>         Feb  3 09:08:19 test_server opensips: INFO:core:init_tcp:
>>         using epoll_lt as the TCP io watch method (auto detected)
>>
>>         Feb  3 09:08:19 test_server /usr/sbin/opensips[14637]:
>>         NOTICE:core:main: version: opensips 1.11.3-tls (x86_64/linux)
>>
>>         Feb  3 09:08:19 test_server /usr/sbin/opensips[14637]:
>>         INFO:core:main: using 32 Mb shared memory
>>
>>         Feb  3 09:08:19 test_server /usr/sbin/opensips[14637]:
>>         INFO:core:main: using 2 Mb private memory per process
>>
>>         Feb  3 09:08:19 test_server /usr/sbin/opensips[14637]:
>>         INFO:core:evi_publish_event: Registered event
>>         <E_CORE_THRESHOLD(0)>
>>
>>         Feb  3 09:08:19 test_server /usr/sbin/opensips[14637]:
>>         INFO:core:evi_publish_event: Registered event
>>         <E_CORE_SHM_THRESHOLD(1)>
>>
>>         Feb  3 09:08:19 test_server /usr/sbin/opensips[14637]:
>>         INFO:core:evi_publish_event: Registered event
>>         <E_CORE_PKG_THRESHOLD(2)>
>>
>>         Feb  3 09:08:19 test_server /usr/sbin/opensips[14637]:
>>         INFO:sl:mod_init: Initializing StateLess engine
>>
>>         Feb  3 09:08:19 test_server /usr/sbin/opensips[14637]:
>>         INFO:tm:mod_init: TM - initializing...
>>
>>         Feb  3 09:08:19 test_server /usr/sbin/opensips[14637]:
>>         NOTICE:signaling:mod_init: initializing module ...
>>
>>         Feb  3 09:08:19 test_server /usr/sbin/opensips[14637]:
>>         INFO:maxfwd:mod_init: initializing...
>>
>>         Feb  3 09:08:19 test_server /usr/sbin/opensips[14637]:
>>         INFO:textops:mod_init: initializing...
>>
>>         Feb  3 09:08:19 test_server /usr/sbin/opensips[14637]:
>>         INFO:sipmsgops:mod_init: initializing...
>>
>>         Feb  3 09:08:19 test_server /usr/sbin/opensips[14637]:
>>         INFO:db_text:dbt_init: using database at: /tmp/opensipsdb
>>
>>         Feb  3 09:08:19 test_server /usr/sbin/opensips[14637]:
>>         ERROR:db_text:dbt_query: table does not exist!
>>
>>         Feb  3 09:08:19 test_server /usr/sbin/opensips[14637]:
>>         ERROR:core:db_table_version: error in db_query
>>
>>         Feb  3 09:08:19 test_server /usr/sbin/opensips[14637]:
>>         ERROR:dispatcher:init_ds_db: failed to query table version
>>
>>         Feb  3 09:08:19 test_server /usr/sbin/opensips[14637]:
>>         ERROR:dispatcher:mod_init: failed to init database support
>>
>>         Feb  3 09:08:19 test_server /usr/sbin/opensips[14637]:
>>         ERROR:core:init_mod: failed to initialize module dispatcher
>>
>>         Feb  3 09:08:19 test_server /usr/sbin/opensips[14637]:
>>         ERROR:core:main: error while initializing modules
>>
>>         Feb  3 09:08:19 test_server /usr/sbin/opensips[14637]:
>>         INFO:core:cleanup: cleanup
>>
>>         Feb  3 09:08:19 test_server opensips: INFO:core:daemonize:
>>         pre-daemon process exiting with -1
>>
>>         Snipped from my opensips.cfg:
>>
>>         loadmodule "db_text.so"
>>
>>         modparam("db_text", "db_mode", 1)
>>
>>         modparam("dispatcher", "db_url", "text:///tmp/opensipsdb")
>>
>>         /tmp/opensipsdb has a chmod of 777:
>>
>>         drwxrwxrwx 2 root             root           4096 Feb  3
>>         09:07 opensipsdb
>>
>>         my test dispatcher file:
>>
>>         [root@ test_server tmp]# ls -ltr opensipsdb/dispatcher
>>
>>         -rw-r--r-- 1 root root 218 Feb  3 09:13 opensipsdb/dispatcher
>>
>>         [root@ test_server tmp]# cat opensipsdb/dispatcher
>>
>>         id(int,auto) setid(int) destination(string)
>>         socket(string,null) state(int) weight(int) attrs(string)
>>         description(string)
>>
>>         1:1:sip\:1.2.3.4\:5060:null:0:51:line1:server11
>>
>>         2:1:sip\:1.2.3.4\:5070:null:0:49:line2:server12
>>
>>         Any help/direction is appreciated.
>>
>>
>>
>>         _______________________________________________
>>         Users mailing list
>>         Users at lists.opensips.org  <mailto:Users at lists.opensips.org>
>>         http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>
>
>

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.opensips.org/pipermail/users/attachments/20150209/ec2656d9/attachment-0001.htm>


More information about the Users mailing list