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 <mico...@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-us...@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 > >
_______________________________________________ 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
