Research Academy
My account Customers About Blog Careers Legal Contact Resellers
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

migrate embedded Windows db to AWS RDS db

Bongiovanni, | Last updated: May 10, 2023 02:29PM UTC

Needed to migrate an embedded db on a Windows server (EOL 2023) to AWS RDS PostgreSQL db. It was a supported configuration they said. But migration did not work. There were errors in the export, the data was not all there and the webserver would not start. Error messages included: ERROR b.web.config.DatabaseUpgradeService - Failed to migrate HTTPS configuration to the database java.lang.NullPointerException: Cannot invoke "net.portswigger.enterprise.common.config.d8.getSecurePort()" because "<local1>" is null And: net.portswigger.enterprise.database.transfer.r: org.postgresql.util.PSQLException: ERROR: permission denied: "RI_ConstraintTrigger_a_678919" is a system trigger Tried multiple times, multiple hosts, sent logs, etc. Advised to repair webserver configuration in the database, upgrade to latest version, etc. Was finally told there was no other solution. Which didn't work for us.. So we figured out how to port from the legacy Windows to AWS RDS PostgreSQL using an intermediate solution. In case it helps you, here is what we did: Used Burpsuite manual migration method to port from embedded Windows db to an AWS EC2 instance running PostgreSQL. After verifying the data, we then used native PostgreSQL tools (pg_dump and pg_restore) to export data from the AWS EC2 instance for import to the AWS RDS PosgreSQL followed by more data verification. Now our new production AL2 (Amazon Linux) Burpsuite EE server points to the AWS RDS PostgreSQL and is running successfully with scan schedules, reports, data preserved.

Thomas, PortSwigger Agent | Last updated: May 11, 2023 01:46PM UTC