ㄉㄨㄞㄉㄨㄞ

Nina Lin, Dazhi, Taipei, Taiwan 一個好吃懶做的米蟲，想吃就吃想睡就睡。 occpuation:公主。interests:吃飯 睡覺 打鼻鼻

XMLBeans command

install

scomp -compiler c:\java_tools\java\jdk1.7\bin\javac.exe -out 1sync_xml_datasource.jar schema/common/1.0/AttrTypes.xsd schema/common/1.0/Header.xsd schema/common/1.0/Types.xsd schema/item/1.0/CatalogueRequestProxy.xsd schema/item/1.0/ResponseProxy.xsd schema/item/1.0/Types.xsd


Install PostgreSQL 8.2.23 in CentOS 5.8

1. Download source files from here
2. Upload files to the CentOS server
3. Prepare the necessary files
1. #yum -y install gcc gcc-c++ autoconf libjpeg libjpeg-devel libpng libpng-devel freetype freetype-devel libxml2 libxml2-devel zlib zlib-devel glibc glibc-devel glib2 glib2-devel bzip2 bzip2-devel ncurses ncurses-devel curl curl-devel e2fsprogs e2fsprogs-devel krb5 krb5-devel libidn libidn-devel openssl openssl-devel openldap openldap-devel nss_ldap openldap-clients openldap-servers
4. #tar -zxf postgresql-8.2.23.tar.gz
5. #cd postgresql*
6. #./configure --prefix=/usr/local/pgsql  --without-readline
7. #make && make install
8. Setting PostgreSQL config process
1. create user: #adduser postgres
2. create password: #passwd postgres
3. Authorized folder/files: 
1. #mkdir /usr/local/pgsql/data
2. #chown -R postgres /usr/local/pgsql
4. login as postgres: su postgres
5. initial dataset: /usr/local/pgsql/bin/initdb -D /usr/local/pgsql/data
6. edit config
1. #vi /usr/local/pgsql/data/postgresql.conf
2. find listen_addresses = ‘localhost’ to listen_addresses = '*'
3. #vi /usr/local/pgsql/data/pg_hba.conf 
4. IPv4 local connections:
host    all         all         127.0.0.1/32          trust 
host    all         all         192.168.1.0/24      password
9. Update user env. parameters
1. #vim /var/lib/pgsql/.bash_profile
2. [ -f /etc/profile ] && source /etc/profile
3. PGDATA=/usr/local/pgsql/data
   export PATH=/usr/local/pgsql/bin:$PATH
   export PGDATA
10. Start the service
1. start SQL service: 
1. #su - postgres
2. #/usr/local/pgsql/bin/pg_ctl start -i -D /usr/local/pgsql/data
2. check SQL status: ps aux | grep postgres
3. update postgres user
1. #su - postgres
2. #psql postgres
3. #alter user postgres ENCRYPTED PASSWORD 'postgres';

Note that: you have a short cut to figure out:

command line: yum -y install postgresql postgresql-libs postgresql-server

Install Tomcat 6 in CentOS 5.8

1. Install Tomcat 6 Process
1. cd /etc/yum.repos.d
2. wget 'http://www.jpackage.org/jpackage50.repo'
3. yum update
4. yum install tomcat6 tomcat6-webapps tomcat6-admin-webapps
5. service tomcat6 start
2. If you have problems accessing the server from another machine you may need to do the following:
1. setup
2. "Firewall configuration"
3. "Customize"
4. "Other ports" 8080:tcp
5. "Ok"
6. service tomcat6 restart
3. If you get a dependency error:
1. rpm -Uvh 'http://plone.lucidsolutions.co.nz/linux/centos/images/jpackage-utils-compat-el5-0.0.1-1.noarch.rpm'
4. tomcat_home: /usr/share/tomcat6
5. "tomcat" is a default execute tomcat server user.

Install JDK 1.6 in CentOS 5.8

1. Download jdk(jdk-6u33-linux-i586-rpm.bin) from Java Sun
1. cd  /root
2. cp jdk-6u33-linux-i586-rpm.bin /usr/local
3. cd /usr/local
4. chmod   +x  jdk-6u33-linux-i586-rpm.bin
5. ./ jdk-6u33-linux-i586-rpm.bin
2. Test JDK
1. By default Java will be installed to /usr/java/jdk1.6.0_33/
2. /usr/java/jdk1.6.0_33/bin/java -version
3. Choosing JDK
1. alternatives --install /usr/bin/java java /usr/java/jdk1.6.0_33/bin/java 2
2. alternatives --config java

There are 3 programs which provide 'java'.
  Selection    Command
-----------------------------------------------
*+ 1         /usr/lib/jvm/jre-1.6.0-openjdk/bin/java
   2           /usr/lib/jvm/jre-1.4.2-gcj/bin/java
   3           /usr/java/jdk1.6.0_33/bin/java
Enter to keep the current selection[+], or type selection number: 3

Done!

Uninstall PostgreSQL 8.2 for MAC 10.6.8

Steps to uninstall PostgreSQL 8.4 (Assuming default locations) 

1) Stop the server and remove the service. 

sudo launchctl unload /Library/LaunchDaemons/com.edb.launchd.postgresql-8.4.plist 

2) Remove the plist file. 

sudo rm -f /Library/LaunchDaemons/com.edb.launchd.postgresql-8.4.plist  

3) Remove the Menu Icons 

sudo rm -rf /Applications/PostgreSQL/8.4

4) Remove the Installation Files. 

sudo rm -rf /Library/PostgreSQL/8.4  

5) Remove the postgres user. 

sudo dscl . delete /Users/postgres  

6) Remove the ini file 

sudo rm -f /etc/postgres-reg.ini  


This will uninstall PostgreSQL 8.4 cleanly from your mac. 

成功

我們不要怕失敗, 因為我們即將成功.