My World & ALL World

java servlet printing from intranet printer on Debian

2023-10-15T22:27:00.000+08:00

apt-get install cups cups-bsd

cups-bsd contain lpr command

lpstat -p

lpadmin -d printername // set default printer

postgresql replication with docker-compose in AS1102T

2023-05-28T22:16:00.004+08:00

docker-compose.yml

 
version: '2'

services:
  postgresql-slave:
    image: 'postgres:13'
    ports:
      - '5433:5433'
    environment:
      - POSTGRES_USERNAME=postgres
      - POSTGRES_PASSWORD=password
    volumes:
      - ../postgresql/data:/var/lib/postgresql/data

    networks:
      - disable_ipv6


networks:
  disable_ipv6:
    external: true

postgresql-master


    su postgres     psql -p 5433 
    CREATE USER replicator WITH REPLICATION ENCRYPTED PASSWORD 'password'; 
    SELECT * FROM pg_create_physical_replication_slot('replication_slot_slave1');

 postgresql.conf: 
     wal_level = replica 
 pg_hba.conf: 
     host    replication     replicator      0.0.0.0/0               trust

postgresql-slave
exec docker-compose


    docker-compose exec -it postgresql-slave bash 
    cd /var/lib/postgresql/data  

    postgresql.conf: 
       wal_level = replica 
       primary_conninfo = 'user=replicator password=password channel_binding=prefer host=masterip port=5433 sslmode=prefer sslcompression=0 ssl_min_protocol_version=TLSv1.2 gssencmode=prefer krbsrvname=postgres target_session_attrs=any'
       primary_slot_name = 'replication_slot_slave1'

       hot_standby = on 
       restore_command = 'cp /var/lib/postgresql/data/pg_wal/%f "%p"' 
    mkdir masterdata 
    cd masterdata 
    pg_basebackup -h masterip -U replicator -p 5433 -D ./  -Fp -Xs -P -R -W 
    exit 
    docker-compose stop 
    postgresq/data: 
        mv *.conf ../ 
        mv masterdata ../ 
        rm -rf * 
        mv ../*.conf ./ 
        mv masterdata/* ./ 
    docker-compose start

postgresql-master


    su postgres 
    psql -p 5433 
    select * from pg_stat_replication;
    SELECT * FROM pg_replication_slots;

Debian apt-get update with error: timeout was reached

2023-05-24T09:12:00.003+08:00

記得那時有多一顆硬碟就把/var另外備份到多的硬碟再重新掛載。結果有一天硬碟掛了，舊有的/var資料比較舊、dpkg都亂了。只好強制升級，跑完升級後都會出現error: timeout was reached。

勉強撐過一段時間之後終於有時間來找找解決辦法，東找找西找找最後發現沒裝packagekit，apt-get install packagekit之後就沒看見錯誤了。

Openwrt with RAIDON-BX32N(SL3650-LB2)

2023-05-16T21:41:00.002+08:00

升級檔案->https://github.com/phchshow/openwrt-raidon-bx32n

前幾個禮拜突然想到很久之前買的儲存設備閒置，本來想趁著SSD便宜組個RAID1玩一下。結果設備有點舊，雖然在官網上可以找到升級檔，但是一樣舊，kernel版本只有2.6.31。

本來想說修改升級檔讓admin取得root權限就好，順便跑跑debootstrap裝個minidlna發揮最後的殘值。但是還是有點不甘心，只好靠著幾年之前有稍微研究Android 2.3時有買uart的USB設備來碰碰運氣，明明看其他oxnas的只需要插三個pin。但是我用就沒辦法看到，只好去找先前是買什麼，才看到買的供電要由設備端供應，拿出三用電錶也只確認接地，一陣亂插之下運氣不錯可以看到uboot開機資訊。結果沒辦法輸入，後來東碰碰西碰碰另外兩條線碰在一起就可以輸入了，整個傻眼。

原先想用其他oxnas版本來碰碰運氣看能不能直升，結果分區都不一樣，只能再研究研究怎麼編Openwrt，一研究就是好幾天，畢竟不是本科，靠著一些薄弱的知識東找西找總算是能夠生出一個穩定版本的Openwrt。不過也只限定在硬碟跟USB算穩定，LED燈跟風扇不知道怎麼控制。應該是i2c跟gpio，電路板也看不懂，有時間再來學習。

最後雖然可以跑新的kernel，卻又受限在設備是32位元的，本來想跑Postgresql replication卻跑不了，再來想想能跑什麼服務。

compile tiap_drv.ko

2013-06-28T22:46:00.003+08:00

make -C system/wlan/ti/WiLink_AP/platforms/os/linux KERNEL_DIR= $(KERNEL) ARCH="arm" CROSS_COMPILE="$(ANDROID_BUILD_TOP)/prebuilt/linux-x86/toolchain/arm-eabi-4.4.3/bin/arm-eabi-" HOST_PLATFORM="zoom2" REPORT_LOG=n

ramdisk and devtree for flipout

2013-02-25T11:37:00.002+08:00

ramdisk:
./split_bootimg.pl CG35.smg
mkdir ramdisk
cd ramdisk
gzip -dc ../CG35.smg-ramdisk.gz | cpio -i

to new ramdisk:
find . | cpio -o -H newc | gzip > ../newramdisk

devtree:
apt-get install device-tree-compiler
get device-tree directory from phone /proc
dtc -f -I fs -O dtb -o devtree device-tree

reference: ramdisk:xda

ruth(MB511) device configure files for CM7, update rom status: RC Version 5

2013-01-29T21:34:00.002+08:00

My ROM VERSION:
RUTEM_U3_01.14.16_DEBLUR_SIGNED_USARUTH15ND0RTINT056.0R_PDS000_USARUTHEHKTWEMARA_P011_A010_HWp3_1FF.sbf

RC version 5: v0.7.4
configure sources
gapps.zip

NOTICE:If you want update fix zip, you should use bootmenu to update.When boot at motologo,click click and click "vol -" to enter bootmenu.

->because bootmenu executed by mot_boot_mode, so /system can't umount, only can remount.

--and update zip have to modify updater-script, remount /system.

can work:

camera

battd

fmradio

bluetooth

gps

sensors

usb connect

audio

half work:

video

-> 720p has problem.

wifi

->no softap.

ril

->I only use 2G service, so I can't test 3G.

flipout(rooted) I/O scheduler recompile module of deadline and sio(update)

2012-12-25T22:33:00.000+08:00

download:deadline-iosched.ko
sio-iosched.ko

flipout(rooted) overclock and drop voltage

2012-12-24T21:49:00.000+08:00

insmod /system/lib/modules/overclock.ko[1] omap2_clk_init_cpufreq_table_addr=0xc00505b4
~~echo 50 > /proc/overclock/max_vsel~~
~~echo 800000 > /proc/overclock/max_rate~~

~~echo "1 600000" > freq_table~~
~~echo "2 400000" > freq_table~~
~~echo "3 200000" > freq_table~~
~~echo "4 125000" > freq_table~~

~~echo "1 125000000 16" > /proc/overclock/mpu_opps~~
~~echo "2 200000000 20" > /proc/overclock/mpu_opps~~
~~echo "3 400000000 30" > /proc/overclock/mpu_opps~~
~~echo "4 600000000 40" > /proc/overclock/mpu_opps~~

unstable~~[update]~~

~~echo 52 > /proc/overclock/max_vsel~~
~~echo 875000 > /proc/overclock/max_rate~~

~~echo "1 675000" > /proc/overclock/freq_table~~
~~echo "2 475000" > /proc/overclock/freq_table~~
~~echo "3 275000" > /proc/overclock/freq_table~~
~~echo "4 200000" > /proc/overclock/freq_table~~

~~echo "1 200000000 18" > /proc/overclock/mpu_opps~~
~~echo "2 275000000 22" > /proc/overclock/mpu_opps~~
~~echo "3 475000000 32" > /proc/overclock/mpu_opps~~
~~echo "4 675000000 42" > /proc/overclock/mpu_opps~~

[update]

echo 50 > /proc/overclock/max_vsel
echo 800000 > /proc/overclock/max_rate

echo "1 600000" > /proc/overclock/freq_table
echo "2 400000" > /proc/overclock/freq_table
echo "3 300000" > /proc/overclock/freq_table
echo "4 200000" > /proc/overclock/freq_table

echo "1 200000000 20" > /proc/overclock/mpu_opps
echo "2 300000000 25" > /proc/overclock/mpu_opps
echo "3 400000000 30" > /proc/overclock/mpu_opps
echo "4 600000000 40" > /proc/overclock/mpu_opps

reference:[1]milestone-overclock

steam on debian wheezy(x86_64) with ATI HD4650, play TF2.

2012-12-22T22:36:00.001+08:00

add i386 architecture
#dpkg --add-architecture i386

use "Steam installer for Debian"[1]
#./steam_bootstrap.sh

use LD_DEBUG=libs to check i386 libs
# LD_DEBUG=libs steam

use ATI closed driver[2]

the question of "GL_EXT_texture_sRGB_decode", solved[3]

reference:[1]
[2]
[3]

cpulimit flipout(rooted)

2012-12-21T22:51:00.001+08:00

limit cpu usage for flipout

recompile for flipout

source:cpulimit

download:cpulimit

flipout(MB511) sensors

2012-10-21T22:42:00.000+08:00

/dev/akm8973_aot
/dev/kxtf9
/dev/sfh7743

hbootmod ko file and hbootuser file with kernel version 2.6.29-omap1 preempt mod_unload ARMv7

2012-10-10T22:41:00.000+08:00

https://github.com/nadlabak/2ndboot

hbootmod.ko
hbootuser

update:
https://github.com/czechop/2ndboot

2ndboot.ko

My Openbox theme 'TheLunarCycle' with LXDE

2012-10-05T14:17:00.002+08:00

about designed concept:
iconify-> show the lunar eclipse
max-> show half moon
max_toggled-> show full moon
close->show sun

close_hover:

iconify_hover:

max_toggled(left to right, Lunar eclipse, Full moon, Sun):

max(left to right, Lunar eclipse, Half Moon, Sun):

max_hover:

max_toggled_hover:

Download:
TheLunarCycle.obt

flipout (rooted), conservative and powersave module of cpufreq

2012-09-10T22:20:00.001+08:00

flipout has no compiled conservative and powersave of cpufreq in kernel.
but we can use compile kernel for modules.

module files:
cpufreq_conservative.ko
cpufreq_powersave.ko

BTW: flipout must be rooted.

asus rt-n16 pppoe with jdownloader reconnect

2012-07-23T13:37:00.001+08:00

#!/usr/bin/expect
spawn telnet 192.168.1.1
expect login:
send admin\r
expect Password:
send admin\r
send "killall pppd &\r"
send "nohup /usr/sbin/pppd file /tmp/ppp/options.wan0 nodetach &\r"
send exit\r
interact

save as a script file, than jdownloader can use it to reconnect.

CM7 OMAP3 libaudio.so alsa-sound

2012-06-01T22:04:00.002+08:00

BoardConfig.mk:

BOARD_USES_ALSA_AUDIO := true
BUILD_WITH_ALSA_UTILS := true

reference:http://processors.wiki.ti.com/index.php/TI-Android-GingerBread-2.3.4-DevKit-2.1.1_PortingGuides

2nd-init recovery can't mount sdcard

2012-05-30T16:52:00.001+08:00

check /dev/block/mmcblk0 has exists
if not exists
# cd /dev/block/
# mknod mmcblk0 b 179 0
# mknod mmcblk0p1 b 179 1

reference:http://forum.cyanogenmod.com/topic/33179-problems-installing-71-recovery-cant-mount-sdcard/

xt502 CM7 z71 phone driver

2012-03-12T10:57:00.001+08:00

when xt502 with CM7, the device become to z71 phone,
XP can't recognition the driver,
so we can use Google USB Driver package to install the driver.

1. download android SDK
2. use Android SDK Manager
3. in Extras, install Goole USB Driver package
4. the driver data will generated at extras directory
5. edit android_winusb.inf
the drive identify should be VID_0489&PID_C001
add to x86 or amd64

;Z71
%SingleAdbInterface% = USB_Install, USB\VID_0489&PID_C001
%CompositeAdbInterface% = USB_Install, USB\VID_0489&PID_C001&MI_01
;
6.install android_winusb.inf

tuning MB511 with sysctl

2012-02-16T16:59:00.001+08:00

# white /system/etc/sysctl.conf

kernel.threads-max=4096 #max threads, smart phoen really use really use so much threads?
vm.swappiness = 0 #MB511 can't use swap, so...
vm.dirty_expire_centisecs=0
vm.dirty_writeback_centisecs=0
vm.min_free_kbytes = 4096 #keep minimum of 4MB idle space
~~vm.dirty_ratio = 90~~
~~vm.dirty_background_ratio = 70~~
~~vm.vfs_cache_pressure = 10~~
~~vm.panic_on_oom = 2~~
~~vm.oom_kill_allocating_task = 1~~ #use android memory manager
kernel.panic = 5 #Enabling kernel panic reboot
kernel.shmmax = 2147483648 #256MB
kernel.shmall = 16777216 #16MB

#userinit.sh
sysctl -p

echo "1536,2048,4096,8192,16384,24576" > /sys/module/lowmemorykiller/parameters/
minfree #use android memory manager

JUST FOR FUN!!

tuning MB511

2012-02-14T17:45:00.000+08:00

#write in userinit.sh
#use cgroup tuning cpu tasks, default init.rc can't write

busybox mkdir -p /dev/cgroup/cpu
busybox mount -t cgroup cgroup -o cpu /dev/cgroup/cpu
echo "/system/local/sbin/cgroup_clean" > /dev/cgroup/cpu/release_agent

busybox mkdir -m 0777 /dev/cgroup/cpu/bg_root
chown root.root /dev/cgroup/cpu/bg_root/tasks
chmod 0777 /dev/cgroup/cpu/bg_root/tasks
echo "500" > /dev/cgroup/cpu/bg_root/cpu.shares #root can get 50% cpu time?

busybox mkdir -m 0777 /dev/cgroup/cpu/bg_non_interactive
chown system.system /dev/cgroup/cpu/bg_non_interactive/tasks
chmod 0777 /dev/cgroup/cpu/bg_non_interactive/tasks
echo "200" > /dev/cgroup/cpu/bg_non_interactive/cpu.shares #system can get 20% cpu time ?

echo "1" > /dev/cgroup/cpu/notify_on_release
echo "1" > /dev/cgroup/cpu/bg_root/notify_on_release
echo "1" > /dev/cgroup/cpu/bg_non_interactive/notify_on_release

nice logcat > /system/sd/swap/$(date +%Y%m%d-%H).log & #save log
~~find /system/sd/swap -mtime +3 -name "*.log" -exec rm -rf {} \ #del over 3 days log~~
nice /data/local/Clear.sh &
nice /data/local/SCgroupTask.sh & //60s update tasks

#Clear.sh

#!/system/bin/sh
while [ true ]
do
echo 'start'
for file in `find /system/sd/logs -mtime +3 -name '*.log' -print 2>/dev/null`
do
rm $file
done

sleep 24h
done

#SCgroupTask.sh
-----
while [ true ]
do
ps | grep root | awk '{print $2}' > /dev/cgroup/cpu/bg_root/tasks #add root tasks to cgroup
ps | grep system\ | awk '{print $2}' > /dev/cgroup/cpu/bg_non_interactive/tasks #add system tasks to cgroup
sleep 60s
done
JUST FOR FUN!!

Android Install APK has out of memory on a 32784-byte allocation

2012-02-10T16:01:00.002+08:00

Add(change) dalvik.vm.heapsize=48m to /data/local.prop or /system/build.prop

FreeBSD e17 menu

2012-01-31T13:28:00.000+08:00

if applications has no menus,

check Environment Variables of XDG.

reference: E17 and Efreet

java mouse cursor Location in screen

2011-12-16T11:34:00.001+08:00

1.4.2 :
java.awt.Point point = new java.awt.Point(e.getPoint());
SwingUtilities.convertPointFromScreen(point, e.getComponent());
int x=(int) point.getX();
int y=(int) point.getY();

1.5 :
java.awt.MouseInfo.getPointerInfo().getLocation();

JDBC drivers, Dynamic loading

2011-12-14T16:10:00.000+08:00

When server can't put JDBC jar file,
we can dynamic loading JDBC jar file.

reference:Dynamic loading of JDBC drivers