Invalid authorization specification

Discussion in 'Programming' started by donboe, Sep 2, 2006.

0
  1. #1
    Hi I'm new to this forum and also quite new to Coldfusion! I'm making a control panel with a log in screen. I have this control panel and database from a working site. When I upload everything and try to log in I get the following error message:

    Error Executing Database Query.  
Invalid authorization specification: Access denied for user 'poliscyprus'@'localhost' (using password: YES)  
  
The error occurred in /home/httpd/vhosts/poliscyprus.info/httpdocs/controlroom/authorise.cfm: line 6
 
4 : <cfelseif isDefined('form.username') AND isDefined('form.password')>
5 : <cfquery name="rsUsers" datasource=#MM_connPolcyp_DSN# username=#MM_connPolcyp_USERNAME# password=#MM_connPolcyp_PASSWORD#>
6 : SELECT * FROM users WHERE username='#form.username#' AND password='#form.password#'
7 : </cfquery>
8 : <cfif rsUsers.RecordCount GT 0>
    Code (markup):

    Can anybody please help me out here.

    Thanks in advance
     
    donboe, Sep 2, 2006 IP
  2. ccoonen

    ccoonen Well-Known Member

    Messages:
    1,606
    Likes Received:
    71
    Best Answers:
    0
    Trophy Points:
    160
    #2
    make sure your user "poliscyprus" is created, and accessible to your table 'users'
     
    ccoonen, Sep 4, 2006 IP
  3. ccoonen

    ccoonen Well-Known Member

    Messages:
    1,606
    Likes Received:
    71
    Best Answers:
    0
    Trophy Points:
    160
    #3
    In the database that is - your database should be also correctly defined in the DSN 'MM_connPolcyp_DSN'
     
    ccoonen, Sep 4, 2006 IP