| Subject: | DBD::mysql::db do failed: alter routine command denied to user ''@'localhost' fo |
Description:
WHen Installing the DBD-mysql-4.021 Module errors stop the bundle from
installing during make test stage
How to repeat:
Commands Ran From my Mac OS X directory:
/Users/Dad/PERL/myModules/DBD-mysql-4.021
1) perl Makefile.PL --mysql_config=/usr/local/mysql/bin/mysql_config
seems to run fine, had some issues here but with a link
creation this was solved:
cd /usr/lib; sudo ln -s
/usr/local/mysql/lib/libmysqlclient.18.dylib .
2) make
seems to run find
3) make test, this is where the issues occur:
~/PERL/myModules/DBD-mysql-4.021 > make test
PERL_DL_NONLAZY=1 /usr/bin/perl "-MExtUtils::Command::MM" "-e"
"test_harness(0, 'blib/lib', 'blib/arch')" t/*.t
t/00base.t .................. ok
t/10connect.t ............... ok
t/20createdrop.t ............ ok
t/25lockunlock.t ............ ok
t/29warnings.t .............. ok
t/30insertfetch.t ........... ok
t/31insertid.t .............. ok
t/32insert_error.t .......... ok
t/35limit.t ................. ok
t/35prepare.t ............... ok
t/40bindparam.t ............. ok
t/40bindparam2.t ............ ok
t/40blobs.t ................. ok
t/40catalog.t ............... ok
t/40keyinfo.t ............... ok
t/40listfields.t ............ ok
t/40nulls.t ................. ok
t/40nulls_prepare.t ......... ok
t/40numrows.t ............... ok
t/40server_prepare.t ........ ok
t/40server_prepare_error.t .. ok
t/40types.t ................. ok
t/41bindparam.t ............. ok
t/41blobs_prepare.t ......... ok
t/42bindparam.t ............. ok
t/50chopblanks.t ............ ok
t/50commit.t ................ ok
t/51bind_type_guessing.t .... ok
t/52comment.t ............... ok
t/53comment.t ............... ok
t/55utf8.t .................. ok
t/60leaks.t ................. skipped: Skip $ENV{SLOW_TESTS} is not set
t/65types.t ................. ok
t/70takeimp.t ............... ok
t/71impdata.t ............... ok
t/75supported_sql.t ......... ok
t/76multi_statement.t ....... 1/25 # Testing multicall against
SQL_DBMS_VER: 5.5.25
t/76multi_statement.t ....... ok
t/80procs.t ................. 1/29 DBD::mysql::db do failed: alter
routine command denied to user ''@'localhost' for routine
'test.testproc' at t/80procs.t line 47.
DBD::mysql::db do failed: alter routine command denied to user
''@'localhost' for routine 'test.testproc' at t/80procs.t line 47.
# Looks like you planned 29 tests but ran 2.
# Looks like your test exited with 255 just after 2.
t/80procs.t ................. Dubious, test returned 255 (wstat 65280,
0xff00)
Failed 27/29 subtests
t/85init_command.t .......... ok
t/86_bug_36972.t ............ ok
Test Summary Report
-------------------
t/80procs.t (Wstat: 65280 Tests: 2 Failed: 0)
Non-zero exit status: 255
Parse errors: Bad plan. You planned 29 tests but ran 2.
Files=40, Tests=863, 9 wallclock secs ( 0.23 usr 0.13 sys + 2.73 cusr
0.45 csys = 3.54 CPU)
Result: FAIL
Failed 1/40 test programs. 0/863 subtests failed.
make: *** [test_dynamic] Error 255
~/PERL/myModules/DBD-mysql-4.021 >