[web2py] Session Issues seen when users log into Web2py with an Andriod App
We have decided to use Web2py Framework to develop an Android app. As a part of the app, we would like to know the users who have logged in. My problem is that I can easily accomplish it ( auth.user_id ) though browser. However, when used with Andriod App, auth.user_id returns NONE. a) Because it works fine on Browser, the auth table is populated correctly. So, the AUTH settings are fine. b) The session ID is okay ( though the IP address is not populated correctly ). [Thu Jul 11 19:40:15 2013] [error] in Json to g [Thu Jul 11 19:40:15 2013] [error] auth.user_id = None [Thu Jul 11 19:40:15 2013] [error] response.session_id = None:93a38-4854-441f-a8c8-bcce624b1aff c) However, as seen above, the user_id returns null. d) The "events" table is also empty. Can anyone please tell me how to debug this issue? -- --- 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: ANN: first pre-alfa release (v0.2) of Web2Py_CC
ok i got it figure out. i have to install several more packages before i get it to work. i have to install - PIL - BeautifulSoup - ComTypes - ConfigObj hopefully this will help others in installing. I'll play will it and let you know if I find anything. Pai On Sep 3, 3:35 pm, Pai wrote: > still more problem > > D:\Development\python\web2py_cc\Web2Py>python Web2py_CC.py > Traceback (most recent call last): > File "Web2py_CC.py", line 19, in > from gui_support import * > File "D:\Development\python\web2py_cc\support\gui_support.py", line > 10, in > from language_support import Language_Current, Set_Language, > Flag_Object > File "D:\Development\python\web2py_cc\support\language_support.py", > line 254, in > from General_Globals import * > File "D:\Development\python\web2py_cc\support\General_Globals.py", > line 674, in > from inifile_support import inifile > File "D:\Development\python\web2py_cc\support\inifile_support.py", > line 130, in > from configobj import ConfigObj > ImportError: No module named configobj > CLOSE LANGUAGE LOG FILE > Error in atexit._run_exitfuncs: > Traceback (most recent call last): > File "C:\Python26\lib\atexit.py", line 24, in _run_exitfuncs > func(*targs, **kargs) > File "D:\Development\python\web2py_cc\support\language_support.py", > line 226, in _Close_Log > _LT_Log.close () > AttributeError: 'NoneType' object has no attribute 'close' > Error in sys.exitfunc: > Traceback (most recent call last): > File "C:\Python26\lib\atexit.py", line 24, in _run_exitfuncs > func(*targs, **kargs) > File "D:\Development\python\web2py_cc\support\language_support.py", > line 226, in _Close_Log > _LT_Log.close () > AttributeError: 'NoneType' object has no attribute 'close' > > Thanks for looking into this!! > > Pai > > On Sep 1, 12:17 pm, Stef Mientki wrote: > > > hi Chris, > > > On 01-09-2010 04:21, sociotech wrote: > > > > Stef, > > > > Thanks for developing what looks like an awesome environment for > > > web2py. > > > your welcome. > > > I tried installing it with your recommended dependencies on my Ubuntu > > > 10.04 system (Python 2.6) and got the following error: > > > > Traceback (most recent call last): > > > File "Web2py_CC.py", line 24, in > > > import wx.lib.agw.thumbnailctrl as TC > > > ImportError: No module named agw.thumbnailctrl > > > > I have wxpython installed (version wx-2.8-gtk2-unicode) so I'm not > > > sure what's missing. > > > I can imagine a few problems: > > 1. you have a much too old version of wxPython, you need at least 1.8.9.2, > > it should be available > > for ubuntu, as I used it myself on Ubuntu 10.04 > > 2. I've seen once a wx.Python version fro Ubuntu, where the agw module is > > not in the correct place > > 3. You've more than one version of wxPython on your system and Web2Py uses > > the wrong (older) version > > ( I don't now how to select the latest version, maybe someone else ?) > > Try if you can upload a newer version of wxPython. > > I don't have any experience / knowledge about Linux systems, > > and my Ubuntu version (running on a Virtual server has crashed completely). > > > let me know if you find the problem. > > cheers, > > Stef > > > > I'll keep following your development efforts and hope to get it > > > working so I can try it out. > > > > Thanks, > > > > Chris > > > > On Aug 27, 1:13 pm, Stef Mientki wrote: > > >> hello, > > > >> I'm proud to present the first pre-alfa release ofWeb2Py_CC. > > > >> *Windows*: as it's developed under windows, it runs without exceptions > > >> (and of course a few bugs ;-) > > >> Sorry, I wasn't able to produce an executable, because py2exe had > > >> problems (probably with my > > >> recently upgraded wxPython, and I can't go back). > > > >> *Fedora 13*: runs as expected > > > >> *Ubuntu 10*: 2 days ago, it runned as expected, but after an adviced > > >> upgrade of wxPython, my > > >> complete Ubuntu installation is ruined. > > > >> *Mac*: sorry I've no access to Mac > > > >> you can find some documentation here: > > >> http://mientki.ruhosting.nl/web2py/web2py_cc.html > > >> a download link and installation instructions are at the bottom of the > > >> above page. > > > >> have fun, > > >> Stef
[web2py] Re: ANN: first pre-alfa release (v0.2) of Web2Py_CC
still more problem
D:\Development\python\web2py_cc\Web2Py>python Web2py_CC.py
Traceback (most recent call last):
File "Web2py_CC.py", line 19, in
from gui_support import *
File "D:\Development\python\web2py_cc\support\gui_support.py", line
10, in
from language_support import Language_Current, Set_Language,
Flag_Object
File "D:\Development\python\web2py_cc\support\language_support.py",
line 254, in
from General_Globals import *
File "D:\Development\python\web2py_cc\support\General_Globals.py",
line 674, in
from inifile_support import inifile
File "D:\Development\python\web2py_cc\support\inifile_support.py",
line 130, in
from configobj import ConfigObj
ImportError: No module named configobj
CLOSE LANGUAGE LOG FILE
Error in atexit._run_exitfuncs:
Traceback (most recent call last):
File "C:\Python26\lib\atexit.py", line 24, in _run_exitfuncs
func(*targs, **kargs)
File "D:\Development\python\web2py_cc\support\language_support.py",
line 226, in _Close_Log
_LT_Log.close ()
AttributeError: 'NoneType' object has no attribute 'close'
Error in sys.exitfunc:
Traceback (most recent call last):
File "C:\Python26\lib\atexit.py", line 24, in _run_exitfuncs
func(*targs, **kargs)
File "D:\Development\python\web2py_cc\support\language_support.py",
line 226, in _Close_Log
_LT_Log.close ()
AttributeError: 'NoneType' object has no attribute 'close'
Thanks for looking into this!!
Pai
On Sep 1, 12:17 pm, Stef Mientki wrote:
> hi Chris,
>
> On 01-09-2010 04:21, sociotech wrote:
>
> > Stef,
>
> > Thanks for developing what looks like an awesome environment for
> > web2py.
>
> your welcome.
> > I tried installing it with your recommended dependencies on my Ubuntu
> > 10.04 system (Python 2.6) and got the following error:
>
> > Traceback (most recent call last):
> > File "Web2py_CC.py", line 24, in
> > import wx.lib.agw.thumbnailctrl as TC
> > ImportError: No module named agw.thumbnailctrl
>
> > I have wxpython installed (version wx-2.8-gtk2-unicode) so I'm not
> > sure what's missing.
>
> I can imagine a few problems:
> 1. you have a much too old version of wxPython, you need at least 1.8.9.2, it
> should be available
> for ubuntu, as I used it myself on Ubuntu 10.04
> 2. I've seen once a wx.Python version fro Ubuntu, where the agw module is not
> in the correct place
> 3. You've more than one version of wxPython on your system and Web2Py uses
> the wrong (older) version
> ( I don't now how to select the latest version, maybe someone else ?)
> Try if you can upload a newer version of wxPython.
> I don't have any experience / knowledge about Linux systems,
> and my Ubuntu version (running on a Virtual server has crashed completely).
>
> let me know if you find the problem.
> cheers,
> Stef
>
> > I'll keep following your development efforts and hope to get it
> > working so I can try it out.
>
> > Thanks,
>
> > Chris
>
> > On Aug 27, 1:13 pm, Stef Mientki wrote:
> >> hello,
>
> >> I'm proud to present the first pre-alfa release ofWeb2Py_CC.
>
> >> *Windows*: as it's developed under windows, it runs without exceptions
> >> (and of course a few bugs ;-)
> >> Sorry, I wasn't able to produce an executable, because py2exe had
> >> problems (probably with my
> >> recently upgraded wxPython, and I can't go back).
>
> >> *Fedora 13*: runs as expected
>
> >> *Ubuntu 10*: 2 days ago, it runned as expected, but after an adviced
> >> upgrade of wxPython, my
> >> complete Ubuntu installation is ruined.
>
> >> *Mac*: sorry I've no access to Mac
>
> >> you can find some documentation here:
> >> http://mientki.ruhosting.nl/web2py/web2py_cc.html
> >> a download link and installation instructions are at the bottom of the
> >> above page.
>
> >> have fun,
> >> Stef
[web2py] Re: view SQL query
+1 On Sep 1, 8:40 am, mdipierro wrote: > You cannot see all of them, You can see the last one > > print db._lastdb > > perhaps now that we have app logging capabilities we should add teh > ability to log all queries. > > On Sep 1, 6:24 am, Francisco Costa wrote: > > > How can I see the SQL queries made after loading a page?
[web2py] Re: ANN: first pre-alfa release (v0.2) of Web2Py_CC
Stef, did you get a chance to upload a new file? I tried again and same error. sorry for being persistence. I'm actually really excited about this. I having WingIDE but I'm actually a lot more excited about using this! Pai On Aug 27, 5:15 pm, Stef Mientki wrote: > On 27-08-2010 22:32, Pai wrote:> I ran it, got error > > > D:\Development\python\web2py_cc\Web2Py>python Web2py_CC.py > > Traceback (most recent call last): > > File "Web2py_CC.py", line 15, in > > """] > > TypeError: list indices must be integers, not tuple > > sorry I uploaded the wrong file. > cheers, > Stef > > > Pai > > > On Aug 27, 3:13 pm, Stef Mientki wrote: > >> hello, > > >> I'm proud to present the first pre-alfa release of Web2Py_CC. > > >> *Windows*: as it's developed under windows, it runs without exceptions > >> (and of course a few bugs ;-) > >> Sorry, I wasn't able to produce an executable, because py2exe had > >> problems (probably with my > >> recently upgraded wxPython, and I can't go back). > > >> *Fedora 13*: runs as expected > > >> *Ubuntu 10*: 2 days ago, it runned as expected, but after an adviced > >> upgrade of wxPython, my > >> complete Ubuntu installation is ruined. > > >> *Mac*: sorry I've no access to Mac > > >> you can find some documentation here: > >> http://mientki.ruhosting.nl/web2py/web2py_cc.html > >> a download link and installation instructions are at the bottom of the > >> above page. > > >> have fun, > >> Stef
[web2py] Re: ANN: first pre-alfa release (v0.2) of Web2Py_CC
I ran it, got error D:\Development\python\web2py_cc\Web2Py>python Web2py_CC.py Traceback (most recent call last): File "Web2py_CC.py", line 15, in """] TypeError: list indices must be integers, not tuple Pai On Aug 27, 3:13 pm, Stef Mientki wrote: > hello, > > I'm proud to present the first pre-alfa release of Web2Py_CC. > > *Windows*: as it's developed under windows, it runs without exceptions (and > of course a few bugs ;-) > Sorry, I wasn't able to produce an executable, because py2exe had problems > (probably with my > recently upgraded wxPython, and I can't go back). > > *Fedora 13*: runs as expected > > *Ubuntu 10*: 2 days ago, it runned as expected, but after an adviced upgrade > of wxPython, my > complete Ubuntu installation is ruined. > > *Mac*: sorry I've no access to Mac > > you can find some documentation here: > http://mientki.ruhosting.nl/web2py/web2py_cc.html > a download link and installation instructions are at the bottom of the above > page. > > have fun, > Stef
[web2py] Re: My editor ...
+1 On Aug 19, 3:12 pm, Stef Mientki wrote: > hello, > > I made a movie about the most important features of the editor I'm using, you > can see it here: > > http://mientki.ruhosting.nl/movies/web2py_1.html > > If there's enough interest, I'll make the application available under BSD > license. > At this moment, only under windows all features are available. > > cheers, > Stef
[web2py] Re: DAL question - highest date less than target date for each group of records w/ common field value
try below.
db().select(\
db.Members.ALL,\
maxDate,\
left=\
db.MemberEvents.on(db.Members.id ==
db.MemberEvents.MemberID),\
having=(maxDate > date)|
(db.MemberEvents.EventDate==None), \
groupby=db.Members.id)
Pai
On Jun 21, 12:01 am, "Joseph S. Greenawalt"
wrote:
> To clarify a bit, what I'm trying to do is very similar to
> this:http://www.xaprb.com/blog/2006/12/07/how-to-select-the-firstleastmax-...
> But with two tables that need to be joined, with dates instead of
> prices, and with a "target date" that serves as a cutoff point for the
> highest date (no events with dates after the target date should end up
> in the results). I want one result per member in the resulting rows.
> And I'd prefer to do it through the DAL, because if I don't, I'll have
> to pack the results (list of tupples) into a list dictionaries, which
> is too time consuming for the amount of records that I'm dealing with
> (any iterative approach in python is out).
>
> Thanks,
> Joe G.
>
> On Jun 20, 11:50 pm, "Joseph S. Greenawalt"
> wrote:
>
> > Sorry for the long subject line. I've got the following tables
> > (extraneous fields removed):
>
> > db.define_table('Members',\
> > Field("FirstName", "string"),\
> > Field("LastName", "string"))
>
> > db.define_table('MemberEvents',\
> > Field("MemberID", "integer"),\
> > Field("EventType", "string"),\
> > Field("EventDate", "string"))
>
> > The MemberEvents table holds multiple events for each member. Some
> > members may have no events; I want them to show up in the results as
> > well, but with Null/None values for the MemberEvents fields. What I'm
> > trying to do is join these two tables in such a way that I end up with
> > only the event that has the highest date that is less than a "target
> > date" parameter for each member. I've tried "groupby", but I can't
> > find a way to control which event is selected when the groups are
> > "collapsed". I've tried all kinds of things, but with no luck so
> > far. Here's my latest attempt (doesn't work):
>
> > maxDate = db.MemberEvents.EventDate.max()
> > results = db((db.MemberEvents.EventDate<=date)).select(\
> > db.Members.ALL,\
> > db.CaseManagers.ALL,\
> > maxDate,\
> > left=\
> > db.MemberEvents.on(db.Members.id == db.MemberEvents.MemberID),\
> > groupby=db.Members.id,\
> > having=(db.MemberEvents.EventDate==maxDate))
>
> > This gives an "Unknown column 'MemberEvents.EventDate' in 'having
> > clause'" error. Any help would be greatly appreciated. I'd even be
> > willing to paypal $30 to anyone who can solve this with the DAL (and
> > provide an explanation of the solution) -- without iterating over the
> > records in python (slow, I've got 1+ event records). I need this
> > to work quickly with lots of records. I've been stuck on this for
> > days and have a deadline rapidly approaching.
>
> > Thanks in advance,
> > Joe G.
[web2py] Re: Custom Form
That was easy.. thanks!
Pai
On Jun 18, 2:42 am, mdipierro wrote:
> form=SQLFORM.factory(Field('child',db.children,requires=IS_IN_DB(db(db.children.sex=='M')),'children.id','%
> (name)s')))
>
> On Jun 16, 11:48 pm, Pai wrote:
>
> > Is it possible to do checkbox with constraints?? For example,
> > consider following
>
> > db.define_table('children', Field('name'), Field('sex'))
>
> > db.children.insert('Tom', 'M')
> > db.children.insert('Jerry', 'M')
> > db.children.insert('Eve', 'F')
> > db.children.insert('Mary', 'F')
>
> > is it possible to create FORM Element which you can only select M
> > child?
>
> > basically, the form should only create checkbox with Tom and Jerry
>
> > SQLFORM(db.children) would create for all records exist.. is it
> > possible to put in some filtering??
[web2py] Re: Custom Form
bump.. anyone??
On Jun 16, 11:48 pm, Pai wrote:
> Is it possible to do checkbox with constraints?? For example,
> consider following
>
> db.define_table('children', Field('name'), Field('sex'))
>
> db.children.insert('Tom', 'M')
> db.children.insert('Jerry', 'M')
> db.children.insert('Eve', 'F')
> db.children.insert('Mary', 'F')
>
> is it possible to create FORM Element which you can only select M
> child?
>
> basically, the form should only create checkbox with Tom and Jerry
>
> SQLFORM(db.children) would create for all records exist.. is it
> possible to put in some filtering??
[web2py] Custom Form
Is it possible to do checkbox with constraints?? For example,
consider following
db.define_table('children', Field('name'), Field('sex'))
db.children.insert('Tom', 'M')
db.children.insert('Jerry', 'M')
db.children.insert('Eve', 'F')
db.children.insert('Mary', 'F')
is it possible to create FORM Element which you can only select M
child?
basically, the form should only create checkbox with Tom and Jerry
SQLFORM(db.children) would create for all records exist.. is it
possible to put in some filtering??
[web2py] Re: where are the auth table model?
there's an option to customized it. see below http://web2py.com/book/default/section/8/1?search=Customizing+Auth hope this helps :) Pai On Jun 15, 10:17 am, Jean-Guy wrote: > Hello, > > I would like to get the auth tables models to implement them in my app > cause web2py complain that they already are define when I move change > from dev to prod database within the same app... > > I had found those models, can't remember where they were... ;-) > > Jonhy
[web2py] Re: WebFactional restart web2py
ahhh thank you thank you :) I was looking for document about web2py on the webfactional site but only thing I found that that one pager! Pai On Jun 14, 12:56 am, Yarko Tymciurak wrote: > On Jun 14, 12:42 am, Pai wrote: > > > Hi, > > > total noob question here.. how do you restart web2py on > > webfactional? I ssh in and put in > > > python web2py.py -z 5 > > > it seems like it is trying to start another instance of web2py rather > > than trying to shut it down. Any body has any idea how shut it down > > and start it back up again? > > When you start web2py like this, you are indeed starting it on the > built-in server; your "served" webfaction web2py is served thru > apache+ mod_wsgi (apache module). > > RTM:: > From:http://docs.webfaction.com/software/django/config.html?highlight=rest... > > (it's just another wsgi app - everywhere it says django_app in the > link above, replace with "web2py_app" application): > -- > 1/ Open an SSH session. > > 2/ Switch to the web2py application’s directory. Enter cd ~/webapps/ > web2py_app where web2py_app is the name of the web2py application as > it appears in the control panel, and press Enter. > > 3/ Run the restart script. Enter ./apache2/bin/restart and press > Enter. Your web2py application restarts over a few seconds. > > Note > Alternatively, you may manually start and stop the Apache instance. To > stop the server, enter ./apache2/bin/stop and press Enter. To start > the server, enter ./apache2/bin/start and press Enter. > - > > - Yarko > > > > > any help is greatly appreciated :) > > > Pai
[web2py] WebFactional restart web2py
Hi, total noob question here.. how do you restart web2py on webfactional? I ssh in and put in python web2py.py -z 5 it seems like it is trying to start another instance of web2py rather than trying to shut it down. Any body has any idea how shut it down and start it back up again? any help is greatly appreciated :) Pai
[web2py] Re: question about webfactional
that works! Thanks annet! On May 8, 1:52 am, annet wrote: > Pai, > > The solution to your problem is described in this thread: > > http://groups.google.com/group/web2py/browse_thread/thread/504dd2deff... > > Basically you have to log on to webfaction via terminal/ssh and > manually create a directory in your remote web2py/applications > directory. You can then upload and install a packed web2py app via the > web interface. > > Kind regards, > > Annet.
[web2py] Re: question about webfactional
I give write permission to the entired web2py folder. still the same error. do i have to restart web2py? if so, how do i do that? i came from a window world. On May 7, 11:13 pm, mdipierro wrote: > probably a file permission issue. > > On May 7, 11:09 pm, Pai wrote: > > > Hi, > > > I sign up for webfactional and ask them to install web2py for my > > framework. They have it back to me within a couple of hours! I'm > > trying to start an application now but when I click on create, I got > > an error that said > > > "unabled to create application "test". " > > > I made some web2py app from my local host before and never had this > > problem. Where can I find where is the problem coming from? Anybody > > experiencing this problem? > > > Thanks in adance! > > > Pai
[web2py] question about webfactional
Hi, I sign up for webfactional and ask them to install web2py for my framework. They have it back to me within a couple of hours! I'm trying to start an application now but when I click on create, I got an error that said "unabled to create application "test". " I made some web2py app from my local host before and never had this problem. Where can I find where is the problem coming from? Anybody experiencing this problem? Thanks in adance! Pai
[web2py:18693] Re: Pycon 2009 - Important
humm where are you guys in pycon?? I walked around today and couldn't find you On Mar 12, 12:29 am, Jorge Vargas wrote: > On Thu, Mar 12, 2009 at 12:20 AM, Yarko Tymciurak wrote: > > We are working out details of what we'd like to propose to cover in the > > PyCon2009 web2py dojo, and it's looking pretty exciting. > > We will have some more announcements around this. > > Massimo will be starting us off, and Bruce Eckel will lead the dojo. > > Stephen and John of Wingware are planning on joining in on the dojo. Maybe > > you will too? > > Hello guys, > > I'm an outsider here, although I keep an eye on your list/product from > time to time. > > It will be great if you add yourself > tohttp://us.pycon.org/2009/sprints/projects/ > > You are also welcome to join ushttp://us.pycon.org/2009/sprints/projects/wsgi/ > > > Hope to see you at PyCon2009! > > Yarko > > > On Mon, Mar 9, 2009 at 9:35 AM, Paul Eden wrote: > > >> I would have liked to be there at the Dojo, but unfortunately I am flying > >> back to Arizona Saturday night. > > >> I'll definitely find the booth though. I can't wait to meet all of you. > > >> Paul > > >> On Mon, Mar 9, 2009 at 7:28 AM, mdipierro wrote: > > >>> Thanks Paul, > > >>> hope you can help with the booth too. We will also have a web2py Dojo > >>> on Saturday night. > > >>> Massimo --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "web2py Web Framework" group. To post to this group, send email to web2py@googlegroups.com To unsubscribe from this group, send email to web2py+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/web2py?hl=en -~--~~~~--~~--~--~---
[web2py:18134] Re: db backend
I did not know that Access can connect to other db backend. I can look into this. As for the file back end, I guess it would be Jet since that the default for the access file? On Mar 15, 11:04 pm, Yarko Tymciurak wrote: > Also, you know Access can connect to "external data" (SQL-Server), correct? > And you should know which "Access" file backend you want - Microsoft.Jet, or > Microsoft.ACE > > On Sun, Mar 15, 2009 at 11:01 PM, mdipierro wrote: > > > we can if/when > > 1) you are available to run some tests > > 2) not until after PyCon. > > > Massimo > > > On Mar 15, 10:54 pm, Pai wrote: > > > is it possible to add support to it? I'm doing a project which I > > > really want to used web2py but one of the requirement from the user is > > > that it has to be ms access on the backend. they need this so that > > > they can easily manipulated the data can able to create the reports > > > from it easily. > > > > On Mar 15, 12:46 pm, Yarko Tymciurak wrote: > > > > > On Sun, Mar 15, 2009 at 11:14 AM, Pai wrote: > > > > > > do you have a test script? I can run it to see if there's any > > problem > > > > > or not. > > > > > > On Mar 14, 7:13 pm, mdipierro wrote: > > > > > > We do not claim we support MS Access. If the MS Access uses the > > same > > > > > > SQL dialect as MS SQL than, we can add support easily but I am I do > > > > > > not know. > > > > > We do not have MS-Access support; > > > > > MS-Access (Microsoft.Jet or Microsoft.ACE for Office 2007-onward files) > > and > > > > MS-SQL (T-SQL language) are different. > > > > > Seehttp:// > > en.wikipedia.org/wiki/Microsoft_Jet_Database_Enginehttp://www > > > > andhttp:// > > sqlserver2000.databases.aspfaq.com/what-are-the-main-differenc... > > > > > > > Massimo > > > > > > > On Mar 14, 4:12 pm, Pai wrote: > > > > > > > > do we have support for MS Access? --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "web2py Web Framework" group. To post to this group, send email to web2py@googlegroups.com To unsubscribe from this group, send email to web2py+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/web2py?hl=en -~--~~~~--~~--~--~---
[web2py:18133] Re: db backend
I'll be happy to help running some test. I'll ping you about this again once pycon is over. Thanks! On Mar 15, 11:01 pm, mdipierro wrote: > we can if/when > 1) you are available to run some tests > 2) not until after PyCon. > > Massimo > > On Mar 15, 10:54 pm, Pai wrote: > > > is it possible to add support to it? I'm doing a project which I > > really want to used web2py but one of the requirement from the user is > > that it has to be ms access on the backend. they need this so that > > they can easily manipulated the data can able to create the reports > > from it easily. > > > On Mar 15, 12:46 pm, Yarko Tymciurak wrote: > > > > On Sun, Mar 15, 2009 at 11:14 AM, Pai wrote: > > > > > do you have a test script? I can run it to see if there's any problem > > > > or not. > > > > > On Mar 14, 7:13 pm, mdipierro wrote: > > > > > We do not claim we support MS Access. If the MS Access uses the same > > > > > SQL dialect as MS SQL than, we can add support easily but I am I do > > > > > not know. > > > > We do not have MS-Access support; > > > > MS-Access (Microsoft.Jet or Microsoft.ACE for Office 2007-onward files) > > > and > > > MS-SQL (T-SQL language) are different. > > > > Seehttp://en.wikipedia.org/wiki/Microsoft_Jet_Database_Enginehttp://www > > > andhttp://sqlserver2000.databases.aspfaq.com/what-are-the-main-differenc... > > > > > > Massimo > > > > > > On Mar 14, 4:12 pm, Pai wrote: > > > > > > > do we have support for MS Access? --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "web2py Web Framework" group. To post to this group, send email to web2py@googlegroups.com To unsubscribe from this group, send email to web2py+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/web2py?hl=en -~--~~~~--~~--~--~---
[web2py:18111] Re: db backend
is it possible to add support to it? I'm doing a project which I really want to used web2py but one of the requirement from the user is that it has to be ms access on the backend. they need this so that they can easily manipulated the data can able to create the reports from it easily. On Mar 15, 12:46 pm, Yarko Tymciurak wrote: > On Sun, Mar 15, 2009 at 11:14 AM, Pai wrote: > > > do you have a test script? I can run it to see if there's any problem > > or not. > > > On Mar 14, 7:13 pm, mdipierro wrote: > > > We do not claim we support MS Access. If the MS Access uses the same > > > SQL dialect as MS SQL than, we can add support easily but I am I do > > > not know. > > We do not have MS-Access support; > > MS-Access (Microsoft.Jet or Microsoft.ACE for Office 2007-onward files) and > MS-SQL (T-SQL language) are different. > > Seehttp://en.wikipedia.org/wiki/Microsoft_Jet_Database_Enginehttp://www.connectionstrings.com/ > andhttp://sqlserver2000.databases.aspfaq.com/what-are-the-main-differenc... > > > > > > Massimo > > > > On Mar 14, 4:12 pm, Pai wrote: > > > > > do we have support for MS Access? --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "web2py Web Framework" group. To post to this group, send email to web2py@googlegroups.com To unsubscribe from this group, send email to web2py+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/web2py?hl=en -~--~~~~--~~--~--~---
[web2py:18072] Re: db backend
do you have a test script? I can run it to see if there's any problem or not. On Mar 14, 7:13 pm, mdipierro wrote: > We do not claim we support MS Access. If the MS Access uses the same > SQL dialect as MS SQL than, we can add support easily but I am I do > not know. > > Massimo > > On Mar 14, 4:12 pm, Pai wrote: > > > do we have support for MS Access? --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "web2py Web Framework" group. To post to this group, send email to web2py@googlegroups.com To unsubscribe from this group, send email to web2py+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/web2py?hl=en -~--~~~~--~~--~--~---
[web2py:18043] db backend
do we have support for MS Access? --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "web2py Web Framework" group. To post to this group, send email to web2py@googlegroups.com To unsubscribe from this group, send email to web2py+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/web2py?hl=en -~--~~~~--~~--~--~---
[web2py:17713] Re: Pycon 2009 - Important
i'll be there :) hopefully it wouldn't be hard to fine.. On Mar 8, 7:19 pm, Yarko Tymciurak wrote: > If you're around for tutorials, come by to help stuff bags Thurs. afternoon > / evening for registration! :-) > > On Sun, Mar 8, 2009 at 7:08 PM, Pai wrote: > > > I'll be at pycon. it'll be my first pycon so i'm planning to attend > > most of the talk. i can drop by and help out whenever I can. I'll > > wear the t-shirt and/or patch if it's available ;) > > > On Mar 7, 4:29 pm, mdipierro wrote: > > > We have a booth at PyCon 2009. If you can me it let me know. > > > > I am looking for volunteers to make shifts at the booth and answer > > > people's questions about web2py. > > > > I may print t-shirts (depending on cost). > > > > If you want to propose a design please email it to me asap. > > > If you have suggestions on how/where to print them cheep please let me > > > know. > > > > If you are attending pycon and promise to wear the T-Shirt you get > > > one. > > > > Massimo --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "web2py Web Framework" group. To post to this group, send email to web2py@googlegroups.com To unsubscribe from this group, send email to web2py+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/web2py?hl=en -~--~~~~--~~--~--~---
[web2py:17693] Re: Pycon 2009 - Important
I'll be at pycon. it'll be my first pycon so i'm planning to attend most of the talk. i can drop by and help out whenever I can. I'll wear the t-shirt and/or patch if it's available ;) On Mar 7, 4:29 pm, mdipierro wrote: > We have a booth at PyCon 2009. If you can me it let me know. > > I am looking for volunteers to make shifts at the booth and answer > people's questions about web2py. > > I may print t-shirts (depending on cost). > > If you want to propose a design please email it to me asap. > If you have suggestions on how/where to print them cheep please let me > know. > > If you are attending pycon and promise to wear the T-Shirt you get > one. > > Massimo --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "web2py Web Framework" group. To post to this group, send email to web2py@googlegroups.com To unsubscribe from this group, send email to web2py+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/web2py?hl=en -~--~~~~--~~--~--~---
[web2py:16239] Re: CSV IO
Does this include validation while importing?? On Feb 11, 10:59 pm, mdipierro wrote: > I believe all outstanding issues with CSV export/import have been > resolved BUT make sure you have the latest appadmin.py in your > applications. Part of the bug was in the old appadmin.py. > > Massimo --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "web2py Web Framework" group. To post to this group, send email to web2py@googlegroups.com To unsubscribe from this group, send email to web2py+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/web2py?hl=en -~--~~~~--~~--~--~---
[web2py:10324] Re: database connection password
So what would the connection string look like?
db=SQLDB("mysql://username:[md5 password [EMAIL PROTECTED]:port/dbname")
On Oct 16, 1:28 pm, "Phyo Arkar" <[EMAIL PROTECTED]> wrote:
> So you can always use any algorighm (SHA , MD5) which already comes with
> python.
>
> On Thu, Oct 16, 2008 at 6:26 PM, Pai <[EMAIL PROTECTED]> wrote:
>
> > That's really all i'm looking for actually. The code will get pass
> > around to a couple of developers. I don't want the password to show
> > up in clear text.
>
> > On Oct 16, 11:20 am, "Phyo Arkar" <[EMAIL PROTECTED]> wrote:
> > > Yes , I couldn't agree more with you massimo.
>
> > > Security by Obscurity Fails Horribly .
>
> > > Pai what you looking will only prevent at the Source Code level , and any
> > > sniffer can grep that encrypted string and can decrypt (there are alot of
> > > MD5 decryption bots out in the internet, use one)
>
> > > On Thu, Oct 16, 2008 at 4:16 PM, mdipierro <[EMAIL PROTECTED]>
> > wrote:
>
> > > > This is a false security mechanism. Consider a communication between
> > > > A(lice) and B(ob). It can be protected against a third party (C) by
> > > > encrypting information (for example the password). It is logically
> > > > impossible to protect B from A.
>
> > > > Even if A only stores the encrypted password there are a number of
> > > > possible scenarios:
>
> > > > 1) it still needs to decrypt the password to authenticate to the
> > > > database
> > > > 2) it can authenticate to the database using the encrypted password
>
> > > > In both cases an attacker who gets control of A can access the
> > > > database. If A can access the attacker can access. Period.
>
> > > > Any other argument is just a distraction.
>
> > > > JBoss is just hiding the problem from storing the password into the
> > > > mechanism from decrypting the password and sending it to the
> > > > datastore. This behavior could be replicated in web2py but it would
> > > > not give you any real protection. This security via obfuscation.
>
> > > > Massimo
>
> > > > On Oct 16, 10:40 am, Pai <[EMAIL PROTECTED]> wrote:
> > > > > Ok so maybe this would be a better way to phrase the question. Is
> > > > > there a way in web2py to not write password in clear text. I know
> > > > > that you can do it in jboss..
>
> > > > > something like this..
>
> > > > >http://www.jboss.org/community/docs/DOC-9703
>
> > > > > Thanks!
>
> > > > > On Oct 15, 9:39 pm, mdipierro <[EMAIL PROTECTED]> wrote:
>
> > > > > > This is not a web2py issue.
>
> > > > > > There are two weak points.
>
> > > > > > 1) The connection between the web server(s) and the database
> > server.
> > > > > > You can secure it by using ssh, but the most common solution is
> > have a
> > > > > > local network behind the firewall and create firewall rules only
> > allow
> > > > > > traffic from the web server reach the database server. Even better
> > > > > > would be to give your web server(s) a second network card that is
> > ONLY
> > > > > > connected to the database server.
>
> > > > > > 2) No matter what you do, the web server needs to connect to the
> > > > > > database server. If somebody hacks into the web server, they can
> > talk
> > > > > > to your database. Nothing protects you for it. You would have the
> > same
> > > > > > issue with Java or PHP. All web applications suffer from this
> > issue.
> > > > > > The only thing you can do is to make sure your web server is as
> > secure
> > > > > > as possible:
>
> > > > > > a) use a secure framework (web2py i very advanced in this respect,
> > > > > > even the http accept-language field gets validated, you can check
> > what
> > > > > > other frameworks do)
> > > > > > b) disable every other service (do not even allow ssh connections
> > from
> > > > > > the internet, only from the internal private network)
> > > > > > c) do not run multiple apps on the web server so, if the hack into
> > > > > > one, they cannot get into the databases of the others.
> > > > >
[web2py:10321] Re: database connection password
That's really all i'm looking for actually. The code will get pass around to a couple of developers. I don't want the password to show up in clear text. On Oct 16, 11:20 am, "Phyo Arkar" <[EMAIL PROTECTED]> wrote: > Yes , I couldn't agree more with you massimo. > > Security by Obscurity Fails Horribly . > > Pai what you looking will only prevent at the Source Code level , and any > sniffer can grep that encrypted string and can decrypt (there are alot of > MD5 decryption bots out in the internet, use one) > > On Thu, Oct 16, 2008 at 4:16 PM, mdipierro <[EMAIL PROTECTED]> wrote: > > > This is a false security mechanism. Consider a communication between > > A(lice) and B(ob). It can be protected against a third party (C) by > > encrypting information (for example the password). It is logically > > impossible to protect B from A. > > > Even if A only stores the encrypted password there are a number of > > possible scenarios: > > > 1) it still needs to decrypt the password to authenticate to the > > database > > 2) it can authenticate to the database using the encrypted password > > > In both cases an attacker who gets control of A can access the > > database. If A can access the attacker can access. Period. > > > Any other argument is just a distraction. > > > JBoss is just hiding the problem from storing the password into the > > mechanism from decrypting the password and sending it to the > > datastore. This behavior could be replicated in web2py but it would > > not give you any real protection. This security via obfuscation. > > > Massimo > > > On Oct 16, 10:40 am, Pai <[EMAIL PROTECTED]> wrote: > > > Ok so maybe this would be a better way to phrase the question. Is > > > there a way in web2py to not write password in clear text. I know > > > that you can do it in jboss.. > > > > something like this.. > > > >http://www.jboss.org/community/docs/DOC-9703 > > > > Thanks! > > > > On Oct 15, 9:39 pm, mdipierro <[EMAIL PROTECTED]> wrote: > > > > > This is not a web2py issue. > > > > > There are two weak points. > > > > > 1) The connection between the web server(s) and the database server. > > > > You can secure it by using ssh, but the most common solution is have a > > > > local network behind the firewall and create firewall rules only allow > > > > traffic from the web server reach the database server. Even better > > > > would be to give your web server(s) a second network card that is ONLY > > > > connected to the database server. > > > > > 2) No matter what you do, the web server needs to connect to the > > > > database server. If somebody hacks into the web server, they can talk > > > > to your database. Nothing protects you for it. You would have the same > > > > issue with Java or PHP. All web applications suffer from this issue. > > > > The only thing you can do is to make sure your web server is as secure > > > > as possible: > > > > > a) use a secure framework (web2py i very advanced in this respect, > > > > even the http accept-language field gets validated, you can check what > > > > other frameworks do) > > > > b) disable every other service (do not even allow ssh connections from > > > > the internet, only from the internal private network) > > > > c) do not run multiple apps on the web server so, if the hack into > > > > one, they cannot get into the databases of the others. > > > > d) Do not run any PHP or ASP app on the same server running web2py. > > > > There are many of them and many have known vulnerabilities that > > > > vulnerability scanners know how to exploit. > > > > e) store the database on a filesystem that has journaling and you can > > > > go back to a previous state and backup your database > > > > f) have an intrusion detection system that looks for scans and blocks > > > > the IP of the scanner before he can get in. > > > > g) setup a honeypot so they want to hack, they hack into that first > > > > and you can take action. > > > > > There is no solution to this problem. Only good practice. > > > > > Massimo > > > > > On Oct 15, 8:50 pm, morningovermidnight <[EMAIL PROTECTED]> > > > > wrote: > > > > > > Massimo > > > > > > I too am concerned about the security of my DB password from prying > > > > > eyes
[web2py:10314] Re: database connection password
Ok so maybe this would be a better way to phrase the question. Is
there a way in web2py to not write password in clear text. I know
that you can do it in jboss..
something like this..
http://www.jboss.org/community/docs/DOC-9703
Thanks!
On Oct 15, 9:39 pm, mdipierro <[EMAIL PROTECTED]> wrote:
> This is not a web2py issue.
>
> There are two weak points.
>
> 1) The connection between the web server(s) and the database server.
> You can secure it by using ssh, but the most common solution is have a
> local network behind the firewall and create firewall rules only allow
> traffic from the web server reach the database server. Even better
> would be to give your web server(s) a second network card that is ONLY
> connected to the database server.
>
> 2) No matter what you do, the web server needs to connect to the
> database server. If somebody hacks into the web server, they can talk
> to your database. Nothing protects you for it. You would have the same
> issue with Java or PHP. All web applications suffer from this issue.
> The only thing you can do is to make sure your web server is as secure
> as possible:
>
> a) use a secure framework (web2py i very advanced in this respect,
> even the http accept-language field gets validated, you can check what
> other frameworks do)
> b) disable every other service (do not even allow ssh connections from
> the internet, only from the internal private network)
> c) do not run multiple apps on the web server so, if the hack into
> one, they cannot get into the databases of the others.
> d) Do not run any PHP or ASP app on the same server running web2py.
> There are many of them and many have known vulnerabilities that
> vulnerability scanners know how to exploit.
> e) store the database on a filesystem that has journaling and you can
> go back to a previous state and backup your database
> f) have an intrusion detection system that looks for scans and blocks
> the IP of the scanner before he can get in.
> g) setup a honeypot so they want to hack, they hack into that first
> and you can take action.
>
> There is no solution to this problem. Only good practice.
>
> Massimo
>
> On Oct 15, 8:50 pm, morningovermidnight <[EMAIL PROTECTED]>
> wrote:
>
> > Massimo
>
> > I too am concerned about the security of my DB password from prying
> > eyes. I understand that when the database connection url uses
> > localhost as in -> db=SQLDB('mysql://username:[EMAIL PROTECTED]:
> > 3306/mydatabase'), when I upload to a shared webhosting server, to
> > connect to the DB I am using my domain as in -> db=SQLDB('mysql://
> > username:[EMAIL PROTECTED]:3306/mydatabase'). Is this secure?
> > It does make me wonder if I am sending this information in the
> > clear. :-/
>
> > On Oct 15, 8:50 pm, mdipierro <[EMAIL PROTECTED]> wrote:
>
> > > In a typical production setting you would have a web server exposed to
> > > the internet and a secure local network. The connection with the
> > > database should go only over the local network. ssh will protect you
> > > from employees snooping around (and stealing database password) but
> > > will make the database connection more of a bottleneck. Nor ssh nor
> > > password will protect you in case somebody hacks into the web server
> > > and acquires the credentials of the web server. If your web app can
> > > access the DB, the attacker can too. To some extend one can also
> > > configure the db engine to accept only connections form certain IPs
> > > and limit the roles of the user associated to the web app.
>
> > > This is why it is very important to try prevent vulnerabilities in web
> > > apps.
>
> > > Massimo
>
> > > On Oct 15, 5:50 pm, achipa <[EMAIL PROTECTED]> wrote:
>
> > > > Depends of why he needs to hide the connection parameters in the first
> > > > place...
>
> > > > Yarko: you can always do mysql over ssh. Not for the faint at heart,
> > > > but it IS paswordless and secure.
>
> > > > On Oct 15, 9:44 pm, yarko <[EMAIL PROTECTED]> wrote:
>
> > > > > I think the issue is: if the db server is on the same box, and the
> > > > > box is secure, then that's a limited issue;
> > > > > If the db server is accross a network, then nothing web2py (or
> > > > > anything else connecting) can help, without the support of the db -
> > > > > this practically means you find an alternate way of authenticating on
> > > > > the db .
>
> > > > > On Oct 15, 2:05 pm, mdipierro <[EMAIL PROTECTED]> wrote:
>
> > > > > > No that I know of.
>
> > > > > > On Oct 15, 11:42 am, Pai <[EMAIL PROTECTED]> wrote:
>
> > > > > > > Is there a way to hide password in the connection-string?
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups
"web2py Web Framework" group.
To post to this group, send email to web2py@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/web2py?hl=en
-~--~~~~--~~--~--~---
[web2py:10281] database connection password
Is there a way to hide password in the connection-string? --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "web2py Web Framework" group. To post to this group, send email to web2py@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/web2py?hl=en -~--~~~~--~~--~--~---
