Harald Tveit Alvestrand | 2 May 09:31 2005
Picon

Bug in DBD::mysql when used under mod_perl - where to report?

Hi,
I have a bug with the use of LISTFIELDS in DBD::mysql used under mod_perl - 
the script attached gives different results under mod_perl 1.27 and under 
normal CGI-BIN execution - under mod_perl, it reports all the lengths as 
zero. Apache 1.3.33.

Can anyone tell me where to report the bug?
(the manpage seemed to say "supported on this list", so that's my first 
try... second bug: the subscribe address doesn't work...)

                   Harald

--

-- 
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe:    http://lists.mysql.com/perl?unsub=gcdmp-msql-mysql-modules <at> m.gmane.org
Yair Lapin | 5 May 10:53 2005
Picon
Picon

FW: test error on installation of DBD::mysql v2.1026 with mysql v 4.1.11


I had the similar problem with DBD::mysql in sparc solaris servers but I
think that the test isn't faithful when it fails. Binaries DBD::mysql
installed after this work without any problems, this driver works with the
same dynamics libraries I used to compile the DBD before. I think if I had
installed the driver compiled by me also it had worked. Few weeks ago I
installed in a new SuSe server DBD::msql and I got very similar error in the
test then I decided to install it although the test failed, I found
everything work fine. The test doesn't work correctly, I found directories
pointing to incorrect sites to load the drivers, the problem is I can't
understand the make files to fix it. I recommend to people have problems
with driver dynamics loading in the test stage to install the driver anyway
and to check it after installations, the test is not faithful.

-----Original Message-----
From: Tim Maynard [mailto:tim <at> redeyeusa.com] 
Sent: Monday, April 25, 2005 11:03 PM
To: perl <at> lists.mysql.com
Subject: test error on installation of DBD::mysql v2.1026 with mysql v4.1.11

trying to compile on RedHat 9.0 with Perl 5.8.6 and MySQL 4.1.11
i have /usr/lib/mysql in the /etc/ld.so.conf and in $LD_RUN_PATH
i have also soft-linked the /usr/local/mysql/lib/* to /usr/lib
and /usr/local/mysql/include/mysql/* to /usr/include/mysql

i cannot find out why that symbol in undefined anywhere.

--------------------------------------------------------
error from make test, used simple 'perl Makefile.PL' to configure:

(Continue reading)

Tim Maynard | 5 May 15:30 2005

RE: test error on installation of DBD::mysql v2.1026 with mysql v4.1.11

installed it anyways and received seg faults on the test script
during the database connection, which is the same error given
by the test script.

ill look into binaries although i have always favored an
optimized/custom install of key applications on my servers

--------------------------------------------------------
test_mysql.pl

#!/usr/bin/perl -w

use strict;
use DBI;

# global values
my $host = 'host.ip.add.res';
my $db   = 'host_db';
my $tbl  = 'host_table';
my $idx  = 'table_key';
my $user = 'username';
my $pswd = 'password';

my( $dbh, $sql, $sth, $cur );

print qq~connecting to db...\n~;
$dbh = DBI->connect("dbi:mysql:$db:$host",$user,$pswd) or
       die(qq~cant open db connection: $!~);

$sql = qq~select distinct $idx from $tbl order by $idx desc limit 25~;
(Continue reading)

Rudy Lippan | 5 May 15:30 2005

RE: test error on installation of DBD::mysql v2.1026 with mysql v4.1.11

On Thu, 5 May 2005, Tim Maynard wrote:

> installed it anyways and received seg faults on the test script
> during the database connection, which is the same error given
> by the test script.

The latest version is 2.9006

-r

--

-- 
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe:    http://lists.mysql.com/perl?unsub=gcdmp-msql-mysql-modules <at> m.gmane.org

Tim Maynard | 5 May 15:44 2005

RE: test error on installation of DBD::mysql v2.1026 with mysql v4.1.11

im using v2.9006 [DBD-mysql-2.9006] and i just found v2.9007 on cpan,
but the changelog for this didnt seem significant for my issues.

-----Original Message-----
From: Rudy Lippan [mailto:rlippan <at> remotelinux.com] 
Sent: Thursday, May 05, 2005 9:30 AM
To: Tim Maynard
Cc: perl <at> lists.mysql.com
Subject: RE: test error on installation of DBD::mysql v2.1026 with mysql
v4.1.11

On Thu, 5 May 2005, Tim Maynard wrote:

> installed it anyways and received seg faults on the test script during

> the database connection, which is the same error given by the test 
> script.

The latest version is 2.9006

-r

--

-- 
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe:    http://lists.mysql.com/perl?unsub=gcdmp-msql-mysql-modules <at> m.gmane.org

Rudy Lippan | 5 May 15:38 2005

RE: test error on installation of DBD::mysql v2.1026 with mysql v4.1.11

On Thu, 5 May 2005, Tim Maynard wrote:

> im using v2.9006 [DBD-mysql-2.9006] and i just found v2.9007 on cpan, but the
> changelog for this didnt seem significant for my issues.

If you are still getting the segfaults with the latest version, send a
DBI->trace(9) and a stack trace. You might also want to verify that you are
linking against the correct client libraries when building DBD::mysql.

rudy

--

-- 
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe:    http://lists.mysql.com/perl?unsub=gcdmp-msql-mysql-modules <at> m.gmane.org

Tim Maynard | 5 May 17:27 2005

RE: test error on installation of DBD::mysql v2.1026 with mysql v4.1.11

- updated my Bundle::DBI through CPAN without any complaints.
- retrieved DBD-mysql-2.9007 version of the driver.
- noticed that i complied mysql with gcc, so modified the Makefile
    to also compile DBD::mysql with gcc as well, including the
libraries:

	-L/usr/lib/gcc-lib/i386-redhat-linux/3.2.2/ -lgcc

-----------------------------------------------------------
make

cp lib/DBD/mysql.pm blib/lib/DBD/mysql.pm
cp lib/DBD/mysql/GetInfo.pm blib/lib/DBD/mysql/GetInfo.pm
cp lib/Mysql.pm blib/lib/Mysql.pm
cp lib/DBD/mysql/INSTALL.pod blib/lib/DBD/mysql/INSTALL.pod
cp lib/Mysql/Statement.pm blib/lib/Mysql/Statement.pm
cp lib/Bundle/DBD/mysql.pm blib/lib/Bundle/DBD/mysql.pm
gcc -c -I/usr/lib/perl5/site_perl/5.8.6/i686-linux/auto/DBI/
-I/usr/include/mysql 
    -DDBD_MYSQL_WITH_SSL -DDBD_MYSQL_INSERT_ID_IS_GOOD -g
-fno-strict-aliasing -pipe 
    -I/usr/local/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64
-I/usr/include/gdbm -O2   
    -DVERSION=\"2.9007\" -DXS_VERSION=\"2.9007\" -fpic
"-I/usr/lib/perl5/5.8.6/i686-linux/CORE"   
    dbdimp.c
/usr/bin/perl -p -e "s/~DRIVER~/mysql/g" 
    /usr/lib/perl5/site_perl/5.8.6/i686-linux/auto/DBI//Driver.xst >
mysql.xsi
/usr/bin/perl /usr/lib/perl5/5.8.6/ExtUtils/xsubpp -typemap
(Continue reading)

Tim Maynard | 10 May 17:12 2005

RE: test error on installation of DBD::mysql v2.1026 with mysql v4.1.11

i have tried recompiling everything for gcc 3.2.2
	perl 5.8.6 compiled and installed successfully with gcc
	mysql 4.1.11 compiled and installed successfully with gcc
	DBD::mysql compiled, but failed intial test.
here is everything that the mysql.so fails to have for the test.

--------------------------------------------------------------
ldd -r blib/arch/auto/DBD/mysql/mysql.so

	libmysqlclient.so.14 => /usr/lib/mysql/libmysqlclient.so.14
(0x40012000)
	libz.so.1 => /usr/lib/libz.so.1 (0x40204000)
	libcrypt.so.1 => /lib/libcrypt.so.1 (0x40224000)
	libnsl.so.1 => /lib/libnsl.so.1 (0x40251000)
	libm.so.6 => /lib/tls/libm.so.6 (0x40266000)
	libssl.so.4 => /lib/libssl.so.4 (0x40289000)
	libcrypto.so.4 => /lib/libcrypto.so.4 (0x402be000)
	libc.so.6 => /lib/tls/libc.so.6 (0x42000000)
	libresolv.so.2 => /lib/libresolv.so.2 (0x403af000)
	libgssapi_krb5.so.2 => /usr/kerberos/lib/libgssapi_krb5.so.2
(0x403c1000)
	libkrb5.so.3 => /usr/kerberos/lib/libkrb5.so.3 (0x403d4000)
	libk5crypto.so.3 => /usr/kerberos/lib/libk5crypto.so.3
(0x40433000)
	libcom_err.so.3 => /usr/kerberos/lib/libcom_err.so.3
(0x40443000)
	libdl.so.2 => /lib/libdl.so.2 (0x40445000)
	/lib/ld-linux.so.2 => /lib/ld-linux.so.2 (0x80000000)
undefined symbol: PL_perl_destruct_level
(blib/arch/auto/DBD/mysql/mysql.so)
(Continue reading)

Jacqueline Lee | 11 May 03:23 2005
Picon

Help - error during "make" for DBD

Hi,

I need help.  I always encounter this error when I execute the "make" command to install the
DBD-mysql-2.9007.  Can someone please tell me what to do?

# make
cp lib/DBD/mysql.pm blib/lib/DBD/mysql.pm
cp lib/DBD/mysql/GetInfo.pm blib/lib/DBD/mysql/GetInfo.pm
cp lib/Mysql.pm blib/lib/Mysql.pm
cp lib/DBD/mysql/INSTALL.pod blib/lib/DBD/mysql/INSTALL.pod
cp lib/Mysql/Statement.pm blib/lib/Mysql/Statement.pm
cp lib/Bundle/DBD/mysql.pm blib/lib/Bundle/DBD/mysql.pm
gcc -c  -I/opt/iw-home/iw-perl/vendor/lib/auto/DBI -I'/usr/local/mysql/include' -g 
-DUSE_HAS_SEED_EXPLICIT -fno-strict-aliasing -I/usr/local/include -D_LARGEFILE_SOURCE
-D_FILE_OFFSET_BITS=64 -O    -DVERSION=\"2.9007\"  -DXS_VERSION=\"2.9007\" -fPIC
"-I/opt/iw-home/iw-perl/lib/CORE"   dbdimp.c
/opt/iw-home/iw-perl/bin/perl -p -e "s/~DRIVER~/mysql/g"
/opt/iw-home/iw-perl/vendor/lib/auto/DBI/Driver.xst > mysql.xsi
/opt/iw-home/iw-perl/bin/perl /opt/iw-home/iw-perl/lib/ExtUtils/xsubpp  -typemap
/opt/iw-home/iw-perl/lib/ExtUtils/typemap  mysql.xs > mysql.xsc && mv mysql.xsc mysql.c
Warning: duplicate function definition 'do' detected in mysql.xs, line 196
Warning: duplicate function definition 'rows' detected in mysql.xs, line 294
gcc -c  -I/opt/iw-home/iw-perl/vendor/lib/auto/DBI -I'/usr/local/mysql/include' -g 
-DUSE_HAS_SEED_EXPLICIT -fno-strict-aliasing -I/usr/local/include -D_LARGEFILE_SOURCE
-D_FILE_OFFSET_BITS=64 -O    -DVERSION=\"2.9007\"  -DXS_VERSION=\"2.9007\" -fPIC
"-I/opt/iw-home/iw-perl/lib/CORE"   mysql.c
Running Mkbootstrap for DBD::mysql ()
chmod 644 mysql.bs
rm -f blib/arch/auto/DBD/mysql/mysql.so
LD_RUN_PATH="/usr/lib" /opt/iw-home/iw-perl/bin/perl myld gcc  -Wl,-E -G -L/usr/local/lib dbdimp.o 
(Continue reading)

Jochen Wiedmann | 11 May 03:32 2005
Picon

Re: Help - error during "make" for DBD

Jacqueline Lee wrote:

> /usr/ccs/bin/ld: illegal option -- E

My guess is, that you are using a build of MySQL, which is compiled by
another source. If so, you have two options:

a) Recompile the MySQL binaries for yourself. (Recommended)
b) Try to modify the linker flags, that mysqlconfig gives to you,
   for example, by removing this -Wl,-E. The output of "perl
   Makefile.PL" should tell you, what options you have now,
   so that a modified "--libs", or "--cflags" option for "perl
   Makefile.PL" should be created easily.

Jochen

--

-- 
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe:    http://lists.mysql.com/perl?unsub=gcdmp-msql-mysql-modules <at> m.gmane.org


Gmane