Odoo Help

Welcome!

This community is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.

0

Cannot create, drop, restore, or backup the database on parallel V7.01 server. - ANSWERED

By
Mark Davis
on 8/14/14, 10:08 AM 1,753 views

So.... I have nailed down the problem - just don't see a clear solution at this point.  Here is how I got here.

I have Odoo (OpenERP 7.0-20140622-231040) locally installed on 2 identical servers, using one as a failover.  I have installed a few modules and have entered some data in the system.  Now comes the rub.

After installing a new module, the application locked up the web interface and showed a blank screen, so, of course I ended up reinstalling the odoo application to recover.  After the reinstall, I had access again to the system, but cannot create, drop, restore, or backup the database.  The latest backup works fine on the second server as does the database management of it.

I have verified the system master password in the openerp-server.conf file to make sure it had not changed. 

Without doing a complete removal and reinstallation,  can anyone shine a bit of light on this issue?

Check that there are no idle PostgreSQL processes.

Bista Solutions US, Ray Carnes
on 8/14/14, 11:27 AM

Can you connenct to postgresql database via its client, like pgadmin iii, with postgres role?

Ben Bernard
on 8/27/14, 10:22 PM

I am having no problems with pgAdminIII access to the database. I have full admin level functionality. I have the issue nailed down to needing to COMPLETELY uninstalling (to include Registry Entries) prior to attempting a reinstall, then having all modules manually downloaded into the addons folder after the installation completes. The restored dataset will scan for updates, but does not seem to scan and install from the cloud for the initial module install.

Mark Davis
on 8/28/14, 9:25 AM
0
Quentin THEURET
On 8/14/14, 10:15 AM

Did you have some logs on the server ? Most of the time, problems are logged into OpenERP server log file.

0
Mark Davis
On 8/27/14, 4:10 PM

For Reference:

Both Systems are

Windows Server 2012 R2 Standard

Intel Xeon E5-2420 @ 1.9GHz 1.9 GHz

24Gig RAM  - 64bit OS x64 processor

By "reinstalling"  I meant that I ran the uninstall application located [C:\Program Files (x86)\OpenERP 7.0-20140622-231040].  After the uninstall, I uninstalled the PostgreSQL database, and the Apache web server. 

I then scrubbed down the registry as indicated by an older article [http://www.windowsuninstaller.org/winuninstall/how-to-remove-open-erp-5-0-6-guide-open-erp-5-0-6-uninstaller-info.html] to allow me to reinstall the postgres server component as part of the install.  If you don't clean the windows registry out, the install database component is disabled.  Basically took the system back to MS Server 2012 R2. 

All of this was a true test in futility, as it reinstalled and ran identically each time th application/database/webserver was installed.  As a result, on the 5th, or 20th attempt(it's a bit of a blur after a while) I decided it must be an operator malfunction.  It seems that if you are hosting your own installation, you have to download all of the modules you are using and place them in the addons folder manually [C:\Program Files (x86)\OpenERP 7.0-20140622-231040\Server\server\openerp\addons]

For Beginner Reference Apps are the same thing as Modules here, it's just that if you are operating on the cloud, you refer to them as "Apps"  if you are hosting the install, they are "Modules"

So,  the reason things were not working is that the original configuration and setup was done when the server was logged into the odoo.com account, and downloaded as an App into my setup.  When you perform a backup, and restore to another local setup, it does not go out and log into the App area.  it is wanting the modules to be in the local system. (Or that is the way it seems to be functioning)

Also, I have found that in some of the installed modules it installs "Web GUI Improvement" in the ir.modules.modules table.  This has consistantly removed the filter (Filter and Dashboard) from the interface.  Once I mark the "Web GUI Improvement" as uninstalled, the Filter/Dashboard reappears and is totally functional.  This is identified as a version 7.0.2.0 module.

 

 

0

Ludo - Neobis

--Ludo - Neobis--
2387
| 2 2 5
Hoogvliet, Netherlands
--Ludo - Neobis--

Developer

Ludo - Neobis
On 8/14/14, 10:33 AM

What Quentin says, logs would be handy.

You did not mention how you "reinstalled" the odoo application? In my opinion it was only required to restart the server at most. In my 4 years of development I had never had to reinstall the application once. It is very rare to have some code being infected just after you installed it, provided you never modified it yourself in the proces.

Not being able to delete or otherwise manipulate the databases sounds to me like you have no (or insufficient) access rights to the postgres database.  Did you reinstall using another system user that is currently not in the postgres configuration? If that is not the case, change the postgres password to something else and see if that works.

Also I could not find if you are working on a Windows or *Nix based system. If windows then I assume some other expert should look at it.

Your Answer

Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!

About This Community

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

Question tools

3 follower(s)

Stats

Asked: 8/14/14, 10:08 AM
Seen: 1753 times
Last updated: 3/16/15, 8:10 AM