OpenERP Server Installation¶
The server installation works on:
- Windows 2000
- Windows XP
- Windows Vista
- Windows Server 2000
- Windows Server 2003
- Windows Server 2008
with disks formatted in NTFS (not a FAT or FAT32 partition).
OpenERP Server doesn’t work on Windows 98 or ME; for obvious reasons – these can’t be formatted using NTFS.
You will also need a PostgreSQL server up and running. If it’s not the case, you can read the PostgreSQL Server installation and configuration Section.
Downloading the OpenERP Server¶
The server can be downloaded from the OpenERP website’s download page
Choose Server if you want to install OpenERP Server standalone and plan to install the OpenERP Client and the PostgreSQL Server separately.
Choose All in One if you want to install PostgreSQL Server, OpenERP Server and OpenERP Client in one shot.
Installing the OpenERP Server¶
Click on the installer you’ve just downloaded.
The ERP server installs also as a Windows service. This means you don’t have to start the server each time you start the computer and it runs without the need of an open user session.
At the end of the installation, the setup wizard proposes to open, OpenERP Prompt, from where you can prepare your server, as described below.
Preparing the server for the first time run¶
The Windows service for OpenERP Server is installed during the installation and it’s set up to start the server automatically on system boot.
In case of Standalone Server, the configuration file is automatically saved in the installation directory, in:
C:\Program Files\OpenERP Server\openerp-server.conf
And in case of All in one, the configuration file is automatically saved in the installation directory, in:
C:\Program Files\OpenERP AllInOne\Server\openerp-server.conf
At the end of installation, the setup wizard proposes to open an OpenERP Prompt.
To start the server manually, start the Windows Command prompt and navigate to the installation directory in “C:\Program Files\OpenERP Server\”
You need to initialize the server and save its configuration for the service to be able to start automatically.
You also need to specify a logfile to be able to read the output the server writes during its execution.
When in the Server directory, type this command but don’t execute it yet:
openerp-server.exe -d <db_name> -r <db_user> -w <db_password> --db_host=localhost --db_port=5432 --logfile="<logfile>" -s --stop-after-init
The initialization of OpenERP Server provides the necessary informations for the connection to the database PostgreSQL and indication of the choice of data to load. Here is the explanation of used options:
- -d <db_name> : Name of the database created for OpenERP Server.
- -r <db_user> : Name of the [=PostgreSQL=] administrator.
- -w <db_password> : Administrator’s password.
- –db_host=<postgresql_server_address> : Address of the server where [=PostgreSQL=]is, if you have installed [=PostgreSQL=] on the same computer as OpenERP Server, you can enter localhost, or the IP address or the name of the distant server.
- –db_port=<port_no> : Port number where listens [=PostgreSQL=]. Default is 5432.
- -s : This option allows you to save the options in configuration file of OpenERP Server.
- –stop-after-init: This option stops the ERP server after initialization.
- –logfile=”<logfile>”: specify a logfile where all the output of ERP Server will be saved.
Before execution of this command you have to decide what usage you want the OpenERP for: see the next section! The command is on only one line, the other long commands as well.
openerp-server.exe -d terp -r openuser -w 123456 --db_host=localhost --logfile="C:\Program Files\OpenERP Server\openerp-server.log" --db_port=5432 -s --stop-after-init
Here you have to enter the username and password initialized in the Initialise database cluster screen.
When you will execute the initialization command, if you specified a logfile, you will not see any server output in the prompt window.
Everything is written to the logfile. You have only to wait until the prompt comes back.
Deciding what is the purpose of the server¶
You have three possibilities for the first launch. This section is really important because the correct initialization can be crucial.
You can initialize the database with OpenERP Server to:
- You want to take a look on the system with demo data loaded
- You are installing a new clean installation (without demo data)
- You are upgrading an existing version.
First time run with demo data¶
To initialize OpenERP Server with the demo data, you need to add this option to the above command:
openerp-server.exe -d terp -r openuser -w 123456 --db_host=localhost --logfile="C:\Program Files\OpenERP Server\openerp-server.log" --db_port=5432 -s --stop-after-init --init=all
This command will initialize the OpenERP Server and fill its PostgreSQL database with the demo data.
First time run without demo data (or new clean version)¶
Execute the command with an option excluding the demo data:
This will load all modules, but will not load the demo data.
Sample command usage:
openerp-server.exe -d terp -r openuser -w 123456 --db_host=localhost --logfile="C:\Program Files\OpenERP Server\openerp-server.log" --db_port=5432 -s --stop-after-init --without-demo=all
Recreate a new database:If you have more than one database , you may force the server to initialize by using the “-i all” or “–init=all” command line option.
If you already initialized the database and you have the demo data loaded, you can recreate a new database
First time run with an upgraded version of OpenERP Server¶
Execute the command with an option that updates the data structures:
Sample command usage:
openerp-server.exe -d terp -r openuser -w 123456 --db_host=localhost --logfile="C:\Program Files\OpenERP Server\openerp-server.log" --db_port=5432 -s --stop-after-init --update=all
Starting the server¶
Now as the server is initialized and the settings are saved, you can finally start the Open ERP Server service.
In the menus there is an icon that directly executes the OpenERP server, but it is only for debugging or testing purposes.
From the command prompt¶
You can now start the OpenERP Server service from the command prompt with a simple command:
net start openerp-service
You can also stop it in a similar way, in case the service is running but you need to reconfigure it:
net stop openerp-service
From the service manager¶
The service and some runtime information is also accessible in the Computer management in Administration tools.
The logging service offers additional information about the execution of the OpenERP Server service.
In the service manager you can define how the service should act in case of server failure.
Monitoring OpenERP Server¶
You can find startup or shutdown information in the Computer Management logging service.
OpenERP Server runtime output can be found in the logfile you specified on the initialization command line.
Given that the server is now running as a Windows service, it doesn’t output any runtime messages, for this the logfile is the only option.
You can find out whether OpenERP Server is running by opening the Windows Task Manager and when you look at the Processes tab, you will see OpenERPServerService.exe and openerp- server.exe and that these two processes are running as SYSTEM user.
Configuring OpenERP Server¶
OpenERP Server menu contains a direct link to the configuration file used by the service. This way you can edit the configuration and then restart the service to load the new configurations.
Be extremely cautious when editing the server configuration directly, you can crash the entire system with inappropriate values.
Congratulations, you have successfully installed the OpenERP Server¶
For more information, please take a look at the Additional Installation Information and Troubleshooting page where you can find some troubleshooting examples.