Windows XP ActivePerl 5.10 MySQL database connectivity : Apache, ActivePerl, 5.10, Connecting to MySQL v5 database

May 9, 2008 09:40am pdt

1. Adam314 310,332
2. ozo 192,243
3. FishMonger 65,885
4. hielo 46,700
5. Tintin 45,565
6. mjcoyne 36,229
7. ravenpl 17,080
8. clockwat... 16,860
9. oleber 15,700
10. nixfreak 12,200
11. teraplane 11,500
12. ahoffmann 10,950
13. suhasbha... 10,100
14. kawas 8,300
15. sentner 7,780

1. ozo 3,464,008
2. Adam314 1,232,751
3. Tintin 693,859
4. kandura 579,965
5. jmcg 517,810
6. mjcoyne 488,367
7. FishMonger 418,519
8. maneshr 385,976
9. teraplane 355,708
10. manav_ma... 338,348
11. clockwat... 233,148
12. rj2 211,481
13. ahoffmann 196,513
14. davorg 153,165
15. Tim_Utschig 113,107

02.23.2008 at 06:33PM PST, ID: 23187907

	[x] Attachment Details

[x]

The Solution Rating System

With so many solutions, how can you tell which solutions are most likely to help you and which ones are not? To provide you with a tool to use, we rate our solutions based on various elements that most accurately determine if a solution is a quality solution. To explain what factors affect the solution rating, here are the elements we take into consideration when formulating our solution rating.

The Grade of the Solution
The Zone Rank of the Expert Providing the Solution
The Number of Author and Expert Comments
The Number of Experts Contributing
The Feedback of the Community

Your Input Matters
Because of the way the system is set up, the most important variable in this equation is you. As a member of Experts Exchange, you are able to cast your vote on the quality of the solutions in regard to how complete, accurate, helpful and easy to understand each solution is. When you provide your feedback, each rating is adjusted accordingly. So, if you see a solution that has a poor rating that you think is a good solution, let us know by rating it. As you do, the rating will be adjusted and will become more accurate for other members of our site.

If you have any suggestions that you would like to make for our rating system, please ask a question in the Suggestions Zone of Community Support.

Thank you!

8.8

Windows XP ActivePerl 5.10 MySQL database connectivity

Zones: Perl Programming Language, CGI Scripting, MySQL Server

Tags: Apache, ActivePerl, 5.10, Connecting to MySQL v5 database

Dear colleagues,

I am running ActivePerl v5.10 on Windows XP Pro. I have been trying to connect to MySQL v5 with no success. I have been getting the following error:

-----------
perl dbconnect3.pl
install_driver(mysql) failed: Can't locate loadable object for module DBD::mysql in @INC (@INC contains: C:/Perl/site/lib C:/Perl/lib .) at (eval 4) line 3
Compilation failed in require at (eval 4) line 3.
Perhaps a module that DBD::mysql requires hasn't been fully installed
at dbconnect3.pl line 5
-------------

Below is the script: dbconnect3.pl
-----
#!/usr/bin/perl -w
use DBI;
my $dbh = DBI->connect("DBI:mysql:database=test;host=localhost", "root", "pwd", {'RaiseError' => 1});
-----

I have successfully installed the DBI module (DBI-1.602) which I have downloaded from the internet. I have also downloaded the DBD module (DBD-mysql-4.006) from the internet. However when I tried to installed the dbd module, I got the a message that the package was up-to-date.

The problem is that, I can't seem to figure out why the dbd::mysql driver cannot be loaded. I have spent some considerable time on the problem so if anyone can help, I will be grateful.

Many thanks in advance.

Richard Koudry

Start your free trial to view this solution

Question Stats

Zone: Programming

Question Asked By: koudry

Solution Provided By: clockwatcher

Participating Experts: 3

Solution Grade: A

Translate:

Loading Advertisement...

Microsoft

Internet Protocols
Applications

Development
OS

Hardware
Windows Security

Apple

Operating Systems
Hardware

Programming
Networking

Software

Internet

Search Engines
File Sharing
WebTrends / Stats
Spy / Ad Blockers

Web Browsers
New Net Users
Web Development
Chat / IM

Anti Spam
Web Servers
Anti-Virus
Email Clients

Gamers

Tips
Online / MMORPG
Puzzle
Emulators

Action / Adventure
Role Playing
Consoles
Game Programming

Strategy
Sports
Misc
Computer Games

Digital Living

Hardware
New Net Users
New Users

Software
Digital Music
Gaming World

Home Security
Apple
Networking Hardware

Virus & Spyware

Vulnerabilities
IDS
Encryption
Anti-Virus

Operating Systems Security
Software Firewalls
WebApplications
Cell Phones

Operating Systems
Internet
Hardware Firewalls

Hardware

Handhelds / PDAs
Displays / Monitors
Components
Networking Hardware

Peripherals
Laptops/Notebooks
Storage
Servers

Desktops
New Users
Misc
Apple

Software

System Utilities
Industry Specific
Network Management
Photos / Graphics
Page Layout
VMWare
Misc
Web Development

OS
CYGWIN
Voice Recognition
Message Queue
Quality Assurance
Security
Firewalls
MultiMedia Applications

Development
Database
Office / Productivity
Business Management
OS/2 Apps
Server Software
Internet / Email

ITPro

OS
Storage
Encryption
Operating Systems Security
Apple Hardware
Laptops & Notebooks
Servers
Networking Hardware
Peripherals

Devices
Displays / Monitors
WebTrends / Stats
Search Engines
Firewalls
WebApplications
IDS
Vulnerabilities
Email Clients

File Sharing
Spy / Ad Blockers
Web Browsers
Web Servers
Networking
Anti-Virus
Chat / IM
Anti Spam

Developer

Web Servers
Web Browsers
Game Programming
Dev Tools
Industry Specific
Office / Productivity

Database
CYGWIN
Web Development
Search Engines
File Sharing
WebTrends / Stats

Programming
Content Management
Application Servers
Protocols

Storage

Removable Backup Media
Storage Technology
Servers

Grid
Remote Access
Backup / Restore

Misc
Hard Drives

Miscellaneous
Security
Development
Linux
VMWare

MainFrame OS
Unix
Apple
OS / 2
AS / 400

BeOS
Microsoft
VMS / OpenVMS

Database

Oracle
Miscellaneous
MySQL
Software
Sybase
Contact Management
PostgreSQL
Data Manipulation
Clarion
InterSystems Cache

Siebel
MUMPS
OLAP
SQLBase
SAS
GIS & GPS
4GL
Berkeley DB
DB2
Informix

Interbase / Firebird
FoxPro
Reporting
LDAP
Filemaker Pro
MS SQL Server
dBase
MS Access

Security

Misc
Web Browsers
Software Firewalls
Operating Systems Security
File Sharing

Spy / Ad Blockers
Vulnerabilities
WebApplications
IDS
Anti-Virus

Encryption
Anti Spam
Email Clients
VPN
Chat / IM

Programming

Editors IDEs
Installation
Handhelds / PDAs
Multimedia Programming
System / Kernel

Algorithms
Game
Signal Processing
Project Management
Open Source

Database
Misc
Languages
Processor Platforms
Theory

Web Development

Scripting
Blogs
Web Servers
Software
Search Engines
Web Graphics
Images

Internet Marketing
Images and Photos
Components
Document Imaging
Web Languages/Standards
Illustration
WebApplications

Fonts
WebTrends / Stats
Authoring
Digital Camera Software
Miscellaneous

Networking

Protocols
Apple Networking
Network Management
Message Queue
Application Servers
Content Management
File Servers
Email Servers
Misc
Java Editors & IDEs

Wireless
Networking Hardware
Backup / Restore
System Utilities
ISPs & Hosting
Web Servers
Storage Technology
Removable Backup Media
Servers
Broadband

Grid
OS / 2
Novell Netware
Unix Networking
Windows Networking
Security
Telecommunications
Operating Systems
Linux Networking

Other

Community Advisor
Lounge
Community Support
New Net Users

Philosophy / Religion
Math / Science
Miscellaneous
URLs

Expert Lounge
Politics
Puzzles / Riddles

Community Support

Suggestions
New to EE
New Topics
Community Advisor

CleanUp
Announcements
General

Feedback
Input
EE Bugs

02.23.2008 at 08:19PM PST, ID: 20968532

Rank: Wizard

FishMonger:

What method are you using to install the DBD module? I presume that you're doing it via CPAN i.e.,
perl -MCPAN -e 'install DBD::mysql'

Have you tried to do a force install?
Have you tried to uninstall then reinstall?

Have you tried to do the build via:
perl Makefile.PL
make
make test
make install

02.23.2008 at 09:44PM PST, ID: 20968873

Rank: Guru

clockwatcher:

ActiveState doesn't have the DBD-mysql ppm package available for 5.10 yet, but the university of winnipeg does:

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

         
           
           
             C:\>ppm repo add http://cpan.uwinnipeg.ca/PPMPackages/10xx/
Downloading ActiveState Package Repository packlist...not modified
Downloading cpan.uwinnipeg.ca packlist...done
Updating cpan.uwinnipeg.ca database...done
Repo 2 added.
 
C:\>ppm install DBD-mysql
Downloading ActiveState Package Repository packlist...not modified
Downloading DBD-mysql-4.005...done
Unpacking DBD-mysql-4.005...done
Generating HTML for DBD-mysql-4.005...done
Updating files in site area...done
  12 files installed

           
         

Open in New Window

Accepted Solution

02.24.2008 at 11:34AM PST, ID: 20970983

koudry:

Reply to FishMonger and Clockwatcher

1. Method used to install modules

I used the binary installation methods as described in the install.html which came with the download for both DBI and DBD modules. Below is the outputs:

(i) Binary installation

C:\DBI-1.602>ppm install DBI
Downloading ActiveState Package Repository packlist...not modified
Syncing site PPM database with .packlists...done
No missing packages to install

C:\DBD-mysql-4.006>ppm install DBD::Mysql
Downloading ActiveState Package Repository packlist...not modified
No missing packages to install

(ii) Source installation

I also tried the source installation with the following commands, but they did not seem to work.

perl Makefile.PL
make
make test
make install

(a) Running "perl Makefile.PL"

When I run the "perl Makefile.PL" command in the dbd module folder, e.g.

C:\DBD-mysql-4.006>perl Makefile.PL --cflags=I%include% --libs=-L%lib%

I get some messages indicating some libraries have not been found (please see attached dbd_makefile_pl_output_24Feb08.txt file).

The %include% variable in the above command is configured in the env as %MYSQL_HOME%\include where %MYSQL_HOME% is the installation location of my MySQL server: C:\Program Files\MySQL\MySQL Server 5.0

The %lib% variable is configured as %MYSQL_HOME%\LIB.

Both the %include% and %lib% variables are two of the many arguments that can be passed to the Makefile.pl script. I have not passed everything and I am not sure if I should pass all the arguments!

(b) Running "Make" command

The make command does not work at all. I suspect it is looking for the "C" compiler in my system env which it cannot find. I get the following message:

----
C:\DBD-mysql-4.006>make
MAKE Version 3.6 Copyright (c) 1991 Borland International
Error makefile 351: Colon expected
Error makefile 402: Redefinition of target 'mysql.obj'
Error makefile 919: Redefinition of target 'mysql.c'

Available memory 15728640 bytes

*** 3 errors during make ***
------

This output tells me that the "make" command was able to locate the "C" compiler "TURBOC3", which I downloaded from the Internet. The installation path has been added to my system env variables. The problem here is that I don't know the type and version of "C" compiler required, so maybe, it will make a difference if I can find the right "C" compiler (only speculating!).

Since "make" did not work, "make test" and "make install" did not work either. It is obvious my environment is not properly setup to run these commands and I would hope there is an easy way to get this db modules and libraries installed. It is frustrating but as an application developer, I never give up.

The Makefile.pl and make commands of the DBI module, also produced similary results.

(2) What now?

I am now going to follow the URL given by Clockwatcher above and see if I should download different versions of the modules. I will report back on this. In the meantime, if you can think of something else please let me know.

Many thanks in advance.

Richard Koudry

dbd-makefile-pl-output-24Feb08.txt (1 KB) (File Type Details)

Ouput of the Makefile.pl script for the DBD module

02.25.2008 at 07:23AM PST, ID: 20976143

Rank: Genius

Adam314:

Installing from source is difficult on windows, and you should use the ppm installer whenever possible. The ppm install failed because the modules could not be found for perl version 5.10. If you use the commands clockwatcher gave, you should be okay.

02.25.2008 at 07:33AM PST, ID: 20976256

koudry:

Replying to Adam314:

You are right. Clockwatcher's approach look promising. However I have to try his instructions outside of the corporate firewall because the firewall is giving me a lot of problems. But this is no issue. I should be able to get this sorted by end of this week and will post the results here.

Thanks very much for your guidance.

Regards,

Richard Koudry

02.25.2008 at 07:47AM PST, ID: 20976419

Rank: Genius

Adam314:

If you can get through the firewall with a username/password, then you can use PPM. You will need to set some environment variables before running those commands.

Set HTTP_proxy to the proxy address (eg: http://proxy.company.com:8080)
Set HTTP_proxy_user to your proxy username
Set HTTP_proxy_pass to your proxy password
Then run the commands clockwatcher mentioned

02.25.2008 at 08:02AM PST, ID: 20976590

koudry:

Replying to Adam314:

Thanks very much Adam314. I did try the command:
Set HTTP_proxy = http://proxy.company.com:8080 (with the appropriate values), first on the command line and also in the system env variables but it did not work. I get the following error:
---
D:\>ppm repo add http://cpan.uwinnipeg.ca/PPMPackages/10xx/
Downloading cpan.uwinnipeg.ca packlist...not found
Downloading cpan.uwinnipeg.ca packlist...not found
Downloading cpan.uwinnipeg.ca packlist...not found
Repo 1 added.
--

where repo 1 is:
--
D:\>ppm repo 1
Id: 1
Name: cpan.uwinnipeg.ca
URL: http://cpan.uwinnipeg.ca/PPMPackages/10xx/
Enabled: yes
Last-Status: 404 Not Found
Last-Access: 1 minute and 53 seconds ago
-----
I am confident that that the packages are at the location as indicated by the URL but I think the firewall would not allow me to get them.

The problem is that the firewall and proxy configurations are not transparent so I cannot tweak anything. We get out of the corporate network to the Internet using a bespoke script. We do not see the script, but only the internal URL to the script. This way, we cannot fiddle with it. Yes, pretty clever but a pain in the back side!

So when I get home tonight, I am going to try with another machine which connects directly to the Internet. I am confident it will work. I will report back on this.

Many thanks in advance.

Richard Koudry

02.25.2008 at 09:01AM PST, ID: 20977147

Rank: Genius

Adam314:

I'm not understanding your proxy config.... If you start internet explorer, can you get to the uwinnipeg address? If so, look in Internet Options -> Connections -> LAN Settings to see what proxy it is using, then use the same thing for ppm.

koudry

02.25.2008 at 02:54PM PST, ID: 20980115

Dear all,
The solution provided by Clockwatcher worked perfectly. I initially had problem downloading the packages but this was due to the corporate firewall. The proxy workaround has not been possible because of the way the proxy configuration is done in my organisation. Nevertheless, I managed to connect and download the package from another computer and it work fine. I am not able to connect to the MySQL Server database and obtain data from it.

Thanks very much for your guidance.

Richard Koudry

koudry

02.26.2008 at 03:03AM PST, ID: 20983106

Dear all,
The solution provided by Clockwatcher worked perfectly. I initially had problem downloading the packages but this was due to the corporate firewall. The proxy workaround has not been possible because of the way the proxy configuration is done in my organisation. Nevertheless, I managed to connect and download the package from another computer and it work fine. I am now able to connect to the MySQL Server database and obtain data from it.

Thanks very much for your guidance.

Richard Koudry

20080236-EE-VQP-29 / EE_QW_2_20070628