網頁
-
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……russel053 2020-02-05
-
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>