<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=UTF-8">
</head>
<body bgcolor="#ffffff" text="#000000">
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 class="moz-txt-link-abbreviated" href="mailto:t1@wi\ngsof\t.ma\ngosip.\ru::mf\tes\t1:somepass:sip\:mf\tes\t1@wi\ngsof\t.ma\ngosip.\ru">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>
</body>
</html>