Odoo Help

0
0
Avatar

Ermin Trevisan

--Ermin Trevisan--
8528
| 6 5 7
Walchwil, Switzerland
--Ermin Trevisan--


Ermin Trevisan
On 12/11/16, 9:15 AM

Why do you touch the database "postgres"???? This database is installed by default and you should not touch it at all. You create a new database and you work with this one only.

What do you mean?

Marcio Valenzuela P
on 12/11/16, 10:01 AM
0
Damon
On 12/10/16, 11:41 AM

Have you tried shutting down database and then restarting things with just the base modules?

I'm on V10 but mine looks like:

sudo service odoo-server stop
./odoo-bin -d databasename --db-filter databasename -u base
This is what I use when I have a custom module go haywire on me and it brings everything to a halt.

so that command above will shutdown the database and restart it?

Marcio Valenzuela P
on 12/10/16, 11:45 AM

oops, I added the shutdown statement before the restart

Damon
on 12/10/16, 11:47 AM

oh ok...im getting this: root@server [/]# sudo service odoo-server stop

Redirecting to /bin/systemctl stop odoo-server.service

Failed to stop odoo-server.service: Unit odoo-server.service not loaded.

root@server [/]#

Marcio Valenzuela P
on 12/10/16, 12:06 PM

your on v9, forgot about that. run the following and look for anything with odoo or openerp in its name and use that after the ./ replacing "odoo-bin" in my script above

<code>service --status-all</code>

Damon
on 12/10/16, 12:22 PM

Please check my OP for the results to systemctl status odoo

Marcio Valenzuela P
on 12/10/16, 12:26 PM

ok

-->sudo service odoo stop

then make sure you are in your odoo directory where odoo.py resides and then

-->./odoo.py -d databasename --db-filter databasename -u base

Damon
on 12/10/16, 12:37 PM

btw, I get nothing with odoo or openerp when i run service status all. I just get something with the word dovecot in it

Marcio Valenzuela P
on 12/10/16, 12:40 PM

if you run top is python running?

Maybe just restart it

sudo reboot -n

Damon
on 12/10/16, 12:42 PM

Ok i get the same as when I run systemctl status odoo...no entry for local, user root, database postgres, SSL OFF

Marcio Valenzuela P
on 12/10/16, 12:43 PM

yes odoo.py is running. I can see it in the top table

Marcio Valenzuela P
on 12/10/16, 12:49 PM

what OS is your VM running?

Damon
on 12/10/16, 1:48 PM

CentOS7

Marcio Valenzuela P
on 12/10/16, 1:58 PM

My server was built on Ubuntu, not completely dif, but dif enough try:

/sbin/chkconfig ––list

look for odoo/openerp .py -bin ?

then try

/sbin/service [name] stop

Once stopped, then cd into the odoo-server dir where odoo.py or odoo-bin or openerp.py is and run

./[name] -d databasename --db-filter databasename -u base

If that doesn't work I'm outta brilliant ideas other than reinstall.

Was your installation on your Mac running under OSX or a VM under OSX?

Damon
on 12/10/16, 2:06 PM

I ran the chkconfig command. i dont have openerp.py but found odoo.py by using find -name and its in ./usr/bin/odoo.py. I can stop it using systemctl stop odoo. As for the last command, should i use my real db or the postgres default db which seems to be causing issues in the pg_hba.conf file? It was on osx using virtual env.

Marcio Valenzuela P
on 12/10/16, 2:30 PM

use the db accessed by Odoo.

In looking again at your log files, I'd reinstall the whole OS, bare minimum w/ openssh server and just install for Odoo which means no MySQL no Apache (LAMP). Because Odoo was initially built ontop of debian, I'd install Ubuntu Server 16.04 w/ just ssh server, then use the following install script to get goin.

http://www.odoo.yenthevg.com/installing-odoo-10-ubuntu-16-04/

Once you have the system setup, you can go to blah.com:8069/web/database/manager and upload your old db, connect to it and see if everything is everything.

Damon
on 12/10/16, 2:39 PM

Damon, I just posted the results from your previous isntructions. As for reinstalling centOS, I dont know if I could do that, its a hosted thing and I dont know how either.

Marcio Valenzuela P
on 12/10/16, 2:42 PM

reinstall postgres

yum install postgresql95-server postgresql95

Damon
on 12/10/16, 2:48 PM

Thx. I got this: root@server [~]# yum install postgresql95-server postgresql95

Loaded plugins: fastestmirror

base | 3.6 kB 00:00:00

epel/x86_64/metalink | 13 kB 00:00:00

epel | 4.3 kB 00:00:00

extras | 3.4 kB 00:00:00

odoo-nightly | 2.9 kB 00:00:00

updates | 3.4 kB 00:00:00

(1/2): epel/x86_64/updateinfo | 682 kB 00:00:00

(2/2): epel/x86_64/primary_db | 4.4 MB 00:00:00

Loading mirror speeds from cached hostfile

* base: centos.mirrors.tds.net

* epel: mirror.nexcess.net

* extras: mirrors.liquidweb.com

* updates: mirror.nexcess.net

No package postgresql95-server available.

No package postgresql95 available.

Error: Nothing to do

Marcio Valenzuela P
on 12/10/16, 3:40 PM

sudo yum install postgresql-server postgresql-contrib

beyond this you're on your own. Good luck

Damon
on 12/10/16, 3:57 PM
Ok thanks!  Could you tell me what that does diffferent from:

yum install postgresql95-server postgresql95


On Sat, Dec 10, 2016 at 2:57 PM, Damon <damon@solutionarts.net> wrote:

sudo yum install postgresql-server postgresql-contrib

beyond this you're on your own. Good luck

--
Damon


Sent by Odoo S.A. using Odoo.




--
Regards/Saludos,

Marcio Valenzuela
www.compasahn.com
Marcio Valenzuela P
on 12/10/16, 9:37 PM
Just a non specific version of Postgres which it looks like your repos prefer. 

On Sat, Dec 10, 2016 at 6:38 PM Marcio Valenzuela <info@compasahn.com> wrote:










Ok thanks!  Could you tell me what that does diffferent from:

yum install postgresql95-server postgresql95


On Sat, Dec 10, 2016 at 2:57 PM, Damon <damon@solutionarts.net> wrote:









sudo yum install postgresql-server postgresql-contrib

beyond this you're on your own. Good luck


--
Damon





Sent by

Odoo S.A.

using
Odoo.




--
Regards/Saludos,

Marcio Valenzuela
www.compasahn.com



--
Santiago EV





Sent by

Odoo S.A.

using
Odoo.



Damon
on 12/10/16, 8:53 PM

About This Community

This community is for professionals and enthusiasts of our products and services. Read Guidelines

Odoo Training Center

Access to our E-learning platform and experience all Odoo Apps through learning videos, exercises and Quizz.

Test it now

Question tools

2 follower(s)

Stats

Asked: 12/9/16, 9:56 PM
Seen: 3575 times
Last updated: 12/11/16, 9:15 AM