Http400 Bad request creating initual user webreports

Usage and Config Platform
1

One of my colleagues has set up our bigfix webreports setup a couple of years ago and our initial user is actually documented in our knowledge database.but for some reason we are asked to create an initial user again for bigfix webreports.

We don’t know since when this is, but we thought, ok let’s just make a new initial user again. Except when we submit the details for this new account we get a http 400 bad request.

I went and checked the logs, but i can’t really figure out what the problem is. Someone who can maybe point me in the right direction? I do seem to get a certificate error when accessing the login page and have the idea that maybe it is linked to this. Happy to hear your thoughts.

hu, 31 Aug 2023 14:29:24 +0200 – /post/create-initial-user (2528) – Entering ProcessPOSTRequest
Thu, 31 Aug 2023 14:29:24 +0200 – /post/create-initial-user (2528) – select DatabasePropertyEx( db_name(), ‘collation’ )
Thu, 31 Aug 2023 14:29:24 +0200 – /post/create-initial-user (2528) – select DatabasePropertyEx( db_name(), ‘LCID’ )
Thu, 31 Aug 2023 14:29:24 +0200 – /post/create-initial-user (2528) – select Value from DBINFO where Name = 'Version’
Thu, 31 Aug 2023 14:29:24 +0200 – /post/create-initial-user (2528) – — printing parameters from
Thu, 31 Aug 2023 14:29:24 +0200 – /post/create-initial-user (2528) – newDisplayName=xxxxxxx
Thu, 31 Aug 2023 14:29:24 +0200 – /post/create-initial-user (2528) – newLogin=xxxxxxx
Thu, 31 Aug 2023 14:29:24 +0200 – /post/create-initial-user (2528) – newPassword1=XXXXX
Thu, 31 Aug 2023 14:29:24 +0200 – /post/create-initial-user (2528) – newPassword2=XXXXX
Thu, 31 Aug 2023 14:29:24 +0200 – /post/create-initial-user (2528) – — done.
Thu, 31 Aug 2023 14:29:24 +0200 – /post/create-initial-user (2528) – Entering POST Method: create-initial-user
Thu, 31 Aug 2023 14:29:24 +0200 – /post/create-initial-user (2528) – select case when exists ( select UserID from USERS ) then 1 else 0 end from DBINFO
Thu, 31 Aug 2023 14:29:24 +0200 – /post/create-initial-user (2528) – Exiting POST Method: create-initial-user (0 ms)
Thu, 31 Aug 2023 14:29:24 +0200 – /post/create-initial-user (2528) – Exiting ProcessPOSTRequest (27 ms)

2

When I had an issue that needed to delete the “Local Administrator” of Web Reports - I’ve followed the above documentation but took only the following steps:

Login to the BESReporting database in SQL with a dbowner / sa credentials

  • Find UserID of the user you wish to delete
    Select * from USERS
    Select * from USER_NAMES

  • Append the Right UserID
    delete from USERS where UserID =
    delete from USER_NAMES where UserID =
    delete from ROLE_USER_ASSIGNMENTS where UserID =

Reopen the Web Reports page from the Web Report Server and configure the initial “Local Administrator” for Web Reports

3

Problem had nothing to do with the certificate as i fixed this first and still had the http 400 bad request pop up again.

created a new login based on the info in the original post after i cleaned up a record in the USER_NAMES table which pointed to a deleted user.

Managed to get in and created a new admin login through the administration panel and deleted the admin login with weak password after.

Thanks for the info, solved my problem.

1 Like