How to install OpenERP 6.1 on Ubuntu 10.04 LTS
The new release of OpenERP 6.1 heralds a great many incremental improvements in the product plus a complete re-write of the web interface; which is a massive improvement and much more an integral part of OpenERP than it’s predecessor.
UPDATE: By popular request here is a subsequent post describing how to set up a reverse proxy and ssl using nginx.
As my previous howto for 6.0 was a such roaring success I thought I’d better do something for the new 6.1 release too.
Before continuing, I should mention that you can simply download a “.deb” package of OpenERP 6.1 and install that on Ubuntu. But that doesn’t provide me with enough fine grained control over what and where things get installed and it restricts our flexibility to modify & customise hence I prefer to do it a slightly more manual way… (It should be said though, that this install process should only take about 10-15 minutes once the host machine has been built)
So without further ado here we go:
Step 1. Build your server
I install just the bare minimum from the install routine (you can install the openssh-server
during the install procedure or install subsequently depending on your preference).
After the server has restarted for the first time I install the openssh-server
package (so we can connect to it remotely) and denyhosts
to add a degree of brute-force attack protection. There are other protection applications available: I’m not saying this one is the best, but it’s one that works and is easy to configure and manage. If you don’t already, it’s also worth looking at setting up key-based ssh access, rather than relying on passwords. This can also help to limit the potential of brute-force attacks. [NB: This isn’t a How To on securing your server…]
sudo apt-get install openssh-server denyhosts
Now make sure you are running all the latest patches by doing an update:
sudo apt-get update
sudo apt-get dist-upgrade
Although not always essential it’s probably a good idea to reboot your server now and make sure it all comes back up and you can login via ssh.
Now we’re ready to start the OpenERP install.
Step 2. Create the OpenERP user that will own and run the application
sudo adduser --system --home=/opt/openerp --group openerp
This is a “system†user. It is there to own and run the application, it isn’t supposed to be a person type user with a login etc. In Ubuntu, a system user gets a UID below 1000, has no shell (it’s actually /bin/false
) and has logins disabled. Note that I’ve specified a “home†of /opt/openerp
, this is where the OpenERP server code will reside and is created automatically by the command above. The location of the server code is your choice of course, but be aware that some of the instructions and configuration files below may need to be altered if you decide to install to a different location.
A question I was asked a few times in the previous how to for 6.0 was how to run the OpenERP server as the openerp system user from the command line if it has no shell. This can be done quite easily:
sudo su - openerp -s /bin/bash
This will su
your current terminal login to the openerp user (the “-
” between su
and openerp
is correct) and use the shell /bin/bash
. When this command is run you will be in openerp’s home directory: /opt/openerp
.
When you have done what you need you can leave the openerp user’s shell by typing exit
.
Step 3. Install and configure the database server, PostgreSQL
sudo apt-get install postgresql
Then configure the OpenERP user on postgres:
First change to the postgres user so we have the necessary privileges to configure the database.
sudo su - postgres
Now create a new database user. This is so OpenERP has access rights to connect to PostgreSQL and to create and drop databases. Remember what your choice of password is here; you will need it later on:
createuser --createdb --username postgres --no-createrole --no-superuser --pwprompt openerp
Enter password for new role: ********
Enter it again: ********
Finally exit from the postgres user account:
exit
Step 4. Install the necessary Python libraries for the server
Update 27/02/2012: Many thanks to Gavin for reporting. Have added python-simplejson to the package list.
sudo apt-get install python-dateutil python-feedparser python-gdata \
python-ldap python-libxslt1 python-lxml python-mako python-openid python-psycopg2 \
python-pybabel python-pychart python-pydot python-pyparsing python-reportlab \
python-simplejson python-tz python-vatnumber python-vobject python-webdav \
python-werkzeug python-xlwt python-yaml python-zsi
From what I can tell, on Ubuntu 10.04 the package python-werkzeug is too old and this will cause the server to not start properly. If you are trying this on a later version of Ubuntu then you might be OK, but just in-case you can also do the following.
I found it necessary to install a more recent version of Werkzeug using Python’s own package management library PIP. The python pip tool can be installed like this:
sudo apt-get install python-pip
Then remove Ubuntu’s packaged version of werkzeug:
sudo apt-get remove python-werkzeug
Then install the up-to-date version of werkzeug:
sudo pip install werkzeug
With that done, all the dependencies for installing OpenERP 6.1 are now satisfied, including for the new integral web interface.
Step 5. Install the OpenERP server
I tend to use wget
for this sort of thing and I download the files to my home directory.
Make sure you get the latest version of the application. At the time of writing this it’s 6.1-1; I got the download links from their download page.
wget http://nightly.openerp.com/6.1/releases/openerp-6.1-1.tar.gz
Now install the code where we need it: cd
to the /opt/openerp/
directory and extract the tarball there.
cd /opt/openerp
sudo tar xvf ~/openerp-6.1-1.tar.gz
Next we need to change the ownership of all the the files to the OpenERP user and group.
sudo chown -R openerp: *
And finally, the way I have done this is to copy the server directory to something with a simpler name so that the configuration files and boot scripts don’t need constant editing (I called it, rather unimaginatively, server). I started out using a symlink solution, but I found that when it comes to upgrading, it seems to make more sense to me to just keep a copy of the files in place and then overwrite them with the new code. This way you keep any custom or user-installed modules and reports etc. all in the right place.
sudo cp -a openerp-6.1-1 server
As an example, should OpenERP 6.1-2 come out soon, I can extract the tarballs into /opt/openerp/ as above. I can do any testing I need, then repeat the copy command so that the modified files will overwrite as needed and any custom modules, report templates and such will be retained. Once satisfied the upgrade is stable, the older 6.1-1 directories can be removed if wanted.
That’s the OpenERP server software installed. The last steps to a working system is to set up the configuration file and associated boot script so OpenERP starts and stops automatically when the server itself stops and starts.
Step 6. Configuring the OpenERP application
The default configuration file for the server (in /opt/openerp/server/install/
) is actually very minimal and will, with only one small change work fine so we’ll simply copy that file to where we need it and change it’s ownership and permissions:
sudo cp /opt/openerp/server/install/openerp-server.conf /etc/
sudo chown openerp: /etc/openerp-server.conf
sudo chmod 640 /etc/openerp-server.conf
The above commands make the file owned and writeable only by the openerp user and group and only readable by openerp and root.
To allow the OpenERP server to run initially, you should only need to change one line in this file. Toward to the top of the file change the line db_password = False
to the same password you used back in step 3. Use your favourite text editor here. I tend to use nano, e.g.
sudo nano /etc/openerp-server.conf
One other line we might as well add to the configuration file now, is to tell OpenERP where to write its log file. To complement my suggested location below add the following line to the openerp-server.conf
file:
logfile = /var/log/openerp/openerp-server.log
Once the configuration file is edited and saved, you can start the server just to check if it actually runs.
sudo su - openerp -s /bin/bash
/opt/openerp/server/openerp-server
If you end up with a few lines eventually saying OpenERP is running and waiting for connections then you are all set. Just type CTL+C
to stop the server then exit
to leave the openerp user’s shell.
If there are errors, you’ll need to go back and check where the problem is.
Step 7. Installing the boot script
For the final step we need to install a script which will be used to start-up and shut down the server automatically and also run the application as the correct user. There is a script you can use in /opt/openerp/server/install/openerp-server.init
but this will need a few small modifications to work with the system installed the way I have described above. Here’s a link to the one I’ve already modified for 6.1-1.
Similar to the configuration file, you need to either copy it or paste the contents of this script to a file in /etc/init.d/
and call it openerp-server
. Once it is in the right place you will need to make it executable and owned by root:
sudo chmod 755 /etc/init.d/openerp-server
sudo chown root: /etc/init.d/openerp-server
In the configuration file there’s an entry for the server’s log file. We need to create that directory first so that the server has somewhere to log to and also we must make it writeable by the openerp user:
sudo mkdir /var/log/openerp
sudo chown openerp:root /var/log/openerp
Step 8. Testing the server
To start the OpenERP server type:
sudo /etc/init.d/openerp-server start
You should now be able to view the logfile and see that the server has started.
less /var/log/openerp/openerp-server.log
If there are any problems starting the server you need to go back and check. There’s really no point ploughing on if the server doesn’t start…
If the log file looks OK, now point your web browser at the domain or IP address of your OpenERP server (or localhost if you are on the same machine) and use port 8069. The url will look something like this:
http://IP_or_domain.com:8069
What you should see is a screen like this one:
What I do recommend you do at this point is to change the super admin password to something nice and strong (Click the “Manage Databases” link below the main Login box). By default this password is just “admin” and knowing that, a user can create, backup, restore and drop databases! This password is stored in plain text in the /etc/openerp-server.conf
file; hence why we restricted access to just openerp and root. When you change and save the new password the /etc/openerp-server.conf
file will be re-written and will have a lot more options in it.
Now it’s time to make sure the server stops properly too:
sudo /etc/init.d/openerp-server stop
Check the logfile again to make sure it has stopped and/or look at your server’s process list.
Step 9. Automating OpenERP startup and shutdown
If everything above seems to be working OK, the final step is make the script start and stop automatically with the Ubuntu Server. To do this type:
sudo update-rc.d openerp-server defaults
You can now try rebooting you server if you like. OpenERP should be running by the time you log back in.
If you type ps aux | grep openerp
you should see a line similar to this:
openerp 1491 0.1 10.6 207132 53596 ? Sl 22:23 0:02 python /opt/openerp/server/openerp-server -c /etc/openerp-server.conf
Which shows that the server is running. And of course you can check the logfile or visit the server from your web browser too.
That’s it!
OpenERP 6.1 really is a major step up in terms of improvements from 6.0 and the new integrated web interface (with a Point of Sale and a Mobile interface built-in) are really very cool. Performance has improved considerably and the way the new web service interfaces to OpenERP is very different. So, if I get the time, the next instalment of these posts will go into a bit of detail about how this works and some alternative ways to provide more secure access, such as reverse proxy.
I was wondering if there are any important changes to the upgrade process you outlined in your 6.0.3 article in order to update to 6.1 (in that article you mentioned we had to just replace the old files with the new ones)
Hi Carlos,
Upgrading between minor versions (i.e. 6.0.3 to 6.0.4, or 6.1-1 to 6.1-2) is a fairly simple process.
It is my understanding however, that currently the only supported way to upgrade an existing OpenERP system from 6.0.x to 6.1-x is to use the OpenERP s.a migration service supplied as part of the OpenERP Enterprise Warranty which you can buy through your local OpenERP partner, preferable, or directly from OpenERP s.a. itself.
There is a project whose aim is to provide the necessary tools to upgrade a database from one version to the next but I have not tried this and so cannot comment on its abilities. The project’s home is here and it has two projects Launchpad, one for the addons and one for the server. So feel free to test it and let us know how you get on!.
Have fun 🙂
Thanks for the great tutorial. I followed all the steps accordingly. When I go to the website -> manage database -> create database -> Access Denied error for Database Creation Error.
Any help to resolve this? Thanks.
Hi Eric,
Access Denied sounds like a password issue.
I suggest you go back to the start and make sure you followed the instructions exactly. The password you created for the openerp user in PostgreSQL needs to be used (and the same) in the openerp-server.conf file or you will not be allowed to create databases.
Thanks Alan,
Your the defacto guide for me for installing OpenERP 6.x on Ubuntu.
Simon
Thanks for your answer Alan
[…] Update: 22/02/2012. OpenERP 6.1 was released today. I’ve written a howto for this new version here. […]
Thank you Alan for the great tutorial. I await the second part, with the addition of a security “Reserve Proxy”. I usually used ” http://www.vultureproject.org/ “as reserve proxy what do you think?
Merci encore
au revoir.
@moula,
I have never heard of the Vulture Project before. I would normally just use Apache, but for the next instalment I think I shall use nginx for a change 🙂 I have it working here, so I just need to find the time to test it some more and then write it up nicely.
hello,
thanks you for the tuto but, when i execute /opt/openerp/server/openerp-server
INFO ? openerp.wsgi.core: HTTP service (werkzeug) running on 0.0.0.0:8069
CRITICAL ? openerp.modules.module: Couldn’t load module web
CRITICAL ? openerp.modules.module: No module named wsgi
ERROR ? openerp: Failed to load server-wide module `web`.
The `web` module is provided by the addons found in the `openerp-web` project.
Maybe you forgot to add those addons in your addons_path configuration.
Have you a good idea
I have seen this error before and it was resolved by updating the ubuntu python-werkzeug package as I have described above using the “pip install”.
Got the same error. The werkzeug issue I solved with:
“sudo pip install –upgrade werkzeug”
But the web modul does still no loading.
Thanks Alan,
I am very green when it comes to linux/ubuntu and this is by far one of the clearest step by step tutorials I have come across. Even learnt a bit along the way.
Everything has gone well to the point of the following
“Similar to the configuration file, you need to either copy it or paste the contents of this script to a file in /etc/init.d/ and call it openerp-server”
I can save your version to my downloads folder (using ubuntu 11.10 desktop) but when I try to copy it to the init.d folder via the gui I am not allowed as it says I don’t have permission. I then tried my hand at a command line verion and was either asked for the “password openerp” which I didn’t think we used one. When I went back as the main user again on the command line I think I just plain got the cp command and file locations wrong.
I know its pretty basic, but could you give me some advice here or the cp command?
What user should I be logged in as on the command line?
Cheers and thanks for the great instruction
diggerD
@diggerD
You must be the root user to write anything into /etc. This is what the
sudo
prefix does before commands, it gives you temporary root privileges. So to copy the file from your home directory to /etc/init.d:sudo cp the_name_off_the_file_in_my_home_dir /etc/init.d/openerp-server
You must be logged in as your normal user (the one you created when you installed Ubuntu) before you can run the sudo command. The password it is expecting is your password.
Hope this helps
Excellent.
All running fine now. Fantastic job and thanks for the help
Thank you so much, I was so frustrated trying to install OpenERP for the last more than a week when I can across your tutorial through a google search.
I am sincerely grateful to you for making the effort to prepare this tutorial to help the rest of the community.
Kind Regards.
Alan, thanks for a great howto as usual. I have 6.0.3 running using your earlier tutorial. Can I test 6.1 on the same machine? Thanks again.
I have followed your example and created a new directory to reflect 6.1 leaving the earlier directory for 6.0.3 intact. On trying to run the installation, I get socket.error: [Errno 98] Address already in use error. I Noticed the port is been used by the 6.0.3 installation. Where can I change the port in to use for the 6.1 and what port numbering do you think will be appropriate.
Thanks.
Shutdown the 6.0.3 services so that I can run a test of the 6.1. The server starts alright but when I point my browser to
http://localhost:8069
, I get the error No handler found.. Is this a bug?Hi Hassan,
Running openerp-6.0 and 6.1 side-by-side is certainly doable, but because they are not compatible with each other I would be a bit more careful about the way you set the system up.
Create a new system & postgres user for 6.1 (maybe called them openerp61 for example)
Create new config files and init scripts for each user to start their own server instances.
Where openerp is installed, /opt/openerp I would probably change the name of the “server” directory to server60 and server61 or something similar.
What I’m trying to do here is to ensure that there is as little chance as possible of the two systems getting mixed up and corruption occurring in the databases. By creating separate users for each version you limit the chance of this greatly.
In terms of port numbering, in the openerp-server.conf file you need a line:
xmlrpc_port = 8069
change the port number to anything you like really, but it must not be used by another service on your server. I’d probably use 8072 or something.
Have fun 🙂
Alan, Thanks for the response. At the command line I have to do the following to get it working
/opt/openerp/server61/openerp-server --config=/etc/openerp-server61.conf
doing
/opt/openerp/server61/openerp-server
does not seem to load the config file.Yes.
Running
/opt/openerp/server61/openerp-server
without a config directive I think means it will look by default for /etc/openerp-server.confHi Alan,
Perfect! Congratulation! I followed all the steps of your tutorial and the system is running fine. Thanks!
Hey Valmir,
Thanks for commenting! I’m glad it all worked fine for you.
Al
Very nice – again!
Thanks for sharing,
Fernando
can we restore database of OE 6.0.3 to 6.1 and how?
I want to install the OE as you guide above.
Not easily no.
Please my earlier comment on upgrading.
Thanks a million!
BTW, I also had to:
sudo apt-get install python-simplejson
Thanks for the comment and good catch! I think that must have been added to the dependencies right at the last minute. Post updated.
Did you experience any problems without python-simplejson installed?
Thanks a lot, if it were not for you it would be a lot more difficult to install OpenERP, this instructions are those that should exist in the official site but dont’t.
Hi Alan & thanks a great deal for writing and publishing this great guide!
I wonder if it’d maybe be wiser in Step 5 create a link to the openerp-6.1-1 directory like
ln -s openerp-6.1-1 server
. Then if you upgrade do the stuff you said, namelytar xvf
the new version, copy openerp-6.1-1 and overwrite contents there with the ones from the new version (thereby keeping as you said the own templates). Then just change the server link to the directory of the new version and you’re done. This way you’ll be able to switch back to the old version more easily in case you ever have to. (Costs some disk space, but that’s cheap)What do you think?
One more thing … I’ve learned from a bad awakening with a 1.6 GB big
/var/log/tomcat6/catalina.out
file: If you don’t want to wake up one day realizing that many of your precious resources get used for a log file you get little intelligence from, create a filenano /etc/logrotate.d/openerp
with content like this:/var/log/openerp/openerp-server.log
{
copytruncate
compress
compresscmd /bin/bzip2
missingok
weekly
size 50M
rotate 10
}
You can test whether logrotate works by running
sudo -s /usr/sbin/logrotate -d /etc/logrotate.d/openerp
. HTHThat’s a great point, thanks!
In the
install
directory of the OpenERP source tarball there is a logrotate file (it has less in it than yours):/var/log/openerp/*.log {
copytruncate
missingok
notifempty
}
Excellent tutorial, top marks for clarity. All up and running with only the tiniest of typo’s to point out in the module install (missing backslash)
Thanks Mike! Updated.
Alan,
Both 6.0 and 6.1 guides are excellent. Any advice on using bzr to manage downloading the source into /opt/openerp/ and managing change using bazaar and launchpad?
Thanks in advance.
Del
Hi Del,
Thanks for the kind words,
Good question on using a bzr branch, but I’m probably not the best one to answer that one. Hopefully another reader might chip-in.
Thanks for the tuto, I managed to start the server correctly.
But I can’t create a database, I have a message “AccessDenied”…
I came back to postgres user creation to recreate the user openerp but it still the same.
By the way, I tried to turn postgres authentification method in “trust”, no effect.
Nothing anormal in the logs…
Have you an idea ?
Thanks.
@Bladerunner,
What password are you using when you try to create the database? You should not be using the one you created for the openerp user. That is for the openerp application itself to access PostgreSQL.
The default password to create your first database when you are using the web interface will be “admin”, this is stored in the openerp-server.conf file.
hi alan
I have followed many other tutorials. Only your two tutorials I have worked (6.0.3 and 6.1). Thank you. Greetings from Mexico. Sorry for my bad English.
@Carlos,
Thank you for your comment and please do not feel the need to apologise for your English! It is much better than my Spanish, French, Italian, Portuguese or any other language for that matter 😉
If Spanish is easier, you can find a translation of this howto here: http://informaticartica.blogspot.com/2012/02/instalacion-de-openerp-61-en-ubuntu.html
So thankful to Alan because of his step-by-step how-to on OpenERP 6.1 installation over Ubuntu 10.04, went through it on an Amazon EC2 instance, and worked like a charm.
Thanks Iveen,
I’m very pleased it helped.
Thanks a lot for this tuto, But I can’t execute this, i dont now the password for openerp, how i can find it?!!
thanks again
openerp@ubuntu:~$ sudo su – openerp -s /bin/bash /opt/openerp/server/openerp-server
[sudo] password for openerp:
Sorry, try again.
[sudo] password for openerp:
Sorry, try again.
[sudo] password for openerp:
That user doesn’t have a password. Unless you set one.
Also you are trying to run the command at the same time as changing user by
su
.Please try to follow the instructions carefully:
You type:
sudo su - openerp -s /bin/bash
Then you type:
/opt/openerp/server/openerp-server
Hope this helps.
thanks Alan, i have instaled openERP-6.1.1 in ubuntu 11.10 with same instructions
@Laheen,
Thanks for letting everyone know.
Alan, hi..
how do you solve. i´m facing the same issue.
sudo su – openerp -s /bin/bash
sudo /etc/init.d/openerp-server start
ask for (sudo password for openerp)
and the log is empty.
i appreciate your help
You are not reading the instructions properly.
Once your terminal session is running as openerp you can’t start the /etc/init.d script as that requires root privileges. But you can start directly the openerp-server binary…
Hello,
Thank you for your hard work on the tutorial! Much appreciate by many as you know! I was wondering,since we have not really done anything with the lower version, how can that be removed first, and then install the latest version?
Thank you in advance!
Tim
Hi Tim,
If you are sure there is nothing you need to keep you can:
* drop all existing databases (you will lose everything!) using the OpenERP client interface
* remove the scripts and files in /etc, e.g. /etc/init.d/openerp-server and /etc/openerp-server.conf
* remove everything below /opt/openerp/
Then you should be able to continue with these new instructions starting at step 4.
I would probably be inclined to take some backups myself, just in case you realise there was something you needed from the old version after all…
If you are not sure, please get someone to help you who knows what they are doing.
thanks for the great tutorial, had it run on linode & rackspace:)) hope you can publish your NGINX setup guide soon. Meanwhile, i am adopting guide from http://blog.thamini.com/xat/howto-add-some-additional-security-your-openerp-web-client-ssl-using-nginx
Hi Wong,
That’s the explanation I used as a basis too 😉 The changes I have made are to port number (obviously) and added some more rewrite code to deal with the mobile interface and webDAV/CalDAV access. I’ll try and get it written up soon.
I followed all the steps and at the end when i run the server i get the following message in the log file:
root@openerp:~# less /var/log/openerp/openerp-server.log
2012-03-03 05:20:59,833 18576 INFO ? openerp: OpenERP version 6.1-1
2012-03-03 05:20:59,833 18576 INFO ? openerp: addons paths: /opt/openerp/server/openerp/addons
2012-03-03 05:20:59,833 18576 INFO ? openerp: database hostname: localhost
2012-03-03 05:20:59,833 18576 INFO ? openerp: database port: 5432
2012-03-03 05:20:59,833 18576 INFO ? openerp: database user: openerp
2012-03-03 05:20:59,834 18576 INFO ? openerp.service.netrpc_server: starting NET-RPC service on 0.0.0.0:8070
2012-03-03 05:20:59,834 18576 INFO ? openerp.netsvc: Starting 1 services
2012-03-03 05:20:59,854 18576 INFO ? openerp.wsgi.core: HTTP service (werkzeug) running on 0.0.0.0:8069
2012-03-03 05:20:59,897 18576 CRITICAL ? openerp.modules.module: Couldn’t load module web
2012-03-03 05:20:59,897 18576 CRITICAL ? openerp.modules.module: expected only letters, got ‘utf-8’
2012-03-03 05:20:59,897 18576 ERROR ? openerp: Failed to load server-wide module `web`.
The `web` module is provided by the addons found in the `openerp-web` project.
Maybe you forgot to add those addons in your addons_path configuration.
Traceback (most recent call last):
File “/opt/openerp/server/openerp-server”, line 252, in
openerp.modules.module.load_openerp_module(m)
File “/opt/openerp/server/openerp/modules/module.py”, line 409, in load_opener
It seems like the web module is not installed? Any idea?
Hi
I have followed all your instructions ans something doesnt’ work for me on an ubuntu server 11.04.
I can’t find what i have missed..Wehn i try to launch openerp serer i obtain the folllowing error :
“2012-03-03 10:45:38,186 3942 WARNING ? openerp.modules.module: module web: module not found
2012-03-03 10:45:38,186 3942 CRITICAL ? openerp.modules.module: Couldn’t load module web
2012-03-03 10:45:38,214 3942 CRITICAL ? openerp.modules.module: unsupported operand type(s) for +: ‘bool’ and ‘str’
2012-03-03 10:45:38,223 3942 ERROR ? openerp: Failed to load server-wide module `web`.
The `web` module is provided by the addons found in the `openerp-web` project.
Maybe you forgot to add those addons in your addons_path configuration.
Traceback (most recent call last):
File “/opt/openerp/server/openerp-server”, line 252, in
openerp.modules.module.load_openerp_module(m)
File “/opt/openerp/server/openerp/modules/module.py”, line 407, in load_openerp_module
zip_mod_path = mod_path + ‘.zip’
TypeError: unsupported operand type(s) for +: ‘bool’ and ‘str’
2012-03-03 10:45:38,265 3942 INFO ? openerp: OpenERP server is running, waiting for connections…
2012-03-03 10:45:38,267 3942 INFO ? openerp.wsgi.core: HTTP service (werkzeug) running on 0.0.0.0:8069
2012-03-03 10:45:38,186 3942 WARNING ? openerp.modules.module: module web: module not found
2012-03-03 10:45:38,186 3942 CRITICAL ? openerp.modules.module: Couldn’t load module web
2012-03-03 10:45:38,214 3942 CRITICAL ? openerp.modules.module: unsupported operand type(s) for +: ‘bool’ and ‘str’
2012-03-03 10:45:38,223 3942 ERROR ? openerp: Failed to load server-wide module`web`.
someone know what i have missed ?
Hi pab,
I have not tried the installation on 11.04 but I wouldn’t have thought there would be much difference.
Please check the dependencies carefully, perhaps one is missing in 11.04 or is a wrong version?
Hi, excuse me, I’m a newbie, but …
Alan wrote:
“Step 7. Installing the boot script
For the final step … There is a script you can use in
/opt/openerp/server/install/openerp-server.init <———————
But This Will need a Few Small Modifications to work … "
Should not he say so?:
"Step 7. Installing the boot script
For the final step … There is a script you can use in
/etc/init.d/openerp-server <———————
But This Will need a Few Small Modifications to work … "
Thanks
Hi Carlos,
I am pointing to an original file provided in the src tarball that you can copy (/opt/openerp/server/install/openerp-server.init) and use to create your script if you like. But it is written for a .deb packaged installation which puts the OpenERP files in different places to me so it requires modifications before being usable.
Excellent! I have followed your steps using Ubuntu 11.10 Server.
The only extra step I had to do was install the following library
sudo apt-get install python-tz
After that everything runs pecfect.
Is it possible to follow your previous tutorial that shows how to secure apache SSL using openERP 6.1?
Many Thanks!
Thanks Ray P,
The Apache reverse proxy will need tweaking for 6.1 as everything runs over port 8069 and you need some rewrite rules for the Mobile webDAV/CalDAv access.
I have something working using nginx but haven’t had time to write it up yet.
Tested on Debian 6, all Ok 🙂
@Dario, Thanks!
Hello all,
I started the server from scratch using TK Linux LAPP, Ubuntu 10.4 Lucid LTS. Performed the steps above including using pip to install werkzeug. However, I get a critical errors on the web module – from the log:
2012-03-06 19:43:32,312 1288 INFO ? openerp: OpenERP version 6.1-1
2012-03-06 19:43:32,312 1288 INFO ? openerp: addons paths:
/opt/openerp/server/openerp/addons
2012-03-06 19:43:32,313 1288 INFO ? openerp: database hostname: localhost
2012-03-06 19:43:32,313 1288 INFO ? openerp: database port: 5432
2012-03-06 19:43:32,313 1288 INFO ? openerp: database user: openerp
2012-03-06 19:43:32,314 1288 INFO ? openerp.service.netrpc_server: starting NET-RPC service
on 0.0.0.0:8070
2012-03-06 19:43:32,315 1288 INFO ? openerp.netsvc: Starting 1 services
2012-03-06 19:43:32,513 1288 INFO ? openerp.wsgi.core: HTTP service (werkzeug) running on
0.0.0.0:8069
2012-03-06 19:43:33,147 1288 INFO ? openerp.addons.web: embedded mode
2012-03-06 19:43:34,112 1288 CRITICAL ? openerp.modules.module: Couldn’t load module web
2012-03-06 19:43:34,112 1288 CRITICAL ? openerp.modules.module: No module named PIL
2012-03-06 19:43:34,113 1288 ERROR ? openerp: Failed to load server-wide module `web`.
The `web` module is provided by the addons found in the `openerp-web` project.
Maybe you forgot to add those addons in your addons_path configuration.
Traceback (most recent call last):
File “/opt/openerp/server/openerp-server”, line 252, in
openerp.modules.module.load_openerp_module(m)
File “/opt/openerp/server/openerp/modules/module.py”, line 419, in load_openerp_module
getattr(sys.modules[‘openerp.addons.’ + module_name], info[‘post_load’])()
File “/opt/openerp/server/openerp/addons/web/__init__.py”, line 29, in wsgi_postload
app = common.http.Root(o)
File “/opt/openerp/server/openerp/addons/web/common/http.py”, line 453, in __init__
static_dirs = self._load_addons(openerp_addons_namespace)
File “/opt/openerp/server/openerp/addons/web/common/http.py”, line 523, in _load_addons
m = __import__(‘openerp.addons.’ + module)
File “/opt/openerp/server/openerp/modules/module.py”, line 139, in load_module
mod = imp.load_module(‘openerp.addons.’ + module_part, f, path, descr)
File “/opt/openerp/server/openerp/addons/point_of_sale/__init__.py”, line 22, in
import point_of_sale
File “/opt/openerp/server/openerp/addons/point_of_sale/point_of_sale.py”, line 26, in
from PIL import Image
ImportError: No module named PIL
2012-03-06 19:43:34,164 1288 INFO ? openerp: OpenERP server is running, waiting for
connections…
The server appears to be running, but in fact it is not working. From a computer on the LAN, the browser pointing at http://192.168.0.10:8069/, the result is “No handler found.”
Can anyone advise where the problem may be? And how to correct?
Thank you
Tim
Hi Tim,
Sorry to hear about your difficulty. I have a couple of questions:
1. What is TK Linux LAPP? I have never heard of this.
2. Do you know what this PIL module is all about? It’s unusual to be in upper-case for a start and is not a module I have ever seen mentioned in logs or dependencies before.
Hopefully some other readers may be able to assist but I’m rather stumped. These instructions, if followed to the letter, do work.
Hello Alan and thank you for your reply!
TK Linux LAPP is “Turnkey Linux virtual appliance – The LAPP stack is an open source web platform that can be used to run dynamic web sites and servers. It is considered by many to be a powerful alternative to the more popular LAMP stack and includes Linux, Apache, PostgreSQL (instead of MySQL) and PHP, Python and Perl.”
The reason to do this, is that the LAPP stack brings all of the components in and ready to go without configuration. Since I am a dummy when it comes to Linux, it was a natural choice. For this install of openERP 6.1, I used the same TK LAPP version as I did before BTW.
I too do not know what PIL is either…
I had used the same base set up (TK Linux LAPP) when I did the install from your fine instructions for version 6.0 of openERP.
In the previous version of openERP, the WEB components had to be added separately. It appears this has changed and is no longer necessary for 6.1 correct?
I’ll try it on another computer with a fresh install of Linux by itself.
If anyone has any ideas how to fix this I would sure appreciate it. I have seen this same problem (web module) in many google hits.
Tim
Alan,
Thanks again for your work! I took another computer, started from scratch with a Linux 10.4 Server 64bit CD and went through the process. As you said it all worked!
Two questions:
1. After I changed the super admin password, I cannot log in. Do you know what the default user name is?
2. I had to type the boot script since I could not figure out how to download it into this machine. My previous attempts had webmin installed so it was easy to copy/paste etc. Can you tell me the command line to download the script to the correct location? I will have to repeat the install process on the real target computer at some point and this would make it easier!
Thank you
Tim
Sorry, forget about the default login… got it squared.
Thank you again for a great Tutorial!
Tim
Hi Tim,
I’m really glad you got it sorted.
To answer your question about the bootscript, there are a few ways:
1: Open the bootscript in your browser (just click on the link) then save the page somewhere sensible. Then you can scp (like FTP but over ssh) it to your server:
scp boot-script-filename user@server.name:
2. Copy the url to the script (right click and choose Copy Link Location in Firefox) then open a terminal on your server (via ssh ideally) and type:
wget (SHFT+CTL+V to paste the URL)
and hit enter.Hope that helps
Alan,
‘Too’ * 80 times good post again.
Being a technical expert, I did all the steps myself but when I came to know about this post, I could not resist myself to reshare this. This will surely guide others.
With all courtesy to you, I have shared the blog http://jayvora.blogspot.in/2012/03/how-to-install-openerp-61-on-ubuntu.html
Thanks,
Jay,
Serpent Consulting Services.
http://www.serpentcs.com
Thanks Jay,
Copying and reproducing the article is absolutely fine! 🙂
The only conditions are:
you attribute the original (which you have)
provide it under the same terms as the original: CC by-sa 3.0
http://creativecommons.org/licenses/by-sa/3.0/
Hi all,
Your tutorial is a great help! I find it very well done and pedagogical.
BUT … 🙂 … I have the same error as Tim and Pab:
2012-03-07 14:38:52,681 1613 INFO ? openerp: OpenERP version 6.1-1
2012-03-07 14:38:52,682 1613 INFO ? openerp: addons paths: /opt/openerp/server/openerp/addons
2012-03-07 14:38:52,682 1613 INFO ? openerp: database hostname: localhost
2012-03-07 14:38:52,682 1613 INFO ? openerp: database port: 5432
2012-03-07 14:38:52,682 1613 INFO ? openerp: database user: openerp
2012-03-07 14:38:52,684 1613 INFO ? openerp.service.netrpc_server: starting NET-RPC service on 0.0.0.0:8070
2012-03-07 14:38:52,684 1613 INFO ? openerp.netsvc: Starting 1 services
2012-03-07 14:38:52,913 1613 INFO ? openerp.wsgi.core: HTTP service (werkzeug) running on 0.0.0.0:8069
2012-03-07 14:38:53,652 1613 INFO ? openerp.addons.web: embedded mode
2012-03-07 14:38:54,042 1613 CRITICAL ? openerp.modules.module: Couldn’t load module web
2012-03-07 14:38:54,042 1613 CRITICAL ? openerp.modules.module: No module named draft
2012-03-07 14:38:54,042 1613 ERROR ? openerp: Failed to load server-wide module `web`.
The `web` module is provided by the addons found in the `openerp-web` project.
Maybe you forgot to add those addons in your addons_path configuration.
Traceback (most recent call last):
File “/opt/openerp/server/openerp-server”, line 252, in
openerp.modules.module.load_openerp_module(m)
File “/opt/openerp/server/openerp/modules/module.py”, line 419, in load_openerp_module
getattr(sys.modules[‘openerp.addons.’ + module_name], info[‘post_load’])()
File “/opt/openerp/server/openerp/addons/web/__init__.py”, line 29, in wsgi_postload
app = common.http.Root(o)
File “/opt/openerp/server/openerp/addons/web/common/http.py”, line 453, in __init__
static_dirs = self._load_addons(openerp_addons_namespace)
File “/opt/openerp/server/openerp/addons/web/common/http.py”, line 523, in _load_addons
m = __import__(‘openerp.addons.’ + module)
File “/opt/openerp/server/openerp/modules/module.py”, line 139, in load_module
mod = imp.load_module(‘openerp.addons.’ + module_part, f, path, descr)
File “/opt/openerp/server/openerp/addons/auth_openid/__init__.py”, line 23, in
import controllers
File “/opt/openerp/server/openerp/addons/auth_openid/controllers/__init__.py”, line 20, in
import main
File “/opt/openerp/server/openerp/addons/auth_openid/controllers/main.py”, line 41, in
from openid.extensions import ax, sreg
File “/usr/lib/pymodules/python2.6/openid/extensions/__init__.py”, line 5, in
from openid.extensions.draft import pape5 as pape
ImportError: No module named draft
2012-03-07 14:38:54,049 1613 INFO ? openerp: OpenERP server is running, waiting for connections…
I simply just do not know how to come forward with this story …. I am sorry to bother, but do you happen to have a idea ….
Thank you in advance,
Antoine from Berlin
You don’t have quite the same error…
Yours refers to a module “draft”:
2012-03-07 14:38:54,042 1613 CRITICAL ? openerp.modules.module: No module named draft
and
File “/usr/lib/pymodules/python2.6/openid/extensions/__init__.pyâ€, line 5, in
from openid.extensions.draft import pape5 as pape
ImportError: No module named draft
I have no idea what module “draft” is. Sorry.
I think there must be something odd with your systems. I discovered that Tim is not using Ubuntu 10.04 but a pre-built vm from Turnkey – sorry but all bets are off with that one. I have no idea what they have or haven’t packaged or modified from base.
If you follow these instructions, to-the-letter, starting from a clean Ubuntu 10.04 LTS system, it will work.
Dear Alan,
your word was truth! A CLEAN ubuntu was the solution. I installed my server anew without the plesk software (10.2) which was installed together with my Ubuntu (german Strato V-Server). And now it does works.
So thank you for the tutorial,
Antoine
@Antoine,
Thanks for taking the time to reply; it will be useful for other readers. I’m glad you now have a working system!
I’m quite sceptical of products like CPanel, Plesk and others. They make a huge number of “under-the-hood” alterations which seem to cause more trouble than good. I’m sure they have their uses (like shared web hosting) but they are not for me.
Anyway thanks again for coming back – it’s really appreciated.
Hey, thanks a lot for the installation tips. The previous one you put up for 6.0 worked fine for me, but I’m having problems with this one. I installed everything like you said and it shows it starts in the log file, but when i try to open it in the browser I get this error in the log file:
2012-03-08 15:36:20,228 5480 INFO ? openerp: OpenERP server is running, waiting for connections…
2012-03-08 15:38:25,461 5480 INFO ? werkzeug: 10.2.5.31 – – [08/Mar/2012 15:38:25] “GET / HTTP/1.1” 301 –
2012-03-08 15:38:25,523 5480 INFO ? werkzeug: 10.2.5.31 – – [08/Mar/2012 15:38:25] “GET /web/webclient/home HTTP/1.1” 500 –
2012-03-08 15:38:25,568 5480 ERROR ? werkzeug: Error on request:
Traceback (most recent call last):
File “/usr/local/lib/python2.6/dist-packages/Werkzeug-0.7-py2.6.egg/werkzeug/serving.py”, line 159, in run_wsgi
execute(app)
File “/usr/local/lib/python2.6/dist-packages/Werkzeug-0.7-py2.6.egg/werkzeug/serving.py”, line 146, in execute
application_iter = app(environ, start_response)
File “/opt/openerp/server/openerp/wsgi/core.py”, line 397, in application
result = handler(environ, start_response)
File “/opt/openerp/server/openerp/addons/web/common/http.py”, line 467, in __call__
return self.dispatch(environ, start_response)
File “/usr/local/lib/python2.6/dist-packages/Werkzeug-0.7-py2.6.egg/werkzeug/wsgi.py”, line 409, in __call__
return self.app(environ, start_response)
File “/opt/openerp/server/openerp/addons/web/common/http.py”, line 503, in dispatch
response.set_cookie(self.session_cookie, session.sid)
File “/usr/lib/python2.6/contextlib.py”, line 23, in __exit__
self.gen.next()
File “/opt/openerp/server/openerp/addons/web/common/http.py”, line 401, in session_context
session_store.save(request.session)
File “/usr/local/lib/python2.6/dist-packages/Werkzeug-0.7-py2.6.egg/werkzeug/contrib/sessions.py”, line 237, in save
dir=self.path)
File “/usr/lib/python2.6/tempfile.py”, line 293, in mkstemp
return _mkstemp_inner(dir, prefix, suffix, flags)
File “/usr/lib/python2.6/tempfile.py”, line 228, in _mkstemp_inner
fd = _os.open(file, flags, 0600)
OSError: [Errno 13] Permission denied: ‘/tmp/oe-sessions-root/tmp7V_Pqy.__wz_sess’
I went over all the permission settings again to make sure I did it right, but nothing works. Please can you help?
Hi Daniel,
I have a spam filter on this blog. If you haven’t posted a comment before it will not show up until I have allowed it. You wouldn’t believe how many spam comments I get every day – Thank goodness for Akismet… “Akismet has protected your site from 653,288 spam comments already. ”
Anyway on to your error(s).
File “/usr/local/lib/python2.6/dist-packages/Werkzeug-0.7-py2.6.egg/werkzeug/serving.pyâ€, line 159, in run_wsgi
I think you are running an old version of werkzeug. Mine is Werkzeug-0.8.3. Please use the
sudo pip install werkzeug
command to get the latest version (you might have to uninstall your current version first).OSError: [Errno 13] Permission denied: ‘/tmp/oe-sessions-root/tmp7V_Pqy.__wz_sess’
This one suggests to me that you have tried to run your openerp server as root! This is a really bad idea. In my /tmp directory I have a subdir called oe-sessions-openerp:
drwx------ 2 openerp openerp 4096 2012-03-09 08:11 oe-sessions-openerp
I suggest that you stop the OpenERP server, delete that directory under /tmp and then make sure that your are running your openerp server as the right user.
Thanks for the post.
I’ve been unsuccessfully trying to configure a reverse proxy for the Web 6.1, using your suggestion – nginx, but keep getting a 502 Bad Gateway message.
My feeling is that some config is missing on the OpenERP server side. Can you share any insights on this ?
Thanks.
I have a working config for an nginx reverse proxy.
I will try and get it written up shortly.
Hi man,
when I get to the point to start the server just to se if it is ok i get a message:
the program ‘openerp-server’ is not installed at this moment. you can install typing:
sudo apt-get install openerp-server
(sorry for the bad english message was in portuguese)
what did I do wrong (no questions marks on this keyboards sorry)
You are not following the instructions correctly.
That message says to me you are not providing the full path to the server script. If you have followed the instructions when you enter (these are two separate commands):
sudo su - openerp -s /bin/bash
/opt/openerp/server/openerp-server
You should not be seeing that error message. If you are further along then you are not using the path to the script in
/etc/init.d/openerp-server
.LOL… my linux knowledge sucks LOL… thx for your help… anyway I choose to install a new copy of ubuntu (too late a start installing before open your blog LOL) but thx again … when I finish the setup and configuration processe I will come back to let you know. Cheers Alexandre
Hi,
Many thanks for this super tutorial. I have followed all the steps accordingly and installed it on ubuntu 10.04 (my first installation of Open ERP). But as I open it on the browser I get this error:
OpenERP Server Error
Client Traceback (most recent call last):
File “/opt/openerp/server/openerp/addons/web/common/http.py”, line 180, in dispatch
response[“result”] = method(controller, self, **self.params)
File “/opt/openerp/server/openerp/addons/web/controllers/main.py”, line 353, in get_list
dbs = proxy.list()
File “/opt/openerp/server/openerp/addons/web/common/openerplib/main.py”, line 117, in proxy
result = self.connector.send(self.service_name, method, *args)
File “/opt/openerp/server/openerp/addons/web/common/http.py”, line 611, in send
raise fault
Server Traceback (most recent call last):
File “/opt/openerp/server/openerp/addons/web/common/http.py”, line 592, in send
result = openerp.netsvc.dispatch_rpc(service_name, method, args)
File “/opt/openerp/server/openerp/netsvc.py”, line 360, in dispatch_rpc
result = ExportService.getService(service_name).dispatch(method, params)
File “/opt/openerp/server/openerp/service/web_services.py”, line 117, in dispatch
return fn(*params)
File “/opt/openerp/server/openerp/service/web_services.py”, line 310, in exp_list
cr = db.cursor()
File “/opt/openerp/server/openerp/sql_db.py”, line 465, in cursor
return Cursor(self._pool, self.dbname, serialized=serialized)
File “/opt/openerp/server/openerp/sql_db.py”, line 173, in __init__
self._cnx = pool.borrow(dsn(dbname))
File “/opt/openerp/server/openerp/sql_db.py”, line 366, in _locked
return fun(self, *args, **kwargs)
File “/opt/openerp/server/openerp/sql_db.py”, line 421, in borrow
result = psycopg2.connect(dsn=dsn, connection_factory=PsycoConnection)
OperationalError: could not connect to server: No such file or directory
Is the server running locally and accepting
connections on Unix domain socket “/var/run/postgresql/.s.PGSQL.5432”?
I also get this database Creation Error
Could not create database ‘Test’: Traceback (most recent call last): File “/opt/openerp/server/openerp/addons/web/common/http.py”, line 592, in send result = openerp.netsvc.dispatch_rpc(service_name, method, args) File “/opt/openerp/server/openerp/netsvc.py”, line 360, in dispatch_rpc result = ExportService.getService(service_name).dispatch(method, params) File “/opt/openerp/server/openerp/service/web_services.py”, line 117, in dispatch return fn(*params) File “/opt/openerp/server/openerp/service/web_services.py”, line 137, in exp_create self._create_empty_database(db_name) File “/opt/openerp/server/openerp/service/web_services.py”, line 121, in _create_empty_database cr = db.cursor() File “/opt/openerp/server/openerp/sql_db.py”, line 465, in cursor return Cursor(self._pool, self.dbname, serialized=serialized) File “/opt/openerp/server/openerp/sql_db.py”, line 173, in __init__ self._cnx = pool.borrow(dsn(dbname)) File “/opt/openerp/server/openerp/sql_db.py”, line 366, in _locked return fun(self, *args, **kwargs) File “/opt/openerp/server/openerp/sql_db.py”, line 421, in borrow result = psycopg2.connect(dsn=dsn, connection_factory=PsycoConnection) OperationalError: could not connect to server: No such file or directory Is the server running locally and accepting connections on Unix domain socket “/var/run/postgresql/.s.PGSQL.5432”?
what could be the problem?
You haven’t followed the instructions accurately. Postgres is not running by the looks of that.
Hi. Great series!
I’m struggling to get webkit_reports working (ubuntu 64bit). seems to be a permission error; if I run wkhtmltopdf as openerp user it gives an error: QPainter::begin() Error: Unable to write to destination.
Running as root works fine. The permissions on the tmp folder is fine.
spent the day fiddlin’ and googlin’ but no luck! Please help 🙂
Thanks!
nevermind… got it working! not quite sure how though 😛
that issue with
CRITICAL ? openerp.modules.module: Couldn’t load module web
is reproducible: it seems this is a 32/64 bit problem 😉
installing the same on a debian 6.0.4 32 bit (x386) works
using a debian 6.0.4 amd64 gives the error
so: you have to install this on a 32 bit distribution until that issue gets resolved
2012-03-14 10:15:41,173 4531 INFO ? openerp: OpenERP version 6.1-1
2012-03-14 10:15:41,173 4531 INFO ? openerp: addons paths: /opt/openerp/server/openerp/addons
2012-03-14 10:15:41,173 4531 INFO ? openerp: database hostname: localhost
2012-03-14 10:15:41,174 4531 INFO ? openerp: database port: 5432
2012-03-14 10:15:41,174 4531 INFO ? openerp: database user: openerp
2012-03-14 10:15:41,174 4531 INFO ? openerp.service.netrpc_server: starting NET-RPC service on 0.0.0.0:8070
2012-03-14 10:15:41,175 4531 INFO ? openerp.netsvc: Starting 1 services
2012-03-14 10:15:41,300 4531 INFO ? openerp.wsgi.core: HTTP service (werkzeug) running on 0.0.0.0:8069
2012-03-14 10:15:41,301 4531 INFO ? openerp.addons.web: embedded mode
2012-03-14 10:15:41,570 4531 CRITICAL ? openerp.modules.module: Couldn’t load module web
2012-03-14 10:15:41,570 4531 CRITICAL ? openerp.modules.module: No module named PIL
2012-03-14 10:15:41,570 4531 ERROR ? openerp: Failed to load server-wide module `web`.
The `web` module is provided by the addons found in the `openerp-web` project.
Maybe you forgot to add those addons in your addons_path configuration.
Traceback (most recent call last):
File “/opt/openerp/server/openerp-server”, line 252, in
openerp.modules.module.load_openerp_module(m)
File “/opt/openerp/server/openerp/modules/module.py”, line 419, in load_openerp_module
getattr(sys.modules[‘openerp.addons.’ + module_name], info[‘post_load’])()
File “/opt/openerp/server/openerp/addons/web/__init__.py”, line 29, in wsgi_postload
app = common.http.Root(o)
File “/opt/openerp/server/openerp/addons/web/common/http.py”, line 453, in __init__
static_dirs = self._load_addons(openerp_addons_namespace)
File “/opt/openerp/server/openerp/addons/web/common/http.py”, line 523, in _load_addons
m = __import__(‘openerp.addons.’ + module)
File “/opt/openerp/server/openerp/modules/module.py”, line 139, in load_module
mod = imp.load_module(‘openerp.addons.’ + module_part, f, path, descr)
File “/opt/openerp/server/openerp/addons/point_of_sale/__init__.py”, line 22, in
import point_of_sale
File “/opt/openerp/server/openerp/addons/point_of_sale/point_of_sale.py”, line 26, in
from PIL import Image
ImportError: No module named PIL
2012-03-14 10:15:41,571 4531 INFO ? openerp: OpenERP server is running, waiting for connections…
2012-03-14 10:49:14,496 4531 INFO ? openerp.netsvc: Stopping 1 services
2012-03-14 10:49:14,664 4531 INFO ? openerp.service: Initiating shutdown
2012-03-14 10:49:14,665 4531 INFO ? openerp.service: Hit CTRL-C again or send a second signal to force the shutdown.
@Mike F,
Not sure about Debian, but I only ever use 64bit server code. All these instructions work fine on Ubuntu 10.04 LTS (amd64). They will probably work just as well on 32bit but I have never tried it.
Thanks for the excelling guide. I am up and running on 10.04LTS 32-bit with 1GB RAM in a virtual machine in a VMware ESXi 4.1 environment. I have managed to start configuring and exploring OpenERP, but the app is timing out every now and again with “XmlHttpRequestError” (in Firefox), but if I wait and retry a few times I will eventually get the page I’m after. Nothing in the logs. I did find a reference to openerp/tiny_socket.py: self.sock.settimeout(120), which I have uncommented but it’s not helped. Any suggestions where to start debugging this? Regards etc.
Edit: Further to above, this seems to be a DNS issue so you can delete the post if you like.
@AlanL: Thanks, this HowTo helped me in a big way.
@MikeF: That PIL module seems to be the Python Imaging Library
apt-get install python-imaging
I installed using the .deb file:
dpkg -i –force-depends ~/openerp_6.1-1-1_all.deb
The force was necessary because of the newer version of python-werkzeug. Is it going to cause problems?
Thank you for this tutorial.
I had this error when launching the server:
2012-03-16 08:51:26,583 4615 CRITICAL ? openerp.modules.module: Couldn't load module web
2012-03-16 08:51:26,584 4615 CRITICAL ? openerp.modules.module: No module named ir
2012-03-16 08:51:26,584 4615 ERROR ? openerp: Failed to load server-wide module `web`.
The `web` module is provided by the addons found in the `openerp-web` project.
Maybe you forgot to add those addons in your addons_path configuration.
I resolved my problem by adding this in the config file:
addons_path = /opt/openerp/server/openerp-server/addons
May be this could help someone who have the same error as me.
Well, I have had a stable and working server for a couple of days but this afternoon after a planned server restart OpenERP won’t run from the /etc/init.d script – I get an error message at the Web login that ends:
File “/opt/openerp/server/openerp/sql_db.py”, line 421, in borrow
result = psycopg2.connect(dsn=dsn, connection_factory=PsycoConnection)
OperationalError: FATAL: Ident authentication failed for user “root”
BUT if I start OpenERP manually with:
su – openerp -s /bin/bash
/opt/openerp/server/openerp-server
It works fine.
Where to start checking!?
Thanks
I would just like to add my thanks for an excellent tutorial..
Being a complete noob with linux this and the previous tutorial for 6.0.3 had me up and running in under 30 mins on a ubuntu 10.04 LTS (32bit) in a ESXi 3.5 VM any thing that didn`t work was down to my fat fingered typing and/or not reading the instructions properly.
Thank you very much for sharing on how to install openerp. I have found it very very useful. It has saved me a lot of time.
Most importantly, the instructions work perfectly.
Once again thank you.
@P.V. Anthony,
Many thanks for dropping by. I’m glad it was useful.
How can I login to the database through PgAdmin? Previously I had 6.1rc1 version (which I had installed according to these instructions: http://www.altinisik.net/component/k2/item/1-how-to-install-and-run-openerp-61-trunk-with-ubuntu-1110-server-x64.html) and I was able to login through openerp user. Now with 6.1 version according to your steps I’m no longer able to connect to database. Maybe it’s due to the fact that openerp user is a system user. Any advices? Thanks a lot.
Pavel
Very nice and complete tutorial, thank you very very much for this great work !
Thank you for the excellent tutorial! I only have one problem. I can not make the server start automatically. I can start it up and works as openerp user but the init.d startap does not work. No error message on startup at all (but it does not work) only on stop: failed to kill 5712: No such process.
Can anyone help me on this case?
Did you run the command
sudo update-rc.d openerp-server defaults
? You should have some symbolic links in /etc/rc.xd/ pointing to the openerp-server script.What is in the log file?
If you have changed or renamed the the configuration file, is it correctly specified at the beginning of the openerp-server script?
These instructions do work if followed accurately.
Thank you for your reply. I don’t know too much about linux systems so
I do have the links there. According to the log file the server has started but I can not connect to it. Manually restarting /etc/init.d/openerp-server restart do not give any error and do not write to the log file either. If I stop the service I got the above mentioned error. It works perfectly if I start it up as openerp user. I made two separate clean install and both has the same problem. I only copy and past lines from your tutorial to avoid misspellings.
hello Alan
I am getting the same error as a few other, I read you reply but to not avail.
sudo su – openerp -s /bin/bash is asking for a password, the same thing happen when try to start openerp.
sudo /etc/init.d/openerp-server start
there was not password created for openerp.
using ubuntu 10.04 openerp 6.1.1
I read all the above comments.
thank you for you help