This is the documentation for older versions of Odoo (formerly OpenERP).

See the new Odoo user documentation.

See the new Odoo technical documentation.

Database creation

Use the technique outlined in this section to create a new database, openerp_ch01 . This database will contain the demonstration data provided with OpenERP and a large proportion of the core Open ERP functionality. You'll need to know your super administrator password for this – or you'll have to find somebody who does have it to create this seed database.


The super-administrator password


After first installation, the password is admin. This is the hard-coded default, and is used if there is no accessible server configuration file. If your system has been set up so that the server configuration file can be written to by the server then you can change the password through the client. Or you could deliberately make the configuration file read-only so that there is no prospect of changing it from the client. Either way, a server systems administrator can change it if you forget it.

So if your system is set u to allow it, you can change the superadmin password through the GTK client from the menu File ‣ Databases ‣ Administrator Password, or through the web client by logging out (click the Logout link), clicking Databases on the login screen, and then clicking the Password button on the Management screen.

服务器上的配置文件位置,通常是在启动服务器时用 --config 命令的选项来指定。



Creating the database

If you're using the GTK client, choose Files ‣ Databases ‣ New database in the menu at the top left. Enter the super-administrator password, then the name of the new database you're creating.


使用 GTK 客户端创建新资料库

If you're using the web client, click Databases on the login screen, then Create on the database management page. Enter the super-administrator password, and the name of the new database you're creating.

In both cases you'll see a checkbox that determines whether you load demonstration data or not. The consequences of checking this box or not affect the whole use of this database.

In both cases you'll also see that you can choose the Administrator password. This makes your database quite secure because you can ensure that it is unique from the outset. (In fact many people find it hard to resist admin as their password!)

数据库 openerp_ch01

Wait for the message showing that the database has been successfully created, along with the user accounts and passwords (admin/XXXX and demo/demo ). Now you've created this seed database you can extend it without having to know the super-administrator password.



对每一个数据库来说,用户名称/密码 都是唯一的组合;如果你有管理员的权限,你可以修改全部的用户。

Alternatively you can install the users_ldap module, which manages the authentication of users in LDAP (the Lightweight Directory Access Protocol, a standard system), and connect it to several Open ERP databases. Using this, many databases can share the same user account details.


Failure to create a database

How do you know if you've successfully created your new database? You're told if the database creation has been unsuccessful. If you have entered a database name using prohibited characters (or no name, or too short a name) you will be alerted by the dialog box Bad database name! explaining how to correct the error. If you've entered the wrong super-administrator password or a name already in use (some names can be reserved without your knowledge), you'll be alerted by the dialog box Error during database creation!.

Connect to the database openerp_ch01 that you just created, using the default administrator account.

If this is the first time you've connected to this database you'll be asked a series of questions to define the database parameters:

  1. Select a profile : select Minimal Profile and click Next.

  2. Company Details : replace the proposed default of Tiny sprl by your own company name, complete as much of your address as you like, and add some lines about your company, such as a slogan and any statutory requirements, to the header and footer fields. Click Next.

  3. Summary : check the information and go back to make any modifications you need before installation. Then click Install.

  4. Installation Completed : click Ok.

Once configuration is complete you're connected to your Open ERP system. Its functionality is very limited because you've selected a minimal installation, but this is sufficient to demonstrate that your installation is working.



Managing databases

As a super-administrator you've not only got rights to create new databases, but also to:

  • 删除数据库(帐套),

  • 备份数据库(帐套),

  • 恢复数据库(帐套).

All of these operations can be carried out from the menu File ‣ Databases... ‣ Backup databases in the GTK client, or from the Database button in the web client's Login screen.


Duplicating a database

To duplicate a database you can:

  1. 从数据库生成备份文件保存到本地电脑上。

  2. restore this database from the backup file on your PC, giving it a new name as you do so.


A system administrator can configure Open ERP to restrict access to some of these database functions so that your security is enhanced in normal production use.

You are now ready to use databases from your installation to familiarize yourself with the administration and use of Open ERP.

New Open ERP functionality

The database you've created and managed so far is based on the core Open ERP functionality that you installed. The core system is installed in the file system of your Open ERP application server, but only installed into an Open ERP database as you require it, as is described in the next chapter, OpenERP 漫游指南.

What if want to update what's there, or extend what's there with additional modules?

  • To update what you have, you'd install a new instance of Open ERP using the same techniques as described earlier in this section, Database creation.

  • To extend what you have, you'd install new modules in the addons directory of your current Open ERP installation. There are several ways of doing that.

In both cases you'll need briefly to be a root user or Administrator of your Open ERP application server.

Extending Open ERP

To extend Open ERP you'll need to copy modules into the addons directory. That's in your server's openerp-server directory (which differs between Windows, Mac and some of the various Linux distributions and not available at all in the Windows all-in-one installer).

If you look there you'll see existing modules such as product and purchase. A module can be provided in the form of files within a directory or a a zip-format file containing that same directory structure.


To add new modules through the server is a conventional systems administration task. As rootuser or other suitable user, you'd put the module in the addons directory and change its permissions to match those of the other modules.

To add new modules through the client you must first change the permissions of the addonsdirectory of the server, so that it is writable by the server. That will enable you to install Open ERP modules using the Open ERP client (a task ultimately carried out on the application server by the server software).


Changing permissions

A very simple way of changing permissions on the Linux system you're using to develop an Open ERP application is to execute the command sudo chmod 777 <path_to_addons> (where <path_to_addons> is the full path to the addons directory, a location like /usr/lib/python2.5/site-packages/openerp- server/addons).

Any user of Open ERP who has access to the relevant administration menus can then upload any new functionality, so you'd certainly disable this capability for production use. You'll see examples of this uploading as you make your way through this book.