CGI/Perl Guide | Learning Center | Forums | Advertise | Login
Site Search: in

  Main Index MAIN
INDEX
Search Posts SEARCH
POSTS
Who's Online WHO'S
ONLINE
Log in LOG
IN

Home: Perl Programming Help: DBI:
Installing DBI and DBD::mysql

 



benn600
User


Sep 29, 2005, 3:21 PM

Post #1 of 5 (5358 views)
Installing DBI and DBD::mysql Can't Post

Installing modules looks challenging! I have been trying things to get the modules installed but nothing seems to work. After reading multiple guides, I have found that you can install it through ppm or just copy files into the directories. First, I don't know how to get to ppm and second, I tried copying files but it never works. My test script simply says use DBI; and I can't get that working.

Can I please have a simple step-by-step guide to getting DBI and DBD::mysql installed? I think that is about all I need still. Although, I will probably have some more questions later on. In the mean time, I'll continue searching and trying things.
----------------------------------------------------------------------------
Wink http://www.ppcpathways.com/ Wink
Visit my new site devoted to reviewing the latest pocketpc products and news that I built in cgi-perl!


rork
User

Sep 30, 2005, 1:58 AM

Post #2 of 5 (5357 views)
Re: [benn600] Installing DBI and DBD::mysql [In reply to] Can't Post

ppm is a package manager which comes with activestate perl for windows. To start it type ppm in command, then it will start

type 'install DBI' and 'install DBD::mysql' to install the packages.

When you're using linux you can probably install it using kynaptic or synaptic.

Another option is to download it from CPAN and use make (or nmake on win32 systems) to install it.
--
Don't reinvent the wheel, use it, abuse it or hack it.


davorg
Thaumaturge / Moderator

Sep 30, 2005, 3:56 AM

Post #3 of 5 (5356 views)
Re: [benn600] Installing DBI and DBD::mysql [In reply to] Can't Post

Just copying files will almost certainly not work with DBD modules as they will usually have an XS component which will need to be compiled.

What operating system are you using? And (if it's Linux) which distribution? Are you using a version of Perl that came with your operating system? Or have you installed an Activestate version? Or an rpm/apt/whatever version? Or have you built it from scratch?

And are you sure that you have the MySQL client libraries installed? Can you use the 'mysql' program to connect to the database successfully?

You really need to get into the habit of giving us a bit more data when asking for help.

And can you please reduce the size of the font in your .sig? It's very distracting.

--
Dave Cross, Perl Hacker, Trainer and Writer
http://www.dave.org.uk/
Get more help at Perl Monks


benn600
User


Sep 30, 2005, 5:06 AM

Post #4 of 5 (5354 views)
Re: [davorg] Installing DBI and DBD::mysql [In reply to] Can't Post

I'll fix my signature. I am using Windows XP Pro and I actually got it all working. Typing ppm didn't work, but I located the ppm.bat file in my perl directory and got it all working! I am now in working order. My only problem now is once I connect to the database in perl, I have seen a few different words for actually doing things and they are confusing. Is there a helpful reference guide I can refer to and possibly a bit of explanation to go along with it on the net somewhere? I have found two guides so far that have tought me a lot about mysql and then I realized that the 2,000 page reference guide provided by mysql is helpful in itself so I have started reading/skimming that. The reason I prefer that is because since it is provided by the maker of the software, they are sure to get every possible command--or at least I think so.

Thanks!
----------------------------------------------------------------------------
Wink http://www.ppcpathways.com/ Wink
Visit my new site devoted to reviewing the latest pocketpc products and news that I built in cgi-perl!


rork
User

Oct 1, 2005, 1:04 AM

Post #5 of 5 (5346 views)
Re: [benn600] Installing DBI and DBD::mysql [In reply to] Can't Post

Hm, I thought ppm would be in your path but I guess it's not.

The mysql documents are very usefull, for perl you can use the perldoc. Scince you use activestate and ppm it is on your computer: x:/perl/html/index.html where x is the drive perl is installed on. You get a long list of standard documents and documents for most of the installed modules.

Else you can use http://perldoc.perl.org/ or http://search.cpan.org/ to look up documentation for perl modules
--
Don't reinvent the wheel, use it, abuse it or hack it.

 
 


Search for (options) Powered by Gossamer Forum v.1.2.0

Web Applications & Managed Hosting Powered by Gossamer Threads
Visit our Mailing List Archives