[前][次][番号順一覧][スレッド一覧]

mysql:14249

From: n-ikeda <n-ikeda <n-ikeda@xxxxxxxxxx>>
Date: Wed, 24 Oct 2007 17:06:11 +0900
Subject: [mysql 14249] MySQLとperlの連携について

はじめまして。

エラーにより、perlの実行が出来ず困っております。
よろしくお願いいたします。


□ ファイルの中身

# vi sample1.pl

use DBI;

$user = 'mysql';
$db = DBI->connect('DBI:mysql:iketst:localhost',$user);
$sth = $db->prepare("INSERT INTO list VALUES(1,'1st','memo 1st')");
$sth->execute;
$sth->finishi;
$db->disconnect;
~
~
□ エラーの内容
# perl sample1.pl
perl: symbol lookup error: /usr/lib/perl5/site_perl/5.8.5/i386-linux-thread-multi/auto/DBD/mysql/mysql.so: undefined symbol: DBIc_TRACE_LEVEL

□

# ls -l /usr/lib/perl5/site_perl/5.8.5/i386-linux-thread-multi/auto/DBD/mysql/mysql.so
-r-xr-xr-x  1 root root 1925245 10月 23 15:47 /usr/lib/perl5/site_perl/5.8.5/i386-linux-thread-multi/auto/DBD/mysql/mysql.so


□ OS情報

# uname -a
Linux ntt.me.hikari.web 2.6.9-34.ELsmp #1 SMP Fri Feb 24 16:54:53 EST 2006 i686 i686 i386 GNU/Linux

# rpm -qa | grep mysql
perl-DBD-mysql-4.005-1.el4.rf
mysql-4.1.12-3.RHEL4.1
mysqlclient10-3.23.58-4.RHEL4.1
[root@ntt 20071023_ike_perl]# rpm -qa | grep My
MySQL-shared-standard-4.1.22-0.rhel3
MySQL-server-4.1.22-0
MySQL-devel-standard-4.1.22-0.rhel3
MySQL-client-4.1.22-0
MySQL-test-standard-4.1.22-0.rhel3
MySQL-standard-debuginfo-4.1.22-0.rhel3
MySQL-shared-compat-4.1.22-0.rhel3

□ perlバージョン

# perl -v

This is perl, v5.8.5 built for i386-linux-thread-multi

Copyright 1987-2004, Larry Wall

Perl may be copied only under the terms of either the Artistic License or the
GNU General Public License, which may be found in the Perl 5 source kit.

Complete documentation for Perl, including FAQ lists, should be found on
this system using `man perl' or `perldoc perl'.  If you have access to the
Internet, point your browser at http://www.perl.com/, the Perl Home Page.

□ perlモジュール
# rpm -qa | grep perl
perl-5.8.5-24.RHEL4
perl-URI-1.30-4
perl-libwww-perl-5.79-5
perl-Crypt-SSLeay-0.51-5
perl-HTML-Tagset-3.03-30
perl-libxml-enno-1.02-31
perl-Net-DNS-0.48-1
perl-XML-Grove-0.46alpha-27
perl-DBD-mysql-4.005-1.el4.rf
newt-perl-1.08-7
mod_perl-1.99_16-4
perl-HTML-Parser-3.35-6
perl-libxml-perl-0.07-30
perl-Time-HiRes-1.55-3
perl-XML-NamespaceSupport-1.08-6
perl-XML-Twig-3.13-6
perl-XML-LibXML-1.58-1
perl-SGMLSpm-1.03ii-14
perl-DBD-Pg-1.31-6
perl-Filter-1.30-6
perl-DBI-1.40-8
perl-Parse-Yapp-1.05-32
perl-XML-Dumper-0.71-2
perl-Digest-SHA1-2.07-5
perl-Convert-ASN1-0.18-3
perl-LDAP-0.31-5
perl-XML-LibXML-Common-0.13-7
perl-DateManip-5.42a-3
perl-XML-Encoding-1.01-26
perl-Digest-HMAC-1.01-13
perl-XML-SAX-0.12-7
perl-dbi-1.51-2tr
perl-XML-Parser-2.34-5

※ 当機は NEC Express5800 / 120Eh モデル です。

[前][次][番号順一覧][スレッド一覧]

->   14249 2007-10-24 17:06 [n-ikeda <n-ikeda@xxx] MySQLとperlの連携について               
     14250 2007-10-24 17:23 ┣[Katsutoshi Nakatomi ]                                       
     14251 2007-10-25 10:58 ┃┗[n-ikeda <n-ikeda@xxx]                                     
     14252 2007-10-25 12:06 ┃ ┣[Masaaki Matsuyama <m]                                   
     14253 2007-10-25 13:14 ┃ ┗[天野 潔 <kiyoshi.am]                                   
     14254 2007-10-25 13:29 ┃  ┗[天野 潔 <kiyoshi.am]                                 
     14255 2007-10-25 16:56 ┣[n-ikeda <n-ikeda@xxx]                                       
     14256 2007-10-25 17:42 ┃┗[HIRATSUKA Sadao <hir]                                     
     14257 2007-10-25 18:40 ┃ ┗[n-ikeda <n-ikeda@xxx]                                   
     14258 2007-10-25 19:04 ┃  ┣[Shintaro Shirai <ytg]                                 
     14259 2007-10-25 19:05 ┃  ┗["TOYOSHIMA,Masayuki"]                                 
     14260 2007-10-25 20:04 ┃   ┗["Yoshiro Ozeki" <yos]                               
     14261 2007-10-26 11:20 ┗[n-ikeda <n-ikeda@xxx]                                       
     14262 2007-10-26 11:23  ┣[n-ikeda <n-ikeda@xxx]                                     
     14263 2007-10-26 12:54  ┗[Katsutoshi Nakatomi ]                                     
     14273 2007-10-29 10:25   ┗[n-ikeda <n-ikeda@xxx]