[Serusers] mySQL

[Gary Goodloff]

I finnaly have this thing in and running. I can make a call to another
person on the same server. But it appears that it is not checking a
password.  I have everything configured the way all the how-to's say for
mysql authentication - but I am at a loss.
 
Also  it does not appear to be supporting accounting (missed calls).
 
Can anyone help?
 
Here is my ser.cfg file.
 
#
# $Id: ser.cfg,v 1.12 2002/10/21 02:40:06 jiri Exp $
#
# simple quick-start config script
#
 
# ----------- global configuration parameters ------------------------
 
debug=3          # debug level (cmd line: -dddddddddd)
fork=yes
log_stderror=yes        # (cmd line: -E)
check_via=no    # (cmd. line: -v)
dns=yes           # (cmd. line: -r)
rev_dns=yes      # (cmd. line: -R)
port=5060
children=4
fifo="/tmp/ser_fifo"
 
# ------------------ module loading ----------------------------------
 
# Uncomment this if you want to use SQL database
loadmodule "/usr/local/lib/ser/modules/mysql.so"
 
loadmodule "/usr/local/lib/ser/modules/sl.so"
loadmodule "/usr/local/lib/ser/modules/tm.so"
loadmodule "/usr/local/lib/ser/modules/rr.so"
loadmodule "/usr/local/lib/ser/modules/maxfwd.so"
loadmodule "/usr/local/lib/ser/modules/usrloc.so"
loadmodule "/usr/local/lib/ser/modules/registrar.so"
 
# Uncomment this if you want digest authentication
# mysql.so must be loaded !
loadmodule "/usr/local/lib/ser/modules/auth.so"
 
# ----------------- setting module-specific parameters ---------------
 
# -- 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", 1)
 
# -- auth params --
                                                           [ Read 105
lines ]
 
root: /www/kalgonline/ser % cat/usr/local/etc/ser/ser.cfg
cat/usr/local/etc/ser/ser.cfg: Command not found.
root: /www/kalgonline/ser % cat /usr/local/etc/ser/ser.cfg
#
# $Id: ser.cfg,v 1.12 2002/10/21 02:40:06 jiri Exp $
#
# simple quick-start config script
#
 
# ----------- global configuration parameters ------------------------
 
debug=3          # debug level (cmd line: -dddddddddd)
fork=yes
log_stderror=yes        # (cmd line: -E)
check_via=no    # (cmd. line: -v)
dns=yes           # (cmd. line: -r)
rev_dns=yes      # (cmd. line: -R)
port=5060
children=4
fifo="/tmp/ser_fifo"
 
# ------------------ module loading ----------------------------------
 
# Uncomment this if you want to use SQL database
loadmodule "/usr/local/lib/ser/modules/mysql.so"
 
loadmodule "/usr/local/lib/ser/modules/sl.so"
loadmodule "/usr/local/lib/ser/modules/tm.so"
loadmodule "/usr/local/lib/ser/modules/rr.so"
loadmodule "/usr/local/lib/ser/modules/maxfwd.so"
loadmodule "/usr/local/lib/ser/modules/usrloc.so"
loadmodule "/usr/local/lib/ser/modules/registrar.so"
 
# Uncomment this if you want digest authentication
# mysql.so must be loaded !
loadmodule "/usr/local/lib/ser/modules/auth.so"
 
# ----------------- setting module-specific parameters ---------------
 
# -- 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", 1)
 
# -- auth params --
# Uncomment if you are using auth module
#
modparam("auth", "secret", "alsdkhglaksdhfkloiwr")
modparam("auth", "calculate_ha1", yes)
#
# If you set "calculate_ha1" parameter to yes (which true in this
config),
# uncomment also the following parameter)
#
modparam("auth", "password_column", "password")
 
# -------------------------  request routing logic -------------------
 
# main routing logic
 
route{
 
        # initial sanity checks -- messages with
        # max_forwars==0, or excessively long requests
        if (!mf_process_maxfwd_header("10")) {
                sl_send_reply("483","Too Many Hops");
                break;
        };
        if (len_gt( max_len )) {
                sl_send_reply("513", "Message too big");
                break;
        };
 
        # Do strict routing if pre-loaded route headers present
        rewriteFromRoute();
 
        # 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=="kalg.net") {
 
                if (method=="REGISTER") {
 
# Uncomment this if you want to use digest authentication
                        if (!www_authorize("kalg.net", "subscriber")) {
                                www_challenge("kalg.net", "0");
                                break;
                        };
 
                        save("location");
                        break;
                };
 
                # native SIP destinations are handled using our USRLOC
DB
                if (!lookup("location")) {
                        sl_send_reply("404", "Not Found");
                        break;
                };
        };
        # forward to current uri now
        if (!t_relay()) {
                sl_reply_error();
        };
 
}
 
Gary Goodloff
KALG Communications / Nebraska Classifieds
T: 402-898-4152
C: 402-208-5183
F: 413-294-3404
 
 
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sip-router.org/pipermail/sr-users/attachments/20030507/8260cf36/attachment.htm>