FileNotFoundException: asqatasun.conf (Permission denied)

asqatasun.conf
acl
Tags: #<Tag:0x00007fe7b4490f90> #<Tag:0x00007fe7b4490e28>

#1

@mfaure The log file content is:

Oct 24, 2016 1:06:52 PM org.apache.catalina.startup.ClassLoaderFactory validateFile
WARNING: Problem with directory [/usr/share/tomcat7/common/classes], exists: [false], isDirectory: [false], canRead: [false]
Oct 24, 2016 1:06:52 PM org.apache.catalina.startup.ClassLoaderFactory validateFile
WARNING: Problem with directory [/usr/share/tomcat7/common], exists: [false], isDirectory: [false], canRead: [false]
Oct 24, 2016 1:06:53 PM org.apache.catalina.startup.ClassLoaderFactory validateFile
WARNING: Problem with directory [/usr/share/tomcat7/server/classes], exists: [false], isDirectory: [false], canRead: [false]
Oct 24, 2016 1:06:53 PM org.apache.catalina.startup.ClassLoaderFactory validateFile
WARNING: Problem with directory [/usr/share/tomcat7/server], exists: [false], isDirectory: [false], canRead: [false]
Oct 24, 2016 1:06:53 PM org.apache.catalina.startup.ClassLoaderFactory validateFile
WARNING: Problem with directory [/usr/share/tomcat7/shared/classes], exists: [false], isDirectory: [false], canRead: [false]
Oct 24, 2016 1:06:53 PM org.apache.catalina.startup.ClassLoaderFactory validateFile
WARNING: Problem with directory [/usr/share/tomcat7/shared], exists: [false], isDirectory: [false], canRead: [false]
Oct 24, 2016 1:06:59 PM org.apache.coyote.AbstractProtocol init
INFO: Initializing ProtocolHandler ["http-bio-8080"]
Oct 24, 2016 1:07:00 PM org.apache.catalina.startup.Catalina load
INFO: Initialization processed in 5529 ms
Oct 24, 2016 1:07:00 PM org.apache.catalina.core.StandardService startInternal
INFO: Starting service Catalina
Oct 24, 2016 1:07:00 PM org.apache.catalina.core.StandardEngine startInternal
INFO: Starting Servlet Engine: Apache Tomcat/7.0.52 (Ubuntu)
Oct 24, 2016 1:07:00 PM org.apache.catalina.startup.HostConfig deployDirectory
INFO: Deploying web application directory /var/lib/tomcat7/webapps/asqatasun
Oct 24, 2016 1:07:45 PM org.apache.catalina.core.StandardContext startInternal
SEVERE: Error listenerStart
Oct 24, 2016 1:07:45 PM org.apache.catalina.core.StandardContext startInternal
SEVERE: Context [/asqatasun] startup failed due to previous errors
Oct 24, 2016 1:07:45 PM org.apache.catalina.startup.HostConfig deployDirectory
INFO: Deploying web application directory /var/lib/tomcat7/webapps/ROOT
Oct 24, 2016 1:07:46 PM org.apache.coyote.AbstractProtocol start
INFO: Starting ProtocolHandler ["http-bio-8080"]
Oct 24, 2016 1:07:46 PM org.apache.catalina.startup.Catalina start
INFO: Server startup in 46404 ms

#2

OK, this is /var/log/catalina.out. Do you have the /var/log/asqatasun/asqatasun.log ?


#3

Yes i do:

24-10-2016 13:07:45:740 0    ERROR org.springframework.web.context.ContextLoader  - Context initialization failed
org.springframework.beans.factory.BeanInitializationException: Could not load properties; nested exception is java.io.FileNotFoundException: /etc/asqatasun/asqatasun.conf (Permission denied)
    at org.springframework.beans.factory.config.PropertyResourceConfigurer.postProcessBeanFactory(PropertyResourceConfigurer.java:87)
    at org.springframework.context.support.AbstractApplicationContext.invokeBeanFactoryPostProcessors(AbstractApplicationContext.java:686)
    at org.springframework.context.support.AbstractApplicationContext.invokeBeanFactoryPostProcessors(AbstractApplicationContext.java:661)
    at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:451)
    at org.springframework.web.context.ContextLoader.configureAndRefreshWebApplicationContext(ContextLoader.java:383)
    at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:283)
    at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:111)
    at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:5010)
    at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5504)
    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:632)
    at org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:1229)
    at org.apache.catalina.startup.HostConfig$DeployDirectory.run(HostConfig.java:1875)
    at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)
    at java.util.concurrent.FutureTask.run(FutureTask.java:262)
    at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
    at java.lang.Thread.run(Thread.java:745)
Caused by: java.io.FileNotFoundException: /etc/asqatasun/asqatasun.conf (Permission denied)
    at java.io.FileInputStream.open(Native Method)
    at java.io.FileInputStream.<init>(FileInputStream.java:146)
    at java.io.FileInputStream.<init>(FileInputStream.java:101)
    at sun.net.www.protocol.file.FileURLConnection.connect(FileURLConnection.java:90)
    at sun.net.www.protocol.file.FileURLConnection.getInputStream(FileURLConnection.java:188)
    at org.springframework.core.io.UrlResource.getInputStream(UrlResource.java:125)
    at org.springframework.core.io.support.PropertiesLoaderSupport.loadProperties(PropertiesLoaderSupport.java:181)
    at org.springframework.core.io.support.PropertiesLoaderSupport.mergeProperties(PropertiesLoaderSupport.java:161)
    at org.springframework.beans.factory.config.PropertyResourceConfigurer.postProcessBeanFactory(PropertyResourceConfigurer.java:78)
    ... 19 more

#4

And var/log/tomcat7/catalina.out is now:

Oct 24, 2016 5:15:59 PM org.apache.coyote.AbstractProtocol pause
INFO: Pausing ProtocolHandler ["http-bio-8080"]
Oct 24, 2016 5:15:59 PM org.apache.catalina.core.StandardService stopInternal
INFO: Stopping service Catalina
Oct 24, 2016 5:15:59 PM org.apache.coyote.AbstractProtocol stop
INFO: Stopping ProtocolHandler ["http-bio-8080"]
Oct 24, 2016 5:15:59 PM org.apache.coyote.AbstractProtocol destroy
INFO: Destroying ProtocolHandler ["http-bio-8080"]
Oct 24, 2016 9:14:59 PM org.apache.catalina.startup.ClassLoaderFactory validateFile
WARNING: Problem with directory [/usr/share/tomcat7/common/classes], exists: [false], isDirectory: [false], canRead: [false]
Oct 24, 2016 9:14:59 PM org.apache.catalina.startup.ClassLoaderFactory validateFile
WARNING: Problem with directory [/usr/share/tomcat7/common], exists: [false], isDirectory: [false], canRead: [false]
Oct 24, 2016 9:15:00 PM org.apache.catalina.startup.ClassLoaderFactory validateFile
WARNING: Problem with directory [/usr/share/tomcat7/server/classes], exists: [false], isDirectory: [false], canRead: [false]
Oct 24, 2016 9:15:00 PM org.apache.catalina.startup.ClassLoaderFactory validateFile
WARNING: Problem with directory [/usr/share/tomcat7/server], exists: [false], isDirectory: [false], canRead: [false]
Oct 24, 2016 9:15:00 PM org.apache.catalina.startup.ClassLoaderFactory validateFile
WARNING: Problem with directory [/usr/share/tomcat7/shared/classes], exists: [false], isDirectory: [false], canRead: [false]
Oct 24, 2016 9:15:00 PM org.apache.catalina.startup.ClassLoaderFactory validateFile
WARNING: Problem with directory [/usr/share/tomcat7/shared], exists: [false], isDirectory: [false], canRead: [false]
Oct 24, 2016 9:15:05 PM org.apache.coyote.AbstractProtocol init
INFO: Initializing ProtocolHandler ["http-bio-8080"]
Oct 24, 2016 9:15:05 PM org.apache.catalina.startup.Catalina load
INFO: Initialization processed in 3835 ms
Oct 24, 2016 9:15:05 PM org.apache.catalina.core.StandardService startInternal
INFO: Starting service Catalina
Oct 24, 2016 9:15:05 PM org.apache.catalina.core.StandardEngine startInternal
INFO: Starting Servlet Engine: Apache Tomcat/7.0.52 (Ubuntu)
Oct 24, 2016 9:15:05 PM org.apache.catalina.startup.HostConfig deployDirectory
INFO: Deploying web application directory /var/lib/tomcat7/webapps/asqatasun
log4j:ERROR setFile(null,true) call failed.
java.io.FileNotFoundException: /var/log/asqatasun/asqatasun.log (Permission denied)
    at java.io.FileOutputStream.open(Native Method)
    at java.io.FileOutputStream.<init>(FileOutputStream.java:221)
    at java.io.FileOutputStream.<init>(FileOutputStream.java:142)
    at org.apache.log4j.FileAppender.setFile(FileAppender.java:294)
    at org.apache.log4j.FileAppender.activateOptions(FileAppender.java:165)
    at org.apache.log4j.DailyRollingFileAppender.activateOptions(DailyRollingFileAppender.java:223)
    at org.apache.log4j.config.PropertySetter.activate(PropertySetter.java:307)
    at org.apache.log4j.config.PropertySetter.setProperties(PropertySetter.java:172)
    at org.apache.log4j.config.PropertySetter.setProperties(PropertySetter.java:104)
    at org.apache.log4j.PropertyConfigurator.parseAppender(PropertyConfigurator.java:842)
    at org.apache.log4j.PropertyConfigurator.parseCategory(PropertyConfigurator.java:768)
    at org.apache.log4j.PropertyConfigurator.configureRootCategory(PropertyConfigurator.java:648)
    at org.apache.log4j.PropertyConfigurator.doConfigure(PropertyConfigurator.java:514)
    at org.apache.log4j.PropertyConfigurator.doConfigure(PropertyConfigurator.java:580)
    at org.apache.log4j.helpers.OptionConverter.selectAndConfigure(OptionConverter.java:526)
    at org.apache.log4j.LogManager.<clinit>(LogManager.java:127)
    at org.apache.log4j.Logger.getLogger(Logger.java:117)
    at org.asqatasun.webapp.util.webapp.ConfigPropertiesExposerListener.<clinit>(ConfigPropertiesExposerListener.java:43)
    at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
    at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
    at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
    at java.lang.reflect.Constructor.newInstance(Constructor.java:526)
    at java.lang.Class.newInstance(Class.java:383)
    at org.apache.catalina.core.DefaultInstanceManager.newInstance(DefaultInstanceManager.java:140)
    at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4925)
    at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5504)
    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:632)
    at org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:1229)
    at org.apache.catalina.startup.HostConfig$DeployDirectory.run(HostConfig.java:1875)
    at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)
    at java.util.concurrent.FutureTask.run(FutureTask.java:262)
    at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
    at java.lang.Thread.run(Thread.java:745)
log4j:ERROR Either File or DatePattern options are not set for appender [FILE_APP].
Oct 24, 2016 9:15:34 PM org.apache.catalina.core.StandardContext startInternal
SEVERE: Error listenerStart
Oct 24, 2016 9:15:35 PM org.apache.catalina.core.StandardContext startInternal
SEVERE: Context [/asqatasun] startup failed due to previous errors
Oct 24, 2016 9:15:35 PM org.apache.catalina.startup.HostConfig deployDirectory
INFO: Deploying web application directory /var/lib/tomcat7/webapps/ROOT
Oct 24, 2016 9:15:35 PM org.apache.coyote.AbstractProtocol start
INFO: Starting ProtocolHandler ["http-bio-8080"]
Oct 24, 2016 9:15:35 PM org.apache.catalina.startup.Catalina start
INFO: Server startup in 30181 ms

#5

I fixed the following error by changing the owner of asqatasun file and all of its contents

java.io.FileNotFoundException: /var/log/asqatasun/asqatasun.log (Permission denied)

but still it isn’t working…

About this error:

"Caused by: java.io.FileNotFoundException: /etc/asqatasun/asqatasun.conf (Permission denied)"

this file is free for reading and writing, so i don’t know why there is no permission.


#6

Hi @nivak91,
Can you tell us what is the result of the following command lines ?

ls -l /etc/ | grep asqatasun
ls -l /etc/asqatasun

#7

Yes of course this is the result:

 ls -l /etc/ |grep asqatasun
drwx------  2 vak  root      4096 Οκτ  24 21:47 asqatasun
 
 ls -l /etc/asqatasun
total 20
-rw-rw-rw- 1 vak root  4035 Οκτ  24 21:47 asqatasun.conf
-rw-r--r-- 1 vak root 10505 Οκτ  12 12:50 ESAPI.properties
-rw------- 1 vak root   494 Οκτ  12 12:49 uninstall.txt

#8

Hello @nivak91,

Your file /etc/asqatasun/asqatasun.conf does not have the correct owner/permissions. You may fix this, but you will certainly have other errors following. It looks like you did not use the installer, am I right ? By the way, how did you install Asqatasun ?

As it may help, here is the Install documentation


#9

Hi @mfaure! I had followed these instructions to install asqatasun and it worked just fine…now i don’t know what changed and i get this error. As i said before asqatasun.conf is readable and writeable by everyone.


#10

Maybe trying to run the code i was talking about in asqatasun API thread caused the problem?


#11

Hi @nivak91,

Just to be sure to understand, did you :

  1. try to compile from the source and then install with the result
  2. OR did you download the latest release of Asqatasun, and install it

Please make your choice :slight_smile:


#12

@mfaure, I downloaded the latest release and installed it following the instructions of the install documentation.


#13

So you do the following:

sudo chown -R tomcat7 /etc/asqatasun/ /var/log/asqatasun/ /var/tmp/asqatasun/

Restart Tomcat ('sudo service tomcat7 restart`), have a coffee in the meantime, try again, and tell us how it goes !


#14

ok @mfaure problem solved…i had already restarted tomcat7 and tried to change the rights of the folders that were not accessible but obviously i had missed something! Thanks a lot!


#15

Hey guys, again out of the blue i get status 404…and now i have to change again the owner of var/log/asqatasun to access the asqatasun.log file. Should i? Here is catalina.out:

Nov 25, 2016 5:29:09 PM org.apache.catalina.startup.ClassLoaderFactory validateFile
WARNING: Problem with directory [/usr/share/tomcat7/common/classes], exists: [false], isDirectory: [false], canRead: [false]
Nov 25, 2016 5:29:09 PM org.apache.catalina.startup.ClassLoaderFactory validateFile
WARNING: Problem with directory [/usr/share/tomcat7/common], exists: [false], isDirectory: [false], canRead: [false]
Nov 25, 2016 5:29:10 PM org.apache.catalina.startup.ClassLoaderFactory validateFile
WARNING: Problem with directory [/usr/share/tomcat7/server/classes], exists: [false], isDirectory: [false], canRead: [false]
Nov 25, 2016 5:29:10 PM org.apache.catalina.startup.ClassLoaderFactory validateFile
WARNING: Problem with directory [/usr/share/tomcat7/server], exists: [false], isDirectory: [false], canRead: [false]
Nov 25, 2016 5:29:10 PM org.apache.catalina.startup.ClassLoaderFactory validateFile
WARNING: Problem with directory [/usr/share/tomcat7/shared/classes], exists: [false], isDirectory: [false], canRead: [false]
Nov 25, 2016 5:29:10 PM org.apache.catalina.startup.ClassLoaderFactory validateFile
WARNING: Problem with directory [/usr/share/tomcat7/shared], exists: [false], isDirectory: [false], canRead: [false]
Nov 25, 2016 5:29:14 PM org.apache.coyote.AbstractProtocol init
INFO: Initializing ProtocolHandler ["http-bio-8080"]
Nov 25, 2016 5:29:14 PM org.apache.catalina.startup.Catalina load
INFO: Initialization processed in 3020 ms
Nov 25, 2016 5:29:14 PM org.apache.catalina.core.StandardService startInternal
INFO: Starting service Catalina
Nov 25, 2016 5:29:14 PM org.apache.catalina.core.StandardEngine startInternal
INFO: Starting Servlet Engine: Apache Tomcat/7.0.52 (Ubuntu)
Nov 25, 2016 5:29:14 PM org.apache.catalina.startup.HostConfig deployDirectory
INFO: Deploying web application directory /var/lib/tomcat7/webapps/asqatasun
SLF4J: Class path contains multiple SLF4J bindings.
SLF4J: Found binding in [jar:file:/var/lib/tomcat7/webapps/asqatasun/WEB-INF/lib/activemq-all-5.9.1.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: Found binding in [jar:file:/var/lib/tomcat7/webapps/asqatasun/WEB-INF/lib/slf4j-log4j12-1.5.11.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an explanation.
SLF4J: Actual binding is of type [org.slf4j.impl.Log4jLoggerFactory]
Nov 25, 2016 5:31:44 PM org.apache.catalina.core.StandardContext startInternal
SEVERE: Error listenerStart
Nov 25, 2016 5:31:44 PM org.apache.catalina.core.StandardContext startInternal
SEVERE: Context [/asqatasun] startup failed due to previous errors
Nov 25, 2016 5:31:45 PM org.apache.catalina.startup.HostConfig deployDirectory
INFO: Deploying web application directory /var/lib/tomcat7/webapps/ROOT
Nov 25, 2016 5:31:45 PM org.apache.coyote.AbstractProtocol start
INFO: Starting ProtocolHandler ["http-bio-8080"]
Nov 25, 2016 5:31:45 PM org.apache.catalina.startup.Catalina start
INFO: Server startup in 151878 ms
Nov 25, 2016 5:56:50 PM org.apache.coyote.AbstractProtocol pause
INFO: Pausing ProtocolHandler ["http-bio-8080"]
Nov 25, 2016 5:56:50 PM org.apache.catalina.core.StandardService stopInternal
INFO: Stopping service Catalina
Nov 25, 2016 5:56:50 PM org.apache.coyote.AbstractProtocol stop
INFO: Stopping ProtocolHandler ["http-bio-8080"]
Nov 25, 2016 5:56:50 PM org.apache.coyote.AbstractProtocol destroy
INFO: Destroying ProtocolHandler ["http-bio-8080"]
Nov 25, 2016 5:56:51 PM org.apache.catalina.startup.ClassLoaderFactory validateFile
WARNING: Problem with directory [/usr/share/tomcat7/common/classes], exists: [false], isDirectory: [false], canRead: [false]
Nov 25, 2016 5:56:51 PM org.apache.catalina.startup.ClassLoaderFactory validateFile
WARNING: Problem with directory [/usr/share/tomcat7/common], exists: [false], isDirectory: [false], canRead: [false]
Nov 25, 2016 5:56:51 PM org.apache.catalina.startup.ClassLoaderFactory validateFile
WARNING: Problem with directory [/usr/share/tomcat7/server/classes], exists: [false], isDirectory: [false], canRead: [false]
Nov 25, 2016 5:56:51 PM org.apache.catalina.startup.ClassLoaderFactory validateFile
WARNING: Problem with directory [/usr/share/tomcat7/server], exists: [false], isDirectory: [false], canRead: [false]
Nov 25, 2016 5:56:51 PM org.apache.catalina.startup.ClassLoaderFactory validateFile
WARNING: Problem with directory [/usr/share/tomcat7/shared/classes], exists: [false], isDirectory: [false], canRead: [false]
Nov 25, 2016 5:56:51 PM org.apache.catalina.startup.ClassLoaderFactory validateFile
WARNING: Problem with directory [/usr/share/tomcat7/shared], exists: [false], isDirectory: [false], canRead: [false]
Nov 25, 2016 5:56:53 PM org.apache.coyote.AbstractProtocol init
INFO: Initializing ProtocolHandler ["http-bio-8080"]
Nov 25, 2016 5:56:53 PM org.apache.catalina.startup.Catalina load
INFO: Initialization processed in 1217 ms
Nov 25, 2016 5:56:53 PM org.apache.catalina.core.StandardService startInternal
INFO: Starting service Catalina
Nov 25, 2016 5:56:53 PM org.apache.catalina.core.StandardEngine startInternal
INFO: Starting Servlet Engine: Apache Tomcat/7.0.52 (Ubuntu)
Nov 25, 2016 5:56:53 PM org.apache.catalina.startup.HostConfig deployDirectory
INFO: Deploying web application directory /var/lib/tomcat7/webapps/asqatasun
SLF4J: Class path contains multiple SLF4J bindings.
SLF4J: Found binding in [jar:file:/var/lib/tomcat7/webapps/asqatasun/WEB-INF/lib/activemq-all-5.9.1.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: Found binding in [jar:file:/var/lib/tomcat7/webapps/asqatasun/WEB-INF/lib/slf4j-log4j12-1.5.11.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an explanation.
SLF4J: Actual binding is of type [org.slf4j.impl.Log4jLoggerFactory]
Nov 25, 2016 5:58:58 PM org.apache.catalina.core.StandardContext startInternal
SEVERE: Error listenerStart
Nov 25, 2016 5:58:58 PM org.apache.catalina.core.StandardContext startInternal
SEVERE: Context [/asqatasun] startup failed due to previous errors
Nov 25, 2016 5:58:58 PM org.apache.catalina.startup.HostConfig deployDirectory
INFO: Deploying web application directory /var/lib/tomcat7/webapps/ROOT
Nov 25, 2016 5:58:58 PM org.apache.coyote.AbstractProtocol start
INFO: Starting ProtocolHandler ["http-bio-8080"]

#16

Hi @nivak91,

Your directory /var/log/asqatasun should be writable by the tomcat user. The installer deals with it.

In your case you should run a sudo chown -R tomcatX /var/log/asqatasun, with X being the major number of your Tomcat version (e.g. 6 ou 7 or 8).


#17

Hi @mfaure, i have done that and yet my problem is not solved.


#18

This is propably the error:

26-11-2016 20:45:06:496 102454 ERROR org.springframework.web.context.ContextLoader  - Context initialization failed
org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'asqatasunOrchestrator' defined in ServletContext resource [/WEB-INF/conf/tgol-beans-orchestrator.xml]: Instantiation of bean failed; nested exception is org.springframework.beans.BeanInstantiationException: Could not instantiate bean class [org.asqatasun.webapp.orchestrator.AsqatasunOrchestratorImpl]: Constructor threw exception; nested exception is org.springframework.transaction.CannotCreateTransactionException: Could not open JPA EntityManager for transaction; nested exception is javax.persistence.PersistenceException: org.hibernate.exception.GenericJDBCException: Could not open connection

#19
hibernate.exception.GenericJDBCException: Could not open connection

@nivak91, can you check if the credentials for the DB connection are correct
and if the url of the DB is also good in /etc/asqatasun/asqatasun.conf file ?

`


#20

I think they are ok @fabrice because i hadn’t changed them. The problem is that for some reason i can’t connect to mysql server…after typing mysql -h 127.0.0.1 -P 3306 -u asqatasun -p
and giving the password as it is in asqatasun.conf i get: Can’t connect to MySQL server on ‘127.0.0.1’ (111)