In short u are trying to connect to a database but cant

1. Do you have a database
2. If yes, is it on same machine
3. If not on same machine can you connect to the database from the ser
machine from the command line eg mysql -h DB.IP.ADD.RESS -u ser -p<pass>
<db_name>
4. If not then make sure you can before you go into ser
5. Once you can connect from the command line, then change
modparam("usrloc", "db_url", "mysql://ser:heslo@localhost/ser")

and enter is ur username instead of "ser", and your password instead of
"heslo" and your IP address of machine where DB is instead of
"localhost", and if by some strange act s & M you have decided to call
your database something other than "ser" replace the "ser" at the
end with your db name

6. Try starting ser again, and it should connect
7. To debug your DB connection, and to see what ser is doing under the
hood, start mysql with logging enabled, usually will goto mysqld.log in
/var/log

8. then tail -f /var/log/mysqld.log |more and sit and watch as ser tries
to connect, and see what error it shows

Iqbal

PS If you have changed your DB name to something other than ser....change
back :-)



On 3/3/2005, "Mohammad Khan" <info@beeplove.com> wrote:

  

First of all, I am not SER expert.
>From my last couple of weeks learning I will suggest below:


Olivier.taylor wrote:

    

Thx to be so fast,
here is my 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 ------------------------

#debug=3         # debug level (cmd line: -dddddddddd)
#fork=yes
#log_stderror=no    # (cmd line: -E)

/* Uncomment these lines to enter debugging mode
debug=7
fork=no
log_stderror=yes
*/

check_via=no    # (cmd. line: -v)
dns=no           # (cmd. line: -r)
rev_dns=no      # (cmd. line: -R)
#port=5060
#children=4
fifo="/tmp/ser_fifo"
      

   fifo_db_url="mysql://ser:heslo@localhost/ser"        #
<--------- if you want fifo db

    

# ------------------ module loading ----------------------------------

# Uncomment this if you want to use SQL database
loadmodule "/usr/lib/ser/modules/mysql.so"

loadmodule "/usr/lib/ser/modules/sl.so"
loadmodule "/usr/lib/ser/modules/tm.so"
loadmodule "/usr/lib/ser/modules/rr.so"
loadmodule "/usr/lib/ser/modules/maxfwd.so"
loadmodule "/usr/lib/ser/modules/usrloc.so"
loadmodule "/usr/lib/ser/modules/registrar.so"

# Uncomment this if you want digest authentication
# mysql.so must be loaded !
loadmodule "/usr/lib/ser/modules/auth.so"
loadmodule "/usr/lib/ser/modules/auth_db.so"

# ----------------- setting module-specific parameters ---------------

# -- usrloc params --

#modparam("usrloc", "db_mode",   0)

# Uncomment this if you want to use SQL database
# for persistent storage and comment the previous line
      

modparam("usrloc", "db_url", "mysql://ser:heslo@localhost/ser")       #
<---- you need define this, if your database is different than default

    

modparam("usrloc", "db_mode", 2)

# -- auth params --
# Uncomment if you are using auth module
#
#modparam("auth_db", "calculate_ha1", yes)
#
# If you set "calculate_ha1" parameter to yes (which true in this
config),
# uncomment also the following parameter)
#
#modparam("auth_db", "password_column", "password")

# -- rr params --
# add value to ;lr param to make some broken UAs happy
      

modparam("rr", "enable_full_lr", 1)  # <----------- i think you want this

    

# -------------------------  request routing logic -------------------

# main routing logic
alias="finalcut.be"
alias="linux.finalcut.be"
alias="82.146.123.252"
      

its better to put above three lines in global section
if your computer ip is 82.146.123.252
you should have
listen=82.146.123.252
alias="finalcut.be"
alias="linux.finalcut.be"


For the rest of your config file, i really can't help.
I am also learing to write route logic.

    

route{

   # initial sanity checks -- messages with
   # max_forwards==0, or excessively long requests
   if (!mf_process_maxfwd_header("70")) {
       sl_send_reply("483","Too Many Hops");
       break;
   };
   if ( msg:len > max_len ) {
       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
   record_route();      # loose-route processing
   if (loose_route()) {
       t_relay();
       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==myself) {

       if (method=="REGISTER") {

# Uncomment this if you want to use digest authentication
           if (!www_authorize("82.146.123.252", "subscriber")) {
               www_challenge("82.146.123.252", "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();
   };

}












Mohammad Khan wrote:

      

you will need something like this in you ser.cfg
modparam("auth_db", "db_url", "mysql://ser:heslo@localhost/ser")
modparam("usrloc", "db_url", "mysql://ser:heslo@localhost/ser")

I can tell you better if I could see your ser.cfg

MOhammad


Olivier.taylor wrote:

        

I installed ser on a linux box centos 3.4
I use mysql 4.10

Furthermore I am noob on Linux and Ser :(

I get this messages at boot in the messages file
Impossible the for an UA to connect to ser...

Help is welcome,
regards,

Olivier

Mar  3 17:12:19 linux ser: WARNING: could not rev. resolve
82.146.123.252
Mar  3 17:12:19 linux ser: Listening on
Mar  3 17:12:19 linux ser:               127.0.0.1 [127.0.0.1]:5060
Mar  3 17:12:19 linux ser:               82.146.123.252
[82.146.123.252]:5060
Mar  3 17:12:19 linux ser: Aliases: localhost:5060
localhost.localdomain:5060 82.146.123.252:* linux.finalcut.be:*
finalcut.be:*
Mar  3 17:12:19 linux ser: Listening on
Mar  3 17:12:19 linux ser:               127.0.0.1 [127.0.0.1]:5060
Mar  3 17:12:19 linux ser:               82.146.123.252
[82.146.123.252]:5060
Mar  3 17:12:19 linux ser: Aliases: localhost:5060
localhost.localdomain:5060 82.146.123.252:* linux.finalcut.be:*
finalcut.be:*
Mar  3 17:12:19 linux ser: Listening on
Mar  3 17:12:19 linux ser:               127.0.0.1 [127.0.0.1]:5060
Mar  3 17:12:19 linux ser:               82.146.123.252
[82.146.123.252]:5060
Mar  3 17:12:19 linux ser: Aliases: localhost:5060
localhost.localdomain:5060 82.146.123.252:* linux.finalcut.be:*
finalcut.be:*
Mar  3 17:12:19 linux ser: ser startup succeeded
Mar  3 17:12:19 linux /usr/sbin/ser[2649]: connect_db(): Can't
connect to local MySQL server through socket
'/var/lib/mysql/mysql.sock' (2)
Mar  3 17:12:19 linux /usr/sbin/ser[2649]: db_init(): Error while
trying to connect database
Mar  3 17:12:19 linux /usr/sbin/ser[2649]: mod_init(): Error while
connecting database
Mar  3 17:12:19 linux /usr/sbin/ser[2649]: init_mod(): Error while
initializing module usrloc

_______________________________________________
Serusers mailing list
serusers@lists.iptel.org
http://lists.iptel.org/mailman/listinfo/serusers
          

Let me know, if it improves the situation.

Good Luck
MOhammad


_______________________________________________
Serusers mailing list
serusers@lists.iptel.org
http://lists.iptel.org/mailman/listinfo/serusers