On Jul 15, 2004, at 8:15 AM, Bill Birkett wrote:
5. Now, you can use CPAN to compile and install 'DBD::mysql'. Type the command 'install DBD::mysql' as with DBI. The software will compile successfully (after first compiling some prerequisites), and pass most of its tests. But the process will end without installing because the tests were not 100% successful.
The tests were not be 100% successful because this is incorrect. Why do people persist in posting misinformation about this? It ain't rocket science, and the correct recipe has been posted here a bazillion times.
If you're using the CPAN shell, use the command 'look DBD::mysql' - this will download and unpack the module package, and open a command shell in the unpacked directory. Then execute the following:
perl Makefile.PL \ --cflags='-I/usr/local/mysql/include -O3 -fno-omit-frame-pointer' \ --libs='-L/usr/local/mysql/lib -lmysqlclient -lz -lm' \ --testdb='test'\ --testuser='root'\ --testpassword='XXXXXX'
Note that you must have set the root password according to the MySQL installation instructions.
After the dust settles, you can proceed with the rest. Exit from the command shell (with 'exit' or ctrl-d) and complete the install in the CPAN shell:
install DBD::mysql
The tests should all pass.
The failed tests are not significant in this case
That is not always true. The failed tests *might* be a result of not being able to connect to the test database, and if that happens to be true then the failures are safe to ignore.
But then, they might also indicate that the database did not start correctly, that the compiler is unable to find the necessary headers and/or library, or another problem. In these cases, the tests most definitely *are* meaningful, and forcing the CPAN shell to ignore them with 'force install' with accomplish nothing but installing a non-functional module.
sherm--
