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@
Now OpenERP server is ready to work with mysql database,
You also need to install python-mysqldb.
RépondreSupprimerIt works perfectly, thanks! is this production ready?
RépondreSupprimerIs this SAserver going to be official any time soon?
I have follow every step in this blog, but when I run openerp-client it can't create database. What should I do?
RépondreSupprimerIs there any news on a Microsoft SQL Server implementation yet?
RépondreSupprimerJunari.com
I have problem starting server:
RépondreSupprimerImportError: No module named dbhandler
where I can find that module ?
hi, I'm new. I download sa-server via Bazaar, it locates at C:\server-sa\trunk.
RépondreSupprimerI installed python 2.6 at C:\Python26
And do not know how to run the Server as service so I can access via http://localhost:8080
Though the article is a bit lengthy, but I really enjoyed reading it. Your post is very much informative and makes my friends to go through it. Keep posting .Thanks.
RépondreSupprimerDedicated Server.
So much useful info posted at here. I am thankful to your for this article. Keep sharing your info in future also.
RépondreSupprimerERP software
It's a pain that this project are discontinued. i'm hope that someday re-launch. there are many differences from version 5 to 6?
RépondreSupprimerDoes it works on OpenErp v7 also???
RépondreSupprimerI'm new to OpenERP, but i want MySql in OpenERP v7. Do i need to download server-sa and addons. if i need, provide me link for addons as i am unable to do. Please exaplain the procedure of installing OpenERP v7 with MySql.
RépondreSupprimerI'm new to OpenERP, but i want MySql in Odoo. Do i need to download server-sa and add-ons. if i need, provide me link for add-ons as i am unable to do. Please explain the procedure of installing Odoo with MySql.
RépondreSupprimerodoo customization
RépondreSupprimerhttp://advanton.com/odoo-erp/
ERP for manufacturing, ecommerce and open source erp: are you looking for odoo implementation? Then choose us. We are experienced, powered by superior technical.
a good topic
RépondreSupprimerGreat post on setting up OpenERP with MySQL! The detailed steps provided are incredibly useful for anyone looking to integrate these platforms. It’s always helpful to see practical guidance like this for those implementing ERP systems. Thanks for sharing this valuable information—it’s a great resource for the community!
RépondreSupprimerepicforcetech