Re: DBD::mysql help

[Jonathan Baumgartner]

On Wednesday, October 23, 2002, at 11:21  PM, Sherm Pendley wrote:

Make sure that the mysql_config tool is in your path.

I'd guess that you installed MySQL via Fink, and then added the Fink startup script to your login script. But, when you 'su - root' to run cpan, you're using *root*'s environment, not that of your "normal" account, so /sw/bin/ isn't in your path any more. That's what happened to me the first time I tried to install it. :-)

Thanks for the help, Sherm. Good call. Didn't install from fink, but from the package at http://www.entropy.ch/software/macosx/ So when I did a look DBD::mysql, I added /usr/local/mysql/bin to the PATH.

In cpan, do a "look DBD::mysql" to have it download the module, unpack it for you, and open up a shell prompt in the correct directory. (Even when it can't compile a module, cpan is still useful for *something*.) Then, configure the module manually, passing a few options to Makefile.PL:

perl Makefile.PL --testdb=test --testuser= --testpassword=

Did this, although I told it to use "mysql" for a user and mysql's password for password. It got a lot further this time.

From here on out, the usual "make; make test; make install" dance should work.

After make, I get some warnings. Are these something I should worry about?

/System/Library/Perl/darwin/CORE/perl.h:498: warning: Precomp '/usr/include/unistd.p' version number is 24 instead of 25, ignoring precomp

After make test, it gets most of the way through, but some fail. Note that it is trying to use 'root' with no password again. In mysql, I granted all privileges to user "mysql" for test.*.

t/akmisc............FAILED test 44
Failed 1/351 tests, 99.72% okay
t/dbdadmin..........ok 4/20Error while executing createdb: Can't create databaset/dbdadmin..........NOK 5New DB not in DSN list
t/dbdadmin..........NOK 6Error while executing _DropDB: Access denied for user: t/dbdadmin..........ok 8/20$drh->admin('createdb') failed: Access denied for user: 'root@localhost' (Using password: NO)
t/dbdadmin..........NOK 9DSN testab not in DSN list.
t/dbdadmin..........NOK 10$drh->admin('dropdb') failed: Access denied for user: 'root@localhost' (Using password: NO)
t/dbdadmin..........NOK 13$drh->admin('createdb') failed: Access denied for user: 'root@localhost' (Using password: NO)
t/dbdadmin..........NOK 14DSN testac not in DSN list.
t/dbdadmin..........NOK 15$drh->admin('dropdb') failed: Access denied for user: 'root@localhost' (Using password: NO)
t/dbdadmin..........FAILED tests 5-7, 9-11, 13-15
Failed 9/20 tests, 55.00% okay
t/insertid..........ok
t/mysql.............FAILED test 23
Failed 1/68 tests, 98.53% okay
t/mysql2............ok
Failed Test Status Wstat Total Fail Failed List of Failed
------------------------------------------------------------------------ --------
t/akmisc.t 351 1 0.28% 44
t/dbdadmin.t 20 9 45.00% 5-7, 9-11, 13-15
t/mysql.t 68 1 1.47% 23
1 test and 14 subtests skipped.
Failed 3/18 test scripts, 83.33% okay. 11/764 subtests failed, 98.56% okay.

thanks,
jon