User Authentication - Error on Login

[00Davo]

When trying to use the login box for authentication, I get this error:

Code: Select all

Fatal error: Uncaught exception 'Exception' with message '2' in C:\xampp\xampp\htdocs\newypt\xataface\Dataface\Serializer.php:68 Stack trace: #0 C:\xampp\xampp\htdocs\newypt\xataface\Dataface\AuthenticationTool.php(139): Dataface_Serializer->serialize('username', 'bob') #1 C:\xampp\xampp\htdocs\newypt\xataface\Dataface\AuthenticationTool.php(210): Dataface_AuthenticationTool->checkCredentials() #2 C:\xampp\xampp\htdocs\newypt\xataface\Dataface\Application.php(1534): Dataface_AuthenticationTool->authenticate() #3 C:\xampp\xampp\htdocs\newypt\index.php(19): Dataface_Application->display() #4 {main} thrown in C:\xampp\xampp\htdocs\newypt\xataface\Dataface\Serializer.php on line 68

This occurs no matter what I have actually typed into the Username and Password boxes - the same error every time.

-- Necessary helpful files --
Here's conf.ini:

Code: Select all

[_database]
    host = localhost
   name = ypt
   user = ypt
   password = ypt

[_tables]
   dashboard = Foyer
   student = Students
   waitinglist = Waiting Lists
   attendance = Attendance
   class = Classes
   adult = Adults
   meeting = Meetings
   production = Productions
   users = Users

[_auth]
     users_table = users
     username_column = "username"
     password_column = "password"
    allow_register = 1
   
[history]
   enabled = 1

And here's /tables/users/fields.ini:

Code: Select all

[UserID]
   visibility:list = hidden

[Password]
    encryption = md5

Table definition for Users:

Code: Select all

CREATE TABLE `users` (                                                   
          `UserID` int(11) NOT NULL AUTO_INCREMENT,                             
          `UserName` varchar(32) NOT NULL,                                       
          `Password` varchar(32) NOT NULL,                                       
          `Role` enum('READ ONLY','EDIT','DELETE','ADMIN') DEFAULT 'READ ONLY', 
          PRIMARY KEY (`UserID`)                                                 
        ) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1       

I have not yet configured any custom permissions as delegate classes. I'll leave that part until after I can get this issue solved.

EDIT: Also, registrations do not correctly function. No errors show up, but the new user isn't actually added to the table.

[shannah]

There it is. Xataface is case sensitive. In your [_auth] section you have:

Code: Select all

username_column = "username"
password_column = "password"


But your table definition shows that your username and password columns are actually named:

Code: Select all

`UserName` varchar(32) NOT NULL,                                       
`Password` varchar(32) NOT NULL,


i.e. case is not the same.

-Steve

[00Davo]

There it is. Xataface is case sensitive.

Oops. You've told me that before. I should have remembered.

It works beautifully now. Thanks again.