Affichage des articles dont le libellé est mysql. Afficher tous les articles
Affichage des articles dont le libellé est mysql. Afficher tous les articles

lundi 24 août 2009

Open ERP Server With MySQL

SAServer will be Enhanced Version Open ERP-Server which will support all Major Databases.
Its main aim is to make Open ERP database independent. So end user can make their existing application as it and able to implement Open ERP easily on the same dababase.

How to get branches?

You need to checkout branch of sa-server :
bzr branch lp:~openerp-commiter/openobject-server/server-sa

For this server you need to get addons from this branch:
bzr branch lp:~openerp-commiter/openobject-addons/addons-sa

Use stable5.0 client for this server:

bzr branch lp:openobject-client/5.0

How to install SQLAlchemy?

Install newer version of sqlalchemy from 0.5.x series,
Download SQLAlchemy from this link:

http://sourceforge.net/projects/sqlalchemy/files/sqlalchemy/SQLAlchemy-0.5.3.tar.gz/download

Configure Mysql

In mysql you need to create new user named tiny:

CREATE USER ‘tiny’@'localhost’ IDENTIFIED BY ‘password’;

Grant privileges to this user by:

GRANT ALL PRIVILEGES ON *.* TO ‘tiny’@'localhost’

How to start server?

You can start sa-server using –engine option,

–engine=’database://USER:PASSWORD@HOSTNAME:PORT’

Where,

USER : mysql user (Super User)
PASSWORD : Password of USER
HOSTNAME : Host on which mysql server is running (By Default : localhost)
PORT : Port on which mysql server is running (By Default : 3306)

Ex: python openerp-server.py –engine=’mysql:tiny@//localhost’ –addons-path=../../addons-sa/

Now OpenERP server is ready to work with mysql database,