数据中心资产管理系统RackTables.zip

# Welcome! Thank you for selecting RackTables as your datacenter management solution! If you are looking for documentation or wish to send feedback, please look for the respective links at [project's web-site](http://racktables.org). # How to install RackTables ## 1. Prepare the server RackTables uses a web-server with PHP (5.5.0 or newer) for front-end and a MySQL/MariaDB server version 5 for back-end. The most commonly used web-server for RackTables is Apache httpd. ### 1.1. Install MySQL server | Distribution | How to do | | ------------------ | ----------------------------------------------------------------------- | | Debian 6 | `aptitude install mysql-server-5.1` | | Debian 7 | `aptitude install mysql-server-5.1` | | Fedora 8-16 | `yum install mysql-server mysql` | | Fedora 23-26 | `dnf install mariadb-server mariadb` | | FreeBSD 10 | `pkg install mysql56-server` | | openSUSE 42.1 | `zypper install mysql-community-server` | | Scientific Linux 6 | `yum install mysql-server mysql` | | Ubuntu 14.04 | `apt-get install mysql-server` | | Ubuntu 16.04 | `apt-get install mysql-server` | ### 1.2. Enable Unicode in the MySQL server | Distribution | How to do | | ------------------ | ------------------------------------------------------------------------------------------------------------------ | | Debian 6 | add `character-set-server=utf8` line to `[mysqld]` section of `/etc/mysql/my.cnf` file and restart mysqld | | Debian 7 | add `character-set-server=utf8` line to `[mysqld]` section of `/etc/mysql/my.cnf` file and restart mysqld | | Fedora 8-16 | add `character-set-server=utf8` line to `[mysqld]` section of `/etc/my.cnf` file and restart mysqld | | Fedora 23-26 | ```printf "[mysqld]\ncharacter-set-server=utf8\n" > /etc/my.cnf.d/mysqld-charset.cnf; systemctl restart mariadb``` | | openSUSE 42.1 | No action required, comes configured for UTF-8 by default. | | Scientific Linux 6 | add `character-set-server=utf8` line to `[mysqld]` section of `/etc/my.cnf` file and restart mysqld | | Ubuntu 14.04 | ```printf "[mysqld]\ncharacter-set-server=utf8\n" > /etc/mysql/conf.d/charset.cnf; service mysql restart``` | | Ubuntu 16.04 | ```printf "[mysqld]\ncharacter-set-server=utf8\n" > /etc/mysql/conf.d/charset.cnf; service mysql restart``` | ### 1.3. Install PHP and Apache httpd (or nginx) | Distribution | How to do | | ------------------ | ------------------------------------------------------------------------------------ | | Debian 6 | `aptitude install libapache2-mod-php5 php5-gd php5-mysql php5-snmp` | | Debian 7 (nginx) | `aptitude install nginx php5-fpm` **(see note below)** | | Fedora 8-16 | `yum install httpd php php-mysql php-pdo php-gd php-snmp php-mbstring php-bcmath` | | Fedora 23 | `dnf install httpd php php-mysql php-pdo php-gd php-snmp php-mbstring php-bcmath` | | Fedora 26 | `dnf install httpd php php-mysqlnd php-pdo php-gd php-snmp php-mbstring php-bcmath` | | FreeBSD 10 | see note 1.3.c | | openSUSE 42.1 | `zypper install apache2-mod_php5 php5-gd php5-mbstring php5-mysql php5-bcmath` | | Scientific Linux 6 | `yum install httpd php php-mysql php-pdo php-gd php-mbstring php-bcmath` | | Ubuntu 14.04 | `apt-get install apache2-bin libapache2-mod-php5 php5-gd php5-mysql php5-snmp` | | Ubuntu 16.04 | `apt-get install apache2-bin libapache2-mod-php7.0 php7.0-gd php7.0-mysql php7.0-mbstring php7.0-bcmath php7.0-json php7.0-snmp` #### 1.3.a. Debian 7 with nginx Remember to adjust `server_name` in `server {}` section, otherwise your logout link will point to localhost (and thus fail). Notice that fpm.sock is advised, keep the rest on default configuration, or tweak to your needs. You may need to set `fastcgi_read_timeout 600;` if you use some external addons like fping, which may take some time in certain situations. Please note that setting aggresive caching for php scripts may result in stale content - so maximum of 60 seconds is advised, but by default it is not enabled. #### 1.3.b. [redacted] #### 1.3.c. FreeBSD 10 There are 3 different ways how you can install RackTables and its dependencies on FreeBSD. ######A. use pkg (Binary Package Management) (not always the newest version) ``` # pkg install racktables # pkg install mod_php56 mysql56-server ``` As of March 2017 this will install RackTables Version 0.20.11 and its dependencies (php 5.6, mysql-server 5.6 and apache 2.4). ######B. use the ports system (possibly more recent than pkg) ``` # cd /usr/ports/sysutils/racktables # make install # pkg install mod_php56 mysql56-server ``` As of March 2017 this will install RackTables Version 0.20.11 and build and install its dependencies (php 5.6, mysql-server 5.6 and apache 2.4). ######C. manual (newest version) Install dependencies with pkg: ``` # pkg install php70-bcmath php70-curl php70-filter php70-gd php70-gmp php70-json php70-mbstring php70-openssl php70-pdo php70-pdo_mysql php70-session php70-simplexml php70-snmp php70-sockets # pkg install mod_php70 mysql56-server ``` unpack tar.gz/zip archive to `/usr/local/www` symlink racktables dir ``` # cd /usr/local/www # ln -s RackTables-0.20.xx racktables ``` ##### Common install steps Apache users should create a racktables.conf file under their apache Includes directory with the following contents: ``` AddType application/x-httpd-php .php AddType application/x-httpd-php-source .phps <Directory /usr/local/www/racktables/wwwroot> DirectoryIndex index.php Require all granted </Directory> Alias /racktables /usr/local/www/racktables/wwwroot ``` Start services: ``` #echo 'apache24_enable="YES"' >> /etc/rc.conf #service apache24 start #echo 'mysql_enable="YES"' >> /etc/rc.conf #service mysql-server start ``` Browse to http://address.to.your.server/racktables/index.php and follow the instructions. Note: set `secret.php` permissions when prompted. ``` # chown www:www /usr/local/www/racktables/wwwroot/inc/secret.php # chmod 400 /usr/local/www/racktables/wwwroot/inc/secret.php ``` ## 2. Copy the files Unpack the tar.gz/zip archive to a directory of your choice and configure Apache httpd to use `wwwroot` subdirectory as a new DocumentRoot. Alternatively, symlinks to `wwwroot` or even to `index.php` from an existing DocumentRoot are also possible and often advisable (see `README.Fedora`). ## 3. Run the installer Open the configured RackTables URL and you will be prompted to configure and initialize the application. | Distribution | Apache httpd UID:GID | MySQL UNIX socket path | | --------------- | ----------------------- | -------------------------------- | | Fedora 23-26 | `apache:apache` | `/var/lib/mysql/mysql.sock` | | openSUSE 42.1 | `wwwrun:www` | `/var/run/mysql/mysql.sock` | | Ubuntu 14.04 | `www-data:www-data` | `/var/run/mysqld/mysqld.sock` | | Ubuntu 16.04 | `www-data:www-data` | `/var/run/mysqld/mysqld.sock` | # How to upgrade RackTables 0. **Backup your database** and check th