Hello,
I have just
installed EmbPerl and Apache on my WinNT development box.
I am
currently converting an ASP/IIS application to EmbPerl/Apache. It seems to
be working fine, as I am able to access my database with some test pages I have
written. In fact it only took me about 5 minutes to get the data access
test page working! Great product!
Here is my problem:
My current ASP
application uses form based login. Once a user logs into the site, and
password/username is validated (from a database), they are allowed to see
and possibly update the data in the database. The site access is
structured in five levels ranging from user to admin, with each level
having access to only certain pages in the site. I am doing this by using
sessions with ASP. I store a few things in the session, userID,
securitylevel, etc. which I evaluate when each page is displayed (if the user
doesn't have access they are redirected, etc.). I also evaluate the user
level on the page displayed to possibly change the SQL queries or display
different things. I don't know how to do this with EmbPerl and
Apache.
By reading whatever
I can find on the web, it seems that I must uses Apache::Session,
Apache::Sessions::DBI, or with EmbPerl Apache::Sessions::ebDBI. Also, I
don't want to be forced into using mySQL as my database. Right now I am
using MSAccess for my database (just for testing) using the DBI::ODBC
driver. I want to use this same driver and database with my session
management also.
Could someone please
point me in the right direction?
I see many people
complaining about the Apache::Session::DBI module. Do I avoid using
that?
Also please remember
that I am using WinNT and don't have $600 to buy Visual C++ 6.0 in order to
recompile Apache and/or Perl!
(P.S. Red Hat 7.1 is
on the way)
Thanks,
Barry White
mailto:[EMAIL PROTECTED]
