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