Zen Path Migration (windows_to_linux)

Demand analysis

With the increase of Zen data, the MySQL server provided by virtual machine could not keep pace with the demand. And the original Zen Road front end and database separation installed in Windows and Linux, now provide physical server, need to move the Zen Road environment.

Confirm Environment Information

ip	system version	sql version	role
192.168.1.249	CentOS 6.4	5.6.28- Log MySQL	old server
192.168.35.130	CentOS 7.2	10.1.22-mariadb	New server

Steps to install the same version of Zen Road in Linux Server one-click installation package

• Unzip to opt directory TAR-ZXVF zentaopms.9.6.2.zbox_64.tar.gz-c/opt

• Apache and MySQL Start-stop

  • Execute the/opt/zbox/zbox start command to open Apache and MySQL.
  • Execute the/opt/zbox/zbox stop command to stop Apache and MySQL.
  • Execute the/opt/zbox/zbox restart command to restart Apache and MySQL.
  • /opt/zbox/zbox-ap 8080-MP 3307
    • AP parameter can modify Apache port
    • MP parameter to modify the MySQL port
  • If you need to start the boot automatically, you can add the/opt/zbox/zbox restart to the operating system's self-starter directory.

Restore data

• Upload a Windows attachment (zentao\www\data\upload\1) backup to a Linux server, overwriting the appropriate directory file,/OPT/ZBOX/APP/ZENTAO/WWW/DATA/UPLOAD/1
• Export data (old database)
  • $/usr/local/mysql/bin/mysqldump-s/data/mysql/mysql3307/tmp/mysql.sock-h192.168.1.249-master-data=2- Single-transaction-default-character-set=utf8-uroot-p Zentao > Zentao.sql

  • Error:

    ERROR 1194 (HY000): Table ' Zt_file ' is marked as crashed and should be repaired

  • Workaround:

    REPAIR TABLEzt_file

• Import data (New database)
  • Mysql-u Root-p < Zentao.sql

Restart Service Zen Road use

• Access and Login Zen Trails

  • Once the Apache and MySQL services are launched, the browser accesses and logs into Zen Road directly by accessing the http://Zen Channel Server Ip:apache port.
  • Note: If the webpage is inaccessible, please turn off the firewall of the computer where Zen Tao is located and then refresh the page access by SELinux.
  • Zen Road Default Admin account is admin, password 123456.

• Zen Trail Database

  • Web Login database

    • Zen Path database management is Adminer, but for security, access to Adminer requires authentication and needs to run/opt/zbox/auth /adduser.sh to add users (cd/opt/zbox/auth/and then execute./adduser.sh)
    • Web Access to http:/Zen Lane Service IP Apache Port, click on the "Database Management" button has 2 layer authentication:
      • Popup validation is the input run Addusers.sh added username and password
      • Web page directly displays the login interface:
        • system: MySQL is selected by default.
        • server: 127.0.0.1:mysql port
        • user name: root
        • password: 123456
        • database: Zentao

  • Command line Connection Database

    • Login database:/opt/zbox/bin/mysql-u root-p mysql Port-P (example:/opt/zbox/bin/mysql-u root-p 3306-p)
    • Import Database:/opt/zbox/bin/mysql-u root-p MySQL Port-p to import the library name < Xxxx.sql (for example:/opt/zbox/bin/mysql-u root-p 3306-p Zentao < ; Zentao.sql)
    • Linux Database storage directory: Opt/zbox/data/mysql/zentao

?

Zen Path Migration (windows_to_linux)