June 18th, 2008

MT Perl MySQL Module 忽然掛點 — Perl CPAN DBD:mysql error

本來跑好好的MT 去讀取MySQL

結果最近忽然出現

Got an error: install_driver(mysql) failed: Can’t load
‘/usr/lib/perl5/vendor_perl/5.8.0/i386-linux-thread-multi/auto/DBD/mysql/mysql
.so’
for module DBD::mysql: libmysqlclient_r.so.12: cannot open shared object
file: No such file or directory at
/usr/lib/perl5/5.8.0/i386-linux-thread-multi/DynaLoader.pm line 229. at (eval
4) line 3 Compilation failed in require at (eval 4) line 3. Perhaps a
required shared library or dll isn’t installed where expected at
/var/www/cgi-bin/mt/lib/MT/ObjectDriver/DBI/mysql.pm line 48

我去查的RPM 結果

[root@www RPMS]# rpm -qa|grep -i mysql
php-mysql-4.3.0-2mdk
MySQL-client-4.0.11a-5mdk
MySQL-common-4.0.11a-5mdk
MySQL-bench-4.0.11a-5mdk
perl-Mysql-1.22_19-6mdk
libmysql12-4.0.11a-5mdk
MySQL-4.0.11a-5mdk

使用 CPAN 更新的時候出現 error

CPAN.pm: Going to build C/CA/CAPTTOFU/DBD-mysql-4.007.tar.gz
Can’t exec “mysql_config”: No such file or directory at Makefile.PL line 76.
Cannot find the file ‘mysql_config’! Your execution PATH doesn’t seem

後來去看文章發現以下文章有很像的問題

http://bytes.com/forum/thread78379.html

http://forums.sixapart.com/lofiversion/index.php/t20654.html

本來用CPAN 查了很久~~ 但是怎麼查都會出問題

我在查的時候我發現我CPAN 的 DBD:mysql 忽然不見了
但是本來都有安裝的

後來安裝 DBD:mysql 的時候
發現需要 mysql_config
查詢之下需要安裝 mysql-devel 的版本
那是要 MySQL 4.1 以上的版本才有的
不過我的 MySQL 是4.0.11a

後來要看到網路上有人講

要找找 libmysqlclient.so.10

開始去找libmysqlclient.so.10

http://rpmfind.net/linux/rpm2html/search.php?query=libmysqlclient.so.10

裝了不少的RPM 仍然不WORK

最後找到

libmysql12 裡面也有libmysqlclient.so.10

所以強制upgrade libmysql12 就可以了

rpm -U libmysql12-4.0.11a-5mdk 即可

June 16th, 2008

CPAN 錯誤 –Can’t use string ("CPAN::Tarzip") as a HASH ref while "strict refs" in use at /usr/lib/perl5/5.8.5/CPAN/Tarzip.pm

由”台北小黑豬的部落格“GOOLE 的備份過來~

Can’t use string (“CPAN::Tarzip”) as a HASH ref while “strict refs” in use at /usr/lib/perl5/5.8.5/CPAN/Tarzip.pm
在今天試著在redhat as4 安裝amavis 時
安裝一些amavisd 必要的module
發現在做某些更新時出現
Can’t use string (“CPAN::Tarzip”) as a HASH ref while “strict refs” in use at /usr/lib/perl5/5.8.5/CPAN/Tarzip.pm line 94.

我試著
reload index
reload cpan
exit 再進入無效

後來在eflo.net
提到要
install mysql-server mysql mysql-devel php-mysql php-devel (for php-eaccelerator)
vi /etc/php.ini
press w to search for memory_limit make it to 48m
then install cpan
檢視後有安裝上敘提到的套件
於是我去檢視/etc/php.ini
default 為8m
改成48m
後
再進行安裝似乎就沒有問題了

June 16th, 2008