On 03.09.2009 12:00 Uhr, Rajesh wrote: Yes i did cretae.. i completed authentication and presence module successfully.. iam caught up with this.. am posting my cfg file below. kindly correct me if iam wrong. ************************************************************************************************************************************************** ####### Global Parameters ######### debug=3 log_stderror=yes log_facility=LOG_LOCAL0 ##fork changed to NO manually from yes fork=yes #fork=yes children=4 /* uncomment the following lines to enable debugging */ #debug=6 #fork=no #log_stderror=yes /* uncomment the next line to disable TCP (default on) */ #disable_tcp=yes /* uncomment the next line to enable the auto temporary blacklisting of not available destinations (default disabled) */ #disable_dns_blacklist=no /* uncomment the next line to enable IPv6 lookup after IPv4 dns lookup failures (default disabled) */ #dns_try_ipv6=yes /* uncomment the next line to disable the auto discovery of local aliases based on revers DNS on IPs (default on) */ #auto_aliases=no /* uncomment the following lines to enable TLS support (default off) */ #disable_tls = no #listen = tls:your_IP:5061 #tls_verify_server = 1 #tls_verify_client = 1 #tls_require_client_certificate = 0 #tls_method = TLSv1 #tls_certificate = "/usr/local//etc/kamailio/tls/user/user-cert.pem" #tls_private_key = "/usr/local//etc/kamailio/tls/user/user-privkey.pem" #tls_ca_list = "/usr/local//etc/kamailio/tls/user/user-calist.pem" port = 5067 /* uncomment and configure the following line if you want Kamailio to bind on a specific interface/port/proto (default bind on all available) */ #listen=udp:192.168.1.2:5060 ####### Modules Section ######## #set module path mpath="/usr/local//lib/kamailio/modules/" /* uncomment next line for MySQL DB support */ loadmodule "db_mysql.so" loadmodule "mi_fifo.so" loadmodule "sl.so" loadmodule "tm.so" loadmodule "rr.so" loadmodule "pv.so" loadmodule "textops.so" loadmodule "usrloc.so" loadmodule "maxfwd.so" loadmodule "imc.so" loadmodule "uri_db.so" loadmodule "siputils.so" loadmodule "xlog.so" loadmodule "acc.so" loadmodule "registrar.so" loadmodule "auth.so" loadmodule "auth_db.so" loadmodule "alias_db.so" loadmodule "domain.so" loadmodule "presence.so" loadmodule "presence_xml.so" #n#loadmodule "nathelper.so" ##insert function tested here # ----------------- setting module-specific parameters --------------- # ----- mi_fifo params ----- modparam("mi_fifo", "fifo_name", "/tmp/openser_fifo") # ----- rr params ----- # add value to ;lr param to cope with most of the UAs modparam("rr", "enable_full_lr", 1) # do not append from tag to the RR (no need for this script) modparam("rr", "append_fromtag", 0) # ----- rr params ----- modparam("registrar", "method_filtering", 1) /* uncomment the next line to disable parallel forking via location */ # modparam("registrar", "append_branches", 0) /* uncomment the next line not to allow more than 10 contacts per AOR */ #modparam("registrar", "max_contacts", 10) # ----- uri_db params ----- /* by default we disable the DB support in the module as we do not need it in this configuration */ modparam("uri_db", "use_uri_table", 0) modparam("uri_db", "db_url", "") # ----- acc params ----- /* what sepcial events should be accounted ? */ modparam("acc", "early_media", 1) modparam("acc", "report_ack", 1) modparam("acc", "report_cancels", 1) /* by default ww do not adjust the direct of the sequential requests. if you enable this parameter, be sure the enable "append_fromtag" in "rr" module */ modparam("acc", "detect_direction", 0) /* account triggers (flags) */ modparam("acc", "failed_transaction_flag", 3) modparam("acc", "log_flag", 1) modparam("acc", "log_missed_flag", 2) modparam("acc", "log_extra", "src_user=$fU;src_domain=$fd;dst_ouser=$tU;dst_user=$rU;dst_domain=$rd") /* uncomment the following lines to enable DB accounting also */ modparam("acc", "db_flag", 1) modparam("acc", "db_missed_flag", 2) modparam("domain", "db_url", "mysql://openser:openserrw@localhost/openser") modparam("acc","db_extra","src_user=$fU;src_domain=$fd;dst_ouser=$tU;dst_user=$rU;dst_domain=$rd") # ----- usrloc params ----- modparam("usrloc", "db_mode", 2) modparam("usrloc", "db_url", "mysql://openser:openserrw@localhost/openser") # ----- auth_db params ----- /* uncomment the following lines if you want to enable the DB based authentication */ modparam("auth_db", "calculate_ha1", yes) modparam("auth_db", "password_column", "password") modparam("auth_db", "db_url","mysql://openser:openserrw@localhost/openser") modparam("auth_db", "load_credentials", "") ###registrar params added for imc # -- registrar params -- modparam("registrar", "default_expires", 120) # -- registrar params -- modparam("usrloc", "db_mode", 0) # -- imc params -- modparam("imc", "imc_cmd_start_char", "#") modparam("imc|usrloc", "db_url", "mysql://openser:openserrw@192.168.64.75/openser") ##the following three lines were added seperately for imc modparam("imc", "rooms_table","imc_rooms") modparam("imc", "rooms_table","imc_members") modparam("imc", "hash_size", 8) # -- tm params -- modparam("tm", "fr_timer", 10 ) modparam("tm", "fr_inv_timer", 15 ) modparam("tm", "wt_timer", 10 ) # ----- alias_db params ----- /* uncomment the following lines if you want to enable the DB based aliases */ modparam("alias_db", "db_url","mysql://openser:openserrw@localhost/openser") # ----- domain params ----- /* uncomment the following lines to enable multi-domain detection support */ modparam("domain", "db_url", "mysql://openser:openserrw@localhost/openser") modparam("domain", "db_mode", 1) # Use caching # ----- multi-module params ----- /* uncomment the following line if you want to enable multi-domain support in the modules (dafault off) */ modparam("alias_db|auth_db|usrloc|uri_db", "use_domain", 1) # ----- presence params ----- /* uncomment the following lines if you want to enable presence */ modparam("presence|presence_xml", "db_url", "mysql://openser:openserrw@localhost/openser") modparam("presence_xml", "force_active", 1) modparam("presence", "server_address", "sip:192.168.64.75:5060") # -- nathelper #n#modparam("nathelper", "rtpproxy_sock", "udp:127.0.0.1:7722") #n#modparam("nathelper", "natping_interval", 30) #n#modparam("nathelper", "ping_nated_only", 1) #n#modparam("nathelper", "sipping_bflag", 7) #n#modparam("nathelper", "sipping_from", "sip:pinger@kamailio.org") #n#modparam("registrar|nathelper", "received_avp", "$avp(i:80)") #n#modparam("usrloc", "nat_bflag", 6) ####### Routing Logic ######## # main request routing logic route{ insert_hf("To-username: test"); if (!mf_process_maxfwd_header("10")) { sl_send_reply("483","Too Many Hops"); exit; } ########The following set of lines were added for implementing imc # registrations - ##the following line has been added for creating chat rooms ##insert_hf (#create chat-000) if(is_method("REGISTER")) { save("location"); exit; } ##if(uri=~"sip:q*@") ## if(uri=~"sip:chat0000@192.168.64.75") ##the below line has been edited by Rajesh. if(uri=~"sip:chat0000@192.168.64.75") { # IMC - message #imc xdbg("script: message from [$fu ] r-uri [$ru ] msg [$rb]\n"); ##the above two lines are edited for imc by Rajesh. xdbg("script: message from [$fu ] chatroom000 [$ru ] msg [$rb]\n"); if(is_method("MESSAGE")) { log("MESSAGE received -> processing with imc\n"); sl_send_reply("200", "ok"); imc_manager(); exit; } else { sl_send_reply("404", "not found"); exit; }; } else { xdbg("script: message not for room, from [$fu ] r-uri [$ru] msg [$rb]\n"); if(!lookup("location")) { sl_send_reply("404", "not found"); exit; } t_relay(); #sl_send_reply("200", "ok"); exit(); }; #######The above lines were added for implementing imc #insert function tested below insert_hf("Test1"); # NAT detection route(4); if (has_totag()) { # sequential request withing a dialog should # take the path determined by record-routing if (loose_route()) { if (is_method("BYE")) { setflag(1); # do accounting ... setflag(3); # ... even if the transaction fails } route(1); } else { if (is_method("SUBSCRIBE") && uri == myself) { # in-dialog subscribe requests route(2); exit; } if ( is_method("ACK") ) { ## insert functioin tested below insert_hf("Test_in_ACK"); if ( t_check_trans() ) { # non loose-route, but stateful ACK; must be an ACK after a 487 or e.g. 404 from upstream server t_relay(); exit; } else { # ACK without matching transaction ... ignore and discard.\n"); exit; } } sl_send_reply("404","Not here"); } exit; } #initial requests # CANCEL processing if (is_method("CANCEL")) { if (t_check_trans()) t_relay(); exit; } t_check_trans(); # authentication route(3); # record routing if (!is_method("REGISTER|MESSAGE")) record_route(); # account only INVITEs if (is_method("INVITE")) { #insert_hf("To-username: test"); setflag(1); # do accounting } if (!uri==myself) /* replace with following line if multi-domain support is used */ ##if (!is_uri_host_local()) { append_hf("P-hint: outbound\r\n"); # if you have some interdomain connections via TLS ##if($rd=="tls_domain1.net") { ## t_relay("tls:domain1.net"); ## exit; ##} else if($rd=="tls_domain2.net") { ## t_relay("tls:domain2.net"); ## exit; ##} route(1); } # requests for my domain insert_hf ("Test2"); if( is_method("PUBLISH|SUBSCRIBE")) route(2); if (is_method("REGISTER")) { if (!save("location")) sl_reply_error(); exit; } if ($rU==NULL) { # request with no Username in RURI sl_send_reply("484","Address Incomplete"); exit; } # apply DB based aliases (uncomment to enable) ##alias_db_lookup("dbaliases"); if (!lookup("location")) { switch ($retcode) { case -1: case -3: t_newtran(); t_reply("404", "Not Found"); exit; case -2: sl_send_reply("405", "Method Not Allowed"); exit; } } # when routing via usrloc, log the missed calls also setflag(2); route(1); } ##insert function added below ##insert_hf ("Test4"); route[1] { ##insert function added below insert_hf ("Test5"); #n# if (check_route_param("nat=yes")) { #n# setbflag(6); #n# } #n# if (isflagset(5) || isbflagset(6)) { #n# route(5); #n# } /* example how to enable some additional event routes */ if (is_method("INVITE")) { insert_hf ("Test5"); ##tried insert function here. #t_on_branch("1"); ##tried here insert_hf("To-username: test"); t_on_reply("1"); t_on_failure("1"); } if (!t_relay()) { sl_reply_error(); } exit; } # Presence route /* uncomment the whole following route for enabling presence server */ route[2] { ##tried here for insert function. #insert_hf("Test_Presence"); #p# if (!t_newtran()) #p# { #p# sl_reply_error(); #p# exit; #p# }; #p# #p# if(is_method("PUBLISH")) #p# { #p# handle_publish(); #p# t_release(); #p# } #p# else #p# if( is_method("SUBSCRIBE")) #p# { #p# handle_subscribe(); #p# t_release(); #p# } #p# exit; # if presence enabled, this part will not be executed if (is_method("PUBLISH") || $rU==null) { sl_send_reply("404", "Not here"); exit; } return; } # Authentication route /* uncomment the whole following route for enabling authentication */ route[3] { if (is_method("REGISTER")) { # authenticate the REGISTER requests (uncomment to enable auth) if (!www_authorize("192.168.64.75", "subscriber")) { www_challenge("192.168.64.75", "0"); exit; } ###the following lines are uncommented if ($au!=$tU) { sl_send_reply("403","Forbidden auth ID"); exit; } } else { # authenticate if from local subscriber (uncomment to enable auth) if (from_uri==myself) { if (!proxy_authorize("", "subscriber")) { proxy_challenge("", "0"); exit; } if (is_method("PUBLISH")) { if ($au!=$tU) { sl_send_reply("403","Forbidden auth ID"); exit; } } else { if ($au!=$fU) { sl_send_reply("403","Forbidden auth ID"); exit; } } consume_credentials(); # caller authenticated } } return; } # Caller NAT detection route /* uncomment the whole following route for enabling Caller NAT Detection */ route[4]{ #n# force_rport(); #n# if (nat_uac_test("19")) { #n# if (method=="REGISTER") { #n# fix_nated_register(); #n# } else { #n# fix_nated_contact(); #n# } #n# setflag(5); #n# } return; } # RTPProxy control /* uncomment the whole following route for enabling RTPProxy Control */ route[5] { #n# if (is_method("BYE")) { #n# unforce_rtp_proxy(); #n# } else if (is_method("INVITE")){ #n# force_rtp_proxy(); #n# } #n# if (!has_totag()) add_rr_param(";nat=yes"); return; } branch_route[1] { xdbg("new branch at $ru\n"); } onreply_route[1] { xdbg("incoming reply\n"); #n# if ((isflagset(5) || isbflagset(6)) && status=~"(183)|(2[0-9][0-9])") { #n# force_rtp_proxy(); #n# } #n# if (isbflagset(6)) { #n# fix_nated_contact(); #n# } } failure_route[1] { #n# if (is_method("INVITE) #n# && (isbflagset(6) || isflagset(5))) { #n# unforce_rtp_proxy(); #n# } if (t_was_cancelled()) { exit; } # uncomment the following lines if you want to block client # redirect based on 3xx replies. ##if (t_check_status("3[0-9][0-9]")) { ##t_reply("404","Not found"); ## exit; ##} # uncomment the following lines if you want to redirect the failed # calls to a different new destination ##if (t_check_status("486|408")) { ## sethostport("192.168.2.100:5060"); ## append_branch(); ## # do not set the missed call flag again ## t_relay(); ##} } ************************************************************************************************************************************************** Daniel-Constantin Mierla wrote: Hello, have you created the db tables: kamdbctl create? Cheers, Daniel On 03.09.2009 11:44 Uhr, Rajesh wrote: Dear Team, Iam configuring imc for kamailio-1.5 and while iam trying to load the module, i get the following error .Kindly guide me with a solution ERROR:db_mysql:db_mysql_submit_query: driver error on query: Unknown column 'name' in 'field list' Sep 3 12:24:20 [18583] ERROR:core:db_do_query: error while submitting query Sep 3 12:24:20 [18583] ERROR:imc:add_from_db: failed to querry table Sep 3 12:24:20 [18583] ERROR:imc:mod_init: failed to get information from db Sep 3 12:24:20 [18583] ERROR:core:init_mod: failed to initialize module imc Sep 3 12:24:20 [18583] ERROR:core:main: error while initializing modules --