CODEWITHSUNDEEP
postgresqlodoo
Nash
Nash

Reputation: 1073

OpenERP - redirected to "Create a New Database" page when accessing Odoo application

When I try to access my Odoo 8 application I am redirected to Database Management menu and page "Create a New Database". However, there is a database in the system, I can see it through pgAdmin fine, and it worked all the time until now. As far as I know I have not changed anything.

How I can make Odoo 8 connecting to already present database again as it did before?

Thanks for your help!

Upvotes: 4

Views: 4238

Answers (4)

zee
zee

Reputation: 184

You should also check the ownership of the database. If you restore it from psql, make sure you set the owner to your openerp user.

ALTER DATABASE your_db OWNER TO your_openerp_user

DB user & password are either specified from the CLI, i.e.

openerp-server --db_user=openerp --db_password=openerp

or they are specified in the configuration file usually located in :

/etc/openerp/openerp-server.conf

Upvotes: 7

Nash
Nash

Reputation: 1073

What I did is I have backed up main database then restored it to a new database called TestA. When I opened Odoo web site, it picked up TestA database. Then I clicked on "Back to Login" option at the top right corner of the page and after that I was offered to chose between the two databases during login. I selected the main one and Odoo loaded successfully.

Upvotes: 0

Andrew L.
Andrew L.

Reputation: 260

I had this same issue. I kept getting redirected to the login page even though the database was already created. What I did was change the admin password in the database using pgAdmin. At the page where the database creation is on there is a login option.

It's under the res_user table I just did this. After that I logged in I wasn't prompted with the database again.

Update res_user
Set password = 'your_password'
Where login = 'admin'

Upvotes: -1

sandra
sandra

Reputation: 1

For that we must enter the administrator OpenERP database, one of the facilities provided to us in that menu is to restore the database from a backup, another option is to create a new database. A look created the database on the homepage of OpenERP can select the database with which we work and then insert the username and password.

Upvotes: 0

Related Questions