SFS3@CENTOS 7.2 環境建置懶人包 By資網中心曾文芳

SFS3@CENTOS 7.2 環境建置懶人包

• 引言回覆

文章由 資網中心曾文芳(infodaes) » 2016年 2月 4日, 08:55

#買地：安裝 CENTOS 7

cat /etc/redhat-release
ip addr
df


#整地：安裝需要的指令與設定環境

yum update -y
yum install mlocate wgetzip unzip ntpdate -y
updatedb
ntpdate time.stdtime.gov.tw | hwclock -w

crontab -e
-------------------------------------------------------------
0 1 * * * yum update -y
15 1 * * * ntpdate time.stdtime.gov.tw | hwclock -w
-------------------------------------------------------------

vi /etc/sysconfig/selinux
-------------------------------------------------------------
SELINUX=disabled
-------------------------------------------------------------
setenforce 0

#蓋樓：安裝SFS3所需的執行環境

yum install httpd mariadb mariadb-server php php-gd php-mbstring php-mysql -y

systemctl start httpd.service
systemctl enable httpd.service
systemctl start mariadb.service
systemctl enable mariadb.service

systemctl status httpd.service
systemctl status mariadb.service

php -v
mysql -V

mysql_secure_installation


vi /etc/locale.conf
-------------------------------------------------------------
LANG="zh_TW.Big5“
-------------------------------------------------------------

vi /etc/httpd/conf/httpd.conf
-------------------------------------------------------------
Options Indexes FollowSymLinks 替換為 Options FollowSymLinks
AddDefaultCharset UTF-8 替換為 AddDefaultCharset big5
-------------------------------------------------------------

vi /etc/my.cnf
-------------------------------------------------------------
[mysqld]
default-storage-engine=MyISAM
-------------------------------------------------------------

vi /etc/php.ini
-------------------------------------------------------------
error_reporting = E_ALL & ~E_NOTICE
date.timezone = "Asia/Taipei“
short_open_tag = On
max_execution_time = 300
upload_max_filesize = 20M
post_max_size = 20M
-------------------------------------------------------------

yum install php-pear -y
yum install php-bcmath -y
pear -d preferred_state=beta install Crypt_DiffieHellman
pear install Crypt_CBC
yum install epel-release -y
yum install php-mcrypt -y

reboot




#接水接電：舊機學務系統移入

*** 瀏覽器測試!!

*** 使用winscp傳入 DB & HTML

*** SQL方式匯入 DB
mysqladmin -uroot -p create sfs3
mysql -uroot -p sfs3 < /root/XXX.sql

**** 以下僅適合原機系統資料庫編碼未曾更改
**** 如果有錯誤訊息 請嚐試 mysql -uroot -p --default-character-set=latin1 sfs3 < /root/XXX.sql

*** 創建專用資料庫連接帳號
mysql -uroot -p
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------
GRANT ALL ON sfs3.* TO 'sfs3'@'localhost' IDENTIFIED BY 'QAZWSX!@#';
flush privileges;
\q
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------


*** 修改SFS3的設定檔
vi /var/www/html/sfs3/include/config.php
----------------------------------------------------------------------
//程式根目錄
PATH
$SFS_PATH = "/var/www/html/sfs3";

//學務管理首頁程式 URL (設定時，保留最後的 "/" )
$SFS_PATH_HTML ="http://192.168.70.129/sfs3/";