Supun, Thanks. It turns out there was no CREDENTIALS table in the credential_store database to DROP (perhaps not a surprise), but I did manage to create one. Unfortunately we are still getting the "Unknown column 'DESCRIPTION' in 'field list' " error.
I see there is also a database named airavata_credentialstore which also includes a CREDENTIALS table but has no DESCRIPTION field, but that's probably irrelevant. Just thought I'd mention it. I still get the "Error occurred while registering SSH Credential. More info : Error occurred while saving SSH Credentials." in the browser. Below is the error and below that are some SQL queries to confirm that the table was built and contains the DESCRIPTION field. I restarted everything including mysql just to be safe, but still no luck. Jeff [ERROR] Error persisting credentials. gateway - php_reference_gateway token id - 4eefe6f0-a9e3-4110-98c5-dc947d3268a6 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 - 4eefe6f0-a9e3-4110-98c5-dc947d3268a6 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$$a0d31de2.CGLIB$generateAndRegisterSSHKeys$167(<generated>) at org.apache.airavata.api.server.handler.AiravataServerHandler$$EnhancerByGuice$$a0d31de2$$FastClassByGuice$$4a3820fa.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$$a0d31de2.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) mysql> show databases; +--------------------------+ | Database | +--------------------------+ | airavata_credentialstore | | app_catalog | | credential_store | | experiment_catalog | | information_schema | | mysql | | performance_schema | | replica_catalog | | sharing_catalog | | test | | workflow_catalog | +--------------------------+ 11 rows in set (0.04 sec) mysql> use credential_store; Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Database changed mysql> show tables; +----------------------------+ | Tables_in_credential_store | +----------------------------+ | CREDENTIALS | +----------------------------+ 1 row in set (0.00 sec) mysql> show fields from CREDENTIALS; +-----------------------+--------------+------+-----+-------------------+-------+ | Field | Type | Null | Key | Default | Extra | +-----------------------+--------------+------+-----+-------------------+-------+ | GATEWAY_ID | varchar(100) | NO | PRI | NULL | | | TOKEN_ID | varchar(100) | NO | PRI | NULL | | | CREDENTIAL | blob | NO | | NULL | | | PORTAL_USER_ID | varchar(256) | NO | | NULL | | | TIME_PERSISTED | timestamp | NO | | CURRENT_TIMESTAMP | | | DESCRIPTION | varchar(500) | YES | | NULL | | | CREDENTIAL_OWNER_TYPE | varchar(10) | NO | | GATEWAY | | +-----------------------+--------------+------+-----+-------------------+-------+ 7 rows in set (0.01 sec)
