Re: [OpenSIPS-Users] Errors on opensips 1.11.3 (Logging and db_text)
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 alfred5...@gmail.com mailto:alfred5...@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 bog...@opensips.org mailto: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 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
Re: [OpenSIPS-Users] Errors on opensips 1.11.3 (Logging and db_text)
Hi Alfred, 1) escape the colon when used in data (with \) 2) latest 1.11 is the stable one 3) yes, all stable releases are production ready. 4) no, there are no official numbers, but you should look also at new features or improvements. For each version you have a page listing the news: http://www.opensips.org/About/Version-1-11-0 http://www.opensips.org/About/Version-1-10-0 Regards, Bogdan-Andrei Iancu OpenSIPS Founder and Developer http://www.opensips-solutions.com On 04.02.2015 17:30, Alfred Rudrapati 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 bog...@opensips.org mailto: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 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:
Re: [OpenSIPS-Users] Errors on opensips 1.11.3 (Logging and db_text)
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)
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
Re: [OpenSIPS-Users] Errors on opensips 1.11.3 (Logging and db_text)
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@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] Errors in OpenSIPS
Hi, Most probably not. OpenSIPS usually does updates/inserts on this table. Only if OpenSIPS is configured to restore it's dialogs from DB in case of restart then you might want to make a test just to be sure it won't complain. Regards, Alex Ionescu On 11/15/2012 01:20 PM, Jorge Ortea wrote: Hello, can someone said me if really modify dialog table and allow callee_contract field to be NULL on DB could break anything?? Thanks. Regards. Date: Tue, 13 Nov 2012 14:48:51 +0100 From: shaherya...@googlemail.com To: users@lists.opensips.org Subject: Re: [OpenSIPS-Users] Errors in OpenSIPS Its db schema problem. The field dialog.callee_contact is set as NOT NULL, while you are getting NULL contact from upstream (most likely in BYE from callee side, as some old PSTN gateways running at many termination providers do not add Contact header in BYE request). Please check SIP trace and confirm or attach that here for our review. For a workaround you can modify dialog table and allow callee_contract field to be NULL. However i am not sure if this won't break anything else. Thank you. On Mon, Nov 12, 2012 at 1:52 PM, Jorge Ortea dar...@hotmail.com mailto:dar...@hotmail.com wrote: Hello, I keep getting these errors. My opensips version is 1.6.4-2-tls and my mysql version is 5.1.34 Would it be better to change the version of opensips? What can mean Column 'callee_contact' cannot be null ?? Thanks. Regards. From: dar...@hotmail.com mailto:dar...@hotmail.com To: users@lists.opensips.org mailto:users@lists.opensips.org Date: Fri, 9 Nov 2012 08:30:03 +0100 Subject: Re: [OpenSIPS-Users] Errors in OpenSIPS Hello Vlad, You are right, I had searched for ERROR, but before each Error message I got this: Nov 5 10:24:19 hgt-tero45 /usr/local/opensips/sbin/opensips[12562]: CRITICAL:db_mysql:wrapper_single_mysql_stmt_execute: driver error (1048): Column 'callee_contact' cannot be null Nov 5 10:24:19 hgt-tero45 /usr/local/opensips/sbin/opensips[12562]: ERROR:dialog:update_dialog_dbinfo: could not add another dialog to db Why could this be happening? Thanks. Regards. Date: Thu, 8 Nov 2012 19:21:45 +0200 From: vladp...@opensips.org mailto:vladp...@opensips.org To: users@lists.opensips.org mailto:users@lists.opensips.org Subject: Re: [OpenSIPS-Users] Errors in OpenSIPS Hello Jorge, Do you see any other errors from the DB level in the OpenSIPS logs ? What DB backend are you using ? It seems that for some reason, the dialog DB inserts are failing, but more ERROR messages should appear in such a case from the db_mysql module.. Regards, Vlad Paiu OpenSIPS Developer http://www.opensips-solutions.com On 11/08/2012 07:10 PM, Ali Pey wrote: I think it's telling you it can't add another dialog to db. I am almost certain that's what's happening. Regards, Ali Pey On Thu, Nov 8, 2012 at 4:22 AM, Jorge Ortea dar...@hotmail.com mailto:dar...@hotmail.com wrote: Hi all, I am getting the following errors: Nov 7 11:47:19 hgt-tero45 /usr/local/opensips/sbin/opensips[12582]: ERROR:dialog:update_dialog_dbinfo: could not add another dialog to db Nov 7 11:47:19 hgt-tero45 /usr/local/opensips/sbin/opensips[12548]: ERROR:dialog:update_dialog_dbinfo: could not add another dialog to db Nov 7 11:47:20 hgt-tero45 /usr/local/opensips/sbin/opensips[12558]: ERROR:dialog:update_dialog_dbinfo: could not add another dialog to db Nov 7 11:57:32 hgt-tero45 /usr/local/opensips/sbin/opensips[12554]: ERROR:dialog:update_dialog_dbinfo: could not add another dialog to db Nov 7 11:57:32 hgt-tero45 /usr/local/opensips/sbin/opensips[12578]: ERROR:dialog:update_dialog_dbinfo: could not add another dialog to db Nov 7 11:59:07 hgt-tero45 /usr/local/opensips/sbin/opensips[12556]: ERROR:dialog:update_dialog_dbinfo: could not add another dialog to db Nov 7 11:59:07 hgt-tero45 /usr/local/opensips/sbin/opensips[12574]: ERROR:dialog:update_dialog_dbinfo: could not add another dialog to db Nov 7 12:23:23 hgt-tero45 /usr/local/opensips/sbin/opensips[12580]: ERROR:dialog:update_dialog_dbinfo: could not add another dialog to db Nov 7 12:23:24 hgt-tero45 /usr/local/opensips/sbin
Re: [OpenSIPS-Users] Errors in OpenSIPS
Hello, can someone said me if really modify dialog table and allow callee_contract field to be NULL on DB could break anything?? Thanks. Regards. Date: Tue, 13 Nov 2012 14:48:51 +0100 From: shaherya...@googlemail.com To: users@lists.opensips.org Subject: Re: [OpenSIPS-Users] Errors in OpenSIPS Its db schema problem. The field dialog.callee_contact is set as NOT NULL, while you are getting NULL contact from upstream (most likely in BYE from callee side, as some old PSTN gateways running at many termination providers do not add Contact header in BYE request). Please check SIP trace and confirm or attach that here for our review. For a workaround you can modify dialog table and allow callee_contract field to be NULL. However i am not sure if this won't break anything else. Thank you. On Mon, Nov 12, 2012 at 1:52 PM, Jorge Ortea dar...@hotmail.com wrote: Hello, I keep getting these errors. My opensips version is 1.6.4-2-tls and my mysql version is 5.1.34 Would it be better to change the version of opensips? What can mean Column 'callee_contact' cannot be null ?? Thanks. Regards. From: dar...@hotmail.com To: users@lists.opensips.org Date: Fri, 9 Nov 2012 08:30:03 +0100 Subject: Re: [OpenSIPS-Users] Errors in OpenSIPS Hello Vlad, You are right, I had searched for ERROR, but before each Error message I got this: Nov 5 10:24:19 hgt-tero45 /usr/local/opensips/sbin/opensips[12562]: CRITICAL:db_mysql:wrapper_single_mysql_stmt_execute: driver error (1048): Column 'callee_contact' cannot be null Nov 5 10:24:19 hgt-tero45 /usr/local/opensips/sbin/opensips[12562]: ERROR:dialog:update_dialog_dbinfo: could not add another dialog to db Why could this be happening? Thanks. Regards. Date: Thu, 8 Nov 2012 19:21:45 +0200 From: vladp...@opensips.org To: users@lists.opensips.org Subject: Re: [OpenSIPS-Users] Errors in OpenSIPS Hello Jorge, Do you see any other errors from the DB level in the OpenSIPS logs ? What DB backend are you using ? It seems that for some reason, the dialog DB inserts are failing, but more ERROR messages should appear in such a case from the db_mysql module.. Regards, Vlad Paiu OpenSIPS Developer http://www.opensips-solutions.com On 11/08/2012 07:10 PM, Ali Pey wrote: I think it's telling you it can't add another dialog to db. I am almost certain that's what's happening. Regards, Ali Pey On Thu, Nov 8, 2012 at 4:22 AM, Jorge Ortea dar...@hotmail.com wrote: Hi all, I am getting the following errors: Nov 7 11:47:19 hgt-tero45 /usr/local/opensips/sbin/opensips[12582]: ERROR:dialog:update_dialog_dbinfo: could not add another dialog to db Nov 7 11:47:19 hgt-tero45 /usr/local/opensips/sbin/opensips[12548]: ERROR:dialog:update_dialog_dbinfo: could not add another dialog to db Nov 7 11:47:20 hgt-tero45 /usr/local/opensips/sbin/opensips[12558]: ERROR:dialog:update_dialog_dbinfo: could not add another dialog to db Nov 7 11:57:32 hgt-tero45 /usr/local/opensips/sbin/opensips[12554]: ERROR:dialog:update_dialog_dbinfo: could not add another dialog to db Nov 7 11:57:32 hgt-tero45 /usr/local/opensips/sbin/opensips[12578]: ERROR:dialog:update_dialog_dbinfo: could not add another dialog to db Nov 7 11:59:07 hgt-tero45 /usr/local/opensips/sbin/opensips[12556]: ERROR:dialog:update_dialog_dbinfo: could not add another dialog to db Nov 7 11:59:07 hgt-tero45 /usr/local/opensips/sbin/opensips[12574]: ERROR:dialog:update_dialog_dbinfo: could not add another dialog to db Nov 7 12:23:23 hgt-tero45 /usr/local/opensips/sbin/opensips[12580]: ERROR:dialog:update_dialog_dbinfo: could not add another dialog to db Nov 7 12:23:24 hgt-tero45 /usr/local/opensips/sbin/opensips[12544]: ERROR:dialog:update_dialog_dbinfo: could not add another dialog to db Nov 7 12:23:25 hgt-tero45 /usr/local/opensips/sbin/opensips[12572]: ERROR:dialog:update_dialog_dbinfo: could not add another dialog to db Nov 7 12:24:47 hgt-tero45 /usr/local/opensips/sbin/opensips[12558]: ERROR:dialog:update_dialog_dbinfo: could
Re: [OpenSIPS-Users] Errors in OpenSIPS
Its db schema problem. The field dialog.callee_contact is set as NOT NULL, while you are getting NULL contact from upstream (most likely in BYE from callee side, as some old PSTN gateways running at many termination providers do not add Contact header in BYE request). Please check SIP trace and confirm or attach that here for our review. For a workaround you can modify dialog table and allow callee_contract field to be NULL. However i am not sure if this won't break anything else. Thank you. On Mon, Nov 12, 2012 at 1:52 PM, Jorge Ortea dar...@hotmail.com wrote: Hello, I keep getting these errors. My opensips version is 1.6.4-2-tls and my mysql version is 5.1.34 Would it be better to change the version of opensips? What can mean Column 'callee_contact' cannot be null ?? Thanks. Regards. -- From: dar...@hotmail.com To: users@lists.opensips.org Date: Fri, 9 Nov 2012 08:30:03 +0100 Subject: Re: [OpenSIPS-Users] Errors in OpenSIPS Hello Vlad, You are right, I had searched for ERROR, but before each Error message I got this: Nov 5 10:24:19 hgt-tero45 /usr/local/opensips/sbin/opensips[12562]: CRITICAL:db_mysql:wrapper_single_mysql_stmt_execute: driver error (1048): Column 'callee_contact' cannot be null Nov 5 10:24:19 hgt-tero45 /usr/local/opensips/sbin/opensips[12562]: ERROR:dialog:update_dialog_dbinfo: could not add another dialog to db Why could this be happening? Thanks. Regards. -- Date: Thu, 8 Nov 2012 19:21:45 +0200 From: vladp...@opensips.org To: users@lists.opensips.org Subject: Re: [OpenSIPS-Users] Errors in OpenSIPS Hello Jorge, Do you see any other errors from the DB level in the OpenSIPS logs ? What DB backend are you using ? It seems that for some reason, the dialog DB inserts are failing, but more ERROR messages should appear in such a case from the db_mysql module.. Regards, Vlad Paiu OpenSIPS Developerhttp://www.opensips-solutions.com On 11/08/2012 07:10 PM, Ali Pey wrote: I think it's telling you it can't add another dialog to db. I am almost certain that's what's happening. Regards, Ali Pey On Thu, Nov 8, 2012 at 4:22 AM, Jorge Ortea dar...@hotmail.com wrote: Hi all, I am getting the following errors: Nov 7 11:47:19 hgt-tero45 /usr/local/opensips/sbin/opensips[12582]: ERROR:dialog:update_dialog_dbinfo: could not add another dialog to db Nov 7 11:47:19 hgt-tero45 /usr/local/opensips/sbin/opensips[12548]: ERROR:dialog:update_dialog_dbinfo: could not add another dialog to db Nov 7 11:47:20 hgt-tero45 /usr/local/opensips/sbin/opensips[12558]: ERROR:dialog:update_dialog_dbinfo: could not add another dialog to db Nov 7 11:57:32 hgt-tero45 /usr/local/opensips/sbin/opensips[12554]: ERROR:dialog:update_dialog_dbinfo: could not add another dialog to db Nov 7 11:57:32 hgt-tero45 /usr/local/opensips/sbin/opensips[12578]: ERROR:dialog:update_dialog_dbinfo: could not add another dialog to db Nov 7 11:59:07 hgt-tero45 /usr/local/opensips/sbin/opensips[12556]: ERROR:dialog:update_dialog_dbinfo: could not add another dialog to db Nov 7 11:59:07 hgt-tero45 /usr/local/opensips/sbin/opensips[12574]: ERROR:dialog:update_dialog_dbinfo: could not add another dialog to db Nov 7 12:23:23 hgt-tero45 /usr/local/opensips/sbin/opensips[12580]: ERROR:dialog:update_dialog_dbinfo: could not add another dialog to db Nov 7 12:23:24 hgt-tero45 /usr/local/opensips/sbin/opensips[12544]: ERROR:dialog:update_dialog_dbinfo: could not add another dialog to db Nov 7 12:23:25 hgt-tero45 /usr/local/opensips/sbin/opensips[12572]: ERROR:dialog:update_dialog_dbinfo: could not add another dialog to db Nov 7 12:24:47 hgt-tero45 /usr/local/opensips/sbin/opensips[12558]: ERROR:dialog:update_dialog_dbinfo: could not add another dialog to db Nov 7 12:24:47 hgt-tero45 /usr/local/opensips/sbin/opensips[12562]: ERROR:dialog:update_dialog_dbinfo: could not add another dialog to db Nov 7 12:26:45 hgt-tero45 /usr/local/opensips/sbin/opensips[12550]: ERROR:dialog:update_dialog_dbinfo: could not add another dialog to db Nov 7 12:26:45 hgt-tero45 /usr/local/opensips/sbin/opensips[12556]: ERROR:dialog:update_dialog_dbinfo: could not add another dialog to db Nov 7 12:26:46 hgt-tero45 /usr/local/opensips/sbin/opensips[12570]: ERROR:dialog:update_dialog_dbinfo: could not add another dialog to db Nov 7 12:28:20 hgt-tero45 /usr/local/opensips/sbin/opensips[12558]: ERROR:dialog:update_dialog_dbinfo: could not add another dialog to db Nov 7 12:28:20 hgt-tero45 /usr/local/opensips/sbin/opensips[12564]: ERROR:dialog:update_dialog_dbinfo: could not add another dialog to db Nov 7 12:28:21 hgt-tero45 /usr/local/opensips/sbin/opensips[12568]: ERROR:dialog:update_dialog_dbinfo: could not add another dialog to db Nov 7 12:30:23 hgt-tero45 /usr/local/opensips/sbin/opensips[12550]: ERROR:dialog:update_dialog_dbinfo: could not add another dialog to db Nov 7 12:30:23 hgt
[OpenSIPS-Users] Errors in OpenSIPS
Hi all, I am getting the following errors: Nov 7 11:47:19 hgt-tero45 /usr/local/opensips/sbin/opensips[12582]: ERROR:dialog:update_dialog_dbinfo: could not add another dialog to db Nov 7 11:47:19 hgt-tero45 /usr/local/opensips/sbin/opensips[12548]: ERROR:dialog:update_dialog_dbinfo: could not add another dialog to db Nov 7 11:47:20 hgt-tero45 /usr/local/opensips/sbin/opensips[12558]: ERROR:dialog:update_dialog_dbinfo: could not add another dialog to db Nov 7 11:57:32 hgt-tero45 /usr/local/opensips/sbin/opensips[12554]: ERROR:dialog:update_dialog_dbinfo: could not add another dialog to db Nov 7 11:57:32 hgt-tero45 /usr/local/opensips/sbin/opensips[12578]: ERROR:dialog:update_dialog_dbinfo: could not add another dialog to db Nov 7 11:59:07 hgt-tero45 /usr/local/opensips/sbin/opensips[12556]: ERROR:dialog:update_dialog_dbinfo: could not add another dialog to db Nov 7 11:59:07 hgt-tero45 /usr/local/opensips/sbin/opensips[12574]: ERROR:dialog:update_dialog_dbinfo: could not add another dialog to db Nov 7 12:23:23 hgt-tero45 /usr/local/opensips/sbin/opensips[12580]: ERROR:dialog:update_dialog_dbinfo: could not add another dialog to db Nov 7 12:23:24 hgt-tero45 /usr/local/opensips/sbin/opensips[12544]: ERROR:dialog:update_dialog_dbinfo: could not add another dialog to db Nov 7 12:23:25 hgt-tero45 /usr/local/opensips/sbin/opensips[12572]: ERROR:dialog:update_dialog_dbinfo: could not add another dialog to db Nov 7 12:24:47 hgt-tero45 /usr/local/opensips/sbin/opensips[12558]: ERROR:dialog:update_dialog_dbinfo: could not add another dialog to db Nov 7 12:24:47 hgt-tero45 /usr/local/opensips/sbin/opensips[12562]: ERROR:dialog:update_dialog_dbinfo: could not add another dialog to db Nov 7 12:26:45 hgt-tero45 /usr/local/opensips/sbin/opensips[12550]: ERROR:dialog:update_dialog_dbinfo: could not add another dialog to db Nov 7 12:26:45 hgt-tero45 /usr/local/opensips/sbin/opensips[12556]: ERROR:dialog:update_dialog_dbinfo: could not add another dialog to db Nov 7 12:26:46 hgt-tero45 /usr/local/opensips/sbin/opensips[12570]: ERROR:dialog:update_dialog_dbinfo: could not add another dialog to db Nov 7 12:28:20 hgt-tero45 /usr/local/opensips/sbin/opensips[12558]: ERROR:dialog:update_dialog_dbinfo: could not add another dialog to db Nov 7 12:28:20 hgt-tero45 /usr/local/opensips/sbin/opensips[12564]: ERROR:dialog:update_dialog_dbinfo: could not add another dialog to db Nov 7 12:28:21 hgt-tero45 /usr/local/opensips/sbin/opensips[12568]: ERROR:dialog:update_dialog_dbinfo: could not add another dialog to db Nov 7 12:30:23 hgt-tero45 /usr/local/opensips/sbin/opensips[12550]: ERROR:dialog:update_dialog_dbinfo: could not add another dialog to db Nov 7 12:30:23 hgt-tero45 /usr/local/opensips/sbin/opensips[12572]: ERROR:dialog:update_dialog_dbinfo: could not add another dialog to db Nov 7 12:30:25 hgt-tero45 /usr/local/opensips/sbin/opensips[12576]: ERROR:dialog:update_dialog_dbinfo: could not add another dialog to db Nov 7 13:12:13 hgt-tero45 /usr/local/opensips/sbin/opensips[12548]: ERROR:dialog:update_dialog_dbinfo: could not add another dialog to db Nov 7 13:12:13 hgt-tero45 /usr/local/opensips/sbin/opensips[12546]: ERROR:dialog:update_dialog_dbinfo: could not add another dialog to db Nov 7 13:12:13 hgt-tero45 /usr/local/opensips/sbin/opensips[12576]: ERROR:dialog:update_dialog_dbinfo: could not add another dialog to db Nov 7 13:23:34 hgt-tero45 /usr/local/opensips/sbin/opensips[12582]: ERROR:dialog:update_dialog_dbinfo: could not add another dialog to db Nov 7 13:23:34 hgt-tero45 /usr/local/opensips/sbin/opensips[12566]: ERROR:dialog:update_dialog_dbinfo: could not add another dialog to db Nov 7 13:23:34 hgt-tero45 /usr/local/opensips/sbin/opensips[12580]: ERROR:dialog:update_dialog_dbinfo: could not add another dialog to db Nov 7 13:33:09 hgt-tero45 /usr/local/opensips/sbin/opensips[12572]: ERROR:dialog:update_dialog_dbinfo: could not add another dialog to db Nov 7 13:33:09 hgt-tero45 /usr/local/opensips/sbin/opensips[12578]: ERROR:dialog:update_dialog_dbinfo: could not add another dialog to db Nov 7 13:33:09 hgt-tero45 /usr/local/opensips/sbin/opensips[12574]: ERROR:dialog:update_dialog_dbinfo: could not add another dialog to db Nov 7 14:10:19 hgt-tero45 /usr/local/opensips/sbin/opensips[12556]: ERROR:dialog:update_dialog_dbinfo: could not add another dialog to db Nov 7 14:10:19 hgt-tero45 /usr/local/opensips/sbin/opensips[12564]: ERROR:dialog:update_dialog_dbinfo: could not add another dialog to db Nov 7 14:10:21 hgt-tero45 /usr/local/opensips/sbin/opensips[12558]: ERROR:dialog:update_dialog_dbinfo: could not add another dialog to db Nov 7 17:58:43 hgt-tero45 /usr/local/opensips/sbin/opensips[12572]: ERROR:dialog:update_dialog_dbinfo: could not add another dialog to db Nov 7 17:58:43 hgt-tero45 /usr/local/opensips/sbin/opensips[12548]: ERROR:dialog:update_dialog_dbinfo: could not add another dialog to db Nov 7 17:58:44
Re: [OpenSIPS-Users] Errors in OpenSIPS
I think it's telling you it can't add another dialog to db. I am almost certain that's what's happening. Regards, Ali Pey On Thu, Nov 8, 2012 at 4:22 AM, Jorge Ortea dar...@hotmail.com wrote: Hi all, I am getting the following errors: Nov 7 11:47:19 hgt-tero45 /usr/local/opensips/sbin/opensips[12582]: ERROR:dialog:update_dialog_dbinfo: could not add another dialog to db Nov 7 11:47:19 hgt-tero45 /usr/local/opensips/sbin/opensips[12548]: ERROR:dialog:update_dialog_dbinfo: could not add another dialog to db Nov 7 11:47:20 hgt-tero45 /usr/local/opensips/sbin/opensips[12558]: ERROR:dialog:update_dialog_dbinfo: could not add another dialog to db Nov 7 11:57:32 hgt-tero45 /usr/local/opensips/sbin/opensips[12554]: ERROR:dialog:update_dialog_dbinfo: could not add another dialog to db Nov 7 11:57:32 hgt-tero45 /usr/local/opensips/sbin/opensips[12578]: ERROR:dialog:update_dialog_dbinfo: could not add another dialog to db Nov 7 11:59:07 hgt-tero45 /usr/local/opensips/sbin/opensips[12556]: ERROR:dialog:update_dialog_dbinfo: could not add another dialog to db Nov 7 11:59:07 hgt-tero45 /usr/local/opensips/sbin/opensips[12574]: ERROR:dialog:update_dialog_dbinfo: could not add another dialog to db Nov 7 12:23:23 hgt-tero45 /usr/local/opensips/sbin/opensips[12580]: ERROR:dialog:update_dialog_dbinfo: could not add another dialog to db Nov 7 12:23:24 hgt-tero45 /usr/local/opensips/sbin/opensips[12544]: ERROR:dialog:update_dialog_dbinfo: could not add another dialog to db Nov 7 12:23:25 hgt-tero45 /usr/local/opensips/sbin/opensips[12572]: ERROR:dialog:update_dialog_dbinfo: could not add another dialog to db Nov 7 12:24:47 hgt-tero45 /usr/local/opensips/sbin/opensips[12558]: ERROR:dialog:update_dialog_dbinfo: could not add another dialog to db Nov 7 12:24:47 hgt-tero45 /usr/local/opensips/sbin/opensips[12562]: ERROR:dialog:update_dialog_dbinfo: could not add another dialog to db Nov 7 12:26:45 hgt-tero45 /usr/local/opensips/sbin/opensips[12550]: ERROR:dialog:update_dialog_dbinfo: could not add another dialog to db Nov 7 12:26:45 hgt-tero45 /usr/local/opensips/sbin/opensips[12556]: ERROR:dialog:update_dialog_dbinfo: could not add another dialog to db Nov 7 12:26:46 hgt-tero45 /usr/local/opensips/sbin/opensips[12570]: ERROR:dialog:update_dialog_dbinfo: could not add another dialog to db Nov 7 12:28:20 hgt-tero45 /usr/local/opensips/sbin/opensips[12558]: ERROR:dialog:update_dialog_dbinfo: could not add another dialog to db Nov 7 12:28:20 hgt-tero45 /usr/local/opensips/sbin/opensips[12564]: ERROR:dialog:update_dialog_dbinfo: could not add another dialog to db Nov 7 12:28:21 hgt-tero45 /usr/local/opensips/sbin/opensips[12568]: ERROR:dialog:update_dialog_dbinfo: could not add another dialog to db Nov 7 12:30:23 hgt-tero45 /usr/local/opensips/sbin/opensips[12550]: ERROR:dialog:update_dialog_dbinfo: could not add another dialog to db Nov 7 12:30:23 hgt-tero45 /usr/local/opensips/sbin/opensips[12572]: ERROR:dialog:update_dialog_dbinfo: could not add another dialog to db Nov 7 12:30:25 hgt-tero45 /usr/local/opensips/sbin/opensips[12576]: ERROR:dialog:update_dialog_dbinfo: could not add another dialog to db Nov 7 13:12:13 hgt-tero45 /usr/local/opensips/sbin/opensips[12548]: ERROR:dialog:update_dialog_dbinfo: could not add another dialog to db Nov 7 13:12:13 hgt-tero45 /usr/local/opensips/sbin/opensips[12546]: ERROR:dialog:update_dialog_dbinfo: could not add another dialog to db Nov 7 13:12:13 hgt-tero45 /usr/local/opensips/sbin/opensips[12576]: ERROR:dialog:update_dialog_dbinfo: could not add another dialog to db Nov 7 13:23:34 hgt-tero45 /usr/local/opensips/sbin/opensips[12582]: ERROR:dialog:update_dialog_dbinfo: could not add another dialog to db Nov 7 13:23:34 hgt-tero45 /usr/local/opensips/sbin/opensips[12566]: ERROR:dialog:update_dialog_dbinfo: could not add another dialog to db Nov 7 13:23:34 hgt-tero45 /usr/local/opensips/sbin/opensips[12580]: ERROR:dialog:update_dialog_dbinfo: could not add another dialog to db Nov 7 13:33:09 hgt-tero45 /usr/local/opensips/sbin/opensips[12572]: ERROR:dialog:update_dialog_dbinfo: could not add another dialog to db Nov 7 13:33:09 hgt-tero45 /usr/local/opensips/sbin/opensips[12578]: ERROR:dialog:update_dialog_dbinfo: could not add another dialog to db Nov 7 13:33:09 hgt-tero45 /usr/local/opensips/sbin/opensips[12574]: ERROR:dialog:update_dialog_dbinfo: could not add another dialog to db Nov 7 14:10:19 hgt-tero45 /usr/local/opensips/sbin/opensips[12556]: ERROR:dialog:update_dialog_dbinfo: could not add another dialog to db Nov 7 14:10:19 hgt-tero45 /usr/local/opensips/sbin/opensips[12564]: ERROR:dialog:update_dialog_dbinfo: could not add another dialog to db Nov 7 14:10:21 hgt-tero45 /usr/local/opensips/sbin/opensips[12558]: ERROR:dialog:update_dialog_dbinfo: could not add another dialog to db Nov 7 17:58:43 hgt-tero45 /usr/local/opensips/sbin/opensips[12572]:
Re: [OpenSIPS-Users] Errors in OpenSIPS
Hello Jorge, Do you see any other errors from the DB level in the OpenSIPS logs ? What DB backend are you using ? It seems that for some reason, the dialog DB inserts are failing, but more ERROR messages should appear in such a case from the db_mysql module.. Regards, Vlad Paiu OpenSIPS Developer http://www.opensips-solutions.com On 11/08/2012 07:10 PM, Ali Pey wrote: I think it's telling you it can't add another dialog to db. I am almost certain that's what's happening. Regards, Ali Pey On Thu, Nov 8, 2012 at 4:22 AM, Jorge Ortea dar...@hotmail.com mailto:dar...@hotmail.com wrote: Hi all, I am getting the following errors: Nov 7 11:47:19 hgt-tero45 /usr/local/opensips/sbin/opensips[12582]: ERROR:dialog:update_dialog_dbinfo: could not add another dialog to db Nov 7 11:47:19 hgt-tero45 /usr/local/opensips/sbin/opensips[12548]: ERROR:dialog:update_dialog_dbinfo: could not add another dialog to db Nov 7 11:47:20 hgt-tero45 /usr/local/opensips/sbin/opensips[12558]: ERROR:dialog:update_dialog_dbinfo: could not add another dialog to db Nov 7 11:57:32 hgt-tero45 /usr/local/opensips/sbin/opensips[12554]: ERROR:dialog:update_dialog_dbinfo: could not add another dialog to db Nov 7 11:57:32 hgt-tero45 /usr/local/opensips/sbin/opensips[12578]: ERROR:dialog:update_dialog_dbinfo: could not add another dialog to db Nov 7 11:59:07 hgt-tero45 /usr/local/opensips/sbin/opensips[12556]: ERROR:dialog:update_dialog_dbinfo: could not add another dialog to db Nov 7 11:59:07 hgt-tero45 /usr/local/opensips/sbin/opensips[12574]: ERROR:dialog:update_dialog_dbinfo: could not add another dialog to db Nov 7 12:23:23 hgt-tero45 /usr/local/opensips/sbin/opensips[12580]: ERROR:dialog:update_dialog_dbinfo: could not add another dialog to db Nov 7 12:23:24 hgt-tero45 /usr/local/opensips/sbin/opensips[12544]: ERROR:dialog:update_dialog_dbinfo: could not add another dialog to db Nov 7 12:23:25 hgt-tero45 /usr/local/opensips/sbin/opensips[12572]: ERROR:dialog:update_dialog_dbinfo: could not add another dialog to db Nov 7 12:24:47 hgt-tero45 /usr/local/opensips/sbin/opensips[12558]: ERROR:dialog:update_dialog_dbinfo: could not add another dialog to db Nov 7 12:24:47 hgt-tero45 /usr/local/opensips/sbin/opensips[12562]: ERROR:dialog:update_dialog_dbinfo: could not add another dialog to db Nov 7 12:26:45 hgt-tero45 /usr/local/opensips/sbin/opensips[12550]: ERROR:dialog:update_dialog_dbinfo: could not add another dialog to db Nov 7 12:26:45 hgt-tero45 /usr/local/opensips/sbin/opensips[12556]: ERROR:dialog:update_dialog_dbinfo: could not add another dialog to db Nov 7 12:26:46 hgt-tero45 /usr/local/opensips/sbin/opensips[12570]: ERROR:dialog:update_dialog_dbinfo: could not add another dialog to db Nov 7 12:28:20 hgt-tero45 /usr/local/opensips/sbin/opensips[12558]: ERROR:dialog:update_dialog_dbinfo: could not add another dialog to db Nov 7 12:28:20 hgt-tero45 /usr/local/opensips/sbin/opensips[12564]: ERROR:dialog:update_dialog_dbinfo: could not add another dialog to db Nov 7 12:28:21 hgt-tero45 /usr/local/opensips/sbin/opensips[12568]: ERROR:dialog:update_dialog_dbinfo: could not add another dialog to db Nov 7 12:30:23 hgt-tero45 /usr/local/opensips/sbin/opensips[12550]: ERROR:dialog:update_dialog_dbinfo: could not add another dialog to db Nov 7 12:30:23 hgt-tero45 /usr/local/opensips/sbin/opensips[12572]: ERROR:dialog:update_dialog_dbinfo: could not add another dialog to db Nov 7 12:30:25 hgt-tero45 /usr/local/opensips/sbin/opensips[12576]: ERROR:dialog:update_dialog_dbinfo: could not add another dialog to db Nov 7 13:12:13 hgt-tero45 /usr/local/opensips/sbin/opensips[12548]: ERROR:dialog:update_dialog_dbinfo: could not add another dialog to db Nov 7 13:12:13 hgt-tero45 /usr/local/opensips/sbin/opensips[12546]: ERROR:dialog:update_dialog_dbinfo: could not add another dialog to db Nov 7 13:12:13 hgt-tero45 /usr/local/opensips/sbin/opensips[12576]: ERROR:dialog:update_dialog_dbinfo: could not add another dialog to db Nov 7 13:23:34 hgt-tero45 /usr/local/opensips/sbin/opensips[12582]: ERROR:dialog:update_dialog_dbinfo: could not add another dialog to db Nov 7 13:23:34 hgt-tero45 /usr/local/opensips/sbin/opensips[12566]: ERROR:dialog:update_dialog_dbinfo: could not add another dialog to db Nov 7 13:23:34 hgt-tero45 /usr/local/opensips/sbin/opensips[12580]: ERROR:dialog:update_dialog_dbinfo: could not add another dialog to db Nov 7 13:33:09 hgt-tero45 /usr/local/opensips/sbin/opensips[12572]: ERROR:dialog:update_dialog_dbinfo: could not add another dialog to db Nov 7 13:33:09 hgt-tero45 /usr/local/opensips/sbin/opensips[12578]:
Re: [OpenSIPS-Users] Errors in OpenSIPS
Hello Vlad, You are right, I had searched for ERROR, but before each Error message I got this: Nov 5 10:24:19 hgt-tero45 /usr/local/opensips/sbin/opensips[12562]: CRITICAL:db_mysql:wrapper_single_mysql_stmt_execute: driver error (1048): Column 'callee_contact' cannot be null Nov 5 10:24:19 hgt-tero45 /usr/local/opensips/sbin/opensips[12562]: ERROR:dialog:update_dialog_dbinfo: could not add another dialog to db Why could this be happening? Thanks. Regards. Date: Thu, 8 Nov 2012 19:21:45 +0200 From: vladp...@opensips.org To: users@lists.opensips.org Subject: Re: [OpenSIPS-Users] Errors in OpenSIPS Hello Jorge, Do you see any other errors from the DB level in the OpenSIPS logs ? What DB backend are you using ? It seems that for some reason, the dialog DB inserts are failing, but more ERROR messages should appear in such a case from the db_mysql module.. Regards, Vlad Paiu OpenSIPS Developer http://www.opensips-solutions.com On 11/08/2012 07:10 PM, Ali Pey wrote: I think it's telling you it can't add another dialog to db. I am almost certain that's what's happening. Regards, Ali Pey On Thu, Nov 8, 2012 at 4:22 AM, Jorge Ortea dar...@hotmail.com wrote: Hi all, I am getting the following errors: Nov 7 11:47:19 hgt-tero45 /usr/local/opensips/sbin/opensips[12582]: ERROR:dialog:update_dialog_dbinfo: could not add another dialog to db Nov 7 11:47:19 hgt-tero45 /usr/local/opensips/sbin/opensips[12548]: ERROR:dialog:update_dialog_dbinfo: could not add another dialog to db Nov 7 11:47:20 hgt-tero45 /usr/local/opensips/sbin/opensips[12558]: ERROR:dialog:update_dialog_dbinfo: could not add another dialog to db Nov 7 11:57:32 hgt-tero45 /usr/local/opensips/sbin/opensips[12554]: ERROR:dialog:update_dialog_dbinfo: could not add another dialog to db Nov 7 11:57:32 hgt-tero45 /usr/local/opensips/sbin/opensips[12578]: ERROR:dialog:update_dialog_dbinfo: could not add another dialog to db Nov 7 11:59:07 hgt-tero45 /usr/local/opensips/sbin/opensips[12556]: ERROR:dialog:update_dialog_dbinfo: could not add another dialog to db Nov 7 11:59:07 hgt-tero45 /usr/local/opensips/sbin/opensips[12574]: ERROR:dialog:update_dialog_dbinfo: could not add another dialog to db Nov 7 12:23:23 hgt-tero45 /usr/local/opensips/sbin/opensips[12580]: ERROR:dialog:update_dialog_dbinfo: could not add another dialog to db Nov 7 12:23:24 hgt-tero45 /usr/local/opensips/sbin/opensips[12544]: ERROR:dialog:update_dialog_dbinfo: could not add another dialog to db Nov 7 12:23:25 hgt-tero45 /usr/local/opensips/sbin/opensips[12572]: ERROR:dialog:update_dialog_dbinfo: could not add another dialog to db Nov 7 12:24:47 hgt-tero45 /usr/local/opensips/sbin/opensips[12558]: ERROR:dialog:update_dialog_dbinfo: could not add another dialog to db Nov 7 12:24:47 hgt-tero45 /usr/local/opensips/sbin/opensips[12562]: ERROR:dialog:update_dialog_dbinfo: could not add another dialog to db Nov 7 12:26:45 hgt-tero45 /usr/local/opensips/sbin/opensips[12550]: ERROR:dialog:update_dialog_dbinfo: could not add another dialog to db Nov 7 12:26:45 hgt-tero45 /usr/local/opensips/sbin/opensips[12556]: ERROR:dialog:update_dialog_dbinfo: could not add another dialog to db Nov 7 12:26:46 hgt-tero45 /usr/local/opensips/sbin/opensips[12570]: ERROR:dialog:update_dialog_dbinfo: could not add another dialog to db Nov 7 12:28:20 hgt-tero45 /usr/local/opensips/sbin/opensips[12558]: ERROR:dialog:update_dialog_dbinfo: could not add another dialog to db Nov 7 12:28:20 hgt-tero45 /usr/local/opensips/sbin/opensips[12564]: ERROR:dialog:update_dialog_dbinfo: could not add another dialog
[OpenSIPS-Users] Errors at opensips startup
I am getting the following errors at opensips startup: May 25 19:41:40 c1opsip1 opensips[5417]: INFO:core:sig_usr: signal 15 received May 25 19:41:40 c1opsip1 opensips[5411]: INFO:core:sig_usr: signal 15 received May 25 19:41:40 c1opsip1 opensips[5409]: INFO:core:sig_usr: signal 15 received May 25 19:41:40 c1opsip1 opensips[5407]: INFO:core:sig_usr: signal 15 received May 25 19:41:40 c1opsip1 opensips[5394]: INFO:core:sig_usr: signal 15 received May 25 19:41:40 c1opsip1 opensips[5406]: INFO:core:sig_usr: signal 15 received May 25 19:41:40 c1opsip1 opensips[5402]: INFO:core:sig_usr: signal 15 received May 25 19:41:40 c1opsip1 opensips[5397]: INFO:core:sig_usr: signal 15 received May 25 19:41:40 c1opsip1 opensips[5403]: INFO:core:sig_usr: signal 15 received May 25 19:41:45 c1opsip1 opensips: INFO:core:init_tcp: using epoll_lt as the TCP io watch method (auto detected) May 25 19:41:45 c1opsip1 opensips[5479]: NOTICE:core:main: version: opensips 1.6.2-notls (i386/linux) May 25 19:41:45 c1opsip1 opensips[5479]: INFO:core:main: using 32 Mb shared memory May 25 19:41:45 c1opsip1 opensips[5479]: INFO:core:main: using 1 Mb private memory per process May 25 19:41:45 c1opsip1 opensips[5479]: NOTICE:signaling:mod_init: initializing module ... May 25 19:41:45 c1opsip1 opensips[5479]: INFO:sl:mod_init: Initializing StateLess engine May 25 19:41:45 c1opsip1 opensips[5479]: INFO:tm:mod_init: TM - initializing... May 25 19:41:45 c1opsip1 opensips[5479]: INFO:maxfwd:mod_init: initializing... May 25 19:41:45 c1opsip1 opensips[5479]: INFO:usrloc:ul_init_locks: locks array size 512 May 25 19:41:45 c1opsip1 opensips[5479]: INFO:registrar:mod_init: initializing... May 25 19:41:45 c1opsip1 opensips[5479]: INFO:textops:mod_init: initializing... May 25 19:41:45 c1opsip1 opensips[5479]: INFO:xlog:mod_init: initializing... May 25 19:41:45 c1opsip1 opensips[5479]: INFO:acc:mod_init: initializing... May 25 19:41:45 c1opsip1 opensips[5479]: INFO:auth:mod_init: initializing... May 25 19:41:45 c1opsip1 opensips[5479]: INFO:auth_db:mod_init: initializing... May 25 19:41:45 c1opsip1 opensips[5479]: INFO:dialog:mod_init: Dialog module - initializing May 25 19:41:45 c1opsip1 opensips[5479]: INFO:load_balancer:mod_init: Load-Balancer module - initializing May 25 19:41:45 c1opsip1 opensips[5479]: INFO:core:probe_max_receive_buffer: using a UDP receive buffer of 255 kb May 25 19:41:45 c1opsip1 last message repeated 2 times May 25 19:41:48 c1opsip1 opensips[5494]: INFO:core:parse_first_line: empty or bad first line May 25 19:41:48 c1opsip1 opensips[5497]: INFO:core:parse_first_line: method not followed by SP May 25 19:41:48 c1opsip1 opensips[5494]: INFO:core:parse_first_line: bad message May 25 19:41:48 c1opsip1 opensips[5497]: INFO:core:parse_first_line: bad message May 25 19:41:48 c1opsip1 opensips[5494]: ERROR:core:parse_msg: message= May 25 19:41:48 c1opsip1 opensips[5497]: ERROR:core:parse_msg: message= May 25 19:41:48 c1opsip1 opensips[5494]: ERROR:core:receive_msg: parse_msg failed May 25 19:41:48 c1opsip1 opensips[5497]: ERROR:core:receive_msg: parse_msg failed May 25 19:41:48 c1opsip1 opensips[5494]: INFO:core:parse_first_line: empty or bad first line May 25 19:41:48 c1opsip1 opensips[5494]: INFO:core:parse_first_line: bad message May 25 19:41:48 c1opsip1 opensips[5494]: ERROR:core:parse_msg: message= May 25 19:41:48 c1opsip1 opensips[5494]: ERROR:core:receive_msg: parse_msg failed May 25 19:41:48 c1opsip1 opensips[5492]: INFO:core:parse_first_line: method not followed by SP May 25 19:41:48 c1opsip1 opensips[5492]: INFO:core:parse_first_line: bad message May 25 19:41:48 c1opsip1 opensips[5492]: ERROR:core:parse_msg: message= May 25 19:41:48 c1opsip1 opensips[5492]: ERROR:core:receive_msg: parse_msg failed Can somebody help me with this? What do they mean? Are they serious? Regards, Alex ___ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users
Re: [OpenSIPS-Users] Errors at opensips startup
Solved, sorry for the bother. It's related to errors in the comunication between syslog and opensips because of a faulty configuration. Thanks anyways! Alex On Wed, May 25, 2011 at 7:43 PM, Alejandro Recarey alexreca...@gmail.com wrote: I am getting the following errors at opensips startup: May 25 19:41:40 c1opsip1 opensips[5417]: INFO:core:sig_usr: signal 15 received May 25 19:41:40 c1opsip1 opensips[5411]: INFO:core:sig_usr: signal 15 received May 25 19:41:40 c1opsip1 opensips[5409]: INFO:core:sig_usr: signal 15 received May 25 19:41:40 c1opsip1 opensips[5407]: INFO:core:sig_usr: signal 15 received May 25 19:41:40 c1opsip1 opensips[5394]: INFO:core:sig_usr: signal 15 received May 25 19:41:40 c1opsip1 opensips[5406]: INFO:core:sig_usr: signal 15 received May 25 19:41:40 c1opsip1 opensips[5402]: INFO:core:sig_usr: signal 15 received May 25 19:41:40 c1opsip1 opensips[5397]: INFO:core:sig_usr: signal 15 received May 25 19:41:40 c1opsip1 opensips[5403]: INFO:core:sig_usr: signal 15 received May 25 19:41:45 c1opsip1 opensips: INFO:core:init_tcp: using epoll_lt as the TCP io watch method (auto detected) May 25 19:41:45 c1opsip1 opensips[5479]: NOTICE:core:main: version: opensips 1.6.2-notls (i386/linux) May 25 19:41:45 c1opsip1 opensips[5479]: INFO:core:main: using 32 Mb shared memory May 25 19:41:45 c1opsip1 opensips[5479]: INFO:core:main: using 1 Mb private memory per process May 25 19:41:45 c1opsip1 opensips[5479]: NOTICE:signaling:mod_init: initializing module ... May 25 19:41:45 c1opsip1 opensips[5479]: INFO:sl:mod_init: Initializing StateLess engine May 25 19:41:45 c1opsip1 opensips[5479]: INFO:tm:mod_init: TM - initializing... May 25 19:41:45 c1opsip1 opensips[5479]: INFO:maxfwd:mod_init: initializing... May 25 19:41:45 c1opsip1 opensips[5479]: INFO:usrloc:ul_init_locks: locks array size 512 May 25 19:41:45 c1opsip1 opensips[5479]: INFO:registrar:mod_init: initializing... May 25 19:41:45 c1opsip1 opensips[5479]: INFO:textops:mod_init: initializing... May 25 19:41:45 c1opsip1 opensips[5479]: INFO:xlog:mod_init: initializing... May 25 19:41:45 c1opsip1 opensips[5479]: INFO:acc:mod_init: initializing... May 25 19:41:45 c1opsip1 opensips[5479]: INFO:auth:mod_init: initializing... May 25 19:41:45 c1opsip1 opensips[5479]: INFO:auth_db:mod_init: initializing... May 25 19:41:45 c1opsip1 opensips[5479]: INFO:dialog:mod_init: Dialog module - initializing May 25 19:41:45 c1opsip1 opensips[5479]: INFO:load_balancer:mod_init: Load-Balancer module - initializing May 25 19:41:45 c1opsip1 opensips[5479]: INFO:core:probe_max_receive_buffer: using a UDP receive buffer of 255 kb May 25 19:41:45 c1opsip1 last message repeated 2 times May 25 19:41:48 c1opsip1 opensips[5494]: INFO:core:parse_first_line: empty or bad first line May 25 19:41:48 c1opsip1 opensips[5497]: INFO:core:parse_first_line: method not followed by SP May 25 19:41:48 c1opsip1 opensips[5494]: INFO:core:parse_first_line: bad message May 25 19:41:48 c1opsip1 opensips[5497]: INFO:core:parse_first_line: bad message May 25 19:41:48 c1opsip1 opensips[5494]: ERROR:core:parse_msg: message= May 25 19:41:48 c1opsip1 opensips[5497]: ERROR:core:parse_msg: message= May 25 19:41:48 c1opsip1 opensips[5494]: ERROR:core:receive_msg: parse_msg failed May 25 19:41:48 c1opsip1 opensips[5497]: ERROR:core:receive_msg: parse_msg failed May 25 19:41:48 c1opsip1 opensips[5494]: INFO:core:parse_first_line: empty or bad first line May 25 19:41:48 c1opsip1 opensips[5494]: INFO:core:parse_first_line: bad message May 25 19:41:48 c1opsip1 opensips[5494]: ERROR:core:parse_msg: message= May 25 19:41:48 c1opsip1 opensips[5494]: ERROR:core:receive_msg: parse_msg failed May 25 19:41:48 c1opsip1 opensips[5492]: INFO:core:parse_first_line: method not followed by SP May 25 19:41:48 c1opsip1 opensips[5492]: INFO:core:parse_first_line: bad message May 25 19:41:48 c1opsip1 opensips[5492]: ERROR:core:parse_msg: message= May 25 19:41:48 c1opsip1 opensips[5492]: ERROR:core:receive_msg: parse_msg failed Can somebody help me with this? What do they mean? Are they serious? Regards, Alex ___ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users