<div dir="ltr">Solved ! Thanks, Now i have to go to the next step " Load Balancing ".<br></div><div class="gmail_extra"><br><div class="gmail_quote">On Thu, Dec 4, 2014 at 10:31 AM, Daniel-Constantin Mierla <span dir="ltr"><<a href="mailto:miconda@gmail.com" target="_blank">miconda@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div 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:<span class=""><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></span>
Cheers,<br>
Daniel<div><div class="h5"><br>
<br>
<div>On 22/11/14 23:46, Mahmoud Ramadan Ali
wrote:<br>
</div>
</div></div><blockquote type="cite"><div><div class="h5">
<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 href="http://kb.asipto.com/asterisk:realtime:kamailio-4.0.x-asterisk-11.3.0-astdb" target="_blank">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 href="http://sipuser:sippassword@192.168.100.10/asterisk" target="_blank">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 href="http://sipuser:sippassword@192.168.100.10/asterisk" target="_blank">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 href="http://sipuser:sippassword@192.168.100.10/asterisk" target="_blank">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></fieldset>
<br>
</div></div><pre>_______________________________________________
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
<a href="mailto:sr-users@lists.sip-router.org" target="_blank">sr-users@lists.sip-router.org</a>
<a href="http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users" target="_blank">http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users</a><span class="HOEnZb"><font color="#888888">
</font></span></pre><span class="HOEnZb"><font color="#888888">
</font></span></blockquote><span class="HOEnZb"><font color="#888888">
<br>
<pre cols="72">--
Daniel-Constantin Mierla
<a href="http://twitter.com/#!/miconda" target="_blank">http://twitter.com/#!/miconda</a> - <a href="http://www.linkedin.com/in/miconda" target="_blank">http://www.linkedin.com/in/miconda</a></pre>
</font></span></div>
<br>_______________________________________________<br>
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list<br>
<a href="mailto:sr-users@lists.sip-router.org">sr-users@lists.sip-router.org</a><br>
<a href="http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users" target="_blank">http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users</a><br>
<br></blockquote></div><br></div>