Resources for “A Database-Driven Web Application in 18 Lines of Code”

January 25th, 2005 by Paul Barry in

Resources for the print article.

The Maypole Home Page: maypole.perl.org

The CPAN Search Site: search.cpan.org

The MySQL Home Page: www.mysql.com

__________________________

Special Magazine Offer -- 2 Free Trial Issues!
Receive 2 free trial issues of Linux Journal as well as instant online access to current and past issues. There's NO RISK and NO OBLIGATION to buy. CLICK HERE for offer

Linux Journal: delivering readers the advice and inspiration they need to get the most out of their Linux systems since 1994.

Sorry, offer available in the US only. International orders, click here.

Comment viewing options

Select your preferred way to display the comments and click "Save settings" to activate your changes.

Problems installing 'libapreq2-2.04_03-dev

On June 21st, 2005 RH Sekaly (not verified) says:

I am trying to install & configure using Mandrake Linux 10.1
I have installed the following apps:
Apache 2.0.50 (Mandrake Linux/7.2.101mdk)
mod_perl 1.99_16
Perl v5.8.5
mod_ssl 2.0.50
OpenSSL 0.9.7d
PHP 4.3.8

When I run the command "perl Makefile.PL", everything works well until the end. The last few lines of the out are as follows:

Checking whether to enable maintainer-specific portions of Makefiles... no
./configure: line 1: apsx command not found
./configure: line 1: apsx command not found
./configure: line 1: apsx command not found
./configure: line 1: apsx command not found
./configure: line 1: apsx command not found
build/version_check.pl failed: no version_string found in ''.
configure: error: Bad apache2 version

Can anyone help??

Ragi

contact

On December 22nd, 2006 jill (not verified) says:

ragi
do you think you can contact me
thanks

Code from the article

On February 24th, 2005 Mike Hjorleifsson (not verified) says:

I followed the directions in the article but i get a 500 error from apache when executing the http://webserver/Club/

below is the dump from /var/log/httpd/error_log
I googled this error and cant figure out whats wrong.

failed to resolve handler `ClubDB': Can't locate Apache/Request.pm in @INC (@INC contains: /usr/lib/perl5/5.8.5/i386-linux-thread-multi /usr/lib/perl5/5.8.5 /usr/lib/perl5/site_perl/5.8.5/i386-linux-thread-multi /usr/lib/perl5/site_perl/5.8.4/i386-linux-thread-multi /usr/lib/perl5/site_perl/5.8.3/i386-linux-thread-multi /usr/lib/perl5/site_perl/5.8.2/i386-linux-thread-multi /usr/lib/perl5/site_perl/5.8.1/i386-linux-thread-multi /usr/lib/perl5/site_perl/5.8.0/i386-linux-thread-multi /usr/lib/perl5/site_perl/5.8.5 /usr/lib/perl5/site_perl/5.8.4 /usr/lib/perl5/site_perl/5.8.3 /usr/lib/perl5/site_perl/5.8.2 /usr/lib/perl5/site_perl/5.8.1 /usr/lib/perl5/site_perl/5.8.0 /usr/lib/perl5/site_perl /usr/lib/perl5/vendor_perl/5.8.5/i386-linux-thread-multi /usr/lib/perl5/vendor_perl/5.8.4/i386-linux-thread-multi /usr/lib/perl5/vendor_perl/5.8.3/i386-linux-thread-multi /usr/lib/perl5/vendor_perl/5.8.2/i386-linux-thread-multi /usr/lib/perl5/vendor_perl/5.8.1/i386-linux-thread-multi /usr/lib/perl5/vendor_perl/5.8.0/i386-linux-thread-multi /usr/lib/perl5/vendor_perl/5.8.5 /usr/lib/perl5/vendor_perl/5.8.4 /usr/lib/perl5/vendor_perl/5.8.3 /usr/lib/perl5/vendor_perl/5.8.2 /usr/lib/perl5/vendor_perl/5.8.1 /usr/lib/perl5/vendor_perl/5.8.0 /usr/lib/perl5/vendor_perl . /etc/httpd/ /etc/httpd/lib/perl) at /usr/lib/perl5/site_perl/5.8.5/Apache/MVC.pm line 22.\nCompilation failed in require at (eval 5) line 3.\n\t...propagated at /usr/lib/perl5/5.8.5/base.pm line 85.\nBEGIN failed--compilation aborted at /usr/lib/perl5/5.8.5/ClubDB.pm line 5.\nCompilation failed in require at (eval 4) line 3.\n

Article improvements:

On February 26th, 2005 Steven Boger (not verified) says:

1. do:

install Bundle::Maypole

2. The article totally glosses over setting up mod_perl lib directories. It oddly states to drop the ClubDB.pm into /etc/httpd/lib/perl directory, even though it never talks about how to set it up. So, (assuming redhat, here), make sure your /etc/httpd/conf.d/perl.conf reads something like:

PerlSetEnv Perl5LIB /etc/httpd/lib/perl

...Agree, Author has not p

On April 5th, 2005 Admir Trakic (not verified) says:

...Agree,

Author has not provided any significant information about server side settings, also I find it article "agressivly redhat friendly".

Small shell for include testing:
$ cat testinc.pl
print "Content-type: text/plain\n\n";
print join "\n", @INC

If debian user try installing "libapache-mod-perl-doc" for more info about CGI/mod_perl stuff portings.

Hope it helps...

/Admir

RedHat/Fedora Friendly

On April 20th, 2005 barryp says:

An editorial decision was made to target one specific distribution (see my reply to another comment at the bottom of the actual article for the reasons behind this). As I have only so much time, I went with what I knew which was Fedora/RedHat. I have installed Maypole on RedHat 9 and Fedora 3 - granted, it takes a while to get everything set-up but, once it is, it works well. The Soccer Club example system will work on Maypole if Maypole is installed correctly. If Maypole has trouble installing, it's really just a matter of keeping at it until it does. There's a load of help on the Maypole mailing-list archive.

As there appears to be no link to the actual source code, here it is (from my own web-site) which should save some people some time.

Hope this helps.

--
Paul Barry

__________________________

Paul Barry

Featured Videos

Linux HOWTO: Video Editing Magic with ffmpeg

Non-linear video editing tools are great, but they're not always the best tool for the job. This is where a powerful tool like ffmpeg becomes useful. This tutorial by Elliot Isaacson covers the basics of transcoding video, as well as more advanced tricks like creating animations, screen captures, and slow motion effects.

Review: HP 2133 Mini-Note

Shawn Powers reviews the HP Mini-Note portable computer.

Thanks to our sponsor: Silicon Mechanics

Silicon Mechanics is a leading manufacturer of rackmount servers, storage, and high performance computing hardware. The best warranty offerings available are backed by experts dedicated to customer satisfaction.

more

From the Magazine

August 2008, #172

There's nuttin like a Cool Project to give you some relief from the summer heat, so get out your parka cuz we got a bunch of em. First up is the BUG, not a bug, The BUG. It's got a GPS, camera and more, in a hand-sized package that's user programmable. The BUG does everything. It's both a floor wax and a dessert topping. Get one now. Need a software version of a Swiss Army knife? Take a look at Billix, and don't leave home without it. Then, chew on this one, an X server on a Gumstix device driving an E-Ink display. Need more storage? How about 16 Terabytes? Can do.

And, of course, we have the usual cast of characters: Marcel, Reuven, Dave, Kyle, Doc, plus the new kid on the block Shawn Powers. But it doesn't stop there: build a MythTV box on a budget, build your own GIS system, set up the tools to monitor your enterprise and more. Finally, remember The War of the Worlds? Now you can play too.

Read this issue