OpenERP Server with MySQL

Introduction

SAServer is the Enhanced Version OpenERP-Server which supports all Major Databases. Its major aim is to make OpenERP database independent . And customer can make their existing application work with OpenERP as it and able to implement OpenERP easily on the database that is used by customer.

How to get branches?

You need to checkout branch of sa-server from bazaar:

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, Checkout branch from bazaar:

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:<password>@localhost'  --addons-path=../../addons-sa/

Now OpenERP server is ready to work with MySQL Database.