Problem installing 4.006 under cygwin - "Cannot find the file "mysql_config"!"

--------------080904030307000402060001
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

I'm about at the end of my rope on this. I'm running on XP Pro SP2 and
have Cygwin 2.573.2.2 (setup version,) MySQL version 5.0.51a, perl
version 5.8.8, and DBD-mysql-4.006

I'm trying to get perl to talk to a local MySQL 5 DB, and I can't get
DBD::mysql to install properly. Of course, I had to figure out a way to
move the home directory so that I could overcome the lack of support for
directory trees including spaces in the path, and I needed to compile
MySql 5 drivers under cygwin, but now I'm totally stumped!

I've been trying to run "perl -MCPAN -e 'install DBD::mysql'" but it
barfs when it tries to run the mysql_config, even though I purposefully
added it's location as the FIRST ITEM on the path.

I thought I'd follow the instructions to build the blasted thing
manually, as documented here:
http://search.cpan.org/~capttofu/DBD-mysql-4.005/lib/DBD/mys ql.pm
but it apparently requires nmake which I don't think is available under
cygwin.

I'm pretty frustrated at this point and would appreciate any help you
can provide.

Output from the command is below....

DBD-mysql-4.006/TODO
Removing previously used /cygdrive/c/home/tcooper/build/DBD-mysql-4.006

CPAN.pm: Going to build C/CA/CAPTTOFU/DBD-mysql-4.006.tar.gz

Can't exec "mysql_config": No such file or directory at Makefile.PL
line 76.

Cannot find the file 'mysql_config'! Your execution PATH doesn't seem
not contain the path to mysql_config. Resorting to guessed values!
Can't exec "mysql_config": No such file or directory at Makefile.PL
line 466.
Can't exec "mysql_config": No such file or directory at Makefile.PL
line 466.
Can't exec "mysql_config": No such file or directory at Makefile.PL
line 466.
Can't exec "mysql_config": No such file or directory at Makefile.PL
line 466.
Can't exec "mysql_config": No such file or directory at Makefile.PL
line 466.
Can't exec "mysql_config": No such file or directory at Makefile.PL
line 466.
Failed to determine directory of mysql.h. Use

perl Makefile.PL --cflags=-I

Re: Problem installing 4.006 under cygwin - "Cannot find the file"mysql_config"!"

Greetings, Tom. I know your pain well...

on 4/5/2008 10:51 AM Tom Cooper said the following:
> I... have Cygwin 2.573.2.2 MySQL version 5.0.51a, perl
> version 5.8.8, and DBD-mysql-4.006
> I thought I'd follow the instructions ... here:
> http://search.cpan.org/~capttofu/DBD-mysql-4.005/lib/DBD/mys ql.pm
> [but get...]
> Can't exec "mysql_config": No such file or directory at Makefile.PL
> line 76.

There are two _other_ sets of installation instructions bundled with
DBD::mysql -- in the README and INSTALL files. They are more complete
than what is found in DBD/mysql.pm.

But confusingly in regard to Cygwin, those two sets of instructions
differ from each other. The INSTALL instructions will get you farther.
But still, under Cygwin's Perl 5.10 they failed (see my original post in
this thread last month). You'll probably have better luck under Perl
5.8. (See also my note in the last paragraph of this email on Cygwin
recently down-grading Perl.)

The copy of mysql_config that you report finding in
/cygdrive/c/mysql/mysql-5.0.51a/ looks like the one for your
_Windows_XP_ install of mysql. That won't help you here.

In addition to your copy of mysql for WinXP, you need to compile a
client-only version of the mysql tools _under_Cygwin_ and then use the
resulting copy of mysql_config for your install of DBD::mysql. The
process is a bit of a bother, but is well described in the INSTALL file
and worked fine for me when I did this a few years back (under Perl 5.8
or 5.6).

All of this is much more fully described in the instructions under
"Special Systems - Windows/Cygwin" in the bundled INSTALL file...

Check here:
http://search.cpan.org/~capttofu/DBD-mysql-4.006/lib/DBD/mys ql/INSTALL.pod#Windows/CygWin

or if that gets broken this will get you there:
http://tinyurl.com/6dzhvb
and scroll down to "Special Systems - Windows/Cygwin"

Please let us know if DBD::mysql's INSTALL instructions work under
Cygwin Perl 5.8.8. My current setup is working and I'm hesitant to mess
with it to test things. ;-)

BTW, since I posted on this issue under Cygwin Perl 5.10 last month,
Cygwin seems to have mysteriously down-graded perl from 5.10 to 5.8.
After a recent Cygwin setup.exe update for other reasons, my previous
install of DBD::mysql now magically works again without any effort on my
part. Go figure!

HTH
David

--
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe: http://lists.mysql.com/perl?unsub=gcdmp-msql-mysql-modules@m .gmane.org

Re: Problem installing 4.006 under cygwin - "Cannot find the file"mysql_config"!"

If anyone has any information I can add/change to make this better,
please let me know - I'd even be glad to give CPAN commit status to
anyone wanting to contribute. The windows issues are hard nuts to crack ;)

--Patrick


David Vergin wrote:

> Greetings, Tom. I know your pain well...
>
> on 4/5/2008 10:51 AM Tom Cooper said the following:
>
>> I... have Cygwin 2.573.2.2 MySQL version 5.0.51a, perl
>> version 5.8.8, and DBD-mysql-4.006
>> I thought I'd follow the instructions ... here:
>> http://search.cpan.org/~capttofu/DBD-mysql-4.005/lib/DBD/mys ql.pm
>> [but get...]
>> Can't exec "mysql_config": No such file or directory at Makefile.PL
>> line 76.
>
>
> There are two _other_ sets of installation instructions bundled with
> DBD::mysql -- in the README and INSTALL files. They are more complete
> than what is found in DBD/mysql.pm.
>
> But confusingly in regard to Cygwin, those two sets of instructions
> differ from each other. The INSTALL instructions will get you farther.
> But still, under Cygwin's Perl 5.10 they failed (see my original post
> in this thread last month). You'll probably have better luck under
> Perl 5.8. (See also my note in the last paragraph of this email on
> Cygwin recently down-grading Perl.)
>
> The copy of mysql_config that you report finding in
> /cygdrive/c/mysql/mysql-5.0.51a/ looks like the one for your
> _Windows_XP_ install of mysql. That won't help you here.
>
> In addition to your copy of mysql for WinXP, you need to compile a
> client-only version of the mysql tools _under_Cygwin_ and then use the
> resulting copy of mysql_config for your install of DBD::mysql. The
> process is a bit of a bother, but is well described in the INSTALL
> file and worked fine for me when I did this a few years back (under
> Perl 5.8 or 5.6).
>
> All of this is much more fully described in the instructions under
> "Special Systems - Windows/Cygwin" in the bundled INSTALL file...
>
> Check here:
> http://search.cpan.org/~capttofu/DBD-mysql-4.006/lib/DBD/mys ql/INSTALL.pod#Windows/CygWin
>
>
> or if that gets broken this will get you there:
> http://tinyurl.com/6dzhvb
> and scroll down to "Special Systems - Windows/Cygwin"
>
> Please let us know if DBD::mysql's INSTALL instructions work under
> Cygwin Perl 5.8.8. My current setup is working and I'm hesitant to
> mess with it to test things. ;-)
>
> BTW, since I posted on this issue under Cygwin Perl 5.10 last month,
> Cygwin seems to have mysteriously down-graded perl from 5.10 to 5.8.
> After a recent Cygwin setup.exe update for other reasons, my previous
> install of DBD::mysql now magically works again without any effort on
> my part. Go figure!
>
> HTH
> David
>


--
Patrick Galbraith, Senior Programmer
Grazr - Easy feed grazing and sharing
http://www.grazr.com

Satyam Eva Jayate - Truth Alone Triumphs
Mundaka Upanishad




--
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe: http://lists.mysql.com/perl?unsub=gcdmp-msql-mysql-modules@m .gmane.org

Re: Problem installing 4.006 under cygwin - "Cannot find the file"mysql_config"!"

on 4/8/2008 3:09 PM Patrick Galbraith said the following:
> ...I'd even be glad to give CPAN commit status to
> anyone wanting to contribute. The windows issues are hard
> nuts to crack ;)

I'd be happy to receive a commit bit and help with the docs regarding
DBD::mysql on Cygwin. The first thing I'd do is make the comments in
DBD/mysql.pm and README point to INSTALL so that there is a single point
of guidance regarding Cygwin installs.

Do changes pass through you? And if not, how do we assure that a
potential collaborator (i.e. me) posts changes that are in harmony with
the intentions of the primary maintainer (viz: you).

This would probably mean that I'd need to re-up for the Cygwin list and
find out who is handling the Perl packages at that end. I have no idea
why they down-graded Perl from 5.10 and when they are likely to come
back with 5.10 again. This could be an issue and anyone doing docs for
the community ought to be on top of the whole picture.

Maybe we could convince the Cygwin folks to include DBD::mysql in their
setup offerings as they do with some of the other tricky packages.

Regards,
David Vergin


--
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe: http://lists.mysql.com/perl?unsub=gcdmp-msql-mysql-modules@m .gmane.org

Re: Problem installing 4.006 under cygwin - "Cannot find the file"mysql_config"!"

David Vergin wrote:

> on 4/8/2008 3:09 PM Patrick Galbraith said the following:
> > ...I'd even be glad to give CPAN commit status to
> > anyone wanting to contribute. The windows issues are hard
> > nuts to crack ;)
>
> I'd be happy to receive a commit bit and help with the docs regarding
> DBD::mysql on Cygwin. The first thing I'd do is make the comments in
> DBD/mysql.pm and README point to INSTALL so that there is a single
> point of guidance regarding Cygwin installs.
>
> Do changes pass through you?

It depends I suppose. I have a bit of faith in what people want to do.
You obviously want to improve this part of the documentation, so that's
a good thing.


> And if not, how do we assure that a potential collaborator (i.e. me)
> posts changes that are in harmony with the intentions of the primary
> maintainer (viz: you).

To do more releases, and more hands/eys makes that more possible.
Windows support is something I'd like to improve.

>
> This would probably mean that I'd need to re-up for the Cygwin list
> and find out who is handling the Perl packages at that end. I have no
> idea why they down-graded Perl from 5.10 and when they are likely to
> come back with 5.10 again. This could be an issue and anyone doing
> docs for the community ought to be on top of the whole picture.
>
> Maybe we could convince the Cygwin folks to include DBD::mysql in
> their setup offerings as they do with some of the other tricky packages.

That'd be great.

feel free to send me in another email your cpan id.

Thanks!

Patrick

>
> Regards,
> David Vergin
>
>


--
Patrick Galbraith, Senior Programmer
Grazr - Easy feed grazing and sharing
http://www.grazr.com

Satyam Eva Jayate - Truth Alone Triumphs
Mundaka Upanishad




--
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe: http://lists.mysql.com/perl?unsub=gcdmp-msql-mysql-modules@m .gmane.org