Koozali.org: home of the SME Server
Contribs.org Forums => General Discussion => Topic started by: michelandre on January 04, 2015, 09:47:18 PM
-
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é
-
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 (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
-
@ 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
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
/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 :
db yum_repositories show pgdg93
You don't want to install obsolete rpm
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!
ls -l /etc/e-smith/db/yum_repositories/migrate
cat /etc/e-smith/db/yum_repositories/migrate/25CentOSExcludes
Now, you can install postgresql93
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
/etc/init.d/postgresql-9.3 initdb
You can start your posgresql server
/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
-
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/ (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)? (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 (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)? (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 (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.
-
@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
-
HF, Mark Twain had a simple saying at times like this, when we have that beer together I'll tell you what it is :-)
-
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.
-
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
-
@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
-
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?
-
@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 !
-
@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.
-
* 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.
***************************************************
-
- Write an howto
really good idea
-
@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
-
* My next steps:
- Try SCL
- Go through "Fichier postgresql.conf et guide de configuration" at: http://docs.postgresql.fr/annotated_postgresql_conf_80.html (http://docs.postgresql.fr/annotated_postgresql_conf_80.html)
- Compare the parameters suggested by http://wiki.contribs.org/Postgres (http://wiki.contribs.org/Postgres) to the ones above
- Make a decision
- Install Odoo and play with it
- Write an howto
Busy road ahead...
And thank you for doing that.
-
This topic is an example why so many users are leaving this forum : it's very difficult to work with those guys.
Anyway you will still find help here or on developez.com from guys like me...and may be, one day those guys will understand why not so many people want to give them a penny for their support!
A+
Xavier, again I find your comments a bit rude, and again you are trying to draw away focus to other fora.
Can you please stop posting your personal frustrations and 'I am not being recognized and I feel under valued' here?
guest
-
I'm so sorry too !
For what please? You have not contributed anything that helped us. If you mean you are sorry for all the noise you are creating, then I personally am happy to accept your apology and I am looking forward to your wiki contributions as you have promised so many times.
I believe you have mentioned you are a teacher if a recall correctly, how would you normally teach a listening audience please?
-
I have just asked to close that conversation....please stop feed the troll
-
locking, as requested
-
***************************************************
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.
***************************************************
Michel,
you didn't. Someone else did. I am very sorry that it descended the way it has. I was merely trying to point out - and as a user since 5.x I am sure you know this already - there is an accepted way of doing things here. That was set in stone before I was here.
Regrettably a certain poster has a historical axe to grind and is happy to do so publicly and as often as possible. It is unfortunate, and quite frankly embarrassing.
As a collective we understand that our users usually seek stability over cutting edge, and that has always been the nature of the distribution.
I can assure you, and anyone else reading this, that we want nothing more than to help users and to ensure a first class, secure, and stable distribution, and therefore we try to discourage people from doing things that may break their system unless they fully understand what they are doing, or are trying to do it as a development project. And in which case the best place to discuss it is the developers list mailing list - do please join it and ask away - or bugzilla, and we are only too happy to help people who want to help themselves and others in a constructive fashion, despite what has been said.
No, not every developer may agree with what you say, or how you want to do it (which is what upset the other poster in the first place), but it is the best place for the discussion. The way forward is always a compromise, and there will always be some differences of opinion. Sometimes we have to agree to disagree, and move on :-)
I am certainly no expert, and have never pretended to be. Nor do I assume the level that other users may have when advising them, so the mantra is always keep it simple, don't do anything that might break your system. If you do advise something that is non standard then advise the user that they may encounter problems.
Quite frankly we have enough bugs to deal with without people installing other repos and then breaking things - we see plenty enough of that already and do not need to add to the pile..... !!!! Unfortunately despite their undoubted intelligence and skill, the other poster never gets involved in fixing anything, and therefore he wouldn't know or care about that.
As I advised you, we support the distribution that we produce, though we are obviously bound by upstream issues if they exist.
Once you start to diverge from our or the standard upstream repos then we start to have a problem, hence my comments. We obviously cannot support every repo and package out there.
Once again, let me assure you that we want to help users in any way we can. What we don't want is people breaking their systems !
I do hope that you will post any results of your endeavours on the wiki. Should you need more help then please join us on the devinfo list here :
http://lists.contribs.org/mailman/listinfo/devinfo
You can also email me personally should you have any other questions.
One again, please accept my apologies for the problems here. This is NOT what the distribution wants to see. It is divisive, non-pedagogic ( ;-) ) and does no one any good.
Kind Regards,
John Crisp