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

Error Connecting and Communicating with SkySQL

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Critical
    • Resolution: Fixed
    • Affects Version/s: 1.0.1
    • Fix Version/s: 1.0.2
    • Component/s: DBAPI 2.0
    • Labels:
      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. sample.zip
          8 kB
        2. log.rtf
          57 kB

          Activity

            People

            Assignee:
            georg Georg Richter
            Reporter:
            rhedgpeth Rob Hedgpeth
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: