Date: Sun, 9 Jan 2011 15:12:47 -0500 (EST) From: Mike Andrews <mandrews@bit0.com> To: FreeBSD-gnats-submit@FreeBSD.org Subject: ports/153825: p5-DBD-mysql fails with mysql-client-5.5.8 port Message-ID: <20110109201247.803422B4905@beast.int.bit0.com> Resent-Message-ID: <201101092020.p09KK41o012240@freefall.freebsd.org>
next in thread | raw e-mail | index | archive | help
>Number: 153825
>Category: ports
>Synopsis: p5-DBD-mysql fails with mysql-client-5.5.8 port
>Confidential: no
>Severity: critical
>Priority: high
>Responsible: freebsd-ports-bugs
>State: open
>Quarter:
>Keywords:
>Date-Required:
>Class: sw-bug
>Submitter-Id: current-users
>Arrival-Date: Sun Jan 09 20:20:04 UTC 2011
>Closed-Date:
>Last-Modified:
>Originator: Mike Andrews
>Release: FreeBSD 8.2-PRERELEASE amd64
>Organization:
Fark, Inc
>Environment:
System: FreeBSD beast.int.bit0.com 8.2-PRERELEASE FreeBSD 8.2-PRERELEASE #31: Fri Dec 31 17:53:11 EST 2010 mandrews@beast.int.bit0.com:/usr/obj/usr/src/sys/BIT0 amd64
>Description:
Starting with the update from MySQL client 5.5.7 to 5.5.8, Perl DBI applications fail to run.
With the mysql-client-5.5.8 port installed, you get:
Character set 'latin1' is not a compiled character set and is not specified in the '/usr/local/share/mysql/charsets/Index.xml' file
DBI connect('database:host;mysql_compression=1','username',...) failed: Can't initialize character set latin1 (path: /usr/local/share/mysql/charsets/) at (name of script)
And indeed, the entire /usr/local/share/mysql directory is missing in the 5.5.8 port, where it is present in 5.5.7.
With the mysql-client-5.5.8_1 port installed (which involved a pthreads fix), Perl (the default non-threaded one) SIGSEGV's.
This is a pretty serious showstopper for the upcoming 8.2-RELEASE ports freeze, I would think.
I have tried renstalling the p5-DBD-mysql port with no success.
>How-To-Repeat:
install databases/mysql55-client port, databases/p5-DBD-mysql port, and:
#!/usr/local/bin/perl
use strict;
use warnings;
use DBI;
my $db = DBI->connect ('DBI:mysql:test:some.host.name;mysql_compression=1', 'username', 'password') or die "db busted\n";
$db->disconnect;
exit;
>Fix:
Use the 5.5.7 version of /usr/ports/databases/mysql55-client/* from mid December 2010
>Release-Note:
>Audit-Trail:
>Unformatted:
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?20110109201247.803422B4905>