ports/153825: p5-DBD-mysql fails with mysql-client-5.5.8 port

[Mike Andrews]

>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 at 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: