Topic: Odoo (OpenERP) need Postgress - SME 9

[michelandre]

Hi all,

I would like to install Odoo on SME 9. First, I need to install Postgress.

- I created a new VM on VirtualBox. updates etc..
- I read the contrib on Postgress (problem with server.crt & server.key)
  I re-installed etc...
  Finally Postgress started but died in starting or after start.
- I googled and found nothing to properly install Postgress on SME 9.

Is it possible to install Postgress and Odoo on SME 9?

If I find a way to install Odoo on SME 9, I will write a full documentation on how to do it

Any help appreciated,

Michel-André

[guest22]

Hi michelandre,

the best and safest way to install Postgress on SME Server 9.x is to use software collections:

http://wiki.contribs.org/Software_collections

It will allow you to install Postgress (amongst other engines like MariaDB, PHP etc) on SME Server 9.x, without modifying SME Server itself. A ready made example for PHP already exists.

I would suggest to give Software Collections a go for Postgress, and let us know how you go, so we can add t to the wiki

HTH
guest

[Xavier.A]

@ michelandre

In the past I have installed a lot of OpenERP apps for pedagogical and professional reasons. I have wrote some tuto, they are not anymore available online but i can send you them (http://forums.contribs.org/index.php/topic,50531.0.html , http://forums.contribs.org/index.php/topic,50524.0.html).

If you are french, I will prefer to help you there : http://www.developpez.net/forums/f1602/logiciels/solutions-d-entreprise/erp/odoo-ex-openerp/
Before to ask here did you ask help there or on the official forum ? There are a lot of google+ groups, you will find some help there too.

Before to install Odoo, are you sure to need it?
Do you have the required knowledge ? if not, do you know an ERP/xRM consultant (a good one)?
Did you try an alternative installation ? Did you try the online Demo?
Do you know tryton (http://www.tryton.org/)? did you try to install tryton?
Do you know Docker? did you try to install odoo-docker (https://github.com/tinyerp/odoo-docker)?
Did you read the Odoo documentation?
Are you sure that SME9 is the best platform for this sort of software ?
Did you try to install it on another GNU/Linux, in a VM (Virtual Machine)?

Anyway, PostgreSQL are releasing very good rpm for production so why don't you use it (http://www.postgresql.org/download/linux/redhat/#yum)?

Example for postgresql 9.3 on SME 9 64:

Install the pgdg repos and the GPG Key

Code: [Select]

yum install http://yum.postgresql.org/9.3/redhat/rhel-6-x86_64/pgdg-redhat93-9.3-1.noarch.rpm
rpm --import /etc/pki/rpm-gpg/RPM-GPG-KEY-PGDG-93
cat /etc/yum.repos.d/pgdg-93-redhat.repo

add the pgdg repos in the SME DB

Code: [Select]

/sbin/e-smith/db yum_repositories set pgdg93 repository \
Name 'PostgreSQL 9.3' \
BaseURL 'http://yum.postgresql.org/9.3/redhat/rhel-$releasever-$basearch' \
EnableGroups yes \
GPGCheck yes \
GPGKey file:///etc/pki/rpm-gpg/RPM-GPG-KEY-PGDG-93 \
Visible yes \
status disabled
signal-event yum-modify

Verification :

Code: [Select]

db yum_repositories show pgdg93

You don't want to install obsolete rpm

Code: [Select]

db yum_repositories setprop base Exclude 'initscripts,libgsf,postgresql*'
signal-event yum-modify
db yum_repositories show base

you should have a look at migrate fragment (/etc/e-smith/db/yum_repositories/migrate) because sometimes core dev add codes there!

Code: [Select]

ls -l /etc/e-smith/db/yum_repositories/migrate
cat /etc/e-smith/db/yum_repositories/migrate/25CentOSExcludes

Now, you can install postgresql93

Code: [Select]

yum install --enablerepo=pgdg93 postgresql93 postgresql93-libs postgresql93-server \
postgresql93-contrib \
postgresql93-devel \
postgresql93-docs \
postgresql93-test

You need to initialise the db for postgresql

Code: [Select]

/etc/init.d/postgresql-9.3 initdb

You can start your posgresql server

Code: [Select]

/etc/init.d/postgresql-9.3 start

Now you can follow the wiki method (http://wiki.contribs.org/Postgres) to create the necessary template but you have to modify a little bit what the wiki guys have wrote for the template-custom files !

gott nytt år

Xavier

[guest22]

If you are french, I will prefer to help you there : http://www.developpez.net/forums/f1602/logiciels/solutions-d-entreprise/erp/odoo-ex-openerp/
Before to ask here did you ask help there or on the official forum ? There are a lot of google+ groups, you will find some help there too.

I find this a bit rude, to try to draw away focus from michelandre to other fora

Do you know Docker? did you try to install odoo-docker (https://github.com/tinyerp/odoo-docker)?

Since michelandre is asking on the SME Server forums, I would suggest to take a look at http://wiki.contribs.org/Docker

Are you sure that SME9 is the best platform for this sort of software ?

Huh?

Anyway, PostgreSQL are releasing very good rpm for production so why don't you use http://www.postgresql.org/download/linux/redhat/#yum)?

What's wrong with Software Collections, an initiative of Redhat and embrassed by CentOS (and SME Server) ?

Install the pgdg repos and the GPG Key

That is a non supported repo nor a supported procedure. You might want to mention that to michelandre, for when things go wrong, nobody will be able to provide support.

Now you can follow the wiki method (http://wiki.contribs.org/Postgres) to create the necessary template but you have to modify a little bit what the wiki guys have wrote for the template-custom files !

As mentioned before, Software Collections is the safest way without compromising your SME Server installation.

[Xavier.A]

@RequestedDeletion

I find this a bit rude, to try to draw away focus from michelandre to other fora

If you want to fight again in the beginning of this year, I don't have any time for that !
If you think my advices are not good, it's your opinion, it's ok for me !
If you are an Odoo(OpenERP) expert and if you are able to help him, it's ok for me too !

Huh?
What's wrong with Software Collections, an initiative of Redhat and embrassed by CentOS (and SME Server) ?
That is a non supported repo nor a supported procedure. You might want to mention that to michelandre, for when things go wrong, nobody will be able to provide support.

As mentioned before, Software Collections is the safest way without compromising your SME Server installation.

I won't give you any argument why he should use postgresql repos and not software collection repos because you should know why !
But finally I'm wondering why the upstream (postgresql) repos shouldn't be used ! Are you a postgresql developer? Do you have any information about any trouble using PGDG repos?
Could you give him a good reason to follow your method and not the common method followed by all the OpenERP expert!

Well one more fight without any reason, just because you want it ! this is the Peter's syndrome !

@ michelandre
I will not come back here if you want help, you should follow my first advice.

Xavier

[TerryF]

HF, Mark Twain had a simple saying at times like this, when we have that beer together I'll tell you what it is

[Charles2008]

When I was looking around at ERP solutions, I took a look at Xero + Dear Inventory (the Xero bit was on the recommendation of a friend). In the end I didn't pursue Xero + DI, but I did note an informative comment on the Community.Xero.com site relating to DI and other ERP's.

The comment was made by Eric Forsberg of http://www.novak-adapt.com (clearly a company with specific inventory needs).
https://community.xero.com/business/discussion/2210069/

I am not very knowledgeable about Odoo. I know that OpenERP(2006) was a development of TinyERP(2002) and that Tryton(2008) was a fork of OpenERP. I know that Tryton (largely Belgian + other EU dev's)  has a client+server set-up and that the client software for Tryton is fairly well supported amongst Linux distro's e.g. Ubuntu, Fedora, Arch Linux, Debian, Gentoo, openSUZE.

Sorry if this is a little off-thread.

[ReetP]

But finally I'm wondering why the upstream (postgresql) repos shouldn't be used ! Are you a postgresql developer? Do you have any information about any trouble using PGDG repos?

Because as HSF pointed out, they are NOT the recommended repos and if the user used them then they would not have any official support here. I do not have to be a postgres dev to know that. You know that too. If you use the standard repos and there is an issue we can look at it. If they don't then we can't.

Also, when you recommend non standard procedures you should clearly advise users that it may render their system unusable, and they do it at their own risk.

Also note the OPs original question :

I would like to install Odoo on SME 9. First, I need to install Postgress.

We are here to assist with installations on SME, and as HSF quite fairly mentioned, not particularly to point people off to other places unless the information is relevant to installing on SME.

@ michelandre
I will not come back here if you want help, you should follow my first advice.

So now you give the OP some unsupported advice, and then tell him you won't be back to support him because you are upset that someone dared to contradict you.

Yup, that seems very fair. Please cease and desist.

John Crisp

[Xavier.A]

@ReetP

what a clever answer ! Ok, enough !

Because as HSF pointed out, they are NOT the recommended repos and if the user used them then they would not have any official support here. I do not have to be a postgres dev to know that. You know that too. If you use the standard repos and there is an issue we can look at it. If they don't then we can't.

You are an expert and you will do the support for everything....

Also, when you recommend non standard procedures you should clearly advise users that it may render their system unusable, and they do it at their own risk.

Also note the OPs original question :

We are here to assist with installations on SME, and as HSF quite fairly mentioned, not particularly to point people off to other places unless the information is relevant to installing on SME.

Well I will try to make you understand why not so many people want to give you a penny !

First, did you really read the Odoo documentation?
Did you try or succeed to install it before?
Are you a database expert or a database admin?
Are you a python developper? a javascript developper?
Are you an OpenERP, an ERP or a xRM expert?

My method works well and you didn't give any good reason to not use it...you just want to fight again and again and again...with all who are more competent than you !

Go to read the Odoo documentation before to try to fight with me !
and try to understand why I will make him install postgresql 9.3 ! In your software collection you can only find postgresql 9.2 ! but you known that because you are an expert of everything !

Before I asked him a lot of questions to make him wonder if he really needs Odoo and not Tryton, and of course you know why?

Second, the support? support from you ? about what ? postgresql, python, Odoo? For SME may be, but who needs your support?

So now you give the OP some unsupported advice, and then tell him you won't be back to support him because you are upset that someone dared to contradict you.

Yup, that seems very fair. Please cease and desist.

Are you really serious John? you are not talking to a newbie !

You are still wondering why not so many people want to give you any money?
But you are not able to define your business model neither your economic model !

Your answer is just not helpful for the user, my method works and may be you should try to start to respect your users before to ask them to pay !!!

Xavier

[guest22]

First, did you really read the Odoo documentation?
Did you try or succeed to install it before?
Are you a database expert or a database admin?
Are you a python developper? a javascript developper?
Are you an OpenERP, an ERP or a xRM expert?

My method works well and you didn't give any good reason to not use it...you just want to fight again and again and again...with all who are more competent than you !

Go to read the Odoo documentation before to try to fight with me !
and try to understand why I will make him install postgresql 9.3 ! In your software collection you can only find postgresql 9.2 ! but you known that because you are an expert of everything !

Before I asked him a lot of questions to make him wonder if he really needs Odoo and not Tryton, and of course you know why?

Second, the support? support from you ? about what ? postgresql, python, Odoo? For SME may be, but who needs your support?
Are you really serious John? you are not talking to a newbie !

You are still wondering why not so many people want to give you any money?
But you are not able to define your business model neither your economic model !

Your answer is just not helpful for the user, my method works and may be you should try to start to respect your users before to ask them to pay !!!

Xavier

Clearly you have all the answers and knowledge. However, I can not find that in the wiki. Nor did I read anything about it our Bugzilla. Where did you put that please?

[Xavier.A]

@RequestedDeletion

To help the final user is a competition to prove our knowledge, really? you are still not serious !
All the answers are not in your wiki. All of my knowledges are not in your wiki neither my notes about SME!

Should I help you in the bugtracker, yes certainly but do you really worth it!
I'm still wondering why anyone should help you to maintain SME alive and in my case I have so many reasons to not help you. But may be i can still help some users sometimes !

Finally with this discussion about the installation of postgresql, you all, show how you are so efficient to help the final user !

[guest22]

@RequestedDeletion

To help the final user is a competition to prove our knowledge, really? you are still not serious !
ith this discussion about the installation of postgresql, you all, show how you are so efficient to help the final user !

Xavier, I suggest we stop this discussion for there seems to be a discrepancy in understanding each others point of view. The end users no longer understand what we are saying.

[michelandre]

* Last month I was testing Dolibarr which is very simple to install. Then I found that a well known organisation in Montreal (Savoir-Faire Linix) is a big player in ERP and that they are in partnership with Odoo; they have a monthly Meetup in downtown. I googled around and find out that OpenERP/Odoo is quite much better than Dolibarr and very well respected. The only problem is that Odoo worked with PostgreSQL. But I decided to give it a try.

* Originally I followed: http://wiki.contribs.org/Postgres . No success after I tried many times, I am on SME-9.

* Then I found all kind of links and tricks which none of them worked. I even tried to make a new entry in the repository DB (many errors)

* I wrote this note here for help.

* By the time I was waiting for an answer, I found: https://wiki.postgresql.org/wiki/YUM_Installation . With that I finally got PostgreSQL to work but it was version 8.4. With: https://wiki.postgresql.org/wiki/First_steps I tested it and it was functioning.

* Early this morning on devinfo@lists.contribs.org John Crisp wrote about SCL. Interesting... I started to look at it. I was checking if an update or an upgrade will keep the DB...

* While I was looking at SCL, I saw Xavier's comment. I found that it looked quite like what I did to have 8.4 functioning. The way he makes the repo DB is much better and cleaner than what I did. I tried his way and made the test with the link of First_steps. Marvellous, it was fast to install and it worked perfectly. Best of all, the DB was version 9.3. His link: http://www.developpez.net/forums/f1602/logiciels/solutions-d-entreprise/erp/odoo-ex-openerp/ was more than very interesting since it is on Odoo (my final goal).

* Then I saw HSF's comment.
- "That is a non supported repo nor a supported procedure"
- "Software Collections is the safest way without compromising your SME Server installation"

I am with SME since version 5.x around 2003, if I remember correctly. I would like to stay with it even if I know very well OpenSuSE and I am familiar with RHEL, Mint and others...

* My next steps:
- Try SCL
- Go through "Fichier postgresql.conf et guide de configuration" at: http://docs.postgresql.fr/annotated_postgresql_conf_80.html
- Compare the parameters suggested by http://wiki.contribs.org/Postgres to the ones above
- Make a decision
- Install Odoo and play with it
- Write an howto

Busy road ahead...

Thank you all for your interests, very appreciated,

Michel-André

***************************************************
P.S. I wrote this before reading John Crisp'comment. I am very sorry to have started that exchange of "words". I just wanted to help a friend who asked me about SME & ERP.
***************************************************

[stephdl]

- Write an howto

really good idea

[Xavier.A]

@michelandre

I'm so sorry too !

This topic is an example why so many users are leaving this forum : it's very difficult to work with those guys.

One more thing, because I'm a teacher I think it's more pedagogic to let you try to install Odoo by yourself but if you don't succeed you can take contact with me by email.

You will find a lot of documentation online but be carefull some documentation are obsolete !

References :
https://plus.google.com/communities/103144161052599446040
http://sisalp.fr/
http://openerp-online.fr/
http://people.via.ecp.fr/~alexis/openerp/
http://thierry-godin.developpez.com/openerp/memento-technique-openerp-fr/ (v7)

for trunk
https://www.odoo.com/
https://doc.odoo.com/trunk/server/
https://launchpad.net/openobject-server
https://launchpad.net/openobject-addons
https://code.launchpad.net/openerp-extra

for backports :
https://code.launchpad.net/ocb-server
https://code.launchpad.net/ocb-web
https://code.launchpad.net/ocb-addons

A+

Xavier