Centostask1

ping 8.8.8.8
clear
yum install httpd
sudo yum install httpd
sudo yum install centos-release-scl
sudo yum install https://centos7.iuscommunity.org/ius-release.rpm
sudo yum install rh-python36
sudo yum install python36u-pip
sudo pip3.6 install flask
pip install --upgrade pip
sudo pip3.6 install --upgrade pip
sudo yum install MySQL
sudo yum install mysql
sudo yum install mariadb
route
sudo yum install ottd
sudo yum install open transport tycoon deluxe
sudo yum update
sudo yum install mariadb-server libmariadbclient-dev libssl-dev
sudo service mysql start
sudo service mariadb start
mysql -u root -p
halt
su
sudo yum list installed mariadb-server
sudo yum remove mariadb-server mariadb-libs
sudo yum list installed mariadb-server
sudo -sS https://downloads.mariadb.com/MariaDB/mariadb_repo_setup | sudo bash
 sudo curl -sS https://downloads.mariadb.com/MariaDB/mariadb_repo_setup | sudo bash
sudo yum install mariadb-server
sudo systemctl enable mariadb
sudo systemctl start mariadb
sudo mysql_secure_installation
sudo mysql -u root -p
sudo systemctl enable httpd
sudo systemctl start httpd
netstat -tulnp | httpd
sudo systemctl stop httpd
sudo yum remove httpd
sudo yum install -y httpd
sudo systemctl stop mariadb
sudo systemctl enable httpd
sudo systemctl start httpd
netstat -tulnp | grep httpd
su
instpo mod_wsgi
exit
sudo yum remove firefox
sudo yum install firefox
systemctl start firefox
 start firefox
sudo start firefox
sudo systemctl start httpd
netstat -tulnp | grep httpd
su
sudo mkdir /var/www/flask
sudo nano /var/www/flask/pythonapp.py
sudo python3.6 /var/www/flask/pythonapp.py
sudo nano /var/www/flask/pythonapp.py
sudo python3.6 /var/www/flask/pythonapp.py
sudo o nano /var/www/flask/pythonapp.py
sudo nano /var/www/flask/pythonapp.py
sudo systemctl restart httpd
sudo python3.6 /var/www/flask/pythonapp.py
sudo o nano /var/www/flask/pythonapp.py
sudo nano /var/www/flask/pythonapp.py
sudo mkdir /var/www/flask/templates
sudo nano /var/www/flask/pythonapp.py
sudo nano /var/www/flask/templates/auth.html
sudo python3.6 /var/www/flask/pythonapp.py
sudo mysql -u root -p
sudo nano /var/www/flask/templates/auth.html
sudo mysql -u root -p
sudo python3.6 /var/www/flask/pythonapp.py
sudo nano /var/www/flask/templates/auth.html
sudo nano /var/www/flask/pythonapp.py
sudo nano /var/www/flask/templates/auth.html
sudo nano /var/www/flask/pythonapp.py
sudo python3.6 setup.py install
sudo pip3.6 install sqlalchemy
sudo yum install mysql
sudo pip3.6 install mysql-connector
sudo pip3.6 install mariadb-connector
sudo mysql -V
sudo nano /var/www/flask/templates/message.html
sudo systemctl restart httpd
sudo nano /var/www/flask/pythonapp.py
sudo nano /var/www/flask/templates/auth.html
sudo nano /var/www/flask/pythonapp.py
sudo python3.6 /var/www/flask/pythonapp.py
sudo nano /var/www/flask/pythonapp.py
sudo python3.6 /var/www/flask/pythonapp.py
sudo nano /var/www/flask/pythonapp.py
sudo python3.6 /var/www/flask/pythonapp.py
sudo nano /var/www/flask/templates/auth.html
sudo nano /var/www/flask/pythonapp.py
sudo python3.6 /var/www/flask/pythonapp.py
sudo nano /var/www/flask/pythonapp.py
sudo python3.6 /var/www/flask/pythonapp.py
s sudo nano /var/www/flask/templates/Display.html
sudo gedit /var/www/flask/templates/Display.html
sudo nano /var/www/flask/templates/Display.html
sudo gedit /var/www/flask/templates/Display.html
sudo nano /var/www/flask/templates/Display.html
sudo nano /var/www/flask/Display.py

sudo systemctl restart httpd
sudo python3.6 /var/www/flask/Display.py
sudo nano /var/www/flask/Display.py
sudo systemctl restart httpd
sudo python3.6 /var/www/flask/Display.py
sudo nano /var/www/flask/Display.py
sudo systemctl restart httpd
sudo python3.6 /var/www/flask/Display.py
sudo nano /var/www/flask/Display.py
sudo systemctl restart httpd
sudo python3.6 /var/www/flask/Display.py
sudo nano /var/www/flask/Display.py
sudo systemctl restart httpd
sudo python3.6 /var/www/flask/Display.py
sudo nano /var/www/flask/Display.py
sudo systemctl restart httpd
sudo python3.6 /var/www/flask/Display.py
sudo gedit /var/www/flask/templates/Display.html
sudo nano /var/www/flask/templates/auth.html
sudo gedit /var/www/flask/templates/auth.html
sudo systemctl restart httpd
sudo python3.6 /var/www/flask/Display.py
sudo python3.6 /var/www/flask/pythonapp.py
sudo nano /var/www/flask/templates/auth.html
sudo python3.6 /var/www/flask/pythonapp.py
sudo systemctl restart httpd
sudo gedit /var/www/flask/pythonapp.py
sudo systemctl restart httpd
sudo python3.6 /var/www/flask/pythonapp.py
sudo python3.6 /var/www/flask/Display.py
sudo mysql -u root -p
sudo gedit /var/www/flask/pythonapp.py
sudo gedit /var/www/flask/Task1.py
sudo python3.6 /var/www/flask/Task1.py
sudo mysql -u root -p
sudo gedit /var/www/flask/Task1.py
sudo nano /var/www/flask/Display.py
sudo gedit /var/www/flask/templates/showdata.html
sudo mysql -u root -p
sudo gedit /var/www/flask/Display.py
sudo gedit /var/www/flask/Task1.py
sudo gedit /var/www/flask/templates/Display.html
sudo gedit /var/www/flask/templates/showdata.html
sudo python3.6 /var/www/flask/Task1.py
sudo gedit /var/www/flask/Task1.py
sudo python3.6 /var/www/flask/Task1.py
sudo gedit /var/www/flask/Task1.py
sudo gedit /var/www/flask/Display.py
sudo gedit /var/www/flask/Task1.py
sudo python3.6 /var/www/flask/Task1.py
sudo gedit /var/www/flask/Task1.py
sudo python3.6 /var/www/flask/Task1.py
sudo gedit /var/www/flask/templates/showdata.html
sudo python3.6 /var/www/flask/Task1.py
sudo gedit /var/www/flask/Task1.py
sudo python3.6 /var/www/flask/Task1.py
sudo gedit /var/www/flask/Task1.py
sudo python3.6 /var/www/flask/Task1.py
sudo gedit /var/www/flask/Task1.py
sudo gedit /var/www/flask/Task1ST.py
sudo python3.6 /var/www/flask/Task1ST.py
sudo gedit var/www/flask/Task1QR.py
sudo gedit /var/www/flask/Task1ST.py
sudo gedit var/www/flask/Task1QR.py
sudo gedit /var/www/flask/Task1QR.py
sudo gedit /var/www/flask/templates/showdate.html
sudo gedit /var/www/flask/templates/auth.html
sudo gedit /var/www/flask/templates/showdate.html
sudo gedit /var/www/flask/Task1QR.py
sudo python3.6 /var/www/flask/Task1QR.py
sudo gedit /var/www/flask/Task1QR.py
sudo gedit /var/www/flask/Display.py
sudo gedit /var/www/flask/Task1QR.py
sudo gedit /var/www/flask/Update.py
sudo gedit /var/www/flask/Task1QR.py
sudo gedit /var/www/flask/templates/showdata.html
sudo gedit /var/www/flask/templates/showcalls.html
sudo gedit /var/www/flask/Task1.py
sudo gedit /var/www/flask/templates/showcalls.html
mysql -u root -p
sudo gedit /var/www/flask/Task1.py
sudo gedit /var/www/flask/templates/showcalls.html
sudo gedit /var/www/flask/Task1QR.py
sudo gedit /var/www/flask/Update.py
sudo gedit /var/www/flask/templates/show.html
sudo gedit /var/www/flask/templates/Show.html
sudo gedit /var/www/flask/templates/showdate.html
sudo gedit /var/www/flask/Update.py
sudo gedit /var/www/flask/Task1QR.py
sudo python3.6 /var/www/flask/Task1QR.py
sudo gedit /var/www/flask/Update.py
sudo gedit /var/www/flask/Task1QR.py
sudo gedit /var/www/flask/Update.py
sudo gedit /var/www/flask/Task1QR.py
sudo python3.6 /var/www/flask/Task1QR.py
sudo gedit /var/www/flask/Task1QR.py
sudo python3.6 /var/www/flask/Task1QR.py
sudo gedit /var/www/flask/Task1QR.py
sudo python3.6 /var/www/flask/Task1QR.py
sudo gedit /var/www/flask/Task1QR.py
sudo python3.6 /var/www/flask/Task1QR.py
sudo gedit /var/www/flask/Task1QR.py
sudo python3.6 /var/www/flask/Task1QR.py
sudo gedit /var/www/flask/Task1QR.py
sudo python3.6 /var/www/flask/Task1QR.py
sudo gedit /var/www/flask/Task1QR.py
sudo python3.6 /var/www/flask/Task1QR.py
sudo gedit /var/www/flask/Task1QR.py
sudo python3.6 /var/www/flask/Task1QR.py
sudo gedit /var/www/flask/Task1QR.py
sudo python3.6 /var/www/flask/Task1QR.py
sudo gedit /var/www/flask/Task1QR.py
sudo mysql_upgrade
sudo mariadb_upgrade
sudo mysql_upgrade --force -u root -p
sudo service mariadb restart
sudo python3.6 /var/www/flask/Task1QR.py
sudo gedit /var/www/flask/Task1QR.py
sudo python3.6 /var/www/flask/Task1QR.py
sudo gedit /var/www/flask/Task1QR.py
sudo python3.6 /var/www/flask/Task1QR.py
sudo gedit /var/www/flask/Task1QR.py
sudo python3.6 /var/www/flask/Task1QR.py
sudo gedit /var/www/flask/Task1QR.py
sudo python3.6 /var/www/flask/Task1QR.py
sudo gedit /var/www/flask/Task1QR.py
sudo python3.6 /var/www/flask/Task1QR.py
sudo gedit /var/www/flask/Task1QR.py
sudo python3.6 /var/www/flask/Task1QR.py
sudo gedit /var/www/flask/Task1QR.py
sudo python3.6 /var/www/flask/Task1QR.py
sudo gedit /var/www/flask/Task1QR.py
sudo python3.6 /var/www/flask/Task1QR.py
sudo gedit /var/www/flask/Task1QR.py
sudo python3.6 /var/www/flask/Task1QR.py
sudo gedit /var/www/flask/Task1QR.py
sudo python3.6 /var/www/flask/Task1QR.py
sudo gedit /var/www/flask/Task1QR.py
sudo python3.6 /var/www/flask/Task1QR.py
sudo gedit /var/www/flask/Task1QR.py
sudo python3.6 /var/www/flask/Task1QR.py
sudo gedit /var/www/flask/Task1QR.py
sudo python3.6 /var/www/flask/Task1QR.py
sudo gedit /var/www/flask/Task1QR.py
sudo python3.6 /var/www/flask/Task1QR.py
sudo gedit /var/www/flask/Task1QR.py
sudo python3.6 /var/www/flask/Task1QR.py
sudo gedit /var/www/flask/Task1QR.py
sudo python3.6 /var/www/flask/Task1QR.py
sudo gedit /var/www/flask/Task1QR.py
sudo python3.6 /var/www/flask/Task1QR.py
sudo lsof -t -i tcp:80
sudo lsof -i :80
sudo httpd.conf
sudo chmod -m 777 /etc/httpd
sudo chmod -R 777 /etc/httpd
sudo systemctl restart httpd
sudo python3.6 /var/www/flask/Task1QR.py
sudo mysql -u root -p
sudo mysql -u user1 -p 123
sudo mysql -u user1 -p
sudo mysql -u user2 -p
sudo gedit /var/www/flask/Task1QR.py
sudo gedit /var/www/flask/apppython.py
sudo gedit /var/www/flask/appython.py
sudo gedit /var/www/flask/Update.py
sudo gedit /var/www/flask/pythonapp.py
sudo gedit /var/www/flask/Task1QR.py
sudo gedit /var/www/flask/templates/dbjoin.html
sudo gedit /var/www/flask/templates/auth.html
sudo gedit /var/www/flask/templates/dbjoin.html
sudo python3.6 /var/www/flask/Task1QR.py
sudo gedit /var/www/flask/Task1QR.py
sudo python3.6 /var/www/flask/Task1QR.py
sudo gedit /var/www/flask/Task1QR.py
sudo gedit /var/www/flask/templates/showdate.html
sudo gedit /var/www/flask/templates/dbjoin.html
sudo gedit /var/www/flask/templates/showdate.html
sudo gedit /var/www/flask/templates/dbjoin.html
sudo gedit /var/www/flask/Task1QR.py
sudo python3.6 /var/www/flask/Task1QR.py
sudo gedit /var/www/flask/Task1QR.py
sudo python3.6 /var/www/flask/Task1QR.py
sudo gedit /var/www/flask/Task1QR.py
sudo python3.6 /var/www/flask/Task1QR.py
sudo gedit /var/www/flask/Task1QR.py
sudo gedit /var/www/flask/templates/dbjoin.html
sudo gedit /var/www/flask/Task1QR.py
sudo python3.6 /var/www/flask/Task1QR.py
sudo gedit /var/www/flask/Task1QR.py
sudo python3.6 /var/www/flask/Task1QR.py
sudo gedit /var/www/flask/Task1QR.py
sudo python3.6 /var/www/flask/Task1QR.py
sudo gedit /var/www/flask/Task1QR.py
sudo python3.6 /var/www/flask/Task1QR.py
sudo gedit /var/www/flask/Task1QR.py
sudo python3.6 /var/www/flask/Task1QR.py
sudo gedit /var/www/flask/Task1QR.py
sudo python3.6 /var/www/flask/Task1QR.py
sudo gedit /var/www/flask/templates/dbjoin.html
sudo gedit /var/www/flask/templates/showdate.html
sudo gedit /var/www/flask/templates/auth.html
sudo gedit /var/www/flask/templates/show.html
sudo gedit /var/www/flask/templates/Show.html
sudo python3.6 /var/www/flask/Task1QR.py
sudo gedit /var/www/flask/templates/showdate.html
sudo python3.6 /var/www/flask/Task1QR.py
sudo gedit /var/www/flask/templates/showdata.html
sudo python3.6 /var/www/flask/Task1QR.py
sudo gedit /var/www/flask/templates/showdata.html
sudo python3.6 /var/www/flask/Task1QR.py
sudo gedit /var/www/flask/Task1QR.py
sudo gedit /var/www/flask/templates/showcalls.html
sudo python3.6 /var/www/flask/Task1QR.py
sudo gedit /var/www/flask/Task1QR.py
sudo python3.6 /var/www/flask/Task1QR.py
sudo gedit /var/www/flask/Task1QR.py
sudo python3.6 /var/www/flask/Task1QR.py
sudo gedit /var/www/flask/Task1QR.py
sudo gedit /var/www/flask/templates/showdate.html
sudo python3.6 /var/www/flask/Task1QR.py
sudo gedit /var/www/flask/templates/showdate.html
sudo gedit /var/www/flask/Task1QR.py
sudo python3.6 /var/www/flask/Task1QR.py
sudo gedit /var/www/flask/Task1QR.py
sudo python3.6 /var/www/flask/Task1QR.py
sudo gedit /var/www/flask/Task1ST.py
sudo gedit /var/www/flask/Task1.py
sudo mysql -u root -p
sudo python3.6 /var/www/flask/Task1.py
sudo mysql -u root -p
sudo python3.6 /var/www/flask/Task1.py
sudo mysql -u root -p
sudo gedit /var/www/flask/Task1.py
sudo python3.6 /var/www/flask/Task1.py
sudo mysql -u root -p
sudo python3.6 /var/www/flask/Task1.py
exit

from flask import Flask, render_template, request
import mysql.connector as mariadb
app=Flask(__name__)
@app.route('/')
def CreateTBL1():
	conn=mariadb.connect(user = 'root', password='lenin1917', database='Task1DB')
	cur=conn.cursor()
	cur.execute("CREATE TABLE IF NOT EXISTS Task1TBL (id VARCHAR(100), calldate DATETIME, clid VARCHAR(100), src VARCHAR(100), dst VARCHAR(100), dcontext VARCHAR(100), channel VARCHAR(100), dstchannel VARCHAR(100), lastapp VARCHAR(100), lastdata VARCHAR(100), duration VARCHAR(100), billsec INT, disposition VARCHAR(100), amaflags VARCHAR(100), accountcode VARCHAR(100), uniqueid VARCHAR(100), userield VARCHAR(100), did VARCHAR(100), recordingfile VARCHAR(100), qname VARCHAR(100), idcrm1 VARCHAR (100), idcrm2 VARCHAR (100), idcrm3 VARCHAR (100), trunkid VARCHAR(100), callend VARCHAR(100), answer VARCHAR(100), src_cc VARCHAR(100), dst_cc VARCHAR(100), trunk_clid VARCHAR(100), qualityid VARCHAR(100), null1 VARCHAR(50))")
	conn.commit()
	return " "
if __name__=='__main__':
	app.run(debug=True)
from flask import Flask, render_template, request
from datetime import datetime, date, time
import mysql.connector as mariadb
app=Flask(__name__)
user="uuuu"
pas="pppp"
@app.route('/')
def dbjoin():
	return render_template("dbjoin.html")
@app.route('/act', methods=['GET', 'POST'])
def act():
	#if (request.method=='POST'):
	global user
	global pas
	user=request.form['User']
	pas=request.form['Pass']
	return render_template('showdate.html')
@app.route('/inputdate', methods=['GET','POST'])
def showquery():
	us=user
	pa=pas
	aDate=request.form['Date']
	aMin=int(request.form['Min'])
	aMin=aMin*60
	conn=mariadb.connect(user = us, password=pa, database='Task1DB')
	cur=conn.cursor()
	cur.execute("SELECT * FROM Task1TBL WHERE DATE(calldate)=%s AND billsec>%s", (aDate,aMin,))
	rows=cur.fetchall()
	return render_template("showcalls.html", rows=rows)
if __name__=='__main__':
	app.run(port=80, debug=True)