Research Academy
My account Customers About Blog Careers Legal Contact Resellers
The Burp Suite User Forum was discontinued on the 1st November 2024.

Burp Suite User Forum

For support requests, go to the Support Center. To discuss with other Burp users, head to our Discord page.

SUPPORT CENTER DISCORD

bsee k8s installation enterprise server mysql error

Remi | Last updated: Jan 03, 2024 11:21AM UTC

We are trying to get BSEE to run on our AKS cluster and MySQL PaaS database hosted on azure. We get errors on the initialising of the database, which I think is linked to a bad server setting or a bad practice in your db changelog. It seems like the DB Migration fails on the recreation of the role_groups table with following errors: liquibase.exception.CommandExecutionException: liquibase.exception.LiquibaseException: liquibase.exception.MigrationFailedException: Migration failed for changeset true::create_role_groups_join_table::PortSwigger: Reason: liquibase.exception.DatabaseException: (conn=77) Table 'role_groups' already exists [Failed SQL: (1050) CREATE TABLE burp_enterprise.role_groups (group_id INT NOT NULL, role_id INT NOT NULL)] at liquibase.command.CommandScope.execute(CommandScope.java:235) at liquibase.Liquibase.lambda$update$0(Liquibase.java:237) at liquibase.Scope.lambda$child$0(Scope.java:194) at liquibase.Scope.child(Scope.java:203) at liquibase.Scope.child(Scope.java:193) at liquibase.Scope.child(Scope.java:172) at liquibase.Liquibase.runInScope(Liquibase.java:1618) at liquibase.Liquibase.update(Liquibase.java:229) at liquibase.Liquibase.update(Liquibase.java:213) at liquibase.Liquibase.update(Liquibase.java:198) at liquibase.Liquibase.update(Liquibase.java:187) at net.portswigger.enterprise.s.W.o.lambda$runLiquibaseChangeLog$0(Unknown Source) at net.portswigger.enterprise.s.W.B.n(Unknown Source) at net.portswigger.enterprise.s.W.B.Q(Unknown Source) at net.portswigger.enterprise.s.W.o.Z(Unknown Source) at net.portswigger.enterprise.s.W.o.u(Unknown Source) at net.portswigger.enterprise.server.R.r.T(Unknown Source) at net.portswigger.enterprise.server.R.o.y(Unknown Source) at net.portswigger.enterprise.server.f.L.Q(Unknown Source) at net.portswigger.enterprise.server.f.Z.b(Unknown Source) at java.base/java.util.stream.ReferencePipeline$3$1.accept(Unknown Source) at java.base/java.util.ArrayList$ArrayListSpliterator.tryAdvance(Unknown Source) at java.base/java.util.stream.ReferencePipeline.forEachWithCancel(Unknown Source) at java.base/java.util.stream.AbstractPipeline.copyIntoWithCancel(Unknown Source) at java.base/java.util.stream.AbstractPipeline.copyInto(Unknown Source) at java.base/java.util.stream.AbstractPipeline.wrapAndCopyInto(Unknown Source) at java.base/java.util.stream.FindOps$FindOp.evaluateSequential(Unknown Source) at java.base/java.util.stream.AbstractPipeline.evaluate(Unknown Source) at java.base/java.util.stream.ReferencePipeline.findFirst(Unknown Source) at net.portswigger.enterprise.server.f.Z.U(Unknown Source) at net.portswigger.enterprise.server.StartEnterpriseServer.a(Unknown Source) at net.portswigger.enterprise.server.StartEnterpriseServer.F(Unknown Source) at net.portswigger.enterprise.server.StartEnterpriseServer.main(Unknown Source) Caused by: liquibase.exception.LiquibaseException: liquibase.exception.MigrationFailedException: Migration failed for changeset true::create_role_groups_join_table::PortSwigger: Reason: liquibase.exception.DatabaseException: (conn=77) Table 'role_groups' already exists [Failed SQL: (1050) CREATE TABLE burp_enterprise.role_groups (group_id INT NOT NULL, role_id INT NOT NULL)] at liquibase.changelog.ChangeLogIterator.run(ChangeLogIterator.java:123) at liquibase.command.core.AbstractUpdateCommandStep.lambda$run$0(AbstractUpdateCommandStep.java:102) at liquibase.Scope.lambda$child$0(Scope.java:194) at liquibase.Scope.child(Scope.java:203) at liquibase.Scope.child(Scope.java:193) at liquibase.Scope.child(Scope.java:172) at liquibase.command.core.AbstractUpdateCommandStep.run(AbstractUpdateCommandStep.java:99) at liquibase.command.CommandScope.execute(CommandScope.java:212) ... 32 more Caused by: liquibase.exception.MigrationFailedException: Migration failed for changeset true::create_role_groups_join_table::PortSwigger: Reason: liquibase.exception.DatabaseException: (conn=77) Table 'role_groups' already exists [Failed SQL: (1050) CREATE TABLE burp_enterprise.role_groups (group_id INT NOT NULL, role_id INT NOT NULL)] at liquibase.changelog.ChangeSet.execute(ChangeSet.java:761) at liquibase.changelog.visitor.UpdateVisitor.visit(UpdateVisitor.java:61) at liquibase.changelog.ChangeLogIterator$2.lambda$null$0(ChangeLogIterator.java:111) at liquibase.Scope.lambda$child$0(Scope.java:194) at liquibase.Scope.child(Scope.java:203) at liquibase.Scope.child(Scope.java:193) at liquibase.Scope.child(Scope.java:172) at liquibase.changelog.ChangeLogIterator$2.lambda$run$1(ChangeLogIterator.java:111) at liquibase.Scope.lambda$child$0(Scope.java:194) at liquibase.Scope.child(Scope.java:203) at liquibase.Scope.child(Scope.java:193) at liquibase.Scope.child(Scope.java:172) at liquibase.Scope.child(Scope.java:260) at liquibase.changelog.ChangeLogIterator$2.run(ChangeLogIterator.java:94) at liquibase.Scope.lambda$child$0(Scope.java:194) at liquibase.Scope.child(Scope.java:203) at liquibase.Scope.child(Scope.java:193) at liquibase.Scope.child(Scope.java:172) at liquibase.Scope.child(Scope.java:260) at liquibase.Scope.child(Scope.java:264) at liquibase.changelog.ChangeLogIterator.run(ChangeLogIterator.java:68) ... 39 more Caused by: liquibase.exception.DatabaseException: (conn=77) Table 'role_groups' already exists [Failed SQL: (1050) CREATE TABLE burp_enterprise.role_groups (group_id INT NOT NULL, role_id INT NOT NULL)] at liquibase.executor.jvm.JdbcExecutor$ExecuteStatementCallback.doInStatement(JdbcExecutor.java:445) at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:77) at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:160) at liquibase.database.AbstractJdbcDatabase.execute(AbstractJdbcDatabase.java:1287) at liquibase.database.AbstractJdbcDatabase.executeStatements(AbstractJdbcDatabase.java:1269) at liquibase.changelog.ChangeSet.execute(ChangeSet.java:718) ... 59 more Caused by: java.sql.SQLSyntaxErrorException: (conn=77) Table 'role_groups' already exists at org.mariadb.jdbc.internal.util.exceptions.ExceptionFactory.createException(ExceptionFactory.java:62) at org.mariadb.jdbc.internal.util.exceptions.ExceptionFactory.create(ExceptionFactory.java:158) at org.mariadb.jdbc.MariaDbStatement.executeExceptionEpilogue(MariaDbStatement.java:262) at org.mariadb.jdbc.MariaDbStatement.executeInternal(MariaDbStatement.java:362) at org.mariadb.jdbc.MariaDbStatement.execute(MariaDbStatement.java:500) at com.zaxxer.hikari.pool.ProxyStatement.execute(ProxyStatement.java:94) at com.zaxxer.hikari.pool.HikariProxyStatement.execute(HikariProxyStatement.java) at liquibase.executor.jvm.JdbcExecutor$ExecuteStatementCallback.doInStatement(JdbcExecutor.java:441) ... 64 more Caused by: org.mariadb.jdbc.internal.util.exceptions.MariaDbSqlException: Table 'role_groups' already exists at org.mariadb.jdbc.internal.util.exceptions.MariaDbSqlException.of(MariaDbSqlException.java:34) at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.exceptionWithQuery(AbstractQueryProtocol.java:194) at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.executeQuery(AbstractQueryProtocol.java:262) at org.mariadb.jdbc.MariaDbStatement.executeInternal(MariaDbStatement.java:356) ... 68 more Caused by: java.sql.SQLException: Table 'role_groups' already exists at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.readErrorPacket(AbstractQueryProtocol.java:1695) at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.readPacket(AbstractQueryProtocol.java:1557) at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.getResult(AbstractQueryProtocol.java:1520) at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.executeQuery(AbstractQueryProtocol.java:256) ... 69 more Any ideas on how to resolve this?

Josh, PortSwigger Agent | Last updated: Jan 03, 2024 04:01PM UTC