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

2015-02-04 Thread Alfred Rudrapati
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 bog...@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 Developerhttp://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 
 listUsers@lists.opensips.orghttp://lists.opensips.org/cgi-bin/mailman/listinfo/users

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

2015-02-03 Thread Alfred Rudrapati
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@lists.opensips.org
http://lists.opensips.org/cgi-bin/mailman/listinfo/users