<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-9">
<META content="MSHTML 6.00.2900.2627" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT face=Arial size=2>Hi List,</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Is there anyone using "Advanced VoIP Billing
Software", i have a few questions regarding to it :</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Both Billing Software and SER installed on same
machine and LAN IP is 192.168.1.11 (test system)</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Linux Dist : Mandrake 10.0 (OS)</FONT></DIV>
<DIV><FONT face=Arial size=2>Apache : Installed (base web server)</FONT></DIV>
<DIV><FONT face=Arial size=2>Java : Installed (important for
tomcat)</FONT></DIV>
<DIV><FONT face=Arial size=2>Tomcat : Installed (important for web
interface)</FONT></DIV>
<DIV><FONT face=Arial size=2>Perl & PHP : Installed (and a few perl modules
for various applications)</FONT></DIV>
<DIV><FONT face=Arial size=2>MySql : Installed (advanced voip needs it and
creates to database like "raddb" and "voipbilling")</FONT></DIV>
<DIV><FONT face=Arial size=2>PostgreSql : Installed (no need for it at this
time)</FONT></DIV>
<DIV><FONT face=Arial size=2>Radiusclient-ng : Installed (it's needed for
SER itself)</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>I followed steps on <A
href="http://www.iptel.org/ser/doc/ser_radius/ser_radius.html">http://www.iptel.org/ser/doc/ser_radius/ser_radius.html</A> except
freeradius server as normal.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>I've installed SER from RPM's for
Mandrake:</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>ser-0.9.0-1mdk.i586.rpm</FONT></DIV>
<DIV><FONT face=Arial size=2>ser-jabber-0.9.0-1mdk.i586.rpm</FONT></DIV>
<DIV><FONT face=Arial size=2>ser-mysql-0.9.0-1mdk.i586.rpm</FONT></DIV>
<DIV><FONT face=Arial size=2>ser-radius-0.9.0-1mdk.i586.rpm</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>
<DIV><FONT face=Arial size=2><<<<< SER.CFG
>>>>></FONT></DIV></FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>[root@localhost ser]# cat ser.cfg<BR>#<BR># $Id:
ser.cfg,v 1.27 2005/03/10 14:16:25 andrei Exp $<BR>#<BR># simple quick-start
config script<BR>#</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Arial size=2># ----------- global configuration parameters
------------------------</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Arial
size=2>#debug=3 # debug level
(cmd line:
-dddddddddd)<BR>#fork=yes<BR>#log_stderror=no
# (cmd line: -E)<BR>#memlog=5 # memory debug log
level<BR>#log_facility=LOG_LOCAL0 # sets the facility used for logging (see
syslog(3))</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Arial size=2>/* Uncomment these lines to enter debugging
mode<BR>fork=no<BR>log_stderror=yes<BR>*/</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>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"<BR>#user=ser<BR>#group=ser<BR>#fifo_user=ser
# owner of the ser fifo<BR>#fifo_group=ser<BR>#fifo_mode=0660 # fifo's
permissions<BR>#disable_core=yes #disables core dumping<BR>#open_fd_limit=1024 #
sets the open file descriptors limit<BR>#mhomed=yes # usefull for
multihomed hosts, small performance
penalty<BR>#disable_tcp=yes<BR>#tcp_accept_aliases=yes # accepts the tcp alias
via option (see NEWS)</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Arial size=2># ------------------ module loading
----------------------------------</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>loadmodule
"/usr/lib/ser/modules/sl.so"<BR>loadmodule
"/usr/lib/ser/modules/tm.so"<BR>loadmodule
"/usr/lib/ser/modules/rr.so"<BR>loadmodule
"/usr/lib/ser/modules/maxfwd.so"<BR>loadmodule
"/usr/lib/ser/modules/usrloc.so"<BR>loadmodule
"/usr/lib/ser/modules/registrar.so"<BR>loadmodule
"/usr/lib/ser/modules/textops.so"<BR>loadmodule
"/usr/lib/ser/modules/auth.so"<BR>loadmodule
"/usr/lib/ser/modules/acc.so"<BR>loadmodule
"/usr/lib/ser/modules/auth_radius.so"<BR>loadmodule
"/usr/lib/ser/modules/xlog.so"</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2># ----------------- setting module-specific
parameters ---------------</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>modparam("auth_radius", "radius_config",
"/usr/local/etc/radiusclient-ng/radiusclient.conf")<BR>modparam("auth_radius",
"service_type", 15)<BR>modparam("rr", "enable_full_lr", 1)</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Arial size=2># ------------------------- request routing
logic -------------------</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Arial size=2># main routing logic</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Arial size=2>route{</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2> #
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> };</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Arial size=2> # 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> if (!method=="REGISTER")
record_route();</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Arial size=2> #
subsequent messages withing a dialog should take
the<BR> # path determined by
record-routing<BR> if (loose_route())
{<BR>
# mark routing logic in
request<BR>
append_hf("P-hint:
rr-enforced\r\n");<BR>
route(1);<BR>
break;<BR> };</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2> if
(!uri==myself)
{<BR>
# mark routing logic in
request<BR>
append_hf("P-hint:
outbound\r\n");<BR>
route(1);<BR>
break;<BR> };</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Arial size=2> # 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==myself)
{</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Arial
size=2>
if (method=="REGISTER") {</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Arial size=2># Uncomment this if you want to use digest
authentication<BR>
if (!radius_www_authorize(""))
{<BR>
www_challenge("","0");<BR>
break;<BR>
};</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Arial
size=2>
save("location");<BR>
break;<BR>
};</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Arial
size=2>
lookup("aliases");<BR>
if (!uri==myself)
{<BR>
append_hf("P-hint: outbound
alias\r\n");<BR>
route(1);<BR>
break;<BR>
};</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Arial
size=2>
# 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> append_hf("P-hint: usrloc
applied\r\n");<BR>
route(1);<BR>}</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial
size=2>route[1]<BR>{<BR> # send it out
now; use stateful forwarding as it works
reliably<BR> # even for
UDP2TCP<BR> if (!t_relay())
{<BR>
sl_reply_error();<BR>
};<BR>}<BR></FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2><<<<< SER --- When I run it
>>>>></FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>[root@localhost root]# ser -c<BR> 0(2178)
WARNING: fix_socket_list: could not rev. resolve 192.168.1.11<BR> 0(2178)
WARNING: fix_socket_list: could not rev. resolve 192.168.1.11<BR>Listening
on<BR>
udp: 127.0.0.1
[127.0.0.1]:5060<BR>
udp: 192.168.1.11
[192.168.1.11]:5060<BR>
tcp: 127.0.0.1
[127.0.0.1]:5060<BR>
tcp: 192.168.1.11
[192.168.1.11]:5060<BR>Aliases:<BR>
tcp:
localhost:5060<BR>
udp: localhost:5060</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>config file ok, exiting...<BR>[root@localhost
root]</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2><<<<< RADIUS --- When I run it
>>>>></FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>[root@localhost advradius]#
./runserver.sh</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Wed, 11 May 2005 13:05:58 095:
FINE:<BR><GlobalConf><BR>
AuthenticationPort = 1812<BR>
AccountingPort = 1813<BR> BindAddress
= null<BR> DictionaryFile =
/billing/advradius/conf/dictionary<BR>
LogDirectory =
/billing/advradius/log<BR> LogLevel =
FINE<BR> ConsoleWrite =
true<BR> FileWrite =
true<BR> ConsiderSrcIPAsNASIP =
false<BR></GlobalConf></FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV><FONT face=Arial size=2>
<DIV><BR>Wed, 11 May 2005 13:05:58 739:
FINE:<BR><ThreadPoolManager><BR>
NumThreads = 10<BR> MaximumWorkTime =
5000<BR> KeepAliveTime =
-1<BR> ExpiryThreadSleepInterval =
5000<BR></ThreadPoolManager></DIV>
<DIV> </DIV>
<DIV><BR>Wed, 11 May 2005 13:05:58 882: FINE:<BR><Client
DEFAULT><BR> NASIdentifier =
default<BR> Secret =
mysecret<BR> Realm =
db<BR></Client></DIV>
<DIV> </DIV>
<DIV><BR>Wed, 11 May 2005 13:05:58 917: FINE:<BR><Realm db><BR>18AuthBy =
[db]<BR> AcctPolicy =
BACK-UP<BR> Accounting = [db,
file_acct]<BR> Session =
db<BR></Realm></DIV>
<DIV> </DIV>
<DIV><BR>Wed, 11 May 2005 13:05:59 708: FINE:<BR><DBParams
DEFAULT><BR> DriverName =
org.gjt.mm.mysql.Driver<BR> DBURL =
jdbc:mysql://127.0.0.1:3306/voipbilling<BR>
UserName = root<BR> UserPassword
=<BR></DBParams></DIV>
<DIV> </DIV>
<DIV><BR>Wed, 11 May 2005 13:05:59 967: FINE:<BR><AuthBy
db><BR> CheckList = [(5, (260, 0))
, (6, (0, 0)) ]<BR> ReplyList = [(1,
(101, 9)) , (2, (102, 9)) , (3, (103, 9)) , (4, (6, 0)) , (7, (0, 0))
]<BR> BackStore =
DB<BR> PwdEncType =
0<BR> SimultaneousLogin =
0<BR> BackStore =
DB<BR> DBParams =
null<BR> AuthQuery =
Select CallAmnt, CallTime, ReturnCode,
AuthServiceType, Password, OtherCheckItems, OtherReplyItems from
TblActiveSessions where AuthConfID = $cisco-h323-conf-id and AuthType =
@GetRequestNumber@<BR> AttribMapping =
ColMapped<BR></AuthBy></DIV>
<DIV> </DIV>
<DIV><BR>Wed, 11 May 2005 13:05:59 990: FINE:<BR><Session
db><BR> BackStore =
DB<BR> InsertSession = Insert INTO
TblActiveSessions ( UserName, TimeStart, AuthType, CalledNumber,
AuthCallingNumber, AuthNASIPAddress, AuthNASPort, AuthNASPortType, AuthConfID,
CallOrigin, CallType, AcctSessionID ) values ($User-Name, $Event-Time, 3,
$Called-Station-Id, $Calling-Station-Id, $NAS-IP-Address, $NAS-Port,
$NAS-Port-Type, $cisco-h323-conf-id, $cisco-h323-call-origin,
$cisco-h323-call-type,
$Acct-Session-Id)<BR> DeleteSession =
Delete from TblActiveSessions where AuthConfID =
$cisco-h323-conf-id<BR> CountSession =
Select count(*) from TblActiveSessions where LoginName = $User-Name and
AuthConfId=$cisco-h323-conf-id<BR>
BackStore = DB<BR></Session></DIV>
<DIV> </DIV>
<DIV><BR>Wed, 11 May 2005 13:06:00 039: FINE:<BR><Accounting
db><BR> BackStore =
DB<BR> InsertAcct = Insert INTO
TblCallsRad ( TimeClose, UserName, ActualDuration, CallingNumber, CalledNumber,
ConfID, CallOrigin, CallType, AcctSessionID, NASIPAddress, BytesIn, BytesOut,
DelayTime, AcctStatusType, RemoteAddress, RemoteGatewayID, TerminationCause, )
values ( $Event-Time, $User-Name, $Acct-Session-Time:NUMBER,
$Calling-Station-Id, $Called-Station-Id, $cisco-h323-conf-id,
$cisco-h323-call-origin, $cisco-h323-call-type, $Acct-Session-Id,
$NAS-IP-Address, $Acct-Input-Octets:NUMBER, $Acct-Output-Octets:NUMBER,
$Acct-Delay-Time:NUMBER, $Acct-Status-Type, $cisco-h323-remote-address,
$cisco-h323-gw-id, $cisco-h323-disconnect-cause,
)<BR> QueueLength =
5000<BR> RecordAcctStart =
FALSE<BR> DBParams =
null<BR> InsertCheckpointAcct =
null<BR></Accounting></DIV>
<DIV> </DIV>
<DIV><BR>Wed, 11 May 2005 13:06:00 070: FINE:<BR><Accounting
file_acct><BR> BackStore =
FILE<BR> InsertAcct =
null<BR> QueueLength =
5000<BR> RecordAcctStart = TRUE</DIV>
<DIV> </DIV>
<DIV> FileNameFormat =
yyyy-MM-dd-HH.csv<BR> AcctDirectory =
AcctLog<BR></Accounting></DIV>
<DIV> </DIV>
<DIV>Your evaluation license will expire in 25 day(s).</DIV>
<DIV> </DIV>
<DIV>Wed, 11 May 2005 13:06:00 137: INFO: Listener started at: 1812</DIV>
<DIV> </DIV>
<DIV>Wed, 11 May 2005 13:06:00 143: INFO: Listener started at: 1813<BR>Started
Successfully <<<</DIV>
<DIV> </DIV>
<DIV>Anyone have any idea how to implement this valuable software in SER because
we're gonna pay for it.</FONT></DIV></BODY></HTML>