MySQL + PHP upgrade procedure in old Linux system

When I try to play wordpress 3.3.1 blog with ckeditor-for-wordpress.3.6.2.5  plugin ,they requirement depends package version as below.

MySQL-5.0.95

PHP-5.2.4

But my Linux version CentOS 3.9 that was too old and cann't on-line insall such as packages. So, I determine to manual prepare/complie the requirement packages.

  • First, download the MySQL 5.0.95 package "MySQL-5.0.95-1.glibc23.src.rpm" from internet and execute below command.

$rpmbuild –rebuild MySQL-5.0.95-1.glibc23.src.rpm –target=i686

Before install the new MySQL, pre-remove all installed MySQL version first.

$rpm -ihv /usr/src/redhat/RPMS/i686/MySQL-*

$mysql_upgrade

$mysql -u root

mysql>create database wordpress;

mysql>GRANT ALL PRIVILEGES ON wordpress.* TO "admin"@"localhost" IDENTIFIED BY "password";

  • The php-5.2.4 depends libxml2-2.6.30, to download libxml2-2.6.30.tar.gz from internet and execute below command

$rpmbuild -tb libxml2-2.6.30.tar.gz

$rpm -Uhv /usr/src/redhat/RPM/i386/libxml*

  • Download php-5.2.4.tar.gz and unpackage it and execute below command.

$./configure '–host=i386-redhat-linux' '–build=i386-redhat-linux' '–target=i386-redhat-linux-gnu' '–program-prefix=' '–prefix=/usr' '–exec-prefix=/usr' '–bindir=/usr/bin' '–sbindir=/usr/sbin' '–sysconfdir=/etc' '–datadir=/usr/share' '–includedir=/usr/include' '–libdir=/usr/lib' '–libexecdir=/usr/libexec' '–localstatedir=/var' '–sharedstatedir=/usr/com' '–mandir=/usr/share/man' '–infodir=/usr/share/info' '–cache-file=../config.cache' '–with-config-file-path=/etc' '–with-config-file-scan-dir=/etc/php.d' '–enable-force-cgi-redirect' '–disable-debug' '–disable-rpath' '–enable-inline-optimization' '–with-bz2' '–with-db4=/usr' '–with-curl' '–with-exec-dir=/usr/bin' '–with-freetype-dir=/usr'  '–with-gd' '–enable-gd-native-ttf' '–with-ttf' '–with-gettext' '–with-ncurses' '–with-gmp' '–with-iconv' '–with-jpeg-dir=/usr' '–with-openssl' '–with-pspell' '–with-regex=system' '–with-zlib' '–with-layout=GNU' '–enable-bcmath' '–enable-exif' '–enable-ftp' '–enable-magic-quotes' '–enable-safe-mode' '–enable-sockets' '–enable-sysvsem' '–enable-sysvshm' '–enable-discard-path' '–enable-wddx' '–enable-mbregex' '–with-kerberos=/usr/kerberos' '–with-mysql' '–with-unixODBC=shared,/usr' '–enable-shmop' '–enable-calendar' '–with-apxs2filter=/usr/sbin/apxs' '–with-pcre-regex' '–with-pear'
$make
$make install

  • Configure http.conf and start httpd service by below command

$vi /etc/httpd/conf/httpd.conf  # Check/Add below lines.
LoadModule php5_module        /usr/lib/httpd/modules/libphp5.so
DirectoryIndex index.html index.html.var index.php
AddType application/x-httpd-php  .php  .phtml
AddType application/x-httpd-php-source  .phps

$vi /etc/php.ini
[MySQL]
; Allow or prevent persistent links.
mysql.allow_persistent = On
; Maximum number of persistent links.  -1 means no limit.
mysql.max_persistent = -1
; Maximum number of links (persistent + non-persistent).  -1 means no limit.
mysql.max_links = -1
; Default host for mysql_connect() (doesn't apply in safe mode).
mysql.default_host =localhost
; Default user for mysql_connect() (doesn't apply in safe mode).
mysql.default_user =root
 
; Whether to allow HTTP file uploads.
file_uploads = On
; Temporary directory for HTTP uploaded files (will use system default if not
; specified).
;upload_tmp_dir =
; Maximum allowed size for uploaded files.
upload_max_filesize = 2M
 

Download  wordpress 3.3.1 and ckeditor-for-wordpress.3.6.2.5, under /var/www/html to unzip wordpress-3.3.1.zip then change to wordpress/wp-content/plugins/ and unzip ckeditor-for-wordpress.3.6.2.5.

$chown -R apache:apache /var/www/html/wordpress
$chmod -R 775 /var/www/html/wordpress

Download ckfinder to /var/www/html and unzip it, change to ckfinder and vi config.php then add below lines.
32:return true;
63:$baseUrl = '/ckfinder/upload/';
$chown -R apache:apache /var/www/html/ckfinder
$chmod -R 755 /var/www/html/ckfinder
$vi /var/www/html/wordpress/wp-content/plugins/ckeditor-for-wordpress/ckeditor.config.js #add below lines

config.filebrowserBrowseUrl = '/ckfinder/ckfinder.html';
config.filebrowserImageBrowseUrl = '/ckfinder/ckfinder.html?Type=Images';
config.filebrowserFlashBrowseUrl = '/ckfinder/ckfinder.html?Type=Flash';
config.filebrowserUploadUrl = '/ckfinder/core/connector/php/connector.php?command=QuickUpload&type=Files'; //support upload normal file
config.filebrowserImageUploadUrl = '/ckfinder/core/connector/php/connector.php?command=QuickUpload&type=Images';//support upload image
config.filebrowserFlashUploadUrl = '/ckfinder/core/connector/php/connector.php?command=QuickUpload&type=Flash';//support upload Flash file

 

Open you Web browser to http://<server ip>/wordpress/wp-admin/install.php

Below data will need to typing following the wordpress page prompt.

DB_NAME 
The name of the database you created for WordPress in Step 2 .
DB_USER 
The username you created for WordPress in Step 2.
DB_PASSWORD 
The password you chose for the WordPress username in Step 2.
DB_HOST 
The hostname you determined in Step 2 (usually localhost, but not always; see some possible DB_HOST values). If a port, socket, or pipe is necessary, append a colon (:) and then the relevant information to the hostname.
DB_CHARSET 
The database character set, normally should not be changed (see Editing wp-config.php).
DB_COLLATE 
The database collation should normally be left blank (see Editing wp-config.php).

 

 

 

 

 

 

 

 

 

 

Read more

How to document Home Lab and Network

運維機房和跨域的網路,會遇到各式需求與問題,用對工具才能分析問題,個人覺得最重要的是使用能處理問題的工具。 推薦目前想學和正在使用的平台與軟體,協助將公司/家用機房文件化 佈告欄任務管理 Focalboard 白板可管理任務指派 網路架構文件編寫 netbox 精細管理網路設備與連接線路 IP 資源管理 phpipam 專注網路IP分配 邏輯塊文件編寫 draw.io 視覺化概念圖 機房設備管理 ITDB 管理設備生命週期與使用者

By Phillips Hsieh

如何在Raspberry Pi4上安裝Proxmox for ARM64

第一步 準備好Raspberry Pi 4 / CM4 4GB RAM,這裡要留意CM4如果是買有內建eMMC storage會限制不能使用SD卡開機而限制本地空間容量,如果沒有NAS外接空間或使用USB開機的話,建議買CM4 Lite插上大容量SD卡 第二步 去Armbian官網下載最小化Debian bookworm image https://www.armbian.com/rpi4b/ Armbian 25.2.2 Bookworm Minimal / IOT 然後寫入SD/USB開機碟,寫入方法參考官方文件 https://github.com/raspberrypi/usbboot/blob/master/Readme.md Note: 官方提供的預先設定系統方法,可以在Armbian初次啟動自動化完成系統設定。連結在此 https://docs.armbian.com/User-Guide_Autoconfig/

By Phillips Hsieh

世界越快心越慢

在晚飯後的休息時間,我特別享受在客廳瀏灠youtube上各樣各式創作者的影音作品。很大不同於傳統媒體,節目多是針對大多數族群喜好挑選的,在youtube上我會依心情看無腦的動畫、一些旅拍記錄、新聞時事談論。 尤其在看了大量的Youtube的分享後,我真的感受到會限制我的是我的無知,特別是那些我想都沒想過的實際應用,在學習後大大幫助到我的生活和工作層面。 休息在家時,我喜歡想一些沒做過的菜,動手去設計生活和工作上的解決方案,自己是真的很難閒著沒事做。 如創作文章,陪養新的習慣都能感覺到成長的喜悅,是不同於吃喝玩樂的快樂的。 創作不去限制固定的形式,文字是創作、影像聲音也是創作,記錄生活也是創作,我想留下的就是創造—》實現—》回憶,這樣子的循環過程,在留下的足跡面看到自己一路上的成長、失敗、絕望、重新再來。 雖然大部份的時候去做這些創作也不明白有什麼特別的意義,但不去做也不會留下什麼,所以呀不如反事都去試試看,也許能有不一樣的水花也許有意想不到的結果,投資自己永遠不會是失敗的決定,不是嗎?先問問自己再開始計畫下一步,未來沒人說得準。 像最近看youtube仍大一群人在為DOS開

By Phillips Hsieh

知識管理的三個步驟:一小時學會把知識運用到生活上

摘錄瓦基「閱讀前哨站」文章作為自己學習知識管理的內容 Part1「篩選資訊」 如何從海量資訊中篩選出啟發性、實用性和相關性的精華,讓你在學習過程中不再迷失方向。 1. 實用性 2. 啟發性 Part2「提高理解」 如何通過譬喻法和應用法,將抽象的知識與日常生活和工作緊密結合,建立更深刻的理解。 1. 應用法 2. 譬喻法 Part3「運用知識」 如何連結既有知識,跟自己感興趣的領域和專案產生關聯,讓你在運用知識的路途上游刃有餘。 1. 跟日常工作專案、人際活動產生連結 # 為什麼要寫日記? * 寫日記是為了忘記,忘卻瑣碎事情,保持專注力 * 寫日記就像在翻譯這個世界,訓練自己的解讀能力 * 不只是透過日記來記錄生活,而是透過日記來發展生活 #如何寫日記? * 不要寫流水帳式的日記,而是寫覆盤式的日記 當我們試著記錄活動和感受之間的關聯,有助於辦認出真正快樂的事 日記的記錄方式要以過程為主,而非結果 * 感恩日記的科學建議,每日感恩的案例

By Phillips Hsieh