Hi List,

Is there anyone using "Advanced VoIP Billing Software", i have a few questions regarding to it :

Both Billing Software and SER installed on same machine and LAN IP is 192.168.1.11 (test system)

Linux Dist : Mandrake 10.0 (OS)

Apache : Installed (base web server)

Java : Installed (important for tomcat)

Tomcat : Installed (important for web interface)

Perl & PHP : Installed (and a few perl modules for various applications)

MySql : Installed (advanced voip needs it and creates to database like "raddb" and "voipbilling")

PostgreSql : Installed (no need for it at this time)

Radiusclient-ng : Installed (it's needed for SER itself)

I followed steps on http://www.iptel.org/ser/doc/ser_radius/ser_radius.html except freeradius server as normal.

I've installed SER from RPM's for Mandrake:

ser-0.9.0-1mdk.i586.rpm

ser-jabber-0.9.0-1mdk.i586.rpm

ser-mysql-0.9.0-1mdk.i586.rpm

ser-radius-0.9.0-1mdk.i586.rpm

<<<<< SER.CFG >>>>>

[root@localhost ser]# cat ser.cfg
#
# $Id: ser.cfg,v 1.27 2005/03/10 14:16:25 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)
#memlog=5 # memory debug log level
#log_facility=LOG_LOCAL0 # sets the facility used for logging (see syslog(3))

/* Uncomment these lines to enter debugging mode
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"
#user=ser
#group=ser
#fifo_user=ser # owner of the ser fifo
#fifo_group=ser
#fifo_mode=0660 # fifo's permissions
#disable_core=yes #disables core dumping
#open_fd_limit=1024 # sets the open file descriptors limit
#mhomed=yes # usefull for multihomed hosts, small performance penalty
#disable_tcp=yes
#tcp_accept_aliases=yes # accepts the tcp alias via option (see NEWS)

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

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"
loadmodule "/usr/lib/ser/modules/textops.so"
loadmodule "/usr/lib/ser/modules/auth.so"
loadmodule "/usr/lib/ser/modules/acc.so"
loadmodule "/usr/lib/ser/modules/auth_radius.so"
loadmodule "/usr/lib/ser/modules/xlog.so"

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

modparam("auth_radius", "radius_config", "/usr/local/etc/radiusclient-ng/radiusclient.conf")
modparam("auth_radius", "service_type", 15)
modparam("rr", "enable_full_lr", 1)

# ------------------------- 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 (!method=="REGISTER") record_route();

        # subsequent messages withing a dialog should take the
        # path determined by record-routing
        if (loose_route()) {
                # mark routing logic in request
                append_hf("P-hint: rr-enforced\r\n");
                route(1);
                break;
        };

        if (!uri==myself) {
                # mark routing logic in request
                append_hf("P-hint: outbound\r\n");
                route(1);
                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 (!radius_www_authorize("")) {
                                www_challenge("","0");
                                break;
                        };

                        save("location");
                        break;
                };

                lookup("aliases");
                if (!uri==myself) {
                        append_hf("P-hint: outbound alias\r\n");
                        route(1);
                        break;
                };

                # native SIP destinations are handled using our USRLOC DB
                if (!lookup("location")) {
                        sl_send_reply("404", "Not Found");
                        break;
                };
        };
        append_hf("P-hint: usrloc applied\r\n");
        route(1);
}

route[1]
{
        # send it out now; use stateful forwarding as it works reliably
        # even for UDP2TCP
        if (!t_relay()) {
                sl_reply_error();
        };
}

<<<<< SER --- When I run it >>>>>

[root@localhost root]# ser -c
0(2178) WARNING: fix_socket_list: could not rev. resolve 192.168.1.11
0(2178) WARNING: fix_socket_list: could not rev. resolve 192.168.1.11
Listening on
             udp: 127.0.0.1 [127.0.0.1]:5060
             udp: 192.168.1.11 [192.168.1.11]:5060
             tcp: 127.0.0.1 [127.0.0.1]:5060
             tcp: 192.168.1.11 [192.168.1.11]:5060
Aliases:
             tcp: localhost:5060
             udp: localhost:5060

config file ok, exiting...
[root@localhost root]

<<<<< RADIUS --- When I run it >>>>>

[root@localhost advradius]# ./runserver.sh

Wed, 11 May 2005 13:05:58 095: FINE:
<GlobalConf>
        AuthenticationPort = 1812
        AccountingPort = 1813
        BindAddress = null
        DictionaryFile = /billing/advradius/conf/dictionary
        LogDirectory = /billing/advradius/log
        LogLevel = FINE
        ConsoleWrite = true
        FileWrite = true
        ConsiderSrcIPAsNASIP = false
</GlobalConf>

Wed, 11 May 2005 13:05:58 739: FINE:
<ThreadPoolManager>
        NumThreads = 10
        MaximumWorkTime = 5000
        KeepAliveTime = -1
        ExpiryThreadSleepInterval = 5000
</ThreadPoolManager>

Wed, 11 May 2005 13:05:58 882: FINE:
<Client DEFAULT>
        NASIdentifier = default
        Secret = mysecret
        Realm = db
</Client>

Wed, 11 May 2005 13:05:58 917: FINE:
<Realm db>
18AuthBy = [db]
        AcctPolicy = BACK-UP
        Accounting = [db, file_acct]
        Session = db
</Realm>

Wed, 11 May 2005 13:05:59 708: FINE:
<DBParams DEFAULT>
        DriverName = org.gjt.mm.mysql.Driver
        DBURL = jdbc:mysql://127.0.0.1:3306/voipbilling
        UserName = root
        UserPassword =
</DBParams>

Wed, 11 May 2005 13:05:59 967: FINE:
<AuthBy db>
        CheckList = [(5, (260, 0)) , (6, (0, 0)) ]
        ReplyList = [(1, (101, 9)) , (2, (102, 9)) , (3, (103, 9)) , (4, (6, 0)) , (7, (0, 0)) ]
        BackStore = DB
        PwdEncType = 0
        SimultaneousLogin = 0
        BackStore = DB
        DBParams = null
        AuthQuery = Select      CallAmnt, CallTime, ReturnCode, AuthServiceType, Password, OtherCheckItems, OtherReplyItems from TblActiveSessions where AuthConfID = $cisco-h323-conf-id and AuthType = @GetRequestNumber@
        AttribMapping = ColMapped
</AuthBy>

Wed, 11 May 2005 13:05:59 990: FINE:
<Session db>
        BackStore = DB
        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)
        DeleteSession = Delete from TblActiveSessions where AuthConfID = $cisco-h323-conf-id
        CountSession = Select count(*) from TblActiveSessions where LoginName = $User-Name and AuthConfId=$cisco-h323-conf-id
        BackStore = DB
</Session>

Wed, 11 May 2005 13:06:00 039: FINE:
<Accounting db>
        BackStore = DB
        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, )
        QueueLength = 5000
        RecordAcctStart = FALSE
        DBParams = null
        InsertCheckpointAcct = null
</Accounting>

Wed, 11 May 2005 13:06:00 070: FINE:
<Accounting file_acct>
        BackStore = FILE
        InsertAcct = null
        QueueLength = 5000
        RecordAcctStart = TRUE

FileNameFormat = yyyy-MM-dd-HH.csv
AcctDirectory = AcctLog
</Accounting>

Your evaluation license will expire in 25 day(s).

Wed, 11 May 2005 13:06:00 137: INFO: Listener started at: 1812

Wed, 11 May 2005 13:06:00 143: INFO: Listener started at: 1813
Started Successfully <<<

Anyone have any idea how to implement this valuable software in SER because we're gonna pay for it.