Date: Fri, 31 Dec 2010 19:43:35 GMT From: Richard Anthony Secor <rsecor@seqlogic.com> To: freebsd-gnats-submit@FreeBSD.org Subject: ports/153588: Character set 'latin1' is not a compiled character set and is not specified Message-ID: <201012311943.oBVJhZqv072376@red.freebsd.org> Resent-Message-ID: <201012311950.oBVJo8Q5067999@freefall.freebsd.org>
next in thread | raw e-mail | index | archive | help
>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@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@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:
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?201012311943.oBVJhZqv072376>