Python 2 and Python 3 on the same maschine install MySQL Connector

Asked by George on 2013-03-23

Hello

I have a little question. I have FreeBSD 8 server, installed Python 2.7.3 and Python 3.3.0 on it.
Then I installed MySQL Connector/Python v 1.0.9 (from dev.mysql.com ) with instructions.

When i run Python 2 and use: "import mysql.connector", everything is ok. But with Python 3 i have an error:

>>> import mysql.connector
Traceback (most recent call last):
  File "<stdin>", line 1, in <module>
  File "./mysql/connector/__init__.py", line 33, in <module>
    from mysql.connector.connection import MySQLConnection
  File "./mysql/connector/connection.py", line 125
    except Exception, err:
                    ^
SyntaxError: invalid syntax

Can someone help to solve this issue? Thanks

Question information

Language:
English Edit question
Status:
Solved
For:
MySQL Connector/Python Edit question
Assignee:
No assignee Edit question
Solved by:
George
Solved:
2013-03-24
Last query:
2013-03-24
Last reply:
2013-03-24
George (omatic-hacker) said : #1

I think MySQL Connector is not installing with Python 3.
I make default Python version in FreeBSD in /etc/make.conf

PYTHON_VERSION= 2.6
PYTHON_DEFAULT_VERSION= 2.6

but it didn't helped, i used command: python setup.py install -v

console output:

running install
running build
running build_py
running install_lib
running install_egg_info
Removing /usr/local/lib/python2.7/site-packages/mysql_connector_python-1.0.9-py2.7.egg-info
Writing /usr/local/lib/python2.7/site-packages/mysql_connector_python-1.0.9-py2.7.egg-info

Any ideas how to manually install connector to Python 3.3.0?

George (omatic-hacker) said : #2

Sorry, there is mistake on my comment, i used:

PYTHON_VERSION= 3.3
PYTHON_DEFAULT_VERSION= 3.3

George (omatic-hacker) said : #3

Ok, i try to install manually with Pyton3, command:

python3 setup.py install -v
running install
running build
running build_py
running install_lib
byte-compiling /usr/local/lib/python3.3/site-packages/mysql/connector/connection.py to connection.cpython-33.pyc
  File "/usr/local/lib/python3.3/site-packages/mysql/connector/connection.py", line 125
    except Exception, err:
                    ^
SyntaxError: invalid syntax

byte-compiling /usr/local/lib/python3.3/site-packages/mysql/connector/constants.py to constants.cpython-33.pyc
  File "/usr/local/lib/python3.3/site-packages/mysql/connector/constants.py", line 47
    raise TypeError, "Can not instanciate from %s" % cls.__name__
                   ^
SyntaxError: invalid syntax

byte-compiling /usr/local/lib/python3.3/site-packages/mysql/connector/conversion.py to conversion.cpython-33.pyc
  File "/usr/local/lib/python3.3/site-packages/mysql/connector/conversion.py", line 260
    except ValueError, e:
                     ^
SyntaxError: invalid syntax

byte-compiling /usr/local/lib/python3.3/site-packages/mysql/connector/cursor.py to cursor.cpython-33.pyc
  File "/usr/local/lib/python3.3/site-packages/mysql/connector/cursor.py", line 235
    except StandardError, e:
                        ^
SyntaxError: invalid syntax

byte-compiling /usr/local/lib/python3.3/site-packages/mysql/connector/errors.py to errors.cpython-33.pyc
  File "/usr/local/lib/python3.3/site-packages/mysql/connector/errors.py", line 148
    except Exception, err:
                    ^
SyntaxError: invalid syntax

byte-compiling /usr/local/lib/python3.3/site-packages/mysql/connector/network.py to network.cpython-33.pyc
  File "/usr/local/lib/python3.3/site-packages/mysql/connector/network.py", line 101
    except Exception, err:
                    ^
SyntaxError: invalid syntax

byte-compiling /usr/local/lib/python3.3/site-packages/mysql/connector/protocol.py to protocol.cpython-33.pyc
  File "/usr/local/lib/python3.3/site-packages/mysql/connector/protocol.py", line 49
    except Exception, err:
                    ^
SyntaxError: invalid syntax

byte-compiling /usr/local/lib/python3.3/site-packages/mysql/connector/utils.py to utils.cpython-33.pyc
  File "/usr/local/lib/python3.3/site-packages/mysql/connector/utils.py", line 87
    if i < 0 or i > 4294967295L:
                              ^
SyntaxError: invalid syntax

running install_egg_info
Removing /usr/local/lib/python3.3/site-packages/mysql_connector_python-1.0.9-py3.3.egg-info
Writing /usr/local/lib/python3.3/site-packages/mysql_connector_python-1.0.9-py3.3.egg-info

and also had errors...

You will need to remove the build directory when you are installing Python v2 and 3. Otherwise Python will just install what was already build.

shell> python2 setup.py install
shell> rm -Rf build/ dist/
shell> python3 setup.py install

George (omatic-hacker) said : #5

Thank's , I delete those, and /__pycache__ , mysql connector installed properly.