I have a site which is using fusetalk 4.0. My set up is win 2k server using cf 5.0.
To log users in I am using an existing table. I have followed the steps in the instructions for setting this up. My issue is that when a handfull(that I am aware of) of users come to the site or login some are getting either automatically logged in as another user or are loging in under the wrong user name.
My first thought was this was a session issue so I verified that all session create and reads were locked. Verified that the session timed out after 30 min in the application and set the default on the server to 30 min. This did not help so I tried a custom tag session management. (rsession) This also did not help.
Any suggestions?
Login action code to the site:
<cfif isdefined('form.submitMe')>
<cfquery name="qLogin" datasource="#request.dsn#">
select password,username,UUID,cemail
from contacts
where username = '#trim(form.username)#' and password = '#trim(form.password)#'
</cfquery>
<cfif qLogin.recordcount gt 0>
<cfset request.session.userID = qLogin.UUID>
<cfset request.session.membername = qLogin.username>
<cfset request.session.memberemail = qLogin.cemail>
<cfset request.returnpage = request.session.returnPage>
<script type="text/javascript"> window.location="<cfoutput>#request.returnPage#</cfoutput>";</script>
<cfelse>
<cfset var.message = "The username and or password you have enter is incorrect.">
</cfif>
</cfif>
++++++++++++++++++++++++++++++++++++++++++++++++++
Fusetalk login code:
<cfapplication name="myapp" sessionmanagement="yes" setclientcookies="yes" sessiontimeout="#createtimespan(0,0,30,0)#" applicationtimeout="#CreateTimeSpan(1,0,0,0)#">
<cf_session_check>
<cfparam name="request.session.userID" default="">
<cfquery name="qValidateUser" datasource="85239">
select * from contacts
where uuid = '#request.session.userID#'
</cfquery>
<cfif qValidateUser.recordcount eq "0">
<cfset FTVAR_PROCEED = "No">
<cfset FTUSER_LOGGEDIN = "No">
<cfelse>
<cfset FTUSER_NICKNAME = qValidateUser.username>
<cfset FTUSER_EMAILADDRESS = qValidateUser.cemail>
</cfif>
To log users in I am using an existing table. I have followed the steps in the instructions for setting this up. My issue is that when a handfull(that I am aware of) of users come to the site or login some are getting either automatically logged in as another user or are loging in under the wrong user name.
My first thought was this was a session issue so I verified that all session create and reads were locked. Verified that the session timed out after 30 min in the application and set the default on the server to 30 min. This did not help so I tried a custom tag session management. (rsession) This also did not help.
Any suggestions?
Login action code to the site:
<cfif isdefined('form.submitMe')>
<cfquery name="qLogin" datasource="#request.dsn#">
select password,username,UUID,cemail
from contacts
where username = '#trim(form.username)#' and password = '#trim(form.password)#'
</cfquery>
<cfif qLogin.recordcount gt 0>
<cfset request.session.userID = qLogin.UUID>
<cfset request.session.membername = qLogin.username>
<cfset request.session.memberemail = qLogin.cemail>
<cfset request.returnpage = request.session.returnPage>
<script type="text/javascript"> window.location="<cfoutput>#request.returnPage#</cfoutput>";</script>
<cfelse>
<cfset var.message = "The username and or password you have enter is incorrect.">
</cfif>
</cfif>
++++++++++++++++++++++++++++++++++++++++++++++++++
Fusetalk login code:
<cfapplication name="myapp" sessionmanagement="yes" setclientcookies="yes" sessiontimeout="#createtimespan(0,0,30,0)#" applicationtimeout="#CreateTimeSpan(1,0,0,0)#">
<cf_session_check>
<cfparam name="request.session.userID" default="">
<cfquery name="qValidateUser" datasource="85239">
select * from contacts
where uuid = '#request.session.userID#'
</cfquery>
<cfif qValidateUser.recordcount eq "0">
<cfset FTVAR_PROCEED = "No">
<cfset FTUSER_LOGGEDIN = "No">
<cfelse>
<cfset FTUSER_NICKNAME = qValidateUser.username>
<cfset FTUSER_EMAILADDRESS = qValidateUser.cemail>
</cfif>