technicalbard
Posts: 7
|
| Posted: 04/13/2008, 9:00 PM |
|
I've built a simple application (modelled on the Task Manager), but using my own database (MySQL). I can't seem to get the published application LOGIN page to work properly. It always indicates the username or password are incorrect.
PHP 5 + MySQL architecture
User authentication based on a table:
USERID : integer : autoincremented
USERNAME: text
PASSWORD: text (doesn't seem to matter if I leave plaintext or encrypt)
GROUP_ID: int
The GROUP_ID comes from another table of group rights (ID and descriptor)
I created a single user in the database using phpMyAdmin and this just isn't working.
Any hints on why this won't work?
|
 |
 |
royalston
Posts: 2
|
| Posted: 04/14/2008, 6:55 PM |
|
Are you by chance using a Windows Vista box with IIS 7.0?
|
|
|
|
technicalbard
Posts: 7
|
| Posted: 04/15/2008, 5:41 PM |
|
No. I'm using a Windows Vista x64 running Apache 2.2.
Still can't figure this out. I swear I've created the tables in MySQL with the same stuff as the intranet demo access database, but I still can't get this to work.
|
|
|
|
royalston
Posts: 2
|
| Posted: 04/15/2008, 6:39 PM |
|
Try giving "everyone" full control of this directory and see if it makes any difference:
C:\Windows\ServiceProfiles\LocalService\AppData\Local\Temp
|
|
|
|
technicalbard
Posts: 7
|
| Posted: 04/15/2008, 8:20 PM |
|
OK - I've gotten it to work.. but I can't seem to make password encryption work. I'm storing them in plaintext in the database. I'd rather not.
Any hints on using MySQL SHA1() functions to encrypt passwords and make CCS handle that?
|
|
|
|
