me and my stuff

Wireless debugging on Android

2023-09-10T23:21:00.001+07:00

I'm not sure which version of android required to have this feature. For my Redmi 9S follow steps below

navigate to

-Settings -> Additional settings-> Developer options -> Wireless debugging

and enable it then click "Pair device with pairing code"

then on your laptop (ip port and code are not exactly same with code below😅)

zsh 1010 % adb pair 192.168.1.213:41855
Enter pairing code: 185176
Successfully paired to 192.168.1.213:41855 [guid=adb-eee2c79f-MOsHVT]
[Sun 23/09/10 23:14 +07][s002][x86_64/darwin22.0/22.5.0][5.9]
<medici@medicis-MacBook-Pro:~>
zsh 1011 % flutter devices
1 connected device:

macOS (desktop) • macos • darwin-arm64 • macOS 13.4.1 22F770820d darwin-arm64

1 wirelessly connected device:

Redmi Note 9S (mobile) • adb-eee2c79f-MOsHVT._adb-tls-connect._tcp. • android-arm64 • Android 12 (API 31)
[Sun 23/09/10 23:14 +07][s002][x86_64/darwin22.0/22.5.0][5.9]
<medici@medicis-MacBook-Pro:~>
zsh 1012 %

Wireless debugging menu may in others place depend on ROM but I hope you got the idea. I really like this feature. Developing app on real phone is a lot faster for me

Connie

2023-09-10T15:57:00.008+07:00

I'm talking my latest omega. I just get into collectable vintage world few months ago, after playing around aliexpress homage watch for a while. There is nothing wrong with chinese homage watch but I will talk about that later

If you gonna buy a vintage omega watch. The constellation is a flagship model you have to look into. Mine is ref. 14902, caliber 561, dogleg, pie pan dial

For this model, other than beatiful clean dial, a good condition to consider is sharp edge, correct crown(not only decagonal crown, the omega logo should also have same shape as one on the dial)

the medal on back case

I guess mine is looking good

A Watch collector

2023-09-10T14:04:00.007+07:00

During covid time, work from home give me a new hobby, watch collecting😎. Just 1 year+ I have at maximum 11 watches in my collection. From 3861 speedy(most expensive one) to AliExpress homage 60 USD watch.

Currently, I sell some that I don't like. Trying to build a collection that can keep value overtime.

How can I post a picture 🥲?

update: at last i found the way. The first and the latest omega.

Long time no see :)

2023-09-10T13:47:00.001+07:00

it's 2023, more than 10 years i left this blog. Many thing changed include me :P. I'm still play around *nix, programing language may change. last i will try to make this blog live again

php mail function is very slow + wordpress didn't send mail

2012-06-17T22:17:00.000+07:00

I host my another site on my own server [ubuntu+apache+wordpress] and notice that notification mail function on my site is not work. After install sendmail, php mail function is working fine but very slow. If you also have this problem, below is how i fix it. first make sure your /etc/hosts file first line look like this

127.0.0.1       localhost.localdomain localhost yourhostname

hostname can found on /etc/hostname. Now php mail function should work correctly. But wordpress still deny to send mail out. This have to fix with little hack[ i don't have other better way yet ].

1. edit file "wp-includes/class-phpmailer.php".
2. Looking for the line 'public $From = 'root@localhost';'.
3. Change root@localhost to something else like name@yourhost.com. I don't know why but this work for me. :)

putting sqlite3 on nexus s

2012-03-07T21:49:00.004+07:00

i just notice that there is no sqlite3 on samsung nexus s (official ICS ROM) and i need it in debugging my application database. so i download it from somewhere on internet can't remember. Anyway the one that come with android sdk linux version should be fine to put it on phone. and here is what i do.

E:\android-sdk-windows-1.5_r2\platform-tools>adb shell
shell@android:/ $ su
su
shell@android:/ # mount -o remount,rw -t yaffs2 /dev/block/mtdblock3 /system
mount -o remount,rw -t yaffs2 /dev/block/mtdblock3 /system
shell@android:/ # dd if=/sdcard/sqlite3 of=/system/bin/sqlite3
dd if=/sdcard/sqlite3 of=/system/bin/sqlite3
47+1 records in
47+1 records out
24120 bytes transferred in 0.003 secs (8040000 bytes/sec)
shell@android:/ # chmod 4755 /system/bin/sqlite3
chmod 4755 /system/bin/sqlite3
shell@android:/ # mount -o remount,ro -t yaffs2 /dev/block/mtdblock3 /system
mount -o remount,ro -t yaffs2 /dev/block/mtdblock3 /system
shell@android:/ # sqlite3
sqlite3
SQLite version 3.7.4
Enter ".help" for instructions
sqlite>

notice : to do this your nexus have to root first.

black screen on 11.04 upgrade

2011-08-07T17:27:00.002+07:00

Just have a time to upgrade my desktop to 11.04 after reboot i get black screen. ebbr.bugs from ubuntuforums said this bcoz nvidia driver was intstalled as a package not a drivers. so this two commands will help

sudo apt-get install --reinstall linux-headers-'uname -r'
sudo apt-get install --reinstall linux-image-'uname -r'

and it fix my problem :)

internal mic on vaio w on karmic

2010-04-20T01:19:00.003+07:00

i have vaio w for 3 five month. i install karmic on it use wubi everything work fine but yesterday i note that internal mic is not work. adding 'model=vaio' or model='sony' in "/etc/modprobe.d/alsa-base" are not work. in my case to make it work i have to add 'model=toshiba-s06' to that file like this

options snd-hda-intel power_save=10 power_save_controller=N model=toshiba-s06

then run alsamixer in terminal change input source to 'Int DMic'.

makeing HTK3.4 on karmic

2010-04-18T13:49:00.004+07:00

When do "make all" for htk3.4 on karmic, i get error "HGraf.c:73:77: X11/Xlib.h: No such file or director". this be solved by ...

poj@ubuntu:~/Downloads$ sudo aptitude install libx11-dev
Reading package lists... Done
Building dependency tree        
Reading state information... Done
Reading extended state information       
Initializing package states... Done
The following NEW packages will be installed:
  libpthread-stubs0{a} libpthread-stubs0-dev{a} libx11-dev libxau-dev{a} libxcb1-dev{a} libxdmcp-dev{a} x11proto-core-dev{a} x11proto-input-dev{a} 
  x11proto-kb-dev{a} xtrans-dev{a} 
0 packages upgraded, 10 newly installed, 0 to remove and 0 not upgraded.
Need to get 2,242kB of archives. After unpacking 6,124kB will be used.
.
.
.      
Initializing package states... Done
Writing extended state information... Done

poj@ubuntu:~/Downloads$

now try again.

a2billing on Karmic Koala

2010-01-21T10:25:00.000+07:00

During install a2billing on Karmic Koala by follow this wiki. In Step9 I get this error.

root@freeradius:/usr/local/src/a2billing/CallBack# easy_install callback-daemon-py/dist/callback_daemon-1.0.prod_r1527-py2.5.egg
Processing callback_daemon-1.0.prod_r1527-py2.5.egg
Copying callback_daemon-1.0.prod_r1527-py2.5.egg to /usr/local/lib/python2.6/dist-packages
Adding callback-daemon 1.0.prod-r1527 to easy-install.pth file
Installing a2b_callback_daemon script to /usr/local/bin

Installed /usr/local/lib/python2.6/dist-packages/callback_daemon-1.0.prod_r1527-py2.5.egg
Processing dependencies for callback-daemon==1.0.prod-r1527
Searching for callback-daemon==1.0.prod-r1527
Reading http://pypi.python.org/simple/callback-daemon/
Couldn't find index page for 'callback-daemon' (maybe misspelled?)
Scanning index of all packages (this may take a while)
Reading http://pypi.python.org/simple/
No local packages or download links found for callback-daemon==1.0.prod-r1527
error: Could not find suitable distribution for Requirement.parse('callback-daemon==1.0.prod-r1527')
root@freeradius:/usr/local/src/a2billing/CallBack#

because installed python version is 2.6 but a2billing1.4.4.1 require version 2.5[I guess hoho]. so try to fix this by install python2.5

root@freeradius:/usr/local/src/a2billing/CallBack# aptitude install python2.5
Reading package lists... Done
Building dependency tree       
Reading state information... Done
Reading extended state information      
Initializing package states... Done
The following NEW packages will be installed:
  libdb4.6{a} python2.5 python2.5-minimal{a} 
0 packages upgraded, 3 newly installed, 0 to remove and 0 not upgraded.
Need to get 4,825kB of archives. After unpacking 16.6MB will be used.
Do you want to continue? [Y/n/?] y
...
Reading extended state information       
Initializing package states... Done
Writing extended state information... Done

root@freeradius:/usr/local/src/a2billing/CallBack#

then try again.

root@freeradius:/usr/local/src/a2billing/CallBack# update-alternatives --install /usr/bin/python python /usr/bin/python2.5 1
update-alternatives: using /usr/bin/python2.5 to provide /usr/bin/python (python) in auto mode.
root@freeradius:/usr/local/src/a2billing/CallBack# easy_install callback-daemon-py/dist/callback_daemon-1.0.prod_r1527-py2.5.egg
Processing callback_daemon-1.0.prod_r1527-py2.5.egg
Copying callback_daemon-1.0.prod_r1527-py2.5.egg to /usr/lib/python2.5/site-packages
Adding callback-daemon 1.0.prod-r1527 to easy-install.pth file
Installing a2b_callback_daemon script to /usr/bin

Installed /usr/lib/python2.5/site-packages/callback_daemon-1.0.prod_r1527-py2.5.egg
Processing dependencies for callback-daemon==1.0.prod-r1527
Finished processing dependencies for callback-daemon==1.0.prod-r1527
root@freeradius:/usr/local/src/a2billing/CallBack#

Arduino on Karmic Koala

2009-12-22T22:43:00.006+07:00

To use arduino on karmic koala, first we need to install required package e.g. gcc-avr and jre[here i use jdk instead]

pnix@x300:~$ sudo aptitude install gcc-avr sun-java6-jdk
Reading package lists... Done
Building dependency tree       
Reading state information... Done
Reading extended state information      
Initializing package states... Done
The following NEW packages will be installed:
  binutils-avr{a} gcc-avr gsfonts-x11{a} java-common{a} odbcinst1debian1{a} sun-java6-bin{a} sun-java6-jdk 
  sun-java6-jre{a} unixodbc{a} 
0 packages upgraded, 9 newly installed, 0 to remove and 0 not upgraded.
...     
Initializing package states... Done
Writing extended state information... Done

pnix@x300:~$

then get latest version of arduino ide, extract and run.

pnix@x300:~/Downloads$ wget http://arduino.googlecode.com/files/arduino-0017.tgz
--2009-12-22 23:05:34--  http://arduino.googlecode.com/files/arduino-0017.tgz
Resolving arduino.googlecode.com... 209.85.231.82
Connecting to arduino.googlecode.com|209.85.231.82|:80... connected.
HTTP request sent, awaiting response... 200 OK
Length: 4141675 (3.9M) [application/x-gzip]
Saving to: `arduino-0017.tgz'

100%[=========================================================================>] 4,141,675   10.9K/s   in 8m 36s  

2009-12-22 23:14:12 (7.83 KB/s) - `arduino-0017.tgz' saved [4141675/4141675]

pnix@x300:~/Downloads$ mkdir ~/bin
pnix@x300:~/Downloads$ tar xzf arduino-0017.tgz  -C ~/bin
pnix@x300:~/Downloads$ cd /home/pnix/bin/arduino-0017/arduino
bash: cd: /home/pnix/bin/arduino-0017/arduino: Not a directory
pnix@x300:~/Downloads$ cd /home/pnix/bin/arduino-0017/
pnix@x300:~/bin/arduino-0017$ ./arduino 
Experimental:  JNI_OnLoad called.
Stable Library
=========================================
Native lib Version = RXTX-2.1-7
Java lib Version   = RXTX-2.1-7

Update:
now the ide should start running fine. but after first compile i've got many error about can't find many avr header file so another package we need [and i forgot].

pnix@x300:~/bin/arduino-0017$ sudo aptitude search avr-libc
p   avr-libc                                          - Standard C library for Atmel AVR development               
pnix@x300:~/bin/arduino-0017$ sudo aptitude install avr-libc
Reading package lists... Done
Building dependency tree       
Reading state information... Done
Reading extended state information      
Initializing package states... Done
The following NEW packages will be installed:
  avr-libc 
0 packages upgraded, 1 newly installed, 0 to remove and 0 not upgraded.
...
Writing extended state information... Done

pnix@x300:~/bin/arduino-0017$

Fixing libstdc++5 Problem in Ubuntu 9.10

2009-12-11T13:17:00.002+07:00

Trying to run X-lite on Karmic Koala[ubuntu 9.10] give me 'error while loading shared libraries: libstdc++.so.5: cannot open shared object file: No such file or directory' as you see below.

pnix@trinity:~/Downloads$ wget http://counterpath.s3.amazonaws.com/downloads/X-Lite_Install.tar.gz
--2009-12-11 02:08:02--  http://counterpath.s3.amazonaws.com/downloads/X-Lite_Install.tar.gz
Resolving counterpath.s3.amazonaws.com... 72.21.202.96
Connecting to counterpath.s3.amazonaws.com|72.21.202.96|:80... connected.
HTTP request sent, awaiting response... 200 OK
Length: 2094582 (2.0M) [application/x-gzip]
Saving to: `X-Lite_Install.tar.gz'

100%[======================================>] 2,094,582   90.1K/s   in 25s     

2009-12-11 02:08:32 (83.2 KB/s) - `X-Lite_Install.tar.gz' saved [2094582/2094582]

pnix@trinity:~/Downloads$ tar xzf X-Lite_Install.tar.gz 
pnix@trinity:~/Downloads$ ls
X-Lite_Install.tar.gz  xten-xlite
pnix@trinity:~/Downloads$ cd xten-xlite/
pnix@trinity:~/Downloads/xten-xlite$ ls
README  xtensoftphone
pnix@trinity:~/Downloads/xten-xlite$ ./xtensoftphone 
./xtensoftphone: error while loading shared libraries: libstdc++.so.5: cannot open shared object file: No such file or directory
pnix@trinity:~/Downloads/xten-xlite$

Because 9.10 use libstdc++6 instead, To fix this download and install libstdc++5 before running xlite

pnix@trinity:~/Downloads$ wget http://mirrors.kernel.org/ubuntu/pool/universe/g/gcc-3.3/libstdc++5_3.3.6-17ubuntu1_i386.deb
--2009-12-11 03:22:09--  http://mirrors.kernel.org/ubuntu/pool/universe/g/gcc-3.3/libstdc++5_3.3.6-17ubuntu1_i386.deb
Resolving mirrors.kernel.org... 130.239.17.6
Connecting to mirrors.kernel.org|130.239.17.6|:80... connected.
HTTP request sent, awaiting response... 200 OK
Length: 296434 (289K) [text/plain]
Saving to: `libstdc++5_3.3.6-17ubuntu1_i386.deb'

100%[======================================>] 296,434      328K/s   in 0.9s    

2009-12-11 03:22:10 (328 KB/s) - `libstdc++5_3.3.6-17ubuntu1_i386.deb' saved [296434/296434]

pnix@trinity:~/Downloads$ sudo dpkg -i libstdc++5_3.3.6-17ubuntu1_i386.deb 
[sudo] password for pnix: 
Selecting previously deselected package libstdc++5.
(Reading database ... 141309 files and directories currently installed.)
Unpacking libstdc++5 (from libstdc++5_3.3.6-17ubuntu1_i386.deb) ...
Setting up libstdc++5 (1:3.3.6-17ubuntu1) ...

Processing triggers for libc-bin ...
ldconfig deferred processing now taking place
pnix@trinity:~/Downloads$ ./xtensoftphone 
bash: ./xtensoftphone: No such file or directory
pnix@trinity:~/Downloads$ ls
libstdc++5_3.3.6-17ubuntu1_i386.deb  X-Lite_Install.tar.gz  xten-xlite
pnix@trinity:~/Downloads$ xten-xlite/xtensoftphone 
I/O warning : failed to load external entity "/home/pnix/.Xscrc"

monitor your filesystem events with inotify-tools

2008-11-12T22:32:00.003+07:00

I looking for the way to mirror files on my server to others when something're updated and found that inotify is a good idea in this case.
Thanks for inotify-tools project, c library and set of command line programs for linux provide interface to inotify, that let me avoid from c code.

On ibex, i get it by..

pnix@pnix-a7n:~$ sudo aptitude install inotify-tools
[sudo] password for pnix: 
Reading package lists... Done
Building dependency tree       
Reading state information... Done
Reading extended state information       
Initializing package states... Done
The following NEW packages will be installed:
  inotify-tools libinotifytools0{a} 
0 packages upgraded, 2 newly installed, 0 to remove and 0 not upgraded.
Need to get 39.0kB of archives. After unpacking 201kB will be used.
Do you want to continue? [Y/n/?] y
...
Writing extended state information... Done

pnix@pnix-a7n:~$

Below is example shell script i use to moniter and update file to remote host.

#!/bin/bash
while inotifywait -rq -e close_write /folder_to_moniter; do
        rsync -av /folder_to_moniter -e "ssh -l pnix" pnix@remotehost:/home/pnix/tmp
done

for Java api look here

Many sound problems on Intrepid ibex

2008-11-01T23:57:00.006+07:00

I upgrade two ibex last night and found few sound problems below

First, on video file(mpg,avi ..), when right click and choose >open with >mplayer. will bring up error " [AO_ALSA] Unable to find simple control 'PCM',0 ".
I'm not sure what it is, maybe the config just is not right but I fix this by right click on movie window-> preference then on audio tab, select 'Enable Software Mixer'. [or you can do this by change 'softvol = "no"' to 'softvol = "yes"' in $HOME/.mplayer/gui.conf]

Another sound issue is flash player on web[like youtube] not play sound. /var/log/message said

pnix@pnix-a7n:_NHDT392$ tail -f /var/log/messages
...
Nov  2 00:33:14 pnix-a7n -- MARK --
Nov  2 00:40:51 pnix-a7n pulseaudio[23941]: sink-input.c: Failed to create sink input: too many inputs per sink.
Nov  2 00:40:51 pnix-a7n last message repeated 31 times
Nov  2 00:40:51 pnix-a7n pulseaudio[23941]: protocol-native.c: Warning! Too many connections (64), dropping incoming connection.

and after run flash, no sound from other application too. I saw bug report for this issue on lunchpad here but no solution for me. I have to kill and restart pulseaudio like this to get sound back.

pnix@pnix-a7n:~$ pulseaudio -k
W: ltdl-bind-now.c: Failed to find original dlopen loader.
pnix@pnix-a7n:~$ ps aux|grep pulseaudio
pnix      2510  0.0  0.0   3236   796 pts/0    S+   04:14   0:00 grep pulseaudio
pnix@pnix-a7n:~$ pulseaudio -D
W: ltdl-bind-now.c: Failed to find original dlopen loader.
pnix@pnix-a7n:~$ ps aux|grep pulseaudio
pnix      2513  3.0  0.3  28952  3952 ?        Ssl  04:14   0:00 pulseaudio -D
pnix      2516  0.0  0.2   7528  2516 ?        S    04:14   0:00 /usr/lib/pulseaudio/pulse/gconf-helper
pnix      2518  0.0  0.0   3236   792 pts/0    S+   04:14   0:00 grep pulseaudio
pnix@pnix-a7n:~$

Fixing shutdown problem in hardy

2008-09-24T23:09:00.003+07:00

For a long time my ubuntu box can't shutdown properly(not sure when this start to happen may be since upgrade to gusty). Shutdown progress bar will stop running, harddrive already stop spinning and hang. I guess it because my kernel option "acpi=off nolapic irqpoll" in /boot/grub/menu.lst without these option shutdown script work perfect. So, why i need that??
I just found the way to fix this from ubuntuforums. This is not new, many guy has this problem and it fixed. To solve this problem [for me]

1.add "apm=power_off" to kernel option.
2.add "apm power_off=1" to /etc/modules

Reboot and try shutdown again this time it work perfect.

Bootchart on Ubuntu hardy

2008-09-24T22:22:00.003+07:00

Today I'm searching for a way to make my box boot up faster and found this tool. Bootchart can use for analyze and visualization boot process.
To install bootchart.

pnix@pnix-a7n:~$ sudo aptitude install bootchart
Reading package lists... Done
Building dependency tree       
Reading state information... Done
Reading extended state information       
Initializing package states... Done
Building tag database... Done      
The following NEW packages will be automatically installed:
  librsvg2-bin 
The following NEW packages will be installed:
  bootchart librsvg2-bin 
0 packages upgraded, 2 newly installed, 0 to remove and 0 not upgraded.
Need to get 121kB of archives. After unpacking 324kB will be used.
Do you want to continue? [Y/n/?] y
Writing extended state information... Done
Get:1 http://mirror1.ku.ac.th hardy/main librsvg2-bin 2.22.2-2 [21.3kB]
Get:2 http://mirror1.ku.ac.th hardy/main bootchart 0.9-0ubuntu7 [99.8kB]
Fetched 121kB in 1s (90.6kB/s)    
...
Building tag database... Done             
pnix@pnix-a7n:~$

then reboot to see the result[in /var/log/bootchart].

Mine take about 34 seconds to boot. Not too bad for six years old box(Athlon XP 1700+, A7N8X-E deluxe, 1G Memory, SATA), but I want faster.
From graph I found few process i install long time ago, and some default configure to autoboot. e.g. avahi-daemon, cvsd, laptop-mode[powernowd], smokeping, winbind.
So, take it out with rcconf, reboot again and see the result.

30 seconds wow I safe 4 sec.

Setup MySQL with Ofbiz

2008-06-19T16:25:00.001+07:00

Download ofbiz weekily build and extract it somewhere you want. From your ofbiz directory, edit file entityengine.xml in framework/entity/config
add new datasources below localmysql datasource part

    <datasource name="custommysql"
            helper-class="org.ofbiz.entity.datasource.GenericHelperDAO"
            field-type-name="mysql"
            check-on-start="true"
            add-missing-on-start="true"
            check-pks-on-start="false"
            use-foreign-keys="true"
            join-style="ansi-no-parenthesis"
            alias-view-columns="false"
            drop-fk-use-foreign-key-keyword="true"
            table-type="InnoDB"
            character-set="latin1"
            collate="latin1_general_cs">
        <read-data reader-name="seed"/>
        <read-data reader-name="seed-initial"/>
        <read-data reader-name="demo"/>
        <read-data reader-name="ext"/>
        <inline-jdbc
                jdbc-driver="com.mysql.jdbc.Driver"
                jdbc-uri="jdbc:mysql://localhost/ofbiz"
                jdbc-username="ofbizuser"
                jdbc-password="mypass"
                isolation-level="ReadCommitted"
                pool-minsize="2"
                pool-maxsize="250"/>
        <!-- <jndi-jdbc jndi-server-name="localjndi" jndi-name="java:/MySqlDataSource" isolation-level="Serializable"/> -->
    </datasource>
    <datasource name="custommysqlolap"
            helper-class="org.ofbiz.entity.datasource.GenericHelperDAO"
            field-type-name="mysql"
            check-on-start="true"
            add-missing-on-start="true"
            check-pks-on-start="false" 
            use-foreign-keys="true"            
            join-style="ansi-no-parenthesis"
            alias-view-columns="false"
            drop-fk-use-foreign-key-keyword="true"
            table-type="InnoDB"
            character-set="latin1" 
            collate="latin1_general_cs">
        <read-data reader-name="seed"/>
        <read-data reader-name="seed-initial"/>
        <read-data reader-name="demo"/>
        <read-data reader-name="ext"/>         
        <inline-jdbc                  
                jdbc-driver="com.mysql.jdbc.Driver"
                jdbc-uri="jdbc:mysql://localhost/ofbizolap?autoReconnect=true"
                jdbc-username="ofbizuser"
                jdbc-password="mypass"  
                isolation-level="ReadCommitted"
                pool-minsize="2"
                pool-maxsize="250"/>               
        <!-- <jndi-jdbc jndi-server-name="localjndi" jndi-name="java:/DerbyDataSource" isolation-level="ReadCommitted"/> -->
    </datasource>

change the "default" delegator make it look like this

<delegator name="default" entity-model-reader="main" entity-group-reader="main" entity-eca-reader="main" distributed-cache-clea$
    <group-map group-name="org.ofbiz" datasource-name="custommysql"/>
    <group-map group-name="org.ofbiz.olap" datasource-name="custommysqlolap"/>
</delegator>

put mysql driver under framework/entity/lib/jdbc

[admin@localhost ofbiz]$ ls framework/entity/lib/jdbc
derby-10.4.1.3.jar  mysql-connector-java-5.1.6-bin.jar
[admin@localhost ofbiz]$

prepare database <create database ,grant user>

mysql> create database ofbiz;
Query OK, 1 row affected (0.05 sec)

mysql> create database ofbizolap;
Query OK, 1 row affected (0.05 sec)

mysql> grant all on *.* to 'ofbizuser'@'localhost' identified by 'mypass';
Query OK, 0 rows affected (0.03 sec)

mysql>

now we're ready to run ant to load database into mysql. Let's go.

[admin@localhost ofbiz]$ ./ant run-install
...
[java] 2008-06-19 10:59:06,245 (main) [    ContainerLoader.java:114:INFO ] Shutting down containers

BUILD SUCCESSFUL
Total time: 5 minutes 25 seconds
[admin@localhost ofbiz]$

Cannot use SUN rmic, as it is not available.

2008-06-18T21:10:00.006+07:00

I download ofbiz weekly build[ofbiz_20080602.zip] from sourceforge and try to build it on eclipse. How to config on eclipse? How to use ofbiz with external database? you can find out from google or may be I'll post here later.:P
This post is about error when I run ant build target 'run-install' to load configured data. Below error'll show on eclipse console.

...
stubs:
     [rmic] RMI Compiling 1 class to D:\eclipse_workspace\ofbiz2\framework\service\build\classes

BUILD FAILED
D:\eclipse_workspace\ofbiz2\build.xml:125: The following error occurred while executing this line:
D:\eclipse_workspace\ofbiz2\framework\build.xml:142: The following error occurred while executing this line:
D:\eclipse_workspace\ofbiz2\framework\service\build.xml:101: Cannot use SUN rmic, as it is not available.  A common solution is to set the environment variable JAVA_HOME or CLASSPATH.

Total time: 8 seconds

I solve this by browse to Window->Preferences->Ant->Runtime then highlight on 'Global Entries', click 'Add Externals JARs' then select tools.jar from your $JAVA_HOME/lib directory. Try run ant build again then it sould be fine.

Compile subversion on Fedora core 6

2008-06-05T15:32:00.014+07:00

I just move to new company. My first job here is setup a svn on FC6 box. This post is about how i built it.
First download, compile and install apache[must be 2.0 version to have same apr version as subversion-deps-1.4.6.tar.bz2]

[root@localhost ~]# wget http://mirrors.issp.co.th/apache/httpd/httpd-2.0.63.tar.bz2
...
[root@localhost ~]# tar xjf httpd-2.0.63.tar.bz2
[root@localhost ~]# cd httpd-2.0.63
[root@localhost httpd-2.0.63]# ./buildconf
[root@localhost httpd-2.0.63]# ./configure --enable-dav --enable-so --enable-maintainer-mode --prefix=/usr/local/apache20
...
[root@localhost httpd-2.0.63]# make && make install
...
[root@localhost httpd-2.0.63]# cd ..
[root@localhost ~]#

then download subversion source code and the subversion dependencies source code, extract both then go to compile and install apr, apr-util, neon and subversion itself.

[root@localhost ~]# wget http://subversion.tigris.org/downloads/subversion-1.4.6.tar.bz2
...
[root@localhost ~]# wget http://subversion.tigris.org/downloads/subversion-deps-1.4.6.tar.bz2
...
[root@localhost ~]# tar xjf subversion-1.4.6.tar.bz2
[root@localhost ~]# tar xjf subversion-deps-1.4.6.tar.bz2
[root@localhost ~]# cd subversion-1.4.6/apr
[root@localhost apr]# ./configure --prefix=/usr/local/apr
...
[root@localhost apr]# make && make install
...
[root@localhost apr]# cd ../apr-util
[root@localhost apr-util]# ./configure --prefix=/usr/local/apr-util --with-apr=/usr/local/apr/
...
[root@localhost apr-util]# make && make install
...
[root@localhost apr-util]# cd ../neon
[root@localhost neon]# ./configure --prefix=/usr/local/neon
...
[root@localhost neon]# make && make install
...
[root@localhost neon]# cd ..
[root@localhost subversion-1.4.6]# ./configure --prefix=/usr/local/subversion --with-apxs=/usr/local/apache20/bin/apxs --with-apr=/usr/local/apr/ --with-apr-util=/usr/local/apr-util/ --with-neon=/usr/local/neon/ --with-ssl
...
[root@localhost subversion-1.4.6]# make && make install
...
[root@localhost subversion-1.4.6]#

now subversion is already installed, add apache user

[root@localhost subversion-1.4.6]# groupadd apache
[root@localhost subversion-1.4.6]# useradd -g apache -d /usr/local/apache20
[root@localhost subversion-1.4.6]# chown -Rv apache.apache /usr/local/apache20

edit /usr/local/apache2/conf/httpd.conf change..

User nobody
Group #-1

User apache
Group apache

and add this code to end of file.

<Location /subversion>
  DAV svn
  SVNPath /usr/local/subversion/repository/
  AuthType Basic
  AuthName "Subversion repository"
  AuthUserFile /usr/local/subversion/repository/conf/svn-auth-file
  Require valid-user
</Location>

create password with this command

/usr/local/apache20/bin/htpasswd -cmd /usr/local/subversion/repository/conf/svn-auth-file {user-name}

create a repository

[root@localhost ~]# mkdir -v /usr/local/subversion/repository
[root@localhost ~]# svnadmin create --fs-type fsfs /usr/local/subversion/repository
[root@localhost ~]#

Last to test I will try import some file to repos.

[root@localhost src]# touch source1
[root@localhost src]# touch source2
[root@localhost src]# ls
source1  source2
[root@localhost src]# svn -m "initial import to svn" import . http://127.0.0.1/subversion/
Authentication realm:  Subversion repository
Password for 'root': 
Authentication realm:  Subversion repository
Username: swd
Password for 'swd': 
svn: Can't create directory '/usr/local/subversion/repository/db/transactions/0-1.txn': Permission denied

uhh.. you need to make apache user can access all the files in the repository.

[root@localhost src]# chown -R apache.apache /usr/local/subversion/repository
[root@localhost src]# chmod g+s /usr/local/subversion/repository/db
[root@localhost src]# svn -m "initial import to svn" import . http://127.0.0.1/subversion/
Authentication realm:  Subversion repository
Password for 'root': 
Authentication realm:  Subversion repository
Username: swd
Password for 'swd': 
Adding         source1
Adding         source2

Committed revision 1.
[root@localhost src]#

That's all. You can browse repos. via url 'http://127.0.0.1/subversion/'.

Try Asterisk on Ubuntu Hardy

2008-05-15T15:34:00.002+07:00

I try install asterisk server on ubuntu hardy from repos. The 'asterisk-sounds-extra' is for testing sound[locate in /usr/share/asterisk/sounds/].

pnix@v400ast:~$ sudo aptitude install asterisk  asterisk-sounds-extra
Reading package lists... Done
Building dependency tree       
Reading state information... Done
Reading extended state information       
Initializing package states... Done
Building tag database... Done      
The following NEW packages will be automatically installed:
  asterisk-config asterisk-sounds-main build-essential debhelper dpkg-dev g++ g++-4.2 
  gettext html2text intltool-debian libc-client2007 libc6-dev libcompress-raw-zlib-perl 
  libcompress-zlib-perl libct3 libdigest-hmac-perl libdigest-sha1-perl libfile-remove-perl 
  libgsm1 libiksemel3 libio-compress-base-perl libio-compress-zlib-perl libio-stringy-perl 
  libmail-box-perl libmail-sendmail-perl libmailtools-perl libmime-types-perl 
  libobject-realize-later-perl libpq5 libpri1.0 libradiusclient-ng2 libstdc++6-4.2-dev 
  libtimedate-perl libtonezone1 libuser-identity-perl libvpb0 linux-libc-dev mlock 
  module-assistant odbcinst1debian1 patch po-debconf unixodbc vpb-driver-source 
The following NEW packages will be installed:
  asterisk asterisk-config asterisk-sounds-extra asterisk-sounds-main build-essential 
  debhelper dpkg-dev g++ g++-4.2 gettext html2text intltool-debian libc-client2007 
  libc6-dev libcompress-raw-zlib-perl libcompress-zlib-perl libct3 libdigest-hmac-perl 
  libdigest-sha1-perl libfile-remove-perl libgsm1 libiksemel3 libio-compress-base-perl 
  libio-compress-zlib-perl libio-stringy-perl libmail-box-perl libmail-sendmail-perl 
  libmailtools-perl libmime-types-perl libobject-realize-later-perl libpq5 libpri1.0 
  libradiusclient-ng2 libstdc++6-4.2-dev libtimedate-perl libtonezone1 
  libuser-identity-perl libvpb0 linux-libc-dev mlock module-assistant odbcinst1debian1 
  patch po-debconf unixodbc vpb-driver-source 
0 packages upgraded, 46 newly installed, 0 to remove and 0 not upgraded.
Need to get 23.5MB of archives. After unpacking 73.8MB will be used.
Do you want to continue? [Y/n/?] y
...
Building tag database... Done             
pnix@v400ast:~$

After finish, try to connect to asterisk

pnix@v400ast:~$ sudo asterisk -rvvv
Asterisk 1.4.17~dfsg-2ubuntu1, Copyright (C) 1999 - 2007 Digium, Inc. and others.
Created by Mark Spencer 
Asterisk comes with ABSOLUTELY NO WARRANTY; type 'core show warranty' for details.
This is free software, with components licensed under the GNU General Public
License version 2 and other licenses; you are welcome to redistribute it under
certain conditions. Type 'core show license' for details.
=========================================================================
This package has been modified for the Debian GNU/Linux distribution
Please report all bugs to http://bugs.debian.org/asterisk
=========================================================================
  == Parsing '/etc/asterisk/asterisk.conf': Found
  == Parsing '/etc/asterisk/extconfig.conf': Found
Connected to Asterisk 1.4.17~dfsg-2ubuntu1 currently running on v400ast (pid = 5041)
Verbosity is at least 3
v400ast*CLI>

Well.. basic installation is very smooth. I try adding sip account and test dialplan to play 'welcome' sound and it working fine too. May be i will use this to be my production server instead of trixbox if I succeed on compiling rhino driver on ubuntu.

Fixing sendmail take a long time to start

2008-05-15T10:59:00.004+07:00

I notice that my database box[FC6+Oracle10.2] take along time to startup. Sendmail and sm-client very very slow to start[ about 5 minutes ]. There's something wrong in /etc/hosts file. 'newalises' command take long time to update and finish with error below.

[root@ora10g ~]# newaliases
WARNING: local host name (ora10g) is not qualified; see cf/README: WHO AM I?
/etc/aliases: 76 aliases, longest 10 bytes, 765 bytes total
[root@ora10g ~]# cat /etc/hosts
# Do not remove the following line, or various programs
# that require network functionality will fail.
127.0.0.1       localhost.localdomain   localhost 
192.168.1.55    ora10g
[root@ora10g ~]#

To fix this, custom hostname[ora10g] need to append to localhost line in /etc/hosts.

[root@ora10g ~]# cat /etc/hosts
# Do not remove the following line, or various programs
# that require network functionality will fail.
127.0.0.1       localhost.localdomain   localhost ora10g
192.168.1.55    ora10g
[root@ora10g ~]# newaliases
/etc/aliases: 76 aliases, longest 10 bytes, 765 bytes total
[root@ora10g ~]#

Using Datapump on oracle 10g to export/import

2008-05-09T11:09:00.005+07:00

This will be update version of this post if you are using oracle 10g or 11g.

Last month I post about export/import data in oracle using exp,imp utility. Actually oracle has something newer and better performance if you're using 10g or 11g.

Assume that we want to export one table from one oracle db and import it into another oracle db. So create the folder /home/oracle/dbbackup on two oracle db server to store <.dmp> file[that will be created when exporting and importing].

Next, we need to tell oracle to know this folder, create directory on both db by run command below in sqlplus

SQL> create directory dmpdir as '/home/oracle/dbbackup';

Directory created.

SQL>

Now on source database export table with command below.

[oracle@k8n ~]$ expdp username/password DIRECTORY=dmpdir DUMPFILE=filename.dmp TABLES=tablename

Export: Release 10.1.0.3.0 - Production on Friday, 09 May, 2008 10:54
...
[oracle@k8n ~]$

after finish you will have filename.dmp in /home/oracle/dbbackup, ftp it to the target box make sure you are using binary mode.
Then on target database import the table like this.

[oracle@dbp4 ~]$ impdp username/password DIRECTORY=dmpdir DUMPFILE==filename.dmp TABLES=tablename

Import: Release 10.2.0.1.0 - Production on Friday, 09 May, 2008 11:02:27
...
[oracle@dbp4 ~]$

That's it. Note that up there exporting from 10.1.0.3.0 and importing into 10.2.0.1.0 is ok but down version import[e.g. expdp with higher version and impdp with lower version]is not, you will get error like this

ORA-39001: invalid argument value
ORA-39000: bad dump file specification
ORA-31619: invalid dump file "/home/oracle/dbbackup/filename.dmp"

To fix this error, expdp command must append with 'version=10.target.version'.

more detail about expdp/impdp tool

expdp help=yes
impdp help=yes

Single user mode in fedora core

2008-05-06T12:50:00.004+07:00

Again that electricity in area of Sukhumvit road, Bangkok down yesterday night. This time one database refuse to boot it freeze at "Starting system logger:". Look like there's no way to get a shell from any normal run level startup.

Not like ubuntu that has recovery mode in grub menu. This box is fedora core, I know there's a way to get in to single user mode by pass kernel parameter at grub boot menu [but can not remember how to at that time:(].

After some googling I found the way. To get single user mode in FC, at grub menu press a [to append kernel parameter]. Now add s to tell fedora kernel that you want single user mode. After finish, enter to continue booting.

Now you will get root shell and can figure out what wrong with your system then fix it. In my case now I just want Oracle to come up so i need atleast two service 'network' and 'oracle'. Try to bring it up by run these two command and pray.

sh-3.00# service network start
sh-3.00# service oracle start

Not too bad that this time network and oracle are come up successfully:). But why syslogd startup caused system freeze is still no idea:(.

Toggle btw compiz&metacity with fusion-icon in Ubuntu Hardy

2008-04-29T01:45:00.006+07:00

Since gusty, compiz-fusion will start by default. I love eye candy but for resource shortage reason on my old box, sometime i need to switch to metacity. with alt-f2 and run 'metacity replace' is just work but not convenion. Thank for Tom that point me . Fusion-icon is use to switch between compiz and metacity window manager. For hardy, fusion-icon is in repos. installation is easy like

pnix@pnix-a7n:~$ sudo aptitude install fusion-icon
Reading package lists... Done
Building dependency tree       
Reading state information... Done
Reading extended state information       
Initializing package states... Done
Building tag database... Done      
The following NEW packages will be installed:
  fusion-icon 
0 packages upgraded, 1 newly installed, 0 to remove and 0 not upgraded.
Need to get 29.8kB of archives. After unpacking 270kB will be used.
...
Building tag database... Done             
pnix@pnix-a7n:~$

Running:
alt-F2 and type 'fusion-icon -n' or if you want this everytime logging in add 'fusion-icon -n' to 'Sessions preference' in System->Preferences->Sessions.

sudo: timestamp too far in the future

2008-04-28T19:02:00.002+07:00

I just finish build the new hardy box at my office. then I go to open the file '/etc/network/interfaces' to add internal ip address and forget something. When I try to open it again, I got this.

pnix@hardy-dev:~$ sudo nano /etc/network/interfaces
sudo: timestamp too far in the future: Apr 29 01:41:32 2008
pnix@hardy-dev:~$ date
Mon Apr 28 18:48:21 ICT 2008
pnix@hardy-dev:~$

I'm not sure why this happen may be some parts of the system using UTC, other parts using timezone-adjusted time. To fix this try code below to clear timestamp.

pnix@hardy-dev:~$ sudo -k
pnix@hardy-dev:~$ sudo nano /etc/network/interfaces
[sudo] password for pnix: