annonymous Monk, thanks for your response and the handy links...
yes i have googled till i dropped.
Sadly for me, i have visited them all before and i have tried them all and much more. i have installed and reinstalled multiple versions of mysql, DBI and DBD in both architectures as well.
so just for completeness sake i will go over them again.
Frankly, i don't know the big picture of what i am trying to achieve, which makes me uncreative when i hit a problem
do you even know what the error means? that might help me see the big picture and be more independent.
| [reply] |
| [reply] |
thanks anonymous....
Problem solved...in a nutshell i installed DBD-mysql in /Applications/xampp/xamppfiles/bin/perl, and not /usr/bin/perl.
long answer:
I basically stayed away from the many examples on the web that used /usr/bin/perl, and /usr/local/mysql....
so it works, now, but it is a cop-out, since the other methods should work as well... anyways this is easier to maintain since i am using an xampp distribution...we'll see about that.
here is what i did.
- Fresh install of xampp-0.74
- Download and tar xvf the developer package of xampp to /mytmp
- note: i needed the include dir in the developer package for cpan to install DBD-mysql, namely the mysql include files
- Copied the /mytmp/xampp/xamppfiles/include to /Applications/xampp/xamppfiles
- Installed DBI and DBD:mysql using CPAN and the perl in xampp. It is important to use XAMPP perl, and /usr/bin.
- sudo /Applications/xampp/xamppfiles/bin/perl -MCPAN -e 'install DBI'
- sudo /Applications/xampp/xamppfiles/bin/perl -MCPAN -e 'install DBD::mysql'
- in my scripts, i used #!/Applications/xampp/xamppfiles/bin/perl instead #!/usr/bin/perl
thanks for your input
regards,
| [reply] |