Hello Bogdan,
Here is the output from the opensips log. I have also attached a snippet
from the log file.
May 21 23:39:15 OpenSips[14397]: [ID 257313 local1.debug]
DBG:registrar:save_aux: xXx - flags param is
May 21 23:39:15 OpenSips[14397]: [ID 154992 local1.debug]
DBG:registrar:save_aux: xXx - flags bitmask is <0>
May 21 23:39:15 OpenSips[14397]: [ID 269964 local1.debug]
DBG:registrar:pack_ci: xXx - flags are 0
Thanks
Nathaniel L Keeling
On 5/20/13 11:56 AM, Bogdan-Andrei Iancu wrote:
Hello Nathaniel,
See the attached patch - it logs more from the part where the params
are handled .
Regards,
Bogdan-Andrei Iancu
OpenSIPS Founder and Developer
http://www.opensips-solutions.com
On 05/18/2013 09:33 AM, Nathaniel L Keeling III wrote:
Hello Bogdan,
Here are snippets from my script. I only have one place where I
execute the save function. Just wondering, could it be truncating a byte?
modparam("usrloc", "nat_bflag", 10)
modparam("usrloc", "use_domain", 1)
modparam("usrloc", "db_mode", 3)
modparam("usrloc", "db_url",
"postgres://opensips:opensip...@ama.akan.net/opensips181t")
modparam("registrar", "tcp_persistent_flag", 7)
modparam("registrar", "received_avp", "$avp(received_nh)")
xlog("SAVING THE SUBSCRIBER INTO THE LOCATION TABLE
....................................................");
if (!save("location","p1"))
{
xlog("L_ERR", "ERR:callerid:$ci|end|System error trying to
save Register's request location");
sl_reply_error();
}
xlog("L_NOTICE", "NOTICE:callerid:$ci|end|The subscriber has
successfully registered with Akan Voice");
exit;
Thanks
Nathaniel
On 5/17/13 6:07 AM, Bogdan-Andrei Iancu wrote:
Hello Nathaniel,
That is odd.....it's like you do not set the "p1" flag ....
I tested and I with "p1" flag I get:
May 17 14:05:03 [7944] DBG:registrar:pack_ci: xXx - flags are 10
Are you sure your script gets to the right save() ??
Regards,
Bogdan-Andrei Iancu
OpenSIPS Founder and Developer
http://www.opensips-solutions.com
On 05/17/2013 09:37 AM, Nathaniel L Keeling III wrote:
Hello Bogdan,
I added the patch and here is what I found: "OpenSips[4378]: [ID
269964 local1.debug] DBG:registrar:pack_ci: xXx - flags are 0". I
have also included the log file.
Thanks
Nathaniel Keeling
On 5/16/13 3:47 AM, Bogdan-Andrei Iancu wrote:
Hello Nathaniel,
Attached is an extended patch - remove the old one and apply this
one. Again look for any xXx logs .
Regards,
Bogdan-Andrei Iancu
OpenSIPS Founder and Developer
http://www.opensips-solutions.com
On 05/14/2013 02:47 PM, Nathaniel L Keeling III wrote:
Hello Bogdan,
here is the output from opensips's og file of the save() with the
patch and the code snippet from the opensips.cfg. I did not see
any ant logs with "xXx". Also,I have usrloc's db_mode set to 3.
xlog("SAVING THE SUBSCRIBER INTO THE LOCATION TABLE
....................................................");
if (!save("location","p1"))
{
xlog("L_ERR", "ERR:callerid:$ci|end|System error trying
to save Register's request location");
sl_reply_error();
}
xlog("L_NOTICE", "NOTICE:callerid:$ci|end|The subscriber has
successfully registered with Akan Voice");
exit;
_______________________________________________
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
_______________________________________________
Users mailing list
Users@lists.opensips.org
http://lists.opensips.org/cgi-bin/mailman/listinfo/users
May 21 23:39:15 OpenSips[14397]: [ID 197553 local1.error] SAVING THE
SUBSCRIBER INTO THE LOCATION TABLE
....................................................
May 21 23:39:15 OpenSips[14397]: [ID 257313 local1.debug]
DBG:registrar:save_aux: xXx - flags param is
May 21 23:39:15 OpenSips[14397]: [ID 154992 local1.debug]
DBG:registrar:save_aux: xXx - flags bitmask is <0>
May 21 23:39:15 OpenSips[14397]: [ID 497291 local1.debug]
DBG:core:parse_headers: flags=ffffffffffffffff
May 21 23:39:15 OpenSips[14397]: [ID 421386 local1.debug] DBG:core:parse_uri:
parsed uri:
May 21 23:39:15 type=1 user=<nkeeling>(8)
May 21 23:39:15 passwd=<>(0)
May 21 23:39:15 host=<akanvoice.com>(13)
May 21 23:39:15 port=<>(0): 0
May 21 23:39:15 params=<>(0)
May 21 23:39:15 headers=<>(0)
May 21 23:39:15 OpenSips[14397]: [ID 883594 local1.debug] DBG:core:parse_uri:
uri params:
May 21 23:39:15 transport=<>, val=<>, proto=0
May 21 23:39:15 OpenSips[14397]: [ID 996803 local1.debug] DBG:core:parse_uri:
user-param=<>, val=<>
May 21 23:39:15 OpenSips[14397]: [ID 784403 local1.debug] DBG:core:parse_uri:
method=<>, val=<>
May 21 23:39:15 OpenSips[14397]: [ID 185236 local1.debug] DBG:core:parse_uri:
ttl=<>, val=<>
May 21 23:39:15 OpenSips[14397]: [ID 628781 local1.debug] DBG:core:parse_uri:
maddr=<>, val=<>
May 21 23:39:15 OpenSips[14397]: [ID 949013 local1.debug] DBG:core:parse_uri:
lr=<>, val=<>
May 21 23:39:15 OpenSips[14397]: [ID 595631 local1.debug] DBG:core:parse_uri:
r2=<>, val=<>
May 21 23:39:15 OpenSips[14397]: [ID 323951 local1.debug]
DBG:db_postgres:db_postgres_val2str: PQescapeStringConn: in: 8 chars, out: 8
chars
May 21 23:39:15 OpenSips[14397]: [ID 323951 local1.debug]
DBG:db_postgres:db_postgres_val2str: PQescapeStringConn: in: 13 chars, out: 13
chars
May 21 23:39:15 OpenSips[14397]: [ID 181770 local1.debug]
DBG:db_postgres:db_postgres_submit_query: 100391220 PQsendQuery(select
contact,expires,q,callid,cseq,flags,cflags,user_agent,received,path,socket,methods,last_modified,sip_instance
from location where username='nkeeling' AND domain='akanvoice.com' order by q)
May 21 23:39:15 OpenSips[14397]: [ID 529718 local1.debug]
DBG:core:db_new_result: allocate 48 bytes for result set at 1003960d0
May 21 23:39:15 OpenSips[14397]: [ID 911073 local1.debug]
DBG:db_postgres:db_postgres_store_result: 100391220
PQresultStatus(PGRES_TUPLES_OK) PQgetResult(100782900)
May 21 23:39:15 OpenSips[14397]: [ID 460951 local1.debug]
DBG:db_postgres:db_postgres_get_columns: 14 columns returned from the query
May 21 23:39:15 OpenSips[14397]: [ID 586195 local1.debug]
DBG:core:db_allocate_columns: allocate 392 bytes for result columns at 100396358
May 21 23:39:15 OpenSips[14397]: [ID 412218 local1.debug]
DBG:db_postgres:db_postgres_get_columns: RES_NAMES(1003963c8)[0]=[contact]
May 21 23:39:15 OpenSips[14397]: [ID 995569 local1.debug]
DBG:db_postgres:db_postgres_get_columns: use DB_STRING result type
May 21 23:39:15 OpenSips[14397]: [ID 412218 local1.debug]
DBG:db_postgres:db_postgres_get_columns: RES_NAMES(1003963d8)[1]=[expires]
May 21 23:39:15 OpenSips[14397]: [ID 588722 local1.debug]
DBG:db_postgres:db_postgres_get_columns: use DB_DATETIME result type
May 21 23:39:15 OpenSips[14397]: [ID 412218 local1.debug]
DBG:db_postgres:db_postgres_get_columns: RES_NAMES(1003963e8)[2]=[q]
May 21 23:39:15 OpenSips[14397]: [ID 656759 local1.debug]
DBG:db_postgres:db_postgres_get_columns: use DB_DOUBLE result type
May 21 23:39:15 OpenSips[14397]: [ID 412218 local1.debug]
DBG:db_postgres:db_postgres_get_columns: RES_NAMES(1003963f8)[3]=[callid]
May 21 23:39:15 OpenSips[14397]: [ID 995569 local1.debug]
DBG:db_postgres:db_postgres_get_columns: use DB_STRING result type
May 21 23:39:15 OpenSips[14397]: [ID 412218 local1.debug]
DBG:db_postgres:db_postgres_get_columns: RES_NAMES(100396408)[4]=[cseq]
May 21 23:39:15 OpenSips[14397]: [ID 499560 local1.debug]
DBG:db_postgres:db_postgres_get_columns: use DB_INT result type
May 21 23:39:15 OpenSips[14397]: [ID 412218 local1.debug]
DBG:db_postgres:db_postgres_get_columns: RES_NAMES(100396418)[5]=[flags]
May 21 23:39:15 OpenSips[14397]: [ID 499560 local1.debug]
DBG:db_postgres:db_postgres_get_columns: use DB_INT result type
May 21 23:39:15 OpenSips[14397]: [ID 412218 local1.debug]
DBG:db_postgres:db_postgres_get_columns: RES_NAMES(100396428)[6]=[cflags]
May 21 23:39:15 OpenSips[14397]: [ID 499560 local1.debug]
DBG:db_postgres:db_postgres_get_columns: use DB_INT result type
May 21 23:39:15 OpenSips[14397]: [ID 412218 local1.debug]
DBG:db_postgres:db_postgres_get_columns: RES_NAMES(100396438)[7]=[user_agent]
May 21 23:39:15 OpenSips[14397]: [ID 995569 local1.debug]
DBG:db_postgres:db_postgres_get_columns: use DB_STRING result type
May 21 23:39:15 OpenSips[14397]: [ID 412218 local1.debug]
DBG:db_postgres:db_postgres_get_columns: RES_NAMES(100396448)[8]=[received]
May 21 23:39:15 OpenSips[14397]: [ID 995569 local1.debug]
DBG:db_postgres:db_postgres_get_columns: use DB_STRING result type
May 21 23:39:15 OpenSips[14397]: [ID 412218 local1.debug]
DBG:db_postgres:db_postgres_get_columns: RES_NAMES(100396458)[9]=[path]
May 21 23:39:15 OpenSips[14397]: [ID 995569 local1.debug]
DBG:db_postgres:db_postgres_get_columns: use DB_STRING result type
May 21 23:39:15 OpenSips[14397]: [ID 412218 local1.debug]
DBG:db_postgres:db_postgres_get_columns: RES_NAMES(100396468)[10]=[socket]
May 21 23:39:15 OpenSips[14397]: [ID 995569 local1.debug]
DBG:db_postgres:db_postgres_get_columns: use DB_STRING result type
May 21 23:39:15 OpenSips[14397]: [ID 412218 local1.debug]
DBG:db_postgres:db_postgres_get_columns: RES_NAMES(100396478)[11]=[methods]
May 21 23:39:15 OpenSips[14397]: [ID 499560 local1.debug]
DBG:db_postgres:db_postgres_get_columns: use DB_INT result type
May 21 23:39:15 OpenSips[14397]: [ID 412218 local1.debug]
DBG:db_postgres:db_postgres_get_columns:
RES_NAMES(100396488)[12]=[last_modified]
May 21 23:39:15 OpenSips[14397]: [ID 588722 local1.debug]
DBG:db_postgres:db_postgres_get_columns: use DB_DATETIME result type
May 21 23:39:15 OpenSips[14397]: [ID 412218 local1.debug]
DBG:db_postgres:db_postgres_get_columns: RES_NAMES(100396498)[13]=[sip_instance]
May 21 23:39:15 OpenSips[14397]: [ID 995569 local1.debug]
DBG:db_postgres:db_postgres_get_columns: use DB_STRING result type
May 21 23:39:15 OpenSips[14397]: [ID 991251 local1.debug]
DBG:db_postgres:db_postgres_convert_rows: no rows returned from the query
May 21 23:39:15 OpenSips[14397]: [ID 198008 local1.debug]
DBG:db_postgres:free_query: PQclear(100782900) result set
May 21 23:39:15 OpenSips[14397]: [ID 333765 local1.debug]
DBG:usrloc:db_load_urecord: aor nkeel...@akanvoice.com not found in table
location
May 21 23:39:15 OpenSips[14397]: [ID 321192 local1.debug]
DBG:core:db_free_columns: freeing result columns at 100396358
May 21 23:39:15 OpenSips[14397]: [ID 670447 local1.debug]
DBG:core:db_free_rows: freeing 0 rows
May 21 23:39:15 OpenSips[14397]: [ID 921065 local1.debug]
DBG:core:db_free_result: freeing result set at 1003960d0
May 21 23:39:15 OpenSips[14397]: [ID 497291 local1.debug]
DBG:core:parse_headers: flags=8000000
May 21 23:39:15 OpenSips[14397]: [ID 269964 local1.debug]
DBG:registrar:pack_ci: xXx - flags are 0
May 21 23:39:15 OpenSips[14397]: [ID 497291 local1.debug]
DBG:core:parse_headers: flags=ffffffffffffffff
May 21 23:39:15 OpenSips[14397]: [ID 323951 local1.debug]
DBG:db_postgres:db_postgres_val2str: PQescapeStringConn: in: 8 chars, out: 8
chars
May 21 23:39:15 OpenSips[14397]: [ID 323951 local1.debug]
DBG:db_postgres:db_postgres_val2str: PQescapeStringConn: in: 48 chars, out: 48
chars
May 21 23:39:15 OpenSips[14397]: [ID 323951 local1.debug]
DBG:db_postgres:db_postgres_val2str: PQescapeStringConn: in: 28 chars, out: 28
chars
May 21 23:39:15 OpenSips[14397]: [ID 323951 local1.debug]
DBG:db_postgres:db_postgres_val2str: PQescapeStringConn: in: 25 chars, out: 25
chars
May 21 23:39:15 OpenSips[14397]: [ID 323951 local1.debug]
DBG:db_postgres:db_postgres_val2str: PQescapeStringConn: in: 23 chars, out: 23
chars
May 21 23:39:15 last message repeated 1 time
May 21 23:39:15 OpenSips[14397]: [ID 323951 local1.debug]
DBG:db_postgres:db_postgres_val2str: PQescapeStringConn: in: 13 chars, out: 13
chars
May 21 23:39:15 OpenSips[14397]: [ID 181770 local1.debug]
DBG:db_postgres:db_postgres_submit_query: 100391220 PQsendQuery(insert into
location
(username,contact,expires,q,callid,cseq,flags,cflags,user_agent,received,path,socket,methods,last_modified,sip_instance,domain
) values
('nkeeling','sip:nkeeling@100.228.192.160:59823;transport=udp','2013-05-22
00:39:15',-1.00 ,'304993846543@100.228.192.160',2,0,0,'Sipdroid/3.0
beta/LG-P999','sip:208.54.44.140:34503',NULL,'udp:209.252.110.48:5060',NULL,'2013-05-21
23:39:15',NULL,'akanvoice.com'))
May 21 23:39:15 OpenSips[14397]: [ID 529718 local1.debug]
DBG:core:db_new_result: allocate 48 bytes for result set at 1003960d0
May 21 23:39:15 OpenSips[14397]: [ID 911073 local1.debug]
DBG:db_postgres:db_postgres_store_result: 100391220
PQresultStatus(PGRES_COMMAND_OK) PQgetResult(1007829e0)
May 21 23:39:15 OpenSips[14397]: [ID 198008 local1.debug]
DBG:db_postgres:free_query: PQclear(1007829e0) result set
May 21 23:39:15 OpenSips[14397]: [ID 670447 local1.debug]
DBG:core:db_free_rows: freeing 0 rows
May 21 23:39:15 OpenSips[14397]: [ID 921065 local1.debug]
DBG:core:db_free_result: freeing result set at 1003960d0
May 21 23:39:15 OpenSips[14397]: [ID 866151 local1.debug]
DBG:registrar:build_contact: created Contact HF: Contact:
<sip:nkeeling@100.228.192.160:59823;transport=udp>;expires=3600;received="sip:208.54.44.140:34503"^M
May 21 23:39:15 OpenSips[14397]: [ID 497291 local1.debug]
DBG:core:parse_headers: flags=ffffffffffffffff
May 21 23:39:15 OpenSips[14397]: [ID 153352 local1.debug] DBG:core:pv_printf:
final buffer length 107
May 21 23:39:15 OpenSips[14397]: [ID 197553 local1.notice]
NOTICE:callerid:304993846543@100.228.192.160|end|The subscriber has
successfully registered with Akan Voice_______________________________________________
Users mailing list
Users@lists.opensips.org
http://lists.opensips.org/cgi-bin/mailman/listinfo/users
