(Migrated) usingi mysql

(This message has been automatically imported from the retired mailing list)

I’m using a fairly fresh ubuntu 12.04 install.

I do the following command:

zato quickstart create ~/quickstart1 mysql localhost 3306 zato1 zatodb1
localhost 6379

File
"/home/ace/zato-bin/zato-1.1/eggs/SQLAlchemy-0.7.9-py2.7-linux-x86_64.egg/sqlalchemy/connectors/mysqldb.py",
line 52, in dbapi
return import(‘MySQLdb’)
ImportError: No module named MySQLdb

tried the following to fix it…

sudo apt-get install python2.7-mysqldb
Reading package lists… Done
Building dependency tree
Reading state information… Done
Note, selecting ‘python-mysqldb’ instead of 'python2.7-mysqldb’
Suggested packages:
python-egenix-mxdatetime python-mysqldb-dbg
The following NEW packages will be installed:
python-mysqldb
0 upgraded, 1 newly installed, 0 to remove and 13 not upgraded.
Need to get 64.0 kB of archives.
After this operation, 221 kB of additional disk space will be used.
Get:1 http://us.archive.ubuntu.com/ubuntu/ precise-updates/main
python-mysqldb amd64 1.2.3-1ubuntu0.1 [64.0 kB]
Fetched 64.0 kB in 0s (94.5 kB/s)
Selecting previously unselected package python-mysqldb.
(Reading database … 76872 files and directories currently installed.)
Unpacking python-mysqldb (from
…/python-mysqldb_1.2.3-1ubuntu0.1_amd64.deb) …
Setting up python-mysqldb (1.2.3-1ubuntu0.1) …

same error… I can only assume it’s a virtualenv thing. suggestions on
what env I need to enter before doing the install ??

fiy, i’ve tryed to cd to zato-common and zato-server and zato-client did

virtualenv .

pip install MySQL-python
Requirement already satisfied (use --upgrade to upgrade): MySQL-python in
/usr/lib/python2.7/dist-packages

thanks again for suggestions.

On 12/29/2013 07:44 PM, Pirate Fibonacci wrote:

File
“/home/ace/zato-bin/zato-1.1/eggs/SQLAlchemy-0.7.9-py2.7-linux-x86_64.egg/sqlalchemy/connectors/mysqldb.py”,
line 52, in dbapi
return import(‘MySQLdb’)
ImportError: No module named MySQLdb

Hi there,

Zato 1.1 will certainly not work with MySQL - there is no support for it
in 1.1.

A user contributed changes needed and there’s an open ticket to make
MySQL a supported database in Zato 1.2

I haven’t looked into it myself yet but you can give it a go by running
from git master instead of 1.1.

On 12/29/2013 07:44 PM, Pirate Fibonacci wrote:

File
“/home/ace/zato-bin/zato-1.1/eggs/SQLAlchemy-0.7.9-py2.7-linux-x86_64.egg/sqlalchemy/connectors/mysqldb.py”,
line 52, in dbapi
return import(‘MySQLdb’)
ImportError: No module named MySQLdb

Hi there,

Zato 1.1 will certainly not work with MySQL - there is no support for it
in 1.1.

A user contributed changes needed and there’s an open ticket to make
MySQL a supported database in Zato 1.2

I haven’t looked into it myself yet but you can give it a go by running
from git master instead of 1.1.

going to give and install from master a shot right now. this hotfix thing
makes sense for an already released image. I’m assuming hotfixman.sh does
not need to be run when we install from master?

On Sun, Dec 29, 2013 at 12:29 PM, Dariusz Suchojad dsuch@zato.io wrote:

On 12/29/2013 07:44 PM, Pirate Fibonacci wrote:

File

“/home/ace/zato-bin/zato-1.1/eggs/SQLAlchemy-0.7.9-py2.7-linux-x86_64.egg/sqlalchemy/connectors/mysqldb.py”,

line 52, in dbapi
return import(‘MySQLdb’)
ImportError: No module named MySQLdb

Hi there,

Zato 1.1 will certainly not work with MySQL - there is no support for it
in 1.1.

A user contributed changes needed and there’s an open ticket to make
MySQL a supported database in Zato 1.2

https://github.com/zatosource/zato/issues/86

I haven’t looked into it myself yet but you can give it a go by running
from git master instead of 1.1.

found solution
https://code.launchpad.net/~wligtenberg/django-openid-auth/mysql_fix/+merge/22726

file ‘django_openid_auth/models.py’

change

  • claimed_id = models.TextField(max_length=2047, unique=True)
  • claimed_id = models.CharField(max_length=255, unique=True)

On Sun, Dec 29, 2013 at 11:44 AM, Pirate Fibonacci
pirate112358@gmail.comwrote:

I’m using a fairly fresh ubuntu 12.04 install.

I do the following command:

zato quickstart create ~/quickstart1 mysql localhost 3306 zato1 zatodb1
localhost 6379

File
"/home/ace/zato-bin/zato-1.1/eggs/SQLAlchemy-0.7.9-py2.7-linux-x86_64.egg/sqlalchemy/connectors/mysqldb.py",
line 52, in dbapi
return import(‘MySQLdb’)
ImportError: No module named MySQLdb

tried the following to fix it…

sudo apt-get install python2.7-mysqldb
Reading package lists… Done
Building dependency tree
Reading state information… Done
Note, selecting ‘python-mysqldb’ instead of 'python2.7-mysqldb’
Suggested packages:
python-egenix-mxdatetime python-mysqldb-dbg
The following NEW packages will be installed:
python-mysqldb
0 upgraded, 1 newly installed, 0 to remove and 13 not upgraded.
Need to get 64.0 kB of archives.
After this operation, 221 kB of additional disk space will be used.
Get:1 http://us.archive.ubuntu.com/ubuntu/ precise-updates/main
python-mysqldb amd64 1.2.3-1ubuntu0.1 [64.0 kB]
Fetched 64.0 kB in 0s (94.5 kB/s)
Selecting previously unselected package python-mysqldb.
(Reading database … 76872 files and directories currently installed.)
Unpacking python-mysqldb (from
…/python-mysqldb_1.2.3-1ubuntu0.1_amd64.deb) …
Setting up python-mysqldb (1.2.3-1ubuntu0.1) …

same error… I can only assume it’s a virtualenv thing. suggestions on
what env I need to enter before doing the install ??

fiy, i’ve tryed to cd to zato-common and zato-server and zato-client did

virtualenv .

pip install MySQL-python
Requirement already satisfied (use --upgrade to upgrade): MySQL-python in
/usr/lib/python2.7/dist-packages

thanks again for suggestions.