Recent Comments

This is default featured slide 1 title

Go to Blogger edit html and find these sentences.Now replace these sentences with your own descriptions.

2011年7月27日 星期三

Ubuntu 11.04 IBUS安裝無蝦米輸入法

下載網址https://github.com/vicamo/ibus-table-boshiamy/downloads 目前安裝『ibus-table-boshiamy_1.3.0.20101012-1_all.deb』安裝好後,點選IBUS後執行『重新啟動』後到『偏好設定』裡把嘸蝦米輸入法加入...

2011年7月3日 星期日

password authentication failed for user "postgres"

postgresql安裝好後用pgadmin連接出現如下的錯誤訊息:Error connecting to the server:FATAL: password authentication failed for user "postgres" 錯誤原因是沒有設定postgres的密碼,檢查及設定如下:[root@Vigor14 ~]# su -l postgres -bash-3.2$ psql psql (8.4.7) Type "help" for help. postgres=# select * from pg_shadow; usename | usesysid | usecreatedb | usesuper | usecatupd | passwd | valunti l | useconfig ----------+----------+-------------+----------+-----------+--------+-------- --+----------- postgres | 10 | t | t | t | | | (1 row) postgres=#...

安裝ora2pg

安裝ora2pg安裝 perl-DBD-Pgyum install perl-DBD-Pg安裝ora2pgtar -xvf ora2pg-8.4.tar.bz2cd ora2pg-8.4perl Makefile.PLmakemake install執行 ora2pg -h若出現下列的結果請先安裝『perl-DBD-Pg』套件[root@DB ora2pg-8.4]# ora2pgCan't locate DBD/Pg.pm in @INC (@INC contains: /usr/lib/perl5/site_perl/5.8.8/i386-linux-thread-multi /usr/lib/perl5/site_perl/5.8.8 /usr/lib/perl5/site_perl /usr/lib/perl5/vendor_perl/5.8.8/i386-linux-thread-multi /usr/lib/perl5/vendor_perl/5.8.8 /usr/lib/perl5/vendor_perl /usr/lib/perl5/5.8.8/i386-linux-thread-multi /usr/lib/perl5/5.8.8 .) at /usr/lib/perl5/site_perl/5.8.8/Ora2Pg.pm...

安裝 DBD-Oracle

安裝 DBD-Oracle設定參數export ORACLE_HOME=/opt/oracle/product/10.2.0/db_1export LD_LIBRARY_PATH=/opt/oracle/product/10.2.0/db_1/lib32ln -s /opt/oracle/product/10.2.0/db_1/lib /opt/oracle/product/10.2.0/db_1/lib32ln -s /opt/oracle/product/10.2.0/db_1/rdbms/lib /opt/oracle/product/10.2.0/db_1/rdbms/lib32安裝tar -xvzf DBD-Oracle-1.28.tar.gzcd DBD-Oracle-1.28perl Makefile.PLmakemake inst...

安裝postgresql資料庫

安裝postgresql資料庫安裝資料庫postgresql84yum install postgresql84 postgresql84-server postgresql84-libs第一次執行需要初始化資料庫service postgresql initdb啟動資料庫service postgresql startpostgresql設定開機時啟動chkconfig postgresql on修改/var/lib/pgsql/data/pg_hba.confhost all all 127.0.0.1/32 md5host all all 192.168.1.0/24 md5修改/var/lib/pgsql/data/postgresql.conflisten_addresses = '*'重新載入設定su -l postgrespg_ctl rel...