Here's the scenario. I have 3000 users in a sql database. I am running Win 2000 and CF 5. I want to be able to authenticate users from the database instead of using Win and write to the cgi.auth_user so I can track them using webtrends. Without it I can't track the activities of specific users. Any help appreciated.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
authenticate users
- Thread starter tdbotts
- Start date
I'm assuming users have a login and password, also do you
have different levels of authentication such as admin users?
The simplest way to do this is to have a login page which checks the users password and login against the database. On the cf side use session vars (dont forget to lock them) to set the user logged in /not logged in.
On all the pages you want to restrict access check the value of the session var if the user is not logged in redirect them to the login page. You can place the restricted pages in a sub directory and have the login check in there. Becareful not to end up with an endless loop if you do - ie if you dont decide to use a subdirectory the application cfm should allow the login page to be displayed instead of trying to redirect the user to the login page as soon as they hit the site.
HTH
If you need more details let me know
Kola
have different levels of authentication such as admin users?
The simplest way to do this is to have a login page which checks the users password and login against the database. On the cf side use session vars (dont forget to lock them) to set the user logged in /not logged in.
On all the pages you want to restrict access check the value of the session var if the user is not logged in redirect them to the login page. You can place the restricted pages in a sub directory and have the login check in there. Becareful not to end up with an endless loop if you do - ie if you dont decide to use a subdirectory the application cfm should allow the login page to be displayed instead of trying to redirect the user to the login page as soon as they hit the site.
HTH
If you need more details let me know
Kola
It's been a while since I worked with Webtrends, but I seem to recall that you can specify in the webtrends configuration which particular cookie to use for tracking purposes. Can you just set a particular cookie for that user? (After they login -- like the method that pigsie suggested, but instead of a session variable use a cookie) That is the only way that I found that you can reliably track users through webtrends.
HTH,
Tim P.
HTH,
Tim P.
Sorry i didnt see the part about web trends. You can use cookies but obviously these are not 100% secure as they can be read on the user's system if the user knows where. Also you would want to use session cookies )ie cookies that expire when the browser closes (and only when the browser closes if you do not log the user out). Not sure if these type of cookies show up in web trends if not then try normal cookies but be aware that if the user does not log out (ie you do not kill the cookies) the user runs the risk of someone else firing up their browser and being logged in. Finaly remember to ensure that cookies are always switched on on the user's machine!
- Status
Similar threads
