install php in linux

/set server limit using AB command

https://easyengine.io/tutorials/linux/increase-open-files-limit/


http://braintwitter.blogspot.in/2011/10/socket-too-many-open-files-24-error-and.html


//AB comand are given below:-
ab -n 10000 -c 1200 -k -r -H "appinventiv: digivive" -H "authorization:5a59804841fc0b650974a8a6" http://172.31.22.240/clientwebservice/geturlvdailyhunt?nmode=WIFI&appv=1.0.2&build=10004&ct=1&charge_code=LIV033&catlogue=589075657f8b9ae825bb3d0f


check php rpm command

rpm -qa | egrep -i 'php|awk'


PHP 7 instalation


rpm -Uvh http://rpms.remirepo.net/enterprise/remi-release-7.rpm

yum -y install yum-utils

yum update

yum-config-manager --enable remi-php71


yum -y install php php-opcache

yum -y install php-mysqlnd php-pdo

yum -y install php-gd php-ldap php-odbc php-pear php-xml php-xmlrpc php-mbstring php-soap curl curl-devel

yum install php-devel

pecl install http://pecl.php.net/get/geoip-1.1.1.tgz

add extension=geoip.so to php.ini

sudo pecl install mongodb

yum install install php-memcached


=======================================================================================================================================

rsync -arv /data/www/html/unified/admin/upload/. root@172.31.22.106:/home/www/html/unified/admin/upload/ >/dev/null 2>&1


rsync -arv /data/www/html/unified/admin/banner/. root@172.31.22.106:/home/www/html/unified/admin/banner/ >/dev/null 2>&1


rsync -arv /data/www/html/common_hd/admin/upload/. root@172.31.22.106:/home/www/html/common_hd/admin/upload/ >/dev/null 2>&1




rsync -arv /data/www/html/unified/admin/upload/. root@172.31.22.107:/home/www/html/unified/admin/upload/ >/dev/null 2>&1


rsync -arv /data/www/html/unified/admin/banner/. root@172.31.22.107:/home/www/html/unified/admin/banner/ >/dev/null 2>&1


rsync -arv /data/www/html/common_hd/admin/upload/. root@172.31.22.107:/home/www/html/common_hd/admin/upload/ >/dev/null 2>&1

====================================================
Given asset is not playin in website


http://www.nexgtv.com/videos/displayVod/U0w1NzI=/Z2VucmU=/MTQy/NDg4


CRDV_BD_CODE                        SL572

RTSP_2G                  rtsp://vod.nexg.tv/video/v/amz3/digi/spot/Epic_5_Things_Delhi_People_Cant_Live_Without_144p.mp4


HTTP_2G             http://vod.nexg.tv/video/v/amz3/digi/spot/Epic_5_Things_Delhi_People_Cant_Live_Without.smil/playlist.m3u8


HTTP_3G          http://vod.nexg.tv/video/v/amz3/digi/spot/Epic_5_Things_Delhi_People_Cant_Live_Without.smil/playlist.m3u8


MPEG4        http://vod.nexg.tv/video/v/amz3/digi/spot/Epic_5_Things_Delhi_People_Cant_Live_Without.smil/playlist.m3u8         



HTTP_SMIL       http://vod.nexg.tv/video/v/amz3/digi/spot/Epic_5_Things_Delhi_People_Cant_Live_Without.smil/playlist.m3u8



WINDOWS_URL     http://vod.nexg.tv/video/v/amz3/digi/spot/Epic_5_Things_Delhi_People_Cant_Live_Without.smil/Manifest



RTSP_HD                      rtsp://vod.nexg.tv/video/v/amz3/digi/spot/Epic_5_Things_Delhi_People_Cant_Live_Without_320p.mp4












172.31.22.237//webservice/livetv?search_text=aajtak&type=livetv&plateform=


========================================
172.31.22.59 IP



0 4 * * * /usr/syncservice/src/analytics.run.sh
0 17 * * * /usr/syncservice/src/nexg_tv.run.sh
0 4 * * * /home/MySQLdump.sh
0 3 * * * /usr/syncservice/src/nexg_tv.run.sh
0 11 * * * /usr/syncservice/src/11epgsync.run.sh
0 6 * * * /usr/syncservice/src/11epgsync.run.sh
0 1 * * * curl http://172.31.22.59/11KillprocesslistUnified_59.php
*/59 * * * * /var/log/filesize.sh



====================================================

 show slave status \G;

 STOP SLAVE; SET GLOBAL SQL_SLAVE_SKIP_COUNTER=1; START SLAVE;



==============================================================================
358094050867333  dthairtel   3013544087   9958000753  (AIRDTH)



356262056103910  29756971    9371059566  (VIDDTH)




==================================================================
iptables -L -n
chkconfig iptables off
service iptables stop
history
    1  echo PAESSHSTART;df -P;echo PAESSHEND
    2  mysqldump -u root -p unified >/home/MysqlBacup/unified_59/unified_ev_10jult_15.sql
    3  cd /home/MysqlBacup/unified_59
    4  rsync -r unified_ev_10jult_15.sql 172.31.22.60:/home/
    5  echo PAESSHSTART;df -P;echo PAESSHEND
    6  sudo sh -c "sync; echo 3 > /proc/sys/vm/drop_caches"
    7  mysqldump -u root -p unified >/home/MysqlBacup/unified_59/unified_12JULY.sql
    8  cd /home/MysqlBacup/unified_59
    9  rsync -r unified_12JULY.sql  172.31.22.60:/home
   10  echo PAESSHSTART;df -P;echo PAESSHEND
   11  mysqldump -u root -p unified >/home/MysqlBacup/unified_59/unified_12JULY.sql
   12  cd /home/MysqlBacup/unified_59
   13  rsync -r unified_12JULY.sql  172.31.22.60:/home
   14  echo PAESSHSTART;df -P;echo PAESSHEND
   15  mysqldump -u root -p unified >/home/MysqlBacup/unified_59/unified_12JULY_9:13NIGHT.sql
   16  echo PAESSHSTART;df -P;echo PAESSHEND
   17  df -h
   18  sudo sh -c "sync; echo 3 > /proc/sys/vm/drop_caches"
   19  echo PAESSHSTART;df -P;echo PAESSHEND
   20  mysql -u root -p
   21  echo PAESSHSTART;df -P;echo PAESSHEND
   22  sudo sh -c "sync; echo 3 > /proc/sys/vm/drop_caches"
   23  df -h
   24  mysql -u root -p
   25  df -h
   26  echo PAESSHSTART;df -P;echo PAESSHEND
   27  sudo sh -c "sync; echo 3 > /proc/sys/vm/drop_caches"
   28  echo PAESSHSTART;df -P;echo PAESSHEND
   29  df -h
   30  echo PAESSHSTART;df -P;echo PAESSHEND
   31  date
   32  echo PAESSHSTART;df -P;echo PAESSHEND
   33  netstat -an |grep :3306 |wc -l
   34  mysql -u root -p
   35  sudo sh -c "sync; echo 3 > /proc/sys/vm/drop_caches"
   36  echo PAESSHSTART;df -P;echo PAESSHEND
   37  mysqldump -u root -p unified >/home/MysqlBacup/unified_59/unifeid_22July_15.sql
   38  mysql -u root -p
   39  echo PAESSHSTART;df -P;echo PAESSHEND
   40  sudo sh -c "sync; echo 3 > /proc/sys/vm/drop_caches"
   41  ssh 172.31.22.58
   42  echo PAESSHSTART;df -P;echo PAESSHEND
   43  mysqldump -u root -p staging >/home/staging_23July_15.sql
   44  echo PAESSHSTART;df -P;echo PAESSHEND
   45  df -h
   46  mysql -u root -p
   47  df -h
   48  ssh 172.31.22.58
   49  echo PAESSHSTART;df -P;echo PAESSHEND
   50  df-h
   51  df -h
   52  echo PAESSHSTART;df -P;echo PAESSHEND
   53  sudo sh -c "sync; echo 3 > /proc/sys/vm/drop_caches"
   54  echo PAESSHSTART;df -P;echo PAESSHEND
   55  sudo sh -c "sync; echo 3 > /proc/sys/vm/drop_caches"
   56  echo PAESSHSTART;df -P;echo PAESSHEND
  57  uname -a
   58  echo PAESSHSTART;df -P;echo PAESSHEND
   59  mysqldump -u root -p -R >/home/proc1.sql
   60  mysqldump -u root -p unified --routines --triggers >/home/proc1.sql
   61  mysqldump --routines --no-create-info --no-data --no-create-db --skip-opt unified > >/home/proc1.sql
   62  mysqldump --routines --no-create-info --no-data --no-create-db --skip-opt unified > /home/proc1.sql
   63  mysqldump -u root -p  --routines --no-create-info --no-data --no-create-db --skip-opt unified > /home/proc1.sql
   64  echo PAESSHSTART;df -P;echo PAESSHEND
   65  df -h
   66  echo PAESSHSTART;df -P;echo PAESSHEND
   67  mysql -u root -p
   68  ps ax |grep mysql
   69  service mysql stop
   70  service mysql start
   71  mysql -u root -p
   72  mysqldump -u root -p unified >/home/unified_3aug_15.sql
   73  cd /home
   74  rsync -r unified_3aug_15.sql 172.31.22.59:/home
   75  mysql -u root -p
   76  mysqldump -u root -p unified >/home/unified_3aug_15.sql
   77  rsync -r unified_3aug_15.sql 172.31.22.58:/home
   78  mysql -u root -p
   79  rsync -r unified_3aug_15.sql 172.31.22.91:/home
   80  mysqldump -u root -p unified tbl_registered_users tbl_registered_users_hd tbl_registered_users_hd_main tbl_registered_users_main tbl_registered_users_sd >/home/uni_tbl_3aug.sql
   81  rsunc -r uni_tbl_3aug.sql  172.31.22.58:/home/uni_tbl_3aug.sql
   82  rsync -r uni_tbl_3aug.sql  172.31.22.58:/home/uni_tbl_3aug.sql
   83  mysql -u root -p
   84  echo PAESSHSTART;df -P;echo PAESSHEND
   85  sh /usr/syncservice/src/epgsync.run.sh
   86  echo PAESSHSTART;df -P;echo PAESSHEND
   87  cd
   88  cd /home/MysqlBacup/unified_59
   89  rsync -r 172.31.22.45:/home/mysqlbackup
   90  rsync -r unified_592015-08-06_04h01.sql  172.31.22.45:/home/mysqlbackup
   91  echo PAESSHSTART;df -P;echo PAESSHEND
   92  df -h
   93  echo PAESSHSTART;df -P;echo PAESSHEND
   94  mysqldump -u root -p --structure unified >/home/unified_structure.sql
   95  mysqldump -u root -p --no-data  unified >/home/unified_structure.sql
   96  echo PAESSHSTART;df -P;echo PAESSHEND
   97  crontab -e
   98  sh  /usr/syncservice/src/epgsync.run.sh
   99  echo PAESSHSTART;df -P;echo PAESSHEND
  100  df -h
  101  mysql -u root -p
  102  echo PAESSHSTART;df -P;echo PAESSHEND
  103  mysql -u root -p
  104  echo PAESSHSTART;df -P;echo PAESSHEND
  105  sudo sh -c "sync; echo 3 > /proc/sys/vm/drop_caches"
  106  echo PAESSHSTART;df -P;echo PAESSHEND
  107  df -h
  108  mysql -u root -p
  109  echo PAESSHSTART;df -P;echo PAESSHEND
  110  mysqldump -u root -p  --no-data unified >/home/unified_structure_13Aug_15.sql
  111  echo PAESSHSTART;df -P;echo PAESSHEND
  112  df -h
  113  echo PAESSHSTART;df -P;echo PAESSHEND
  114  mysqldump -u root -p unified >/home/MysqlBacup/unified/unified_17Aug.sql
  115  cd /home/MysqlBacup/unified
  116  rsync -r unified_17Aug.sql 172.31.22.58:/home/mysqlBackup/unified
  117  mysql -u root -p
  118  echo PAESSHSTART;df -P;echo PAESSHEND
  119  df -h
  120  mysqldump -u root -p unified  ws_vods ws_subcategory ws_channel ws_category VOD_METADATA VIEW_VOD_MASTER view_vod_detail VIEW_SUBCAT_MASTER view_subcat_detail VIEW_CATEGORY_MASTER view_category_detail version_summary version >/home/unified_table_17Aug_15.sql
  121  cd /home
  122  rsync -r unified_table_17Aug_15.sql 172.31.22.58:/home
  123  echo PAESSHSTART;df -P;echo PAESSHEND
  124  sudo sh -c "sync; echo 3 > /proc/sys/vm/drop_caches"
  125  echo PAESSHSTART;df -P;echo PAESSHEND
  126  mysqldump -u root -p unified >/home/unified_19aug.sql
  127  cd home
  128  cd /home
  129  rsync -r unified_19aug.sql 172.31.22.58:/home
  130  mysql -u root -p
  131  echo PAESSHSTART;df -P;echo PAESSHEND
  132  df -h
  133  mysqldump -u rooot -p unified >/home/unified_19Aug_15.sql
  134  mysqldump -u root -p unified >/home/unified_19Aug.sql
  135  cd /home
  136  rsync -r unified_19Aug.sql 172.31.22..58:/home
  137  rsync -r unified_19Aug.sql 172.31.22.58:/home
  138  mysql -u root -p
  139  echo PAESSHSTART;df -P;echo PAESSHEND
  140  mysql -u root -p
  141  echo PAESSHSTART;df -P;echo PAESSHEND
  142  mysqldump -u root -p unified >/home/unified_20Aug.sql
  143  cd /home
  144  rsync -r  unified_20Aug.sql  -r 172.31.22.58:/home
  145  df -h
  146  mysql -u root -p
  147  echo PAESSHSTART;df -P;echo PAESSHEND
  148  df -h
  149  echo PAESSHSTART;df -P;echo PAESSHEND
  150  sudo sh -c "sync; echo 3 > /proc/sys/vm/drop_caches"
  151  echo PAESSHSTART;df -P;echo PAESSHEND
  152  df -h
  153  mysql -u root -p
  154  df -h
  155  echo PAESSHSTART;df -P;echo PAESSHEND
  156  ps ax |grep mysql
  157  kill -9 4399
  158  ps ax |grep mysql
  159  echo PAESSHSTART;df -P;echo PAESSHEND
  160  mysql -u root -p
  161  echo PAESSHSTART;df -P;echo PAESSHEND
  162  service mysql stop
  163  service mysql start
  164  mysqldump -u root -p unified >/home/unified_25Aug_15.sql
  165  rsync -r unified_25Aug_15.sql 172.31.22.58:/home/
  166  rsync -r /home/unified_25Aug_15.sql 172.31.22.58:/home/
  167  sudo sh -c "sync; echo 3 > /proc/sys/vm/drop_caches"
  168  echo PAESSHSTART;df -P;echo PAESSHEND
  169  sudo sh -c "sync; echo 3 > /proc/sys/vm/drop_caches"
  170  df -h
  171  echo PAESSHSTART;df -P;echo PAESSHEND
  172  cat CPUinfo
  173  /cat/cpuinfo
  174  echo PAESSHSTART;df -P;echo PAESSHEND
  175  crontab -e
  176  echo PAESSHSTART;df -P;echo PAESSHEND
  177  sh /usr/syncservice/src/epgsync.run.sh
  178  crontab -e
  179  echo PAESSHSTART;df -P;echo PAESSHEND
  180  sh /usr/syncservice/src/epgsync.run.sh
  181  ssh 172.31.22.159
  182  echo PAESSHSTART;df -P;echo PAESSHEND
  183  sudo sh -c "sync; echo 3 > /proc/sys/vm/drop_caches"
  184  df -h
  185  show binary logs\G;
  186  mysql -u root -p
  187  df -h
  188  echo PAESSHSTART;df -P;echo PAESSHEND
  189  mysqldump -u root -p unified CHANNEL_DETAIL_VIEW CHANNEL_RTSP_DETAILS_VIEW PACKAGE_CHANNEL_MAP_VIEW PACKAGE_MASTER_VIEW VIEW_VOD_MASTER VOD_METADATA ws_vods ws_category ws_channel ws_subcategory >/home/unified_2SEP_15sometable.sql
  190  mysql -u root -p
  191  mysqldump -u root -p unified  >/home/unified_2SEP_15sometable.sql
  192  mysql -u root -p
  193  echo PAESSHSTART;df -P;echo PAESSHEND
  194  df -h
  195  sudo sh -c "sync; echo 3 > /proc/sys/vm/drop_caches"
  196  df -h
  197  mysql -u root -p
  198  df -h
  199  mysql -u root -p
  200  df -h
  201  echo PAESSHSTART;df -P;echo PAESSHEND
  202  df -h
  203  free -m
  204  sudo sh -c "sync; echo 3 > /proc/sys/vm/drop_caches"
  205  free -m
  206  df -h
  207  ssh 172.31.22.58
  208  echo PAESSHSTART;df -P;echo PAESSHEND
  209  mysqldump -u root -p unified PACKAGE_CHANNEL_MAP_VIEW PACKAGE_MASTER_VIEW >/home/unified_2table.sql
  210  mysql -u root -p
  211  echo PAESSHSTART;df -P;echo PAESSHEND
  212  df -h
  213  sudo sh -c "sync; echo 3 > /proc/sys/vm/drop_caches"
  214  echo PAESSHSTART;df -P;echo PAESSHEND
  215  df -h
  216  mysql -u root -p
  217  df -h
  218  echo PAESSHSTART;df -P;echo PAESSHEND
  219  df -h
  220  echo PAESSHSTART;df -P;echo PAESSHEND
  221  df -h
  222  top
  223  sudo sh -c "sync; echo 3 > /proc/sys/vm/drop_caches"
  224  top
  225  echo PAESSHSTART;df -P;echo PAESSHEND
  226  df -h
  227  sudo sh -c "sync; echo 3 > /proc/sys/vm/drop_caches"
  228  mysql -u root -p
  229  echo PAESSHSTART;df -P;echo PAESSHEND
  230  df -h
  231  sudo sh -c "sync; echo 3 > /proc/sys/vm/drop_caches"
  232  echo PAESSHSTART;df -P;echo PAESSHEND
  233  mysqldump -u root -p unified tbl_registered_users_main >/home/tbl_registered_users_main_21sep15.sql
  234  cd home
  235  cd /home
  236  rsync -r tbl_registered_users_main_21sep15.sql 172.31.22.58:/home
  237  echo PAESSHSTART;df -P;echo PAESSHEND
  238  df -h
  239  mysql -u rooot -p
  240  mysql -u root -p
  241  df -h
  242  echo PAESSHSTART;df -P;echo PAESSHEND
  243  sudo sh -c "sync; echo 3 > /proc/sys/vm/drop_caches"
  244  echo PAESSHSTART;df -P;echo PAESSHEND
  245  mysql -u root -p
  246  echo PAESSHSTART;df -P;echo PAESSHEND
  247  mysql -u root -p
  248  echo PAESSHSTART;df -P;echo PAESSHEND
  249  df -h
  250  mysql -u root -p
  251  df -h
  252  echo PAESSHSTART;df -P;echo PAESSHEND
  253  df -h
  254  sudo sh -c "sync; echo 3 > /proc/sys/vm/drop_caches"
  255  echo PAESSHSTART;df -P;echo PAESSHEND
  256  df -h
  257  sudo sh -c "sync; echo 3 > /proc/sys/vm/drop_caches"
  258  echo PAESSHSTART;df -P;echo PAESSHEND
  259  df -h
  260  mysql -u root -p
  261  df -h
  262  sudo sh -c "sync; echo 3 > /proc/sys/vm/drop_caches"
  263  echo PAESSHSTART;df -P;echo PAESSHEND
  264  mysqldump -u root -p unified >/home/unifed_3oct_15.sql
  265  mysql -u root -p
  266  cd /home
  267  rsync -r unifed_3oct_15.sql 172.31.22.58:/home
  268  mysql -u root -p
  269  mysqldump -u root -p unified >/home/unified_3oct.sql
  270  echo PAESSHSTART;df -P;echo PAESSHEND
  271  cd /home
  272  rsync -r unified_3oct.sql 172.31.22.58:/home
  273  echo PAESSHSTART;df -P;echo PAESSHEND
  274  mysql -u root -p
  275  echo PAESSHSTART;df -P;echo PAESSHEND
  276  mysql -u root -p
  277  echo PAESSHSTART;df -P;echo PAESSHEND
  278  cat /proc/cpuinfo
  279  grep flags /proc/cpuinfo
  280  uname -m
  281  uname -a
  282  echo PAESSHSTART;df -P;echo PAESSHEND
  283  df -h
  284  mysql -u root -p
  285  df -h
  286  echo PAESSHSTART;df -P;echo PAESSHEND
  287  sudo sh -c "sync; echo 3 > /proc/sys/vm/drop_caches"
  288  echo PAESSHSTART;df -P;echo PAESSHEND
  289  mysqldump -u root -p unified >/home/unified_8Oct.sql
  290  cd /home
  291  rsync -r unified_8Oct.sql 172.31.22.60:/home
  292  mysqldump -u root -p unified >/home/unified_8Oct.sql
  293  rsync -r unified_8Oct.sql 172.31.22.60:/home
  294  mysqldump -u root -p unified >/home/unified_8Oct.sql
  295  rsync -r unified_8Oct.sql 172.31.22.60:/home
  296  echo PAESSHSTART;df -P;echo PAESSHEND
  297  mysql -u root -p
  298  echo PAESSHSTART;df -P;echo PAESSHEND
  299  df -h
  300  sudo sh -c "sync; echo 3 > /proc/sys/vm/drop_caches"
  301  mysql -u root -p
  302  df -h
  303  echo PAESSHSTART;df -P;echo PAESSHEND
  304  df -h
  305  echo PAESSHSTART;df -P;echo PAESSHEND
  306  mysql -u root -p
  307  echo PAESSHSTART;df -P;echo PAESSHEND
  308  mysql -u root -p
  309  echo PAESSHSTART;df -P;echo PAESSHEND
  310  sh usr/syncservice/src/epgsync.run.sh
  311  crontab -e
  312  sh /usr/syncservice/src/epgsync.run.sh
  313  echo PAESSHSTART;df -P;echo PAESSHEND
  314  df -h
  315  echo PAESSHSTART;df -P;echo PAESSHEND
  316  df -h
  317  mysql - u root -p
  318  mysql -u root -p
  319  df -h
  320  echo PAESSHSTART;df -P;echo PAESSHEND
  321  df -h
  322  mysql - uroot -p
  323  mysql -u root -p
  324  df -h
  325  echo PAESSHSTART;df -P;echo PAESSHEND
  326  df -h
  327  echo PAESSHSTART;df -P;echo PAESSHEND
  328  df -h
  329  mysql -u root -p
  330  df -h
  331  echo PAESSHSTART;df -P;echo PAESSHEND
  332  sudo sh -c "sync; echo 3 > /proc/sys/vm/drop_caches"
  333  echo PAESSHSTART;df -P;echo PAESSHEND
  334  df -h
  335  mysql -u root -p
  336  df -h
  337  echo PAESSHSTART;df -P;echo PAESSHEND
  338  df -h
  339  mysqldump -u root -p
  340  mysqldump -u root -p unified >/home/MysqlBacup/unified_59/unified_31Oct_15.sql
  341  service mysql stop
  342  service mysql start
  343  sudo sh -c "sync; echo 3 > /proc/sys/vm/drop_caches"
  344  echo PAESSHSTART;df -P;echo PAESSHEND
  345  df -h
  346  sudo sh -c "sync; echo 3 > /proc/sys/vm/drop_caches"
  347  echo PAESSHSTART;df -P;echo PAESSHEND
  348  sudo sh -c "sync; echo 3 > /proc/sys/vm/drop_caches"
  349  df -h
  350  mysql -u root -p
  351  df -h
  352  echo PAESSHSTART;df -P;echo PAESSHEND
  353  mysql -u root -p
  354  echo PAESSHSTART;df -P;echo PAESSHEND
  355  sudo sh -c "sync; echo 3 > /proc/sys/vm/drop_caches"
  356  echo PAESSHSTART;df -P;echo PAESSHEND
  357  df -h
  358  echo PAESSHSTART;df -P;echo PAESSHEND
  359  sudo sh -c "sync; echo 3 > /proc/sys/vm/drop_caches"
  360  echo PAESSHSTART;df -P;echo PAESSHEND
  361  df -h
  362  sudo sh -c "sync; echo 3 > /proc/sys/vm/drop_caches"
  363  mysql -u root -p
  364  df -h
  365  echo PAESSHSTART;df -P;echo PAESSHEND
  366  df -h
  367  echo PAESSHSTART;df -P;echo PAESSHEND
  368  sudo sh -c "sync; echo 3 > /proc/sys/vm/drop_caches"
  369  echo PAESSHSTART;df -P;echo PAESSHEND
  370  df -h
  371  sudo sh -c "sync; echo 3 > /proc/sys/vm/drop_caches"
  372  mysql -u root -p
  373  df -h
  374  echo PAESSHSTART;df -P;echo PAESSHEND
  375  sudo sh -c "sync; echo 3 > /proc/sys/vm/drop_caches"
  376  echo PAESSHSTART;df -P;echo PAESSHEND
  377  df -h
  378  mysqldump -u root -p unified >/home/MysqlBacup/unified_59/unified_18Nov_15.sql
  379  echo PAESSHSTART;df -P;echo PAESSHEND
  380  crontab -e
  381  echo PAESSHSTART;df -P;echo PAESSHEND
  382  sh /usr/syncservice/src/epgsync.run.sh
  383  echo PAESSHSTART;df -P;echo PAESSHEND
  384  df -h
  385  mysql -u root -p
  386  df -h
  387  echo PAESSHSTART;df -P;echo PAESSHEND
  388  sudo sh -c "sync; echo 3 > /proc/sys/vm/drop_caches"
  389  echo PAESSHSTART;df -P;echo PAESSHEND
  390  crontab -e
  391  sh /usr/syncservice/src/epgsync.run.sh
  392  echo PAESSHSTART;df -P;echo PAESSHEND
  393  sudo sh -c "sync; echo 3 > /proc/sys/vm/drop_caches"
  394  df -h
  395  mysql -u root -p
  396  df -h
  397  echo PAESSHSTART;df -P;echo PAESSHEND
  398  sudo sh -c "sync; echo 3 > /proc/sys/vm/drop_caches"
  399  echo PAESSHSTART;df -P;echo PAESSHEND
  400  df -h
  401  mysql -u root -p
  402  df -h
  403  echo PAESSHSTART;df -P;echo PAESSHEND
  404  mysqldump -u root -p --no-data unified > /home/unified_struct_2dec_15.sql
  405  echo PAESSHSTART;df -P;echo PAESSHEND
  406  cd /var/lib/mysql
  407  tail -f mysql-bin.000472
  408  echo PAESSHSTART;df -P;echo PAESSHEND
  409  sudo sh -c "sync; echo 3 > /proc/sys/vm/drop_caches"
  410  cd /home/MysqlBacup/unified_59
  411  rsync -r unified_592015-12-02_04h01.sql  172.31.22.91:/home
  412  echo PAESSHSTART;df -P;echo PAESSHEND
  413  crontab -e
  414  sh /usr/syncservice/src/epgsync.run.sh
  415  echo PAESSHSTART;df -P;echo PAESSHEND
  416  df -h
  417  echo PAESSHSTART;df -P;echo PAESSHEND
  418  df -h
  419  mysql -u root -p
  420  df -h
  421  echo PAESSHSTART;df -P;echo PAESSHEND
  422  df-h
  423  df -h
  424  sudo sh -c "sync; echo 3 > /proc/sys/vm/drop_caches"
  425  mysql -u root -p
  426  df -h
  427  echo PAESSHSTART;df -P;echo PAESSHEND
  428  df -h
  429  mysql -u root -p
  430  echo PAESSHSTART;df -P;echo PAESSHEND
  431  df -h
  432  sudo sh -c "sync; echo 3 > /proc/sys/vm/drop_caches"
  433  echo PAESSHSTART;df -P;echo PAESSHEND
  434  df -h
  435  mysql -u root -p
  436  df -h
  437  mysql -u root -p
  438  sudo sh -c "sync; echo 3 > /proc/sys/vm/drop_caches"
  439  echo PAESSHSTART;df -P;echo PAESSHEND
  440  df -h
  441  mysql -u root -p
  442  sudo sh -c "sync; echo 3 > /proc/sys/vm/drop_caches"
  443  df -h
  444  echo PAESSHSTART;df -P;echo PAESSHEND
  445  sudo sh -c "sync; echo 3 > /proc/sys/vm/drop_caches"
  446  df -h
  447  echo PAESSHSTART;df -P;echo PAESSHEND
  448  sudo sh -c "sync; echo 3 > /proc/sys/vm/drop_caches"
  449  echo PAESSHSTART;df -P;echo PAESSHEND
  450  mysql -u root -p
  451  echo PAESSHSTART;df -P;echo PAESSHEND
  452  df -h
  453  mysql -u root -p
  454  df -h
  455  echo PAESSHSTART;df -P;echo PAESSHEND
  456  exit
  457  echo PAESSHSTART;df -P;echo PAESSHEND
  458  vim .ssh/authorized_keys
  459  chmod 600 .ssh/authorized_keys
  460  echo PAESSHSTART;df -P;echo PAESSHEND
  461  mysql -u root -p
  462  echo PAESSHSTART;df -P;echo PAESSHEND
  463  mysql -u root -p
  464  echo PAESSHSTART;df -P;echo PAESSHEND
  465  mysql -u root -p
  466  echo PAESSHSTART;df -P;echo PAESSHEND
  467  cd /db/
  468  ll
  469  cd bckup/
  470  ll
  471  du -sh unified-21-12-2015.sql
  472  ll
  473  gzip unified-21-12-2015.sql
  474  ll
  475  echo PAESSHSTART;df -P;echo PAESSHEND
  476  df -h
  477  cd /db/
  478  ll
  479  vim /etc/my.cnf
  480  cd bckup/
  481  ll
  482  cd ..
  483  cd mysql/
  484  ll
  485  du -sh unified/
  486  cd ..
  487  ll
  488  mysqldump -u root -p unified > bckup/unified-21-12-2015.sql
  489  ll
  490  cd bckup/
  491  ll
  492  du -sh unified-21-12-2015.sql.gz
  493  ll
  494  du -sh unified-21-12-2015.sql.gz
  495  ll
  496  du -sh unified-21-12-2015.sql.gz
  497  echo PAESSHSTART;df -P;echo PAESSHEND
  498  df -h
  499  echo PAESSHSTART;df -P;echo PAESSHEND
  500  sudo sh -c "sync; echo 3 > /proc/sys/vm/drop_caches
  501  "
  502  echo PAESSHSTART;df -P;echo PAESSHEND
  503  cat /proc/cpuinfo
  504  free -m
  505  top
  506  sudo sh -c "sync; echo 3 > /proc/sys/vm/drop_caches"
  507  echo PAESSHSTART;df -P;echo PAESSHEND
  508  df -h
  509  crontab -e
  510  echo PAESSHSTART;df -P;echo PAESSHEND
  511  df -h
  512  crontab -e
  513  cd /usr/syncservice/src
  514  javac EPGSync.java
  515  crontab -e
  516  sh /usr/syncservice/src/epgsync.run.sh
  517  df -h
  518  echo PAESSHSTART;df -P;echo PAESSHEND
 519  df -h
  520  echo PAESSHSTART;df -P;echo PAESSHEND
  521  mysql -u root -p
  522  ifconfig
  523  echo PAESSHSTART;df -P;echo PAESSHEND
  524  sudo sh -c "sync; echo 3 > /proc/sys/vm/drop_caches"
  525  echo PAESSHSTART;df -P;echo PAESSHEND
  526  df -h
  527  mysqldump -u root -p unified  tbl_registered_users_main tbl_registered_users >/home/tbl_reg_users_28dec_15.sql
  528  mysqldump -u root -p unified  tbl_registered_users_main >/home/tbl_reg_users_28dec1_15.sql
  529  mysql -u root -p
  530  echo PAESSHSTART;df -P;echo PAESSHEND
  531  df -h
  532  sudo sh -c "sync; echo 3 > /proc/sys/vm/drop_caches"
  533  mysql -u root -p
  534  echo PAESSHSTART;df -P;echo PAESSHEND
  535  df -h
  536  echo PAESSHSTART;df -P;echo PAESSHEND
  537  ifconfig
  538  exit
  539  echo PAESSHSTART;df -P;echo PAESSHEND
  540  df -h
  541  sudo sh -c "sync; echo 3 > /proc/sys/vm/drop_caches"
  542  mysql -u root -p
  543  df -h
  544  echo PAESSHSTART;df -P;echo PAESSHEND
  545  ifconfig
  546  exit
  547  echo PAESSHSTART;df -P;echo PAESSHEND
  548  crontab 0l
  549  crontab -l
  550  vim /home/MySQLdump.sh
  551  df -h
  552  cd /home/
  553  ll
  554  cd MysqlBacup/
  555  ll
  556  cd aircel/
  557  l
  558  ll
  559  du -sh aircel_2016-01-07_04h00.sql
  560  ll
  561  cd ..
  562  ll
  563  cd common_hd/
  564  ll
  565  du -sh common_hd_2016-01-07_04h00.sql
  566  ll
  567  df -h
  568  cd /
  569  ll
  570  du -sh *
  571  cd var/
  572  ll
  573  du -sh *
  574  cd lib/
  575  ll
  576  du -sh *
  577  cd mysql
  578  ll
  579  df -h
  580  cd /db
  581  ll
  582  cd bckup/
  583  ll
  584  cd /home/MysqlBacup/
  585  ll
  586  cd common_hd/
  587  ll
  588  echo PAESSHSTART;df -P;echo PAESSHEND
  589  df -h
  590  cd /home/
  591  ll
  592  du -sh *
  593  cd MysqlBacup/
  594  ll
  595  du -sh *
  596  crontab -
  597  crontab -l
  598  cat /usr/syncservice/src/epgsync.run.sh
  599  cat /var/log/filesize.sh
  600  tail -f /var/log/mysqld.log
  601  vim /etc/my.cnf
  602  tail -f /var/log/mysqld.log
  603  ll
  604  crontab -l
  605  vim /home/MySQLdump.sh
  606  ll
  607  vim ORACLEdump.sh
  608  vim /home/MysqlBacup/unified.sql
  609  du -sh tbl_registered_users_17Feb.sql
  610  vim tbl_registered_users_17Feb.sql
  611  ls -ltr
  612  du -sh bcup/
  613  cd bcup/
  614  ll
  615  gzip *
  616  ll
  617  cd ..
  618  ll
  619  gzip tbl_registered_users_17Feb.sql
  620  ll
  621  cd aircel/
  622  ll
  623  gzip *
  624  ll
  625  cd ..
  626  ll
  627  cd bcup/
  628  ll
  629  cd ..
  630  ll
  631  cd common_hd/
  632  ll
  633  gzip *
  634  cd ..
  635  ll
  636  cd dthairtel/
  637  ll
  638  gzip *
  639  ll
  640  cd ..
  641  ll
  642  cd ondeck/
  643  ll
  644  gzip *
  645  ll
  646  cd ..
  647  ll
  648  cd unified
  649  ll
  650  gzip *
  651  ll
  652  cd ..
  653  ll
  654  cd unified_59/
  655  ll
  656  gzip *
  657  ll
  658  cd ..
  659  ll
  660  cd VIDDTH/
  661  l
  662  ll
  663  gzip *
  664  ll
  665  cd ..
  666  ll
  667  echo PAESSHSTART;df -P;echo PAESSHEND
  668  cd /home/MysqlBacup/unified_59
  669  rsync -r unified_592016-01-07_04h01.sql.gz 172.31.22.91:/home
  670  echo PAESSHSTART;df -P;echo PAESSHEND
  671  df -h
  672  crontab -l
  673  sudo sh -c "sync; echo 3 > /proc/sys/vm/drop_caches"
  674  echo PAESSHSTART;df -P;echo PAESSHEND
  675  df -h
  676  mysql -u root -p
  677  sudo sh -c "sync; echo 3 > /proc/sys/vm/drop_caches"
  678  echo PAESSHSTART;df -P;echo PAESSHEND
  679  ll
  680  cd /
  681  ll
  682  df -h
  683  cd /home/
  684  ll
  685  cd database/
  686  ll
  687  cd mysql/
  688  ll
  689  cd ..
  690  ll
  691  cd MysqlBacup/
  692  ll
  693  cd unified
  694  ll
  695  ls -lr
  696  sl -ltr
  697  ls -ltr
  698  scp unified_2016-01-14_04h00.sql.gz root@172.31.22.91:~/tools/
  699  ifconfig
  700  echo PAESSHSTART;df -P;echo PAESSHEND
  701  df -h
  702  crontab -e
  703  ssh 172.31.22.159
  704  echo PAESSHSTART;df -P;echo PAESSHEND
  705  cd /usr/syncservice/src
  706  javac Oracle2sql.java
  707  crontab -l
  708  crontab -e
  709  echo PAESSHSTART;df -P;echo PAESSHEND
  710  df -h
  711  mysql -u root -p
  712  df -h
  713  echo PAESSHSTART;df -P;echo PAESSHEND
  714  ifconfig
  715  df -h
  716  cd /
  717  ll
  718  du -sh *
  719  df -h
  720  cd /var/
  721  l;
  722  ll
  723  du -sh *
  724  cd lib/
  725  ll
  726  du -sh *
  727  cd mysql
  728  ll
  729  vim /etc/my.cnf
  730  mysql -u root -p
  731  ls -ltr
  732  mysql -u root -p
  733  ls -ltr
  734  df -h
  735  mysql -u root -p
  736  ll
  737  df -h
  738  vim /etc/my.cnf
  739  mysql -u root -p
  740  echo PAESSHSTART;df -P;echo PAESSHEND
  741  df -h
  742  mysql -u root -p
  743  echo PAESSHSTART;df -P;echo PAESSHEND
  744  df -h
  745  echo PAESSHSTART;df -P;echo PAESSHEND
  746  ifcofnig
  747  ifconfig
  748  df -h
  749  mysql -u root -p
  750  df -h
  751  cd /db/
  752  ll
  753  cd bckup/
  754  ll
  755  cd ..
  756  cd mysql/
  757  ll
  758  pwd
  759  vim /etc/my.cnf
  760  crontab -l
  761  vim /home/MySQLdump.sh
  762  cd  /home/MysqlBacup/unified
  763  ls -ltr
  764  gunzip unified_2016-02-04_04h00.sql.gz
  765  ll
  766  mysql -u root -p unifiedtest < unified_2016-02-04_04h00.sql
  767  echo PAESSHSTART;df -P;echo PAESSHEND
  768  cd /usr/syncservice/src
  769  javac Oracle2sql.java
  770  echo PAESSHSTART;df -P;echo PAESSHEND
  771  /etc/init.d/mysql restart
  772  /etc/init.d/mysql status
  773  mysql -u root -p
  774  df -h
  775  uptime
  776  top -d 2
  777  mysql -u root -p
  778  echo PAESSHSTART;df -P;echo PAESSHEND
  779  cat .ssh/authorized_keys
  780  echo PAESSHSTART;df -P;echo PAESSHEND
  781  top -d 2
  782  echo PAESSHSTART;df -P;echo PAESSHEND
  783  ls -ltr
  784  mysql -u root -p
  785  cd /home/My
  786  cd /home/MySQLdump
  787  cd /home/MysqlBacup/
  788  ll
  789  cd unified
  790  ls -ltr
  791  mysql -u root -p unifiedtest < unified_2016-02-04_04h00.sql
  792  echo PAESSHSTART;df -P;echo PAESSHEND
  793  ifconfig
  794  exit
  795  echo PAESSHSTART;df -P;echo PAESSHEND
  796  mysql -u root -p
  797  echo PAESSHSTART;df -P;echo PAESSHEND
  798  mysql -u root -p
  799  echo PAESSHSTART;df -P;echo PAESSHEND
  800  df -h
  801  mysql -u root -p
  802  echo PAESSHSTART;df -P;echo PAESSHEND
  803  free -m
  804  top -d 2
  805  cat /proc/cpuinfo
  806  df -h
  807  cat /etc/redhat-release
  808  uname a-
  809  uname -a
  810  echo PAESSHSTART;df -P;echo PAESSHEND
  811  cat .ssh/authorized_keys
  812  echo PAESSHSTART;df -P;echo PAESSHEND
  813  mysql -u root -p
  814  exit
  815  echo PAESSHSTART;df -P;echo PAESSHEND
  816  crontab -l
  817  echo PAESSHSTART;df -P;echo PAESSHEND
  818  cat /proc/cpuinfo
  819  ssh root@172.31.22.60
  820  exit
  821  echo PAESSHSTART;df -P;echo PAESSHEND
  822  route -n
  823  vim /etc/sysconfig/network-scripts/route-eth0
  824  exit
  825  echo PAESSHSTART;df -P;echo PAESSHEND
  826  route -n
  827  exit
  828  echo PAESSHSTART;df -P;echo PAESSHEND
  829  route -n
  830  ssh root@172.31.22.60
  831  ssh root@172.31.22.160
  832  exit
  833  echo PAESSHSTART;df -P;echo PAESSHEND
  834  df -kh
  835  ssh root@172.31.22.60
  836  exit
  837  echo PAESSHSTART;df -P;echo PAESSHEND
  838  crontab -l
  839  echo PAESSHSTART;df -P;echo PAESSHEND
  840  cd /
  841  ll
  842  df -h
  843  cd /home/
  844  ll
  845  cd MysqlBacup/
  846  l
  847  ls -ltr
  848  cd common_hd/
  849  ls -ltr
  850  cd ..
  851  ls -ltr
  852  cd unified
  853  ls -ltr
  854  scp unified_2016-03-14_04h00.sql.gz root@172.31.22.91:/root/tools/
  855  echo PAESSHSTART;df -P;echo PAESSHEND
  856  mysqldump -u root -p unified >/home/unified_15march.sql
  857  cd /home
  858  rsync -r unified_15march.sql   172.31.22.91:/home
  859  echo PAESSHSTART;df -P;echo PAESSHEND
  860  sudo sh -c "sync; echo 3 > /proc/sys/vm/drop_caches"
  861  df -h
  862  mysql -u root -p
  863  df -h
  864  echo PAESSHSTART;df -P;echo PAESSHEND
  865  crontab -ll
  866  crontab -l
  867  crontab -e
  868  echo PAESSHSTART;df -P;echo PAESSHEND
 869  mysql -u root -p unififed
  870  mysql -u root -p unified
  871  echo PAESSHSTART;df -P;echo PAESSHEND
  872  mysql -u root -p unified
  873  echo PAESSHSTART;df -P;echo PAESSHEND
  874  df -h
  875  du -sh *
  876  df -h
  877  mysql -u root -p
  878  df -h
  879  echo PAESSHSTART;df -P;echo PAESSHEND
  880  mysql -u root -p
  881  echo PAESSHSTART;df -P;echo PAESSHEND
  882  telnet 172.29.10.105 1521
  883  echo PAESSHSTART;df -P;echo PAESSHEND
  884  telnet 172.29.10.117 1521
  885  telnet 172.29.10.105 1521
  886  echo PAESSHSTART;df -P;echo PAESSHEND
  887  sudo sh -c "sync; echo 3 > /proc/sys/vm/drop_caches"
  888  echo PAESSHSTART;df -P;echo PAESSHEND
  889  df -h
  890  mysql -u root -p
  891  echo PAESSHSTART;df -P;echo PAESSHEND
  892  crontab -l
  893  echo PAESSHSTART;df -P;echo PAESSHEND
  894  mysql -u root -p
  895  echo PAESSHSTART;df -P;echo PAESSHEND
  896  crontab -l
  897  echo PAESSHSTART;df -P;echo PAESSHEND
  898  crontab -e
  899  echo PAESSHSTART;df -P;echo PAESSHEND
  900  crontab -e
  901  sh /usr/syncservice/src/nexg_tv.run.sh
  902  echo PAESSHSTART;df -P;echo PAESSHEND
  903  crontab -e
  904  crontab -l
  905  sh /usr/syncservice/src/nexg_tv.run.sh
  906  echo PAESSHSTART;df -P;echo PAESSHEND
  907  mysql -u root -p
  908  echo PAESSHSTART;df -P;echo PAESSHEND
  909  cd /usr/syncservice/src
  910  javac Oracle2sql.java
  911  javac Oracle2sql_vod_dect.java
  912  df -h
  913  mysql -u root -p
  914  df -h
  915  java -classpath .:/usr/syncservice/src/mysql-connector-java-5.0.8-bin.jar:/usr/syncservice/src/ojdbc14.jar:/usr/syncservice/src Oracle2sql
  916  service memcached relaod
  917  service memcached reload
  918  service memcache  reload
  919  echo PAESSHSTART;df -P;echo PAESSHEND
  920  ps -wef |grep java|grep -v grep
  921  echo PAESSHSTART;df -P;echo PAESSHEND
  922  crontab -l
  923  crontab -e
  924  crontab -l
  925  echo PAESSHSTART;df -P;echo PAESSHEND
  926  crontab -l
  927  echo PAESSHSTART;df -P;echo PAESSHEND
  928  mysql -u root -p
  929  echo PAESSHSTART;df -P;echo PAESSHEND
  930  df -h
  931  top
  932  mysql -u root -p
  933  date
  934  mysql -u root -p
  935  echo PAESSHSTART;df -P;echo PAESSHEND
  936  crontab -e
  937  echo PAESSHSTART;df -P;echo PAESSHEND
  938  top
  939  sh /usr/syncservice/src/nexg_tv.run.sh
  940  echo PAESSHSTART;df -P;echo PAESSHEND
  941  crontab -l
  942  crontab -e
  943  echo PAESSHSTART;df -P;echo PAESSHEND
  944  df -h
  945  du -sh*
  946  df -h
  947  echo PAESSHSTART;df -P;echo PAESSHEND
  948  crontab -e
  949  echo PAESSHSTART;df -P;echo PAESSHEND
  950  crontab -e
  951  crontab -l
  952  echo PAESSHSTART;df -P;echo PAESSHEND
  953  df -h
  954  mysqldump -u root -p --no-data unified>unifiedstructuredump.sql
  955  mysql -u root -p
  956  echo PAESSHSTART;df -P;echo PAESSHEND
  957  cd /usr/syncservice/src
  958  javac Oracle2sqlAnalytics.java
  959  crontab -l
  960  crontab -e
  961  echo PAESSHSTART;df -P;echo PAESSHEND
  962  crontab -l
  963  ps -wef |grep nexg_tv.run
  964  ps -wef |grep nexg_tv.run |grep -v grep
  965  sh /usr/syncservice/src/nexg_tv.run.sh
  966  echo PAESSHSTART;df -P;echo PAESSHEND
  967  rpm -qa |grep MySQL
  968  ifcofnig
  969  ifconifg
  970  ifconfig
  971  rpm -qa |grep MySQL
  972  mysql -u root -p
  973  cat /etc/resolv.conf
  974  cd /var/log/mysql
  975  ls -ltr
  976  echo PAESSHSTART;df -P;echo PAESSHEND
  977  cd /db/
  978  ll
  979  du -sh mysqlbak/
  980  cd /root/tools/
  981  ll
  982  vim /etc/my.cnf
  983  du -sh /db/mysql/
  984  df -h
  985  cp -prv /db/mysql /db/mysqlbak
  986  cd
  987  rpm -qa |grep mysql
  988  rpm -qa |grep MySQL
  989  /etc/init.d/mysql stop
  990  rpm -e MySQL-server-advanced MySQL-shared-advanced MySQL-embedded-advanced MySQL-test-advanced MySQL-client-advanced MySQL-devel-advanced
  991  rpm -qa |grep MySQL
  992  cd tools/
  993  ll
  994  rpm -Uvn *
  995  rpm -Uvh *
  996  /etc/init.d/mysql start
  997  msyql -u root -p
  998  mysql -u root -p
  999  echo PAESSHSTART;df -P;echo PAESSHEND
1000  history
[root@INDB-0-2 ~]# history
    1  echo PAESSHSTART;df -P;echo PAESSHEND
    2  mysqldump -u root -p unified >/home/MysqlBacup/unified_59/unified_ev_10jult_15.sql
    3  cd /home/MysqlBacup/unified_59
    4  rsync -r unified_ev_10jult_15.sql 172.31.22.60:/home/
    5  echo PAESSHSTART;df -P;echo PAESSHEND
    6  sudo sh -c "sync; echo 3 > /proc/sys/vm/drop_caches"
    7  mysqldump -u root -p unified >/home/MysqlBacup/unified_59/unified_12JULY.sql
    8  cd /home/MysqlBacup/unified_59
    9  rsync -r unified_12JULY.sql  172.31.22.60:/home
   10  echo PAESSHSTART;df -P;echo PAESSHEND
   11  mysqldump -u root -p unified >/home/MysqlBacup/unified_59/unified_12JULY.sql
   12  cd /home/MysqlBacup/unified_59
   13  rsync -r unified_12JULY.sql  172.31.22.60:/home
   14  echo PAESSHSTART;df -P;echo PAESSHEND
   15  mysqldump -u root -p unified >/home/MysqlBacup/unified_59/unified_12JULY_9:13NIGHT.sql
   16  echo PAESSHSTART;df -P;echo PAESSHEND
   17  df -h
   18  sudo sh -c "sync; echo 3 > /proc/sys/vm/drop_caches"
   19  echo PAESSHSTART;df -P;echo PAESSHEND
   20  mysql -u root -p
   21  echo PAESSHSTART;df -P;echo PAESSHEND
   22  sudo sh -c "sync; echo 3 > /proc/sys/vm/drop_caches"
   23  df -h
   24  mysql -u root -p
   25  df -h
   26  echo PAESSHSTART;df -P;echo PAESSHEND
   27  sudo sh -c "sync; echo 3 > /proc/sys/vm/drop_caches"
   28  echo PAESSHSTART;df -P;echo PAESSHEND
   29  df -h
   30  echo PAESSHSTART;df -P;echo PAESSHEND
   31  date
   32  echo PAESSHSTART;df -P;echo PAESSHEND
   33  netstat -an |grep :3306 |wc -l
   34  mysql -u root -p
   35  sudo sh -c "sync; echo 3 > /proc/sys/vm/drop_caches"
   36  echo PAESSHSTART;df -P;echo PAESSHEND
   37  mysqldump -u root -p unified >/home/MysqlBacup/unified_59/unifeid_22July_15.sql
   38  mysql -u root -p
   39  echo PAESSHSTART;df -P;echo PAESSHEND
   40  sudo sh -c "sync; echo 3 > /proc/sys/vm/drop_caches"
   41  ssh 172.31.22.58
   42  echo PAESSHSTART;df -P;echo PAESSHEND
   43  mysqldump -u root -p staging >/home/staging_23July_15.sql
   44  echo PAESSHSTART;df -P;echo PAESSHEND
   45  df -h
   46  mysql -u root -p
   47  df -h
   48  ssh 172.31.22.58
   49  echo PAESSHSTART;df -P;echo PAESSHEND
   50  df-h
   51  df -h
   52  echo PAESSHSTART;df -P;echo PAESSHEND
   53  sudo sh -c "sync; echo 3 > /proc/sys/vm/drop_caches"
   54  echo PAESSHSTART;df -P;echo PAESSHEND
   55  sudo sh -c "sync; echo 3 > /proc/sys/vm/drop_caches"
   56  echo PAESSHSTART;df -P;echo PAESSHEND
   57  uname -a
   58  echo PAESSHSTART;df -P;echo PAESSHEND
   59  mysqldump -u root -p -R >/home/proc1.sql
   60  mysqldump -u root -p unified --routines --triggers >/home/proc1.sql
   61  mysqldump --routines --no-create-info --no-data --no-create-db --skip-opt unified > >/home/proc1.sql
   62  mysqldump --routines --no-create-info --no-data --no-create-db --skip-opt unified > /home/proc1.sql
   63  mysqldump -u root -p  --routines --no-create-info --no-data --no-create-db --skip-opt unified > /home/proc1.sql
   64  echo PAESSHSTART;df -P;echo PAESSHEND
   65  df -h
   66  echo PAESSHSTART;df -P;echo PAESSHEND
   67  mysql -u root -p
   68  ps ax |grep mysql
   69  service mysql stop
   70  service mysql start
   71  mysql -u root -p
   72  mysqldump -u root -p unified >/home/unified_3aug_15.sql
   73  cd /home
   74  rsync -r unified_3aug_15.sql 172.31.22.59:/home
   75  mysql -u root -p
   76  mysqldump -u root -p unified >/home/unified_3aug_15.sql
   77  rsync -r unified_3aug_15.sql 172.31.22.58:/home
   78  mysql -u root -p
   79  rsync -r unified_3aug_15.sql 172.31.22.91:/home
   80  mysqldump -u root -p unified tbl_registered_users tbl_registered_users_hd tbl_registered_users_hd_main tbl_registered_users_main tbl_registered_users_sd >/home/uni_tbl_3aug.sql
   81  rsunc -r uni_tbl_3aug.sql  172.31.22.58:/home/uni_tbl_3aug.sql
   82  rsync -r uni_tbl_3aug.sql  172.31.22.58:/home/uni_tbl_3aug.sql
   83  mysql -u root -p
   84  echo PAESSHSTART;df -P;echo PAESSHEND
   85  sh /usr/syncservice/src/epgsync.run.sh
   86  echo PAESSHSTART;df -P;echo PAESSHEND
   87  cd
   88  cd /home/MysqlBacup/unified_59
   89  rsync -r 172.31.22.45:/home/mysqlbackup
   90  rsync -r unified_592015-08-06_04h01.sql  172.31.22.45:/home/mysqlbackup
   91  echo PAESSHSTART;df -P;echo PAESSHEND
   92  df -h
   93  echo PAESSHSTART;df -P;echo PAESSHEND
   94  mysqldump -u root -p --structure unified >/home/unified_structure.sql
   95  mysqldump -u root -p --no-data  unified >/home/unified_structure.sql
   96  echo PAESSHSTART;df -P;echo PAESSHEND
   97  crontab -e
   98  sh  /usr/syncservice/src/epgsync.run.sh
   99  echo PAESSHSTART;df -P;echo PAESSHEND
  100  df -h
  101  mysql -u root -p
  102  echo PAESSHSTART;df -P;echo PAESSHEND
  103  mysql -u root -p
  104  echo PAESSHSTART;df -P;echo PAESSHEND
  105  sudo sh -c "sync; echo 3 > /proc/sys/vm/drop_caches"
  106  echo PAESSHSTART;df -P;echo PAESSHEND
  107  df -h
  108  mysql -u root -p
  109  echo PAESSHSTART;df -P;echo PAESSHEND
  110  mysqldump -u root -p  --no-data unified >/home/unified_structure_13Aug_15.sql
  111  echo PAESSHSTART;df -P;echo PAESSHEND
  112  df -h
  113  echo PAESSHSTART;df -P;echo PAESSHEND
  114  mysqldump -u root -p unified >/home/MysqlBacup/unified/unified_17Aug.sql
  115  cd /home/MysqlBacup/unified
  116  rsync -r unified_17Aug.sql 172.31.22.58:/home/mysqlBackup/unified
  117  mysql -u root -p
  118  echo PAESSHSTART;df -P;echo PAESSHEND
  119  df -h
  120  mysqldump -u root -p unified  ws_vods ws_subcategory ws_channel ws_category VOD_METADATA VIEW_VOD_MASTER view_vod_detail VIEW_SUBCAT_MASTER view_subcat_detail VIEW_CATEGORY_MASTER view_category_detail version_summary version >/home/unified_table_17Aug_15.sql
  121  cd /home
  122  rsync -r unified_table_17Aug_15.sql 172.31.22.58:/home
  123  echo PAESSHSTART;df -P;echo PAESSHEND
  124  sudo sh -c "sync; echo 3 > /proc/sys/vm/drop_caches"
  125  echo PAESSHSTART;df -P;echo PAESSHEND
  126  mysqldump -u root -p unified >/home/unified_19aug.sql
  127  cd home
  128  cd /home
  129  rsync -r unified_19aug.sql 172.31.22.58:/home
  130  mysql -u root -p
  131  echo PAESSHSTART;df -P;echo PAESSHEND
  132  df -h
  133  mysqldump -u rooot -p unified >/home/unified_19Aug_15.sql
  134  mysqldump -u root -p unified >/home/unified_19Aug.sql
  135  cd /home
  136  rsync -r unified_19Aug.sql 172.31.22..58:/home
  137  rsync -r unified_19Aug.sql 172.31.22.58:/home
  138  mysql -u root -p
  139  echo PAESSHSTART;df -P;echo PAESSHEND
  140  mysql -u root -p
  141  echo PAESSHSTART;df -P;echo PAESSHEND
  142  mysqldump -u root -p unified >/home/unified_20Aug.sql
  143  cd /home
  144  rsync -r  unified_20Aug.sql  -r 172.31.22.58:/home
  145  df -h
  146  mysql -u root -p
  147  echo PAESSHSTART;df -P;echo PAESSHEND
  148  df -h
  149  echo PAESSHSTART;df -P;echo PAESSHEND
  150  sudo sh -c "sync; echo 3 > /proc/sys/vm/drop_caches"
  151  echo PAESSHSTART;df -P;echo PAESSHEND
  152  df -h
  153  mysql -u root -p
  154  df -h
  155  echo PAESSHSTART;df -P;echo PAESSHEND
  156  ps ax |grep mysql
  157  kill -9 4399
  158  ps ax |grep mysql
  159  echo PAESSHSTART;df -P;echo PAESSHEND
  160  mysql -u root -p
  161  echo PAESSHSTART;df -P;echo PAESSHEND
  162  service mysql stop
  163  service mysql start
  164  mysqldump -u root -p unified >/home/unified_25Aug_15.sql
  165  rsync -r unified_25Aug_15.sql 172.31.22.58:/home/
  166  rsync -r /home/unified_25Aug_15.sql 172.31.22.58:/home/
  167  sudo sh -c "sync; echo 3 > /proc/sys/vm/drop_caches"
  168  echo PAESSHSTART;df -P;echo PAESSHEND
  169  sudo sh -c "sync; echo 3 > /proc/sys/vm/drop_caches"
  170  df -h
  171  echo PAESSHSTART;df -P;echo PAESSHEND
  172  cat CPUinfo
  173  /cat/cpuinfo
  174  echo PAESSHSTART;df -P;echo PAESSHEND
  175  crontab -e
  176  echo PAESSHSTART;df -P;echo PAESSHEND
  177  sh /usr/syncservice/src/epgsync.run.sh
  178  crontab -e
  179  echo PAESSHSTART;df -P;echo PAESSHEND
  180  sh /usr/syncservice/src/epgsync.run.sh
  181  ssh 172.31.22.159
  182  echo PAESSHSTART;df -P;echo PAESSHEND
  183  sudo sh -c "sync; echo 3 > /proc/sys/vm/drop_caches"
  184  df -h
  185  show binary logs\G;
  186  mysql -u root -p
  187  df -h
  188  echo PAESSHSTART;df -P;echo PAESSHEND
  189  mysqldump -u root -p unified CHANNEL_DETAIL_VIEW CHANNEL_RTSP_DETAILS_VIEW PACKAGE_CHANNEL_MAP_VIEW PACKAGE_MASTER_VIEW VIEW_VOD_MASTER VOD_METADATA ws_vods ws_category ws_channel ws_subcategory >/home/unified_2SEP_15sometable.sql
  190  mysql -u root -p
  191  mysqldump -u root -p unified  >/home/unified_2SEP_15sometable.sql
  192  mysql -u root -p
  193  echo PAESSHSTART;df -P;echo PAESSHEND
  194  df -h
  195  sudo sh -c "sync; echo 3 > /proc/sys/vm/drop_caches"
  196  df -h
  197  mysql -u root -p
  198  df -h
  199  mysql -u root -p
  200  df -h
  201  echo PAESSHSTART;df -P;echo PAESSHEND
  202  df -h
  203  free -m
  204  sudo sh -c "sync; echo 3 > /proc/sys/vm/drop_caches"
  205  free -m
  206  df -h
  207  ssh 172.31.22.58
  208  echo PAESSHSTART;df -P;echo PAESSHEND
  209  mysqldump -u root -p unified PACKAGE_CHANNEL_MAP_VIEW PACKAGE_MASTER_VIEW >/home/unified_2table.sql
  210  mysql -u root -p
  211  echo PAESSHSTART;df -P;echo PAESSHEND
  212  df



======================================================================================================================

Mysql installation







https://access.redhat.com/discussions/1469853



rpm -i MySQL-test-5.6.30-1.el6.x86_64.rpm MySQL-shared-compat-5.6.30-1.el6.x86_64.rpm MySQL-shared-5.6.30-1.el6.x86_64.rpm MySQL-server-5.6.30-1.el6.x86_64.rpm MySQL-embedded-5.6.30-1.el6.x86_64.rpm MySQL-devel-5.6.30-1.el6.x86_64.rpm MySQL-client-5.6.30-1.el6.x86_64.rpm



rpm -e MySQL-test-5.6.30-1.el6.x86_64.rpm MySQL-shared-compat-5.6.30-1.el6.x86_64.rpm MySQL-shared-5.6.30-1.el6.x86_64.rpm MySQL-server-5.6.30-1.el6.x86_64.rpm MySQL-embedded-5.6.30-1.el6.x86_64.rpm MySQL-devel-5.6.30-1.el6.x86_64.rpm MySQL-client-5.6.30-1.el6.x86_64.rpm


 rpm -e MySQL-server-advanced MySQL-shared-advanced MySQL-embedded-advanced MySQL-test-advanced MySQL-client-advanced MySQL-devel-advanced


remove old mysq from YUM command

then

sudo yum localinstall MySQL-embedded-advanced-5.6.24-1.el6.x86_64.rpm


sudo yum localinstall MySQL-test-advanced-5.6.24-1.el6.x86_64.rpm


sudo yum localinstall MySQL-shared-compat-advanced-5.6.24-1.el6.x86_64.rpm



sudo yum localinstall MySQL-shared-advanced-5.6.24-1.el6.x86_64.rpm


sudo yum localinstall MySQL-server-advanced-5.6.24-1.el6.x86_64.rpm


sudo yum localinstall MySQL-client-advanced-5.6.24-1.el6.x86_64.rpm


sudo yum localinstall MySQL-devel-advanced-5.6.24-1.el6.x86_64.rpm






=========================
for NOSQL IN SQL URL IS


https://scriptingmysql.wordpress.com/2014/05/01/use-mysql-to-store-nosql-and-sql-data-in-the-same-database-using-memcached-and-innodb/
=========================




 chmod -R 755 upload

cd /home/www/html/VIDDTH/admin/
cd /home/www/html/AIRDTH/admin/




===========================================================================================
snmp install



 rpm -Uvh *
 vim /etc/snmp/snmpd.conf (change file value.)

/etc/init.d/net
systemctl status snmpd.service
systemctl enable snmpd.service

systemctl restart snmpd.service

systemctl status snmpd.service




=================================================================




[root@APP001 tools]# rpm -Uvh *
Preparing...                          ################################# [100%]
Updating / installing...
   1:net-snmp-libs-1:5.7.2-24.el7     ################################# [ 33%]
   2:net-snmp-agent-libs-1:5.7.2-24.el################################# [ 67%]
   3:net-snmp-1:5.7.2-24.el7          ################################# [100%]
[root@APP001 tools]# vim /etc/snmp/snmpd.conf
[root@APP001 tools]# /etc/init.d/net
netconsole  network
[root@APP001 tools]# /etc/init.d/^C
[root@APP001 tools]# /etc/init.d/^C
[root@APP001 tools]# systemctl status snmpd.service
â snmpd.service - Simple Network Management Protocol (SNMP) Daemon.
   Loaded: loaded (/usr/lib/systemd/system/snmpd.service; disabled; vendor preset: disabled)
   Active: inactive (dead)
[root@APP001 tools]# systemctl enable snmpd.service
Created symlink from /etc/systemd/system/multi-user.target.wants/snmpd.service to /usr/lib/systemd/system/snmpd.service.
[root@APP001 tools]# systemctl restart snmpd.service
[root@APP001 tools]# systemctl status snmpd.service
â snmpd.service - Simple Network Management Protocol (SNMP) Daemon.
   Loaded: loaded (/usr/lib/systemd/system/snmpd.service; enabled; vendor preset: disabled)
   Active: active (running) since Tue 2016-09-06 16:29:32 IST; 4s ago
 Main PID: 30009 (snmpd)
   CGroup: /system.slice/snmpd.service
           ââ30009 /usr/sbin/snmpd -LS0-6d -f

Sep 06 16:29:32 APP001 systemd[1]: Starting Simple Network Management Protocol (SNMP) Daemon....
Sep 06 16:29:32 APP001 snmpd[30009]: NET-SNMP version 5.7.2
Sep 06 16:29:32 APP001 systemd[1]: Started Simple Network Management Protocol (SNMP) Daemon..
[root@APP001 tools]# systemctl^Cestart snmpd.service
[root@APP001 tools]#  vim /etc/snmp/snmpd.conf






===============================================

EPEL redhat extra package library


 yum install php-pecl-ssh2

 yum install epel*

php -m|grep ssh







===========================================





[client]
socket = /home/mysql/mysql.sock


==========================================
Install soap client


yum install php-soap

==================================================================
http://php.net/manual/en/ssh2.installation.php

Change file permission in appachie

chown -R apache:apache logs
chown -R mongod:mongod mongo

chown -R apache:apache upload

chmod 755 logs


tar -xvzf html-2016-08-24.tar.gz

======================================
date -s '2016-08-30 15:26:56'

Tue Aug 30 14:24:56 IST 2016


yum install vim php httpd php-mysql


yum install php-mysql

 netstat -an|more

yum install sysstat


netstat -an|more

yum install netstat


yum install net-tools



netstat -an|more

ifconfig

iptables -L -n

iptables -F

chkconfig iptables off


 cat /etc/redhat-release


service firewalld stop

chkconfig firewalld off



 yum install php-memcached  php-memcache


==========================================
command change path php from linux

vim /etc/sysconfig/selinux

change SELINUX=disabled



setenforce 0

getenforce
=====================================================================

Install nginx

yum install epel-release


yum -y install nginx

service nginx start

service nginx stop



====================================
change in centos error for

configure: error: Cannot find OpenSSL's <evp.h>


 yum install openssl-devel

sudo pecl install mongodb


http://php.net/manual/en/mongodb.installation.pecl.php
http://stackoverflow.com/questions/23181096/configure-cant-find-evp-h


==================================

tar -xvzf html-2016-08-24.tar.gz


========================================


CREATE USER 'newuser'@'localhost' IDENTIFIED BY 'password';










CREATE USER 'neo'@'172.31.22.102' IDENTIFIED BY 'admin123';


GRANT ALL PRIVILEGES ON * . * TO 'neo'@'172.31.22.102';


CREATE USER 'root'@'172.31.22.102' IDENTIFIED BY 'root123';


GRANT ALL PRIVILEGES ON * . * TO 'root'@'172.31.22.102';






















CREATE USER 'neo'@'172.31.22.103' IDENTIFIED BY 'admin123';


GRANT ALL PRIVILEGES ON * . * TO 'neo'@'172.31.22.103';


CREATE USER 'root'@'172.31.22.103' IDENTIFIED BY 'root123';


GRANT ALL PRIVILEGES ON * . * TO 'root'@'172.31.22.103';






=====================================================



db.USER.find({"first_name":"nexg1981"})


db.USER.remove({"first_name":"popopo"})


db.SESSION.remove({"user_id":"57c804c2c29ef208497a8555"})


db.SESSION.find({"user_id":"57c9743fc19ef2116d8b456b"}).pretty()

 db.SESSION.find({"user_id":"57c804c2c29ef208497a8555"}).pretty()


565c8c878c86ba151d29b689

db.CATLOGUES.find({"_id":ObjectId("565c8c878c86ba151d29b689")}).pretty()




db.ASSETS.find({"genre":{"$in":["56e156139da23c60750e692a"]}})


db.SESSION.find({"catlogue":{"$in":["565c8c878c86ba151d29b689"]}},{"plateform" : "Android"}).limit(1).pretty()



db.SESSION.find({"catlogue":{"$in":["565c8c878c86ba151d29b689"]},"plateform" : "iOS"}).count()

db.SESSION.find({"catlogue":{"$in":["565c8c878c86ba151d29b689"]},"plateform" : "Android"}).count()

db.SESSION.distinct('device_id',{"catlogue":{"$in":["565c8c878c86ba151d29b689"]},"plateform" : "Android"});








android  totalcount

398888    398893



db.SESSION.find({"plateform" : "Android"},"catlogue":{"$in":["565c8c878c86ba151d29b689"]}).limit(1).pretty()


 db.SESSION.find({"catlogue":{"$in":["565c8c878c86ba151d29b689"]}},{"plateform":"iOS"}).count()


ObjectId("57a08eee7f8b9ab708d6c9e7")

db.ASSETS.find({"catlogue":{"$in":["57a08eee7f8b9ab708d6c9e7"]}})
//Firetv

db.ASSETS.find({"catlogue":{"$in":["57a08eee7f8b9ab708d6c9e7"]}, "type":"episode"})



db.SESSION.find({"catlogue":{"$in":["57a08eee7f8b9ab708d6c9e7"]}})




ObjectId("57d00c3a064a23f914795ef3")


======================================================




db.SESSION.remove({"_id" : ObjectId("57a8136cc935952b865b48e5")})



db.SESSION.find({"_id" : ObjectId("573a1357c935952b8647ac62")})










db.SESSION.find({"_id" : ObjectId("57a8136cc935952b865b48e5")})

db.SESSION.find({"_id" : ObjectId("573a1357c935952b8647ac62")})


57a81339c29ef228357bc7cb





db.USER.find({"_id" : ObjectId("57a81339c29ef228357bc7cb")})

db.USER.remove({"_id" : ObjectId("57a81339c29ef228357bc7cb")})


573a1325c19ef2dc601c2a95




ObjectId("57d00c3a064a23f914795ef3")








clientapps.nexg.tv/webservice/signup/


authorization   de6ed43f6c08ecf56536f8abcc812701

appinventiv     digivive


device_id    123Manoj








"country_code" : "KR",
    "country_name" : "Korea, Republic of"






plateform   testmanoj



=========================================================================



















CRDV_BD_CODE varchar(255)
CH676
RTSP_2G varchar(255)
rtsp://liver.nexg.tv/liver/pogo_2G.sdp

RTSP_3G varchar(255)
rtsp://liver.nexg.tv/liver/pogo_3G.sdp
HTTP_2G varchar(255)
http://liveha.nexg.tv/liveha/pogo.smil/playlist.m3u8
HTTP_3G varchar(255)
http://hdapplive.nexg.tv/hdapp/pogo.smil/playlist.m3u8
MPEG4 varchar(255)
http://vod.nexg.tv/liveloop/pogowap.smil/playlist.m3u8
HTTP_SMIL varchar(255)
http://vod.nexg.tv/liveloop/pogo.smil/playlist.m3u8
WINDOWS_URL varchar(255)
http://livehs.nexg.tv/livehs/pogo.smil/Manifest
CRDV_OPERATOR varchar(255)
OAIRT
RTSP_HD varchar(255)
rtsp://liver.nexg.tv/liver/pogo_HD.sdp



===========================================================================

db.SESSION.find({"user_id":"57c9743fc19ef2116d8b456b"}).pretty()



=========================================================================


{
        "_id" : ObjectId("565c8c878c86ba151d29b689"),
        "catlogues_code" : "APP001",
        "catlogues_name" : "NexGTV",
        "catlogues_status" : "1"
}
rs0:PRIMARY> db.CATLOGUES.find().pretty()
{
        "_id" : ObjectId("565c8c878c86ba151d29b689"),
        "catlogues_code" : "APP001",
        "catlogues_name" : "NexGTV",
        "catlogues_status" : "1"
}
{
        "_id" : ObjectId("56b34109d0944fca428b456b"),
        "catlogues_code" : "APP002",
        "catlogues_name" : "nexGTv Kids",
        "catlogues_status" : "1",
        "catlogues_insert_time" : ISODate("2016-02-04T12:16:09.416Z"),
        "catlogues_update_time" : ISODate("2016-02-04T12:16:09.416Z")
}
{
        "_id" : ObjectId("57550ee77f8b9a5d2eb061b1"),
        "catlogues_name" : "nexgtvnews",
        "catlogues_insert_time" : ISODate("2016-06-06T05:49:27.653Z"),
        "catlogues_update_time" : ISODate("2016-06-06T05:49:27.653Z"),
        "catlogues_code" : "APP009",
        "catlogues_status" : "1"
}
{
        "_id" : ObjectId("5757e3e47f8b9a2a2f8b4567"),
        "catlogues_name" : "moviesnmusic",
        "catlogues_insert_time" : ISODate("2016-06-08T09:22:44.224Z"),
        "catlogues_update_time" : ISODate("2016-06-08T09:22:44.224Z"),
        "catlogues_code" : "APP010",
        "catlogues_status" : "1"
}
{
        "_id" : ObjectId("5757e41d7f8b9a2c2f8b4567"),
        "catlogues_name" : "nexgtvcomedy",
        "catlogues_insert_time" : ISODate("2016-06-08T09:23:41.017Z"),
        "catlogues_update_time" : ISODate("2016-06-08T09:23:41.017Z"),
        "catlogues_code" : "APP011",
        "catlogues_status" : "1"
}
{
        "_id" : ObjectId("5757e4277f8b9a8e318b4567"),
        "catlogues_name" : "nexgtvyoga",
        "catlogues_insert_time" : ISODate("2016-06-08T09:23:51.475Z"),
        "catlogues_update_time" : ISODate("2016-06-08T09:23:51.475Z"),
        "catlogues_code" : "APP012",
        "catlogues_status" : "1"
}
{
        "_id" : ObjectId("575bf78f7f8b9a46468b4567"),
        "catlogues_name" : "nexgtvastro",
        "catlogues_insert_time" : ISODate("2016-06-11T11:35:43.181Z"),
        "catlogues_update_time" : ISODate("2016-06-11T11:35:43.181Z"),
        "catlogues_code" : "APP009",
        "catlogues_status" : "1"
}
{
        "_id" : ObjectId("577cb6d37f8b9ab017819fe4"),
        "catlogues_name" : "nexgtvhotflix",
        "catlogues_insert_time" : ISODate("2016-07-06T07:44:19.307Z"),
        "catlogues_update_time" : ISODate("2016-07-06T07:44:19.307Z"),
        "catlogues_code" : "APP011",
        "catlogues_status" : "1"
}
{
        "_id" : ObjectId("578736217f8b9a0b0958a47d"),
        "catlogues_name" : "bollywoodadda",
        "catlogues_insert_time" : ISODate("2016-07-14T06:50:09.770Z"),
        "catlogues_update_time" : ISODate("2016-07-14T06:50:09.770Z"),
        "catlogues_code" : "APP016",
        "catlogues_status" : "1"
}
{
        "_id" : ObjectId("578e03f77f8b9a2b21b91142"),
        "catlogues_name" : "digiflix",
        "catlogues_insert_time" : ISODate("2016-07-19T10:41:59.025Z"),
        "catlogues_update_time" : ISODate("2016-07-19T10:41:59.025Z"),
        "catlogues_code" : "APP017",
        "catlogues_status" : "1"
}
{
        "_id" : ObjectId("57a08eee7f8b9ab708d6c9e7"),
        "catlogues_name" : "firetv",
        "catlogues_insert_time" : ISODate("2016-08-02T12:15:42.137Z"),
        "catlogues_update_time" : ISODate("2016-08-02T12:15:42.137Z"),
        "catlogues_code" : "APP018",
        "catlogues_status" : "1"
}
{
        "_id" : ObjectId("57bc13bd7f8b9acb11ac9bce"),
        "catlogues_name" : "digiflixapp",
        "catlogues_insert_time" : ISODate("2016-08-23T09:13:33.381Z"),
        "catlogues_update_time" : ISODate("2016-08-26T11:43:25.807Z"),
        "catlogues_code" : "APP021",
        "catlogues_status" : "1"
}




echo $params['country']."==";


db.SESSION.find({"_id" : ObjectId("57a8136cc935952b865b48e5")})




db.SESSION.find({"_id" : ObjectId("573a1357c935952b8647ac62")})





db.SESSION.find("catlogue":{"$in":["57a08eee7f8b9ab708d6c9e7"]})





db.ASSETS.find()

====================================================

db.ASSETS.aggregate(
   {$group : { '_id' : "$channel_name",'charge_code':{'$first':'$charge_code'},'platform':{'$first':'$platform'}}}
)




















===================================================================






================================================================
















//set server limit using AB command

https://easyengine.io/tutorials/linux/increase-open-files-limit/


http://braintwitter.blogspot.in/2011/10/socket-too-many-open-files-24-error-and.html


//AB comand are given below:-
ab -n 10000 -c 1200 -k -r -H "appinventiv: digivive" -H "authorization:5a59804841fc0b650974a8a6" http://172.31.22.240/clientwebservice/geturlvdailyhunt?nmode=WIFI&appv=1.0.2&build=10004&ct=1&charge_code=LIV033&catlogue=589075657f8b9ae825bb3d0f


check php rpm command

rpm -qa | egrep -i 'php|awk'


iptables -L -n
chkconfig iptables off
service iptables stop

snmp install



 rpm -Uvh *
 vim /etc/snmp/snmpd.conf (change file value.)

/etc/init.d/net
systemctl status snmpd.service
systemctl enable snmpd.service

systemctl restart snmpd.service

systemctl status snmpd.service









[root@APP001 tools]# rpm -Uvh *
Preparing...                          ################################# [100%]
Updating / installing...
   1:net-snmp-libs-1:5.7.2-24.el7     ################################# [ 33%]
   2:net-snmp-agent-libs-1:5.7.2-24.el################################# [ 67%]
   3:net-snmp-1:5.7.2-24.el7          ################################# [100%]
[root@APP001 tools]# vim /etc/snmp/snmpd.conf
[root@APP001 tools]# /etc/init.d/net
netconsole  network
[root@APP001 tools]# /etc/init.d/^C
[root@APP001 tools]# /etc/init.d/^C
[root@APP001 tools]# systemctl status snmpd.service
â snmpd.service - Simple Network Management Protocol (SNMP) Daemon.
   Loaded: loaded (/usr/lib/systemd/system/snmpd.service; disabled; vendor preset: disabled)
   Active: inactive (dead)
[root@APP001 tools]# systemctl enable snmpd.service
Created symlink from /etc/systemd/system/multi-user.target.wants/snmpd.service to /usr/lib/systemd/system/snmpd.service.
[root@APP001 tools]# systemctl restart snmpd.service
[root@APP001 tools]# systemctl status snmpd.service
â snmpd.service - Simple Network Management Protocol (SNMP) Daemon.
   Loaded: loaded (/usr/lib/systemd/system/snmpd.service; enabled; vendor preset: disabled)
   Active: active (running) since Tue 2016-09-06 16:29:32 IST; 4s ago
 Main PID: 30009 (snmpd)
   CGroup: /system.slice/snmpd.service
           ââ30009 /usr/sbin/snmpd -LS0-6d -f

Sep 06 16:29:32 APP001 systemd[1]: Starting Simple Network Management Protocol (SNMP) Daemon....
Sep 06 16:29:32 APP001 snmpd[30009]: NET-SNMP version 5.7.2
Sep 06 16:29:32 APP001 systemd[1]: Started Simple Network Management Protocol (SNMP) Daemon..
[root@APP001 tools]# systemctl^Cestart snmpd.service
[root@APP001 tools]#  vim /etc/snmp/snmpd.conf


========================================================

Change file permission in appachie

chown -R apache:apache logs

chmod 755 logs


tar -xvzf html-2016-08-24.tar.gz

======================================
date -s '2016-08-30 15:26:56'

Tue Aug 30 14:24:56 IST 2016


yum install vim php httpd php-mysql




 netstat -an|more

yum install sysstat


netstat -an|more

yum install netstat


yum install net-tools



netstat -an|more

ifconfig

iptables -L -n

iptables -F

chkconfig iptables off


 cat /etc/redhat-release


service firewalld stop

chkconfig firewalld off



 yum install php-memcached  php-memcache


==========================================
command change path php from linux

vim /etc/sysconfig/selinux

change SELINUX=disabled



setenforce 0

getenforce


====================================
change in centos error for

configure: error: Cannot find OpenSSL's <evp.h>


 yum install openssl-devel

sudo pecl install mongodb


http://php.net/manual/en/mongodb.installation.pecl.php
http://stackoverflow.com/questions/23181096/configure-cant-find-evp-h


==================================

tar -xvzf html-2016-08-24.tar.gz


========================================


===============================================

EPEL redhat extra package library


 yum install php-pecl-ssh2

 yum install epel*

php -m|grep ssh







===========================================






ONCE AGAIN







rsync -arv /data/www/html/unified/admin/upload/. root@172.31.22.106:/home/www/html/unified/admin/upload/ >/dev/null 2>&1


rsync -arv /data/www/html/unified/admin/banner/. root@172.31.22.106:/home/www/html/unified/admin/banner/ >/dev/null 2>&1


rsync -arv /data/www/html/common_hd/admin/upload/. root@172.31.22.106:/home/www/html/common_hd/admin/upload/ >/dev/null 2>&1




rsync -arv /data/www/html/unified/admin/upload/. root@172.31.22.107:/home/www/html/unified/admin/upload/ >/dev/null 2>&1


rsync -arv /data/www/html/unified/admin/banner/. root@172.31.22.107:/home/www/html/unified/admin/banner/ >/dev/null 2>&1


rsync -arv /data/www/html/common_hd/admin/upload/. root@172.31.22.107:/home/www/html/common_hd/admin/upload/ >/dev/null 2>&1

====================================================
Given asset is not playin in website


http://www.nexgtv.com/videos/displayVod/U0w1NzI=/Z2VucmU=/MTQy/NDg4


CRDV_BD_CODE                        SL572

RTSP_2G                  rtsp://vod.nexg.tv/video/v/amz3/digi/spot/Epic_5_Things_Delhi_People_Cant_Live_Without_144p.mp4


HTTP_2G             http://vod.nexg.tv/video/v/amz3/digi/spot/Epic_5_Things_Delhi_People_Cant_Live_Without.smil/playlist.m3u8


HTTP_3G          http://vod.nexg.tv/video/v/amz3/digi/spot/Epic_5_Things_Delhi_People_Cant_Live_Without.smil/playlist.m3u8


MPEG4        http://vod.nexg.tv/video/v/amz3/digi/spot/Epic_5_Things_Delhi_People_Cant_Live_Without.smil/playlist.m3u8        



HTTP_SMIL       http://vod.nexg.tv/video/v/amz3/digi/spot/Epic_5_Things_Delhi_People_Cant_Live_Without.smil/playlist.m3u8



WINDOWS_URL     http://vod.nexg.tv/video/v/amz3/digi/spot/Epic_5_Things_Delhi_People_Cant_Live_Without.smil/Manifest



RTSP_HD                      rtsp://vod.nexg.tv/video/v/amz3/digi/spot/Epic_5_Things_Delhi_People_Cant_Live_Without_320p.mp4












172.31.22.237//webservice/livetv?search_text=aajtak&type=livetv&plateform=


========================================
172.31.22.59 IP



0 4 * * * /usr/syncservice/src/analytics.run.sh
0 17 * * * /usr/syncservice/src/nexg_tv.run.sh
0 4 * * * /home/MySQLdump.sh
0 3 * * * /usr/syncservice/src/nexg_tv.run.sh
0 11 * * * /usr/syncservice/src/11epgsync.run.sh
0 6 * * * /usr/syncservice/src/11epgsync.run.sh
0 1 * * * curl http://172.31.22.59/11KillprocesslistUnified_59.php
*/59 * * * * /var/log/filesize.sh



====================================================

 show slave status \G;

 STOP SLAVE; SET GLOBAL SQL_SLAVE_SKIP_COUNTER=1; START SLAVE;



==============================================================================
358094050867333  dthairtel   3013544087   9958000753  (AIRDTH)



356262056103910   29756971    9371059566  (VIDDTH)




==================================================================

history
    1  echo PAESSHSTART;df -P;echo PAESSHEND
    2  mysqldump -u root -p unified >/home/MysqlBacup/unified_59/unified_ev_10jult_15.sql
    3  cd /home/MysqlBacup/unified_59
    4  rsync -r unified_ev_10jult_15.sql 172.31.22.60:/home/
    5  echo PAESSHSTART;df -P;echo PAESSHEND
    6  sudo sh -c "sync; echo 3 > /proc/sys/vm/drop_caches"
    7  mysqldump -u root -p unified >/home/MysqlBacup/unified_59/unified_12JULY.sql
    8  cd /home/MysqlBacup/unified_59
    9  rsync -r unified_12JULY.sql  172.31.22.60:/home
   10  echo PAESSHSTART;df -P;echo PAESSHEND
   11  mysqldump -u root -p unified >/home/MysqlBacup/unified_59/unified_12JULY.sql
   12  cd /home/MysqlBacup/unified_59
   13  rsync -r unified_12JULY.sql  172.31.22.60:/home
   14  echo PAESSHSTART;df -P;echo PAESSHEND
   15  mysqldump -u root -p unified >/home/MysqlBacup/unified_59/unified_12JULY_9:13NIGHT.sql
   16  echo PAESSHSTART;df -P;echo PAESSHEND
   17  df -h
   18  sudo sh -c "sync; echo 3 > /proc/sys/vm/drop_caches"
   19  echo PAESSHSTART;df -P;echo PAESSHEND
   20  mysql -u root -p
   21  echo PAESSHSTART;df -P;echo PAESSHEND
   22  sudo sh -c "sync; echo 3 > /proc/sys/vm/drop_caches"
   23  df -h
   24  mysql -u root -p
   25  df -h
   26  echo PAESSHSTART;df -P;echo PAESSHEND
   27  sudo sh -c "sync; echo 3 > /proc/sys/vm/drop_caches"
   28  echo PAESSHSTART;df -P;echo PAESSHEND
   29  df -h
   30  echo PAESSHSTART;df -P;echo PAESSHEND
   31  date
   32  echo PAESSHSTART;df -P;echo PAESSHEND
   33  netstat -an |grep :3306 |wc -l
   34  mysql -u root -p
   35  sudo sh -c "sync; echo 3 > /proc/sys/vm/drop_caches"
   36  echo PAESSHSTART;df -P;echo PAESSHEND
   37  mysqldump -u root -p unified >/home/MysqlBacup/unified_59/unifeid_22July_15.sql
   38  mysql -u root -p
   39  echo PAESSHSTART;df -P;echo PAESSHEND
   40  sudo sh -c "sync; echo 3 > /proc/sys/vm/drop_caches"
   41  ssh 172.31.22.58
   42  echo PAESSHSTART;df -P;echo PAESSHEND
   43  mysqldump -u root -p staging >/home/staging_23July_15.sql
   44  echo PAESSHSTART;df -P;echo PAESSHEND
   45  df -h
   46  mysql -u root -p
   47  df -h
   48  ssh 172.31.22.58
   49  echo PAESSHSTART;df -P;echo PAESSHEND
   50  df-h
   51  df -h
   52  echo PAESSHSTART;df -P;echo PAESSHEND
   53  sudo sh -c "sync; echo 3 > /proc/sys/vm/drop_caches"
   54  echo PAESSHSTART;df -P;echo PAESSHEND
   55  sudo sh -c "sync; echo 3 > /proc/sys/vm/drop_caches"
   56  echo PAESSHSTART;df -P;echo PAESSHEND
  57  uname -a
   58  echo PAESSHSTART;df -P;echo PAESSHEND
   59  mysqldump -u root -p -R >/home/proc1.sql
   60  mysqldump -u root -p unified --routines --triggers >/home/proc1.sql
   61  mysqldump --routines --no-create-info --no-data --no-create-db --skip-opt unified > >/home/proc1.sql
   62  mysqldump --routines --no-create-info --no-data --no-create-db --skip-opt unified > /home/proc1.sql
   63  mysqldump -u root -p  --routines --no-create-info --no-data --no-create-db --skip-opt unified > /home/proc1.sql
   64  echo PAESSHSTART;df -P;echo PAESSHEND
   65  df -h
   66  echo PAESSHSTART;df -P;echo PAESSHEND
   67  mysql -u root -p
   68  ps ax |grep mysql
   69  service mysql stop
   70  service mysql start
   71  mysql -u root -p
   72  mysqldump -u root -p unified >/home/unified_3aug_15.sql
   73  cd /home
   74  rsync -r unified_3aug_15.sql 172.31.22.59:/home
   75  mysql -u root -p
   76  mysqldump -u root -p unified >/home/unified_3aug_15.sql
   77  rsync -r unified_3aug_15.sql 172.31.22.58:/home
   78  mysql -u root -p
   79  rsync -r unified_3aug_15.sql 172.31.22.91:/home
   80  mysqldump -u root -p unified tbl_registered_users tbl_registered_users_hd tbl_registered_users_hd_main tbl_registered_users_main tbl_registered_users_sd >/home/uni_tbl_3aug.sql
   81  rsunc -r uni_tbl_3aug.sql  172.31.22.58:/home/uni_tbl_3aug.sql
   82  rsync -r uni_tbl_3aug.sql  172.31.22.58:/home/uni_tbl_3aug.sql
   83  mysql -u root -p
   84  echo PAESSHSTART;df -P;echo PAESSHEND
   85  sh /usr/syncservice/src/epgsync.run.sh
   86  echo PAESSHSTART;df -P;echo PAESSHEND
   87  cd
   88  cd /home/MysqlBacup/unified_59
   89  rsync -r 172.31.22.45:/home/mysqlbackup
   90  rsync -r unified_592015-08-06_04h01.sql  172.31.22.45:/home/mysqlbackup
   91  echo PAESSHSTART;df -P;echo PAESSHEND
   92  df -h
   93  echo PAESSHSTART;df -P;echo PAESSHEND
   94  mysqldump -u root -p --structure unified >/home/unified_structure.sql
   95  mysqldump -u root -p --no-data  unified >/home/unified_structure.sql
   96  echo PAESSHSTART;df -P;echo PAESSHEND
   97  crontab -e
   98  sh  /usr/syncservice/src/epgsync.run.sh
   99  echo PAESSHSTART;df -P;echo PAESSHEND
  100  df -h
  101  mysql -u root -p
  102  echo PAESSHSTART;df -P;echo PAESSHEND
  103  mysql -u root -p
  104  echo PAESSHSTART;df -P;echo PAESSHEND
  105  sudo sh -c "sync; echo 3 > /proc/sys/vm/drop_caches"
  106  echo PAESSHSTART;df -P;echo PAESSHEND
  107  df -h
  108  mysql -u root -p
  109  echo PAESSHSTART;df -P;echo PAESSHEND
  110  mysqldump -u root -p  --no-data unified >/home/unified_structure_13Aug_15.sql
  111  echo PAESSHSTART;df -P;echo PAESSHEND
  112  df -h
  113  echo PAESSHSTART;df -P;echo PAESSHEND
  114  mysqldump -u root -p unified >/home/MysqlBacup/unified/unified_17Aug.sql
  115  cd /home/MysqlBacup/unified
  116  rsync -r unified_17Aug.sql 172.31.22.58:/home/mysqlBackup/unified
  117  mysql -u root -p
  118  echo PAESSHSTART;df -P;echo PAESSHEND
  119  df -h
  120  mysqldump -u root -p unified  ws_vods ws_subcategory ws_channel ws_category VOD_METADATA VIEW_VOD_MASTER view_vod_detail VIEW_SUBCAT_MASTER view_subcat_detail VIEW_CATEGORY_MASTER view_category_detail version_summary version >/home/unified_table_17Aug_15.sql
  121  cd /home
  122  rsync -r unified_table_17Aug_15.sql 172.31.22.58:/home
  123  echo PAESSHSTART;df -P;echo PAESSHEND
  124  sudo sh -c "sync; echo 3 > /proc/sys/vm/drop_caches"
  125  echo PAESSHSTART;df -P;echo PAESSHEND
  126  mysqldump -u root -p unified >/home/unified_19aug.sql
  127  cd home
  128  cd /home
  129  rsync -r unified_19aug.sql 172.31.22.58:/home
  130  mysql -u root -p
  131  echo PAESSHSTART;df -P;echo PAESSHEND
  132  df -h
  133  mysqldump -u rooot -p unified >/home/unified_19Aug_15.sql
  134  mysqldump -u root -p unified >/home/unified_19Aug.sql
  135  cd /home
  136  rsync -r unified_19Aug.sql 172.31.22..58:/home
  137  rsync -r unified_19Aug.sql 172.31.22.58:/home
  138  mysql -u root -p
  139  echo PAESSHSTART;df -P;echo PAESSHEND
  140  mysql -u root -p
  141  echo PAESSHSTART;df -P;echo PAESSHEND
  142  mysqldump -u root -p unified >/home/unified_20Aug.sql
  143  cd /home
  144  rsync -r  unified_20Aug.sql  -r 172.31.22.58:/home
  145  df -h
  146  mysql -u root -p
  147  echo PAESSHSTART;df -P;echo PAESSHEND
  148  df -h
  149  echo PAESSHSTART;df -P;echo PAESSHEND
  150  sudo sh -c "sync; echo 3 > /proc/sys/vm/drop_caches"
  151  echo PAESSHSTART;df -P;echo PAESSHEND
  152  df -h
  153  mysql -u root -p
  154  df -h
  155  echo PAESSHSTART;df -P;echo PAESSHEND
  156  ps ax |grep mysql
  157  kill -9 4399
  158  ps ax |grep mysql
  159  echo PAESSHSTART;df -P;echo PAESSHEND
  160  mysql -u root -p
  161  echo PAESSHSTART;df -P;echo PAESSHEND
  162  service mysql stop
  163  service mysql start
  164  mysqldump -u root -p unified >/home/unified_25Aug_15.sql
  165  rsync -r unified_25Aug_15.sql 172.31.22.58:/home/
  166  rsync -r /home/unified_25Aug_15.sql 172.31.22.58:/home/
  167  sudo sh -c "sync; echo 3 > /proc/sys/vm/drop_caches"
  168  echo PAESSHSTART;df -P;echo PAESSHEND
  169  sudo sh -c "sync; echo 3 > /proc/sys/vm/drop_caches"
  170  df -h
  171  echo PAESSHSTART;df -P;echo PAESSHEND
  172  cat CPUinfo
  173  /cat/cpuinfo
  174  echo PAESSHSTART;df -P;echo PAESSHEND
  175  crontab -e
  176  echo PAESSHSTART;df -P;echo PAESSHEND
  177  sh /usr/syncservice/src/epgsync.run.sh
  178  crontab -e
  179  echo PAESSHSTART;df -P;echo PAESSHEND
  180  sh /usr/syncservice/src/epgsync.run.sh
  181  ssh 172.31.22.159
  182  echo PAESSHSTART;df -P;echo PAESSHEND
  183  sudo sh -c "sync; echo 3 > /proc/sys/vm/drop_caches"
  184  df -h
  185  show binary logs\G;
  186  mysql -u root -p
  187  df -h
  188  echo PAESSHSTART;df -P;echo PAESSHEND
  189  mysqldump -u root -p unified CHANNEL_DETAIL_VIEW CHANNEL_RTSP_DETAILS_VIEW PACKAGE_CHANNEL_MAP_VIEW PACKAGE_MASTER_VIEW VIEW_VOD_MASTER VOD_METADATA ws_vods ws_category ws_channel ws_subcategory >/home/unified_2SEP_15sometable.sql
  190  mysql -u root -p
  191  mysqldump -u root -p unified  >/home/unified_2SEP_15sometable.sql
  192  mysql -u root -p
  193  echo PAESSHSTART;df -P;echo PAESSHEND
  194  df -h
  195  sudo sh -c "sync; echo 3 > /proc/sys/vm/drop_caches"
  196  df -h
  197  mysql -u root -p
  198  df -h
  199  mysql -u root -p
  200  df -h
  201  echo PAESSHSTART;df -P;echo PAESSHEND
  202  df -h
  203  free -m
  204  sudo sh -c "sync; echo 3 > /proc/sys/vm/drop_caches"
  205  free -m
  206  df -h
  207  ssh 172.31.22.58
  208  echo PAESSHSTART;df -P;echo PAESSHEND
  209  mysqldump -u root -p unified PACKAGE_CHANNEL_MAP_VIEW PACKAGE_MASTER_VIEW >/home/unified_2table.sql
  210  mysql -u root -p
  211  echo PAESSHSTART;df -P;echo PAESSHEND
  212  df -h
  213  sudo sh -c "sync; echo 3 > /proc/sys/vm/drop_caches"
  214  echo PAESSHSTART;df -P;echo PAESSHEND
  215  df -h
  216  mysql -u root -p
  217  df -h
  218  echo PAESSHSTART;df -P;echo PAESSHEND
  219  df -h
  220  echo PAESSHSTART;df -P;echo PAESSHEND
  221  df -h
  222  top
  223  sudo sh -c "sync; echo 3 > /proc/sys/vm/drop_caches"
  224  top
  225  echo PAESSHSTART;df -P;echo PAESSHEND
  226  df -h
  227  sudo sh -c "sync; echo 3 > /proc/sys/vm/drop_caches"
  228  mysql -u root -p
  229  echo PAESSHSTART;df -P;echo PAESSHEND
  230  df -h
  231  sudo sh -c "sync; echo 3 > /proc/sys/vm/drop_caches"
  232  echo PAESSHSTART;df -P;echo PAESSHEND
  233  mysqldump -u root -p unified tbl_registered_users_main >/home/tbl_registered_users_main_21sep15.sql
  234  cd home
  235  cd /home
  236  rsync -r tbl_registered_users_main_21sep15.sql 172.31.22.58:/home
  237  echo PAESSHSTART;df -P;echo PAESSHEND
  238  df -h
  239  mysql -u rooot -p
  240  mysql -u root -p
  241  df -h
  242  echo PAESSHSTART;df -P;echo PAESSHEND
  243  sudo sh -c "sync; echo 3 > /proc/sys/vm/drop_caches"
  244  echo PAESSHSTART;df -P;echo PAESSHEND
  245  mysql -u root -p
  246  echo PAESSHSTART;df -P;echo PAESSHEND
  247  mysql -u root -p
  248  echo PAESSHSTART;df -P;echo PAESSHEND
  249  df -h
  250  mysql -u root -p
  251  df -h
  252  echo PAESSHSTART;df -P;echo PAESSHEND
  253  df -h
  254  sudo sh -c "sync; echo 3 > /proc/sys/vm/drop_caches"
  255  echo PAESSHSTART;df -P;echo PAESSHEND
  256  df -h
  257  sudo sh -c "sync; echo 3 > /proc/sys/vm/drop_caches"
  258  echo PAESSHSTART;df -P;echo PAESSHEND
  259  df -h
  260  mysql -u root -p
  261  df -h
  262  sudo sh -c "sync; echo 3 > /proc/sys/vm/drop_caches"
  263  echo PAESSHSTART;df -P;echo PAESSHEND
  264  mysqldump -u root -p unified >/home/unifed_3oct_15.sql
  265  mysql -u root -p
  266  cd /home
  267  rsync -r unifed_3oct_15.sql 172.31.22.58:/home
  268  mysql -u root -p
  269  mysqldump -u root -p unified >/home/unified_3oct.sql
  270  echo PAESSHSTART;df -P;echo PAESSHEND
  271  cd /home
  272  rsync -r unified_3oct.sql 172.31.22.58:/home
  273  echo PAESSHSTART;df -P;echo PAESSHEND
  274  mysql -u root -p
  275  echo PAESSHSTART;df -P;echo PAESSHEND
  276  mysql -u root -p
  277  echo PAESSHSTART;df -P;echo PAESSHEND
  278  cat /proc/cpuinfo
  279  grep flags /proc/cpuinfo
  280  uname -m
  281  uname -a
  282  echo PAESSHSTART;df -P;echo PAESSHEND
  283  df -h
  284  mysql -u root -p
  285  df -h
  286  echo PAESSHSTART;df -P;echo PAESSHEND
  287  sudo sh -c "sync; echo 3 > /proc/sys/vm/drop_caches"
  288  echo PAESSHSTART;df -P;echo PAESSHEND
  289  mysqldump -u root -p unified >/home/unified_8Oct.sql
  290  cd /home
  291  rsync -r unified_8Oct.sql 172.31.22.60:/home
  292  mysqldump -u root -p unified >/home/unified_8Oct.sql
  293  rsync -r unified_8Oct.sql 172.31.22.60:/home
  294  mysqldump -u root -p unified >/home/unified_8Oct.sql
  295  rsync -r unified_8Oct.sql 172.31.22.60:/home
  296  echo PAESSHSTART;df -P;echo PAESSHEND
  297  mysql -u root -p
  298  echo PAESSHSTART;df -P;echo PAESSHEND
  299  df -h
  300  sudo sh -c "sync; echo 3 > /proc/sys/vm/drop_caches"
  301  mysql -u root -p
  302  df -h
  303  echo PAESSHSTART;df -P;echo PAESSHEND
  304  df -h
  305  echo PAESSHSTART;df -P;echo PAESSHEND
  306  mysql -u root -p
  307  echo PAESSHSTART;df -P;echo PAESSHEND
  308  mysql -u root -p
  309  echo PAESSHSTART;df -P;echo PAESSHEND
  310  sh usr/syncservice/src/epgsync.run.sh
  311  crontab -e
  312  sh /usr/syncservice/src/epgsync.run.sh
  313  echo PAESSHSTART;df -P;echo PAESSHEND
  314  df -h
  315  echo PAESSHSTART;df -P;echo PAESSHEND
  316  df -h
  317  mysql - u root -p
  318  mysql -u root -p
  319  df -h
  320  echo PAESSHSTART;df -P;echo PAESSHEND
  321  df -h
  322  mysql - uroot -p
  323  mysql -u root -p
  324  df -h
  325  echo PAESSHSTART;df -P;echo PAESSHEND
  326  df -h
  327  echo PAESSHSTART;df -P;echo PAESSHEND
  328  df -h
  329  mysql -u root -p
  330  df -h
  331  echo PAESSHSTART;df -P;echo PAESSHEND
  332  sudo sh -c "sync; echo 3 > /proc/sys/vm/drop_caches"
  333  echo PAESSHSTART;df -P;echo PAESSHEND
  334  df -h
  335  mysql -u root -p
  336  df -h
  337  echo PAESSHSTART;df -P;echo PAESSHEND
  338  df -h
  339  mysqldump -u root -p
  340  mysqldump -u root -p unified >/home/MysqlBacup/unified_59/unified_31Oct_15.sql
  341  service mysql stop
  342  service mysql start
  343  sudo sh -c "sync; echo 3 > /proc/sys/vm/drop_caches"
  344  echo PAESSHSTART;df -P;echo PAESSHEND
  345  df -h
  346  sudo sh -c "sync; echo 3 > /proc/sys/vm/drop_caches"
  347  echo PAESSHSTART;df -P;echo PAESSHEND
  348  sudo sh -c "sync; echo 3 > /proc/sys/vm/drop_caches"
  349  df -h
  350  mysql -u root -p
  351  df -h
  352  echo PAESSHSTART;df -P;echo PAESSHEND
  353  mysql -u root -p
  354  echo PAESSHSTART;df -P;echo PAESSHEND
  355  sudo sh -c "sync; echo 3 > /proc/sys/vm/drop_caches"
  356  echo PAESSHSTART;df -P;echo PAESSHEND
  357  df -h
  358  echo PAESSHSTART;df -P;echo PAESSHEND
  359  sudo sh -c "sync; echo 3 > /proc/sys/vm/drop_caches"
  360  echo PAESSHSTART;df -P;echo PAESSHEND
  361  df -h
  362  sudo sh -c "sync; echo 3 > /proc/sys/vm/drop_caches"
  363  mysql -u root -p
  364  df -h
  365  echo PAESSHSTART;df -P;echo PAESSHEND
  366  df -h
  367  echo PAESSHSTART;df -P;echo PAESSHEND
  368  sudo sh -c "sync; echo 3 > /proc/sys/vm/drop_caches"
  369  echo PAESSHSTART;df -P;echo PAESSHEND
  370  df -h
  371  sudo sh -c "sync; echo 3 > /proc/sys/vm/drop_caches"
  372  mysql -u root -p
  373  df -h
  374  echo PAESSHSTART;df -P;echo PAESSHEND
  375  sudo sh -c "sync; echo 3 > /proc/sys/vm/drop_caches"
  376  echo PAESSHSTART;df -P;echo PAESSHEND
  377  df -h
  378  mysqldump -u root -p unified >/home/MysqlBacup/unified_59/unified_18Nov_15.sql
  379  echo PAESSHSTART;df -P;echo PAESSHEND
  380  crontab -e
  381  echo PAESSHSTART;df -P;echo PAESSHEND
  382  sh /usr/syncservice/src/epgsync.run.sh
  383  echo PAESSHSTART;df -P;echo PAESSHEND
  384  df -h
  385  mysql -u root -p
  386  df -h
  387  echo PAESSHSTART;df -P;echo PAESSHEND
  388  sudo sh -c "sync; echo 3 > /proc/sys/vm/drop_caches"
  389  echo PAESSHSTART;df -P;echo PAESSHEND
  390  crontab -e
  391  sh /usr/syncservice/src/epgsync.run.sh
  392  echo PAESSHSTART;df -P;echo PAESSHEND
  393  sudo sh -c "sync; echo 3 > /proc/sys/vm/drop_caches"
  394  df -h
  395  mysql -u root -p
  396  df -h
  397  echo PAESSHSTART;df -P;echo PAESSHEND
  398  sudo sh -c "sync; echo 3 > /proc/sys/vm/drop_caches"
  399  echo PAESSHSTART;df -P;echo PAESSHEND
  400  df -h
  401  mysql -u root -p
  402  df -h
  403  echo PAESSHSTART;df -P;echo PAESSHEND
  404  mysqldump -u root -p --no-data unified > /home/unified_struct_2dec_15.sql
  405  echo PAESSHSTART;df -P;echo PAESSHEND
  406  cd /var/lib/mysql
  407  tail -f mysql-bin.000472
  408  echo PAESSHSTART;df -P;echo PAESSHEND
  409  sudo sh -c "sync; echo 3 > /proc/sys/vm/drop_caches"
  410  cd /home/MysqlBacup/unified_59
  411  rsync -r unified_592015-12-02_04h01.sql  172.31.22.91:/home
  412  echo PAESSHSTART;df -P;echo PAESSHEND
  413  crontab -e
  414  sh /usr/syncservice/src/epgsync.run.sh
  415  echo PAESSHSTART;df -P;echo PAESSHEND
  416  df -h
  417  echo PAESSHSTART;df -P;echo PAESSHEND
  418  df -h
  419  mysql -u root -p
  420  df -h
  421  echo PAESSHSTART;df -P;echo PAESSHEND
  422  df-h
  423  df -h
  424  sudo sh -c "sync; echo 3 > /proc/sys/vm/drop_caches"
  425  mysql -u root -p
  426  df -h
  427  echo PAESSHSTART;df -P;echo PAESSHEND
  428  df -h
  429  mysql -u root -p
  430  echo PAESSHSTART;df -P;echo PAESSHEND
  431  df -h
  432  sudo sh -c "sync; echo 3 > /proc/sys/vm/drop_caches"
  433  echo PAESSHSTART;df -P;echo PAESSHEND
  434  df -h
  435  mysql -u root -p
  436  df -h
  437  mysql -u root -p
  438  sudo sh -c "sync; echo 3 > /proc/sys/vm/drop_caches"
  439  echo PAESSHSTART;df -P;echo PAESSHEND
  440  df -h
  441  mysql -u root -p
  442  sudo sh -c "sync; echo 3 > /proc/sys/vm/drop_caches"
  443  df -h
  444  echo PAESSHSTART;df -P;echo PAESSHEND
  445  sudo sh -c "sync; echo 3 > /proc/sys/vm/drop_caches"
  446  df -h
  447  echo PAESSHSTART;df -P;echo PAESSHEND
  448  sudo sh -c "sync; echo 3 > /proc/sys/vm/drop_caches"
  449  echo PAESSHSTART;df -P;echo PAESSHEND
  450  mysql -u root -p
  451  echo PAESSHSTART;df -P;echo PAESSHEND
  452  df -h
  453  mysql -u root -p
  454  df -h
  455  echo PAESSHSTART;df -P;echo PAESSHEND
  456  exit
  457  echo PAESSHSTART;df -P;echo PAESSHEND
  458  vim .ssh/authorized_keys
  459  chmod 600 .ssh/authorized_keys
  460  echo PAESSHSTART;df -P;echo PAESSHEND
  461  mysql -u root -p
  462  echo PAESSHSTART;df -P;echo PAESSHEND
  463  mysql -u root -p
  464  echo PAESSHSTART;df -P;echo PAESSHEND
  465  mysql -u root -p
  466  echo PAESSHSTART;df -P;echo PAESSHEND
  467  cd /db/
  468  ll
  469  cd bckup/
  470  ll
  471  du -sh unified-21-12-2015.sql
  472  ll
  473  gzip unified-21-12-2015.sql
  474  ll
  475  echo PAESSHSTART;df -P;echo PAESSHEND
  476  df -h
  477  cd /db/
  478  ll
  479  vim /etc/my.cnf
  480  cd bckup/
  481  ll
  482  cd ..
  483  cd mysql/
  484  ll
  485  du -sh unified/
  486  cd ..
  487  ll
  488  mysqldump -u root -p unified > bckup/unified-21-12-2015.sql
  489  ll
  490  cd bckup/
  491  ll
  492  du -sh unified-21-12-2015.sql.gz
  493  ll
  494  du -sh unified-21-12-2015.sql.gz
  495  ll
  496  du -sh unified-21-12-2015.sql.gz
  497  echo PAESSHSTART;df -P;echo PAESSHEND
  498  df -h
  499  echo PAESSHSTART;df -P;echo PAESSHEND
  500  sudo sh -c "sync; echo 3 > /proc/sys/vm/drop_caches
  501  "
  502  echo PAESSHSTART;df -P;echo PAESSHEND
  503  cat /proc/cpuinfo
  504  free -m
  505  top
  506  sudo sh -c "sync; echo 3 > /proc/sys/vm/drop_caches"
  507  echo PAESSHSTART;df -P;echo PAESSHEND
  508  df -h
  509  crontab -e
  510  echo PAESSHSTART;df -P;echo PAESSHEND
  511  df -h
  512  crontab -e
  513  cd /usr/syncservice/src
  514  javac EPGSync.java
  515  crontab -e
  516  sh /usr/syncservice/src/epgsync.run.sh
  517  df -h
  518  echo PAESSHSTART;df -P;echo PAESSHEND
 519  df -h
  520  echo PAESSHSTART;df -P;echo PAESSHEND
  521  mysql -u root -p
  522  ifconfig
  523  echo PAESSHSTART;df -P;echo PAESSHEND
  524  sudo sh -c "sync; echo 3 > /proc/sys/vm/drop_caches"
  525  echo PAESSHSTART;df -P;echo PAESSHEND
  526  df -h
  527  mysqldump -u root -p unified  tbl_registered_users_main tbl_registered_users >/home/tbl_reg_users_28dec_15.sql
  528  mysqldump -u root -p unified  tbl_registered_users_main >/home/tbl_reg_users_28dec1_15.sql
  529  mysql -u root -p
  530  echo PAESSHSTART;df -P;echo PAESSHEND
  531  df -h
  532  sudo sh -c "sync; echo 3 > /proc/sys/vm/drop_caches"
  533  mysql -u root -p
  534  echo PAESSHSTART;df -P;echo PAESSHEND
  535  df -h
  536  echo PAESSHSTART;df -P;echo PAESSHEND
  537  ifconfig
  538  exit
  539  echo PAESSHSTART;df -P;echo PAESSHEND
  540  df -h
  541  sudo sh -c "sync; echo 3 > /proc/sys/vm/drop_caches"
  542  mysql -u root -p
  543  df -h
  544  echo PAESSHSTART;df -P;echo PAESSHEND
  545  ifconfig
  546  exit
  547  echo PAESSHSTART;df -P;echo PAESSHEND
  548  crontab 0l
  549  crontab -l
  550  vim /home/MySQLdump.sh
  551  df -h
  552  cd /home/
  553  ll
  554  cd MysqlBacup/
  555  ll
  556  cd aircel/
  557  l
  558  ll
  559  du -sh aircel_2016-01-07_04h00.sql
  560  ll
  561  cd ..
  562  ll
  563  cd common_hd/
  564  ll
  565  du -sh common_hd_2016-01-07_04h00.sql
  566  ll
  567  df -h
  568  cd /
  569  ll
  570  du -sh *
  571  cd var/
  572  ll
  573  du -sh *
  574  cd lib/
  575  ll
  576  du -sh *
  577  cd mysql
  578  ll
  579  df -h
  580  cd /db
  581  ll
  582  cd bckup/
  583  ll
  584  cd /home/MysqlBacup/
  585  ll
  586  cd common_hd/
  587  ll
  588  echo PAESSHSTART;df -P;echo PAESSHEND
  589  df -h
  590  cd /home/
  591  ll
  592  du -sh *
  593  cd MysqlBacup/
  594  ll
  595  du -sh *
  596  crontab -
  597  crontab -l
  598  cat /usr/syncservice/src/epgsync.run.sh
  599  cat /var/log/filesize.sh
  600  tail -f /var/log/mysqld.log
  601  vim /etc/my.cnf
  602  tail -f /var/log/mysqld.log
  603  ll
  604  crontab -l
  605  vim /home/MySQLdump.sh
  606  ll
  607  vim ORACLEdump.sh
  608  vim /home/MysqlBacup/unified.sql
  609  du -sh tbl_registered_users_17Feb.sql
  610  vim tbl_registered_users_17Feb.sql
  611  ls -ltr
  612  du -sh bcup/
  613  cd bcup/
  614  ll
  615  gzip *
  616  ll
  617  cd ..
  618  ll
  619  gzip tbl_registered_users_17Feb.sql
  620  ll
  621  cd aircel/
  622  ll
  623  gzip *
  624  ll
  625  cd ..
  626  ll
  627  cd bcup/
  628  ll
  629  cd ..
  630  ll
  631  cd common_hd/
  632  ll
  633  gzip *
  634  cd ..
  635  ll
  636  cd dthairtel/
  637  ll
  638  gzip *
  639  ll
  640  cd ..
  641  ll
  642  cd ondeck/
  643  ll
  644  gzip *
  645  ll
  646  cd ..
  647  ll
  648  cd unified
  649  ll
  650  gzip *
  651  ll
  652  cd ..
  653  ll
  654  cd unified_59/
  655  ll
  656  gzip *
  657  ll
  658  cd ..
  659  ll
  660  cd VIDDTH/
  661  l
  662  ll
  663  gzip *
  664  ll
  665  cd ..
  666  ll
  667  echo PAESSHSTART;df -P;echo PAESSHEND
  668  cd /home/MysqlBacup/unified_59
  669  rsync -r unified_592016-01-07_04h01.sql.gz 172.31.22.91:/home
  670  echo PAESSHSTART;df -P;echo PAESSHEND
  671  df -h
  672  crontab -l
  673  sudo sh -c "sync; echo 3 > /proc/sys/vm/drop_caches"
  674  echo PAESSHSTART;df -P;echo PAESSHEND
  675  df -h
  676  mysql -u root -p
  677  sudo sh -c "sync; echo 3 > /proc/sys/vm/drop_caches"
  678  echo PAESSHSTART;df -P;echo PAESSHEND
  679  ll
  680  cd /
  681  ll
  682  df -h
  683  cd /home/
  684  ll
  685  cd database/
  686  ll
  687  cd mysql/
  688  ll
  689  cd ..
  690  ll
  691  cd MysqlBacup/
  692  ll
  693  cd unified
  694  ll
  695  ls -lr
  696  sl -ltr
  697  ls -ltr
  698  scp unified_2016-01-14_04h00.sql.gz root@172.31.22.91:~/tools/
  699  ifconfig
  700  echo PAESSHSTART;df -P;echo PAESSHEND
  701  df -h
  702  crontab -e
  703  ssh 172.31.22.159
  704  echo PAESSHSTART;df -P;echo PAESSHEND
  705  cd /usr/syncservice/src
  706  javac Oracle2sql.java
  707  crontab -l
  708  crontab -e
  709  echo PAESSHSTART;df -P;echo PAESSHEND
  710  df -h
  711  mysql -u root -p
  712  df -h
  713  echo PAESSHSTART;df -P;echo PAESSHEND
  714  ifconfig
  715  df -h
  716  cd /
  717  ll
  718  du -sh *
  719  df -h
  720  cd /var/
  721  l;
  722  ll
  723  du -sh *
  724  cd lib/
  725  ll
  726  du -sh *
  727  cd mysql
  728  ll
  729  vim /etc/my.cnf
  730  mysql -u root -p
  731  ls -ltr
  732  mysql -u root -p
  733  ls -ltr
  734  df -h
  735  mysql -u root -p
  736  ll
  737  df -h
  738  vim /etc/my.cnf
  739  mysql -u root -p
  740  echo PAESSHSTART;df -P;echo PAESSHEND
  741  df -h
  742  mysql -u root -p
  743  echo PAESSHSTART;df -P;echo PAESSHEND
  744  df -h
  745  echo PAESSHSTART;df -P;echo PAESSHEND
  746  ifcofnig
  747  ifconfig
  748  df -h
  749  mysql -u root -p
  750  df -h
  751  cd /db/
  752  ll
  753  cd bckup/
  754  ll
  755  cd ..
  756  cd mysql/
  757  ll
  758  pwd
  759  vim /etc/my.cnf
  760  crontab -l
  761  vim /home/MySQLdump.sh
  762  cd  /home/MysqlBacup/unified
  763  ls -ltr
  764  gunzip unified_2016-02-04_04h00.sql.gz
  765  ll
  766  mysql -u root -p unifiedtest < unified_2016-02-04_04h00.sql
  767  echo PAESSHSTART;df -P;echo PAESSHEND
  768  cd /usr/syncservice/src
  769  javac Oracle2sql.java
  770  echo PAESSHSTART;df -P;echo PAESSHEND
  771  /etc/init.d/mysql restart
  772  /etc/init.d/mysql status
  773  mysql -u root -p
  774  df -h
  775  uptime
  776  top -d 2
  777  mysql -u root -p
  778  echo PAESSHSTART;df -P;echo PAESSHEND
  779  cat .ssh/authorized_keys
  780  echo PAESSHSTART;df -P;echo PAESSHEND
  781  top -d 2
  782  echo PAESSHSTART;df -P;echo PAESSHEND
  783  ls -ltr
  784  mysql -u root -p
  785  cd /home/My
  786  cd /home/MySQLdump
  787  cd /home/MysqlBacup/
  788  ll
  789  cd unified
  790  ls -ltr
  791  mysql -u root -p unifiedtest < unified_2016-02-04_04h00.sql
  792  echo PAESSHSTART;df -P;echo PAESSHEND
  793  ifconfig
  794  exit
  795  echo PAESSHSTART;df -P;echo PAESSHEND
  796  mysql -u root -p
  797  echo PAESSHSTART;df -P;echo PAESSHEND
  798  mysql -u root -p
  799  echo PAESSHSTART;df -P;echo PAESSHEND
  800  df -h
  801  mysql -u root -p
  802  echo PAESSHSTART;df -P;echo PAESSHEND
  803  free -m
  804  top -d 2
  805  cat /proc/cpuinfo
  806  df -h
  807  cat /etc/redhat-release
  808  uname a-
  809  uname -a
  810  echo PAESSHSTART;df -P;echo PAESSHEND
  811  cat .ssh/authorized_keys
  812  echo PAESSHSTART;df -P;echo PAESSHEND
  813  mysql -u root -p
  814  exit
  815  echo PAESSHSTART;df -P;echo PAESSHEND
  816  crontab -l
  817  echo PAESSHSTART;df -P;echo PAESSHEND
  818  cat /proc/cpuinfo
  819  ssh root@172.31.22.60
  820  exit
  821  echo PAESSHSTART;df -P;echo PAESSHEND
  822  route -n
  823  vim /etc/sysconfig/network-scripts/route-eth0
  824  exit
  825  echo PAESSHSTART;df -P;echo PAESSHEND
  826  route -n
  827  exit
  828  echo PAESSHSTART;df -P;echo PAESSHEND
  829  route -n
  830  ssh root@172.31.22.60
  831  ssh root@172.31.22.160
  832  exit
  833  echo PAESSHSTART;df -P;echo PAESSHEND
  834  df -kh
  835  ssh root@172.31.22.60
  836  exit
  837  echo PAESSHSTART;df -P;echo PAESSHEND
  838  crontab -l
  839  echo PAESSHSTART;df -P;echo PAESSHEND
  840  cd /
  841  ll
  842  df -h
  843  cd /home/
  844  ll
  845  cd MysqlBacup/
  846  l
  847  ls -ltr
  848  cd common_hd/
  849  ls -ltr
  850  cd ..
  851  ls -ltr
  852  cd unified
  853  ls -ltr
  854  scp unified_2016-03-14_04h00.sql.gz root@172.31.22.91:/root/tools/
  855  echo PAESSHSTART;df -P;echo PAESSHEND
  856  mysqldump -u root -p unified >/home/unified_15march.sql
  857  cd /home
  858  rsync -r unified_15march.sql   172.31.22.91:/home
  859  echo PAESSHSTART;df -P;echo PAESSHEND
  860  sudo sh -c "sync; echo 3 > /proc/sys/vm/drop_caches"
  861  df -h
  862  mysql -u root -p
  863  df -h
  864  echo PAESSHSTART;df -P;echo PAESSHEND
  865  crontab -ll
  866  crontab -l
  867  crontab -e
  868  echo PAESSHSTART;df -P;echo PAESSHEND
 869  mysql -u root -p unififed
  870  mysql -u root -p unified
  871  echo PAESSHSTART;df -P;echo PAESSHEND
  872  mysql -u root -p unified
  873  echo PAESSHSTART;df -P;echo PAESSHEND
  874  df -h
  875  du -sh *
  876  df -h
  877  mysql -u root -p
  878  df -h
  879  echo PAESSHSTART;df -P;echo PAESSHEND
  880  mysql -u root -p
  881  echo PAESSHSTART;df -P;echo PAESSHEND
  882  telnet 172.29.10.105 1521
  883  echo PAESSHSTART;df -P;echo PAESSHEND
  884  telnet 172.29.10.117 1521
  885  telnet 172.29.10.105 1521
  886  echo PAESSHSTART;df -P;echo PAESSHEND
  887  sudo sh -c "sync; echo 3 > /proc/sys/vm/drop_caches"
  888  echo PAESSHSTART;df -P;echo PAESSHEND
  889  df -h
  890  mysql -u root -p
  891  echo PAESSHSTART;df -P;echo PAESSHEND
  892  crontab -l
  893  echo PAESSHSTART;df -P;echo PAESSHEND
  894  mysql -u root -p
  895  echo PAESSHSTART;df -P;echo PAESSHEND
  896  crontab -l
  897  echo PAESSHSTART;df -P;echo PAESSHEND
  898  crontab -e
  899  echo PAESSHSTART;df -P;echo PAESSHEND
  900  crontab -e
  901  sh /usr/syncservice/src/nexg_tv.run.sh
  902  echo PAESSHSTART;df -P;echo PAESSHEND
  903  crontab -e
  904  crontab -l
  905  sh /usr/syncservice/src/nexg_tv.run.sh
  906  echo PAESSHSTART;df -P;echo PAESSHEND
  907  mysql -u root -p
  908  echo PAESSHSTART;df -P;echo PAESSHEND
  909  cd /usr/syncservice/src
  910  javac Oracle2sql.java
  911  javac Oracle2sql_vod_dect.java
  912  df -h
  913  mysql -u root -p
  914  df -h
  915  java -classpath .:/usr/syncservice/src/mysql-connector-java-5.0.8-bin.jar:/usr/syncservice/src/ojdbc14.jar:/usr/syncservice/src Oracle2sql
  916  service memcached relaod
  917  service memcached reload
  918  service memcache  reload
  919  echo PAESSHSTART;df -P;echo PAESSHEND
  920  ps -wef |grep java|grep -v grep
  921  echo PAESSHSTART;df -P;echo PAESSHEND
  922  crontab -l
  923  crontab -e
  924  crontab -l
  925  echo PAESSHSTART;df -P;echo PAESSHEND
  926  crontab -l
  927  echo PAESSHSTART;df -P;echo PAESSHEND
  928  mysql -u root -p
  929  echo PAESSHSTART;df -P;echo PAESSHEND
  930  df -h
  931  top
  932  mysql -u root -p
  933  date
  934  mysql -u root -p
  935  echo PAESSHSTART;df -P;echo PAESSHEND
  936  crontab -e
  937  echo PAESSHSTART;df -P;echo PAESSHEND
  938  top
  939  sh /usr/syncservice/src/nexg_tv.run.sh
  940  echo PAESSHSTART;df -P;echo PAESSHEND
  941  crontab -l
  942  crontab -e
  943  echo PAESSHSTART;df -P;echo PAESSHEND
  944  df -h
  945  du -sh*
  946  df -h
  947  echo PAESSHSTART;df -P;echo PAESSHEND
  948  crontab -e
  949  echo PAESSHSTART;df -P;echo PAESSHEND
  950  crontab -e
  951  crontab -l
  952  echo PAESSHSTART;df -P;echo PAESSHEND
  953  df -h
  954  mysqldump -u root -p --no-data unified>unifiedstructuredump.sql
  955  mysql -u root -p
  956  echo PAESSHSTART;df -P;echo PAESSHEND
  957  cd /usr/syncservice/src
  958  javac Oracle2sqlAnalytics.java
  959  crontab -l
  960  crontab -e
  961  echo PAESSHSTART;df -P;echo PAESSHEND
  962  crontab -l
  963  ps -wef |grep nexg_tv.run
  964  ps -wef |grep nexg_tv.run |grep -v grep
  965  sh /usr/syncservice/src/nexg_tv.run.sh
  966  echo PAESSHSTART;df -P;echo PAESSHEND
  967  rpm -qa |grep MySQL
  968  ifcofnig
  969  ifconifg
  970  ifconfig
  971  rpm -qa |grep MySQL
  972  mysql -u root -p
  973  cat /etc/resolv.conf
  974  cd /var/log/mysql
  975  ls -ltr
  976  echo PAESSHSTART;df -P;echo PAESSHEND
  977  cd /db/
  978  ll
  979  du -sh mysqlbak/
  980  cd /root/tools/
  981  ll
  982  vim /etc/my.cnf
  983  du -sh /db/mysql/
  984  df -h
  985  cp -prv /db/mysql /db/mysqlbak
  986  cd
  987  rpm -qa |grep mysql
  988  rpm -qa |grep MySQL
  989  /etc/init.d/mysql stop
  990  rpm -e MySQL-server-advanced MySQL-shared-advanced MySQL-embedded-advanced MySQL-test-advanced MySQL-client-advanced MySQL-devel-advanced
  991  rpm -qa |grep MySQL
  992  cd tools/
  993  ll
  994  rpm -Uvn *
  995  rpm -Uvh *
  996  /etc/init.d/mysql start
  997  msyql -u root -p
  998  mysql -u root -p
  999  echo PAESSHSTART;df -P;echo PAESSHEND
1000  history
[root@INDB-0-2 ~]# history
    1  echo PAESSHSTART;df -P;echo PAESSHEND
    2  mysqldump -u root -p unified >/home/MysqlBacup/unified_59/unified_ev_10jult_15.sql
    3  cd /home/MysqlBacup/unified_59
    4  rsync -r unified_ev_10jult_15.sql 172.31.22.60:/home/
    5  echo PAESSHSTART;df -P;echo PAESSHEND
    6  sudo sh -c "sync; echo 3 > /proc/sys/vm/drop_caches"
    7  mysqldump -u root -p unified >/home/MysqlBacup/unified_59/unified_12JULY.sql
    8  cd /home/MysqlBacup/unified_59
    9  rsync -r unified_12JULY.sql  172.31.22.60:/home
   10  echo PAESSHSTART;df -P;echo PAESSHEND
   11  mysqldump -u root -p unified >/home/MysqlBacup/unified_59/unified_12JULY.sql
   12  cd /home/MysqlBacup/unified_59
   13  rsync -r unified_12JULY.sql  172.31.22.60:/home
   14  echo PAESSHSTART;df -P;echo PAESSHEND
   15  mysqldump -u root -p unified >/home/MysqlBacup/unified_59/unified_12JULY_9:13NIGHT.sql
   16  echo PAESSHSTART;df -P;echo PAESSHEND
   17  df -h
   18  sudo sh -c "sync; echo 3 > /proc/sys/vm/drop_caches"
   19  echo PAESSHSTART;df -P;echo PAESSHEND
   20  mysql -u root -p
   21  echo PAESSHSTART;df -P;echo PAESSHEND
   22  sudo sh -c "sync; echo 3 > /proc/sys/vm/drop_caches"
   23  df -h
   24  mysql -u root -p
   25  df -h
   26  echo PAESSHSTART;df -P;echo PAESSHEND
   27  sudo sh -c "sync; echo 3 > /proc/sys/vm/drop_caches"
   28  echo PAESSHSTART;df -P;echo PAESSHEND
   29  df -h
   30  echo PAESSHSTART;df -P;echo PAESSHEND
   31  date
   32  echo PAESSHSTART;df -P;echo PAESSHEND
   33  netstat -an |grep :3306 |wc -l
   34  mysql -u root -p
   35  sudo sh -c "sync; echo 3 > /proc/sys/vm/drop_caches"
   36  echo PAESSHSTART;df -P;echo PAESSHEND
   37  mysqldump -u root -p unified >/home/MysqlBacup/unified_59/unifeid_22July_15.sql
   38  mysql -u root -p
   39  echo PAESSHSTART;df -P;echo PAESSHEND
   40  sudo sh -c "sync; echo 3 > /proc/sys/vm/drop_caches"
   41  ssh 172.31.22.58
   42  echo PAESSHSTART;df -P;echo PAESSHEND
   43  mysqldump -u root -p staging >/home/staging_23July_15.sql
   44  echo PAESSHSTART;df -P;echo PAESSHEND
   45  df -h
   46  mysql -u root -p
   47  df -h
   48  ssh 172.31.22.58
   49  echo PAESSHSTART;df -P;echo PAESSHEND
   50  df-h
   51  df -h
   52  echo PAESSHSTART;df -P;echo PAESSHEND
   53  sudo sh -c "sync; echo 3 > /proc/sys/vm/drop_caches"
   54  echo PAESSHSTART;df -P;echo PAESSHEND
   55  sudo sh -c "sync; echo 3 > /proc/sys/vm/drop_caches"
   56  echo PAESSHSTART;df -P;echo PAESSHEND
   57  uname -a
   58  echo PAESSHSTART;df -P;echo PAESSHEND
   59  mysqldump -u root -p -R >/home/proc1.sql
   60  mysqldump -u root -p unified --routines --triggers >/home/proc1.sql
   61  mysqldump --routines --no-create-info --no-data --no-create-db --skip-opt unified > >/home/proc1.sql
   62  mysqldump --routines --no-create-info --no-data --no-create-db --skip-opt unified > /home/proc1.sql
   63  mysqldump -u root -p  --routines --no-create-info --no-data --no-create-db --skip-opt unified > /home/proc1.sql
   64  echo PAESSHSTART;df -P;echo PAESSHEND
   65  df -h
   66  echo PAESSHSTART;df -P;echo PAESSHEND
   67  mysql -u root -p
   68  ps ax |grep mysql
   69  service mysql stop
   70  service mysql start
   71  mysql -u root -p
   72  mysqldump -u root -p unified >/home/unified_3aug_15.sql
   73  cd /home
   74  rsync -r unified_3aug_15.sql 172.31.22.59:/home
   75  mysql -u root -p
   76  mysqldump -u root -p unified >/home/unified_3aug_15.sql
   77  rsync -r unified_3aug_15.sql 172.31.22.58:/home
   78  mysql -u root -p
   79  rsync -r unified_3aug_15.sql 172.31.22.91:/home
   80  mysqldump -u root -p unified tbl_registered_users tbl_registered_users_hd tbl_registered_users_hd_main tbl_registered_users_main tbl_registered_users_sd >/home/uni_tbl_3aug.sql
   81  rsunc -r uni_tbl_3aug.sql  172.31.22.58:/home/uni_tbl_3aug.sql
   82  rsync -r uni_tbl_3aug.sql  172.31.22.58:/home/uni_tbl_3aug.sql
   83  mysql -u root -p
   84  echo PAESSHSTART;df -P;echo PAESSHEND
   85  sh /usr/syncservice/src/epgsync.run.sh
   86  echo PAESSHSTART;df -P;echo PAESSHEND
   87  cd
   88  cd /home/MysqlBacup/unified_59
   89  rsync -r 172.31.22.45:/home/mysqlbackup
   90  rsync -r unified_592015-08-06_04h01.sql  172.31.22.45:/home/mysqlbackup
   91  echo PAESSHSTART;df -P;echo PAESSHEND
   92  df -h
   93  echo PAESSHSTART;df -P;echo PAESSHEND
   94  mysqldump -u root -p --structure unified >/home/unified_structure.sql
   95  mysqldump -u root -p --no-data  unified >/home/unified_structure.sql
   96  echo PAESSHSTART;df -P;echo PAESSHEND
   97  crontab -e
   98  sh  /usr/syncservice/src/epgsync.run.sh
   99  echo PAESSHSTART;df -P;echo PAESSHEND
  100  df -h
  101  mysql -u root -p
  102  echo PAESSHSTART;df -P;echo PAESSHEND
  103  mysql -u root -p
  104  echo PAESSHSTART;df -P;echo PAESSHEND
  105  sudo sh -c "sync; echo 3 > /proc/sys/vm/drop_caches"
  106  echo PAESSHSTART;df -P;echo PAESSHEND
  107  df -h
  108  mysql -u root -p
  109  echo PAESSHSTART;df -P;echo PAESSHEND
  110  mysqldump -u root -p  --no-data unified >/home/unified_structure_13Aug_15.sql
  111  echo PAESSHSTART;df -P;echo PAESSHEND
  112  df -h
  113  echo PAESSHSTART;df -P;echo PAESSHEND
  114  mysqldump -u root -p unified >/home/MysqlBacup/unified/unified_17Aug.sql
  115  cd /home/MysqlBacup/unified
  116  rsync -r unified_17Aug.sql 172.31.22.58:/home/mysqlBackup/unified
  117  mysql -u root -p
  118  echo PAESSHSTART;df -P;echo PAESSHEND
  119  df -h
  120  mysqldump -u root -p unified  ws_vods ws_subcategory ws_channel ws_category VOD_METADATA VIEW_VOD_MASTER view_vod_detail VIEW_SUBCAT_MASTER view_subcat_detail VIEW_CATEGORY_MASTER view_category_detail version_summary version >/home/unified_table_17Aug_15.sql
  121  cd /home
  122  rsync -r unified_table_17Aug_15.sql 172.31.22.58:/home
  123  echo PAESSHSTART;df -P;echo PAESSHEND
  124  sudo sh -c "sync; echo 3 > /proc/sys/vm/drop_caches"
  125  echo PAESSHSTART;df -P;echo PAESSHEND
  126  mysqldump -u root -p unified >/home/unified_19aug.sql
  127  cd home
  128  cd /home
  129  rsync -r unified_19aug.sql 172.31.22.58:/home
  130  mysql -u root -p
  131  echo PAESSHSTART;df -P;echo PAESSHEND
  132  df -h
  133  mysqldump -u rooot -p unified >/home/unified_19Aug_15.sql
  134  mysqldump -u root -p unified >/home/unified_19Aug.sql
  135  cd /home
  136  rsync -r unified_19Aug.sql 172.31.22..58:/home
  137  rsync -r unified_19Aug.sql 172.31.22.58:/home
  138  mysql -u root -p
  139  echo PAESSHSTART;df -P;echo PAESSHEND
  140  mysql -u root -p
  141  echo PAESSHSTART;df -P;echo PAESSHEND
  142  mysqldump -u root -p unified >/home/unified_20Aug.sql
  143  cd /home
  144  rsync -r  unified_20Aug.sql  -r 172.31.22.58:/home
  145  df -h
  146  mysql -u root -p
  147  echo PAESSHSTART;df -P;echo PAESSHEND
  148  df -h
  149  echo PAESSHSTART;df -P;echo PAESSHEND
  150  sudo sh -c "sync; echo 3 > /proc/sys/vm/drop_caches"
  151  echo PAESSHSTART;df -P;echo PAESSHEND
  152  df -h
  153  mysql -u root -p
  154  df -h
  155  echo PAESSHSTART;df -P;echo PAESSHEND
  156  ps ax |grep mysql
  157  kill -9 4399
  158  ps ax |grep mysql
  159  echo PAESSHSTART;df -P;echo PAESSHEND
  160  mysql -u root -p
  161  echo PAESSHSTART;df -P;echo PAESSHEND
  162  service mysql stop
  163  service mysql start
  164  mysqldump -u root -p unified >/home/unified_25Aug_15.sql
  165  rsync -r unified_25Aug_15.sql 172.31.22.58:/home/
  166  rsync -r /home/unified_25Aug_15.sql 172.31.22.58:/home/
  167  sudo sh -c "sync; echo 3 > /proc/sys/vm/drop_caches"
  168  echo PAESSHSTART;df -P;echo PAESSHEND
  169  sudo sh -c "sync; echo 3 > /proc/sys/vm/drop_caches"
  170  df -h
  171  echo PAESSHSTART;df -P;echo PAESSHEND
  172  cat CPUinfo
  173  /cat/cpuinfo
  174  echo PAESSHSTART;df -P;echo PAESSHEND
  175  crontab -e
  176  echo PAESSHSTART;df -P;echo PAESSHEND
  177  sh /usr/syncservice/src/epgsync.run.sh
  178  crontab -e
  179  echo PAESSHSTART;df -P;echo PAESSHEND
  180  sh /usr/syncservice/src/epgsync.run.sh
  181  ssh 172.31.22.159
  182  echo PAESSHSTART;df -P;echo PAESSHEND
  183  sudo sh -c "sync; echo 3 > /proc/sys/vm/drop_caches"
  184  df -h
  185  show binary logs\G;
  186  mysql -u root -p
  187  df -h
  188  echo PAESSHSTART;df -P;echo PAESSHEND
  189  mysqldump -u root -p unified CHANNEL_DETAIL_VIEW CHANNEL_RTSP_DETAILS_VIEW PACKAGE_CHANNEL_MAP_VIEW PACKAGE_MASTER_VIEW VIEW_VOD_MASTER VOD_METADATA ws_vods ws_category ws_channel ws_subcategory >/home/unified_2SEP_15sometable.sql
  190  mysql -u root -p
  191  mysqldump -u root -p unified  >/home/unified_2SEP_15sometable.sql
  192  mysql -u root -p
  193  echo PAESSHSTART;df -P;echo PAESSHEND
  194  df -h
  195  sudo sh -c "sync; echo 3 > /proc/sys/vm/drop_caches"
  196  df -h
  197  mysql -u root -p
  198  df -h
  199  mysql -u root -p
  200  df -h
  201  echo PAESSHSTART;df -P;echo PAESSHEND
  202  df -h
  203  free -m
  204  sudo sh -c "sync; echo 3 > /proc/sys/vm/drop_caches"
  205  free -m
  206  df -h
  207  ssh 172.31.22.58
  208  echo PAESSHSTART;df -P;echo PAESSHEND
  209  mysqldump -u root -p unified PACKAGE_CHANNEL_MAP_VIEW PACKAGE_MASTER_VIEW >/home/unified_2table.sql
  210  mysql -u root -p
  211  echo PAESSHSTART;df -P;echo PAESSHEND
  212  df



======================================================================================================================

Mysql installation







https://access.redhat.com/discussions/1469853



rpm -i MySQL-test-5.6.30-1.el6.x86_64.rpm MySQL-shared-compat-5.6.30-1.el6.x86_64.rpm MySQL-shared-5.6.30-1.el6.x86_64.rpm MySQL-server-5.6.30-1.el6.x86_64.rpm MySQL-embedded-5.6.30-1.el6.x86_64.rpm MySQL-devel-5.6.30-1.el6.x86_64.rpm MySQL-client-5.6.30-1.el6.x86_64.rpm



rpm -e MySQL-test-5.6.30-1.el6.x86_64.rpm MySQL-shared-compat-5.6.30-1.el6.x86_64.rpm MySQL-shared-5.6.30-1.el6.x86_64.rpm MySQL-server-5.6.30-1.el6.x86_64.rpm MySQL-embedded-5.6.30-1.el6.x86_64.rpm MySQL-devel-5.6.30-1.el6.x86_64.rpm MySQL-client-5.6.30-1.el6.x86_64.rpm


 rpm -e MySQL-server-advanced MySQL-shared-advanced MySQL-embedded-advanced MySQL-test-advanced MySQL-client-advanced MySQL-devel-advanced


remove old mysq from YUM command

then

sudo yum localinstall MySQL-embedded-advanced-5.6.24-1.el6.x86_64.rpm


sudo yum localinstall MySQL-test-advanced-5.6.24-1.el6.x86_64.rpm


sudo yum localinstall MySQL-shared-compat-advanced-5.6.24-1.el6.x86_64.rpm



sudo yum localinstall MySQL-shared-advanced-5.6.24-1.el6.x86_64.rpm


sudo yum localinstall MySQL-server-advanced-5.6.24-1.el6.x86_64.rpm


sudo yum localinstall MySQL-client-advanced-5.6.24-1.el6.x86_64.rpm


sudo yum localinstall MySQL-devel-advanced-5.6.24-1.el6.x86_64.rpm






=========================
for NOSQL IN SQL URL IS


https://scriptingmysql.wordpress.com/2014/05/01/use-mysql-to-store-nosql-and-sql-data-in-the-same-database-using-memcached-and-innodb/
=========================




 chmod -R 755 upload

cd /home/www/html/VIDDTH/admin/
cd /home/www/html/AIRDTH/admin/




===========================================================================================
snmp install



 rpm -Uvh *
 vim /etc/snmp/snmpd.conf (change file value.)

/etc/init.d/net
systemctl status snmpd.service
systemctl enable snmpd.service

systemctl restart snmpd.service

systemctl status snmpd.service




=================================================================




[root@APP001 tools]# rpm -Uvh *
Preparing...                          ################################# [100%]
Updating / installing...
   1:net-snmp-libs-1:5.7.2-24.el7     ################################# [ 33%]
   2:net-snmp-agent-libs-1:5.7.2-24.el################################# [ 67%]
   3:net-snmp-1:5.7.2-24.el7          ################################# [100%]
[root@APP001 tools]# vim /etc/snmp/snmpd.conf
[root@APP001 tools]# /etc/init.d/net
netconsole  network
[root@APP001 tools]# /etc/init.d/^C
[root@APP001 tools]# /etc/init.d/^C
[root@APP001 tools]# systemctl status snmpd.service
â snmpd.service - Simple Network Management Protocol (SNMP) Daemon.
   Loaded: loaded (/usr/lib/systemd/system/snmpd.service; disabled; vendor preset: disabled)
   Active: inactive (dead)
[root@APP001 tools]# systemctl enable snmpd.service
Created symlink from /etc/systemd/system/multi-user.target.wants/snmpd.service to /usr/lib/systemd/system/snmpd.service.
[root@APP001 tools]# systemctl restart snmpd.service
[root@APP001 tools]# systemctl status snmpd.service
â snmpd.service - Simple Network Management Protocol (SNMP) Daemon.
   Loaded: loaded (/usr/lib/systemd/system/snmpd.service; enabled; vendor preset: disabled)
   Active: active (running) since Tue 2016-09-06 16:29:32 IST; 4s ago
 Main PID: 30009 (snmpd)
   CGroup: /system.slice/snmpd.service
           ââ30009 /usr/sbin/snmpd -LS0-6d -f

Sep 06 16:29:32 APP001 systemd[1]: Starting Simple Network Management Protocol (SNMP) Daemon....
Sep 06 16:29:32 APP001 snmpd[30009]: NET-SNMP version 5.7.2
Sep 06 16:29:32 APP001 systemd[1]: Started Simple Network Management Protocol (SNMP) Daemon..
[root@APP001 tools]# systemctl^Cestart snmpd.service
[root@APP001 tools]#  vim /etc/snmp/snmpd.conf






===============================================

EPEL redhat extra package library


 yum install php-pecl-ssh2

 yum install epel*

php -m|grep ssh







===========================================





[client]
socket = /home/mysql/mysql.sock


==========================================
Install soap client


yum install php-soap

==================================================================
http://php.net/manual/en/ssh2.installation.php

Change file permission in appachie

chown -R apache:apache logs

chmod 755 logs


tar -xvzf html-2016-08-24.tar.gz

======================================
date -s '2016-08-30 15:26:56'

Tue Aug 30 14:24:56 IST 2016


yum install vim php httpd php-mysql


yum install php-mysql

 netstat -an|more

yum install sysstat


netstat -an|more

yum install netstat


yum install net-tools



netstat -an|more

ifconfig

iptables -L -n

iptables -F

chkconfig iptables off


 cat /etc/redhat-release


service firewalld stop

chkconfig firewalld off



 yum install php-memcached  php-memcache


==========================================
command change path php from linux

vim /etc/sysconfig/selinux

change SELINUX=disabled



setenforce 0

getenforce
=====================================================================

Install nginx

yum install epel-release


yum -y install nginx

service nginx start

service nginx stop



====================================
change in centos error for

configure: error: Cannot find OpenSSL's <evp.h>


 yum install openssl-devel

sudo pecl install mongodb


http://php.net/manual/en/mongodb.installation.pecl.php
http://stackoverflow.com/questions/23181096/configure-cant-find-evp-h


==================================

tar -xvzf html-2016-08-24.tar.gz


========================================


CREATE USER 'newuser'@'localhost' IDENTIFIED BY 'password';










CREATE USER 'neo'@'172.31.22.102' IDENTIFIED BY 'admin123';


GRANT ALL PRIVILEGES ON * . * TO 'neo'@'172.31.22.102';


CREATE USER 'root'@'172.31.22.102' IDENTIFIED BY 'root123';


GRANT ALL PRIVILEGES ON * . * TO 'root'@'172.31.22.102';






















CREATE USER 'neo'@'172.31.22.103' IDENTIFIED BY 'admin123';


GRANT ALL PRIVILEGES ON * . * TO 'neo'@'172.31.22.103';


CREATE USER 'root'@'172.31.22.103' IDENTIFIED BY 'root123';


GRANT ALL PRIVILEGES ON * . * TO 'root'@'172.31.22.103';






=====================================================



db.USER.find({"first_name":"nexg1981"})


db.USER.remove({"first_name":"popopo"})


db.SESSION.remove({"user_id":"57c804c2c29ef208497a8555"})


db.SESSION.find({"user_id":"57c9743fc19ef2116d8b456b"}).pretty()

 db.SESSION.find({"user_id":"57c804c2c29ef208497a8555"}).pretty()


565c8c878c86ba151d29b689

db.CATLOGUES.find({"_id":ObjectId("565c8c878c86ba151d29b689")}).pretty()




db.ASSETS.find({"genre":{"$in":["56e156139da23c60750e692a"]}})


db.SESSION.find({"catlogue":{"$in":["565c8c878c86ba151d29b689"]}},{"plateform" : "Android"}).limit(1).pretty()



db.SESSION.find({"catlogue":{"$in":["565c8c878c86ba151d29b689"]},"plateform" : "iOS"}).count()

db.SESSION.find({"catlogue":{"$in":["565c8c878c86ba151d29b689"]},"plateform" : "Android"}).count()

db.SESSION.distinct('device_id',{"catlogue":{"$in":["565c8c878c86ba151d29b689"]},"plateform" : "Android"});








android  totalcount

398888    398893



db.SESSION.find({"plateform" : "Android"},"catlogue":{"$in":["565c8c878c86ba151d29b689"]}).limit(1).pretty()


 db.SESSION.find({"catlogue":{"$in":["565c8c878c86ba151d29b689"]}},{"plateform":"iOS"}).count()


ObjectId("57a08eee7f8b9ab708d6c9e7")

db.ASSETS.find({"catlogue":{"$in":["57a08eee7f8b9ab708d6c9e7"]}})
//Firetv

db.ASSETS.find({"catlogue":{"$in":["57a08eee7f8b9ab708d6c9e7"]}, "type":"episode"})



db.SESSION.find({"catlogue":{"$in":["57a08eee7f8b9ab708d6c9e7"]}})




ObjectId("57d00c3a064a23f914795ef3")


======================================================




db.SESSION.remove({"_id" : ObjectId("57a8136cc935952b865b48e5")})



db.SESSION.find({"_id" : ObjectId("573a1357c935952b8647ac62")})










db.SESSION.find({"_id" : ObjectId("57a8136cc935952b865b48e5")})

db.SESSION.find({"_id" : ObjectId("573a1357c935952b8647ac62")})


57a81339c29ef228357bc7cb





db.USER.find({"_id" : ObjectId("57a81339c29ef228357bc7cb")})

db.USER.remove({"_id" : ObjectId("57a81339c29ef228357bc7cb")})


573a1325c19ef2dc601c2a95




ObjectId("57d00c3a064a23f914795ef3")








clientapps.nexg.tv/webservice/signup/


authorization   de6ed43f6c08ecf56536f8abcc812701

appinventiv     digivive


device_id    123Manoj








"country_code" : "KR",
    "country_name" : "Korea, Republic of"






plateform   testmanoj



=========================================================================



















CRDV_BD_CODE varchar(255)
CH676
RTSP_2G varchar(255)
rtsp://liver.nexg.tv/liver/pogo_2G.sdp

RTSP_3G varchar(255)
rtsp://liver.nexg.tv/liver/pogo_3G.sdp
HTTP_2G varchar(255)
http://liveha.nexg.tv/liveha/pogo.smil/playlist.m3u8
HTTP_3G varchar(255)
http://hdapplive.nexg.tv/hdapp/pogo.smil/playlist.m3u8
MPEG4 varchar(255)
http://vod.nexg.tv/liveloop/pogowap.smil/playlist.m3u8
HTTP_SMIL varchar(255)
http://vod.nexg.tv/liveloop/pogo.smil/playlist.m3u8
WINDOWS_URL varchar(255)
http://livehs.nexg.tv/livehs/pogo.smil/Manifest
CRDV_OPERATOR varchar(255)
OAIRT
RTSP_HD varchar(255)
rtsp://liver.nexg.tv/liver/pogo_HD.sdp



===========================================================================

db.SESSION.find({"user_id":"57c9743fc19ef2116d8b456b"}).pretty()



=========================================================================


{
        "_id" : ObjectId("565c8c878c86ba151d29b689"),
        "catlogues_code" : "APP001",
        "catlogues_name" : "NexGTV",
        "catlogues_status" : "1"
}
rs0:PRIMARY> db.CATLOGUES.find().pretty()
{
        "_id" : ObjectId("565c8c878c86ba151d29b689"),
        "catlogues_code" : "APP001",
        "catlogues_name" : "NexGTV",
        "catlogues_status" : "1"
}
{
        "_id" : ObjectId("56b34109d0944fca428b456b"),
        "catlogues_code" : "APP002",
        "catlogues_name" : "nexGTv Kids",
        "catlogues_status" : "1",
        "catlogues_insert_time" : ISODate("2016-02-04T12:16:09.416Z"),
        "catlogues_update_time" : ISODate("2016-02-04T12:16:09.416Z")
}
{
        "_id" : ObjectId("57550ee77f8b9a5d2eb061b1"),
        "catlogues_name" : "nexgtvnews",
        "catlogues_insert_time" : ISODate("2016-06-06T05:49:27.653Z"),
        "catlogues_update_time" : ISODate("2016-06-06T05:49:27.653Z"),
        "catlogues_code" : "APP009",
        "catlogues_status" : "1"
}
{
        "_id" : ObjectId("5757e3e47f8b9a2a2f8b4567"),
        "catlogues_name" : "moviesnmusic",
        "catlogues_insert_time" : ISODate("2016-06-08T09:22:44.224Z"),
        "catlogues_update_time" : ISODate("2016-06-08T09:22:44.224Z"),
        "catlogues_code" : "APP010",
        "catlogues_status" : "1"
}
{
        "_id" : ObjectId("5757e41d7f8b9a2c2f8b4567"),
        "catlogues_name" : "nexgtvcomedy",
        "catlogues_insert_time" : ISODate("2016-06-08T09:23:41.017Z"),
        "catlogues_update_time" : ISODate("2016-06-08T09:23:41.017Z"),
        "catlogues_code" : "APP011",
        "catlogues_status" : "1"
}
{
        "_id" : ObjectId("5757e4277f8b9a8e318b4567"),
        "catlogues_name" : "nexgtvyoga",
        "catlogues_insert_time" : ISODate("2016-06-08T09:23:51.475Z"),
        "catlogues_update_time" : ISODate("2016-06-08T09:23:51.475Z"),
        "catlogues_code" : "APP012",
        "catlogues_status" : "1"
}
{
        "_id" : ObjectId("575bf78f7f8b9a46468b4567"),
        "catlogues_name" : "nexgtvastro",
        "catlogues_insert_time" : ISODate("2016-06-11T11:35:43.181Z"),
        "catlogues_update_time" : ISODate("2016-06-11T11:35:43.181Z"),
        "catlogues_code" : "APP009",
        "catlogues_status" : "1"
}
{
        "_id" : ObjectId("577cb6d37f8b9ab017819fe4"),
        "catlogues_name" : "nexgtvhotflix",
        "catlogues_insert_time" : ISODate("2016-07-06T07:44:19.307Z"),
        "catlogues_update_time" : ISODate("2016-07-06T07:44:19.307Z"),
        "catlogues_code" : "APP011",
        "catlogues_status" : "1"
}
{
        "_id" : ObjectId("578736217f8b9a0b0958a47d"),
        "catlogues_name" : "bollywoodadda",
        "catlogues_insert_time" : ISODate("2016-07-14T06:50:09.770Z"),
        "catlogues_update_time" : ISODate("2016-07-14T06:50:09.770Z"),
        "catlogues_code" : "APP016",
        "catlogues_status" : "1"
}
{
        "_id" : ObjectId("578e03f77f8b9a2b21b91142"),
        "catlogues_name" : "digiflix",
        "catlogues_insert_time" : ISODate("2016-07-19T10:41:59.025Z"),
        "catlogues_update_time" : ISODate("2016-07-19T10:41:59.025Z"),
        "catlogues_code" : "APP017",
        "catlogues_status" : "1"
}
{
        "_id" : ObjectId("57a08eee7f8b9ab708d6c9e7"),
        "catlogues_name" : "firetv",
        "catlogues_insert_time" : ISODate("2016-08-02T12:15:42.137Z"),
        "catlogues_update_time" : ISODate("2016-08-02T12:15:42.137Z"),
        "catlogues_code" : "APP018",
        "catlogues_status" : "1"
}
{
        "_id" : ObjectId("57bc13bd7f8b9acb11ac9bce"),
        "catlogues_name" : "digiflixapp",
        "catlogues_insert_time" : ISODate("2016-08-23T09:13:33.381Z"),
        "catlogues_update_time" : ISODate("2016-08-26T11:43:25.807Z"),
        "catlogues_code" : "APP021",
        "catlogues_status" : "1"
}




echo $params['country']."==";


db.SESSION.find({"_id" : ObjectId("57a8136cc935952b865b48e5")})




db.SESSION.find({"_id" : ObjectId("573a1357c935952b8647ac62")})





db.SESSION.find("catlogue":{"$in":["57a08eee7f8b9ab708d6c9e7"]})





db.ASSETS.find()

====================================================

db.ASSETS.aggregate(
   {$group : { '_id' : "$channel_name",'charge_code':{'$first':'$charge_code'},'platform':{'$first':'$platform'}}}
)