actually let's make this conversation private during debugging until
we get to the bottom if it.
On Oct 21, 11:52 pm, mdipierro <[EMAIL PROTECTED]> wrote:
> That is because you are probably using proxy (mod_proxy?). The ip
> address stored in db does not affect validation.
>
> In gluon/globals.py there is
>
> try:
> key=request.cookies[response.session_id_name].value
> record_id,unique_key=key.split(':')
> if record_id=='0': raise Exception
> rows=db(table.id==record_id).select()
> if len(rows)==0 or rows[0].unique_key!=unique_key:
> raise Exception, "No record"
> #rows[0].update_record(locked=True)
> session_data=cPickle.loads(rows[0].session_data)
> self.update(session_data)
> except Exception, e:
>
> can you change it to
>
> try:
> key=request.cookies[response.session_id_name].value
> print key
> record_id,unique_key=key.split(':')
> if record_id=='0': raise Exception
> print 'here'
> rows=db(table.id==record_id).select()
> print rows
> if len(rows)==0 or rows[0].unique_key!=unique_key:
> raise Exception, "No record"
> #rows[0].update_record(locked=True)
> print 'here'
> session_data=cPickle.loads(rows[0].session_data)
> print session_data
> self.update(session_data)
> print 'there'
> except Exception, e:
>
> restart web2py, reload the page a couple of time and tell me what this
> output to the console?
>
> Massimo
>
> On Oct 21, 8:25 pm, ceej <[EMAIL PROTECTED]> wrote:
>
> > It happens when i put it on my remote linux server and use mysql on
> > there not on my mac. I think I found out why it creates a new session
> > on every page load though.
>
> > I looked at the records it was creating, and all the client_ip fields
> > were filled with 127.0.0.1.
>
> > My ip is not 127.0.0.1 as the website is hosted on webfaction.
>
> > If you can try on a server you will defiantly be able to recreate what
> > I'm getting. This is a serious issue for anyone wanting to have a
> > production site running on a server using mysql to hold the sessions.
>
> > Many thanks,
>
> > On Oct 20, 12:36 pm, mdipierro <[EMAIL PROTECTED]> wrote:
>
> > > Hi Ceej,
>
> > > I installed MySQL on my Mac (which was a pain) but I cannot reproduce
> > > the problem. I remember when you first raised the issue there was a
> > > problem with the file size. It was fixed then. It you possible your
> > > 'sessions' table did not migrate. I suggest manually remove the table
> > > and the associated .table files.
>
> > > I did have one problem with mysql on mac. Because of a MySQL bug that
> > > was supposedly fixed (not on the version I have) this statement issues
> > > by web2py "SET sql_mode='NO_BACKSLASH_ESCAPES';" results in an
> > > OperationalError. In order to test the issue you raised I had to
> > > comment that line in sql.py
>
> > > Massimo
>
> > > On Oct 17, 2:11 pm, ceej <[EMAIL PROTECTED]> wrote:
>
> > > > Hi there,
>
> > > > If i use session.connect(request,response,tablename='sessions',db=db)
> > > > on my production server which uses MySQL It resets the sessions on
> > > > every page load, it works fine in my development server that uses
> > > > sqlite. I know i mentioned this before, did you get a chance to have a
> > > > look at it?
>
> > > > Many thanks
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"web2py Web Framework" group.
To post to this group, send email to [email protected]
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
-~----------~----~----~----~------~----~------~--~---
