Does python3 support mySQL short passwords and if so how. What needs to be done to allow this. I have a mySQL db with short passwords and cannot access via python 3.2

Asked by Rick Helsen on 2011-09-23

Does python3 support mySQL short passwords and if so how. What needs to be done to allow this. I have a mySQL db with short passwords and cannot access via python 3.2.

This is the error I receive running under linux:

File "/opt/cms/scripts/LoadConairZODSFile.py", line 280, in <module>
    main(prog_name, import_filename)
  File "/opt/cms/scripts/LoadConairZODSFile.py", line 192, in main
    db = mysql.connector.Connect(**config.Config.dbinfo())
  File "/usr/lib/python3.2/site-packages/mysql/connector/__init__.py", line 45, in Connect
    return MySQLConnection(*args, **kwargs)
  File "/usr/lib/python3.2/site-packages/mysql/connector/connection.py", line 361, in __init__
    self.connect(*args, **kwargs)
  File "/usr/lib/python3.2/site-packages/mysql/connector/connection.py", line 398, in connect
    ssl=(ssl_ca, ssl_cert, ssl_key))
  File "/usr/lib/python3.2/site-packages/mysql/connector/connection.py", line 436, in _open_connection
    self._charset)
  File "/usr/lib/python3.2/site-packages/mysql/connector/protocol.py", line 358, in do_auth
    "Authentication with old (insecure) passwords "\
mysql.connector.errors.NotSupportedError: -1: Authentication with old (insecure) passwords is not supported:

Question information

Language:
English Edit question
Status:
Answered
For:
MySQL Connector/Python Edit question
Assignee:
No assignee Edit question
Last query:
2011-09-23
Last reply:
2011-09-23

Short term: move to secure passwords. really!

Long term: might want to wait for newer versions. I vowed not to support it anymore, but well.. we'll see.

Can you help with this problem?

Provide an answer of your own, or ask Rick Helsen for more information if necessary.

To post a message you must log in.