<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2900.2802" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT face=Arial size=2>
<DIV><FONT face=Arial size=2>Hello Everyone,</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>I need help in configuring user authentication for
a folder in Zope using MySQL database. I spent many hours reading and searching
for the answer but I con not reach a successful outcome. Here is what I did so
far:</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>- the folder that needs to be protected is "Root
Folder\domains\mydomain"</FONT></DIV>
<DIV><FONT face=Arial size=2>- I added a "MySQL_database_connection (Z MySQL
Database Connection). The "Status" tab says the connection is open.</FONT></DIV>
<DIV><FONT face=Arial size=2>- I added an "acl_users" (Extensible User
Folder).</FONT></DIV>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV><FONT face=Arial size=2>- the "parameters" tab is set to "cookie-based
authentication"</FONT></DIV>
<DIV><FONT face=Arial size=2>- the "Authentication Source" tab
shows</FONT></DIV>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV><FONT face=Arial size=2>Database Connection set to
"MySQL_database_connection</FONT></DIV>
<DIV><FONT face=Arial size=2>Table Name set to "webusers"</FONT></DIV>
<DIV><FONT face=Arial size=2>Username Column set to
"user_login"</FONT></DIV>
<DIV><FONT face=Arial size=2>Password Column set to "user_pass"</FONT></DIV>
<DIV><FONT face=Arial size=2>Roles Column set to
"user_roles"</FONT></DIV></BLOCKQUOTE>
<DIV dir=ltr><FONT face=Arial size=2>- the "Properties Source" tab shows
Database Connection set to "MySQL_database_connection"</FONT></DIV>
<DIV dir=ltr><FONT face=Arial size=2>- the "Membership Source" tab shows (I
list only some of the entries here):</FONT></DIV>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV dir=ltr><FONT face=Arial size=2>Mail Host set to "MialHost"
<BR>Site Base set to "<A
href="http://my.ip.address:8080/domains/mydomain">http://my.ip.address:8080/domains/mydomain</A>"<BR>Relative
Path (from base) of Login Page set to "LoginForm"<BR>Relative Path (from
base) of Signup Page set to "SignupForm"<BR>Relative Path (from base) of
Change Password Page set to "ChangPasswordForm"<BR>After login.... set to
"Go to intended destination"<BR>Default Roles has nothing
selected<BR></FONT></DIV></BLOCKQUOTE>
<DIV dir=ltr><FONT face=Arial size=2>- the "Groups Source" is
blank</FONT></DIV>
<DIV dir=ltr><FONT face=Arial size=2>- the "Security" tab shows all set to
"Aquire"</FONT></DIV>
<DIV dir=ltr><FONT face=Arial size=2>- the "Contents" tab has a list of DTML
and folders (too long to enter them here)</FONT></DIV></BLOCKQUOTE>
<DIV dir=ltr><FONT face=Arial size=2>- I added an "index_html" DTML
method</FONT></DIV>
<DIV dir=ltr><FONT face=Arial size=2>- I inserted a row in the database with the
following data "user_login=admin" "user_pass=schi" "user_roles=administrator" (I
used phpMyAdmin for this since I did not know how to do it in Zope)</FONT></DIV>
<DIV dir=ltr><FONT face=Arial size=2></FONT> </DIV>
<DIV dir=ltr><FONT face=Arial size=2>When I call in a browser <A
href="http://my.ip.address:8080/domains/mydomain">http://my.ip.address:8080/domains/mydomain</A>
the above "index_html" is displayed</FONT></DIV>
<DIV dir=ltr><FONT face=Arial size=2></FONT> </DIV>
<DIV dir=ltr><FONT face=Arial size=2>When I change on the "Security" tab
of the "index_html" method, the "View" permission from "Acquire" to
"Authenticated" I do receive the "Login Required" page from
domains/mydomain/acl_users and the "Contents" tab, DTML method called "docLogin
(Login Page)".</FONT></DIV>
<DIV dir=ltr><FONT face=Arial size=2></FONT> </DIV>
<DIV dir=ltr><FONT face=Arial size=2>If I enter the user name as "caladmin" and
its password "schi" and click the OK button ... the login page comes back
over and over again. No error messages are displayed.</FONT></DIV>
<DIV dir=ltr><FONT face=Arial size=2></FONT> </DIV>
<DIV dir=ltr><FONT face=Arial size=2>What am I doing wrong and how can I
make it work? Please help.</FONT></DIV>
<DIV dir=ltr><FONT face=Arial size=2></FONT> </DIV>
<DIV dir=ltr><FONT face=Arial size=2>Thank you.</FONT></DIV>
<DIV dir=ltr><FONT face=Arial
size=2>Laurentiu </DIV></FONT></FONT></DIV></BODY></HTML>