My Windows environment is Windows 8.1, Oracle Java 1.7.0_67 64 Bit, and TomEE
1.7.1 Plus.
MySql Community 5.6.21 using mysql-connector-java-5.1.33-bin.jar.
My login.config:
SQLLoginApp {
org.apache.openejb.core.security.jaas.SQLLoginModule required
dataSourceName="jdbc/myDatasourceUnmanaged"
userSelect="select `email_address` as user_name, `password` as
user_pass from `user` inner join `user_email_addresses` on uuid = user where
`user_email_addresses`.is_primary = 1 and `email_address` = ?"
groupSelect="select `email_address` as user_name, role as role_name
from `user` inner join `user_email_addresses` on uuid = user where
`user_email_addresses`.is_primary = 1 and `email_address` = ?";
};
tomee.xml
<Resource id="jdbc/myDatasourceUnmanaged" type="DataSource">
JdbcDriver com.mysql.jdbc.Driver
JdbcUrl jdbc:mysql://localhost:3306/mySchema
UserName <username>
Password <password>
JtaManaged false
</Resource>
Realm in server.xml Catalina Engine:
<Realm className="org.apache.catalina.realm.JAASRealm"
appName="SQLLoginApp"
userClassNames="org.apache.openejb.core.security.jaas.UserPrincipal"
roleClassNames="org.apache.openejb.core.security.jaas.GroupPrincipal">
</Realm>
The attachment is the thread jump using jstack -F <pid>.
tomee.txt
<http://tomee-openejb.979440.n4.nabble.com/file/n4672449/tomee.txt>
--
View this message in context:
http://tomee-openejb.979440.n4.nabble.com/Problems-with-shutting-down-TomEE-1-7-1-using-the-JAAS-module-SQLLoginModule-tp4672430p4672449.html
Sent from the TomEE Users mailing list archive at Nabble.com.
