Hi,
I use the following schema for MySQL, and create 1 user, but I'm having
problem of login using this user/password. (I got error message:
"Reason: Bad credentials").
Could somebody give me a pointer? Is the password should be encoded in
the database? I have tried the sample application, it works which means
the dataSource etc should be correct. I remembered that the passwords in
the "user" table were encrypted, but don't know how that happens.
Thanks
Richard
----------------------------------------------------
CREATE TABLE users (
username VARCHAR(50) NOT NULL PRIMARY KEY,
password VARCHAR(50) NOT NULL,
enabled TINYINT(1) NOT NULL
);
CREATE TABLE authorities (
username VARCHAR(50) NOT NULL,
authority VARCHAR(50) NOT NULL
);
CREATE UNIQUE INDEX ix_auth_username ON authorities (username, authority
);
ALTER TABLE authorities ADD CONSTRAINT fk_authorities_users foreign key
(username) REFERENCES users(username);
INSERT INTO users VALUES ('admin', 'adminx', 1);
INSERT INTO authorities VALUES ('admin', 'ROLE_ADMIN');
_______________________________________________
Home: http://acegisecurity.org
Acegisecurity-developer mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/acegisecurity-developer
