This post is my personal notes (for future retrieval or reference) on a script that can be used to query billing system (in this example Radius Manager) and gather data for all re-seller’s yesterday sales activity and summarize it in a file and email it to Administrator. It comes handy to get idea which dealer made how much sale with number of activated users, sale amount, balance and summarize it in the end for admin view.
As showed in the image below …
SCRIPT
dealer_renewal_yesterday.sh
- mkdir /temp
- touch /temp/dealer_renewal_yesterday.sh
- chmod +x /temp/dealer_renewal_yesterday.sh
- nano /temp/dealer_renewal_yesterday.sh
Paste the following data [but do make sure you modify the data like id password or other before deploying it.]
As wordpress is not letting my copy paste the full code properly, therefore I have updated on my google drive, check it here
https://drive.google.com/drive/u/0/folders/1BRIvT6lr9s66nzPP2tRsBV6G-0YA-Zkw
Install sendEmail Tool
apt-get -y install libio-socket-ssl-perl libnet-ssleay-perl perl apt-get -y install sendemailADD SUPPORTING LIBRARY
For UBUNTU [Life is really easy on ubuntu but with some glitches)
apt-get -y install libio-socket-ssl-perl libnet-ssleay-perl perlFor CENTOS
yum -y install perl perl-Crypt-SSLeay perl-IO-Socket-SSLTEST SENDING EMAIL
Try to send email using command line: Example
/temp/sendEmail-v1.56/sendEmail -t TO_YOURMAIL@hotmail.com -u "Test Email" -s smtp.gmail.com:587 -xu YOURMGAILID@gmail.com -xp YOURGMAILPASSWORD -f YOURMGAILIDgmail.com -o tls=yesIf you get message something like “sendEmail[xxxx]: Email was sent successfully!”, then you are good to GO LIVE !
Regard’s
Syed Jahanzaib
Syed Jahanzaib - Personal Blog to Share Knowledge ! 
Dear sir, i need to add script to radiusmanager that changes user speed after consuming his gb limit without disconnecting his account and stop account disconnect after using all his limit. if possible email me and ill pay for this script.thanks
Sent from my Samsung device
LikeLike
Comment by tareckinho — August 20, 2015 @ 4:02 PM
in general not possible.
Once the user DAILY GB limit crossed, he will be disconnected, so that next service shoudl activated for the rest of the day.
LikeLike
Comment by Syed Jahanzaib / Pinochio~:) — August 21, 2015 @ 10:41 AM
Very good. ¡¡..
LikeLike
Comment by Juan Carlos — August 20, 2015 @ 6:59 PM
salam jhanzaib,
dear jhanzaib i need u to reply on this post https://aacable.wordpress.com/2015/06/15/sending-email-on-router-reboot-with-logs-and-lastseen-time/#comments
atleast tell me if u r helping to solve this issue or not
if yes then how much i have to wait, i;ll wait but please reply me.
my problem is
i follow this post https://aacable.wordpress.com/2011/08/29/mikrotik-4-wan-load-balancing-using-pcc-with-pppoe-server-complete-script/
after this my squid box not work properly as it was working,
then i do too much google also i try ur other ways to redirect http traffic to squid from MT
and two more post by u but i failed to gain my goal,
when i check access.log it shows some request of web sites with client source address but some time not in that time i got timeout error in browser
1 another thing i have to mention that when i access my PTCL router page when MT is DNAT to squid its opening normally from squid every time
but it hangs on browsing, i guess MT not working properly in DNAT to squid
please correct me if i m wrong or atleast reply me,
should i have to wait for it if yes then how long bcoz i cant leave my network without squid
i just want to solve https broken issue when PCC loadbalancing happening if u have any other way to gain this goal then please let me know i will follow that
i have 1 MTx86 os with 14 port lan card
1 CRS series 24 port switch+router.
i glad if u reply me here or in older posts.
thanking you, 🙂
LikeLike
Comment by Rehmat Ali Gulwating — August 23, 2015 @ 9:05 PM
Disable NAT rule then check it ,15 ports in x86 how?
LikeLike
Comment by UmmarHussain — August 29, 2015 @ 12:45 AM
Hello Dear Sir Syed Jahanzaib
sir main multan se Jalil Abbas m NetCable Chala raha hoo menay abhi Wateen se Fiber par connection liya hai pehlay to PTCL chal rahe thay
to sir problem yeh hai k Wateen ka Self Care Portal login system hai
jab tak login nahi karo to net nahi chalta aksar bar bar logout ho jata hai
to bar bar login karna parta hai sir please mujhe koe tareeka btayen k
jis se har 6 hr ya 12 hr k baad auto login ho jaye i mean k mere pass ubuntu bhi chal raha hai proxy cache server ubuntu 10.04 ya to us m koe python Script ban jaye auto login ya phir mikrotik m bas auto login hota rahe
har 6 hr ya phir 12 hr baad so please help me i hope k aap k pass is koe
hull hoga main Wait karo ga ap k reply ka
LikeLike
Comment by Jalil Abbas — September 3, 2015 @ 5:22 PM
you have to first contact wateen if they support API or script base login support then you can use auto login feature.
possibly there could be a way to auto login but it really depends on the operator network. its possible.
LikeLike
Comment by Syed Jahanzaib / Pinochio~:) — September 4, 2015 @ 9:12 AM
Dear Sir,
I have done as you instructed in this tutorial. But I had set the services as per day pricing. Like 10 for monthly 300 plan. Its only showing 10 when users are credited for 300 with amount 30. What I have to change to get 300 without changing the services.
LikeLike
Comment by Arjun Neupane — September 30, 2015 @ 12:19 PM
dear jahanziab Vhai, i forget my mysql password do you know what is default password and i need to setup payment gateway but nobody setup this in my country and DMA want lot of money. can you help me.
LikeLike
Comment by santonu — April 26, 2016 @ 5:58 PM
Dear Boss
Check this
https://zonatsolutions.blogspot.com/p/ip-calc.html
LikeLike
Comment by Talha Ali — November 20, 2016 @ 2:10 AM