Odoo 中文社区

[quote]原帖由 [i]digitalsatori[/i] 于 2009-9-4 16:22 发表 www.shine-it.net/redirect.php?goto=findpost&pid=2668&ptid=610
按道理说，通过debian安装包安装的openerp应该会自动设置数据库用户，配置文件等，Daemon服务等，一般不需要你再做设置。我没有用apt-get安装过openerp，所以具体情况不是很清楚。

postgreSQL数据库在ubuntu上默认 ... [/quote]

wen@wen-d:~$ openerp-server -d openerp -r openerp --addons-path=/etc/openerp-server.conf -s
Traceback (most recent call last):
File "./openerp-server.py", line 108, in <module>
pooler.get_db_and_pool(db, update_module=tools.config['init'] or
tools.config['update'])
File "/usr/lib/openerp-server/pooler.py", line 40, in get_db_and_pool
addons.load_modules(db, force_demo, status, update_module)
File "/usr/lib/openerp-server/addons/init.py", line 703, in load_modules
cr.execute("SELECT name from ir_module_module WHERE state in (%s)" %
','.join(['%s']*len(STATES_TO_LOAD)), STATES_TO_LOAD)
File "/usr/lib/openerp-server/sql_db.py", line 76, in wrapper
return f(self, *args, **kwargs)
File "/usr/lib/openerp-server/sql_db.py", line 118, in execute
res = self._obj.execute(query, params)
psycopg2.ProgrammingError: 错误: 关系 "ir_module_module" 不存在

在数据库中已经有对应数据库用户存在，用pgadmin可以登陆

为什么指定openerp的配置文件会出错呢？

[code]
wen@wen-d:/usr/bin$ openerp-server -c /etc/openerp-server.conf
ERROR: couldn't create the logfile directory. Logging to the standard
output.
[2009-09-01 22:08:46,708] INFO:server:version - 5.0.0
[2009-09-01 22:08:46,709] INFO:server:addons_path -
/usr/lib/openerp-server/addons
[2009-09-01 22:08:46,709] INFO:server:database hostname - localhost
[2009-09-01 22:08:46,709] INFO:server:database port - 5432
[2009-09-01 22:08:46,709] INFO:server:database user - openerp
[2009-09-01 22:08:46,710] INFO:objects:initialising distributed objects
services
[2009-09-01 22:08:46,986] INFO:dbpool:Connecting to openerp
Traceback (most recent call last):
File "./openerp-server.py", line 108, in <module>
pooler.get_db_and_pool(db, update_module=tools.config['init'] or
tools.config['update'])
File "/usr/lib/openerp-server/pooler.py", line 40, in get_db_and_pool
addons.load_modules(db, force_demo, status, update_module)
File "/usr/lib/openerp-server/addons/init.py", line 703, in load_modules
cr.execute("SELECT name from ir_module_module WHERE state in (%s)" %
','.join(['%s']*len(STATES_TO_LOAD)), STATES_TO_LOAD)
File "/usr/lib/openerp-server/sql_db.py", line 76, in wrapper
return f(self, *args, **kwargs)
File "/usr/lib/openerp-server/sql_db.py", line 118, in execute
res = self._obj.execute(query, params)
psycopg2.ProgrammingError: 错误: 关系 "ir_module_module" 不存在
[/code]

老大，谢了，又明白了一点点。

不过又出现了一些问题，

指定用户登陆，用的却是别的数据库：[code]
wen@wen-d:~$ openerp-server -r openerp
[2009-08-31 21:48:23,963] INFO:server:version - 5.0.0
[2009-08-31 21:48:23,963] INFO:server:addons_path -
/usr/lib/openerp-server/addons
[2009-08-31 21:48:23,963] INFO:server:database hostname - localhost
[2009-08-31 21:48:23,964] INFO:server:database port - 5432
[2009-08-31 21:48:23,964] INFO:server:database user - openerp
[2009-08-31 21:48:23,964] INFObjects:initialising distributed objects
services
[2009-08-31 21:48:24,199] INFO:web-services:starting XML-RPC services,
port 8069
[2009-08-31 21:48:24,199] INFO:web-services:starting NET-RPC service,
port 8070
[2009-08-31 21:48:24,200] INFO:web-services:the server is running,
waiting for connections...
[2009-08-31 21:48:32,287] INFO:dbpool:Connecting to template1
[2009-08-31 21:48:32,300] INFO:dbpool:Closing all connections to template1
Closing connection <connection object at 0x152cc80; dsn: 'user=openerp
dbname=template1', closed: 0>
[/code]指定数据库用户名和数据库，我也不知道是什么错误了：[code]
wen@wen-d:~$ openerp-server -r openerp
[2009-08-31 21:48:23,963] INFO:server:version - 5.0.0
[2009-08-31 21:48:23,963] INFO:server:addons_path -
/usr/lib/openerp-server/addons
[2009-08-31 21:48:23,963] INFO:server:database hostname - localhost
[2009-08-31 21:48:23,964] INFO:server:database port - 5432
[2009-08-31 21:48:23,964] INFO:server:database user - openerp
[2009-08-31 21:48:23,964] INFObjects:initialising distributed objects
services
[2009-08-31 21:48:24,199] INFO:web-services:starting XML-RPC services,
port 8069
[2009-08-31 21:48:24,199] INFO:web-services:starting NET-RPC service,
port 8070
[2009-08-31 21:48:24,200] INFO:web-services:the server is running,
waiting for connections...
[2009-08-31 21:48:32,287] INFO:dbpool:Connecting to template1
[2009-08-31 21:48:32,300] INFO:dbpool:Closing all connections to template1
Closing connection <connection object at 0x152cc80; dsn: 'user=openerp
dbname=template1', closed: 0>
[/code]指定数据库，它却用系统里的用户登陆：[code]
wen@wen-d:~$ openerp-server -d openerp
[2009-08-31 21:52:16,328] INFO:server:version - 5.0.0
[2009-08-31 21:52:16,328] INFO:server:addons_path -
/usr/lib/openerp-server/addons
[2009-08-31 21:52:16,329] INFO:server:database hostname - localhost
[2009-08-31 21:52:16,329] INFO:server:database port - 5432
[2009-08-31 21:52:16,329] INFO:server:database user - wen
[2009-08-31 21:52:16,329] INFObjects:initialising distributed objects
services
[2009-08-31 21:52:16,563] INFO:dbpool:Connecting to openerp
[2009-08-31 21:52:16,578] ERROR:dbpool:Unable to connect to openerp: 致
命错误: role "wen" does not exist
Traceback (most recent call last):
File "./openerp-server.py", line 108, in <module>
pooler.get_db_and_pool(db, update_module=tools.config['init'] or
tools.config['update'])
File "/usr/lib/openerp-server/pooler.py", line 29, in get_db_and_pool
db = get_db_only(db_name)
File "/usr/lib/openerp-server/pooler.py", line 71, in get_db_only
db = sql_db.db_connect(db_name)
File "/usr/lib/openerp-server/sql_db.py", line 239, in db_connect
return PoolManager.get(db_name)
File "/usr/lib/openerp-server/sql_db.py", line 223, in get
cls._pools[db_name] = ConnectionPool(ThreadedConnectionPool(1,
cls.maxconn, cls.dsn(db_name)), db_name)
File "/usr/lib/python2.5/site-packages/psycopg2/pool.py", line 161, in
init
self, minconn, maxconn, *args, **kwargs)
File "/usr/lib/python2.5/site-packages/psycopg2/pool.py", line 76, in
init
self._connect()
File "/usr/lib/python2.5/site-packages/psycopg2/pool.py", line 80, in
_connect
conn = psycopg2.connect(*self._args, **self._kwargs)
psycopg2.OperationalError: 致命错误: role "wen" does not exist
[/code]我想可能要指定配置文件才能解决问题，顺便问一下

 openerp-server.py --config=/PATH/TO/openerp-server.conf

/PATH/TO/openerp-server.conf是指哪里的地址？
如果我直接用openerp-server.py --config=/etc/openerp-server.conf,是不是就指定了/etc/openerp-server.conf为openerp的配置文件了呢?

[[i] 本帖最后由 paridis 于 2009-9-1 16:02 编辑 [/i]]

为什么在终端运行openerp-server --hlep可以显示很详细的帮助信息

Usage: openerp-server.py [options]
Options:
--version show program's version number and exit
-h, --help show this help message and exit
-c CONFIG, --config=CONFIG
specify alternate config file
-s, --save save configuration to ~/.openerp_serverrc
--pidfile=PIDFILE file where the server pid will be stored
-n INTERFACE, --interface=INTERFACE
specify the TCP IP address
-p PORT, --port=PORT specify the TCP port
--net_interface=NETINTERFACE
specify the TCP IP address for netrpc
--net_port=NETPORT specify the TCP port for netrpc

…

但是我运行openerp-server.py提示找不到命令？

如果openerp-server.py可以运行的话，用 --db_user=DB_USER 和 --db_password=DB_PASSWORD应该就可以解决问题了。

不过还是搞不清楚openerp的配置文件是哪个。

[[i] 本帖最后由 paridis 于 2009-8-31 20:24 编辑 [/i]]

谢谢您的答复，我是在ubuntu9.04上安装openerp5.0。

但是我在系统里搜索不到openerp_serverrc文件，只有一个openerp_serverrc.5.gz的压缩包。
openerp-server.conf在/etc文件夹下，应该就是openerp的配置文件了把，不过想不通为什么没有被读取。

现在刚换到ubuntu系统，对ubuntu还不熟，弱弱的问一下版主，上面那些命令要在哪个特定的目录里运行吗，在终端里面运行提示命令不存在？

在openerp-server.conf中的设置为

db_name =
db_user = openerp
db_password = openerp

用pgadmin3登陆PostgreSQL没有问题。

但是，每次用openerp-client都是显示，账套无法连接到服务器，确定按钮是灰色的无法点击。

/openerp-server中显示

[2009-08-31 10:48:20,894] INFO:server:version - 5.0.0
[2009-08-31 10:48:20,894] INFO:server:addons_path - /usr/lib/openerp-server/addons
[2009-08-31 10:48:20,895] INFO:server:database hostname - localhost
[2009-08-31 10:48:20,895] INFO:server:database port - 5432
[2009-08-31 10:48:20,895] INFO:server:database user - root
[2009-08-31 10:48:20,895] INFO:objects:initialising distributed objects services
[2009-08-31 10:48:22,059] INFO:web-services:starting XML-RPC services, port 8069
[2009-08-31 10:48:22,060] INFO:web-services:starting NET-RPC service, port 8070
[2009-08-31 10:48:22,060] INFO:web-services:the server is running, waiting for connections...

[2009-08-31 10:50:19,812] INFO:dbpool:Connecting to template1
[2009-08-31 10:50:19,859] ERROR:dbpool:Unable to connect to template1: 致命错误: role "root" does not exist

为什么会用root登陆呢？要在哪里设置？