Research Academy
My account Customers About Blog Careers Legal Contact Resellers

Burp Suite User Forum

Create new post

Burp Enterprise unattended install -- what is the administrator password?

John | Last updated: Sep 13, 2019 11:04PM UTC

When doing an unattended install from a response file generated by a previous install, e.g. `./burpsuite_enterprise_linux_v1_1_02.sh -q -varfile response.varfile`, what's the administrator password set to? The password from the previous installation is not saved to response.varfile.

Mike, PortSwigger Agent | Last updated: Sep 16, 2019 09:39AM UTC

Hi, when you install Burp Suite Enterprise you are required to specify the credentials for the administrator account, we don't have any default values for this. You can create a new administrator by running a utility that should be in the installation directory called ‘adminusercreator’. An example of how to run it is: adminusercreator —username=new_admin —password=letmein —email=some@example.com —dbUrl=jdbc:<your database url> —dbUsername=burp_enterprise —dbPassword=*

Burp User | Last updated: Sep 16, 2019 03:16PM UTC

What's the dbUrl format if you chose the file-based internal database?

Mike, PortSwigger Agent | Last updated: Sep 16, 2019 03:24PM UTC

Hi John, glad I could help and thank you for sharing your solution.

Burp User | Last updated: Sep 16, 2019 03:39PM UTC

Figured it out, I had to stop the burpsuiteenterpriseedition_db service then use: adminusercreator --username=administrator --password=newpassword --email=security@example.com --dbUrl=jdbc:h2:/var/lib/BurpSuiteEnterpriseEdition/data/burpsuiteenterpriseedition_db --dbUsername=burp_enterprise --dbPassword=[redacted] (where dbPassword was found in /opt/burpsuite_enterprise/database/init.sql) Thanks

Jay | Last updated: Feb 14, 2020 07:49PM UTC

With burpsuite_enterprise_linux_v2020_1.sh I am not getting prompted to enter credentials for the administrator account. And when I attempt to run: /opt/burpsuite_enterprise/adminusercreator —username=administrator —password=letmein —email=email@company.com —dbUrl=jdbc:dbaname:3306/burpenterprise —dbUsername=xxxxx —dbPassword=xxxxx I get a "password is mandatory" response.

Ben, PortSwigger Agent | Last updated: Feb 18, 2020 10:19AM UTC

Hi Jay, Are you using two hyphen characters when specifying each parameter (the formatting on your post suggests you are using the — character)?

Jay | Last updated: Feb 19, 2020 07:47PM UTC

yes, that was it. I copied the script from above & didn't notice the different characters. thanks.

John | Last updated: Feb 25, 2020 04:08PM UTC

When I run the adminusercreator utility I get the following: # ./adminusercreator --username=new_admin --password=<password> --email=me@example.com --dbUrl=jdbc:<my DB>.us-east-2.rds.amazonaws.com:5432/burpenterprise --dbUsername=beserver --dbPassword='<beserver password>' Create admin user on URL:jdbc:<my DB>.us-east-2.rds.amazonaws.com:5432/burpenterprise, User: beserver 15:51:29.838 [main] INFO net.portswigger.enterprise.common.repository.b - Creating data source for URL: jdbc:<my DB>.us-east-2.rds.amazonaws.com:5432/burpenterprise, username: beserver 15:51:29.842 [main] INFO net.portswigger.enterprise.common.repository.b - DB timeouts: idle=60000, max life=120000 15:51:29.855 [main] DEBUG com.zaxxer.hikari.HikariConfig - bewspool - configuration: 15:51:29.861 [main] DEBUG com.zaxxer.hikari.HikariConfig - allowPoolSuspension.............false 15:51:29.862 [main] DEBUG com.zaxxer.hikari.HikariConfig - autoCommit......................true 15:51:29.862 [main] DEBUG com.zaxxer.hikari.HikariConfig - catalog.........................none 15:51:29.862 [main] DEBUG com.zaxxer.hikari.HikariConfig - connectionInitSql...............none 15:51:29.862 [main] DEBUG com.zaxxer.hikari.HikariConfig - connectionTestQuery.............none 15:51:29.862 [main] DEBUG com.zaxxer.hikari.HikariConfig - connectionTimeout...............10000 15:51:29.862 [main] DEBUG com.zaxxer.hikari.HikariConfig - dataSource......................none 15:51:29.862 [main] DEBUG com.zaxxer.hikari.HikariConfig - dataSourceClassName.............none 15:51:29.862 [main] DEBUG com.zaxxer.hikari.HikariConfig - dataSourceJNDI..................none 15:51:29.863 [main] DEBUG com.zaxxer.hikari.HikariConfig - dataSourceProperties............{password=<masked>} 15:51:29.863 [main] DEBUG com.zaxxer.hikari.HikariConfig - driverClassName.................none 15:51:29.864 [main] DEBUG com.zaxxer.hikari.HikariConfig - healthCheckProperties...........{} 15:51:29.864 [main] DEBUG com.zaxxer.hikari.HikariConfig - healthCheckRegistry.............com.codahale.metrics.health.HealthCheckRegistry@a514af7 15:51:29.864 [main] DEBUG com.zaxxer.hikari.HikariConfig - idleTimeout.....................60000 15:51:29.864 [main] DEBUG com.zaxxer.hikari.HikariConfig - initializationFailFast..........false 15:51:29.864 [main] DEBUG com.zaxxer.hikari.HikariConfig - initializationFailTimeout.......-1 15:51:29.864 [main] DEBUG com.zaxxer.hikari.HikariConfig - isolateInternalQueries..........false 15:51:29.864 [main] DEBUG com.zaxxer.hikari.HikariConfig - jdbc4ConnectionTest.............false 15:51:29.865 [main] DEBUG com.zaxxer.hikari.HikariConfig - jdbcUrl........................."jdbc:<my DB>.us-east-2.rds.amazonaws.com:5432/burpenterprise" 15:51:29.865 [main] DEBUG com.zaxxer.hikari.HikariConfig - leakDetectionThreshold..........0 15:51:29.865 [main] DEBUG com.zaxxer.hikari.HikariConfig - maxLifetime.....................120000 15:51:29.865 [main] DEBUG com.zaxxer.hikari.HikariConfig - maximumPoolSize.................10 15:51:29.865 [main] DEBUG com.zaxxer.hikari.HikariConfig - metricRegistry..................com.codahale.metrics.MetricRegistry@6b927fb 15:51:29.865 [main] DEBUG com.zaxxer.hikari.HikariConfig - metricsTrackerFactory...........none 15:51:29.865 [main] DEBUG com.zaxxer.hikari.HikariConfig - minimumIdle.....................0 15:51:29.865 [main] DEBUG com.zaxxer.hikari.HikariConfig - password........................<masked> 15:51:29.865 [main] DEBUG com.zaxxer.hikari.HikariConfig - poolName........................"bewspool" 15:51:29.865 [main] DEBUG com.zaxxer.hikari.HikariConfig - readOnly........................false 15:51:29.866 [main] DEBUG com.zaxxer.hikari.HikariConfig - registerMbeans..................false 15:51:29.866 [main] DEBUG com.zaxxer.hikari.HikariConfig - scheduledExecutor...............none 15:51:29.866 [main] DEBUG com.zaxxer.hikari.HikariConfig - scheduledExecutorService........internal 15:51:29.866 [main] DEBUG com.zaxxer.hikari.HikariConfig - threadFactory...................internal 15:51:29.866 [main] DEBUG com.zaxxer.hikari.HikariConfig - transactionIsolation............"TRANSACTION_READ_COMMITTED" 15:51:29.866 [main] DEBUG com.zaxxer.hikari.HikariConfig - username........................"beserver" 15:51:29.866 [main] DEBUG com.zaxxer.hikari.HikariConfig - validationTimeout...............5000 15:51:29.868 [main] INFO com.zaxxer.hikari.HikariDataSource - bewspool - Starting... net.portswigger.enterprise.common.config.l: Problem creating driver class at net.portswigger.enterprise.common.repository.ax.a(Unknown Source) at net.portswigger.enterprise.common.repository.ax.a(Unknown Source) at net.portswigger.enterprise.common.repository.b.<init>(Unknown Source) at net.portswigger.enterprise.common.repository.b.<init>(Unknown Source) at net.portswigger.enterprise.server.adminuser.AdminUserCreator.main(Unknown Source) at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.base/java.lang.reflect.Method.invoke(Method.java:564) at com.exe4j.runtime.LauncherEngine.launch(LauncherEngine.java:85) at com.install4j.runtime.launcher.UnixLauncher.main(UnixLauncher.java:62) Caused by: java.lang.RuntimeException: Failed to get driver instance for jdbcUrl=jdbc:<my DB>.us-east-2.rds.amazonaws.com:5432/burpenterprise at com.zaxxer.hikari.util.DriverDataSource.<init>(DriverDataSource.java:88) at com.zaxxer.hikari.pool.PoolBase.initializeDataSource(PoolBase.java:323) at com.zaxxer.hikari.pool.PoolBase.<init>(PoolBase.java:114) at com.zaxxer.hikari.pool.HikariPool.<init>(HikariPool.java:105) at com.zaxxer.hikari.HikariDataSource.<init>(HikariDataSource.java:72) at net.portswigger.enterprise.common.repository.ax.a(Unknown Source) ... 10 more Caused by: java.sql.SQLException: No suitable driver at java.sql/java.sql.DriverManager.getDriver(DriverManager.java:299) at com.zaxxer.hikari.util.DriverDataSource.<init>(DriverDataSource.java:81) ... 15 more I am (pretty) sure my DB URL is correctly formatted but could be wrong. I can connect to the DB with the postgresql client from my burp instance. It looks like jdbc issues but I am not sure how to resolve.

John | Last updated: Feb 25, 2020 04:51PM UTC

<Apologies for double posting above> I found my problem. My DB was not being called properly. I left off the postgresql (--dbUrl=jdbc:<my DB>.us-east-2.rds.amazonaws.com:5432/burpenterprise as opposed to --dbUrl=jdbc:postgresql://<my DB>.us-east-2.rds.amazonaws.com:5432/burpenterprise)

Ben, PortSwigger Agent | Last updated: Feb 26, 2020 08:40AM UTC

Hi John, Glad to hear that you were able to resolve your issue. Please do not hesitate to get back in touch if you require assistance with anything else in the future.

Sukru | Last updated: Oct 14, 2022 12:40PM UTC

Hi, I am trying to add an admin account by running the below command I receive "Error querying database. Cause: org.h2.jdbc.JdbcSQLException: Table "GROUPS" not found; SQL statement:" I tried username admin and administrator. Both have the same error. I run this command while burpsuiteenterpriseedition_db.service running and after it stopped but still the same error. Can you please help me how to fix this error? buntu@ip-10-24-3-218:/opt/burpsuite_enterprise$ sudo ./adminusercreator --usernam e=admin --password=newpassword --email=secteam@company.com --dbUrl=jdbc:h2:/var/lib/BurpSuiteEnterpriseEdition/data/burpsuiteenterpriceedition_db --dbUsername=BURP_ENTERPRISE --dbPassword=XXXXXXXX Create admin user on URL:jdbc:h2:/var/lib/BurpSuiteEnterpriseEdition/data/burpsuit eenterpriceedition_db, User: BURP_ENTERPRISE 11:18:51.087 [main] INFO net.portswigger.enterprise.common.repository.g - Creating data source for URL: jdbc:h2:/var/lib/BurpSuiteEnterpriseEdition/data/burpsuiteen terpriceedition_db, username: BURP_ENTERPRISE 11:18:51.093 [main] INFO net.portswigger.enterprise.common.repository.g - DB timeo uts: idle=60000, max life=120000 11:18:51.126 [main] DEBUG com.zaxxer.hikari.HikariConfig - bewspool - configuratio n: 11:18:51.144 [main] DEBUG com.zaxxer.hikari.HikariConfig - allowPoolSuspension.... .........false 11:18:51.144 [main] DEBUG com.zaxxer.hikari.HikariConfig - autoCommit............. .........true 11:18:51.149 [main] DEBUG com.zaxxer.hikari.HikariConfig - catalog................ .........none 11:18:51.150 [main] DEBUG com.zaxxer.hikari.HikariConfig - connectionInitSql...... .........none 11:18:51.150 [main] DEBUG com.zaxxer.hikari.HikariConfig - connectionTestQuery.... .........none 11:18:51.151 [main] DEBUG com.zaxxer.hikari.HikariConfig - connectionTimeout...... .........10000 11:18:51.151 [main] DEBUG com.zaxxer.hikari.HikariConfig - dataSource............. .........none 11:18:51.151 [main] DEBUG com.zaxxer.hikari.HikariConfig - dataSourceClassName.... .........none 11:18:51.151 [main] DEBUG com.zaxxer.hikari.HikariConfig - dataSourceJNDI......... .........none 11:18:51.156 [main] DEBUG com.zaxxer.hikari.HikariConfig - dataSourceProperties... .........{password=<masked>} 11:18:51.157 [main] DEBUG com.zaxxer.hikari.HikariConfig - driverClassName........ .........none 11:18:51.157 [main] DEBUG com.zaxxer.hikari.HikariConfig - healthCheckProperties.. .........{} 11:18:51.157 [main] DEBUG com.zaxxer.hikari.HikariConfig - healthCheckRegistry.... .........com.codahale.metrics.health.HealthCheckRegistry@6379eb 11:18:51.158 [main] DEBUG com.zaxxer.hikari.HikariConfig - idleTimeout............ .........60000 11:18:51.159 [main] DEBUG com.zaxxer.hikari.HikariConfig - initializationFailFast. .........false 11:18:51.159 [main] DEBUG com.zaxxer.hikari.HikariConfig - initializationFailTimeo ut.......-1 11:18:51.159 [main] DEBUG com.zaxxer.hikari.HikariConfig - isolateInternalQueries. .........false 11:18:51.160 [main] DEBUG com.zaxxer.hikari.HikariConfig - jdbc4ConnectionTest.... .........false 11:18:51.160 [main] DEBUG com.zaxxer.hikari.HikariConfig - jdbcUrl................ ........."jdbc:h2:/var/lib/BurpSuiteEnterpriseEdition/data/burpsuiteenterpriceedit ion_db" 11:18:51.160 [main] DEBUG com.zaxxer.hikari.HikariConfig - leakDetectionThreshold. .........0 11:18:51.160 [main] DEBUG com.zaxxer.hikari.HikariConfig - maxLifetime............ .........120000 11:18:51.161 [main] DEBUG com.zaxxer.hikari.HikariConfig - maximumPoolSize........ .........10 11:18:51.161 [main] DEBUG com.zaxxer.hikari.HikariConfig - metricRegistry......... .........com.codahale.metrics.MetricRegistry@294425a7 11:18:51.161 [main] DEBUG com.zaxxer.hikari.HikariConfig - metricsTrackerFactory.. .........none 11:18:51.161 [main] DEBUG com.zaxxer.hikari.HikariConfig - minimumIdle............ .........0 11:18:51.162 [main] DEBUG com.zaxxer.hikari.HikariConfig - password............... .........<masked> 11:18:51.162 [main] DEBUG com.zaxxer.hikari.HikariConfig - poolName............... ........."bewspool" 11:18:51.162 [main] DEBUG com.zaxxer.hikari.HikariConfig - readOnly............... .........false 11:18:51.163 [main] DEBUG com.zaxxer.hikari.HikariConfig - registerMbeans......... .........false 11:18:51.163 [main] DEBUG com.zaxxer.hikari.HikariConfig - scheduledExecutor...... .........none 11:18:51.163 [main] DEBUG com.zaxxer.hikari.HikariConfig - scheduledExecutorServic e........internal 11:18:51.164 [main] DEBUG com.zaxxer.hikari.HikariConfig - threadFactory.......... .........internal 11:18:51.164 [main] DEBUG com.zaxxer.hikari.HikariConfig - transactionIsolation... ........."TRANSACTION_READ_COMMITTED" 11:18:51.164 [main] DEBUG com.zaxxer.hikari.HikariConfig - username............... ........."BURP_ENTERPRISE" 11:18:51.164 [main] DEBUG com.zaxxer.hikari.HikariConfig - validationTimeout...... .........5000 11:18:51.169 [main] INFO com.zaxxer.hikari.HikariDataSource - bewspool - Starting. .. 11:18:51.632 [main] INFO com.zaxxer.hikari.HikariDataSource - bewspool - Start com pleted. 11:18:51.735 [bewspool housekeeper] DEBUG com.zaxxer.hikari.pool.HikariPool - bews pool - Before cleanup stats (total=0, active=0, idle=0, waiting=0) 11:18:51.750 [bewspool housekeeper] DEBUG com.zaxxer.hikari.pool.HikariPool - bews pool - After cleanup stats (total=0, active=0, idle=0, waiting=0) 11:18:51.973 [main] DEBUG org.apache.ibatis.logging.LogFactory - Logging initializ ed using 'class org.apache.ibatis.logging.slf4j.Slf4jImpl' adapter. WARNING: An illegal reflective access operation has occurred WARNING: Illegal reflective access by com.google.inject.internal.cglib.core.$Refle ctUtils$1 (file:/opt/burpsuite_enterprise/enterpriseServer/1.0.12beta/lib/guice-4. 2.2.jar) to method java.lang.ClassLoader.defineClass(java.lang.String,byte[],int,i nt,java.security.ProtectionDomain) WARNING: Please consider reporting this to the maintainers of com.google.inject.in ternal.cglib.core.$ReflectUtils$1 WARNING: Use --illegal-access=warn to enable warnings of further illegal reflectiv e access operations WARNING: All illegal access operations will be denied in a future release 11:18:52.721 [main] DEBUG org.apache.ibatis.logging.LogFactory - Logging initializ ed using 'class org.apache.ibatis.logging.slf4j.Slf4jImpl' adapter. 11:18:54.307 [main] DEBUG org.apache.ibatis.transaction.jdbc.JdbcTransaction - Ope ning JDBC Connection 11:18:54.557 [bewspool connection adder] DEBUG com.zaxxer.hikari.pool.HikariPool - bewspool - Added connection conn0: url=jdbc:h2:/var/lib/BurpSuiteEnterpriseEditio n/data/burpsuiteenterpriceedition_db user=BURP_ENTERPRISE 11:18:54.560 [main] DEBUG org.apache.ibatis.transaction.jdbc.JdbcTransaction - Set ting autocommit to false on JDBC Connection [HikariProxyConnection@453007883 wrapp ing conn0: url=jdbc:h2:/var/lib/BurpSuiteEnterpriseEdition/data/burpsuiteenterpric eedition_db user=BURP_ENTERPRISE] 11:18:54.575 [main] DEBUG net.portswigger.enterprise.common.repository.mybatis.map pers.GroupMapper.findGroups - ==> Preparing: SELECT g.id as group_id, g.name as g roup_name, g.built_in as group_built_in, rg.role_id as role_id, isr.node_id AS inc lude_node_id, esr.node_id AS exclude_node_id, ug.user_id FROM groups g LEFT OUTER JOIN role_groups rg ON g.id = rg.group_id LEFT OUTER JOIN site_restrictions isr ON g.id = isr.group_id AND isr.include = 1 LEFT OUTER JOIN site_restrictions esr ON g.id = esr.group_id AND esr.include = 0 LEFT OUTER JOIN user_groups ug ON g.id = u g.group_id ORDER BY g.name 11:18:54.598 [main] DEBUG org.apache.ibatis.transaction.jdbc.JdbcTransaction - Res etting autocommit to true on JDBC Connection [HikariProxyConnection@453007883 wrap ping conn0: url=jdbc:h2:/var/lib/BurpSuiteEnterpriseEdition/data/burpsuiteenterpri ceedition_db user=BURP_ENTERPRISE] 11:18:54.602 [main] DEBUG org.apache.ibatis.transaction.jdbc.JdbcTransaction - Clo sing JDBC Connection [HikariProxyConnection@453007883 wrapping conn0: url=jdbc:h2: /var/lib/BurpSuiteEnterpriseEdition/data/burpsuiteenterpriceedition_db user=BURP_E NTERPRISE] org.apache.ibatis.exceptions.PersistenceException: ### Error querying database. Cause: org.h2.jdbc.JdbcSQLException: Table "GROUPS" not found; SQL statement: SELECT g.id as group_id, g.name as group_name, g.built_in as group_built_in, rg.r ole_id as role_id, isr.node_id AS include_node_id, esr.node_id AS exclude_node_id, ug.user_id FROM groups g LEFT OUTER JOIN role_groups rg ON g.id = rg.group_id LEFT OUTER JOIN site_restrictions isr ON g.id = isr.group_id AND isr.inclu de = 1 LEFT OUTER JOIN site_restrictions esr ON g.id = esr.group_id AND esr.inclu de = 0 LEFT OUTER JOIN user_groups ug ON g.id = ug.group_id ORDER BY g.name [42102-197] ### The error may exist in net/portswigger/enterprise/common/repository/mybatis/ma ppers/GroupMapper.xml ### The error may involve net.portswigger.enterprise.common.repository.mybatis.map pers.GroupMapper.findGroups ### The error occurred while executing a query ### SQL: SELECT g.id as group_id, g.name as group_name, g.built_ in as group_built_in, rg.role_id as role_id, isr.node_id AS include_node_id, esr.n ode_id AS exclude_node_id, ug.user_id FROM groups g LEFT OUTER JOIN role_groups rg ON g.id = rg.group_id LEFT OUTER JOIN sit e_restrictions isr ON g.id = isr.group_id AND isr.include = 1 LEFT OUTER J OIN site_restrictions esr ON g.id = esr.group_id AND esr.include = 0 LEFT OUTER JOIN user_groups ug ON g.id = ug.group_id ORDER BY g.name ### Cause: org.h2.jdbc.JdbcSQLException: Table "GROUPS" not found; SQL statement: SELECT g.id as group_id, g.name as group_name, g.built_in as group_built_in, rg.r ole_id as role_id, isr.node_id AS include_node_id, esr.node_id AS exclude_node_id, ug.user_id FROM groups g LEFT OUTER JOIN role_groups rg ON g.id = rg.group_id LEFT OUTER JOIN site_restrictions isr ON g.id = isr.group_id AND isr.inclu de = 1 LEFT OUTER JOIN site_restrictions esr ON g.id = esr.group_id AND esr.inclu de = 0 LEFT OUTER JOIN user_groups ug ON g.id = ug.group_id ORDER BY g.name [42102-197] at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFa ctory.java:30) at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(Default SqlSession.java:150) at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(Default SqlSession.java:141) at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMe thodAccessorImpl.java:62) at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(Dele gatingMethodAccessorImpl.java:43) at java.base/java.lang.reflect.Method.invoke(Method.java:564) at org.apache.ibatis.session.SqlSessionManager$SqlSessionInterceptor.invok e(SqlSessionManager.java:357) at com.sun.proxy.$Proxy23.selectList(Unknown Source) at org.apache.ibatis.session.SqlSessionManager.selectList(SqlSessionManage r.java:206) at org.apache.ibatis.binding.MapperMethod.executeForMany(MapperMethod.java :139) at org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:76) at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:59) at com.sun.proxy.$Proxy32.findGroups(Unknown Source) at net.portswigger.enterprise.common.repository.mybatis.m.b(Unknown Source ) at net.portswigger.enterprise.server.adminuser.AdminUserCreator.main(Unkno wn Source) at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMe thodAccessorImpl.java:62) at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(Dele gatingMethodAccessorImpl.java:43) at java.base/java.lang.reflect.Method.invoke(Method.java:564) at com.exe4j.runtime.LauncherEngine.launch(LauncherEngine.java:85) at com.install4j.runtime.launcher.UnixLauncher.main(UnixLauncher.java:62) Caused by: org.h2.jdbc.JdbcSQLException: Table "GROUPS" not found; SQL statement: SELECT g.id as group_id, g.name as group_name, g.built_in as group_built_in, rg.r ole_id as role_id, isr.node_id AS include_node_id, esr.node_id AS exclude_node_id, ug.user_id FROM groups g LEFT OUTER JOIN role_groups rg ON g.id = rg.group_id LEFT OUTER JOIN site_restrictions isr ON g.id = isr.group_id AND isr.inclu de = 1 LEFT OUTER JOIN site_restrictions esr ON g.id = esr.group_id AND esr.inclu de = 0 LEFT OUTER JOIN user_groups ug ON g.id = ug.group_id ORDER BY g.name [42102-197] at org.h2.message.DbException.getJdbcSQLException(DbException.java:357) at org.h2.message.DbException.get(DbException.java:179) at org.h2.message.DbException.get(DbException.java:155) at org.h2.command.Parser.readTableOrView(Parser.java:5920) at org.h2.command.Parser.readTableFilter(Parser.java:1430) at org.h2.command.Parser.parseSelectSimpleFromPart(Parser.java:2138) at org.h2.command.Parser.parseSelectSimple(Parser.java:2287) at org.h2.command.Parser.parseSelectSub(Parser.java:2133) at org.h2.command.Parser.parseSelectUnion(Parser.java:1946) at org.h2.command.Parser.parseSelect(Parser.java:1919) at org.h2.command.Parser.parsePrepared(Parser.java:463) at org.h2.command.Parser.parse(Parser.java:335) at org.h2.command.Parser.parse(Parser.java:307) at org.h2.command.Parser.prepareCommand(Parser.java:278) at org.h2.engine.Session.prepareLocal(Session.java:611) at org.h2.engine.Session.prepareCommand(Session.java:549) at org.h2.jdbc.JdbcConnection.prepareCommand(JdbcConnection.java:1247) at org.h2.jdbc.JdbcPreparedStatement.<init>(JdbcPreparedStatement.java:76) at org.h2.jdbc.JdbcConnection.prepareStatement(JdbcConnection.java:304) at com.zaxxer.hikari.pool.ProxyConnection.prepareStatement(ProxyConnection .java:311) at com.zaxxer.hikari.pool.HikariProxyConnection.prepareStatement(HikariPro xyConnection.java) at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMe thodAccessorImpl.java:62) at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(Dele gatingMethodAccessorImpl.java:43) at java.base/java.lang.reflect.Method.invoke(Method.java:564) at org.apache.ibatis.logging.jdbc.ConnectionLogger.invoke(ConnectionLogger .java:55) at com.sun.proxy.$Proxy47.prepareStatement(Unknown Source) at org.apache.ibatis.executor.statement.PreparedStatementHandler.instantia teStatement(PreparedStatementHandler.java:87) at org.apache.ibatis.executor.statement.BaseStatementHandler.prepare(BaseS tatementHandler.java:88) at org.apache.ibatis.executor.statement.RoutingStatementHandler.prepare(Ro utingStatementHandler.java:59) at org.apache.ibatis.executor.SimpleExecutor.prepareStatement(SimpleExecut or.java:85) at org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:6 2) at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor. java:326) at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:156) at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:1 09) at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:8 3) at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMe thodAccessorImpl.java:62) at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(Dele gatingMethodAccessorImpl.java:43) at java.base/java.lang.reflect.Method.invoke(Method.java:564) at org.apache.ibatis.plugin.Invocation.proceed(Invocation.java:49) at net.portswigger.enterprise.common.repository.j.intercept(Unknown Source ) at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:61) at com.sun.proxy.$Proxy46.query(Unknown Source) at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(Default SqlSession.java:148) ... 20 more

Maia, PortSwigger Agent | Last updated: Oct 14, 2022 02:45PM UTC

Hi, Rather than using ./adminusercreator you can reset the administrator account password using the instructions in the link below. If the administrator account does not exist then a new account with that name will be created. https://portswigger.net/burp/documentation/enterprise/managing-users-and-permissions/reset-admin-password

Sukru | Last updated: Oct 15, 2022 10:52PM UTC

Hi Maia, Thanks for your answer. I have tried reset-admin-password link you provided but I keep receiving "./resetAdministratorPassword: command not found" error whenever I run "sudo ./resetAdministratorPassword xxxxxx". I have run this in the installation directory (/opt/burpsuite_enterprise/" Can you please tell me how to fix this error?

Maia, PortSwigger Agent | Last updated: Oct 17, 2022 10:40AM UTC

Can you let me know which version of Burp Suite Enterprise Edition you are using please? Do you see the resetAdministratorPassword script in the installation directory?

Sukru | Last updated: Oct 18, 2022 09:15PM UTC

Hi Maia, We are using "burpsuite_enterprise_linux_v1_0_12beta" version. Please see below setup file. I don't see resetAdministratorPassword script in the installation directory. Please see below for the list of files and folders in the installation folder. ubuntu@ip-10-24-3-218:~$ ls burpenterprise/ 'Burp Suite Enterprise Edition installation instructions.html' burpsuite_enterprise_linux_v1_0_12beta.sh 'Burp Suite Enterprise Edition installation instructions_files' images ubuntu@ip-10-24-3-218:/opt/burpsuite_enterprise$ ls adminusercreator adminusercreator.vmoptions agentkeyuploader agentkeyuploader.vmoptions burp burpsuiteenterpriseedition_agent burpsuiteenterpriseedition_agent.vmoptions burpsuiteenterpriseedition_db burpsuiteenterpriseedition_db.vmoptions burpsuiteenterpriseedition_enterpriseserver burpsuiteenterpriseedition_enterpriseserver.vmoptions burpsuiteenterpriseedition_webserver burpsuiteenterpriseedition_webserver.vmoptions database database_migration database_migration.vmoptions databaseconnectionchecker databaseconnectionchecker.vmoptions enterpriseAgent enterpriseServer eula_acceptance_uploader eula_acceptance_uploader.vmoptions filelockchecker filelockchecker.vmoptions hs_err_pid2316.log jre jres keyhashreader keyhashreader.vmoptions output.log supervisor uninstall webServer ubuntu@ip-10-24-3-218:/opt/burpsuite_enterprise$ Please help me get resetAdministratorPassword script or help me fix the issue "Error querying database. Cause: org.h2.jdbc.JdbcSQLException: Table "GROUPS" not found; SQL statement:" when I run the ./adminusercreator script

Maia, PortSwigger Agent | Last updated: Oct 19, 2022 12:04PM UTC

Hi, The version you are using is very old and was released before the password reset script was included. It looks like you have a typo in the dbUrl value (database name) when running the adminusercreator script. Can you please verify the path of the data directory and database and the database name?

Sukru | Last updated: Oct 19, 2022 11:21PM UTC

Hi Maria, Here are the data directory and database name. ubuntu@ip-10-24-3-218:/var/lib/BurpSuiteEnterpriseEdition/data$ ls burpsuiteenterpriceedition_db.mv.db burpsuiteenterpriceedition_db.mv.mv.db burpsuiteenterpriseedition_db.mv.db burpsuiteenterpriceedition_db.mv.db.mv.db burpsuiteenterpriceedition_db.mv.trace.db burpsuiteenterpriceedition_db.mv.db.trace.db burpsuiteenterpriceedition_db.trace.db keystores ubuntu@ip-10-24-3-218:/var/lib/BurpSuiteEnterpriseEdition/data$

Sukru | Last updated: Oct 19, 2022 11:26PM UTC

As database name, I have tried it below options but no luck burpsuiteenterpriceedition_db burpsuiteenterpriceedition_db.mv burpsuiteenterpriceedition_db.mv.db

Maia, PortSwigger Agent | Last updated: Oct 20, 2022 12:28PM UTC

I'm not sure why you have the files with the enterprice typo in. Did you try using burpsuiteenterpriseedition_db.mv.db? You can also use the database url from the enterprise server configuration file: [installation directory]/enterpriseServer/1.0.12beta/enterprise-server.conf Please use the URL under admin_respository. For example: ./adminusercreator --username=newadmin --password=newpassword --email=some@example.com --dbUrl=jdbc:h2:tcp://localhost/./burpsuiteenterpriseedition_db --dbUsername=burp_enterprise --dbPassword=XXXXXXXX

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