IBSng

troubleshooting

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

#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' $