[Zope] Help with ZPoPyDA
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. ___ Zope maillist - [EMAIL PROTECTED] 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 )
Re: [Zope] Help with ZPoPyDA
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 [EMAIL PROTECTED] //\ IDEALX www.IDEALX.com www.IDEALX.org v_/_ Ingénierie Open Source ___ Zope maillist - [EMAIL PROTECTED] 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 )
Re: [Zope] Help with ZPoPyDA
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. ___ Zope maillist - [EMAIL PROTECTED] 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 )
Re: [Zope] Help with ZPoPyDA
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 - [EMAIL PROTECTED] 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 ) ___ Zope maillist - [EMAIL PROTECTED] 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 )
Re: [Zope] Help with ZPoPyDA
On Mon, 10 Jul 2000 [EMAIL PROTECTED] 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 nbufsset 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 ___ Zope maillist - [EMAIL PROTECTED] 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 )
Re: [Zope] Help with ZPoPyDA
On Mon, Jul 10, 2000 at 05:39:27PM -0500, Nitesh Dhanjani wrote: On Mon, 10 Jul 2000 [EMAIL PROTECTED] 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 nbufsset 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 - [EMAIL PROTECTED] 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 ) ___ Zope maillist - [EMAIL PROTECTED] 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 )