Hi
If I turn on !define WITH_DEBUG.
The output:
0(4311) DEBUG: <core> [sr_module.c:871]: DEBUG: init_mod: dialplan
0(4311) DEBUG: dialplan [dialplan.c:128]:
db_url=mysql://xxxx:xxxx@10.60.10.102/kamailio/48/0x89a268
0(4311) DEBUG: <core> [usr_avp.c:890]: Parsing 's:dest'
0(4311) DEBUG: dialplan [dp_db.c:162]: trying to initialize data from db
0(4311) DEBUG: <core> [sr_module.c:506]: find_export_record: found
<db_bind_api> in module db_mysql
[/usr/local/lib/kamailio/modules/db_mysql.so]
0(4311) DEBUG: <core> [db.c:202]: using db bind api for db_mysql
0(4311) DEBUG: <core> [db.c:285]: connection 0x95ee00 not found in pool
0(4311) DEBUG: db_mysql [km_my_con.c:94]: opening connection:
mysql://xxxx:xxxx@10.60.10.102/kamailio
0(4311) DEBUG: db_mysql [km_my_con.c:119]: connection type is
10.60.10.102 via TCP/IP
0(4311) DEBUG: db_mysql [km_my_con.c:120]: protocol version is 10
0(4311) DEBUG: db_mysql [km_my_con.c:121]: server version is
5.1.41-3ubuntu12.3
0(4311) DEBUG: <core> [db_res.c:118]: allocate 48 bytes for result
set at 0x95ef28
0(4311) DEBUG: db_mysql [km_res.c:68]: 1 columns returned from the query
0(4311) DEBUG: <core> [db_res.c:155]: allocate 8 bytes for result
names at 0x95ef68
0(4311) DEBUG: <core> [db_res.c:165]: allocate 4 bytes for result
types at 0x95f318
0(4311) DEBUG: db_mysql [km_res.c:85]: allocate 16 bytes for
RES_NAMES[0] at 0x95f2f8
0(4311) DEBUG: db_mysql [km_res.c:92]:
RES_NAMES(0x95f2f8)[0]=[table_version]
0(4311) DEBUG: db_mysql [km_res.c:100]: use DB1_INT result type
0(4311) DEBUG: <core> [db_res.c:184]: allocate 16 bytes for rows at
0x95f2d8
0(4311) DEBUG: <core> [db_row.c:119]: allocate 32 bytes for row
values at 0x95f0e0
0(4311) DEBUG: <core> [db_val.c:73]: converting INT [1]
0(4311) DEBUG: <core> [db_res.c:81]: freeing 1 columns
0(4311) DEBUG: <core> [db_res.c:85]: freeing RES_NAMES[0] at 0x95f2f8
0(4311) DEBUG: <core> [db_res.c:94]: freeing result names at 0x95ef68
0(4311) DEBUG: <core> [db_res.c:99]: freeing result types at 0x95f318
0(4311) DEBUG: <core> [db_res.c:54]: freeing 1 rows
0(4311) DEBUG: <core> [db_row.c:97]: freeing row values at 0x95f0e0
0(4311) DEBUG: <core> [db_res.c:62]: freeing rows at 0x95f2d8
0(4311) DEBUG: <core> [db_res.c:136]: freeing result set at 0x95ef28
0(4311) DEBUG: dialplan [dp_db.c:200]: init
0(4311) DEBUG: <core> [db_res.c:118]: allocate 48 bytes for result
set at 0x95ef28
0(4311) DEBUG: db_mysql [km_res.c:68]: 8 columns returned from the query
0(4311) DEBUG: <core> [db_res.c:155]: allocate 64 bytes for result
names at 0x95eff0
0(4311) DEBUG: <core> [db_res.c:165]: allocate 32 bytes for result
types at 0x95f0e0
0(4311) DEBUG: db_mysql [km_res.c:85]: allocate 16 bytes for
RES_NAMES[0] at 0x95f2d8
0(4311) DEBUG: db_mysql [km_res.c:92]: RES_NAMES(0x95f2d8)[0]=[dpid]
0(4311) DEBUG: db_mysql [km_res.c:100]: use DB1_INT result type
0(4311) DEBUG: db_mysql [km_res.c:85]: allocate 16 bytes for
RES_NAMES[1] at 0x95f318
0(4311) DEBUG: db_mysql [km_res.c:92]: RES_NAMES(0x95f318)[1]=[pr]
0(4311) DEBUG: db_mysql [km_res.c:100]: use DB1_INT result type
0(4311) DEBUG: db_mysql [km_res.c:85]: allocate 16 bytes for
RES_NAMES[2] at 0x95f2f8
0(4311) DEBUG: db_mysql [km_res.c:92]: RES_NAMES(0x95f2f8)[2]=[match_op]
0(4311) DEBUG: db_mysql [km_res.c:100]: use DB1_INT result type
0(4311) DEBUG: db_mysql [km_res.c:85]: allocate 16 bytes for
RES_NAMES[3] at 0x95ede0
0(4311) DEBUG: db_mysql [km_res.c:92]:
RES_NAMES(0x95ede0)[3]=[match_exp]
0(4311) DEBUG: db_mysql [km_res.c:136]: use DB1_STRING result type
0(4311) DEBUG: db_mysql [km_res.c:85]: allocate 16 bytes for
RES_NAMES[4] at 0x95f2b8
0(4311) DEBUG: db_mysql [km_res.c:92]:
RES_NAMES(0x95f2b8)[4]=[match_len]
0(4311) DEBUG: db_mysql [km_res.c:100]: use DB1_INT result type
0(4311) DEBUG: db_mysql [km_res.c:85]: allocate 16 bytes for
RES_NAMES[5] at 0x95f298
0(4311) DEBUG: db_mysql [km_res.c:92]:
RES_NAMES(0x95f298)[5]=[subst_exp]
0(4311) DEBUG: db_mysql [km_res.c:136]: use DB1_STRING result type
0(4311) DEBUG: db_mysql [km_res.c:85]: allocate 16 bytes for
RES_NAMES[6] at 0x95f278
0(4311) DEBUG: db_mysql [km_res.c:92]: RES_NAMES(0x95f278)[6]=[repl_exp]
0(4311) DEBUG: db_mysql [km_res.c:136]: use DB1_STRING result type
0(4311) DEBUG: db_mysql [km_res.c:85]: allocate 16 bytes for
RES_NAMES[7] at 0x95f258
0(4311) DEBUG: db_mysql [km_res.c:92]: RES_NAMES(0x95f258)[7]=[attrs]
0(4311) DEBUG: db_mysql [km_res.c:136]: use DB1_STRING result type
0(4311) DEBUG: db_mysql [km_dbase.c:342]: converting row 0 of 1 count 1
0(4311) DEBUG: <core> [db_row.c:119]: allocate 256 bytes for row
values at 0x95f338
0(4311) DEBUG: <core> [db_val.c:73]: converting INT [1]
0(4311) DEBUG: <core> [db_val.c:73]: converting INT [100]
0(4311) DEBUG: <core> [db_val.c:73]: converting INT [1]
0(4311) DEBUG: <core> [db_val.c:117]: converting STRING [ ^123+]
0(4311) DEBUG: <core> [db_val.c:73]: converting INT [0]
0(4311) DEBUG: <core> [db_val.c:117]: converting STRING [^(123.+)]
0(4311) DEBUG: <core> [db_val.c:117]: converting STRING [0030\1]
0(4311) DEBUG: <core> [db_val.c:117]: converting STRING []
0(4311) DEBUG: dialplan [dp_db.c:374]: build_rule
and kamailio is not started!
Without !define WITH_DEBUG, and starting kamailio with command
"kamailio -E -dd" the output is:
Aug 2 08:20:23 ubuntu kamailio: WARNING: <core> [socket_info.c:896]:
WARNING: fix_hostname: could not rev. resolve 10.50.11.103
Aug 2 08:20:23 ubuntu kamailio: WARNING: <core> [socket_info.c:896]:
WARNING: fix_hostname: could not rev. resolve 10.60.10.103
Aug 2 08:20:23 ubuntu kamailio: WARNING: <core> [socket_info.c:896]:
WARNING: fix_hostname: could not rev. resolve 10.60.11.103
Aug 2 08:20:23 ubuntu kamailio: WARNING: <core> [daemonize.c:150]:
pid file contains old pid, replacing pid
Aug 2 08:20:23 ubuntu /usr/local/sbin/kamailio[3845]: INFO: usrloc
[hslot.c:53]: locks array size 512
But kamailio is not started.
Any help, I realy need dialplan module.
Ernest
On 22. 07. 2010 21:51, Daniel-Constantin Mierla wrote:
On 7/22/10 8:48 PM, IƱaki Baz Castillo wrote:
2010/7/22 Ernest
Mavrel<ernest.mavrel(a)novatel.si>si>:
Hi
This is what i get:
kamailio -E -dd
[...]
0(15033) WARNING:<core>
[socket_info.c:896]: WARNING:
fix_hostname: could
not rev. resolve 10.50.11.103
0(15033) WARNING:<core> [socket_info.c:896]: WARNING:
fix_hostname: could
not rev. resolve 10.60.10.103
0(15033) WARNING:<core> [socket_info.c:896]: WARNING:
fix_hostname: could
not rev. resolve 10.60.11.103
Listening on
udp: 127.0.0.1:5060
udp: 10.50.11.103:5060
udp: 10.60.10.103:5060
udp: 10.60.11.103:5060
Aliases:
udp: localhost:5060
root@ubuntu:~# 0(15035) INFO: usrloc [hslot.c:53]: locks array
size 512
It seems it has started, right?
the output still looks incomplete, but more
strange is that DEBUG
messages must have not been printed. So I am not sure the output is
the right one.
Parameter -dd must set the threshold to INFO messages -- I wanted to
spot quickly eventual errors.
Ernest, can you doublecheck if you pasted the right output?
Cheers,
Daniel
_______________________________________________
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
sr-users(a)lists.sip-router.org