Uploaded image for project: 'MariaDB Connector/Python'
  1. MariaDB Connector/Python
  2. CONPY-110

Error Connecting and Communicating with SkySQL

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Critical
    • Resolution: Fixed
    • 1.0.1
    • 1.0.2
    • DBAPI 2.0
    • None

    Description

      I was previously able to connect to SkySQL using the Python Connector (v. 0.9.59), but am unable to do so with the same configuration with versions 1.0.0+.

      The sample application I am using to test is here. (A react.js front-end with a variety of api project options)

      The Python API project lives here.

      The connection configuration I am using:

      config = {
          'host': os.getenv("DB_HOST"),
          'port': int(os.getenv("DB_PORT")),
          'user': os.getenv("DB_USER"),
          'password': os.getenv("DB_PASS"),
          'database': os.getenv("DB_NAME"),
          'ssl': 'True'
      }
      

      DB_HOST=htap-1.mdb0001390.db.skysql.net
      DB_PORT=5002
      DB_USER=DB00002718
      DB_PASS=y4]0Xhzz8k5N5|tX1O5c207
      DB_NAME=todo
      

      I have also attached:

      • a sample (sample.zip) with my exact settings. I have a running SkySQL instance that can be used to test.
      • a log file containing the error I am experiencing when attempting to connect to SkySQL

      Attachments

        1. log.rtf
          57 kB
        2. sample.zip
          8 kB

        Activity

          People

            georg Georg Richter
            rhedgpeth Rob Hedgpeth (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.