mod_perl, mysql, and set names

Hi I have a cgi script running with mod_perl and mysql that uses utf8 input. As you might know, it is important to issue the command set names "utf8" after initialising the mysql connection, or utf8 data can get garbled. I do this successfully when running standrad cgi like this: { my $dbh

Re: mod_perl, mysql, and set names

Thanks to those who responded to me privately. It seems the problem is caused by the connection timing out, after which it automatically reconnects - but set names is not then done. (I am not using Apache::DBI.) Possible solutions: - modify code to issue set names at the start of every request (

Re: mod_perl, mysql, and set names

Thanks again for the varied responses. My main concern right now is to get this thing running reliably with minimum hassle. I've not had any connection related problems aprt from this "set names" related stuff. For now I'll take the minor hit of an extra query per request and issue "set names" eve

making versioned libraries work on the same server

) I don't know what the working dir of one of teh mod_perl processes would be? The dir of teh first script that is executed? The dir where the server was started? Anyways, I doubt that this is teh correct way. All help much appreciated. And big thanks for the great free software ... mod_perl is brilliant! Daniel -- Daniel McBrearty danielmcbrearty at gmail.com

Re: making versioned libraries work on the same server

ls to browser' controlled individually. Also I'm kind of happy if there is a bit more isolation between the screwups I might make doing dev work, and the server that others can be working on. Thanks again for the help. Load of work to get this stuff working right, but it's nice to get a good fix. Daniel -- Daniel McBrearty danielmcbrearty at gmail.com

[slightly OT] Catalyst? Maypole?

Hi I've been looking around at MVC frameworks a bit recently. RoR looks good if you don't mind the language switch, but I'm also looking at these two. Anyone have much experience of them, in tandem with mod_perl? Feedback and thoughts? thanks Daniel -- Daniel McBrearty dan

identifying mod_perl process at runtime

If I have a library which is used for both mod_perl and standard cgi processes, and I want to know at runtime which, how can I do that? thanks Daniel-- Daniel McBreartyemail : danielmcbrearty at gmail.comwww.engoi.com : the multi - language vocab trainerBTW : 0873928131

Re: identifying mod_perl process at runtime

Thanks all. The ENV var is indeed the best way. On 2/7/06, Frank Wiles <[EMAIL PROTECTED]> wrote: On Tue, 7 Feb 2006 06:58:24 +0100Daniel McBrearty <[EMAIL PROTECTED]> wrote:> If I have a library which is used for both mod_perl and standard cgi > processes, and I want to know at runtime which, how

caching data in a module

Hi all I have some multilingual pages running on mysql/modperl. I'm thinking that certain text will be retrieved again and again from the db, hence I'm thinking about caching it in a hash. There is alreaday a specific method I get that retrieves these values so just a rewrite of that method would

Re: caching data in a module

if it is in the hash at startup, all the children will access thathash and share it.if it written to after startup.pl, use memcachedOn Feb 7, 2006, at 1:31 PM, Daniel McBrearty wrote:> that any memory that gets written to will be seen as dirty, and > therefore not shared. But if it is only writt

odd bug - script not executed only when passed certain argument

Hi I have a very odd bug here that is making me scratch my head. Essentially, I have a script which gets executed normally - except when one particular argument is passed to it. Then it doesn't execute - it gets spat out as a text document. My server config is maybe a bit unusual. I have this in

Re: caching data in a module

ht have changed between versions, I'd be grateful. Thanks DOn 2/7/06, Daniel McBrearty <[EMAIL PROTECTED]> wrote: Thanks Jonathan Just to be clear - the hash and the method to init it are declared and defined in MyModule like this: {  my $hash = 0; sub init {   # fill in the hash

Re: caching data in a module

ceachern), if anyone ever wants to find it ... I knew there was a reason I bought it ;-) cheers D which really makes it into a package global. In addition it really seems to get shared then. Nothing to do with subtly different perl versions at all.On 2/8/06, Daniel McBrearty <[EMAIL PROTECTED]>

Re: caching data in a module

Thanks. Well, here is the code (slightly edited) package Sitetext; {     my $sitetext_cache = {};     sub init     {     print "Sitetext::init\n";     my $all = getAll();     foreach $st (@$all)     {     # ... fill in the cache. This is definitely OK.     } #pri

Re: caching data in a module

I don't know if this is connected, but I noticed init was getting called TWICE on a restart. I turned of PerlFreshRestart and now it just happens once. Can't quite see the connection, but maybe it is related ...On 2/8/06, Daniel McBrearty <[EMAIL PROTECTED] > wrote:Thanks. Well,

Re: caching data in a module

06-02-08 at 21:03 +0100, Daniel McBrearty wrote:> I don't know if this is connected, but I noticed init was getting> called TWICE on a restart. I turned of PerlFreshRestart and now it> just happens once. >> Can't quite see the connection, but maybe it is related ...That pr

Re: Best way to determine memory leaks?

age"SYNC="rsync://rsync.gentoo.org/gentoo-portage"USE="amd64 acl alsa apache2 avi berkdb bitmap-fonts bzip2 crypt edsemboss encode expat foomaticdb fortran gif gpm gstreamer gtk2 imagemagick imlib ipv6 jpeg libwww lzw lzw-tiff mhash mp3 mpeg mysqlncurses nls no-suexec odbc opengl pam pcre pdflib perl php png pythonquicktime readline samba sdl spell ssl tcpd tiff truetype truetype-fonts type1-fonts udev urandom usb userlocales xpm xv zlib userland_GNUkernel_linux elibc_glibc"Unset:  ASFLAGS, CTARGET, LC_ALL, LDFLAGS, LINGUAS-- Daniel McBrearty email : danielmcbrearty at gmail.comwww.engoi.com : the multi - language vocab trainerBTW : 0873928131

Re: A question for the newbies

emplates at the same time. So I'd like to know.thanks. Good thread.-- Daniel McBrearty email : danielmcbrearty at gmail.comwww.engoi.com : the multi - language vocab trainerBTW : 0873928131

Re: A question for the newbies

to do some simple comparison tests of this at some point. But if you or anyone else has "been there done that" I'd like to hear about it.On 2/16/06, Perrin Harkins <[EMAIL PROTECTED]> wrote: On Thu, 2006-02-16 at 22:28 +0100, Daniel McBrearty wrote:> Hmmm. Thanks Perrin. Shame

Re: A question for the newbies

On 2/16/06, Jonathan Vanasco <[EMAIL PROTECTED]> wrote: On Feb 16, 2006, at 4:20 PM, Perrin Harkins wrote:> On Thu, 2006-02-16 at 22:14 +0100, Daniel McBrearty wrote:>> One question about the various template systems and mod_perl : is>> there not a performance hit in using th

Re: A question for the newbies

Frank, what's the light/heavy approach?On 2/17/06, Frank Wiles <[EMAIL PROTECTED]> wrote: On Fri, 17 Feb 2006 06:31:21 -0500 (EST)Jeff Pang <[EMAIL PROTECTED]> wrote:> I do agree mod_perl is a strong web-develop language.But I still> think it consume too much memory. Under my test,it's not so stabl

(slightly OT) postgresql? firebird? mysql?

Hi guys, I'm currently using mysql, but I'm considering changing over to firebird or postgre. Anyone have any reasoned loves/hates/useful experiences to pass on? Thanks Daniel -- Daniel McBreartyemail : danielmcbrearty at gmail.comwww.engoi.com : the multi - language vocab trainerBTW : 08739281

Re: [OT] modperl vs. Ruby

I think catalyst was modeled closely on ROR. ROR is quite nice if a substantial part of what you wnat is CRUD based on db schema. Also the AJAX tools look good. But i18n  support is not looking too solid, though it may improve. This seems to be a problem with most frameworks though, and because

Re: [OT] modperl vs. Ruby

"Let's not accuse the Perl community of playing catchup ..."I don't see things that way anyway. People always take good ideas from other places and reuse them, and it's always been so. On 25 Feb 2006 06:28:19 -0800, Randal L. Schwartz <merlyn@stonehenge.com>

Re: [OT] modperl vs. Ruby

Hi Enno Funnily enough I'm doing the exact same thing ... I thought I already had a lot of perl modules, but this beats everything. I know it's a bit of an apples and oranges thing, but can anyone give an idea of the size of mod_perl processes that are actually using catalyst? I currently run

bug report : "make test" failure when compiling from source.

terest status: Apache2: - Apache2::Request : - CGI: 3.15 ExtUtils::MakeMaker: 6.30 LWP: 5.805 mod_perl : - mod_perl2 : - 3. This is the core dump trace: (if you get a core dump): [CORE TRACE COMES HERE] This report was generated by t/REPORT on Tue Sep 19 21:12:54 2006 GMT. -- Daniel McBrearty email : danielmcbrearty at gmail.com www.engoi.com : the multi - language vocab trainer BTW : 0873928131

using light/heavy apache

the first part of the uri will normally be the user language, ( www.engoi.com/en/ ...) I'd rather not do it like that. Just wondering what my options are in configuring this. Can anyone point me at useful links, or give some hints? thank you. Daniel -- Daniel McBrearty email : danielmcbrear

Re: using light/heavy apache

thanks very much guys - that's very useful info. -- Daniel McBrearty email : danielmcbrearty at gmail.com www.engoi.com : the multi - language vocab trainer BTW : 0873928131