error on running openerp-client

Asked by Pravitha V

i have installed GTK client and server successfully........but when i run the client using openerp-client the following error occurs at the server side.........
can anyone please help me

[2012-01-03 14:53:03,446][template1] ERROR:db.connection_pool:Connection to the database failed
Traceback (most recent call last):
  File "/usr/local/lib/python2.7/site-packages/openerp-server/sql_db.py", line 303, in borrow
    result = psycopg2.connect(dsn=dsn, connection_factory=PsycoConnection)
  File "/usr/local/lib/python2.7/site-packages/psycopg2/__init__.py", line 179, in connect
    connection_factory=connection_factory, async=async)
OperationalError: could not connect to server: No such file or directory
        Is the server running locally and accepting
        connections on Unix domain socket "/tmp/.s.PGSQL.5432"?

Question information

Language:
English Edit question
Status:
Solved
For:
Odoo Server (MOVED TO GITHUB) Edit question
Assignee:
No assignee Edit question
Solved by:
Serpent Consulting Services
Solved:
Last query:
Last reply:

This question was originally filed as bug #913046.

Revision history for this message
Pravitha V (pravithavarghese1) said :
#1

i have installed GTK client and server successfully........but when i run the client using openerp-client the following error occurs at the server side.........
can anyone please help me

[2012-01-03 14:53:03,446][template1] ERROR:db.connection_pool:Connection to the database failed
Traceback (most recent call last):
  File "/usr/local/lib/python2.7/site-packages/openerp-server/sql_db.py", line 303, in borrow
    result = psycopg2.connect(dsn=dsn, connection_factory=PsycoConnection)
  File "/usr/local/lib/python2.7/site-packages/psycopg2/__init__.py", line 179, in connect
    connection_factory=connection_factory, async=async)
OperationalError: could not connect to server: No such file or directory
        Is the server running locally and accepting
        connections on Unix domain socket "/tmp/.s.PGSQL.5432"?

Revision history for this message
Serpent Consulting Services (serpent-consulting-services) said :
#2

Hello Pravitha,

Typically this error means PostgreSQL is not currently running on the system you are logged into. You will need to start the daemon, which is typically done through your distribution's init system. Try to run it if its not running already.

I suppose your user has enough rights to access psql.

The easiest way to determine if PostgreSQL is running is to look for it using ps. For example when I run the command on my Fedora system:

ps auxw | grep post

I see the following processes:

postgres 4335 2.4 0.2 27704 2936 ? S 14:47 0:00 /usr/bin/postmaster -p 5432 -D /var/lib/pgsql/data
postgres 4337 0.0 0.0 9972 548 ? S 14:47 0:00 postgres: logger process
postgres 4339 0.0 0.0 27704 804 ? S 14:47 0:00 postgres: writer process
postgres 4340 0.0 0.0 10972 544 ? S 14:47 0:00 postgres: stats buffer process
postgres 4341 0.0 0.0 10148 668 ? S 14:47 0:00 postgres: stats collector process

Which as you can see means PostgreSQL is running on my local system. If we had received no results or just the final result line then we would no for certain that it is not running on this system.

If it still does not solve,
-- Do this:
-- # chown postgres /tmp/.s.PGSQL.5432.lock

If its still a path issue:
-- just edit /etc/paths and move the /usr/local/bin entry above /usr/bin and restart Terminal.

Hope this helps.

Thanks,
Serpent Consulting Services.
http://www.serpentcs.com

Revision history for this message
Pravitha V (pravithavarghese1) said :
#3

thankyou for ur help sir the problem was with ma server and client configuration i had fixed it.Now the database is working perfectly fine......now ma other prob is i had configured some applications but i want to delete one of the application.what should i do for it.

Revision history for this message
Serpent Consulting Services (serpent-consulting-services) said :
#4

Pravitha,

If you wish to remove the applications, you should go the list of modules, open your desired module record, and click uninstall.

Thanks,
Serpent Consulting Services.

Revision history for this message
Pravitha V (pravithavarghese1) said :
#5

but that not working sir.........actually i want to delete payroll menu from human resource application....i tried to uninstall from admministration->modules->modules->human resource payroll..........
but when i tried to delete it i get the following message

"You try to remove a module that is installed or will be installed"

and when i try to uninstall the it didnt worked and the status turned to

 "to be removed".

then i clicked apply sheduled upgrades then it shows

"Following modules are not installed or unknown: hr_contract"
 now what should i do???????????????????

Revision history for this message
Best Serpent Consulting Services (serpent-consulting-services) said :
#6

Pravitha,

That's because hr_contract might also been selected for un-installation.

If you dont want Payroll menu, you can hide the menu by adding a group.

Thanks.

Revision history for this message
Pravitha V (pravithavarghese1) said :
#7

i have uninstalled hr_contact by this method.it worked fine now its uninstalled.but the problem is with payroll.............sir i didnt understand what u meant by hiding the menu by adding a group........now payroll submenus are not working when clicked on them they show the following message

"Object hr.payslip doesn't exist".
i dont want payroll menu to vanish from display for that what should i do??????????????????

Revision history for this message
Pravitha V (pravithavarghese1) said :
#8

Thanks Serpent Consulting Services, that solved my question.