Inception_web version installation
Preface
Inception is an automated database operation and maintenance system that integrates auditing SQL, executing SQL and rolling back.
Environment:
System: centos 6.8
Ip: 192.168.137.38
Python:Python2.7
Deployment steps:
# cd / usr/src/
# wget https://github.com/mysql-inception/inception/archive/master.zip
# unzip master.zip
# yum-y install gcc gcc-c++ cmake bison openssl-devel ncurses-devel mysql-devel
# cd inception-master
#. / inception_build.sh debug [Xcode] # [Xcode] specify the default linux for the platform
# echo $? # if 0 is returned, it is successful.
# Edit the configuration file, and if not, create it
# vim / etc/inc.cnf
[inception]
General_log=1
General_log_file=inc.log
Port=6669
Socket=/tmp/inc.socket
Character-set-client-handshake=0
Character-set-server=utf8
Inception_remote_system_password=admin
Inception_remote_system_user=myadmin
Inception_remote_backup_port=3308
Inception_remote_backup_host=127.0.0.1
Inception_support_charset=utf8
Inception_enable_nullable=0
Inception_check_primary_key=1
Inception_check_column_comment=1
Inception_check_table_comment=1
Inception_osc_min_table_size=1
Inception_osc_bin_dir=/usr/bin
Inception_osc_chunk_time=0.1
Inception_ddl_support=1
Inception_enable_blob_type=1
Inception_check_column_default_value=1
# press esc first, then press shift followed by: enter wq! Save exit
# the following should be run according to the directory of the unzipped package files and load the files
# / usr/src/inception-master/debug/mysql/bin/Inception-- defaults-file=/etc/inc.cnf &
# Log in to mysql
# mysql-uroot-h227.0.0.1-P 6669
# enter the following command in mysql
# inception get variables
# upgrade Python to 2.7
# cd / usr/src/
# wget http://www.python.org/ftp/python/2.7.3/Python-2.7.3.tgz
# tar-xf Python-2.7.3.tgz
# cd Python-2.7.3
#. / configure-prefix=/usr/local/python27
# echo $?
# make & & make install
# echo $?
# mv / usr/bin/python / usr/bin/python26
# ln-s / usr/local/python27/bin/python2.7 / usr/bin/python
# vim / usr/bin/yum
# change #! / usr/bin/python to #! / usr/bin/python26
# enter Python to see if it is 2.7.Then exit () exits, and type yum list to see if the yum source is normal
# cd / usr/src/
# wget https://bootstrap.pypa.io/ez_setup.py-- no-check-certificate
# python ez_setup.py
# [root@localhost ~] # find /-name easy_install-2.7
/ usr/local/python27/bin/easy_install-2.7
# cd / usr/local/python27/bin/
#. / easy_install-2.7 pip
# echo $?
# [root@localhost bin] # find /-name pip2.7
/ usr/local/python27/bin/pip2.7
#. / pip2.7 install flask_wtf
#. / pip2.7 install flask-script
#. / pip2.7 install flask-debugtoolbar
#. / pip2.7 install MySQL-python
# cd / usr/src/
# yum install git
# git clone https://github.com/dbalihui/inception_web.git
# cd inception_web/app/
# vim inception.py # (Note: the red part is defined for yourself)
Coding=utf-8
Import MySQLdb
Def table_structure (mysql_structure):
Sql1='/*--user=root;--password=root;--host=127.0.0.1;--execute=1;--port=3306;*/\
Inception_magic_start;\
Use test_3;'
Sql2='inception_magic_commit;'
Sql = sql1 + mysql_structure + sql2
Try:
Conn=MySQLdb.connect (host='127.0.0.1',user='root',passwd='root',db='test_3',port=6669,use_unicode=True, charset= "utf8")
Cur=conn.cursor ()
Ret=cur.execute (sql)
Result=cur.fetchall ()
Num_fields = len (cur.description)
Field_names = [I [0] for i in cur.description]
Print field_names
For row in result:
Print row [0], "|", row [1], "|", row [2], "|", row [3], "|", row [4], "|", row [5], "|", row [6], "|, row [7]," | ", row [8]," | ", row [9]," | ", row [10]
Cur.close ()
Conn.close ()
Except MySQLdb.Error,e:
Print "Mysql Error% d:% s"% (e.args [0], e.args [1])
Return result [1] [4] .split ("\ n")
# cd.. # return to the previous level
#. / run.py runserver-- host 192.168.137.38 & # your own server ip
# vim / etc/sysconfig/iptables # Open Port 3306P5000
-An INPUT-m state-- state NEW-m tcp-p tcp-- dport 3306-j ACCEPT
-An INPUT-m state-- state NEW-m tcp-p tcp-- dport 5000-j ACCEPT
# service iptables restart
