Keith Thomas | 15 Dec 23:22 2009
Picon

problems loading DBD::MySQL

Hi

I keep running into the following error when attempting to load the DBD for
mysql:

C:\PROGRA~1\MySQL\MYSQLS~1.1\bin\MYSQLA~1.EXE: connect to server at
'localhost'
failed
error: 'Access denied for user 'ODBC' <at> 'localhost' (using password: NO)'

I originally tried to install through CPAN but kept getting 500 errors when
trying to connect (probably blocked by my company's IT), so I pulled the tar
down and decompressed it to load it manually. I had no troubles getting DBI
to load. I am using MySQl 5.1.41 - the test DB and default accounts all
appear there correctly, and i have went as far as giiving the
ODBC <at> localhostaccount full permissions to the test DB and still get
the same error. Any
idea what I am missing?

Thanks

Keith Thomas
Michael R Boudreau | 16 Dec 16:03 2009

Re: problems loading DBD::MySQL

Keith,

The "access denied" error message indicates that your script is successfully contacting the MySQL
server, but the user 'ODBC' doesn't have permission to connect without a password from whatever host your
script is running on.

On 12/15/09 4:22 PM, "Keith Thomas" <kttradesltd <at> gmail.com> wrote:

Hi

I keep running into the following error when attempting to load the DBD for
mysql:

C:\PROGRA~1\MySQL\MYSQLS~1.1\bin\MYSQLA~1.EXE: connect to server at
'localhost'
failed
error: 'Access denied for user 'ODBC' <at> 'localhost' (using password: NO)'

I originally tried to install through CPAN but kept getting 500 errors when
trying to connect (probably blocked by my company's IT), so I pulled the tar
down and decompressed it to load it manually. I had no troubles getting DBI
to load. I am using MySQl 5.1.41 - the test DB and default accounts all
appear there correctly, and i have went as far as giiving the
ODBC <at> localhostaccount full permissions to the test DB and still get
the same error. Any
idea what I am missing?

Thanks

Keith Thomas
(Continue reading)

Keith Thomas | 16 Dec 21:47 2009
Picon

Re: problems loading DBD::MySQL

Ok so I "think" I have it loaded...
Here is what I did:
-unloaded mySQl 5.1.41 and loaded 5.0.88 (I read an article last night
saying that there might be a version issue...)
-created a user 'ODBC' <at> 'localhost' in the test DB and gave it all privileges
-pulled the DBD-mysql-4.013 package local (we have a fun firewall that wont
let me out using ppm)
-ran the makefile.pl as local admin
-tried to run nmake then had to go back and edit the makefile  and swap libs
- libmysql.lib for mysqlclient.lib
-nmake then ran successfully
-nmake test passed (barely) with it skipping 35 of 36 tests (I also dropped
my.ini in the win root - didn't make a diference on the test)
-ran nmake install which ran succesffully

my only question now is that when I go to the ppm repository and look, it
does not list DBD::mysql, but if I go to
the \Perl\site\lib\DBD\mysql I find a pod and pm file. Am I ok then?

Thanks

Keith
On Wed, Dec 16, 2009 at 7:03 AM, Michael R Boudreau <
mboudreau <at> press.uchicago.edu> wrote:

> Keith,
>
> The “access denied” error message indicates that your script is
> successfully contacting the MySQL server, but the user ‘ODBC’ doesn’t have
> permission to connect without a password from whatever host your script is
(Continue reading)

Selke, Gisbert W. | 17 Dec 16:36 2009
Picon

AW: problems loading DBD::MySQL

Hi Keith --

> -----Ursprüngliche Nachricht-----
> Von: Keith Thomas [mailto:kttradesltd <at> gmail.com] 
> Gesendet: Mittwoch, 16. Dezember 2009 21:47
 my only question now is that when I go to the ppm repository 
> and look, it does not list DBD::mysql, but if I go to the 
> \Perl\site\lib\DBD\mysql I find a pod and pm file. Am I ok then?
It's an old and unresolved issue that ppm will not pick up any manual installations. ppm is all very nice and
handy where it works, but sometimes it doesn't, and you have to resort to other means (like you did). Then
ppm will not know about this, but perl itself will: Try 
perl -MDBD::mysql -e "print $DBD::mysql::VERSION" 
The next glitch will come up when next time you will be using ppm in order to upgrade DBD::mysql (supposing
you resolve the firewall problem). I guess one could write a "repair script" for the ppm database to update
it about all the manual changes (probably someone already has one this -- I haven't been concerned enough myself).

If you're really concerned about it, there is still one way out:
* make your DBD::mysql as described by you, but do not install
* make ppm
* Take the resulting ppm/ppd files and drop them into some directory that will serve as your local ppm repository
* direct ppm (the programme) to your local repository instead of one of those on the internet
* install

\Gisbert

--

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

(Continue reading)

Keith Thomas | 17 Dec 20:52 2009
Picon

Re: problems loading DBD::MySQL

OK
boy is my face red! It was a port issue! MySQL defaults to 3306 and my
machine was stepping on the port.
I did go back and check the version as you described and it is indeed loaded
(v4.013) even though PPM says its not there. Afterwards I went to the effort
of cleaning the makefile and starting over with the makefile.pl - this time
I explicitly called the libmysql.lib when I  compiled it - Next I ran the
'make test' only to see the same skips. At that point I jumped into the
mysql.mtest and specified the DB name, user and password. once I re-ran the
test it started connecting, but with 15 of 35 tests failing and 745 subtest
failing. I did build out a small test program and it connected with out
issue this time. Do I ignore the fails at this point, consider myself luck
and go on with my life?

btw: thanks for all the advice!

Keith

On Thu, Dec 17, 2009 at 7:36 AM, Selke, Gisbert W. <
Gisbert.Selke <at> wido.bv.aok.de> wrote:

> Hi Keith --
>
> > -----Ursprüngliche Nachricht-----
> > Von: Keith Thomas [mailto:kttradesltd <at> gmail.com]
> > Gesendet: Mittwoch, 16. Dezember 2009 21:47
>  my only question now is that when I go to the ppm repository
> > and look, it does not list DBD::mysql, but if I go to the
> > \Perl\site\lib\DBD\mysql I find a pod and pm file. Am I ok then?
> It's an old and unresolved issue that ppm will not pick up any manual
(Continue reading)

Selke, Gisbert W. | 17 Dec 22:06 2009
Picon

AW: problems loading DBD::MySQL


	-----Ursprüngliche Nachricht-----
	Von: Keith Thomas [mailto:kttradesltd <at> gmail.com] 
	Gesendet: Donnerstag, 17. Dezember 2009 20:52
	
	 [..] , but with 15 of 35 tests failing and 745 subtest failing. I did build out a small test program and it
connected with out issue this time. Do I ignore the fails at this point, consider myself luck and go on with
my life?

I guess it depends on which tests were failing. If it looks like some functionality that you need: better
not. It also depends on the alternatives. (Do you have some older DBD::mysql that you know works fine, and
that satisfies your needs? Try Randy Kobes' archive.)
I know I've had trouble recompiling DBD::mysql in the past several times, and I try to avoid having to do
that. Usually that works for me, because I hardly ever need bleeding edge functionality.

\Gisbert

Gmane