Problem with Apache::Session::DBI
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
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
-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
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
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
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
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
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
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
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
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]
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
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?
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
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
"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?
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
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
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?
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
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?
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?)
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
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?)
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?
- 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
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
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...
http://stream1.iims.intelonline.com/ViewWeb/PremiereRadio/File/102400bush1.asx Dave
here is the best one
http://stream1.iims.intelonline.com/ViewWeb/PremiereRadio/File/102400bush2.asx