Re: unable to log in via DB auth
Joe, We do something similar over here, though I just grab the AUTH_USER var passed from IE's Integrated Auth. Eitherway though, try this for your CFLOGINUSER In short, wrap your CFLOGINUSER with CFLOGIN. It drove me nuts for a few hours then I realized I needed to wrap it. -Brent ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322241 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
unable to log in via DB auth
I have an app that currently authenticates against an AD and I'm updating it to also look in a database for users as well. My code currently is as follows: select role, needPasswordReset from v_users where oprid = '#theusername#' and password = '#hash(thepassword,"sha-256")#' and isInactive is null select role from v_users where oprid = '#theusername#' and isInactive is null; Right now as it is written I'm still able to log in normally via AD. If I use a database user, the code will run but getAuthUser() will return a blank. I even stripped out the CFNTAuthenticate and ran it with just the database validation but cfloginuser wouldn't run for me. Has anyone seen this before? tia, - Joe ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322186 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4