By type
2021-05-29 10:44:21,150+0000 INFO [/opt/primekey/bin/start.sh] (process:1) uid=10001 gid=0(root) groups=0(root)
2021-05-29 10:44:21,283+0000 INFO [/opt/primekey/bin/start.sh] (process:1) Detected 0.0 available core(s).
2021-05-29 10:44:21,306+0000 INFO [/opt/primekey/bin/start.sh] (process:1) Detected 16818544640 bytes available host memory.
2021-05-29 10:44:21,343+0000 INFO [/opt/primekey/bin/start.sh] (process:1) MySQL/MariaDB database.
2021-05-29 10:44:22,447+0000 ERROR [org.ejbca.ui.cli.jdbc.JdbcTool] (main) Could not connect to address=(host=mariadb-galera)(port=3306)(type=master) : Access denied for user 'ejbca'@'%' to database 'ejbca'
2021-05-29 10:44:22,447+0000 INFO [org.ejbca.ui.cli.jdbc.JdbcTool] (main) Done.
2021-05-29 10:44:22,471+0000 INFO [/opt/primekey/bin/start.sh] (process:1) Waiting for external database 'jdbc:mariadb://mariadb-galera:3306/ejbca' to become available.
2021-05-29 10:44:26,606+0000 ERROR [org.ejbca.ui.cli.jdbc.JdbcTool] (main) Could not connect to address=(host=mariadb-galera)(port=3306)(type=master) : Access denied for user 'ejbca'@'%' to database 'ejbca'
2021-05-29 10:44:26,606+0000 INFO [org.ejbca.ui.cli.jdbc.JdbcTool] (main) Done.
2021-05-29 10:44:26,634+0000 INFO [/opt/primekey/bin/start.sh] (process:1) Waiting for external database 'jdbc:mariadb://mariadb-galera:3306/ejbca' to become available.
2021-05-29 10:44:30,993+0000 ERROR [org.ejbca.ui.cli.jdbc.JdbcTool] (main) Could not connect to address=(host=mariadb-galera)(port=3306)(type=master) : Access denied for user 'ejbca'@'%' to database 'ejbca'
2021-05-29 10:44:30,993+0000 INFO [org.ejbca.ui.cli.jdbc.JdbcTool] (main) Done.
2021-05-29 10:44:31,059+0000 INFO [/opt/primekey/bin/start.sh] (process:1) Waiting for external database 'jdbc:mariadb://mariadb-galera:3306/ejbca' to become available.
2021-05-29 10:44:35,184+0000 ERROR [org.ejbca.ui.cli.jdbc.JdbcTool] (main) Could not connect to address=(host=mariadb-galera)(port=3306)(type=master) : Access denied for user 'ejbca'@'%' to database 'ejbca'
2021-05-29 10:44:35,185+0000 INFO [org.ejbca.ui.cli.jdbc.JdbcTool] (main) Done.
2021-05-29 10:44:35,245+0000 INFO [/opt/primekey/bin/start.sh] (process:1) Waiting for external database 'jdbc:mariadb://mariadb-galera:3306/ejbca' to become available.
2021-05-29 10:44:39,480+0000 ERROR [org.ejbca.ui.cli.jdbc.JdbcTool] (main) Could not connect to address=(host=mariadb-galera)(port=3306)(type=master) : Access denied for user 'ejbca'@'%' to database 'ejbca'
2021-05-29 10:44:39,481+0000 INFO [org.ejbca.ui.cli.jdbc.JdbcTool] (main) Done.
2021-05-29 10:44:39,515+0000 INFO [/opt/primekey/bin/start.sh] (process:1) Waiting for external database 'jdbc:mariadb://mariadb-galera:3306/ejbca' to become available.
2021-05-29 10:44:43,715+0000 ERROR [org.ejbca.ui.cli.jdbc.JdbcTool] (main) Could not connect to address=(host=mariadb-galera)(port=3306)(type=master) : Access denied for user 'ejbca'@'%' to database 'ejbca'
2021-05-29 10:44:43,715+0000 INFO [org.ejbca.ui.cli.jdbc.JdbcTool] (main) Done.
2021-05-29 10:44:43,728+0000 INFO [/opt/primekey/bin/start.sh] (process:1) Waiting for external database 'jdbc:mariadb://mariadb-galera:3306/ejbca' to become available.
2021-05-29 10:44:47,843+0000 ERROR [org.ejbca.ui.cli.jdbc.JdbcTool] (main) Could not connect to address=(host=mariadb-galera)(port=3306)(type=master) : Access denied for user 'ejbca'@'%' to database 'ejbca'
2021-05-29 10:44:47,844+0000 INFO [org.ejbca.ui.cli.jdbc.JdbcTool] (main) Done.
2021-05-29 10:44:47,878+0000 INFO [/opt/primekey/bin/start.sh] (process:1) Waiting for external database 'jdbc:mariadb://mariadb-galera:3306/ejbca' to become available.
2021-05-29 10:44:52,747+0000 ERROR [org.ejbca.ui.cli.jdbc.JdbcTool] (main) Could not connect to address=(host=mariadb-galera)(port=3306)(type=master) : Access denied for user 'ejbca'@'%' to database 'ejbca'
2021-05-29 10:44:52,747+0000 INFO [org.ejbca.ui.cli.jdbc.JdbcTool] (main) Done.
2021-05-29 10:44:52,809+0000 INFO [/opt/primekey/bin/start.sh] (process:1) Waiting for external database 'jdbc:mariadb://mariadb-galera:3306/ejbca' to become available.
2021-05-29 10:44:57,114+0000 ERROR [org.ejbca.ui.cli.jdbc.JdbcTool] (main) Could not connect to address=(host=mariadb-galera)(port=3306)(type=master) : Access denied for user 'ejbca'@'%' to database 'ejbca'
2021-05-29 10:44:57,114+0000 INFO [org.ejbca.ui.cli.jdbc.JdbcTool] (main) Done.
2021-05-29 10:44:57,135+0000 INFO [/opt/primekey/bin/start.sh] (process:1) Waiting for external database 'jdbc:mariadb://mariadb-galera:3306/ejbca' to become available.
2021-05-29 10:45:01,416+0000 ERROR [org.ejbca.ui.cli.jdbc.JdbcTool] (main) Could not connect to address=(host=mariadb-galera)(port=3306)(type=master) : Access denied for user 'ejbca'@'%' to database 'ejbca'
2021-05-29 10:45:01,417+0000 INFO [org.ejbca.ui.cli.jdbc.JdbcTool] (main) Done.
2021-05-29 10:45:01,448+0000 INFO [/opt/primekey/bin/start.sh] (process:1) Waiting for external database 'jdbc:mariadb://mariadb-galera:3306/ejbca' to become available.
2021-05-29 10:45:05,672+0000 ERROR [org.ejbca.ui.cli.jdbc.JdbcTool] (main) Could not connect to address=(host=mariadb-galera)(port=3306)(type=master) : Access denied for user 'ejbca'@'%' to database 'ejbca'
2021-05-29 10:45:05,673+0000 INFO [org.ejbca.ui.cli.jdbc.JdbcTool] (main) Done.
2021-05-29 10:45:05,702+0000 INFO [/opt/primekey/bin/start.sh] (process:1) Waiting for external database 'jdbc:mariadb://mariadb-galera:3306/ejbca' to become available.
2021-05-29 10:45:09,977+0000 ERROR [org.ejbca.ui.cli.jdbc.JdbcTool] (main) Could not connect to address=(host=mariadb-galera)(port=3306)(type=master) : Access denied for user 'ejbca'@'%' to database 'ejbca'
2021-05-29 10:45:09,978+0000 INFO [org.ejbca.ui.cli.jdbc.JdbcTool] (main) Done.
2021-05-29 10:45:10,021+0000 INFO [/opt/primekey/bin/start.sh] (process:1) Waiting for external database 'jdbc:mariadb://mariadb-galera:3306/ejbca' to become available.
2021-05-29 10:45:14,501+0000 INFO [org.ejbca.ui.cli.jdbc.JdbcTool] (main) Connected.
2021-05-29 10:45:14,514+0000 INFO [org.ejbca.ui.cli.jdbc.JdbcTool] (main) 'SELECT 1' -> hit
2021-05-29 10:45:14,515+0000 INFO [org.ejbca.ui.cli.jdbc.JdbcTool] (main) Done.
2021-05-29 10:45:15,675+0000 ERROR [org.ejbca.ui.cli.jdbc.JdbcTool] (main) Could not connect to address=(host=mariadb-galera)(port=3306)(type=master) : Access denied for user 'ejbca'@'%' to database 'ejbca'
2021-05-29 10:45:15,676+0000 INFO [org.ejbca.ui.cli.jdbc.JdbcTool] (main) Done.
2021-05-29 10:45:15,686+0000 INFO [/opt/primekey/bin/start.sh] (process:1) Creating database tables...
2021-05-29 10:45:16,762+0000 INFO [org.ejbca.ui.cli.jdbc.JdbcTool] (main) Loading SQL script '/opt/primekey/ejbca/doc/sql-scripts/create-tables-ejbca-mysql.sql' with 460 lines.
2021-05-29 10:45:17,510+0000 INFO [org.ejbca.ui.cli.jdbc.JdbcTool] (main) Connected.
2021-05-29 10:45:17,538+0000 INFO [org.ejbca.ui.cli.jdbc.JdbcTool] (main) 'CREATE TABLE AccessRulesData ( pK INT(11) NOT NULL, accessRule VARCHAR(250) BINARY NOT NULL, isRecursive TINYINT(4) NOT NULL, rowProtection LONGTEXT, rowVersion INT(11) NOT NULL, rule INT(11) NOT NULL, AdminGroupData_accessRules INT(11), PRIMARY KEY (pK) )' -> 0
2021-05-29 10:45:17,558+0000 INFO [org.ejbca.ui.cli.jdbc.JdbcTool] (main) 'CREATE TABLE AdminEntityData ( pK INT(11) NOT NULL, cAId INT(11) NOT NULL, matchType INT(11) NOT NULL, matchValue VARCHAR(250) BINARY, matchWith INT(11) NOT NULL, rowProtection LONGTEXT, rowVersion INT(11) NOT NULL, tokenType VARCHAR(250) BINARY, AdminGroupData_adminEntities INT(11), PRIMARY KEY (pK) )' -> 0
2021-05-29 10:45:17,577+0000 INFO [org.ejbca.ui.cli.jdbc.JdbcTool] (main) 'CREATE TABLE AdminGroupData ( pK INT(11) NOT NULL, adminGroupName VARCHAR(250) BINARY NOT NULL, rowProtection LONGTEXT, rowVersion INT(11) NOT NULL, PRIMARY KEY (pK) )' -> 0
2021-05-29 10:45:17,596+0000 INFO [org.ejbca.ui.cli.jdbc.JdbcTool] (main) 'CREATE TABLE AdminPreferencesData ( id VARCHAR(250) BINARY NOT NULL, data LONGBLOB NOT NULL, rowProtection LONGTEXT, rowVersion INT(11) NOT NULL, PRIMARY KEY (id) )' -> 0
2021-05-29 10:45:17,616+0000 INFO [org.ejbca.ui.cli.jdbc.JdbcTool] (main) 'CREATE TABLE ApprovalData ( id INT(11) NOT NULL, approvalData LONGTEXT NOT NULL, approvalId INT(11) NOT NULL, approvalType INT(11) NOT NULL, cAId INT(11) NOT NULL, endEntityProfileId INT(11) NOT NULL, expireDate BIGINT(20) NOT NULL, remainingApprovals INT(11) NOT NULL, subjectDn VARCHAR(250) BINARY, email VARCHAR(250) BINARY, reqAdminCertIssuerDn VARCHAR(250) BINARY, reqAdminCertSn VARCHAR(250) BINARY, requestData LONGTEXT NOT NULL, requestDate BIGINT(20) NOT NULL, rowProtection LONGTEXT, rowVersion INT(11) NOT NULL, status INT(11) NOT NULL, PRIMARY KEY (id) )' -> 0
2021-05-29 10:45:17,636+0000 INFO [org.ejbca.ui.cli.jdbc.JdbcTool] (main) 'CREATE TABLE AuditRecordData ( pk VARCHAR(250) BINARY NOT NULL, additionalDetails LONGTEXT, authToken VARCHAR(250) BINARY NOT NULL, customId VARCHAR(250) BINARY, eventStatus VARCHAR(250) BINARY NOT NULL, eventType VARCHAR(250) BINARY NOT NULL, module VARCHAR(250) BINARY NOT NULL, nodeId VARCHAR(250) BINARY NOT NULL, rowProtection LONGTEXT, rowVersion INT(11) NOT NULL, searchDetail1 VARCHAR(250) BINARY, searchDetail2 VARCHAR(250) BINARY, sequenceNumber BIGINT(20) NOT NULL, service VARCHAR(250) BINARY NOT NULL, timeStamp BIGINT(20) NOT NULL, PRIMARY KEY (pk) )' -> 0
2021-05-29 10:45:17,667+0000 INFO [org.ejbca.ui.cli.jdbc.JdbcTool] (main) 'CREATE TABLE AuthorizationTreeUpdateData ( pK INT(11) NOT NULL, authorizationTreeUpdateNumber INT(11) NOT NULL, rowProtection LONGTEXT, rowVersion INT(11) NOT NULL, PRIMARY KEY (pK) )' -> 0
2021-05-29 10:45:17,697+0000 INFO [org.ejbca.ui.cli.jdbc.JdbcTool] (main) 'CREATE TABLE Base64CertData ( fingerprint VARCHAR(250) BINARY NOT NULL, base64Cert LONGTEXT, rowProtection LONGTEXT, rowVersion INT(11) NOT NULL, certificateRequest LONGTEXT, PRIMARY KEY (fingerprint) )' -> 0
2021-05-29 10:45:17,719+0000 INFO [org.ejbca.ui.cli.jdbc.JdbcTool] (main) 'CREATE TABLE CAData ( cAId INT(11) NOT NULL, data LONGTEXT NOT NULL, expireTime BIGINT(20) NOT NULL, name VARCHAR(250) BINARY, rowProtection LONGTEXT, rowVersion INT(11) NOT NULL, status INT(11) NOT NULL, subjectDN VARCHAR(250) BINARY, updateTime BIGINT(20) NOT NULL, PRIMARY KEY (cAId) )' -> 0
2021-05-29 10:45:17,740+0000 INFO [org.ejbca.ui.cli.jdbc.JdbcTool] (main) 'CREATE TABLE CRLData ( fingerprint VARCHAR(250) BINARY NOT NULL, base64Crl LONGTEXT NOT NULL, cAFingerprint VARCHAR(250) BINARY NOT NULL, crlPartitionIndex INT(11), cRLNumber INT(11) NOT NULL, deltaCRLIndicator INT(11) NOT NULL, issuerDN VARCHAR(250) BINARY NOT NULL, nextUpdate BIGINT(20) NOT NULL, rowProtection LONGTEXT, rowVersion INT(11) NOT NULL, thisUpdate BIGINT(20) NOT NULL, PRIMARY KEY (fingerprint) )' -> 0
2021-05-29 10:45:17,759+0000 INFO [org.ejbca.ui.cli.jdbc.JdbcTool] (main) 'CREATE TABLE CertReqHistoryData ( fingerprint VARCHAR(250) BINARY NOT NULL, issuerDN VARCHAR(250) BINARY NOT NULL, rowProtection LONGTEXT, rowVersion INT(11) NOT NULL, serialNumber VARCHAR(250) BINARY NOT NULL, timestamp BIGINT(20) NOT NULL, userDataVO LONGTEXT NOT NULL, username VARCHAR(250) BINARY NOT NULL, PRIMARY KEY (fingerprint) )' -> 0
2021-05-29 10:45:17,800+0000 INFO [org.ejbca.ui.cli.jdbc.JdbcTool] (main) 'CREATE TABLE CertificateData ( fingerprint VARCHAR(250) BINARY NOT NULL, base64Cert LONGTEXT, cAFingerprint VARCHAR(250) BINARY, certificateProfileId INT(11) NOT NULL, endEntityProfileId INT(11), crlPartitionIndex INT(11), expireDate BIGINT(20) NOT NULL, issuerDN VARCHAR(250) BINARY NOT NULL, notBefore BIGINT(20), revocationDate BIGINT(20) NOT NULL, revocationReason INT(11) NOT NULL, rowProtection LONGTEXT, rowVersion INT(11) NOT NULL, serialNumber VARCHAR(250) BINARY NOT NULL, status INT(11) NOT NULL, subjectAltName VARCHAR(2000) BINARY, subjectDN VARCHAR(767) BINARY NOT NULL, subjectKeyId VARCHAR(250) BINARY, tag VARCHAR(250) BINARY, type INT(11) NOT NULL, updateTime BIGINT(20) NOT NULL, username VARCHAR(250) BINARY, certificateRequest LONGTEXT, PRIMARY KEY (fingerprint) )' -> 0
2021-05-29 10:45:17,824+0000 INFO [org.ejbca.ui.cli.jdbc.JdbcTool] (main) 'CREATE TABLE CertificateProfileData ( id INT(11) NOT NULL, certificateProfileName VARCHAR(250) BINARY NOT NULL, data LONGBLOB NOT NULL, rowProtection LONGTEXT, rowVersion INT(11) NOT NULL, PRIMARY KEY (id) )' -> 0
2021-05-29 10:45:17,843+0000 INFO [org.ejbca.ui.cli.jdbc.JdbcTool] (main) 'CREATE TABLE CryptoTokenData ( id INT(11) NOT NULL, lastUpdate BIGINT(20) NOT NULL, rowProtection LONGTEXT, rowVersion INT(11) NOT NULL, tokenData LONGTEXT, tokenName VARCHAR(250) BINARY NOT NULL, tokenProps LONGTEXT, tokenType VARCHAR(250) BINARY NOT NULL, PRIMARY KEY (id) )' -> 0
2021-05-29 10:45:17,862+0000 INFO [org.ejbca.ui.cli.jdbc.JdbcTool] (main) 'CREATE TABLE EndEntityProfileData ( id INT(11) NOT NULL, data LONGBLOB NOT NULL, profileName VARCHAR(250) BINARY NOT NULL, rowProtection LONGTEXT, rowVersion INT(11) NOT NULL, PRIMARY KEY (id) )' -> 0
2021-05-29 10:45:17,883+0000 INFO [org.ejbca.ui.cli.jdbc.JdbcTool] (main) 'CREATE TABLE GlobalConfigurationData ( configurationId VARCHAR(250) BINARY NOT NULL, data LONGBLOB NOT NULL, rowProtection LONGTEXT, rowVersion INT(11) NOT NULL, PRIMARY KEY (configurationId) )' -> 0
2021-05-29 10:45:17,904+0000 INFO [org.ejbca.ui.cli.jdbc.JdbcTool] (main) 'CREATE TABLE InternalKeyBindingData ( id INT(11) NOT NULL, certificateId VARCHAR(250) BINARY, cryptoTokenId INT(11) NOT NULL, keyBindingType VARCHAR(250) BINARY NOT NULL, keyPairAlias VARCHAR(250) BINARY NOT NULL, lastUpdate BIGINT(20) NOT NULL, name VARCHAR(250) BINARY NOT NULL, rawData LONGTEXT, rowProtection LONGTEXT, rowVersion INT(11) NOT NULL, status VARCHAR(250) BINARY NOT NULL, PRIMARY KEY (id) )' -> 0
2021-05-29 10:45:17,923+0000 INFO [org.ejbca.ui.cli.jdbc.JdbcTool] (main) 'CREATE TABLE KeyRecoveryData ( certSN VARCHAR(80) BINARY NOT NULL, issuerDN VARCHAR(250) BINARY NOT NULL, cryptoTokenId INT(11) DEFAULT 0 NOT NULL, keyAlias VARCHAR(250) BINARY, keyData LONGTEXT NOT NULL, markedAsRecoverable TINYINT(4) NOT NULL, publicKeyId VARCHAR(250) BINARY, rowProtection LONGTEXT, rowVersion INT(11) NOT NULL, username VARCHAR(250) BINARY, PRIMARY KEY (certSN, issuerDN) )' -> 0
2021-05-29 10:45:17,941+0000 INFO [org.ejbca.ui.cli.jdbc.JdbcTool] (main) 'CREATE TABLE PeerData ( id INT(11) NOT NULL, connectorState INT(11) NOT NULL, data LONGTEXT, name VARCHAR(250) BINARY NOT NULL, rowProtection LONGTEXT, rowVersion INT(11) NOT NULL, url VARCHAR(250) BINARY NOT NULL, PRIMARY KEY (id) )' -> 0
2021-05-29 10:45:17,960+0000 INFO [org.ejbca.ui.cli.jdbc.JdbcTool] (main) 'CREATE TABLE ProfileData ( id INT(11) NOT NULL, profileName VARCHAR(250) BINARY NOT NULL, profileType VARCHAR(250) BINARY NOT NULL, rawData LONGTEXT, rowProtection LONGTEXT, rowVersion INT(11) NOT NULL, PRIMARY KEY (id) )' -> 0
2021-05-29 10:45:17,984+0000 INFO [org.ejbca.ui.cli.jdbc.JdbcTool] (main) 'CREATE TABLE PublisherData ( id INT(11) NOT NULL, data LONGTEXT, name VARCHAR(250) BINARY, rowProtection LONGTEXT, rowVersion INT(11) NOT NULL, updateCounter INT(11) NOT NULL, PRIMARY KEY (id) )' -> 0
2021-05-29 10:45:18,005+0000 INFO [org.ejbca.ui.cli.jdbc.JdbcTool] (main) 'CREATE TABLE PublisherQueueData ( pk VARCHAR(250) BINARY NOT NULL, fingerprint VARCHAR(250) BINARY, lastUpdate BIGINT(20) NOT NULL, publishStatus INT(11) NOT NULL, publishType INT(11) NOT NULL, publisherId INT(11) NOT NULL, rowProtection LONGTEXT, rowVersion INT(11) NOT NULL, timeCreated BIGINT(20) NOT NULL, tryCounter INT(11) NOT NULL, volatileData LONGTEXT, PRIMARY KEY (pk) )' -> 0
2021-05-29 10:45:18,022+0000 INFO [org.ejbca.ui.cli.jdbc.JdbcTool] (main) 'CREATE TABLE BlacklistData ( id INT(11) NOT NULL, type VARCHAR(250) BINARY NOT NULL, value VARCHAR(250) BINARY NOT NULL, data VARCHAR(250) BINARY, rowProtection LONGTEXT, rowVersion INT(11) NOT NULL, updateCounter INT(11) NOT NULL, PRIMARY KEY (id) )' -> 0
2021-05-29 10:45:18,040+0000 INFO [org.ejbca.ui.cli.jdbc.JdbcTool] (main) 'CREATE TABLE RoleData ( id INT(11) NOT NULL, roleName VARCHAR(250) BINARY NOT NULL, nameSpace VARCHAR(250) BINARY, rawData LONGTEXT, rowProtection LONGTEXT, rowVersion INT(11) NOT NULL, PRIMARY KEY (id) )' -> 0
2021-05-29 10:45:18,058+0000 INFO [org.ejbca.ui.cli.jdbc.JdbcTool] (main) 'CREATE TABLE RoleMemberData ( primaryKey INT(11) NOT NULL, tokenType VARCHAR(250) BINARY NOT NULL, tokenIssuerId INT(11) NOT NULL, tokenMatchKey INT(11) NOT NULL, tokenMatchOperator INT(11) NOT NULL, tokenMatchValue VARCHAR(2000) BINARY, roleId INT(11) NOT NULL, description VARCHAR(250) BINARY, rowProtection LONGTEXT, rowVersion INT(11) NOT NULL, PRIMARY KEY (primaryKey) )' -> 0
2021-05-29 10:45:18,092+0000 INFO [org.ejbca.ui.cli.jdbc.JdbcTool] (main) 'CREATE TABLE ServiceData ( id INT(11) NOT NULL, data LONGTEXT, name VARCHAR(250) BINARY NOT NULL, nextRunTimeStamp BIGINT(20) NOT NULL, rowProtection LONGTEXT, rowVersion INT(11) NOT NULL, runTimeStamp BIGINT(20) NOT NULL, PRIMARY KEY (id) )' -> 0
2021-05-29 10:45:18,116+0000 INFO [org.ejbca.ui.cli.jdbc.JdbcTool] (main) 'CREATE TABLE UserData ( username VARCHAR(250) BINARY NOT NULL, cAId INT(11) NOT NULL, cardNumber VARCHAR(250) BINARY, certificateProfileId INT(11) NOT NULL, clearPassword VARCHAR(250) BINARY, endEntityProfileId INT(11) NOT NULL, extendedInformationData LONGTEXT, keyStorePassword VARCHAR(250) BINARY, passwordHash VARCHAR(250) BINARY, rowProtection LONGTEXT, rowVersion INT(11) NOT NULL, status INT(11) NOT NULL, subjectAltName VARCHAR(2000) BINARY, subjectDN VARCHAR(767) BINARY, subjectEmail VARCHAR(256) BINARY, timeCreated BIGINT(20) NOT NULL, timeModified BIGINT(20) NOT NULL, tokenType INT(11) NOT NULL, type INT(11) NOT NULL, PRIMARY KEY (username) )' -> 0
2021-05-29 10:45:18,132+0000 INFO [org.ejbca.ui.cli.jdbc.JdbcTool] (main) 'CREATE TABLE UserDataSourceData ( id INT(11) NOT NULL, data LONGTEXT, name VARCHAR(250) BINARY NOT NULL, rowProtection LONGTEXT, rowVersion INT(11) NOT NULL, updateCounter INT(11) NOT NULL, PRIMARY KEY (id) )' -> 0
2021-05-29 10:45:18,203+0000 INFO [org.ejbca.ui.cli.jdbc.JdbcTool] (main) 'alter table AccessRulesData add index FKABB4C1DFDBBC970 (AdminGroupData_accessRules), add constraint FKABB4C1DFDBBC970 foreign key (AdminGroupData_accessRules) references AdminGroupData (pK)' -> 0
2021-05-29 10:45:18,262+0000 INFO [org.ejbca.ui.cli.jdbc.JdbcTool] (main) 'alter table AdminEntityData add index FKD9A99EBCB3A110AD (AdminGroupData_adminEntities), add constraint FKD9A99EBCB3A110AD foreign key (AdminGroupData_adminEntities) references AdminGroupData (pK)' -> 0
2021-05-29 10:45:18,290+0000 INFO [org.ejbca.ui.cli.jdbc.JdbcTool] (main) 'CREATE TABLE NoConflictCertificateData ( id VARCHAR(250) BINARY NOT NULL, fingerprint VARCHAR(250) BINARY NOT NULL, base64Cert LONGTEXT, cAFingerprint VARCHAR(250) BINARY, certificateProfileId INT(11) NOT NULL, endEntityProfileId INT(11), crlPartitionIndex INT(11), expireDate BIGINT(20) NOT NULL, issuerDN VARCHAR(250) BINARY NOT NULL, notBefore BIGINT(20), revocationDate BIGINT(20) NOT NULL, revocationReason INT(11) NOT NULL, rowProtection LONGTEXT, rowVersion INT(11) NOT NULL, serialNumber VARCHAR(250) BINARY NOT NULL, status INT(11) NOT NULL, subjectAltName VARCHAR(2000) BINARY, subjectDN VARCHAR(767) BINARY NOT NULL, subjectKeyId VARCHAR(250) BINARY, tag VARCHAR(250) BINARY, type INT(11) NOT NULL, updateTime BIGINT(20) NOT NULL, username VARCHAR(250) BINARY, certificateRequest LONGTEXT, PRIMARY KEY (id) )' -> 0
2021-05-29 10:45:18,323+0000 INFO [org.ejbca.ui.cli.jdbc.JdbcTool] (main) 'CREATE TABLE AcmeNonceData ( nonce VARCHAR(250) BINARY NOT NULL, timeExpires BIGINT(20) NOT NULL, rowProtection LONGTEXT, rowVersion INT(11) NOT NULL, PRIMARY KEY (nonce) )' -> 0
2021-05-29 10:45:18,344+0000 INFO [org.ejbca.ui.cli.jdbc.JdbcTool] (main) 'CREATE TABLE AcmeAccountData ( accountId VARCHAR(250) BINARY NOT NULL, currentKeyId VARCHAR(250) BINARY NOT NULL, rawData LONGTEXT, rowProtection LONGTEXT, rowVersion INT(11) NOT NULL, PRIMARY KEY (accountId) )' -> 0
2021-05-29 10:45:18,364+0000 INFO [org.ejbca.ui.cli.jdbc.JdbcTool] (main) 'CREATE TABLE AcmeChallengeData ( challengeId VARCHAR(250) BINARY NOT NULL, authorizationId VARCHAR(250) BINARY NOT NULL, type VARCHAR(20) BINARY NOT NULL, rawData LONGTEXT, rowProtection LONGTEXT, rowVersion INT(11) NOT NULL, PRIMARY KEY (challengeId) )' -> 0
2021-05-29 10:45:18,386+0000 INFO [org.ejbca.ui.cli.jdbc.JdbcTool] (main) 'CREATE TABLE AcmeOrderData ( orderId VARCHAR(250) BINARY NOT NULL, accountId VARCHAR(250) BINARY NOT NULL, fingerprint VARCHAR(250) BINARY, status VARCHAR(250) BINARY NOT NULL, rawData LONGTEXT, rowProtection LONGTEXT, rowVersion INT(11) NOT NULL, PRIMARY KEY (orderId) )' -> 0
2021-05-29 10:45:18,417+0000 INFO [org.ejbca.ui.cli.jdbc.JdbcTool] (main) 'CREATE TABLE AcmeAuthorizationData ( authorizationId VARCHAR(250) BINARY NOT NULL, orderId VARCHAR(250) BINARY, accountId VARCHAR(250) BINARY NOT NULL, rawData LONGTEXT, rowProtection LONGTEXT, rowVersion INT(11) NOT NULL, PRIMARY KEY (authorizationId) )' -> 0
2021-05-29 10:45:18,436+0000 INFO [org.ejbca.ui.cli.jdbc.JdbcTool] (main) 'CREATE TABLE SctData ( pk VARCHAR(250) BINARY NOT NULL, logId INT(11) NOT NULL, fingerprint VARCHAR(250) BINARY NOT NULL, certificateExpirationDate BIGINT(20) NOT NULL, data LONGTEXT, rowProtection LONGTEXT, rowVersion INT(11) NOT NULL, PRIMARY KEY (pk) )' -> 0
2021-05-29 10:45:18,456+0000 INFO [org.ejbca.ui.cli.jdbc.JdbcTool] (main) 'CREATE TABLE OcspResponseData ( id VARCHAR(250) BINARY NOT NULL, serialNumber VARCHAR(250) BINARY NOT NULL, producedAt BIGINT(20) NOT NULL, nextUpdate BIGINT(20), ocspResponse LONGBLOB, cAId INT(11), rowProtection LONGTEXT, rowVersion INT(11) NOT NULL, PRIMARY KEY (id) )' -> 0
2021-05-29 10:45:18,460+0000 INFO [org.ejbca.ui.cli.jdbc.JdbcTool] (main) Done.
2021-05-29 10:45:18,483+0000 INFO [/opt/primekey/bin/start.sh] (process:1) Applying recommended database indexes...
2021-05-29 10:45:19,623+0000 INFO [org.ejbca.ui.cli.jdbc.JdbcTool] (main) Loading SQL script '/opt/primekey/ejbca/doc/sql-scripts/create-index-ejbca.sql' with 92 lines.
2021-05-29 10:45:19,704+0000 ERROR [org.ejbca.ui.cli.jdbc.JdbcTool] (main) Could not connect to address=(host=mariadb-galera)(port=3306)(type=master) : Access denied for user 'ejbca'@'%' to database 'ejbca'
2021-05-29 10:45:19,704+0000 INFO [org.ejbca.ui.cli.jdbc.JdbcTool] (main) Done.
2021-05-29 10:45:19,721+0000 INFO [/opt/primekey/bin/start.sh] (process:1) Starting application server:
=========================================================================
JBoss Bootstrap Environment
JBOSS_HOME: /opt/primekey/wildfly-22.0.1.Final
JAVA: java
JAVA_OPTS: -server -Xms128m -Xmx15703m -Xss256k -XX:MetaspaceSize=160m -XX:MaxMetaspaceSize=256m -XX:+UseParallelGC -XX:GCTimeRatio=4 -XX:AdaptiveSizePolicyWeight=90 -XX:MinHeapFreeRatio=10 -XX:MaxHeapFreeRatio=20 -XX:+ExitOnOutOfMemoryError -Djdk.tls.ephemeralDHKeySize=2048 -Djava.net.preferIPv4Stack=false -Djava.security.egd=file:/dev/random -Dcontainer.database.name=mysql -Dcontainer.hibernate.dialect=org.hibernate.dialect.MySQL5Dialect -Dhibernate.dialect.storage_engine=innodb -Djboss.modules.system.pkgs=org.jboss.byteman -Djava.awt.headless=true --add-exports=java.base/sun.nio.ch=ALL-UNNAMED --add-exports=jdk.unsupported/sun.misc=ALL-UNNAMED --add-exports=jdk.unsupported/sun.reflect=ALL-UNNAMED
=========================================================================
2021-05-29 10:45:21,800+0000 INFO [org.jboss.as] (MSC service thread 1-2) WFLYSRV0049: WildFly Full 22.0.1.Final (WildFly Core 14.0.1.Final) starting
2021-05-29 10:45:24,042+0000 WARN [org.jboss.as.server.deployment.scanner] (ServerService Thread Pool -- 18) WFLYDS0006: Reliable deployment behaviour is not possible when auto-deployment of exploded content is enabled (i.e. deployment without use of ".dodeploy"' marker files). Configuration of auto-deployment of exploded content is not recommended in any situation where reliability is desired. Configuring the deployment scanner's auto-deploy-exploded setting to "false" is recommended.
2021-05-29 10:45:24,201+0000 INFO [org.jboss.as.server] (Controller Boot Thread) WFLYSRV0039: Creating http management service using socket-binding (management-http)
2021-05-29 10:45:24,718+0000 INFO [org.wildfly.extension.undertow] (MSC service thread 1-1) WFLYUT0003: Undertow 2.2.4.Final starting
2021-05-29 10:45:24,900+0000 INFO [org.wildfly.extension.undertow] (MSC service thread 1-2) WFLYUT0012: Started server default-server.
2021-05-29 10:45:25,005+0000 INFO [org.wildfly.extension.undertow] (MSC service thread 1-2) WFLYUT0018: Host default-host starting
2021-05-29 10:45:25,011+0000 INFO [org.wildfly.extension.undertow] (MSC service thread 1-1) WFLYUT0006: Undertow HTTP listener remoting listening on 127.0.0.1:4447
2021-05-29 10:45:26,065+0000 WARN [org.jboss.jca.core.connectionmanager.pool.strategy.OnePool] (JCA PoolFiller) IJ000610: Unable to fill pool: java:/AppDS: javax.resource.ResourceException: IJ031084: Unable to create connection
at org.jboss.ironjacamar.jdbcadapters@1.4.25.Final//org.jboss.jca.adapters.jdbc.local.LocalManagedConnectionFactory.createLocalManagedConnection(LocalManagedConnectionFactory.java:345)
at org.jboss.ironjacamar.jdbcadapters@1.4.25.Final//org.jboss.jca.adapters.jdbc.local.LocalManagedConnectionFactory.getLocalManagedConnection(LocalManagedConnectionFactory.java:352)
at org.jboss.ironjacamar.jdbcadapters@1.4.25.Final//org.jboss.jca.adapters.jdbc.local.LocalManagedConnectionFactory.createManagedConnection(LocalManagedConnectionFactory.java:287)
at org.jboss.ironjacamar.impl@1.4.25.Final//org.jboss.jca.core.connectionmanager.pool.mcp.SemaphoreConcurrentLinkedDequeManagedConnectionPool.createConnectionEventListener(SemaphoreConcurrentLinkedDequeManagedConnectionPool.java:1322)
at org.jboss.ironjacamar.impl@1.4.25.Final//org.jboss.jca.core.connectionmanager.pool.mcp.SemaphoreConcurrentLinkedDequeManagedConnectionPool.fillTo(SemaphoreConcurrentLinkedDequeManagedConnectionPool.java:1142)
at org.jboss.ironjacamar.impl@1.4.25.Final//org.jboss.jca.core.connectionmanager.pool.mcp.PoolFiller.run(PoolFiller.java:97)
at java.base/java.lang.Thread.run(Unknown Source)
Caused by: java.sql.SQLSyntaxErrorException: Could not connect to address=(host=mariadb-galera)(port=3306)(type=master) : Access denied for user 'ejbca'@'%' to database 'ejbca'
at deployment.jdbc-driver.jar//org.mariadb.jdbc.internal.util.exceptions.ExceptionMapper.get(ExceptionMapper.java:243)
at deployment.jdbc-driver.jar//org.mariadb.jdbc.internal.protocol.AbstractConnectProtocol.connectWithoutProxy(AbstractConnectProtocol.java:1243)
at deployment.jdbc-driver.jar//org.mariadb.jdbc.internal.util.Utils.retrieveProxy(Utils.java:622)
at deployment.jdbc-driver.jar//org.mariadb.jdbc.MariaDbConnection.newConnection(MariaDbConnection.java:142)
at deployment.jdbc-driver.jar//org.mariadb.jdbc.Driver.connect(Driver.java:86)
at org.jboss.ironjacamar.jdbcadapters@1.4.25.Final//org.jboss.jca.adapters.jdbc.local.LocalManagedConnectionFactory.createLocalManagedConnection(LocalManagedConnectionFactory.java:321)
... 6 more
Caused by: java.sql.SQLException: Access denied for user 'ejbca'@'%' to database 'ejbca'
at deployment.jdbc-driver.jar//org.mariadb.jdbc.internal.protocol.AbstractConnectProtocol.authenticationHandler(AbstractConnectProtocol.java:729)
at deployment.jdbc-driver.jar//org.mariadb.jdbc.internal.protocol.AbstractConnectProtocol.createConnection(AbstractConnectProtocol.java:507)
at deployment.jdbc-driver.jar//org.mariadb.jdbc.internal.protocol.AbstractConnectProtocol.connectWithoutProxy(AbstractConnectProtocol.java:1238)
... 10 more
2021-05-29 10:45:26,626+0000 INFO [org.infinispan.CONTAINER] (ServerService Thread Pool -- 46) ISPN000128: Infinispan version: Infinispan 'Corona Extra' 11.0.8.Final
2021-05-29 10:45:26,717+0000 INFO [org.infinispan.CONFIG] (MSC service thread 1-1) ISPN000152: Passivation configured without an eviction policy being selected. Only manually evicted entities will be passivated.
2021-05-29 10:45:26,721+0000 INFO [org.infinispan.CONFIG] (MSC service thread 1-1) ISPN000152: Passivation configured without an eviction policy being selected. Only manually evicted entities will be passivated.
2021-05-29 10:45:26,843+0000 INFO [org.infinispan.PERSISTENCE] (ServerService Thread Pool -- 46) ISPN000556: Starting user marshaller 'org.wildfly.clustering.infinispan.spi.marshalling.InfinispanProtoStreamMarshaller'
2021-05-29 10:45:30,354+0000 INFO [org.jboss.as.jpa] (MSC service thread 1-2) WFLYJPA0002: Read persistence.xml for ejbca
2021-05-29 10:45:32,464+0000 INFO [org.jboss.as.jpa] (ServerService Thread Pool -- 46) WFLYJPA0010: Starting Persistence Unit (phase 1 of 2) Service 'ejbca.ear#ejbca'
2021-05-29 10:45:33,324+0000 ERROR [org.jboss.as.jsf] (MSC service thread 1-2) WFLYJSF0002: Could not load JSF managed bean class: org.ejbca.ui.web.admin.peerconnector.PeerConnectorsMBean
2021-05-29 10:45:33,326+0000 ERROR [org.jboss.as.jsf] (MSC service thread 1-2) WFLYJSF0002: Could not load JSF managed bean class: org.ejbca.ui.web.admin.peerconnector.PeerConnectorMBean
2021-05-29 10:45:35,464+0000 WARN [org.jboss.as.ee] (MSC service thread 1-1) WFLYEE0007: Not installing optional component view-handler.org.apache.myfaces.tomahawk.application.ResourceViewHandlerWrapper due to an exception (enable DEBUG log level to see the cause)
2021-05-29 10:45:35,471+0000 WARN [org.jboss.as.ee] (MSC service thread 1-1) WFLYEE0007: Not installing optional component exception-handler-factory.org.ejbca.ra.jsfext.RaExceptionHandlerFactory due to an exception (enable DEBUG log level to see the cause)
2021-05-29 10:45:35,478+0000 WARN [org.jboss.as.ee] (MSC service thread 1-1) WFLYEE0007: Not installing optional component resource-handler.org.apache.myfaces.custom.captcha.CAPTCHAResourceHandlerWrapper due to an exception (enable DEBUG log level to see the cause)
2021-05-29 10:45:35,493+0000 WARN [org.jboss.as.ee] (MSC service thread 1-1) WFLYEE0007: Not installing optional component resource-handler.org.apache.myfaces.tomahawk.resource.UncompressedResourceHandlerWrapper due to an exception (enable DEBUG log level to see the cause)
2021-05-29 10:45:35,500+0000 WARN [org.jboss.as.ee] (MSC service thread 1-1) WFLYEE0007: Not installing optional component faces-context-factory.org.apache.myfaces.webapp.filter.TomahawkFacesContextFactory due to an exception (enable DEBUG log level to see the cause)
2021-05-29 10:45:36,031+0000 WARN [org.jboss.as.ejb3] (MSC service thread 1-1) WFLYEJB0131: EJB org.ejbca.core.ejb.ca.auth.EndEntityAuthenticationSessionBean should not have a final or static method (decRemainingLoginAttempts)
2021-05-29 10:45:39,964+0000 INFO [org.jboss.as.jpa] (ServerService Thread Pool -- 46) WFLYJPA0010: Starting Persistence Unit (phase 2 of 2) Service 'ejbca.ear#ejbca'
2021-05-29 10:45:40,183+0000 WARN [org.jboss.jca.core.connectionmanager.pool.strategy.OnePool] (ServerService Thread Pool -- 46) IJ000604: Throwable while attempting to get a new connection: null: javax.resource.ResourceException: IJ031084: Unable to create connection
at org.jboss.ironjacamar.jdbcadapters@1.4.25.Final//org.jboss.jca.adapters.jdbc.local.LocalManagedConnectionFactory.createLocalManagedConnection(LocalManagedConnectionFactory.java:345)
at org.jboss.ironjacamar.jdbcadapters@1.4.25.Final//org.jboss.jca.adapters.jdbc.local.LocalManagedConnectionFactory.getLocalManagedConnection(LocalManagedConnectionFactory.java:352)
at org.jboss.ironjacamar.jdbcadapters@1.4.25.Final//org.jboss.jca.adapters.jdbc.local.LocalManagedConnectionFactory.createManagedConnection(LocalManagedConnectionFactory.java:287)
at org.jboss.ironjacamar.impl@1.4.25.Final//org.jboss.jca.core.connectionmanager.pool.mcp.SemaphoreConcurrentLinkedDequeManagedConnectionPool.createConnectionEventListener(SemaphoreConcurrentLinkedDequeManagedConnectionPool.java:1322)
at org.jboss.ironjacamar.impl@1.4.25.Final//org.jboss.jca.core.connectionmanager.pool.mcp.SemaphoreConcurrentLinkedDequeManagedConnectionPool.getConnection(SemaphoreConcurrentLinkedDequeManagedConnectionPool.java:499)
at org.jboss.ironjacamar.impl@1.4.25.Final//org.jboss.jca.core.connectionmanager.pool.AbstractPool.getSimpleConnection(AbstractPool.java:632)
at org.jboss.ironjacamar.impl@1.4.25.Final//org.jboss.jca.core.connectionmanager.pool.AbstractPool.getConnection(AbstractPool.java:604)
at org.jboss.ironjacamar.impl@1.4.25.Final//org.jboss.jca.core.connectionmanager.AbstractConnectionManager.getManagedConnection(AbstractConnectionManager.java:624)
at org.jboss.ironjacamar.impl@1.4.25.Final//org.jboss.jca.core.connectionmanager.tx.TxConnectionManagerImpl.getManagedConnection(TxConnectionManagerImpl.java:440)
at org.jboss.ironjacamar.impl@1.4.25.Final//org.jboss.jca.core.connectionmanager.AbstractConnectionManager.allocateConnection(AbstractConnectionManager.java:789)
at org.jboss.ironjacamar.jdbcadapters@1.4.25.Final//org.jboss.jca.adapters.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:151)
at org.jboss.as.connector@22.0.1.Final//org.jboss.as.connector.subsystems.datasources.WildFlyDataSource.getConnection(WildFlyDataSource.java:64)
at org.hibernate@5.3.20.Final//org.hibernate.engine.jdbc.connections.internal.DatasourceConnectionProviderImpl.getConnection(DatasourceConnectionProviderImpl.java:122)
at org.hibernate@5.3.20.Final//org.hibernate.engine.jdbc.env.internal.JdbcEnvironmentInitiator$ConnectionProviderJdbcConnectionAccess.obtainConnection(JdbcEnvironmentInitiator.java:180)
at org.hibernate@5.3.20.Final//org.hibernate.engine.jdbc.env.internal.JdbcEnvironmentInitiator.initiateService(JdbcEnvironmentInitiator.java:68)
at org.hibernate@5.3.20.Final//org.hibernate.engine.jdbc.env.internal.JdbcEnvironmentInitiator.initiateService(JdbcEnvironmentInitiator.java:35)
at org.hibernate@5.3.20.Final//org.hibernate.boot.registry.internal.StandardServiceRegistryImpl.initiateService(StandardServiceRegistryImpl.java:94)
at org.hibernate@5.3.20.Final//org.hibernate.service.internal.AbstractServiceRegistryImpl.createService(AbstractServiceRegistryImpl.java:263)
at org.hibernate@5.3.20.Final//org.hibernate.service.internal.AbstractServiceRegistryImpl.initializeService(AbstractServiceRegistryImpl.java:237)
at org.hibernate@5.3.20.Final//org.hibernate.service.internal.AbstractServiceRegistryImpl.getService(AbstractServiceRegistryImpl.java:214)
at org.hibernate@5.3.20.Final//org.hibernate.id.factory.internal.DefaultIdentifierGeneratorFactory.injectServices(DefaultIdentifierGeneratorFactory.java:152)
at org.hibernate@5.3.20.Final//org.hibernate.service.internal.AbstractServiceRegistryImpl.injectDependencies(AbstractServiceRegistryImpl.java:286)
at org.hibernate@5.3.20.Final//org.hibernate.service.internal.AbstractServiceRegistryImpl.initializeService(AbstractServiceRegistryImpl.java:243)
at org.hibernate@5.3.20.Final//org.hibernate.service.internal.AbstractServiceRegistryImpl.getService(AbstractServiceRegistryImpl.java:214)
at org.hibernate@5.3.20.Final//org.hibernate.boot.internal.InFlightMetadataCollectorImpl.(InFlightMetadataCollectorImpl.java:179)
at org.hibernate@5.3.20.Final//org.hibernate.boot.model.process.spi.MetadataBuildingProcess.complete(MetadataBuildingProcess.java:119)
at org.hibernate@5.3.20.Final//org.hibernate.jpa.boot.internal.EntityManagerFactoryBuilderImpl.metadata(EntityManagerFactoryBuilderImpl.java:1215)
at org.hibernate@5.3.20.Final//org.hibernate.jpa.boot.internal.EntityManagerFactoryBuilderImpl.build(EntityManagerFactoryBuilderImpl.java:1246)
at org.hibernate.jipijapa-hibernate5-3@22.0.1.Final//org.jboss.as.jpa.hibernate5.TwoPhaseBootstrapImpl.build(TwoPhaseBootstrapImpl.java:44)
at org.jboss.as.jpa@22.0.1.Final//org.jboss.as.jpa.service.PersistenceUnitServiceImpl$1$1.run(PersistenceUnitServiceImpl.java:170)
at org.jboss.as.jpa@22.0.1.Final//org.jboss.as.jpa.service.PersistenceUnitServiceImpl$1$1.run(PersistenceUnitServiceImpl.java:128)
at java.base/java.security.AccessController.doPrivileged(Native Method)
at org.wildfly.security.elytron-private@1.14.1.Final//org.wildfly.security.manager.WildFlySecurityManager.doChecked(WildFlySecurityManager.java:664)
at org.jboss.as.jpa@22.0.1.Final//org.jboss.as.jpa.service.PersistenceUnitServiceImpl$1.run(PersistenceUnitServiceImpl.java:213)
at org.jboss.threads@2.4.0.Final//org.jboss.threads.ContextClassLoaderSavingRunnable.run(ContextClassLoaderSavingRunnable.java:35)
at org.jboss.threads@2.4.0.Final//org.jboss.threads.EnhancedQueueExecutor.safeRun(EnhancedQueueExecutor.java:1990)
at org.jboss.threads@2.4.0.Final//org.jboss.threads.EnhancedQueueExecutor$ThreadBody.doRunTask(EnhancedQueueExecutor.java:1486)
at org.jboss.threads@2.4.0.Final//org.jboss.threads.EnhancedQueueExecutor$ThreadBody.run(EnhancedQueueExecutor.java:1377)
at java.base/java.lang.Thread.run(Unknown Source)
at org.jboss.threads@2.4.0.Final//org.jboss.threads.JBossThread.run(JBossThread.java:513)
Caused by: java.sql.SQLSyntaxErrorException: Could not connect to address=(host=mariadb-galera)(port=3306)(type=master) : Access denied for user 'ejbca'@'%' to database 'ejbca'
at deployment.jdbc-driver.jar//org.mariadb.jdbc.internal.util.exceptions.ExceptionMapper.get(ExceptionMapper.java:243)
at deployment.jdbc-driver.jar//org.mariadb.jdbc.internal.protocol.AbstractConnectProtocol.connectWithoutProxy(AbstractConnectProtocol.java:1243)
at deployment.jdbc-driver.jar//org.mariadb.jdbc.internal.util.Utils.retrieveProxy(Utils.java:622)
at deployment.jdbc-driver.jar//org.mariadb.jdbc.MariaDbConnection.newConnection(MariaDbConnection.java:142)
at deployment.jdbc-driver.jar//org.mariadb.jdbc.Driver.connect(Driver.java:86)
at org.jboss.ironjacamar.jdbcadapters@1.4.25.Final//org.jboss.jca.adapters.jdbc.local.LocalManagedConnectionFactory.createLocalManagedConnection(LocalManagedConnectionFactory.java:321)
... 39 more
Caused by: java.sql.SQLException: Access denied for user 'ejbca'@'%' to database 'ejbca'
at deployment.jdbc-driver.jar//org.mariadb.jdbc.internal.protocol.AbstractConnectProtocol.authenticationHandler(AbstractConnectProtocol.java:729)
at deployment.jdbc-driver.jar//org.mariadb.jdbc.internal.protocol.AbstractConnectProtocol.createConnection(AbstractConnectProtocol.java:507)
at deployment.jdbc-driver.jar//org.mariadb.jdbc.internal.protocol.AbstractConnectProtocol.connectWithoutProxy(AbstractConnectProtocol.java:1238)
... 43 more
2021-05-29 10:45:40,189+0000 WARN [org.hibernate.engine.jdbc.env.internal.JdbcEnvironmentInitiator] (ServerService Thread Pool -- 46) HHH000342: Could not obtain connection to query metadata : javax.resource.ResourceException: IJ000453: Unable to get managed connection for java:/AppDS
2021-05-29 10:45:40,566+0000 WARN [org.hibernate.cfg.annotations.reflection.JPAOverriddenAnnotationReader] (ServerService Thread Pool -- 46) HHH000207: Property org.ejbca.core.ejb.approval.ApprovalData.subjectdn not found in class but described in (DdlTransactionIsolatorJtaImpl.java:59)
at org.hibernate@5.3.20.Final//org.hibernate.resource.transaction.backend.jta.internal.JtaTransactionCoordinatorBuilderImpl.buildDdlTransactionIsolator(JtaTransactionCoordinatorBuilderImpl.java:46)
at org.hibernate@5.3.20.Final//org.hibernate.tool.schema.internal.HibernateSchemaManagementTool.getDdlTransactionIsolator(HibernateSchemaManagementTool.java:175)
at org.hibernate@5.3.20.Final//org.hibernate.tool.schema.internal.AbstractSchemaMigrator.doMigration(AbstractSchemaMigrator.java:94)
at org.hibernate@5.3.20.Final//org.hibernate.tool.schema.spi.SchemaManagementToolCoordinator.performDatabaseAction(SchemaManagementToolCoordinator.java:183)
at org.hibernate@5.3.20.Final//org.hibernate.tool.schema.spi.SchemaManagementToolCoordinator.process(SchemaManagementToolCoordinator.java:72)
at org.hibernate@5.3.20.Final//org.hibernate.internal.SessionFactoryImpl.(SessionFactoryImpl.java:310)
at org.hibernate@5.3.20.Final//org.hibernate.boot.internal.SessionFactoryBuilderImpl.build(SessionFactoryBuilderImpl.java:467)
at org.hibernate@5.3.20.Final//org.hibernate.jpa.boot.internal.EntityManagerFactoryBuilderImpl.build(EntityManagerFactoryBuilderImpl.java:1250)
at org.hibernate.jipijapa-hibernate5-3@22.0.1.Final//org.jboss.as.jpa.hibernate5.TwoPhaseBootstrapImpl.build(TwoPhaseBootstrapImpl.java:44)
at org.jboss.as.jpa@22.0.1.Final//org.jboss.as.jpa.service.PersistenceUnitServiceImpl$1$1.run(PersistenceUnitServiceImpl.java:170)
at org.jboss.as.jpa@22.0.1.Final//org.jboss.as.jpa.service.PersistenceUnitServiceImpl$1$1.run(PersistenceUnitServiceImpl.java:128)
at java.base/java.security.AccessController.doPrivileged(Native Method)
at org.wildfly.security.elytron-private@1.14.1.Final//org.wildfly.security.manager.WildFlySecurityManager.doChecked(WildFlySecurityManager.java:664)
at org.jboss.as.jpa@22.0.1.Final//org.jboss.as.jpa.service.PersistenceUnitServiceImpl$1.run(PersistenceUnitServiceImpl.java:213)
at org.jboss.threads@2.4.0.Final//org.jboss.threads.ContextClassLoaderSavingRunnable.run(ContextClassLoaderSavingRunnable.java:35)
at org.jboss.threads@2.4.0.Final//org.jboss.threads.EnhancedQueueExecutor.safeRun(EnhancedQueueExecutor.java:1990)
at org.jboss.threads@2.4.0.Final//org.jboss.threads.EnhancedQueueExecutor$ThreadBody.doRunTask(EnhancedQueueExecutor.java:1486)
at org.jboss.threads@2.4.0.Final//org.jboss.threads.EnhancedQueueExecutor$ThreadBody.run(EnhancedQueueExecutor.java:1377)
at java.base/java.lang.Thread.run(Unknown Source)
at org.jboss.threads@2.4.0.Final//org.jboss.threads.JBossThread.run(JBossThread.java:513)
Caused by: java.sql.SQLSyntaxErrorException: Could not connect to address=(host=mariadb-galera)(port=3306)(type=master) : Access denied for user 'ejbca'@'%' to database 'ejbca'
at deployment.jdbc-driver.jar//org.mariadb.jdbc.internal.util.exceptions.ExceptionMapper.get(ExceptionMapper.java:243)
at deployment.jdbc-driver.jar//org.mariadb.jdbc.internal.protocol.AbstractConnectProtocol.connectWithoutProxy(AbstractConnectProtocol.java:1243)
at deployment.jdbc-driver.jar//org.mariadb.jdbc.internal.util.Utils.retrieveProxy(Utils.java:622)
at deployment.jdbc-driver.jar//org.mariadb.jdbc.MariaDbConnection.newConnection(MariaDbConnection.java:142)
at deployment.jdbc-driver.jar//org.mariadb.jdbc.Driver.connect(Driver.java:86)
at org.jboss.ironjacamar.jdbcadapters@1.4.25.Final//org.jboss.jca.adapters.jdbc.local.LocalManagedConnectionFactory.createLocalManagedConnection(LocalManagedConnectionFactory.java:321)
... 34 more
Caused by: java.sql.SQLException: Access denied for user 'ejbca'@'%' to database 'ejbca'
at deployment.jdbc-driver.jar//org.mariadb.jdbc.internal.protocol.AbstractConnectProtocol.authenticationHandler(AbstractConnectProtocol.java:729)
at deployment.jdbc-driver.jar//org.mariadb.jdbc.internal.protocol.AbstractConnectProtocol.createConnection(AbstractConnectProtocol.java:507)
at deployment.jdbc-driver.jar//org.mariadb.jdbc.internal.protocol.AbstractConnectProtocol.connectWithoutProxy(AbstractConnectProtocol.java:1238)
... 38 more
2021-05-29 10:45:44,457+0000 WARN [org.hibernate.engine.jdbc.spi.SqlExceptionHelper] (ServerService Thread Pool -- 46) SQL Error: 0, SQLState: null
2021-05-29 10:45:44,460+0000 ERROR [org.hibernate.engine.jdbc.spi.SqlExceptionHelper] (ServerService Thread Pool -- 46) javax.resource.ResourceException: IJ000453: Unable to get managed connection for java:/AppDS
2021-05-29 10:45:44,464+0000 ERROR [org.jboss.msc.service.fail] (ServerService Thread Pool -- 46) MSC000001: Failed to start service jboss.persistenceunit."ejbca.ear#ejbca": org.jboss.msc.service.StartException in service jboss.persistenceunit."ejbca.ear#ejbca": javax.persistence.PersistenceException: [PersistenceUnit: ejbca] Unable to build Hibernate SessionFactory
at org.jboss.as.jpa@22.0.1.Final//org.jboss.as.jpa.service.PersistenceUnitServiceImpl$1$1.run(PersistenceUnitServiceImpl.java:198)
at org.jboss.as.jpa@22.0.1.Final//org.jboss.as.jpa.service.PersistenceUnitServiceImpl$1$1.run(PersistenceUnitServiceImpl.java:128)
at java.base/java.security.AccessController.doPrivileged(Native Method)
at org.wildfly.security.elytron-private@1.14.1.Final//org.wildfly.security.manager.WildFlySecurityManager.doChecked(WildFlySecurityManager.java:664)
at org.jboss.as.jpa@22.0.1.Final//org.jboss.as.jpa.service.PersistenceUnitServiceImpl$1.run(PersistenceUnitServiceImpl.java:213)
at org.jboss.threads@2.4.0.Final//org.jboss.threads.ContextClassLoaderSavingRunnable.run(ContextClassLoaderSavingRunnable.java:35)
at org.jboss.threads@2.4.0.Final//org.jboss.threads.EnhancedQueueExecutor.safeRun(EnhancedQueueExecutor.java:1990)
at org.jboss.threads@2.4.0.Final//org.jboss.threads.EnhancedQueueExecutor$ThreadBody.doRunTask(EnhancedQueueExecutor.java:1486)
at org.jboss.threads@2.4.0.Final//org.jboss.threads.EnhancedQueueExecutor$ThreadBody.run(EnhancedQueueExecutor.java:1377)
at java.base/java.lang.Thread.run(Unknown Source)
at org.jboss.threads@2.4.0.Final//org.jboss.threads.JBossThread.run(JBossThread.java:513)
Caused by: javax.persistence.PersistenceException: [PersistenceUnit: ejbca] Unable to build Hibernate SessionFactory
at org.hibernate@5.3.20.Final//org.hibernate.jpa.boot.internal.EntityManagerFactoryBuilderImpl.persistenceException(EntityManagerFactoryBuilderImpl.java:1327)
at org.hibernate@5.3.20.Final//org.hibernate.jpa.boot.internal.EntityManagerFactoryBuilderImpl.build(EntityManagerFactoryBuilderImpl.java:1253)
at org.hibernate.jipijapa-hibernate5-3@22.0.1.Final//org.jboss.as.jpa.hibernate5.TwoPhaseBootstrapImpl.build(TwoPhaseBootstrapImpl.java:44)
at org.jboss.as.jpa@22.0.1.Final//org.jboss.as.jpa.service.PersistenceUnitServiceImpl$1$1.run(PersistenceUnitServiceImpl.java:170)
... 10 more
Caused by: org.hibernate.exception.GenericJDBCException: Unable to open JDBC Connection for DDL execution
at org.hibernate@5.3.20.Final//org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:47)
at org.hibernate@5.3.20.Final//org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:113)
at org.hibernate@5.3.20.Final//org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:99)
at org.hibernate@5.3.20.Final//org.hibernate.resource.transaction.backend.jta.internal.DdlTransactionIsolatorJtaImpl.(DdlTransactionIsolatorJtaImpl.java:62)
at org.hibernate@5.3.20.Final//org.hibernate.resource.transaction.backend.jta.internal.JtaTransactionCoordinatorBuilderImpl.buildDdlTransactionIsolator(JtaTransactionCoordinatorBuilderImpl.java:46)
at org.hibernate@5.3.20.Final//org.hibernate.tool.schema.internal.HibernateSchemaManagementTool.getDdlTransactionIsolator(HibernateSchemaManagementTool.java:175)
at org.hibernate@5.3.20.Final//org.hibernate.tool.schema.internal.AbstractSchemaMigrator.doMigration(AbstractSchemaMigrator.java:94)
at org.hibernate@5.3.20.Final//org.hibernate.tool.schema.spi.SchemaManagementToolCoordinator.performDatabaseAction(SchemaManagementToolCoordinator.java:183)
at org.hibernate@5.3.20.Final//org.hibernate.tool.schema.spi.SchemaManagementToolCoordinator.process(SchemaManagementToolCoordinator.java:72)
at org.hibernate@5.3.20.Final//org.hibernate.internal.SessionFactoryImpl.(SessionFactoryImpl.java:310)
at org.hibernate@5.3.20.Final//org.hibernate.boot.internal.SessionFactoryBuilderImpl.build(SessionFactoryBuilderImpl.java:467)
at org.hibernate@5.3.20.Final//org.hibernate.jpa.boot.internal.EntityManagerFactoryBuilderImpl.build(EntityManagerFactoryBuilderImpl.java:1250)
... 12 more
Caused by: java.sql.SQLException: javax.resource.ResourceException: IJ000453: Unable to get managed connection for java:/AppDS
at org.jboss.ironjacamar.jdbcadapters@1.4.25.Final//org.jboss.jca.adapters.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:159)
at org.jboss.as.connector@22.0.1.Final//org.jboss.as.connector.subsystems.datasources.WildFlyDataSource.getConnection(WildFlyDataSource.java:64)
at org.hibernate@5.3.20.Final//org.hibernate.engine.jdbc.connections.internal.DatasourceConnectionProviderImpl.getConnection(DatasourceConnectionProviderImpl.java:122)
at org.hibernate@5.3.20.Final//org.hibernate.engine.jdbc.env.internal.JdbcEnvironmentInitiator$ConnectionProviderJdbcConnectionAccess.obtainConnection(JdbcEnvironmentInitiator.java:180)
at org.hibernate@5.3.20.Final//org.hibernate.resource.transaction.backend.jta.internal.DdlTransactionIsolatorJtaImpl.(DdlTransactionIsolatorJtaImpl.java:59)
... 20 more
Caused by: javax.resource.ResourceException: IJ000453: Unable to get managed connection for java:/AppDS
at org.jboss.ironjacamar.impl@1.4.25.Final//org.jboss.jca.core.connectionmanager.AbstractConnectionManager.getManagedConnection(AbstractConnectionManager.java:690)
at org.jboss.ironjacamar.impl@1.4.25.Final//org.jboss.jca.core.connectionmanager.tx.TxConnectionManagerImpl.getManagedConnection(TxConnectionManagerImpl.java:440)
at org.jboss.ironjacamar.impl@1.4.25.Final//org.jboss.jca.core.connectionmanager.AbstractConnectionManager.allocateConnection(AbstractConnectionManager.java:789)
at org.jboss.ironjacamar.jdbcadapters@1.4.25.Final//org.jboss.jca.adapters.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:151)
... 24 more
Caused by: javax.resource.ResourceException: IJ031084: Unable to create connection
at org.jboss.ironjacamar.jdbcadapters@1.4.25.Final//org.jboss.jca.adapters.jdbc.local.LocalManagedConnectionFactory.createLocalManagedConnection(LocalManagedConnectionFactory.java:345)
at org.jboss.ironjacamar.jdbcadapters@1.4.25.Final//org.jboss.jca.adapters.jdbc.local.LocalManagedConnectionFactory.getLocalManagedConnection(LocalManagedConnectionFactory.java:352)
at org.jboss.ironjacamar.jdbcadapters@1.4.25.Final//org.jboss.jca.adapters.jdbc.local.LocalManagedConnectionFactory.createManagedConnection(LocalManagedConnectionFactory.java:287)
at org.jboss.ironjacamar.impl@1.4.25.Final//org.jboss.jca.core.connectionmanager.pool.mcp.SemaphoreConcurrentLinkedDequeManagedConnectionPool.createConnectionEventListener(SemaphoreConcurrentLinkedDequeManagedConnectionPool.java:1322)
at org.jboss.ironjacamar.impl@1.4.25.Final//org.jboss.jca.core.connectionmanager.pool.mcp.SemaphoreConcurrentLinkedDequeManagedConnectionPool.getConnection(SemaphoreConcurrentLinkedDequeManagedConnectionPool.java:499)
at org.jboss.ironjacamar.impl@1.4.25.Final//org.jboss.jca.core.connectionmanager.pool.AbstractPool.getSimpleConnection(AbstractPool.java:632)
at org.jboss.ironjacamar.impl@1.4.25.Final//org.jboss.jca.core.connectionmanager.pool.AbstractPool.getConnection(AbstractPool.java:604)
at org.jboss.ironjacamar.impl@1.4.25.Final//org.jboss.jca.core.connectionmanager.AbstractConnectionManager.getManagedConnection(AbstractConnectionManager.java:624)
... 27 more
Caused by: java.sql.SQLSyntaxErrorException: Could not connect to address=(host=mariadb-galera)(port=3306)(type=master) : Access denied for user 'ejbca'@'%' to database 'ejbca'
at deployment.jdbc-driver.jar//org.mariadb.jdbc.internal.util.exceptions.ExceptionMapper.get(ExceptionMapper.java:243)
at deployment.jdbc-driver.jar//org.mariadb.jdbc.internal.protocol.AbstractConnectProtocol.connectWithoutProxy(AbstractConnectProtocol.java:1243)
at deployment.jdbc-driver.jar//org.mariadb.jdbc.internal.util.Utils.retrieveProxy(Utils.java:622)
at deployment.jdbc-driver.jar//org.mariadb.jdbc.MariaDbConnection.newConnection(MariaDbConnection.java:142)
at deployment.jdbc-driver.jar//org.mariadb.jdbc.Driver.connect(Driver.java:86)
at org.jboss.ironjacamar.jdbcadapters@1.4.25.Final//org.jboss.jca.adapters.jdbc.local.LocalManagedConnectionFactory.createLocalManagedConnection(LocalManagedConnectionFactory.java:321)
... 34 more
Caused by: java.sql.SQLException: Access denied for user 'ejbca'@'%' to database 'ejbca'
at deployment.jdbc-driver.jar//org.mariadb.jdbc.internal.protocol.AbstractConnectProtocol.authenticationHandler(AbstractConnectProtocol.java:729)
at deployment.jdbc-driver.jar//org.mariadb.jdbc.internal.protocol.AbstractConnectProtocol.createConnection(AbstractConnectProtocol.java:507)
at deployment.jdbc-driver.jar//org.mariadb.jdbc.internal.protocol.AbstractConnectProtocol.connectWithoutProxy(AbstractConnectProtocol.java:1238)
... 38 more
2021-05-29 10:45:44,500+0000 ERROR [org.jboss.as.controller.management-operation] (Controller Boot Thread) WFLYCTL0013: Operation ("deploy") failed - address: ([("deployment" => "ejbca.ear")]) - failure description: {"WFLYCTL0080: Failed services" => {"jboss.persistenceunit.\"ejbca.ear#ejbca\"" => "javax.persistence.PersistenceException: [PersistenceUnit: ejbca] Unable to build Hibernate SessionFactory
Caused by: javax.persistence.PersistenceException: [PersistenceUnit: ejbca] Unable to build Hibernate SessionFactory
Caused by: org.hibernate.exception.GenericJDBCException: Unable to open JDBC Connection for DDL execution
Caused by: java.sql.SQLException: javax.resource.ResourceException: IJ000453: Unable to get managed connection for java:/AppDS
Caused by: javax.resource.ResourceException: IJ000453: Unable to get managed connection for java:/AppDS
Caused by: javax.resource.ResourceException: IJ031084: Unable to create connection
Caused by: java.sql.SQLSyntaxErrorException: Could not connect to address=(host=mariadb-galera)(port=3306)(type=master) : Access denied for user 'ejbca'@'%' to database 'ejbca'
Caused by: java.sql.SQLException: Access denied for user 'ejbca'@'%' to database 'ejbca'"}}
2021-05-29 10:45:44,528+0000 INFO [org.jboss.as.server] (ServerService Thread Pool -- 27) WFLYSRV0010: Deployed "ejbca.ear" (runtime-name : "ejbca.ear")
2021-05-29 10:45:44,528+0000 INFO [org.jboss.as.server] (ServerService Thread Pool -- 27) WFLYSRV0010: Deployed "jdbc-driver.jar" (runtime-name : "jdbc-driver.jar")
2021-05-29 10:45:44,564+0000 INFO [org.jboss.as.controller] (Controller Boot Thread) WFLYCTL0183: Service status report
WFLYCTL0186: Services which failed to start: service jboss.persistenceunit."ejbca.ear#ejbca": javax.persistence.PersistenceException: [PersistenceUnit: ejbca] Unable to build Hibernate SessionFactory
WFLYCTL0448: 904 additional services are down due to their dependencies being missing or failed
2021-05-29 10:45:44,711+0000 INFO [org.jboss.as.server] (Controller Boot Thread) WFLYSRV0212: Resuming server
2021-05-29 10:45:44,725+0000 ERROR [org.jboss.as] (Controller Boot Thread) WFLYSRV0026: WildFly Full 22.0.1.Final (WildFly Core 14.0.1.Final) started (with errors) in 24271ms - Started 4846 of 5915 services (932 services failed or missing dependencies, 283 services are lazy, passive or on-demand)
2021-05-29 10:45:44,733+0000 INFO [org.jboss.as] (Controller Boot Thread) WFLYSRV0060: Http management interface listening on http://127.0.0.1:9990/management
2021-05-29 10:45:44,734+0000 INFO [org.jboss.as] (Controller Boot Thread) WFLYSRV0054: Admin console is not enabled
2021-05-29 10:45:51,517+0000 INFO [org.jboss.as.server] (management-handler-thread - 1) WFLYSRV0211: Suspending server with 3000 ms timeout.
2021-05-29 10:45:51,542+0000 INFO [org.jboss.as.server] (Management Triggered Shutdown) WFLYSRV0241: Shutting down in response to management operation 'shutdown'
2021-05-29 10:45:44,987+0000 WARN [/opt/primekey/bin/start.sh] (process:1) {
2021-05-29 10:45:44,987+0000 WARN [/opt/primekey/bin/start.sh] (process:1) "result" => undefined
2021-05-29 10:45:44,987+0000 WARN [/opt/primekey/bin/start.sh] (process:1) }
kill: usage: kill [-s sigspec | -n signum | -sigspec] pid | jobspec ... or kill -l [sigspec]
2021-05-29 10:45:51,684+0000 INFO [org.jboss.as.jpa] (ServerService Thread Pool -- 19) WFLYJPA0011: Stopping Persistence Unit (phase 1 of 2) Service 'ejbca.ear#ejbca'
2021-05-29 10:45:52,307+0000 INFO [org.infinispan.manager.DefaultCacheManager] (ServerService Thread Pool -- 13) Stopping cache manager null on null
2021-05-29 10:45:53,069+0000 INFO [org.jboss.as] (MSC service thread 1-1) WFLYSRV0050: WildFly Full 22.0.1.Final (WildFly Core 14.0.1.Final) stopped in 1474ms
2021-05-29 10:45:53,516+0000 INFO [/opt/primekey/bin/start.sh] (process:1) Stopped application server.