One reply I get from Mario: Mario Premke wrote:
I remember I had the same problem. In GUF's acl_user folder I gave the special_role the same permissions as the anonymus role. As far as I remember that did it ...
-- César A. K. Grossmann ckant@usa.net http://members.xoom.com/ckant/
Hello, Im trying to access a postres database from within zope. I have ZPoPyDA-0.5.tar.gz installed along with PoPy-1.2. The connection string Im using is something like: user=thierry host=myhost dbname=test port=5432 password=mypassword When I try to add a Z PoPy Database Connection with the above string, I get: Invalid connection string: user=thierry host=myhost dbname=test port=5432 password=mypassword Traceback (innermost last): File /usr/local/zope/2.1.7/lib/python/ZPublisher/Publish.py, line 214, in publish_module File /usr/local/zope/2.1.7/lib/python/ZPublisher/Publish.py, line 179, in publish File /usr/local/zope/2.1.7/lib/python/Zope/__init__.py, line 202, in zpublisher_exception_hook (Object: ElementWithAttributes) File /usr/local/zope/2.1.7/lib/python/ZPublisher/Publish.py, line 165, in publish File /usr/local/zope/2.1.7/lib/python/ZPublisher/mapply.py, line 160, in mapply (Object: addConnection) File /usr/local/zope/2.1.7/lib/python/ZPublisher/Publish.py, line 102, in call_object (Object: addConnection) File /usr/local/zope/2.1.7/lib/python/Products/ZPoPyDA/DA.py, line 55, in addConnection (Object: ElementWithAttributes) File /usr/local/zope/2.1.7/lib/python/Products/ZPoPyDA/DA.py, line 70, in __init__ (Object: RoleManager) File /usr/local/zope/2.1.7/lib/python/Products/ZPoPyDA/DA.py, line 140, in edit (Object: RoleManager) File /usr/local/zope/2.1.7/lib/python/Shared/DC/ZRDB/Connection.py, line 227, in connect (Object: RoleManager) File /usr/local/zope/2.1.7/lib/python/Products/ZPoPyDA/PoPy_db.py, line 54, in __init__ BadRequest: (see above) Any help would be appreciated. Thanks nitesh.
Le Mon, Jul 10, 2000 at 10:49:27AM -0500, Nitesh Dhanjani à écrit: # Im trying to access a postres database from within zope. I have # ZPoPyDA-0.5.tar.gz installed along with PoPy-1.2. # # The connection string Im using is something like: # user=thierry host=myhost dbname=test port=5432 password=mypassword It's a example. Change with yours attributes. thierry by your user. myhost by your host (or localhost). test by your db name. mypassword by your db password. For create a DB -> man createdb For create a user -> man createuser Docs at /usr/doc/postgresql-xxx/ -- (°- Sébastien Douche <sdouche@IDEALX.com> //\ IDEALX <www.IDEALX.com> <www.IDEALX.org> v_/_ Ingénierie Open Source
On Mon, 10 Jul 2000, Sebastien Douche wrote:
Le Mon, Jul 10, 2000 at 10:49:27AM -0500, Nitesh Dhanjani � �crit: # Im trying to access a postres database from within zope. I have # ZPoPyDA-0.5.tar.gz installed along with PoPy-1.2. # # The connection string Im using is something like: # user=thierry host=myhost dbname=test port=5432 password=mypassword
It's a example. Change with yours attributes. thierry by your user. myhost by your host (or localhost). test by your db name. mypassword by your db password.
Yes I know its an example, but did not want to post host+user info to the entire mailing list. I cannot seem to connect to the postgres database using psql, and get: Failed to authenticate client as Postgres user 'bob' using <unknown authentication type>: be_recvauth: unrecognized message type: 131072 so its probably not a problem with ZPoPyDA. If anyone has come across this error or might know of a solution, please let me know. Thanks nitesh.
On Mon, Jul 10, 2000 at 01:42:48PM -0500, Nitesh Dhanjani wrote:
On Mon, 10 Jul 2000, Sebastien Douche wrote:
Le Mon, Jul 10, 2000 at 10:49:27AM -0500, Nitesh Dhanjani à écrit: # Im trying to access a postres database from within zope. I have # ZPoPyDA-0.5.tar.gz installed along with PoPy-1.2. # # The connection string Im using is something like: # user=thierry host=myhost dbname=test port=5432 password=mypassword
Yes I know its an example, but did not want to post host+user info to the entire mailing list.
I cannot seem to connect to the postgres database using psql, and get: Failed to authenticate client as Postgres user 'bob' using <unknown authentication type>: be_recvauth: unrecognized message type: 131072
so its probably not a problem with ZPoPyDA. If anyone has come across this error or might know of a solution, please let me know.
Could you please post a bit more information: platform postgres is running on: postgres version: are internet domain sockets enabled on postgres: was PoPy compiled locally: are multiple versions of postgres residing on your db host: Jim
Thanks nitesh.
_______________________________________________ Zope maillist - Zope@zope.org http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )
On Mon, 10 Jul 2000 jpenny@universal-fasteners.com wrote:
On Mon, Jul 10, 2000 at 01:42:48PM -0500, Nitesh Dhanjani wrote:
On Mon, 10 Jul 2000, Sebastien Douche wrote:
Le Mon, Jul 10, 2000 at 10:49:27AM -0500, Nitesh Dhanjani � �crit: # Im trying to access a postres database from within zope. I have # ZPoPyDA-0.5.tar.gz installed along with PoPy-1.2. # # The connection string Im using is something like: # user=thierry host=myhost dbname=test port=5432 password=mypassword
Yes I know its an example, but did not want to post host+user info to the entire mailing list.
I cannot seem to connect to the postgres database using psql, and get: Failed to authenticate client as Postgres user 'bob' using <unknown authentication type>: be_recvauth: unrecognized message type: 131072
so its probably not a problem with ZPoPyDA. If anyone has come across this error or might know of a solution, please let me know.
Could you please post a bit more information:
platform postgres is running on: SunOS 5.6 Generic_105181-19 sun4m sparc SUNW,SPARCstation-20
Client (zope and psql) running on Linux 2.2.16 i686
postgres version: The person who installed postgres on the sparc machine isnt around anymore, im still trying to figure this out. The postmaster or postres executable do not have a "-v" or "-V" option that spits out the version.
The client side psql is 6.5.3
are internet domain sockets enabled on postgres:
I usually startup postgres like this "postmaster &", and was told to start it up with the -i switch. However postmaster doesnt seem to accept that switch: % postmaster -h usage: postmaster [options..] -a authsys do/do not permit use of an authentication system -B nbufs set number of shared buffers -b backend use a specific backend server executable -d [1|2|3] set debugging level -D datadir set data directory -m start up multiplexing backends -n don't reinitialize shared memory after abnormal exit -o option pass 'option' to each backend servers -p port specify port for postmaster to listen on -S silent mode (disassociate from tty) -s send SIGSTOP to all backend servers if one dies
was PoPy compiled locally:
yes, but this shouldnt matter, all im trying to do now is connect to a postgres database using psql.
are multiple versions of postgres residing on your db host:
nope thanks! nitesh
On Mon, Jul 10, 2000 at 05:39:27PM -0500, Nitesh Dhanjani wrote:
On Mon, 10 Jul 2000 jpenny@universal-fasteners.com wrote:
On Mon, Jul 10, 2000 at 01:42:48PM -0500, Nitesh Dhanjani wrote:
On Mon, 10 Jul 2000, Sebastien Douche wrote:
Le Mon, Jul 10, 2000 at 10:49:27AM -0500, Nitesh Dhanjani à écrit: # Im trying to access a postres database from within zope. I have # ZPoPyDA-0.5.tar.gz installed along with PoPy-1.2. # # The connection string Im using is something like: # user=thierry host=myhost dbname=test port=5432 password=mypassword
Yes I know its an example, but did not want to post host+user info to the entire mailing list.
I cannot seem to connect to the postgres database using psql, and get: Failed to authenticate client as Postgres user 'bob' using <unknown authentication type>: be_recvauth: unrecognized message type: 131072
so its probably not a problem with ZPoPyDA. If anyone has come across this error or might know of a solution, please let me know.
Could you please post a bit more information:
platform postgres is running on: SunOS 5.6 Generic_105181-19 sun4m sparc SUNW,SPARCstation-20
Client (zope and psql) running on Linux 2.2.16 i686
postgres version: The person who installed postgres on the sparc machine isnt around anymore, im still trying to figure this out. The postmaster or postres executable do not have a "-v" or "-V" option that spits out the version.
The client side psql is 6.5.3
Can psql on the linux connect to the postmaster on the sparc? (If I am right about the postmaster supporting only unix domain sockets, it should not.)
are internet domain sockets enabled on postgres:
I usually startup postgres like this "postmaster &", and was told to start it up with the -i switch. However postmaster doesnt seem to accept that switch: % postmaster -h usage: postmaster [options..] -a authsys do/do not permit use of an authentication system -B nbufs set number of shared buffers -b backend use a specific backend server executable -d [1|2|3] set debugging level -D datadir set data directory -m start up multiplexing backends -n don't reinitialize shared memory after abnormal exit -o option pass 'option' to each backend servers -p port specify port for postmaster to listen on -S silent mode (disassociate from tty) -s send SIGSTOP to all backend servers if one dies
OK, you are dead in the water at this point...you can use only Unix domain sockets and PoPy needs internet domain sockets. (Unix domain sockets can only talk when both client and server are on the same machine.)
was PoPy compiled locally:
yes, but this shouldnt matter, all im trying to do now is connect to a postgres database using psql.
It does matter for this reason: libpq changed between the 6.3 series and the 6.5 series. A client compiled against a newer libpq cannot connect to a postmaster compiled against the older libpq. I know that the version distributed by mixadlive.com was compiled with the new libpq.
are multiple versions of postgres residing on your db host:
nope
My best guess: you need to build new postgres on both machines. For locking performance, you certainly want a more recent version of postgres, anyway! The version you have almost certainly does table level locking. You are going to have to rebuild the sparc's copy. And dump and restore may get to be 'interesting'.
thanks! nitesh
_______________________________________________ Zope maillist - Zope@zope.org http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )
Failed to authenticate client as Postgres user 'bob' using <unknown authentication type>: be_recvauth: unrecognized message type: 131072
Can psql on the linux connect to the postmaster on the sparc? Nope, i get the error mentioned above when trying to connect with psql.
My best guess: you need to build new postgres on both machines. For locking performance, you certainly want a more recent version of postgres, anyway! The version you have almost certainly does table level locking. You are going to have to rebuild the sparc's copy. And dump and restore may get to be 'interesting'.
Yes, this is what Im going to do. From what I can tell, the postmater running on the sparc machine does not support the -i option. This will probably break a lot of stuff, including the tcl/tk interface that relies on this old postgres... oh well. thanks for your help. nitesh
participants (4)
-
Cesar A. K. Grossmann -
jpenny＠universal-fasteners.com -
Nitesh Dhanjani -
Sebastien Douche