11 Apr
2005
11 Apr
'05
8:35 a.m.
Hello,
I have:
ser-0.8.14
mediaproxy-1.2.1
mysql-server-4.0.24
When SER is starting i have error:
############################
bash-2.05b# serctl start
Starting SER : Listening on
udp: xxxxxxxxxxxxxxx [xxxxxxxxxxxxxxxxxx]:5060
udp: 127.0.0.1 [127.0.0.1]:5060
tcp: xxxxxxxxxxxxxxxxx [xxxxxxxxxxxxxx]:5060
tcp: 127.0.0.1 [127.0.0.1]:5060
Aliases:
tcp: localhost:5060
tcp: xxxxxxxxxxxxx:5060
udp: localhost:5060
udp: xxxxxxxxxxxx:5060
*: universe:*
*: vco.pl:*
stateless - initializing
0(0) Maxfwd module- initializing
textops - initializing
0(0) INFO: udp_init: SO_RCVBUF is initially 42080
0(0) INFO: udp_init: SO_RCVBUF is finally 231808
0(0) INFO: udp_init: SO_RCVBUF is initially 42080
0(0) INFO: udp_init: SO_RCVBUF is finally 231808
1(882) INFO: fifo process starting: 882
2(883) new_connection: Access denied for user: 'serro@localhost'
(Using password: YES)
2(883) db_init: No memory left
2(883) ERROR:domain_db_init: cannot initialize database connection
2(883) ERROR: domain:child_init(): Unable to connect to the database
2(883) init_mod_child(): Error while initializing module domain
2(883) init_child failed
15(896) INFO: signal 15 received
14(895) INFO: signal 15 received
13(894) INFO: signal 15 received
12(893) INFO: signal 15 received
11(892) INFO: signal 15 received
10(891) INFO: signal 15 received
9(890) INFO: signal 15 received
8(889) INFO: signal 15 received
7(888) INFO: signal 15 received
5(886) INFO: signal 15 received
4(885) INFO: signal 15 received
3(884) INFO: signal 15 received
1(882) INFO: signal 15 received
6(887) INFO: signal 15 received
PID file /var/run/ser.pid does not exist -- SER start failed
###########################
I don't know why it cannot connect to database.
I can connect with this username and password from mysql CLI.
in my ser.cfg:
###########################
debug=3
fork=yes
log_stderror=yes
check_via=no
dns=no
rev_dns=no
port=5060
children=4
fifo="/tmp/ser_fifo"
fifo_db_url="mysql://ser:heslo@localhost/ser"
alias=vco.pl
alias="universe"
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/domain.so"
loadmodule "/usr/local/lib/ser/modules/uri.so"
loadmodule "/usr/local/lib/ser/modules/registrar.so"
loadmodule "/usr/local/lib/ser/modules/textops.so"
loadmodule "/usr/local/lib/ser/modules/mediaproxy.so"
loadmodule "/usr/local/lib/ser/modules/auth.so"
loadmodule "/usr/local/lib/ser/modules/auth_db.so"
modparam("usrloc", "db_mode", 0)
#modparam("usrloc", "db_mode", 2)
modparam("usrloc", "db_url",
"mysql://ser:______@_______________/ser")
modparam("auth_db|uri_db", "db_url",
"mysql://serro:______@___________/ser")
modparam("auth_db", "calculate_ha1", yes)
modparam("auth_db", "password_column", "password")
modparam("rr", "enable_full_lr", 1)
modparam("mediaproxy", "mediaproxy_socket",
"/var/run/proxydispatcher.sock")
modparam("mediaproxy",
"sip_asymmetrics","/etc/ser/sip-asymmetrics-clients")
modparam("mediaproxy",
"rtp_asymmetrics","/etc/ser/rtp-asymmetrics-clients")
modparam("mediaproxy", "natping_interval", 20)
modparam("registrar", "nat_flag", 2)
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 >= max_len ) {
sl_send_reply("513", "Message too big");
break;
};
# Force subsequent messages to pass trough this proxy
record_route();
if (loose_route()) {
if (method=="INVITE" || method=="ACK") {
use_media_proxy();
};
# end media session for BYE and CANCEL is done above
# before entering the loose route. no need to call it here
t_relay();
break;
};
if (uri==myself) {
if (method=="REGISTER") {
# Mark as NAT'ed
if (client_nat_test("3")) {
setflag(2);
force_rport();
fix_contact();
};
if (!www_authorize("universe", "subscriber")) {
www_challenge("universe", "0");
break;
};
# else if (!check_to()) {
# sl_send_reply("403", "Username!=To not
allowed");
# break;
#};
if (!save("location")) {
sl_reply_error();
};
};
# if (is_uri_host_local()) {
if (!lookup("location")) {
sl_send_reply("404", "Not found");
break;
};
# };
} else {
sl_send_reply("403", "This domain is not served here");
break;
};
# if (method=="INVITE") {
if (method=="12345") {
if (!(is_from_local() || is_uri_host_local())) {
sl_send_reply("403", "Relaying is forbidden");
break;
};
t_on_failure("1");
} else if (method == "BYE" || method == "CANCEL") {
end_media_session();
};
if (client_nat_test("3") && !search("^Record-Route:"))
{
# Mark as NAT'ed
force_rport();
fix_contact();
};
if (method=="INVITE") {
t_on_reply("1");
};
if (method=="INVITE" || method=="ACK") {
use_media_proxy();
};
if (!t_relay()) {
if (method=="INVITE" || method=="ACK") {
end_media_session();
};
sl_reply_error();
};
}
failure_route[1] {
end_media_session();
}
onreply_route[1] {
if (status=~"(183)|(2[0-9][0-9])") {
if (client_nat_test("1")) {
fix_contact();
};
use_media_proxy();
};
}
##############################
Regards Marcin Grzymski