Return-Path: 
 <users-return-60231-apmail-cocoon-users-archive=cocoon.apache.org@cocoon.apache.org>
Delivered-To: apmail-cocoon-users-archive@www.apache.org
Received: (qmail 18037 invoked from network); 22 Dec 2003 17:36:43 -0000
Received: from daedalus.apache.org (HELO mail.apache.org) (208.185.179.12)
  by minotaur-2.apache.org with SMTP; 22 Dec 2003 17:36:43 -0000
Received: (qmail 22822 invoked by uid 500); 22 Dec 2003 17:36:29 -0000
Delivered-To: apmail-cocoon-users-archive@cocoon.apache.org
Received: (qmail 22501 invoked by uid 500); 22 Dec 2003 17:36:27 -0000
Mailing-List: contact users-help@cocoon.apache.org; run by ezmlm
Precedence: bulk
list-help: <mailto:users-help@cocoon.apache.org>
list-unsubscribe: <mailto:users-unsubscribe@cocoon.apache.org>
list-post: <mailto:users@cocoon.apache.org>
Reply-To: users@cocoon.apache.org
Delivered-To: mailing list users@cocoon.apache.org
Received: (qmail 22471 invoked from network); 22 Dec 2003 17:36:27 -0000
Received: from unknown (HELO smtp10.atl.mindspring.net) (207.69.200.246)
  by daedalus.apache.org with SMTP; 22 Dec 2003 17:36:27 -0000
Received: from sdn-ap-015txhousp0425.dialsprint.net ([63.190.145.171]
 helo=jdwinspiron)
	by smtp10.atl.mindspring.net with smtp (Exim 3.33 #1)
	id 1AYTyn-0002t5-00
	for users@cocoon.apache.org; Mon, 22 Dec 2003 12:36:29 -0500
Message-ID: <000a01c3c8b2$2220ba90$0201a8c0@jdwinspiron>
From: "Joe D. Williams" <joe_d_williams@mindspring.com>
To: <users@cocoon.apache.org>
References: <000a01c3c822$f9402640$0201a8c0@jdwinspiron>
 <3FE6A269.2050302@informatik.tu-darmstadt.de>
Subject: Re: Newbie: Nested <map:act> in sitemap for
 DatabaseAuthenticatorAction and DatabaseSelectAction?
Date: Mon, 22 Dec 2003 11:36:28 -0600
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
X-Priority: 3
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook Express 6.00.2800.1158
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
X-Spam-Rating: daedalus.apache.org 1.6.2 0/1000/N
X-Spam-Rating: minotaur-2.apache.org 1.6.2 0/1000/N

I am still unable to get the info I want to the session using the
DatabaseSelectAction. I could accomplish the same thing, I know, with an
XSP. But, I would prefer to use the action to keep the number of files and
code to a minimum for the users who will eventually have to maintain the
application.

Visitors are to log in using a typical form with username and password.
Username is saved to the session as "user", and authenticated against the
"support" db column "username".

That part works fine. However, I would like to deliver content based, not on
the username, but on the company the user works for, identified in the db as
"customer_name". Therefore, I would like to store the attribute "customer"
in the session.

I am using the following matcher:

<map:match pattern="dologin">
 <map:act type="authenticator">
  <map:parameter name="descriptor"
value="context://support/content/defs/authenticate.xml"/>

  <map:act type="select">
   <map:parameter name="descriptor"
value="context://support/content/select.xml"/>
  </map:act>

  <map:redirect-to uri="support/index"/>

 </map:act>
 <map:redirect-to uri="login"/>
</map:match>

And I get the following error:

org.apache.cocoon.ProcessingException: Could not prepare statement :position
= 0: org.apache.avalon.framework.configuration.ConfigurationException: Error
trying to load configurations for resource: null

Through several iterations, I have arrived at the following descriptors for
the actions above. Any help would be appreciated.

<auth-descriptor>
 <connection>support</connection>
 <table name="users">
  <select dbcol="username" request-param="user" to-session="user"/>
  <select dbcol="password" request-param="pass"/>
 </table>
</auth-descriptor>

<components>
 <connection>support</connection>
 <table name="users">
  <keys>
   <key param="user" dbcol="username" type="string"/>
  </keys>
  <values>
   <value param="customer" dbcol="customer_name" type="string"/>
  </values>
 </table>
</components>


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