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

[Bogdan-Andrei Iancu]

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

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