Problem with Apache::Session::DBI

2000-10-26 Thread Alberto Mateos

I should explain better:

Once, in one of my mod_perl files, I did this trying to delete all the
data from a session:

tied(%session)-delete

I know is wrong.

Anyway since I did this I can't request any page from the server. I
removed the code from where it was.

The error I see in the logs is:

[error] Can't locate object method "populate" via package
"Apache::Session::DBI" at
/usr/lib/perl5/site_perl/5.005/Apache/Session.pm line 368.

Alberto.





Re: ApacheCon Sunday Pub Meet

2000-10-26 Thread Stas Bekman

On Fri, 20 Oct 2000, Doug MacEachern wrote:

 On Thu, 19 Oct 2000, Matt Sergeant wrote:
 
  How about Harvey Floorbangers, from 7 till late. (erm, I think late might
  still be 11pm for england *sigh*)...
  
  "With a name like Harvey Floorbangers you'd expect this to be a cheesy
  theme bar with singing bar staff and signed guitars on the
  wall. Thankfully, this is actually a traditional English pub frequented by
  locals and visitors to the Olympia Exhibition Building across the road."
  
  Sound OK to everyone? (Stas, I'm sure they serve tomato juice too...:)
 
 count me in!
 
 p.s.
 stas' drink of choice is cranberry juice.

Sorry folks I've missed this meeting, but I've got my doze of cranberry
juice at the rest of our pub hangouts :)

For those who have missed the conference -- it was very cool, both in a
number of attendees to the mod_perl classes and the hours spent with cool
people outside the classes, when there were no mod_perl classes :)

Just in case you are wandering what one could do at the conference if
looking at the schedule program doesn't give you an insentive to go to the
confence -- you miss an important point. Conferences are not about
learning new things (well sometimes :) but about meeting people face to
face and having fun that you couldn't have otherwise over email. That's
it.

BTW, Doug's mod_perl 2.0 talk was so cool!!! Just imagine that the demos
and slides were running on 'mod_perl/1.99-dev apache/2.0-dev perl/5.7.0'
you get the idea...

And last but not least, you have missed the talk by Douglas Adams and his
books signing...

[...490 more mod_perl emails to read...]

_
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





RE: Authorization handler shared database handle

2000-10-26 Thread Geoffrey Young



 -Original Message-
 From: John Russell [mailto:[EMAIL PROTECTED]]
 Sent: Tuesday, October 24, 2000 8:08 PM
 To: [EMAIL PROTECTED]
 Subject: Authorization handler  shared database handle
 
 
 I'm using Apache::DBI, DBI and DBD::Oracle
 
 The database connection is made with one username/password for best
 performance but a pl/sql program in the database authorizes 
 the supplied
 username and password and then generates the desired output.
 
 The username and password has been obtained using basic authentication
 with Apache::AuthAny (pp 282-285 Apache Modules with Perl  C 
 - Stein 
 MacEachern).
 
 Possible solutions might be:

I'm not sure I understand what the 'problem' is - do you mean that you use
one user/pass to authenticate another user/pass in authentication but then
need the authenticated user/pass to connect to the database during content
generation (PerlHandler)?

One of the problems with Apache::DBI is that it caches connections per
connect string, meaning that if you have 50 distinct users you'll have 50
cached connections per child (assuming that they hit each child)...

one solution to this is to cache the authenticating user/pass and then use
the 6 argument connect call:
$dbh = DBI-connect($dbase, $user, $pass, \%attr, undef, "connect") || die
$DBI::errstr;
  

which will override Apache::DBI for that connection only (keep in mind you
should call disconnect if you weren't before)

 
 1) connect and authorize using the authentication handler and pass the
 database handle to the script to do further operations on the opened
 connection. If this is possible how would you pass the database handle
 from the authentication handler to the perl program?

I imagine you can place $dbh into pnotes and pass it to your PerlHandler,
but if you are using Apache::DBI calling connect again will have basically
the same effect, since it will just return a cached connection

HTH

--Geoff

 
 2) Allow the perl program to return DECLINED or AUTH_REQUIRED 
 to Apache.
 How would you do this?
 
 Thanks,
 John Russell
 



Sticking Environment with Apache::ASP

2000-10-26 Thread Brian Wheeler

I'm having trouble with using $Request-ServerVariables() in Apache::ASP.
After 6 requests (always), the last requested page gets returned, regardless
of what is actually being passed.  I'm using PATH_INFO to pass information.
Coincedentally (or is it?) there are 6 httpd processes running.

If I make a change to the script or restart the server, it works fine for
the first 6 requests.  I'm passing the output through AxKit via Apache::Filter.

Here's the relevant sections of the involved files:

--- test.asp ---
%
$env=$Request-ServerVariables();

foreach (sort(keys(%$env))) {
print "item$_ = ",$env-{$_},"/item\n";
}
%


--- httpd.conf ---
## Set up Apache::ASP
PerlModule Apache::ASP
FilesMatch "\.asp$"
  SetHandler perl-script
  PerlSetVar Filter On
  AxCacheDir /tmp/axkit
  AxProvider Apache::AxKit::Provider::Filter
  PerlHandler Apache::ASP AxKit
  AuthName Nothing
  PerlSetVar Global /tmp/asp_cache
  AxAddStyleMap text/xsl Apache::AxKit::Language::Sablot
  AxAddStyleMap application/x-xpathscript Apache::AxKit::Language::XPathScript
  AxAddStyleMap application/x-xsp Apache::AxKit::Language::XSP
/FilesMatch



Thanks!
Brian Wheeler
[EMAIL PROTECTED]



problem connecting to oracle with DBD-Oracle-1.06/DBI-1.14 with Perl version v5.6.0 for Apache/1.3.12 (Unix) mod_perl/1.24 mod_ssl/2.6.6 OpenSSL/0.9.5a

2000-10-26 Thread HotMail: Bill

I've got a system running the following:

Perl version v5.6.0 for Apache/1.3.12 (Unix) mod_perl/1.24 mod_ssl/2.6.6
OpenSSL/0.9.5a

If I run the cgi scripts from command line they connect to the oracle
database just fine.

If I run them under the webserver (apache::registry), the cannot connect to
the database.
ORA-12054 error.

Has anyone seen this before or have an idea on how to track down the
problem?
All help will be very appreciated.

Thanks,
Bill



Re: problem connecting to oracle with DBD-Oracle-1.06/DBI-1.14 with Perl version v5.6.0 for Apache/1.3.12 (Unix) mod_perl/1.24 mod_ssl/2.6.6 OpenSSL/0.9.5a

2000-10-26 Thread Alexander Farber (EED)

HotMail: Bill wrote:
 If I run the cgi scripts from command line they connect to the oracle
 database just fine.
 
 If I run them under the webserver (apache::registry), the cannot connect to
 the database.
 ORA-12054 error.
 
 Has anyone seen this before or have an idea on how to track down the
 problem?

I suggest asking on the dbi-users list (archive
at http://www.xray.mpe.mpg.de/mailing-lists/dbi/ )
and submitting there a trace of 2 or higher (perldoc DBI)



RE: problem connecting to oracle with DBD-Oracle-1.06/DBI-1.14 with Perl version v5.6.0 for Apache/1.3.12 (Unix) mod_perl/1.24 mod_ssl/2.6.6 OpenSSL/0.9.5a

2000-10-26 Thread David Harris


HotMail: Bill [mailto:[EMAIL PROTECTED]] wrote:
 I've got a system running the following:

 Perl version v5.6.0 for Apache/1.3.12 (Unix) mod_perl/1.24 mod_ssl/2.6.6
 OpenSSL/0.9.5a

 If I run the cgi scripts from command line they connect to the oracle
 database just fine.

 If I run them under the webserver (apache::registry), the cannot connect to
 the database.
 ORA-12054 error.

 Has anyone seen this before or have an idea on how to track down the
 problem?
 All help will be very appreciated.

 Thanks,
 Bill

Do you have the environment setup correctly? To connect from mod_perl I do the
following in my modules:

sub get_database_handle
{
my ($db_user, $db_pass, $ora_home, $ora_sid) = get_userpass();

$ENV{ORACLE_HOME} = $ora_home;
$ENV{ORACLE_SID} = $ora_sid;

my $dbh = DBI-connect("dbi:Oracle:", $db_user, $db_pass,
{ RaiseError = 1, AutoCommit = 0, PrintError = 0 } )
or die "unable to connect: $DBI::errstr";

return $dbh;
}

I looked up ORA-12054 (for my server version) and got:

ORA-12054 cannot set the ON COMMIT refresh attribute for the materialized view
Cause: The materialized view does not satisfy conditions for refresh at commit
time.
Action: Specify only legal options.

which does not make much sense to me.

David Harris
President, DRH Internet Inc.
[EMAIL PROTECTED]
http://www.drh.net/






Re: problem connecting to oracle with DBD-Oracle-1.06/DBI-1.14 with Perlversion v5.6.0 for Apache/1.3.12 (Unix) mod_perl/1.24 mod_ssl/2.6.6OpenSSL/0.9.5a

2000-10-26 Thread Richard Routh/Tampa/IBM

What version/variety of UNIX?

If I can clarify this for anyone please respond and I will gladly review
this.

Mit Freundlichen Grüssen/Kind Regards/Met Vreundlijke Groet,
Richard Routh
ABS -  Network Capacity, Performance and Tuning

Vox: 863-965-7773
Fax: 209-882-9276
Email:  [EMAIL PROTECTED]

In the middle of difficulty lies opportunity. - Albert Einstein



"HotMail: Bill" [EMAIL PROTECTED] on 10/26/2000 11:28:53 AM

To:   [EMAIL PROTECTED]
cc:
Subject:  problem connecting to oracle with DBD-Oracle-1.06/DBI-1.14 with
  Perl version v5.6.0 for Apache/1.3.12 (Unix) mod_perl/1.24
  mod_ssl/2.6.6 OpenSSL/0.9.5a



I've got a system running the following:

Perl version v5.6.0 for Apache/1.3.12 (Unix) mod_perl/1.24 mod_ssl/2.6.6
OpenSSL/0.9.5a

If I run the cgi scripts from command line they connect to the oracle
database just fine.

If I run them under the webserver (apache::registry), the cannot connect to
the database.
ORA-12054 error.

Has anyone seen this before or have an idea on how to track down the
problem?
All help will be very appreciated.

Thanks,
Bill





Re: Sticking Environment with Apache::ASP

2000-10-26 Thread G.W. Haywood

Hi there,

On Thu, 26 Oct 2000, Brian Wheeler wrote:

 I'm having trouble with using $Request-ServerVariables() in Apache::ASP.
 After 6 requests (always), the last requested page gets returned, regardless
 of what is actually being passed.  I'm using PATH_INFO to pass information.
 Coincedentally (or is it?) there are 6 httpd processes running.

Try investigating with httpd -X

Try also http://perl.apache.org/guide

I'll bet Josh knows something too, but he's very busy right now.

73,
Ged.




Re: problem connecting to oracle with DBD-Oracle-1.06/DBI-1.14 with Perl version v5.6.0 for Apache/1.3.12 (Unix) mod_perl/1.24 mod_ssl/2.6.6 OpenSSL/0.9.5a

2000-10-26 Thread HotMail: Bill

Oops  correction to below: should read ORA-12154
 ORA-12154 (DBD ERROR: OCIServerAttach)
- Original Message -
From: "HotMail: Bill" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, October 27, 2000 12:28 AM
Subject: problem connecting to oracle with DBD-Oracle-1.06/DBI-1.14 with
Perl version v5.6.0 for Apache/1.3.12 (Unix) mod_perl/1.24 mod_ssl/2.6.6
OpenSSL/0.9.5a


 I've got a system running the following:

 Perl version v5.6.0 for Apache/1.3.12 (Unix) mod_perl/1.24 mod_ssl/2.6.6
 OpenSSL/0.9.5a

 If I run the cgi scripts from command line they connect to the oracle
 database just fine.

 If I run them under the webserver (apache::registry), the cannot connect
to
 the database.
 ORA-12054 error.

 Has anyone seen this before or have an idea on how to track down the
 problem?
 All help will be very appreciated.

 Thanks,
 Bill




Re: problem connecting to oracle with DBD-Oracle-1.06/DBI-1.14 with Perl version v5.6.0 for Apache/1.3.12 (Unix) mod_perl/1.24 mod_ssl/2.6.6 OpenSSL/0.9.5a

2000-10-26 Thread HotMail: Bill

redhat linux 6.2
- Original Message -
From: "Richard Routh/Tampa/IBM" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, October 27, 2000 12:47 AM
Subject: Re: problem connecting to oracle with DBD-Oracle-1.06/DBI-1.14 with
Perl version v5.6.0 for Apache/1.3.12 (Unix) mod_perl/1.24 mod_ssl/2.6.6
OpenSSL/0.9.5a


What version/variety of UNIX?

If I can clarify this for anyone please respond and I will gladly review
this.

Mit Freundlichen Grüssen/Kind Regards/Met Vreundlijke Groet,
Richard Routh
ABS -  Network Capacity, Performance and Tuning

Vox: 863-965-7773
Fax: 209-882-9276
Email:  [EMAIL PROTECTED]

In the middle of difficulty lies opportunity. - Albert Einstein



"HotMail: Bill" [EMAIL PROTECTED] on 10/26/2000 11:28:53 AM

To:   [EMAIL PROTECTED]
cc:
Subject:  problem connecting to oracle with DBD-Oracle-1.06/DBI-1.14 with
  Perl version v5.6.0 for Apache/1.3.12 (Unix) mod_perl/1.24
  mod_ssl/2.6.6 OpenSSL/0.9.5a



I've got a system running the following:

Perl version v5.6.0 for Apache/1.3.12 (Unix) mod_perl/1.24 mod_ssl/2.6.6
OpenSSL/0.9.5a

If I run the cgi scripts from command line they connect to the oracle
database just fine.

If I run them under the webserver (apache::registry), the cannot connect to
the database.
ORA-12054 error.

Has anyone seen this before or have an idea on how to track down the
problem?
All help will be very appreciated.

Thanks,
Bill






Apache::Filter problem? [was: Re: Sticking Environment with Apache::ASP]

2000-10-26 Thread Brian Wheeler

 
 Hi there,
 
 On Thu, 26 Oct 2000, Brian Wheeler wrote:
 
  I'm having trouble with using $Request-ServerVariables() in Apache::ASP.
  After 6 requests (always), the last requested page gets returned, regardless
  of what is actually being passed.  I'm using PATH_INFO to pass information.
  Coincedentally (or is it?) there are 6 httpd processes running.
 
 Try investigating with httpd -X
 
 Try also http://perl.apache.org/guide
 
 I'll bet Josh knows something too, but he's very busy right now.
 
 73,
 Ged.
 

Well, running under -X makes it hang after the first hit (as I suspected).
I also have it printing the current time, and when its hanging, the
time isn't updated, so its not an environment thing, per se, but a
caching issue of some sort.  AxKit (the module used to filter the ASP
output) always prints the correct time, even when the ASP portion is hung.

Is this really an Apache::Filter issue, perhaps?  Apache::ASP-AxKit is 
the only filter I have running on my machine (since Apache::RegistryFilter
seems to be broken).  I may have to test it out more...

Brian



ApacheCon 2000

2000-10-26 Thread Simon_Wilcox


As a relative newbie to the whole Apache/mod_perl world (just 7 months !) I
wasn't sure what to expect from the conference.

  I have to report that it was fantastic. The enthusiasm of everyone
  involved and their openness was just amazing to someone used to
  closed-source software.

  Stas' talks were great, just a pity we didn't have another couple of hours
  :-)

  Stas - I'm sorry I didn't get to thank you personally for The Guide,
  without which I would be dead (or at least out of a job !).

  I agree with the other posts that Doug's talk was very cool. So many
  things I want to do right now will be so easy in a few months time.
  Especially filters !

  It was clear to me that everyone involved is so committed, on a really
  personal level, to this technology and I am even more convinced that
  moving to this platform was the right thing to do.

  Thank you all.

  Simon Wilcox.



__


   This email contains proprietary information some or all of which may be
   legally privileged.  It is for the intended recipient only. If an addressing
   or transmission error has misdirected this email, please notify the author by
   replying to this email. If you are not the intended recipient you must not
   use, disclose, distribute, copy, print, or reply on this email.





sending Apache::ASP output to a variable?

2000-10-26 Thread Jeff Ng

I would like to Apache::ASP to parse pages in an existing mod_perl
environment.  Ideally, I could set headers with mod_perl, then use
Apache::ASP to parse templates which I can arbitrarily combine.  It seems
that using Apache::ASP forces me to do most of my coding in the perlscript
whereas I would prefer to minimize this for the sake of not interspersing
too much code within the HTML.

As it stands, it appears that the output of Apache::ASP goes directly to
stdout.  Is there a way to use Apache::ASP as part of a normal mod_perl
module, then capture the output to a variable?

Or perhaps there is a better solution using Mason?


 Jeff Ng
Lead Web Developer
   onDevice Corp.
 [EMAIL PROTECTED]




Re: ApacheCon 2000

2000-10-26 Thread Stas Bekman

 As a relative newbie to the whole Apache/mod_perl world (just 7 months !) I
 wasn't sure what to expect from the conference.
 
   I have to report that it was fantastic. The enthusiasm of everyone
   involved and their openness was just amazing to someone used to
   closed-source software.
 
   Stas' talks were great, just a pity we didn't have another couple of hours
   :-)

Thanks, too bad that this time I'd only 4 hours :) And because of some (:)
Douglas Adams talk they enforced me to finish on time :)

   Stas - I'm sorry I didn't get to thank you personally for The Guide,
   without which I would be dead (or at least out of a job !).

No problem at all, the Guide is a collaborative work of many many people
on this list, so 'thank you' applies to all of them not only me!!!

   I agree with the other posts that Doug's talk was very cool. So many
   things I want to do right now will be so easy in a few months time.
   Especially filters !
 
   It was clear to me that everyone involved is so committed, on a really
   personal level, to this technology and I am even more convinced that
   moving to this platform was the right thing to do.

Welcome to the great world with great applications and great people!

_
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





Re: Authenticated Sessions, Performance

2000-10-26 Thread Joe Schaefer

"Marinos J. Yannikos" [EMAIL PROTECTED] writes:

 Hi!
 
 I need to implement user authentication / session management for a
 relatively busy web site and I have observed the following:
 
 1) one database query per visited page is out of the question, at this time
 we can't afford the hardware to scale up to our projected 10-15 mil. page
 impressions / month (currently  2,5 mil.), so we can't simply take the
 user/password data from a cookie or through the Basic Authentication
 mechanism at each request and authenticate. Session management using an SQL
 database or even GDBM/DB is thus also not easily possible.
 
 2) caching the database lookups for authentication and sessions / user state
 would require some sort of synchronization between the apache processes for
 the case of password / user data changes, IPC::Cache turned out to be very
 slow on our FreeBSD box (so it's out)
 
 3) Ticket-based authentications seems like a high-performance solution (user
 name, password, perhaps some session state are MD5-hashed and stored in a
 cookie, no database queries needed for authentication, no state must be
 shared among apache processes), a "permanent" login can be achieved by
 combining this method with a common login cookie (1 database query per
 session). This seems to be the best solution, although the amount of session
 state that can be kept easily is limited (larger stuff can be stored in a
 database if accessed less frequently).
 

I recommend you use option 3.  It is the easiest to manage, has the best
performance, and is very scalable.  In the future, you can add additional
security by maintaining an altogether separate authentication server that
runs over SSL.  No more plaintext passwords over the wire, and the performance
hit you suffer is limited to the sign-on process. The only downside it that 
you are requiring your users to enable cookies. They'll get over it :)

 Since a variety of mod_perl, CGI and JSP scripts need to use the
 authentication mechanism, a PerlAuthenHandler seems necessary (it sets
 $ENV{REMOTE_USER}).
 
 Has anyone of those who have faced a similar problem got any other ideas?
 Suggestions? Success stories?

The eagle book contains an excellent discussion on how to set one up. See

http://www.modperl.org/book/chapters/ch6.html

Then go out and buy it :).

-- 
Joe Schaefer

SunStar Systems, Inc.



Re: sending Apache::ASP output to a variable?

2000-10-26 Thread G.W. Haywood

Hi there,

On Thu, 26 Oct 2000, Jeff Ng wrote:

 it appears that the output of Apache::ASP goes directly to
 stdout.  Is there a way to use Apache::ASP as part of a normal mod_perl
 module, then capture the output to a variable?

Have a look at sub PRINT and sub PRINTF in ASP.pm, I'm sure you can do
what you want there.  Check out the Eagle Book if you're unsure about
tied filehandles.

73,
Ged.




Re: problem connecting to oracle with DBD-Oracle-1.06/DBI-1.14 with Perl version v5.6.0 for Apache/1.3.12 (Unix) mod_perl/1.24 mod_ssl/2.6.6 OpenSSL/0.9.5a

2000-10-26 Thread Kailashnath V Rampure


I had a problem connectingto DB using CGI scripts, but it was
working fine manual connections. So we had to add line
“$ORACLE_HOME/lib “ in the file /etc/ld.so.conf and run command
ldconfig
Here Please replace $ORACLE_HOME with absolute path.

Hope this solves the problem.

Regards
Kailas
The line is 
At 12:51 AM 10/27/00 +0900, HotMail: Bill wrote:
Oops correction to below:
should read ORA-12154
ORA-12154 (DBD ERROR: OCIServerAttach)
- Original Message -
From: HotMail: Bill [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, October 27, 2000 12:28 AM
Subject: problem connecting to oracle with DBD-Oracle-1.06/DBI-1.14
with
Perl version v5.6.0 for Apache/1.3.12 (Unix) mod_perl/1.24
mod_ssl/2.6.6
OpenSSL/0.9.5a


 I've got a system running the following:

 Perl version v5.6.0 for Apache/1.3.12 (Unix) mod_perl/1.24
mod_ssl/2.6.6
 OpenSSL/0.9.5a

 If I run the cgi scripts from command line they connect to the
oracle
 database just fine.

 If I run them under the webserver (apache::registry), the cannot
connect
to
 the database.
 ORA-12054 error.

 Has anyone seen this before or have an idea on how to track down
the
 problem?
 All help will be very appreciated.

 Thanks,
 Bill



Re: Rapid prototyping and mirroring

2000-10-26 Thread Dave Rolsky

On Thu, 26 Oct 2000, John Marquart wrote:

 the possibility of multiple mirror sites around the world.  Is there a
 apache/mod_perl module that enables this?  (i.e. an end-user add content
 at one sight, and upon committing it, it propogates to the other mirror
 sites?)  Or am I just ficticiously remembering past postings.

Why use Apache for this?  Seems like CVS with a script run for checkins
could accomplish the same thing.


-dave

/*==
www.urth.org
We await the New Sun
==*/




Re: sending Apache::ASP output to a variable?

2000-10-26 Thread Joshua Chamas

Jeff Ng wrote:
 
 I would like to Apache::ASP to parse pages in an existing mod_perl
 environment.  Ideally, I could set headers with mod_perl, then use
 Apache::ASP to parse templates which I can arbitrarily combine.  It seems
 that using Apache::ASP forces me to do most of my coding in the perlscript
 whereas I would prefer to minimize this for the sake of not interspersing
 too much code within the HTML.
 
 As it stands, it appears that the output of Apache::ASP goes directly to
 stdout.  Is there a way to use Apache::ASP as part of a normal mod_perl
 module, then capture the output to a variable?
 

Apache::ASP was built to be a fully standalone environment, thus
doing this is not easy.  It would be a worthwhile extension of
the environment to be able to use Apache::ASP just to render
specific templates, and provide the output back to the caller,
but an extension it would be, quite significant I would imagine.

 Or perhaps there is a better solution using Mason?
 

... also some of the other templating solutions, which were
designed for this purpose.

-- Joshua
_
Joshua Chamas   Chamas Enterprises Inc.
NodeWorks  free web link monitoring   Huntington Beach, CA  USA 
http://www.nodeworks.com1-714-625-4051



Re: Sticking Environment with Apache::ASP

2000-10-26 Thread Joshua Chamas

Brian Wheeler wrote:
 
 I'm having trouble with using $Request-ServerVariables() in Apache::ASP.
 After 6 requests (always), the last requested page gets returned, regardless
 of what is actually being passed.  I'm using PATH_INFO to pass information.
 Coincedentally (or is it?) there are 6 httpd processes running.
 
 If I make a change to the script or restart the server, it works fine for
 the first 6 requests.  I'm passing the output through AxKit via Apache::Filter.
 

Sound like a browser caching issue, which normally
occurs because of particular headers that are sent
back.  Anything in your request chain could be adding
those headers, like Expires.  What do you get from the 
request if you do:

  lwp-request -edS http://$URL

There is also the possibility that AxKit is assuming the 
source to be static, and is caching things at that level?
Its worth investigating at least.

BTW, I think what you are trying to do here is very cool.

--Joshua

_
Joshua Chamas   Chamas Enterprises Inc.
NodeWorks  free web link monitoring   Huntington Beach, CA  USA 
http://www.nodeworks.com1-714-625-4051



Removing entries from @INC?

2000-10-26 Thread Eamon Daly

We've just started using StatINC on our staging server, and it's
slowed things down quite a bit, true to the docs. I've been trying
to pare down @INC with little success. My startup.pl script begins:

BEGIN: {
  use Apache ();
  no lib qw(:ALL
'/web/home/apache/'
'/web/home/apache/lib'
'/web/home/apache/lib/perl');
  use lib Apache-server_root_relative('lib');
}

yet scripts running under mod_perl still report:

/web/home/apache/lib
/web/home/apache/lib
/usr/local/lib/perl5/5.00503/sun4-solaris
/usr/local/lib/perl5/5.00503
/usr/local/lib/perl5/site_perl/5.005/sun4-solaris
/usr/local/lib/perl5/site_perl/5.005
.
/web/home/apache/
/web/home/apache/lib/perl

Note the duplicate entries, plus entries that should have been
deleted altogether. Is there a syntax I'm missing?


Eamon Daly
FastWeb, Inc.
847 568 6410




Apache::ASP + Apache::Filter - how fast? (was:sending Apache::ASP output to a variable?)

2000-10-26 Thread Jeff Ng

Thanks Ged.  I started down that path, but found that Apache::Filter
combined with Apache::ASP basically does the job I need.  There are a few
limitations, but it should be good enough.  The only remaining concern is
speed.

Does anyone have experience with this setup?

Thanks.


Jeff.

  it appears that the output of Apache::ASP goes directly to
  stdout.  Is there a way to use Apache::ASP as part of a 
 normal mod_perl
  module, then capture the output to a variable?
 
 Have a look at sub PRINT and sub PRINTF in ASP.pm, I'm sure you can do
 what you want there.  Check out the Eagle Book if you're unsure about
 tied filehandles.
 
 73,
 Ged.
 



Replacing Authen Authz handlers

2000-10-26 Thread Bill Moseley

I've got Authen and Authz protecting an entire site:

   location /
   PerlAuthenHandler My::Authen
   PerlAuthzHandler My::Authz
   AuthType Basic
   AuthName Test
   require valid-user
   /location

I'd like to have one directory that uses Apache's built-in Basic
Authentication, but I'm having a hard time making it happen.

I've tried using a "PerlSetVar DisableAuthen 1" and then returning DECLINED
in my handlers, but that's causing this error:

   configuration error:  couldn't check user.  No user file?: /test

Can someone fill me in, please.  Also, what's Apache seeing that's
triggering the above error message.

Thanks,



Bill Moseley
mailto:[EMAIL PROTECTED]



Re: Apache::ASP + Apache::Filter - how fast? (was:sending Apache::ASPoutput to a variable?)

2000-10-26 Thread Joshua Chamas

Jeff Ng wrote:
 
 Thanks Ged.  I started down that path, but found that Apache::Filter
 combined with Apache::ASP basically does the job I need.  There are a few
 limitations, but it should be good enough.  The only remaining concern is
 speed.
 
 Does anyone have experience with this setup?
 

No real world experience, but in the lab it seems speedy enough,
but then it all depends on what you need to get out of it.
Your own performance analysis will be the best here.
I would recommend cranking on it with ab for a rough 
estimate.

One fundamental limitation with this setup is how I/O is
buffered, that you can't ever send a trickle down to 
the web client, its all or none.

--Joshua



Re: sending Apache::ASP output to a variable?

2000-10-26 Thread Les Mikesell


- Original Message -
From: "Jeff Ng" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, October 26, 2000 12:07 PM
Subject: sending Apache::ASP output to a variable?


 I would like to Apache::ASP to parse pages in an existing mod_perl
 environment.  Ideally, I could set headers with mod_perl, then use
 Apache::ASP to parse templates which I can arbitrarily combine.  It seems
 that using Apache::ASP forces me to do most of my coding in the perlscript
 whereas I would prefer to minimize this for the sake of not interspersing
 too much code within the HTML.

 As it stands, it appears that the output of Apache::ASP goes directly to
 stdout.  Is there a way to use Apache::ASP as part of a normal mod_perl
 module, then capture the output to a variable?

One thing that may not be obvious is that if you use mod_include in
apache along with mod_perl and put something like:
!--#include virtual="/cgi-bin/perlprog.pl$PATH_INFO?$QUERY_STRING" --
in the *.shtml file, apache will run it efficiently as a subrequest in
the same process (assuming apache is configured to run that URL under
mod_perl) and substitute the output in the page.  It isn't quite as flexible
as being able to reparse the output by a program but it does let people
who are likely to break the perl programs use them in their html pages.

   Les Mikesell
[EMAIL PROTECTED]





Re: problem connecting to oracle with DBD-Oracle-1.06/DBI-1.14 with Perl version v5.6.0 for Apache/1.3.12 (Unix) mod_perl/1.24 mod_ssl/2.6.6 OpenSSL/0.9.5a

2000-10-26 Thread HotMail: Bill



Yup that solved... that error message.. now I 
get ORA-06401 (DBD ERROR: OCIServerAttach)

-Bill

  - Original Message - 
  From: 
  Kailashnath V 
  Rampure 
  To: HotMail: Bill ; HotMail: 
  Bill ; [EMAIL PROTECTED] 
  Sent: Friday, October 27, 2000 3:52 
  AM
  Subject: Re: problem connecting to oracle 
  with DBD-Oracle-1.06/DBI-1.14 with Perl version v5.6.0 for Apache/1.3.12 
  (Unix) mod_perl/1.24 mod_ssl/2.6.6 OpenSSL/0.9.5a
  I had a 
  problem connectingto DB using CGI scripts, but it was working fine manual 
  connections. So we had to add line $ORACLE_HOME/lib  in the file 
  /etc/ld.so.conf and run command "ldconfig"Here Please replace $ORACLE_HOME 
  with absolute path.Hope this solves the 
  problem.RegardsKailasThe line is At 12:51 AM 
  10/27/00 +0900, HotMail: Bill wrote:
  Oops correction to below: 
should read ORA-12154ORA-12154 (DBD ERROR: 
OCIServerAttach)- Original Message -From: "HotMail: Bill" 
[EMAIL PROTECTED]To: [EMAIL PROTECTED]Sent: 
Friday, October 27, 2000 12:28 AMSubject: problem connecting to oracle 
with DBD-Oracle-1.06/DBI-1.14 withPerl version v5.6.0 for Apache/1.3.12 
(Unix) mod_perl/1.24 mod_ssl/2.6.6OpenSSL/0.9.5a I've 
got a system running the following: Perl version v5.6.0 for 
Apache/1.3.12 (Unix) mod_perl/1.24 mod_ssl/2.6.6 
OpenSSL/0.9.5a If I run the cgi scripts from command line 
they connect to the oracle database just fine. If I 
run them under the webserver (apache::registry), the cannot 
connectto the database. ORA-12054 error. 
Has anyone seen this before or have an idea on how to track down the 
problem? All help will be very appreciated. 
Thanks, Bill


Re: Connection Pooling / TP Monitor

2000-10-26 Thread Matt Sergeant

On Tue, 24 Oct 2000, Jeff Horn wrote:

 However, I am also aware of a _major_ ISP that implements their email
 system using a _major_ RDBMS that has had problems that are best
 solved via connection pooling.  Essentially, the time it takes them to
 search through all the cached connections is nearly as long as the
 time it is taking to read/write to the database.  Although, I'm not
 implementing email as this ISP is, I think that scalability in my case
 may definitely run into similar roadblocks.
 
 I am interested in hearing from anyone that has tried to implement
 true connection pooling either within Apache or as an external
 process.  I'm particularly interested in hearing about implementations
 that could be made to work or are done using Perl and DBI/DBD.  I am
 mostly interested in things that are Open Source or licensed like Perl
 itself.

Having just returned from ApacheCon, I can honestly recommend looking at
mod_backhand to simply have a few servers that run the DBI pool, and have
database intensive requests go to those servers. It is a *very* cool
solution to just these sorts of scalability problems.

PS: I'll have an ApacheCon report "coming soon".

-- 
Matt/

/||** Director and CTO **
   //||**  AxKit.com Ltd   **  ** XML Application Serving **
  // ||** http://axkit.org **  ** XSLT, XPathScript, XSP  **
 // \\| // ** Personal Web Site: http://sergeant.org/ **
 \\//
 //\\
//  \\




check this out...

2000-10-26 Thread Dave Reinhardt

   
http://stream1.iims.intelonline.com/ViewWeb/PremiereRadio/File/102400bush1.asx
Dave



here is the best one

2000-10-26 Thread Dave Reinhardt

http://stream1.iims.intelonline.com/ViewWeb/PremiereRadio/File/102400bush2.asx