Hello, How to configure Shiro with Firebird? I have the following tables:
CREATE TABLE USERS ( USERSNAME VARCHAR (20) CHARACTER SET UTF8 NOT NULL COLLATE UNICODE_CI_AI, "PASSWORD" VARCHAR (36) CHARACTER SET UTF8 NOT NULL, PASSWORD_SALT VARCHAR (40) CHARACTER SET UTF8 ); CREATE TABLE USER_ROLES ( USERNAME VARCHAR (20) CHARACTER SET UTF8 NOT NULL COLLATE UNICODE_CI_AI, ROLE_NAME VARCHAR (100) CHARACTER SET UTF8 NOT NULL ); CREATE TABLE ROLES_PERMISSIONS ( PERMISSION VARCHAR (100) CHARACTER SET UTF8 NOT NULL COLLATE UNICODE_CI_AI, ROLE_NAME VARCHAR (100) CHARACTER SET UTF8 NOT NULL ); Tables created based on JdbcRealm My configuration Shiro.ini: [main] ds = org.firebirdsql.jdbc.FBDriver ds.serverName = localhost:3050 ds.user = SYSDBA ds.password = masterkey ds.databaseName = WebSKS jdbcRealm = org.apache.shiro.realm.jdbc.JdbcRealm jdbcRealm.dataSource = $ds jdbcRealm.permissionsLookupEnabled = true authc = org.apache.shiro.web.filter.authc.PassThruAuthenticationFilter authc.loginUrl = /login/ [urls] /login/ = authc I'm just beginning with Shiro :)
