On Thu, 8 Aug 2024 16:21:09 +0200
Guido Brugnara wrote:
>
> I evaluate the query but returning only Primary Keys [*] using
> OFFSET/LIMIT limiting to a multiple of rows to display but not too
> large, which I save in cache.
Thanks for the info.
How do you do the caching?
--
vv.lists
ows? do you use a
cursor?
--
Bien à vous, Vincent Veyron
https://compta.libremen.com
Logiciel libre de comptabilité générale en partie double
27;d mention it.
--
Bien à vous, Vincent Veyron
https://marica.fr/
Logiciel de suivi des contentieux juridiques, des sinistres d'assurance et des
contrats
d to Debian Bookworm.
--
Bien à vous, Vincent Veyron
https://marica.fr/
Logiciel de suivi des contentieux juridiques, des sinistres d'assurance et des
contrats
uv1; I noticed this
line in the messages, following unpacking :
Processing triggers for libc-bin (2.36-9+deb12u4) ...
Not sure if this is related? Does anyone have an idea of what causes this?
--
Bien à vous, Vincent Veyron
https://marica.fr
Logiciel de gesti
On Thu, 16 Nov 2023 01:43:16 +0100
"Vincent Veyron" wrote:
Hi All,
Following advice from Joe Schaefer, I compiled libapreq2 from subversion
sources.
Make install fails with : make: *** No rule to make target 'install'. Stop.
(Unix build)
So, I simply replaced the lib
know
when?
--
Bien à vous, Vincent Veyron
https://marica.fr/
Logiciel de suivi des contentieux juridiques, des sinistres d'assurance et des
contrats
://packages.debian.org/bookworm-backports/libapache2-mod-apreq2
--
Bien à vous, Vincent Veyron
https://marica.fr/
Logiciel de suivi des contentieux juridiques, des sinistres d'assurance et des
contrats
On Sun, 6 Aug 2023 13:00:15 +0100
Steve Hay wrote:
> Please download, test, and report back on this mod_perl 2.0.13 release
> candidate.
>
> https://dist.apache.org/repos/dist/dev/perl/mod_perl-2.0.13-rc1.tar.gz
>
Hi Steve,
+1 on Debian Bookworm.
Debian version 12.1
Server version: Apache/2.
On Sun, 6 Aug 2023 13:00:15 +0100
Steve Hay wrote:
> Please download, test, and report back on this mod_perl 2.0.13 release
> candidate.
Hi Steve,
This is the result on Debian 11.7 with Apache 2.4.56
Test Summary Report
---
t/filter/in_bbs_inject_header.t (Wstat: 0 Tests
$key and $digest are equal?
--
Bien à vous, Vincent Veyron
https://compta.libremen.com
Logiciel libre de comptabilité générale en partie double
On Fri, 22 Apr 2022 05:40:21 +0800
Wes Peng wrote:
> Bounced by your ISP? Just guessing
>
Good guess : I went to their web interface, and found the messages in the junk
folder
Thanks for the hint
--
Bien à vous, Vincent Veyron
https://mar
:2022-4
Henrik S's initial request never made it to my inbox, but I did receive Jacques
Deguest's and John Dunlap's responses.
Even then, Jacques made two replies to Henrik, and I only received the first
one.
Any idea what the cause might be?
Failed 1/245 test programs. 3/3505 subtests failed.
[warning] server localhost:8529 shutdown
[warning] port 8529 still in use...
done
So, only the documented bbs_inject_header.t fails
--
Bien à vous, Vincent Veyron
https://compta.libremen.com
Logiciel lib
] server localhost:8529 shutdown
[warning] port 8529 still in use...
done
So, only the documented bbs_inject_header.t fails
--
Bien à vous, Vincent Veyron
https://compta.libremen.com
Logiciel libre de comptabilité générale en partie double
--
Vincent Veyron
ages :
apache2 2.4.38-3+deb10u5 i386 Apache HTTP
Server
libapache2-mod-perl2 2.0.10-3 i386 Integration of
perl with the Apache2 web server
Machine is an IBM X201
Attached :
t/logs/error_log
--
Bien à vous,
8 [#/sec] (mean)
Time per request: 75.664 [ms] (mean)
Time per request: 15.133 [ms] (mean, across all concurrent requests)
Transfer rate: 544.33 [Kbytes/sec] received
--
Bien à vous, Vincent Veyron
https://compta.libremen.com
Logic
save me
> going down some dead ends :D
I use mod_perl handlers, so not sure how it mixes with PerlRegistry, but you
probably want to have a look at connect_cached
--
Bien à vous, Vincent Veyron
https://compta.libremen.com
Logiciel libre de c
On Mon, 21 Dec 2020 12:15:45 +
James Smith wrote:
Hi James,
>
> The first rule of session hashes is don't use session hashes,
I thought this was a standard way of storing user information? I've copied an
example at the bottom (this application calculates quotes for a sailmaker)
I'm not
sure how mod_perl could handle that kind of load and be horribly
inefficient?
(I forgot to say in my previous post that over 50% of the time used by my
script is spent on the _one_ query out of 120 that writes a smallish session
hash to disk)
--
Bien à vous
ies, the latest one makes
150 different queries in .05 seconds. I never see more than 0.15 load average
with 10 users on line.
Granted, I have low traffic and small databases, but still.
(incidentally, I had a look at your home page, which took a good 5 seconds to
load)
On Sun, 20 Dec 2020 14:03:35 -0600
Mithun Bhattacharya wrote:
>
> As for your Lets Encrypt certificate - autorenewal isnt a mod_perl thing
> rather you do have to place a script in some sort of scheduler.
I use Lets Encrypt on Debian, there is no need to place a script; certificates
are being a
On Mon, 1 Jun 2020 09:55:24 +0200
André Warnier (tomcat/perl) wrote:
>
> PerlPostConfigRequire "/etc/apache2/modperl2_startup.pl"
>
> Maybe you forgot this on one of the systems, and not the other ?
>
You know, I grepped the hell out of my modules for an hour before posting,
trying to find t
Hi List,
I have two servers using mod_perl, both having the same modules installed and
enabled; server1 got a fresh install of Debian Buster, while server2 was
upgraded to Buster from Stretch.
This code :
my $cookie = CGI::Cookie->new(-name => 'session',
0-2+deb9u and
libapache2-request-perl 2.13-7~deb9u1
--
Bien à vous, Vincent Veyron
https://marica.fr/
Logiciel de gestion des sinistres assurances, des dossiers contentieux et des
contrats pour le service juridique
handlers, not output filters, that read from files and use this :
open DOCUMENT_CONTENT, "<:encoding(UTF-8)", "$document_content" or die
"can't open $document_content : $!\n" ;
--
Bien à vous, Vincent Veyron
http
On Thu, 26 Sep 2019 21:52:29 +0300
Damyan Ivanov wrote:
>
> builds OK and tests pass on Debian/unstable amd64 and i386 with apache
> 2.4.41, apr 1.6.5, Perl 5.28.1, CGI 4.44
Would you mind explaining what steps you took to build on Debian? I'm on
Stretch (old stable), and can't build.
After
tFilterHandler instead of after it (something changed in the
processing order of the filter queue; the solution was found here :
https://github.com/h5bp/html5-boilerplate/issues/1012)
Other than that, everything went smoothly
--
Bien à vous,
my part. It appeared on all systems, after more thorough
testing. Installations are identical, but I suppose because the backup machine
does not receive any requests, it just took a bit longer for the problem to
appear.
--
Bien à vous, Vincent Veyron
find. Strange that it worked fine up to now, and
suddenly not at all.
Thank you for the helpful answer, as always, John.
Now, if you happen to know why this _had_ to surface during a demo [:-(
--
Bien à vous, Vincent Veyron
https://compta.li
ger (aucune
description n'est disponible)
ii libapache2-mod-perl2 2.0.10-2 amd64 Integration of
perl with the Apache2 web server
un libapache2-reload-perl (aucune
description n'est disponible)
ii libapache2-request-per
hen your next request is served by a new
process which compiles for some reason.
You might want to try to run in single process mode :
https://perl.apache.org/docs/general/control/control.html#Running_a_Server_in_Single_Process_Mode
--
st bet is probably a dedicated
server. I've been using low end dedicated servers from online.net and
kimsufi.com at 10.00 euros/month for years, no problem at all
I even see an offer at 4.99€/month now :
https://www.kimsufi.com/fr/serveurs.xml
--
Bi
4 cached Mem
Tests with ab show 50 requests/second, and I don't see a memory problem that
would warrant the overhead of a front-end reverse proxy.
--
Bien à vous, Vincent Veyron
https://marica.fr/
Gestion des sinistres assurances, des dossiers con
filters (mod_deflate ran before my custom outputfilter in 2.4).
Everything running smoothly since those were fixed across several different
virtual hosts.
--
Bien à vous, Vincent Veyron
https://marica.fr/
Logiciel de suivi des contentieux juridiques, des sinistres d'assurance et des
contrats
s/2.0/api/Apache2/Log.html#Cr_E_gt_log_rerror___
(note : there appears to be a typo in the example, missing parentheses after
LOG_MARK)
--
Bien à vous, Vincent Veyron
https://marica.fr/
Gestion des sinistres assurances, des dossiers contentieux et des contrats pour
le service juridique
s/2.0/user/handlers/filters.html#C_PerlOutputFilterHandler_
http://modperlbook.org/html/25-3-I-O-Filtering.html
--
Bien à vous, Vincent Veyron
https://marica.fr/
Gestion des sinistres assurances, des dossiers contentieux et des contrats pour
le service juridique
On Tue, 4 Oct 2016 12:40:14 + (UTC)
" daniel.axtell" wrote:
>
>
> On Mon, 10/3/16, Vincent Veyron wrote:
> Now all I need to do to get up and running is
> :
>
> apt install
> apache2-mpm-prefork libapac
ache2-mod-perl2
libapache2-mod-apreq2 apache2.2-common
and from then on :
apt upgrade
--
Bien à vous, Vincent Veyron
https://marica.fr/
Gestion des sinistres assurances, des dossiers contentieux et des contrats pour
le service juridique
d have your::module do the select host, etc... and set the cookie
--
Bien à vous, Vincent Veyron
https://compta.libremen.com
Logiciel libre de comptabilité générale
I forgot to add : if you were not using filters previously, this may not solve
your problem.
Do you have accented characters in your queries' parameters? if so those need
to be decoded (anything that uses APR::Table)
--
Bien à vous, Vincent V
find very few examples of how to use Apache2::Filter.
>
I use the streaming filter. Try the recipe for package Apache::HijackFull;
(page 13) in :
http://www.modperlcookbook.org/~geoff/slides/WUC/2005/mp2_filters-printable.pdf
(you need to check for seen_eos to print)
This is my code :
htt
odperl/107021
--
Bien à vous, Vincent Veyron
https://marica.fr/
Gestion des sinistres assurances, des dossiers contentieux et des contrats pour
le service juridique
Hi all,
See this post on reddit :
https://www.reddit.com/r/linuxadmin/comments/4n5seo/apache_22_mod_perl_to_nginx/
Please help set the record straight. Ancient technology WTF?
--
Bien à vous, Vincent Veyron
https://libremen.com
Logiciels de gestion
t;",
map +(0..9,"a".."z","A".."Z")[rand(10+26*2)],
1..32;$h{$session_id}=1};$v=keys %h; print $v'
1000
--
Bien à vous, Vincent Veyron
https://libremen.com
Logiciels de gestion, libres
the installer for the (32-bit) i386 architecture."
So, maybe it was not a good idea?
--
Bien à vous, Vincent Veyron
https://marica.fr/
Gestion des sinistres assurance et des dossiers contentieux pour le service
juridique
may have to do with a cpan upgrade I did on the machine, that generated
quite a bit of errors, and messed my system somehow.
--
Bien à vous, Vincent Veyron
https://compta.libremen.com
Logiciel libre de comptabilité générale
On Mon, 16 May 2016 16:38:18 +0200
Vincent Veyron wrote:
> Out of five different servers, the code works fine on four machines, and a
> different token is generated every time the page is loaded or re-loaded. On
> one server however, a previous token is being re-used
Hi,
The faul
ta/Base/Handler/entry.pm line 146.
Token : VpCyv6GmeQwPqnD84nYBVGJeS93g64of at
/home/lib/Compta/Base/Handler/entry.pm line 150.
--
Bien à vous, Vincent Veyron
https://compta.libremen.com
Logiciel de comptabilité générale, libre
s first compiled (by this child).
Tried that, no dice. And I checked the code on an eeepc, it generates thousands
of unique keys no problem, it's just that one server :-(
Well, giving up for now. Thank you for your help.
--
Bien à vous, Vincent
nstall additional modules, I'd prefer to use the Debian packaging system, for
maintenance reasons. Is libcrypt-random-seed-perl a possibility?
Still don't understand why the problem does not show up in the other machines,
no matter what I throw at them.
--
for (1..10_000_000) {my $session_id = join "",
map +(0..9,"a".."z","A".."Z")[rand(10+26*2)], 1..32;$h{$session_id}=1};$v=keys
%h; print $v'
1000
--
Bien à vous, Vincent Veyron
https://libremen.com
Logiciels de gestion, libres
b1 amd64generic
Apache request library - Perl modules
--
Bien à vous, Vincent Veyron
https://marica.fr/
Gestion des sinistres assurance et des dossiers juridiques
- token 2
};
Before : $VAR1 = {
'mois' => 0,
'open_journal' => 'Fournisseurs',
'id_entry' => '16257'
};
After : $VAR1 = {
'open_journal' => 'Fournisseurs',
erning UTF-8 data.
If I understood correctly, anything that goes through APR::Table is considered
UTF-8, however the SvUTF8 flag is not set, so you get double encoding when
processing your data.
--
Bien à vous, Vincent Veyron
https://marica.fr/
Gestion
't help you, but see 'Run-Time
Configuration Changes' in :
https://httpd.apache.org/docs/2.4/upgrading.html
--
Bien à vous, Vincent Veyron
https://marica.fr/
Gestion des contentieux, des dossiers de sinistres assurance et des contrats
pour le service juridique
affic Mangers and Apache in different places) - in most production
> environments this is the "usual" setup...
>
Ha, that would explain it. Thanks for the heads up.
My site is low traffic, so I only use one Apache server for everything.
--
Which places mod_deflate after my PerlOutputFilterHandler in the chain.
I was surprised nobody else had the problem before, though?
--
Bien à vous, Vincent Veyron
https://marica.fr/
Suivi des contentieux juridiques, des sinistres d'assurance et des contrats
me problems following an upgrade to Debian 8 that I would have thought
someone else had encountered, but my couple of questions went unanswered; this
never happened before.
--
Bien à vous, Vincent Veyron
https://marica.fr/
Suivi des contentieux juri
On Sat, 28 Nov 2015 20:38:17 +0400
Davit Nergadze wrote:
> Is there anyone? After perl porters mailing list, this feels like an
> empty room ro something... :-/
--
Bien à vous, Vincent Veyron
https://marica.fr/
Suivi des contentieux juridique
opping web server: apache2.
Apache error log is empty.
Apache seems to be hung somewhere, because if I comment the "PerlOptions
+Parent" line, Apache starts, but only after I stop the invisible/not created
process.
--
Bien à vous, Vincent Veyro
On Wed, 21 Oct 2015 13:06:39 +0200
Tosh Cooey wrote:
> Has this been bundled yet for any Linux packages?
>
There is libapache2-mod-perl2 for Debian 8 (jessie)
--
Bien à vous, Vincent Veyron
https://marica.fr/
Suivi des contentieux juridique
stead works
FilterRequestHandler is assumed when no attribute is specified (see :
http://modperlbook.org/html/25-3-2-Filter-Configuration.html)
No idea why specifying does not work, though.
--
Bien à vous, Vincent Veyron
https://marica.fr/
Su
log is empty, though.
--
Bien à vous, Vincent Veyron
https://marica.fr/
Gestion des contentieux, des dossiers de sinistres assurance et des contrats
pour le service juridique
stop' to
complete step 2
2 - comment 'use TryCatch;' in your script and the server starts normally, then
uncomment the line (the change being picked up by Apache2::Reload) to trigger
the bug.
Sorry about the noise.
--
Bien à vous, Vinc
On Wed, 16 Sep 2015 09:40:43 -0500
Michael Schout wrote:
> On 9/16/15 9:22 AM, Vincent Veyron wrote:
> > apt-get install apache2-mpm-prefork libapache2-request-perl
> > libapache2-mod-perl2 libapache2-mod-apreq2
>
> How did you install TryCatch (the only dependency my mod
t I also have
use lib qw(/home/lib);
in startup.pl, and put your module in this library. Other than that I did not
change anything.
--
Bien à vous, Vincent Veyron
https://legalcase.libremen.com/
Legal case, contract and insurance claim management software
4.10 (Debian)
Server built: Aug 1 2015 20:53:57
--
Bien à vous, Vincent Veyron
https://legalcase.libremen.com/
Legal case, contract and insurance claim management software
$$$ yet (but I'm hopeful).
--
Salutations, Vincent Veyron
https://legalcase.libremen.com/
Legal case, contract and insurance claim management software
ng page displayed by the example is :
OutputFilterHandler $buffer NOT utf8
myparam : ôê € : 1
string : lâàéè : 1
returned_value_1 : lâàéè : 1
returned_value_2 : lâàéè : 1
returned_value_3 : ôê € : 1
OutputFilterHandler $added_string àêôu € IS utf8
--
Sal
see :
https://en.wikipedia.org/wiki/HTTP_cookie#Domain_and_Path
--
Salutations, Vincent Veyron
https://legalcase.libremen.com/
Legal case, contract and insurance claim management software
case it was consistent.
I described the symptoms here :
http://www.gossamer-threads.com/lists/modperl/modperl/108254?search_string=vincent%20veyron%20deflate;#108254
--
Salutations, Vincent Veyron
https://marica.fr/
Gestion des contentieux, des dossiers
eclare COMPRESS CONTENT_SET
FilterProvider COMPRESS DEFLATE "%{CONTENT_TYPE} =~ m#^text/(html|plain)#"
FilterChain COMPRESS
FilterProtocol COMPRESS DEFLATE change=yes;byteranges=no
--
Salutations, Vincent Veyron
https://leg
3] simpify and speed up /.*.../
handling
DEBPKG:fixes/failed_require_diagnostics - http://bugs.debian.org/781120
[perl #123270] Report inaccesible file on failed require
Built under linux
Compiled at Mar 29 2015 23:30:09
@INC:
/etc/perl
/usr/local/lib/i386-linux-gnu/perl/5.2
Hi,
Something happened to the search functionality on perl.apache.org, it returns
'Service unavailable' since yesterday at least.
--
Salutations, Vincent Veyron
https://marica.fr/
Gestion des contentieux, des dossiers de sinistres assura
On Wed, 3 Jun 2015 17:47:25 +0200
Vincent Veyron wrote:
>
> FYI, the problem disappears when using mod_perl-2.0.9 RC2.
>
Scratch this, I had forgotten to enable mod_deflate. It's still there.
Bummer.
On Thu, 28 May 2015 09:06:13 -0400
"Kevin A. McGrail" wrote:
> On 5/27/2015 6:45 PM, Vincent Veyron wrote:
> >> and what version of MP are you using?
Hi,
FYI, the problem disappears when using mod_perl-2.0.9 RC2.
All is well.
--
Built under linux
Compiled at Mar 29 2015 23:30:09
@INC:
/etc/perl
/usr/local/lib/i386-linux-gnu/perl/5.20.2
/usr/local/share/perl/5.20.2
/usr/lib/i386-linux-gnu/perl5/5.20
/usr/share/perl5
/usr/lib/i386-linux-gnu/perl/5.20
/usr/share/perl/5.20
/usr/local/lib/site_perl
.
--
Salutations, Vincent Veyron
https://marica.fr/
Gestion des contentieux, des dossiers de sinistres assurance et des contrats
pour le service juridique
(forgot to cc the list)
Begin forwarded message:
Date: Tue, 2 Jun 2015 14:44:27 +0200
From: Vincent Veyron
To: Steve Hay
Subject: Re: [RELEASE CANDIDATE]: mod_perl-2.0.9 RC2
On Tue, 2 Jun 2015 08:41:49 +0100
Steve Hay wrote:
>
> Just follow the instructions in INSTALL in the tarbal
server to start: .AH00534: apache2: Configuration
error: No MPM loaded.
[ error]
server has died with status 255 (t/logs/error_log wasn't created, start the
server in the debug mode)
Terminated
Makefile:1106: recipe for target 'run_tests' failed
make: *** [run_tests] Error 143
geez... forgot to cc the list and then sent twice with wrong id :-(
Begin forwarded message:
Date: Tue, 2 Jun 2015 14:44:27 +0200
From: Vincent Veyron
To: Steve Hay
Subject: Re: [RELEASE CANDIDATE]: mod_perl-2.0.9 RC2
On Tue, 2 Jun 2015 08:41:49 +0100
Steve Hay wrote:
>
> Just foll
e worst is that I'm sure I've done it once years ago...
--
Salutations, Vincent Veyron
https://marica.fr/
Gestion des contentieux, des dossiers de sinistres assurance et des contrats
pour le service juridique
.
--
Salutations, Vincent Veyron
https://legalcase.libremen.com/
Legal case, contract and insurance claim management software
ng to run apt-get upgrade, then apt-get dist-upgrade
>and what version of MP are you using?
#dpkg -l *mod-perl*
libapache2-mod-perl2 2.0.9~1624218-2 i386
--
Salutations, Vincent Veyron
https://legalcase.libremen.
cause this?
--
Salutations, Vincent Veyron
https://legalcase.libremen.com/
Legal case, contract and insurance claim management software
On Sun, 10 May 2015 11:58:56 +1000
Jie Gao wrote:
>
> You've now got help from Randal! So you know this is really mod_perl list. :-)
>
Well put!
--
Salutations, Vincent Veyron
https://legalcase.libremen.com/
Legal case, contract and i
ectly from the web server, to see if that solves the problem; something like
:
my $location = '/path/to/file' ;
$r->headers_out->set(Location => $location) ;
return Apache2::Const::REDIRECT ;
--
Salutations, Vincent Veyron
ere is a workaround if that bothers you :
http://perl.apache.org/docs/2.0/api/Apache2/Log.html#Virtual_Hosts
--
Regards, Vincent Veyron
https://libremen.com/
Legal case, contract and insurance claim management software
ng connect_cached, where the documentations says :
The cached database handle is replaced with a new
connection if it has been disconnected or if the "ping" method fails
Would that not solve OP's problem?
--
Regards, Vincent Veyron
h
bout this. Thanks for the heads up.
--
Salutations, Vincent Veyron
https://marica.fr/
Gestion des contentieux, des dossiers de sinistres assurance et des contrats
pour le service juridique
me=$db_name", 'www-data', undef,
{
PrintError => 1,
RaiseError => 1,
AutoCommit => 1,
pg_bool_tf => 1,
private_preferred_datestyle => $preferred_datestyle } )
or die "Cannot connect to db: $DBI::errstr" ;
return
Am I doing something
wrong?
--
Regards, Vincent Veyron
https://libremen.com/
Legal case, contract and insurance claim management software
cached?
--
Regards, Vincent Veyron
https://libremen.com/
Legal case, contract and insurance claim management software
ng connect_cached, where the documentations says :
The cached database handle is replaced with a new
connection if it has been disconnected or if the "ping" method fails
Would that not solve OP's problem?
--
Regards, Vincent Veyron
h
quite often and in multiple places. So maintaining the test suite on top of the
code base seems appealing in theory, but I found it overwhelming in practice.
I can see it happening for a well matured app that changes rarely, but for a
new one?
--
Reg
, you can look into automating
it.
--
Regards, Vincent Veyron
https://libremen.com/
Legal case, contract and insurance claim management software
e?
> s/b Apache2::URI::unescape_url()... [...]
>
I don't get this
P.S. : please don't top-post
--
Salutations, Vincent Veyron
http://marica.fr/
Gestion des contentieux, des dossiers de sinistres assurance et des contrats
pour le service juridique
g);
$r->log_error($string);
}
Result:
[Sat Jun 28 15:54:44 2014] [error] 6%2D41913%2FUK1
--
Salutations, Vincent Veyron
http://vincentveyron.com
g);
$r->log_error($string);
}
Result:
[Sat Jun 28 15:54:44 2014] [error] 6%2D41913%2FUK1
--
Salutations, Vincent Veyron
http://vincentveyron.com
I look at to debug this and understand why my connection does not
get the right encoding on the backup server?
--
Salutations, Vincent Veyron
http://marica.fr/
Gestion des contentieux, des dossiers de sinistres assurance et des contrats
pour le service juridique
1 - 100 of 159 matches
Mail list logo