I apologize, I copy n' paste the wrong config file to my email.

Below my signature is the correct openser.cfg with the load of mysql.so and the db_mode set.

It does crash openser. But this time I managed to have some more indication in the log file:
[...]
Apr 16 15:00:41 vpngw /usr/local/sbin/openser[27620]: CRITICAL:core:receive_fd: EOF on 11
Apr 16 15:00:41 vpngw /usr/local/sbin/openser[27582]: INFO:core:handle_sigs: child process 27586 exited by a signal 4
Apr 16 15:00:41 vpngw /usr/local/sbin/openser[27582]: INFO:core:handle_sigs: core was generated
Apr 16 15:00:41 vpngw /usr/local/sbin/openser[27582]: INFO:core:handle_sigs: terminating due to SIGCHLD
Apr 16 15:00:41 vpngw /usr/local/sbin/openser[27606]: INFO:core:sig_usr: signal 15 received
Apr 16 15:00:41 vpngw /usr/local/sbin/openser[27609]: INFO:core:sig_usr: signal 15 received
Apr 16 15:00:41 vpngw /usr/local/sbin/openser[27617]: INFO:core:sig_usr: signal 15 received
Apr 16 15:00:41 vpngw /usr/local/sbin/openser[27620]: INFO:core:sig_usr: signal 15 received
Apr 16 15:00:41 vpngw /usr/local/sbin/openser[27615]: INFO:core:sig_usr: signal 15 received
Apr 16 15:00:41 vpngw /usr/local/sbin/openser[27613]: INFO:core:sig_usr: signal 15 received
Apr 16 15:00:41 vpngw /usr/local/sbin/openser[27588]: INFO:core:sig_usr: signal 15 received
Apr 16 15:00:41 vpngw /usr/local/sbin/openser[27590]: INFO:core:sig_usr: signal 15 received
Apr 16 15:00:41 vpngw /usr/local/sbin/openser[27596]: INFO:core:sig_usr: signal 15 received
Apr 16 15:00:41 vpngw /usr/local/sbin/openser[27611]: INFO:core:sig_usr: signal 15 received
Apr 16 15:00:41 vpngw /usr/local/sbin/openser[27592]: INFO:core:sig_usr: signal 15 received
Apr 16 15:00:41 vpngw /usr/local/sbin/openser[27598]: INFO:core:sig_usr: signal 15 received
Apr 16 15:00:41 vpngw /usr/local/sbin/openser[27600]: INFO:core:sig_usr: signal 15 received
Apr 16 15:00:41 vpngw /usr/local/sbin/openser[27602]: INFO:core:sig_usr: signal 15 received
Apr 16 15:00:41 vpngw /usr/local/sbin/openser[27604]: INFO:core:sig_usr: signal 15 received
Apr 16 15:00:41 vpngw /usr/local/sbin/openser[27594]: INFO:core:sig_usr: signal 15 received
Apr 16 15:00:41 vpngw /usr/local/sbin/openser[27595]: INFO:core:sig_usr: signal 15 received
Apr 16 15:00:41 vpngw /usr/local/sbin/openser[27619]: INFO:core:sig_usr: signal 15 received

Regards,
Pascal


#
# $Id: openser.cfg 3542 2008-01-16 15:00:34Z miconda $
#
# OpenSER basic configuration script
#     by Anca Vamanu <anca@voice-system.ro>
#
# Please refer to the Core CookBook at http://www.openser.org/dokuwiki/doku.php
# for a explanation of possible statements, functions and parameters.
#


####### Global Parameters #########

debug=3
log_stderror=no
log_facility=LOG_LOCAL0

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/openser/tls/user/user-cert.pem"
#tls_private_key = "/usr/local/etc/openser/tls/user/user-privkey.pem"
#tls_ca_list = "/usr/local/etc/openser/tls/user/user-calist.pem"


port=5060

/* uncomment and configure the following line if you want openser to
   bind on a specific interface/port/proto (default bind on all available) */
#listen=udp:192.168.1.2:5060

alias=ptt.domain.net

####### Modules Section ########

#set module path
mpath="/usr/local/lib/openser/modules/"

/* uncomment next line for MySQL DB support */
loadmodule "mysql.so"
loadmodule "sl.so"
loadmodule "tm.so"
loadmodule "rr.so"
loadmodule "maxfwd.so"
loadmodule "usrloc.so"
loadmodule "registrar.so"
loadmodule "textops.so"
loadmodule "mi_fifo.so"
loadmodule "uri_db.so"
loadmodule "uri.so"
loadmodule "xlog.so"
loadmodule "acc.so"
/* uncomment next lines for MySQL based authentication support
   NOTE: a DB (like mysql) module must be also loaded */
#loadmodule "auth.so"
#loadmodule "auth_db.so"
/* uncomment next line for aliases support
   NOTE: a DB (like mysql) module must be also loaded */
#loadmodule "alias_db.so"
/* uncomment next line for multi-domain support
   NOTE: a DB (like mysql) module must be also loaded
   NOTE: be sure and enable multi-domain support in all used modules
         (see "multi-module params" section ) */
#loadmodule "domain.so"
/* uncomment the next two lines for presence server support
   NOTE: a DB (like mysql) module must be also loaded */
#loadmodule "presence.so"
#loadmodule "presence_xml.so"


# ----------------- 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)
/* uncomment the following lines to enable DB accounting also */
modparam("acc", "db_flag", 1)
modparam("acc", "db_missed_flag", 2)


# ----- usrloc params -----
#modparam("usrloc", "db_mode",   0)
modparam("usrloc", "db_mode",   1)
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@192.168.1.3/openser_1_3")
#modparam("auth_db", "load_credentials", "")


# ----- alias_db params -----
/* uncomment the following lines if you want to enable the DB based
   aliases */
#modparam("alias_db", "db_url",
#    "mysql://openser:openserrw@192.168.1.3/openser_1_3")


# ----- domain params -----
/* uncomment the following lines to enable multi-domain detection
   support */
#modparam("domain", "db_url",
#    "mysql://openser:openserrw@192.168.1.3/openser_1_3")
#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@192.168.1.3/openser_1_3")
#modparam("presence_xml", "force_active", 1)
#modparam("presence", "server_address", "sip:192.168.1.2:5060")


####### Routing Logic ########


# main request routing logic

route{

    if (!mf_process_maxfwd_header("10")) {
        sl_send_reply("483","Too Many Hops");
        exit;
    }

    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 accouting ...
                setflag(3); # ... even if the transaction fails
            }
            route(1);
        } else {
            /* uncomment the following lines if you want to enable presence */
            ##if (is_method("SUBSCRIBE") && $rd == "your.server.ip.address") {
            ##    # in-dialog subscribe requests
            ##    route(2);
            ##    exit;
            ##}
            if ( is_method("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();

    # authenticate if from local subscriber (uncomment to enable auth)
    ##if (!(method=="REGISTER") && from_uri==myself)
    ##{
    ##    if (!proxy_authorize("", "subscriber")) {
    ##        proxy_challenge("", "0");
    ##        exit;
    ##    }
    ##    if (!check_from()) {
    ##        sl_send_reply("403","Forbidden auth ID");
    ##        exit;
    ##    }
    ##
    ##    consume_credentials();
    ##    # caller authenticated
    ##}

    # record routing
    if (!is_method("REGISTER|MESSAGE"))
        record_route();

    # account only INVITEs
    if (is_method("INVITE")) {
        setflag(1); # do accouting
    }
    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

    /* uncomment this if you want to enable presence server
       and comment the next 'if' block
       NOTE: uncomment also the definition of route[2] from  below */
    ##if( is_method("PUBLISH|SUBSCRIBE"))
    ##        route(2);

    if (is_method("PUBLISH"))
    {
        sl_send_reply("503", "Service Unavailable");
        exit;
    }
   

    if (is_method("REGISTER"))
    {
        # authenticate the REGISTER requests (uncomment to enable auth)
        ##if (!www_authorize("", "subscriber"))
        ##{
        ##    www_challenge("", "0");
        ##    exit;
        ##}
        ##
        ##if (!check_to())
        ##{
        ##    sl_send_reply("403","Forbidden auth ID");
        ##    exit;
        ##}

        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);
}


route[1] {
  xlog("L_WARN", "Routing block 1. Method [$rm], request URI [$ru]\n");

    # send it out now; use stateful forwarding as it works reliably
    # even for UDP2TCP
    if (!t_relay()) {
        sl_reply_error();
    };
    exit;

}


# Presence route
/* uncomment the whole following route for enabling presence
   NOTE: do not forget to enable the call of this route from the main
     route */
##route[2]
##{
##    if (!t_newtran())
##    {
##        sl_reply_error();
##        exit;
##    };
##
##    if(is_method("PUBLISH"))
##    {
##        handle_publish();
##        t_release();
##    }
##    else
##    if( is_method("SUBSCRIBE"))
##    {
##        handle_subscribe();
##        t_release();
##    }
##
##    exit;
##}


branch_route[2] {
    xlog("new branch at $ru\n");
}


onreply_route[2] {
    xlog("incoming reply\n");
}


failure_route[1] {
    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();
    ##}
}


On Wed, Apr 16, 2008 at 2:01 PM, Henning Westerholt <henning.westerholt@1und1.de> wrote:
On Wednesday 16 April 2008, Pascal Maugeri wrote:
> I've got a weird problem I do not manage to solve alone.
>
> I'm using v1.3.0 with mysql.so and and usrloc.so, on redhat enterprise v4.
>
> When there is a permanent user location in the database (added previously
> with openserctl ul add), the server does not start:
> - there is no log about any error,
> - after starting the server, there is no running openser process
>
> Is it a server bug or should I activate/configure something else ?
>
> Below my signature is my configuration file.

Hi Pascal,

looking to the config file it seems that you don't load the database driver at
all. Perhaps you commented this out for debugging? Without a database driver
the usrloc module will not load if you specify a db_mode that needs a db
connection.

Cheers,

Henning