分類: 網頁
Wordpress:DB 內網站網址批次修改
UPDATE wp_posts
SET post_content = REPLACE(post_content, 'www.abc.com', 'www.xyz.com')
WHERE post_content LIKE '%www.abc.com%';
UPDATE wp_posts……
phpMyAdmin:需要設定一組加密密碼 (blowfish_secret)修正方法
cd /usr/share/phpmyadmin/
cp config.sample.inc.php config.inc.php
nano config.inc.php
在以下地方新增32碼以上任意密碼:
$cfg['blowfish_secret'] = 'a……
phpMyAdmin:$cfg ['TempDir'](/usr/share/phpmyadmin/tmp)無法存取修正方式
mkdir /usr/share/phpmyadmin/tmp
chmod 777 /usr/share/phpmyadmin/tmp/
smokeping 安裝與 smokeping_prober 服務建立
安裝 smokeping:
apt install smokeping
建立 smokeping_prober >> smokeping_prober
Nginx 反向代理 conf:
server {
listen 80;
server_name……
Nextcloud:啟用 MySQL 4-byte 支援
nano /etc/mysql/mariadb.conf.d/50-server.cnf
MariaDB 10.3 或更新的版本
[mysqld]
innodb_file_per_table=1
MariaDB 10.2 或更舊的版本
[mysqld]
innodb_……
Nextcloud:系統詳細設定
在 /var/www/example.com/config/config.php 加入：
'memcache.local' => '\OC\Memcache\APCu'
'filesystem_check_changes' => 1,
'check_data_direct……
Nextcloud:關閉外掛App
到nextcloud所屬目錄
cd /var/www/nextcloud
執行禁用App
sudo -u www-data php occ app:disable <APP名稱>
Moodle 網站架設
安裝基礎 Nginx + PHP7.2-FPM+MariaDB
要額外安裝以下套件:
apt install php7.2-soap
下載Moodle:
wget https://download.moodle.org/stable35/moodle-lates……
hexonet.net DNSSEC API Setting
command = ModifyDomain
domain = ______________.com
secDNS-ds0 = 2371 13 2 B24________________________53E9735____________594AED4CEE
Nginx: reverse proxy conf
include proxy_params;
proxy_http_version 1.1;
proxy_set_header Upgrade $http_upgrade;
proxy_set_header Connection "upgrad……
修正mysql-ERROR 1698 (28000): Access denied for user 'root'@'localhost'
sudo mysql -u root
MariaDB [mysql]>GRANT ALL PRIVILEGES ON *.* TO 'root'@'web.server.ip.address';
MariaDB [mysql]>GRANT USAGE ON *.* TO 'roo……
PHP:Nextcloud與Collabora CODE 非英文檔名無法開啟解法
nano /etc/php/7.2/fpm/php.ini
找到: disable_functions 將 pcntl_wtermsig 註解掉即可
or
----------------------------
<優先建議使用>
在Nextcloud……
Nginx:Security Header Setting
nano /etc/nginx/nginx.conf
user www-data;
worker_processes auto;
pid /run/nginx.pid;
include /etc/nginx/modules-enabled/*.conf;
events {
wor……
Nginx :proxy_headers_hash_max_size 解決方法
Nginx錯誤
[emerg]: could not build the proxy_headers_hash, you should increase either proxy_headers_hash_max_size: 512 or proxy_headers_hash_bucket_……
Let's Encrypt DNS 簽證
安裝Cert-bot:
sudo apt-get update
sudo apt-get install software-properties-common
sudo add-apt-repository ppa:certbot/certbot
sudo apt-get update……
BookStack Menual installation(Nginx)
LNMP 先建立完成後安裝git/composer/php-tidy:
apt install git composer php-tidy
先移動到要存放的位置:
cd /var/www
安裝完成之後git clone 官方原版或者節……
Nginx Reverse Proxy with SSL Example
server {
listen 443 ssl;
server_name example.com;
ssl_certificate /etc/letsencrypt/live/example.com/fullchain.pem;
ssl_c……
PHP 7啟用Zend-Opcache
啟用Zend Opcache
nano /etc/php/7.2/fpm/php.ini
or
nano /etc/php/7.2/fpm/conf.d/10-opcache.ini
zend_extension=opcache.so
opcache.enable=1
opcache.e……
Wordpress: 禁用 xmlrpc.php 防止攻擊
nano /web path/.htaccess 增加:
<Files xmlrpc.php>
order deny,allow
deny from all
</Files>