Debian Chroot on DSM

Debian Chroot on DSM

|, , , |科技資訊

Use Debian chroot instead of ipkg (optware) on DSM 5.0. Here is a installation notes of XPEnology on HP N36L Prerequisite: add custom source:  Package Centre > Settings > Package Sources Name: SynoCommunity Location:  https://synocommunity.com/packages  Readme: https://github.com/SynoCommunity/spksrc/blob/develop/spk/debian-chroot/src/app/help/enu/index.html Installation: – required python on SynoCommunity, DSM default python not OK. – select Debian Chroot and click install – after installation completed, ssh to DSM as root root@diskstation> /var/packages/debian-chroot/scripts/start-stop-status chroot bash: warning: setlocale: LC_ALL: cannot change locale (en_US.utf8) root@diskstation:/# – now under chroot ##backup and update source list. e.g. from France to Australia ##see https://www.debian.org/mirror/list sed -i.`date +%Y%m%d` ‘s/fr.debian.org/au.debian.org/g’ /etc/apt/sources.list aptitude update aptitude upgrade aptitude install locales dpkg-reconfigure locales dpkg-reconfigure tzdata aptitude install less vim curl rsync screen openssh-server – enable home for users: Control Panel > User > Advance, “Enable user home services”, Apply. ls -al /var/services/homes  symbolic link updated and pointed correctly – some additional directories want to be mount by startup script # diff -u /var/packages/debian-chroot/scripts/start-stop-status — start-stop-status.org +++ start-stop-status @@ -20,6 +20,16 @@ grep -q “${CHROOTTARGET}/dev ” /proc/mounts || mount -o bind /dev ${CHROOTTARGET}/dev grep -q “${CHROOTTARGET}/dev/pts ” /proc/mounts || mount -o bind /dev/pts ${CHROOTTARGET}/dev/pts + grep -q “${CHROOTTARGET}/home ” `realpath /var/services/homes` || mount -o bind `realpath /var/services/homes` ${CHROOTTARGET}/home + + [ ! -d ${CHROOTTARGET}/volume2 ] && mkdir -p ${CHROOTTARGET}/volume2 + grep -q “${CHROOTTARGET}/volume2 ” /volume2 || mount -o bind /volume2 ${CHROOTTARGET}/volume2 + # Start all services ${INSTALL_DIR}/app/start.py fi @@ -35,6 +45,11 @@ umount ${CHROOTTARGET}/dev umount ${CHROOTTARGET}/sys umount ${CHROOTTARGET}/proc + + umount ${CHROOTTARGET}/home + umount ${CHROOTTARGET}/volume2 } daemon_status () – setup users on debian …

Read more »

MySql 中文亂碼 utf8 latin1

|生活記事, 科技資訊

話說2008 年搬家既時候, 由LifeType upgrade 去WordPress, 因為MySQL database default latin1 既關係, 有很多comment 亂碼. 當時只有文章有backup, comment 已經 dump 左落.sql file, 唔識搞. 最近Google 其他野冇意間見到有關encoding, 終於救返了. ============================== e.g. backup.sql 有鬼畫符的文字：è€è±†ä½ åƒåŠ é›»ç®—ç›ƒå‘€???? 1. create database / tables, default collation utf8_generic_ci 2. import data $ mysql -u user -ppassword < backup.sql 3. export again as latin1 $ mysqldump -u user -ppassword -B dbName –tables plog_articles_comments –default-character-set=latin1 > comments-latin1.sql 4. replace all “latin1” to “utf8” cp  comments-latin1.sql  comments-utf8.sql sed -i -e “s/latin1/utf8/g” comments-utf8.sql 5. final import back $ mysql -u user -ppassword –default-character-set=utf8 < comments-utf8.sql    

Read more »
...10...14151617...40...