[Serusers] problem with module acc
Jan Janak
jan at iptel.org
Mon Oct 18 11:45:30 CEST 2004
Increate the maximum number of connections in my.cnf (the configuration
file of mysql ).
Jan.
On 18-10 10:28, Marian Danisek wrote:
>
> hello,
>
> i have ser version 0.8.14. Everything working fine, but i want to use
> accounting with mysql, so i recompile ser a and acc module with
> DEFS+=-DSQL_ACC
>
> now ser crash everytime a try to start it, following messagess apears in
> log :
>
> Oct 18 10:19:51 mdk10 ser: Listening on
> Oct 18 10:19:51 mdk10 ser: 127.0.0.1 [127.0.0.1]:5060
> Oct 18 10:19:51 mdk10 ser: 192.168.1.250 [192.168.1.250]:5060
> Oct 18 10:19:51 mdk10 ser: Aliases: mdk10:5060 localhost:5060
> sunteq.sk:* mdk10.sunteq.sk:*
> Oct 18 10:19:51 mdk10 ser: ser startup succeeded
> Oct 18 10:19:51 mdk10 /sbin/ser[9609]: connect_db(): Too many connections
> Oct 18 10:19:51 mdk10 /sbin/ser[9609]: db_init(): Error while trying to
> connect database
> Oct 18 10:19:51 mdk10 /sbin/ser[9609]: group:init_child(): Unable to
> connect database
> Oct 18 10:19:51 mdk10 /sbin/ser[9609]: init_mod_child(): Error while
> initializing module group
> Oct 18 10:19:51 mdk10 /sbin/ser[9609]: init_children failed
>
> anybody could help, please ?
>
> below is my ser config file
>
>
> #
> # $Id: ser.cfg,v 1.21.4.1 2003/11/10 15:35:15 andrei Exp $
> #
> # simple quick-start config script
> #
>
> # ----------- global configuration parameters ------------------------
>
> #debug=3 # debug level (cmd line: -dddddddddd)
> #fork=yes
> #log_stderror=no # (cmd line: -E)
>
> /* Uncomment these lines to enter debugging mode
> debug=7
> fork=no
> log_stderror=yes
> */
> alias=mdk10.sunteq.sk
> alias=sunteq.sk
> #alias=atlas.sunteq.sk
>
>
> check_via=no # (cmd. line: -v)
> dns=no # (cmd. line: -r)
> rev_dns=no # (cmd. line: -R)
> #port=5060
> #children=4
> fifo="/tmp/ser_fifo"
>
> # ------------------ module loading ----------------------------------
>
> # Uncomment this if you want to use SQL database
> loadmodule "/lib/ser/modules/mysql.so"
>
> loadmodule "/lib/ser/modules/sl.so"
> loadmodule "/lib/ser/modules/tm.so"
> loadmodule "/lib/ser/modules/rr.so"
> loadmodule "/lib/ser/modules/maxfwd.so"
> loadmodule "/lib/ser/modules/usrloc.so"
> loadmodule "/lib/ser/modules/registrar.so"
> loadmodule "/lib/ser/modules/textops.so"
>
> # Uncomment this if you want digest authentication
> # mysql.so must be loaded !
> loadmodule "/lib/ser/modules/auth.so"
> loadmodule "/lib/ser/modules/auth_db.so"
>
> # load the voicemail module
> #loadmodule "/lib/ser/modules/vm.so"
>
> # load the enum module
> loadmodule "/lib/ser/modules/enum.so"
>
> # load the group module, to verify if a user forwards to voicemail
> loadmodule "/lib/ser/modules/group.so"
>
> # load the nathelper module
> loadmodule "/lib/ser/modules/nathelper.so"
> loadmodule "/lib/ser/modules/acc.so"
>
> # ----------------- setting module-specific parameters ---------------
>
> # -- registrar parameter
> # special NAT flag indicates that a registered client is behind NAT
> modparam("registrar", "nat_flag", 6)
>
> # -- usrloc params --
>
> #modparam("usrloc", "db_mode", 0)
>
> # Uncomment this if you want to use SQL database
> # for persistent storage and comment the previous line
> modparam("usrloc", "db_mode", 2)
> #modparam("usrloc", "db_url", "mysql://ser:heslo@localhost/ser")
> modparam("usrloc|auth_db|acc|group|msilo|uri","db_url","mysql://ser:heslo@localhost/ser")
>
> # -- auth params --
> # Uncomment if you are using auth module
> #
> modparam("auth_db", "calculate_ha1", yes)
> #
> # If you set "calculate_ha1" parameter to yes (which true in this config),
> # uncomment also the following parameter)
> #
> modparam("auth_db", "password_column", "password")
> #modparam("auth_db", "db_url", "mysql://ser:heslo@localhost/ser")
>
> # -- rr params --
> # add value to ;lr param to make some broken UAs happy
> modparam("rr", "enable_full_lr", 1)
>
> # -- voicemail params --
> #modparam("voicemail", "db_url","mysql://ser:heslo@localhost/ser")
>
> # -- voicemail params --
> #modparam("group", "db_url","mysql://serro:heslo@localhost/ser")
>
> # -- nathelper params --
> modparam("nathelper", "natping_interval", 60)
> modparam("nathelper", "ping_nated_only", 1)
>
> modparam("tm", "fr_inv_timer", 30 )
> #modparam("tm", "fr_inv_timer", 8 )
>
>
>
> # ------------------------- request routing logic -------------------
>
> # main routing logic
>
> route{
>
> log(1, "-------------------------------------------\n");
> log(1, "entering main loop\n");
>
> if (nat_uac_test("2")) {
> log(1, "src address different than via header->NAT
> detected\n");
> log(1, "force_rport and fix_nated_contact and
> setflag(5)\n");
> #try NAT traversal, works only if the client is symmetrical
> force_rport();
> fix_nated_contact();
> append_hf("P-hint: fixed NAT contact for request\r\n");
> # flag 5 indicates that incoming request is from NATed
> client
> setflag(5);
> };
>
> if (method=="REGISTER")
> log(1, "REGISTER message received\n");
>
> if (method=="INVITE")
> log(1, "INVITE message received\n");
>
> if (method=="ACK")
> log(1, "ACK message received\n");
>
> if (method=="BYE")
> log(1, "BYE message received\n");
>
> if (method=="CANCEL")
> log(1, "CANCEL message received\n");
>
> if (method=="SUBSCRIBE")
> log(1, "SUBSCRIBE message received\n");
>
> if (method=="NOTIFY")
> log(1, "NOTIFY message received\n");
>
> if (method=="OPTIONS")
> log(1, "OPTIONS message received\n");
>
> if (method=="INFO")
> log(1, "INFO message received\n");
>
> if (method=="MESSAGE")
> log(1, "MESSAGE message received\n");
>
> if (method=="REFER")
> log(1, "REFER message received\n");
>
>
> # initial sanity checks -- messages with
> # max_forwards==0, or excessively long requests
> if (!mf_process_maxfwd_header("10")) {
> sl_send_reply("483","Too Many Hops");
> break;
> };
>
> if (msg:len > max_len) {
> #if (len_gt( max_len )) {
> sl_send_reply("513", "Message too big");
> break;
> };
>
> # loose-route processing
> if (loose_route()) {
> log(1, "loose_route processing\n");
> t_relay();
> break;
> };
>
> # Check for PSTN access
> if (uri=~"^sip:0[0-9]*@.*") {
> route(3);
> break;
> };
>
>
> # if the request is for other domain use UsrLoc
> # (in case, it does not work, use the following command
> # with proper names and addresses in it)
> if (uri==myself) {
>
> if (method=="REGISTER") {
> log(1, "analyzing REGISTER request\n");
> # Uncomment this if you want to use digest authentication
> if (!www_authorize("mdk10.sunteq.sk",
> "subscriber")) {
> www_challenge("mdk10.sunteq.sk", "0");
> break;
> };
>
> if (isflagset(5)) {
> #register from nated client, save
> nat_flag=6
> #in location table
> setflag(6);
> };
> if (!save("location")) {
> log(1, "save location error\n");
> sl_reply_error();
> };
> break;
> };
>
> lookup("aliases");
>
> #mark transaction for voicemail
> if (is_user_in("Request-URI", "voicemail\n")) {
> log(1, "requested user is in voicemail group");
> setflag(4);
> };
>
> # Process Aliases
> lookup("aliases");
>
>
> # native SIP destinations are handled using our USRLOC DB
> if (!lookup("location")) {
> # handle user which was not found
> log(1, "requested user not found\n");
> route(4);
> break;
> };
> };
>
> #add failure route which should be performed if response code >=300
> if (method=="INVITE" && isflagset(4)) {
> log(1, "invite for voicemail user->initiate
> failureroute[1]\n");
> t_on_failure("1");
> };
>
> # forward to current uri now; use stateful forwarding; that
> # works reliably even if we forward from TCP to UDP
>
> route(1);
> }
>
> route[1]{
> log(1, "-------------------------------------------\n");
> log(1, "entering route[1] - relaying SIP message\n");
> if ((isflagset(5)) || (isflagset(6))) {
> log(1, "at least one of the participants is
> NATed->record_route\n");
> record_route();
> log(1, " -->setting up reply processing
> ->onreply_route[1]");
> t_on_reply("1");
> if (method=="INVITE") {
> log(1, " INVITE request-->force_rtp_proxy,
> set NATED-INVITE flag(7)");
> force_rtp_proxy();
> append_hf("P-hint: request forced to rtp
> proxy\r\n");
> setflag(7);
> };
> };
>
> log(1, "relaying message ...\n");
> if (!t_relay()) {
> log(1, "t_relay error occured\n");
> sl_reply_error();
> };
>
> }
>
> # all incoming replies for t_onrepli-ed transactions enter here
> onreply_route[1] {
> log(1, "-------------------------------------------\n");
> log(1, "onreply_route[1] entered\n");
>
> if (isflagset(6)) {
> log(1, "transaction was sent to a NATED client -> fix
> nated contact\n");
> fix_nated_contact();
> append_hf("P-hint: fixed NAT contact for response\r\n");
> }
>
> if ( (status=~"100") ) {
> log(1, "status 100 received\n");
> };
>
> if ( (status=~"180") ) {
> log(1, "status 180 received\n");
> };
>
> if ( (status=~"202") ) {
> log(1, "status 202 received\n");
> };
>
> if ( (status=~"200" || status=~"183") ) {
> log(1, "status 2xx or 183");
> if ( isflagset(7) ) {
> log(1, "marked(7) as NATED-INVITE ->
> force_rtp_proxy \n");
> force_rtp_proxy();
> append_hf("P-hint: response forced to rtp
> proxy\r\n");
> };
> };
> }
>
> route[3] {
> if (method=="INVITE" && (!src_ip==192.168.1.253)) {
> if (!proxy_authorize( "mdk10.sunteq.sk","subscriber")) {
> proxy_challenge( "mdk10.sunteq.sk", "0");
> break;
> };
> # let's check from=id ... avoids accounting confusion
>
> if(!is_user_in("credentials", "local")) {
> sl_send_reply("403", "NO PSTN Privileges...");
> break;
> };
> consume_credentials();
>
> }; # INVITE to authorized PSTN
>
> # if you have passed through all the checks, let your call go to GW!
> force_rtp_proxy();
> record_route();
> t_on_reply("1");
> # snom conditioner
> if (method=="INVITE" && search("User-Agent: snom")) {
> replace("100rel, ", "");
> };
>
> append_hf("P-hint: GATEWAY\r\n");
> # use UDP to guarantee well-known sender port (TCP ephemeral)
> t_relay_to_udp("192.168.1.253","5060");
> }
>
>
> route[4]{
> log(1, "-------------------------------------------\n");
> log(1, "entering route[4] = requested user not online\n");
> # non-Voip -- just send "off-line"
> if (!(method == "INVITE" || method == "ACK" || method ==
> "CANCEL" || method == "REFER" || method == "BYE")) {
> log(1, "no invite,ack,cancel,refer->return 404\n");
> sl_send_reply("404", "Not Found");
> break;
> };
>
> # not voicemail subscriber and no echo/conference call
> if ( isflagset(4)) {
> log(1, "flag(4) active\n");
> };
> if (uri =~ "conference") {
> log(1, "conference call\n");
> };
> if (uri =~ "echo") {
> log(1, "echo call\n");
> };
> if ( !( isflagset(4) || (uri =~ "conference") || (uri =~
> "echo") ) ) {
> log(1, "no voicemail subscriber->return 404");
> sl_send_reply("404", "Not Found and no voicemail turned
> on");
> break;
> };
>
> if ( isflagset(5) ) {
> log(1, "caller is NATed->record_route\n");
> record_route();
> log(1, " -->setting up reply processing
> ->onreply_route[1]");
> t_on_reply("1");
> if (method=="INVITE") {
> log(1, " INVITE request-->force_rtp_proxy");
> force_rtp_proxy();
> };
> };
>
> # forward to voicemail now
> rewritehostport("192.168.1.253:5060");
> log(1, "forward to voicemail\n");
> t_relay_to_udp("192.168.1.253", "5060");
>
> }
>
> failure_route[1] {
> /* XX: note: unsafe if preloaded routes without username used */
> log(1, "-------------------------------------------\n");
> log(1, "failureroute[1] entered\");
> revert_uri();
> rewritehostport("212.17.35.184:5060");
> append_branch();
> t_relay_to_udp("212.17.35.184", "5060");
>
> _______________________________________________
> Serusers mailing list
> serusers at lists.iptel.org
> http://lists.iptel.org/mailman/listinfo/serusers
More information about the sr-users
mailing list