Last active
July 2, 2017 06:58
-
-
Save morteza-mori/141dc2577032032826ea6c898a5dcbe1 to your computer and use it in GitHub Desktop.
IBSng
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
install | |
#time | |
LC_ALL="en_US.UTF-8" | |
#repository | |
deb http://ftp.debian.org/debian/ testing main contrib non-free | |
deb http://ftp.debian.org/debian wheezy main | |
#after install package | |
apt-get install libc6-dev | |
apt-get install python-mpi4py | |
apt-get install openmpi-bin | |
apt-get install openmpi-common | |
#ibsng utility | |
wget pkg.parspooyesh.com/pkg/ibsng-utility.deb | |
#proxy | |
export http_proxy="http://151.232.65.130:9999" | |
unset http_proxy; | |
unset ftp_proxy; | |
on another server: | |
python /usr/local/src/tools/custom/proxy/PythonProxy.py |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
#connection log query
select * from connection_log where login_time > '2017-01-30 00:00' and logout_time < '2017-01-31 23:56' and user_id = 161 ;
select * from connection_log_internet_details where connection_log_id = 327058;
select * from connection_log_charge_rule_details where connection_log_id = 327058;
IBSng=# select user_id, sum(credit_used) from connection_log_y2017_m02 where user_id = 175442 and login_time >= '2017-02-10' $