JBoss MySQL Authentication
belfast Aug 4, 2003 6:22 PMI have the jboss docs (which are pretty good) but they don't seem to be helping me figure out my error in using MySQL (4.1) with JBoss3.2rc1/tomcat4.1.24 (on XP Pro)
I have followed all that is written, and my struts application (which works fine on tomcat alone) doesn't work (with auth)
I am using form based auth with /j_security_check
Any hints would be great, as the logs don't seem to be helping me at all.
thanks in advance...
my mysql-ds.xml file
-------------------
<local-tx-datasource>
<jndi-name>jbossDS</jndi-name>
<connection-url>jdbc:mysql://localhost:3306/jbossdb</connection-url>
<driver-class>org.gjt.mm.mysql.Driver</driver-class>
<user-name>jboss</user-name>
password
</local-tx-datasource>
--------------------
my login-config.xml (part)
<application-policy name = "testwebapp">
<login-module code="org.jboss.security.auth.spi.DatabaseServerLoginModule" flag = "required">
<module-option name = "dsJndiName">java:/jbossDS</module-option>
<module-option name = "principalsQuery">select password from users where Username=?</module-option>
<module-option name = "rolesQuery">select Role form userroles where Username=?</module-option>
</login-module>
</application-policy>
------------------
my database
CREATE TABLE roles (
Role varchar(64) NOT NULL default '',
Description mediumtext,
PRIMARY KEY (Role)
) TYPE=MyISAM;
--
-- Table structure for table 'userroles'
--
CREATE TABLE userroles (
Username varchar(64) NOT NULL default '',
Role varchar(64) NOT NULL default ''
) TYPE=MyISAM;
--
-- Table structure for table 'users'
--
CREATE TABLE users (
Username varchar(64) NOT NULL default '',
Password varchar(64) NOT NULL default '',
FirstName varchar(64) NOT NULL default '',
LastName varchar(64) NOT NULL default '',
Email varchar(255) NOT NULL default '',
Extension varchar(16) default NULL,
PRIMARY KEY (Username)
) TYPE=MyISAM;
---- my jboss web
<jboss-web>
<!-- Uncomment the security-domain to enable security. You will
need to edit the htmladaptor login configuration to setup the
login modules used to authentication users.
-->
<security-domain>java:/jaas/testwebapp</security-domain>
</jboss-web>