Charging & Billing / VAS Adventures

This is to document the config for outside access to VPN , incase i forget again!

access-list outside_nat extended permit ip [vpn client network] 255.255.255.0 any

global (outside) 1 interface

nat (outside) 1 access-list outside_nat

group-policy DfltGrpPolicy attributes

dns-server value [dns server]

nem enable

group-policy VPN attributes

split-tunnel-policy tunnelall

split-tunnel-network-list none

Was playing around with Mbuni for a friend of mine , who wanted to use it as a VASP gateway and interconnect it with an operator over MM7. Spent a little while configuring it and thought of posting the configs here for anyone who’s trying to achieve a similar configuration.

Mbuni consits of

1. MMS Relay
2. MMS Proxy
3. MMS From Email
4. MMSbox

For this sepecific purpose , only MMSBOX is required. I expect that you’re already familiar with either Kannel and / or Mbuni ‘s basic configuration.  So I’ll just focus on MMSBox MM7 integration.

group = mmsc

id = local

mmsc-url = http://username:password@ipaddr:port/mm7/mm7tomms.sh

incoming-username = incominguser

incoming-password = incomingpass

incoming-port = incomingport

allowed-prefix = Prefixes

type = soap

The “mmsc-url” bit is the most important one as it is used for submit_mms over mm7 , this piece of information is provided by the operator , the extra bit [ /mm7/mm7tomms.sh ] is specific to Jinny’s MMSC and your submit URL might be different [ pls. confirm this with your operator ].

The incoming user name , password & port are using to receive “MO-AT” messages over MM7 from the operator. This information will be provided by you to the operator for configuration on their side . Once a AT MMS is received by Mbuni , it can decide based on the service parameters  on exactly what to do with the mms.

The prefixes are the CC+NDC [ Country Code + National Dialing Codes ] that will be allowed for sending over this mm7 connection. Some samples can be +93;+92;+937;07;+923;03 . Make sure you define it in National [ 07X ] , International [ +937X] & Unknown [ 937X] in order to properly cater for the messages [ both incoming & outgoing  ] .

Fire up mmsbox , hit the url with http://ipaddr:port/cgi-bin/sendmms?username=X&password=Y&to=XXXX&from=YYYY&smil=<INSERT SMIL CONTENTS HERE>

Cheers!

Hi,

I wanted a way to quickly pick , loadup and analyze tickets from our IN platform, ( we’re talking about 1.3 Mil + rows for one file in peak hours )  Waseem [ http://convergence.pk ] , was kind enough to spare some time for the setup and we ended up with infobright [ http://infobright.com ] community edition.

Infobright’s based on MySQL and uses knowledge base + vertical coloums , which end up making queries run ridiculously fast.

I’ve compared the results on 122 Million rows , running on oracle [ old setup ] & infobright  [ new setup ] and the results are amazing , a single query on oracle takes 15 minutes to get the results , whereas the same query takes around 2 minutes on infobright

I’ll share the details for the setup , once its finished

Cheers.