learning for someone like me
I am looking for a source of learning, books, sites, whatever. I am a unix/oracle developer. I am experienced in perl/DBI. I thought it would be interesting to learn something about web development. I have some experience with HTML, XML-XSLT and Java Servlets, but Java is not fun. So I am looking for information on creating dynamic database driven web sites using perl. Most of the introductory web development books/sites do little with databases, and even pride themselves on showing how much you can do without knowing much about the backend. Books that look at building dynamic sites in depth assume you have a strong grounding in CGI/HTML. Ideas? ~quagly - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: learning for someone like me
Ok, run to a book store NOW, and get O'Rielly's Eagle Book! Read it from core to the core and then post questions here, once you are done. Good luck, Pavel look @ http://perl.apache.org/guide - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
URGENT: Call for participation for FREENIX (please forward) (fwd)
FYI -- Forwarded message -- Date: Fri, 17 Nov 2000 13:40:41 -0500 From: Rodent of Unusual Size [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: ASF members [EMAIL PROTECTED] Subject: URGENT: Call for participation for FREENIX (please forward) I'm on the programme committee for FREENIX 01 in June 2001. The call for participation ends on 27 November 2000, and we're still looking for presentations. I'll send the invite to new-httpd, apr, and apache-docs, but would members of the other Apache projects *please* forward the text below to their project lists ASAP? Thanks! URGENT: FREENIX 01 CALL FOR PARTICIPATION The FREENIX track of the 2001 USENIX annual technical conference is still seeking proposals. The deadline is 27 NOVEMBER 2000, which is a little more than a week away. If you might be interested in presenting at this conference, please see URL:http://www.usenix.org/events/usenix01/cfp/cfp.pdf That's an Acrobat PDF file that describes what sort of sessions are being sought, how to submit a proposal, and deadlines and dates. Thanks for your time and consideration! -- #kenP-)} Ken Coarhttp://Golux.Com/coar/ Apache Software Foundation http://www.apache.org/ "Apache Server for Dummies" http://Apache-Server.Com/ "Apache Server Unleashed" http://ApacheUnleashed.Com/ - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: two identical directives in Perl configuration (doc patch included)
Dave Kaufman wrote:
"Adi Fairbank" [EMAIL PROTECTED] wrote:
Dave Kaufman wrote:
$Location{"blah"} = {
require = "group payer_manager, payer_group demo"
};
should do the trick.
I wrote:
Thanks, that fixed it.
Actually, no that didn't fix it!
$r-requires
returns
[{ 'group' = "payer_manager, payer_group demo"}]
d'oh! we have the syntax wrong to begin with.
http://www.apache.org/docs/mod/core.html#require says:
Yes, but I'm using Apache::AuthCookie, which allows you to implement your own
require methods. Theoretically, I could have as many require'ments as I write
perl methods in the PerlAuthzHandler.
require group payer_manager
require payer_group demo
require user_ip 127.0.0.1
require dayofweek wednesday
etc..
This is why it would be useful for Perl sections to support:
$Location{"blah"} = {
require = ["req 1", "req 2", "req 3", "req 4", ..]
};
-Adi
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Re: Problem with single quote ' character
Hi Omri -
my $authors = $query{'authors'};
[...]
$q_authors = $dbh-quote($authors);
[...]
$sth = $dbh-prepare( "UPDATE tbl_sarah SET authors = '$authors',
It fails because you're not using the quoted version of the variables
(e.g. "$q_authors") in your prepare statement.
Using bind variables like Mike described below is still a better way to
go. Not only easier, but from what I understand (at least with Oracle) it
allows the database to cache a single update statement (the one with the
placeholders) instead of caching a new statement for each update (with
explicit column values).
The solution is simple, put the bind variables in the '$sth-execute'
and it will automagically be quoted like so:
$sth = $dbh-prepapre("UPDATE tbl_sarah SET authors = ?, title = ? WHERE
id = ?");
$sth-execute($authors, $title, $id);
use one variable per placeholder '?'. no need to use single quotes in the
SQL statement. for more info read the DBI documentation.
you wouldn't need all those '$q_var = $dbh-quote($var)' lines in the top
too.
Larry Leszczynski
[EMAIL PROTECTED]
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
new mailing lists archives
I've just updated http://perl.apache.org/#maillists and now I'm glad to announce to you that we have the online archives of modperl-dev and modperl-cvs lists thanks to Hank Leininger. Enjoy. _ Stas Bekman JAm_pH -- Just Another mod_perl Hacker http://stason.org/ mod_perl Guide http://perl.apache.org/guide mailto:[EMAIL PROTECTED] http://apachetoday.com http://jazzvalley.com http://singlesheaven.com http://perlmonth.com perl.org apache.org - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: compiling modperl on alpha
Didier: I had no trouble compiling mod_perl (with SSL and Frontpage support) on 4.0B and 4.0D True64. The script used on the mod_perl side is: #!/bin/sh perl Makefile.PL \ APACHE_SRC=../apache_1.3.12/src \ SSL_BASE=../openssl-0.9.5a \ DO_HTTPD=1 \ USE_APACI=1 \ PREP_HTTPD=1 \ EVERYTHING=1 make make test ### and on the Apache (1.3.12) side: #!/bin/sh SSL_BASE=../openssl-0.9.5a \ ./configure --prefix=/usr/local/apache \ --enable-module=ssl \ --activate-module=src/modules/perl/libperl.a \ --activate-module=src/modules/extra/mod_frontpage.o make make certificate make install ### It's worked like a charm. I guess that perl 5.6 differences appart, it should work. Regards, Rafael Caceres At 07:24 PM 11/16/00 -0500, you wrote: Hi all, maybe somebody can shed some light on this: I'm trying to compile mod_perl as a dso with apxs on Alpha/Tru64 unix and there is an error from the linker: ld -shared -expect_unresolved "*" -O4 -msym -std -s -L/usr/local/lib -o libperl.so mod_perl.lo perlxsi.lo perl_config.lo perl_util.l o perlio.lo mod_perl_opmask.lo Apache.lo Constants.lo ModuleConfig.lo Log.lo URI.lo Util.lo Connection.lo Server.lo File.lo Table.l o -Wl,-rpath,/usr/local/lib/perl5/5.6.0/alpha-dec_osf/CORE -L/usr/local/lib /usr/local/lib/perl5/5.6.0/alpha-dec_osf/auto/DynaLoade r/DynaLoader.a -L/usr/local/lib/perl5/5.6.0/alpha-dec_osf/CORE -lperl -lbind -ldbm -ldb -lm -liconv ld: Invalid flag usage: Wl,-rpath,/usr/local/lib/perl5/5.6.0/alpha-dec_osf/CORE, -Wx,-option must appear after -_SYSTYPE_SVR4 ld: Usage: ld [options] file [...] *** Exit 1 Where would this flag be defined? How can this be fixed? I tried this on both a Tru64 5.1 and an older DU4.0b and the error is the same. Can anyone give a clue? -- Didier Godefroy mailto:[EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: Apache::AuthenDBI NOTICE message
George Sanderson wrote:
So far, using Apache::AuthenDBI, I get an error_log message:
NOTICE: Unrecognized variable client_encoding
Every time the DBI ping is called.
I have not been able to tack down the origin of this message.
Any ideas or suggestions?
never seen before. What database do you use ?
I am using PostgreSQL 7.0.2
More details. . .
I am also using the latest Apache::AuthenDBI and Apache::AuthzDBI.
In startup.pl I have:
Apache::DBI-connect_on_init("dbi:Pg:dbname=atable", "webuser", "webuser",
{
PrintError = 1, # warn() on errors
RaiseError = 0, # don't die on error
AutoCommit = 1 # commit executes immediately
}
);
#
I did try seting PrintError=0 with no change on the NOTICE message.
Note: I am not using any of the following (in startup.pl):
Apache::DBI-setPingTimeOut("dbi:driver:database", $timeout);
Apache::AuthDBI-setCacheTime(0);
Apache::AuthDBI-setCleanupTime(-1);
Apache::AuthDBI-initIPC(5);
When I start httpd I get the following error log output.
==
[Wed Nov 15 17:47:48 2000] [info] created shared memory segment #12928
[Wed Nov 15 17:47:48 2000] [notice] Apache/1.3.14 (Unix) mod_perl/1.24_01
mod_layout/2.8 configured -- resuming normal operations
[Wed Nov 15 17:47:48 2000] [notice] suEXEC mechanism enabled (wrapper:
/usr/local/apache/bin/suexec)
[Wed Nov 15 17:47:48 2000] [info] Server built: Nov 5 2000 10:26:07
12052 Apache::DBI PerlChildInitHandler
12051 Apache::DBI PerlChildInitHandler
12053 Apache::DBI PerlChildInitHandler
NOTICE: Unrecognized variable client_encoding
Database handle destroyed without explicit disconnect at
/usr/local/lib/perl5/5.6.0/site_perl/Apache/DBI.pm line 140.
require 0 called at
/usr/local/lib/perl5/5.6.0/site_perl/Apache/DBI.pm line 140
Apache::DBI::childinit('Apache=SCALAR(0x874565c)') called at
/dev/null line 0
require 0 called at /dev/null line 0
12054 Apache::DBI PerlChildInitHandler
NOTICE: Unrecognized variable client_encoding
Database handle destroyed without explicit disconnect at
/usr/local/lib/perl5/5.6.0/site_perl/Apache/DBI.pm line 140.
require 0 called at
/usr/local/lib/perl5/5.6.0/site_perl/Apache/DBI.pm line 140
Apache::DBI::childinit('Apache=SCALAR(0x874565c)') called at
/dev/null line 0
require 0 called at /dev/null line 0
12055 Apache::DBI PerlChildInitHandler
12056 Apache::DBI PerlChildInitHandler
=
The NOTICE and etc messages are repeated several (12) times for the 6
Apache children and the 1 Apache root processes running (i.e. 2 NOTICE
messages per child).
The Apache::DBI.pm is version 0.87 and near line 140 I see:
sub childinit {
my $prefix = "$$ Apache::DBI";
print STDERR "$prefix PerlChildInitHandler \n" if $Apache::DBI::DEBUG 1;
#if (defined @ChildConnect) {
if (@ChildConnect) {
for my $aref (@ChildConnect) {
shift @$aref;
DBI-connect(@$aref);
$LastPingTime{@$aref[0]} = time;
}
}
1;
}
Note that I changed the "if(defined @ChildConnect" line because, "defined
on aggregates (hashes and arrays) is deprecated." Line 140 is:
$LastPingTime{@$aref[0]} = time;
please read postgresql-7.0.2/doc/postgres/trouble18031.htm.
Edmund
--
http://www.edmund-mergl.de
fon: +49 700 edemergl
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Re: new mailing lists archives
On Sat, 18 Nov 2000, Stas Bekman wrote: I've just updated http://perl.apache.org/#maillists and now I'm glad to announce to you that we have the online archives of modperl-dev and modperl-cvs lists thanks to Hank Leininger. Or visit http://archive.covalent.net/ if you have trouble. -- Sander van Zoest [[EMAIL PROTECTED]] Covalent Technologies, Inc. http://www.covalent.net/ (415) 536-5218 http://www.vanzoest.com/sander/ - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: new mailing lists archives
On Sat, 18 Nov 2000, Sander van Zoest wrote: On Sat, 18 Nov 2000, Stas Bekman wrote: I've just updated http://perl.apache.org/#maillists and now I'm glad to announce to you that we have the online archives of modperl-dev and modperl-cvs lists thanks to Hank Leininger. Or visit http://archive.covalent.net/ if you have trouble. Oh, you didn't tell me that you've completed this project. Sander, can you please add a name="" tags so I could link directly to the relevant sections? Thanks! _ Stas Bekman JAm_pH -- Just Another mod_perl Hacker http://stason.org/ mod_perl Guide http://perl.apache.org/guide mailto:[EMAIL PROTECTED] http://apachetoday.com http://jazzvalley.com http://singlesheaven.com http://perlmonth.com perl.org apache.org - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: security suggestion
I think Randal was making a similar point I was making last night (SG time). That as long as you execute Perl code, you can manipualte the memory space of Perl (and hance change the behavior of Apache::Registry). But you explained it in your reply to me. Basically you want explicit handlers that are tightly defined to run but you aren't talking about allowing users to run Apache::Registry scripts arbitrarily. Just explicitly defined pieces of code like a handler for counter() logic. The CGI scripts on your site would not be passed through Apache::Registry or Apache::PerlRun, they would run as normal CGIs. No? So that makes sense as a motivation to allow mod_perl on a server for content handlers that are tightly defined. But don't allow the users access to anything else in mod_perl. At 04:36 PM 11/17/00 -0500, Richard L. Goerwitz wrote: "Randal L. Schwartz" wrote: I think y'all are missing it. As soon as I have any Perl code access via Apache::Registry or anything like that, I can do this: *Apache::Registry::handler = \my_trojan_horse; Can you explain in what server-configuration context the above directive would be executed? (I'm not disputing anything you say; just trying to follow.) -- Richard Goerwitz[EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] __ Gunther Birznieks ([EMAIL PROTECTED]) eXtropia - The Web Technology Company http://www.extropia.com/ - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
CGI scripts mod_perl
Quick (and maybe stupid) question(s): How do we make sure regular CGI scripts are using mod_perl??? Is there a way to find out? Is there anything to modify to make them work with mod_perl?? -- Didier Godefroy mailto:[EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[OT] Another *new* idea patented
I know this is way off topic, but I couldn't resist. Sorry if this is old news. First Amazon figures out that cookies could be used for, (who would have guessed?), maintaining state between sessions and patenting the concept. What a new idea! Now looking at eBay and I see that they have invented this thing called "thumbnails" that are miniature photos that you can, get this, click with your mouse! Not only that, they have figured out a way to transfer images from one computer to another via HTTP! Another brilliant invention that needs a patent. http://pages.ebay.com/help/basics/g-gallery.html "Gallery Our patent pending Gallery () is a new way of browsing items for sale at eBay. The Gallery presents miniature pictures, called thumbnails, for all of the items sellers have supplied pictures for in JPG format." US Patent 6,058,417 http://164.195.100.11/netahtml/srchnum.htm Can Randal still give his "Mod_perl Enabled Thumbnail Picture Server" talk? BTW -- For fun go to Ebay and do a search for any auction, then look closely at the HTTP headers IIS is spitting out when requesting any of their auctions. You can imagine the fun in trying to explain (over three emails now) the problem to their customer support. Bill Moseley mailto:[EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [OT] Another *new* idea patented
On Sat, 18 Nov 2000, Bill Moseley wrote: I know this is way off topic, but I couldn't resist. Sorry if this is old news. First Amazon figures out that cookies could be used for, (who would have guessed?), maintaining state between sessions and patenting the concept. What a new idea! Now looking at eBay and I see that they have invented this thing called "thumbnails" that are miniature photos that you can, get this, click with your mouse! Not only that, they have figured out a way to transfer images from one computer to another via HTTP! Another brilliant invention that needs a patent. http://pages.ebay.com/help/basics/g-gallery.html "Gallery Our patent pending Gallery () is a new way of browsing items for sale at eBay. The Gallery presents miniature pictures, called thumbnails, for all of the items sellers have supplied pictures for in JPG format." NEVER UNDERESTIMATE POWER OF A LARGE GROUP OF STUPID PEOPLE. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
cvs commit: modperl-site index.html
sbekman 00/11/18 09:04:38 Modified:.index.html Log: correcting the url of the email archives: mod_perl at marc.theaimsgroup.com adding two archives for -cvs and -dev lists at the same server Revision ChangesPath 1.66 +33 -2 modperl-site/index.html Index: index.html === RCS file: /home/cvs/modperl-site/index.html,v retrieving revision 1.65 retrieving revision 1.66 diff -u -r1.65 -r1.66 --- index.html2000/08/31 12:51:04 1.65 +++ index.html2000/11/18 17:04:38 1.66 @@ -463,8 +463,8 @@ /li li a - href="http://www.progressive-comp.com/Lists/?l=apache-modperlr=1w=2#apache-modperl" - www.progressive-comp.com/a + href="http://marc.theaimsgroup.com/?l=apache-modperlr=1w=2#apache-modperl" + http://marc.theaimsgroup.com/a /li li a href="http://www.egroups.com/group/modperl/"www.egroups.com/a @@ -554,6 +554,22 @@ /ul + p + List's searchable archives: + + ul + + li + a + href="http://marc.theaimsgroup.com/?l=apache-modperl-devr=1w=2#apache-modperl-dev" + http://marc.theaimsgroup.com/a. + /li + + /ul + + /p + + pa name="cvs-list"/a The bmodperl-cvs/b list is the list where you can watch mod_perl getting patched. No real discussions @@ -589,6 +605,21 @@ bNote/b: To subscribe or unsubscribe send an empty email to one of the above addresses. + /p + + p + List's searchable archives: + + ul + + li + a + href="http://marc.theaimsgroup.com/?l=apache-modperl-cvsr=1w=2#apache-modperl-cvs" + http://marc.theaimsgroup.com/a. + /li + + /ul + /p hr width="40%" align="left"
