Re: session records bulding up

2003-01-16 Thread Angus Lees
At Tue, 14 Jan 2003 20:49:56 +0100, Gerald Richter wrote:
> >One more way which is probably evil but better overall, imo, is to add a
> field to the session table with the timestamp
> 
> Adding a field should work. Mysql can use a default value on insert. If you
> set the default to now() mysql should automaticly insert the date and time
> and you should be done

if i remember mysql correctly, there's a "timestamp" data type. if you
create a column with that type it will automatically have the time
that row was last modified.

-- 
 - Gus

-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]




RE: session records bulding up

2003-01-16 Thread Alexandru Deva
Yes, that's just what I did. Thanks.

-Original Message-
From: Angus Lees [mailto:[EMAIL PROTECTED]] 
Sent: Thursday, January 16, 2003 10:52 AM
To: [EMAIL PROTECTED]
Cc: Alexandru Deva; Keith Watanabe
Subject: Re: session records bulding up


At Tue, 14 Jan 2003 20:49:56 +0100, Gerald Richter wrote:
> >One more way which is probably evil but better overall, imo, is to 
> >add a
> field to the session table with the timestamp
> 
> Adding a field should work. Mysql can use a default value on insert. 
> If you set the default to now() mysql should automaticly insert the 
> date and time and you should be done

if i remember mysql correctly, there's a "timestamp" data type. if you
create a column with that type it will automatically have the time that
row was last modified.

-- 
 - Gus


---
The content of this communication is classified as Mobifon SA Romania Confidential and 
Proprietary Information.The content of this communication is intended solely for the 
use of the individual or entity to whom it is addressed and others authorized to 
receive it. If you are not the intended recipient you are hereby notified that any 
disclosure, copying, distribution or taking any action in reliance on the contents of 
this information is strictly prohibited and may be unlawful. If you have received this 
communication in error, please notify us immediately by responding to this 
communication then delete it from your system. We appreciate your assistance in 
preserving the confidentiality of our correspondence. Thank you.

Prezentul mesaj constituie o Informatie confidentiala si este proprietatea exclusiva a 
 MobiFon S.A.. Mesajul se adreseaza numai persoanei fizice sau juridice mentionata ca 
destinatara, precum si altor persoane autorizate sa-l primeasca. In cazul in care nu 
sunteti destinatarul vizat, va aducem la cunostinta ca dezvaluirea, copierea, 
distribuirea sau initierea unor actiuni pe baza prezentei informatii sunt strict 
interzise si atrag raspunderea civila si penala. Daca ati primit acest mesaj dintr-o 
eroare, va rugam sa ne anuntati imediat, ca raspuns la mesajul de fata, si sa-l 
stergeti apoi din sistemul dvs. Apreciem si va multumim pentru sprijinul acordat in 
pastrarea confidentialitatii corespondentei noastre. 
---

-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]




Re: Dreamweaver MX and Embperl?

2003-01-16 Thread Luiz Fernando B. Ribeiro
Hi,

Download: 
http://www.engenhosolucoes.com.br/arquivos/DW_Embperl.zip

Extract this zip file in your Dreamweaver MX Configuration folder
(backup first) and it should work. This is a simple setup with just code
identification and icons. I use the extension .epl to designate Embperl
pages so if you use any other you you have to add them to the
Extensions.txt file and MMDocumentTypes.xml file.

Dreamweaver MX is very customizable and you can really make it an
Embperl friend. You can be surprized by how much it can speed up your
layuot and design tasks.

Contact me if you need further help.

Regards,

Luiz Fernando B. Ribeiro
Engenho Soluções para a Internet


Em Thu, 16 Jan 2003 01:02:03 -0500
Saadiq Rodgers-King <[EMAIL PROTECTED]> escreveu:

> I'm aware of this extension (http://www.somewhere.com/software/) for
> Dreamweaver 3, but has anyone had any success making MX play nicely w/
> Embperl?  I'm not very familiar w/ Dreamweaver at all, preferring vi
> myself, but I can't expect the rest of my team to use vi.  I'd
> appreciate any tips.  Thanks.
> 
> -
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> 
> 


-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]




ENV{QUERY_STRING} not included in %fdat?

2003-01-16 Thread Scott Chapman
I was surprised to find that the URL parameters passed in ?name=value after 
the URL are not being parsed into %fdat.  Is there an embperl way of getting 
at this data or do I need to parse it manually?

EmbPerl 2.0b8, ModPerl 1.27, Apache 1.3.27, RedHat 7.3

Thanks!
Scott




-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]




Re: Can't locate object method "TIEHASH"

2003-01-16 Thread Gerald Richter



Hi,
 
sorry I have overseen in your last message that you 
are using 2.0b8. 2.0b8 doesn't support Embperl::Session anymore. Please use 
Apache::SessionX instead
 
Gerald
 
-Gerald 
Richter    ecos electronic communication services 
gmbhInternetconnect * Webserver/-design/-datenbanken * Consulting
 
Post:   Tulpenstrasse 
5 D-55276 Dienheim b. 
MainzE-Mail: [EMAIL PROTECTED] 
Voice:    +49 6133 
925131WWW:    http://www.ecos.de  
Fax:  +49 6133 
925152-

  - Original Message - 
  From: 
  Farouk 
  Khawaja 
  To: Gerald Richter 
  Cc: [EMAIL PROTECTED] 
  Sent: Tuesday, January 14, 2003 9:11 
  PM
  Subject: Re: Can't locate object method 
  "TIEHASH"
  On Tue, 2003-01-14 at 14:57, Gerald Richter wrote:
  Did you load Embperl::Session somewhere. If not do it
I belive the following from 
  'httpd.conf' loads Embperl::Session.     
  PerlModule  
  Embperl  
  SetHandler  
  perl-script  
  PerlHandler 
  Embperl::Object  
  Options 
  ExecCGI  
  Embperl_AppName 
  GSSiconsole  Embperl_Object_Base 
  base.htm  Embperl_UriMatch    
  "\.htm.?|\.epl$"  
  Embperl_Options 16  
  Embperl_Log 
  "/www/apache/logs/embperl/embperl.log"  
  Embperl_Debug   
  4  Embperl_Mailhost    
  tusmail.instinet.com  Embperl_Cookie_Expires 
  +1h  Embperl_Session_Handler_Class 
  "Embperl::Session"  Embperl_Session_Classes 
  "File Semaphore"  Embperl_Session_Args 
  "Directory=/www/apache/session"   
  -- Farouk Khawaja <[EMAIL PROTECTED]>Instinet Corporation 
***<>This 
  message is intended only for the use of the Addressee and may contain 
  information that is PRIVILEGED and/orCONFIDENTIAL or both.This 
  email is intended only for the personal and confidential useof the 
  recipient(s) named above.If the reader of this email is not an 
  intended recipient, you havereceived this email in error and any review, 
  dissemination,distribution or copying is strictly prohibited.If 
  you have received this email in error, please notify the senderimmediately 
  by return mail and permanently deleting the copyyou received.Thank 
  you.***


Re: ENV{QUERY_STRING} not included in %fdat?

2003-01-16 Thread Gerald Richter


>I was surprised to find that the URL parameters passed in ?name=value after
>the URL are not being parsed into %fdat.  Is there an embperl way of
getting
>at this data or do I need to parse it manually?

Embperl passes the URL parameters in %fdat. That's what it always did. Only
if you have POST data (from a form) and URL parameters, you only get the
POST data in %fdat

Gerald

-
Gerald Richterecos electronic communication services gmbh
Internetconnect * Webserver/-design/-datenbanken * Consulting

Post:   Tulpenstrasse 5 D-55276 Dienheim b. Mainz
E-Mail: [EMAIL PROTECTED] Voice:+49 6133 925131
WWW:http://www.ecos.de  Fax:  +49 6133 925152
-



-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]




Re: ENV{QUERY_STRING} not included in %fdat?

2003-01-16 Thread Scott Chapman
Are there security implications or other problems with using GET for 
submission?

On Thursday 16 January 2003 11:47 am, Gerald Richter wrote:
> >I was surprised to find that the URL parameters passed in ?name=value
> > after the URL are not being parsed into %fdat.  Is there an embperl way
> > of
>
> getting
>
> >at this data or do I need to parse it manually?
>
> Embperl passes the URL parameters in %fdat. That's what it always did. Only
> if you have POST data (from a form) and URL parameters, you only get the
> POST data in %fdat
>
> Gerald
>
> -
> Gerald Richterecos electronic communication services gmbh
> Internetconnect * Webserver/-design/-datenbanken * Consulting
>
> Post:   Tulpenstrasse 5 D-55276 Dienheim b. Mainz
> E-Mail: [EMAIL PROTECTED] Voice:+49 6133 925131
> WWW:http://www.ecos.de  Fax:  +49 6133 925152
> -


-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]




Re: problem with %udat

2003-01-16 Thread Michael Boudreau
Sorry to have delayed so long in following this up...

At 10/5/02 11:13 PM, Gerald Richter wrote:

>
> When I start up Apache, it reports that session support is enabled:
>
> % apachectl start
>   [6351]SES:  Embperl Session management enabled ()

Mmmh, you should see a version number between the braces. DO you have also
Apache::Session installed (without the ending X) ?


Apache::Session and Apache::SessionX are installed. I can run a tiny script 
that includes "use Apache::Session" and "use Apache::SessionX" and it gives 
no error messages.


Does make test of Apache::SessionX works?


They were installed using the CPAN module. Using CPAN again, I tried "test 
Apache::SessionX" and got this, which doesn't seem to contain any error 
messages:

cpan> test Apache::SessionX
CPAN: Storable loaded ok
Going to read /w1/local/.cpan/Metadata
  Database was generated on Mon, 04 Nov 2002 04:24:20 GMT
CPAN: LWP::UserAgent loaded ok
Fetching with LWP:
  ftp://ftp.duke.edu/pub/perl/authors/01mailrc.txt.gz
Going to read /w1/local/.cpan/sources/authors/01mailrc.txt.gz
CPAN: Compress::Zlib loaded ok
Fetching with LWP:
  ftp://ftp.duke.edu/pub/perl/modules/02packages.details.txt.gz
Going to read /w1/local/.cpan/sources/modules/02packages.details.txt.gz
  Database was generated on Thu, 16 Jan 2003 02:48:12 GMT
Fetching with LWP:
  ftp://ftp.duke.edu/pub/perl/modules/03modlist.data.gz
Going to read /w1/local/.cpan/sources/modules/03modlist.data.gz
Going to write /w1/local/.cpan/Metadata
Running test for module Apache::SessionX
Running make for G/GR/GRICHTER/Apache-SessionX-2.00b3.tar.gz
CPAN: Digest::MD5 loaded ok
Checksum for 
/w1/local/.cpan/sources/authors/id/G/GR/GRICHTER/Apache-SessionX-2.00b3.tar.gz 
ok
Scanning cache /w1/local/.cpan/build for sizes
x Apache-SessionX-2.00b3, 0 bytes, 0 tape blocks
x Apache-SessionX-2.00b3/SessionX.pm, 17670 bytes, 35 tape blocks
x Apache-SessionX-2.00b3/Makefile.PL, 9153 bytes, 18 tape blocks
x Apache-SessionX-2.00b3/test.pl, 11832 bytes, 24 tape blocks
x Apache-SessionX-2.00b3/MANIFEST, 93 bytes, 1 tape blocks
x Apache-SessionX-2.00b3/SessionX, 0 bytes, 0 tape blocks
x Apache-SessionX-2.00b3/SessionX/Generate, 0 bytes, 0 tape blocks
x Apache-SessionX-2.00b3/SessionX/Generate/MD5.pm, 2685 bytes, 6 tape blocks
x Apache-SessionX-2.00b3/testcount.pl, 727 bytes, 2 tape blocks
x Apache-SessionX-2.00b3/README, 3511 bytes, 7 tape blocks
Removing previously used /w1/local/.cpan/build/Apache-SessionX-2.00b3

  CPAN.pm: Going to build G/GR/GRICHTER/Apache-SessionX-2.00b3.tar.gz


Checking configuration...
Storage 'Oracle' is unavailable because DBD::Oracle is not installed on 
your system
Storage 'Postgres' is unavailable because DBD::Pg is not installed on your 
system
Storage 'Sybase' is unavailable because DBD::Sybase is not installed on 
your system

The following ways to store session are available on your system:
 - DB_File : DB_File
 - File: File, use semaphore for locking
 - FileFile: File, use lockfiles
 - Mysql   : MySQL, use semaphore for locking
 - MysqlMysql  : MySQL, use MySQL for locking
Found previous configuration. Modify it(y/n) [n]
Using MysqlMysql as default
Checking if your kit is complete...
Looks good
Writing Makefile for Apache::SessionX
mkdir blib
mkdir blib/lib
mkdir blib/lib/Apache
mkdir blib/arch
mkdir blib/arch/auto
mkdir blib/arch/auto/Apache
mkdir blib/arch/auto/Apache/SessionX
mkdir blib/lib/auto
mkdir blib/lib/auto/Apache
mkdir blib/lib/auto/Apache/SessionX
mkdir blib/man3
cp SessionX/Generate/MD5.pm blib/lib/Apache/SessionX/Generate/MD5.pm
cp testcount.pl blib/lib/Apache/testcount.pl
cp SessionX.pm blib/lib/Apache/SessionX.pm
cp SessionX/Config.pm blib/lib/Apache/SessionX/Config.pm
Manifying blib/man3/Apache::SessionX::Generate::MD5.3
Manifying blib/man3/Apache::SessionX.3
  /usr/ccs/bin/make  -- OK
Running make test
PERL_DL_NONLAZY=1 /w1/local/bin/perl -Iblib/arch -Iblib/lib 
-I/w1/local/lib/perl5/5.6.0/sun4-solaris -I/w1/local/lib/perl5/5.6.0 test.pl

** Testing configuration 'MysqlMysql': MySQL, use MySQL for locking...
#00 o Open... ok
#01 s No Args...  ok
#02 s Lazy... ok
#03 f unknown id...   ok
#04 f unknown id...   ok
#05 f unknown idfrom...   ok
#06 f unknown idfrom...   ok
#07 s create_unknown...   ok
#08 s Idfrom, create_unknown, id...ok
#09 s Idfrom, create_unknown...   ok
#10 s create_unknown, recreate... ok
#11 s newid...ok
#12 s newid, lazy...  ok
#13 s newid 2...  ok
#14 p Lazy... ok
#15 p create_unknown...   ok
#16 p Idfrom, create_unknown, id...ok
#17 p Idfrom, create_unknown...   ok
#18 p create_unknown, recreate... ok
#19 p newid...ok
#20 p newid, lazy...  ok
#21 p newid 2...  ok
#22 c concurrent access...
A0 A1 A2 A3 A4 A5 A6 A7 A8 A9 C10 C11 B12 C13

Re: ENV{QUERY_STRING} not included in %fdat?

2003-01-16 Thread Gerald Richter



>Are there security implications or other problems with using GET for
>submission?


GET is limited in length (depends on the web server) and the user will see
it in the address line.

You can also add hidden input fields to your form to add data to the POST,
instead of using GET and appending it to the URL

Gerald



-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]




Trying to put a hash in $req.

2003-01-16 Thread Scott Chapman
I'm trying to parse the ENV{QUERY_STRING} and put it in a hash (%fields) in 
$req.  This is being done in constants.epl under EmbPerl::Object.  I want to 
make this hash available to the page being loaded without having to go 
through too much trouble and I don't want to use cookies.  I'm doing this to 
parse and build the %fields hash in $req.  Am I doing this right?

$queryString = $ENV{QUERY_STRING};
@queries = split(/&/, $queryString);
for ($i = 0; $i < @queries; $i ++) {
  @pairs = split(/=/, $queries[$i]);
  $value = $pairs[1];
  do decode(*value);
  $req->{$fields{$pairs[0]}} = $value;
}


Later when I try to walk through the hash it doesn't work and I'm accessing it 
wrong I think:

while(($key, $value) = each($req->{%fields})) {
&{$req->{DBUG}} ("FIELDS: KEY: $key   VALUE: $value");
}

I'm not too strong on this "$req->" stuff.  If anyone can give me a boost here 
I'd appreciate it!

Scott


-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]




Re: Trying to put a hash in $req.

2003-01-16 Thread Gerald Richter
>  do decode(*value);

What is this?


>  $req->{$fields{$pairs[0]}} = $value;

must be

$req->{fields}{$pairs[0]} = $value;

and this

>while(($key, $value) = each($req->{%fields})) {

must be

while(($key, $value) = each(%{$req->{fields}})) {

Gerald

-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]



-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]




Re: Duplicating SELECT

2003-01-16 Thread Gerald Richter
> Embperl 2.0b9 will add any SELECT field to the [$hidden$], so it will be
> duplicated. If the user chooses an entry with value 1, it will be 1\t1 if
I
> use [$hidden$].
>
> It did not do that with 2.0b8.
>


I works correctly for me, but it is required that the value inside %fdat is
one of the values in the option list. There is no chane between b8 and b9.

If it doesn't do what you expect, please send me a small test page that
shows the behaviour

Gerald

-
Gerald Richterecos electronic communication services gmbh
Internetconnect * Webserver/-design/-datenbanken * Consulting

Post:   Tulpenstrasse 5 D-55276 Dienheim b. Mainz
E-Mail: [EMAIL PROTECTED] Voice:+49 6133 925131
WWW:http://www.ecos.de  Fax:  +49 6133 925152
-


-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]




Re: problem with %udat

2003-01-16 Thread Gerald Richter
> > > % apachectl start
> > >   [6351]SES:  Embperl Session management enabled ()
> >
> >Mmmh, you should see a version number between the braces. DO you have
also
> >Apache::Session installed (without the ending X) ?
>
> Apache::Session and Apache::SessionX are installed. I can run a tiny
script
> that includes "use Apache::Session" and "use Apache::SessionX" and it
gives
> no error messages.
>

ok, so Apache::SessionX installation is ok. Do you have any configuration
directives realated to sessions in your httpd.conf. If yes please send them.

>
> I added [- $dbgSession=1; -] before the code which uses %udat.
>

Do you see any lines starting with SES in your embperl.log file?

Gerald



-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]