Research Academy
My account Customers About Blog Careers Legal Contact Resellers

Burp Suite User Forum

Create new post

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

Hi, Remi; I've replied to the email that you sent. Thanks.

You must be an existing, logged-in customer to reply to a thread. Please email us for additional support.