Re: [web2py] Re: postgres connect problem

2012-07-11 Thread lucas
ing centos 6.2 and the "web2py_install" script found at: http://www.web2pyslices.com/slice/show/1423/deploy-web2py-on-fedoracentosred-hat lucas

Re: [web2py] Re: postgres connect problem

2012-07-11 Thread lucas
) works fine also with no issues and conn shows a proper connection object. so damn, even the psycopg2 driver is working either. lucas

[web2py] insert() syntax problem

2012-08-05 Thread lucas
d can't be an expression" advice, please. lucas --

[web2py] howto subset a select element

2012-08-13 Thread lucas
_id, which is known from auth.user_id at the time of login. so how do you present only a subset of values for the select element of a form under some kind of boolean test condition? thanx in advance, lucas --

[web2py] Re: howto subset a select element

2012-08-13 Thread lucas
oh my, that is so perfect, i love that. i learned a new word and i am going to use it everywhere. thanx anthony. p.s. hey, when is web2py v2.0 going to be stable and released full? doesn't it have angularjs built into it also? --

[web2py] Re: howto subset a select element

2012-08-14 Thread lucas
id)s)')), and: Field('lecture_item_id', db.lecture_items, requires=IS_IN_DB(db(db.lecture_items.lecture_id == db.class_assignments.lecture_id), db.lecture_items.id, '%(title)s (%(id)s)')), but both attempts failed. so how do i do a subselect kind of model? thanx in advance, lucas --

[web2py] Re: howto subset a select element

2012-08-14 Thread lucas
it should be in the referencing table, however, it is ok to leave it blank and the controller will handle it according to design. how do i define that requires? thanx again in advance, i am really learning the poop out of this system. lucas --

[web2py] cascading drop down list

2012-08-15 Thread lucas
return "omg dude" also tried: def ajaxLectureItems(): return OPTION("omg dude", _value="1") and other permutations, but i am just not getting any return result with no errors. so i think it is in the onchange area somewhere. using web2py 1.99.2. lucas --

[web2py] {{code}} compile in view

2012-08-28 Thread lucas
however, how does web2py execute string into code, run it, and return the "return" variable that has the dictionary keys:values generated from that executed code? lucas --

[web2py] Re: {{code}} compile in view

2012-08-29 Thread lucas
what using restricted or snapshot? would that be best and is it visible to us normal web2py users? --

[web2py] Re: {{code}} compile in view

2012-08-29 Thread lucas
ok, that is fine for simple code execution, but what of the more complex? how does web2py execute all of that complex code we can embed within a view? that is what i want to reproduce in my scheme. --

[web2py] Re: {{code}} compile in view

2012-08-29 Thread lucas
field, allow web2py to execute it, and finally return the dictionary so that it can be further used in the view or other processes. i know it is a bit dynamic, and thus difficult to give more details, so i am hoping that that is more clear. let me know. ok. lucas --

[web2py] Re: {{code}} compile in view

2012-08-29 Thread lucas
ok, i see the source code for restricted but its use eludes me a bit. how do i grab its executed processed output? --

[web2py] Re: {{code}} compile in view

2012-08-30 Thread lucas
function lucas53. i do not know how to access the local variables within lucas53 or the locals to find harry or rtn. so i am still learning python. thanx for the help in advance. lucas --

[web2py] internal error crash with newest 2.0.6 and old 1.99.2

2012-09-03 Thread lucas
i have been having a problem with users logging in or registering. web2py seems to crash on some level and returns an internal error after the user hits submit upon registering or logging in. i was initially getting the error on my web2py version installed of 1.99.2, so i updated to the latest

[web2py] Re: internal error crash with newest 2.0.6 and old 1.99.2

2012-09-03 Thread lucas
in those areas i will capture exceptions and rollback as suggested. what exactly is the exception for the db or DAL? like > > try: some code except DBException on e: db.rollback() return 'db exception: %s' % e just so that i can at least return more tracking information also. lucas --

[web2py] 2.0.6 editor

2012-09-03 Thread lucas
g for me and the find box is very different and it doesn't have replace. has anyone else complained like i am, don't want to be the only big whiny one. anyway, great on everything. lucas --

[web2py] Re: internal error crash with newest 2.0.6 and old 1.99.2

2012-09-04 Thread lucas
anymore possible areas of danger i should be looking for because this instability is pretty bad? lucas --

[web2py] Re: internal error crash with newest 2.0.6 and old 1.99.2

2012-09-04 Thread lucas
yes, i mean ticket, sorry. should i just delete the session manually or should i do it programmatically? --

[web2py] Re: internal error crash with newest 2.0.6 and old 1.99.2

2012-09-06 Thread lucas
wondering, almost desperate. lucas --

[web2py] Re: internal error crash with newest 2.0.6 and old 1.99.2

2012-09-06 Thread lucas
pt to say that it is > occuring at login. i don't know exactly what kind of error postgres might > give, but it looks like it commits and tidies up after the queries just > fine. not really seeing any problem there and it only confirms that web2py > is bugging during the log

Re: [web2py] Re: internal error crash with newest 2.0.6 and old 1.99.2

2012-09-07 Thread lucas
On Friday, September 7, 2012 4:57:37 AM UTC-4, Michele Comitini wrote: > > lucas, > > OK. So there is no error at SQL level. The problem is probably a closing > cursor that happens somewhere in the DAL, that is triggered by some > usage/environment peculiar to your applicat

Re: [web2py] Re: internal error crash with newest 2.0.6 and old 1.99.2

2012-09-11 Thread lucas
up to date. so i am still having trouble finding if it is the postgresql-9.1, the pg8000 driver, web2py, the DAL, my code, my views, i just don't know. pretty frustrating. lucas --

Re: [web2py] Re: internal error crash with newest 2.0.6 and old 1.99.2

2012-09-11 Thread lucas
avails itself to bring in stability. please. lucas --

Re: [web2py] Re: internal error crash with newest 2.0.6 and old 1.99.2

2012-09-11 Thread lucas
On Tuesday, September 11, 2012 10:35:02 AM UTC-4, Massimo Di Pierro wrote: > > Some problems have been reported with pg8000. Can you reproduce the errors > with psycopg2. yes, i can reinstall the psycopg2 rpm package. how do you specify and ensure that web2py is using that driver in the DAL?

Re: [web2py] Re: internal error crash with newest 2.0.6 and old 1.99.2

2012-09-11 Thread lucas
sycopg.so: undefined symbol: GSS_C_NT_HOSTBASED_SERVICE is there a good forum for psycopg2 anywhere? lucas --

Re: [web2py] Re: internal error crash with newest 2.0.6 and old 1.99.2

2012-09-12 Thread lucas
it took a while to figure this out, but with the postgres repository that i am using for 9.1, the python-psycopg2 rpm that is installed on my system is from the pgdg91 repository. so i would have to conclude that the psycopg2 driver from that repository is for postgresql-9.1 and not the centos

[web2py] Amazon EC2 discussion

2012-04-30 Thread lucas
nions. lucas

[web2py] Amazon EC2 discussion: pros/cons, etc.

2012-04-30 Thread lucas
thanx in advance and i look forward to your experienced opinions. lucas

[web2py] Re: Amazon EC2 discussion: pros/cons, etc.

2012-04-30 Thread lucas
wow, really, so did you actually install freebsd on your EC2 harddisk slice because i don't see freebsd under the amazon EC2 operating systems. i do see redhat enterprise 6, which is probably very very similar to centos 6. and with that freebsd install, did you install and use a relational da

[web2py] IS_IN_DB

2012-05-12 Thread lucas
e not in database". i believe it is not referencing the id from the pull-down list properly, or so. please suggest. thank you in advance. lucas

[web2py] empty field

2012-05-13 Thread lucas
l.py", line 3842, in __getitem__ return dict.__getitem__(self, key) KeyError: 'create_lecture_foldername' so isn't there a better way then the try|except block. lucas

[web2py] loop created forms

2012-05-14 Thread lucas
dy.append(d) and i have noticed with say two DIV opinion forms that web2py is giving different values for the _formkey. good. so why is it when a user enters in their opinion and pushes submit, it does not enter the opinion in the database? is there a better way to structure this so that the function accepts the processed form? what is the best method of creating forms via a loop or on the fly based on database records? thanx in advance, lucas

[web2py] Re: loop created forms

2012-05-14 Thread lucas
? or, what is the best approach to soft-coding variable names in python to achieve that? thanx in advance, lucas

[web2py] Re: loop created forms

2012-05-14 Thread lucas
sure i can us the id from the table of sections. but how to i attach that id number to a variable and python recognize that "string" as a variable name that i can then access again for the form processing? i guess this is more of a python question now then a web2py. lucas

[web2py] Re: loop created forms

2012-05-14 Thread lucas
i did try messing around with f = SQLFORM(db.opinions) f.vars.stuff.assignments... exec 'f%s = %s' % (i.id, f) if (exec 'f%s' % i.id).process().accepted: session.flash = 'Thank you for your opinion'

[web2py] Re: loop created forms

2012-05-15 Thread lucas
omg, that is so totally working. cool. i am almost there. i added this at the top of my function if ((request.vars._formname<>None) and (request.vars._formname.rfind('opinion_')>-1)): f = SQLFORM(db.lecture_item_opinions) f.vars.lecture_id=lecture.id f.vars.lecture_

[web2py] Re: loop created forms

2012-05-15 Thread lucas
yes, thank you so much. i learned some very subtle things here and i love the way it works. thank you so much. web2py is so powerful and so cool.

[web2py] update not updating

2012-05-16 Thread lucas
alse, readable=False), thank you in advance and have a great day. lucas

[web2py] uncompiling an application

2012-05-18 Thread lucas
hello one and all, i inadvertenly compiled my application. how do i get back to where i can edit it again? like how do i uncompile it or unpack it? i didn't lose the source did i? lucas

[web2py] html5 background video script

2012-07-05 Thread lucas
. lucas

[web2py] postgres connect problem

2012-07-11 Thread lucas
init__ self._adapter = ADAPTERS[self._dbname](*args) File "/opt/web-apps/web2py/gluon/dal.py", line 1999, in __init__ self.driver = self.drivers.get('pg8000') AttributeError: 'list' object has no attribute 'get' postgres is running but it will not connect. any ideas? lucas

[web2py] Re: postgres connect problem

2012-07-11 Thread lucas
my install does recognize the pg8000 driver: [root@q3200 web2py]# python web2py.py web2py Web Framework Created by Massimo Di Pierro, Copyright 2007-2011 Version 1.99.7 (2012-03-04 22:12:08) stable Database drivers available: SQLite3, pymysql, pg8000, IMAP Starting hardcron...

[web2py] Re: postgres connect problem

2012-07-11 Thread lucas
and i did "CREATE DATABASE testbank;" under psql and it does exist as an empty database at this point.

[web2py] register/login post processing

2013-04-13 Thread lucas
hello one and all, how can i intercept the register and login functions to add code after each has run? i essentially want to run some checks on the newly logged in user and then redirect them as necessary. thanx in advance. lucas -- --- You received this message because you are

[web2py] Re: register/login post processing

2013-04-13 Thread lucas
how come the following doesn't work? it should just return a simple page. just for testing for now... def check_login(form): return HTML(BODY('%s%s' % (auth.user_id, 'test'))) auth.settings.login_onaccept = check_login auth.settings.register_onaccept = check_login -- --- You received t

[web2py] Re: register/login post processing

2013-04-13 Thread lucas
nice, perfect and working simple and effective. thanx anthony. lucas -- --- 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...@google

[web2py] DAL best opinions

2013-04-13 Thread lucas
either reference the auth_user table id OR the firms table id? thanx in advance. lucas -- --- 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

[web2py] Re: DAL best opinions

2013-04-13 Thread lucas
irms.id, '%(id)s'),.. . i know this is wrong, but how can i best do this sort of thing? lucas -- --- 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

[web2py] Re: DAL best opinions

2013-04-14 Thread lucas
ok, i had a little revelation in my sleep, have both fields IS_EMPTY_OR with IS_IN_DB, but how can i add the extra condition that one or the other must not be empty? db.define_table('payments', Field('user_id', db.auth_user, requires=IS_EMPTY_OR(IS_IN_DB(db, db.auth_user.id, '%(last_name)s,

[web2py] change admin password in command line

2012-10-08 Thread lucas
hello one and all, using linux, centos 6, and web2py 2.0.9. how do i update or change the admin password under the console or command-line editor? thanx in advance, lucas --

[web2py] long load time for scipy package

2012-11-01 Thread lucas
hing comes crashing down. however, once it is loaded it all runs very smooth and very fast, even the scipy functionality. any suggestions to make scipy load much quicker under web2py? thanx in advance, lucas --

[web2py] Re: long load time for scipy package

2012-11-01 Thread lucas
that was totally haunting me so badly. now that is real professor talk. thanx massimo, have a great weekend. lucas --

[web2py] Re: NEWINSTALL not working

2012-12-17 Thread lucas
probably related: using web2py 2.3.1 stable, centos 6.3, httpd apache 2 (2, 3, 1, datetime.datetime(2012, 12, 14, 15, 24, 12), 'stable')PythonPython 2.6.6: /usr/bin/pythonTRACEBACK 1. 2. 3. 4. 5. 6. 7. 8. 9. Traceback (most recent call last): File "/opt/web-apps/web2py/gluon/main.py", line

[web2py] hello3.xml question

2012-12-19 Thread lucas
html returned functions and it doesn't convert it into xml. so how is that done because i want to be able to have some data sent as an xml doc as hello3 function? because to me it seems that hello3 just looks like a regular html template with dict returned from the function. thanx in advance, lucas --

[web2py] Re: hello3.xml question

2012-12-19 Thread lucas
oh yeah, that worked absolutely great. thank you so much. so cool, data can be stripped and sent so many different ways. so sweet. lucas --

[web2py] upload field without the upload

2012-12-25 Thread lucas
populate the fields using a db.table_name.insert(*...***) without web2py wanting to actually upload the file? thanx in advance, lucas --

Re: [web2py] upload field without the upload

2012-12-25 Thread lucas
ission=permission, name=fname, ext=fext, type=ftype, description=fdsc, file=ffile) where file is the upload field and i am passing it a string, most of which look something like files.file.8710083b15af8a66.5044505f4c756b6163735f4e6f6973652d52656a656374696f6e5f525349312e706466.pdf so what am i doing wrong? lucas --

Re: [web2py] upload field without the upload

2012-12-25 Thread lucas
ok, what if i just upload the file? how do i do that programmically? lucas --

[web2py] Re: Upload file from bash script

2012-12-26 Thread lucas
function? just confused i guess, missing so critical points. lucas --

[web2py] Re: Upload file from bash script

2012-12-26 Thread lucas
ourapp/default/upload/givenfilename.txt > > so, how is this statement executed if it isn't under a function? second, is curl part of python 2.6 and above or not. i read that it is but my python's don't have it native. i think i need this spelled out for me, sorry for my ignorance. lucas --

[web2py] import numpy and scipy slows function return

2012-12-31 Thread lucas
command line, import of either of these libraries is very very quick. so how do i increase the speed of loading these libraries in web2py? thanx in advance. lucas --

Re: [web2py] import numpy and scipy slows function return

2013-01-02 Thread lucas
have a good link that explains that? so i figured i would just show and ask. i am importing like this: import numpy from scipy import stats from scipy import optimize which one of these takes the longest to load? i am optimizing for speed and can adjust the code accordingly. thanx lucas --

[web2py] crud update with writeable=readable=False

2012-01-05 Thread lucas
or the admin and then add this field manually to the crud object after it is created so that the admin can edit the field. please advise me into which of the two scenarios is best and exactly how to do it. thank you in advance and have a great day. lucas

[web2py] Re: crud update with writeable=readable=False

2012-01-05 Thread lucas
much. lucas

[web2py] Re: crud update with writeable=readable=False

2012-01-05 Thread lucas
n and web2py is really great. i am learning it and loving it. lucas

[web2py] crud.update comments False

2012-01-06 Thread lucas
hello one and all, how do i shut off or disable the 3rd column of comments under crud.update? also, how can i change the number of columns and rows of a textarea for a text blob field? basically i wan to make it bigger? thank you in advance and talk to you soon. lucas

[web2py] crud insert master/detail master.id

2012-01-06 Thread lucas
data almost perfectly. but it doesn't give the proper value of the blog_id field to point back to its master record. and upon reflection, how would it? how do i designation the db.blog_items.blog_id under the blog_items function so crud.create will insert the record properly and fill the blog_id field also? thank you in advance. lucas

[web2py] Re: crud insert master/detail master.id

2012-01-06 Thread lucas
le. i really am impressed with web2py and haven't enjoyed programming since delphi went south. lucas

[web2py] Re: crud.update comments False

2012-01-11 Thread lucas
working perfect, thanx again anthony. lucas

[web2py] Re: crud.update comments False

2012-01-11 Thread lucas
working perfect, thanx again anthony. lucas

[web2py] Re: crud.update comments False

2012-01-11 Thread lucas
working perfect, thanx again anthony. lucas

[web2py] admin password

2012-01-12 Thread lucas
hello one and all, i am stupid. i forgot the web2py admin password on my server and i can't access the https interface. how can i change the password? is there a simple script i can run as root or something? thanx in advance. i know the technique is somewhere, i just can't find it. lucas

[web2py] postgresql DAL connection issue

2011-09-25 Thread lucas
rror, "Failure to connect, tried %d times:\n%s" % (attempts, error) RuntimeError: Failure to connect, tried 5 times: could not connect to server: Permission denied Is the server running on host "localhost" (127.0.0.1) and accepting TCP/IP connections on port 5432? any ideas on what i have not done properly??? thank you in advance and have a great day. lucas

[web2py] Re: postgresql DAL connection issue

2011-09-26 Thread lucas
... then into as lucas: > python Python 2.6.5 (r265:79063, Jun 25 2011, 08:36:25) [GCC 4.4.4 20100726 (Red Hat 4.4.4-13)] on linux2 >>>import psycopg2 >>> psycopg2.connect(database="prac2", user="lucas", >>> password="passwdnotposted"

[web2py] Re: postgresql DAL connection issue

2011-09-26 Thread lucas
[ OK ] Starting postgresql-9.1 service: [ OK ] then under lucas: > psql prac2 -U lucas -h 127.0.0.1 psql: FATAL: Ident authentication failed for user "lucas" > psql psql: FATAL: database "lucas" does not exist but this works > psql prac2

[web2py] Re: postgresql DAL connection issue

2011-09-27 Thread lucas
: #testing python and psycopg2 under lucas login worked well: > python >>>import psycopg2 >>>psycopg2.connect(database="prac2", user="lucas", password="passwdnotposted", >>>host="localhost") #which looks like it worked #testing ps

[web2py] Re: postgresql DAL connection issue

2011-09-27 Thread lucas
tions? advice? howto, please? lucas

[web2py] postgresql DAL connection issue with Enforced SELinux

2011-09-27 Thread lucas
k together well. thank you in advance and have a great day. lucas

[web2py] BR in default.py

2011-10-02 Thread lucas
even simpler like, def index(): body = 'dude man' return dict(body=body) and the html see it has the newline tag instead of as a string. so how to i embed the html tag under python controllers? thank you in advance. lucas

[web2py] Re: BR in default.py

2011-10-02 Thread lucas
ok, i must be missing something, because that is not working. i am running web2py v1.98.2 on apache 2.2.15 on centos 6.0. lucas

[web2py] Re: BR in default.py

2011-10-02 Thread lucas
yes anthony, both of those worked in the way you prescribed. thank you so much and have a nice day. lucas

[web2py] remove "login" from navbar

2011-10-07 Thread lucas
hello one and all, how do i direct auth to remove the "login" link from the navbar? i already tried auth.settings.actions_disabled.append('login') like you would to remove register, but that didn't seem to work. ideas? thank you in advance. lucas

[web2py] confused with install on centos 5.7

2011-10-12 Thread lucas
f so, please direct me to the thread or solution? thank you in advance and have a great day. lucas

[web2py] DAL total record count

2011-10-22 Thread lucas
hello one and all, i think this is easy. how do you get the actual record/row total/ count for a particular table in web2py under DAL? thank you in advance and have a great weekend. lucas

[web2py] Re: DAL total record count

2011-10-23 Thread lucas
thank you to both of you. i am learning this stuff and i always have to start at the base. lucas

[web2py] auth_user

2011-10-23 Thread lucas
ional_title.requires = IS_IN_SET(('','Ph.D.','M.D.','Ed.D.','M.B.A.','C.P.A.','P.A.','M.S.','M.A.')) auth.define_tables() but the bottom two requires to fill the lists are bugging out. suggestions on this modify? i don't need a custom auth_user so that is why i am trying to modify the default one. also, i would like to change to field order. how can i do that also? thank you in advance and have a great day. lucas

[web2py] Re: auth_user

2011-10-23 Thread lucas
that view? thanx in advance, lucas

[web2py] password_two

2011-10-23 Thread lucas
d_two which makes the form look a little funky if you set this classes in the css file. that could be fixed in the future correct? just a thought either way. lucas

[web2py] setting up using auth confusion

2011-10-24 Thread lucas
lay or not display certain information? i know a lot a related questions, but i just can't seem to find good documentation on it. thank you in advance and have a great week. lucas

[web2py] Re: password_two

2011-10-24 Thread lucas
at. thanx again, lucas

[web2py] Re: setting up using auth confusion

2011-10-24 Thread lucas
l that means is that user f...@gmail.com should be a Guest with permission set to true for "News Restricted". ok? how come when f...@gmail.com is logged in, auth.has_permission('News Restricted') proves False. Shouldn't it be True? thanx in advance and have a good day. lucas

[web2py] Re: setting up using auth confusion

2011-10-24 Thread lucas
y filter out the restricted rows, compile and display only the unrestricted rows? interesting suggestion. but i still can't get a True out of has_permission. that one first. thanx again. lucas

[web2py] Re: setting up using auth confusion

2011-10-24 Thread lucas
btw, i am using 1.98.2 and will probably upgrade to 1.99.2 soon.

[web2py] adding temp field in row

2011-10-25 Thread lucas
ea of what i am trying to do. suggestions? thank you in advance. lucas

[web2py] adjusting default select() behavior

2011-10-25 Thread lucas
30, and change the headers to remove the "news.". how do i do both of those customizations? thank you in advance and have a great day. lucas

[web2py] upload

2011-10-25 Thread lucas
files to the client computer. so how would i best do an upload from the server to the client. specifically, i want to store files under static or static/pdf and upload static files from there to the client. thank you in advance and have a great day. lucas

[web2py] Re: adjusting default select() behavior

2011-10-30 Thread lucas
thanx massimo, i guess that does give the most optimum customization and control. thank you. lucas

[web2py] lexical scanner

2011-10-31 Thread lucas
, that is probably exactly it. what is that called and how do we implement that on our own? thank you in advance and have a great day. lucas

[web2py] Re: lexical scanner

2011-11-01 Thread lucas
ot sure, so how does view get processed and separated by html and python code and then the python code is interpreted and run as executable code? thank you in advance, lucas

  1   2   3   4   5   >