PHPBLOG: May 2014

//Bckup mongodb #!/bin/bash MONGO_DATABASE="nexgtv_16" APP_NAME="nexgtv" MONGO_HOST="127.0.0.1" MONGO_PORT="27017" TIMESTAMP=`date +%F-%H%M` MONGODUMP_PATH="/usr/bin/mongodump" BACKUPS_DIR="/data/appinvn/backups/$APP_NAME" BACKUP_NAME="$APP_NAME-$TIMESTAMP" $MONGODUMP_PATH -d $MONGO_DATABASE mkdir -p $BACKUPS_DIR mv dump $BACKUP_NAME tar -zcvf $BACKUPS_DIR/$BACKUP_NAME.tgz $BACKUP_NAME rm -rf $BACKUP_NAME find /data/appinvn/backups/nexgtv/ -mindepth 1 -mtime +17 -delete

java -classpath .:/usr/syncservice/src/mysql-connector-java-5.0.8-bin.jar:/usr/syncservice/src/ojdbc14.jar:/usr/syncservice/src Oracle_airtel_hd_test

0 4 * * * /share/syncservice/sync_ondeck_aircel_hd/src/catalog_aircel.run.sh

java -classpath .:/share/syncservice/src/mysql-connector-java-5.0.8-bin.jar:/share/syncservice/src/ojdbc14.jar:/share/syncservice/src Oracle_dth

ps ax |grep http

/etc/init.d/httpd fullstatus | more

netstat -an |grep :3306 |wc -l

netstat -an |grep :80 |wc -l

tail -f error_log
/var/log/httpd

update pushnotificationuser dest , tbl_reg_user_common_hd co_hd set
dest.reg_msisdn= co_hd.reg_msisdn where dest.name = co_hd.deviceid

SELECT DATE_FORMAT(DATE(replace_date),'%d-%m-%Y') as curRepDate ,replace_date,DATE_FORMAT(DATE(DATE_ADD(replace_date,INTERVAL 30 DAY)),'%d-%m-%Y') as nextReplace from

device_replace_his where cr_number='12367891012451'

http://119.252.216.91/unified_android/admin/pushNotificationUser_crown.php
=======================================================================================================
Thank you for showing interest in the airtel digitalTV pocket app. Your One time activation password is 12345. Please use it within 2hrs.

delete
FROM `tbl_registered_users`
WHERE `reg_device_id` LIKE '%test%'

memcached -d -m 1024 -u root -l 127.0.0.1 -p 11211

mysqladmin -uroot -proot123 extended-status | grep Threads

======================================================
SHOW STATUS WHERE `variable_name` = 'Threads_connected';

mpstat -P ALL

mysqld will timeout DB Connections based on two(2) server options:

interactive_timeout
wait_timetout
Both are 28800 seconds (8 hours) by default.

You can set these options in /etc/my.cnf

If your connections are persistent (opened via mysql_pconnect) you could lower these numbers to something reasonable like 600 (10 min) or even 60 (1 min). Or, if your

app works just fine, you can leave the default. This is up to you.

You must set these as follows in my.cnf (takes effect after mysql restart):

[mysqld]
interactive_timeout=180
wait_timeout=180
If you do not want to restart mysql, then run these two commands:

SET GLOBAL interactive_timeout = 180;
SET GLOBAL wait_timeout = 180;
28800

------------------------------------------------------------------------------------
http://stackoverflow.com/questions/5213339/how-to-see-indexes-for-a-database-or-table

create index i_push_usr_idea_ondeck on push_usr_idea_ondeck
(gcm_regid (255))

create index i_complex on channel_master_view(CMV_CHANNEL_CODE,CMV_OPERATOR)

SELECT coloumn_name,coloumn_position from user_index_columns where index_name=i_complex

create index i_complex on pushnotificationuser(CMV_CHANNEL_CODE,CMV_OPERATOR)

simple index

complex index

uniqe index

bitmap index

cluster index

localhost » pushnotification_airtel_hd » pushnotificationuser

------------------------------------------------

91 server detail

119.252.216.91
-----------------------------

http://172.31.22.55/CI_Unified_test/index.php?

d=API&c=paymentUrl&m=payurl&format=json&device_id=000000000000000&&platform=j2me&msisdn=&packId=PK341&amount=75&validity=30

http://172.31.22.51/common_hd_test/index.php?

d=API&c=Authentication_HD&m=getsecureurl&format=json&device_id=000000000000000&PackID=FACOFF2&chanelID=CH400&packType=B&CustomerStatus=A&RequestDateTime=

%2704/02/201203:55:00%20PM%27&RequestID=2345&streamType=3g&UAProf=sdsa123&platform=Android&msisdn=&deviceType&ad_type=Digivive&deviceType&validity=&app_ver=&build_ver=

172.31.22.55/CI_Unified_test/index.php?

d=API&c=Authentication&m=getsecureurl&format=json&device_id=000000000000000&PackID=FACOFF2&chanelID=CH400&packType=B&CustomerStatus=A&RequestDateTime='04/02/2012

03:55:00 PM'&RequestID=2345&streamType=3g&UAProf=sdsa123&platform=Android&msisdn=&deviceType&ad_type=Digivive&deviceType&validity=&app_ver=&build_ver=

//Authentication

http://172.31.22.51/common_hd_test/index.php?d=API&c=Authentication_HD&m=Channels&format=json&device_id=000000000000000&ch_ver=-1&pkg_ver=-1&vod_ver=-1&ch_cat_ver=-

1&device_res=bb60&platform=Android&msisdn=

http://119.252.215.103/CI_Unified/index.php?d=API&c=Authentication&m=Channels&format=json&device_id=000000000000000&ch_ver=-1&pkg_ver=-1&vod_ver=-1&ch_cat_ver=-

1&device_res=bb60&platform=Android&msisdn=

/CI_Unified/index.php?d=API&c=Authentication_HD&m=Channels&format=json&device_id=000000000000000&ch_ver=-1&pkg_ver=-1&vod_ver=-1&ch_cat_ver=-

1&device_res=bb60&platform=Android&msisdn=

//vod subcat

http://119.252.215.103/CI_Unified/index.php?d=API&c=Authentication&m=Vods_subcat&format=json&device_id=000000000000000&cat_id=31&platform=j2me

http://localhost/common_hd/index.php?d=API&c=Authentication&m=Vods_subcat&format=json&device_id=000000000000000&cat_id=10&platform=j2me

//vod subcat assets

http://119.252.215.103/CI_Unified/index.php?d=API&c=Authentication&m=Vods_subcat_assets&format=json&device_id=000000000000000&cat_id=31&sub_cat_id=32&platform=j2me

//epg

http://119.252.215.103/CI_Unified/index.php?d=API&c=Authentication&m=epg&format=json&device_id=355477051393404&epg_ver=-1&platform=j2me&msisdn=

//request register

http://119.252.215.103/CI_Unified/index.php?d=API&c=Authentication&m=RequestRegister&format=json&device_id=psk&platform=Android&msisdn=9998****

//confirm request register

http://119.252.215.103/CI_Unified/index.php?d=API&c=Authentication&m=ConfirmRequestRegister&format=json&device_id=psk&platform=Android&msisdn=9898***8&otp=25***

//customer enuiey

http://119.252.215.103/CI_Unified/index.php?d=API&c=CustomerEnq&m=cus&device_id=355477051393404&&platform=j2me&msisdn=

//package list

http://119.252.215.103/CI_Unified/index.php?d=API&c=PackageList&m=pkglist&device_id=000000000000000&platform=j2me&msisdn=

//pack purchase

http://119.252.215.103/CI_Unified/index.php?d=API&c=PackPurchase&m=packpur&device_id=000000000000000&packCode=pk&validity=40&platform=j2me&msisdn=

//pack remove
355477051393404

http://119.252.215.103/CI_Unified/index.php?d=API&c=PackRemove&m=packrem&device_id=000000000000000&packCode=pk&validity=40&platform=j2me&msisdn=

//get secure URl

http://119.252.215.103/CI_Unified/index.php?

d=API&c=Authentication&m=getsecureurl&format=json&device_id=000000000000000&PackID=FACOFF2&chanelID=CH400&packType=B&CustomerStatus=A&RequestDateTime=

%2704/02/2012%2003:55:00%20PM

%27&RequestID=2345&streamType=3g&UAProf=sdsa123&platform=Android&msisdn=&deviceType&ad_type=Digivive&deviceType&validity=&app_ver=&build_ver=

//payment URl WAP

http://119.252.215.103/CI_Unified/index.php?d=API&c=paymentUrl&m=payurl&format=json&device_id=000000000000000&&platform=j2me&msisdn=&packId=PK341&amount=75&validity=30

//feedback

http://119.252.215.103/CI_Unified/index.php?d=API&c=Authentication&m=Feedback&device_id=000000000000000&platform=j2me&format=json&msisdn=9&intext=&platform=j2me

//pop up message

http://119.252.215.103/CI_Unified/index.php?d=API&c=Authentication&m=PopUpMessage&device_id=355477051393404&platform=j2me&format=json&msisdn=

//rqating

http://172.31.22.45/CI_Unified/index.php?d=API&c=AuthenticationHome&m=Rating&device_id=355477051393404&asset_code=RT342&user_rating=4&format=json

------------------------------------------------------------------------------------------------------------------

test_unified_HD

http://clientapps.nexg.tv/test_unified_HD

/data/WWW_bkup

cp -avr /var/www/html/AIRTEL_DTH/admin /var/www/html/DTH

unified_HD_old

cp -avr /var/www/html /data

cp -avr /var/www/html/unified_HD_old /data/WWW_bkup

cp -avr /var/www/html/games_15July_2013 /data/WWW_bkup

cp -avr /var/www/html/unified_aircelTest /data/WWW_bkup

172.31.22.50/test_unified_HD/webservices/feedback.php?device_id=000000000000001&intext=Hi H&msisdn=9312955804

172.31.22.55/test_unified_HD/webservices/feedback.php?device_id=000000000000001&intext=Hi H&msisdn=9312955804
=============================================

http://serverfault.com/questions/483593/apache-httpd-configuration-for-high-load
*****************************************************************
some imp url

http://demos.9lessons.info/

********************************
ERROR

apr_socket_recv: Connection reset by peer (104)

Deadlock found when trying to get lock; try restarting transaction
*******************************

SHOW VARIABLES LIKE 'key_buffer'

SHOW VARIABLES LIKE 'table_cache';

SHOW VARIABLES LIKE 'max_allowed_packet';

SET GLOBAL table_cache = 1800;

SET GLOBAL wait_timeout = 7200;

SET GLOBAL max_allowed_packet = 16777216;

SET GLOBAL query_cache_size = 52428800;

SHOW VARIABLES LIKE 'query_cache_size';
SHOW VARIABLES LIKE 'table_cache_size';

SHOW VARIABLES LIKE 'read_rnd_buffer_size';

SHOW VARIABLES LIKE 'key_buffer';

---------------------------------------------
grant replication slave on *.* to 'replication'@172.31.22.57 identified by 'admin123';

GRANT REPLICATION SLAVE ON *.* TO '172.31.22.57'@'%' IDENTIFIED BY 'admin123';

CHANGE MASTER TO MASTER_HOST='172.31.22.56', MASTER_USER='root', MASTER_PASSWORD='admin123', MASTER_LOG_FILE='mysql-bin.000003', MASTER_LOG_POS=317;
*****************************************************************************************************************************
Master slave url

http://studioshorts.com/blog/2010/03/mysql-master-slave-replication-on-centos-rhel/

http://erlycoder.com/43/mysql-master-slave-and-master-master-replication-step-by-step-configuration-instructions-

http://php.net/manual/en/ssh2.installation.php (ssh2 instalation Linux)

lower_case_table_names = 1

Mysql

http://dev.mysql.com/doc/refman/5.0/en/too-many-connections.html

http://www.linux4beginners.info/node/increase-max-connections-mysql-without-restart

***************************************************************************************************************************************

http://172.31.22.45/singleOffdeck/webservices/packpurchase.php?device_id=3C0754152573&packCode=FACOFF&validity=30

http://172.31.22.45/singleOffdeck/webservices/packpurchase.php?device_id=3C0754152573&packCode=FACOFF&validity=30

http://172.31.22.50/singleOffdeck/webservices/chanelList.php?device_id=00000000028&epg_ver=-1&chanelName=News%2024&platform=android

device_id=00000000028&msisdn=919650927324&platform=android

http://172.31.22.50/singleOffdeck/webservices/getsecureurl.php?

device_id=353942042026753&PackID=PK320&chanelID=CH305&packType=B&CustomerStatus=A&RequestID=1&UAProf=digivive&deviceType=iphone&RequestDateTime=

%2704/02/2012%2003:55:00%20PM%27

172.31.22.50/unified/webservices/authentication.php?device_id=12jw&msisdn=9555285804

http://172.31.22.45/singleOffdeck/webservices/authentication.php?device_id=abc12345&msisdn=917195000000

http://172.31.22.45/singleOffdeck/webservices/requestRegister.php?device_id=1234ew&msisdn=9312955804

http://172.31.22.45/singleOffdeck/webservices/confirmRequestRegister.php?device_id=12jw&msisdn=9555285804&otp=939224

http://172.31.22.50/unified/webservices/customerenq.php?device_id=abc123&msisdn=9312955804&ch_ver=-1&pkg_ver=-1&vod_ver=-1

update `tbl_registered_users` set `reg_operator`='OVOD' WHERE `reg_device_id`='3C0754152573'

tar vxzf ssh2-0.11.2.tar.gz

tar vxzf ssh2-0.11.2.tgz

style='bordesh Person Greets you.

Be Alert When a Selfish Person Greets you.

ulimit -n 10000

http://www.webpagetest.org/

http://172.31.22.50/unified/webservices/getsecureurl.php?

chanelID=CH389&ad_type=Digivive&device_id=12jw&PackID=PK320&packType=B&CustomerStatus=A&RequestID=1&UAProf=digivive&deviceType=andriod&RequestDateTime=

%2704/02/2012%2003:55:00%20PM%27&stream_type=2g&platform=andriod

http://clientapps.nexg.tv/unified/webservices/getsecureurl.php?

chanelID=CH389&ad_type=Digivive&device_id=000000000000000&PackID=PK320&packType=B&CustomerStatus=A&RequestID=1&UAProf=digivive&deviceType=andriod&RequestDateTime=

%2704/02/2012%2003:55:00%20PM%27&platform=Android&streamType=2g

http://clientapps.nexg.tv/unified/webservices/getsecureurl.php?

chanelID=MV303&ad_type=Digivive&device_id=000000000000000&PackID=PK320&packType=NB&CustomerStatus=A&RequestID=1&UAProf=digivive&deviceType=andriod&RequestDateTime=

%2704/02/2012%2003:55:00%20PM%27&platform=Android&streamType=2g

localhost » unified » digivive_adurl

ab -n 5000 -c 3000 http://172.31.22.50/unified_58/common_uni/index.php?d=UNI_API&c=Authentication&m=Channels&format=json&device_id=000000000000000&ch_ver=-1&pkg_ver=-

1&vod_ver=-1&ch_cat_ver=-1&device_res=bb60&platform=Android&msisdn=

ab -n 1000 -c 5 http://172.31.22.50/unified_58/webservices/authentication.php?device_id=000000000000000

ab -n 1000 -c 5 http://172.31.22.50/test.php

ab -n 5000 -c 5 http://172.31.22.50/test.php

ab -n 10000 -c 500 http://172.31.22.50/unified/webservices/authentication.php?msisdn=9930093897&device_id=352985054488636

ab -n 10000 -c 500 http://172.31.22.54/unified_memcache/webservices/authentication.php?device_id=355884051263877
ab -n 10000 -c 500 http://172.31.22.55/unified/webservices/authentication.php?device_id=355884051263877

ab -n 10000 -c 500 http://172.31.22.50/unified/webservices/epglist.php?device_id=00000000028

http://172.31.22.50/unified/webservices/epglist.php?device_id=00000000028

ab -n 10000 -c 500 http://172.31.22.55/unified/webservices/authentication.php?device_id=355884051263877&ch_ver=300&pkg_ver=100&vod_ver=100

ab -n 10000 -c 500 http://172.31.22.50/unified/webservices/epglist.php?device_id=355884051263877

http://172.31.22.55/unified/webservices/epglist.php?device_id=355884051263877&deviceRes=bb20

ulimit -n 10000

http://www.webpagetest.org/

ab -n 10000 -c 500 http://172.31.22.51/unified/webservices/testheader.php

ab -n 800 -c 100 http://172.31.22.51/unified/webservices/authentication.php?device_id=355884051263877

ab -n 3000 -c 1000 http://172.31.22.50/unified/webservices/authentication.php?device_id=353743050306834

172.31.22.50/airtel/webservices/authentication.php?ch_ver=-1&pkg_ver=-1&vod_ver=-1

172.31.22.50/airtel/webservices/chanelList.php?chanelName=News 24

http://172.31.22.50/airtel/webservices/buildver.php?build_ver=1&build_type=android

http://172.31.22.50/airtel/webservices/customerenq.php

172.31.22.50/airtel/webservices/packpurchase.php?packCode=PK309&validity=30

172.31.22.50/airtel/webservices/packpurchase.php?packCode=PK309&validity=30&ip_add=27.56.0.1&msisdn=9999999999&operatorId=AT_ON

ip_add=27.56.0.1&msisdn=9999999999&operatorId=AT_ON&ch_ver=-1&pkg_ver=-1&vod_ver=-validity=30&packCode=PK320

http://172.31.22.50/airtel/webservices/packremove.php?packCode=PK309&validity=30

172.31.22.50/airtel/webservices/epglist.php?epg_ver=-1

http://172.31.22.50/airtel/webservices/packagelist.php

172.31.22.50/airtel/webservices/message.php

http://172.31.22.50/airtel/webservices/feedback.php?msisdn=1212&intext=asas

http://172.31.22.50/airtel/webservices/getsecureurl.php?

ip_add=27.56.0.1&msisdn=9999999999&PackID=PK321&chanelID=CH335&packType=B&CustomerStatus=A&RequestDateTime=11/22/2012%2001:44:56%20PM&RequestID=digivive1353572096874.3

3&streamType=&UAProf=digivive123&deviceType=iphone

http://172.31.22.55/airtel/webservices/packpurchase.php?ip_add=27.56.0.1&msisdn=9999999999&operatorId=AT_ON&build_type=android

----------------------------------------------------------------------

ETISLAT_19NOVEMBER2012

http://172.31.22.40/etisalat_test/webservices/buildver.php?ip_add=203.189.184.0&msisdn=123456&build_type=android

http://172.31.22.40/etisalat_test/webservices/authentication.php?ip_add=203.189.184.0&msisdn=123131123&packCode=LC_NWS&validity=30

http://172.31.22.40/etisalat_test/webservices/customerenq.php?ip_add=203.189.184.0&msisdn=123131123&packCode=LC_NWS&validity=30

http://172.31.22.40/etisalat_test/webservices/epglist.php?ip_add=203.189.184.0&msisdn=123131123&packCode=LC_NWS&validity=30

http://172.31.22.40/etisalat_test/webservices/getsecureurl.php

http://172.31.22.40/etisalat_test/webservices/packremove.php?ip_add=203.189.184.0&msisdn=123131123&packCode=FACOFF&validity=30

----------------------------------------------------------

22 november-2012

http://172.31.22.55/airtel/webservices/buildver.php?ip_add=27.56.0.0&msisdn=9999999999&operatorId=AT_ON&ch_ver=-1&pkg_ver=-1&vod_ver=-1

http://172.31.22.55/airtel/webservices/chanelList.php?ip_add=27.56.0.0&msisdn=9999999999&operatorId=AT_ON&ch_ver=-1&pkg_ver=-1&vod_ver=-1

http://172.31.22.55/airtel/webservices/customerenq.php?ip_add=27.56.0.0&msisdn=9999999999&operatorId=AT_ON&ch_ver=-1&pkg_ver=-1&vod_ver=-1

172.31.22.56/unified/webservices/customerenq.php?device_id=1234ew&msisdn=9312955804&operatorId=AT_ON&ch_ver=-1&pkg_ver=-1&vod_ver=-1

http://172.31.22.55/airtel/webservices/epglist.php?ip_add=27.56.0.0&msisdn=9999999999&operatorId=AT_ON&ch_ver=-1&pkg_ver=-1&vod_ver=-1

epglist.php?ip_add=27.56.0.0&msisdn=9999999999&operatorId=AT_ON&ch_ver=-1&pkg_ver=-1&vod_ver=-1

http://172.31.22.55/airtel/webservices/getsecureurl.php?ip_add=27.56.0.1&msisdn=9999999999&operatorId=AT_ON&ch_ver=-1&pkg_ver=-1&vod_ver=-1&validity=30&packCode=PK320

http://172.31.22.55/airtel/webservices/packagelist.php?ip_add=27.56.0.1&msisdn=9999999999&operatorId=AT_ON&ch_ver=-1&pkg_ver=-1&vod_ver=-91&validity=30&packCode=PK320

http://172.31.22.55/airtel/webservices/authentication.php?ip_add=27.56.0.1&msisdn=9999999999&operatorId=AT_ON&ch_ver=-1&pkg_ver=-1&vod_ver=-validity=30&packCode=PK320

http://172.31.22.55/airtel/webservices/packremove.php?ip_add=27.56.0.1&msisdn=9999999999&operatorId=AT_ON&ch_ver=-1&pkg_ver=-1&vod_ver=-91&validity=30&packCode=PK320

http://172.31.22.54/airtel/webservices/getsecureurl.php?

ip_add=27.56.0.1&msisdn=9999999999&PackID=PK321&chanelID=CH335&packType=B&CustomerStatus=A&RequestDateTime=11/22/2012%2001:44:56%20PM&RequestID=digivive1353572096874.3

3&streamType=&UAProf=digivive123&deviceType=iphone

http://172.31.22.55/airtel/webservices/buildver.php?build_ver=1&build_type=blackberry

http://slevy1.wordpress.com/2010/09/07/xml-to-json-with-php/

http://www.sitepoint.com/forums/showthread.php?754499-Create-JSON-with-PHP-HELP!

--------------------------------------------------------------------------

INDB0000022
---------------------------------------------------------------------------------------------------------------------------------------------------------------

Singleoffdeck

http://172.31.22.45/singleOffdeck/webservices/authentication.php?ch_ver=-1&pkg_ver=-1&device_id=0000000000000

http://172.31.22.45/singleOffdeck/webservices/buildver.php?build_ver=-1&build_type=android

http://172.31.22.45/singleOffdeck/webservices/feedback.php?msisdn=1212&intext=asas&device_id=0000000000000

rtsp://vodalive.nexg.tv/voda/cnnibn_3G.sdp?

o=OVOD&m=abc12345&u=Client&src=Client&p=PK320&StreamID=2087063&wmsAuthSign=20121214131853:b179bb860778aa6996bbe0a4ff2fe418301f03ab&app=cyb_vcon

rtsp://vodalive.nexg.tv/voda/cnnibn_3G.sdp?

o=OVOD&m=abc12345&u=Client&src=Client&p=PK320&StreamID=2087068&wmsAuthSign=20121214131955:ecd5175b1afb7def024516553f61f635200c8cf1&app=cyb_vcon

A7806

SELECT *
FROM `view_vod_master`
WHERE `VVM_DES` LIKE CONVERT( _utf8 '%Yagopavit suraksha%'
USING latin1 )

epglist.php?device_id=1234ew&msisdn=9312955804&operatorId=AT_ON&ch_ver=-1&pkg_ver=-1&vod_ver=-1

http://172.31.22.45/unified/webservices/customerenq.php?device_id=1234ew&msisdn=9312955804&operatorId=AT_ON&ch_ver=-1&pkg_ver=-1&vod_ver=-1

http://172.31.22.45/unified/webservices/getsecureurl.php?

device_id=1234ew&msisdn=9312955804&PackID=PK321&chanelID=CH335&packType=B&CustomerStatus=A&RequestDateTime=11/22/2012%2001:44:56%20PM&RequestID=digivive1353572096874.3

3&streamType=&UAProf=digivive123&deviceType=iphone

getsecureurl.php?

device_id=000000000000000&msisdn=9312955804&PackID=premium_150&chanelID=CH335&packType=B&CustomerStatus=A&RequestDateTime=5/1/2013%2001:44:56%20PM&RequestID=digivive13

53572096874.33&streamType=&UAProf=digivive123&deviceType=andriod&platform=andriod

http://172.31.22.45/unified/webservices/getsecureurl.php?

device_id=1234ew&msisdn=9312955804&PackID=PK321&chanelID=CH345&packType=B&CustomerStatus=A&RequestDateTime=11/22/2012%2001:44:56%20PM&RequestID=digivive1353572096874.3

3&streamType=2g&UAProf=digivive123&deviceType=window

http://172.31.22.50/unified/webservices/getsecureurl.php?

chanelID=CH303&device_id=352700050349470&msisdn=8956586375&PackID=PK321&&packType=B&CustomerStatus=A&RequestDateTime=06/21/2013%2001:44:56%20PM&RequestID=digivive13535

72096874.33&streamType=2g&UAProf=digivive123&deviceType=android

clientapps.nexg.tv/unified_HD/webservices/getsecureurl.php?

chanelID=CH312&device_id=352700050349470&msisdn=8956586375&&packType=B&CustomerStatus=A&RequestDateTime=06/21/2013 01:44:56

PM&RequestID=digivive1353572096874.33&streamType=2g&UAProf=digivive123&platform=android&packId=premium_150&item_id=CH312

http://172.31.22.45/singleOffdeck/webservices/authentication.php?ch_ver=-1&pkg_ver=-1&device_id=0000000000000

http://172.31.22.45/singleOffdeck/webservices/buildver.php?build_ver=-1&build_type=android

http://172.31.22.45/singleOffdeck/webservices/feedback.php?msisdn=1212&intext=asas&device_id=0000000000000

http://172.31.22.45/unified/webservices/packagelist.php?device_id=0000000000&msisdn=989130786&operatorId=AT_ON&ch_ver=-1&pkg_ver=-1&vod_ver=-

91&validity=30&packCode=PK320

http://172.31.22.45/unified/webservices/packpurchase.php?device_id=1234ew&&msisdn=9312955804&packCode=FACOFF2&validity=30

172.31.22.57/unified/webservices/packpurchase.php?device_id=0000000000&&msisdn=9891307868&packCode=FACOFF2&validity=30

http://119.252.215.211/unified/webservices/confirmRequestRegister.php?device_id=0000000000&&msisdn=9891307868&otp=704762

http://119.252.215.103/unified/webservices/requestRegister.php?device_id=0000000000&msisdn=9312955804

http://172.31.22.56/unified/webservices/message.php?device_id=0000000000

http://172.31.22.56/unified/webservices/confirmRequestRegister.php?device_id=abc1245&&msisdn=9873214648&otp=70476

http://172.31.22.50/unified/webservices/getsecureurl.php?chanelID=CH389&ad_type=Digivive&device_id=12jw

bndpm1600b

BNDPM1600B

9223174677
60849014

UPDATE mysql.user SET Password=PASSWORD('root123') WHERE User='root';

UPDATE mysql.user SET Password=PASSWORD('root123') WHERE User='root' AND Host='localhost';

UPDATE mysql.user SET Password=PASSWORD('root123') WHERE User='root' AND Host='%.example.org';

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

GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' WITH GRANT OPTION;

CHANGE MASTER TO MASTER_HOST='172.31.22.58', MASTER_USER='neo', MASTER_PASSWORD='admin123', MASTER_LOG_FILE='mysql-bin.000002', MASTER_LOG_POS=52609;

localhost » test_unified » view_tbl_register_users

GRANT SELECT ON test_unified.view_tbl_register_users TO 'pradeep'@'172.31.22.59';

CREATE USER 'view'@'172.31.22.59' IDENTIFIED BY 'admin123';

GRANT SHOW VIEW
ON test_unified.view_tbl_register_users TO 'view'@'172.31.22.59'
IDENTIFIED BY 'admin123'

GRANT SELECT ON test_unified.view_tbl_register_users TO 'view'@'172.31.22.59'
IDENTIFIED BY 'admin123'

update mysql.user set Password=PASSWORD('root123') where user='root' and Host='172.31.22.59'

select Host,Password,User from user;

drop USER 'root'@'172.31.22.53' where Host='172.31.22.53'

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

GRANT ALL PRIVILEGES ON *.* TO 'neo'@'172.31.22.60' WITH GRANT OPTION;

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

GRANT ALL PRIVILEGES ON *.* TO 'neo'@'172.31.22.53' WITH GRANT OPTION;

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

GRANT ALL PRIVILEGES ON *.* TO 'neo'@'172.31.22.52' WITH GRANT OPTION;

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

GRANT ALL PRIVILEGES ON *.* TO 'root'@'172.31.22.52' WITH GRANT OPTION;

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

GRANT ALL PRIVILEGES ON *.* TO 'neo'@'172.31.22.52' WITH GRANT OPTION;

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

GRANT ALL PRIVILEGES ON *.* TO 'root'@'172.31.22.159' WITH GRANT OPTION;

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

GRANT ALL PRIVILEGES ON *.* TO 'root'@'172.31.22.158' WITH GRANT OPTION;

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

GRANT ALL PRIVILEGES ON *.* TO 'root'@'172.31.22.50' WITH GRANT OPTION;

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

GRANT ALL PRIVILEGES ON *.* TO 'root'@'172.31.22.55' WITH GRANT OPTION;

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

GRANT ALL PRIVILEGES ON *.* TO 'root'@'119.252.216.91' WITH GRANT OPTION;

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

GRANT ALL PRIVILEGES ON *.* TO 'root'@'172.31.22.53' WITH GRANT OPTION;

CREATE USER 'root'@'172.31.22.59' IDENTIFIED BY 'admin123';

GRANT ALL PRIVILEGES ON *.* TO 'root'@'172.31.22.59' WITH GRANT OPTION;

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

GRANT ALL PRIVILEGES ON *.* TO 'neo'@'119.252.216.91' WITH GRANT OPTION;

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

GRANT ALL PRIVILEGES ON *.* TO 'neo'@'172.31.22.60' WITH GRANT OPTION;

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

GRANT ALL PRIVILEGES ON *.* TO 'neo'@'172.31.22.58' WITH GRANT OPTION;

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

GRANT ALL PRIVILEGES ON *.* TO 'neo'@'172.31.22.59' WITH GRANT OPTION;

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

GRANT ALL PRIVILEGES ON *.* TO 'neo'@'172.31.22.55' WITH GRANT OPTION;

CREATE USER 'root'@'172.31.22.50' IDENTIFIED BY 'root123'

GRANT ALL PRIVILEGES ON *.* TO 'root'@'172.31.22.50' WITH GRANT OPTION;

CREATE USER 'root'@'172.31.22.51' IDENTIFIED BY 'root123'

GRANT ALL PRIVILEGES ON *.* TO 'root'@'172.31.22.51' WITH GRANT OPTION;

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

GRANT ALL PRIVILEGES ON *.* TO 'root'@'172.31.22.54' WITH GRANT OPTION;

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

GRANT ALL PRIVILEGES ON *.* TO 'root'@'172.31.22.55' WITH GRANT OPTION;

CREATE USER 'pradeep'@'172.31.22.58' IDENTIFIED BY 'admin123';

CREATE USER 'manoj'@'172.31.22.58' IDENTIFIED BY 'admin123';

GRANT ALL PRIVILEGES ON *.* TO 'manoj'@'172.31.22.58' WITH GRANT OPTION;

GRANT SELECT ON unified.* TO 'pradeep'@'172.31.22.58' WITH GRANT OPTION;

drop USER 'neo'@'172.31.22.58' where Host='172.31.22.58'

mysql> CREATE USER 'neo'@'172.31.22.58' IDENTIFIED BY 'admin123';

mysql> GRANT ALL PRIVILEGES ON *.* TO 'neo'@'172.31.22.58' WITH GRANT OPTION;
->
mysql> CREATE USER 'monty'@'%' IDENTIFIED BY 'some_pass';
mysql> GRANT ALL PRIVILEGES ON *.* TO 'monty'@'%'
-> WITH GRANT OPTION;

down vote accepted

Possibly a security precaution. You could try adding a new administrator account:

mysql> CATE USER 'monty'@'localhost' IDENTIFIED BY 'some_pass';
mysql> GRANT ALL PRIVILEGES ON *.* TO 'monty'@'localhost'
-> WITH GRANT OPTION;
mysql> CREATE USER 'monty'@'%' IDENTIFIED BY 'some_pass';
mysql> GRANT ALL PRIVILEGES ON *.* TO 'monty'@'%'
-> WITH GRANT OPTION;

SELECT user_id, session_id,
STATUS , time_to_sec( timediff( now( ) , last_access ) ) AS duration
FROM session_log
WHERE remote_ip = '119.252.211.66'
AND session_id = (
SELECT max( session_id )
FROM session_log
WHERE remote_ip = '119.252.211.66' )

http://www.linuxforu.com/2009/01/server-side-sessions/

http://shiflett.org/articles/storing-sessions-in-a-database

119.252.215.211

CREATE USER root WITH PASSWORD 'root';

GRANT ALL PRIVILEGES ON DATABASE vintouch_dev to root;

SELECT * FROM information_schema.columns WHERE table_name = 'tableName' AND table_schema = 'vintouch_dev';

172.31.22.50/unified/webservices/confirmRequestRegister.php?device_id==1234ew&msisdn=9312955804&otp=939224

http://172.31.22.50/unified/webservices/requestRegister.php?device_id==1234ew&msisdn=9312955804

// ab -n tootalcount(100) -c no of concurrnet hits url name

*****************************************************

host 119.252.215.106
Name digivive2/digivive@
cyberlink/Cyber%$#@!

SBM Number:-

28756587
28757908

*********************************************
================================================================================================================
675559446

ab -n 1000 -c 5 http://172.31.22.50/test.php

ab -n 5000 -c 5 http://172.31.22.50/test.php

ab -n 10000 -c 500 http://172.31.22.50/unified/webservices/authentication.php?device_id=00000000028

ulimit -n 10000

http://www.webpagetest.org/

172.31.22.56

172.31.22.57

http://mysqltuner.com/

http://serverfault.com/questions/290358/improve-server-performance-by-configuring-mysql

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

District Institute of Educational and Training

http://upbasiceduboard.gov.in/

http://uptet.co.in/72825-cut-off/

http://www.apdsc2012.in/p/up-basic-education-board-primary.html

UPTET.CO.IN

119.252.215.211/singleOffdeck_iphone/

16038819

29/05/1981

pradeep

*%deep#

************************************************master-master configure start*******************************************************
Masetr-master configuration

iptables -A INPUT -p tcp -s 172.31.22.56 --sport 3306 -d 172.31.22.57 --dport 3306 -m state --state NEW,ESTABLISHED -j ACCEPT

iptables -A OUTPUT -p tcp -s 172.31.22.57 --sport 3306 -d 172.31.22.56 --dport 3306 -m state --state ESTABLISHED -j ACCEPT

grant replication slave on *.* to 'root'@172.31.22.57 identified by 'admin123';

CHANGE MASTER TO MASTER_HOST='172.31.22.56', MASTER_USER='root', MASTER_PASSWORD='admin123', MASTER_PORT=3306,MASTER_LOG_FILE='mysqld-bin.000003',

MASTER_LOG_POS=23594, MASTER_CONNECT_RETRY=10;

---------------------------

grant replication slave on *.* to 'root'@172.31.22.56 identified by 'admin123'

CHANGE MASTER TO MASTER_HOST='172.31.22.57', MASTER_USER='root', MASTER_PASSWORD='admin123', MASTER_PORT=3306,MASTER_LOG_FILE='mysql-bin.000005',

MASTER_LOG_POS=98,MASTER_CONNECT_RETRY=10;

**************************************************master-master configure end*******************************************************

GRANT ALL PRIVILEGES ON *.* TO 'root'@'172.31.22.57' IDENTIFIED BY PASSWORD '171b786d2574fdba' WITH GRANT OPTION;

localhost » singleoffdeck

http://119.252.215.103/unified_HD/webservices/authentication.php?device_id=352272059344027

********************************************************************************************************

rename table channel_detail_view To CHANNEL_DETAIL_VIEW;

rename table channel_master_view To CHANNEL_MASTER_VIEW ;

rename table language_master To LANGUAGE_MASTER ;

rename table VIEW_LANGUAGE_MASTER To LANGUAGE_MASTER ;

rename table home_category To HOME_CATEGORY;

rename table home_category_assets To HOME_CATEGORY_ASSETS;

rename table operator_master_view To OPERATOR_MASTER_VIEW ;

rename table package_channel_map_view To PACKAGE_CHANNEL_MAP_VIEW ;

rename table package_master_view To PACKAGE_MASTER_VIEW ;

rename table program_details To Program_Details ;

rename table view_category_master To VIEW_CATEGORY_MASTER ;

rename table view_subcat_master To VIEW_SUBCAT_MASTER ;

rename table view_theme_master To VIEW_THEME_MASTER ;

rename table view_vod_master To VIEW_VOD_MASTER ;

rename table channel_rtsp_details_view To CHANNEL_RTSP_DETAILS_VIEW;

*****************************************************************

http://stackoverflow.com/questions/6389097/problem-sending-emails-from-a-php-app-linux-server

http://localhost/unified_HD/unified_HD/webservices/buildver.php?msisdn=919989944518&device_id=354098053399230&build_ver=-10&build_type=Android

172.31.22.45/unified_HD_json/webservices/authentication.php?msisdn=919989944518&device_id=354098053399230&ch_ver=-1&pkg_ver=-1&vod_ver=-1

http://172.31.22.45/unified_HD_json/webservices/requestRegister.php?device_id==1234ew&msisdn=9312955804

http://172.31.22.45/unified_HD_json/webservices/confirmRequestRegister.php?device_id==1234ew&msisdn=9312955804&otp=1232

http://www.cyberciti.biz/faq/what-is-mysql-binary-log/

172.31.22.45/games/Nexg Games WAP/index.php?option=play&gameId=1&device_id=acvd123&msisdn=919717000000

http://172.31.22.45/games/android_files/wab_android_all_multilang.apk

172.31.22.50/games/main.php?msisdn=918826009561&option=play&gameId=1&device_id=2

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

SELECT *
FROM `all_users` where msisdn!=''

Not empty 158

Total users 247

download users:- 137

select count(*),msisdn from user_detail group by msisdn

select count(distinct(msisdn)) from user_detail

select sum(count(*)),msisdn from user_detail group by msisdn

select count(*),msisdn from user_detail group by msisdn

select count(*) as cnt,msisdn from user_detail group by msisdn

-----------------------------

set mysqlsock path in mysql

1. Wrong path for the mysql.sock
mysql.sock is the instance of the mysql, so first you have to find where does it place at.
You may find it at "/tmp/mysql.sock" or "/var/mysql/mysql.sock".

Go to your php.ini and make sure the value for "pdo_mysql.default_socket", "mysql.default_socket", "mysqli.default_socket" is the right path.

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

GRANT ALL PRIVILEGES ON *.* TO 'neo'@'172.31.22.50' WITH GRANT OPTION;

GRANT REPLICATION SLAVE ON *.* TO 'root'@'172.31.22.56' IDENTIFIED BY 'admin123';

GRANT ALL PRIVILEGES ON *.* TO 'root'@'172.31.22.54' WITH GRANT OPTION;

GRANT REPLICATION SLAVE ON *.* TO 'root'@'172.31.22.54' IDENTIFIED BY 'admin123';
GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' IDENTIFIED BY 'admin123';

GRANT ALL PRIVILEGES ON *.* TO 'root'@'172.31.22.54' IDENTIFIED BY 'admin123';

GRANT ALL PRIVILEGES ON *.* TO 'root'@'172.31.22.54' IDENTIFIED BY 'admin123';

GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'admin123';

GRANT ALL PRIVILEGES ON *.* TO 'root'@'172.31.22.53' IDENTIFIED BY 'admin123';

DROP USER 'root'@'localhost';

DROP USER 'root'@'172.31.22.58';

drop USER 'root'@'localhost' where Host='localhost'

drop USER 'root'@'172.31.22.54' where Host='172.31.22.54'

drop USER 'root'@'172.31.22.55' where Host='172.31.22.55'

drop USER 'root'@'172.31.22.50' where Host='172.31.22.50'

drop USER 'root'@'172.31.22.51' where Host='172.31.22.51'

CREATE USER 'root'@'localhost' IDENTIFIED BY 'admin123';

GRANT SELECT, INSERT, DELETE ON database TO 'root'@'localhost' IDENTIFIED BY 'admin123';

GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' WITH GRANT OPTION;

CREATE USER 'root'@'%' IDENTIFIED BY 'admin123';

drop USER 'root'@'localhost' IDENTIFIED BY 'admin123';

drop USER 'root'@'%' where Password='admin123'

CREATE USER 'root'@'%' IDENTIFIED BY 'Cyberlinks';

CHANGE MASTER TO MASTER_HOST='172.31.22.53', MASTER_USER='root', MASTER_PASSWORD='admin123', MASTER_LOG_FILE='mysql-bin.000005', MASTER_LOG_POS=66883888;

CHANGE MASTER TO MASTER_HOST='172.31.22.53', MASTER_USER='root', MASTER_PASSWORD='admin123', MASTER_LOG_FILE='mysql-bin.000001', MASTER_LOG_POS=23713;

CHANGE MASTER TO MASTER_HOST='172.31.22.53', MASTER_USER='root', MASTER_PASSWORD='admin123', MASTER_LOG_FILE='mysql-bin.000001', MASTER_LOG_POS=292367;

CHANGE MASTER TO MASTER_HOST='172.31.22.53', MASTER_USER='root', MASTER_PASSWORD='admin123', MASTER_LOG_FILE='mysql-bin.000034', MASTER_LOG_POS=601584658;

CHANGE MASTER TO MASTER_HOST='172.31.22.58', MASTER_USER='root', MASTER_PASSWORD='admin123', MASTER_LOG_FILE='mysql-bin.000034', MASTER_LOG_POS=601584658;

9716566599
912266796200
=============================================================================================================================================================
52server

0 0 * * * /usr/syncservice/src/catalog.run.sh
0 0 * * * /usr/syncservice/src/catalog_aircel.run.sh
0 0 * * * /usr/syncservice/src/epgsync.run.sh
0 0 * * * /usr/syncservice/src/epgsync_aircel.run.sh
0 0 * * * /usr/syncservice/src/epgsync_hd.run.sh
0 0 * * * /root/MySQLdump.sh
0 0 * * * /usr/syncservice/src/catalog_airtel.run.sh
0 0 * * * /usr/syncservice/src/epgsync_airtel_hd.run.sh

0 4 * * * /home/MySQLdump.sh

172.31.22.53 root 171b786d2574fdba

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

24sepppp

354098053399230

http://172.31.22.55/test_unified_HD/webservices/feedback.php?device_id=000000000000001&intext=Hi%20H&msisdn=9312955804

172.31.22.55/test_unified_HD/webservices/paymentUrl.php?device_id=354098053399230&validity=30&msisdn=919989944518&packCode=PremiumPack(not in use)

http://172.31.22.55/test_unified_HD/webservices/paymentUrl.php?device_id=354098053399230&validity=30&msisdn=919989944518&packCode=PremiumPack

172.31.22.55/test_unified_HD/webservices/packremove.php?device_id=354098053399230&validity=30&msisdn=919989944518&packCode=PremiumPack

http://172.31.22.55/test_unified/webservices/requestRegister.php?device_id=000000000000001&msisdn=9312955804

http://172.31.22.55/test_unified/webservices/confirmRequestRegister.php?device_id=000000000000001&msisdn=9312955804&otp=163547

-------------------------------------------------------------------------------------------------

select distinct f.feedback_id,f.msisdn,f.platform,r.reg_operator,f.text,f.created_date from feedback f left join tbl_registered_users r on f.msisdn=r.reg_msisdn order

by created_date DESC

--------------------------------------
.HOME_CATEGORY_ASSETS

rename table home_category To home_category;

rename table Structurehome_category_assets To HOME_CATEGORY_ASSETS;

---------------------------------------------------------------------------------------------------------------

53 server

ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)

UPDATE user SET Password=admin123 where USER='root';

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

unified_hd

chanelURL CH533 duplicate

ab -n 50000 -c 100 http://www.thelinuxlink.net/index.php

ab -n 50000 -c 100 172.31.22.50/unified_HD/webservices/authentication.php?device_id=000000000000000

ab -n 50000 -c 100 172.31.22.51/unified_HD/webservices/authentication.php?device_id=000000000000000

ab -n 50000 -c 100 172.31.22.54/unified_HD/webservices/authentication.php?device_id=000000000000000

ab -n 50000 -c 100 172.31.22.55/unified_HD/webservices/authentication.php?device_id=000000000000000

===========================================================================================================================================
Simple
Index for unified HD

create index pushnotificationuser_index on pushnotificationuser(gcm_regid,name)

create index channel_detail_index on CHANNEL_DETAIL_VIEW(CMV_CHANNEL_CODE,CMV_OPERATOR)

create index i_complex_CHANNEL_MASTER_VIEW_HD on CHANNEL_MASTER_VIEW(CMV_CHANNEL_CODE,CMV_OPERATOR)

create index i_complex_PACKAGE_CHANNEL_MAP_VIEW_HD on PACKAGE_CHANNEL_MAP_VIEW (PCMV_PACK_CODE,PCMV_CHANNEL_CODE,PCMV_OPERATOR)

create index i_simple_PACKAGE_MASTER_VIEW_HD on PACKAGE_MASTER_VIEW(PMV_BDD_CODE)

create index i_complex_VIEW_VOD_MASTER_HD on VIEW_VOD_MASTER(VVM_BD_CODE,VVM_OPERATOR)

create index i_simple_channelurls_HD on channelurls(CHANNEL_CODE)

create index i_complex_view_vod_detail_HD on view_vod_detail(VVM_BD_CODE,VVM_OPERATOR)

create index i_complex_tbl_registered_users_HD on tbl_registered_users(reg_device_id,reg_msisdn,reg_operator)

create index i_complex_CHANNEL_DETAIL_VIEW_HD on CHANNEL_DETAIL_VIEW(CMV_CHANNEL_CODE,CMV_OPERATOR)

drop index i_simple_PACKAGE_MASTER_VIEW_HD on PACKAGE_MASTER_VIEW

drop index i_complex_CHANNEL_DETAIL_VIEW_HD on CHANNEL_DETAIL_VIEW

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

642 total, Query took 1.6326 sec)

select * from VIEW_VOD_MASTER AS VVM INNER JOIN view_vod_detail AS VVD ON VVM.VVM_BD_CODE = VVD.VVM_BD_CODE AND VVM.VVM_OPERATOR = VVD.VVM_OPERATOR where

VVM.VVM_ASSET_STATUS = 'A' AND VVM.VVM_CAT_ID='10' AND VVM.VVM_OPERATOR='CM_OF' ORDER BY VVD.VVD_DISPLAY_ORDER DESC

-------------------------------------------------------------------------------------------------------------------------------------------
ALTER TABLE `CHANNEL_MASTER_VIEW` DROP INDEX `CHANNEL_MASTER_I` ,
ADD INDEX `CHANNEL_MASTER_I` ( `CMV_CHANNEL_CODE` , `CMV_OPERATOR` , `CMV_EPGNO` )

create index Program_Details_I on Program_Details(Service_Id,Service_Name)

create index CHANNEL_MASTER_I on CHANNEL_MASTER_VIEW(CMV_CHANNEL_CODE,CMV_OPERATOR)

create index channel_detail_index_I on CHANNEL_DETAIL_VIEW(CMV_CHANNEL_CODE,CMV_OPERATOR)

create index vod_detail_I on view_vod_detail(VVM_BD_CODE,VVM_OPERATOR)

create index VOD_MASTER_I on VIEW_VOD_MASTER(VVM_BD_CODE,VVM_OPERATOR,VVM_CAT_ID,VVM_SUB_CAT_ID)

create index PACKAGE_CHANNEL_MAP_I on PACKAGE_CHANNEL_MAP_VIEW (PCMV_PACK_CODE,PCMV_CHANNEL_CODE,PCMV_OPERATOR)

create index PACKAGE_MASTER_VIEW_i_simple on PACKAGE_MASTER_VIEW(PMV_BDD_CODE,PMV_OPERATOR)

create index channelurls_simple on channelurls(CHANNEL_CODE)

create index CHANNEL_RTSP_DETAILS_VIEW_I on CHANNEL_RTSP_DETAILS_VIEW(CRDV_BD_CODE)

create index tbl_registered_users_I on tbl_registered_users(reg_device_id,reg_msisdn)

create index customer_detail_iphone_I on customer_detail_iphone(customer_device_id)

create index tbl_opt_circle_I on tbl_opt_circle(opt_series_start,opt_series_end)

create index VIEW_CATEGORY_MASTER_I on VIEW_CATEGORY_MASTER(VCM_GENRE_ID,VCM_OPERATOR_ID)

create index view_category_detail_I on view_category_detail(vcd_id,VCD_OPERATOR_ID)

create index VIEW_SUBCAT_MASTER_I on VIEW_SUBCAT_MASTER(VSM_SUBCAT_ID,VSM_CATEGORY_ID,VSM_OPERATOR_ID)

create index view_subcat_detail_I on view_subcat_detail(vsd_id,VSM_OPERATOR_ID)

create index ip_check_I on ip_check(PM_START_IP,PM_END_IP,PM_OPERATOR_ID)

create index customer_detail_I on customer_detail(customer_msisdn)

create index ip_check_I on ip_check(PM_IP_ADDRESS,PM_OPERATOR_ID)

-----------------------------------------------------------------------------------

CREATE INDEX cmv_index ON CHANNEL_MASTER_VIEW (CMV_CHANNEL_CODE(5));

create index cdv_index on CHANNEL_DETAIL_VIEW (CMV_CHANNEL_CODE,CMV_OPERATOR);

CREATE INDEX pcmv_index ON PACKAGE_CHANNEL_MAP_VIEW(PCMV_PACK_CODE(5));

CREATE INDEX pmv_index3 ON PACKAGE_MASTER_VIEW (PMV_BDD_CODE(5));

CREATE INDEX vcm_index ON VIEW_CATEGORY_MASTER (VCM_GENRE_ID(5));

CREATE INDEX vvm_index ON VIEW_VOD_MASTER (VVM_BD_CODE(5));

CREATE INDEX vsm_index ON VIEW_SUBCAT_MASTER (VSM_SUBCAT_ID(5));

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

insert into view_vod_detail(`VVM_BD_CODE`,`VVM_OPERATOR`,`vvd_icon`,`vvd_preview_image`,`VVD_DISPLAY_ORDER`)

SELECT `VVM_BD_CODE`,'ID_OF',`vvd_icon`,`vvd_preview_image`,`VVD_DISPLAY_ORDER` FROM `view_vod_detail` WHERE `VVM_OPERATOR`='CM_OF'

--------------------------------------------------------------------------------------

CREATE TABLE `airtel_hd`.`VIEW_VOD_SUBCATEGORY_L3` (
`SUB_CAT_ID_L3` VARCHAR( 100 ) NOT NULL ,
`SUB_CAT_NAME_L3` VARCHAR( 200 ) NOT NULL ,
`SUB_CAT_ID` VARCHAR( 100 ) NOT NULL ,
`STATUS` VARCHAR( 4 ) NOT NULL ,
`MODIFICATION_DATE` DATE NULL ,
`CREATION_DATE` DATE NULL ,
`OPERATOR_ID` VARCHAR( 20 ) NULL
) ENGINE = MYISAM

------------------------------------------------------------------------------------------------------------------

insert into view_vod_detail(`VVM_BD_CODE`,`VVM_OPERATOR`,`vvd_icon`,`vvd_preview_image`,`VVD_DISPLAY_ORDER`)

SELECT `VVM_BD_CODE`,'ID_OF',`vvd_icon`,`vvd_preview_image`,`VVD_DISPLAY_ORDER` FROM `view_vod_detail` WHERE `VVM_OPERATOR`='CM_OF'

--------------------------------------------------------------------------------------------------------------------------------------

create table view_vod_subcategory_detail_l3

CREATE TABLE `airtel_hd`.`vod_subcategory_detail_l3` (
`vsd_id_l3` INT NOT NULL ,
`VSM_OPERATOR_ID` VARCHAR( 256 ) NOT NULL ,
`VSM_CATEGORY_ID` VARCHAR( 70 ) NOT NULL ,
`VSM_SUBCAT_ID` VARCHAR( 70 ) NOT NULL ,
`VSM_SUBCAT_ID_l3` VARCHAR( 70 ) NOT NULL ,
`vsm_icon` VARCHAR( 256 ) NOT NULL ,
`display_order` INT( 5 ) NOT NULL
) ENGINE = MYISAM DEFAULT CHARSET=latin1

INSERT INTO `vod_subcategory_detail_l3` (`vsd_id_l3`, `VSM_OPERATOR_ID`, `VSM_CATEGORY_ID`, `VSM_SUBCAT_ID`, `VSM_SUBCAT_ID_l3`, `vsm_icon`, `display_order`) VALUES
(1, 'CO_HD', '31', '33','111', '13806197101366181716Color_Replay_120x120.png', 0),
(2, 'CO_HD', '31', '34', '112' , '13806197261366181786star-plus_Replay_120x120.png', 0),
(3, 'CO_HD', '31', '35', '113', '13806197451366181839MTV_Replay_120x120.png', 0);

-----------------------------------------------------------------------------

select * from VIEW_VOD_MASTER AS VVM INNER JOIN view_vod_detail AS VVD ON VVM.VVM_BD_CODE = VVD.VVM_BD_CODE AND VVM.VVM_OPERATOR = VVD.VVM_OPERATOR where

VVM.VVM_ASSET_STATUS = 'A' AND VVM.VVM_CAT_ID='10' AND VVM.VVM_OPERATOR='CM_OF' ORDER BY VVD.VVD_DISPLAY_ORDER DESC

select * from view_vod_subcategory_l3 AS VVS_l3 JOIN vod_subcategory_detail_l3 AS VVSD_l3 ON VVS_l3.SUB_CAT_ID_L3 = VVSD_l3.VSM_SUBCAT_ID_l3 AND VVS_l3.SUB_CAT_ID =

VVSD_l3.VSM_SUBCAT_ID where VVS_l3.STATUS = 'A' and VVSD_l3.VSM_OPERATOR_ID='CO_HD' ORDER BY VVSD_l3.display_order DESC

select * from view_vod_subcategory_l3 AS VVS_l3 LEFT JOIN vod_subcategory_detail_l3 AS VVSD_l3 ON VVS_l3.SUB_CAT_ID_L3 = VVSD_l3.VSM_SUBCAT_ID_l3 AND

VVS_l3.SUB_CAT_ID = VVSD_l3.VSM_SUBCAT_ID where VVS_l3.STATUS = 'A' and VVSD_l3.VSM_OPERATOR_ID='CO_HD' ORDER BY VVSD_l3.display_order DESC

select VVS_l3.SUB_CAT_ID_L3,VVS_l3.SUB_CAT_NAME_L3,VVS_l3.SUB_CAT_ID,VVS_l3.STATUS,VVSD_l3.VSM_OPERATOR_ID,VVSD_l3.vsm_icon,VVSD_l3.display_order from

view_vod_subcategory_l3 AS VVS_l3 LEFT JOIN vod_subcategory_detail_l3 AS VVSD_l3 ON VVS_l3.SUB_CAT_ID_L3 = VVSD_l3.VSM_SUBCAT_ID_l3 AND VVS_l3.SUB_CAT_ID =

VVSD_l3.VSM_SUBCAT_ID where VVS_l3.STATUS = 'A' and VVSD_l3.VSM_OPERATOR_ID='CO_HD' ORDER BY VVSD_l3.display_order DESC

create table ws_vod_subcat_l3 as select

VVS_l3.SUB_CAT_ID_L3,VVS_l3.SUB_CAT_NAME_L3,VVS_l3.SUB_CAT_ID,VVS_l3.STATUS,VVSD_l3.VSM_OPERATOR_ID,VVSD_l3.vsm_icon,VVSD_l3.display_order from

view_vod_subcategory_l3 AS VVS_l3 LEFT JOIN vod_subcategory_detail_l3 AS VVSD_l3 ON VVS_l3.SUB_CAT_ID_L3 = VVSD_l3.VSM_SUBCAT_ID_l3 AND VVS_l3.SUB_CAT_ID =

VVSD_l3.VSM_SUBCAT_ID where VVS_l3.STATUS = 'A' ORDER BY VVSD_l3.display_order DESC

select VVS_l3.SUB_CAT_ID_L3,VVS_l3.SUB_CAT_NAME_L3,VVS_l3.SUB_CAT_ID,VVS_l3.STATUS,VVSD_l3.VSM_OPERATOR_ID,VVSD_l3.vsm_icon,VVSD_l3.display_order from

view_vod_subcategory_l3 AS VVS_l3 LEFT JOIN vod_subcategory_detail_l3 AS VVSD_l3 ON VVS_l3.SUB_CAT_ID_L3 = VVSD_l3.VSM_SUBCAT_ID_l3 AND VVS_l3.SUB_CAT_ID =

VVSD_l3.VSM_SUBCAT_ID

http://172.31.22.45/common_hd/index.php?d=API&c=Authentication_HD&m=Vods_subcat&format=xml&device_id=354155055372902&cat_id=10&platform=j2me
http://119.252.215.103/common_hd/index.php?

d=API&c=Authentication_HD&m=subcat_l3_assets&format=json&device_id=354155055372902&cat_id=8&sub_cat_id=33&sub_cat_id_l3=111&platform=j2me

http://119.252.215.103/common_hd/index.php?

d=API&c=Authentication_HD&m=Vods_subcat_l3&format=xml&device_id=354155055372902&cat_id=8&sub_cat_id=33&sub_cat_id_l3=33&platform=

---------------------------------------------------------=========================================================================================

insert into ws_vods SELECT

VVM.`VVM_BD_CODE`,`VVM_DES`,`VVM_OPEN_DATE`,VVM.`VVM_OPERATOR`,`VVM_CLOSE_DATE`,`VVM_TYPE`,`VVM_LANGUAGE`,`VVM_ASSET_STATUS`,`VVM_THEME_ID`,
`VVM_CAT_ID`,`VVM_SUB_CAT_ID`,`VVM_SEASON`,`VVM_EPISODE_NO`,

`VVM_ASSET_DESC`,`VVM_DURATION`,`vvd_icon`,`vvd_preview_image`,`VVD_DISPLAY_ORDER`,`modify_date`,`VVM_SUB_CAT_ID_L3`
FROM `VIEW_VOD_MASTER` AS VVM
LEFT JOIN

view_vod_detail AS VVD
ON VVM.VVM_BD_CODE=VVD.VVM_BD_CODE
AND VVM.VVM_OPERATOR=VVD.VVM_OPERATOR
ORDER BY VVM.`VVM_BD_CODE` ASC

MV567
111

ulimit -a

ab -n 5000 -c 2000 http://localhost/common_hd/index.php?d=API&c=Authentication_HD&m=Channels&format=json&device_id=000000000000000&ch_ver=-1&pkg_ver=-1&vod_ver=-

1&ch_cat_ver=-1&device_res=bb60&platform=Android&msisdn=

ab -n 1000 -c 2000 http://119.252.216.91/common_hd/index.php?d=API&c=Authentication_HD&m=Channels&format=json&device_id=000000000000000&ch_ver=-1&pkg_ver=-

1&vod_ver=-1&ch_cat_ver=-1&device_res=bb60&platform=Android&msisdn=

http://119.252.216.91/common_hd/index.php?d=API&c=Authentication_HD&m=Channels&format=json&device_id=000000000000000&ch_ver=-1&pkg_ver=-1&vod_ver=-1&ch_cat_ver=-

1&device_res=bb60&platform=Android&msisdn=

//vod subcat

http://172.31.22.45/common_hd/index.php?d=API&c=Authentication&m=Vods_subcat&format=json&device_id=354155055372902&cat_id=31&platform=j2me

//vod subcat assets

http://172.31.22.45/common_hd/index.php?d=API&c=Authentication&m=Vods_subcat_assets&format=json&device_id=354155055372902&cat_id=31&sub_cat_id=32&platform=j2me

//vod subcatl3

http://172.31.22.45/common_hd/index.php?

d=API&c=Authentication_HD&m=subcat_l3_assets&format=json&device_id=354155055372902&cat_id=8&sub_cat_id=33&sub_cat_id_l3=111&platform=j2me

http://172.31.22.45/common_hd/index.php?

d=API&c=Authentication_HD&m=Vods_subcat_l3&format=xml&device_id=354155055372902&cat_id=8&sub_cat_id=33&sub_cat_id_l3=33&platform=

http://172.31.22.45/common_hd/index.php?d=API&c=Authentication&m=Vods_subcat_assets&format=xml&device_id=354155055372902&cat_id=10&sub_cat_id=2&platform=j2me

http://172.31.22.45/common_hd/index.php?d=API&c=Authentication&m=Vods_subcat&format=xml&device_id=354155055372902&cat_id=10&platform=j2me

http://172.31.22.45/common_hd/index.php?d=API&c=Authentication_HD&m=Vods_subcat_l3&format=xml&device_id=355798050579887&cat_id=3&sub_cat_id=17&platform=

http://119.252.215.103/common_hd/index.php?d=API&c=Authentication_HD&m=Vods_subcat_l3&format=xml&device_id=354155055372902&cat_id=8&sub_cat_id=33&platform=

http://172.31.22.45/common_hd/index.php?

d=API&c=Authentication_HD&m=subcat_l3_assets&format=xml&device_id=354155055372902&cat_id=8&sub_cat_id=33&sub_cat_id_l3=111&platform=j2me

=========================================================================================================================================================
http://stackoverflow.com/questions/34588/how-do-i-change-the-number-of-open-files-limit-in-linux

* soft nofile 16384
* hard nofile 16384
apache soft nproc 1457280
apache hard nproc 3000000

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

SELECT * FROM ws_vods where VVM_ASSET_STATUS = 'A'
AND VVM_CAT_ID='8'
AND VVM_SUB_CAT_ID='33'
AND VVM_SUB_CAT_ID_L3 ='111'
AND VVM_OPERATOR='CO_HD'
AND vvd_icon !=''
AND vvd_preview_image !=''
ORDER BY modify_date DESC

+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

=====================================================================
update `CHANNEL_DETAIL_VIEW` set `cat_name` ='General Entertainment' where `CMV_CHANNEL_CODE` IN (select `CMV_CHANNEL_CODE` from Entert)

update `CHANNEL_DETAIL_VIEW` set `cat_name` ='Movies & Music' where `CMV_CHANNEL_CODE` IN (select `CMV_CHANNEL_CODE` from Movies_Music)

update `CHANNEL_DETAIL_VIEW` set `cat_name` ='Business News' where `CMV_CHANNEL_CODE` IN (select `CMV_CHANNEL_CODE` from Business_News)

update `CHANNEL_DETAIL_VIEW` set `cat_name` ='Regional Channels' where `CMV_CHANNEL_CODE` IN (select `CMV_CHANNEL_CODE` from Regional_Channels)

update `CHANNEL_DETAIL_VIEW` set `cat_name` ='Devotional' where `CMV_CHANNEL_CODE` IN (select `CMV_CHANNEL_CODE` from Devotional)

update `CHANNEL_DETAIL_VIEW` set `cat_name` ='General News' where `CMV_CHANNEL_CODE` IN (select `CMV_CHANNEL_CODE` from General_News)

update `CHANNEL_DETAIL_VIEW` set `cat_name` ='Kids' where `CMV_CHANNEL_CODE` IN (select `CMV_CHANNEL_CODE` from Kids)

update `CHANNEL_DETAIL_VIEW` set `cat_name` ='Info & Lifestyle' where `CMV_CHANNEL_CODE` IN (select `CMV_CHANNEL_CODE` from Info_Lifestyle)

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

create table Entert as select * from channel_detail_view where CMV_OPERATOR = 'CM_OF' and cat_name ='Entertainment'

create table Movies_Music as select * from channel_detail_view where CMV_OPERATOR = 'CM_OF' and cat_name ='Movies & Music'

create table Business_News as select * from channel_detail_view where CMV_OPERATOR = 'CM_OF' and cat_name ='Business News'

create table Regional_Channels as select * from channel_detail_view where CMV_OPERATOR = 'CM_OF' and cat_name ='Regional Channels'

create table Devotional as select * from channel_detail_view where CMV_OPERATOR = 'CM_OF' and cat_name ='Devotional'

create table General_News as select * from channel_detail_view where CMV_OPERATOR = 'CM_OF' and cat_name ='General News'

create table Kids as select * from channel_detail_view where CMV_OPERATOR = 'CM_OF' and cat_name ='Kids'

create table Info_Lifestyle as select * from channel_detail_view where CMV_OPERATOR = 'CM_OF' and cat_name ='Info & Lifestyle'

+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

CREATE TABLE `dth`.`PACKAGE_MASTER_VIEW` (
`PMV_BDD_CODE` VARCHAR( 100 ) NULL ,
`PMV_DES` VARCHAR( 255 ) NULL ,
`PMV_VAL` INT( 25 ) NULL ,
`PMV_OPEN_DATE` DATE NULL ,
`PMV_CLOSE_DATE` VARCHAR( 10 ) NULL ,
`PMV_OPERATOR` VARCHAR( 50 ) NULL ,
`PMV_PACKAGE_TYPE` VARCHAR( 25 ) NULL ,
`PMV_PRICE` INT( 25 ) NULL ,
`PMV_RENEWFLAG` VARCHAR( 10 ) NULL ,
`PMV_CHANNEL_LIST` VARCHAR( 25 ) NULL
) ENGINE = MYISAM

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

update ws_channel1 set cat_name='2' where cat_name='General Entertainment';

update ws_channel1 set cat_name='7' where cat_name='English News';

update ws_channel1 set cat_name='9' where cat_name='Hindi News';

update ws_channel1 set cat_name='11' where cat_name='Music';

update ws_channel1 set cat_name='13' where cat_name='Kids';

update ws_channel1 set cat_name='19' where cat_name='Regional Channels';

update channel_detail_view set cat_name='2' where CMV_OPERATOR ='DTHAIR' and cat_name='General Entertainment';

update channel_detail_view set cat_name='7' where CMV_OPERATOR ='DTHAIR' and cat_name='English News';

update channel_detail_view set cat_name='9' where CMV_OPERATOR ='DTHAIR' and cat_name='Hindi News';

update channel_detail_view set cat_name='11' where CMV_OPERATOR ='DTHAIR' and cat_name='Music';

update channel_detail_view set cat_name='13' where CMV_OPERATOR ='DTHAIR' and cat_name='Kids';

update channel_detail_view set cat_name='19' where CMV_OPERATOR ='DTHAIR' and cat_name='Regional Channels';

update channel_detail_view set cat_name='38' where CMV_OPERATOR ='CO_HD' and cat_name='Free Channels';

update channel_detail_view set cat_name='21' where CMV_OPERATOR ='AIRHD' and cat_name='General Entertainment';

update channel_detail_view set cat_name='23' where CMV_OPERATOR ='AIRHD' and cat_name='English News';

update channel_detail_view set cat_name='25' where CMV_OPERATOR ='AIRHD' and cat_name='Hindi News';

update channel_detail_view set cat_name='27' where CMV_OPERATOR ='AIRHD' and cat_name='Music';

update channel_detail_view set cat_name='29' where CMV_OPERATOR ='AIRHD' and cat_name='Kids';

update channel_detail_view set cat_name='31' where CMV_OPERATOR ='AIRHD' and cat_name='Regional Channels';

update channel_detail_view set cat_name='39' where CMV_OPERATOR ='AIRHD' and cat_name='Free Channels';

update channel_detail_view set cat_name='32' where CMV_OPERATOR ='OVOD' and cat_name='General Entertainment';

update channel_detail_view set cat_name='33' where CMV_OPERATOR ='OVOD' and cat_name='English News';

update channel_detail_view set cat_name='34' where CMV_OPERATOR ='OVOD' and cat_name='Hindi News';

update channel_detail_view set cat_name='35' where CMV_OPERATOR ='OVOD' and cat_name='Music';

update channel_detail_view set cat_name='36' where CMV_OPERATOR ='OVOD' and cat_name='Kids';

update channel_detail_view set cat_name='37' where CMV_OPERATOR ='OVOD' and cat_name='Regional Channels';

update channel_detail_view set cat_name='40' where CMV_OPERATOR ='AIRHD' and cat_name='OVOD';

update channel_detail_view set cat_name='41' where CMV_OPERATOR ='AR_ON' and cat_name='General Entertainment';

update channel_detail_view set cat_name='42' where CMV_OPERATOR ='AR_ON' and cat_name='English News';

update channel_detail_view set cat_name='43' where CMV_OPERATOR ='AR_ON' and cat_name='Hindi News';

update channel_detail_view set cat_name='44' where CMV_OPERATOR ='AR_ON' and cat_name='Music';

update channel_detail_view set cat_name='45' where CMV_OPERATOR ='AR_ON' and cat_name='Kids';

update channel_detail_view set cat_name='46' where CMV_OPERATOR ='AR_ON' and cat_name='Regional Channels';

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

http://localhost/AIRTEL_DTH/index.php?d=API&c=Authentication_HD&m=Channels&format=xml&device_id=000000000000000&ch_ver=-1&pkg_ver=-1&vod_ver=-1&ch_cat_ver=-

1&device_res=bb60&platform=Android&msisdn=

DTH

http://localhost/AIRTEL_DTH/index.php?d=API&c=Authentication_HD&m=dthUserRegistration&format=json&device_id=psk&platform=Android&msisdn=9998****

REqustREGISTER .php

http://localhost/AIRTEL_DTH/index.php?

d=API&c=Authentication_HD&m=dthUserRegistration&format=json&device_id=000000000000000&platform=Android&msisdn=9873214648&deviceName=nokia1

localhost/AIRTEL_DTH/index.php?d=API&c=Authentication_HD&m=dthUserRegistration&format=json&device_id=000000000000000&platform=Android&crnumber=123cr&deviceName=nokia1

//confiemRquest Register for dth

localhost/AIRTEL_DTH/index.php?d=API&c=Authentication_HD&m=ConfirmRequestRegisterDTH&format=json&device_id=000000000000000&platform=Android&otp=12345

http://localhost/AIRTEL_DTH/index.php?

d=API&c=Authentication_HD&m=ConfirmRequestRegisterDTH&format=json&device_id=000000000000000&platform=Android&otp=12345&crNumber=123abc&msisdn=123

getsequreURL

http://localhost/AIRTEL_DTH/index.php?

d=API&c=Authentication_HD&m=getsecure_dthurl&format=json&device_id=000000000000000&PackID=PK10&chanelID=AC83&packType=B&RequestDateTime=&streamType=2g

http://localhost/AIRTEL_DTH/index.php?

d=API&c=Authentication_HD&m=getsecure_dthurl&format=json&device_id=000000000000000&PackID=PK10&chanelID=AC83&packType=B&CustomerStatus=A&RequestDateTime=&streamType=2g

http://172.31.22.45/DTH/index.php?

d=API&c=Authentication_HD&m=getsecureurl&format=json&device_id=000000000000000&PackID=PK10&chanelID=AC83&packType=B&RequestDateTime=&streamType=2g

CH409 AC42 AC83 Zoom

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

50 server 32GB
51server 32GB

54server 16GB

55server 16GB

56Server 16GB

//
Registration screen

http://119.252.215.103/DTH/index.php?

d=API&c=Authentication_HD&m=dthUserRegistration&format=json&device_id=000000000000000&platform=Android&msisdn=9873214648&deviceName=nokia1

//confirmation screen
http://119.252.215.103/DTH/index.php?

d=API&c=Authentication_HD&m=ConfirmRequestRegisterDTH&format=json&device_id=000000000000000&platform=Android&otp=12345&crNumber=123abc&msisdn=123

//get secure URL Screen
http://119.252.215.103/DTH/index.php?

d=API&c=Authentication_HD&m=getsecure_dthurl&format=json&device_id=000000000000000&PackID=PK10&chanelID=AC83&packType=B&RequestDateTime=&streamType=2g

http://119.252.215.103/DTH

172.31.22.45/DTH/index.php?d=API&c=Authentication_HD&m=dthUserRegistration&format=json&device_id=0000000000000002&platform=Android&msisdn=9873214648&deviceName=nokia1

http://localhost/AIRTEL_DTH/index.php?

d=API&c=Authentication_HD&m=ConfirmRequestRegisterDTH&format=json&device_id=0000000000000002&platform=Android&otp=12345&crNumber=123abc&msisdn=123

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

119.252.215.126

http://119.252.215.126:8082/tbms/services/SDPLWebService?wsdl

Soap service Universal URL:-
http://119.252.215.126:8082/DBVAS/ITBMService.svc?wsdl

172.31.25.15 8082//DBVAS/

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

DTH URL

//epg
119.252.215.103/DTH/index.php?d=API&c=Authentication_HD&m=epg&format=json&device_id=000000000000000&epg_ver=-1&platform=

////vod subcat

http://119.252.215.103/DTH/index.php?d=API&c=Authentication_HD&m=Vods_subcat&format=json&device_id=000000000000000&cat_id=31&platform=

//vod subcat assets

119.252.215.103/DTH/index.php?d=API&c=Authentication_HD&m=Vods_subcat_assets&format=json&device_id=000000000000000&cat_id=31&sub_cat_id=32&platform=j2me

//feedback
http://119.252.215.103/DTH/index.php?d=API&c=Authentication_HD&m=Feedback&device_id=000000000000000&platform=j2me&format=json&msisdn=9&intext=&platform=j2me

//pop up message
http://119.252.215.103/DTH/index.php?d=API&c=Authentication_HD&m=PopUpMessage&device_id=000000000000000&platform=j2me&format=json&msisdn=

//Authentication

http://119.252.215.103/DTH/index.php?d=API&c=Authentication_HD&m=Channels&format=json&device_id=000000000000000&ch_ver=-1&pkg_ver=-1&vod_ver=-1&ch_cat_ver=-

1&device_res=bb60&platform=Android&msisdn=

//
Registration screen

http://119.252.215.103/DTH/index.php?

d=API&c=Authentication_HD&m=dthUserRegistration&format=json&device_id=000000000000000&platform=Android&msisdn=9873214648&deviceName=nokia1

//confirmation screen
http://119.252.215.103/DTH/index.php?

d=API&c=Authentication_HD&m=ConfirmRequestRegisterDTH&format=json&device_id=000000000000000&platform=Android&otp=12345&crNumber=123abc&msisdn=123

//get secure URL Screen
http://119.252.215.103/DTH/index.php?

d=API&c=Authentication_HD&m=getsecure_dthurl&format=json&device_id=000000000000000&PackID=PK10&chanelID=AC83&packType=B&RequestDateTime=&streamType=2g

update `program_details`set `Service_Id`=27 where `Service_Name`='IBN7'

2C572307-9FB8-446C-8319-14AF3C8E9584

http://172.31.22.45/DTH/index.php?

%20d=API&c=Authentication_HD&m=dthUserRegistration1&format=json&device_id=00000000000000067&platform=Android&msisdn=9555285804&deviceName=nokia1

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

12367891012451 9654399030

12367891012462 9555285804

12367891012473 9911369528

12367891012484 8586928927

12367891012495 9873214648
9702233726

354905056085741

http://172.31.22.45/DTH/index.php?%20d=DTHAPI&c=Authentication_HD&m=unlinkRegDevice&format=json&deleid=143

http://172.31.22.45/DTH/index.php?%20d=DTHAPI&c=Authentication_HD&m=unlinkRegDevice&format=json&deleid=143

http://172.31.22.45/DTH/index.php?

%20d=API&c=Authentication_HD&m=dthUserRegistration&format=json&device_id=0000000000000004&platform=Android&msisdn=9555285804&crnumber=&deviceName=nokia1

PHPBLOG

Monday, 5 May 2014

backupfiles