Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
General
GeneralPortable MacsHardwareNetworking
Applications
Mac ApplicationsEudoraFirefox / MozillaInternet ExplorerOutlook ExpressMS OfficeEntourageExcelPowerPointWordVirtual PCMedia PlayerOther MS Products
Programming
Mac ProgrammingCodeWarriorPerl
Country Specific
Australian Mac GroupUK Mac Group

Mac Forum / Programming / Perl / February 2005



Tip: Looking for answers? Try searching our database.

Can't get DBD::mysql installed

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Boysenberry Payne - 15 Feb 2005 17:51 GMT
Hello everyone,

    I'm doing a fresh install of my OS X 10.3 and am to the point where
I'm trying to
get DBD::mysl installed.  I found a website that gives good
instructions for OS X, but
I'm getting a few errors on make test (mysql.t 46-48) that stops it
from getting to make
install.

    Am I doing something wrong?
The website with the instructions I'm following is here:
http://www.truerwords.net/3556

Thanks ahead of time,
Boysenberry
Boysenberry Payne - 15 Feb 2005 17:56 GMT
Nevermind,

    It seems as though it's installed regardless...

> Hello everyone,
>
[quoted text clipped - 12 lines]
> Thanks ahead of time,
> Boysenberry
Chris Devers - 15 Feb 2005 19:09 GMT
>     It seems as though it's installed regardless...

But the errors may still exist; it's good to correct, or at least fully
understand, any `make test` errors you come across.

This page has the correct fix for the DBD::Mysql problem:

 <http://www.mail-archive.com/macosx%40perl.org/msg05736.html>

The fix, in full, is as follows:

 We recently discovered the DBD::mysql problem as well. The patch is to
 edit /System/Library/Perl/5.8.1/darwin-thread-multi-2level/Config.pm,
 replacing:

   ld='MACOSX_DEPLOYMENT_TARGET=10.3 cc'

 with

   ld='env MACOSX_DEPLOYMENT_TARGET=10.3 cc'

 Unfortunately, this change is too late to get into Panther.

The instructions at <http://www.truerwords.net/3556> patch the symptom,
but not the underlying problem; other module instals could have the same
problem. It's better to address what's really causing this error.

(Not that this is a mod_perl issue either, but oh well.)

Signature

Chris Devers

Sherm Pendley - 15 Feb 2005 20:39 GMT
>>     It seems as though it's installed regardless...
>
[quoted text clipped - 4 lines]
>
>   <http://www.mail-archive.com/macosx%40perl.org/msg05736.html>

...

> The instructions at <http://www.truerwords.net/3556> patch the symptom,
> but not the underlying problem

What's bizarre is that those instructions link to Ed Moy's email too -
The author *knows* about the permanent fix, and chooses to provide a
band-aid instead.

sherm--

Cocoa programming in Perl: http://camelbones.sourceforge.net
Hire me! My resume: http://www.dot-app.org
Boysenberry Payne - 16 Feb 2005 06:59 GMT
Thanks for the patch/fix.  Do you think I should rebuild DBD::mysql?

> ld='MACOSX_DEPLOYMENT_TARGET=10.3 cc'
Chris Devers - 16 Feb 2005 12:52 GMT
> > ld='MACOSX_DEPLOYMENT_TARGET=10.3 cc'
>
> Thanks for the patch/fix.  Do you think I should rebuild DBD::mysql?

It certainly wouldn't hurt, and it would only take a few minutes.

It's worth doing.


Signature

Chris Devers

Boysenberry Payne - 17 Feb 2005 16:00 GMT
I tried to reinstall as suggested and still get the same :
t/mysql.t                 68    3   4.41%  46-48
It fails on 46-48.

I'm still able to use it, so no big deal for me, but I would, like you
suggested, find out why it's not behaving as it should.

Maybe someone is familiar enough with the DBD::mysql
mysql test suite enough to describe what tests 46-48 are
for and how to get them to behave correctly.  I imagine
if the test fail, anything I try to do that the tests are trying
will fail for me as well...

Thanks again for all the help!
Boysenberry

>>> ld='MACOSX_DEPLOYMENT_TARGET=10.3 cc'
>>
[quoted text clipped - 3 lines]
>
> It's worth doing.
Jason Kerr - 26 Feb 2005 22:03 GMT
> I tried to reinstall as suggested and still get the same :
> t/mysql.t                 68    3   4.41%  46-48
> It fails on 46-48.
>
> I'm still able to use it, so no big deal for me, but I would, like you
> suggested, find out why it's not behaving as it should.

I get the same errors when testing. I guess 'force install' will have  
to do, for now.

According to Rudy Lippan on comp.db.mysql.perl, the error is caused by  
case-folding causing table file problems. He isn't that diplomatic,  
saying:

"IIRC, this is because OS X has a broken file system that does not know  
the
difference between 'File' and 'file', and since mysql just stores the  
table
names as files on disk, the caps in the test are screwing with the test  
results
(I think this might be fixed in CVS, but I'd have to check)."

http://article.gmane.org/gmane.comp.db.mysql.perl/1483

A conversation last March on another forum was more detailed, but it  
appear that Lippan may be right:
http://www.mysqlmonster.com/Uwe/Forum.aspx/mysql-modules/245/Install-
DBD-mysql-on-Mac-10-3-2

I, too, am not proficient at this, so duplicating results was the  
extent of my experiments.

Jason
Joel Rees - 27 Feb 2005 09:36 GMT
> According to Rudy Lippan on comp.db.mysql.perl, the error is caused by  
> case-folding causing table file problems. He isn't that diplomatic,  
[quoted text clipped - 14 lines]
> http://www.mysqlmonster.com/Uwe/Forum.aspx/mysql-modules/245/Install-
> DBD-mysql-on-Mac-10-3-2

I think the case insensitivity problem shows up quite regularly in the  
archives, particularly with respect to HEAD getting overwritten.

BTW, I noticed somewhere recently, maybe on macosxhints, that there is  
a way to mke HFS+ volumes case-sensitive when you partition. That might  
be an option.

I myself put as many of my additional unix tools as I can on UFS  
partitions. It seems more secure that way to me.
Donny Forbes - 16 Feb 2005 14:34 GMT
Chris,

Not so much of a mysql problem. Basically I need to know how to upgrade
the mod_perl.

Here is what I did:

I am running apache version:
Server version: Apache/2.0.46

And when trying to do the following /home/dforbes/bin/actl <app> start I
am getting the following error message.

httpd: module "mod_perl.c" is not compatible with this version of Apache
(found 20020628, need 20020903). Please contact the vendor for the
correct version.

I have downloaded the latest from http://modules.apache.org and
installed it by doing this.

tar -zxvf mod_perl-2.0-current.tar.gz
cd mod_perl-2.0.0-RC4/

#perl Makefile.PL MP_INST_APACHE2=1 MP_APXS=/path/to/apxs \
   MP_APR_CONFIG=/another/path/to/apr-config <other options

I did use the correct paths etc.. Then did make && make install ..
When done I add the following to the httpd.conf file. Then stop and
Started httpd and here is the version I am on now:

Tue Feb 15 13:41:52 2005] [notice] Apache/2.0.52 (Unix)
mod_perl/1.999.21 Perl/v5.8.0 configured -- resuming normal operations

# Dynamic Shared Object (DSO) Support

LoadModule perl_module modules/mod_perl.so

Also here is an output of my make test!

[Tue Feb 15 07:26:25 2005] [error] Need CGI.pm or Apache::Request to
operate at /var/tmp/mod_perl-2.0.0-RC4/blib/lib/Apache2/Apache/Status.pm
line 50.\nCompilation failed in require at
/var/tmp/mod_perl-2.0.0-RC4/t/conf/post_config_startup.pl line
52.\nCompilation failed in require at (eval 104) line 1.\n
[Tue Feb 15 07:26:25 2005] [error] Can't load Perl file:
/var/tmp/mod_perl-2.0.0-RC4/t/conf/post_config_startup.pl for server
localhost.localdomain:8529, exiting...

Please let me know what I am doing wrong.. I need help ..

Thanks,
~D


-----Original Message-----
From: Chris Devers [mailto:cdevers@pobox.com]
Sent: Tuesday, February 15, 2005 11:09 AM
To: Boysenberry Payne
Cc: OSX Perl Group; mod_perl
Subject: Re: Can't get DBD::mysql installed

>     It seems as though it's installed regardless...

But the errors may still exist; it's good to correct, or at least fully
understand, any `make test` errors you come across.

This page has the correct fix for the DBD::Mysql problem:

 <http://www.mail-archive.com/macosx%40perl.org/msg05736.html>

The fix, in full, is as follows:

 We recently discovered the DBD::mysql problem as well. The patch is to
 edit /System/Library/Perl/5.8.1/darwin-thread-multi-2level/Config.pm,
 replacing:

   ld='MACOSX_DEPLOYMENT_TARGET.3 cc'

 with

   ld='env MACOSX_DEPLOYMENT_TARGET.3 cc'

 Unfortunately, this change is too late to get into Panther.

The instructions at <http://www.truerwords.net/3556> patch the symptom,
but not the underlying problem; other module instals could have the same
problem. It's better to address what's really causing this error.

(Not that this is a mod_perl issue either, but oh well.)

--
Chris Devers

**********************************************************************
This message contains confidential information intended only for the
use of the addressee(s) named above and may contain information that
is legally privileged.  If you are not the addressee, or the person
responsible for delivering it to the addressee, you are hereby
notified that reading, disseminating, distributing or copying this
message is strictly prohibited.  If you have received this message by
mistake, please immediately notify us by replying to the message and
delete the original message immediately thereafter.

Thank you.                                       FADLD Tag
**********************************************************************
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.