Re: [Health] Problems with back and restore from Tryton client

[zodman]

same problem i resolve with this:

http://gilesbowkett.blogspot.mx/2011/07/error-must-be-owner-of-language-plpgsql.html

The user who connect to postgresql need be a superuser.

i fix the same problem with it.

On Mon, Feb 20, 2012 at 12:06 PM, Christoph H. Larsen
<address@hidden> wrote:
> Dear All,
>
> Sorry for cross-posting. The following has been submitted to the Tryton
> list on 21 January 2012. No reply so far, so maybe you can help:
>
> -----------------------------------------------------------------------
> On a recent install of Tryton 2.2.1 inside a jail located inside a
> well-established multi-jail server running FreeBSD 8.2. PostgreSQL
> (version 9.1.2 used for server and clients throughout the jails) is
> happily churning away on in a diffferent jail (and used by other
> application in other jails, too). Packet Filter (pf) firewall is in
> place and working nicely.
>
> I seem to encounter the dreaded OpenERP backup/restore problem, albeit
> partially:
> I CANNOT do any backup using the Tryton client database management
> faciltiies, unless I have been logged into the respective Tryton
> instance. When logged in, I do strike luck.
>
> So, if I am not logged into the respective Tryton database via the
> Tryton cient, and try to do a backup using the correct Tryton
> superuser password, I get:
> -----------------------------------------------------------------------------------------------------------------
> [Sat Jan 21 22:34:15 2012] INFO:database:DUMP DB: hmis_dkgmdc
> ----------------------------------------
> Exception happened during processing of request from ('192.168.0.71',
> 34096)
> Traceback (most recent call last):
>  File "/usr/local/lib/python2.7/SocketServer.py", line 582, in
> process_request_thread
>    self.finish_request(request, client_address)
>  File "/usr/local/lib/python2.7/SocketServer.py", line 323, in
> finish_request
>    self.RequestHandlerClass(request, client_address, self)
>  File "/usr/local/lib/python2.7/SocketServer.py", line 639, in
> __init__
>    self.handle()
>  File "/usr/local/lib/python2.7/BaseHTTPServer.py", line 345, in
> handle
>    self.handle_one_request()
>  File "/usr/local/lib/python2.7/BaseHTTPServer.py", line 313, in
> handle_one_request
>    self.raw_requestline = self.rfile.readline(65537)
>  File "/usr/local/lib/python2.7/socket.py", line 476, in readline
>    data = self._sock.recv(self._rbufsize)
> SysCallError: (-1, 'Unexpected EOF')
> ----------------------------------------
> Exception in thread Thread-6:
> Traceback (most recent call last):
>  File "/usr/local/lib/python2.7/threading.py", line 552, in
> __bootstrap_inner
>    self.run()
>  File "/usr/local/lib/python2.7/threading.py", line 505, in run
>    self.__target(*self.__args, **self.__kwargs)
>  File "/usr/local/lib/python2.7/SocketServer.py", line 586, in
> process_request_thread
>    self.shutdown_request(request)
>  File "/usr/local/lib/python2.7/SocketServer.py", line 459, in
> shutdown_request
>    request.shutdown(socket.SHUT_WR)
> TypeError: shutdown() takes exactly 0 arguments (1 given)
> -----------------------------------------------------------------------------------------------------------------
>
> Restores of the backed-up file via the Tryton client are entirely
> impossible and give this error message:
> ---------------------------------------------------------------------------------------------------------------------------------
> [Sat Jan 21 22:11:32 2012] INFO:database:connect to "template1"
> pg_restore: [archiver (db)] Error while PROCESSING TOC:
> pg_restore: [archiver (db)] Error from TOC entry 5370; 0 0 COMMENT
> EXTENSION plpgsql
> pg_restore: [archiver (db)] could not execute query: ERROR:  must be
> owner of extension plpgsql
>    Command was: COMMENT ON EXTENSION plpgsql IS 'PL/pgSQL procedural
> language';
>
> pg_restore: WARNING:  no privileges could be revoked for "public"
> pg_restore: WARNING:  no privileges could be revoked for "public"
> pg_restore: WARNING:  no privileges were granted for "public"
> pg_restore: WARNING:  no privileges were granted for "public"
> WARNING: errors ignored on restore: 1
> ----------------------------------------
> Exception happened during processing of request from ('192.168.0.71',
> 60833)
> Traceback (most recent call last):
>  File "/usr/local/lib/python2.7/SocketServer.py", line 582, in
> process_request_thread
>    self.finish_request(request, client_address)
>  File "/usr/local/lib/python2.7/SocketServer.py", line 323, in
> finish_request
>    self.RequestHandlerClass(request, client_address, self)
>  File "/usr/local/lib/python2.7/SocketServer.py", line 639, in
> __init__
>    self.handle()
>  File "/usr/local/lib/python2.7/BaseHTTPServer.py", line 345, in
> handle
>    self.handle_one_request()
>  File "/usr/local/lib/python2.7/BaseHTTPServer.py", line 313, in
> handle_one_request
>    self.raw_requestline = self.rfile.readline(65537)
>  File "/usr/local/lib/python2.7/socket.py", line 476, in readline
>    data = self._sock.recv(self._rbufsize)
> SysCallError: (-1, 'Unexpected EOF')
> ----------------------------------------
> Exception in thread Thread-1:
> Traceback (most recent call last):
>  File "/usr/local/lib/python2.7/threading.py", line 552, in
> __bootstrap_inner
>    self.run()
>  File "/usr/local/lib/python2.7/threading.py", line 505, in run
>    self.__target(*self.__args, **self.__kwargs)
>  File "/usr/local/lib/python2.7/SocketServer.py", line 586, in
> process_request_thread
>    self.shutdown_request(request)
>  File "/usr/local/lib/python2.7/SocketServer.py", line 459, in
> shutdown_request
>    request.shutdown(socket.SHUT_WR)
> TypeError: shutdown() takes exactly 0 arguments (1 given)
> ---------------------------------------------------------------------------------------------------------------------------------
> Given the strange error message (python-PgSQL is nowhere mentioned as
> a dependency for Trytond) I did install in both client and server for
> testing purposes, but did not get any different error message. The
> unexpected EOF error might also indicate a defective backup file...
>
> Anybody with any ideas how to approach this problem? (Please note that
> I do NOT PostgreSQL on localhost with trust credentials, but via SSL
> in a different jail.)
> -----------------------------------------------------------------------
>
> Thanks a lot, indeed -
>
> Chris
>