[Serusers] Errors during startup
Ronald Wiplinger
ronald at elmit.com
Thu Sep 29 15:25:14 CEST 2005
Sep 29 19:44:11 dns ser: WARNING: fix_socket_list: could not rev.
resolve 192.168.0.254
Sep 29 19:44:11 dns ser: WARNING: fix_socket_list: could not rev.
resolve 192.168.0.254
Sep 29 19:44:11 dns /usr/local/sbin/ser[19346]: Maxfwd module- initializing
Sep 29 19:44:11 dns /usr/local/sbin/ser[19346]: new_connection(): Access
denied for user: 'serro at localhost' (Using password: YES)
Sep 29 19:44:11 dns /usr/local/sbin/ser[19346]: db_init(): Could not
create a connection
Sep 29 19:44:11 dns /usr/local/sbin/ser[19346]: ERROR: auth_db_ver:
unable to open database connection
Sep 29 19:44:11 dns /usr/local/sbin/ser[19346]: auth_db:str_fixup():
Error while querying table version
Sep 29 19:44:11 dns /usr/local/sbin/ser[19346]: ERROR: fix_expr :
fix_actions error
Q:
1. Where do the Warning 192.168.0.254 come from? My network does not use
192.168.0.x
2. Access denied is most likely the error for all following errors. Note
the quote marks, they are around the entire name and not
'serro'@'localhost' I am not sure if that makes a difference.
The access to the database is for me not clear in the moment. We have a
user ser with password serpassword and a user serro with password
serropassword. We have also admin with the password adminpassword.
I don't find the user/passwords in the config files.
My ser.cfg looks like that:
grep -v ^[$,#] ser.cfg
/* Uncomment these lines to enter debugging mode
fork=no
log_stderror=yes
*/
check_via=no # (cmd. line: -v)
dns=no # (cmd. line: -r)
rev_dns=no # (cmd. line: -R)
fifo="/tmp/ser_fifo"
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/textops.so"
loadmodule "/usr/local/lib/ser/modules/auth.so"
loadmodule "/usr/local/lib/ser/modules/auth_db.so"
modparam("usrloc", "db_mode", 2)
modparam("usrloc", "db_url", "mysql://ser:serpassword@localhost/ser")
modparam("auth", "secret", "myphrase")
modparam("auth_db", "calculate_ha1", yes)
modparam("auth_db", "password_column", "password")
modparam("rr", "enable_full_lr", 1)
route{
# 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 >= 2048 ) {
sl_send_reply("513", "Message too big");
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
if (!method=="REGISTER") record_route();
# subsequent messages withing a dialog should take the
# path determined by record-routing
if (loose_route()) {
# mark routing logic in request
append_hf("P-hint: rr-enforced\r\n");
route(1);
break;
};
if (!uri==myself) {
# mark routing logic in request
append_hf("P-hint: outbound\r\n");
route(1);
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==trace-intl.net) {
if (method=="REGISTER") {
if (!www_authorize("trace-intl.net",
"subscriber")) {
www_challenge("trace-intl.net", "0");
break;
};
save("location");
break;
};
lookup("aliases");
if (!uri==myself) {
append_hf("P-hint: outbound alias\r\n");
route(1);
break;
};
# native SIP destinations are handled using our USRLOC DB
if (!lookup("location")) {
sl_send_reply("404", "Not Found");
break;
};
};
append_hf("P-hint: usrloc applied\r\n");
route(1);
}
route[1]
{
# send it out now; use stateful forwarding as it works reliably
# even for UDP2TCP
if (!t_relay()) {
sl_reply_error();
};
}
More information about the sr-users
mailing list