How can i start openerp server using postgres user in version 5.2dev?

Hello Deven,

It seems like you are running server from postgres user.
Logout from postgres user and retry.

It should not be postgres@user/server/bin/ ./openerp-server.py.

postgres@XXX:/home/XXX/ws_bzr/trunk/server/bin$ ./openerp-server.py
[2010-04-28 11:55:37,569] INFO:server:version - 5.2dev
[2010-04-28 11:55:37,570] INFO:server:addons_path - /home/XXX/ws_bzr/trunk/server/bin/addons
[2010-04-28 11:55:37,570] INFO:server:database hostname - localhost
[2010-04-28 11:55:37,570] INFO:server:database port - 5432
[2010-04-28 11:55:37,571] INFO:server:database user - postgres
[2010-04-28 11:55:37,571] ERROR:server:Attempted to connect database with postgres user. This is a security flaws, aborting.
postgres@XXX:/home/XXX/ws_bzr/trunk/server/bin$ exit
exit
XXX@XXX:~/ws_bzr/trunk/server/bin$ ./openerp-server.py --addons-path=../../addons/
[2010-04-28 11:55:56,523] INFO:server:version - 5.2dev
[2010-04-28 11:55:56,524] INFO:server:addons_path - /home/XXX/ws_bzr/trunk/addons
[2010-04-28 11:55:56,524] INFO:server:database hostname - localhost
[2010-04-28 11:55:56,524] INFO:server:database port - 5432
[2010-04-28 11:55:56,525] INFO:server:database user - jvo
[2010-04-28 11:55:56,525] INFO:objects:initialising distributed objects services
[2010-04-28 11:55:56,754] INFO:web-services:starting HTTPS service at 0.0.0.0 port 8069
[2010-04-28 11:55:56,755] INFO:web-services:Registered XML-RPC over HTTP
[2010-04-28 11:55:56,756] INFO:web-services:starting NET-RPC service at 0.0.0.0 port 8070
[2010-04-28 11:55:56,757] INFO:server:Starting 2 services
[2010-04-28 11:55:56,773] INFO:web-services:the server is running, waiting for connections...

Hope this helps.

Thanks.

Hello Jay,

I have run the below command,

XXX@XXX:~/XXX/openerp/source/trunk/openobject-server/bin$ python openerp-server.py --db_user=openerp --db_password=openerp
[2010-04-28 12:02:03,501] INFO:server:version - 5.2dev
[2010-04-28 12:02:03,501] INFO:server:addons_path - /home/XXX/XXX/openerp/source/trunk/openobject-server/bin/addons
[2010-04-28 12:02:03,501] INFO:server:database hostname - localhost
[2010-04-28 12:02:03,501] INFO:server:database port - 5432
[2010-04-28 12:02:03,501] INFO:server:database user - openerp
[2010-04-28 12:02:03,502] INFO:objects:initialising distributed objects services
[2010-04-28 12:02:03,836] INFO:web-services:starting HTTPS service at 0.0.0.0 port 8069
[2010-04-28 12:02:03,836] INFO:web-services:Registered XML-RPC over HTTP
[2010-04-28 12:02:03,840] INFO:web-services:starting NET-RPC service at 0.0.0.0 port 8070
[2010-04-28 12:02:03,840] INFO:server:Starting 2 services
[2010-04-28 12:02:03,841] INFO:web-services:the server is running, waiting for connections...

So server is running successfully but when i am starting client then it showing me 'Could not connect to server!'

How can i connect them?

Sincerely,
Deven

Hello Deven,

If you can't connect to server, make sure the port is properly set.
I dont think you need to run server with --db_user=openerp --db_password=openerp.

Make sure, the client is also under non-postgres user.

Thanks.

Hello Jay,

I have run server without --db_user and --db_password option but still its not able to connect. And how can i check on which user client is running?

Sincerely,
Deven

XXX@XXX:~/XXX/openerp/source/trunk/openobject-client/bin.

You may check tracebacks on log.

Thanks.

Hello Jay,

In traceback log only one line is coming

WARNING:translate:Unable to set locale en_US.ISO8859-1: unsupported locale setting

What should i do now?

Sincerely,
Deven

Make sure client is running with non-postgres user.
 XXX@XXX:~/XXX/openerp/source/trunk/openobject-client/bin.

The port should be right to connect to server, the user should have rights to connect to server. Check server log.

Thanks.

I think that the server does not log postgres connexion errors.

I have the same problem (I didn't spend time on this for now.) on a computer at home.
I am pretty sure that was a Postgres bad configuration. I think Posgres refuse connexion but OpenERP doesn't log it, even in "Debug log" mode.

https://bugs.launchpad.net/openobject-server/+bug/550151

Hello Jay,

I agree with Nicolas. I am not getting anything in server or in client.
What should i do now? Where is the actual problem?

Sincerely,
Deven

Hello Deven,

Its a problem of either a postgres user starting openerp client or your bad configuration of postgres.

As I wrote already, XXX@XXX:~/XXX/openerp/source/trunk/openobject-client/bin.
User should not be a postgres.

Thanks.

I was running the client as a non-postgres user and it wouldn't connect.

I then realized I had not started the openerp-server as the postgres user. When I did that, it worked.

Hope this helps.