<DIV>hi, All</DIV>
<DIV> </DIV>
<DIV>I have setup the SER with auth enable for MySQL ( and radius also .. at a time only one is used ) I am able to see that if user is not in database he is not able to login to SOFTPHONE .... Now I want to enable accounting also ,,, as in my case auth is working perfectly fine but accounting is not working ... I have tried all the things ,, but still I am missing somthing ...... please help me ...... as even inserting the acc module in ser.cfg file nothing is getting inserted into database .. in the form of accounting information..</DIV>
<DIV> </DIV>
<DIV>At the same time where can i get the information about .. what is a information stored in each mysql table</DIV>
<DIV> </DIV>
<DIV>---------------------------------------------------------------------------------------------------------------------------------</DIV>
<DIV><STRONG>my ser.cfg file is as follows ( where i have compiled ser with all the module enable)</STRONG></DIV>
<DIV>------------------------------------------------------------------------------------------------------------------------------------</DIV>
<DIV> </DIV>
<DIV>[root@test ser]# cat ser.cfg<BR>#<BR># $Id: ser.cfg,v 1.21.4.1 2003/11/10 15:35:15 andrei Exp $<BR>#<BR># simple quick-start config script<BR>#</DIV>
<DIV># ----------- global configuration parameters ------------------------</DIV>
<DIV>debug=5 # debug level (cmd line: -dddddddddd)<BR>fork=yes<BR>log_stderror=yes # (cmd line: -E)</DIV>
<DIV>/* Uncomment these lines to enter debugging mode<BR>debug=7<BR>fork=no<BR>log_stderror=yes<BR>*/</DIV>
<DIV>check_via=no # (cmd. line: -v)<BR>dns=no # (cmd. line: -r)<BR>rev_dns=no # (cmd. line: -R)<BR>port=5060<BR>children=4<BR>fifo="/tmp/ser_fifo"</DIV>
<DIV># ------------------ module loading ----------------------------------</DIV>
<DIV># Uncomment this if you want to use SQL database<BR>loadmodule "/usr/local/lib/ser/modules/mysql.so"</DIV>
<DIV>loadmodule "/usr/local/lib/ser/modules/sl.so"<BR>loadmodule "/usr/local/lib/ser/modules/tm.so"<BR>loadmodule "/usr/local/lib/ser/modules/rr.so"<BR>loadmodule "/usr/local/lib/ser/modules/maxfwd.so"<BR>loadmodule "/usr/local/lib/ser/modules/usrloc.so"<BR>loadmodule "/usr/local/lib/ser/modules/registrar.so"</DIV>
<DIV># Uncomment this if you want digest authentication<BR># mysql.so must be loaded !<BR>loadmodule "/usr/local/lib/ser/modules/auth.so"<BR>loadmodule "/usr/local/lib/ser/modules/acc.so"<BR>loadmodule "/usr/local/lib/ser/modules/auth_db.so"<BR>#loadmodule "/usr/local/lib/ser/modules/auth_radius.so"</DIV>
<DIV># ----------------- setting module-specific parameters ---------------</DIV>
<DIV># -- usrloc params --</DIV>
<DIV># -- auth_radius params --<BR>#modparam("auth_radius", "radius_config", "/usr/local/etc/radiusclient/radiusclient.conf")</DIV>
<DIV><BR>#modparam("usrloc", "db_mode", 0)</DIV>
<DIV> </DIV>
<DIV># --domain module--<BR>modparam("usrloc", "db_url", "mysql://ser:heslo@localhost/ser")<BR>#modparam("domain", "db_mode", 1)<BR>#modparam("domain", "domain_table", "domain")<BR>#modparam("domain", "domain_col", "domain")</DIV>
<DIV># --acc params--<BR>modparam("acc", "log_level", 1)<BR>modparam("acc", "log_flag", 2)<BR>#modparam("acc", "log_missed_flag", 2)<BR>#modparam("acc", "log_fmt", "fimos")<BR>#modparam("acc", "db_url", "mysql://ser:heslo@localhost/ser")<BR>#modparam("acc", "db_missed_flag", 2)</DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV><BR># Uncomment this if you want to use SQL database<BR># for persistent storage and comment the previous line<BR>modparam("usrloc", "db_mode", 1)</DIV>
<DIV># -- auth params --<BR># Uncomment if you are using auth module<BR>#<BR>modparam("auth_db", "calculate_ha1", yes)<BR>#<BR># If you set "calculate_ha1" parameter to yes (which true in this config),<BR># uncomment also the following parameter)<BR>#<BR>modparam("auth_db", "password_column", "password")</DIV>
<DIV># -- rr params --<BR># add value to ;lr param to make some broken UAs happy<BR>modparam("rr", "enable_full_lr", 1)</DIV>
<DIV># ------------------------- request routing logic -------------------</DIV>
<DIV># main routing logic</DIV>
<DIV>route{</DIV>
<DIV> # initial sanity checks -- messages with<BR> # max_forwards==0, or excessively long requests<BR> if (!mf_process_maxfwd_header("10")) {<BR> sl_send_reply("483","Too Many Hops");<BR> break;<BR> };<BR> if ( msg:len > max_len ) {<BR> sl_send_reply("513", "Message too big");<BR> break;<BR> };</DIV>
<DIV> # we record-route all messages -- to make sure that<BR> # subsequent messages will go through our proxy; that's<BR> # particularly good if upstream and downstream entities<BR> # use different transport protocol<BR> record_route();<BR> # loose-route processing<BR> if (loose_route()) {<BR> t_relay();<BR> break;<BR> };</DIV>
<DIV> # if the request is for other domain use UsrLoc<BR> # (in case, it does not work, use the following command<BR> # with proper names and addresses in it)<BR> if (uri=='192.168.1.246') {</DIV>
<DIV> if (method=="REGISTER") {</DIV>
<DIV># Uncomment this if you want to use digest authentication<BR> if (!www_authorize("192.168.1.246", "subscriber")) {<BR> www_challenge("192.168.1.246", "0");<BR> break;<BR> };</DIV>
<DIV> save("location");<BR> break;<BR> };</DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV> # native SIP destinations are handled using our USRLOC DB<BR> if (!lookup("location")) {<BR> sl_send_reply("404", "Not Found");<BR> break;<BR> };<BR> };<BR> # forward to current uri now; use stateful forwarding; that<BR> # works reliably even if we forward from TCP to UDP<BR>
if (!t_relay()) {<BR> sl_reply_error();<BR> };</DIV>
<DIV>}</DIV>
<DIV> </DIV>
<DIV><BR> </DIV>
<DIV> </DIV>
<DIV><STRONG>Please see teh table list </STRONG></DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV>[root@test ser]# mysql<BR>Welcome to the MySQL monitor. Commands end with ; or \g.<BR>Your MySQL connection id is 376 to server version: 3.23.58</DIV>
<DIV>Type 'help;' or '\h' for help. Type '\c' to clear the buffer.</DIV>
<DIV>mysql> use ser<BR>Reading table information for completion of table and column names<BR>You can turn off this feature to get a quicker startup with -A</DIV>
<DIV>Database changed<BR></DIV>
<DIV>mysql> show tables<BR> -> ;<BR>+-----------------------+<BR>| Tables_in_ser |<BR>+-----------------------+<BR>| acc |<BR>| active_sessions |<BR>| aliases |<BR>| config |<BR>| domain |<BR>| event |<BR>| grp |<BR>| location |<BR>|
missed_calls |<BR>| pending |<BR>| phonebook |<BR>| preferences |<BR>| reserved |<BR>| server_monitoring |<BR>| server_monitoring_agg |<BR>| silo |<BR>| subscriber |<BR>| uri |<BR>| version |<BR>+-----------------------+<BR>19 rows in set (0.00 sec)</DIV>
<DIV> </DIV><p>
                <hr size=1>Yahoo! Mail Mobile<br>
<a href="http://us.rd.yahoo.com/mail_us/taglines/mobile/*http://mobile.yahoo.com/learn/mail">Take Yahoo! Mail with you!</a> Check email on your mobile phone.