Errors with DBD::mysql

mk_olc — Fri, 25 Jul 2008 12:26:08 +0100

Since upgrading to v. 5.10.0 I get Errors like that:

install_driver(mysql) failed: Can't load 'C:/Programme/xampp/perl/site/lib/auto/DBD/mysql/mysql.dll' for module DBD::mysql: load_file:Das angegebene Modul wurde nicht gefunden at C:/Programme/xampp/perl/lib/DynaLoader.pm line 202.
at (eval 7) line 3
Compilation failed in require at (eval 7) line 3.
Perhaps a required shared library or dll isn't installed where expected
at D:/Wissensdatenbank/htdocs/cgi-bin/projekteingangsform.pl line 24

I checked, that the .dll is in place.

What do I have to check, else?

Difficulty Installing Email-Valid and HTML-Entities Using PPM

steven.arrington — Fri, 25 Jul 2008 01:54:29 +0100

When attempting to install Email-Vaild and HTML-Entities using the ActivePerl PPM for 5.100.1001, I received this error message:

ERROR: "Don't know how to copy C:WINDOWS\TEMP\ppm-8aXPEG/Email-Address-1.88/blib/html/?l???U??

The operating system is Windows ME...I am a Perl novice and would appreciate any help.

Thanks in advance for your comments.

Problem with variables in compile perlsvc script

jmozley — Thu, 24 Jul 2008 14:22:39 +0100

I am using the dev kit for the first time to create a windows service.

The issues I am having are with trying to get the service to run.

I have created a script along the lines of the PingSvc.pl example as I want something that can be run interactively and as a service.

I can get it compiled OK and run it interactively (using Komodo) without errors.

The problem I have is after compiling when trying to start the service.

At first I had variables with values assigned that did not seem to have values. For instance when I put a message to the event log expecting to see the value in "Logfile path $servicelogfile" I would see "Logfile path " even though $servicelogfile was set. So I started to use a BEGIN block. This enabled me to get further but I now see in the event log:

Undefined subroutine &PerlSvc::Startup called at /PerlSvc.pm line 95

I do not have this subroutine anywhere near line 95.

I think I need some help in the correct way to make variables and subroutines known at the right time. Apologies if this is bordering on general Perl questions.

Cannot get Net::SSLeay to work

ski98033 — Wed, 23 Jul 2008 20:29:47 +0100

Hi,

I am trying to get Net::Ldaps to work and it needs IO::Socket::SSL which needs Net::SSLeay. I am using MinGW to compile Net::SSLeay and this worked fine and Net::SSLeay installed ok. When I try to use it I get:

Net::SSLeay could not find a random number generator on your system.

and it fails.

Any help to get working is most appreciated.

cheers,

ski

Spreadsheet::WriteExcel in 5.10

paperRam — Wed, 23 Jul 2008 15:57:50 +0100

I developed a script a while ago in Perl 5.8 (latest version at the time) which uses the Spreadsheet::WriteExcel module. I recently received a report from a user that in Perl 5.10 it was not possible to find Spreadsheet::WriteExcel in PPM unless a certain private repository was added (namely http://homepage.eircom.net/~jmcnamara/perl ). The user reported that in the end he was successful in installing the module from this private repository and that my script did work.

However, I would like to know why this module has apparently been removed from the ActiveState repository for 5.10, since it seems like the module itself does work in 5.10. Are there any plans to restore it to the repository?

Shouldn't the installation work?

xyz123 — Wed, 23 Jul 2008 04:05:34 +0100

I just downloaded and installed Active Perl 5.8.8 (MSI) for the first time on a Windows 2000 SP4 server. There were no error messages during the installation, so I assume everything went fine.

I installed AP to t:\Perl

My environmental variable PATH statement has this path included: t:\Perl\bin

The .PL, PLX, etc extensions are listed in the IIS Manager application mappings.

OK, so I try to see if ActivePerl works, so I open Internet Explorer and navigate to T:\Perl\eg\IEExamples and run index.htm

None of the examples there work.

OK, so why can't the installation handle a plain vanilla installation and get it right the first time, rather than have me beg for help here?

Help!

Running Perl with DBD::mysql on Vista 64 bit

FlatBallFlyer — Tue, 22 Jul 2008 19:54:32 +0100

I've spent several days trying to get a build of PERL and PPM that could provide me with support for DBD::mysql under 64 bit Vista. I first tried PERL 5.10-x64, the PERL part worked just fine, but under PPM I could not find DBD::mysql anywhere. I then tried PERL 5.8-x64, and under PPM again I could not find DBD::mysql. Finally I installed PERL 5.8 x86, and PPM found the DBD::mysql module just fine. I hate to be running this far off of the latest version, and for my true platform. My questions are:

1. Is there any support for the MySql module under 64 bit Perl 5.10 or 5.8?
2. Are there any known issues with running Perl 5.8 x86 under Vista 64 bit?

Thanks for any information
FlatBallFlyer
><>

redirecting output of a system-call

thmauch — Tue, 22 Jul 2008 16:41:02 +0100

I have a script which uses system() to execute a SQL*Plus-Script against a Oracle database. This all works fine and I get the output I except in my Command Prompt window, e.g.
> print.pl
OUTPUT

When I however try to redirect the output to a file like this
>print.pl >out

it does not work. I see no output in the Command Prompt window, and the file out gets created but it is always empty.

I tried to set $AUTOFLUSH but it did not help.
Any ideas?

Thanks,
Thomas

Here is the content of the files mentioned:

print.pl
--------
system "sqlplus -s usr/pwd @ print";

print.sql:
----------
prompt OUTPUT
quit;

Package Term::ANSIColor not working

erang — Sun, 20 Jul 2008 15:11:39 +0100

When using the Term::ANSIColor package and trying to display text in color in the Windows command shell (cmd.exe), the output is not formatted correctly and gibrish terminal characters are outputted instead of the colored text.
Example:

# example.pl
use Term::ANSIColor;
print "my text",color('bold green'),"my colored text","\n";

output:
my text ←[1;32m my colored text

Perl Script unable to open text file

ranky — Sun, 20 Jul 2008 10:13:48 +0100

Hi All,

I am new to Perl with a problem but no solution. I wanted to create a perl script that only opens a text file and search for a particular word. Unfortunately, the script cannot open the text file. It returns the following error message:

No such file or directory.

The text file "test.txt" und perl script are in the same folder. I am using Apache Friends.

Here is the script:

#!/usr/bin/perl -w

use strict;

my $file_to_open =	"test.txt";

open (FILE, "< $file_to_open")
or die "File cannot open! $!\n";

my $text;

undef $/; $text = ;

while ($text =~m/African/g) {
	print "The word African is found.\n";
}
close (FILE);

TEXT FILE:

African african African Dating - Pride and Ambition
It is no secret that African culture is known for its pride.
Most Africans do not have a problem standing up for their beliefs and

WORD TO FIND:

African

Please any idea on how to resolve this problem?

Thanks

Ranky