Excuse me if i repost the same question, but the problem is still alive. Maybe somebody can give me a little hint ... if a complete example is too much ; i'm quite new at this list so please forgive me if i mistake.
Thanks Flavio >Hi all, i'am trying to authenticate users agaist a DB table using a XSP page with no success. i show the pages below, i'm not able to find where is the mistake (probably many ...) ; the page that accesses the DB table seems not to be executed > can somebody provide a complete example ? :-) i searched the mail archive back since 02/2003 but i was not able to find the right example to solve my problem. thanks a lot Flavio SITEMAP-------------------------------------------------- >------------ <map:pipelines> <map:component-configurations> <authentication-manager> <handlers> <handler name="protArea"> <redirect-to uri="cocoon:/login"/> <authentication uri="cocoon:raw:/ >uthenticate"/> </handler> </handlers> </authentication-manager> </map:component-configurations> <map:pipeline> <map:match pattern=""> <map:redirect-to uri="login"/> </map:match> < >-- ================= --> <!-- Simple login page --> <!-- ================= --> <map:match pattern="login"> <!-- if we are already logged in, redirect to the protected document --> <map:act type="auth-loggedIn"> > <map:parameter name="handler" value="protArea"/> <map:redirect-to uri="protected/home"/> </map:act> <map:generate src="docs/login.xml"/> <map:transform src="stylesheets/simple-page2html.xsl"/> <!-- > <map:transform type="encodeURL"/> --> <map:serialize/> </map:match> <!-- ========================================= --> <!-- Form target which performs auth service --> <!-- ===================================== >=== --> <map:match pattern="do-login"> <!-- try to login --> <map:act type="auth-login"> <map:parameter name="handler" value="protArea"/> <map:parameter name="parameter_name" value="{request-param:username >"/> <map:redirect-to uri="protected/home"/> </map:act> <!-- something was wrong, try it again --> <map:redirect-to uri="login"/> </map:match> <!-- ================ --> <!-- Protected area - >> <!-- ================ --> <map:match pattern="protected/**"> <map:act type="auth-protect"> <map:parameter name="handler" value="protArea"/> ...... </map:act> <!-- something was wrong, re >irect to login page --> <map:redirect-to uri="login"/> </map:match> <!-- ========================================= --> <!-- Logout link which invalidates the session --> <!-- ====================================== >== --> <map:match pattern="do-logout"> <map:act type="auth-protect"> <map:parameter name="handler" value="protArea"/> <map:act type="auth-logout"/> </map:act> <map:redirect-to uri="login"/> > </map:match> </map:pipeline> <map:pipeline internal-only="true"> <!-- This is the authentication resource --> <map:match pattern="authenticate"> <map:generate type="serverpages" src="docs/autenticaLogin.xsp"/> > <map:parameter name="use-request-parameters" value="true"/> <map:transform src="stylesheets/autentica.xsl"/> <map:serialize type="xml"/> </map:match> <map:handle-errors> <map:transform src="stylesheets/system/er >or2document.xsl"/> <map:transform src="stylesheets/apache.xsl"/> <map:serialize status-code="500"/> </map:handle-errors> </map:pipeline> </map:pipelines> </map:sitemap> ACCESS to user table------------------------------------ >----------------- <?xml version="1.0"?> <xsp:page xmlns:xsp="http://apache.org/xsp" xmlns:xsp-request="http://apache.org/xsp/request/2.0" xmlns:esql="http://apache.org/cocoon/SQL/v2"> <esql:connection> <esql:pool> >iskIdem</esql:pool> <esql:execute-query> <esql:query> SELECT a0_user, a0_pass, a0_codiceSocOM, a0_codiceUserOM, a0_nazione, a0_lingua, a0_currency FROM a0_users WHERE a0_user = <esql:parameter><xsp-request:g >t-parameter name="username"/></esql:parameter> </esql:query> <esql:results> <esql:row-results> <authentication> <user><esql:get-string column="a0_user"/></user> </authentica >ion> </esql:row-results> </esql:results> <esql:no-results> <authentication> </authentication> </esql:no-results> </esql:execute-query> </esql:connection> </xsp: >age> STYLESHEET to transform in XML------------------------------------------------- <?xml version="1.0"?> <xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform"> <xsl:template match="authentication"> <authenticati >n> <xsl:apply-templates/> </authentication> </xsl:template> <xsl:template match="user"> <ID><xsl:apply-templates/></ID> </xsl:template> </xsl:stylesheet> --------------------------------------------------------------------- >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]