Re: [web2py:36741] Re: admin from a vpn client

2009-12-07 Thread
Thanks! 2009/12/8 Yarko Tymciurak resultsinsoftw...@gmail.com On Dec 6, 9:18 pm, 陶艺夫 artman...@gmail.com wrote: Thanks for reply. I do know the server's IP, I can connect to the server too. I'm runing web2py behind a apache web server. What I mean is - How can I set a secure channel

[web2py:36654] admin from a vpn client

2009-12-06 Thread
Hi, I'm runing a web2py in an openvpn server and I want to login as an administrator to manage my site from a openvpn client. How can I make it possible? Thanks. -- You received this message because you are subscribed to the Google Groups web2py-users group. To post to this group, send email

Re: [web2py:36659] Re: admin from a vpn client

2009-12-06 Thread
just define the IP for the interface where you want web2py to be available. Suppose your web2py is running on a machine with the IP 192.168.1.9, then you could do: python web2py.py -i 192.168.1.9 Regards On Dec 7, 2:03 am, 陶艺夫 artman...@gmail.com wrote: Hi, I'm runing a web2py in an openvpn

[web2py:34825] Re: load balancing and HA clustering

2009-11-07 Thread
not need any special configuration to handle sessions. This is described somewhat in chapter 11 of the book. Massimo On Nov 3, 10:51 pm, 陶艺夫 artman...@gmail.com wrote: Hi, Is it possibale to use web2py under apache (via mod_wsgi) to construct a load balancing HA clustering servers' group

[web2py:34546] load balancing and HA clustering

2009-11-03 Thread
Hi, Is it possibale to use web2py under apache (via mod_wsgi) to construct a load balancing HA clustering servers' group? If it is, how? Thanks. --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups web2py-users group.

[web2py:31690] mdipierro, can you help me with calling remote web2py' methods by Flex3?

2009-09-25 Thread
Hi, mdipierro. I need a sample of Flex3 application (or code fragments) with it I can call remote methods exposed by web2py with @seveice_amfrpc. Can you help me? Thanks. --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google

[web2py:31605] Re: Flex3: how to get remote service exposed by Web2Py

2009-09-24 Thread
The address turns out to be: http://docs.turbogears.org/2.0/TGandPyAMF. Any idea? 2009/9/23 陶艺夫 artman...@gmail.com I'm trying to get a remote call from service exposed by web2py in flex 3. The Turbogears gateway example on PyAmf site shows that you should get a remote object to make it's

[web2py:31513] Flex3: how to get remote service exposed by Web2Py

2009-09-23 Thread
I'm trying to get a remote call from service exposed by web2py in flex 3. The Turbogears gateway example on PyAmf site shows that you should get a remote object to make it's methods called(*this address may be wrong, cuz the PyAmf site is just now unavailable* -

[web2py:31458] Need a Web2Py, PyAMF and Flex 3.0 Skeleton

2009-09-22 Thread
Is there a more morden sample somewhere than http://mdp.cti.depaul.edu/AlterEgo/default/show/22 ? thanks. --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups web2py-users group. To post to this group, send email to

[web2py:31466] Re: Need a Web2Py, PyAMF and Flex 3.0 Skeleton

2009-09-22 Thread
Thanks. I'll fowllow it. Web2py really makes things simple! :) 2009/9/22 mdipierro mdipie...@cs.depaul.edu Yes, http://mdp.cti.depaul.edu/AlterEgo/default/show/232 it is also in the book. On Sep 22, 5:15 am, 陶艺夫 artman...@gmail.com wrote: Is there a more morden sample somewhere

[web2py:30356] Re: hey! we passed 30000 messages.

2009-09-07 Thread
I envy you guys. I'd love to but it's too far for me. Have fun, guys! :) 2009/9/8 mdipierro mdipie...@cs.depaul.edu What about Monday 14 in the late evening. Late evening works better for me too. Massimo On Sep 7, 6:03 pm, Álvaro Justen [Turicas] alvarojus...@gmail.com wrote: On Mon,

[web2py:29559] Re: clean up the session files

2009-08-28 Thread
I thought a file would be closed automatically as its handler unreferred(for example, the method referred it ended) and garbage-collected. But we can't count on this, for the time is uncertain. Close the file explicitly maybe a good choice. 2009/8/28 陶艺夫 artman...@gmail.com I appended a line

[web2py:29502] clean up the session files

2009-08-27 Thread
Hi, Under windows, is there another way other than running session2trash.py in the background(windws always show a command window) to clean up the session files periodically? What if I do cleanup work every request-check the files timestamp then delete them if time expired? If the sessions are

[web2py:29510] Re: can't import csv data file

2009-08-27 Thread
Check your csv file, does it contain some empty rows? Or does your data contain any coma ( which will tell the csv reader you have more fields than you expect)? Or some fields get illegal values? good luck. 2009/8/27 Carlos Aboim abo...@gmail.com Hi list, I want import some data from a CSV

[web2py:29525] Re: clean up the session files

2009-08-27 Thread
(os.path.join(ps,f)) for f in os.listdir(ps) if os.stat (os.path.join(ps,f))[stat.ST_MTIME]time.time()-3600] except: pass and delete all sessions older than 1h (3600) about pack-compiled. Can you say more about the error? can you tell use about the web2py version? On Aug 27, 9:43 am, 陶艺夫

[web2py:29543] Re: clean up the session files

2009-08-27 Thread
On Aug 27, 12:51 pm, 陶艺夫 artman...@gmail.com wrote: Thank you, mdipierro! I've put the cleanup code in logout method, to avoid per request check. I don't know if it is more reasonable. pack-compiled just give me a Internal error message by the message flash. I'm using the newest

[web2py:29551] Re: clean up the session files

2009-08-27 Thread
there. 2009/8/28 陶艺夫 artman...@gmail.com No. There were not any errors shown in the console, it seemd nothing had happened - that's why I could not figure out what was wrong. Thanks. 2009/8/28 mdipierro mdipie...@cs.depaul.edu When you get internal error it should show the traceback

[web2py:29557] Re: clean up the session files

2009-08-27 Thread
I appended a line tar.close() to the tar() method in the file fileutils.py, now it's ok. :) 2009/8/28 陶艺夫 artman...@gmail.com The error occured when 'os.unlink(tarname)'. Error 32 means the file is still open. I don't know why and am working on it. 2009/8/28 陶艺夫 artman...@gmail.com

[web2py:29553] Re: clean up the session files

2009-08-27 Thread
The error occured when 'os.unlink(tarname)'. Error 32 means the file is still open. I don't know why and am working on it. 2009/8/28 陶艺夫 artman...@gmail.com No. There were not any errors shown in the console, it seemd nothing had happened - that's why I could not figure out what was wrong

[web2py:29421] How to force db to re-create all tables?

2009-08-26 Thread
Hi, I have finished my app, and I deleted the database-which contains a lot of testing data-from PostgreSQL server then created a new empty one. I thought when my app found that all tables had gone it would re-create all tables automatically. But it wasn't the case. It would just complain relation

[web2py:29461] Re: How to force db to re-create all tables?

2009-08-26 Thread
Thank you, mdipierro. I didn't know the trick before. Now it works. 2009/8/26 mdipierro mdipie...@cs.depaul.edu Did you delete the *.table files in yourapp/databases/ ? Massimo On Aug 26, 10:20 am, 陶艺夫 artman...@gmail.com wrote: Hi, I have finished my app, and I deleted the database

[web2py:29241] Re: one more reason to stay with python 2.5 for now

2009-08-24 Thread
How about Python 2.6.2? I run my applications under 2.6.2, it seems great. 2009/8/24 mdipierro mdipie...@cs.depaul.edu IO is still about twice faster than Python 3.1 http://www.gtsystem.eu/blog/2009/08/improved-performance-of-python-31/

[web2py:28282] Re: Static Uploads Time Out

2009-08-09 Thread
I failed in downloading large files from cherrypy server after I'd tried many aspects of adjustment. I think cherrypy has some limitations. You can change to use apache and mod_wsgihttp://code.google.com/p/modwsgi/downloads/list, they have been working fine for me. For building mod_wsgi from the

[web2py:28202] Re: strftime problem

2009-08-08 Thread
to use datetime in the database late than 1899-12-31, at least under win32. It's sort of ridiculous. 2009/8/8 mdipierro mdipie...@cs.depaul.edu Which python version? This may be a python issue, not a web2py issue. On Aug 7, 2:22 pm, 陶艺夫 artman...@gmail.com wrote: Hi, my app got an error

[web2py:28247] Re: Web2py.com down

2009-08-08 Thread
No problem too, in China. 2009/8/9 Kuba Kucharski kuba.kuchar...@gmail.com Also no problem from Europe, Poland at that time. On Aug 9, 2009 1:35 AM, Yarko Tymciurak yark...@gmail.com wrote: I see - ok; then I just didn't see an access problem from here (Chicago area)... On Sat, Aug 8,

[web2py:28149] Re: db - stored procedure

2009-08-07 Thread
, and it can work rather well. Regards, - Yarko 2009/8/6 陶艺夫 artman...@gmail.com Thank you for reply. It's a charity project. The city goverment here decided to help old people who aged 70 above financially every month. There are aid standards here: age range : 70-7980-8990-9495-99

[web2py:28170] Re: db - stored procedure

2009-08-07 Thread
produces results like (though I left the TOWNSHIP grouping out since I don't have a similar column and for brevity): 30-39 9684 40-49 15344 50-59 15697 60-69 8581 70-79 2358 other 3206 On Aug 6, 1:13 pm, 陶艺夫 artman...@gmail.com wrote: Hi, I'm using PostgreSQL, I need

[web2py:28174] strftime problem

2009-08-07 Thread
Hi, my app got an error in db(db.person.birth_date=_date) , when the _date had a value '1900-01-01'. That's for python's strftime constraint. I found chaging _date to _date.isoformat() would work, and I had to search whole my app to make the change. Or is there a better solution? Thanks.

[web2py:28179] Re: strftime problem

2009-08-07 Thread
It's just a try, means nothing :) But what if the date is not birth_date and really means something 2009/8/8, Yarko Tymciurak yark...@gmail.com: Wow! You're preparing for dealing with some of the oldest living people on earth here! On Fri, Aug 7, 2009 at 2:22 PM, 陶艺夫 artman

[web2py:28096] db - stored procedure

2009-08-06 Thread
Hi, I'm using PostgreSQL, I need to use stored procedure to calculate on more than 5 records -- according to every people's birthday, figure out how much subsidy (s)he will get. Is this a rational idea? I have done calculating by a controller, but it has taken more than 50 seconds to get the

[web2py:28110] Re: db - stored procedure

2009-08-06 Thread
any sql you want. If you show us what you need to do specifically perhaps we can suggest a better way. Massimo On Aug 6, 1:13 pm, 陶艺夫 artman...@gmail.com wrote: Hi, I'm using PostgreSQL, I need to use stored procedure to calculate on more than 5 records -- according to every people's

[web2py:28018] psycopg2 problem

2009-08-05 Thread
I compiled psycopg2 under windwos xp using mingw. After installed it, I added import pstcopg2 in my model file. But I got the ImportError message cannot import name tz in the __init__ file of psycopy2. It's weird, the tz.py is there! Any idea will be thankful.

[web2py:27932] How to set http keep-alive parameter?

2009-08-04 Thread
Hi, I don't wanna use another web server but cherrypy, I think it is capable of serving my site. I tested my app to download a 4.2M file through response.stream(file_name), it always terminated halfway. Is this the case of 'Keep-alive time is not enougth? If it is, How can I set the parameter?

[web2py:27913] Re: file downloading problem

2009-08-03 Thread
figure out what it is. The result is fine, but the feelings is not so good... 2009/8/4 Alex Fanjul alex.fan...@gmail.com Could you solve the infinite error ticket loop? It happened to me and I had to reinstall web2py. after that It worked again... Alex F El 01/08/2009 7:50, 陶艺夫 escribió

[web2py:27806] Re: file downloading problem

2009-08-02 Thread
/1 mdipierro mdipie...@cs.depaul.edu It may be a file permission issue. On Aug 1, 12:50 am, 陶艺夫 artman...@gmail.com wrote: Now there are some problems I can't figure out why. My application has been doing well under binary web2py with cherrypy. After I moved it into Apache and mod_wsgi

[web2py:27810] Re: file downloading problem

2009-08-02 Thread
to parameters_80.py 2009/8/2 陶艺夫 artman...@gmail.com Yes. I got the message admin disabled because unable to access password file when I tried to get into admin app. Then started over the web2py using -a parameter and assigned a password. I saw the file parameters_8000.py showed up

[web2py:27701] Re: file downloading problem

2009-07-31 Thread
yark...@gmail.com I believe this is a cherrypy issue; Can you use apache + mod_wsgi instead? This is more reliable for serious work. On Thu, Jul 30, 2009 at 10:32 PM, 陶艺夫 artman...@gmail.com wrote: Hi, I'm using response.stream(file_name) method to offer users downloading files which

[web2py:27718] Re: file downloading problem

2009-07-31 Thread
/how_to_install_apache2_ssl_web2py_window however, abraham told me that the wsgi version i use is old, but i couldnt find updated one for python 2.5 , all are for 2.6 cheers alex f El 31/07/2009 14:48, 陶艺夫 escribió: Thank you for reply. I've been googling the right version of mod_wsgi for couples of hours and I

[web2py:27743] Re: file downloading problem

2009-07-31 Thread
30, 10:32 pm, 陶艺夫 artman...@gmail.com wrote: Hi, I'm using response.stream(file_name) method to offer users downloading files which are sort of business-classified, but the downloading process always terminated halfway. The testing file is 4.2M, an Excel workbook. Is there anything I can do

[web2py:27744] Re: file downloading problem

2009-07-31 Thread
, and on... I found the admin application wouldn't work in this env till now. I try to remove ssl from Apache, the error was still there. Any idea? 2009/8/1 陶艺夫 artman...@gmail.com I got it works evetually. Guess what was wrong? I had a wrong spelled word in the conf file! It had taken my 2 hours away

[web2py:27666] file downloading problem

2009-07-30 Thread
Hi, I'm using response.stream(file_name) method to offer users downloading files which are sort of business-classified, but the downloading process always terminated halfway. The testing file is 4.2M, an Excel workbook. Is there anything I can do with system configuration(CherryPy), or it's just

[web2py:26877] Re: Create file on the fly for downloadling

2009-07-19 Thread
/browse_thread/thread/581a01953ce3575f/61e40855d94c1eb3?lnk=gstq=save%28%29#61e40855d94c1eb3 http://www.djangosnippets.org/snippets/1151/ (look for 'output = StrintIO.StringIO()' and 'book.save(output)') Hope that's helpful... 2009/7/18 陶艺夫 artman...@gmail.com Thank you for replying

[web2py:26878] Re: Custom SQLFORM problem

2009-07-19 Thread
try by following your advice. I'll let you know as soon as it works. Thank you! 2009/7/18 DenesL denes1...@yahoo.ca Hi Artman, On Jul 18, 8:02 am, 陶艺夫 artman...@gmail.com wrote: the table: db.define_table('users', SQLField('user_name','string',required=True,unique=True

[web2py:26793] Re: Custom SQLFORM problem

2009-07-18 Thread
the table: db.define_table('users', SQLField('user_name','string',required=True,unique=True), SQLField('password','password',length=80,required=True), SQLField('town_id','integer'), # this can be NULL SQLField('name','string',required=True),

[web2py:26860] Create file on the fly for downloadling

2009-07-18 Thread
Hi, all friends. I'm using PyExelerator to create Excel report for users to download. I tried to save the Workbook object to a StringIO which is said a file-like object, but the result is an empty file. Following are the codes: def get_report(): # generating workbook codes f =

[web2py:26870] Re: Create file on the fly for downloadling

2009-07-18 Thread
? 2009/7/19 mdipierro mdipie...@cs.depaul.edu Try replace f.seek(0) return f.read() with return f.getvalue() if it does not work than it is a PyExelerator issue On Jul 18, 8:32 pm, 陶艺夫 artman...@gmail.com wrote: Hi, all friends. I'm using PyExelerator to create Excel report