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

[Daniel-Constantin Mierla]

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@192.168.100.10/asterisk
> <http://sipuser:sippassword@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@192.168.100.10/asterisk
> <http://sipuser:sippassword@192.168.100.10/asterisk>")
> modparam("auth_db", "version_table", 0)
> #!else
> modparam("auth_db", "db_url",
> "db_url","mysql://sipuser:sippassword@192.168.100.10/asterisk
> <http://sipuser:sippassword@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 list
> sr-users at lists.sip-router.org
> http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users

-- 
Daniel-Constantin Mierla
http://twitter.com/#!/miconda - http://www.linkedin.com/in/miconda

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sip-router.org/pipermail/sr-users/attachments/20141204/30fe3f4f/attachment.html>