Sorry, I should have done that. The errors are below. There may be some duplication because I may have clicked the button more than once. In particular I noticed the reference to "Unknown column 'DESCRIPTION' in 'field list'". Not sure how to resolve it though.
Thanks for your help! Jeff [ERROR] Error persisting credentials. gateway - php_reference_gateway token id - 191e342c-d7a1-4e54-980e-9ccd14adfbb1 com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'DESCRIPTION' in 'field list' at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) at java.lang.reflect.Constructor.newInstance(Constructor.java:423) at com.mysql.jdbc.Util.handleNewInstance(Util.java:425) at com.mysql.jdbc.Util.getInstance(Util.java:408) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:943) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3973) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3909) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2527) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2680) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2501) at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1858) at com.mysql.jdbc.PreparedStatement.executeUpdateInternal(PreparedStatement.java:2079) at com.mysql.jdbc.PreparedStatement.executeUpdateInternal(PreparedStatement.java:2013) at com.mysql.jdbc.PreparedStatement.executeLargeUpdate(PreparedStatement.java:5104) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1998) at org.apache.airavata.credential.store.store.impl.db.CredentialsDAO.addCredentials(CredentialsDAO.java:112) at org.apache.airavata.credential.store.store.impl.SSHCredentialWriter.writeCredentials(SSHCredentialWriter.java:64) at org.apache.airavata.credential.store.server.CredentialStoreServerHandler.addSSHCredential(CredentialStoreServerHandler.java:102) at org.apache.airavata.credential.store.cpi.CredentialStoreService$Processor$addSSHCredential.getResult(CredentialStoreService.java:1160) at org.apache.airavata.credential.store.cpi.CredentialStoreService$Processor$addSSHCredential.getResult(CredentialStoreService.java:1144) at org.apache.thrift.ProcessFunction.process(ProcessFunction.java:39) at org.apache.thrift.TBaseProcessor.process(TBaseProcessor.java:39) at org.apache.thrift.server.TThreadPoolServer$WorkerProcess.run(TThreadPoolServer.java:286) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) at java.lang.Thread.run(Thread.java:745) [ERROR] Error occurred while saving SSH Credentials. org.apache.airavata.credential.store.store.CredentialStoreException: Error persisting credentials. gateway - php_reference_gateway token id - 191e342c-d7a1-4e54-980e-9ccd14adfbb1 at org.apache.airavata.credential.store.store.impl.db.CredentialsDAO.addCredentials(CredentialsDAO.java:121) at org.apache.airavata.credential.store.store.impl.SSHCredentialWriter.writeCredentials(SSHCredentialWriter.java:64) at org.apache.airavata.credential.store.server.CredentialStoreServerHandler.addSSHCredential(CredentialStoreServerHandler.java:102) at org.apache.airavata.credential.store.cpi.CredentialStoreService$Processor$addSSHCredential.getResult(CredentialStoreService.java:1160) at org.apache.airavata.credential.store.cpi.CredentialStoreService$Processor$addSSHCredential.getResult(CredentialStoreService.java:1144) at org.apache.thrift.ProcessFunction.process(ProcessFunction.java:39) at org.apache.thrift.TBaseProcessor.process(TBaseProcessor.java:39) at org.apache.thrift.server.TThreadPoolServer$WorkerProcess.run(TThreadPoolServer.java:286) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) at java.lang.Thread.run(Thread.java:745) Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'DESCRIPTION' in 'field list' at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) at java.lang.reflect.Constructor.newInstance(Constructor.java:423) at com.mysql.jdbc.Util.handleNewInstance(Util.java:425) at com.mysql.jdbc.Util.getInstance(Util.java:408) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:943) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3973) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3909) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2527) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2680) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2501) at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1858) at com.mysql.jdbc.PreparedStatement.executeUpdateInternal(PreparedStatement.java:2079) at com.mysql.jdbc.PreparedStatement.executeUpdateInternal(PreparedStatement.java:2013) at com.mysql.jdbc.PreparedStatement.executeLargeUpdate(PreparedStatement.java:5104) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1998) at org.apache.airavata.credential.store.store.impl.db.CredentialsDAO.addCredentials(CredentialsDAO.java:112) ... 10 common frames omitted [ERROR] Error occurred while registering SSH Credential org.apache.airavata.credential.store.exception.CredentialStoreException: Error occurred while saving SSH Credentials. at org.apache.airavata.credential.store.cpi.CredentialStoreService$addSSHCredential_result$addSSHCredential_resultStandardScheme.read(CredentialStoreService.java:3719) at org.apache.airavata.credential.store.cpi.CredentialStoreService$addSSHCredential_result$addSSHCredential_resultStandardScheme.read(CredentialStoreService.java:3697) at org.apache.airavata.credential.store.cpi.CredentialStoreService$addSSHCredential_result.read(CredentialStoreService.java:3639) at org.apache.thrift.TServiceClient.receiveBase(TServiceClient.java:86) at org.apache.airavata.credential.store.cpi.CredentialStoreService$Client.recv_addSSHCredential(CredentialStoreService.java:210) at org.apache.airavata.credential.store.cpi.CredentialStoreService$Client.addSSHCredential(CredentialStoreService.java:197) at org.apache.airavata.api.server.handler.AiravataServerHandler.generateAndRegisterSSHKeys(AiravataServerHandler.java:528) at org.apache.airavata.api.server.handler.AiravataServerHandler$$EnhancerByGuice$$5c8b1608.CGLIB$generateAndRegisterSSHKeys$168(<generated>) at org.apache.airavata.api.server.handler.AiravataServerHandler$$EnhancerByGuice$$5c8b1608$$FastClassByGuice$$b0e29ae1.invoke(<generated>) at com.google.inject.internal.cglib.proxy.$MethodProxy.invokeSuper(MethodProxy.java:228) at com.google.inject.internal.InterceptorStackCallback$InterceptedMethodInvocation.proceed(InterceptorStackCallback.java:75) at org.apache.airavata.api.server.security.interceptor.SecurityInterceptor.invoke(SecurityInterceptor.java:56) at com.google.inject.internal.InterceptorStackCallback$InterceptedMethodInvocation.proceed(InterceptorStackCallback.java:75) at com.google.inject.internal.InterceptorStackCallback.intercept(InterceptorStackCallback.java:55) at org.apache.airavata.api.server.handler.AiravataServerHandler$$EnhancerByGuice$$5c8b1608.generateAndRegisterSSHKeys(<generated>) at org.apache.airavata.api.Airavata$Processor$generateAndRegisterSSHKeys.getResult(Airavata.java:16585) at org.apache.airavata.api.Airavata$Processor$generateAndRegisterSSHKeys.getResult(Airavata.java:16569) at org.apache.thrift.ProcessFunction.process(ProcessFunction.java:39) at org.apache.thrift.TBaseProcessor.process(TBaseProcessor.java:39) at org.apache.thrift.server.TThreadPoolServer$WorkerProcess.run(TThreadPoolServer.java:286) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) at java.lang.Thread.run(Thread.java:745) [ERROR] Error persisting credentials. gateway - php_reference_gateway token id - 92e40c3f-9a6d-404e-928f-b1f06c8d60f6 com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'DESCRIPTION' in 'field list' at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) at java.lang.reflect.Constructor.newInstance(Constructor.java:423) at com.mysql.jdbc.Util.handleNewInstance(Util.java:425) at com.mysql.jdbc.Util.getInstance(Util.java:408) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:943) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3973) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3909) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2527) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2680) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2501) at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1858) at com.mysql.jdbc.PreparedStatement.executeUpdateInternal(PreparedStatement.java:2079) at com.mysql.jdbc.PreparedStatement.executeUpdateInternal(PreparedStatement.java:2013) at com.mysql.jdbc.PreparedStatement.executeLargeUpdate(PreparedStatement.java:5104) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1998) at org.apache.airavata.credential.store.store.impl.db.CredentialsDAO.addCredentials(CredentialsDAO.java:112) at org.apache.airavata.credential.store.store.impl.SSHCredentialWriter.writeCredentials(SSHCredentialWriter.java:64) at org.apache.airavata.credential.store.server.CredentialStoreServerHandler.addPasswordCredential(CredentialStoreServerHandler.java:151) at org.apache.airavata.credential.store.cpi.CredentialStoreService$Processor$addPasswordCredential.getResult(CredentialStoreService.java:1208) at org.apache.airavata.credential.store.cpi.CredentialStoreService$Processor$addPasswordCredential.getResult(CredentialStoreService.java:1192) at org.apache.thrift.ProcessFunction.process(ProcessFunction.java:39) at org.apache.thrift.TBaseProcessor.process(TBaseProcessor.java:39) at org.apache.thrift.server.TThreadPoolServer$WorkerProcess.run(TThreadPoolServer.java:286) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) at java.lang.Thread.run(Thread.java:745) [ERROR] Error occurred while saving PWD Credentials. org.apache.airavata.credential.store.store.CredentialStoreException: Error persisting credentials. gateway - php_reference_gateway token id - 92e40c3f-9a6d-404e-928f-b1f06c8d60f6 at org.apache.airavata.credential.store.store.impl.db.CredentialsDAO.addCredentials(CredentialsDAO.java:121) at org.apache.airavata.credential.store.store.impl.SSHCredentialWriter.writeCredentials(SSHCredentialWriter.java:64) at org.apache.airavata.credential.store.server.CredentialStoreServerHandler.addPasswordCredential(CredentialStoreServerHandler.java:151) at org.apache.airavata.credential.store.cpi.CredentialStoreService$Processor$addPasswordCredential.getResult(CredentialStoreService.java:1208) at org.apache.airavata.credential.store.cpi.CredentialStoreService$Processor$addPasswordCredential.getResult(CredentialStoreService.java:1192) at org.apache.thrift.ProcessFunction.process(ProcessFunction.java:39) at org.apache.thrift.TBaseProcessor.process(TBaseProcessor.java:39) at org.apache.thrift.server.TThreadPoolServer$WorkerProcess.run(TThreadPoolServer.java:286) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) at java.lang.Thread.run(Thread.java:745) Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'DESCRIPTION' in 'field list' at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) at java.lang.reflect.Constructor.newInstance(Constructor.java:423) at com.mysql.jdbc.Util.handleNewInstance(Util.java:425) at com.mysql.jdbc.Util.getInstance(Util.java:408) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:943) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3973) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3909) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2527) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2680) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2501) at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1858) at com.mysql.jdbc.PreparedStatement.executeUpdateInternal(PreparedStatement.java:2079) at com.mysql.jdbc.PreparedStatement.executeUpdateInternal(PreparedStatement.java:2013) at com.mysql.jdbc.PreparedStatement.executeLargeUpdate(PreparedStatement.java:5104) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1998) at org.apache.airavata.credential.store.store.impl.db.CredentialsDAO.addCredentials(CredentialsDAO.java:112) ... 10 common frames omitted [ERROR] Error occurred while registering PWD Credential org.apache.airavata.credential.store.exception.CredentialStoreException: Error occurred while saving PWD Credentials. at org.apache.airavata.credential.store.cpi.CredentialStoreService$addPasswordCredential_result$addPasswordCredential_resultStandardScheme.read(CredentialStoreService.java:5373) at org.apache.airavata.credential.store.cpi.CredentialStoreService$addPasswordCredential_result$addPasswordCredential_resultStandardScheme.read(CredentialStoreService.java:5351) at org.apache.airavata.credential.store.cpi.CredentialStoreService$addPasswordCredential_result.read(CredentialStoreService.java:5293) at org.apache.thrift.TServiceClient.receiveBase(TServiceClient.java:86) at org.apache.airavata.credential.store.cpi.CredentialStoreService$Client.recv_addPasswordCredential(CredentialStoreService.java:262) at org.apache.airavata.credential.store.cpi.CredentialStoreService$Client.addPasswordCredential(CredentialStoreService.java:249) at org.apache.airavata.api.server.handler.AiravataServerHandler.registerPwdCredential(AiravataServerHandler.java:566) at org.apache.airavata.api.server.handler.AiravataServerHandler$$EnhancerByGuice$$5c8b1608.CGLIB$registerPwdCredential$167(<generated>) at org.apache.airavata.api.server.handler.AiravataServerHandler$$EnhancerByGuice$$5c8b1608$$FastClassByGuice$$b0e29ae1.invoke(<generated>) at com.google.inject.internal.cglib.proxy.$MethodProxy.invokeSuper(MethodProxy.java:228) at com.google.inject.internal.InterceptorStackCallback$InterceptedMethodInvocation.proceed(InterceptorStackCallback.java:75) at org.apache.airavata.api.server.security.interceptor.SecurityInterceptor.invoke(SecurityInterceptor.java:56) at com.google.inject.internal.InterceptorStackCallback$InterceptedMethodInvocation.proceed(InterceptorStackCallback.java:75) at com.google.inject.internal.InterceptorStackCallback.intercept(InterceptorStackCallback.java:55) at org.apache.airavata.api.server.handler.AiravataServerHandler$$EnhancerByGuice$$5c8b1608.registerPwdCredential(<generated>) at org.apache.airavata.api.Airavata$Processor$registerPwdCredential.getResult(Airavata.java:16613) at org.apache.airavata.api.Airavata$Processor$registerPwdCredential.getResult(Airavata.java:16597) at org.apache.thrift.ProcessFunction.process(ProcessFunction.java:39) at org.apache.thrift.TBaseProcessor.process(TBaseProcessor.java:39) at org.apache.thrift.server.TThreadPoolServer$WorkerProcess.run(TThreadPoolServer.java:286) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) at java.lang.Thread.run(Thread.java:745) [ERROR] Error persisting credentials. gateway - php_reference_gateway token id - 464bc41b-8687-40d0-8a39-0781dc687c29 com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'DESCRIPTION' in 'field list' at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) at java.lang.reflect.Constructor.newInstance(Constructor.java:423) at com.mysql.jdbc.Util.handleNewInstance(Util.java:425) at com.mysql.jdbc.Util.getInstance(Util.java:408) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:943) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3973) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3909) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2527) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2680) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2501) at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1858) at com.mysql.jdbc.PreparedStatement.executeUpdateInternal(PreparedStatement.java:2079) at com.mysql.jdbc.PreparedStatement.executeUpdateInternal(PreparedStatement.java:2013) at com.mysql.jdbc.PreparedStatement.executeLargeUpdate(PreparedStatement.java:5104) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1998) at org.apache.airavata.credential.store.store.impl.db.CredentialsDAO.addCredentials(CredentialsDAO.java:112) at org.apache.airavata.credential.store.store.impl.SSHCredentialWriter.writeCredentials(SSHCredentialWriter.java:64) at org.apache.airavata.credential.store.server.CredentialStoreServerHandler.addSSHCredential(CredentialStoreServerHandler.java:102) at org.apache.airavata.credential.store.cpi.CredentialStoreService$Processor$addSSHCredential.getResult(CredentialStoreService.java:1160) at org.apache.airavata.credential.store.cpi.CredentialStoreService$Processor$addSSHCredential.getResult(CredentialStoreService.java:1144) at org.apache.thrift.ProcessFunction.process(ProcessFunction.java:39) at org.apache.thrift.TBaseProcessor.process(TBaseProcessor.java:39) at org.apache.thrift.server.TThreadPoolServer$WorkerProcess.run(TThreadPoolServer.java:286) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) at java.lang.Thread.run(Thread.java:745) [ERROR] Error occurred while saving SSH Credentials. org.apache.airavata.credential.store.store.CredentialStoreException: Error persisting credentials. gateway - php_reference_gateway token id - 464bc41b-8687-40d0-8a39-0781dc687c29 at org.apache.airavata.credential.store.store.impl.db.CredentialsDAO.addCredentials(CredentialsDAO.java:121) at org.apache.airavata.credential.store.store.impl.SSHCredentialWriter.writeCredentials(SSHCredentialWriter.java:64) at org.apache.airavata.credential.store.server.CredentialStoreServerHandler.addSSHCredential(CredentialStoreServerHandler.java:102) at org.apache.airavata.credential.store.cpi.CredentialStoreService$Processor$addSSHCredential.getResult(CredentialStoreService.java:1160) at org.apache.airavata.credential.store.cpi.CredentialStoreService$Processor$addSSHCredential.getResult(CredentialStoreService.java:1144) at org.apache.thrift.ProcessFunction.process(ProcessFunction.java:39) at org.apache.thrift.TBaseProcessor.process(TBaseProcessor.java:39) at org.apache.thrift.server.TThreadPoolServer$WorkerProcess.run(TThreadPoolServer.java:286) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) at java.lang.Thread.run(Thread.java:745) Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'DESCRIPTION' in 'field list' at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) at java.lang.reflect.Constructor.newInstance(Constructor.java:423) at com.mysql.jdbc.Util.handleNewInstance(Util.java:425) at com.mysql.jdbc.Util.getInstance(Util.java:408) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:943) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3973) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3909) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2527) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2680) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2501) at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1858) at com.mysql.jdbc.PreparedStatement.executeUpdateInternal(PreparedStatement.java:2079) at com.mysql.jdbc.PreparedStatement.executeUpdateInternal(PreparedStatement.java:2013) at com.mysql.jdbc.PreparedStatement.executeLargeUpdate(PreparedStatement.java:5104) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1998) at org.apache.airavata.credential.store.store.impl.db.CredentialsDAO.addCredentials(CredentialsDAO.java:112) ... 10 common frames omitted [ERROR] Error occurred while registering SSH Credential org.apache.airavata.credential.store.exception.CredentialStoreException: Error occurred while saving SSH Credentials. at org.apache.airavata.credential.store.cpi.CredentialStoreService$addSSHCredential_result$addSSHCredential_resultStandardScheme.read(CredentialStoreService.java:3719) at org.apache.airavata.credential.store.cpi.CredentialStoreService$addSSHCredential_result$addSSHCredential_resultStandardScheme.read(CredentialStoreService.java:3697) at org.apache.airavata.credential.store.cpi.CredentialStoreService$addSSHCredential_result.read(CredentialStoreService.java:3639) at org.apache.thrift.TServiceClient.receiveBase(TServiceClient.java:86) at org.apache.airavata.credential.store.cpi.CredentialStoreService$Client.recv_addSSHCredential(CredentialStoreService.java:210) at org.apache.airavata.credential.store.cpi.CredentialStoreService$Client.addSSHCredential(CredentialStoreService.java:197) at org.apache.airavata.api.server.handler.AiravataServerHandler.generateAndRegisterSSHKeys(AiravataServerHandler.java:528) at org.apache.airavata.api.server.handler.AiravataServerHandler$$EnhancerByGuice$$5c8b1608.CGLIB$generateAndRegisterSSHKeys$168(<generated>) at org.apache.airavata.api.server.handler.AiravataServerHandler$$EnhancerByGuice$$5c8b1608$$FastClassByGuice$$b0e29ae1.invoke(<generated>) at com.google.inject.internal.cglib.proxy.$MethodProxy.invokeSuper(MethodProxy.java:228) at com.google.inject.internal.InterceptorStackCallback$InterceptedMethodInvocation.proceed(InterceptorStackCallback.java:75) at org.apache.airavata.api.server.security.interceptor.SecurityInterceptor.invoke(SecurityInterceptor.java:56) at com.google.inject.internal.InterceptorStackCallback$InterceptedMethodInvocation.proceed(InterceptorStackCallback.java:75) at com.google.inject.internal.InterceptorStackCallback.intercept(InterceptorStackCallback.java:55) at org.apache.airavata.api.server.handler.AiravataServerHandler$$EnhancerByGuice$$5c8b1608.generateAndRegisterSSHKeys(<generated>) at org.apache.airavata.api.Airavata$Processor$generateAndRegisterSSHKeys.getResult(Airavata.java:16585) at org.apache.airavata.api.Airavata$Processor$generateAndRegisterSSHKeys.getResult(Airavata.java:16569) at org.apache.thrift.ProcessFunction.process(ProcessFunction.java:39) at org.apache.thrift.TBaseProcessor.process(TBaseProcessor.java:39) at org.apache.thrift.server.TThreadPoolServer$WorkerProcess.run(TThreadPoolServer.java:286) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) at java.lang.Thread.run(Thread.java:745) [ERROR] Error persisting credentials. gateway - php_reference_gateway token id - 4e0f0346-cd61-4e4c-b412-1076853139e2 com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'DESCRIPTION' in 'field list' at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) at java.lang.reflect.Constructor.newInstance(Constructor.java:423) at com.mysql.jdbc.Util.handleNewInstance(Util.java:425) at com.mysql.jdbc.Util.getInstance(Util.java:408) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:943) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3973) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3909) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2527) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2680) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2501) at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1858) at com.mysql.jdbc.PreparedStatement.executeUpdateInternal(PreparedStatement.java:2079) at com.mysql.jdbc.PreparedStatement.executeUpdateInternal(PreparedStatement.java:2013) at com.mysql.jdbc.PreparedStatement.executeLargeUpdate(PreparedStatement.java:5104) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1998) at org.apache.airavata.credential.store.store.impl.db.CredentialsDAO.addCredentials(CredentialsDAO.java:112) at org.apache.airavata.credential.store.store.impl.SSHCredentialWriter.writeCredentials(SSHCredentialWriter.java:64) at org.apache.airavata.credential.store.server.CredentialStoreServerHandler.addSSHCredential(CredentialStoreServerHandler.java:102) at org.apache.airavata.credential.store.cpi.CredentialStoreService$Processor$addSSHCredential.getResult(CredentialStoreService.java:1160) at org.apache.airavata.credential.store.cpi.CredentialStoreService$Processor$addSSHCredential.getResult(CredentialStoreService.java:1144) at org.apache.thrift.ProcessFunction.process(ProcessFunction.java:39) at org.apache.thrift.TBaseProcessor.process(TBaseProcessor.java:39) at org.apache.thrift.server.TThreadPoolServer$WorkerProcess.run(TThreadPoolServer.java:286) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) at java.lang.Thread.run(Thread.java:745) [ERROR] Error occurred while saving SSH Credentials. org.apache.airavata.credential.store.store.CredentialStoreException: Error persisting credentials. gateway - php_reference_gateway token id - 4e0f0346-cd61-4e4c-b412-1076853139e2 at org.apache.airavata.credential.store.store.impl.db.CredentialsDAO.addCredentials(CredentialsDAO.java:121) at org.apache.airavata.credential.store.store.impl.SSHCredentialWriter.writeCredentials(SSHCredentialWriter.java:64) at org.apache.airavata.credential.store.server.CredentialStoreServerHandler.addSSHCredential(CredentialStoreServerHandler.java:102) at org.apache.airavata.credential.store.cpi.CredentialStoreService$Processor$addSSHCredential.getResult(CredentialStoreService.java:1160) at org.apache.airavata.credential.store.cpi.CredentialStoreService$Processor$addSSHCredential.getResult(CredentialStoreService.java:1144) at org.apache.thrift.ProcessFunction.process(ProcessFunction.java:39) at org.apache.thrift.TBaseProcessor.process(TBaseProcessor.java:39) at org.apache.thrift.server.TThreadPoolServer$WorkerProcess.run(TThreadPoolServer.java:286) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) at java.lang.Thread.run(Thread.java:745) Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'DESCRIPTION' in 'field list' at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) at java.lang.reflect.Constructor.newInstance(Constructor.java:423) at com.mysql.jdbc.Util.handleNewInstance(Util.java:425) at com.mysql.jdbc.Util.getInstance(Util.java:408) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:943) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3973) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3909) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2527) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2680) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2501) at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1858) at com.mysql.jdbc.PreparedStatement.executeUpdateInternal(PreparedStatement.java:2079) at com.mysql.jdbc.PreparedStatement.executeUpdateInternal(PreparedStatement.java:2013) at com.mysql.jdbc.PreparedStatement.executeLargeUpdate(PreparedStatement.java:5104) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1998) at org.apache.airavata.credential.store.store.impl.db.CredentialsDAO.addCredentials(CredentialsDAO.java:112) ... 10 common frames omitted [ERROR] Error occurred while registering SSH Credential org.apache.airavata.credential.store.exception.CredentialStoreException: Error occurred while saving SSH Credentials. at org.apache.airavata.credential.store.cpi.CredentialStoreService$addSSHCredential_result$addSSHCredential_resultStandardScheme.read(CredentialStoreService.java:3719) at org.apache.airavata.credential.store.cpi.CredentialStoreService$addSSHCredential_result$addSSHCredential_resultStandardScheme.read(CredentialStoreService.java:3697) at org.apache.airavata.credential.store.cpi.CredentialStoreService$addSSHCredential_result.read(CredentialStoreService.java:3639) at org.apache.thrift.TServiceClient.receiveBase(TServiceClient.java:86) at org.apache.airavata.credential.store.cpi.CredentialStoreService$Client.recv_addSSHCredential(CredentialStoreService.java:210) at org.apache.airavata.credential.store.cpi.CredentialStoreService$Client.addSSHCredential(CredentialStoreService.java:197) at org.apache.airavata.api.server.handler.AiravataServerHandler.generateAndRegisterSSHKeys(AiravataServerHandler.java:528) at org.apache.airavata.api.server.handler.AiravataServerHandler$$EnhancerByGuice$$5c8b1608.CGLIB$generateAndRegisterSSHKeys$168(<generated>) at org.apache.airavata.api.server.handler.AiravataServerHandler$$EnhancerByGuice$$5c8b1608$$FastClassByGuice$$b0e29ae1.invoke(<generated>) at com.google.inject.internal.cglib.proxy.$MethodProxy.invokeSuper(MethodProxy.java:228) at com.google.inject.internal.InterceptorStackCallback$InterceptedMethodInvocation.proceed(InterceptorStackCallback.java:75) at org.apache.airavata.api.server.security.interceptor.SecurityInterceptor.invoke(SecurityInterceptor.java:56) at com.google.inject.internal.InterceptorStackCallback$InterceptedMethodInvocation.proceed(InterceptorStackCallback.java:75) at com.google.inject.internal.InterceptorStackCallback.intercept(InterceptorStackCallback.java:55) at org.apache.airavata.api.server.handler.AiravataServerHandler$$EnhancerByGuice$$5c8b1608.generateAndRegisterSSHKeys(<generated>) at org.apache.airavata.api.Airavata$Processor$generateAndRegisterSSHKeys.getResult(Airavata.java:16585) at org.apache.airavata.api.Airavata$Processor$generateAndRegisterSSHKeys.getResult(Airavata.java:16569) at org.apache.thrift.ProcessFunction.process(ProcessFunction.java:39) at org.apache.thrift.TBaseProcessor.process(TBaseProcessor.java:39) at org.apache.thrift.server.TThreadPoolServer$WorkerProcess.run(TThreadPoolServer.java:286) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) at java.lang.Thread.run(Thread.java:745) ________________________________ From: Supun Nakandala [[email protected]] Sent: Wednesday, May 31, 2017 12:12 PM To: [email protected] Subject: Re: Running Gaussian on Comet Hi Jeff, Can you share the error log file or the detailed console out? On Wed, May 31, 2017 at 2:48 PM, Sale, Jeff <[email protected]<mailto:[email protected]>> wrote: Thanks, Eroma. Don't I also need to create key pairs in the Credential Store? When I click the option to "Generate a new token" I get the following error: "Error occurred while registering SSH Credential. More info: Error occurred while saving SSH Credentials." Jeff ________________________________ From: Eroma Abeysinghe [[email protected]<mailto:[email protected]>] Sent: Wednesday, May 31, 2017 11:17 AM To: [email protected]<mailto:[email protected]> Subject: Re: Running Gaussian on Comet Hi Jeff, Sorry you are facing an issue with the job submission, Could you please check whether you have a gateway preference defined for Comet in Admin Dashboard --> Gateway Management If not you have to add the preferences. please follow http://airavata.readthedocs.io/en/latest/Gateway-Configurations/#Preference Hope this helps Thanks, Eroma On Wed, May 31, 2017 at 1:43 PM, Sale, Jeff <[email protected]<mailto:[email protected]>> wrote: I decided to skip the Local Echo example due to problems with the definition of the Local Compute Resource and move on to the Gaussian tutorial. I used the testdrive.airavata.org<http://testdrive.airavata.org> Comet compute resource configuration settings as a guide for my own. I was able to submit an Experiment but got the following error which appears to be similar to the error I was getting with the Local Echo example: DriverClassName=com.mysql.jdbc.Driver,Url=jdbc:mysql://localhost:3306/replica_catalog?autoReconnect=true,Username=airavata,Password=airavata,validationQuery=SELECT 1 from CONFIGURATION 5 replicacatalog_data INFO [pool-1-thread-124] openjpa.Runtime - Starting OpenJPA 2.2.0 26 replicacatalog_data INFO [pool-1-thread-124] openjpa.jdbc.JDBC - Using dictionary class "org.apache.openjpa.jdbc.sql.MySQLDictionary" (MySQL 5.5.5-10.1.21-MariaDB ,MySQL Connector Java mysql-connector-java-5.1.41 ( Revision: 83c6dc41b96809df81444362933043b20a1d49d5 )). [INFO] Message Received with message id 'LAUNCH.EXP-03044130-2e70-431f-a07d-90125d1eaa55' and with message type 'EXPERIMENT' for experimentId: Gaussian_Job_1_ee4b0727-2503-42b6-a8cf-7792a0f45afb [INFO] Launching experiment with experimentId: Gaussian_Job_1_ee4b0727-2503-42b6-a8cf-7792a0f45afb gateway Id: php_reference_gateway [ERROR] Experiment launch failed due to Thrift conversion error, experimentId: Gaussian_Job_1_ee4b0727-2503-42b6-a8cf-7792a0f45afb, gatewayId: php_reference_gateway org.apache.thrift.TException: Experiment 'Gaussian_Job_1_ee4b0727-2503-42b6-a8cf-7792a0f45afb' launch failed. Unable to figureout execution type for application Gaussian_9598a0ff-1417-4dd5-bf73-39b8ebdaf521 at org.apache.airavata.orchestrator.server.OrchestratorServerHandler.launchExperiment(OrchestratorServerHandler.java:251) at org.apache.airavata.orchestrator.server.OrchestratorServerHandler.launchExperiment(OrchestratorServerHandler.java:666) at org.apache.airavata.orchestrator.server.OrchestratorServerHandler.access$500(OrchestratorServerHandler.java:76) at org.apache.airavata.orchestrator.server.OrchestratorServerHandler$ExperimentHandler.onMessage(OrchestratorServerHandler.java:622) at org.apache.airavata.messaging.core.impl.ExperimentConsumer.handleDelivery(ExperimentConsumer.java:84) at com.rabbitmq.client.impl.ConsumerDispatcher$5.run(ConsumerDispatcher.java:144) at com.rabbitmq.client.impl.ConsumerWorkService$WorkPoolRunnable.run(ConsumerWorkService.java:99) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) at java.lang.Thread.run(Thread.java:745) Caused by: java.lang.NullPointerException: null at org.apache.airavata.orchestrator.server.OrchestratorServerHandler.launchExperiment(OrchestratorServerHandler.java:156) ... 9 common frames omitted -- Thank You, Best Regards, Eroma -- Thank you Supun Nakandala Dept. Computer Science and Engineering University of Moratuwa
