<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
First of all, I am really surprised how Linux and ser users are so
kind, I am from the windows world and they are not so fast and kind,
spending time to help a stupid noob user, thanks for that, when i'll be
the king of Linux(hope I will be) and Ser, i will help everyone needing
help like you do.<br>
I will check all the stuff coming to me by you and tell you more after.<br>
Thanks again,<br>
<br>
Olivier<br>
<br>
Iqbal wrote:
<blockquote cite="midNy5V2oOy.1109871154.2818470.iqbal@gigo.co.uk"
type="cite">
<pre wrap="">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" <a class="moz-txt-link-rfc2396E" href="mailto:info@beeplove.com"><info@beeplove.com></a> wrote:
</pre>
<blockquote type="cite">
<pre wrap="">First of all, I am not SER expert.
>From my last couple of weeks learning I will suggest below:
Olivier.taylor wrote:
</pre>
<blockquote type="cite">
<pre wrap="">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"
</pre>
</blockquote>
<pre wrap=""> fifo_db_url="mysql://ser:heslo@localhost/ser" #
<--------- if you want fifo db
</pre>
<blockquote type="cite">
<pre wrap=""># ------------------ 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
</pre>
</blockquote>
<pre wrap="">modparam("usrloc", "db_url", "mysql://ser:heslo@localhost/ser") #
<---- you need define this, if your database is different than default
</pre>
<blockquote type="cite">
<pre wrap="">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
</pre>
</blockquote>
<pre wrap="">modparam("rr", "enable_full_lr", 1) # <----------- i think you want this
</pre>
<blockquote type="cite">
<pre wrap=""># ------------------------- request routing logic -------------------
# main routing logic
alias="finalcut.be"
alias="linux.finalcut.be"
alias="82.146.123.252"
</pre>
</blockquote>
<pre wrap="">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.
</pre>
<blockquote type="cite">
<pre wrap="">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:
</pre>
<blockquote type="cite">
<pre wrap="">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:
</pre>
<blockquote type="cite">
<pre wrap="">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
<a class="moz-txt-link-abbreviated" href="mailto:serusers@lists.iptel.org">serusers@lists.iptel.org</a>
<a class="moz-txt-link-freetext" href="http://lists.iptel.org/mailman/listinfo/serusers">http://lists.iptel.org/mailman/listinfo/serusers</a>
</pre>
</blockquote>
<pre wrap="">
</pre>
</blockquote>
</blockquote>
<pre wrap="">
Let me know, if it improves the situation.
Good Luck
MOhammad
_______________________________________________
Serusers mailing list
<a class="moz-txt-link-abbreviated" href="mailto:serusers@lists.iptel.org">serusers@lists.iptel.org</a>
<a class="moz-txt-link-freetext" href="http://lists.iptel.org/mailman/listinfo/serusers">http://lists.iptel.org/mailman/listinfo/serusers</a>
</pre>
</blockquote>
<pre wrap=""><!---->
</pre>
</blockquote>
<br>
</body>
</html>