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……

pfSense ddns後無法登入處理方式

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>