Research Academy
My account Customers About Blog Careers Legal Contact Resellers

Burp Suite User Forum

Create new post

Burp Enterprise: Failed to initialize database

Timmins, | Last updated: Jun 18, 2019 10:40AM UTC

Hi, I'm trying to install Burp Enterprise on an already configured database following the documentation here: https://portswigger.net/burp/documentation/enterprise/getting-started/installation#database-setup However, after I configure the database the installation ends with the following. Initializing database ... Failed to initialize database Finishing installation ... No error was presented during installation and got no error in the logs folder. The webserver service also failed to start. Upon restarting the service successfully the following error gets outputted repeatedly. 2019-06-18 10:15:40 ERROR n.p.e.server.StartEnterpriseServer - Database migration mismatch detected... exiting immediately! [main] 2019-06-18 10:15:44 INFO n.p.enterprise.common.config.b - Selected default file 'enterprise-server.config' [main] 2019-06-18 10:15:44 INFO net.portswigger.enterprise.common.l - BuildConstants.ProductVersion: 1.0.17beta-1945 [main] 2019-06-18 10:15:44 INFO n.p.e.server.StartEnterpriseServer - Enterprise Server version 1.0.17beta-1945 [main] 2019-06-18 10:15:44 INFO n.p.e.server.StartEnterpriseServer - Using Java version 9.0.4 [main] 2019-06-18 10:15:45 INFO n.p.enterprise.common.config.a.c - Config has version 4 [main] 2019-06-18 10:15:45 INFO n.p.enterprise.common.repository.d - Creating data source for URL: jdbc:mysql://xxxxxxxxxxxxxxxxx:3306/burpenterprise, username: beserver [main] 2019-06-18 10:15:45 INFO n.p.enterprise.common.repository.d - DB timeouts: idle=60000, max life=120000 [main] 2019-06-18 10:15:49 ERROR n.p.e.server.StartEnterpriseServer - Un-run ChangeSets detected: create_alerts_table, create_jira_settings_table, create_issue_integration_link_table, add_remotelinkid_column_to_issue_integration_link_table, cascade_delete_issues_to_integration_links, create_jira_issue_contexts_table, add_join_table_between_issues_and_issue_integration_link, add_automatically_created_to_issue_integration_link, create_auto_jira_columns, create_jira_work_queue_table, create_issue_tags_table, delete_issue_tags_table, 02-01, 02-02, 02-02-01, add_view_issues_perm_to_scan_initiator_role, 02-03, 02-04, 02-05, 02-06, 02-07, 02-08, 02-09, 02-10, 02-11, 02-12, 02-13, 02-14, 02-15, 02-16, 02-17, delete_unused_alert_permissions, insert sites maintainer role, insert sites maintainer group, insert scan viewers role, insert scan viewers group, add-modify-permissions, remove-licence-permissions, rename-scan-initiators, add_edit_issues_to_administrator, add_scan_results_editor_role, remove-licence-permissions-again, rename customization to configuration, rename credential to application login [main] 2019-06-18 10:15:49 ERROR n.p.e.server.StartEnterpriseServer - Database migration mismatch detected... exiting immediately! [main] Enterprise server: Ubuntu 18.04.2 LTS Database: MySQL 5.7.22 Installing using the console as root.

Liam, PortSwigger Agent | Last updated: Jun 18, 2019 10:46AM UTC

Thanks for this report Adam. We can get more debugging information by using the following options when running the installer at the command line: -Dinstall4j.debug=true -Dinstall4j.logToStderr=true -Dinstall4j.detailStdout=true -Dinstall4j.keepLog=true Adding these options should generate a useful log file for the installation in your temp directory. Would it be possible to send us the file?

Burp User | Last updated: Jun 19, 2019 09:28AM UTC

Couple more bits of info: Running the database in AWS RDS and the Burp Enterprise Server on an EC2 instance. Tried using a different version of MySQL (5.6.43) and MariaDB (10.2.21) and the installation still failed at initializing the database. When I jump into the bupenterprise database I can see that some tables are created from the installation. DATABASECHANGELOG DATABASECHANGELOGLOCK agent_machines application_logins authentication_tokens configuration groups invitation_tokens issue_definitions issue_event_types issues role_groups role_permissions roles scan_configurations scan_status scans schedule_application_logins schedule_item_scan_configs site_restrictions site_tree_application_logins site_tree_excluded_urls site_tree_scan_configurations site_tree_urls site_trees updates user_groups users

Burp User | Last updated: Dec 17, 2019 08:29AM UTC

Were you able to resolve the issue? I am having the exact same issue using Oracle as external database.

Liam, PortSwigger Agent | Last updated: Dec 17, 2019 10:23AM UTC

Murat, you could send us a screenshot of the error message to support@portswigger.net?

Burp User | Last updated: Dec 17, 2019 10:58AM UTC

Me too, using MSSQL as external DB.

Liam, PortSwigger Agent | Last updated: Dec 17, 2019 02:18PM UTC

Lyka, which version of Oracle are you using?

Burp User | Last updated: Dec 23, 2019 03:03AM UTC

Also experiencing this issue, running on AWS EC2 with Postgress AWS database. I am actually re-installing the software on a new EC2 instance and hooking it up with the existing database that is/was already used by Burp running on an EC2 instance we want to deprecate.

Michelle, PortSwigger Agent | Last updated: Dec 23, 2019 02:53PM UTC

Dmitri, at the point where you switch the databases over, the two versions of Enterprise need to be level. Could you let me know which version of Enterprise your original installation was running and what version your new re-installed version is running when you see the error, please?

Gutierrez | Last updated: Apr 03, 2020 07:27AM UTC

Hi. Im having the same problem: 2020-04-03 09:20:25 INFO n.p.enterprise.common.config.d - Selected default file 'enterprise-server.config' [main] 2020-04-03 09:20:25 INFO net.portswigger.enterprise.common.l - BuildConstants.ProductVersion: 2020.2-3025 [main] 2020-04-03 09:20:25 INFO n.p.e.server.StartEnterpriseServer - Enterprise Server version 2020.2-3025 [main] 2020-04-03 09:20:25 INFO n.p.e.server.StartEnterpriseServer - Using Java version 9.0.4 [main] 2020-04-03 09:20:25 INFO n.p.enterprise.common.config.a.a - Config has version 4 [main] 2020-04-03 09:20:26 INFO n.p.enterprise.common.repository.b - Creating data source for URL: jdbc:mariadb://XXXX:YYYY/burpenterprise, username: XXXX [main] 2020-04-03 09:20:26 INFO n.p.enterprise.common.repository.b - DB timeouts: idle=60000, max life=120000 [main] 2020-04-03 09:20:35 ERROR n.p.e.server.StartEnterpriseServer - Un-run ChangeSets detected: prevent_duplicated_site_names_in_root_folder_and_case_sensitive_columns, create_site_email_recipients_table, create_webserver_machines_for_docker, add update time column, add serial number index, update character set on issue_json, add_min_severity_and_confidence_to_auto_jira_settings, update character set on amq, create scan_config_ui table, drop caption column, create_audit_items_table, create_audit_items_errors_table, create_audit_items_issues_table, add audit item scan index, create_event_logs_table, modifyDataType_event_log_type, Add View/Edit Scan Configuration permissions to scan initiator [main] 2020-04-03 09:20:35 ERROR n.p.e.server.StartEnterpriseServer - Database migration mismatch detected... exiting immediately! [main] Like the log said, i am running mariadb in the same instance...

Gutierrez | Last updated: Apr 03, 2020 07:27AM UTC

Hi. Im having the same problem: 2020-04-03 09:20:25 INFO n.p.enterprise.common.config.d - Selected default file 'enterprise-server.config' [main] 2020-04-03 09:20:25 INFO net.portswigger.enterprise.common.l - BuildConstants.ProductVersion: 2020.2-3025 [main] 2020-04-03 09:20:25 INFO n.p.e.server.StartEnterpriseServer - Enterprise Server version 2020.2-3025 [main] 2020-04-03 09:20:25 INFO n.p.e.server.StartEnterpriseServer - Using Java version 9.0.4 [main] 2020-04-03 09:20:25 INFO n.p.enterprise.common.config.a.a - Config has version 4 [main] 2020-04-03 09:20:26 INFO n.p.enterprise.common.repository.b - Creating data source for URL: jdbc:mariadb://XXXX:YYYY/burpenterprise, username: XXXX [main] 2020-04-03 09:20:26 INFO n.p.enterprise.common.repository.b - DB timeouts: idle=60000, max life=120000 [main] 2020-04-03 09:20:35 ERROR n.p.e.server.StartEnterpriseServer - Un-run ChangeSets detected: prevent_duplicated_site_names_in_root_folder_and_case_sensitive_columns, create_site_email_recipients_table, create_webserver_machines_for_docker, add update time column, add serial number index, update character set on issue_json, add_min_severity_and_confidence_to_auto_jira_settings, update character set on amq, create scan_config_ui table, drop caption column, create_audit_items_table, create_audit_items_errors_table, create_audit_items_issues_table, add audit item scan index, create_event_logs_table, modifyDataType_event_log_type, Add View/Edit Scan Configuration permissions to scan initiator [main] 2020-04-03 09:20:35 ERROR n.p.e.server.StartEnterpriseServer - Database migration mismatch detected... exiting immediately! [main] Like the log said, i am running mariadb in the same instance...

Gutierrez | Last updated: Apr 03, 2020 07:27AM UTC

Hi. Im having the same problem: 2020-04-03 09:20:25 INFO n.p.enterprise.common.config.d - Selected default file 'enterprise-server.config' [main] 2020-04-03 09:20:25 INFO net.portswigger.enterprise.common.l - BuildConstants.ProductVersion: 2020.2-3025 [main] 2020-04-03 09:20:25 INFO n.p.e.server.StartEnterpriseServer - Enterprise Server version 2020.2-3025 [main] 2020-04-03 09:20:25 INFO n.p.e.server.StartEnterpriseServer - Using Java version 9.0.4 [main] 2020-04-03 09:20:25 INFO n.p.enterprise.common.config.a.a - Config has version 4 [main] 2020-04-03 09:20:26 INFO n.p.enterprise.common.repository.b - Creating data source for URL: jdbc:mariadb://XXXX:YYYY/burpenterprise, username: XXXX [main] 2020-04-03 09:20:26 INFO n.p.enterprise.common.repository.b - DB timeouts: idle=60000, max life=120000 [main] 2020-04-03 09:20:35 ERROR n.p.e.server.StartEnterpriseServer - Un-run ChangeSets detected: prevent_duplicated_site_names_in_root_folder_and_case_sensitive_columns, create_site_email_recipients_table, create_webserver_machines_for_docker, add update time column, add serial number index, update character set on issue_json, add_min_severity_and_confidence_to_auto_jira_settings, update character set on amq, create scan_config_ui table, drop caption column, create_audit_items_table, create_audit_items_errors_table, create_audit_items_issues_table, add audit item scan index, create_event_logs_table, modifyDataType_event_log_type, Add View/Edit Scan Configuration permissions to scan initiator [main] 2020-04-03 09:20:35 ERROR n.p.e.server.StartEnterpriseServer - Database migration mismatch detected... exiting immediately! [main] Like the log said, i am running mariadb in the same instance...

Gutierrez | Last updated: Apr 03, 2020 07:27AM UTC

Hi. Im having the same problem: 2020-04-03 09:20:25 INFO n.p.enterprise.common.config.d - Selected default file 'enterprise-server.config' [main] 2020-04-03 09:20:25 INFO net.portswigger.enterprise.common.l - BuildConstants.ProductVersion: 2020.2-3025 [main] 2020-04-03 09:20:25 INFO n.p.e.server.StartEnterpriseServer - Enterprise Server version 2020.2-3025 [main] 2020-04-03 09:20:25 INFO n.p.e.server.StartEnterpriseServer - Using Java version 9.0.4 [main] 2020-04-03 09:20:25 INFO n.p.enterprise.common.config.a.a - Config has version 4 [main] 2020-04-03 09:20:26 INFO n.p.enterprise.common.repository.b - Creating data source for URL: jdbc:mariadb://XXXX:YYYY/burpenterprise, username: XXXX [main] 2020-04-03 09:20:26 INFO n.p.enterprise.common.repository.b - DB timeouts: idle=60000, max life=120000 [main] 2020-04-03 09:20:35 ERROR n.p.e.server.StartEnterpriseServer - Un-run ChangeSets detected: prevent_duplicated_site_names_in_root_folder_and_case_sensitive_columns, create_site_email_recipients_table, create_webserver_machines_for_docker, add update time column, add serial number index, update character set on issue_json, add_min_severity_and_confidence_to_auto_jira_settings, update character set on amq, create scan_config_ui table, drop caption column, create_audit_items_table, create_audit_items_errors_table, create_audit_items_issues_table, add audit item scan index, create_event_logs_table, modifyDataType_event_log_type, Add View/Edit Scan Configuration permissions to scan initiator [main] 2020-04-03 09:20:35 ERROR n.p.e.server.StartEnterpriseServer - Database migration mismatch detected... exiting immediately! [main] Like the log said, i am running mariadb in the same instance...

Gutierrez | Last updated: Apr 03, 2020 07:27AM UTC

Hi. Im having the same problem: 2020-04-03 09:20:25 INFO n.p.enterprise.common.config.d - Selected default file 'enterprise-server.config' [main] 2020-04-03 09:20:25 INFO net.portswigger.enterprise.common.l - BuildConstants.ProductVersion: 2020.2-3025 [main] 2020-04-03 09:20:25 INFO n.p.e.server.StartEnterpriseServer - Enterprise Server version 2020.2-3025 [main] 2020-04-03 09:20:25 INFO n.p.e.server.StartEnterpriseServer - Using Java version 9.0.4 [main] 2020-04-03 09:20:25 INFO n.p.enterprise.common.config.a.a - Config has version 4 [main] 2020-04-03 09:20:26 INFO n.p.enterprise.common.repository.b - Creating data source for URL: jdbc:mariadb://XXXX:YYYY/burpenterprise, username: XXXX [main] 2020-04-03 09:20:26 INFO n.p.enterprise.common.repository.b - DB timeouts: idle=60000, max life=120000 [main] 2020-04-03 09:20:35 ERROR n.p.e.server.StartEnterpriseServer - Un-run ChangeSets detected: prevent_duplicated_site_names_in_root_folder_and_case_sensitive_columns, create_site_email_recipients_table, create_webserver_machines_for_docker, add update time column, add serial number index, update character set on issue_json, add_min_severity_and_confidence_to_auto_jira_settings, update character set on amq, create scan_config_ui table, drop caption column, create_audit_items_table, create_audit_items_errors_table, create_audit_items_issues_table, add audit item scan index, create_event_logs_table, modifyDataType_event_log_type, Add View/Edit Scan Configuration permissions to scan initiator [main] 2020-04-03 09:20:35 ERROR n.p.e.server.StartEnterpriseServer - Database migration mismatch detected... exiting immediately! [main] Like the log said, i am running mariadb in the same instance...

Michelle, PortSwigger Agent | Last updated: Apr 03, 2020 07:59AM UTC

This looks like an issue with the database migration during an update. We've responded to your email if you can reply and let us know the OS your Enterprise Server is running we can send you details on how to re-run the migration tool manually.

Ritesh | Last updated: May 27, 2020 10:24AM UTC

Hello Team, I am having exactly same problem. Using AWS RDS - MariaDB 10.2.21 Enterprise server and webserver installed in ec2 instance(O.S RHEL8) During the installation Initializing database ... Failed to initialize database Finishing installation If I check the RDS. All table structure is present there. Please let us know if we are missing anything

Michelle, PortSwigger Agent | Last updated: May 27, 2020 01:36PM UTC

Did you see any other errors during the installation or on attempting to restart any of the services? If you'd prefer to share these directly rather than via the forum you can email them to support@portswigger.net.

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