Re: [Templates] Storing compiled templates to memcached?

2007-09-09 Thread Perrin Harkins
On 9/9/07, Peter Hartzler [EMAIL PROTECTED] wrote: Right, they have to be in memory *while in use*. Then they can be forgotten, e.g., not cached in TT's cache, and when needed again, pulled from the one central copy provided by memcached. Well, yes, but you'd have to recompile them again

Re: global vs multi-process

2007-09-06 Thread Perrin Harkins
On 9/6/07, David Willams [EMAIL PROTECTED] wrote: Obviously, I'm not involved with apache internals, but are you saying it's architecturally impossible for apache to somehow manage a hash that can, at the same time, be available (read-only) to child processes? There are things for apache that

Re: global vs multi-process

2007-09-05 Thread Perrin Harkins
On 9/6/07, David Willams [EMAIL PROTECTED] wrote: Child processes cannot update %CACHE, so what other apache methods or architectural strategies exist (creative, elaborate, etc) or have been used to update a similar hash? You'll find many discussions about sharing data in the list archives and

Re: global vs multi-process

2007-09-05 Thread Perrin Harkins
On 9/6/07, David Willams [EMAIL PROTECTED] wrote: When the translation happens on a random, ad hoc string of sometimes thousands of words, the process simply does something like this: Untranslated: hfj kei hty ... jan oej wio Translated: $CACHE{hfj} $CACHE{kei} $CACHE{hty} ...

Re: [Catalyst] Catalyst and Informix

2007-09-03 Thread Perrin Harkins
On 9/3/07, Robert Carew [EMAIL PROTECTED] wrote: Has anyone used Catalyst with an Informix database and if so which ORM are you using and what advice can you offer? Any pointers in either getting DBIC to work with Informix or RDBO with Catalyst would be gratefully received. If you search the

Re: creating an instance of Apache2::RequestRec

2007-08-30 Thread Perrin Harkins
On 8/30/07, bharanee rathna [EMAIL PROTECTED] wrote: has anyone tried to create an instance of Apache2::RequestRec outside apache ? How could that work? And even if it could work, what good what it be? This class is a Perl version of the C API to Apache's internals. It has no other purpose.

Re: creating an instance of Apache2::RequestRec

2007-08-30 Thread Perrin Harkins
On 8/30/07, bharanee rathna [EMAIL PROTECTED] wrote: It would work for the purpose of testing, mainly simulating a request without running apache like Apache::Test does currently. Apache::Test does it this way because it's a better way to test. It actually tests the full code path. There are

Re: Automatically maintaining cache consistency

2007-08-29 Thread Perrin Harkins
On 8/29/07, Mohammad J [EMAIL PROTECTED] wrote: At the worldcomp '07 conference, there was a method presented that is available online at http://cacheconsistency.com. In short, by defining dependency information in your source code whenever you set a cache element, you can analyze the source

Re: Migrate LWP::UserAgent + HTTP::Request to mod_perl2

2007-08-28 Thread Perrin Harkins
On 8/27/07, Nguyen Vu Hung [EMAIL PROTECTED] wrote: The following code run without problems under Apache 1.3.29, Perl 5.6.1, mod_perl 1.29. Under the new environment which is Apache 2.0.52, Perl 5.8.8, mod_perl 2.0.3 ( Cent OS 4.5 ), it won't run. There is no mod_perl-related code in what

Re: [Catalyst] CMS

2007-08-23 Thread Perrin Harkins
On 8/23/07, Cory Watson [EMAIL PROTECTED] wrote: I want something manages and version my templates and then a view that lets Cat retrieve the appropriate template through some means. You can do something like that with Krang or Bricolage. They both publish files rather than serving the

Re: [Catalyst] A Perl Message Queue?

2007-08-23 Thread Perrin Harkins
On 8/23/07, tprinty [EMAIL PROTECTED] wrote: Have you looked at memcache? Don't put your messages into memcached unless you don't mind losing some. It is not a database or reliable storage. It's just a cache. - Perrin ___ List:

Re: [Catalyst] A Perl Message Queue?

2007-08-23 Thread Perrin Harkins
On 8/23/07, Ash Berlin [EMAIL PROTECTED] wrote: Don't use a DB as the backing store for a message queue if you will ever need to pass a lot of messages thought it - you're just asking for trouble doing it that way. Like most things, it depends. If you need ACID properties for your messages,

Re: Internal Server Error

2007-08-23 Thread Perrin Harkins
On 8/21/07, Jeff Pang [EMAIL PROTECTED] wrote: PerlHandler Package::Name instead of: PerlHandler Package::Name-handler So on the first case,we need to write the handler as sub handler { my $r = shift; ...} because Apache may call the function directly as Package::Name::handler. on

Re: Internal Server Error

2007-08-23 Thread Perrin Harkins
On 8/21/07, Foo JH [EMAIL PROTECTED] wrote: Are there any technical advantages with either method, or is it a TIMTOWDI option given to the developers? You can structure your code differently with method handlers, in ways that appeal to some people. There's an example here:

Re: Internal Server Error

2007-08-23 Thread Perrin Harkins
On 8/23/07, Foo JH [EMAIL PROTECTED] wrote: I've read http://perldoc.perl.org/attributes.html about attributes, but it does not seem to suggest that tagging the method attribute to subroutine has any programming advantages, unless you're interested to list the subroutines with that attribute.

Re: Internal Server Error

2007-08-23 Thread Perrin Harkins
On 8/23/07, Jeff Pang [EMAIL PROTECTED] wrote: why it need prototype in mp1's method handler? Subroutine attributes did not exist before perl 5.6. - Perrin

Re: Configuring Mod_perl and Apache web Server

2007-08-21 Thread Perrin Harkins
On 8/21/07, usha rani [EMAIL PROTECTED] wrote: We would like to have information regarding configuration of MOD_PERL 2.0.3 with Apache Server -2.2.4 version in cygwin. I need some information regarding configuration of httpd.conf file, what are the changes we have to make

Re: compiled mp2 handler?

2007-08-21 Thread Perrin Harkins
On 8/21/07, Jen mlists [EMAIL PROTECTED] wrote: does this mean mp1 handler need to be parsed and compiled each time when requests came and called that handler? No, it means that the dispatch code like MyModule-handler is parsed and compiled each time. - Perrin

Re: Internal Server Error

2007-08-21 Thread Perrin Harkins
On 8/21/07, Jordan McLain [EMAIL PROTECTED] wrote: sub handler ($$) { my ($class, $r) = @_; For some reason $r is not defined. This only happens intermittently... Does anyone have any ideas? Sounds like sometimes it doesn't get properly called as a method, so $r ends up as the first

Re: Perl 5.8.8.

2007-08-20 Thread Perrin Harkins
On 8/20/07, JónJósef Bjarnason [EMAIL PROTECTED] wrote: Does anyone know how --with-perl option works ? or how to compile apache with perl 5.8.8 if this is not the correct way. The page you're looking at is not related to mod_perl. It is for configuring the command-line utilities that come

Re: Perl 5.8.8.

2007-08-20 Thread Perrin Harkins
On 8/20/07, JónJósef Bjarnason [EMAIL PROTECTED] wrote: But it's not mod_perl I am conserned with, that seems to sitt nicely at 5.8.8. its Apache, it looks into the old lib directories ../perl/5.8.7 instead of ../perl5/5.8.8 and I can't find where to change that in Apache. Can you be more

Re: Perl 5.8.8.

2007-08-20 Thread Perrin Harkins
On 8/20/07, JónJósef Bjarnason [EMAIL PROTECTED] wrote: Apache's @INC Apache doesn't have an @INC because Apache doesn't have perl. It looks like this is mod_perl's @INC. Did you print this out from a script or module running through mod_perl? To change which perl mod_perl is using, you just

Re: All about CGI.pm

2007-08-19 Thread Perrin Harkins
On 8/19/07, Tracy12 [EMAIL PROTECTED] wrote: Can you let me know for mod_perl compatibility what is the minimum CGI.pm version we should have? The most recent mod_perl-related change was in 3.20, but you really should just grab the latest one. The current list of changes is here:

Re: [Catalyst] Rate limiting password attacks

2007-08-17 Thread Perrin Harkins
On 8/17/07, Bill Moseley [EMAIL PROTECTED] wrote: I missed something along the way in this thread. Cookies? Is that to block a specific client? Yes, as opposed to an IP that could be a proxy. I'm just thinking of blocking specific logins when too many failed logins are attempted. That

Re: [RDBO] Still fighting with transactions

2007-08-17 Thread Perrin Harkins
On 8/17/07, John Siracusa [EMAIL PROTECTED] wrote: But really, I'd like to solve this somehow so the default way works as well. It would be nice if I could ask Apache::DBI not to call reset_startup_state(), perhaps by passing a special connect attribute: Do you think that Apache::DBI should

Re: Problem with IPC:RUN on Windows

2007-08-17 Thread Perrin Harkins
On 8/17/07, Manoj Bist [EMAIL PROTECTED] wrote: My understanding is that a perl module that manipulates stdout is not expected to work under mod_perl. IPC::Run manipulates stdout to make different processes connected by pipes work. IPC::Run used to work, at least on mod_perl 1. I've never

Re: All about CGI.pm

2007-08-17 Thread Perrin Harkins
On 8/16/07, Tracy12 [EMAIL PROTECTED] wrote: When we ran the same script on other Linux machine, the param value is not showing, it looks to me from the observation that CGI.pm has not been installed, but I was under the impression that mod_perl 2.0 CGI.pm is not bundled with mod_perl. It is

Re: speed limit

2007-08-17 Thread Perrin Harkins
On 8/16/07, Jen mlists [EMAIL PROTECTED] wrote: Is it possible to write speed limit module (for file downloading) by modperl rather than using Apache's official module? Yes, you have the full Apache API available to you from mod_perl. If you look on CPAN, you may find something like this

Re: [Catalyst] Rate limiting password attacks

2007-08-16 Thread Perrin Harkins
On 8/16/07, Bill Moseley [EMAIL PROTECTED] wrote: I'm looking for ideas on how to implement a way to detect and block dictionary attacks. This is not a question of how to implement strong passwords, but rather the act of limiting logins when too many failed passwords have been attempted in

Re: [RDBO] Still fighting with transactions

2007-08-15 Thread Perrin Harkins
On 8/15/07, Michael Lackhoff [EMAIL PROTECTED] wrote: Well, I didn't switch AutoCommit on or off and I didn't do a rollback myself, so the question remains why the default configuration with Apache::DBI and init_db(MyApp::DB-new) does a rollback when the database is accessed from a new db (in

Re: [RDBO] Still fighting with transactions

2007-08-15 Thread Perrin Harkins
On 8/15/07, Graham Barr [EMAIL PROTECTED] wrote: So either init_dbh needs to be able to detect that the $dbh it gets is a reuse of an existing connection, or Rose::DB-new needs to return the same object for all calls for the same connection. Even if init_dbh is changed, I think Apache::DBI

Re: Class inheritance, and SUPER under mod_perl2

2007-08-15 Thread Perrin Harkins
On 8/15/07, Nguyen Vu Hung [EMAIL PROTECTED] wrote: In the code below, the class XXX:YYY3 inherits Net::Cmd, IO::Socket::Inet, create an object $obj with the SUPER keyword. As far as I know, this code works well under Apache 1.3, Perl 5.6, mod_perl 1.3. But in current environment which

Re: [RDBO] Still fighting with transactions

2007-08-14 Thread Perrin Harkins
On 8/14/07, Michael Lackhoff [EMAIL PROTECTED] wrote: my $db = MyApp::DB-new; $self-my_db($db); # a new db for a new transaction $db-begin_work; # Start transaction ... create two objects and save them ... die Does it roll back?; $db-commit; I don't see any rollback there. It's a common

Re: [RDBO] Still fighting with transactions

2007-08-14 Thread Perrin Harkins
On 8/14/07, Michael Lackhoff [EMAIL PROTECTED] wrote: Well, my understandig was that if perl dies within a transaction it (or DBI) would do a rollback, from your answer I guess this is not the case. No. Your database will do it if you cut the connection and there is uncommitted work, but perl

Re: [RDBO] Still fighting with transactions

2007-08-14 Thread Perrin Harkins
On 8/14/07, Michael Lackhoff [EMAIL PROTECTED] wrote: Only question: Is it really possible to call rollback as a class method or do I have to call it on the specific object that started the transaction? You have to call it on the database handle that started the transaction. If all of your

Re: [RDBO] Still fighting with transactions

2007-08-14 Thread Perrin Harkins
On 8/14/07, John Siracusa [EMAIL PROTECTED] wrote: The simplest way to do this is to leave everything as per the defaults, and just use Apache::DBI. Note that Apache::DBI also does the automatic rollback for you, but only if you have AutoCommit off when you connect. If you connect with

Re: [RDBO] Still fighting with transactions

2007-08-14 Thread Perrin Harkins
On 8/14/07, John Siracusa [EMAIL PROTECTED] wrote: I looked for that and didn't see it, and still don't see it. Sorry, this was actually changed already. I was looking at an older release. - Perrin - This SF.net email is

Re: Scripts works under CGI but not under mod_perl

2007-08-14 Thread Perrin Harkins
On 8/13/07, Manoj Bist [EMAIL PROTECTED] wrote: Is there some recommended way to detect if STDOUT is being manipulated? The source code is usually the easiest way. The library is using TCP sockets to communicate with the server. That usually is not a problem under mod_perl. Is there some

Re: Scripts works under CGI but not under mod_perl (and thread stack size)

2007-08-14 Thread Perrin Harkins
On 8/14/07, Manoj Bist [EMAIL PROTECTED] wrote: Is it possible to change the stack size in mod_perl(Similar to ulimit -s unlimited etc.)? The stack size? What are you trying to do? I'm not aware of anything special about stack size in mod_perl that would be different from any other compiled C

Re: Scripts works under CGI but not under mod_perl (and thread stack size)

2007-08-14 Thread Perrin Harkins
On 8/14/07, William A. Rowe, Jr. [EMAIL PROTECTED] wrote: Few issues here running threaded, but that depends on a host of other decisions (ancient library bindings, different host contexts, etc). It definitely could be the cause of issues with a C library using sockets that isn't written to be

Re: Scripts works under CGI but not under mod_perl (and thread stack size)

2007-08-14 Thread Perrin Harkins
On 8/14/07, William A. Rowe, Jr. [EMAIL PROTECTED] wrote: I'm familiar with copy-on-write. Could you elaborate? From httpd's perspective, those same gains are true of worker as well. Perl's threads don't share much. Most of the memory is used for data structures, and these are fully

Re: Scripts works under CGI but not under mod_perl

2007-08-13 Thread Perrin Harkins
On 8/13/07, Manoj Bist [EMAIL PROTECTED] wrote: I created a perl binding for a third party C library using swig. This works fine under CGI but consistently fails under mod_perl. Is there a known set of calls(mulithreading etc.) that is not expected to work under mod_perl? Modules with C code

Re: Scripts works under CGI but not under mod_perl

2007-08-13 Thread Perrin Harkins
On 8/13/07, Manoj Bist [EMAIL PROTECTED] wrote: Thanks for the response. The C library is a third party library which does the following: - Connect to a server running on port 7000 on the local machine. - Make an initialize call ==This call is consistently

Re: [Catalyst] Serving server-dependent static content

2007-08-12 Thread Perrin Harkins
On 8/12/07, Peter Lytle [EMAIL PROTECTED] wrote: If someone has a solution from the Apache side, that's fine but I suspect that it might be easier to do this with Catalyst::Plugin::Static::Simple Don't serve static content through perl. Let your webserver do it. Usually people just set up

Re: [Catalyst] Serving server-dependent static content

2007-08-12 Thread Perrin Harkins
On 8/12/07, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: a lot of times, 'static' content is found via database queries. and sometimes that content needs to be protected from unauthorized viewers, and your authorization mechanisms are already built into your application, so you can't just use

Re: compile

2007-08-11 Thread Perrin Harkins
On 8/11/07, usha rani [EMAIL PROTECTED] wrote: how can we compile modperl programs in cygwin. You g-billboards.com people need to stop asking the same question over and over. If you're looking for Win32 binaries, they are on http://perl.apache.org/. If that's not what you're looking for,

Re: Using perl source code filter in mod_perl2

2007-08-11 Thread Perrin Harkins
On 8/10/07, Steve Hay [EMAIL PROTECTED] wrote: Is it possible to use perl source code filters (like Filter::Util::Call) in scripts that are run via ModPerl::Registry? I don't think that can work because of the way Registry modifies your code. Try using handlers instead of Registry scripts, or

Re: SV: [mp2+Win32] Frustration over Apache 2.0/ 2.2 restart failure

2007-08-10 Thread Perrin Harkins
On 8/10/07, Foo JH [EMAIL PROTECTED] wrote: The sad truth is that my clients are more comfortable with Windows OS Is it possible that if they have a small enough site to run comfortably on Windows, they can run it through CGI? I suspect that whatever issue you're having with mod_perl could be

Re: configure

2007-08-09 Thread Perrin Harkins
On 8/9/07, prasanthi devisetti [EMAIL PROTECTED] wrote: How to install mod_perl in cygwin , without configure file , Are you looking for Windows binaries? Those are here: http://perl.apache.org/docs/2.0/os/win32/install.html#All_in_one_packages please send me reply as soon as

Re: [Mason] Large data structure in Mason

2007-08-08 Thread Perrin Harkins
On 8/7/07, Mark Torrance [EMAIL PROTECTED] wrote: Here's another alternative you might consider: If you are looking for a way to have the lookup be fast (faster than you could get from a database) but you don't want to let each Apache process grow as large as this data structure, you could

Re: why error_log was written many times for same item?

2007-08-07 Thread Perrin Harkins
On 8/7/07, Jen mlists [EMAIL PROTECTED] wrote: In my mp1 script I wrote some info to apache's error_log: } elsif ($ip_int != $ip_int2) { $r-log_error([$ip FORBIDDEN] Request IP was not matched); return FORBIDDEN; But I saw it wrote many times for same error It must

Re: How to delete lots of related keys at once

2007-08-02 Thread Perrin Harkins
On 8/2/07, Don MacAskill [EMAIL PROTECTED] wrote: The way it invalides the cache is if TABLE has changed in any way, get rid of any cache entries referencing this TABLE: [...] You can, of course, do much better than this yourself if you goal is to cache certain SQL queries. It's pretty hard

Re: [Catalyst] do I need to load Apache::DBI?

2007-08-01 Thread Perrin Harkins
On 7/31/07, Matt S Trout [EMAIL PROTECTED] wrote: Except in the DBIx::Class, Class::DBI and plain DBI apps I've brought back to production quality stability by removing it. DBIx::Class and Class::DBI both handle connection caching on their own, so that is not where one would need Apache::DBI.

Re: counting on a complex query

2007-08-01 Thread Perrin Harkins
On 8/1/07, Jerry Schwartz [EMAIL PROTECTED] wrote: Will SELECT SQL_CALC_FOUND_ROWS and SELECT FOUND_ROWS() do what you want? Be careful. While it will give the correct number of rows that would have been found if LIMIT had not been used, it makes the server compute the whole result set,

Re: counting on a complex query

2007-08-01 Thread Perrin Harkins
On 8/1/07, Les Fletcher [EMAIL PROTECTED] wrote: SQL_CALC_FOUND_ROWS isn't an option for us. Right now I am doing two queries, but I am just trying to see if there is a better way to do the count query than to just turn it into a dervied table and count the results i.e. SELECT COUNT(*) FROM

Re: how to use Apache::DBI

2007-07-31 Thread Perrin Harkins
On 7/31/07, Clinton Gormley [EMAIL PROTECTED] wrote: What you could do instead is to use DBI's connect_cached method, which provides similar functionality. I actually use this instead of Apache::DBI, even when running under mod_perl. I also use connect_cached in many cases. Just be aware of

Re: [Catalyst] flash with DBIC session storage

2007-07-30 Thread Perrin Harkins
On 7/27/07, Tobias Kremer [EMAIL PROTECTED] wrote: While hammering my site with ab (Apache bench) I'm getting loads of the the following error message: Couldn't render template undef error - DBIx::Class::ResultSet::find_or_create(): DBI Exception: DBD::mysql::st execute failed: Duplicate

Re: [Catalyst] do I need to load Apache::DBI?

2007-07-30 Thread Perrin Harkins
On 7/24/07, Matt S Trout [EMAIL PROTECTED] wrote: Apache::DBI is an awful hack and should be avoided where possible. Kind of an exaggeration. Apache::DBI is a useful module for porting existing CGI scripts to mod_perl. If you aren't porting CGI scripts to mod_perl, you can use other tools like

Re: [BULK] - Re: [Catalyst] flash with DBIC session storage

2007-07-30 Thread Perrin Harkins
On 7/27/07, Jonathan T. Rockway [EMAIL PROTECTED] wrote: On Fri, Jul 27, 2007 at 11:57:01AM -0700, Mesdaq, Ali wrote: Are you sure that InnoDB would solve this issue? Even if just a row was locked and you have 2 inserts at the exact same time how would that resolve the issue? One

Re: [Catalyst] do I need to load Apache::DBI?

2007-07-30 Thread Perrin Harkins
On 7/30/07, Matt S Trout [EMAIL PROTECTED] wrote: I used to consider it a neat hack. After some time with the internals, some fun explicitly disabling it within DBIC since it sometimes broke our reconnect code, and even then discovering I could often solve client mod_perl problems by removing

Re: how to use Apache::DBI

2007-07-30 Thread Perrin Harkins
On 7/30/07, Ken Perl [EMAIL PROTECTED] wrote: my question is I can not find any persistent connections for my CGI script. If you are running your scripts through ModPerl::Registry, all you need to do is call DBI-connect normally and you will get persistent connections. - Perrin

Re: how to use Apache::DBI

2007-07-30 Thread Perrin Harkins
On 7/30/07, Ken Perl [EMAIL PROTECTED] wrote: I didn't run it under ModPerl::Registry Did you run it under some other mod_perl module, like ModPerl::PerlRun? If it's a CGI script, and you aren't running it through something like this, then you aren't running it through mod_perl and you won't be

Re: how to use Apache::DBI

2007-07-30 Thread Perrin Harkins
On 7/30/07, Dodger [EMAIL PROTECTED] wrote: You're being semantically picky with this guy, and innacurately so. An apache registry script *is* a CGI script. So is an ASP page, a PHP script, and any other interpreted way fo dealing with CGI input. We tend to be generous with the use of the word

Re: mod_perl2 and SDBM-tied hashes

2007-07-29 Thread Perrin Harkins
On 7/29/07, Brian Reichert [EMAIL PROTECTED] wrote: The symptom I see that after a 'set', subsequent 'gets' show me various results; sometimes the data comes back set, sometimes not. The dbm implementation you're using will not always write everything to disk until you untie it. To make this

Re: performance of extended insert vs. load data

2007-07-23 Thread Perrin Harkins
On 7/23/07, Sid Lane [EMAIL PROTECTED] wrote: is either one significantly faster than the other? Yes, LOAD DATA INFILE is much faster. are there additional (faster) approaches I have not thought of? Not that I've found. I think you'd have to write directly to the C API to beat LOAD DATA

Re: performance of extended insert vs. load data

2007-07-23 Thread Perrin Harkins
On 7/23/07, mos [EMAIL PROTECTED] wrote: Load data will of course be much faster. However to obtain the maximum speed you need to load the data to an empty table, because then MySQL will load the data without updating the index for every row that's added, and will instead rebuild the index only

Re: Can't call method prepare on an undefined value

2007-07-22 Thread Perrin Harkins
On 7/22/07, Dustin D. [EMAIL PROTECTED] wrote: I thought I had mod_perl up and running in my development environment, so I pushed the new changes + apache configuration out to my production environment, and immediately began tail -f on the logs. What I noticed was, most of the time, everything

Re: Unique Rowid

2007-07-19 Thread Perrin Harkins
On 7/19/07, John Comerford [EMAIL PROTECTED] wrote: I am in the process of putting together a web application. I have decided to add a 'RowId' field to all my tables and assign it a unique number so that I use it to retrieve data. In concept this number might be passed back to the server as

Re: [Templates] Enabling caching of templates under mod_perl?

2007-07-19 Thread Perrin Harkins
On 7/19/07, Andrew Light [EMAIL PROTECTED] wrote: The one thing I have to figure out now, is how to manage the global varialbe thing. To be honest, I have never heard about the Apache::Registry hack, I just pop in all of my regular CGI files in a mod_perl environment and don´t really have any

Re: auto_index extension to filter on update time

2007-07-19 Thread Perrin Harkins
On 7/16/07, Thomas Hilbig [EMAIL PROTECTED] wrote: Does anyone have any MP code to extend the functionality of the mod_autoindex to include a new filter that is based on files that are before or after a last-modified date? Maybe one of these would help you:

Re: berkeleyDB tie once and forever with mod_perl

2007-07-19 Thread Perrin Harkins
On 7/19/07, Nils Kaiser [EMAIL PROTECTED] wrote: I was able to change our code to have the handlers called by the Apache server (PerlResponseHandler, PerlChildInitHandler, PerlChildExitHandler). What I don't understand, is in which scope/object I store the reference to the BerkeleyDB in the init

Re: Confused Apache::DBI (best practice)

2007-07-17 Thread Perrin Harkins
On 7/17/07, Clinton Gormley [EMAIL PROTECTED] wrote: But yes, 150 connections may be a lot depending on your database. However, if you need 150 mod_perl children, then it is a busy site, and you need a database server big enough to support it. Anthony, Clinton is right. I suspect you haven't

Re: [Catalyst] TT2 + CP::Authentication + DBIC gotcha

2007-07-13 Thread Perrin Harkins
On 7/13/07, apv [EMAIL PROTECTED] wrote: [% vote = Catalyst.user.votes({word = w.id}) IF Catalyst.user_exists %] Just FYI, you should never do this type of construct in perl. It will break in bizarre ways. I doubt that's the issue with TT, but don't get in the habit. my $vote = $foo if

Re: [Catalyst] TT2 + CP::Authentication + DBIC gotcha

2007-07-13 Thread Perrin Harkins
On 7/13/07, J. Shirley [EMAIL PROTECTED] wrote: As anecdotal evidence to its insidious behavior, I've personally been involved in a 5 man debugging effort that took 13 days (not full days, but probably an average of 3-4 hours a day * 5 people * 13 days) to finally find the bug. Which was simply

Re: berkeleyDB tie once and forever with mod_perl

2007-07-13 Thread Perrin Harkins
On 7/13/07, Jonathan Vanasco [EMAIL PROTECTED] wrote: I'm thinking of the situation where you have 1 parent, 4 children. all 4 children hit max-requests and exit before the first replacement spawns. without a standing connection in the parent (or another process using bdb in any way ) wouldn't

Re: SELECT missing records

2007-07-12 Thread Perrin Harkins
On 7/12/07, Jerry Schwartz [EMAIL PROTECTED] wrote: I believe this query will do it, but can it be redone without the sub-query by using JOINs? Yes, use a LEFT JOIN. Would that be more efficient? Yes. SELECT prod.prod_num, price.prod_price FROM prod JOIN price WHERE prod.prod_id =

Re: SELECT missing records

2007-07-12 Thread Perrin Harkins
On 7/12/07, Jerry Schwartz [EMAIL PROTECTED] wrote: Since the rows is identical except for the last bit, where mine is 4 and yours is 2, does that mean yours is roughly more efficient by a 2:1 ratio? For the most part, MySQL will do better with LEFT JOIN than an IN subquery. You can read all

Re: SELECT missing records

2007-07-12 Thread Perrin Harkins
On 7/12/07, Jerry Schwartz [EMAIL PROTECTED] wrote: I think that will give me one record for every price that is not Yen, so if a product has a price in USD and a price in GBP it will show up twice. That would happen if you removed the 'USD' condition from the first JOIN. Like I said, I'm not

Re: SELECT missing records

2007-07-12 Thread Perrin Harkins
On 7/12/07, mos [EMAIL PROTECTED] wrote: BTW, joins will work faster if you load one or more tables in a Memory table before you do the join. Well, if your tables are so small that you can load them entirely into memory, it probably doesn't matter how you code the query. - Perrin -- MySQL

Re: berkeleyDB tie once and forever with mod_perl

2007-07-12 Thread Perrin Harkins
On 7/12/07, Nils Kaiser [EMAIL PROTECTED] wrote: To achieve full performance, I read that it better to tie the berkeleyDB once and reuse the handle for each request, i.e. having the tie command outside of the mod_perl handler. Yes. If you really are concerned with performance, don't use the

Re: berkeleyDB tie once and forever with mod_perl

2007-07-12 Thread Perrin Harkins
On 7/12/07, Jonathan Vanasco [EMAIL PROTECTED] wrote: a) the tie be global pre-fork b) the tie be post-fork c) there be no tie whatsoever , and somehow a connection is made using the API at the beginning , and everything just uses the library/ api methods ~b + ~c Open

Re: how do I clear stale POST data?

2007-07-11 Thread Perrin Harkins
On 7/11/07, Scott Kaplan [EMAIL PROTECTED] wrote: Problem: When the user hits refresh or forward, their magically logged in again. Solution: http://en.wikipedia.org/wiki/Post/Redirect/Get - Perrin

Re: DBI and threaded MPM

2007-07-11 Thread Perrin Harkins
On 7/11/07, Anthony Gardner [EMAIL PROTECTED] wrote: A. We recently went live with a DB application and the system ground to a halt. It could be due to many things, but the thing I'm looking at is the fact that we had many network connections. I then found the info about Databases

Re: mod_perl lazy loading modules with eval in custom lib

2007-07-11 Thread Perrin Harkins
On 7/11/07, Christiaan Kras [EMAIL PROTECTED] wrote: I add to @INC with use lib qw(/my/path) . All the other modules I load continue to work fine. Just those that use lazy loading fail infrequently. Okay, I think I see the problem. When you change @INC during a request, the change only lasts

Re: mod_perl lazy loading modules with eval in custom lib

2007-07-11 Thread Perrin Harkins
On 7/11/07, Christiaan Kras [EMAIL PROTECTED] wrote: Thanks. I will try that. So basicly, the modules that are loaded at the first request will stay in memory, but @INC will get reset? Yes. It's a simulation of CGI behavior. The only reason your CGI scripts don't have this problem is that

Re: mod_perl lazy loading modules with eval in custom lib

2007-07-11 Thread Perrin Harkins
On 7/11/07, Christiaan Kras [EMAIL PROTECTED] wrote: By the way, I've used push() to add my path to @INC before. But that didn't work out. It should work fine. The reason people typically use unshift for this is that it lets modules in your local path override ones in the system path. -

Re: [Catalyst] using a persistent hash in a model

2007-07-10 Thread Perrin Harkins
On 7/10/07, Jonathan Rockway [EMAIL PROTECTED] wrote: BerkeleyDB has an RPC layer for talking to remote clients. Interesting. I had never heard of this before. It looks kind of rudimentary. The docs say it's only single-process at this point, so it serializes all data access. I find the

Re: [Catalyst] Apache strange output with mod_perl

2007-07-10 Thread Perrin Harkins
On 7/10/07, Cookie [EMAIL PROTECTED] wrote: When I start my apache server with mod_perl,I found some strange output.I don't know how to solve this problem? Usually this means you upgraded perl and didn't recompile mod_perl, or your modules. - Perrin

Re: [mp2] Apache2::Reload doesn't reload

2007-07-10 Thread Perrin Harkins
On 6/27/07, Colin Wetherbee [EMAIL PROTECTED] wrote: I have a handler in a module called JetSet::Handler. That module depends on a number of other modules, which I've tried to include with 'use', with limited success. It seems, sometimes, symbols act just fine and reload when they should, but

Re: DBI and threaded MPM

2007-07-09 Thread Perrin Harkins
On 7/9/07, Anthony Gardner [EMAIL PROTECTED] wrote: I'm looking into a problem we're experiencing (lots of netword connections) and I think the answer lies with Apache::DBI and the version of mod_perl we're using. Can you explain a little more about what the problem is and why you think it

Re: [Catalyst] using a persistent hash in a model

2007-07-07 Thread Perrin Harkins
On 7/7/07, Daniel McBrearty [EMAIL PROTECTED] wrote: Is there any easy way to keep some ad-hoc persistent data out of the database? Sure. Most of them are either lossy or tricky to use, and tend to be poor for concurrent reading/writing. The obvious options are: - BerkeleyDB. Fast, but

Re: Where to store uploads

2007-07-06 Thread Perrin Harkins
On 7/6/07, Frank Wiles [EMAIL PROTECTED] wrote: Another option for this is to use MogileFS (http://www.danga.com/mogilefs/) to store your files. You can control the redundancy at the app level and it just figures out where the file is when you request it. Keep in mind, you have to

Re: script runs from command line and as CGI, not under ePerl/mod_perl

2007-07-06 Thread Perrin Harkins
On 7/5/07, Todd Finney [EMAIL PROTECTED] wrote: With due respect, Perrin, I disagree with the (common, unfortunately) belief that a lack of an active release cycle indicates that a package is somehow unsuitable. Sometimes, that just means that it's done. Sure, but the real problem is that no

Re: passing CGI paramters

2007-07-06 Thread Perrin Harkins
On 7/5/07, CraigT [EMAIL PROTECTED] wrote: Is what I'm hearing you say is that in the PerlRun environment (and I'm guessing the mod_perl environment too), anything that a subroutine uses coming from outside that code must be passed as a parameter like 'sub($paramter)'. Am I correct in this.

Re: passing CGI paramters

2007-07-06 Thread Perrin Harkins
On 7/6/07, CraigT [EMAIL PROTECTED] wrote: Am I passing the paramters in the anchor examples I presented earlier as I should using PerlRun or mod_perl? I don't think you ever showed us the code. You just showed the code where you print the HTML. If you can show us a complete sub and how you

Re: mod_perl lazy loading modules with eval in custom lib

2007-07-06 Thread Perrin Harkins
On 7/6/07, Christiaan Kras [EMAIL PROTECTED] wrote: I'm 100% sure it happens in the modules that use lazy loading (eval(require module.pm)). Somehow @INC gets reset. Are you sure @INC is getting reset? Sometimes people have this problem because the user that apache runs as (usually nobody)

Re: passing CGI paramters

2007-07-06 Thread Perrin Harkins
On 7/6/07, CraigT [EMAIL PROTECTED] wrote: In this regard though, I would like to ask what you recommend to pass back several paramters from a sub The usual way to do it is to accept a list of return values: my ($foo, $bar) = sub_call($param); I'd like to focus on this problem here because

Re: [Catalyst] Re: How to access current MyApp instance ?

2007-07-05 Thread Perrin Harkins
On 7/4/07, Jonathan Rockway [EMAIL PROTECTED] wrote: I agree that this is a terrible way to do things. Perl has the right idea with $sigils, so at least functions look different from other @things. Oh, and you know... a lexical scope. If you feel the need for complicated scoping rules in

Re: [Catalyst] Re: How to access current MyApp instance ?

2007-07-05 Thread Perrin Harkins
On 7/5/07, A. Pagaltzis [EMAIL PROTECTED] wrote: That's what I was advising, basically, except that I would tell people to use INCLUDE instead of PROCESS. Else you'll be violating your own rule not to add variables to the stash from inside a template, as soon as any of your blocks are

Re: header issues etc...

2007-07-04 Thread Perrin Harkins
On 7/4/07, pubert na [EMAIL PROTECTED] wrote: Won't multiple simultaneous requests change the our variables unpredictably since they all have access to the symbol table? No. Every child process is completely separate and they don't share anything. Each process only handles one request at a

<    5   6   7   8   9   10   11   12   13   14   >