Re: [Zope] Re: ZEO and Sessions.
On 4/14/05, Richard Jones [EMAIL PROTECTED] wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Wed, 13 Apr 2005 10:21 am, Tres Seaver wrote:
Richard Jones wrote:
Yeah, I remember poking around that code way back, and it seemed
reasonable. Its interactions with transactions are the bits that scare
me. Using a standard RDBMS connection would probably solve that though.
I revisited the SQLSession product a year ago for a consuling customer,
making their hacked version a drop-in replacement for the transient
storage. I can't release their code, but I maybe learned enough then to
redo the task as a PluggableSessions product, using the
PluginRegistry product to manage the different requried bits.
Well, I have a ZSQLSessionDataManager implementation based on the standard
SessionDataManager with some changes. It appears to work fine when I test our
application (which makes heavy use of sessions).
So far the SQL code is geared towards Postgres (and gadfly, I think). It'd
need some tweaking to work on MySQL ('cos MySQL is *special*) and I'm not
interested in doing that work ('cos MySQL is *special*).
http://www.zope.org/Members/richard/ZSQLSessionDataManager
ark!
insufficient priveleges
Insufficient Privileges
You do not have sufficient privileges to view this page.
If you are getting this message when trying to edit your own zope.org
content, remember that you must retract published items before you may
edit them. To retract an item, click on the State link to view the
publishing status form and select retract from the publishing
options.
If you believe you are receiving this message in error, please send an
e-mail to [EMAIL PROTECTED]
Richard
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.2.4 (GNU/Linux)
iD8DBQFCXhkFrGisBEHG6TARAjmiAKCCEa9AH/1l5LGx4py/CHhXb1X7hACfZiYE
iFsD9cpdZgb8+7NwlVwethY=
=nVP7
-END PGP SIGNATURE-
___
Zope maillist - Zope@zope.org
http://mail.zope.org/mailman/listinfo/zope
** No cross posts or HTML encoding! **
(Related lists -
http://mail.zope.org/mailman/listinfo/zope-announce
http://mail.zope.org/mailman/listinfo/zope-dev )
--
http://myzope.kedai.com.my - my-zope org
___
Zope maillist - Zope@zope.org
http://mail.zope.org/mailman/listinfo/zope
** No cross posts or HTML encoding! **
(Related lists -
http://mail.zope.org/mailman/listinfo/zope-announce
http://mail.zope.org/mailman/listinfo/zope-dev )
[Zope] Re: ZEO and Sessions.
Bakhtiar A Hamid wrote:
On 4/14/05, Richard Jones [EMAIL PROTECTED] wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Wed, 13 Apr 2005 10:21 am, Tres Seaver wrote:
Richard Jones wrote:
Yeah, I remember poking around that code way back, and it seemed
reasonable. Its interactions with transactions are the bits that scare
me. Using a standard RDBMS connection would probably solve that though.
I revisited the SQLSession product a year ago for a consuling customer,
making their hacked version a drop-in replacement for the transient
storage. I can't release their code, but I maybe learned enough then to
redo the task as a PluggableSessions product, using the
PluginRegistry product to manage the different requried bits.
Well, I have a ZSQLSessionDataManager implementation based on the standard
SessionDataManager with some changes. It appears to work fine when I test our
application (which makes heavy use of sessions).
So far the SQL code is geared towards Postgres (and gadfly, I think). It'd
need some tweaking to work on MySQL ('cos MySQL is *special*) and I'm not
interested in doing that work ('cos MySQL is *special*).
http://www.zope.org/Members/richard/ZSQLSessionDataManager
ark!
insufficient priveleges
Works now !
Michael
--
http://zope.org/Members/d2m
http://planetzope.org
___
Zope maillist - Zope@zope.org
http://mail.zope.org/mailman/listinfo/zope
** No cross posts or HTML encoding! **
(Related lists -
http://mail.zope.org/mailman/listinfo/zope-announce
http://mail.zope.org/mailman/listinfo/zope-dev )
Re: [Zope] Re: ZEO and Sessions.
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Fri, 15 Apr 2005 05:54 pm, Michael Haubenwallner wrote: Bakhtiar A Hamid wrote: Richard Jones wrote: http://www.zope.org/Members/richard/ZSQLSessionDataManager ark! insufficient priveleges Works now ! Well, it does *sometimes*. Whenever I make a new release though, the zope.org permissions seem to be screwey and end up giving people an error when they try to view the page! So I made two releases in quick succession today, and whoever manages zope.org did get those releases through publication quickly (though again, the page came up as an error in the mean time). Unfortunately, an erroneous release I made - which I did not mark for publication that I'm aware of, and had a meaningless ID - was also published. I've now marked it as retracted (there doesn't appear to be any way to *delete* a release), meaning the ZSQLSessionDataManager is again inaccessible by regular users. Sigh. Richard -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.4 (GNU/Linux) iD8DBQFCX4aorGisBEHG6TARAhSJAJ4qsrn7hHcc4MP3qftObcQlfF/7LACcCZQe NIrUvoBbIvplD/s0jZuelLc= =0gfa -END PGP SIGNATURE- ___ Zope maillist - Zope@zope.org http://mail.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce http://mail.zope.org/mailman/listinfo/zope-dev )
[Zope] Re: ZEO and Sessions.
Richard Jones wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Fri, 15 Apr 2005 05:54 pm, Michael Haubenwallner wrote: Bakhtiar A Hamid wrote: Richard Jones wrote: http://www.zope.org/Members/richard/ZSQLSessionDataManager ark! insufficient priveleges Works now ! Well, it does *sometimes*. Whenever I make a new release though, the zope.org permissions seem to be screwey and end up giving people an error when they try to view the page! So I made two releases in quick succession today, and whoever manages zope.org did get those releases through publication quickly (though again, the page came up as an error in the mean time). Unfortunately, an erroneous release I made - which I did not mark for publication that I'm aware of, and had a meaningless ID - was also published. I've now marked it as retracted (there doesn't appear to be any way to *delete* a release), meaning the ZSQLSessionDataManager is again inaccessible by regular users. Sigh. Hi Richard, that is a very old problem with software releases - any 'private' file inside the current release blocks the access to the release and only folder_contents works for some roles. You can retract the file it is in 'private' state and you remove it from the folder yourself. It takes some time for the caches to update too. Michael -- http://zope.org/Members/d2m http://planetzope.org ___ Zope maillist - Zope@zope.org http://mail.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce http://mail.zope.org/mailman/listinfo/zope-dev )
Re: [Zope] Re: ZEO and Sessions.
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Wed, 13 Apr 2005 10:21 am, Tres Seaver wrote:
Richard Jones wrote:
Yeah, I remember poking around that code way back, and it seemed
reasonable. Its interactions with transactions are the bits that scare
me. Using a standard RDBMS connection would probably solve that though.
I revisited the SQLSession product a year ago for a consuling customer,
making their hacked version a drop-in replacement for the transient
storage. I can't release their code, but I maybe learned enough then to
redo the task as a PluggableSessions product, using the
PluginRegistry product to manage the different requried bits.
Well, I have a ZSQLSessionDataManager implementation based on the standard
SessionDataManager with some changes. It appears to work fine when I test our
application (which makes heavy use of sessions).
So far the SQL code is geared towards Postgres (and gadfly, I think). It'd
need some tweaking to work on MySQL ('cos MySQL is *special*) and I'm not
interested in doing that work ('cos MySQL is *special*).
http://www.zope.org/Members/richard/ZSQLSessionDataManager
Richard
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.2.4 (GNU/Linux)
iD8DBQFCXhkFrGisBEHG6TARAjmiAKCCEa9AH/1l5LGx4py/CHhXb1X7hACfZiYE
iFsD9cpdZgb8+7NwlVwethY=
=nVP7
-END PGP SIGNATURE-
___
Zope maillist - Zope@zope.org
http://mail.zope.org/mailman/listinfo/zope
** No cross posts or HTML encoding! **
(Related lists -
http://mail.zope.org/mailman/listinfo/zope-announce
http://mail.zope.org/mailman/listinfo/zope-dev )
[Zope] Re: ZEO and Sessions.
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Richard Jones wrote:
On Wed, 13 Apr 2005 10:21 am, Tres Seaver wrote:
Richard Jones wrote:
Yeah, I remember poking around that code way back, and it seemed
reasonable. Its interactions with transactions are the bits that scare
me. Using a standard RDBMS connection would probably solve that though.
I revisited the SQLSession product a year ago for a consuling customer,
making their hacked version a drop-in replacement for the transient
storage. I can't release their code, but I maybe learned enough then to
redo the task as a PluggableSessions product, using the
PluginRegistry product to manage the different requried bits.
Well, I have a ZSQLSessionDataManager implementation based on the standard
SessionDataManager with some changes. It appears to work fine when I test our
application (which makes heavy use of sessions).
So far the SQL code is geared towards Postgres (and gadfly, I think). It'd
need some tweaking to work on MySQL ('cos MySQL is *special*) and I'm not
interested in doing that work ('cos MySQL is *special*).
http://www.zope.org/Members/richard/ZSQLSessionDataManager
Cool. Where is CVS for that, so that I don't bug you for features. ;)
I could import it to cvs.zope.org, if you like.
Tres.
- --
===
Tres Seaver[EMAIL PROTECTED]
Zope Corporation Zope Dealers http://www.zope.com
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.2.5 (GNU/Linux)
Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org
iD8DBQFCXoEbGqWXf00rNCgRAuhJAKCaV3P7/MRuBQD8oL6Awmofc42hYgCglex+
OY3hhWKBg05zs4IG5xmKNuk=
=vYaS
-END PGP SIGNATURE-
___
Zope maillist - Zope@zope.org
http://mail.zope.org/mailman/listinfo/zope
** No cross posts or HTML encoding! **
(Related lists -
http://mail.zope.org/mailman/listinfo/zope-announce
http://mail.zope.org/mailman/listinfo/zope-dev )
Re: [Zope] Re: ZEO and Sessions.
Tres Seaver wrote: http://www.zope.org/Members/richard/ZSQLSessionDataManager Cool. Where is CVS for that, so that I don't bug you for features. ;) I could import it to cvs.zope.org, if you like. I'd like to add Oracle support since I need it myself, and when I have working changes would like to have them included in newer releases of ZSQLSessionDataManager. /dario -- -- --- Dario Lopez-Kästen, IT Systems Services Chalmers University of Tech. ...and click? damn, I need to kill -9 Word again... - b using macosx ___ Zope maillist - Zope@zope.org http://mail.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce http://mail.zope.org/mailman/listinfo/zope-dev )
[Zope] Re: ZEO and Sessions.
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Richard Jones wrote: On Wed, 13 Apr 2005 09:44 am, Chris McDonough wrote: Probably not hard. You could write a session data manager implementation that used a relational database. The interface for those things is in Products/Sessions/SessionInterfaces.py Yeah, I remember poking around that code way back, and it seemed reasonable. Its interactions with transactions are the bits that scare me. Using a standard RDBMS connection would probably solve that though. I revisited the SQLSession product a year ago for a consuling customer, making their hacked version a drop-in replacement for the transient storage. I can't release their code, but I maybe learned enough then to redo the task as a PluggableSessions product, using the PluginRegistry product to manage the different requried bits. Tres. - -- === Tres Seaver[EMAIL PROTECTED] Zope Corporation Zope Dealers http://www.zope.com -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.5 (GNU/Linux) Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org iD8DBQFCXGYNGqWXf00rNCgRAqgqAJ9YjRNE1yqZKOXrl4nWlLCNaa/LvwCffVLH nqNZzuOutIv9hMTkIWfPu1w= =rrHr -END PGP SIGNATURE- ___ Zope maillist - Zope@zope.org http://mail.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce http://mail.zope.org/mailman/listinfo/zope-dev )
