[Serusers] Mysql Database cant get connect on authentication part.
Felipe Martins
fmartins at mundivox.com
Fri Jan 14 13:25:13 CET 2005
Hi Sun,
Is your mysql running ? If it's running, are all the tables (ser and mysql) created ? If everything works fine, by loging on to mysql, can you consult it ???
Thats is how my ser.cfg is confugured today, with mysql running. Any doubt let us know ...
--------------------- ser.cfg ------------------------
#
# $Id: ser.cfg,v 1.21.4.1 2003/11/10 15:35:15 andrei Exp $
#
# simple quick-start config script
#
# ----------- global configuration parameters ------------------------
# Uncomment these lines to enter debugging mode
debug=9
fork=yes
log_stderror=no
listen=192.168.4.10
port=5060
# hostname matching an alias will satisfy the condition "uri==myself".
alias="mundivox.com"
alias="sipserver.com"
# sip_warning - Should replies include extensive warnings? By default
# yes, it is good for trouble-shooting
#sip_warnings=yes
# server_signature - Should locally-generated messages include server's
# signature? By default yes, it is good for trouble-shooting.
# server_signature=yes
# reply_to_via - A hint reply modules whether they should send reply
# to IP advertised in Via. Turned off by default, which means that
# replies are sent to IP address from which requests came.
# reply_to_via=no
# mhomed -- enable calculation of outbound interface; useful on
# multihomed servers.
# mhomed=0
check_via=no # (cmd. line: -v)
dns=no # (cmd. line: -r)
rev_dns=no # (cmd. line: -R)
children=4
fifo_mode=0666
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"
loadmodule "/usr/local/lib/ser/modules/domain.so"
loadmodule "/usr/local/lib/ser/modules/acc.so"
loadmodule "/usr/local/lib/ser/modules/textops.so"
loadmodule "/usr/local/lib/ser/modules/uri.so"
loadmodule "/usr/local/lib/ser/modules/group.so"
loadmodule "/usr/local/lib/ser/modules/msilo.so"
loadmodule "/usr/local/lib/ser/modules/enum.so"
loadmodule "/usr/local/lib/ser/modules/nathelper.so"
# Uncomment this if you want digest authentication
# mysql.so must be loaded !
loadmodule "/usr/local/lib/ser/modules/auth.so"
loadmodule "/usr/local/lib/ser/modules/auth_db.so"
# ----------------- setting module-specific parameters ---------------
# -- usrloc params --
# 0 = disable
# 1 = write-through
# 2 = write-back
# MySQL Based User Authentication
modparam("auth_db", "db_url", "sql://ser:heslo@localhost/ser")
# Checking for Username Column
#modparam("auth_db", "user_column", "username")
# Checking for Domain Column
#modparam("auth_db", "domain_column", "domain")
# Checking for Password Column
modparam("auth_db", "password_column", "password")
# Uncomment this if you want to use SQL database
# for persistent storage and comment the previous line
modparam("usrloc", "db_mode", 2)
modparam("usrloc", "timer_interval", 60)
modparam("usrloc", "desc_time_order", 1)
# ----- Acc Params ------
modparam("acc", "log_level", 1)
modparam("acc", "log_flag", 1)
# ----- auth params -----
# Uncomment if you are using auth module
# Permite tambem clear text passwords no mysql
modparam("auth_db", "calculate_ha1", yes)
#
# If you set "calculate_ha1" parameter to yes (which true in this config),
# uncomment also the following parameter)
#
# ------ rr params ------
# add value to ;lr param to make some broken UAs happy
modparam("rr", "enable_full_lr", 1)
# ------------------------- request routing logic -------------------
# main routing logic
route {
# ----------------------------------------------------------------------------
# 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 ) {
sl_send_reply("513", "Message too big");
break;
};
# ------------------------------------------------------------
# OPTIONS Section
#
# This is used by sipsak to monitor the heath of our sip proxy
#-------------------------------------------------------------
# if (search("^From: sip:sipsak@") &&
# (method=="OPTIONS") && (!uri=~"sip:.*[@]+.*")) {
# options_reply();
# break;
# };
# ------------------------------------------------------------
# Registration Section
# ------------------------------------------------------------
# if (method=="REGISTER") {
#
# if (!is_from_local()) {
#
# sl_send_reply("403", "Unknown Domain");
# break;
# };
#
# if (is_user_in("Request-URI", "disabled")) {
#
# sl_send_reply("403", "Your evaluation period has expired");
# break;
# };
#
# if (!www_authorize("", "subscriber")) {
#
# www_challeng("", "0");
# break;
# };
#
# if (!check_to()) {
#
# sl_send_reply("401", "Unauthorized");
# break;
# };
#
# if (!save("location")) {
#
# sl_reply_error();
# };
#
# break;
#
# };
# -----------------------------------------------------------------
# Open Relay Section
# -----------------------------------------------------------------
# if (method=="INVITE") {
#
# if (!(is_from_local() || is_uri_host_local())) {
# sl_send_reply("403", "Please register to use our service");
# break;
# };
# };
# -----------------------------------------------------------------
# Accounting Section
# -----------------------------------------------------------------
# if (method=="INVITE" || method=="BYE") {
# setflag(1);
# };
# -----------------------------------------------------------------
# Record Route Section
#
# we record-route all messages -- to make sure that subsequent messages
# will go through our proxy; that's particularly good if upstream and
# donwstream entities use different transport protocol
# -----------------------------------------------------------------
# if (method=="INVITE") record_route();
# -----------------------------------------------------------------
# Loose Route Section
#
# Grant route routing if route headers present
# -----------------------------------------------------------------
if (loose_route()) {
route(2);
break;
};
# -----------------------------------------------------------------
# Alias Routing Section
# -----------------------------------------------------------------
lookup("aliases");
if (!uri==myself) {
route(2);
break;
};
# we record-route all messages -- to make sure that
# subsequent messages will go through our proxy; that's
# particularly good if upstream and downstream entities
# use different transport protocol
record_route();
# loose-route processing
if (loose_route()) {
t_relay();
break;
};
# Rota usada para guardar Logs no CDRTool - Billing
# if (method=="REGISTER" || method=="INVITE" || method=="BYE" || method=="CANCEL") {
# # Salvar mensagens no myslq para o CDRTool
# exec_msg("/var/www/html/serweb/sertrace.py; exit 1");
# };
# 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)
# uri==myself retorna true se o nome de dominio URI for igual ao nome do
# host ao qual SER esta rodando. Para configurar quais domain names o ser
# aceita, deve-se configurar os ALIASES do sistema para tais nomes.
if (uri==myself) {
if (method=="REGISTER") {
# Uncomment this if you want to use digest authentication
if (!www_authorize("192.168.4.10", "subscriber")) {
www_challenge("192.168.4.10", "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; use stateful forwarding; that
# works reliably even if we forward from TCP to UDP
if (!t_relay()) {
sl_reply_error();
};
}
---------------------------- end -------------------------------------
On Fri, 14 Jan 2005 15:13:42 +0800
"Sun Shung" <lsshung at hotmail.com> wrote:
> Hi,
>
> When i tried to start the SER its keep on giving me error on db_init():
> Can't connect to database. Is it anything to do with this command
> modparam("usrloc", "db_url", "sql://ser:heslo@localhost/ser")
>
> Thanx
>
> _________________________________________________________________
> Get an advanced look at the new version of MSN Messenger.
> http://messenger.msn.com.my/Beta/Default.aspx
>
> _______________________________________________
> Serusers mailing list
> serusers at lists.iptel.org
> http://lists.iptel.org/mailman/listinfo/serusers
>
--
Felipe Martins
Linux System Administrator
Tep Solution Provider
Mundivox Communications
Rua Lauro Muller, 116/Sala 505
RJ - Brasil - 22290-906
Tel.: 55 21 3820-8839
Fax.: 55 21 3820-8844
More information about the sr-users
mailing list