<html>
<head>
<meta content="text/html; charset=windows-1252"
http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
Hello,<br>
<br>
can you check the structure of asterisk users table? MySQL library
reports it doesn't have the column secret:<br>
<br>
Nov 22 17:19:20 debian /usr/local/sbin/kamailio[6434]: ERROR:
db_mysql [km_dbase.c:122]: db_mysql_submit_query(): driver error on
query: Unknown column 'secret' in 'field list'<br>
<br>
Cheers,<br>
Daniel<br>
<br>
<div class="moz-cite-prefix">On 22/11/14 23:46, Mahmoud Ramadan Ali
wrote:<br>
</div>
<blockquote
cite="mid:CAMznL=WpG9_C-em=OXa10ub0u7cHUcREvtcM0xsb6d8pJJU62Q@mail.gmail.com"
type="cite">
<div dir="ltr">
<div>Hi Dears,<br>
I'm trying to configure Kamailio as SBC in multi home mode for
Asterisk by authenticating the inbound SIP registration
requests,i'm following this tutorial <a
moz-do-not-send="true"
href="http://kb.asipto.com/asterisk:realtime:kamailio-4.0.x-asterisk-11.3.0-astdb">http://kb.asipto.com/asterisk:realtime:kamailio-4.0.x-asterisk-11.3.0-astdb</a>
to achieve this goal. i have modified the necessary changes
like the Asterisk DB URL and the SIP table name and Username
and password column and verified the Mysql connection.<br>
<br>
My topology like this Asterisk (192.168.100.10)
<----Internal:192.168.100.1---->Kamailio<---External:192.168.50.1----->
SIP Phone (192.168.50.2)<br>
But when trying to register a SIP phone Kamailio generates
these error messages <br>
<br>
Nov 22 17:19:20 debian /usr/local/sbin/kamailio[6434]: ERROR:
db_mysql [km_dbase.c:122]: db_mysql_submit_query(): driver
error on query: Unknown column 'secret' in 'field list'<br>
Nov 22 17:19:20 debian /usr/local/sbin/kamailio[6434]: ERROR:
<core> [db_query.c:132]: db_do_query_internal(): error
while submitting query<br>
Nov 22 17:19:20 debian /usr/local/sbin/kamailio[6434]: ERROR:
auth_db [authorize.c:175]: get_ha1(): failed to query database<br>
<br>
The Auth_DB Params in the configuration file is as follows.<br>
<br>
# ----- auth_db params -----<br>
#!ifdef WITH_AUTH<br>
modparam("auth_db", "calculate_ha1", yes)<br>
modparam("auth_db", "load_credentials", "")<br>
<br>
#!ifdef WITH_ASTERISK<br>
modparam("auth_db", "user_column", "account")<br>
modparam("auth_db", "password_column", "secret")<br>
modparam("auth_db", "db_url", DBASTURL)<br>
modparam("auth_db", "version_table", 0)<br>
#!else<br>
modparam("auth_db", "db_url", DBURL)<br>
modparam("auth_db", "password_column", "password")<br>
modparam("auth_db", "use_domain", MULTIDOMAIN)<br>
#!endif<br>
<br>
</div>
I tried also to give the Auth_DB module all the paramaters like
this but still receiving the same error ! So any ideas about the
cause of the problem and how to solve it please ?<br>
<br>
# ----- auth_db params -----<br>
#!ifdef WITH_AUTH<br>
modparam("auth_db", "user_column", "account")<br>
modparam("auth_db", "password_column", "secret")<br>
modparam("auth_db", "db_url", "mysql://<a moz-do-not-send="true"
href="http://sipuser:sippassword@192.168.100.10/asterisk">sipuser:sippassword@192.168.100.10/asterisk</a>")<br>
modparam("auth_db", "calculate_ha1", yes)<br>
modparam("auth_db", "load_credentials", "")<br>
<br>
#!ifdef WITH_ASTERISK<br>
modparam("auth_db", "user_column", "account")<br>
modparam("auth_db", "password_column", "secret")<br>
modparam("auth_db", "db_url", "mysql://<a moz-do-not-send="true"
href="http://sipuser:sippassword@192.168.100.10/asterisk">sipuser:sippassword@192.168.100.10/asterisk</a>")<br>
modparam("auth_db", "version_table", 0)<br>
#!else<br>
modparam("auth_db", "db_url", "db_url","mysql://<a
moz-do-not-send="true"
href="http://sipuser:sippassword@192.168.100.10/asterisk">sipuser:sippassword@192.168.100.10/asterisk</a>")<br>
modparam("auth_db", "password_column", "secret")<br>
modparam("auth_db", "user_column", "account")<br>
modparam("auth_db", "use_domain", MULTIDOMAIN)<br>
#!endif<br>
<div><br>
<br>
</div>
</div>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:sr-users@lists.sip-router.org">sr-users@lists.sip-router.org</a>
<a class="moz-txt-link-freetext" href="http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users">http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users</a>
</pre>
</blockquote>
<br>
<pre class="moz-signature" cols="72">--
Daniel-Constantin Mierla
<a class="moz-txt-link-freetext" href="http://twitter.com/#!/miconda">http://twitter.com/#!/miconda</a> - <a class="moz-txt-link-freetext" href="http://www.linkedin.com/in/miconda">http://www.linkedin.com/in/miconda</a></pre>
</body>
</html>