ports/153588: Character set 'latin1' is not a compiled character set and is not specified

[Richard Anthony Secor]

>Number:         153588
>Category:       ports
>Synopsis:       Character set 'latin1' is not a compiled character set and is not specified
>Confidential:   no
>Severity:       serious
>Priority:       medium
>Responsible:    freebsd-ports-bugs
>State:          open
>Quarter:        
>Keywords:       
>Date-Required:
>Class:          sw-bug
>Submitter-Id:   current-users
>Arrival-Date:   Fri Dec 31 19:50:08 UTC 2010
>Closed-Date:
>Last-Modified:
>Originator:     Richard Anthony Secor
>Release:        8.1-RELEASE
>Organization:
>Environment:
FreeBSD fbsd1.prestigehq.com 8.1-RELEASE FreeBSD 8.1-RELEASE #0: Mon Jul 19 02:36:49 UTC 2010     root at mason.cse.buffalo.edu:/usr/obj/usr/src/sys/GENERIC  amd64
and
FreeBSD dper710a.prestigehq.com 8.1-RELEASE FreeBSD 8.1-RELEASE #0: Mon Jul 19 02:36:49 UTC 2010     root at mason.cse.buffalo.edu:/usr/obj/usr/src/sys/GENERIC  amd64

>Description:
Please reference the following MySQL bug report: http://bugs.mysql.com/bug.php?id=59243

Under perl:
Failure on connection and exits script.

Under php:
Failure on connection and script just hangs.

This issue seems to be the same as those having problems with ODBC connectors, etc that
I've seen in other bugs. However, they do not go on to specifically find the issue and
ultimately correct it.

It also appears that this bug has found it's way into the code on and off for years. It
must be something simple somewhere that anyone coding anything in MySQL must be made
aware of, once found, so that it does not show up again, after it's fixed, in the future.


>How-To-Repeat:
On FreeBSD 8.1-RELEASE install the following ports:

For Perl:
lang/perl5.12
databases/mysql55-client
databases/mysql55-server
www/apache22
databases/p5-DBI
databases/p5-DBD-mysql55

For php:
lang/perl5.12
databases/mysql55-client
databases/mysql55-server
lang/php5
databases/php5-mysql
 WITH_MYSQLND=false
databases/php5-mysqli
 WITH_MYSQLND=false


>Fix:
Perl uses the libraries for the currently installed copy of MySQL.
PHP uses the libraries for the currently installed copy of MySQL where
WITH_MYSQLDN=false.

This leads me to believe it is something in MySQL itself.

Temporary fix for PHP is to compile the PHP library with WITH_MYSQLDN=true so that it
uses the PHP embedded libraries for talking with MySQL. While this is not desired it does
work.

-----------------------------------------------------------------
Downloaded:
mysql-5.5.8-freebsd8.0-x86_64.tar.gz

Extracted to:
/usr/local/mysql-5.5.8-freebsd8.0-x86_64
Linked to /usr/local/mysql

And re-compiled/re-installed p5-DBD-mysql against it by doing the following:
export PATH=/usr/local/mysql:$PATH
cd /usr/ports/databases/p5-DBD-mysql
make clean
make deinstall
make install

This fixes the perl module. I would guess that the same would be true of the php
modules.


>Release-Note:
>Audit-Trail:
>Unformatted: