DatabaseServerLoginModule in 3.2.1

[mozheyko_d]

I read previous topic and
I wrote:

############################
database.sql
############################
...
create table jboss_users(
code integer not null primary key,
name varchar( 20),
passwd varchar( 20),
therole varchar( 20)
);

insert into jboss_users values ( 1, 'dm', 'dm', 'admin');
insert into jboss_users values ( 2, 'qwerty', 'qwerty', 'user');
...
############################
server/default/conf/login-config.xml
############################
...
<application-policy name = "mozheyko">

<login-module code = "org.jboss.security.auth.spi.DatabaseServerLoginModule" flag = "required">
<module-option name="dsJndiName">java:/FirebirdDS</module-option>
<module-option name="pricipalsQuery">select passwd from jboss_users where name=?</module-option>
<module-option name="rolesQuery">select therole, 'Roles' from jboss_users where name=?</module-option>
</login-module>

</application-policy>
...
############################
jboss-web.xml
############################
...
<security-domain>java:/jaas/mozheyko</security-domain>
...

############################

and turn DEBUG level in log4j.xml

I RECEIVE:
...
2003-06-17 16:16:53,278 DEBUG [org.jboss.jetty.security.JBossUserRealm#Main servlet] JBossUserPrincipal: dm
2003-06-17 16:16:53,283 DEBUG [org.jboss.jetty.security.JBossUserRealm#Main servlet] created JBossUserRealm::JBossUserPrincipal: admin
2003-06-17 16:16:53,284 DEBUG [org.jboss.jetty.security.JBossUserRealm#Main servlet] authenticating: Name:admin Password:****2003-06-17
...
16:16:53,316 DEBUG [org.firebirdsql.jca.FBManagedConnection] preparing sql: select Password from Principals where
PrincipalID=?
...
What i forget and whence this quiry has undertaken ?

[jalex]

The resources you have posted seem correct: what about j2ee xml deploy file (ejb-jar.xml)? The auth.conf is labeled with your security domain (java:/jaas/mozheyko)? Also check trimming on query: this can be up to dbms, but we have used a trim function. Please provide us many info: the error trace doesn't seem too clear... it just reports the prepared statement

[sradford]

How about the mis-spelling of principalsQuery in your module-option?? (you're posting misses out the 'n' in principalsQuesry, i.e. pricipalsQuery)

Sean

[mozheyko_d]

Thank you, very much !!!

I copy 'pricipalQuery' string from some message of this forum, and when i correct it to priNcipalQuery all is works !!!

[sradford]

My pleasure

- with code one often gets too close to notice simple things like that (and we all keep doing it no matter how many years of coding!)

Good luck,

Sean