cocoon-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From fabrizio picca <fabrizio.pi...@gmail.com>
Subject Re: desperate help on authentication framework and mysql connection
Date Sat, 18 Sep 2004 17:05:06 GMT
could you please post also the authentication pipeline?

thanks a lot.


On Sat, 18 Sep 2004 18:43:53 +0200, g[R]eK <grek@warsztat.pac.pl> 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:rowset[@sql: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:gReK@warsztat.pac.pl                                    .>
> 
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: users-unsubscribe@cocoon.apache.org
> For additional commands, e-mail: users-help@cocoon.apache.org
> 
> 



-- 
copyright - fabpicca

---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@cocoon.apache.org
For additional commands, e-mail: users-help@cocoon.apache.org


Mime
View raw message