Hello everybody,

I should explain what ever I do one by one. 1. I downloed ser files under "/usr/local/ser-0.8.14" directory. 2. I get in here and open "/usr/local/ser-0.8.14/modules/acc/Makefile" 3. Changed like this DEFS+=-DSQL_ACC 4. While in "/usr/local/ser-0.8.14" Run these commands :

make all include_modules=mysql make prefix=/usr/local install include_modules=mysql

setup seemed succesfull.

5. Install SER mysql database. 6. Change ser.cfg like this.

# # $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=yes # (cmd line: -E)

check_via=no # (cmd. line: -v) dns=no # (cmd. line: -r) rev_dns=no # (cmd. line: -R)

listen=10.90.232.121 listen=127.0.0.1

port=5060 children=4

alias=10.90.232.121

fifo="/tmp/ser_fifo" fifo_mode=0666

# Uncomment this if you want to use SQL database 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/acc.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/registrar.so" loadmodule "/usr/local/lib/ser/modules/uri.so"

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

modparam("acc|auth_db|domain|group|speeddial|uri_db|usrloc", "db_url", "mysql://ser:heslo@10.90.232.121/ser")

#modparam("acc", "db_flag", 1) #modparam("acc", "db_missed_flag", 1) #modparam("acc", "log_fmt", "cdfimorstup") modparam("acc", "log_level", 1) #modparam("acc", "failed_transactions", 1) #modparam("acc", "report_cancels", 1) #modparam("acc", "report_ack", 0)

modparam("acc", "log_flag", 1) #modparam("acc", "log_missed_flag", 1)

# -- 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_mode", 2) modparam("usrloc", "timer_interval", 60) modparam("usrloc", "desc_time_order", 1)

# -- 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)

modparam("tm", "fr_timer", 20) modparam("tm", "fr_inv_timer", 40) modparam("tm", "wt_timer", 5)

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

# main routing logic

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; };

# 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

if (loose_route()) { t_relay(); break; };

setflag(1);

/*if (method=="INVITE" || method=="BYE") { setflag(1); };*/

/* record-route INVITEs -- all subsequent requests must visit us */ if (method=="INVITE") record_route();

# 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=="INVITE" || method== "CANCEL" || method== "ACK") { if (!proxy_authorize("10.90.232.121","subscriber")) { proxy_challenge("10.90.232.121","0"); break;

} else if (!check_from()) { sl_send_reply("403", "Use From=ID"); break; };

setflag(1);

consume_credentials();

/*if (!lookup("location")) { sl_send_reply("404", "Not Found"); break; };*/

} else if (method=="REGISTER") {

if (!www_authorize("10.90.232.121", "subscriber")) { www_challenge("10.90.232.121", "0"); break; };

if (!check_to()) { sl_send_reply("401", "Unauthorized"); break; };

consume_credentials();

save("location"); break; };

lookup("aliases");

# 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

setflag(1);

if (uri=~"^sip:00[0-9]*@10.90.232.121") { ## This assumes that the caller is log("Forwarding to PSTN\n"); ## registered in our realm rewritehostport("10.90.232.122:5060"); forward(uri:host, uri:port); #t_relay_to( "10.90.232.122", "5060"); break; };

if (!t_relay()) { sl_reply_error(); };

}

Although I can speak between two softphone. There is no record in acc table. And I could not route calls which starts with "00" to SIP gateway.

I would be great if you become guide...