Sakai Setup Issu

[Nikunj Parmar]

Hi Guys,

I setup sakai-demo-10.5 on linux sever (1 GB RAM) with my sql database.

Its working fine for HSQLDB but when I switched it to MYSQL it is throwing CacheManager has been shut down error.I investigated the log and found that WarehouseTask is throwing mysql connection error.Below is mysql configuration setting  and it created database tables etc.

Could you please help me to fix this issue ? Do we need to configure different username and password properties for WarehouseTask ? Thanks a million.

ven...@org.sakaiproject.db.api.SqlService=mysql

driverC...@javax.sql.BaseDataSource=com.mysql.jdbc.Driver

hibernate.dialect=org.hibernate.dialect.MySQL5InnoDBDialect

u...@javax.sql.BaseDataSource=jdbc:mysql://localhost:3306/sakai_demo?useUnicode=true&characterEncoding=UTF-8

validat...@javax.sql.BaseDataSource=select 1 from DUAL

defaultTransacti...@javax.sql.BaseDataSource=TRANSACTION_READ_COMMITTED

user...@javax.sql.DataSource=XYZ

pass...@javax.sql.DataSource=XYZ

ERROR 1 : 

org.sakaiproject.portal.api.PortalHandlerException: java.lang.IllegalStateException: The CacheManager has been shut down. It can no longer be used.

    at org.sakaiproject.portal.charon.SkinnableCharonPortal.doGet(SkinnableCharonPortal.java:901)

ERROR 2 : 

2015-07-26 15:37:07,747 ERROR localhost-startStop-1 org.sakaiproject.util.NoisierDefaultListableBeanFactory - Failed to preinstantiate the singleton named org.sakaiproject.warehouse.service.WarehouseTask.wizard. Destroying all Spring beans.

org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'org.sakaiproject.warehouse.service.WarehouseTask.wizard' defined in file [/home/tommy/sakai-demo-10.5/components/osp-warehouse-component/WEB-INF/wizard-components.xml]: Invocation of init method failed; nested exception is java.lang.RuntimeException: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Access denied for user ''@'localhost' to database 'sakaifinal'

at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1482)

at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:521)

at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:458)

at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:295)

at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:223)

at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:292)

at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:194)

at org.sakaiproject.util.NoisierDefaultListableBeanFactory.preInstantiateSingletons(NoisierDefaultListableBeanFactory.java:73)

at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:932)

at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:479)

at org.sakaiproject.component.impl.SpringCompMgr.init(SpringCompMgr.java:160)

at org.sakaiproject.component.cover.ComponentManager.getInstance(ComponentManager.java:106)

at org.sakaiproject.component.cover.ComponentManager.get(ComponentManager.java:117)

at org.sakaiproject.component.cover.ServerConfigurationService.getInstance(ServerConfigurationService.java:52)

at org.sakaiproject.component.cover.ServerConfigurationService.getSakaiHomePath(ServerConfigurationService.java:173)

at org.sakaiproject.util.ToolListener.contextInitialized(ToolListener.java:66)

at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:5016)

at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5524)

at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)

at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:901)

at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:877)

at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:649)

at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:1081)

at org.apache.catalina.startup.HostConfig$DeployWar.run(HostConfig.java:1877)

at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)

at java.util.concurrent.FutureTask.run(Unknown Source)

at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)

at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)

at java.lang.Thread.run(Unknown Source)

Caused by: java.lang.RuntimeException: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Access denied for user ''@'localhost' to database 'sakaifinal'

at org.sakaiproject.warehouse.impl.BaseWarehouseTask.init(BaseWarehouseTask.java:104)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)

at java.lang.reflect.Method.invoke(Unknown Source)

at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeCustomInitMethod(AbstractAutowireCapableBeanFactory.java:1608)

at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1549)

at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1479)

... 28 more

Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Access denied for user ''@'localhost' to database 'sakaifinal'

at sun.reflect.GeneratedConstructorAccessor63.newInstance(Unknown Source)

at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)

at java.lang.reflect.Constructor.newInstance(Unknown Source)

at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)

at com.mysql.jdbc.Util.getInstance(Util.java:386)

at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1054)

at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4237)

at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4169)

at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:928)

at com.mysql.jdbc.MysqlIO.proceedHandshakeWithPluggableAuthentication(MysqlIO.java:1750)

at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1290)

at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2493)

at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2526)

at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2311)

at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:834)

at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47)

at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)

at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)

at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)

at java.lang.reflect.Constructor.newInstance(Unknown Source)

at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)

at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:416)

at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:347)

at org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:38)

at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:582)

at org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:1181)

at org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:106)

at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:1044)

at org.sakaiproject.warehouse.impl.BaseWarehouseTask.init(BaseWarehouseTask.java:95)

... 35 more

java.lang.Exception: traceback

at org.sakaiproject.util.NoisierDefaultListableBeanFactory.destroySingletons(NoisierDefaultListableBeanFactory.java:94)

at org.sakaiproject.util.NoisierDefaultListableBeanFactory.preInstantiateSingletons(NoisierDefaultListableBeanFactory.java:83)

at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:932)

at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:479)

at org.sakaiproject.component.impl.SpringCompMgr.init(SpringCompMgr.java:160)

at org.sakaiproject.component.cover.ComponentManager.getInstance(ComponentManager.java:106)

at org.sakaiproject.component.cover.ComponentManager.get(ComponentManager.java:117)

at org.sakaiproject.component.cover.ServerConfigurationService.getInstance(ServerConfigurationService.java:52)

at org.sakaiproject.component.cover.ServerConfigurationService.getSakaiHomePath(ServerConfigurationService.java:173)

at org.sakaiproject.util.ToolListener.contextInitialized(ToolListener.java:66)

at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:5016)

at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5524)

at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)

at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:901)

at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:877)

at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:649)

at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:1081)

at org.apache.catalina.startup.HostConfig$DeployWar.run(HostConfig.java:1877)

at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)

at java.util.concurrent.FutureTask.run(Unknown Source)

at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)

at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)

at java.lang.Thread.run(Unknown Source)

[Brian Jones]

What did you create the mysql schema name as? Seems like differing
information:

>
u...@javax.sql.BaseDataSource=jdbc:mysql://localhost:3306/sakai_demo?useUnicode=true&characterEncoding=UTF-8

schema name here is "sakai_demo", but in the stacktrace you pasted:

> for user ''@'localhost' to database 'sakaifinal'

schema name mentioned here is "sakaifinal".


Brian Jones
Programmer/Analyst
Information Technology Services
Support Services Building, Suite 4300
Western University
(519) 661-2111 x86969
bjon...@uwo.ca

On 2015-07-27 04:07 PM, Nikunj Parmar wrote:
> Hi Guys,
>
> I setup sakai-demo-10.5 on linux sever (1 GB RAM) with my sql database.
> Its working fine for HSQLDB but when I switched it to MYSQL it is
> throwing CacheManager has been shut down error.I investigated the log
> and found that WarehouseTask is throwing mysql connection error.Below is
> mysql configuration setting and it created database tables etc.
> Could you please help me to fix this issue ? Do we need to configure
> different username and password properties for WarehouseTask ? Thanks a
> million.
>
>
>
> ven...@org.sakaiproject.db.api.SqlService=mysql
> driverC...@javax.sql.BaseDataSource=com.mysql.jdbc.Driver
> hibernate.dialect=org.hibernate.dialect.MySQL5InnoDBDialect
> u...@javax.sql.BaseDataSource=jdbc:mysql://localhost:3306/sakai_demo?useUnicode=true&characterEncoding=UTF-8
> validat...@javax.sql.BaseDataSource=select 1 from DUAL
> defaultTransacti...@javax.sql.BaseDataSource=TRANSACTION_READ_COMMITTED
> user...@javax.sql.DataSource=XYZ
> pass...@javax.sql.DataSource=XYZ
>
>
>

> *ERROR 1 : *

>
>
> org.sakaiproject.portal.api.PortalHandlerException:
> java.lang.IllegalStateException: The CacheManager has been shut down. It
> can no longer be used.
> at
> org.sakaiproject.portal.charon.SkinnableCharonPortal.doGet(SkinnableCharonPortal.java:901)
>
>

> *ERROR 2 : *

> --
> You received this message because you are subscribed to the Google
> Groups "Sakai Development" group.
> To unsubscribe from this group and stop receiving emails from it, send
> an email to sakai-dev+...@apereo.org
> <mailto:sakai-dev+...@apereo.org>.
> To post to this group, send email to saka...@apereo.org
> <mailto:saka...@apereo.org>.
> Visit this group at http://groups.google.com/a/apereo.org/group/sakai-dev/.

[Brian Jones]

Also, user name in stacktrace is empty. Be sure you have set these two
properties to the username and password you created for the mysql database:

> user...@javax.sql.DataSource=XYZ
> pass...@javax.sql.DataSource=XYZ

Brian Jones
Programmer/Analyst
Information Technology Services
Support Services Building, Suite 4300
Western University
(519) 661-2111 x86969
bjon...@uwo.ca

[Earle Nietzel]

I think this line in your stack trace says it all!

Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Access denied for user ''@'localhost' to database 'sakaifinal'

notice there is no user specified here ''@'localhost', should be more like '<mysql user goes here>'@'localhost'

-earle

To unsubscribe from this group and stop receiving emails from it, send an email to sakai-dev+...@apereo.org.
To post to this group, send email to saka...@apereo.org.

[Nikunj]

Thanks a million for reply.I have correct db configuration but still getting below error when I open home page.Please suggest.

org.sakaiproject.portal.api.PortalHandlerException: java.lang.IllegalStateException: The CacheManager has been shut down. It can no longer be used.

    at org.sakaiproject.portal.charon.SkinnableCharonPortal.doGet(SkinnableCharonPortal.java:901)

Regards,

Nikunj Parmar

[Steve Swinsburg]

That error is likely one in a long list. Check the entire log from the most recent startup, it will give you the info you need. Do you have the MySQL driver class installed in Tomcat?

[Nikunj]

Yes it has mysql and also created database.In windows local its works fine but on Linux server throwing cache issue.

Regards,

Nikunj Parmar

[Steve Swinsburg]

Stop Sakai, delete logs, start up and send the entire log file.

sent from my mobile device

[Matthew Jones]

It's probably some issue with how you have mysql setup.

You maybe don't have the database setup to connect remotely or you don't have the access controls setup right

http://stackoverflow.com/a/16288118/3708872

Or maybe you have an anonymous user that's matching first 

http://stackoverflow.com/a/11216911/3708872

Can you connect on the command line? It might be an issue of ipv6 verses ipv4.

Maybe this is useful http://serverfault.com/a/295300/260441

Try changing the address to 127.0.0.1 instead of locathost and seeing if it connects.

[Nikunj]

Hi Guys,

I taken latest code from github and build sakai then deploy on linux server.

I am able to login as admin but some functionality is not working like : work site setup.It is showing could not open hibernate session.

I also checked log and found  - Failed to obtain DB connection from data source 'myDS': java.sql.SQLException: Pool has been shutdown.Could you please where I need to configure myDS ? 

Below is mysql settings and please find attached log having more details.

Thanks a million for your help.Please suggest me solution to fix this problem.

ven...@org.sakaiproject.db.api.SqlService=mysql

driverC...@javax.sql.BaseDataSource=com.mysql.jdbc.Driver

hibernate.dialect=org.hibernate.dialect.MySQL5InnoDBDialect

u...@javax.sql.BaseDataSource=jdbc:mysql://localhost:3306/sakaigit?useUnicode=true&characterEncoding=UTF-8

validat...@javax.sql.BaseDataSource=select 1 from DUAL

defaultTransacti...@javax.sql.BaseDataSource=TRANSACTION_READ_COMMITTED

user...@javax.sql.DataSource=nikunj

pass...@javax.sql.DataSource=nikunj123 

  

aused by: java.lang.reflect.InvocationTargetException
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
caused by: org.springframework.transaction.CannotCreateTransactionException: Could not open Hibernate Session for transaction; nested exception is java.lang.NullPointerException
    at org.springframework.transaction.support.AbstractPlatformTransactionManager.getTransaction(AbstractPlatformTransactionManager.java:372)
caused by: java.lang.NullPointerException

[Nikunj]

Thanks Guys.Please ignore below issue.Its working fine now..

Regards,

Nikunj Parmar

--

[gokhan ulucay]

Hi Nikunj,

i have same problem, How did you solve the problem please help me.

1 Ağustos 2015 Cumartesi 01:21:15 UTC+3 tarihinde Nikunj Parmar yazdı:

Thanks Guys.Please ignore below issue.Its working fine now..

Regards,

Nikunj Parmar

On Mon, Jul 27, 2015 at 9:07 PM, Nikunj Parmar <nikun...@gmail.com> wrote:

Hi Guys,

I setup sakai-demo-10.5 on linux sever (1 GB RAM) with my sql database.

Its working fine for HSQLDB but when I switched it to MYSQL it is throwing CacheManager has been shut down error.I investigated the log and found that WarehouseTask is throwing mysql connection error.Below is mysql configuration setting  and it created database tables etc.

Could you please help me to fix this issue ? Do we need to configure different username and password properties for WarehouseTask ? Thanks a million.

ven...@org.sakaiproject.db.api.SqlService=mysql

driverC...@javax.sql.BaseDataSource=com.mysql.jdbc.Driver

hibernate.dialect=org.hibernate.dialect.MySQL5InnoDBDialect

u...@javax.sql.BaseDataSource=jdbc:mysql://localhost:3306/sakai_demo?useUnicode=true&characterEncoding=UTF-8

validat...@javax.sql.BaseDataSource=select 1 from DUAL

defaultTransactionIsolationStri...@javax.sql.BaseDataSource=TRANSACTION_READ_COMMITTED

user...@javax.sql.DataSource=XYZ

pass...@javax.sql.DataSource=XYZ