Atlassian uses cookies to improve your browsing experience, perform analytics and research, and conduct advertising. Accept all cookies to indicate that you agree to our use of cookies on your device. Atlassian cookies and tracking notice, (opens new window)
Teams
, (opens new window)
SQL for Confluence
Results will update as you type.
  • SQL for Confluence
  • _InclusionsLibrary
  • _Archive
    • User's Guide
    • Administrator's Guide
      • Get Started - Configuration
      • Getting Help And Support
      • Configure Data Sources
      • Configure Data Source Profiles
        • Example profile configurations
        • Troubleshooting Data Source Profiles
          • Data Source Not Found
          • Unable to Connect to Database
          • Unable to Load Database Driver
      • Pro Tips
      • Better Together
      • Editions
      • Analytics Data
    • SQL Macro
    • SQL-file Macro
    • SQL-query Macro
    You‘re viewing this with anonymous access, so some content might be blocked.
    /
    Unable to Connect to Database

    Unable to Connect to Database

    Mar 06, 2018

    Symptoms

    One or more SQL Macro returns the following error:

    Error rendering macro 'sql-query' : Unable to connect to database using jdbc:mysql://<HOSTNAME>:<PORT>/<DBNAME> with user <USER>

    Cause

    Your SQL Macro is referencing a Data Source Profile that has one or more incorrect connection configurations. 

    Resolution

    Double check the connection information associated with this Data Source Profile (Hostname, Port, Database, Username, and Password). 

    , multiple selections available, Use left or right arrow keys to navigate selected items
    howto

    Need support? Create a request with our support team.

    Copyright © 2005 - 2025 Appfire | All rights reserved.

    {"serverDuration": 32, "requestCorrelationId": "377e8575664b44ab9dfe1866616a84a4"}