Jdbc Realm with MySQL.

[ipas <mi...@gmail.com>]

Hi, 
I am trying to use Shiro JdbcRealm, configured web.xml as below :

<filter>
		<filter-name>ShiroFilter</filter-name>
		<filter-class>org.apache.shiro.web.servlet.IniShiroFilter</filter-class>
		<init-param>
<param-name>config</param-name>
<param-value>
[main]
  jdbcRealm = org.apache.shiro.realm.jdbc.JdbcRealm

                jdbcRealm.permissionsLookupEnabled = true

                jdbcRealm.authenticationQuery = "SELECT password FROM users
WHERE user_name = ?"

                jdbcRealm.userRolesQuery = "SELECT role_name FROM user_roles
WHERE user_name = ?"

                jdbcRealm.permissionsQuery = "SELECT permission FROM
roles_permissions WHERE role_name = ?"

                ds = com.mysql.jdbc.Driver
                ds.serverName = localhost
                ds.user = root
                ds.password = 12345
                ds.databaseName = iaau
                coreFreightRealm.dataSource = $ds
</param-value>
</init-param>
	</filter>

But my server is giving me following stack trace : 

SEVERE: Exception starting filter ShiroFilter
javax.servlet.ServletException:
org.apache.shiro.config.ConfigurationException: Property 'serverName' does
not exist for object of type com.mysql.jdbc.Driver.
	at
org.apache.shiro.web.servlet.AbstractFilter.init(AbstractFilter.java:105)
	at
org.apache.catalina.core.ApplicationFilterConfig.initFilter(ApplicationFilterConfig.java:273)
	at
org.apache.catalina.core.ApplicationFilterConfig.getFilter(ApplicationFilterConfig.java:254)
	at
org.apache.catalina.core.ApplicationFilterConfig.setFilterDef(ApplicationFilterConfig.java:372)
	at
org.apache.catalina.core.ApplicationFilterConfig.<init>(ApplicationFilterConfig.java:98)
	at
org.apache.catalina.core.StandardContext.filterStart(StandardContext.java:4542)
	at
org.apache.catalina.core.StandardContext$2.call(StandardContext.java:5220)
	at
org.apache.catalina.core.StandardContext$2.call(StandardContext.java:5215)
	at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)
	at java.util.concurrent.FutureTask.run(FutureTask.java:138)
	at
java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
	at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
	at java.lang.Thread.run(Thread.java:619)
Caused by: org.apache.shiro.config.ConfigurationException: Property
'serverName' does not exist for object of type com.mysql.jdbc.Driver.
	at
org.apache.shiro.config.ReflectionBuilder.isTypedProperty(ReflectionBuilder.java:243)
	at
org.apache.shiro.config.ReflectionBuilder.applyProperty(ReflectionBuilder.java:347)
	at
org.apache.shiro.config.ReflectionBuilder.applySingleProperty(ReflectionBuilder.java:198)
	at
org.apache.shiro.config.ReflectionBuilder.applyProperty(ReflectionBuilder.java:159)
	at
org.apache.shiro.config.ReflectionBuilder.buildObjects(ReflectionBuilder.java:119)
	at
org.apache.shiro.config.IniSecurityManagerFactory.buildInstances(IniSecurityManagerFactory.java:170)
	at
org.apache.shiro.config.IniSecurityManagerFactory.createSecurityManager(IniSecurityManagerFactory.java:119)
	at
org.apache.shiro.config.IniSecurityManagerFactory.createSecurityManager(IniSecurityManagerFactory.java:97)
	at
org.apache.shiro.config.IniSecurityManagerFactory.createInstance(IniSecurityManagerFactory.java:83)
	at
org.apache.shiro.config.IniSecurityManagerFactory.createInstance(IniSecurityManagerFactory.java:41)
	at
org.apache.shiro.config.IniFactorySupport.createInstance(IniFactorySupport.java:123)
	at
org.apache.shiro.util.AbstractFactory.getInstance(AbstractFactory.java:47)
	at
org.apache.shiro.web.servlet.IniShiroFilter.applySecurityManager(IniShiroFilter.java:260)
	at
org.apache.shiro.web.servlet.IniShiroFilter.configure(IniShiroFilter.java:228)
	at
org.apache.shiro.web.servlet.IniShiroFilter.init(IniShiroFilter.java:190)
	at
org.apache.shiro.web.servlet.AbstractShiroFilter.onFilterConfigSet(AbstractShiroFilter.java:152)
	at org.apache.shiro.web.servlet.AbstractFilter.init(AbstractFilter.java:97)
	... 12 more 

Do you have any ideas regarding this error.

Thank you.
Mirlan

--
View this message in context: http://shiro-user.582556.n2.nabble.com/Jdbc-Realm-with-MySQL-tp6519593p6519593.html
Sent from the Shiro User mailing list archive at Nabble.com.