You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@shiro.apache.org by yuwei <yu...@hotmail.com> on 2017/06/03 13:04:37 UTC
Some errors when using tomcat database connection pool
Hi guys,
I tried to configure shiro.ini to make shiro using tomcat database
connection pool.
The configuration is as below,
datasrc = org.apache.shiro.jndi.JndiObjectFactory
datasrc.requiredType = javax.sql.DataSource
datasrc.resourceName = mysql/ustudy
datasrc.resourceRef = true
datasrc.user = root
datasrc.password = mysql
datasrc.url =
jdbc:mysql://192.168.0.107:13306/ustudy?characterEncoding=UTF-8
datasrc.driverClassName = com.mysql.jdbc.Driver
realm = org.apache.shiro.realm.jdbc.JdbcRealm
realm.permissionsLookupEnabled = true
realm.dataSource = $datasrc
realm.authenticationQuery = select usr_passwd from sec_users where loginname
= ?
realm.credentialsMatcher = $pwMatcher
securityManager.realms = $realm
tomcat failed to enable shiro and I got following errors:
03-Jun-2017 11:41:52.930 INFO [main]
org.apache.catalina.core.ApplicationContext.log Initializing Shiro
environment
03-Jun-2017 11:41:53.130 SEVERE [main]
org.apache.catalina.core.StandardContext.listenerStart Exception sending
context initialized event to listener instance of class
[org.apache.shiro.web.env.EnvironmentLoaderListener]
org.apache.shiro.config.ConfigurationException: Property 'user' does not
exist for object of type org.apache.shiro.jndi.JndiObjectFactory.
at
org.apache.shiro.config.ReflectionBuilder.isTypedProperty(ReflectionBuilder.java:255)
at
org.apache.shiro.config.ReflectionBuilder.applyProperty(ReflectionBuilder.java:544)
at
org.apache.shiro.config.ReflectionBuilder.applySingleProperty(ReflectionBuilder.java:206)
at
org.apache.shiro.config.ReflectionBuilder.applyProperty(ReflectionBuilder.java:167)
at
org.apache.shiro.config.ReflectionBuilder.buildObjects(ReflectionBuilder.java:124)
at
org.apache.shiro.config.IniSecurityManagerFactory.buildInstances(IniSecurityManagerFactory.java:161)
at
org.apache.shiro.config.IniSecurityManagerFactory.createSecurityManager(IniSecurityManagerFactory.java:124)
at
org.apache.shiro.config.IniSecurityManagerFactory.createSecurityManager(IniSecurityManagerFactory.java:102)
at
org.apache.shiro.config.IniSecurityManagerFactory.createInstance(IniSecurityManagerFactory.java:88)
at
org.apache.shiro.config.IniSecurityManagerFactory.createInstance(IniSecurityManagerFactory.java:46)
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.env.IniWebEnvironment.createWebSecurityManager(IniWebEnvironment.java:203)
at
org.apache.shiro.web.env.IniWebEnvironment.configure(IniWebEnvironment.java:99)
at
org.apache.shiro.web.env.IniWebEnvironment.init(IniWebEnvironment.java:92)
at org.apache.shiro.util.LifecycleUtils.init(LifecycleUtils.java:45)
at org.apache.shiro.util.LifecycleUtils.init(LifecycleUtils.java:40)
at
org.apache.shiro.web.env.EnvironmentLoader.createEnvironment(EnvironmentLoader.java:221)
at
org.apache.shiro.web.env.EnvironmentLoader.initEnvironment(EnvironmentLoader.java:133)
at
org.apache.shiro.web.env.EnvironmentLoaderListener.contextInitialized(EnvironmentLoaderListener.java:58)
at
org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4734)
Maybe this is only configuration problem.
Could you please help to have a look?
Thx.
--
View this message in context: http://shiro-user.582556.n2.nabble.com/Some-errors-when-using-tomcat-database-connection-pool-tp7581595.html
Sent from the Shiro User mailing list archive at Nabble.com.
Re: Some errors when using tomcat database connection pool
Posted by Brian Demers <br...@gmail.com>.
It looks like you are trying to use a JNDI lookup an explicit configuration.
Try something like this: https://gist.github.com/dominicfarr/9637357
On Sat, Jun 3, 2017 at 9:04 AM, yuwei <yu...@hotmail.com> wrote:
> Hi guys,
> I tried to configure shiro.ini to make shiro using tomcat database
> connection pool.
> The configuration is as below,
> datasrc = org.apache.shiro.jndi.JndiObjectFactory
> datasrc.requiredType = javax.sql.DataSource
> datasrc.resourceName = mysql/ustudy
> datasrc.resourceRef = true
> datasrc.user = root
> datasrc.password = mysql
> datasrc.url =
> jdbc:mysql://192.168.0.107:13306/ustudy?characterEncoding=UTF-8
> datasrc.driverClassName = com.mysql.jdbc.Driver
>
> realm = org.apache.shiro.realm.jdbc.JdbcRealm
> realm.permissionsLookupEnabled = true
> realm.dataSource = $datasrc
> realm.authenticationQuery = select usr_passwd from sec_users where
> loginname
> = ?
> realm.credentialsMatcher = $pwMatcher
>
> securityManager.realms = $realm
>
> tomcat failed to enable shiro and I got following errors:
> 03-Jun-2017 11:41:52.930 INFO [main]
> org.apache.catalina.core.ApplicationContext.log Initializing Shiro
> environment
> 03-Jun-2017 11:41:53.130 SEVERE [main]
> org.apache.catalina.core.StandardContext.listenerStart Exception sending
> context initialized event to listener instance of class
> [org.apache.shiro.web.env.EnvironmentLoaderListener]
> org.apache.shiro.config.ConfigurationException: Property 'user' does not
> exist for object of type org.apache.shiro.jndi.JndiObjectFactory.
> at
> org.apache.shiro.config.ReflectionBuilder.isTypedProperty(
> ReflectionBuilder.java:255)
> at
> org.apache.shiro.config.ReflectionBuilder.applyProperty(
> ReflectionBuilder.java:544)
> at
> org.apache.shiro.config.ReflectionBuilder.applySingleProperty(
> ReflectionBuilder.java:206)
> at
> org.apache.shiro.config.ReflectionBuilder.applyProperty(
> ReflectionBuilder.java:167)
> at
> org.apache.shiro.config.ReflectionBuilder.buildObjects(
> ReflectionBuilder.java:124)
> at
> org.apache.shiro.config.IniSecurityManagerFactory.buildInstances(
> IniSecurityManagerFactory.java:161)
> at
> org.apache.shiro.config.IniSecurityManagerFactory.createSecurityManager(
> IniSecurityManagerFactory.java:124)
> at
> org.apache.shiro.config.IniSecurityManagerFactory.createSecurityManager(
> IniSecurityManagerFactory.java:102)
> at
> org.apache.shiro.config.IniSecurityManagerFactory.createInstance(
> IniSecurityManagerFactory.java:88)
> at
> org.apache.shiro.config.IniSecurityManagerFactory.createInstance(
> IniSecurityManagerFactory.java:46)
> 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.env.IniWebEnvironment.createWebSecurityManager(
> IniWebEnvironment.java:203)
> at
> org.apache.shiro.web.env.IniWebEnvironment.configure(
> IniWebEnvironment.java:99)
> at
> org.apache.shiro.web.env.IniWebEnvironment.init(IniWebEnvironment.java:92)
> at org.apache.shiro.util.LifecycleUtils.init(
> LifecycleUtils.java:45)
> at org.apache.shiro.util.LifecycleUtils.init(
> LifecycleUtils.java:40)
> at
> org.apache.shiro.web.env.EnvironmentLoader.createEnvironment(
> EnvironmentLoader.java:221)
> at
> org.apache.shiro.web.env.EnvironmentLoader.initEnvironment(
> EnvironmentLoader.java:133)
> at
> org.apache.shiro.web.env.EnvironmentLoaderListener.contextInitialized(
> EnvironmentLoaderListener.java:58)
> at
> org.apache.catalina.core.StandardContext.listenerStart(
> StandardContext.java:4734)
>
> Maybe this is only configuration problem.
> Could you please help to have a look?
> Thx.
>
>
>
> --
> View this message in context: http://shiro-user.582556.n2.
> nabble.com/Some-errors-when-using-tomcat-database-
> connection-pool-tp7581595.html
> Sent from the Shiro User mailing list archive at Nabble.com.
>