|Come for the quick hacks, stay for the epiphanies.
Re^2: Perl XAMPP DB Connect issue (Windows/Strawberry?)by Polyglot (Chaplain)
|on Jan 01, 2023 at 02:51 UTC
My options are nearly exhausted at this point. I have made some discoveries, some good, some not.
I downloaded Strawberry Perl, which is supposed to have DBD::mysql and all that is necessary, and found it to apparently have the identical list of libraries that came with XAMPP. So that's the bad news--XAMPP is not working out of the box with what, by all accounts online, appears to be the best possible option for getting Perl going on Windows.
The good news is that I found the DBD::mysql library tucked into a directory where I would not have expected it. It was in "C:\xampp\perl\vendor\lib\auto\".
But more bad news is coming. The file is not compatible for some reason. An error message leading back to DynaLoader.pm appears saying "Can't load 'C:/xampp/perl/vendor/lib/auto/DBD/mysql/mysql.xs.dll' for module DBD::mysql: load_file: The specified module could not be found at C:/xampp/perl/lib/DynaLoader.pm line 193."
I tried a "hail Mary"-style push of the path for the DBD module to DynaLoader's "@dl_library_path" array...to no avail, of course.
It looks like this is where the whole project dies. Is there an easy way to inline some php to handle the DB connections that I cannot do with Perl?
I'd really hate to go back to having to run a linux VM on windows just to get perl to use a database--it takes a whopping amount of space to do it this way, not to mention the added layers of complexity with accessing it via the VM.