[web2py] how to delete records from table older than 1 day?

2012-07-16 Thread Amit
Hi, I have created table Employe with following fields: db.define_table( 'Employee', Field('created_on','datetime', default=request.now), Field('emp_id'), Field('emp_age'), Field('emp_address), ) inserting data into the table is working fine but when i am trying to delete data one

Re: [web2py] Re: how to delete records from table older than 1 day?

2012-07-16 Thread Amit
mployee.created_on < yesterday).delete() > > > > On Monday, July 16, 2012 12:12:56 PM UTC+2, Amit wrote: >> >> Hi, >> I have created table Employe with following fields: >> db.define_table( >>'Employee', >>Field('creat

Re: [web2py] Re: Making a field non-editable, but writable using SQLFORM

2012-07-16 Thread amit
Old thread, but this would trigger a race condition in case of multiple concurrent users. On Friday, June 17, 2011 5:12:27 AM UTC+8, JayShaffstall wrote: > > I'd been thinking I needed to do that between form creation and the > accepts call, but you're right, it works even after that point. I >

[web2py] How to start a thread upon starting of webserver?

2012-07-16 Thread Amit
Hi, I have one timer thread which has to start once when web sever starts very first time and stop when web server stops, means it should be running continuously irrespective of how many users interacting with the application so there is only one instance of this thread running though out life

Re: [web2py] Re: Making a field non-editable, but writable using SQLFORM

2012-07-17 Thread amit
field to writable in one request > does not affect it another request. > I am not sure if I understand this for db.table.field.writable. The change is occurring within the shared DAL object. Is it not? Best Regards -Amit --

Re: [web2py] Re: How to start a thread upon starting of webserver?

2012-07-17 Thread Amit
lt-in web server) or apache? > > > On Monday, 16 July 2012 23:42:49 UTC-5, Amit wrote: >> >> Hi, >> I have one timer thread which has to start once when web sever starts >> very first time and stop when web server stops, means it should be running >> continuously

[web2py] Re: User Login/Logout authentication event

2012-07-17 Thread amit
For logout, I could not find logout_onaccept. There is though: auth.settings.logout_onlogout I am using v 1.99.7. --

Re: [web2py] Re: How to start a thread upon starting of webserver?

2012-07-18 Thread Amit
Hi Massimo, could you please provide me the solution for this? On Wednesday, 18 July 2012 08:37:23 UTC+5:30, Amit wrote: > > for development purpose I am using Rocket but will deploy the application > to ubuntu machine where web server will be apache, so please provide me > solut

Re: [web2py] Re: How to start a thread upon starting of webserver?

2012-07-18 Thread Amit
Mayer wrote: > Can't you use in a model. > cache.ram('parallel_thread_name', , None) > so that you have the thread created at first connection. > > I don't know how to close it afterwards though. Maybe using a cron job ? > > Le jeudi 19 juillet 2012 05:24:

[web2py] how to compare date time in web2py?

2012-07-19 Thread Amit
Hi, I have some records in a table and each record is having one field of type datetime [fromat : 2012-07-19 23:12:0 (-MM-DD HH:MM:SS)], table structure is: Emp_ID Emp_Name Emp_Address Emp_Salary updated_on(Type: datetime) periodically getting data against each Emp_ID and updating to the p

[web2py] Facing problem of settingup web2py project in Eclipse.

2012-07-19 Thread Amit
Hi, I followed below link to configure Web2py project in eclipse: http://allisterx.blogspot.in/2009/06/using-web2py-framework-on-eclipse.html but after setting up when i open my application which is there inside application folder of web2py_src folder, I saw so many errors on the module. once i

[web2py] how to use db connection multiple times with scheduler?

2012-07-19 Thread Amit
hi, I have to implement one scenario where scheduler will make the query to database periodically to retrieve data(lets say every 10 mins), i have written function inside model db.py to retrieve the data, and from controller i am staring the scheduler and assign the job to get the data periodic

[web2py] how to achieve public/private key authentication for web service in web2py?

2012-07-24 Thread Amit
Hi, I have to provide public/private key authentication for accessing web service (REST) from client in my web2py application.How to achieve it? Scenario: 1.Each client will have unique private key which will be sent to the server alongwith request. 2. Server has to authenticate private key usi

Re: [web2py] Re: how to achieve public/private key authentication for web service in web2py?

2012-07-24 Thread Amit
your REST action with @auth.requires_login(). > This will give you access to information contained in the certificate > such common name or serial id. To customize you can extend the X509_Auth > class. > > To generate test certificates fast you can use simpatica as Derek > correct

Re: [web2py] Re: how to achieve public/private key authentication for web service in web2py?

2012-07-25 Thread Amit
sure Michele, let me go through the code,If i am not wrong simpatica is to generate the certificate file for the client and if you are having any sample code to use x509 in case of web service then please do share with me. Thanks, Amit On Wed, Jul 25, 2012 at 12:34 PM, Michele Comitini

Re: [web2py] Re: how to achieve public/private key authentication for web service in web2py?

2012-07-25 Thread Amit
so is it the same, if yes then I need to create auth.settings.login_form = X509Auth() instance ? Thanks, Amit On Wed, Jul 25, 2012 at 2:28 PM, Michele Comitini < michele.comit...@gmail.com> wrote: > > simpatica > > - generate ca priv key + self signed c

Re: [web2py] Re: how to achieve public/private key authentication for web service in web2py?

2012-07-25 Thread Amit
Thanks Michele,I am going to generate keys using simpatica, I will let you know if i face any problem. Thanks, Amit On Wed, Jul 25, 2012 at 7:01 PM, Michele Comitini < michele.comit...@gmail.com> wrote: > 2012/7/25 Amit : > > Michele, > > > > I have gone through

Re: [web2py] Re: how to achieve public/private key authentication for web service in web2py?

2012-07-26 Thread Amit
llers/public.py>, line 28, in from M2Crypto import X509, ASN1, Rand, EVP, RSA So not able to execute it :(. I have installed M2Crypto-0.21.1-py2.7.egg-info for windows . I couldn't able to identify what is the exact problem, so can you please help me to resolve it? Thanks, Amit On Thu,

[web2py] Getting error: DLL load failed: The operating system cannot run %1

2012-07-26 Thread Amit
I Have installed python 2.7.2 and M2Crypto-0.21.1-py2.7.egg-info in my Windows XP SP3 machine and wherever i am using import statement: from M2Crypto import X509,ASN1,Rand,EVP,RSA its throwing error * DLL load failed: The operating system cannot run %1.* it seems like M2Crypto version is no

Re: [web2py] Getting error: DLL load failed: The operating system cannot run %1

2012-07-27 Thread Amit
Found the problem :), I was using wrong version of M2Crypto so uninstalled it and install M2Crypto-0.20.2.win32-py2.7 version and its working fine. On Fri, Jul 27, 2012 at 12:02 PM, Amit wrote: > I Have installed python 2.7.2 and M2Crypto-0.21.1-py2.7.egg-info in my > Windows XP SP3 machi

[web2py] Re: Facing problem of settingup web2py project in Eclipse.

2012-07-29 Thread Amit
r , its working fine, so not sure why eclipse is displaying import errors. Can anybody help me to resolve this problem? Thanks, Amit On Friday, 20 July 2012 10:49:29 UTC+5:30, Amit wrote: > > Hi, > I followed below link to configure Web2py project in eclipse: > > http://al

[web2py] how to use pycurl in web2py?

2012-07-30 Thread Amit
Hi, I want to use pycurl in my web2py app to send Post request to the server, I added Pycurl path(path to pycurl.c file ---> pycurl-7.19.0\src) to pythonpath and tried to import pycurl in default.py class but it throws error " No module named pycurl" even i tried to add pycurl.c file in mudule

Re: [web2py] Re: how to achieve public/private key authentication for web service in web2py?

2012-07-31 Thread Amit
ficate 2. generate server priv keys + certificates signed by the above ca certificate 3. generate client priv keys + certificates signed by the above ca certificate but I am not able to generate above 2. and 3. so pleae guide me to generate the same. Thanks, Amit > > > On Thu, Jul 26

Re: [web2py] Re: how to achieve public/private key authentication for web service in web2py?

2012-07-31 Thread Amit
is other two client and server pem encoded key files , how to generate them? On Tue, Jul 31, 2012 at 3:17 PM, Amit wrote: > Hi Michele, > Still I am not able to achieve X509 authentication, I am able to generate > following files using CA menu: > cacert.key (CA private key) >

[web2py] WARNING:web2py:unable to open SSL certificate. SSL is OFF in web2py 1.99.7

2012-08-02 Thread Amit
t;*. does PyOpenSSL-0.13 not supported by Web2py 1.99.7 version OR is there any other problem? Can anyone please help me out how to resolve this issue? Regards, Amit --

[web2py] How to keep database connection alive ?

2012-08-07 Thread Amit
Hi, I am using SQlite database for my web2py application, I have to keep the same db instance which is created at first time request comes to model db.py db = DAL('sqlite://storage.sqlite') database connection is getting closed once request is completed so I am not able to use the "db" for so

Re: [web2py] Re: How to keep database connection alive ?

2012-08-08 Thread Amit
7;) db(db.appliance_tbl.created_on < yesterday).delete() is it correct? OR do I need to re-define all the tables for local db instance?if no, then how this instance will be able to recognize all tables? Please guide me to resolve this. Thanks, Amit On Wed, Aug 8, 2012 at 10:49 PM, Mass

Re: [web2py] Re: How to keep database connection alive ?

2012-08-08 Thread Amit
This is also not working giving same error: "ProgrammingError: Cannot operate on a closed database." :( Regards, Amit On Thu, Aug 9, 2012 at 9:58 AM, Massimo Di Pierro < massimo.dipie...@gmail.com> wrote: > This definitively would not work... > > how about > > @sc

Re: [web2py] Re: How to keep database connection alive ?

2012-08-09 Thread Amit
Hi, Migrated to MySql from Sqlite and tested the purging feature, its working as intended :) Thanks a lot you guys for assisting me to resolve it :) Regards, Amit On Thu, Aug 9, 2012 at 10:05 AM, Amit wrote: > This is also not working giving same error: "ProgrammingError: Cannot >

[web2py] Help me to write SQL query in web2py

2012-08-16 Thread Amit
I have written one sql query: select device_id, sensor_id, max(created_on) from test.abc_tbl where date_sub(now(), interval interval_time minute) > created_on group by device_id, sensor_id; How to write it in web2py? Please help me to do the same. Thanks. --

Re: [web2py] Re: Help me to write SQL query in web2py

2012-08-20 Thread Amit
Thanks a lot Massimo and mcamel, its working as expected :) Regards, Amit On Sat, Aug 18, 2012 at 7:04 PM, Massimo Di Pierro < massimo.dipie...@gmail.com> wrote: > My bad. It should be > > t.created_on.max() > > > On Saturday, 18 August 2012 04:26:37 UTC-5, mcamel wrote:

[web2py] NameError: global name 'requests' is not defined

2012-08-21 Thread Amit
Hi, I am using mailgun libraries to send mail from my web2py application,I followed example given in mailgun site mailgun.com: 1. requests.post(("https://api.mailgun.net/v2/samples.mailgun.org/messages";), 2. auth=("api", "key-3ax6xnjp29jd6fds4gc373sgvjxteol0"), 3. data={ 4.

Re: [web2py] Re: NameError: global name 'requests' is not defined

2012-08-21 Thread Amit
se that with the request object > (without the s) that is available in web2py). > > Their examples lacks of the import line (import requests). > Of course you need to install that to be able to use it with pip install > requests. > > Il giorno martedì 21 agosto 2012 12:09:24

Re: [web2py] Re: NameError: global name 'requests' is not defined

2012-08-21 Thread Amit
I resolved the issue, somehow after installing it to Lib/site-packages of python installation path , it has not added to PYTHONPATH, because of that requests is not recognized, i have explicitly added it to the PYTHONPATH then its working fine. Thanks, Amit On Tue, Aug 21, 2012 at 4:02 PM, Amit

[web2py] Database interaction with custom html in web2py.

2012-08-21 Thread Amit
Hi, I generated one custom html file which is having one text field where user has to enter id and one submit button. I have to use it in following manner: 1. User has to enter the id and press the submit button 2. after pressing submit button, id value has to be validated in xyz table. 3. first

Re: [web2py] Re: Help me to write SQL query in web2py

2012-08-21 Thread Amit
interval_time,max_created_on,groupby=tbl.device_id|tbl.sensor_id) Regards, Amit On Wed, Aug 22, 2012 at 11:44 AM, mcamel wrote: > Hi Amit, > > Could you post the final code that works?. > > Thanks. > > -- > > > > --

Re: [web2py] Database interaction with custom html in web2py.

2012-08-21 Thread Amit
Thanks Khalil for providing solution with example..I will write as per below instruction and let you know the result. Thanks once again :) Amit On Wed, Aug 22, 2012 at 11:42 AM, Khalil KHAMLICHI < khamlichi.kha...@gmail.com> wrote: > 1) controller page1: controllers/default.py >

Re: [web2py] Database interaction with custom html in web2py.

2012-08-23 Thread Amit
for each employee record so user can click which can open employee edit html page and from there user can change employee details and save it to the database, what is the best way to achieve it in web2py? Regards, Amit On Wed, Aug 22, 2012 at 8:38 PM, Anthony wrote: > Note, you do

Re: [web2py] Re: Help me to write SQL query in web2py

2012-08-23 Thread Amit
It should work from inside select() also, i used it only for convenient. Regards, Amit On Wed, Aug 22, 2012 at 5:33 PM, mcamel wrote: > Amit, > > Does it works if you use tbl.created_on.max() inside the select(), instead > of max_created_on?. > > I mean, is it n

[web2py] how to parse xml in web2py?

2012-08-23 Thread Amit
Hi, I have web service method in my application which will receive xml file from the request, i need to parse it and save the extracted data to the database. Please suggest me the best way to parse xml in web2py. xml format would be like below: 123456 2012-06-30 1 adadafdfd

Re: [web2py] Re: how to parse xml in web2py?

2012-08-23 Thread Amit
Thanks guys for helping me to write xml parsing in python..I will use ElementTree Or cElementTree to extract data from xml and let you people know about the outcome. @Anthony: My mistatke :( , I manually written the xml so did mistake on matching opening and closing tags. Thanks once again Amit

[web2py] how to use javascript code in web2py html pages?

2012-08-23 Thread Amit
Hi, I have html file with one text field with submit button inside form.I added javascript code to validate the textfield but its not working at all, why is it so? does web2py not support javascript function? please check below the code : function textFieldValidation() { var x=document.for

Re: [web2py] Re: how to use javascript code in web2py html pages?

2012-08-26 Thread Amit
Thanks Anthony to finding the issue, after modifying the code as per your suggestion,its working fine now. Regards, Amit On Fri, Aug 24, 2012 at 5:01 PM, Anthony wrote: > Also, a tip -- if you think web2py is causing a problem with your code, > try the code in a page not served by web2p

[web2py] How to call controller function upon onClick from html?

2012-08-27 Thread Amit
Hi, I have created one html file with list of records, each records are there in a row of table in html and there is one corresponding button (type as button) for each record so when user clicks on it , it should take the id of that record from the html call controller function which will

[web2py] how to send function arguments value from redirect()?

2012-08-27 Thread Amit
hi, I have to send the arguments value from redirect to the target function, for e.g: redirect(URL(r=request,f='record_config')) def record_config(record_id): I have to send the value of record_id from the redirect() to the record_config() function OR is it some other way to send value of rec

[web2py] Re: how to send function arguments value from redirect()?

2012-08-27 Thread Amit
y, 28 August 2012 11:09:56 UTC+5:30, Amit wrote: > > hi, > I have to send the arguments value from redirect to the target function, > for e.g: > > redirect(URL(r=request,f='record_config')) > > def record_config(record_id): > > > I have to send the

[web2py] Re: How to call controller function upon onClick from html?

2012-08-27 Thread Amit
Thanks Anthony, its working as expected :) regards, Amit On Monday, 27 August 2012 19:21:46 UTC+5:30, Anthony wrote: > > The onclick property of an HTML element must be Javascript. You cannot > call a server-side Python function directly from the browser. If you want > the button

Re: [web2py] Re: How to call controller function upon onClick from html?

2012-08-28 Thread Amit
rm ,inside same table but still it is giving same error so how to get the text field value and pass it to the args? Regards, Amit On Mon, Aug 27, 2012 at 7:21 PM, Anthony wrote: > The onclick property of an HTML element must be Javascript. You cannot > call a server-side Python function d

[web2py] How to pass html text field value to the controller function?

2012-08-29 Thread Amit
Hi, I have to send textfield value from html to controller function, how to achieve it, please see the code below : I have one text field on html page named record name, user can input the name of the record which I want to pass to the record_config() function of default.py but i am unable

Re: [web2py] How to pass html text field value to the controller function?

2012-08-29 Thread Amit
to do once > you have pass the input value to this function. > > Richard > > > On Wed, Aug 29, 2012 at 6:18 AM, Amit wrote: > >> Hi, >> I have to send textfield value from html to controller function, how to >> achieve it, please see the code below : >&

Re: [web2py] Re: How to pass html text field value to the controller function?

2012-08-29 Thread Amit
t 29, 2012 6:18:57 AM UTC-4, Amit wrote: >> >> Hi, >> I have to send textfield value from html to controller function, how to >> achieve it, please see the code below : >> >> > >>onClick = 'window.location="{{=URL('defa**ult', &#x

Re: [web2py] Re: How to call controller function upon onClick from html?

2012-08-29 Thread Amit
Hi Anthony, I used the code which you have suggested but it's not working at all, it is not calling record_config() function of controller. second point is if the above approach is successful then how would I retrieve the value in controller side: def record_config(): print 'inside rec

Re: [web2py] Re: How to call controller function upon onClick from html?

2012-08-30 Thread Amit
+ > jQuery("input[name=name_text_field]").val();' > > The value will be available as request.args(0) in the record_config() > function. > > Anthony > > > On Thursday, August 30, 2012 2:41:40 AM UTC-4, Amit wrote: >> >> H

Re: [web2py] Re: How to call controller function upon onClick from html?

2012-08-30 Thread Amit
page, may be some temporary page is getting created with these values. what I understood is this page is not record_config page that's why it is not calling onclick of the button , hence not calling javascript, JQuery stuffs also. Please provide your inputs on this. Regards, Amit On Thu, A

Re: [web2py] Re: How to call controller function upon onClick from html?

2012-08-30 Thread Amit
; } but if I use JQuery instead of directly putting record name, its not working.Please suggest is it a proper way to send the parameters to the controller function. Regards, Amit On Thu, Aug 30, 2012 at 2:44 PM, Amit wrote: > Anthony, > I observe one more thing, as I have launched

Re: [web2py] Re: How to call controller function upon onClick from html?

2012-08-30 Thread Amit
As I told you I have created my own custom html without extending layout.html. I am not sure how to load JQuery in that? Please check the whole html file in attachement once and suggest me how to support JQuery in the html. Regards, Amit On Thu, Aug 30, 2012 at 4:53 PM, Anthony wrote: >

Re: [web2py] Re: How to call controller function upon onClick from html?

2012-09-02 Thread Amit
Thanks Anthony :) Regards, Amit On Fri, Aug 31, 2012 at 4:47 PM, Anthony wrote: > On Thursday, August 30, 2012 10:44:51 PM UTC-4, Amit wrote: >> >> As I told you I have created my own custom html without extending >> layout.html. > > > "I have created my own

[web2py] Getting error " No module named facebook.modules.facebook"

2012-04-05 Thread Amit
try to run its giving error " No module named facebook.modules.facebook". I am new to web2py development so not sure whether i did something wrong or not, so please guide me to resolve this issue. Regards, Amit

[web2py] Re: Getting error " No module named facebook.modules.facebook"

2012-04-05 Thread Amit
Thanks for pointing to the actual problem, I put facebook.py into the application's modules folder and import the path has resolved the problem. Regards, Amit On Thursday, 5 April 2012 20:48:10 UTC+5:30, Anthony wrote: > > If you put the module in the application's /modules f

[web2py] is it possible to communicate over webservices in web2py application?

2012-05-01 Thread Amit
-directional communication between SERVER and N/W Panel AND how to integrate with Web2Py application? Web services can be SOAP OR REST. Regards, Amit

[web2py] Difference between web2py reference book edition4.0 and Web2py application development cookbook

2012-05-10 Thread Amit
ponse. Regards, Amit

[web2py] Re: Difference between web2py reference book edition4.0 and Web2py application development cookbook

2012-05-10 Thread Amit
thony > > On Thursday, May 10, 2012 6:24:08 AM UTC-4, Amit wrote: >> >> Hi, >> Can anyone please elaborate what is the difference between Web2py >> reference book edition 4.0 and Web2py application development cookbook? >> I have been searching some good coding e

[web2py] gae + wsgi testing with lettuce and webtest

2012-05-17 Thread amit
The overall setup is that I have a gae, wsgi application and I am trying to include lettuce with webtest to automate the testing. 1. I am trying to run lettuce from myapp/tests/ directory. 2. myapp/tests/features directory contains the features and steps description as input to lettuce. In one

Re: [web2py] Re: web2py book now free in PDF

2012-06-13 Thread Amit
I am able to download, its awesome ...thanks guys for your effort..can anybody put free version of web2py cook book also, it would be appreciable. On Wed, Jun 13, 2012 at 2:46 PM, Rahul wrote: > It does not work for me - I *cannot *get my hands to the free PDF :( > Accessed from both firefox and

[web2py] how to install web2py and deploy web2py application in ubuntu server?

2012-06-14 Thread Amit
I am new bee in web2py development so can anyone share me whole procedure of how to install web2py in ubuntu machine? And how to run web2py application in ubuntu machine? Please share me the procedure in details. Thanks in advance.

Re: [web2py] how to install web2py and deploy web2py application in ubuntu server?

2012-06-14 Thread Amit
cd scripts > ./setup-web2py-ubuntu.sh > And have fun! > You can see what it runs, which is most likely what we would tell you in > email by typing this... > cd scripts > gedit setup-web2py-ubuntu.sh > BR, > Jason Brower > > > On Thu, Jun 14, 2012 at 1:41 PM, Amit

Re: [web2py] how to install web2py and deploy web2py application in ubuntu server?

2012-06-14 Thread Amit
mysql in web2py(web2py supports both databases so what is advantage of using postgresql over using MySql?).? Regards, Amit On Fri, Jun 15, 2012 at 9:02 AM, Jason Brower wrote: > Built into web2py for when you develop locally is a server called Rocket. > This helps a lot because you don

Re: [web2py] how to install web2py and deploy web2py application in ubuntu server?

2012-06-14 Thread Amit
are amazing , i never thought of getting this much of support from you guys in such a short span of time..hats off to you guys... regards, Amit On Fri, Jun 15, 2012 at 9:56 AM, Jason Brower wrote: > Yeah, I did the script I mentioned to you earlier on ubuntu running on > amazon. Very easy i

[web2py] how to write on the wall of Facebook Friends?

2012-06-21 Thread Amit
Hi, I have to develop one web2py application which can write on the wall of Facebook friends and send mail as well, how to achieve it in web2py? regards, Amit --

[web2py] How to update UI and DB in web2py?

2012-07-02 Thread Amit
I have to implement one application in web2py where my app will have Restful web service which will collect the request data and insert or update to the database and after updating to db it will display all update data to the UI. Lets take an example of employee: I have employee table(employe

[web2py] auth email verification design question

2012-07-07 Thread amit
For the case that the email has not been verified by the user, request_reset_password can be overload to include "resend email verification request". Not sure if the above is a good idea?

Re: [web2py] Re: Converting Field of a SQLFORM.grid to local timezone of a user.....

2013-02-12 Thread Amit
Can we use "represent" callback in case of hugh number of rows(lets say 2 or more rows is there in db), will it not be causing to slow down the whole process, means, while converting utc time to target timezone's time one by one for each row and then displayed to UI using SQLFORM.grid()? Pleas

[web2py] Problem in SQLFORM.grid()

2012-10-28 Thread Amit
_id field of Add screen. Second problem is : How can I make “Email Ids” field to accept only email ids and maximum number of email ids should be allowed to enter is 5? Please help me resolve this issue. Regards, Amit --

[web2py] Problem in deploying ssl certificates to Rocket server.

2012-11-01 Thread Amit
nnot be shown because the authenticity of the received data could not be verified. Please contact the website owners to inform them of this problem. Alternatively, use the command found in the help menu to report this broken site.* Could anyone please help me out to resolve this issue? Regards, Amit --

Re: [web2py] Re: Problem in deploying ssl certificates to Rocket server.

2012-11-04 Thread Amit
know any other way to create these certificates without password on windows then please do share me. waiting for your response. Thanks, Amit On Fri, Nov 2, 2012 at 6:23 PM, Niphlod wrote: > certs are supposed to be generated without passwords. Even in apache, etc, > if you protect

Re: [web2py] Re: Problem in deploying ssl certificates to Rocket server.

2012-11-05 Thread Amit
certificate. SSL is OFF* and on browser it display following error message: *SSL received a record that exceeded the maximum permissible length. (Error code: ssl_error_rx_record_too_long)* So no idea, how to resolve this? Thanks, Amit On Mon, Nov 5, 2012 at 4:10 PM, Niphlod wrote: > the us

Re: [web2py] Re: Problem in deploying ssl certificates to Rocket server.

2012-11-05 Thread Amit
: ssl_error_rx_record_too_long) *Hope this will help you to understand the problem.* *Thanks, Amit* * On Mon, Nov 5, 2012 at 5:17 PM, LightDot wrote: > One way I know of is the same Niphlod told you in his previous post - use > openssl to generate the certificate. He gave you the complete command > example, I d

[web2py] Getting error "Login not allowed. No valid x509 crentials"

2012-11-06 Thread Amit
tps://127.0.0.1:8000/MyApp/default/index It is displaying below message on the browser: *Login not allowed. No valid x509 crentials* * * Please guide me what I am doing wrong. Regards, Amit --

Re: [web2py] Re: Problem in deploying ssl certificates to Rocket server.

2012-11-06 Thread Amit
ert. > ca-cert is used if you're willing to auth users through x509, but given > that your understanding on certificates is basic I'd say you don't need it. > > Il giorno martedì 6 novembre 2012 04:00:37 UTC+1, Amit ha scritto: >> >> Thanks for your respons

Re: [web2py] Re: Problem in deploying ssl certificates to Rocket server.

2012-11-06 Thread Amit
Hi Michele, I used Simpatica to generates the certificates but failed to deploy to the web2py server, please check once the first mail in this mail chain where I explained the problem in details. Regards, Amit On Tue, Nov 6, 2012 at 4:52 PM, Michele Comitini wrote: > I suggest looking at c

Re: [web2py] Re: Problem in deploying ssl certificates to Rocket server.

2012-11-06 Thread Amit
I am using Python 2.7.2. On Tue, Nov 6, 2012 at 6:33 PM, Michele Comitini wrote: > What is your python version? > > > 2012/11/6 Amit > >> Hi Michele, >> I used Simpatica to generates the certificates but failed to deploy to >> the web2py server, please check

Re: [web2py] Re: Problem in deploying ssl certificates to Rocket server.

2012-11-06 Thread Amit
Address) # IMPORTANT WE USE THE CERT SERIAL AS UNIQUE KEY FOR THE USER p['registration_id'] = self.serial Variables a undefined b undefined builtinreduce self.subject.surname [] self self.subject p {'first_name': 'A | m | i | t'

Re: [web2py] Re: Problem in deploying ssl certificates to Rocket server.

2012-11-06 Thread Amit
://www.cafesoft.com/products/cams/ps/docs30/admin/ConfiguringApache2ForSSLTLSMutualAuthentication.html So x509_auth.py expects surname but above link doesn't provide option to fill surname :( Regards, Amit On Tue, Nov 6, 2012 at 8:34 PM, Michele Comitini wrote: > self.subject

Re: [web2py] Re: Problem in deploying ssl certificates to Rocket server.

2012-11-07 Thread Amit
they make request for application but can't be able to access the application pages because on server command prompt it will ask for password, so how to make it password free? On Wed, Nov 7, 2012 at 6:52 PM, Michele Comitini wrote: > Amit, > > A "self" was missing this

[web2py] Optimized way to use web2py Scheduler

2012-11-08 Thread Amit
ed way to use web2py scheduler? Regards, Amit --

Re: [web2py] Re: Optimized way to use web2py Scheduler

2012-11-09 Thread Amit
o run more than one tasks at the same time period then I should go to the approach of starting more than one workers. Thanks, Amit On Fri, Nov 9, 2012 at 3:16 PM, Niphlod wrote: > ehm, missing something here: worker(s) do(es) auto-assignments of tasks. > there's no web2py involved in a

[web2py] ImportError: Cannot import module 'requests'

2012-11-12 Thread Amit
Hi, I am using scheduler in my application which will periodically sends mail to the user, but when i start worker on command prompt using web2py.py -K MyApp, its giving follwoing error on command prompt: D:\web2py2.1.1\web2py>web2py.py -K MyApp No handlers could be found for logger "web2py"

[web2py] Re: ImportError: Cannot import module 'requests'

2012-11-12 Thread Amit
module available on python ? > > i.e. if you open a python shell, what you get when you do > > import requests > > ? > > Il giorno lunedì 12 novembre 2012 10:12:08 UTC+1, Amit ha scritto: >> >> Hi, >> >> I am using scheduler in my application

[web2py] Re: ImportError: Cannot import module 'requests'

2012-11-12 Thread Amit
com"], "subject": "Update", "text": str(testmessage) } ) return r On Monday, 12 November 2012 15:00:43 UTC+5:30, Amit wrote: > > I am getting below error on python shell: > > Py

[web2py] Getting error near "interval_time": syntax error

2012-11-14 Thread Amit
del self.db._timings[:-TIMINGSSIZE] return ret Variables a ('SELECT status.serial_no, status.name, status.in...dated_on) GROUP BY status.serial_no, status.name;',) b {} self ret undefined self.cursor self.cursor.execute *I am suspecting something is wrong with Expression syntax but unable to catch it , please help me resolve this issue.* Thanks, Amit * * --

Re: [web2py] Re: Getting error near "interval_time": syntax error

2012-11-14 Thread Amit
db,"date('now','-interval_time minutes') > updated_on")* it returns nothing. So can you please help me out write the above query in Sqlite. Thanks, Amit On Wed, Nov 14, 2012 at 3:36 PM, Niphlod wrote: > > Il giorno mercoledì 14 novembre 2012 09:51:43 UTC+1, Amit

[web2py] Unable to call the onclick on my custom button on SQLFORM.grid

2012-11-19 Thread Amit
Hi, I have added one custom button after *Search* and *Clear* buttons of SQLFORM.grid but unable to associate the action onto it, onclick is not getting called.Please see below the code: grid = SQLFORM.grid(db.test_table,deletable=True) grid[0][1][1].components = [ TAG.button('testbutt

[web2py] Re: Unable to call the onclick on my custom button on SQLFORM.grid

2012-11-19 Thread Amit
Could you elaborate more on this with some example code? On Monday, 19 November 2012 19:13:58 UTC+5:30, Niphlod wrote: > > _onclick expects a javascript fragment to be executed. > > On Monday, November 19, 2012 2:40:24 PM UTC+1, Amit wrote: >> >> Hi, >> I have

[web2py] Re: Unable to call the onclick on my custom button on SQLFORM.grid

2012-11-19 Thread Amit
upon clicking the button , I need to make query to db and delete the records... On Monday, 19 November 2012 19:23:54 UTC+5:30, Niphlod wrote: > > the _onclick parameter is "translated" to just a plain onclick attribute > of the tag you're using. > > When you do in HTML mylink nothing will > hap

[web2py] Re: Unable to call the onclick on my custom button on SQLFORM.grid

2012-11-19 Thread Amit
I assume that just going to the "test" function and return back would not > be enough ? (i.e. a simple _href=URL('test') on that button) > > On Monday, November 19, 2012 2:56:36 PM UTC+1, Amit wrote: >> >> upon clicking the button , I need to make query

Re: [web2py] Re: Unable to call the onclick on my custom button on SQLFORM.grid

2012-11-20 Thread Amit
-**delete",_type="button",_href=U**RL('test')) > > > On Tuesday, November 20, 2012 6:27:18 AM UTC+1, Amit wrote: >> >> Thanks Niphold for sharing the example code, but still it is not working >> means upon clicking on the "Delete"

Re: [web2py] Re: Unable to call the onclick on my custom button on SQLFORM.grid

2012-11-20 Thread Amit
: > > > On Tuesday, November 20, 2012 10:19:25 AM UTC+1, Amit wrote: >> >> If I use A instead of button then its calling perfectly but i have to >> show Delete as a button not as a link. >> > > Style the A as a button. With bootstrap's included just add a clas

[web2py] Set: no tables selected

2012-11-20 Thread Amit
I have added button "Delete" beside Clear button on SQLFORM.grid and when user selects query and click on it , I am passing the query to my controller function and using regular expression I just prepending "db." and changing "=" to "==" and passing the query to the db() function but it throws

[web2py] Re: Set: no tables selected

2012-11-21 Thread Amit
ted* Same applies for delete() statement, even for delete we can't specify the database table name as a parameter like select(). On Wednesday, 21 November 2012 12:01:08 UTC+5:30, Amit wrote: > > I have added button "Delete" beside Clear button on SQLFORM.grid and when > user

[web2py] Re: Set: no tables selected

2012-11-21 Thread Amit
Fixed :). using smart_query: db.smart_query([db.status],query).delete() where query is in string format. On Wednesday, 21 November 2012 15:23:44 UTC+5:30, Amit wrote: > > I have done slight changes in the code and its working for select() > statement but still facing problem in case

  1   2   >