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

Unable to use "adminusercreator" on 2022.07 - "resetAdministratorPassword" script doesn't exist.

SOFTWARE | Last updated: Aug 03, 2022 08:53PM UTC

Lost ability to log in using LDAP, and can't seem to find administrator password. Tried to use "adminusercreator" script. It connects to the DB, but fails with: ### Error querying database. Cause: org.h2.jdbc.JdbcSQLException: Column "USERNAME" not found; SQL statement: SELECT id, username, first_name, last_name, email, enabled, last_login_time, password_salt, password_hash, api_user, failed_login_count, last_failed_login_time , group_id FROM users u LEFT OUTER JOIN user_groups ug ON u.id = ug.user_id WHERE username = lower(?) [42122-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.expression.ExpressionColumn.optimize(ExpressionColumn.java:150) at org.h2.command.dml.Select.prepare(Select.java:858) at org.h2.command.Parser.prepareCommand(Parser.java:283) at org.h2.engine.Session.prepareLocal(Session.java:611) at org.h2.server.TcpServerThread.process(TcpServerThread.java:271) at org.h2.server.TcpServerThread.run(TcpServerThread.java:165) at java.base/java.lang.Thread.run(Unknown Source) ### The error may exist in net/portswigger/enterprise/common/repository/mybatis/mappers/UserMapper.xml ### The error may involve net.portswigger.enterprise.common.repository.mybatis.mappers.UserMapper.selectUserByUsername Noticed that the current instructions in the documentation (https://portswigger.net/burp/documentation/enterprise/managing-users-and-permissions/reset-admin-password) reference a "resetAdministratorPassword" script, but it is not in the installation directory. Any assistance is appreciated.

Maia, PortSwigger Agent | Last updated: Aug 04, 2022 09:57AM UTC