Skip Menu |
 

This queue is for tickets about the DBD-mysql CPAN distribution.

Report information
The Basics
Id: 83348
Status: resolved
Priority: 0/
Queue: DBD-mysql

People
Owner: Nobody in particular
Requestors: sveta.smirnova [...] oracle.com
Cc:
AdminCc:

Bug Information
Severity: Normal
Broken in: (no value)
Fixed in: (no value)



Subject: DBD::mysql::db do failed: alter routine command denied to user ''@'localhost' fo
Download (untitled) / with headers
text/plain 3.1k
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 >
Download (untitled) / with headers
text/plain 437b
This error happens when the database user does not have full permissions. The 'test' user, which is available on some default mysql installations, does not have enough permissions to run these tests. This is fixed in https://github.com/perl5-dbi/DBD-mysql/commit/4a2d029974401c2ef268626d84e6230b13d45b3f https://github.com/perl5-dbi/DBD-mysql/commit/e948a94ba2843b06d8414ffb63ffcc2268bb1188 and will be part of upcoming 4.025 -- Mike


This service is sponsored and maintained by Best Practical Solutions and runs on Perl.org infrastructure.

Please report any issues with rt.cpan.org to rt-cpan-admin@bestpractical.com.