Tomcat JBDCRealm with Oracle DB
Hi. I configured two JDBCRealm's - for MySQL and Oracle databases. Both DB have same tables with same content: mysql show tables; +--+ | Tables_in_tmc_access | +--+ | user_roles | | users| +--+ mysql desc user_roles; +---+--+--+-+-+---+ | Field | Type | Null | Key | Default | Extra | +---+--+--+-+-+---+ | user_name | varchar(100) | NO | PRI | NULL| | | role_name | varchar(100) | NO | PRI | NULL| | +---+--+--+-+-+---+ 2 rows in set (0.00 sec) mysql desc users; +---+--+--+-+-+---+ | Field | Type | Null | Key | Default | Extra | +---+--+--+-+-+---+ | user_name | varchar(100) | NO | PRI | NULL| | | user_pass | varchar(100) | NO | | NULL| | +---+--+--+-+-+---+ 2 rows in set (0.00 sec) mysql select * from users,user_roles; ++---+++ | user_name | user_pass | user_name | role_name | ++---+++ | indexadmin | password | indexadmin | indexadmin | ++---+++ 1 row in set (0.00 sec) Oracle: SQL SELECT table_name FROM user_tables; TABLE_NAME -- TMC_USERS_SET USER_ROLES_SET SQL desc USER_ROLES_SET; Name Null?Type - USER_NAME NOT NULL VARCHAR2(100) ROLE_NAME NOT NULL VARCHAR2(100) SQL desc TMC_USERS_SET; Name Null?Type - USER_NAME NOT NULL VARCHAR2(100) USER_PASS NOT NULL VARCHAR2(100) SQL select * from TMC_USERS_SET,USER_ROLES_SET; USER_NAME USER_PASS USER_NAME ROLE_NAME indexadmin password indexadmin indexadmin server.xml config: !-- Realm className=org.apache.catalina.realm.JDBCRealm driverName=org.gjt.mm.mysql.Driver connectionURL=jdbc:mysql://10.***.***.239/tmc_access connectionName=tmc_access connectionPassword=password userTable=users userNameCol=user_name userCredCol=user_pass userRoleTable=user_roles roleNameCol=role_name / -- Realm className=org.apache.catalina.realm.JDBCRealm driverName=oracle.jdbc.driver.OracleDriver connectionURL=jdbc:oracle:thin:@oraclehost:1521:correctscheme connectionName=tmc connectionPassword=tmc userTable=tmc_users_set userNameCol=user_name userCredCol=user_pass userRoleTable=user_roles_set roleNameCol=role_name / web.xml: security-constraint web-resource-collection web-resource-nameRestricted Area/web-resource-name url-pattern/index.jsp/url-pattern /web-resource-collection auth-constraint role-nameindexadmin/role-name /auth-constraint /security-constraint login-config auth-methodBASIC/auth-method /login-config security-role role-nameindexadmin/role-name /security-role So, when I switch config to Oracle Realm - it is not working (just return again login-window)... With MySQL - working perfect. What I'm doing wrong?
Re: Tomcat JBDCRealm with Oracle DB
Арсений Зинченко wrote: Hi. I configured two JDBCRealm's - for MySQL and Oracle databases. Both DB have same tables with same content: mysql show tables; +--+ | Tables_in_tmc_access | +--+ | user_roles | | users| +--+ mysql desc user_roles; +---+--+--+-+-+---+ | Field | Type | Null | Key | Default | Extra | +---+--+--+-+-+---+ | user_name | varchar(100) | NO | PRI | NULL| | | role_name | varchar(100) | NO | PRI | NULL| | +---+--+--+-+-+---+ 2 rows in set (0.00 sec) mysql desc users; +---+--+--+-+-+---+ | Field | Type | Null | Key | Default | Extra | +---+--+--+-+-+---+ | user_name | varchar(100) | NO | PRI | NULL| | | user_pass | varchar(100) | NO | | NULL| | +---+--+--+-+-+---+ 2 rows in set (0.00 sec) mysql select * from users,user_roles; ++---+++ | user_name | user_pass | user_name | role_name | ++---+++ | indexadmin | password | indexadmin | indexadmin | ++---+++ 1 row in set (0.00 sec) Oracle: SQL SELECT table_name FROM user_tables; TABLE_NAME -- TMC_USERS_SET USER_ROLES_SET SQL desc USER_ROLES_SET; Name Null?Type - USER_NAME NOT NULL VARCHAR2(100) ROLE_NAME NOT NULL VARCHAR2(100) SQL desc TMC_USERS_SET; Name Null?Type - USER_NAME NOT NULL VARCHAR2(100) USER_PASS NOT NULL VARCHAR2(100) SQL select * from TMC_USERS_SET,USER_ROLES_SET; USER_NAME USER_PASS USER_NAME ROLE_NAME indexadmin password indexadmin indexadmin server.xml config: !-- Realm className=org.apache.catalina.realm.JDBCRealm driverName=org.gjt.mm.mysql.Driver connectionURL=jdbc:mysql://10.***.***.239/tmc_access connectionName=tmc_access connectionPassword=password userTable=users userNameCol=user_name userCredCol=user_pass userRoleTable=user_roles roleNameCol=role_name / -- Realm className=org.apache.catalina.realm.JDBCRealm driverName=oracle.jdbc.driver.OracleDriver connectionURL=jdbc:oracle:thin:@oraclehost:1521:correctscheme connectionName=tmc connectionPassword=tmc userTable=tmc_users_set userNameCol=user_name userCredCol=user_pass userRoleTable=user_roles_set roleNameCol=role_name / web.xml: security-constraint web-resource-collection web-resource-nameRestricted Area/web-resource-name url-pattern/index.jsp/url-pattern /web-resource-collection auth-constraint role-nameindexadmin/role-name /auth-constraint /security-constraint login-config auth-methodBASIC/auth-method /login-config security-role role-nameindexadmin/role-name /security-role So, when I switch config to Oracle Realm - it is not working (just return again login-window)... With MySQL - working perfect. What I'm doing wrong? Not looking at the Tomcat logfiles ? - To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org For additional commands, e-mail: users-h...@tomcat.apache.org
Re: Tomcat JBDCRealm with Oracle DB
No errors, but I already found problem cause - forgot run `commit` in SQLPLUS after added rows with usernamerole. :-( Thanks for replay. 2013/12/16 André Warnier a...@ice-sa.com Арсений Зинченко wrote: Hi. I configured two JDBCRealm's - for MySQL and Oracle databases. Both DB have same tables with same content: mysql show tables; +--+ | Tables_in_tmc_access | +--+ | user_roles | | users| +--+ mysql desc user_roles; +---+--+--+-+-+---+ | Field | Type | Null | Key | Default | Extra | +---+--+--+-+-+---+ | user_name | varchar(100) | NO | PRI | NULL| | | role_name | varchar(100) | NO | PRI | NULL| | +---+--+--+-+-+---+ 2 rows in set (0.00 sec) mysql desc users; +---+--+--+-+-+---+ | Field | Type | Null | Key | Default | Extra | +---+--+--+-+-+---+ | user_name | varchar(100) | NO | PRI | NULL| | | user_pass | varchar(100) | NO | | NULL| | +---+--+--+-+-+---+ 2 rows in set (0.00 sec) mysql select * from users,user_roles; ++---+++ | user_name | user_pass | user_name | role_name | ++---+++ | indexadmin | password | indexadmin | indexadmin | ++---+++ 1 row in set (0.00 sec) Oracle: SQL SELECT table_name FROM user_tables; TABLE_NAME -- TMC_USERS_SET USER_ROLES_SET SQL desc USER_ROLES_SET; Name Null?Type - USER_NAME NOT NULL VARCHAR2(100) ROLE_NAME NOT NULL VARCHAR2(100) SQL desc TMC_USERS_SET; Name Null?Type - USER_NAME NOT NULL VARCHAR2(100) USER_PASS NOT NULL VARCHAR2(100) SQL select * from TMC_USERS_SET,USER_ROLES_SET; USER_NAME USER_PASS USER_NAME ROLE_NAME indexadmin password indexadmin indexadmin server.xml config: !-- Realm className=org.apache.catalina.realm.JDBCRealm driverName=org.gjt.mm.mysql.Driver connectionURL=jdbc:mysql://10.***.***.239/tmc_access connectionName=tmc_access connectionPassword=password userTable=users userNameCol=user_name userCredCol=user_pass userRoleTable=user_roles roleNameCol=role_name / -- Realm className=org.apache.catalina.realm.JDBCRealm driverName=oracle.jdbc.driver.OracleDriver connectionURL=jdbc:oracle:thin:@oraclehost:1521:correctscheme connectionName=tmc connectionPassword=tmc userTable=tmc_users_set userNameCol=user_name userCredCol=user_pass userRoleTable=user_roles_set roleNameCol=role_name / web.xml: security-constraint web-resource-collection web-resource-nameRestricted Area/web-resource-name url-pattern/index.jsp/url-pattern /web-resource-collection auth-constraint role-nameindexadmin/role-name /auth-constraint /security-constraint login-config auth-methodBASIC/auth-method /login-config security-role role-nameindexadmin/role-name /security-role So, when I switch config to Oracle Realm - it is not working (just return again login-window)... With MySQL - working perfect. What I'm doing wrong? Not looking at the Tomcat logfiles ? - To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org For additional commands, e-mail: users-h...@tomcat.apache.org
Re: [OT] Tomcat JBDCRealm with Oracle DB
-BEGIN PGP SIGNED MESSAGE- Hash: SHA256 Арсений, On 12/16/13, 7:17 AM, Арсений Зинченко wrote: server.xml config: !-- Realm className=org.apache.catalina.realm.JDBCRealm driverName=org.gjt.mm.mysql.Driver That driver name is *SUPER* old. Are you using a really old driver, or just the old name? Current driver version is 5.1.27. - -chris -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.15 (Darwin) Comment: GPGTools - http://gpgtools.org Comment: Using GnuPG with Thunderbird - http://www.enigmail.net/ iQIcBAEBCAAGBQJSr1K3AAoJEBzwKT+lPKRYeDgQAKYqIQsZdII0FG3MDdl7TRkm QT0TUaZmCdtY4vM2GYJVZRtwZz+ypIYumKBO2RmzJtnj3IZm8gkU5/8WY1sv4IyI Nb+f823E+sc3E+wilA5+vRH1RzOYMJ5jtqvq+23feH1AYBMAkVxIkvaGbcq4SZYs /Fxpaxn+vNTY1H2bmyVCM3srr4HXPkxM2v8u02rZQY+4SVdqzfuqeC4gxQvI3M50 1DQTbJudPGtapCA31dmB9+2QncVVNy6g1S3GDY4RPwTcau0s1zvq9i66I9daA/30 XPgF7r7+lXyERRcfr9N8PhnhC5LwoNKUb4bGkkohErruaWTqa8Oz5DoYVATx6cOO R/pC5cL7kZOR3AdpDMZrYaLM075QF1UVe0ox5fNQvYVrqO+s049KXhXLWxed59xk 5qBL+AABd96UEaUhJbzm9AoFnWPzvxaafxVnezlNEwweB7KrjpQwDfwDK7r3svsm Q2v4Qmwj/iFWD6RS+KQuTsu8AsFnFrdszvfTpIz8umFaykNQhniQe9Ptgggk526Z O5s/g+Z0FwIYZBISfXdQlos5L3GsewKL3uhZNcHgy1t5dOW0QDqL1/9AB1t2ZrlQ ozPcVxAzDvv8GA8wO+xsME2gBwX4x53M4K2F5cThhyZ8xT2ayw9JEFuEr8m4tjfa tH0rEvwIQ0ZQuq9SjbZ/ =WnX0 -END PGP SIGNATURE- - To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org For additional commands, e-mail: users-h...@tomcat.apache.org
Re: [OT] Tomcat JBDCRealm with Oracle DB
16.12.2013 21:21, Christopher Schultz пишет: Name=org.gjt.mm.mysql.Driver That driver name is *SUPER* old. Are you using a really old driver, or just the old name? Current driver version is 5.1.27. - -chris -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.15 (Darwin) Comment: GPGTools - http://gpgtools.org Comment: Using GnuPG with Thunderbird - http://www.enigmail.net/ iQIcBAEBCAAGBQJSr1K3AAoJEBzwKT+lPKRYeDgQAKYqIQsZdII0FG3MDdl7TRkm QT0TUaZmCdtY4vM2GYJVZRtwZz+ypIYumKBO2RmzJtnj3IZm8gkU5/8WY1sv4IyI Nb+f823E+sc3E+wilA5+vRH1RzOYMJ5jtqvq+23feH1AYBMAkVxIkvaGbcq4SZYs /Fxpaxn+vNTY1H2bmyVCM3srr4HXPkxM2v8u02rZQY+4SVdqzfuqeC4gxQvI3M50 1DQTbJudPGtapCA31dmB9+2QncVVNy6g1S3GDY4RPwTcau0s1zvq9i66I9daA/30 XPgF7r7+lXyERRcfr9N8PhnhC5LwoNKUb4bGkkohErruaWTqa8Oz5DoYVATx6cOO R/pC5cL7kZOR3AdpDMZrYaLM075QF1UVe0ox5fNQvYVrqO+s049KXhXLWxed59xk 5qBL+AABd96UEaUhJbzm9AoFnWPzvxaafxVnezlNEwweB7KrjpQwDfwDK7r3svsm Q2v4Qmwj/iFWD6RS+KQuTsu8AsFnFrdszvfTpIz8umFaykNQhniQe9Ptgggk526Z O5s/g+Z0FwIYZBISfXdQlos5L3GsewKL3uhZNcHgy1t5dOW0QDqL1/9AB1t2ZrlQ ozPcVxAzDvv8GA8wO+xsME2gBwX4x53M4K2F5cThhyZ8xT2ayw9JEFuEr8m4tjfa tH0rEvwIQ0ZQuq9SjbZ/ =WnX0 -END PGP SIGNATURE- - To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org For additional commands, e-mail: users-h...@tomcat.apache.org We using Tomcat 5.5.36 (don't ask why :-)), and this driver name was included to server.xml by default, so I doesn't change it. But - real driver, which placed to [...]server/lib/somethinghere.jar - was downloaded from MySQL website and have version 5.1.27. - To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org For additional commands, e-mail: users-h...@tomcat.apache.org