Hi all, Thanks for your help. I have now solved the error by correcting jdbc URL for the credential store.I had forgot to change the name of the database to 'credential-store' from 'airavata_credentialstore'(as I had created DB with name credential-store) in one of the URL.
Regards, Pratik Patel On Thu, May 19, 2016 at 5:13 PM, Supun Nakandala <[email protected]> wrote: > Hi Pratik > can you attach your airavata-server.properties file. > > On Thu, May 19, 2016 at 5:12 PM, Pratik Patel <[email protected]> > wrote: > >> Hi Eroma, >> >> I am using 5.1.39 version of the jar file. Do you think that newest >> version would not work? >> >> Marlon, >> >> I have attached file content of my file in this email. I do not think its >> corrupted. Do we need to comment out >> 'credential.store.jdbc.driver=com.mysql.jdbc.Driver' these properties? >> which provides driver name? >> >> Thanks, >> Pratik Patel >> >> On Thu, May 19, 2016 at 5:05 PM, Pierce, Marlon <[email protected]> wrote: >> >>> Pratik, can you confirm that the mysql.jar is correct, uncorrupted, >>> etc? Use jar –tf or a similar command to list the contents. >>> >>> >>> >>> Marlon >>> >>> >>> >>> *From: *Eroma Abeysinghe <[email protected]> >>> *Reply-To: *"[email protected]" <[email protected]> >>> *Date: *Thursday, May 19, 2016 at 4:51 PM >>> *To: *"[email protected]" <[email protected]> >>> *Subject: *Re: java.lang.RuntimeException: Failed to create database >>> connection pool >>> >>> >>> >>> Hi Pratik, >>> >>> >>> >>> What is the version you have copied? I copied >>> version mysql-connector-java-5.1.38-bin.jar and it worked fine. >>> >>> Could you try this version? >>> >>> >>> >>> Thanks, >>> Eroma >>> >>> >>> >>> On Thu, May 19, 2016 at 4:34 PM, Pratik Patel <[email protected]> >>> wrote: >>> >>> Hi Suresh, >>> >>> Thanks for prompt response. >>> >>> I have already added mysql.jar in 'lib' folder. >>> >>> [image: nline image 1] >>> >>> >>> >>> I have downloaded the jar file from ' >>> http://dev.mysql.com/downloads/connector/j/'. This link was provided in >>> instructions. Does it automatically look for this jar file or I have to >>> provide the complete path of the jar with file name in >>> airavata-server.properties file? >>> >>> Thanks, >>> Pratik Patel >>> >>> >>> >>> On Thu, May 19, 2016 at 4:29 PM, Suresh Marru <[email protected]> wrote: >>> >>> Hi Pratik, >>> >>> >>> >>> As you can see from “ Can't find class for driver:” it is looking for >>> the mysql jar which should be Step 8 in instructions - >>> http://airavata.readthedocs.io/en/latest/Airavata-Installation/ >>> >>> >>> >>> Suresh >>> >>> >>> >>> On May 19, 2016, at 4:26 PM, Pratik Patel <[email protected]> wrote: >>> >>> >>> >>> Hi all, >>> >>> I am trying to start airavata-server. But I am getting following error >>> while doing so: >>> >>> Command Used: >>> $ ./airavata-server.sh start >>> >>> >>> >>> Error: >>> >>> >>> >>> >>> >>> 2016-05-19 16:17:08,225 [main] ERROR >>> org.apache.airavata.server.ServerMain - Server Start Error: >>> >>> java.lang.RuntimeException: Failed to create database connection pool. >>> >>> at >>> org.apache.airavata.api.server.util.JdbcStorage.<init>(JdbcStorage.java:47) >>> >>> at >>> org.apache.airavata.api.server.util.CredentialStoreInitUtil.initializeDB(CredentialStoreInitUtil.java:64) >>> >>> at >>> org.apache.airavata.api.server.AiravataAPIServer.startAiravataServer(AiravataAPIServer.java:74) >>> >>> at >>> org.apache.airavata.api.server.AiravataAPIServer.start(AiravataAPIServer.java:202) >>> >>> at >>> org.apache.airavata.server.ServerMain.startAllServers(ServerMain.java:292) >>> >>> at >>> org.apache.airavata.server.ServerMain.performServerStart(ServerMain.java:141) >>> >>> at org.apache.airavata.server.ServerMain.main(ServerMain.java:124) >>> >>> Caused by: java.sql.SQLException: Can't find class for driver: >>> >>> at >>> org.apache.airavata.api.server.util.ConnectionPool.makeNewConnection(ConnectionPool.java:200) >>> >>> at >>> org.apache.airavata.api.server.util.ConnectionPool.initialize(ConnectionPool.java:127) >>> >>> at >>> org.apache.airavata.api.server.util.ConnectionPool.<init>(ConnectionPool.java:90) >>> >>> at >>> org.apache.airavata.api.server.util.JdbcStorage.<init>(JdbcStorage.java:41) >>> >>> ... 6 more >>> >>> >>> >>> -------------------------------------------------------------------------------------------------------------- >>> >>> >>> >>> I have attached log file in this email. Could someone point out where I >>> am going wrong? >>> >>> >>> >>> <airavata.log> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> -- >>> >>> Thank You, >>> >>> Best Regards, >>> >>> Eroma >>> >> >> > > > -- > Thank you > Supun Nakandala > Dept. Computer Science and Engineering > University of Moratuwa >
