could you please post also the authentication pipeline?
thanks a lot.
On Sat, 18 Sep 2004 18:43:53 +0200, g[R]eK <[EMAIL PROTECTED]> wrote:
> <. Hi fabrizio! .>
>
> Saturday, September 18, 2004, 6:22:43 PM, you wrote:
>
> fp> can someone provide me some exemples of authentication Framework with
> fp> Mysql db connection? please , i'm desperate in trying to solve my
> fp> problem...
>
> sitemap:
>
> <handler name="warsztat-auth">
> <redirect-to
> uri="cocoon://warsztat/users/login.html"/>
> <authentication
> uri="cocoon:raw:/authenticate"/>
> <!-- applications are optional
> -->
> <applications>
> <application name="gdpl">
> <load
> uri="cocoon:/LoadUser"/>
> </application>
> </applications>
> </handler>
>
> <map:pipeline internal-only="true" id="internal-resources">
> <map:match pattern="authenticate">
> <map:generate src="users/authenticate-template.xml"/>
> <map:transform type="sql">
> <map:parameter name="username"
> value="{request-param:username}"/>
> <map:parameter name="password"
> value="{request-param:password}"/>
> <map:parameter name="show-nr-of-rows"
> value="true"/>
> <map:parameter name="use-connection"
> value="warsztat"/>
> </map:transform>
> <map:transform src="users/authenticate.xsl"/>
> <map:serialize type="xml"/>
> </map:match>
> [...]
> </map:pipeline>
>
> authenticate-template.xml:
> <authenticate xmlns:sql="http://apache.org/cocoon/SQL/2.0";>
> <sql:execute-query>
> <sql:query name="authenticate">
> SELECT
> user_id,
> username,
> warsztat_privilege_level
> FROM forum_users
> WHERE
> username = '<sql:substitute-value sql:name="username"/>'
> AND
> user_password = md5('<sql:substitute-value
> sql:name="password"/>')
> ;
> </sql:query>
> </sql:execute-query>
> </authenticate>
>
> authenticate.xsl:
> <xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform";
> xmlns:fo="http://www.w3.org/1999/XSL/Format";
> xmlns:sql="http://apache.org/cocoon/SQL/2.0";>
> <xsl:template match="authenticate">
> <authentication>
> <xsl:choose>
> <xsl:when test="sql:[EMAIL PROTECTED]:nrofrows > 0]">
> <ID><xsl:value-of
> select="sql:rowset/sql:row/sql:user_id"/></ID>
> <role><xsl:value-of
> select="sql:rowset/sql:row/sql:warsztat_privilege_level"/></role>
> <data><xsl:copy-of
> select="sql:rowset/sql:row/sql:*"/></data>
> </xsl:when>
> <xsl:otherwise>
> <data>Some error</data>
> </xsl:otherwise>
> </xsl:choose>
> </authentication>
> </xsl:template>
> </xsl:stylesheet>
>
> Hope this help.
>
> --
> Best regards
> <. g[R]eK mailto:[EMAIL PROTECTED] .>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
>
>
--
copyright - fabpicca
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
