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 mystake (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:/authenticate"/>
</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, redirect 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/error2document.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>riskIdem</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:get-parameter
name="username"/></esql:parameter>
</esql:query>
<esql:results>
<esql:row-results>
<authentication>
<user><esql:get-string column="a0_user"/></user>
</authentication>
</esql:row-results>
</esql:results>
<esql:no-results>
<authentication>
</authentication>
</esql:no-results>
</esql:execute-query>
</esql:connection>
</xsp:page>
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">
<authentication>
<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]
