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
<[email protected] <mailto:[email protected]>> 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
<[email protected] <mailto:[email protected]>> 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
[email protected] <mailto:[email protected]>
http://lists.opensips.org/cgi-bin/mailman/listinfo/users
_______________________________________________
Users mailing list
[email protected]
http://lists.opensips.org/cgi-bin/mailman/listinfo/users
