[SR-Users] Kamailio Failed to Query the Asterisk DB to Authenticate Registration Requests.

[Mahmoud Ramadan Ali]

Solved ! Thanks, Now i have to go to the next step " Load Balancing ".

On Thu, Dec 4, 2014 at 10:31 AM, Daniel-Constantin Mierla <miconda at gmail.com
> wrote:

>  Hello,
>
> can you check the structure of asterisk users table? MySQL library reports
> it doesn't have the column secret:
>
> 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'
>
> Cheers,
> Daniel
>
>
> On 22/11/14 23:46, Mahmoud Ramadan Ali wrote:
>
>  Hi Dears,
> 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
> http://kb.asipto.com/asterisk:realtime:kamailio-4.0.x-asterisk-11.3.0-astdb
> 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.
>
> 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)
> But when trying to register a SIP phone Kamailio generates these error
> messages
>
> 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'
> 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
> Nov 22 17:19:20 debian /usr/local/sbin/kamailio[6434]: ERROR: auth_db
> [authorize.c:175]: get_ha1(): failed to query database
>
> The Auth_DB Params in the configuration file is as follows.
>
> # ----- auth_db params -----
> #!ifdef WITH_AUTH
> modparam("auth_db", "calculate_ha1", yes)
> modparam("auth_db", "load_credentials", "")
>
> #!ifdef WITH_ASTERISK
> modparam("auth_db", "user_column", "account")
> modparam("auth_db", "password_column", "secret")
> modparam("auth_db", "db_url", DBASTURL)
> modparam("auth_db", "version_table", 0)
> #!else
> modparam("auth_db", "db_url", DBURL)
> modparam("auth_db", "password_column", "password")
> modparam("auth_db", "use_domain", MULTIDOMAIN)
> #!endif
>
>  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 ?
>
> # ----- auth_db params -----
> #!ifdef WITH_AUTH
> modparam("auth_db", "user_column", "account")
> modparam("auth_db", "password_column", "secret")
> modparam("auth_db", "db_url", "mysql://
> sipuser:sippassword at 192.168.100.10/asterisk")
> modparam("auth_db", "calculate_ha1", yes)
> modparam("auth_db", "load_credentials", "")
>
> #!ifdef WITH_ASTERISK
> modparam("auth_db", "user_column", "account")
> modparam("auth_db", "password_column", "secret")
> modparam("auth_db", "db_url", "mysql://
> sipuser:sippassword at 192.168.100.10/asterisk")
> modparam("auth_db", "version_table", 0)
> #!else
> modparam("auth_db", "db_url", "db_url","mysql://
> sipuser:sippassword at 192.168.100.10/asterisk")
> modparam("auth_db", "password_column", "secret")
> modparam("auth_db", "user_column", "account")
> modparam("auth_db", "use_domain", MULTIDOMAIN)
> #!endif
>
>
>
>
> _______________________________________________
> SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing listsr-users at lists.sip-router.orghttp://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
>
>
> --
> Daniel-Constantin Mierlahttp://twitter.com/#!/miconda - http://www.linkedin.com/in/miconda
>
>
> _______________________________________________
> SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
> sr-users at lists.sip-router.org
> http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sip-router.org/pipermail/sr-users/attachments/20141204/bd1a5f31/attachment.html>