Originally Posted by Elleroth
Well, to start off, I have actually installed the module. However, I would like to avoid this minor problem in the future if possible...
I used CPAN to get, configure, compile, and install the DBD::MySQL.
The problem occured when the module went through testing. From what I understood of the error messages, the test section barfed because it couldn't connect to the SQL server because it wanted a password for the root user and thus couldn't run the tests.
To fix this, I simply deactivated the root user's password for localhost and reran CPAN, which compiled and installed the module without any problems.
Now my question for future reference is: Is there any way to let CPAN or PERL know what your root user's password is so that it won't crap out on the test phase? Or better yet, is there a way to specify a specific "test" account to CPAN or the PERL config/make command that accesses only the "test" database of the SQL server??
I'm currently running:
PERL 5.8.6 with:
cpan script version 1.03
CPAN.pm version 1.7601
mysql Ver 14.7 Distrib 4.1.11, for slackware-linux-gnu (i486)
Everything listed is pretty much a default package install for Slackware.
Any help's appreciated.
Hi, if you install mysql (what version ?), make sure your lib*.so and "linked" files are in a directoy, in case you install mysql from RPM check the file path and locate the directory where your RPM install the *.so library. If you did install from source wich is the best solution (in my case) by default everything is installed in /usr/local/mysql.
After you successfully install mysql, add you /usr/mysql/lib/mysql directory to the /etc/ld.so.conf and save it, then load it by running "ldconfig -f /etc/ld.so.conf", and walla!, all your *.so files are accessible from any where in the system.
Note that if you system has Perl and CPAN, then it would be the easiest way to install all the packages you want, just type "cpan from shell". The first time CPAN is executed it will make you some question, just answer them and at the end choose only http servers rather than ftp because the are faster.
After all the questions, just type " install cpan" -->run "install Boundle::CPAN" and it will update your cpan.
Now make sure that you can run mysql_client from any part of the system, if you can't, do this "export PATH=$PATH:PATH_TO_YOU_MYSQL_BASE_DIR/bin" and try again by running mysql or any MySQL bin file.
After every thing is up, run CPAN again, just type "o conf prerequisites_policy ask" -->run "install DB::Mysql"
I hope all of these lines help you