Okay, just starting out and I can't jump the first hurdle. I following several tutorials and books but run into a wall. My login should be working, but isn't. Guess I missed something.

I have a phpbb up and running. I decide to restrict other sections of the site by a standard login page using coldfusion. I'm trying to use the phpbb database for authentication: username, user_password, so users have only one name/password, even if they have to use it twice.

DSN and mysql database have been verified to work by running live CF queries. Application.cfm was written and added to site. Dreamweaver reconizes the database, and the login in server behavior.

The Login always fails and sends me to my failed login page. I have enabled debugging, but since the cf sends me to the failed page if there a problem, it works properly. So I verified that my username/password combo was correct, which it was. Added my own password field to the database, to see if there was an encryption problem, but no effect. And refreshed everthing to no avail.

Any suggestions would be welcome!

Hello,

Sorry to hear about your problems. Don't use Dreamwaver's login server behavior. I love Dreamweaver, but tend to stay away from their built in behaviors because of the sometimes cumbersome and troublesome code.

CF Security can sometimes be tricky. A good tutorial with excellent documentation and source files can be found here: (This will only work for Coldfusion 7!)

http://www.trajiklyhip.com/tutorials/loginSecurityCF7/index.cfm

I've used this many times and it works great. I had to modify it to suite my needs but I think it will be a good solution for you out of the box. It comes complete with the database and source files. However, you can modify the SQL to accommodate your existing MySQL table structure. If you continue to have a problem, post your code here and I'll have a look at it.

Good Luck!

Jason,

Thanks for the help. I've downloaded the files and will start walking through the tutorial. One question, my DSN uses a username and password. I would like to use the Request.DSN function. I have tried to use variations to input the two variables, ie

<cfset Request.DSN=' "DSNname" username="xxxxx" password="yyyyy" '>

single quoting the entire string, but to no effect. I wrote my login pages without using the Request.DSN function to elimenate it as a source of the problem, but would like to use it in the future.

Anyways I have a new tutorial to work through. I haven't played with .cfc's yet. Always something new!!! Thanks again! Matt

what you need to do is, in the "On Request Start" function of the Application.cfc you would do the following:




And then, for all of your queries:



Give that a shot!