jboss mysql authentication setup

IN PROGRESS
Bids
2
Avg Bid (USD)
$103
Project Budget (USD)
$30 - $150

Project Description:
Hi,
we need a JBOSS expert! If you are not please do not bid on this post.

we have a jboss server (4.2.3 GA) and need to

1. install the mysql connector properly. (we put it but not sure if it is right)
2. Configure jboss to use an external mysql for authentication.
3. configure the login-config.xml to use mysql for authentication.
4. Test login succesfully from an existing login page which uses

The application used to login with ldap, but we want to login with mysql.
Code in login-config.xml was:



com.sun.jndi.ldap.LdapCtxFactory
ldap://10.5.1.2:3268
simple
@cys.org.cy
sAMAccountName
false
memberOf
true
false
name
CN=Users,DC=cys,DC=org,DC=cy
guest




Replaced it with:

java:/MySqlDS
SELECT password FROM usermaster WHERE email=?
SELECT role, 'Roles' FROM usrrolesview WHERE email=?


Jboss starts but we are getting these errors:

2013-01-25 18:32:55,858 ERROR [org.jboss.security.auth.spi.UsersRolesLoginModule] Failed to load users/passwords/role files
java.io.IOException: No properties file: users.properties or defaults: defaultUsers.properties found
2013-01-25 18:32:55,863 WARN [org.apache.catalina.realm.JAASRealm] Login exception authenticating username "nikolas"
javax.security.auth.login.LoginException: Missing users.properties file.

We are looking to have this done ASAP.

Thanks,
Michael

Additional Project Description:
01/25/2013 at 18:22 CET
Please check uploaded file for the code we added.

Skills required:
Engineering, MySQL
Additional Files: login.xml.txt
About the employer:
Verified
Public Clarification Board
Bids are hidden by the project creator. Log in as the employer to view bids or to bid on this project.
You will not be able to bid on this project if you are not qualified in one of the job categories. To see your qualifications click here.


$ 125
in 2 days
$ 80
in 2 days