[web2py] Re: Email and PGP

[szimszon]

I think the problem here is
 
 - The key was found but the can_sign property is set to False

but I can't find how to set it... :(

2014. január 30., csütörtök 11:55:39 UTC+1 időpontban Alan Etkin a 
következőt írta:
>
> Okay, looks like nobody can help me. I guess not that many people use PGP 
>> email from web2py. Probably because it's so gnarly.
>>
>
> Apparently, you get that error message because one of this reasons:
>
> - A search for the signing key returned a void set
> - The key was found but the can_sign property is set to False
>
> If you want, you can debug the error checking the output in gluon/tools.py 
> around line 496.
>

-- 
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
--- 
You received this message because you are subscribed to the Google Groups 
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

[web2py] Re: Email and PGP

[szimszon]

Can you sign some txt from command line with web2py's user?

gpg --sign --default-key my_han...@gmail.com x.txt


?

2014. január 29., szerda 16:12:43 UTC+1 időpontban horridohobbyist a 
következőt írta:
>
> It says "expires: never" and "trust: ultimate" and "validity: ultimate", 
> and "usage: SC" for "pub" and "usage: E" for "sub". Looks good, I think.
>
> Just for the purpose of testing, I want to do one thing at a time. So 
> first, I want to send an encrypted email. I don't care whether the receiver 
> can decrypt the message. Surely web2py can send an encrypted email to 
> anybody without a public key...
>
> Alternatively, can I send an encrypted email to myself, since my public 
> key should already be in my keyring? Ultimately, that's what I want to do, 
> anyway.
>
>
> On Wednesday, 29 January 2014 09:29:31 UTC-5, szimszon wrote:
>>
>> It could be that the key is not trusted. What is the status of the key if 
>> you look at:
>>
>> gpg --edit-key my_h...@gmail.com
>>
>> you can mark it as trusted with the trust command at gpg's cli.
>>
>> As I see in pgpme the problem is that there is no *suitable* key for 
>> signing rater than no key at all.
>>
>> First you should disable encryption and see if you could set up 
>> signing... 
>>
>> 2014. január 29., szerda 14:54:51 UTC+1 időpontban horridohobbyist a 
>> következőt írta:
>>>
>>> Absolutely. The private (and public) keys are there for "
>>> my_h...@gmail.com".
>>>
>>> Re: the receiver's public key, where do I put it and how do I 
>>> incorporate it into the code that sends the email? (Excuse me for not 
>>> understanding how PGP email works.) This second question is lower priority. 
>>> Right now, my *biggest* issue is just getting web2py to send the 
>>> *encrypted* email *without errors*.
>>>
>>> Thanks.
>>>
>>> On Wednesday, 29 January 2014 03:11:55 UTC-5, szimszon wrote:
>>>>
>>>> If you list your private keys is there a key for 'my_h...@gmail.com'?
>>>>
>>>> (gpg --list-secret-keys)
>>>>
>>>> And yes you need to have receiver's public key before you could send 
>>>> encrypted messages to him/her.
>>>>
>>>> 2014. január 28., kedd 22:27:44 UTC+1 időpontban horridohobbyist a 
>>>> következőt írta:
>>>>>
>>>>> GnuPG seems to be intimately tied to the user account on Linux. It 
>>>>> always, always expects .gnupg to be in /home/richard/. I can't seem to 
>>>>> give 
>>>>> it an alternate location.
>>>>>
>>>>> Thinking that it might be a file ownership problem, I chown'd .gnupg 
>>>>> and everything in it to www-data:www-data, but this gave me the 
>>>>> mail.error 
>>>>> "GPG error:Invocation of gpgme_op_sign:Unspecified source:General error".
>>>>>
>>>>> I chown'd everything back to richard:richard, and I got the mail.error 
>>>>> "No key for signing [my_h...@gmail.com]". So I lose either way!
>>>>>
>>>>> It's probably not a file ownership problem. I am totally baffled by 
>>>>> this. Is PGP Email in web2py broken? Has anyone used it successfully 
>>>>> recently??
>>>>>
>>>>> Another question I have is:  Must I have the public key for the 
>>>>> receiver of my encrypted email before I can send? I'm grasping at straws, 
>>>>> I 
>>>>> know.
>>>>>
>>>>> Thanks.
>>>>>
>>>>>
>>>>> On Tuesday, 28 January 2014 13:53:02 UTC-5, horridohobbyist wrote:
>>>>>>
>>>>>> The error message is "No key for signing [my_h...@gmail.com]".
>>>>>>
>>>>>> I did create the key files with gpg for sender "my_h...@gmail.com". 
>>>>>> By default, they're created in my home directory, so I moved the .gnupg 
>>>>>> folder to /home/www-data/ and chown'd it and its contents to 
>>>>>> "www-data:www-data".
>>>>>>
>>>>>> I don't know if there are any other steps besides the above. I used 
>>>>>> the same sender email and passphrase in creating the keys. So everything 
>>>>>> should be okay.
>>>>>&

[web2py] Re: Email and PGP

[szimszon]

You must have a public key for the recipient. Web2py can send only 
encrypted mails if the recipient's public key is known.

2014. január 29., szerda 16:12:43 UTC+1 időpontban horridohobbyist a 
következőt írta:
>
> It says "expires: never" and "trust: ultimate" and "validity: ultimate", 
> and "usage: SC" for "pub" and "usage: E" for "sub". Looks good, I think.
>
> Just for the purpose of testing, I want to do one thing at a time. So 
> first, I want to send an encrypted email. I don't care whether the receiver 
> can decrypt the message. Surely web2py can send an encrypted email to 
> anybody without a public key...
>
> Alternatively, can I send an encrypted email to myself, since my public 
> key should already be in my keyring? Ultimately, that's what I want to do, 
> anyway.
>
>
> On Wednesday, 29 January 2014 09:29:31 UTC-5, szimszon wrote:
>>
>> It could be that the key is not trusted. What is the status of the key if 
>> you look at:
>>
>> gpg --edit-key my_h...@gmail.com
>>
>> you can mark it as trusted with the trust command at gpg's cli.
>>
>> As I see in pgpme the problem is that there is no *suitable* key for 
>> signing rater than no key at all.
>>
>> First you should disable encryption and see if you could set up 
>> signing... 
>>
>> 2014. január 29., szerda 14:54:51 UTC+1 időpontban horridohobbyist a 
>> következőt írta:
>>>
>>> Absolutely. The private (and public) keys are there for "
>>> my_h...@gmail.com".
>>>
>>> Re: the receiver's public key, where do I put it and how do I 
>>> incorporate it into the code that sends the email? (Excuse me for not 
>>> understanding how PGP email works.) This second question is lower priority. 
>>> Right now, my *biggest* issue is just getting web2py to send the 
>>> *encrypted* email *without errors*.
>>>
>>> Thanks.
>>>
>>> On Wednesday, 29 January 2014 03:11:55 UTC-5, szimszon wrote:
>>>>
>>>> If you list your private keys is there a key for 'my_h...@gmail.com'?
>>>>
>>>> (gpg --list-secret-keys)
>>>>
>>>> And yes you need to have receiver's public key before you could send 
>>>> encrypted messages to him/her.
>>>>
>>>> 2014. január 28., kedd 22:27:44 UTC+1 időpontban horridohobbyist a 
>>>> következőt írta:
>>>>>
>>>>> GnuPG seems to be intimately tied to the user account on Linux. It 
>>>>> always, always expects .gnupg to be in /home/richard/. I can't seem to 
>>>>> give 
>>>>> it an alternate location.
>>>>>
>>>>> Thinking that it might be a file ownership problem, I chown'd .gnupg 
>>>>> and everything in it to www-data:www-data, but this gave me the 
>>>>> mail.error 
>>>>> "GPG error:Invocation of gpgme_op_sign:Unspecified source:General error".
>>>>>
>>>>> I chown'd everything back to richard:richard, and I got the mail.error 
>>>>> "No key for signing [my_h...@gmail.com]". So I lose either way!
>>>>>
>>>>> It's probably not a file ownership problem. I am totally baffled by 
>>>>> this. Is PGP Email in web2py broken? Has anyone used it successfully 
>>>>> recently??
>>>>>
>>>>> Another question I have is:  Must I have the public key for the 
>>>>> receiver of my encrypted email before I can send? I'm grasping at straws, 
>>>>> I 
>>>>> know.
>>>>>
>>>>> Thanks.
>>>>>
>>>>>
>>>>> On Tuesday, 28 January 2014 13:53:02 UTC-5, horridohobbyist wrote:
>>>>>>
>>>>>> The error message is "No key for signing [my_h...@gmail.com]".
>>>>>>
>>>>>> I did create the key files with gpg for sender "my_h...@gmail.com". 
>>>>>> By default, they're created in my home directory, so I moved the .gnupg 
>>>>>> folder to /home/www-data/ and chown'd it and its contents to 
>>>>>> "www-data:www-data".
>>>>>>
>>>>>> I don't know if there are any other steps besides the above. I used 
>>>>>> the same sender email and passphrase in creating the keys. So everything 
>>>>>> should be o

[web2py] Re: Email and PGP

[szimszon]

It could be that the key is not trusted. What is the status of the key if 
you look at:

gpg --edit-key my_han...@gmail.com

you can mark it as trusted with the trust command at gpg's cli.

As I see in pgpme the problem is that there is no *suitable* key for 
signing rater than no key at all.

First you should disable encryption and see if you could set up signing... 

2014. január 29., szerda 14:54:51 UTC+1 időpontban horridohobbyist a 
következőt írta:
>
> Absolutely. The private (and public) keys are there for 
> "my_h...@gmail.com
> ".
>
> Re: the receiver's public key, where do I put it and how do I incorporate 
> it into the code that sends the email? (Excuse me for not understanding how 
> PGP email works.) This second question is lower priority. Right now, my 
> *biggest* issue is just getting web2py to send the *encrypted* email *without 
> errors*.
>
> Thanks.
>
> On Wednesday, 29 January 2014 03:11:55 UTC-5, szimszon wrote:
>>
>> If you list your private keys is there a key for 'my_h...@gmail.com'?
>>
>> (gpg --list-secret-keys)
>>
>> And yes you need to have receiver's public key before you could send 
>> encrypted messages to him/her.
>>
>> 2014. január 28., kedd 22:27:44 UTC+1 időpontban horridohobbyist a 
>> következőt írta:
>>>
>>> GnuPG seems to be intimately tied to the user account on Linux. It 
>>> always, always expects .gnupg to be in /home/richard/. I can't seem to give 
>>> it an alternate location.
>>>
>>> Thinking that it might be a file ownership problem, I chown'd .gnupg and 
>>> everything in it to www-data:www-data, but this gave me the mail.error "GPG 
>>> error:Invocation of gpgme_op_sign:Unspecified source:General error".
>>>
>>> I chown'd everything back to richard:richard, and I got the mail.error 
>>> "No key for signing [my_h...@gmail.com]". So I lose either way!
>>>
>>> It's probably not a file ownership problem. I am totally baffled by 
>>> this. Is PGP Email in web2py broken? Has anyone used it successfully 
>>> recently??
>>>
>>> Another question I have is:  Must I have the public key for the receiver 
>>> of my encrypted email before I can send? I'm grasping at straws, I know.
>>>
>>> Thanks.
>>>
>>>
>>> On Tuesday, 28 January 2014 13:53:02 UTC-5, horridohobbyist wrote:
>>>>
>>>> The error message is "No key for signing [my_h...@gmail.com]".
>>>>
>>>> I did create the key files with gpg for sender "my_h...@gmail.com". By 
>>>> default, they're created in my home directory, so I moved the .gnupg 
>>>> folder 
>>>> to /home/www-data/ and chown'd it and its contents to "www-data:www-data"
>>>> .
>>>>
>>>> I don't know if there are any other steps besides the above. I used the 
>>>> same sender email and passphrase in creating the keys. So everything 
>>>> should 
>>>> be okay.
>>>>
>>>> Thanks.
>>>>
>>>> On Tuesday, 28 January 2014 10:51:31 UTC-5, szimszon wrote:
>>>>>
>>>>> Sorry, mail.error :-o my bad.
>>>>>
>>>>> 2014. január 28., kedd 14:35:55 UTC+1 időpontban horridohobbyist a 
>>>>> következőt írta:
>>>>>>
>>>>>> AttributeError: 'Mail' object has no attribute 'err'
>>>>>>
>>>>>>
>>>>>> On Tuesday, 28 January 2014 08:25:43 UTC-5, szimszon wrote:
>>>>>>>
>>>>>>> Could you please print mail.err after the failed send?
>>>>>>>
>>>>>>> 2014. január 28., kedd 14:22:59 UTC+1 időpontban horridohobbyist a 
>>>>>>> következőt írta:
>>>>>>>>
>>>>>>>> As per the web2py book, I've installed python-pyme and created the 
>>>>>>>> key files (for sender 'my_h...@gmail.com'). I have the following 
>>>>>>>> code:
>>>>>>>>
>>>>>>>> mail = Mail('smtp.gmail.com:587','my_han...@gmail.com
>>>>>>>> ','my_handle:my_password')
>>>>>>>> mail.settings.gpg_home = '/home/www-data/.gnupg/'
>>>>>>>> mail.settings.cipher_type = 'gpg'
>>>>>>>> mail.settings.sign = True
>>>>>>>> mail.settings.sign_passphrase = 'my_passphrase'
>>>>>>>> mail.settings.encrypt = True
>>>>>>>> status = mail.send('some_...@gmail.com','some 
>>>>>>>> subject','some text')
>>>>>>>>
>>>>>>>> The mail.send() is failing. What's wrong?
>>>>>>>>
>>>>>>>> Thanks.
>>>>>>>>
>>>>>>>

-- 
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
--- 
You received this message because you are subscribed to the Google Groups 
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

[web2py] Re: Email and PGP

[szimszon]

If you list your private keys is there a key for 'my_han...@gmail.com'?

(gpg --list-secret-keys)

And yes you need to have receiver's public key before you could send 
encrypted messages to him/her.

2014. január 28., kedd 22:27:44 UTC+1 időpontban horridohobbyist a 
következőt írta:
>
> GnuPG seems to be intimately tied to the user account on Linux. It always, 
> always expects .gnupg to be in /home/richard/. I can't seem to give it an 
> alternate location.
>
> Thinking that it might be a file ownership problem, I chown'd .gnupg and 
> everything in it to www-data:www-data, but this gave me the mail.error "GPG 
> error:Invocation of gpgme_op_sign:Unspecified source:General error".
>
> I chown'd everything back to richard:richard, and I got the mail.error "No 
> key for signing [my_h...@gmail.com ]". So I lose either way!
>
> It's probably not a file ownership problem. I am totally baffled by this. 
> Is PGP Email in web2py broken? Has anyone used it successfully recently??
>
> Another question I have is:  Must I have the public key for the receiver 
> of my encrypted email before I can send? I'm grasping at straws, I know.
>
> Thanks.
>
>
> On Tuesday, 28 January 2014 13:53:02 UTC-5, horridohobbyist wrote:
>>
>> The error message is "No key for signing [my_h...@gmail.com 
>> ]".
>>
>> I did create the key files with gpg for sender 
>> "my_h...@gmail.com". 
>> By default, they're created in my home directory, so I moved the .gnupg 
>> folder to /home/www-data/ and chown'd it and its contents to 
>> "www-data:www-data".
>>
>> I don't know if there are any other steps besides the above. I used the 
>> same sender email and passphrase in creating the keys. So everything should 
>> be okay.
>>
>> Thanks.
>>
>> On Tuesday, 28 January 2014 10:51:31 UTC-5, szimszon wrote:
>>>
>>> Sorry, mail.error :-o my bad.
>>>
>>> 2014. január 28., kedd 14:35:55 UTC+1 időpontban horridohobbyist a 
>>> következőt írta:
>>>>
>>>> AttributeError: 'Mail' object has no attribute 'err'
>>>>
>>>>
>>>> On Tuesday, 28 January 2014 08:25:43 UTC-5, szimszon wrote:
>>>>>
>>>>> Could you please print mail.err after the failed send?
>>>>>
>>>>> 2014. január 28., kedd 14:22:59 UTC+1 időpontban horridohobbyist a 
>>>>> következőt írta:
>>>>>>
>>>>>> As per the web2py book, I've installed python-pyme and created the 
>>>>>> key files (for sender 'my_h...@gmail.com'). I have the following 
>>>>>> code:
>>>>>>
>>>>>> mail = Mail('smtp.gmail.com:587','my_han...@gmail.com
>>>>>> ','my_handle:my_password')
>>>>>> mail.settings.gpg_home = '/home/www-data/.gnupg/'
>>>>>> mail.settings.cipher_type = 'gpg'
>>>>>> mail.settings.sign = True
>>>>>> mail.settings.sign_passphrase = 'my_passphrase'
>>>>>> mail.settings.encrypt = True
>>>>>> status = mail.send('some_...@gmail.com','some subject','some 
>>>>>> text')
>>>>>>
>>>>>> The mail.send() is failing. What's wrong?
>>>>>>
>>>>>> Thanks.
>>>>>>
>>>>>

-- 
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
--- 
You received this message because you are subscribed to the Google Groups 
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

[web2py] Re: Email and PGP

[szimszon]

Sorry, mail.error :-o my bad.

2014. január 28., kedd 14:35:55 UTC+1 időpontban horridohobbyist a 
következőt írta:
>
> AttributeError: 'Mail' object has no attribute 'err'
>
>
> On Tuesday, 28 January 2014 08:25:43 UTC-5, szimszon wrote:
>>
>> Could you please print mail.err after the failed send?
>>
>> 2014. január 28., kedd 14:22:59 UTC+1 időpontban horridohobbyist a 
>> következőt írta:
>>>
>>> As per the web2py book, I've installed python-pyme and created the key 
>>> files (for sender 'my_h...@gmail.com'). I have the following code:
>>>
>>> mail = Mail('smtp.gmail.com:587','my_han...@gmail.com
>>> ','my_handle:my_password')
>>> mail.settings.gpg_home = '/home/www-data/.gnupg/'
>>> mail.settings.cipher_type = 'gpg'
>>> mail.settings.sign = True
>>> mail.settings.sign_passphrase = 'my_passphrase'
>>> mail.settings.encrypt = True
>>> status = mail.send('some_...@gmail.com','some subject','some 
>>> text')
>>>
>>> The mail.send() is failing. What's wrong?
>>>
>>> Thanks.
>>>
>>

-- 
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
--- 
You received this message because you are subscribed to the Google Groups 
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

[web2py] Re: Email and PGP

[szimszon]

Could you please print mail.err after the failed send?

2014. január 28., kedd 14:22:59 UTC+1 időpontban horridohobbyist a 
következőt írta:
>
> As per the web2py book, I've installed python-pyme and created the key 
> files (for sender 'my_h...@gmail.com '). I have the 
> following code:
>
> mail = Mail('smtp.gmail.com:587','my_han...@gmail.com
> ','my_handle:my_password')
> mail.settings.gpg_home = '/home/www-data/.gnupg/'
> mail.settings.cipher_type = 'gpg'
> mail.settings.sign = True
> mail.settings.sign_passphrase = 'my_passphrase'
> mail.settings.encrypt = True
> status = mail.send('some_...@gmail.com ','some 
> subject','some text')
>
> The mail.send() is failing. What's wrong?
>
> Thanks.
>

-- 
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
--- 
You received this message because you are subscribed to the Google Groups 
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

[web2py] Re: Important New Year News: Edison Award

[szimszon]

Good luck! :) Hajrá!

2014. január 19., vasárnap 22:49:04 UTC+1 időpontban step a következőt írta:
>
> Yes! Good luck Massimo and web2py, go go go
>
> On Saturday, January 4, 2014 5:08:38 AM UTC+1, Massimo Di Pierro wrote:
>>
>> Web2py/me have been nominated for the Edison Award. Please wish web2py 
>> (and me) good luck. :-)
>>
>>

-- 
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
--- 
You received this message because you are subscribed to the Google Groups 
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

[web2py] Re: request.user_agent().is_mobile

[szimszon]

I had that with 2.7.x too. I changed all my app to 
user_agent()['is_mobile'] :-o

2013. november 28., csütörtök 20:55:14 UTC+1 időpontban mr.freeze a 
következőt írta:
>
> Did request.user_agent() change from a Storage object to dict? 
> request.user_agent().is_mobile is throwing errors for me on the latest bits 
> (2.8.2):
> AttributeError: 'dict' object has no attribute 'is_mobile'. 
> Happy Thanksgiving!
>

-- 
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
--- 
You received this message because you are subscribed to the Google Groups 
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

[web2py] Re: disk cache problem

[szimszon]

In 2.8.1 I still have a problem.

Now another one too:

Ticket ID 
192.168.7.29.2013-11-28.11-31-21.11f4e653-5c83-4b57-8615-c88eba04fffd 
__len__() should return >= 0 Version web2py(tm) Version 
2.8.1-stable+timestamp.2013.11.27.13.52.50 Traceback 
Traceback (most recent call last):
File "/home/gyszabolcs/fejlesztes/web2py/gluon/restricted.py", line 217, in 
restricted
exec ccode in environment
File 
"/home/gyszabolcs/fejlesztes/web2py/applications/eszkoz/controllers/autocomplete.py"
 
(https://w2p-dev.primerate.lan/admin/default/edit/eszkoz/controllers/autocomplete.py),
 
line 462, in 
File "/home/gyszabolcs/fejlesztes/web2py/gluon/globals.py", line 372, in 
self._caller = lambda f: f()
File "/home/gyszabolcs/fejlesztes/web2py/gluon/tools.py", line 3239, in f
return action(*a, **b)
File 
"/home/gyszabolcs/fejlesztes/web2py/applications/eszkoz/controllers/autocomplete.py"
 
(https://w2p-dev.primerate.lan/admin/default/edit/eszkoz/controllers/autocomplete.py),
 
line 110, in qrcode_strAC
select(db.device.qrcode, distinct=True , cache=(cache.disk, 120))
File "/home/gyszabolcs/fejlesztes/web2py/gluon/dal.py", line 10335, in 
select
return adapter.select(self.query,fields,attributes)
File "/home/gyszabolcs/fejlesztes/web2py/gluon/dal.py", line 1831, in select
return self._select_aux(sql,fields,attributes)
File "/home/gyszabolcs/fejlesztes/web2py/gluon/dal.py", line 1805, in 
_select_aux
rows = cache_model(key,_select_aux2,time_expire)
File "/home/gyszabolcs/fejlesztes/web2py/gluon/cache.py", line 365, in 
__call__
self._close_shelve_and_unlock()
File "/home/gyszabolcs/fejlesztes/web2py/gluon/cache.py", line 255, in 
_close_shelve_and_unlock
if self.storage:
File "/usr/lib/python2.7/shelve.py", line 104, in __len__
return len(self.dict)
ValueError: __len__() should return >= 0

2013. november 27., szerda 10:53:05 UTC+1 időpontban szimszon a következőt 
írta:
>
> Hello!
>
>
> Nobody has problem with disk cache?
>
> 2013. november 26., kedd 9:16:31 UTC+1 időpontban szimszon a következőt 
> írta:
>>
>> http://code.google.com/p/web2py/issues/detail?id=1791&thanks=1791&ts=1385453629
>>
>> I have an app with lot of disk cache usage in selects after 2.7 - don't know 
>> exactly the exact version :( - I got a lot of trouble with it, sometimes the 
>> app just wait and if I try disk. Or if I make a cache.disk.flush() I got 
>> this:
>>
>> Ticket ID
>>
>> 192.168.7.29.2013-11-18.14-42-35.394acb31-76b9-4204-8695-c5f9ee84a87a
>>  (-30988, 'DB_NOTFOUND: No matching key/data 
>> pair found')
>> Version
>> web2py(tm)   Version 2.7.4-stable+timestamp.2013.11.03.22.45.08
>> Traceback
>>
>> Traceback (most recent call last):
>>   File "/usr/local/share/web2py/gluon/restricted.py", line 217, in restricted
>> exec ccode in environment
>>   File "applications/eszkoz/compiled/controllers.bevetel.szamla.py", line 
>> 1090, in 
>>   File "/usr/local/share/web2py/gluon/globals.py", line 372, in 
>> self._caller = lambda f: f()
>>   File "/usr/local/share/web2py/gluon/tools.py", line 3240, in f
>> return action(*a, **b)
>>   File "applications/eszkoz/compiled/controllers.bevetel.szamla.py", line 
>> 415, in szamla
>>   File "/usr/local/share/web2py/gluon/tools.py", line 3948, in create
>> **attributes
>>   File "/usr/local/share/web2py/gluon/tools.py", line 3899, in update
>> callback(onaccept, form, table._tablename)
>>   File "/usr/local/share/web2py/gluon/tools.py", line 76, in callback
>> [action(form) for action in actions]
>>   File "/usr/local/share/web2py/gluon/tools.py", line 3240, in f
>> return action(*a, **b)
>>   File "applications/eszkoz/compiled/controllers.bevetel.szamla.py", line 
>> 65, in send_mail_to_penzugy
>>   File "applications/eszkoz/compiled/controllers.bevetel.szamla.py", line 
>> 52, in flush_cache
>>   File "/usr/local/share/web2py/gluon/cache.py", line 336, in clear
>> storage.clear()
>>   File "/usr/lib/python2.6/UserDict.py", line 124, in clear
>> del self[key]
>>   File "/usr/lib/python2.6/shelve.py", line 136, in __delitem__
>> del self.dict[key]
>>   File "/usr/lib/python2.6/bsddb/__init__.py", line 285, in __delitem__
>> _DeadlockWrap(wrapF)  # del self.db[key]
>>   File "/usr/lib/python2.6/bsddb/dbutils.py", line 68, in DeadlockWrap
>> return function(*_args, **_kwargs)
>>   File "/usr/lib/python2.6/bsddb/__init__.p

[web2py] Re: disk cache problem

[szimszon]

Hello!


Nobody has problem with disk cache?

2013. november 26., kedd 9:16:31 UTC+1 időpontban szimszon a következőt 
írta:
>
> http://code.google.com/p/web2py/issues/detail?id=1791&thanks=1791&ts=1385453629
>
> I have an app with lot of disk cache usage in selects after 2.7 - don't know 
> exactly the exact version :( - I got a lot of trouble with it, sometimes the 
> app just wait and if I try disk. Or if I make a cache.disk.flush() I got this:
>
> Ticket ID
>
> 192.168.7.29.2013-11-18.14-42-35.394acb31-76b9-4204-8695-c5f9ee84a87a
>  (-30988, 'DB_NOTFOUND: No matching key/data 
> pair found')
> Version
> web2py™   Version 2.7.4-stable+timestamp.2013.11.03.22.45.08
> Traceback
>
> Traceback (most recent call last):
>   File "/usr/local/share/web2py/gluon/restricted.py", line 217, in restricted
> exec ccode in environment
>   File "applications/eszkoz/compiled/controllers.bevetel.szamla.py", line 
> 1090, in 
>   File "/usr/local/share/web2py/gluon/globals.py", line 372, in 
> self._caller = lambda f: f()
>   File "/usr/local/share/web2py/gluon/tools.py", line 3240, in f
> return action(*a, **b)
>   File "applications/eszkoz/compiled/controllers.bevetel.szamla.py", line 
> 415, in szamla
>   File "/usr/local/share/web2py/gluon/tools.py", line 3948, in create
> **attributes
>   File "/usr/local/share/web2py/gluon/tools.py", line 3899, in update
> callback(onaccept, form, table._tablename)
>   File "/usr/local/share/web2py/gluon/tools.py", line 76, in callback
> [action(form) for action in actions]
>   File "/usr/local/share/web2py/gluon/tools.py", line 3240, in f
> return action(*a, **b)
>   File "applications/eszkoz/compiled/controllers.bevetel.szamla.py", line 65, 
> in send_mail_to_penzugy
>   File "applications/eszkoz/compiled/controllers.bevetel.szamla.py", line 52, 
> in flush_cache
>   File "/usr/local/share/web2py/gluon/cache.py", line 336, in clear
> storage.clear()
>   File "/usr/lib/python2.6/UserDict.py", line 124, in clear
> del self[key]
>   File "/usr/lib/python2.6/shelve.py", line 136, in __delitem__
> del self.dict[key]
>   File "/usr/lib/python2.6/bsddb/__init__.py", line 285, in __delitem__
> _DeadlockWrap(wrapF)  # del self.db[key]
>   File "/usr/lib/python2.6/bsddb/dbutils.py", line 68, in DeadlockWrap
> return function(*_args, **_kwargs)
>   File "/usr/lib/python2.6/bsddb/__init__.py", line 284, in wrapF
> del self.db[key]
> DBNotFoundError: (-30988, 'DB_NOTFOUND: No matching key/data pair found')
>
> In file: 
> /usr/local/share/web2py/applications/eszkoz/compiled/controllers.bevetel.szamla.pyc
>
>at 0xfbc8b068, file 
> "applications/eszkoz/compiled/controllers.bevetel.szamla.py", line 1>
>
> I need to manually del the content of the cache dir.
>
> The very some app is running good with 2.6.4.
>
> I use apache frontend with wsgi in both case.
>
>

-- 
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
--- 
You received this message because you are subscribed to the Google Groups 
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

[web2py] disk cache problem

[szimszon]

http://code.google.com/p/web2py/issues/detail?id=1791&thanks=1791&ts=1385453629

I have an app with lot of disk cache usage in selects after 2.7 - don't know 
exactly the exact version :( - I got a lot of trouble with it, sometimes the 
app just wait and if I try disk. Or if I make a cache.disk.flush() I got this:

Ticket ID

192.168.7.29.2013-11-18.14-42-35.394acb31-76b9-4204-8695-c5f9ee84a87a
 (-30988, 'DB_NOTFOUND: No matching key/data 
pair found')
Version
web2py™ Version 2.7.4-stable+timestamp.2013.11.03.22.45.08
Traceback

Traceback (most recent call last):
  File "/usr/local/share/web2py/gluon/restricted.py", line 217, in restricted
exec ccode in environment
  File "applications/eszkoz/compiled/controllers.bevetel.szamla.py", line 1090, 
in 
  File "/usr/local/share/web2py/gluon/globals.py", line 372, in 
self._caller = lambda f: f()
  File "/usr/local/share/web2py/gluon/tools.py", line 3240, in f
return action(*a, **b)
  File "applications/eszkoz/compiled/controllers.bevetel.szamla.py", line 415, 
in szamla
  File "/usr/local/share/web2py/gluon/tools.py", line 3948, in create
**attributes
  File "/usr/local/share/web2py/gluon/tools.py", line 3899, in update
callback(onaccept, form, table._tablename)
  File "/usr/local/share/web2py/gluon/tools.py", line 76, in callback
[action(form) for action in actions]
  File "/usr/local/share/web2py/gluon/tools.py", line 3240, in f
return action(*a, **b)
  File "applications/eszkoz/compiled/controllers.bevetel.szamla.py", line 65, 
in send_mail_to_penzugy
  File "applications/eszkoz/compiled/controllers.bevetel.szamla.py", line 52, 
in flush_cache
  File "/usr/local/share/web2py/gluon/cache.py", line 336, in clear
storage.clear()
  File "/usr/lib/python2.6/UserDict.py", line 124, in clear
del self[key]
  File "/usr/lib/python2.6/shelve.py", line 136, in __delitem__
del self.dict[key]
  File "/usr/lib/python2.6/bsddb/__init__.py", line 285, in __delitem__
_DeadlockWrap(wrapF)  # del self.db[key]
  File "/usr/lib/python2.6/bsddb/dbutils.py", line 68, in DeadlockWrap
return function(*_args, **_kwargs)
  File "/usr/lib/python2.6/bsddb/__init__.py", line 284, in wrapF
del self.db[key]
DBNotFoundError: (-30988, 'DB_NOTFOUND: No matching key/data pair found')

In file: 
/usr/local/share/web2py/applications/eszkoz/compiled/controllers.bevetel.szamla.pyc

 at 0xfbc8b068, file 
"applications/eszkoz/compiled/controllers.bevetel.szamla.py", line 1>

I need to manually del the content of the cache dir.

The very some app is running good with 2.6.4.

I use apache frontend with wsgi in both case.

-- 
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
--- 
You received this message because you are subscribed to the Google Groups 
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

Re: [web2py] Re: Some forms need to be submitted multiple times.

[szimszon]

http://code.google.com/p/web2py/issues/detail?id=1688

Thanks.

2013. szeptember 22., vasárnap 19:33:22 UTC+2 időpontban Massimo Di Pierro 
a következőt írta:
>
> Please open a ticket. I have an idea about what to do.
>
> On Sep 22, 2013, at 12:31 PM, szimszon wrote:
>
> Hi!
>
> I have some apps where I usually do multiple things simultaneously or I 
> have to look at some page for information (page with form too) and 
> copy&past to the first. But I have to reload the first page because the 
> single form key. It can be really annoying :( So if it could be change I'm 
> for the change. :-)
>
> 2013. szeptember 22., vasárnap 18:16:57 UTC+2 időpontban Christian Foster 
> Howes a következőt írta:
>>
>> and i don't mind the design at alli can't think of a good reason 
>> that a real user would be in this situation.  i tend to break things 
>> when testing or doing rote admin tasks (with my admin forms not web2py 
>> admin) 
>>
>> cfh 
>>
>>
>> On 9/22/13 9:11 , Massimo Di Pierro wrote: 
>> > That is by design. Perhaps we should change it. The problem is how not 
>> to 
>> > pollute the session with un-used keys. 
>> > 
>> > On Sunday, 22 September 2013 10:53:26 UTC-5, Christian Foster Howes 
>> wrote: 
>> >> 
>> >> i have noticed that if in the same browser i open the same page with 
>> the 
>> >> same form in multiple tabs my stored session data only stores 1 form 
>> key, 
>> >> so the most recently loaded tab will submit the form fine, the others 
>> will 
>> >> be denied until i reload the page.  any chance you have form key 
>> >> duplication?  or are losing the form key somehow? 
>> >> 
>> >> On Saturday, September 21, 2013 7:16:17 AM UTC-7, Ian W. Scott wrote: 
>> >>> 
>> >>> Thanks Niphlod. I submit the form and get back the same form, empty. 
>> It's 
>> >>> as if the submitted data is just dumped and the page reloads as if 
>> nothing 
>> >>> had been sent. 
>> >>> 
>> >>> I'll try the replacement you suggest and get back to you. 
>> >>> 
>> >>> Ian 
>> >>> 
>> >>> On Friday, September 20, 2013 5:12:35 PM UTC-4, Niphlod wrote: 
>> >>>> 
>> >>>> I can't replicate it  but 1st thing to debug: remove that 
>> requires 
>> >>>> and replace with a requires=IS_IN_SET(('America/Toronto')) ... 
>> >>>> 
>> >>>> BTW: "submitting 2 or 3 times" what means exactly? that you put 
>> email 
>> >>>> and password and you hit submit and you get back an error, the same 
>> login 
>> >>>> form, the login form empty,  (fill the blanks :-P) ? 
>> >>>> 
>> >>>> On Friday, September 20, 2013 10:26:39 PM UTC+2, Ian W. Scott wrote: 
>> >>>>> 
>> >>>>> Sorry for the slow response. I'm experiencing this with 2.6.3 but 
>> have 
>> >>>>> also had the problem with the last couple of versions. It has been 
>> the kind 
>> >>>>> of thing that I keep putting off debugging because I'm not sure 
>> where to 
>> >>>>> start. 
>> >>>>> 
>> >>>>> Could it have to do with the way I'm extending the auth_user table? 
>> In 
>> >>>>> my db.py I have 
>> >>>>> 
>> >>>>> auth = Auth(db, hmac_key=Auth.get_or_create_key())  # 
>> >>>>> authent/authorization 
>> >>>>> 
>> >>>>> #adding custom field for user time zone 
>> >>>>> auth.settings.extra_fields['auth_user'] = [ 
>> >>>>>  Field('time_zone', 
>> >>>>>'string', 
>> >>>>>default='America/Toronto', 
>> >>>>>requires=IS_IN_SET((common_timezones)), 
>> >>>>>widget=SQLFORM.widgets.options.widget 
>> >>>>>) 
>> >>>>> ] 
>> >>>>> 
>> >>>>> Although I'm able to use the data from that field without any 
>> trouble. 
>> >>>>> 
>> >>>>> Ian 
>> >>>>> 
>> >>>>> On Wednesday, September 18, 2013 12:41:19 PM UTC-4, Massimo Di 
>> Pierro 
>> >>>>> wrote: 
>> >>>>>> 
>> >>>>>> Which version? 
>> >>>>>> 
>> >>>>>> On Wednesday, 18 September 2013 10:15:46 UTC-5, Ian W. Scott 
>> wrote: 
>> >>>>>>> 
>> >>>>>>> I'm experiencing an odd problem where some of my forms (including 
>> >>>>>>> registration and login forms) need to be submitted 2 or 3 times 
>> before they 
>> >>>>>>> are processed. It's been hard to solve because it doesn't seem 
>> entirely 
>> >>>>>>> consistent. Has anyone run into this, and does anyone have any 
>> idea what 
>> >>>>>>> the cause would be? 
>> >>>>>>> 
>> >>>>>>> Thanks, 
>> >>>>>>> 
>> >>>>>>> Ian 
>> >>>>>>> 
>> >>>>>> 
>> > 
>>
>
>

-- 
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
--- 
You received this message because you are subscribed to the Google Groups 
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

Re: [web2py] Re: Some forms need to be submitted multiple times.

[szimszon]

Hi!

I have some apps where I usually do multiple things simultaneously or I 
have to look at some page for information (page with form too) and 
copy&past to the first. But I have to reload the first page because the 
single form key. It can be really annoying :( So if it could be change I'm 
for the change. :-)

2013. szeptember 22., vasárnap 18:16:57 UTC+2 időpontban Christian Foster 
Howes a következőt írta:
>
> and i don't mind the design at alli can't think of a good reason 
> that a real user would be in this situation.  i tend to break things 
> when testing or doing rote admin tasks (with my admin forms not web2py 
> admin) 
>
> cfh 
>
>
> On 9/22/13 9:11 , Massimo Di Pierro wrote: 
> > That is by design. Perhaps we should change it. The problem is how not 
> to 
> > pollute the session with un-used keys. 
> > 
> > On Sunday, 22 September 2013 10:53:26 UTC-5, Christian Foster Howes 
> wrote: 
> >> 
> >> i have noticed that if in the same browser i open the same page with 
> the 
> >> same form in multiple tabs my stored session data only stores 1 form 
> key, 
> >> so the most recently loaded tab will submit the form fine, the others 
> will 
> >> be denied until i reload the page.  any chance you have form key 
> >> duplication?  or are losing the form key somehow? 
> >> 
> >> On Saturday, September 21, 2013 7:16:17 AM UTC-7, Ian W. Scott wrote: 
> >>> 
> >>> Thanks Niphlod. I submit the form and get back the same form, empty. 
> It's 
> >>> as if the submitted data is just dumped and the page reloads as if 
> nothing 
> >>> had been sent. 
> >>> 
> >>> I'll try the replacement you suggest and get back to you. 
> >>> 
> >>> Ian 
> >>> 
> >>> On Friday, September 20, 2013 5:12:35 PM UTC-4, Niphlod wrote: 
>  
>  I can't replicate it  but 1st thing to debug: remove that 
> requires 
>  and replace with a requires=IS_IN_SET(('America/Toronto')) ... 
>  
>  BTW: "submitting 2 or 3 times" what means exactly? that you put email 
>  and password and you hit submit and you get back an error, the same 
> login 
>  form, the login form empty,  (fill the blanks :-P) ? 
>  
>  On Friday, September 20, 2013 10:26:39 PM UTC+2, Ian W. Scott wrote: 
> > 
> > Sorry for the slow response. I'm experiencing this with 2.6.3 but 
> have 
> > also had the problem with the last couple of versions. It has been 
> the kind 
> > of thing that I keep putting off debugging because I'm not sure 
> where to 
> > start. 
> > 
> > Could it have to do with the way I'm extending the auth_user table? 
> In 
> > my db.py I have 
> > 
> > auth = Auth(db, hmac_key=Auth.get_or_create_key())  # 
> > authent/authorization 
> > 
> > #adding custom field for user time zone 
> > auth.settings.extra_fields['auth_user'] = [ 
> >  Field('time_zone', 
> >'string', 
> >default='America/Toronto', 
> >requires=IS_IN_SET((common_timezones)), 
> >widget=SQLFORM.widgets.options.widget 
> >) 
> > ] 
> > 
> > Although I'm able to use the data from that field without any 
> trouble. 
> > 
> > Ian 
> > 
> > On Wednesday, September 18, 2013 12:41:19 PM UTC-4, Massimo Di 
> Pierro 
> > wrote: 
> >> 
> >> Which version? 
> >> 
> >> On Wednesday, 18 September 2013 10:15:46 UTC-5, Ian W. Scott wrote: 
> >>> 
> >>> I'm experiencing an odd problem where some of my forms (including 
> >>> registration and login forms) need to be submitted 2 or 3 times 
> before they 
> >>> are processed. It's been hard to solve because it doesn't seem 
> entirely 
> >>> consistent. Has anyone run into this, and does anyone have any 
> idea what 
> >>> the cause would be? 
> >>> 
> >>> Thanks, 
> >>> 
> >>> Ian 
> >>> 
> >> 
> > 
>

-- 
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
--- 
You received this message because you are subscribed to the Google Groups 
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

[web2py] Re: Latest Trunk - problem with auth(session) and login using 'remember me'

[szimszon]

Seems to work. Tnx!

2013. augusztus 22., csütörtök 11:36:16 UTC+2 időpontban Massimo Di Pierro 
a következőt írta:
>
> Please try again. Thanks for checking this.
>
> On Thursday, 22 August 2013 03:29:03 UTC-5, szimszon wrote:
>>
>> Hi!
>>
>> It's still broken for me.
>>
>> googlecode 7a1ff6228799
>>
>> I have a session in db. If I didn't check the Remember me than I get 
>>
>> Traceback (most recent call last): 
>>   File "/home/gyszabolcs/fejlesztes/web2py/gluon/restricted.py", line 
>> 217, in restricted 
>> exec ccode in environment 
>>   File 
>> "/home/gyszabolcs/fejlesztes/web2py/applications/web2print/controllers/default.py",
>>  
>> line 134, in  
>>   File "/home/gyszabolcs/fejlesztes/web2py/gluon/globals.py", line 358, 
>> in  
>> self._caller = lambda f: f() 
>>   File 
>> "/home/gyszabolcs/fejlesztes/web2py/applications/web2print/controllers/default.py",
>>  
>> line 17, in user 
>> return dict(form=auth()) 
>>   File "/home/gyszabolcs/fejlesztes/web2py/gluon/tools.py", line 1293, in 
>> __call__ 
>> return getattr(self, args[0])() 
>>   File "/home/gyszabolcs/fejlesztes/web2py/gluon/tools.py", line 2249, in 
>> login 
>> self.login_user(user) 
>>   File "/home/gyszabolcs/fejlesztes/web2py/gluon/tools.py", line 1871, in 
>> login_user 
>> current.session.renew(clear_session=not 
>> self.settings.keep_session_onlogin) 
>>   File "/home/gyszabolcs/fejlesztes/web2py/gluon/globals.py", line 889, 
>> in renew 
>> rows = db(table.id==record_id)(table.unique_key==unique_key)\ 
>> NameError: global name 'db' is not defined 
>>
>> In a model:
>>
>> db = DAL(settings.database_uri, pool_size=2)
>> session.connect(request, response, db=db)
>>
>> 2013. augusztus 22., csütörtök 9:37:22 UTC+2 időpontban Massimo Di Pierro 
>> a következőt írta:
>>>
>>> I think it is solved in trunk (committed to googlecode only, github is 
>>> down today).
>>>
>>> On Thursday, 22 August 2013 02:16:20 UTC-5, David Marko wrote:
>>>>
>>>> I know there are some changes in session internals in trunk, so just 
>>>> reporting an issue I observed. When I login using 'Remember me' checked, 
>>>> I'm getting this error below. Without 'remember me' its working just fine. 
>>>> I tried to remove all session files but still the same consistent 
>>>> behaviour 
>>>> ...
>>>>
>>>> Traceback
>>>>
>>>> 1.
>>>> 2.
>>>> 3.
>>>> 4.
>>>> 5.
>>>> 6.
>>>> 7.
>>>> 8.
>>>> 9.
>>>>
>>>> Traceback (most recent call last):
>>>>   File "C:\java\web2py\gluon\restricted.py", line 217, in restricted
>>>> exec ccode in environment
>>>>   File "C:/java/web2py/applications/gapps/models/03_db.py" 
>>>> <http://web2py2.tcl-digitrade.com/admin/default/edit/gapps/models/03_db.py>,
>>>>  line 49, in 
>>>> auth = Auth(db)
>>>>   File "C:\java\web2py\gluon\tools.py", line 1229, in __init__
>>>> auth.expiration
>>>> KeyError: 'session_id_gapps'
>>>>
>>>> Error snapshot [image: 
>>>> help]<http://web2py2.tcl-digitrade.com/admin/default/ticket/gapps/127.0.0.1.2013-08-22.09-11-58.ff9c728c-27f4-4f34-bddc-23c433cef9fe#>
>>>>
>>>> ('session_id_gapps')
>>>>
>>>> inspect attributes
>>>> Frames
>>>>
>>>>- 
>>>>
>>>>*File C:\java\web2py\gluon\restricted.py in restricted at line 217* 
>>>>code arguments variables
>>>>- 
>>>>
>>>>*File C:\java\web2py\applications\gapps\models\03_db.py in  
>>>>at line 49* code arguments variables
>>>>- 
>>>>
>>>>*File C:\java\web2py\gluon\tools.py in __init__ at line 1229* code 
>>>>arguments variables
>>>>Function argument list
>>>>
>>>>(self=, environment=>>>uri="sqlite://storage.sqlite">, db=, 
>>>>mailer=True, hmac_key=None, controller='default', function='user', 
>>>>cas_provider=None, signature=True, secure=False)
>>>>Code listing
>>>>
>>>>1224.
>>>>1225.
>>>>1226.
>>>>1227.
>>>>1228.
>>>>1229.
>>>>
>>>>1230.
>>>>1231.
>>>>1232.
>>>>1233.
>>>>
>>>># for "remember me" option
>>>>response = current.response
>>>>if auth and auth.remember:
>>>># when user wants to be logged in for longer
>>>>response.cookies[response.session_id_name]["expires"] = \
>>>>auth.expiration
>>>>
>>>>if signature:
>>>>self.define_signature()
>>>>else:
>>>>self.signature = None
>>>>
>>>>
>>>>

-- 

--- 
You received this message because you are subscribed to the Google Groups 
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

[web2py] Re: Latest Trunk - problem with auth(session) and login using 'remember me'

[szimszon]

The last googlecode eec36566d1ac partially works for me. The Remember me 
works but I have still the "NameError: global name 'db' is not defined " as 
seen below. It's if there is a session to renew...

In tools.py 1870 line... (new session logic)

current*.*session*.*renew*(*clear_session*=not self.*settings*.*
keep_session_onlogin*)*



2013. augusztus 22., csütörtök 10:29:03 UTC+2 időpontban szimszon a 
következőt írta:
>
> Hi!
>
> It's still broken for me.
>
> googlecode 7a1ff6228799
>
> I have a session in db. If I didn't check the Remember me than I get 
>
> Traceback (most recent call last): 
>   File "/home/gyszabolcs/fejlesztes/web2py/gluon/restricted.py", line 217, 
> in restricted 
> exec ccode in environment 
>   File 
> "/home/gyszabolcs/fejlesztes/web2py/applications/web2print/controllers/default.py",
>  
> line 134, in  
>   File "/home/gyszabolcs/fejlesztes/web2py/gluon/globals.py", line 358, in 
>  
> self._caller = lambda f: f() 
>   File 
> "/home/gyszabolcs/fejlesztes/web2py/applications/web2print/controllers/default.py",
>  
> line 17, in user 
> return dict(form=auth()) 
>   File "/home/gyszabolcs/fejlesztes/web2py/gluon/tools.py", line 1293, in 
> __call__ 
> return getattr(self, args[0])() 
>   File "/home/gyszabolcs/fejlesztes/web2py/gluon/tools.py", line 2249, in 
> login 
> self.login_user(user) 
>   File "/home/gyszabolcs/fejlesztes/web2py/gluon/tools.py", line 1871, in 
> login_user 
> current.session.renew(clear_session=not 
> self.settings.keep_session_onlogin) 
>   File "/home/gyszabolcs/fejlesztes/web2py/gluon/globals.py", line 889, in 
> renew 
> rows = db(table.id==record_id)(table.unique_key==unique_key)\ 
> NameError: global name 'db' is not defined 
>
> In a model:
>
> db = DAL(settings.database_uri, pool_size=2)
> session.connect(request, response, db=db)
>
> 2013. augusztus 22., csütörtök 9:37:22 UTC+2 időpontban Massimo Di Pierro 
> a következőt írta:
>>
>> I think it is solved in trunk (committed to googlecode only, github is 
>> down today).
>>
>> On Thursday, 22 August 2013 02:16:20 UTC-5, David Marko wrote:
>>>
>>> I know there are some changes in session internals in trunk, so just 
>>> reporting an issue I observed. When I login using 'Remember me' checked, 
>>> I'm getting this error below. Without 'remember me' its working just fine. 
>>> I tried to remove all session files but still the same consistent behaviour 
>>> ...
>>>
>>> Traceback
>>>
>>> 1.
>>> 2.
>>> 3.
>>> 4.
>>> 5.
>>> 6.
>>> 7.
>>> 8.
>>> 9.
>>>
>>> Traceback (most recent call last):
>>>   File "C:\java\web2py\gluon\restricted.py", line 217, in restricted
>>> exec ccode in environment
>>>   File "C:/java/web2py/applications/gapps/models/03_db.py" 
>>> <http://web2py2.tcl-digitrade.com/admin/default/edit/gapps/models/03_db.py>,
>>>  line 49, in 
>>> auth = Auth(db)
>>>   File "C:\java\web2py\gluon\tools.py", line 1229, in __init__
>>> auth.expiration
>>> KeyError: 'session_id_gapps'
>>>
>>> Error snapshot [image: 
>>> help]<http://web2py2.tcl-digitrade.com/admin/default/ticket/gapps/127.0.0.1.2013-08-22.09-11-58.ff9c728c-27f4-4f34-bddc-23c433cef9fe#>
>>>
>>> ('session_id_gapps')
>>>
>>> inspect attributes
>>> Frames
>>>
>>>- 
>>>
>>>*File C:\java\web2py\gluon\restricted.py in restricted at line 217* 
>>>code arguments variables
>>>- 
>>>
>>>*File C:\java\web2py\applications\gapps\models\03_db.py in  
>>>at line 49* code arguments variables
>>>- 
>>>
>>>*File C:\java\web2py\gluon\tools.py in __init__ at line 1229* code 
>>>arguments variables
>>>Function argument list
>>>
>>>(self=, environment=>>uri="sqlite://storage.sqlite">, db=, 
>>>mailer=True, hmac_key=None, controller='default', function='user', 
>>>cas_provider=None, signature=True, secure=False)
>>>Code listing
>>>
>>>1224.
>>>1225.
>>>1226.
>>>1227.
>>>1228.
>>>1229.
>>>
>>>1230.
>>>1231.
>>>1232.
>>>1233.
>>>
>>># for "remember me" option
>>>response = current.response
>>>if auth and auth.remember:
>>># when user wants to be logged in for longer
>>>response.cookies[response.session_id_name]["expires"] = \
>>>auth.expiration
>>>
>>>if signature:
>>>self.define_signature()
>>>else:
>>>self.signature = None
>>>
>>>
>>>

-- 

--- 
You received this message because you are subscribed to the Google Groups 
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

[web2py] Re: Latest Trunk - problem with auth(session) and login using 'remember me'

[szimszon]

Hi!

It's still broken for me.

googlecode 7a1ff6228799

I have a session in db. If I didn't check the Remember me than I get 

Traceback (most recent call last): 
  File "/home/gyszabolcs/fejlesztes/web2py/gluon/restricted.py", line 217, 
in restricted 
exec ccode in environment 
  File 
"/home/gyszabolcs/fejlesztes/web2py/applications/web2print/controllers/default.py",
 
line 134, in  
  File "/home/gyszabolcs/fejlesztes/web2py/gluon/globals.py", line 358, in 
 
self._caller = lambda f: f() 
  File 
"/home/gyszabolcs/fejlesztes/web2py/applications/web2print/controllers/default.py",
 
line 17, in user 
return dict(form=auth()) 
  File "/home/gyszabolcs/fejlesztes/web2py/gluon/tools.py", line 1293, in 
__call__ 
return getattr(self, args[0])() 
  File "/home/gyszabolcs/fejlesztes/web2py/gluon/tools.py", line 2249, in 
login 
self.login_user(user) 
  File "/home/gyszabolcs/fejlesztes/web2py/gluon/tools.py", line 1871, in 
login_user 
current.session.renew(clear_session=not 
self.settings.keep_session_onlogin) 
  File "/home/gyszabolcs/fejlesztes/web2py/gluon/globals.py", line 889, in 
renew 
rows = db(table.id==record_id)(table.unique_key==unique_key)\ 
NameError: global name 'db' is not defined 

In a model:

db = DAL(settings.database_uri, pool_size=2)
session.connect(request, response, db=db)

2013. augusztus 22., csütörtök 9:37:22 UTC+2 időpontban Massimo Di Pierro a 
következőt írta:
>
> I think it is solved in trunk (committed to googlecode only, github is 
> down today).
>
> On Thursday, 22 August 2013 02:16:20 UTC-5, David Marko wrote:
>>
>> I know there are some changes in session internals in trunk, so just 
>> reporting an issue I observed. When I login using 'Remember me' checked, 
>> I'm getting this error below. Without 'remember me' its working just fine. 
>> I tried to remove all session files but still the same consistent behaviour 
>> ...
>>
>> Traceback
>>
>> 1.
>> 2.
>> 3.
>> 4.
>> 5.
>> 6.
>> 7.
>> 8.
>> 9.
>>
>> Traceback (most recent call last):
>>   File "C:\java\web2py\gluon\restricted.py", line 217, in restricted
>> exec ccode in environment
>>   File "C:/java/web2py/applications/gapps/models/03_db.py" 
>> , 
>> line 49, in 
>> auth = Auth(db)
>>   File "C:\java\web2py\gluon\tools.py", line 1229, in __init__
>> auth.expiration
>> KeyError: 'session_id_gapps'
>>
>> Error snapshot [image: 
>> help]
>>
>> ('session_id_gapps')
>>
>> inspect attributes
>> Frames
>>
>>- 
>>
>>*File C:\java\web2py\gluon\restricted.py in restricted at line 217* 
>>code arguments variables
>>- 
>>
>>*File C:\java\web2py\applications\gapps\models\03_db.py in  
>>at line 49* code arguments variables
>>- 
>>
>>*File C:\java\web2py\gluon\tools.py in __init__ at line 1229* code 
>>arguments variables
>>Function argument list
>>
>>(self=, environment=>uri="sqlite://storage.sqlite">, db=, 
>>mailer=True, hmac_key=None, controller='default', function='user', 
>>cas_provider=None, signature=True, secure=False)
>>Code listing
>>
>>1224.
>>1225.
>>1226.
>>1227.
>>1228.
>>1229.
>>
>>1230.
>>1231.
>>1232.
>>1233.
>>
>># for "remember me" option
>>response = current.response
>>if auth and auth.remember:
>># when user wants to be logged in for longer
>>response.cookies[response.session_id_name]["expires"] = \
>>auth.expiration
>>
>>if signature:
>>self.define_signature()
>>else:
>>self.signature = None
>>
>>
>>

-- 

--- 
You received this message because you are subscribed to the Google Groups 
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

Re: [web2py][LDAP] once authenticated with LDAP I got "No fields to update"

[szimszon]

Could you try setting the logging_level to debug?

from gluon.contrib.login_methods.ldap_auth import ldap_auth
auth.settings.login_methods.append(ldap_auth(mode='ad', 
   bind_dn='userName', bind_pw='passWord', manage_groups=False,
   server='serverName',
   base_dn='ou=OU,ou=OU,dc=DC,dc=DC',
   logging_level='debug'))

And see if you get some messages and post it back?

2013. augusztus 1., csütörtök 23:25:18 UTC+2 időpontban Richard a 
következőt írta:
>
> Hello,
>
> I am trying to implement LDAP authentication right now and I am falling on 
> issue "No fields to update". As far as I know the authencation is working 
> since I only start to have this issue once the it happen something else 
> then have the same login blank form again and again.
>
> So, I think I have proper LDAP setting...
>
> from gluon.contrib.login_methods.ldap_auth import ldap_auth
> auth.settings.login_methods.append(ldap_auth(mode='ad', 
>bind_dn='userName', bind_pw='passWord', manage_groups=False,
>server='serverName',
>base_dn='ou=OU,ou=OU,dc=DC,dc=DC'))
>
> I try set manage_groups=False because I found some pretty old thread 
> talking about issue... But notting better. 
>
> I also set explicitly a redirect on login :
>
> auth.settings.login_next = URL(c='default', f='index')
>
> What's happen once authentication success? Does AD try to update auth_user 
> data somehow? Or Does web2py is waiting for update data that don't arrive 
> cause of my configuration of LDAP, so I should tell web2py to not try 
> update anything?
>
> Thanks
>
> PS.: "ldap" tag could be good
>
> Richard
>

-- 

--- 
You received this message because you are subscribed to the Google Groups 
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

[web2py] Re: Encrypting/decrypting db values

[szimszon]

+1

2013. június 25., kedd 22:23:32 UTC+2 időpontban Massimo Di Pierro a 
következőt írta:
>
> Should we include decrypt(key,data) and encrypt(key,data) in gluon.utils?
>
> On Tuesday, 25 June 2013 13:42:29 UTC-5, Niphlod wrote:
>>
>> sorry, cut&paste error.
>>
>>
>>
>> import gluon.contrib.aes as AES
>> import threading 
>> import os
>> import base64
>>
>> def fast_urandom16(urandom=[], locker=threading.RLock()):
>> """
>> this is 4x faster than calling os.urandom(16) and prevents
>> the "too many files open" issue with concurrent access to 
>> os.urandom()
>> """
>> try:
>> return urandom.pop()
>> except IndexError:
>> try:
>> locker.acquire()
>> ur = os.urandom(16 * 1024)
>> urandom += [ur[i:i + 16] for i in xrange(16, 1024 * 16, 16)]
>> return ur[0:16]
>> finally:
>> locker.release()
>> 
>> def pad(s, n=32, padchar=' '):
>> return s + (32 - len(s) % 32) * padchar
>>
>> def AES_new(key, IV=None):
>> """ Returns an AES cipher object and random IV if None specified """
>> if IV is None:
>> IV = fast_urandom16()
>>
>> return AES.new(key, AES.MODE_CBC, IV), IV
>>
>> def w2p_encrypt(data):
>> key = 'asdsaddasdasdas'
>> key = pad(key[:32])
>> cipher, IV = AES_new(key)
>> encrypted_data = IV + cipher.encrypt(pad(data))
>> return base64.urlsafe_b64encode(encrypted_data)
>>
>> def w2p_decrypt(data):
>> key = 'asdsaddasdasdas'
>> key = pad(key[:32])
>> data = base64.urlsafe_b64decode(data)
>> IV, data = data[:16], data[16:]
>> cipher, _ = AES_new(key, IV=IV)
>> data = cipher.decrypt(data)
>> data = data.rstrip(' ')
>> return data
>>
>> db.define_table('t_test',
>> Field('f_field')
>> )
>>
>> db.t_test.f_field.filter_in = lambda value : w2p_encrypt(value)
>> db.t_test.f_field.filter_out = lambda value : w2p_decrypt(value)
>>
>>
>>

-- 

--- 
You received this message because you are subscribed to the Google Groups 
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

[web2py] Re: AD LDAP manage_user problem

[szimszon]

It's like you do not have a "db" DAL object.

Where is your db connection settings?

2013. június 3., hétfő 23:22:30 UTC+2 időpontban mrendon a következőt írta:
>
> Thanks! Is this it?
>
> Traceback (most recent call last):
>  File "/home/www-data/web2py/gluon/restricted.py", line 212, in restricted
>  exec ccode in environment
>  File 
> "/home/www-data/web2py/applications/alcolholedu/controllers/default.py", line 
> 14, in 
>  File "/home/www-data/web2py/gluon/globals.py", line 194, in 
>  self._caller = lambda f: f()
>  File 
> "/home/www-data/web2py/applications/alcolholedu/controllers/default.py", line 
> 3, in user
>  def user(): return dict(form=auth())
>  File "/home/www-data/web2py/gluon/tools.py", line 1285, in __call__
>  return getattr(self, args[0])()
>  File "/home/www-data/web2py/gluon/tools.py", line 2143, in login
>  request.vars[passfield]):
>  File "/home/www-data/web2py/gluon/contrib/login_methods/ldap_auth.py", line 
> 421, in ldap_auth_aux
>  user_in_db = db(db.auth_user.email == username)
> AttributeError: 'NoneType' object has no attribute 'auth_user'
>
>
> On Monday, June 3, 2013 3:08:29 PM UTC-6, Derek wrote:
>>
>> We need to see the whole traceback.
>>
>> On Monday, June 3, 2013 9:21:51 AM UTC-7, mrendon wrote:
>>>
>>> Hi. I'm trying to get email address and name attributes imported into my 
>>> database. I'm using Active Directory and version web2py 
>>> 2.4.7-stable+timestamp.2013.05.24.17.48.47. 
>>> I think I've followed the instructions in the ldap_auth.py file under 
>>> gluon/contrib/login_methods.
>>>
>>>
>>> Relevant part of db.py:
>>>
>>> ## create all tables needed by auth if not custom tables
>>> auth.define_tables(username=True)
>>> auth.settings.create_user_groups=False
>>>
>>> ## configure auth policy
>>> auth.settings.registration_requires_verification = False
>>> auth.settings.registration_requires_approval = False
>>> auth.settings.reset_password_requires_verification = True
>>>
>>>
>>> # all we need is login
>>> auth.settings.actions_disabled=['register','change_password',
>>> 'request_reset_password','retrieve_username','profile']
>>>
>>>
>>> # you don't have to remember me
>>> auth.settings.remember_me_form = False
>>>
>>>
>>> from gluon.contrib.login_methods.ldap_auth import ldap_auth
>>> auth.settings.login_methods.append(ldap_auth(mode='ad',
>>>server='xxx..xxx',
>>>base_dn='OU=,DC=,DC=xx',
>>>bind_dn='CN=xxx,CN=x,DC=xx,DC=x',
>>>bind_pw='xx',
>>>manage_user=True,
>>>user_firstname_attrib='cn:1',
>>>user_lastname_attrib='cn:2',
>>>user_mail_attrib='mail'
>>>))
>>>
>>>
>>> I'm able to login without manage_user=True. But when I try to use it I 
>>> get the following error:
>>>  
>>> ('NoneType' object has no attribute 
>>> 'auth_user')
>>>
>>> Any ideas?
>>>
>>>

-- 

--- 
You received this message because you are subscribed to the Google Groups 
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

[web2py] Using a recursive select but encountered a broken reference (versioning and auth.signature)

[szimszon]

Hi All!

I wonder if somebody could help me. I use record versioning with 
auth.signature but if I delete (is_active=False) the parent row than I got 
a "Using a recursive select but encountered a broken reference" ticket 
issued when I try to access the child...

I opened a ticket about it: 
http://code.google.com/p/web2py/issues/detail?id=1419 with a video and test 
app. I think if I delete the parent row than the child's is_active should 
be set to False too. That is the case if I don't use auth.signature 
anyway...  child row get deleted if I delete parent.

-- 

--- 
You received this message because you are subscribed to the Google Groups 
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

Re: [web2py] Re: scheduler sincronization

[szimszon]

My bad. Never looked closely :(

Than my guess is that the scheduler is exec the task at some point after 
the next run time and the actual running time is a base of the next run 
time not the original (first) intended run time.

2013. március 25., hétfő 16:42:04 UTC+1 időpontban Paolo valleri a 
következőt írta:
>
> Accordingly to the book 
> http://web2py.com/books/default/chapter/29/04?search=scheduler#Scheduler-(experimental)
> It doesn't start when the previous task ends but when the previous task 
> starts instead.
>
>  Paolo
>
>
> 2013/3/25 szimszon >
>
>> I think the period starts as the last execution ends.
>>
>> Sometimes I miss the feature to start the task exactly at fixed interval 
>> rater than fixed interval starting after the last run ends but I can live 
>> without it. :) It's a great tool anyway :-D
>>
>> 2013. március 25., hétfő 16:23:56 UTC+1 időpontban Paolo valleri a 
>> következőt írta:
>>
>>> Dear all, 
>>> I started to use scheduler. I've created a simple starting example task: 
>>> https://github.com/ilvalle/**scapp/blob/master/models/**scheduler.py<https://github.com/ilvalle/scapp/blob/master/models/scheduler.py>
>>> and with the great niphlod's plugin cs_monitor_plugin I created an 
>>> initial repetitive task.
>>> However, although I set repeats: 0 and period: 300, tasks are not 
>>> repeated as expected exactly every 300s. The first five tasks were executed 
>>> at:
>>> 2013-03-25 15:34:43
>>> 2013-03-25 15:40:48
>>> 2013-03-25 15:46:52
>>> 2013-03-25 15:52:08
>>> 2013-03-25 15:57:22
>>> The time between two consecutive execution is not so straightforward. 
>>> what am I missing? Is there a way to impose more accuracy ?
>>>
>>> paolo
>>>
>>  -- 
>>  
>> --- 
>> You received this message because you are subscribed to a topic in the 
>> Google Groups "web2py-users" group.
>> To unsubscribe from this topic, visit 
>> https://groups.google.com/d/topic/web2py/u_PgzKLuQmw/unsubscribe?hl=en.
>> To unsubscribe from this group and all its topics, send an email to 
>> web2py+un...@googlegroups.com .
>> For more options, visit https://groups.google.com/groups/opt_out.
>>  
>>  
>>
>
>

-- 

--- 
You received this message because you are subscribed to the Google Groups 
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

[web2py] Re: scheduler sincronization

[szimszon]

I think the period starts as the last execution ends.

Sometimes I miss the feature to start the task exactly at fixed interval 
rater than fixed interval starting after the last run ends but I can live 
without it. :) It's a great tool anyway :-D

2013. március 25., hétfő 16:23:56 UTC+1 időpontban Paolo valleri a 
következőt írta:
>
> Dear all, 
> I started to use scheduler. I've created a simple starting example task: 
> https://github.com/ilvalle/scapp/blob/master/models/scheduler.py
> and with the great niphlod's plugin cs_monitor_plugin I created an initial 
> repetitive task.
> However, although I set repeats: 0 and period: 300, tasks are not repeated 
> as expected exactly every 300s. The first five tasks were executed at:
> 2013-03-25 15:34:43
> 2013-03-25 15:40:48
> 2013-03-25 15:46:52
> 2013-03-25 15:52:08
> 2013-03-25 15:57:22
> The time between two consecutive execution is not so straightforward. what 
> am I missing? Is there a way to impose more accuracy ?
>
> paolo
>

-- 

--- 
You received this message because you are subscribed to the Google Groups 
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

[web2py] Re: I got a fancy wiki problem. All user end up in rw mode :(

[szimszon]

Okay. :)

2013. március 11., hétfő 20:22:11 UTC+1 időpontban Alan Etkin a következőt 
írta:
>
> > Is it relevant where is logged into the application?
>
> It seems it is, since when the admininstrator session is expired, the wiki 
> access control returns to normal behavior (it requires access rights for 
> read and create wikis).
>

-- 

--- 
You received this message because you are subscribed to the Google Groups 
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

[web2py] Re: I got a fancy wiki problem. All user end up in rw mode :(

[szimszon]

What do you mean when you say logged into admin? Is someone logged into 
web2py admin interface? Is it relevant where is logged into the 
application? Because the admin interface has only a password for login. If 
it is relevant than it would be good the have some feedback in admin which 
user is logged in with the admin password. Display the name in menu or 
something... could be good.

As for your question. It could be that I was logged into web2py's admin 
with the new user. So I missed that part. But it's a bit confusing anyway 
that the admin interface assign group membership in an app :-o

The book say:
 If you are logged-in as administrator the "wiki-editor" group is created 
automatically and you are made a member.
So is administrator a logged in user in web2py's admin interface? One more 
thing with it: if you inactivate the membership then it shouldn't touch it 
again and reactivate it... 

2013. március 11., hétfő 18:22:24 UTC+1 időpontban Massimo Di Pierro a 
következőt írta:
>
> membership record should be created automatically only for users logged 
> into admin. Are you saying this is not the case?
>
> On Monday, 11 March 2013 12:07:42 UTC-5, szimszon wrote:
>>
>>
>>
>> 2013. március 11., hétfő 18:05:36 UTC+1 időpontban Alan Etkin a 
>> következőt írta:
>>>
>>> > ''wiki-editor'' I think it's just a typo :) 
>>>
>>> Me too, there's no use of "wiki-editor" in the Wiki class (it checks for 
>>> "wiki_editor")
>>>
>>> > and than I recognized that the new user got in to a wiki_editor group
>>>
>>> Did he actually got into the editors group (was that membership record 
>>> created)? Or it's that non editors can create pages?
>>>
>>  
>> Yes he did got into the editors group. Membership record is created.
>>
>

-- 

--- 
You received this message because you are subscribed to the Google Groups 
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

[web2py] Re: I got a fancy wiki problem. All user end up in rw mode :(

[szimszon]

2013. március 11., hétfő 18:05:36 UTC+1 időpontban Alan Etkin a következőt 
írta:
>
> > ''wiki-editor'' I think it's just a typo :) 
>
> Me too, there's no use of "wiki-editor" in the Wiki class (it checks for 
> "wiki_editor")
>
> > and than I recognized that the new user got in to a wiki_editor group
>
> Did he actually got into the editors group (was that membership record 
> created)? Or it's that non editors can create pages?
>
 
Yes he did got into the editors group. Membership record is created.

-- 

--- 
You received this message because you are subscribed to the Google Groups 
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

[web2py] I got a fancy wiki problem. All user end up in rw mode :(

[szimszon]

Hi!

I wonder if somebody could help me.

I tried to set up a wiki in web2py and I face some funny errors :(

1, In book http://web2py.com/books/default/chapter/29/03 there is: ''recognizes 
permissions for "wiki-editor" and "wiki-author"'' but auth.wiki creates 
  ''wiki_editor''
not
  ''wiki-editor''
I think it's just a typo :)

2, I need a lot of read-only user and a handful writers but I end up with all 
user in read-write mode :(

  I created a user and add membership in wiki_editor group.
  I created a first page.
  I creaded a new user.
  The new user got in to a wiki_editor group.
  I delete the membership (I have record versioning)
  I log in with a new user. New user can create page and than I recognized that 
the new user got in to a wiki_editor group :( again.

Miss I something? I tried with and without manage_permissions=True :(


http://code.google.com/p/web2py/issues/detail?id=1381

Version 2.4.1-alpha.2+timestamp.2013.02.23.14.51.03

-- 

--- 
You received this message because you are subscribed to the Google Groups 
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

[web2py] Re: Encrypt an email?

[szimszon]

Hello!

You can try this:

http://web2py.com/books/default/chapter/29/08#x509-and-PGP-Encryption

2013. március 10., vasárnap 4:55:06 UTC+1 időpontban a.ma...@hotmail.com a 
következőt írta:
>
> I found that website http://www.msgpadlock.com who basically allow you to 
> encrypt/decrypt a message that I can then copy paste into the email i want 
> to send. My question is is there a better way? Thanks guys!

-- 

--- 
You received this message because you are subscribed to the Google Groups 
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

[web2py] Re: Debugging with the scheduler

[szimszon]

for the ugly print vars I use:

import logging
logger=logging.getLogger('web2py.app.yourappname')
logger.setLevel(logging.DEBUG)

logger.debug(msg)

2013. február 26., kedd 21:12:23 UTC+1 időpontban José L. a következőt írta:
>
> Hello, 
> I'm working with async processes using the scheduler (with the 
> unvaluable help of the "learn by trial" application from Niphlod. 
>
> I wonder if there's an easy way to debug the processes that are being 
> executed in the background (I'm  having problems with them, they work 
> ok when run from web2py directly as a normal process, but not when 
> they're executed by the scheduler). 
> Pdb would be great, but if not, is there any way to use the ugly but 
> useful "print vars" commands to see the flow of execution of the 
> tasks? 
>
> I know of the output field in the scheduler_task table in the 
> database, but that's terribly slow 
>
> Regards. 
> José L. 
>

-- 

--- 
You received this message because you are subscribed to the Google Groups 
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

[web2py] Old app and 2.4.1-alpha.2+timestamp.2013.01.18.10.00.28 and form submission get 'Consecutive update'

[szimszon]

I wonder if somebody could help me.

I have an old app with a simple form but if I try to submit in second time.

I change some value than press Submit button (after that I got an extra # 
in the end of the url)
than I change some value and press Submit button I end up with this flash 
message:

A record change was detected. Consecutive update self-submissions are notallowed
. Try re-submitting or refreshing the form page. 

Ubuntu Firefox 18.0.1

Thanks.

-- 

--- 
You received this message because you are subscribed to the Google Groups 
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

[web2py] Re: Autoincrement field

[szimszon]

http://code.google.com/p/web2py/issues/detail?id=1307

and

http://code.google.com/p/web2py/issues/detail?id=1308

Tnx.


2013. január 29., kedd 15:15:59 UTC+1 időpontban Massimo Di Pierro a 
következőt írta:
>
> Please open a ticket about this.
>
> On Tuesday, 29 January 2013 03:05:17 UTC-6, szimszon wrote:
>>
>> Some other issue: 
>>
>> db:
>> import datetime
>> db.define_table('sometable',
>> Field('otherid',
>>   compute=lambda r: 'SPPRIME%s' % (
>> datetime.date.today().strftime(
>> '%y%m%d'))
>> )
>>
>>
>>
>>
>> If I insert a db row from modules
>>
>> current.db.sometable.insert()
>>
>>
>> The new record has otherid==None :(
>>
>>
>> 2013. január 29., kedd 9:17:38 UTC+1 időpontban szimszon a következőt 
>> írta:
>>>
>>> The really ugly thing is that compute can silently fail and you could 
>>> end up with None in the db table cell :(
>>>
>>> 2013. január 29., kedd 9:13:29 UTC+1 időpontban szimszon a következőt 
>>> írta:
>>>>
>>>> Something about this issue? Should it work?
>>>>
>>>> 2013. január 28., hétfő 15:44:22 UTC+1 időpontban szimszon a következőt 
>>>> írta:
>>>>>
>>>>> Hi!
>>>>>
>>>>> I wonder if somebody could help me.
>>>>>
>>>>> The
>>>>>
>>>>> definet_table('sometable',
>>>>> Field('otherid', compute=lambda r: r['id'])
>>>>> )
>>>>>
>>>>>
>>>>> doesn't work for me. :( Sould it work? With other than r['id'] it's 
>>>>> working.
>>>>>
>>>>> Version 2.4.1-alpha.2+timestamp.2013.01.27.10.24.17
>>>>>
>>>>>
>>>>> 2010. május 28., péntek 16:02:23 UTC+2 időpontban mdipierro a 
>>>>> következőt írta:
>>>>>>
>>>>>> yes 
>>>>>>
>>>>>> On May 28, 3:44 am, Mathieu Clabaut  
>>>>>> wrote: 
>>>>>> > I guess that one may want some more constraints on the 
>>>>>> autoincrement field. 
>>>>>> > For example, it shall begin at 100  for ecample. 
>>>>>> > It may be because for example, before the application exists some 
>>>>>> paper 
>>>>>> > records where made which were referenced by number < 100) 
>>>>>> > 
>>>>>> > For such a problem, I've set up with: 
>>>>>> > 
>>>>>> > Field('ref_number', compute=lambda r: r['id'] + 100) 
>>>>>> > 
>>>>>> > Which I hope would eliminate the race solution as it is calculate 
>>>>>> upon 
>>>>>> > insertion in the database... Is it the case ? 
>>>>>> > 
>>>>>> > -Mathieu 
>>>>>> > 
>>>>>> > On Thu, May 27, 2010 at 23:25, mdipierro  
>>>>>> wrote: 
>>>>>> > > What is wrong with the default id field that web2py creates for 
>>>>>> every 
>>>>>> > > table? 
>>>>>> > 
>>>>>> > > On May 27, 3:16 pm, matclab  wrote: 
>>>>>> > > > Hello, 
>>>>>> > > >  I'm finding this message in a thread from February... 
>>>>>> > 
>>>>>> > > >  I thought that autoincremented field would guaranty unicity in 
>>>>>> the 
>>>>>> > > > table. 
>>>>>> > > >  I'm afraid the provided solution would allow two record to 
>>>>>> have the 
>>>>>> > > > same autonumber field (think about an access from two users at 
>>>>>> the 
>>>>>> > > > same time). 
>>>>>> > > >  I guess the autoincrement should be done on the DAL or 
>>>>>> database side, 
>>>>>> > > > inside a transaction 
>>>>>> > 
>>>>>> > > >  What do you think about it ? 
>>>>>> > 
>>>>>> > > > On 19 jan, 21:38, Thadeus Burgess  
>>>>>> wrote: 
>>>>>> >

[web2py] Re: Autoincrement field

[szimszon]

Some other issue: 

db:
import datetime
db.define_table('sometable',
Field('otherid',
  compute=lambda r: 'SPPRIME%s' % (
datetime.date.today().strftime('%y%m%d'
))
)




If I insert a db row from modules

current.db.sometable.insert()


The new record has otherid==None :(


2013. január 29., kedd 9:17:38 UTC+1 időpontban szimszon a következőt írta:
>
> The really ugly thing is that compute can silently fail and you could end 
> up with None in the db table cell :(
>
> 2013. január 29., kedd 9:13:29 UTC+1 időpontban szimszon a következőt írta:
>>
>> Something about this issue? Should it work?
>>
>> 2013. január 28., hétfő 15:44:22 UTC+1 időpontban szimszon a következőt 
>> írta:
>>>
>>> Hi!
>>>
>>> I wonder if somebody could help me.
>>>
>>> The
>>>
>>> definet_table('sometable',
>>> Field('otherid', compute=lambda r: r['id'])
>>> )
>>>
>>>
>>> doesn't work for me. :( Sould it work? With other than r['id'] it's 
>>> working.
>>>
>>> Version 2.4.1-alpha.2+timestamp.2013.01.27.10.24.17
>>>
>>>
>>> 2010. május 28., péntek 16:02:23 UTC+2 időpontban mdipierro a következőt 
>>> írta:
>>>>
>>>> yes 
>>>>
>>>> On May 28, 3:44 am, Mathieu Clabaut  wrote: 
>>>> > I guess that one may want some more constraints on the autoincrement 
>>>> field. 
>>>> > For example, it shall begin at 100  for ecample. 
>>>> > It may be because for example, before the application exists some 
>>>> paper 
>>>> > records where made which were referenced by number < 100) 
>>>> > 
>>>> > For such a problem, I've set up with: 
>>>> > 
>>>> > Field('ref_number', compute=lambda r: r['id'] + 100) 
>>>> > 
>>>> > Which I hope would eliminate the race solution as it is calculate 
>>>> upon 
>>>> > insertion in the database... Is it the case ? 
>>>> > 
>>>> > -Mathieu 
>>>> > 
>>>> > On Thu, May 27, 2010 at 23:25, mdipierro  
>>>> wrote: 
>>>> > > What is wrong with the default id field that web2py creates for 
>>>> every 
>>>> > > table? 
>>>> > 
>>>> > > On May 27, 3:16 pm, matclab  wrote: 
>>>> > > > Hello, 
>>>> > > >  I'm finding this message in a thread from February... 
>>>> > 
>>>> > > >  I thought that autoincremented field would guaranty unicity in 
>>>> the 
>>>> > > > table. 
>>>> > > >  I'm afraid the provided solution would allow two record to have 
>>>> the 
>>>> > > > same autonumber field (think about an access from two users at 
>>>> the 
>>>> > > > same time). 
>>>> > > >  I guess the autoincrement should be done on the DAL or database 
>>>> side, 
>>>> > > > inside a transaction 
>>>> > 
>>>> > > >  What do you think about it ? 
>>>> > 
>>>> > > > On 19 jan, 21:38, Thadeus Burgess  wrote: 
>>>> > 
>>>> > > > > max_id=   db(db.table.autonumber>1).select(db.table.autonumber, 
>>>>  # 
>>>> > > > > select all records, and only pull the autonumber column 
>>>> > > > > orderby=~db.table.autonumber, # 
>>>> > > > > descending sort on the autonumber, (highest first) 
>>>> > > > > limitby=(0,1) # limit the query 
>>>> and 
>>>> > > > > only select the first record 
>>>> > > > > ).first().autonumber # pull the first 
>>>> record 
>>>> > > > > from the web2py rows object, and get its autonumber member 
>>>> > 
>>>> > > > > db.table.autonumber.default = max_id + 1 # Set the table 
>>>> default as 
>>>> > > > > the last autonumber and incremented by one. 
>>>> > > > > db.table.autonumber.writable = False 
>>>> > 
>>>> > > > > form = crud.create(db.table) 
>>>> > 
>>>> > > > > -Thadeus 
>>>> > 
>>>> > > > > On Tue, Jan 19, 2010 at 4:32 AM, ceriox  
>>>> wrote: 
>>>> > > > > > thanks for the reply but i'm not a good web2py programmer ... 
>>>> i 
>>>> > > > > > writing my first real app 
>>>> > > > > > you can write the code for my request? (i can't understand 
>>>> the post 
>>>> > > of 
>>>> > > > > > your link) 
>>>> > 
>>>> > > > > > -- 
>>>> > > > > > You received this message because you are subscribed to the 
>>>> Google 
>>>> > > Groups "web2py-users" group. 
>>>> > > > > > To post to this group, send email to web...@googlegroups.com. 
>>>>
>>>> > > > > > To unsubscribe from this group, send email to 
>>>> > > web2py+un...@googlegroups.com 
>>>>
>>>> > > . 
>>>> > > > > > For more options, visit this group athttp:// 
>>>> > > groups.google.com/group/web2py?hl=en.
>>>
>>>

-- 

--- 
You received this message because you are subscribed to the Google Groups 
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

[web2py] Re: Autoincrement field

[szimszon]

The really ugly thing is that compute can silently fail and you could end 
up with None in the db table cell :(

2013. január 29., kedd 9:13:29 UTC+1 időpontban szimszon a következőt írta:
>
> Something about this issue? Should it work?
>
> 2013. január 28., hétfő 15:44:22 UTC+1 időpontban szimszon a következőt 
> írta:
>>
>> Hi!
>>
>> I wonder if somebody could help me.
>>
>> The
>>
>> definet_table('sometable',
>> Field('otherid', compute=lambda r: r['id'])
>> )
>>
>>
>> doesn't work for me. :( Sould it work? With other than r['id'] it's 
>> working.
>>
>> Version 2.4.1-alpha.2+timestamp.2013.01.27.10.24.17
>>
>>
>> 2010. május 28., péntek 16:02:23 UTC+2 időpontban mdipierro a következőt 
>> írta:
>>>
>>> yes 
>>>
>>> On May 28, 3:44 am, Mathieu Clabaut  wrote: 
>>> > I guess that one may want some more constraints on the autoincrement 
>>> field. 
>>> > For example, it shall begin at 100  for ecample. 
>>> > It may be because for example, before the application exists some 
>>> paper 
>>> > records where made which were referenced by number < 100) 
>>> > 
>>> > For such a problem, I've set up with: 
>>> > 
>>> > Field('ref_number', compute=lambda r: r['id'] + 100) 
>>> > 
>>> > Which I hope would eliminate the race solution as it is calculate upon 
>>> > insertion in the database... Is it the case ? 
>>> > 
>>> > -Mathieu 
>>> > 
>>> > On Thu, May 27, 2010 at 23:25, mdipierro  
>>> wrote: 
>>> > > What is wrong with the default id field that web2py creates for 
>>> every 
>>> > > table? 
>>> > 
>>> > > On May 27, 3:16 pm, matclab  wrote: 
>>> > > > Hello, 
>>> > > >  I'm finding this message in a thread from February... 
>>> > 
>>> > > >  I thought that autoincremented field would guaranty unicity in 
>>> the 
>>> > > > table. 
>>> > > >  I'm afraid the provided solution would allow two record to have 
>>> the 
>>> > > > same autonumber field (think about an access from two users at the 
>>> > > > same time). 
>>> > > >  I guess the autoincrement should be done on the DAL or database 
>>> side, 
>>> > > > inside a transaction 
>>> > 
>>> > > >  What do you think about it ? 
>>> > 
>>> > > > On 19 jan, 21:38, Thadeus Burgess  wrote: 
>>> > 
>>> > > > > max_id=   db(db.table.autonumber>1).select(db.table.autonumber, 
>>>  # 
>>> > > > > select all records, and only pull the autonumber column 
>>> > > > > orderby=~db.table.autonumber, # 
>>> > > > > descending sort on the autonumber, (highest first) 
>>> > > > > limitby=(0,1) # limit the query 
>>> and 
>>> > > > > only select the first record 
>>> > > > > ).first().autonumber # pull the first 
>>> record 
>>> > > > > from the web2py rows object, and get its autonumber member 
>>> > 
>>> > > > > db.table.autonumber.default = max_id + 1 # Set the table default 
>>> as 
>>> > > > > the last autonumber and incremented by one. 
>>> > > > > db.table.autonumber.writable = False 
>>> > 
>>> > > > > form = crud.create(db.table) 
>>> > 
>>> > > > > -Thadeus 
>>> > 
>>> > > > > On Tue, Jan 19, 2010 at 4:32 AM, ceriox  
>>> wrote: 
>>> > > > > > thanks for the reply but i'm not a good web2py programmer ... 
>>> i 
>>> > > > > > writing my first real app 
>>> > > > > > you can write the code for my request? (i can't understand the 
>>> post 
>>> > > of 
>>> > > > > > your link) 
>>> > 
>>> > > > > > -- 
>>> > > > > > You received this message because you are subscribed to the 
>>> Google 
>>> > > Groups "web2py-users" group. 
>>> > > > > > To post to this group, send email to web...@googlegroups.com. 
>>> > > > > > To unsubscribe from this group, send email to 
>>> > > web2py+un...@googlegroups.com 
>>>
>>> > > . 
>>> > > > > > For more options, visit this group athttp:// 
>>> > > groups.google.com/group/web2py?hl=en.
>>
>>

-- 

--- 
You received this message because you are subscribed to the Google Groups 
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

[web2py] Re: Autoincrement field

[szimszon]

Something about this issue? Should it work?

2013. január 28., hétfő 15:44:22 UTC+1 időpontban szimszon a következőt 
írta:
>
> Hi!
>
> I wonder if somebody could help me.
>
> The
>
> definet_table('sometable',
> Field('otherid', compute=lambda r: r['id'])
> )
>
>
> doesn't work for me. :( Sould it work? With other than r['id'] it's 
> working.
>
> Version 2.4.1-alpha.2+timestamp.2013.01.27.10.24.17
>
>
> 2010. május 28., péntek 16:02:23 UTC+2 időpontban mdipierro a következőt 
> írta:
>>
>> yes 
>>
>> On May 28, 3:44 am, Mathieu Clabaut  wrote: 
>> > I guess that one may want some more constraints on the autoincrement 
>> field. 
>> > For example, it shall begin at 100  for ecample. 
>> > It may be because for example, before the application exists some paper 
>> > records where made which were referenced by number < 100) 
>> > 
>> > For such a problem, I've set up with: 
>> > 
>> > Field('ref_number', compute=lambda r: r['id'] + 100) 
>> > 
>> > Which I hope would eliminate the race solution as it is calculate upon 
>> > insertion in the database... Is it the case ? 
>> > 
>> > -Mathieu 
>> > 
>> > On Thu, May 27, 2010 at 23:25, mdipierro  
>> wrote: 
>> > > What is wrong with the default id field that web2py creates for every 
>> > > table? 
>> > 
>> > > On May 27, 3:16 pm, matclab  wrote: 
>> > > > Hello, 
>> > > >  I'm finding this message in a thread from February... 
>> > 
>> > > >  I thought that autoincremented field would guaranty unicity in the 
>> > > > table. 
>> > > >  I'm afraid the provided solution would allow two record to have 
>> the 
>> > > > same autonumber field (think about an access from two users at the 
>> > > > same time). 
>> > > >  I guess the autoincrement should be done on the DAL or database 
>> side, 
>> > > > inside a transaction 
>> > 
>> > > >  What do you think about it ? 
>> > 
>> > > > On 19 jan, 21:38, Thadeus Burgess  wrote: 
>> > 
>> > > > > max_id=   db(db.table.autonumber>1).select(db.table.autonumber, 
>>  # 
>> > > > > select all records, and only pull the autonumber column 
>> > > > > orderby=~db.table.autonumber, # 
>> > > > > descending sort on the autonumber, (highest first) 
>> > > > > limitby=(0,1) # limit the query 
>> and 
>> > > > > only select the first record 
>> > > > > ).first().autonumber # pull the first 
>> record 
>> > > > > from the web2py rows object, and get its autonumber member 
>> > 
>> > > > > db.table.autonumber.default = max_id + 1 # Set the table default 
>> as 
>> > > > > the last autonumber and incremented by one. 
>> > > > > db.table.autonumber.writable = False 
>> > 
>> > > > > form = crud.create(db.table) 
>> > 
>> > > > > -Thadeus 
>> > 
>> > > > > On Tue, Jan 19, 2010 at 4:32 AM, ceriox  
>> wrote: 
>> > > > > > thanks for the reply but i'm not a good web2py programmer ... i 
>> > > > > > writing my first real app 
>> > > > > > you can write the code for my request? (i can't understand the 
>> post 
>> > > of 
>> > > > > > your link) 
>> > 
>> > > > > > -- 
>> > > > > > You received this message because you are subscribed to the 
>> Google 
>> > > Groups "web2py-users" group. 
>> > > > > > To post to this group, send email to web...@googlegroups.com. 
>> > > > > > To unsubscribe from this group, send email to 
>> > > web2py+un...@googlegroups.com 
>> > > . 
>> > > > > > For more options, visit this group athttp:// 
>> > > groups.google.com/group/web2py?hl=en.
>
>

-- 

--- 
You received this message because you are subscribed to the Google Groups 
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

Re: [web2py] Re: Autoincrement field

[szimszon]

I'm definitively for an auto-increment field like datetime anyway :-D

2013. január 28., hétfő 15:48:24 UTC+1 időpontban Alec Taylor a következőt 
írta:
>
> Which DB are you using BTW? 
>
> Because if you're using something like MySQL; they have inbuilt 
> autoincrement fields which would be much better to utilise than what 
> we provide in the DAL. 
>
> Maybe we should have an 'autoincrement' field, like we have a 'datetime' 
> field? 
>
> Gracefully degrade to a lambda if there isn't native autoincrement 
> support. 
>
> On Tue, Jan 29, 2013 at 1:44 AM, szimszon > 
> wrote: 
> > Hi! 
> > 
> > I wonder if somebody could help me. 
> > 
> > The 
> > 
> > definet_table('sometable', 
> > Field('otherid', compute=lambda r: r['id']) 
> > ) 
> > 
> > 
> > doesn't work for me. :( Sould it work? With other than r['id'] it's 
> working. 
> > 
> > Version 2.4.1-alpha.2+timestamp.2013.01.27.10.24.17 
> > 
> > 
> > 2010. május 28., péntek 16:02:23 UTC+2 időpontban mdipierro a következőt 
> > írta: 
> >> 
> >> yes 
> >> 
> >> On May 28, 3:44 am, Mathieu Clabaut  wrote: 
> >> > I guess that one may want some more constraints on the autoincrement 
> >> > field. 
> >> > For example, it shall begin at 100  for ecample. 
> >> > It may be because for example, before the application exists some 
> paper 
> >> > records where made which were referenced by number < 100) 
> >> > 
> >> > For such a problem, I've set up with: 
> >> > 
> >> > Field('ref_number', compute=lambda r: r['id'] + 100) 
> >> > 
> >> > Which I hope would eliminate the race solution as it is calculate 
> upon 
> >> > insertion in the database... Is it the case ? 
> >> > 
> >> > -Mathieu 
> >> > 
> >> > On Thu, May 27, 2010 at 23:25, mdipierro  
> >> > wrote: 
> >> > > What is wrong with the default id field that web2py creates for 
> every 
> >> > > table? 
> >> > 
> >> > > On May 27, 3:16 pm, matclab  wrote: 
> >> > > > Hello, 
> >> > > >  I'm finding this message in a thread from February... 
> >> > 
> >> > > >  I thought that autoincremented field would guaranty unicity in 
> the 
> >> > > > table. 
> >> > > >  I'm afraid the provided solution would allow two record to have 
> the 
> >> > > > same autonumber field (think about an access from two users at 
> the 
> >> > > > same time). 
> >> > > >  I guess the autoincrement should be done on the DAL or database 
> >> > > > side, 
> >> > > > inside a transaction 
> >> > 
> >> > > >  What do you think about it ? 
> >> > 
> >> > > > On 19 jan, 21:38, Thadeus Burgess  wrote: 
> >> > 
> >> > > > > max_id=   db(db.table.autonumber>1).select(db.table.autonumber, 
>  # 
> >> > > > > select all records, and only pull the autonumber column 
> >> > > > > orderby=~db.table.autonumber, # 
> >> > > > > descending sort on the autonumber, (highest first) 
> >> > > > > limitby=(0,1) # limit the query 
> >> > > > > and 
> >> > > > > only select the first record 
> >> > > > > ).first().autonumber # pull the first 
> >> > > > > record 
> >> > > > > from the web2py rows object, and get its autonumber member 
> >> > 
> >> > > > > db.table.autonumber.default = max_id + 1 # Set the table 
> default 
> >> > > > > as 
> >> > > > > the last autonumber and incremented by one. 
> >> > > > > db.table.autonumber.writable = False 
> >> > 
> >> > > > > form = crud.create(db.table) 
> >> > 
> >> > > > > -Thadeus 
> >> > 
> >> > > > > On Tue, Jan 19, 2010 at 4:32 AM, ceriox  
> wrote: 
> >> > > > > > thanks for the reply but i'm not a good web2py programmer ... 
> i 
> >> > > > > > writing my first real app 
> >> > > > > > you can write the code for my request? (i can't understand 
> the 
> >> > > > > > post 
> >> > > of 
> >> > > > > > your link) 
> >> > 
> >> > > > > > -- 
> >> > > > > > You received this message because you are subscribed to the 
> >> > > > > > Google 
> >> > > Groups "web2py-users" group. 
> >> > > > > > To post to this group, send email to web...@googlegroups.com. 
>
> >> > > > > > To unsubscribe from this group, send email to 
> >> > > web2py+un...@googlegroups.com>
> >> > >  
>
> >> > > . 
> >> > > > > > For more options, visit this group athttp:// 
> >> > > groups.google.com/group/web2py?hl=en. 
> > 
> > -- 
> > 
> > 
> > 
>

-- 

Re: [web2py] Re: Autoincrement field

[szimszon]

postgresql Version: 8.4.12-0squeeze1 (producttion - not tested)
postgresql Version: 9.1.7-0ubuntu12.10 (dev)

I need somethink like:

Field('otherid','string', compute=lambda r: 'SOMETHING%s%s' % (
str(datetime.date.today()),
str(r['id'])))



2013. január 28., hétfő 15:48:24 UTC+1 időpontban Alec Taylor a következőt 
írta:
>
> Which DB are you using BTW? 
>
> Because if you're using something like MySQL; they have inbuilt 
> autoincrement fields which would be much better to utilise than what 
> we provide in the DAL. 
>
> Maybe we should have an 'autoincrement' field, like we have a 'datetime' 
> field? 
>
> Gracefully degrade to a lambda if there isn't native autoincrement 
> support. 
>
> On Tue, Jan 29, 2013 at 1:44 AM, szimszon > 
> wrote: 
> > Hi! 
> > 
> > I wonder if somebody could help me. 
> > 
> > The 
> > 
> > definet_table('sometable', 
> > Field('otherid', compute=lambda r: r['id']) 
> > ) 
> > 
> > 
> > doesn't work for me. :( Sould it work? With other than r['id'] it's 
> working. 
> > 
> > Version 2.4.1-alpha.2+timestamp.2013.01.27.10.24.17 
> > 
> > 
> > 2010. május 28., péntek 16:02:23 UTC+2 időpontban mdipierro a következőt 
> > írta: 
> >> 
> >> yes 
> >> 
> >> On May 28, 3:44 am, Mathieu Clabaut  wrote: 
> >> > I guess that one may want some more constraints on the autoincrement 
> >> > field. 
> >> > For example, it shall begin at 100  for ecample. 
> >> > It may be because for example, before the application exists some 
> paper 
> >> > records where made which were referenced by number < 100) 
> >> > 
> >> > For such a problem, I've set up with: 
> >> > 
> >> > Field('ref_number', compute=lambda r: r['id'] + 100) 
> >> > 
> >> > Which I hope would eliminate the race solution as it is calculate 
> upon 
> >> > insertion in the database... Is it the case ? 
> >> > 
> >> > -Mathieu 
> >> > 
> >> > On Thu, May 27, 2010 at 23:25, mdipierro  
> >> > wrote: 
> >> > > What is wrong with the default id field that web2py creates for 
> every 
> >> > > table? 
> >> > 
> >> > > On May 27, 3:16 pm, matclab  wrote: 
> >> > > > Hello, 
> >> > > >  I'm finding this message in a thread from February... 
> >> > 
> >> > > >  I thought that autoincremented field would guaranty unicity in 
> the 
> >> > > > table. 
> >> > > >  I'm afraid the provided solution would allow two record to have 
> the 
> >> > > > same autonumber field (think about an access from two users at 
> the 
> >> > > > same time). 
> >> > > >  I guess the autoincrement should be done on the DAL or database 
> >> > > > side, 
> >> > > > inside a transaction 
> >> > 
> >> > > >  What do you think about it ? 
> >> > 
> >> > > > On 19 jan, 21:38, Thadeus Burgess  wrote: 
> >> > 
> >> > > > > max_id=   db(db.table.autonumber>1).select(db.table.autonumber, 
>  # 
> >> > > > > select all records, and only pull the autonumber column 
> >> > > > > orderby=~db.table.autonumber, # 
> >> > > > > descending sort on the autonumber, (highest first) 
> >> > > > > limitby=(0,1) # limit the query 
> >> > > > > and 
> >> > > > > only select the first record 
> >> > > > > ).first().autonumber # pull the first 
> >> > > > > record 
> >> > > > > from the web2py rows object, and get its autonumber member 
> >> > 
> >> > > > > db.table.autonumber.default = max_id + 1 # Set the table 
> default 
> >> > > > > as 
> >> > > > > the last autonumber and incremented by one. 
> >> > > > > db.table.autonumber.writable = False 
> >> > 
> >> > > > > form = crud.create(db.table) 
> >> > 
> >> > > > > -Thadeus 
> >> > 
> >> > > > > On Tue, Jan 19, 2010 at 4:32 AM, ceriox  
> wrote: 
> >> > > > > > thanks for the reply but i'm not a good web2py programmer ... 
> i 
> >> > > > > > writing my first real app 
> >> > > > > > you can write the code for my request? (i can't understand 
> the 
> >> > > > > > post 
> >> > > of 
> >> > > > > > your link) 
> >> > 
> >> > > > > > -- 
> >> > > > > > You received this message because you are subscribed to the 
> >> > > > > > Google 
> >> > > Groups "web2py-users" group. 
> >> > > > > > To post to this group, send email to web...@googlegroups.com. 
>
> >> > > > > > To unsubscribe from this group, send email to 
> >> > > web2py+un...@googlegroups.com>
> >> > >  
>
> >> > > . 
> >> > > > > > For more options, visit this group athttp:// 
> >> > > groups.google.com/group/web2py?hl=en. 
> > 
> > -- 
> > 
> > 
> > 
>

-- 

[web2py] Re: Autoincrement field

[szimszon]

Hi!

I wonder if somebody could help me.

The

definet_table('sometable',
Field('otherid', compute=lambda r: r['id'])
)


doesn't work for me. :( Sould it work? With other than r['id'] it's working.

Version 2.4.1-alpha.2+timestamp.2013.01.27.10.24.17


2010. május 28., péntek 16:02:23 UTC+2 időpontban mdipierro a következőt 
írta:
>
> yes 
>
> On May 28, 3:44 am, Mathieu Clabaut  wrote: 
> > I guess that one may want some more constraints on the autoincrement 
> field. 
> > For example, it shall begin at 100  for ecample. 
> > It may be because for example, before the application exists some paper 
> > records where made which were referenced by number < 100) 
> > 
> > For such a problem, I've set up with: 
> > 
> > Field('ref_number', compute=lambda r: r['id'] + 100) 
> > 
> > Which I hope would eliminate the race solution as it is calculate upon 
> > insertion in the database... Is it the case ? 
> > 
> > -Mathieu 
> > 
> > On Thu, May 27, 2010 at 23:25, mdipierro  
> wrote: 
> > > What is wrong with the default id field that web2py creates for every 
> > > table? 
> > 
> > > On May 27, 3:16 pm, matclab  wrote: 
> > > > Hello, 
> > > >  I'm finding this message in a thread from February... 
> > 
> > > >  I thought that autoincremented field would guaranty unicity in the 
> > > > table. 
> > > >  I'm afraid the provided solution would allow two record to have the 
> > > > same autonumber field (think about an access from two users at the 
> > > > same time). 
> > > >  I guess the autoincrement should be done on the DAL or database 
> side, 
> > > > inside a transaction 
> > 
> > > >  What do you think about it ? 
> > 
> > > > On 19 jan, 21:38, Thadeus Burgess  wrote: 
> > 
> > > > > max_id=   db(db.table.autonumber>1).select(db.table.autonumber,  # 
> > > > > select all records, and only pull the autonumber column 
> > > > > orderby=~db.table.autonumber, # 
> > > > > descending sort on the autonumber, (highest first) 
> > > > > limitby=(0,1) # limit the query 
> and 
> > > > > only select the first record 
> > > > > ).first().autonumber # pull the first 
> record 
> > > > > from the web2py rows object, and get its autonumber member 
> > 
> > > > > db.table.autonumber.default = max_id + 1 # Set the table default 
> as 
> > > > > the last autonumber and incremented by one. 
> > > > > db.table.autonumber.writable = False 
> > 
> > > > > form = crud.create(db.table) 
> > 
> > > > > -Thadeus 
> > 
> > > > > On Tue, Jan 19, 2010 at 4:32 AM, ceriox  wrote: 
> > > > > > thanks for the reply but i'm not a good web2py programmer ... i 
> > > > > > writing my first real app 
> > > > > > you can write the code for my request? (i can't understand the 
> post 
> > > of 
> > > > > > your link) 
> > 
> > > > > > -- 
> > > > > > You received this message because you are subscribed to the 
> Google 
> > > Groups "web2py-users" group. 
> > > > > > To post to this group, send email to 
> > > > > > web...@googlegroups.com. 
>
> > > > > > To unsubscribe from this group, send email to 
> > > web2py+un...@googlegroups.com <
> web2py%2bunsubscr...@googlegroups.com > 
> > > . 
> > > > > > For more options, visit this group athttp:// 
> > > groups.google.com/group/web2py?hl=en.

-- 

[web2py] Re: Is it possible to define how a field is rendered in the DB model?

[szimszon]

Hi!

What is a difference between represent and filter_out? Tnx.

-- 

[web2py] Re: Repo in github missing

[szimszon]

OK. Tnx.

2013. január 1., kedd 17:38:14 UTC+1 időpontban Massimo Di Pierro a 
következőt írta:
>
> I deleted it to avoid confusion. The official is github.com/web2py/web2py.
>
> On Tuesday, 1 January 2013 02:21:40 UTC-6, szimszon wrote:
>>
>> Where is the web2py repo from https://github.com/mdipierro/ ?
>>
>> Happy New Year for everyone!
>>
>

-- 

[web2py] Repo in github missing

[szimszon]

Where is the web2py repo from https://github.com/mdipierro/ ?

Happy New Year for everyone!

-- 

[web2py] Re: Disable hidden columns export in grid

[szimszon]

Nice and working feature :) Tnx.

2012. december 4., kedd 11:26:50 UTC+1 időpontban Niphlod a következőt írta:
>
> with trunk just pass exportclasses=dict(csv_with_hidden_cols=False, 
> tsv_with_hidden_cols=False)
>
> On Tuesday, December 4, 2012 10:35:52 AM UTC+1, szimszon wrote:
>>
>> Hi All!
>>
>> I wonder if somebody could help me.
>>
>> How can I disable hidden column export in grid?
>>
>

-- 

[web2py] Disable hidden columns export in grid

[szimszon]

Hi All!

I wonder if somebody could help me.

How can I disable hidden column export in grid?

-- 

[web2py] Re: server request as transfer encoding: chunked not working

[szimszon]

I was able to handle it:

try:
import gluon
if isinstance(request.env.wsgi_input, gluon.rocket.ChunkedReader):
body = ''
while True:
try:
s = request.env.wsgi_input.read(1)
if s == '':
break
body += s
except:
break
else:
body = request.body.read()

Any suggestion to make it better?

Thanks.

2012. december 3., hétfő 13:10:31 UTC+1 időpontban Niphlod a következőt 
írta:
>
> don't know if it's a design decision but request.body is filled only if 
> there is a content-length header, otherwise a StringIO() is returned.
>
> you can still read the contents iterating over request.env.wsgi_input
>
> On Monday, December 3, 2012 12:30:38 PM UTC+1, szimszon wrote:
>>
>> Version 2.2.1 (2012-11-04 20:45:19) stable
>>
>>

-- 

[web2py] Re: server request as transfer encoding: chunked not working

[szimszon]

Wow. Thanks for the hint :)

Funny that the variables have a different type in *chunked*:

request.body: 
request.env.wsgi_input:  

and in *Content-Lenght* context:

request.body: 
request.env.wsgi_input:  




2012. december 3., hétfő 13:10:31 UTC+1 időpontban Niphlod a következőt 
írta:
>
> don't know if it's a design decision but request.body is filled only if 
> there is a content-length header, otherwise a StringIO() is returned.
>
> you can still read the contents iterating over request.env.wsgi_input
>
> On Monday, December 3, 2012 12:30:38 PM UTC+1, szimszon wrote:
>>
>> Version 2.2.1 (2012-11-04 20:45:19) stable
>>
>>

-- 

[web2py] Re: server request as transfer encoding: chunked not working

[szimszon]

Version 2.2.1 (2012-11-04 20:45:19) stable

-- 

[web2py] server request as transfer encoding: chunked not working

[szimszon]

Hi All!

I wonder if somebody could help me.

I need a little help with rocket :(

I have a contoller like:

def statementlist():
  body = request.body.read()
  return dict(body=body)



And I try to send a request as:

curl -H "Transfer-Encoding: chunked" --data 'Some data inside the 
request...'

but the body is empty :(


-- 

[web2py] Re: Custom import creates module name conflicts (2.1.1)

[szimszon]

I have in app's modules dir a modul named sftp.py and I try to use paramiko 
but sftp.py modul can't import it because paramiko has it's own modul named 
as sftp.py and custom_import find the app's module first and nor paramiko's 
:(

http://code.google.com/p/web2py/issues/detail?id=1125

2012. október 22., hétfő 23:31:14 UTC+2 időpontban Jim Karsten a következőt 
írta:
>
> Thanks, Massimo.
>
> I upgraded to web2py v2.2.1 and that patch addresses the 'ImportError: 
> cannot import name web2py_uuid' error.
>
> I still have name clashes with my constants.py module and MySQLdb. For now 
> I am going to rename my module. I have some reservations about the new 
> custom_importer as it can produce these clash problems and there is little 
> I can do to prepare for them or protect my code from them.
>
> On Friday, October 19, 2012 7:37:44 PM UTC-4, Massimo Di Pierro wrote:
>>
>> Good catch. Fixed in trunk
>>
>> On Friday, 19 October 2012 16:54:54 UTC-5, Jim Karsten wrote:
>>>
>>> I upgraded to v 2.1.1 and now see problems with module name conflicts 
>>> due to the custom importer. Previously I used v2.0.9 without problems.
>>>
>>> I have a custom application module named utils.py. This appears to 
>>> conflict with the gluon.utils module. I was able to simulate using the 
>>> basic web2py zip file and then creating a simple module 
>>> applications/welcome/modules/utils.py. When I access the welcome default 
>>> page, I get this error: 
>>>
>>> Traceback (most recent call last): 
>>> File "/root/tmp/web2py/web2py/gluon/restricted.py", line 209, 
>>> in restricted exec ccode in environment 
>>> File "/root/tmp/web2py/web2py/applications/welcome/models/db.py", line 
>>> 42, 
>>> in from gluon.tools import Auth, Crud, Service, PluginManager, 
>>> prettydate 
>>> File "/root/tmp/web2py/web2py/gluon/custom_import.py", line 89, 
>>> in custom_importer return 
>>> NATIVE_IMPORTER(name,globals,locals,fromlist,level)
>>> File "/root/tmp/web2py/web2py/gluon/tools.py", line 30, in from utils 
>>> import web2py_uuid 
>>> ImportError: cannot import name web2py_uuid 
>>>
>>> I disabled the custom importer by issuing a return immediately in 
>>> gluon/custom_import.py def custom_import_install() and the problem goes 
>>> away. 
>>>
>>> I can also correct this specific issue if I change this line in 
>>> gluon/tools.py 
>>>
>>> -from utils import web2py_uuid 
>>> +from gluon.utils import web2py_uuid 
>>>
>>> This last change works, but it isn't a complete solution. For example, 
>>> in another application I have a constants.py module. It is conflicting with 
>>> a constants module MySQLdb makes use of. Deep in the code of MySQLdb there 
>>> is a line:
>>>
>>> from constants import CLIENT, FIELD_TYPE 
>>>
>>> That import fails as it tries to find those classes in my custom module. 
>>> I can always rename my custom module, but this becomes a cat and mouse 
>>> game. I can't know every module name already in use. 
>>>
>>> Any suggestions for this? It's a bit of a show stopper for me. Perhaps 
>>> an option should be available to disable the custom importer. 
>>
>>

-- 

Re: [web2py] Re: manage_groups AD problem

[szimszon]

I still have no means to test AD but I welcome all the help I can get :)

Please put a 

print '##%s##' % str(group_row)

or 

logger.warning('##%s##' % str(group_row))

line to the gluon/contrib/login_methods/ldap_auth.py file line 627. Restart 
web2py try and send the printed lines back. It seems to me that AD results 
are in other format than ldap results...

2012. október 20., szombat 13:21:52 UTC+2 időpontban software.ted a 
következőt írta:
>
> Hi, went to the office to try out your suggestion. Honetly the debug 
> process is a little strange to me I had put a break at line with 
> ldap_auth() but the next toggled went to very cryptic code i couldn't 
> follow. 
>
> On the other hand you suggested i try adding allowed_groups...i did 
> that and when i click on the login button am getting a ticket. I have 
> attached the ticket details, am not sure why its complaining about the 
> list being indices when your documentation says the list values for 
> allowed_groups should be str as follows: 
> allowed_groups=['group1','group2','etc']. 
>
> I have also noticed your old post: 
>
> "If there is somebody using ldap_auth with AD please try to test 
> allowed_groups and / or manage_groups as I have no means to test it. 
> And I do not know differences between OpenLdap and AD regarding groups 
> :( 
>
> Tnx." 
>
> You still have not tested the group feature? I am quiet surprised, 
> cause AD is widely used and you guys need to test. From the searches I 
> have done, looks like AD does not work well with web2py as far as 
> groups are concerned. 
>
> I goes I have reached a dead end. 
>
> :< 
>
> Thanks for your help. 
>
> Teddy L. 
>
>
> On Sat, Oct 20, 2012 at 9:52 AM, szimszon > 
> wrote: 
> > 
> > ldap_auth(...as usual...,logging_level='debug') 
> > 
> > 2012. október 20., szombat 9:29:44 UTC+2 időpontban software.ted a 
> > következőt írta: 
> >> 
> >> Whr do I set the log level and see how the code is executing I realy 
> need 
> >> that for debugging. 
> >> 
> >> On Oct 20, 2012 9:20 AM, "szimszon"  wrote: 
> >>> 
> >>> Could you set ldap_auth's logging_level to debug and see (in console) 
> >>> what's happening? Or you could specify allowed_groups=['some group 
> name'] if 
> >>> there a logic error and login  works only with allowed_groups set. 
> >>> 
> >>> Sorry I have no AD to test. With ldap it works. So I need a bit 
> help... 
> >>> 
> >>> 2012. október 20., szombat 7:44:20 UTC+2 időpontban software.ted a 
> >>> következőt írta: 
> >>>> 
> >>>> Yes that's one am referring to. The moment I introduce the parameter 
> >>>> manage_groups users fail to login against AD...this is my sample 
> code: 
> >>>> 
> >>>> from gluon.contrib.login_methods.ldap_auth import ldap_auth 
> >>>> auth.settings.login_methods = [ldap_auth(mode='ad', manage_groups= 
> True, 
> >>>> bind_dn = 'CN=Admin,DC=example,DC=co,DC= zm', bind_pw = 'ADPASSWORD', 
> >>>> group_dn = 'DC= example,DC=co,DC=zm', group_name_attrib = 'cn', 
> >>>> group_member_attrib = 'member', group_filterstr = 
> 'objectClass=Group', 
> >>>> server='xxx.xxx.xxx.xxx', base_dn='dc=example,dc=co,dc=zm')] 
> >>>> Any reason why group management is not working? Is there another way 
> I 
> >>>> can use AD users and assign rolls to certain users? 
> >>>> 
> >>>> Teddy L. 
> >>>> 
> >>>> On Oct 19, 2012 8:46 PM, "Massimo Di Pierro"  
> >>>> wrote: 
> >>>>> 
> >>>>> Are you talking about ldap_auth? 
> >>>>> 
> >>>>> On Friday, 19 October 2012 02:38:39 UTC-5, software.ted wrote: 
> >>>>>> 
> >>>>>> I am having trouble with manage_group=True, when I enable it i am 
> >>>>>> getting "Invalid Login" but without it logins work. Does AD Group 
> >>>>>> Management in web2py work? 
> >>>>>> 
> >>>>>> Kind regards, 
> >>>>> 
> >>>>> -- 
> >>>>> 
> >>>>> 
> >>>>> 
> >>> 
> >>> -- 
> >>> 
> >>> 
> >>> 
> > 
> > -- 
> > 
> > 
> > 
>
>
>
> -- 
> ...
>  
>
> Teddy Lubasi Nyambe 
> Opensource Zambia 
> Lusaka, ZAMBIA 
>
> Cell: +260 97 7760473 
> website: http://www.opensource.org.zm 
>
> ~/ 
> Human Knowledge belongs to the world! - AntiTrust 
>
> Man is a tool-using animal. Without tools he is nothing, with tools he 
> is all - Thomas Carlyle 1795-1881 
>
> /~ 
>

-- 

Re: [web2py] Re: manage_groups AD problem

[szimszon]

ldap_auth(...as usual...,logging_level='debug')

2012. október 20., szombat 9:29:44 UTC+2 időpontban software.ted a 
következőt írta:
>
> Whr do I set the log level and see how the code is executing I realy need 
> that for debugging.
> On Oct 20, 2012 9:20 AM, "szimszon" > 
> wrote:
>
>> Could you set ldap_auth's *logging_level* to debug and see (in console) 
>> what's happening? Or you could specify *allowed_groups*=['some group 
>> name'] if there a logic error and login  works only with allowed_groups set.
>>
>> Sorry I have no AD to test. With ldap it works. So I need a bit help...
>>
>> 2012. október 20., szombat 7:44:20 UTC+2 időpontban software.ted a 
>> következőt írta:
>>>
>>> Yes that's one am referring to. The moment I introduce the parameter 
>>> manage_groups users fail to login against AD...this is my sample code:
>>>
>>> from gluon.contrib.login_methods.**ldap_auth import ldap_auth 
>>> auth.settings.login_methods = [ldap_auth(mode='ad', manage_groups= True, 
>>> bind_dn = 'CN=Admin,DC=example,DC=co,DC= zm', bind_pw = 'ADPASSWORD', 
>>> group_dn = 'DC= example,DC=co,DC=zm', group_name_attrib = 'cn', 
>>> group_member_attrib = 'member', group_filterstr = 'objectClass=Group', 
>>> server='xxx.xxx.xxx.xxx', base_dn='dc=example,dc=co,dc=**zm')] 
>>> Any reason why group management is not working? Is there another way I 
>>> can use AD users and assign rolls to certain users?
>>>
>>> Teddy L.
>>>  On Oct 19, 2012 8:46 PM, "Massimo Di Pierro"  
>>> wrote:
>>>
>>>> Are you talking about ldap_auth?
>>>>
>>>> On Friday, 19 October 2012 02:38:39 UTC-5, software.ted wrote:
>>>>>
>>>>> I am having trouble with manage_group=True, when I enable it i am 
>>>>> getting "Invalid Login" but without it logins work. Does AD Group 
>>>>> Management in web2py work? 
>>>>>
>>>>> Kind regards, 
>>>>>
>>>>  -- 
>>>>  
>>>>  
>>>>  
>>>>
>>>  -- 
>>  
>>  
>>  
>>
>

-- 

Re: [web2py] Re: manage_groups AD problem

[szimszon]

Could you set ldap_auth's *logging_level* to debug and see (in console) 
what's happening? Or you could specify *allowed_groups*=['some group name'] 
if there a logic error and login  works only with allowed_groups set.

Sorry I have no AD to test. With ldap it works. So I need a bit help...

2012. október 20., szombat 7:44:20 UTC+2 időpontban software.ted a 
következőt írta:
>
> Yes that's one am referring to. The moment I introduce the parameter 
> manage_groups users fail to login against AD...this is my sample code:
>
> from gluon.contrib.login_methods.ldap_auth import ldap_auth 
> auth.settings.login_methods = [ldap_auth(mode='ad', manage_groups= True, 
> bind_dn = 'CN=Admin,DC=example,DC=co,DC= zm', bind_pw = 'ADPASSWORD', 
> group_dn = 'DC= example,DC=co,DC=zm', group_name_attrib = 'cn', 
> group_member_attrib = 'member', group_filterstr = 'objectClass=Group', 
> server='xxx.xxx.xxx.xxx', base_dn='dc=example,dc=co,dc=zm')] 
> Any reason why group management is not working? Is there another way I can 
> use AD users and assign rolls to certain users?
>
> Teddy L.
>  On Oct 19, 2012 8:46 PM, "Massimo Di Pierro" 
> > 
> wrote:
>
>> Are you talking about ldap_auth?
>>
>> On Friday, 19 October 2012 02:38:39 UTC-5, software.ted wrote:
>>>
>>> I am having trouble with manage_group=True, when I enable it i am 
>>> getting "Invalid Login" but without it logins work. Does AD Group 
>>> Management in web2py work? 
>>>
>>> Kind regards, 
>>>
>>  -- 
>>  
>>  
>>  
>>
>

-- 

[web2py] Re: 2.1rc1 parse_version error

[szimszon]

In 2.1.0rc1 admin do not work.

S'Traceback (most recent call last):\n  File 
"/home/gyszabolcs/fejlesztes/web2py/gluon/main.py", line 616, in 
wsgibase\nBaseAdapter.
close_all_instances(\'rollback\')\n  File 
"/home/gyszabolcs/fejlesztes/web2py/gluon/dal.py", line 529, in 
close_all_instances\nTHREA
D_LOCAL.db_instances.clear()\nAttributeError: \'thread._local\' object has 
no attribute \'db_instances\'\n'
p4570

If you just do http://127.0.0.1:8000/admin you got error.

2012. október 8., hétfő 9:23:03 UTC+2 időpontban szimszon a következőt írta:
>
> parse_version can handle only numbers... and not rc1 :(
>
> fileutils.py line 46:
>
> re_version = re.compile('[^\d]+ 
> (\d+)\.(\d+)\.(\d+)\s*\((?P.+?)\)\s*(?P[a-z]+)?')
>

-- 

[web2py] 2.1rc1 parse_version error

[szimszon]

parse_version can handle only numbers... and not rc1 :(

fileutils.py line 46:

re_version = re.compile('[^\d]+ 
(\d+)\.(\d+)\.(\d+)\s*\((?P.+?)\)\s*(?P[a-z]+)?')

-- 

Re: [web2py] Please stop embedding Bootstrap classes in your HTML!

[szimszon]

Recently was a bit messy the SQLFORM.[smart]grid because a class changed 
from button to btn :-o

Because we need to maintain backward compatibility but the used css 
framework for welcome can change significantly I think that maintaining a 
web framework's own class names could be beneficial. So than the webapp's 
less/css can handle all web framework related class names and use it with 
recent css framework.


2012. október 4., csütörtök 15:01:11 UTC+2 időpontban Niphlod a következőt 
írta:
>
> I think the point stated is correct, but I don't remember having an html 
> template that is interoperable and modify all the looks with just only css 
> changes.
>
> Yes, zengarden is known to me and for simple pages you may have template 
> and css that are decoupable, but with standard websites it's futile to 
> develop a html template without class declarations (with javascript and 
> canvas and fonts, the thing just got worse :D)
> If only existed one standard way to interpret css rules and behaviours, 
> and only one screen size, maybe we could have arrived to decouple structure 
> from presentation completely. But we had to deal with IE back in the days, 
> now with mobiles, etc,etc,etc.
>
> I know very little about css and I use frameworks to let my site look 
> good. If I wanted it to look "cool", I'd surely go with my own styles. But 
> I'm not a web designer. And spending time to find that one css rule that 
> makes all browsers behave in the same way ... seems time wasted.
>
> Yes, less mixins are good, but I want to use "sidebar" and my css uses 
> "sidebar-left": are we sure that my convention is better than the one on 
> the framework itself (and when I'll have to change my css, will I retain 
> that name at all)?
>
> Css frameworks are used all around the web and quite all of them have 
> classes going around (960.gs, blueprint, yurb, ez, etc) so when you're 
> deploying your html you must "follow" their conventions (if you want to use 
> css frameworks at all).
>  
> I'm sure I would spend more time on re-making my own css (and tweaks, 
> copying styles around and assigning them according to my "naming 
> convention") than adopting a new css framework and adjusting my html 
> template to match the "class-naming conventions" of that framework.
>
> Additionally, if you don't write HTML by hand but you use some templating 
> system, that change in "html structure" means practically no time at all.
>
>
>

-- 

[web2py] Re: removed form.vars.{fieldname}_newfilename -- I used it :(

[szimszon]

Thanks.

2012. augusztus 30., csütörtök 15:20:05 UTC+2 időpontban Massimo Di Pierro 
a következőt írta:
>
> This is an undocumented feature. You should be able to just use 
>
> form.vars.fieldname 
>
> instead of
>
> form.vars.fieldname_newfieldname
>
> it was redundant
>
> On Thursday, 30 August 2012 05:18:52 UTC-5, szimszon wrote:
>>
>> Hi!
>>
>>
>> https://github.com/mdipierro/web2py/commit/74418b1a6962bf2db36b46f9620e16297abfd059
>>
>> I used it :(
>>
>

-- 

[web2py] crud file upload do not work :(

[szimszon]

http://code.google.com/p/web2py/issues/detail?id=966

-- 

[web2py] removed form.vars.{fieldname}_newfilename -- I used it :(

[szimszon]

Hi!

https://github.com/mdipierro/web2py/commit/74418b1a6962bf2db36b46f9620e16297abfd059

I used it :(

-- 

[web2py] Re: menu, mobile phones and tablets

[szimszon]

+1

https://groups.google.com/d/msg/web2py-developers/FMCF0HTs64A/CJ-PNCaIsuwJ

2012. augusztus 21., kedd 15:58:27 UTC+2 időpontban mweissen a következőt 
írta:
>
> I have played with some menu details and these are my results
>
> First try:
>
> response.menu = [
> (T('Home'), False, URL('default','index'), [
> (T('Dummy1'), False, URL('default','index'), [],),
> (T('Dummy2'), False, None, [],),
> (T('Desktop'), False, URL('default','index'), [], 
>not (request.user_agent().is_mobile or 
> request.user_agent().is_mobile)),
> (T('Mobile'), False, URL('default','index'), [], 
> request.user_agent().is_mobile),
> (T('Tablet'), False, URL('default','index'), [], 
> request.user_agent().is_tablet),
> ])
> ]
>
>
> *Desktop:*
> I have expected and I got:  Home | Dummy1 | Dummy2 | Desktop  (#1)
>
> *Mobile phone:*
> I have expected:
> Home | Dummy1 | Dummy2 | Mobile
>
> I got:
> Home | Dummy1 | Mobile  (#2)
>
> *Tablet:*
> I have expected:
> Home | Dummy1 | Dummy2 | Tablet
>
> I got:
> Home | Dummy1 | Mobile | Tablet  (#2, #3)
>
> Now a second try:
>
> response.menu = [
> (T('Home'), False, None, [
> (T('Dummy1'), False, URL('default','index'), [],),
> (T('Dummy2'), False, None, [],),
> (T('Desktop'), False, URL('default','index'), [], 
>not (request.user_agent().is_mobile or 
> request.user_agent().is_mobile)),
> (T('Mobile'), False, URL('default','index'), [], 
> request.user_agent().is_mobile),
> (T('Tablet'), False, URL('default','index'), [], 
> request.user_agent().is_tablet),
> ])
> ]
>
>
> *Desktop:*
> I have expected and I got:  Home | Dummy1 | Dummy2 | Desktop  (#1)
>
> *Mobile phone:*
> I have expected:
> Home | Dummy1 | Dummy2 | Mobile
>
> I got:
>   (#2, #4)
>
> *Tablet:*
> I have expected:
> Home | Dummy1 | Dummy2 | Tablet
>
> I got:
>   (#2, #4)
>
> Comments:
>
> #1: Everything works as expected, but only on a desktop pc
> #2: Menu items without a link are not displayed on a mobile device
> #3: Interesting: a tablet is a "tablet" *and *a "mobile phone"
> #4: The empty menu is very confusing. It took some hours to find it out, 
> because my "real"  menu is more complicated.
>
> Maybe #2, #3 and #4 are *features *and not *bugs*, but I think, these 
> things should be documented or changed.
> My proposal: menu items should not become invisible depending on the 
> device. If somebody wants this behavior he could use the fifth component.
>
> Maybe is_tablet should be True only for tablets and not for mobile phones 
> too. But in this case there should be not only a mobile.html view but 
> also a tablet.html. And this would make things more complicated.
>
> Regards, Martin
>
>
>
>

-- 

[web2py] auth exception with Version 2.0.0 (2012-07-04 23:30:47) dev

[szimszon]

Hi!

I'm using ldap auth and after the web2py update I get:

Traceback (most recent call last):
  File "/home/PRIMERATE.LAN/gyszabolcs/fejlesztes/web2py/gluon/restricted.py", 
line 205, in restricted
exec ccode in environment
  File 
"/home/PRIMERATE.LAN/gyszabolcs/fejlesztes/web2py/applications/webadmin/controllers/default.py",
 line 2072, in 
  File "/home/PRIMERATE.LAN/gyszabolcs/fejlesztes/web2py/gluon/globals.py", 
line 182, in 
self._caller = lambda f: f()
  File 
"/home/PRIMERATE.LAN/gyszabolcs/fejlesztes/web2py/applications/webadmin/controllers/default.py",
 line 2051, in user
return dict( form = auth() )
  File "/home/PRIMERATE.LAN/gyszabolcs/fejlesztes/web2py/gluon/tools.py", line 
1197, in __call__
return getattr(self,args[0])()
  File "/home/PRIMERATE.LAN/gyszabolcs/fejlesztes/web2py/gluon/tools.py", line 
1832, in login
if temp_user.registration_key == 'pending':
  File "/home/PRIMERATE.LAN/gyszabolcs/fejlesztes/web2py/gluon/dal.py", line 
6156, in __getattr__
return self[key]
  File "/home/PRIMERATE.LAN/gyszabolcs/fejlesztes/web2py/gluon/dal.py", line 
6147, in __getitem__
return dict.__getitem__(self, key)
KeyError: 'registration_key'



http://code.google.com/p/web2py/issues/detail?id=876

[web2py] with the new welcome app as template in mobile view some menu isn't accessible

[szimszon]

I have an app with Version 2.00.0 (2012-07-01 22:43:58) dev of welcome as 
template.

But if I browse it with a mobile all the menus with a submenu didn't get 
into the dropdown list. So I can access only the top level menus without 
submenu. :(

With a new look I can't put a link in top level menu if it has a submenu. 
Thats ok. Can that be the problem?

[web2py] Re: smartgrid look & feel with last trunk

[szimszon]

Okay. If it was intended then is should stay so... :)

2012. július 3., kedd 0:12:30 UTC+2 időpontban Anthony a következőt írta:
>
> I agree -- I think it's good to make a visual distinction between the 
> references (links) and the actions (buttons).
>
> Anthony
>
> On Monday, July 2, 2012 5:40:17 PM UTC-4, Jim S wrote:
>>
>> I personally like it the new way.  Just my 2 cents.
>>
>> -Jim
>>
>> On Monday, July 2, 2012 8:45:13 AM UTC-5, szimszon wrote:
>>>
>>> Hi!
>>>
>>> I noticed the following if you create a new app from welcome with 
>>> smartgrid then the linked table names aren't looking like buttons anymore. 
>>> And the acural table names are just a link it looks a bit odd...
>>>
>>>

[web2py] Re: smartgrid look & feel with last trunk

[szimszon]

http://code.google.com/p/web2py/issues/detail?id=870

2012. július 2., hétfő 15:45:13 UTC+2 időpontban szimszon a következőt írta:
>
> Hi!
>
> I noticed the following if you create a new app from welcome with 
> smartgrid then the linked table names aren't looking like buttons anymore. 
> And the acural table names are just a link it looks a bit odd...
>
>

[web2py] smartgrid look & feel with last trunk

[szimszon]

Hi!

I noticed the following if you create a new app from welcome with smartgrid 
then the linked table names aren't looking like buttons anymore. And the 
acural table names are just a link it looks a bit odd...

<><>

[web2py] Re: Error importing ldap_auth module

[szimszon]

common ldap utilities are working? ldapsearch and co?

2012. június 21., csütörtök 17:34:45 UTC+2 időpontban ehgonzalez a 
következőt írta:
>
> You rigth, python version is 2.6.6. I copied ldap_auth.py from trunk but 
> it's throwing same error.
>
> any ideas?
>
> El jueves, 21 de junio de 2012 10:18:43 UTC-4:30, szimszon escribió:
>>
>> Try to use ldap_auth.py from trunk. Just copy it over the old one.
>>
>> You say Python 2.7.3 but in the error there is a 
>>
>> ... python2.6/dist-packages/ldap ...
>>
>>
>> 2012. június 21., csütörtök 16:39:40 UTC+2 időpontban ehgonzalez a 
>> következőt írta:
>>>
>>> Hi,
>>>
>>> When I try to import the ldap_auth module in my db.py is throwing an 
>>> error. Here's the traceback:
>>>
>>> Traceback (most recent call last):
>>>   File "/var/www/web2pytest/gluon/restricted.py", line 205, in restricted
>>> exec ccode in environment
>>>   File "/var/www/web2pytest/applications/SMS/models/db.py" 
>>> <https://web2py-test.pdvsa.com/admin/default/edit/SMS/models/db.py>, line 
>>> 44, in 
>>> from gluon.contrib.login_methods.ldap_auth import ldap_auth
>>>   File "/var/www/web2pytest/gluon/custom_import.py", line 293, in __call__
>>> fromlist, level)
>>>   File "/var/www/web2pytest/gluon/custom_import.py", line 78, in __call__
>>> level)
>>>   File "/var/www/web2pytest/gluon/contrib/login_methods/ldap_auth.py", line 
>>> 9, in 
>>> raise e
>>> SystemError: error 89 from ldap_set_option
>>>
>>>
>>> Web2py's Shell:
>>>
>>> In [1] : import ldap
>>>
>>> In [2] : import ldap.filter
>>>
>>> In [3] : ldap.set_option( ldap.OPT_REFERRALS, 0 )
>>> Traceback (most recent call last):
>>>   File "/var/www/web2py/gluon/contrib/shell.py", line 225, in run
>>> exec compiled in statement_module.__dict__
>>>   File "", line 1, in 
>>>   File "/usr/lib/python2.6/dist-packages/ldap/functions.py", line 124, in 
>>> set_option
>>> _ldap_function_call(_ldap.set_option,option,invalue)
>>>   File "/usr/lib/python2.6/dist-packages/ldap/functions.py", line 57, in 
>>> _ldap_function_call
>>> result = func(*args,**kwargs)
>>> SystemError: error 89 from ldap_set_option
>>>
>>> Debian 6.0.5, Apache 2.2.16, WSGI 3.3-2, Python 2.7.3, , web2py 1.99.7.
>>>
>>> Any help much appreciated.
>>>
>>> Eduardo.
>>>
>>>
>>>
>>>
>>>
>>>
>>>

-- 

[web2py] Re: Error importing ldap_auth module

[szimszon]

Try to use ldap_auth.py from trunk. Just copy it over the old one.

You say Python 2.7.3 but in the error there is a 

... python2.6/dist-packages/ldap ...


2012. június 21., csütörtök 16:39:40 UTC+2 időpontban ehgonzalez a 
következőt írta:
>
> Hi,
>
> When I try to import the ldap_auth module in my db.py is throwing an 
> error. Here's the traceback:
>
> Traceback (most recent call last):
>   File "/var/www/web2pytest/gluon/restricted.py", line 205, in restricted
> exec ccode in environment
>   File "/var/www/web2pytest/applications/SMS/models/db.py" 
> , line 44, 
> in 
> from gluon.contrib.login_methods.ldap_auth import ldap_auth
>   File "/var/www/web2pytest/gluon/custom_import.py", line 293, in __call__
> fromlist, level)
>   File "/var/www/web2pytest/gluon/custom_import.py", line 78, in __call__
> level)
>   File "/var/www/web2pytest/gluon/contrib/login_methods/ldap_auth.py", line 
> 9, in 
> raise e
> SystemError: error 89 from ldap_set_option
>
>
> Web2py's Shell:
>
> In [1] : import ldap
>
> In [2] : import ldap.filter
>
> In [3] : ldap.set_option( ldap.OPT_REFERRALS, 0 )
> Traceback (most recent call last):
>   File "/var/www/web2py/gluon/contrib/shell.py", line 225, in run
> exec compiled in statement_module.__dict__
>   File "", line 1, in 
>   File "/usr/lib/python2.6/dist-packages/ldap/functions.py", line 124, in 
> set_option
> _ldap_function_call(_ldap.set_option,option,invalue)
>   File "/usr/lib/python2.6/dist-packages/ldap/functions.py", line 57, in 
> _ldap_function_call
> result = func(*args,**kwargs)
> SystemError: error 89 from ldap_set_option
>
> Debian 6.0.5, Apache 2.2.16, WSGI 3.3-2, Python 2.7.3, , web2py 1.99.7.
>
> Any help much appreciated.
>
> Eduardo.
>
>
>
>
>
>
>

-- 

Re: [web2py] Users Poll: To keep the button look for the welcome app's auth options, or not ?

[szimszon]

b.1

2012. június 17., vasárnap 8:06:54 UTC+2 időpontban encompass a következőt 
írta:
>
>  B.1 looks nice.
>
> On 06/17/2012 06:30 AM, Andrew wrote: 
>
> A  week or two ago a change was made to the nav bar to give the auth 
> buttons for Login, Register, etc   a button look.   This was part of the 
> fix to the dropdown menus to get them to work with bootstrap.  Another 
> change was made to revert back to the old look (but only as an attachment 
> to a previous post in this list).   
>
>  There are two screen shots, current welcome app, and with the buttons 
> reverted to the old look.
>
>  Credit to Paolo for making both changes.  Given that the buttons have 
> been in trunk for a while, it is worth getting a consensus to keep it or 
> revert it.  So:
>
>  *Vote:*
> *A) KEEP THE BUTTON LOOK*
> *B) REVERT TO THE OLD LOOK*
> *
> *
> *if B) *
> *
> *
> *B.1) Revert to the Pipe separator between the options (as shown)*
> *B.2) Don't include the Pipe separator.*
>
>
>  B.1) involves updating a recent patch to layout.html:
>  {{='auth' in globals() and auth.navbar(separators=(' 
> ',' | ','')) or ''}}
>  
>  A patch for B.1) has already been sent to Massimo (that's my vote :) ) , 
> but let's see what the general feeling is.
>
>  Thanks
>
>
> 

[web2py] Re: commit 2799e09d6bb4 broke backward compatibility

[szimszon]

+1

2012. június 5., kedd 22:22:44 UTC+2 időpontban Niphlod a következőt írta:
>
> The only thing coming to mind is "add" a 
> web2py-component-flash-international header in "new trunk" and check only 
> that in new web2py.js, leaving web2py-component-flash header the way it was 
> before. 
>
> Il giorno martedì 5 giugno 2012 22:17:36 UTC+2, Massimo Di Pierro ha 
> scritto:
>>
>> We cannot do that.
>>
>> Yet I agree that this improvement broke backward compatibility and needs 
>> to be reverted until we find a way to deal with intrnationalization of 
>> flash and in a backward compatible way.
>>
>>
>>
>> On Tuesday, 5 June 2012 15:02:07 UTC-5, Niphlod wrote:
>>>
>>> Hi, I'm all for supporting international flash messages, but for 
>>> applications relying on the old web2py.js (or even web2py_ajax.js) the 
>>> message appear urlencoded.
>>>
>>> That's because 
>>>
>>> *var 
>>> flash=**decodeURIComponent(**xhr.getResponseHeader('web2py-component-flash'**)**);
>>>
>>> *expects an encoded flash message (done in main.py in trunk) but if it 
>>> isn't (encoded, e.g. using the 1.99.7 version) 
>>> the old line transforming web2py-component-flash header gets the "raw" 
>>> urlencoded message i.e. shows "form%20accepted" 
>>> instead of "form accepted".
>>>
>>> Maybe a message stating that web2py.js or web2py_ajax.js of old apps needs 
>>> to be overwritten by the one in welcome 
>>> for web2py 2.0.0 will prevent angry users :P
>>>
>>>
>>>
>>>
>>>

[web2py] Re: newcron.py", line 227 AttributeError: 'list' object has no attribute 'split'

[szimszon]

I'm running it on Linux and I have nothing in cron. I use scheduler and 
linux crontab.

2012. június 11., hétfő 20:58:55 UTC+2 időpontban Niphlod a következőt írta:
>
> I'm running from source and I don't see the error, but I think I know 
> what's going on.
>
> Have you something in your applications crontab ?
>
> also, are you on linux, mac or windows ?
>
> Il giorno lunedì 11 giugno 2012 18:49:58 UTC+2, simon ha scritto:
>>
>> I also get this. It appears after the "cron fix" update to trunk.
>>
>> On Monday, 11 June 2012 14:23:20 UTC+1, szimszon wrote:
>>>
>>> It's on the console where you start the web2py.py...
>>>
>>> 2012. június 11., hétfő 14:19:45 UTC+2 időpontban szimszon a következőt 
>>> írta:
>>>>
>>>> http://code.google.com/p/web2py/issues/detail?id=849
>>>>
>>>> Exception in thread Thread-21:
>>>> Traceback (most recent call last):
>>>>   File "/usr/lib/python2.7/threading.py", line 551, in __bootstrap_inner
>>>> self.run()
>>>>   File "/home/szimszon/fejlesztes/sajat/web2py/gluon/newcron.py", line 
>>>> 227, in run
>>>> proc = subprocess.Popen(self.cmd.split(),
>>>> AttributeError: 'list' object has no attribute 'split'
>>>>
>>>> Version 2.00.0 (2012-06-10 01:18:28) dev
>>>>
>>>>
>>>>

[web2py] Re: newcron.py", line 227 AttributeError: 'list' object has no attribute 'split'

[szimszon]

It's on the console where you start the web2py.py...

2012. június 11., hétfő 14:19:45 UTC+2 időpontban szimszon a következőt 
írta:
>
> http://code.google.com/p/web2py/issues/detail?id=849
>
> Exception in thread Thread-21:
> Traceback (most recent call last):
>   File "/usr/lib/python2.7/threading.py", line 551, in __bootstrap_inner
> self.run()
>   File "/home/szimszon/fejlesztes/sajat/web2py/gluon/newcron.py", line 227, 
> in run
> proc = subprocess.Popen(self.cmd.split(),
> AttributeError: 'list' object has no attribute 'split'
>
> Version 2.00.0 (2012-06-10 01:18:28) dev
>
>
>

[web2py] newcron.py", line 227 AttributeError: 'list' object has no attribute 'split'

[szimszon]

http://code.google.com/p/web2py/issues/detail?id=849

Exception in thread Thread-21:
Traceback (most recent call last):
  File "/usr/lib/python2.7/threading.py", line 551, in __bootstrap_inner
self.run()
  File "/home/szimszon/fejlesztes/sajat/web2py/gluon/newcron.py", line 227, in 
run
proc = subprocess.Popen(self.cmd.split(),
AttributeError: 'list' object has no attribute 'split'

Version 2.00.0 (2012-06-10 01:18:28) dev

[web2py] Re: commit 2799e09d6bb4 broke backward compatibility

[szimszon]

There are sometimes "null" displayed in flash :( (Version 2.0.0 (2012-06-10 
01:18:28) dev)

2012. június 5., kedd 22:22:44 UTC+2 időpontban Niphlod a következőt írta:
>
> The only thing coming to mind is "add" a 
> web2py-component-flash-international header in "new trunk" and check only 
> that in new web2py.js, leaving web2py-component-flash header the way it was 
> before. 
>
> Il giorno martedì 5 giugno 2012 22:17:36 UTC+2, Massimo Di Pierro ha 
> scritto:
>>
>> We cannot do that.
>>
>> Yet I agree that this improvement broke backward compatibility and needs 
>> to be reverted until we find a way to deal with intrnationalization of 
>> flash and in a backward compatible way.
>>
>>
>>
>> On Tuesday, 5 June 2012 15:02:07 UTC-5, Niphlod wrote:
>>>
>>> Hi, I'm all for supporting international flash messages, but for 
>>> applications relying on the old web2py.js (or even web2py_ajax.js) the 
>>> message appear urlencoded.
>>>
>>> That's because 
>>>
>>> *var 
>>> flash=**decodeURIComponent(**xhr.getResponseHeader('web2py-component-flash'**)**);
>>>
>>> *expects an encoded flash message (done in main.py in trunk) but if it 
>>> isn't (encoded, e.g. using the 1.99.7 version) 
>>> the old line transforming web2py-component-flash header gets the "raw" 
>>> urlencoded message i.e. shows "form%20accepted" 
>>> instead of "form accepted".
>>>
>>> Maybe a message stating that web2py.js or web2py_ajax.js of old apps needs 
>>> to be overwritten by the one in welcome 
>>> for web2py 2.0.0 will prevent angry users :P
>>>
>>>
>>>
>>>
>>>

[web2py] Re: grid's web2py style cleanup

[szimszon]

I don't think so. bootstrap use button too... Using two or more css 
template system could be problematic because name collisions...

2012. június 10., vasárnap 12:01:19 UTC+2 időpontban villas a következőt 
írta:
>
> I think many of these problems are resolved by the inclusion of 
> static/css/css3buttons.css
>
>
>
> On Wednesday, June 6, 2012 1:37:51 PM UTC+1, szimszon wrote:
>>
>> Hi!
>>
>> I wonder if somebody could help to clean up sqlhtml.py's grid web2py 
>> style because there are buttons with 'button' and 'buttontext' class but 
>> the css have no visible definition for it. It should be 'btn' or something.
>>
>> I opened an issue about it in google code:
>>
>> http://code.google.com/p/web2py/issues/detail?id=840
>>
>> Thanks.
>>
>

[web2py] session in cookies

[szimszon]

Hi All!

What is the use case behind a session in cookies scenario?

Tnx.

[web2py] Re: grid's web2py style cleanup

[szimszon]

Or better the dictionary should be tied in the layout(.html) somehow. I 
think it would better than polluting the web2py core with time limited 
data... it could be a javascript / javascript variable that should set the 
right class names in layout scope. So people do not need to search and 
replace in all their code if new layout is applied.

2012. június 6., szerda 17:25:40 UTC+2 időpontban LightDot a következőt 
írta:
>
> Quite right, I forgot that the grids are experimental. Sorry, I was too 
> quick to comment in regards to backward compatibility. I missed the scope 
> of the issue anyway, since if I remember right, "ui" setting for the grid 
> is already defined as a dictionary in sqlhtml.py. With definitions such as 
> button='button', etc.
>
> So you are suggesting a new ui dictionary, predefined for the bootstrap? 
> Similar to the jquery-ui dictionary that is already in the sqlhtml.py? I 
> should have realized that sooner... And it's a great idea, of course.
>
> Regards
>
>
> On Wednesday, June 6, 2012 3:57:40 PM UTC+2, szimszon wrote:
>>
>> SQLFORM.grid and .smartgrid is experimental...
>>
>> If grid and smartgrid will use the button and buttontext class for 
>> buttons in grid with new app you have to add this class definition back 
>> manually to the new look&feel layout :(
>>
>> What if grid and smartgrid can access some resource in app layout system 
>> with class names and can adopt to the new underlying css system. 
>>
>> 2012. június 6., szerda 15:30:08 UTC+2 időpontban LightDot a következőt 
>> írta:
>>>
>>> I don't have a personal preference about this since I'm not using these 
>>> selectors in any project. But even if the default css doesn't use them, 
>>> some developer could already be using them for custom css definitions.
>>>
>>> So wouldn't this break backward compatibility of web2py?
>>>
>>> Regards
>>>
>>> On Wednesday, June 6, 2012 2:37:51 PM UTC+2, szimszon wrote:
>>>>
>>>> Hi!
>>>>
>>>> I wonder if somebody could help to clean up sqlhtml.py's grid web2py 
>>>> style because there are buttons with 'button' and 'buttontext' class but 
>>>> the css have no visible definition for it. It should be 'btn' or something.
>>>>
>>>> I opened an issue about it in google code:
>>>>
>>>> http://code.google.com/p/web2py/issues/detail?id=840
>>>>
>>>> Thanks.
>>>>
>>>

[web2py] Re: grid's web2py style cleanup

[szimszon]

SQLFORM.grid and .smartgrid is experimental...

If grid and smartgrid will use the button and buttontext class for buttons 
in grid with new app you have to add this class definition back manually to 
the new look&feel layout :(

What if grid and smartgrid can access some resource in app layout system 
with class names and can adopt to the new underlying css system. 

2012. június 6., szerda 15:30:08 UTC+2 időpontban LightDot a következőt 
írta:
>
> I don't have a personal preference about this since I'm not using these 
> selectors in any project. But even if the default css doesn't use them, 
> some developer could already be using them for custom css definitions.
>
> So wouldn't this break backward compatibility of web2py?
>
> Regards
>
> On Wednesday, June 6, 2012 2:37:51 PM UTC+2, szimszon wrote:
>>
>> Hi!
>>
>> I wonder if somebody could help to clean up sqlhtml.py's grid web2py 
>> style because there are buttons with 'button' and 'buttontext' class but 
>> the css have no visible definition for it. It should be 'btn' or something.
>>
>> I opened an issue about it in google code:
>>
>> http://code.google.com/p/web2py/issues/detail?id=840
>>
>> Thanks.
>>
>

[web2py] grid's web2py style cleanup

[szimszon]

Hi!

I wonder if somebody could help to clean up sqlhtml.py's grid web2py style 
because there are buttons with 'button' and 'buttontext' class but the css 
have no visible definition for it. It should be 'btn' or something.

I opened an issue about it in google code:

http://code.google.com/p/web2py/issues/detail?id=840

Thanks.

[web2py] Re: LOAD with ajax=True not working please help

[szimszon]

Here is what I found with help of 
http://stackoverflow.com/questions/777062/jquery-field-is-null

--- web2py.js.old2012-06-04 22:02:56.0 +0200
+++ web2py.js2012-06-06 14:12:48.546141468 +0200
@@ -104,8 +104,8 @@
 
 function web2py_component(action, target, timeout, times){
   jQuery(function(){
-var element = $("#" + target).get(0);
-var statement = "$('#" + target + "').get(0).reload();";
+var element = jQuery("#" + target).get(0);
+var statement = "jQuery('#" + target + "').get(0).reload();";
 element.reload = function (){
 // Continue if times is Infinity or
 // the times limit is not reached



2012. június 6., szerda 13:38:12 UTC+2 időpontban szimszon a következőt 
írta:
>
>
> Version 2.00.0 (2012-06-05 00:02:52) dev
>
> in layout.html {{=LOAD('default','setuser',extension='load',ajax=True)}}
>
> $("#" + target) is null @ http://127.0.0.1:8000/.../static/js/web2py.js:107
>
> without ajax=True it loads but is is working correctly only with ajax=True :(
> http://code.google.com/p/web2py/issues/detail?id=839
>
>
>

[web2py] Re: Anyone using BootSwatch with new web2py layout

[szimszon]

I have issue with dropdown menu when the main menu is a link too.

If I click on the main menu than that menu is activated and I can't access 
the items below it with any means :(

[web2py] LOAD with ajax=True not working please help

[szimszon]

Version 2.00.0 (2012-06-05 00:02:52) dev

in layout.html {{=LOAD('default','setuser',extension='load',ajax=True)}}

$("#" + target) is null @ http://127.0.0.1:8000/.../static/js/web2py.js:107

without ajax=True it loads but is is working correctly only with ajax=True :(
http://code.google.com/p/web2py/issues/detail?id=839

Re: [web2py] MailCaptcha

[szimszon]

There is now a honeypot address handling to put sender directly in to 
blacklist.


   1. somebody send you an email from someb...@domain.com
   2. postfix ask MailCaptcha what to do
   - if the recipient address is not in the protected list do nothing 
  special
  - else if the sender is in the blacklist reject the message with 5xx 
  code
  - else if the recipient address is a honeypot address put the sender 
  in the blacklist and reject the message with 5xx code
  - else if the sender is in the whitelist do nothing special
  - else if the sender is in the waiting queue the message get a 
  temporary rejection with 4xx code
  - else if the sender is not in queue then
 - put the sender address in the waiting queue
 - send a mail to the sender address with the web url where the 
 sender can solve the captcha and so the sender address is going to the 
 whitelist
 - optionally send a mail to mail system admin to notify about a 
 new sender address in the waiting queue so admin can enable the sender 
 address by hand
  3. the sender have to go to the web url and solve the captcha
   4. sender address is going to the whitelist
   5. the next time the sender's mail system (the system that hold the 
   sender's mail) try to deliver the e-mail after temporary failure can 
   deliver the message without problem
   
 

[web2py] Re: I have trouble with the new scheduler and mysql: NotSupportedError

[szimszon]

Thank you!

2012. június 4., hétfő 22:00:54 UTC+2 időpontban Niphlod a következőt írta:
>
> patched and ready for new testing..
> Thank you for your patience szimszon 
>
> Niphlod
>

[web2py] Re: I have trouble with the new scheduler and mysql: NotSupportedError

[szimszon]

already there... http://code.google.com/p/web2py/issues/detail?id=833

2012. június 4., hétfő 17:39:52 UTC+2 időpontban Massimo Di Pierro a 
következőt írta:
>
> Thank you. Please upload the patch in a google code issue. Less changes of 
> me forgetting or doing a mistake. ;-)
>
> On Monday, 4 June 2012 04:00:05 UTC-5, szimszon wrote:
>>
>> Prev. patch wasn't good, here it is:
>>
>> --- scheduler.py.old2012-06-02 14:44:26.0 +0200
>> +++ scheduler.py2012-06-04 10:53:59.013899780 +0200
>> @@ -417,13 +417,13 @@
>>  return None
>>  grabbed = db(ts.assigned_worker_name==self.worker_name)\
>>  (ts.status==ASSIGNED)
>> -task_id = grabbed._select(ts.id, limitby=(0,1), orderby=ts.
>> next_run_time)
>> -updated = db(
>> -ts.id.belongs(task_id)
>> -).update(status=RUNNING,last_run_time=now) #reduces 
>> collisions?
>> -#noone will touch my task!
>> -db.commit()
>> -if updated:
>> +task_row = grabbed.select(ts.id, limitby=(0,1), orderby=ts.
>> next_run_time).first()
>> +if task_row:
>> +updated = db(
>> +ts.id==task_row.id
>> +).update(status=RUNNING,last_run_time=now) #reduces 
>> collisions?
>> +#noone will touch my task!
>> +db.commit()
>>  logging.debug('   work to do %s' % updated)
>>  task = db(ts.assigned_worker_name==self.worker_name)\
>>  (ts.status==RUNNING).select().first()
>>
>>
>>
>>
>>
>> 2012. június 4., hétfő 9:47:29 UTC+2 időpontban szimszon a következőt 
>> írta:
>>>
>>> http://code.google.com/p/web2py/issues/detail?id=833
>>>
>>> After upgrading to Version 2.0.0 (2012-06-02 16:44:25) dev I got this if I 
>>> start scheduler:
>>>
>>> Currently running 1 scheduler processes
>>> Processes started
>>> 2012-06-04 09:40:47,874 - root - DEBUG - defining tables (migrate=True)
>>> 2012-06-04 09:40:47,880 - root - DEBUG - thread building own DAL object
>>> 2012-06-04 09:40:47,880 - root - DEBUG - looping...
>>> 2012-06-04 09:40:47,883 - root - DEBUG - defining tables (migrate=False)
>>> 2012-06-04 09:40:47,886 - root - DEBUG - recording heartbeat
>>> 2012-06-04 09:40:47,887 - root - DEBUG - freeing workers that have not 
>>> sent heartbeat
>>> 2012-06-04 09:40:47,889 - root - INFO - TICKER: I'm a ticker 
>>> (info-szimszon#709cdf44-805a-41a5-b197-8aa124acf311)
>>> Traceback (most recent call last):
>>>   File "/home/PRIMERATE.LAN/gyszabolcs/fejlesztes/web2py/gluon/shell.py", 
>>> line 219, in run
>>> exec(python_code, _env)
>>>   File "", line 1, in 
>>>   File 
>>> "/home/PRIMERATE.LAN/gyszabolcs/fejlesztes/web2py/gluon/scheduler.py", line 
>>> 398, in loop
>>> MetaScheduler.loop(self)
>>>   File 
>>> "/home/PRIMERATE.LAN/gyszabolcs/fejlesztes/web2py/gluon/scheduler.py", line 
>>> 279, in loop
>>> task = self.pop_task()
>>>   File 
>>> "/home/PRIMERATE.LAN/gyszabolcs/fejlesztes/web2py/gluon/scheduler.py", line 
>>> 423, in pop_task
>>> ).update(status=RUNNING,last_run_time=now) #reduces collisions?
>>>   File "/home/PRIMERATE.LAN/gyszabolcs/fejlesztes/web2py/gluon/dal.py", 
>>> line 8147, in update
>>> if any(f(self,update_fields) for f in table._before_update): return 0
>>>   File "/home/PRIMERATE.LAN/gyszabolcs/fejlesztes/web2py/gluon/dal.py", 
>>> line 8147, in 
>>> if any(f(self,update_fields) for f in table._before_update): return 0
>>>   File "/home/PRIMERATE.LAN/gyszabolcs/fejlesztes/web2py/gluon/dal.py", 
>>> line 7051, in 
>>> archive_record(qset,fs,at,cn))
>>>   File "/home/PRIMERATE.LAN/gyszabolcs/fejlesztes/web2py/gluon/dal.py", 
>>> line 7450, in archive_record
>>> for row in qset.select():
>>>   File "/home/PRIMERATE.LAN/gyszabolcs/fejlesztes/web2py/gluon/dal.py", 
>>> line 8130, in select
>>> return adapter.select(self.query,fields,attributes)
>>>   File "/home/PRIMERATE.LAN/gyszabolcs/fejlesztes/web2py/gluon/dal.py", 
>>> line 1400, in select
>>> rows = response(sql)
>>>   File "/home/PRIMERATE.LAN/gyszabolcs/fejlesztes/web2py/gluon/dal.py", 
>>> line 1390, in response
>>> self.execute(sql)
>>>   File "/home/PRIMERATE.LAN/gyszabolcs/fejlesztes/web2py/gluon/dal.py", 
>>> line 1479, in execute
>>> return self.log_execute(*a, **b)
>>>   File "/home/PRIMERATE.LAN/gyszabolcs/fejlesztes/web2py/gluon/dal.py", 
>>> line 1473, in log_execute
>>> ret = self.cursor.execute(*a, **b)
>>>   File 
>>> "/home/PRIMERATE.LAN/gyszabolcs/fejlesztes/web2py/gluon/contrib/pymysql/cursors.py",
>>>  line 108, in execute
>>> self.errorhandler(self, exc, value)
>>>   File 
>>> "/home/PRIMERATE.LAN/gyszabolcs/fejlesztes/web2py/gluon/contrib/pymysql/connections.py",
>>>  line 184, in defaulterrorhandler
>>> raise errorclass, errorvalue
>>> NotSupportedError: (1235, u"This version of MySQL doesn't yet support 
>>> 'LIMIT & IN/ALL/ANY/SOME subquery'")
>>>
>>>
>>>

[web2py] Re: I have trouble with the new scheduler and mysql: NotSupportedError

[szimszon]

Prev. patch wasn't good, here it is:

--- scheduler.py.old2012-06-02 14:44:26.0 +0200
+++ scheduler.py2012-06-04 10:53:59.013899780 +0200
@@ -417,13 +417,13 @@
 return None
 grabbed = db(ts.assigned_worker_name==self.worker_name)\
 (ts.status==ASSIGNED)
-task_id = grabbed._select(ts.id, limitby=(0,1), orderby=ts.
next_run_time)
-updated = db(
-ts.id.belongs(task_id)
-).update(status=RUNNING,last_run_time=now) #reduces collisions?
-#noone will touch my task!
-db.commit()
-if updated:
+task_row = grabbed.select(ts.id, limitby=(0,1), orderby=ts.
next_run_time).first()
+if task_row:
+updated = db(
+ts.id==task_row.id
+).update(status=RUNNING,last_run_time=now) #reduces 
collisions?
+#noone will touch my task!
+db.commit()
 logging.debug('   work to do %s' % updated)
 task = db(ts.assigned_worker_name==self.worker_name)\
 (ts.status==RUNNING).select().first()





2012. június 4., hétfő 9:47:29 UTC+2 időpontban szimszon a következőt írta:
>
> http://code.google.com/p/web2py/issues/detail?id=833
>
> After upgrading to Version 2.0.0 (2012-06-02 16:44:25) dev I got this if I 
> start scheduler:
>
> Currently running 1 scheduler processes
> Processes started
> 2012-06-04 09:40:47,874 - root - DEBUG - defining tables (migrate=True)
> 2012-06-04 09:40:47,880 - root - DEBUG - thread building own DAL object
> 2012-06-04 09:40:47,880 - root - DEBUG - looping...
> 2012-06-04 09:40:47,883 - root - DEBUG - defining tables (migrate=False)
> 2012-06-04 09:40:47,886 - root - DEBUG - recording heartbeat
> 2012-06-04 09:40:47,887 - root - DEBUG - freeing workers that have not 
> sent heartbeat
> 2012-06-04 09:40:47,889 - root - INFO - TICKER: I'm a ticker 
> (info-szimszon#709cdf44-805a-41a5-b197-8aa124acf311)
> Traceback (most recent call last):
>   File "/home/PRIMERATE.LAN/gyszabolcs/fejlesztes/web2py/gluon/shell.py", 
> line 219, in run
> exec(python_code, _env)
>   File "", line 1, in 
>   File "/home/PRIMERATE.LAN/gyszabolcs/fejlesztes/web2py/gluon/scheduler.py", 
> line 398, in loop
> MetaScheduler.loop(self)
>   File "/home/PRIMERATE.LAN/gyszabolcs/fejlesztes/web2py/gluon/scheduler.py", 
> line 279, in loop
> task = self.pop_task()
>   File "/home/PRIMERATE.LAN/gyszabolcs/fejlesztes/web2py/gluon/scheduler.py", 
> line 423, in pop_task
> ).update(status=RUNNING,last_run_time=now) #reduces collisions?
>   File "/home/PRIMERATE.LAN/gyszabolcs/fejlesztes/web2py/gluon/dal.py", line 
> 8147, in update
> if any(f(self,update_fields) for f in table._before_update): return 0
>   File "/home/PRIMERATE.LAN/gyszabolcs/fejlesztes/web2py/gluon/dal.py", line 
> 8147, in 
> if any(f(self,update_fields) for f in table._before_update): return 0
>   File "/home/PRIMERATE.LAN/gyszabolcs/fejlesztes/web2py/gluon/dal.py", line 
> 7051, in 
> archive_record(qset,fs,at,cn))
>   File "/home/PRIMERATE.LAN/gyszabolcs/fejlesztes/web2py/gluon/dal.py", line 
> 7450, in archive_record
> for row in qset.select():
>   File "/home/PRIMERATE.LAN/gyszabolcs/fejlesztes/web2py/gluon/dal.py", line 
> 8130, in select
> return adapter.select(self.query,fields,attributes)
>   File "/home/PRIMERATE.LAN/gyszabolcs/fejlesztes/web2py/gluon/dal.py", line 
> 1400, in select
> rows = response(sql)
>   File "/home/PRIMERATE.LAN/gyszabolcs/fejlesztes/web2py/gluon/dal.py", line 
> 1390, in response
> self.execute(sql)
>   File "/home/PRIMERATE.LAN/gyszabolcs/fejlesztes/web2py/gluon/dal.py", line 
> 1479, in execute
> return self.log_execute(*a, **b)
>   File "/home/PRIMERATE.LAN/gyszabolcs/fejlesztes/web2py/gluon/dal.py", line 
> 1473, in log_execute
> ret = self.cursor.execute(*a, **b)
>   File 
> "/home/PRIMERATE.LAN/gyszabolcs/fejlesztes/web2py/gluon/contrib/pymysql/cursors.py",
>  line 108, in execute
> self.errorhandler(self, exc, value)
>   File 
> "/home/PRIMERATE.LAN/gyszabolcs/fejlesztes/web2py/gluon/contrib/pymysql/connections.py",
>  line 184, in defaulterrorhandler
> raise errorclass, errorvalue
> NotSupportedError: (1235, u"This version of MySQL doesn't yet support 'LIMIT 
> & IN/ALL/ANY/SOME subquery'")
>
>
>

[web2py] Re: I have trouble with the new scheduler and mysql: NotSupportedError

[szimszon]

Here is a quick patch need testing:

--- scheduler.py.old2012-06-02 14:44:26.0 +0200
+++ scheduler.py2012-06-04 10:46:35.557913663 +0200
@@ -417,13 +417,13 @@
 return None
 grabbed = db(ts.assigned_worker_name==self.worker_name)\
 (ts.status==ASSIGNED)
-task_id = grabbed._select(ts.id, limitby=(0,1), 
orderby=ts.next_run_time)
-updated = db(
-ts.id.belongs(task_id)
-).update(status=RUNNING,last_run_time=now) #reduces collisions?
-#noone will touch my task!
-db.commit()
-if updated:
+task_row = grabbed.select(ts.id, limitby=(0,1), 
orderby=ts.next_run_time).first()
+if task_row:
+updated = db(
+ts.id.belongs(task_row.id)
+).update(status=RUNNING,last_run_time=now) #reduces collisions?
+#noone will touch my task!
+db.commit()
 logging.debug('   work to do %s' % updated)
 task = db(ts.assigned_worker_name==self.worker_name)\
 (ts.status==RUNNING).select().first()






2012. június 4., hétfő 9:47:29 UTC+2 időpontban szimszon a következőt írta:
>
> http://code.google.com/p/web2py/issues/detail?id=833
>
> After upgrading to Version 2.0.0 (2012-06-02 16:44:25) dev I got this if I 
> start scheduler:
>
> Currently running 1 scheduler processes
> Processes started
> 2012-06-04 09:40:47,874 - root - DEBUG - defining tables (migrate=True)
> 2012-06-04 09:40:47,880 - root - DEBUG - thread building own DAL object
> 2012-06-04 09:40:47,880 - root - DEBUG - looping...
> 2012-06-04 09:40:47,883 - root - DEBUG - defining tables (migrate=False)
> 2012-06-04 09:40:47,886 - root - DEBUG - recording heartbeat
> 2012-06-04 09:40:47,887 - root - DEBUG - freeing workers that have not 
> sent heartbeat
> 2012-06-04 09:40:47,889 - root - INFO - TICKER: I'm a ticker 
> (info-szimszon#709cdf44-805a-41a5-b197-8aa124acf311)
> Traceback (most recent call last):
>   File "/home/PRIMERATE.LAN/gyszabolcs/fejlesztes/web2py/gluon/shell.py", 
> line 219, in run
> exec(python_code, _env)
>   File "", line 1, in 
>   File "/home/PRIMERATE.LAN/gyszabolcs/fejlesztes/web2py/gluon/scheduler.py", 
> line 398, in loop
> MetaScheduler.loop(self)
>   File "/home/PRIMERATE.LAN/gyszabolcs/fejlesztes/web2py/gluon/scheduler.py", 
> line 279, in loop
> task = self.pop_task()
>   File "/home/PRIMERATE.LAN/gyszabolcs/fejlesztes/web2py/gluon/scheduler.py", 
> line 423, in pop_task
> ).update(status=RUNNING,last_run_time=now) #reduces collisions?
>   File "/home/PRIMERATE.LAN/gyszabolcs/fejlesztes/web2py/gluon/dal.py", line 
> 8147, in update
> if any(f(self,update_fields) for f in table._before_update): return 0
>   File "/home/PRIMERATE.LAN/gyszabolcs/fejlesztes/web2py/gluon/dal.py", line 
> 8147, in 
> if any(f(self,update_fields) for f in table._before_update): return 0
>   File "/home/PRIMERATE.LAN/gyszabolcs/fejlesztes/web2py/gluon/dal.py", line 
> 7051, in 
> archive_record(qset,fs,at,cn))
>   File "/home/PRIMERATE.LAN/gyszabolcs/fejlesztes/web2py/gluon/dal.py", line 
> 7450, in archive_record
> for row in qset.select():
>   File "/home/PRIMERATE.LAN/gyszabolcs/fejlesztes/web2py/gluon/dal.py", line 
> 8130, in select
> return adapter.select(self.query,fields,attributes)
>   File "/home/PRIMERATE.LAN/gyszabolcs/fejlesztes/web2py/gluon/dal.py", line 
> 1400, in select
> rows = response(sql)
>   File "/home/PRIMERATE.LAN/gyszabolcs/fejlesztes/web2py/gluon/dal.py", line 
> 1390, in response
> self.execute(sql)
>   File "/home/PRIMERATE.LAN/gyszabolcs/fejlesztes/web2py/gluon/dal.py", line 
> 1479, in execute
> return self.log_execute(*a, **b)
>   File "/home/PRIMERATE.LAN/gyszabolcs/fejlesztes/web2py/gluon/dal.py", line 
> 1473, in log_execute
> ret = self.cursor.execute(*a, **b)
>   File 
> "/home/PRIMERATE.LAN/gyszabolcs/fejlesztes/web2py/gluon/contrib/pymysql/cursors.py",
>  line 108, in execute
> self.errorhandler(self, exc, value)
>   File 
> "/home/PRIMERATE.LAN/gyszabolcs/fejlesztes/web2py/gluon/contrib/pymysql/connections.py",
>  line 184, in defaulterrorhandler
> raise errorclass, errorvalue
> NotSupportedError: (1235, u"This version of MySQL doesn't yet support 'LIMIT 
> & IN/ALL/ANY/SOME subquery'")
>
>
>

[web2py] I have trouble with the new scheduler and mysql: NotSupportedError

[szimszon]

http://code.google.com/p/web2py/issues/detail?id=833

After upgrading to Version 2.0.0 (2012-06-02 16:44:25) dev I got this if I 
start scheduler:

Currently running 1 scheduler processes
Processes started
2012-06-04 09:40:47,874 - root - DEBUG - defining tables (migrate=True)
2012-06-04 09:40:47,880 - root - DEBUG - thread building own DAL object
2012-06-04 09:40:47,880 - root - DEBUG - looping...
2012-06-04 09:40:47,883 - root - DEBUG - defining tables (migrate=False)
2012-06-04 09:40:47,886 - root - DEBUG - recording heartbeat
2012-06-04 09:40:47,887 - root - DEBUG - freeing workers that have not sent 
heartbeat
2012-06-04 09:40:47,889 - root - INFO - TICKER: I'm a ticker 
(info-szimszon#709cdf44-805a-41a5-b197-8aa124acf311)
Traceback (most recent call last):
  File "/home/PRIMERATE.LAN/gyszabolcs/fejlesztes/web2py/gluon/shell.py", line 
219, in run
exec(python_code, _env)
  File "", line 1, in 
  File "/home/PRIMERATE.LAN/gyszabolcs/fejlesztes/web2py/gluon/scheduler.py", 
line 398, in loop
MetaScheduler.loop(self)
  File "/home/PRIMERATE.LAN/gyszabolcs/fejlesztes/web2py/gluon/scheduler.py", 
line 279, in loop
task = self.pop_task()
  File "/home/PRIMERATE.LAN/gyszabolcs/fejlesztes/web2py/gluon/scheduler.py", 
line 423, in pop_task
).update(status=RUNNING,last_run_time=now) #reduces collisions?
  File "/home/PRIMERATE.LAN/gyszabolcs/fejlesztes/web2py/gluon/dal.py", line 
8147, in update
if any(f(self,update_fields) for f in table._before_update): return 0
  File "/home/PRIMERATE.LAN/gyszabolcs/fejlesztes/web2py/gluon/dal.py", line 
8147, in 
if any(f(self,update_fields) for f in table._before_update): return 0
  File "/home/PRIMERATE.LAN/gyszabolcs/fejlesztes/web2py/gluon/dal.py", line 
7051, in 
archive_record(qset,fs,at,cn))
  File "/home/PRIMERATE.LAN/gyszabolcs/fejlesztes/web2py/gluon/dal.py", line 
7450, in archive_record
for row in qset.select():
  File "/home/PRIMERATE.LAN/gyszabolcs/fejlesztes/web2py/gluon/dal.py", line 
8130, in select
return adapter.select(self.query,fields,attributes)
  File "/home/PRIMERATE.LAN/gyszabolcs/fejlesztes/web2py/gluon/dal.py", line 
1400, in select
rows = response(sql)
  File "/home/PRIMERATE.LAN/gyszabolcs/fejlesztes/web2py/gluon/dal.py", line 
1390, in response
self.execute(sql)
  File "/home/PRIMERATE.LAN/gyszabolcs/fejlesztes/web2py/gluon/dal.py", line 
1479, in execute
return self.log_execute(*a, **b)
  File "/home/PRIMERATE.LAN/gyszabolcs/fejlesztes/web2py/gluon/dal.py", line 
1473, in log_execute
ret = self.cursor.execute(*a, **b)
  File 
"/home/PRIMERATE.LAN/gyszabolcs/fejlesztes/web2py/gluon/contrib/pymysql/cursors.py",
 line 108, in execute
self.errorhandler(self, exc, value)
  File 
"/home/PRIMERATE.LAN/gyszabolcs/fejlesztes/web2py/gluon/contrib/pymysql/connections.py",
 line 184, in defaulterrorhandler
raise errorclass, errorvalue
NotSupportedError: (1235, u"This version of MySQL doesn't yet support 'LIMIT & 
IN/ALL/ANY/SOME subquery'")

[web2py] Re: MailCaptcha

[szimszon]

Agree.

On Friday, May 25, 2012 6:04:22 AM UTC+2, Massimo Di Pierro wrote:
>
> We need a way to post apps like this. Perhaps a subsection of poweredby 
> for apps with may not be deployed but are available for download.
>
> On Thursday, 24 May 2012 17:00:43 UTC-5, szimszon wrote:
>>
>> Hi All!
>>
>> I made a little app to be able to filter spam with recaptcha.
>>
>> MailCaptcha
>> ===
>>
>> For e-mail address protection with recaptcha for postfix.
>>
>> If somebody send an e-mail to a protected address the MailCaptcha
>> defer it with 4xx temporary failure and send an e-mail to the
>> sender with the URL where the sender can solve the captcha and get
>> their e-mail address to the whitelist. After that the mail system
>> is accepting the e-mail address.
>>
>> There is a
>> * whitelist
>> * blacklist
>> * notification to the mail system administrator
>> * sent mail can be signed with x.509 certificate
>>
>> Requirements
>> 
>>
>> * web2py 1.99.7 (http://web2py.com)
>> * postfix (http://postfix.com)
>>
>>
>> https://github.com/szimszon/web2py_mailcaptcha
>>
>

Re: [web2py] MailCaptcha

[szimszon]

The right order: (sorry)

   1. somebody send you an email from someb...@domain.com
   2. postfix ask MailCaptcha what to do
  - if the recipient address is not in the protected list do nothing 
  special
  - *else if the sender is in the blacklist reject the message with 5xx 
  code*
  - *else if the sender is in the whitelist do nothing special*
  - else if the sender is in the waiting queue the message get a 
  temporary rejection with 4xx code
  - else if the sender is not in queue then
 - put the sender address in the waiting queue
 - send a mail to the sender address with the web url where the 
 sender can solve the captcha and so the sender address is going to the 
 whitelist
 - optionally send a mail to mail system admin to notify about a 
 new sender address in the waiting queue so admin can enable the sender 
 address by hand
  3. the sender have to go to the web url and solve the captcha
   4. sender address is going to the whitelist
   5. the next time the sender's mail system (the system that hold the 
   sender's mail) try to deliver the e-mail after temporary failure can 
   deliver the message without problem
   
 

Re: [web2py] MailCaptcha

[szimszon]

On Friday, May 25, 2012 12:54:42 AM UTC+2, Ricardo Pedroso wrote:
>
> On Thu, May 24, 2012 at 11:00 PM, szimszon  wrote: 
>
>
> > MailCaptcha 
> > === 
> > 
> > For e-mail address protection with recaptcha for postfix. 
>
> I'm not understand how this works, but I feel that is an interesting idea. 
>  

Can you specify a use case? 
>


   1. somebody send you an email from someb...@domain.com
   2. postfix ask MailCaptcha what to do
  - if the recipient address is not in the protected list do nothing 
  special
  - else if the sender is in the whitelist do nothing special
  - else if the sender is in the blacklist reject the message with 5xx 
  code
  - else if the sender is in the waiting queue the message get a 
  temporary rejection with 4xx code
  - else if the sender is not in queue then
 - put the sender address in the waiting queue
 - send a mail to the sender address with the web url where the 
 sender can solve the captcha and so the sender address is going to the 
 whitelist
 - optionally send a mail to mail system admin to notify about a 
 new sender address in the waiting queue so admin can enable the sender 
 address by hand
  3. the sender have to go to the web url and solve the captcha
   4. sender address is going to the whitelist
   5. the next time the sender's mail system (the system that hold the 
   sender's mail) try to deliver the e-mail after temporary failure can 
   deliver the message without problem
   
 

> Why and how is tied to postfix? 
>
> It's a postfix policy daemon. Here is the doc:  
http://www.postfix.org/SMTPD_POLICY_README.html
It receives over tcp message envelope header parameter and based the 
recipient and sender parameter ask postfix to do accept, tem. reject, 
reject...

> 
> > If somebody send an e-mail to a protected address the MailCaptcha 
> > defer it with 4xx temporary failure and send an e-mail to the 
> > sender with the URL where the sender can solve the captcha and get 
> > their e-mail address to the whitelist. After that the mail system 
> > is accepting the e-mail address. 
> > 
> > There is a 
> > * whitelist 
> > * blacklist 
>
> Are these lists defined in postfix side or web2py side?


 It's in web2py's side.


>
> By the way, I was trying to browse the code via github but you are using 
> tabs for indentation, making a litter bit harder to follow the code. 
>

Sorry for that I'm used to make code indention with tabs. :-o
 

>
> Ricardo 
>

The main idea is from:
 http://www.kfki.hu/cnc/projekt/postfilter/indexeng.html
 http://www.kfki.hu/cnc/projekt/postfilter/docs/README.txt

[web2py] MailCaptcha

[szimszon]

Hi All!

I made a little app to be able to filter spam with recaptcha.

MailCaptcha
===

For e-mail address protection with recaptcha for postfix.

If somebody send an e-mail to a protected address the MailCaptcha
defer it with 4xx temporary failure and send an e-mail to the
sender with the URL where the sender can solve the captcha and get
their e-mail address to the whitelist. After that the mail system
is accepting the e-mail address.

There is a
* whitelist
* blacklist
* notification to the mail system administrator
* sent mail can be signed with x.509 certificate

Requirements


* web2py 1.99.7 (http://web2py.com)
* postfix (http://postfix.com)


https://github.com/szimszon/web2py_mailcaptcha

[web2py] Re: OverflowError: long int too large to convert to int (SQLFORM.grid)

[szimszon]

Sorry, invalid.

2012. május 21., hétfő 12:21:29 UTC+2 időpontban szimszon a következőt írta:
>
>   File "applications/szegedarchive/compiled/controllers_default_index.py", 
> line 127, in index
>   File "/srv/web2py/gluon/sqlhtml.py", line 1905, in grid
> tr.append(TD(link['body'](row)))
>   File "applications/szegedarchive/compiled/controllers_default_index.py", 
> line 120, in 
>   File "/srv/web2py/gluon/dal.py", line 6851, in __getattr__
> self.__allocate()
>   File "/srv/web2py/gluon/dal.py", line 6844, in __allocate
> self._record = self._table[int(self)]
>   File "/srv/web2py/gluon/dal.py", line 7119, in __getitem__
> return self._db(self._id == key).select(limitby=(0,1)).first()
>   File "/srv/web2py/gluon/dal.py", line 8110, in select
> return adapter.select(self.query,fields,attributes)
>   File "/srv/web2py/gluon/dal.py", line 1402, in select
> return processor(rows,fields,self._colnames)
>   File "/srv/web2py/gluon/dal.py", line 1704, in parse
> self.parse_value(value,field.type,blob_decode)
>   File "/srv/web2py/gluon/dal.py", line 1581, in parse_value
> return self.parsemap[key](value,field_type)
>   File "/srv/web2py/gluon/dal.py", line 1586, in parse_reference
> value = Reference(value)
> OverflowError: long int too large to convert to int
> http://code.google.com/p/web2py/issues/detail?id=815
>
>

[web2py] OverflowError: long int too large to convert to int (SQLFORM.grid)

[szimszon]

  File "applications/szegedarchive/compiled/controllers_default_index.py", line 
127, in index
  File "/srv/web2py/gluon/sqlhtml.py", line 1905, in grid
tr.append(TD(link['body'](row)))
  File "applications/szegedarchive/compiled/controllers_default_index.py", line 
120, in 
  File "/srv/web2py/gluon/dal.py", line 6851, in __getattr__
self.__allocate()
  File "/srv/web2py/gluon/dal.py", line 6844, in __allocate
self._record = self._table[int(self)]
  File "/srv/web2py/gluon/dal.py", line 7119, in __getitem__
return self._db(self._id == key).select(limitby=(0,1)).first()
  File "/srv/web2py/gluon/dal.py", line 8110, in select
return adapter.select(self.query,fields,attributes)
  File "/srv/web2py/gluon/dal.py", line 1402, in select
return processor(rows,fields,self._colnames)
  File "/srv/web2py/gluon/dal.py", line 1704, in parse
self.parse_value(value,field.type,blob_decode)
  File "/srv/web2py/gluon/dal.py", line 1581, in parse_value
return self.parsemap[key](value,field_type)
  File "/srv/web2py/gluon/dal.py", line 1586, in parse_reference
value = Reference(value)
OverflowError: long int too large to convert to int
http://code.google.com/p/web2py/issues/detail?id=815

[web2py] Re: Little problem with scheduler_task - has no signature Fields

[szimszon]

Wrong project. Sorry.

http://code.google.com/p/web2py/issues/detail?id=814

2012. május 21., hétfő 8:40:43 UTC+2 időpontban szimszon a következőt írta:
>
> Here it is: http://code.google.com/p/osmand/issues/detail?id=1012
>
> Thank you!
>
> 2012. május 20., vasárnap 23:19:33 UTC+2 időpontban Massimo Di Pierro a 
> következőt írta:
>>
>> Please open a ticket about this. We can add options to add fields to 
>> scheduler tables.
>>
>> On Friday, 18 May 2012 03:43:38 UTC-5, szimszon wrote:
>>>
>>> Hi!
>>>
>>> I wonder if somebody could help me.
>>>
>>> I have to audit scheduler_task 
>>> db.scheduler_task._enable_record_versioning() works but scheduler_task have 
>>> no Created On, By and Modified On, By (is_active) Fields :(
>>>
>>> Can we put this Fields in it?
>>>
>>

[web2py] signature field's label should be translatable and _archive.current_record too...

[szimszon]

Hi All!

I think it could be good to have auth.signature. ... .label wrapped with 
T(). And  _archive.current_record too...

Thanks! 

http://code.google.com/p/web2py/issues/detail?id=812
http://code.google.com/p/web2py/issues/detail?id=813

[web2py] Re: Little problem with scheduler_task - has no signature Fields

[szimszon]

Here it is: http://code.google.com/p/osmand/issues/detail?id=1012

Thank you!

2012. május 20., vasárnap 23:19:33 UTC+2 időpontban Massimo Di Pierro a 
következőt írta:
>
> Please open a ticket about this. We can add options to add fields to 
> scheduler tables.
>
> On Friday, 18 May 2012 03:43:38 UTC-5, szimszon wrote:
>>
>> Hi!
>>
>> I wonder if somebody could help me.
>>
>> I have to audit scheduler_task 
>> db.scheduler_task._enable_record_versioning() works but scheduler_task have 
>> no Created On, By and Modified On, By (is_active) Fields :(
>>
>> Can we put this Fields in it?
>>
>

[web2py] Re: Little problem with scheduler_task - has no signature Fields

[szimszon]

There are users they can  trigger scheduled tasks and I need to audit it. 
I'll try what you say. And report back.

2012. május 18., péntek 17:56:19 UTC+2 időpontban Niphlod a következőt írta:
>
> you can put them on like in every table, and then prevent the scheduler 
> migrating the table setting migrate=False in its call.
> There should be no problems on that, but a big problem arises : the 
> scheduler_task table will likely to have multiple copies of the same task 
> (auditing works in that way, setting to "is_active" only the last version 
> of the record but keeping the entire history) and will try to execute all 
> of them.
>
> anyway, why do you need to audit the task table ?
>
> Il giorno venerdì 18 maggio 2012 10:43:38 UTC+2, szimszon ha scritto:
>>
>> Hi!
>>
>> I wonder if somebody could help me.
>>
>> I have to audit scheduler_task 
>> db.scheduler_task._enable_record_versioning() works but scheduler_task have 
>> no Created On, By and Modified On, By (is_active) Fields :(
>>
>> Can we put this Fields in it?
>>
>

[web2py] Little problem with scheduler_task - has no signature Fields

[szimszon]

Hi!

I wonder if somebody could help me.

I have to audit scheduler_task 
db.scheduler_task._enable_record_versioning() works but scheduler_task have 
no Created On, By and Modified On, By (is_active) Fields :(

Can we put this Fields in it?

[web2py] Re: mailing with pgp

[szimszon]

Is there any progress? Are you able to use it?

2012. április 27., péntek 23:06:40 UTC+2 időpontban szimszon a következőt 
írta:
>
> What distrib is this?
> What is the content of GPGKEY?
>
> The list is from python shell or from web2py?
>
> 2012. április 27., péntek 17:34:06 UTC+2 időpontban weheh a következőt 
> írta:
>>
>> os.environ listing:
>>  
>>
>>> LANG
>>>> TERM
>>>> SHELL
>>>> LESSCLOSE
>>>> XDG_SESSION_COOKIE
>>>> SHLVL
>>>> SSH_TTY
>>>> OLDPWD
>>>> GPGKEY
>>>> PWD
>>>> LESSOPEN
>>>> SSH_CLIENT
>>>> LOGNAME
>>>> USER
>>>> PATH
>>>> MAIL
>>>> LS_COLORS
>>>> HOME
>>>> _
>>>> SSH_CONNECTION
>>>>
>>>>

Re: [web2py] Need a little help in code review (a function eating up all memory)

[szimszon]

I had only to reach that count of browser request :-D

Re: [web2py] Need a little help in code review (a function eating up all memory)

[szimszon]

OK. Finally I have it :)

It was only the amount of memory it was consumed each time. I tried it with 
a smaller but a significant number of records and finally I figured out 
that there is a limit and after that memory consumption  is ok. I had only 
reach that count of browser request :-D

Sorry for your time and thanks for help. =-<>-=

2012. május 11., péntek 9:30:28 UTC+2 időpontban szimszon a következőt írta:
>
> The problem is not that if I call the controller function if consumes 
> memory. My problem is that there is something that still reference 
> something after the execution is finished so the consumed memory never get 
> released / reused...
>
> 2012. május 10., csütörtök 23:27:32 UTC+2 időpontban Martin.Mulone a 
> következőt írta:
>>
>> The problem is fetchall(), is getting all the records to memory.
>> If you want to iterate a large dataset or not so heavy, but have a table 
>> with many fields, perhaps you can do it by blocks.
>>
>> For example using raw sql with dal: example: this fetch by 1000 records
>>
>> queryraw = "select * from mytable %(limit_query)s"
>> def records(query):
>> rows = db.executesql(query)
>> if rows:
>> return True
>> else:
>> return False
>>
>> rec = 0
>> stage = 0
>> block = 1000while True:
>> offset = stage * block
>> query = queryraw % {'limitquery': 'LIMIT %s, %s' % (offset, block)}
>> if not records(query):
>> break
>>
>> rows = db.executesql(query)
>> for row in rows:
>> rec += 1
>> # do something
>> 
>> stage += 1
>>
>> This is not fast but keep memory low.
>>
>>
>> 2012/5/10 szimszon 
>>
>>> Could it be related?  
>>> https://groups.google.com/forum/#!topic/web2py/hmsupVHdDHo/discussion 
>>> (Memory 
>>> leak in standalone DAL (issue #731), can you please help test?)
>>>
>>> 2012. május 10., csütörtök 22:32:53 UTC+2 időpontban szimszon a 
>>> következőt írta:
>>>
>>>> Okay. It's clear.
>>>>
>>>> I'm only puzzled about why the memory didn't get freed or reused after 
>>>> execution is finished. And if I execute the controller function in 1-2min 
>>>> interval mem is still not reused.
>>>>
>>>> So I understand it can eat up the memory but why is all memory locked 
>>>> forever and didn't get reused - in my understanding (it's not much) in my 
>>>> case GC do not free mem at all in python level. So some reference is still 
>>>> intact after function is finished.
>>>>
>>>>
>>>> 2012. május 10., csütörtök 21:53:06 UTC+2 időpontban Richard a 
>>>> következőt írta:
>>>>>
>>>>> Ok, you don't need it to works all the time.
>>>>>
>>>>> Did you get it to update your records?
>>>>>
>>>>> If not, and if as you said it is a one trip, you can just treat the 
>>>>> whole records batch by batch...
>>>>>
>>>>> Look here : http://web2py.com/books/**default/chapter/29/14#**
>>>>> Populating-database-with-**dummy-data<http://web2py.com/books/default/chapter/29/14#Populating-database-with-dummy-data>
>>>>>
>>>>> for i in range(10):
>>>>>
>>>>>
>>>>> populate(db.mytable,100)
>>>>>
>>>>>
>>>>> db.commit()
>>>>>
>>>>>
>>>>> In this example only 100 records are populated at a time between 
>>>>> db.commit()... So maybe you just have to wrap for loop that will 
>>>>> db.commit() a couples of time during your processing.
>>>>>
>>>>> Richard
>>>>>
>>>>>
>>>>> On Thu, May 10, 2012 at 3:32 PM, szimszon  wrote:
>>>>>
>>>>>> I had to store files and a lot of properties for it. It was in csv. 
>>>>>> But after I processed it we figured out that not all value was correct 
>>>>>> in 
>>>>>> csv but it was a bit redundant. So I can correct it by go through all 
>>>>>> the 
>>>>>> records row by row. So that was a one time trip.
>>>>>>
>>>>>> I just realized after the process I had no memory left. So now I'm 
>>>>>> investigating what happened... 
>>>>>>
>

Re: [web2py] Need a little help in code review (a function eating up all memory)

[szimszon]

The problem is not that if I call the controller function if consumes 
memory. My problem is that there is something that still reference 
something after the execution is finished so the consumed memory never get 
released / reused...

2012. május 10., csütörtök 23:27:32 UTC+2 időpontban Martin.Mulone a 
következőt írta:
>
> The problem is fetchall(), is getting all the records to memory.
> If you want to iterate a large dataset or not so heavy, but have a table 
> with many fields, perhaps you can do it by blocks.
>
> For example using raw sql with dal: example: this fetch by 1000 records
>
> queryraw = "select * from mytable %(limit_query)s"
> def records(query):
> rows = db.executesql(query)
> if rows:
> return True
> else:
> return False
>
> rec = 0
> stage = 0
> block = 1000while True:
> offset = stage * block
> query = queryraw % {'limitquery': 'LIMIT %s, %s' % (offset, block)}
> if not records(query):
> break
>
> rows = db.executesql(query)
> for row in rows:
> rec += 1
>     # do something
> 
> stage += 1
>
> This is not fast but keep memory low.
>
>
> 2012/5/10 szimszon 
>
>> Could it be related?  
>> https://groups.google.com/forum/#!topic/web2py/hmsupVHdDHo/discussion 
>> (Memory 
>> leak in standalone DAL (issue #731), can you please help test?)
>>
>> 2012. május 10., csütörtök 22:32:53 UTC+2 időpontban szimszon a 
>> következőt írta:
>>
>>> Okay. It's clear.
>>>
>>> I'm only puzzled about why the memory didn't get freed or reused after 
>>> execution is finished. And if I execute the controller function in 1-2min 
>>> interval mem is still not reused.
>>>
>>> So I understand it can eat up the memory but why is all memory locked 
>>> forever and didn't get reused - in my understanding (it's not much) in my 
>>> case GC do not free mem at all in python level. So some reference is still 
>>> intact after function is finished.
>>>
>>>
>>> 2012. május 10., csütörtök 21:53:06 UTC+2 időpontban Richard a 
>>> következőt írta:
>>>>
>>>> Ok, you don't need it to works all the time.
>>>>
>>>> Did you get it to update your records?
>>>>
>>>> If not, and if as you said it is a one trip, you can just treat the 
>>>> whole records batch by batch...
>>>>
>>>> Look here : http://web2py.com/books/**default/chapter/29/14#**
>>>> Populating-database-with-**dummy-data<http://web2py.com/books/default/chapter/29/14#Populating-database-with-dummy-data>
>>>>
>>>> for i in range(10):
>>>>
>>>>
>>>> populate(db.mytable,100)
>>>>
>>>>
>>>> db.commit()
>>>>
>>>>
>>>> In this example only 100 records are populated at a time between 
>>>> db.commit()... So maybe you just have to wrap for loop that will 
>>>> db.commit() a couples of time during your processing.
>>>>
>>>> Richard
>>>>
>>>>
>>>> On Thu, May 10, 2012 at 3:32 PM, szimszon  wrote:
>>>>
>>>>> I had to store files and a lot of properties for it. It was in csv. 
>>>>> But after I processed it we figured out that not all value was correct in 
>>>>> csv but it was a bit redundant. So I can correct it by go through all the 
>>>>> records row by row. So that was a one time trip.
>>>>>
>>>>> I just realized after the process I had no memory left. So now I'm 
>>>>> investigating what happened... 
>>>>>
>>>>> 2012. május 10., csütörtök 21:00:05 UTC+2 időpontban Richard a 
>>>>> következőt írta:
>>>>>>
>>>>>> Yes but in this case it is not for the entire reecords...
>>>>>>
>>>>>> Why would you return a full list of all the records?
>>>>>>
>>>>>> I don't understand what is the purpose of listar that you return in 
>>>>>> the view under a html table, why do you need to return all the 10+ 
>>>>>> entries?
>>>>>>
>>>>>> Richard
>>>>>>
>>>>>> On Thu, May 10, 2012 at 2:56 PM, szimszon  wrote:
>>>>>>
>>>>>>> In book it is a recommended way to iterate over sql results:
>>>>>>>

Re: [web2py] Need a little help in code review (a function eating up all memory)

[szimszon]

Could it be related?  
https://groups.google.com/forum/#!topic/web2py/hmsupVHdDHo/discussion (Memory 
leak in standalone DAL (issue #731), can you please help test?)

2012. május 10., csütörtök 22:32:53 UTC+2 időpontban szimszon a következőt 
írta:
>
> Okay. It's clear.
>
> I'm only puzzled about why the memory didn't get freed or reused after 
> execution is finished. And if I execute the controller function in 1-2min 
> interval mem is still not reused.
>
> So I understand it can eat up the memory but why is all memory locked 
> forever and didn't get reused - in my understanding (it's not much) in my 
> case GC do not free mem at all in python level. So some reference is still 
> intact after function is finished.
>
>
> 2012. május 10., csütörtök 21:53:06 UTC+2 időpontban Richard a következőt 
> írta:
>>
>> Ok, you don't need it to works all the time.
>>
>> Did you get it to update your records?
>>
>> If not, and if as you said it is a one trip, you can just treat the whole 
>> records batch by batch...
>>
>> Look here : 
>> http://web2py.com/books/default/chapter/29/14#Populating-database-with-dummy-data
>>
>> for i in range(10):
>>
>> populate(db.mytable,100)
>>
>> db.commit()
>>
>>
>> In this example only 100 records are populated at a time between 
>> db.commit()... So maybe you just have to wrap for loop that will 
>> db.commit() a couples of time during your processing.
>>
>> Richard
>>
>>
>> On Thu, May 10, 2012 at 3:32 PM, szimszon  wrote:
>>
>>> I had to store files and a lot of properties for it. It was in csv. But 
>>> after I processed it we figured out that not all value was correct in csv 
>>> but it was a bit redundant. So I can correct it by go through all the 
>>> records row by row. So that was a one time trip.
>>>
>>> I just realized after the process I had no memory left. So now I'm 
>>> investigating what happened... 
>>>
>>> 2012. május 10., csütörtök 21:00:05 UTC+2 időpontban Richard a 
>>> következőt írta:
>>>>
>>>> Yes but in this case it is not for the entire reecords...
>>>>
>>>> Why would you return a full list of all the records?
>>>>
>>>> I don't understand what is the purpose of listar that you return in the 
>>>> view under a html table, why do you need to return all the 10+ entries?
>>>>
>>>> Richard
>>>>
>>>> On Thu, May 10, 2012 at 2:56 PM, szimszon  wrote:
>>>>
>>>>> In book it is a recommended way to iterate over sql results:
>>>>>
>>>>> http://web2py.com/books/**default/chapter/29/6<http://web2py.com/books/default/chapter/29/6>
>>>>>
>>>>> You can do all the steps in one statement:
>>>>>
>>>>> 1.
>>>>> 2.
>>>>> 3.
>>>>>
>>>>> >>> for row in db(db.person.name=='Alex').sel**ect():
>>>>>
>>>>>
>>>>> print row.name
>>>>>
>>>>> Alex
>>>>>
>>>>>
>>>>>
>>>>>
>>>>> 2012. május 10., csütörtök 20:42:22 UTC+2 időpontban Bruce Wade a 
>>>>> következőt írta:
>>>>>
>>>>>> Sorry, you really need to read more about how python works. If you 
>>>>>> learn how for loops work and memory you will understand the problem. 
>>>>>>
>>>>>> One solution do the query before the for loop then loop through the 
>>>>>> objects. This may help at bit. Research xrange vs range
>>>>>>
>>>>>>
>>>>>> On Thu, May 10, 2012 at 11:30 AM, szimszon wrote:
>>>>>>
>>>>>>> Sorry I don't understand. What do you mean "achieve with join"?
>>>>>>>
>>>>>>> There is an empty for loop with db.executesql() without join. And it 
>>>>>>> is eating up the memory. :(
>>>>>>>
>>>>>>> 2012. május 10., csütörtök 19:12:30 UTC+2 időpontban Richard a 
>>>>>>> következőt írta:
>>>>>>>
>>>>>>>> You can't manage what you want to achieve with join?
>>>>>>>>
>>>>>>>> Richard
>>>>>>>>
>>>>>>>> On Thu, May 10, 2012