<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=UTF-8">
</head>
<body bgcolor="#ffffff" text="#000000">
Sorry, forgot the version - opensips 1.8.1<br>
<br>
<div class="moz-cite-prefix">08.10.2012 13:59, Alexandr A.
Alexandrov пишет:<br>
</div>
<blockquote class=" cite" id="mid_5072A416_90104_gmail_com"
cite="mid:5072A416.90104@gmail.com" type="cite">
<meta http-equiv="content-type" content="text/html; charset=UTF-8">
Hi!<br>
<br>
I am trying to use uac_registrant with db_text.<br>
Here is 'registrant' table:<br>
<br>
id(int,auto) registrar(string) proxy(string,null) aor(string)
third_party_registrant(string,null) username(string,null)
password(string,null) binding_URI(string)
binding_params(string,null) expiry(int,null)
forced_socket(string,null)<br>
1:sip\:wi\ngsof\t.ma\ngosip.\ru::sip\:mf\tes\<a
moz-do-not-send="true" class="moz-txt-link-abbreviated"
href="mailto:t1@wi%5Cngsof%5Ct.ma%5Cngosip.%5Cru::mf%5Ctes%5Ct1:somepass:sip%5C:mf%5Ctes%5Ct1@wi%5Cngsof%5Ct.ma%5Cngosip.%5Cru">t1@wi\ngsof\t.ma\ngosip.\ru::mf\tes\t1:somepass:sip\:mf\tes\t1@wi\ngsof\t.ma\ngosip.\ru</a>::::<br>
<br>
The row seems to be ok (all escapes, \n in the end of line)<br>
<br>
Here is what I get in log:<br>
<br>
Oct 8 13:39:30 prod2 /usr/local/sbin/opensips[30380]:
DBG:db_text:dbt_load_file: request for table [registrant]<br>
Oct 8 13:39:30 prod2 /usr/local/sbin/opensips[30380]:
DBG:db_text:dbt_load_file: db is [/usr/local/etc/opensips/dbtext]<br>
Oct 8 13:39:30 prod2 /usr/local/sbin/opensips[30380]:
DBG:db_text:dbt_load_file: loading file
[/usr/local/etc/opensips/dbtext/registrant]<br>
Oct 8 13:39:30 prod2 /usr/local/sbin/opensips[30380]:
DBG:db_text:dbt_table_new: mtime is 1349689164<br>
Oct 8 13:39:30 prod2 /usr/local/sbin/opensips[30380]:
DBG:db_text:dbt_load_file: column[0] is INT!<br>
Oct 8 13:39:30 prod2 /usr/local/sbin/opensips[30380]:
DBG:db_text:dbt_load_file: column[1] is STR!<br>
Oct 8 13:39:30 prod2 /usr/local/sbin/opensips[30380]:
DBG:db_text:dbt_load_file: column[1] is actually STRING!<br>
Oct 8 13:39:30 prod2 /usr/local/sbin/opensips[30380]:
DBG:db_text:dbt_load_file: column[2] is STR!<br>
Oct 8 13:39:30 prod2 /usr/local/sbin/opensips[30380]:
DBG:db_text:dbt_load_file: column[2] is actually STRING!<br>
Oct 8 13:39:30 prod2 /usr/local/sbin/opensips[30380]:
DBG:db_text:dbt_load_file: column[3] is STR!<br>
Oct 8 13:39:30 prod2 /usr/local/sbin/opensips[30380]:
DBG:db_text:dbt_load_file: column[3] is actually STRING!<br>
Oct 8 13:39:30 prod2 /usr/local/sbin/opensips[30380]:
DBG:db_text:dbt_load_file: column[4] is STR!<br>
Oct 8 13:39:30 prod2 /usr/local/sbin/opensips[30380]:
DBG:db_text:dbt_load_file: column[4] is actually STRING!<br>
Oct 8 13:39:30 prod2 /usr/local/sbin/opensips[30380]:
DBG:db_text:dbt_load_file: column[5] is STR!<br>
Oct 8 13:39:30 prod2 /usr/local/sbin/opensips[30380]:
DBG:db_text:dbt_load_file: column[5] is actually STRING!<br>
Oct 8 13:39:30 prod2 /usr/local/sbin/opensips[30380]:
DBG:db_text:dbt_load_file: column[6] is STR!<br>
Oct 8 13:39:30 prod2 /usr/local/sbin/opensips[30380]:
DBG:db_text:dbt_load_file: column[6] is actually STRING!<br>
Oct 8 13:39:30 prod2 /usr/local/sbin/opensips[30380]:
DBG:db_text:dbt_load_file: column[7] is STR!<br>
Oct 8 13:39:30 prod2 /usr/local/sbin/opensips[30380]:
DBG:db_text:dbt_load_file: column[7] is actually STRING!<br>
Oct 8 13:39:30 prod2 /usr/local/sbin/opensips[30380]:
DBG:db_text:dbt_load_file: column[8] is STR!<br>
Oct 8 13:39:30 prod2 /usr/local/sbin/opensips[30380]:
DBG:db_text:dbt_load_file: column[8] is actually STRING!<br>
Oct 8 13:39:30 prod2 /usr/local/sbin/opensips[30380]:
DBG:db_text:dbt_load_file: column[9] is INT!<br>
Oct 8 13:39:30 prod2 /usr/local/sbin/opensips[30380]:
DBG:db_text:dbt_load_file: column[10] is STR!<br>
Oct 8 13:39:30 prod2 /usr/local/sbin/opensips[30380]:
DBG:db_text:dbt_load_file: column[10] is actually STRING!<br>
Oct 8 13:39:30 prod2 /usr/local/sbin/opensips[30380]:
DBG:db_text:dbt_query: new res with 10 cols<br>
Oct 8 13:39:30 prod2 /usr/local/sbin/opensips[30380]:
DBG:db_text:dbt_result_new: new res with 10 cols<br>
Oct 8 13:39:30 prod2 /usr/local/sbin/opensips[30380]:
DBG:core:db_new_result: allocate 48 bytes for result set at
0x7fdded96baf8<br>
Oct 8 13:39:30 prod2 /usr/local/sbin/opensips[30380]:
DBG:core:db_allocate_columns: allocate 280 bytes for result
columns at 0x7fdded96a988<br>
Oct 8 13:39:30 prod2 /usr/local/sbin/opensips[30380]:
DBG:core:db_allocate_rows: allocate 336 bytes for result rows and
values at 0x7fdded96aab8<br>
Oct 8 13:39:30 prod2 /usr/local/sbin/opensips[30380]:
INFO:uac_registrant:load_reg_info_from_db: loading [1] records
from db<br>
Oct 8 13:39:30 prod2 kernel: opensips[30380]: segfault at 0 ip
00007fddeaf63ddf sp 00007ffff64e0f60 error 4 in
uac_registrant.so[7fddeaf61000+e000]<br>
Oct 8 13:39:30 prod2 opensips: DBG:core:wait_status_code: read
code 0 ? rc = 0, errno=Inappropriate ioctl for device<br>
Oct 8 13:39:30 prod2 opensips: INFO:core:daemonize: pre-daemon
process exiting with -1<br>
<br>
Best reagrds,<br>
Alexandr A. Alexandrov<br>
</blockquote>
<br>
</body>
</html>