[Serusers] Access denied user serro - Mysql

[Marcin Grzymski]

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 at 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