Burp Suite User Forum

Login to post

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

Hi, Thank you for your message. If you cannot log in using any accounts, restarting the Burp services usually resolves the issue. If you are still unable to log in, I recommend repairing your installation by running the installer (same version as installed) over the top. This will uninstall and reinstall using your previous configuration and the resetAdministratorPassword script should now be present. If you still experience issues after resetting the password, please email us a copy of your Support Pack so we can investigate further.

You need to Log in to post a reply. Or register here, for free.