Trying to Install Bundle::DBD::mysql
I'm trying to install this module on my powerbook. I did perl -MCPAN -e 'install Bundle::DBD::mysql' and was able to download this module and have it go through the process. At the end, though, I got this: Test returned status 255 (wstat 65280, 0xff00) Failed Test Stat Wstat Total Fail Failed List of Failed --- t/10dsnlist.t 10 2560 9 17 188.89% 1-9 t/20createdrop.t10 2560 59 180.00% 1-5 t/30insertfetch.t 10 256011 21 190.91% 1-11 t/40bindparam.t 10 256028 55 196.43% 1-28 t/40blobs.t 10 256011 21 190.91% 1-11 t/40listfields.t10 256018 35 194.44% 1-18 t/40nulls.t 10 256011 21 190.91% 1-11 t/40numrows.t 10 256025 49 196.00% 1-25 t/50chopblanks.t10 256035 69 197.14% 1-35 t/50commit.t 255 6528030 59 196.67% 1-30 t/ak-dbd.t 255 6528090 175 194.44% 1 4-90 t/akmisc.t 10 2560 351 701 199.72% 1-351 t/dbdadmin.t10 256021 41 195.24% 1-21 t/insertid.t 255 6528012 24 200.00% 1-12 t/mysql.t ?? ?? % ?? t/mysql2.t 255 65280?? ?? % ?? 1 test skipped. Failed 16/18 test scripts, 11.11% okay. 723/730 subtests failed, 0.96% okay. make: *** [test_dynamic] Error 2 /usr/bin/make test -- NOT OK Running make install make test had returned bad status, won't install without force Bundle summary: The following items in bundle Bundle::DBD::mysql had installation problems: DBD::mysql Several tests failed because access was denied, for instance: t/mysql2...Mysql connect('database=test;host=','',...) failed: Access denied for user: '[EMAIL PROTECTED]' (Using password: NO) at t/mysql2.t line 29 What else should I do to get this to run as should be? -- Lola - mailto:[EMAIL PROTECTED] http://www.lolajl.net | Blog at http://www.lolajl.net/blog/ Terrorism delenda est! (Terrorism must be destroyed utterly!) I'm in Bowie, MD, USA, halfway between DC and Annapolis.
Re: Trying to Install Bundle::DBD::mysql
On Dec 15, 2004, at 2:29 PM, Lola Lee wrote: Several tests failed because access was denied, for instance: t/mysql2...Mysql connect('database=test;host=','',...) failed: Access denied for user: '[EMAIL PROTECTED]' (Using password: NO) at t/mysql2.t line 29 What else should I do to get this to run as should be? The problem is that the self-tests are run by root, and root normally requires a password to connect to mysql. You have two options: The simplest is to grant [EMAIL PROTECTED] full access to the "test" database, without requiring a password. In the mysql shell: mysql> grant all privileges on test.* to '[EMAIL PROTECTED]'; Query OK, 0 rows affected (0.22 sec) The second option is more complicated. You can start the CPAN shell with 'perl -MCPAN -e shell', and use the 'look DBD::mysql' command from there. That will download and unzip the latest module source, and open up a sub-shell in the source directory. From there, you can run 'perl Makefile.PL' using any of the options listed in INSTALL.html. For example, to specify the database, user name and password to use, you'd run 'Makefile.PL' like this: perl Makefile.PL --testdb=test --testuser=somebody --testpassword=blah sherm-- Cocoa programming in Perl: http://camelbones.sourceforge.net Hire me! My resume: http://www.dot-app.org
Re: Trying to Install Bundle::DBD::mysql
Sherm Pendley said the following on 12/20/04 7:00 AM: mysql> grant all privileges on test.* to '[EMAIL PROTECTED]'; Query OK, 0 rows affected (0.22 sec) Odd . . . when I did this I got: ERROR 1044: Access denied for user: '@localhost' to database 'test' When I went into phpMyAdmin this is what I saw: MySQL 4.0.20-standard running on localhost as [EMAIL PROTECTED] I'd set up an user 'mysqluser' that is only allowed to access Mysql. So it looks like I need to set up root to access Mysql - is that correct? -- Lola - mailto:[EMAIL PROTECTED] http://www.lolajl.net | Blog at http://www.lolajl.net/blog/ Terrorism delenda est! (Terrorism must be destroyed utterly!) I'm in Bowie, MD, USA, halfway between DC and Annapolis.
Re: Trying to Install Bundle::DBD::mysql
On Dec 20, 2004, at 9:05 AM, Lola Lee wrote: Sherm Pendley said the following on 12/20/04 7:00 AM: mysql> grant all privileges on test.* to '[EMAIL PROTECTED]'; Query OK, 0 rows affected (0.22 sec) Odd . . . when I did this I got: ERROR 1044: Access denied for user: '@localhost' to database 'test' When I went into phpMyAdmin this is what I saw: MySQL 4.0.20-standard running on localhost as [EMAIL PROTECTED] I'd set up an user 'mysqluser' that is only allowed to access Mysql. So it looks like I need to set up root to access Mysql - is that correct? No, it doesn't matter what user you use to grant the privileges. If 'mysqluser' is your normal admin user, just log in to the mysql shell as that user: mysql -u mysqluser -p For that matter, you could use phpMyAdmin to grant the privileges too. The important part is that the user '[EMAIL PROTECTED]' needs full access to the database 'test' - how you grant it that access is incidental. sherm-- Cocoa programming in Perl: http://camelbones.sourceforge.net Hire me! My resume: http://www.dot-app.org
Re: Trying to Install Bundle::DBD::mysql
On Mon, 20 Dec 2004, Sherm Pendley wrote: > No, it doesn't matter what user you use to grant the privileges. If > 'mysqluser' is your normal admin user, just log in to the mysql shell > as that user: > > mysql -u mysqluser -p > > For that matter, you could use phpMyAdmin to grant the privileges too. > The important part is that the user '[EMAIL PROTECTED]' needs full access > to the database 'test' - how you grant it that access is incidental. To clarify, '[EMAIL PROTECTED]' is an account with the MySQL database. It has no relation at all to the system 'root' account on your computer. MySQL has its own set of accounts which generally have no connection to the ones on the system that the database server is running on. -- Chris Devers