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") 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") modparam("auth_db", "version_table", 0) #!else modparam("auth_db", "db_url", "db_url","mysql:// 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
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@lists.sip-router.org http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
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@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@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") modparam("auth_db", "version_table", 0) #!else modparam("auth_db", "db_url", "db_url","mysql:// 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 listsr-users@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@lists.sip-router.org http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
-
Daniel-Constantin Mierla -
Mahmoud Ramadan Ali