DBD::mysql Options

[Starke]

ok this is just stumping me i have reinstalled psychostats several times, and wamp severaltimes and activeperl several times, and i cant figure out whats causing this error. it keeps saying that it cant find the DBD::mysql package i am running the latest Wamp with active perl 5.8.8

[crazykar]

haha thats funny i just did that a few minutes ago, wat u need to do is


start>>>Run>>>>

and type this in:


ppm install DBD::mysql




and it shoud go and fetch sum files and install them

[Starke]

i did, and it installed just fine however when i try to run the stats.pl file it cant find it

[Stormtrooper]

You probably didn't actually install it. You probably installed one of the other DBD-MysqlXX modules which are not the same.

If you're running ActiveState Perl 5.10, apparently they don't have all their modules updated, or in a different location that I can't find.

Do this at a command prompt:

Perl 5.10:

CODE

ppm install http://cpan.uwinnipeg.ca/PPMPackages/10xx/DBD-mysql.ppd

Perl 5.8:

CODE

ppm install http://theoryx5.uwinnipeg.ca/ppms/DBD-mysql.ppd

The uwinnipeg.ca site has been supplying PPM's for a long time now, so it's safe.

[Stormtrooper]

Added to FAQ:
http://www.psychostats.com/wiki/FAQ#DBD::M...is_not_found.21

[Cool Cat]

Hi all,
Guys may I ask you to help me ?

I've got:

Win XP SP3
WampServer 2.0f
Psychostats 3.1

First I installed ActivePerl5.10.0. DBD-mysql was not installed on Perl ignitially, but DBI module was there. I installed DBD-mysql as per FAQ. And it installed but when I run psychostats.bat it tells me it can't find DBD::mysql module.

Then I tried to instal Perl 5.8.9.825 and also installed DBD-mysql. Same problem.
I will be very grateful if somebody can help me. Thanks in avance.

P.S. I checked similar topics but didn't get solutions. The very alike was about the same problem but *nix OS. So hope u can help me.

[Thriller185]

active perl 5.8.0 Works everything is in the ppm I had the same problems.

Did you try what Stormtrooper posted. I wish I had that last time I reinstalled everything on a win server.

[Cool Cat]

Yep, tried. Actually modules installed without problems. And I can see it over the PPM, but Psycho tells me it can't find it. The same was on both ActivePerl 5.10 and 5.8

[Stormtrooper]

Don't confuse the DBD-mysqlPP module with the DBD-mysql module. They are completely different. Unless you setup the repository as explained in the PPM docs then you most likely installed the DBD-mysqlPP module instead.

[Cool Cat]

Nope, I am not pro in Perl but I am not so silly )
I installed DBD-mysql nad no DBD-mysqlPP or else. I installed from the source you provide eralier and also mentioned in FAQ. That is problem. It is installed but Psych don't see it.
I have no idea where problem can be.
Maybe problem in location ?
Is there any general rules I should follow installing WAMP Perl and Psych ? I know rules about Psych location files (lib folder, stats.pl ets).
Also why I am installing DBD-mysql and Psychostats checking for DBD::mysql ? Is it ok that names are different I mean "-" and "::" ?

[Stormtrooper]

Chances are you have 2 versions or copies of perl installed and each looks for modules in different locations. This is a semi-common problem for some linux systems, but not so usual for Windows.

DBD-mysql and DBD::mysql are essentially the same thing. ActiveState simply refers to their packages w/o the double :: colons. Once DBD-mysql is installed its seen by perl as DBD::mysql.

[Cool Cat]

No, there is only one ActivePerl installed.
Stormtrooper, I suppose here is where no ideas anymore unfortunately. To be honest I read some of Perl and MySQL forums and still have no idea where is the problem. May I ask you then if you have Win OS to give me (upload to some file server) Active Perl with installed DBD-mysql module. I suppose maybe if I will just overwrite it then maybe it will start work.

[Stormtrooper]

Open a DOS prompt (start menu -> run -> "cmd") and type in the following and report what you get:

CODE

perl -MDBD::mysql -e 'print $DBD::mysql::VERSION'

If you get an error then the module is most definitely not installed. If you get a version number back (something like 3.0008) then the module is installed and you can try to run stats.pl by creating a shortcut that runs perl like this:

CODE

c:\full\path\to\perl\bin\perl.exe c:\full\path\to\stats.pl -v

[Vinas]

ok this is just stumping me i have reinstalled psychostats several times, and wamp severaltimes and activeperl several times, and i cant figure out whats causing this error. it keeps saying that it cant find the DBD::mysql package i am running the latest Wamp with active perl 5.8.8

For debian try:

CODE

sudo apt-get install libclass-dbi-mysql-perl

[Cool Cat]

Stormtrooper, tnx. But I solved the problem. I found on one of the Russians forum ActivePerl-5.10.0.1004-MSWin32-x86-287188 in archive with all required modules. Thus I installed ActivePerl-5.10.0.1004-MSWin32-x86-287188 then unpacked those archive over and it works fine. One more time thanks for your attention and time.

[khan]

well your help files is missing i want to read info about dbd::mysql. When i run stats.pl it's give error. In ppm i have dbd::mysqllite so is i still need dbd::mysql? after have dbd::mysqllite if yes so where i can get it?

sorry for bad English