fusionauth logo
search-interface-symbol
Quickstarts
API Docs
SDK
search-interface-symbol
talk to an expert
Log In
talk to an expert
Navigate to...
  • Welcome
  • Getting Started
    • Getting Started
    • 5-minute Setup Guide
      • Overview
      • Docker
      • Fast Path
      • Sandbox
    • Setup Wizard & First Login
    • Register a User and Login
    • Self-service Registration
    • Start and Stop FusionAuth
    • Core Concepts
      • Overview
      • Users
      • Roles
      • Groups
      • Registrations
      • Applications
      • Tenants
      • Identity Providers
      • Authentication/Authorization
      • Integration Points
    • Example Apps
      • Overview
      • Dart
      • Go
      • Java
      • JavaScript
      • .NET Core
      • PHP
      • Python
      • Ruby
    • Tutorials
      • Overview
      • Java Spring
      • Python Django
      • Ruby on Rails
  • Installation Guide
    • Overview
    • System Requirements
    • Server Layout
    • Cloud
    • Cluster
    • Docker
    • Fast Path
    • Kubernetes
      • Overview
      • Deployment Guide
      • Minikube Setup
      • Amazon EKS Setup
      • Google GKE Setup
      • Microsoft AKS Setup
    • Kickstart™
    • Homebrew
    • Marketplaces
    • Packages
    • Database
    • FusionAuth App
    • FusionAuth Search
    • Common Configuration
  • Migration Guide
    • Overview
    • General
    • Auth0
    • Keycloak
    • Amazon Cognito
    • Firebase
    • Microsoft Azure AD B2C
    • Tutorial
  • Admin Guide
    • Overview
    • Account Portal
    • Config Management
    • Editions and Features
    • Key Rotation
    • Licensing
    • Monitoring
    • Prometheus Setup
    • Proxy Setup
    • Reference
      • Overview
      • Configuration
      • CORS
      • Data Types
      • Hosted Login Pages Cookies
      • Known Limitations
      • Password Hashes
    • Releases
    • Roadmap
    • Search And FusionAuth
    • Securing
    • Switch Search Engines
    • Technical Support
    • Troubleshooting
    • Upgrading
    • WebAuthn
  • Login Methods
    • Identity Providers
      • Overview
      • Apple
      • Epic Games
      • External JWT
        • Overview
        • Example
      • Facebook
      • Google
      • HYPR
      • LinkedIn
      • Nintendo
      • OpenID Connect
        • Overview
        • Amazon Cognito
        • Azure AD
        • Discord
        • Github
        • Okta
      • Sony PlayStation Network
      • Steam
      • Twitch
      • Twitter
      • SAML v2
        • Overview
        • ADFS
        • Azure AD
        • Okta
      • SAML v2 IdP Initiated
        • Overview
        • Okta
      • Xbox
    • OIDC & OAuth 2.0
      • Overview
      • Endpoints
      • Tokens
      • OAuth Modes
      • URL Validation
    • Passwordless
      • Overview
      • Magic Links
      • WebAuthn & Passkeys
    • SAML v2 IdP
      • Overview
      • Google
      • PagerDuty
      • Tableau Cloud
      • Zendesk
  • Developer Guide
    • Overview
    • API Gateways
      • Overview
      • Amazon API Gateway
      • Kong Gateway
      • ngrok Cloud Edge
    • Client Libraries & SDKs
      • Overview
      • Dart
      • Go
      • Java
      • JavaScript
      • .NET Core
      • Node
      • OpenAPI
      • PHP
      • Python
      • React
      • Ruby
      • Typescript
    • Events & Webhooks
      • Overview
      • Writing a Webhook
      • Securing Webhooks
      • Events
        • Overview
        • Audit Log Create
        • Event Log Create
        • JWT Public Key Update
        • JWT Refresh
        • JWT Refresh Token Revoke
        • Kickstart Success
        • Group Create
        • Group Create Complete
        • Group Delete
        • Group Delete Complete
        • Group Update
        • Group Update Complete
        • Group Member Add
        • Group Member Add Complete
        • Group Member Remove
        • Group Member Remove Complete
        • Group Member Update
        • Group Member Update Complete
        • User Action
        • User Bulk Create
        • User Create
        • User Create Complete
        • User Deactivate
        • User Delete
        • User Delete Complete
        • User Email Update
        • User Email Verified
        • User IdP Link
        • User IdP Unlink
        • User Login Failed
        • User Login Id Dup. Create
        • User Login Id Dup. Update
        • User Login New Device
        • User Login Success
        • User Login Suspicious
        • User Password Breach
        • User Password Reset Send
        • User Password Reset Start
        • User Password Reset Success
        • User Password Update
        • User Reactivate
        • User Reg. Create
        • User Reg. Create Complete
        • User Reg. Delete
        • User Reg. Delete Complete
        • User Registration Update
        • User Reg. Update Complete
        • User Reg. Verified
        • User 2FA Method Add
        • User 2FA Method Remove
        • User Update
        • User Update Complete
    • Guides
      • Overview
      • Application Specific Email Templates
      • Authentication Tokens
      • Exposing A Local Instance
      • JSON Web Tokens
      • Key Master
      • Localization and Internationalization
      • Multi-Factor Authentication
      • Multi-Tenant
      • Passwordless
      • Registration-based Email Verification
      • Searching With Elasticsearch
      • Securing Your APIs
      • Silent Mode
      • Single Sign-on
      • Two Factor (pre 1.26)
    • Integrations
      • Overview
      • CleanSpeak
      • Kafka
      • Twilio
    • Plugins
      • Overview
      • Writing a Plugin
      • Custom Password Hashing
    • User Control & Gating
      • Overview
      • Gate Unverified Users
      • Gate Unverified Registrations
      • User Account Lockout
  • Customization
    • Email & Templates
      • Overview
      • Configure Email
      • Email Templates
      • Email Variables
      • Message Templates
    • Lambdas
      • Overview
      • Apple Reconcile
      • Client Cred. JWT Populate
      • Epic Games Reconcile
      • External JWT Reconcile
      • Facebook Reconcile
      • Google Reconcile
      • HYPR Reconcile
      • JWT Populate
      • LDAP Connector Reconcile
      • LinkedIn Reconcile
      • Nintendo Reconcile
      • OpenID Connect Reconcile
      • SAML v2 Populate
      • SAML v2 Reconcile
      • SCIM Group Req. Converter
      • SCIM Group Resp. Convtr.
      • SCIM User Req. Converter
      • SCIM User Resp. Converter
      • Self-Service Registration
      • Sony PSN Reconcile
      • Steam Reconcile
      • Twitch Reconcile
      • Twitter Reconcile
      • Xbox Reconcile
    • Messengers
      • Overview
      • Generic Messenger
      • Twilio Messenger
    • Themes
      • Overview
      • Examples
      • Helpers
      • Localization
      • Template Variables
      • Kickstart Custom Theme
  • Premium Features
    • Overview
    • Advanced Registration Forms
    • Advanced Threat Detection
    • Application Specific Themes
    • Breached Password Detection
    • Connectors
      • Overview
      • Generic Connector
      • LDAP Connector
      • FusionAuth Connector
    • Entity Management
    • SCIM
      • Overview
      • Azure AD Client
      • Okta Client
      • SCIM-SDK
    • Self Service Account Mgmt
      • Overview
      • Updating User Data & Password
      • Add Two-Factor Authenticator
      • Add Two-Factor Email
      • Add Two-Factor SMS
      • Add WebAuthn Passkey
      • Customizing
      • Troubleshooting
    • WebAuthn
  • APIs
    • Overview
    • Authentication
    • Errors
    • API Explorer
    • Actioning Users
    • API Keys
    • Applications
    • Audit Logs
    • Connectors
      • Overview
      • Generic
      • LDAP
    • Consents
    • Emails
    • Entity Management
      • Overview
      • Entities
      • Entity Types
      • Grants
    • Event Logs
    • Families
    • Forms
    • Form Fields
    • Groups
    • Identity Providers
      • Overview
      • Links
      • Apple
      • External JWT
      • Epic Games
      • Facebook
      • Google
      • HYPR
      • LinkedIn
      • Nintendo
      • OpenID Connect
      • SAML v2
      • SAML v2 IdP Initiated
      • Sony PlayStation Network
      • Steam
      • Twitch
      • Twitter
      • Xbox
    • Integrations
    • IP Access Control Lists
    • JWT
    • Keys
    • Lambdas
    • Login
    • Message Templates
    • Messengers
      • Overview
      • Generic
      • Twilio
    • Multi-Factor/Two Factor
    • Passwordless
    • Reactor
    • Registrations
    • Reports
    • SCIM
      • Overview
      • SCIM User
      • SCIM Group
      • SCIM EnterpriseUser
      • SCIM Service Provider Config.
    • System
    • Tenants
    • Themes
    • Users
    • User Actions
    • User Action Reasons
    • User Comments
    • WebAuthn
    • Webhooks
  • Release Notes

    Migrate from Inversoft Passport to FusionAuth

    Overview

    If you are currently an Inversoft Passport customer and looking to move to FusionAuth you have come to the right place. Here you’ll find important information on API changes, database upgrade procedures, etc. We have attempted to build an exhaustive list of changes you will need to be aware of, but please do plan to test your migration and ask for assistance from the FusionAuth team during your migration.

    The following sections are provided for you to review prior to upgrading to FusionAuth.

    • Naming Changes

    • License Changes

    • Breaking Changes

    • Database Migration

    • Migration Summary

    Naming Changes

    In addition to the obvious change of Passport to FusionAuth, as you read through the documentation and update your integration be aware of the following name changes.

    Table 1. Name changes
    Old name New Name Description

    Passport

    FusionAuth

    Passport is now known as FusionAuth

    passport.properties

    fusionauth.properties

    The Passport configuration file is now named fusionauth.properties.

    Passport Backend

    FusionAuth App

    The Passport Backend which refers to the webservice that services APIs and provides the UI is now referred as FusionAuth or FusionAuth App.

    passport-backend

    fusionauth-app

    The passport-backend which was the name of the package or bundle which contained the Passport Backend service will now be called fusionauth-app.

    Passport Search Search

    FusionAuth Search

    The Passport Search Search which refers to the webservice that provides search capability to FusionAuth is now referred to FusionAuth Search.

    passport-search-engine

    fusionauth-search

    The passport-search-engine which was the name of the package or bundle which contained the Passport Search Engine service will now be called fusionauth-search.

    X-Passport-TenantId

    X-FusionAuth-TenantId

    The X-Passport-TenantId which was used if you had configured more than one tenant to scope an API request to a particular tenant should be changed to X-FusionAuth-TenantId.

    License Changes

    Because FusionAuth is no longer licensed in a traditional way, no license is required and no license checks are performed during a User create or Registration process. In Passport it was possible to receive a 402 status code indicating the license was expired or had exceeded the allocated usage, this response code will no longer be returned.

    Breaking Changes

    Review the following breaking changes when moving from Passport to FusionAuth. A breaking change means that compatibility has been broken and if your integration will break if you do not review the following changes and update your integration accordingly.

    API Changes

    • When the Search Engine service is down or un-reachable a new status code of 503 will be returned. Previously this error condition would have returned a 500 status code.

    • If you were passing the Tenant Id in an HTTP header, this header X-Passport-TenantId should now be provided as X-FusionAuth-TenantId.

    • Application API

      • Free form data is now available on the Application object, see application.data

    • Audit Log API

      • auditLog.data.attributes moved to auditLog.data

      • auditLog.data.newValue moved to auditLog.newValue

      • auditLog.data.oldValue moved to auditLog.oldValue

      • auditLog.data.reason moved to auditLog.reason

    • Group API

      • group.data.attributes moved to group.data

    • Group Member API

      • groupMember.data.attributes moved to groupMember.data

    • SystemConfiguration API

      • systemConfiguration.failedAuthenticationUserActionId moved to systemConfiguration.failedAuthenticationConfiguration.userActionId

      • systemConfiguration.forgotEmailTemplateId moved to systemConfiguration.emailConfiguration.forgotPasswordEmailTemplateId

      • systemConfiguration.setPasswordEmailTemplateId moved to systemConfiguration.emailConfiguration.setPasswordEmailTemplateId

      • systemConfiguration.verificationEmailTemplateId moved to systemConfiguration.emailConfiguration.verificationEmailTemplateId

      • systemConfiguration.verifyEmail moved to systemConfiguration.emailConfiguration.verifyEmail

      • systemConfiguration.verifyEmailWhenChanged moved to systemConfiguration.emailConfiguration.verifyEmailWhenChanged

    • Tenant API

      • tenant.data.attributes moved to tenant.data

      • tenant.forgotEmailTemplateId moved to tenant.data

      • tenant.setPasswordEmailTemplateId moved to tenant.emailConfiguration.forgotPasswordEmailTemplateId

      • tenant.verificationEmailTemplateId moved to tenant.emailConfiguration.verificationEmailTemplateId

      • tenant.verifyEmail moved to tenant.emailConfiguration.verifyEmail

      • tenant.verifyEmailWhenChanged moved to tenant.emailConfiguration.verifyEmailWhenChanged

    • User API

      • user.data.attributes moved to user.data

      • user.data.preferredLanguages moved to user.preferredLanguages

      • Removed childIds and parentId

    • User Registration API

      • userRegistration.data.attributes moved to userRegistration.data

      • userRegistration.data.timezone moved to userRegistration.timezone

      • userRegistration.data.preferredLanguages moved to userRegistration.preferredLanguages

    Email Templates

    The Forgot Email and Setup Password templates no longer support the verificationId replacement parameter. The verificationId replacement parameter was provided for backwards compatibility with older versions of Passport and has been removed in FusionAuth.

    Review your Forgot Password and Setup Password email templates and if you are using the the replacement value ${verificationId} in either the HTML or Text version of the template, replace it with ${changePasswordId}.

    See Email Templates for additional information.

    Client Libraries

    If you were using a Passport Client library please upgrade to the FusionAuth version. See Client Libraries

    Removed Features

    • Parent and Child relationships between users was removed in FusionAuth. This feature is planned to be re-introduced with better support for a family structure and a more flexible relationship model. If you currently utilize this feature please contact the FusionAuth team for assistance.

    Database Migration

    Due to the data model changes that were made in FusionAuth your database schema will need to be updated. Please be aware that you Passport database MUST be upgraded to the latest version prior to migrating to FusionAuth. The latest Passport version is 1.22.4, the easiest way to upgrade your schema is to install the latest version of Passport and start up the service and allow Maintenance Mode to upgrade your database for you. Once this is complete you may then run the migration script.

    Stop! Read me

    Prior to upgrading to FusionAuth, you MUST upgrade Passport to version 1.22.4. If you do not, this will not work and you will need to restore your database from a backup.

    MySQL

    The following is the MySQL database migration. Please ensure you fully test this migration or contact the FusionAuth team for assistance.

    
    -- Passport to FusionAuth
    
    -- Update the version.
    UPDATE version
    SET version = '1.0.0';
    
    CREATE TABLE instance (
      id         BINARY(16) NOT NULL,
      support_id BINARY(16) NULL
    )
      ENGINE = innodb
      CHARACTER SET utf8mb4
      COLLATE utf8mb4_bin;
    
    -- Insert instance
    INSERT INTO instance(id)
      VALUES (random_bytes(16));
    
    -- Rename the forgot password
    ALTER TABLE system_configuration
      CHANGE COLUMN forgot_email_templates_id forgot_password_email_templates_id BINARY(16) NULL;
    ALTER TABLE tenants
      CHANGE COLUMN forgot_email_templates_id forgot_password_email_templates_id BINARY(16) NULL;
    
    -- Delete the system_configuration columns (verify_email and verify_email_when_changed didn't make it through and need to be manually updated)
    UPDATE system_configuration
    SET data = JSON_INSERT(data, '$.data', CAST('{}' AS JSON));
    UPDATE system_configuration
    SET data = JSON_INSERT(data, '$.emailConfiguration', CAST(email_configuration AS JSON));
    UPDATE system_configuration
    SET data = JSON_INSERT(data, '$.emailConfiguration.verifyEmail', IF(verify_email = 1, TRUE, FALSE) IS TRUE);
    UPDATE system_configuration
    SET data = JSON_INSERT(data, '$.emailConfiguration.verifyEmailWhenChanged', IF(verify_email_when_changed = 1, TRUE, FALSE) IS TRUE);
    UPDATE system_configuration
    SET data = JSON_INSERT(data, '$.passwordValidationRules', CAST(password_validation_rules AS JSON));
    ALTER TABLE system_configuration
      DROP COLUMN email_configuration,
      DROP COLUMN password_expiration_days,
      DROP COLUMN password_validation_rules,
      DROP COLUMN verify_email,
      DROP COLUMN verify_email_when_changed;
    
    -- Add timezone to registration
    ALTER TABLE user_registrations
      ADD COLUMN timezone VARCHAR(255) NULL;
    
    -- Delete parent/child relationships
    ALTER TABLE users
      DROP COLUMN parent_id,
      DROP COLUMN parental_consent_type;
    
    -- Clean up application (two cases because some old Applications might have a data column with the value '{}' only)
    UPDATE applications
    SET data = JSON_INSERT(data, '$.data', CAST('{}' AS JSON));
    UPDATE applications
    SET data = JSON_INSERT(data, '$.cleanSpeakConfiguration', CAST(clean_speak_configuration AS JSON));
    UPDATE applications
    SET data = JSON_INSERT(data, '$.oauthConfiguration', CAST(oauth_configuration AS JSON));
    ALTER TABLE applications
      DROP COLUMN clean_speak_configuration,
      DROP COLUMN oauth_configuration;
    
    -- Fix the data column for audit_logs
    UPDATE audit_logs
    SET data = JSON_REMOVE(JSON_INSERT(data, '$.data', CAST(COALESCE(JSON_EXTRACT(data, '$.attributes'), '{}') AS JSON)), '$.attributes');
    
    -- Fix the data column for groups
    UPDATE groups
    SET data = JSON_REMOVE(JSON_INSERT(data, '$.data', CAST(COALESCE(JSON_EXTRACT(data, '$.attributes'), '{}') AS JSON)), '$.attributes');
    
    -- Fix the data column for group_members
    UPDATE group_members
    SET data = JSON_REMOVE(JSON_INSERT(data, '$.data', CAST(COALESCE(JSON_EXTRACT(data, '$.attributes'), '{}') AS JSON)), '$.attributes');
    
    -- Fix the data column for users
    UPDATE users
    SET data = JSON_REMOVE(JSON_INSERT(data, '$.data', CAST(COALESCE(JSON_EXTRACT(data, '$.attributes'), '{}') AS JSON)), '$.attributes');
    
    -- Fix the data column for user_registrations
    UPDATE user_registrations
    SET data = JSON_REMOVE(JSON_INSERT(data, '$.data', CAST(COALESCE(JSON_EXTRACT(data, '$.attributes'), '{}') AS JSON)), '$.attributes');
    
    -- Fix the data column for tenants
    UPDATE tenants
    SET data = JSON_REMOVE(JSON_INSERT(data, '$.data', CAST(COALESCE(JSON_EXTRACT(data, '$.attributes'), '{}') AS JSON)), '$.attributes');
    UPDATE tenants
    SET data = JSON_INSERT(data, '$.emailConfiguration.verifyEmail', COALESCE(JSON_EXTRACT(data, '$.verifyEmail'), FALSE));
    UPDATE tenants
    SET data = JSON_INSERT(data, '$.emailConfiguration.verifyEmailWhenChanged', COALESCE(JSON_EXTRACT(data, '$.verifyEmailWhenChanged'), FALSE));
    
    -- Fix the internal API key
    DELETE
      FROM authentication_keys
      WHERE id LIKE '__internal_%' AND meta_data LIKE '%"cacheReloader"%';
    INSERT INTO authentication_keys(id, permissions, meta_data, tenants_id)
      VALUES (concat('__internal_', replace(to_base64(random_bytes(64)), '\n', '')),
              '{"endpoints": {"/api/cache/reload": ["POST"]}}', '{"attributes": {"internalCacheReloader": "true"}}', NULL);

    PostgreSQL

    The following is the PostgreSQL database migration. Please ensure you fully test this migration or contact the FusionAuth team for assistance.

    
    \set ON_ERROR_STOP true
    
    -- Passport to FusionAuth
    
    -- Update the version.
    UPDATE version
    SET version = '1.0.0';
    
    CREATE TABLE instance (
      id         UUID NOT NULL,
      support_id UUID NULL
    );
    
    -- Insert instance
    INSERT INTO instance(id)
      VALUES (md5(random() :: TEXT || clock_timestamp() :: TEXT) :: UUID);
    
    -- Rename the forgot password
    ALTER TABLE system_configuration
      RENAME COLUMN forgot_email_templates_id TO forgot_password_email_templates_id;
    ALTER TABLE tenants
      RENAME COLUMN forgot_email_templates_id TO forgot_password_email_templates_id;
    
    -- Delete the system_configuration columns
    -- Delete the system_configuration columns (verify_email and verify_email_when_changed didn't make it through and need to be manually updated)
    UPDATE system_configuration
    SET data = JSONB_SET(data::JSONB, '{data}', '{}', TRUE);
    UPDATE system_configuration
    SET data = JSONB_SET(data::JSONB, '{emailConfiguration}', email_configuration::JSONB, TRUE);
    UPDATE system_configuration
    SET data = JSONB_SET(data::JSONB, '{emailConfiguration,verifyEmail}', TO_JSONB(verify_email), TRUE);
    UPDATE system_configuration
    SET data = JSONB_SET(data::JSONB, '{emailConfiguration,verifyEmailWhenChanged}', TO_JSONB(verify_email_when_changed), TRUE);
    UPDATE system_configuration
    SET data = JSONB_SET(data::JSONB, '{passwordValidationRules}', password_validation_rules::JSONB, TRUE);
    ALTER TABLE system_configuration
      DROP COLUMN email_configuration,
      DROP COLUMN password_expiration_days,
      DROP COLUMN password_validation_rules,
      DROP COLUMN verify_email,
      DROP COLUMN verify_email_when_changed;
    
    -- Add timezone to registration
    ALTER TABLE user_registrations
      ADD COLUMN timezone VARCHAR(255) NULL;
    
    -- Delete parent/child relationships
    ALTER TABLE users
      DROP COLUMN parent_id,
      DROP COLUMN parental_consent_type;
    
    -- Clean up application (two cases because some old Applications might have a data column with the value '{}' only)
    UPDATE applications
    SET data = JSONB_SET(data::JSONB, '{data}', '{}', TRUE);
    UPDATE applications
    SET data = JSONB_SET(data::JSONB, '{cleanSpeakConfiguration}', COALESCE(clean_speak_configuration, '{}')::JSONB, TRUE);
    UPDATE applications
    SET data = JSONB_SET(data::JSONB, '{oauthConfiguration}', COALESCE(oauth_configuration, '{}')::JSONB, TRUE);
    ALTER TABLE applications
      DROP COLUMN clean_speak_configuration,
      DROP COLUMN oauth_configuration;
    
    -- Fix the data column for audit_logs
    UPDATE audit_logs
    SET data = JSONB_SET(data::JSONB, '{data}', COALESCE(data::JSONB -> 'attributes', '{}')::JSONB, TRUE) - 'attributes';
    
    -- Fix the data column for groups
    UPDATE groups
    SET data = JSONB_SET(data::JSONB, '{data}', COALESCE(data::JSONB -> 'attributes', '{}')::JSONB, TRUE) - 'attributes';
    
    -- Fix the data column for group_members
    UPDATE group_members
    SET data = JSONB_SET(data::JSONB, '{data}', COALESCE(data::JSONB -> 'attributes', '{}')::JSONB, TRUE) - 'attributes';
    
    -- Fix the data column for users
    UPDATE users
    SET data = JSONB_SET(data::JSONB, '{data}', COALESCE(data::JSONB -> 'attributes', '{}')::JSONB, TRUE) - 'attributes';
    
    -- Fix the data column for user_registrations
    UPDATE user_registrations
    SET data = JSONB_SET(data::JSONB, '{data}', COALESCE(data::JSONB -> 'attributes', '{}')::JSONB, TRUE) - 'attributes';
    
    -- Fix the data column for tenants
    UPDATE tenants
    SET data = JSONB_SET(data::JSONB, '{data}', COALESCE(data::JSONB -> 'data' -> 'attributes', '{}')::JSONB, TRUE) #- '{data,attributes}';
    UPDATE tenants
    SET data = JSONB_SET(data::JSONB, '{emailConfiguration,verifyEmail}', COALESCE(data::JSONB -> 'verifyEmail', TO_JSONB(FALSE)), TRUE);
    UPDATE tenants
    SET data = JSONB_SET(data::JSONB, '{emailConfiguration,verifyEmailWhenChanged}', COALESCE(data::JSONB -> 'verifyEmailWhenChanged', TO_JSONB(FALSE)), TRUE);
    
    -- Fix the internal API key
    DELETE
      FROM authentication_keys
      WHERE id LIKE '__internal_%' AND meta_data LIKE '%"cacheReloader"%';
    INSERT INTO authentication_keys(id, permissions, meta_data, tenants_id)
      VALUES ('__internal_' || replace(
          encode(md5(random()::TEXT || clock_timestamp()::TEXT)::BYTEA || md5(random()::TEXT || clock_timestamp()::TEXT)::BYTEA, 'base64'),
          E'\n', ''), '{"endpoints": {"/api/cache/reload": ["POST"]}}', '{"attributes": {"internalCacheReloader": "true"}}', NULL);

    Migration Summary

    The following is a summary of the steps required to migration to FusionAuth and is provided as a guidelines to assist you in performing the migration steps in the correct order.

    1. Review all documented changes in this guide

    2. Make a backup of your database

    3. Upgrade Passport to the latest version.

    4. Install the latest version of FusionAuth

    5. Review and migrate settings from passport.properties to fusionauth.properties. You may have other settings that require migration in addition to the following.

      • database.url

      • database.username

      • database.password

      • passport-search-engine.memory is now fusionauth-search.memory

      • passport-backend.memory is now fusionauth-app.memory

    6. Run the SQL migration found above

    7. Start FusionAuth and bring up the UI and complete maintenance mode, you will be prompted to do the following steps:

      • Upgrade the db schema

      • Create search index

    8. Once logged into FusionAuth rebuild the Elasticsearch index

      • Navigate to System → Reindex.

    9. Review your configuration in FusionAuth for accuracy.

    Feedback

    How helpful was this page?

    See a problem?

    File an issue in our docs repo

    Have a question or comment to share?

    Visit the FusionAuth community forum.

    © 2023 FusionAuth
    How-to
    Blog
    Expert Advice
    Download
    Subscribe for developer updates