I installed odoo 9 on a vps. I then restored a dB I had on my local mac. Everything went perfect until I tried editing the website. After a few product ow I getcategory edits (nothing major) I an Infirst got an internal server error trying to load the /web/login and now tI get the internal Server Error just loading the website at ip:8069.
Should I reinstall odoo or remove the website module somehow from the command line?
I tried reinstalling odoo but I get a message saying there is nothing to update.
I ran this command per Damon's and Ermin's instructions:
root@server [/usr/bin]# ./odoo.py -d postgres --db-filter postgres -u baseRunning as user 'root' is a security risk.
2016-12-10 19:36:34,282 4354 INFO ? openerp: OpenERP version 9.0c-201612102016-12-10 19:36:34,282 4354 INFO ? openerp: addons paths: ['/root/.local/share/Odoo/addons/9.0', u'/usr/lib/python2.7/site-packages/openerp/addons']2016-12-10 19:36:34,282 4354 INFO ? openerp: database: default@default:default2016-12-10 19:36:34,284 4354 INFO ? openerp.sql_db: Connection to the database failedTraceback (most recent call last):
File "./odoo.py", line 160, in <module> main() File "./odoo.py", line 157, in main openerp.cli.main() File "/usr/lib/python2.7/site-packages/openerp/cli/command.py", line 64, in main o.run(args) File "/usr/lib/python2.7/site-packages/openerp/cli/server.py", line 165, in run main(args) File "/usr/lib/python2.7/site-packages/openerp/cli/server.py", line 136, in main openerp.service.db._create_empty_database(db_name) File "/usr/lib/python2.7/site-packages/openerp/service/db.py", line 79, in _create_empty_database with closing(db.cursor()) as cr:
File "/usr/lib/python2.7/site-packages/openerp/sql_db.py", line 630, in cursor
return Cursor(self.__pool, self.dbname, self.dsn, serialized=serialized)
File "/usr/lib/python2.7/site-packages/openerp/sql_db.py", line 164, in __init__
self._cnx = pool.borrow(dsn)
File "/usr/lib/python2.7/site-packages/openerp/sql_db.py", line 513, in _locked
return fun(self, *args, **kwargs)
File "/usr/lib/python2.7/site-packages/openerp/sql_db.py", line 581, in borrow
**connection_info) File "/usr/lib64/python2.7/site-packages/psycopg2/__init__.py", line 164, in connect
conn = _connect(dsn, connection_factory=connection_factory, async=async)psycopg2.
OperationalError: FATAL: no pg_hba.conf entry for host "[local]", user "root", database "postgres", SSL off
Its the same I get when running
root@server [/]# systemctl status odoo●
odoo.service - Odoo Open Source ERP and CRM
Loaded: loaded (/usr/lib/systemd/system/odoo.service; enabled; vendor preset: disabled)
Active: active (running) since Sat 2016-12-10 11:43:59 EST; 37min ago
Main PID: 97 (odoo.py) CGroup: /system.slice/odoo.service
└─97 /usr/bin/python /usr/bin/odoo.py --config=/etc/odoo/openerp-server.conf
Dec 10 12:21:15 server odoo.py[97]: return Cursor(self.__pool, self.dbname, self.dsn, serialized=serialized)
Dec 10 12:21:15 server odoo.py[97]: File "/usr/lib/python2.7/site-packages/openerp/sql_db.py", line 164, in __init__
Dec 10 12:21:15 server odoo.py[97]: self._cnx = pool.borrow(dsn)
Dec 10 12:21:15 server odoo.py[97]: File "/usr/lib/python2.7/site-packages/openerp/sql_db.py", line 513, in _locked
Dec 10 12:21:15 server odoo.py[97]: return fun(self, *args, **kwargs)
Dec 10 12:21:15 server odoo.py[97]: File "/usr/lib/python2.7/site-packages/openerp/sql_db.py", line 581, in borrow
Dec 10 12:21:15 server odoo.py[97]: **connection_info)
Dec 10 12:21:15 server odoo.py[97]: File "/usr/lib64/python2.7/site-packages/psycopg2/__init__.py", line 164, in connect
Dec 10 12:21:15 server odoo.py[97]: conn = _connect(dsn, connection_factory=connection_factory, async=async)
Dec 10 12:21:15 server odoo.py[97]: OperationalError: FATAL: no pg_hba.conf entry for host "[local]", user "odoo", database "postgres", SSL off
You should first analyze the corresponding log entries and post them here.
I posted the log files up above in the OP