Checklist for database-based user login

Checklist for database-based user login

This guide assumes that you have installed openCRX 2.0 Server. For more information see here.

New users created as openCRX segment administrator are stored in the database tables OOCSE1_TOBJ_USERS and OOCSE1_TOBJ_ROLES. By default, Tomcat performs user authentication based on the entries in the file tomcat-users.xml. However, Tomcat allows to override this behaviour by setting an alternative login realm in the servlet context configuration.

The openCRX web applications use the JdbcRealm which are configured in the context configuration files in the directory .\opencrxServer-2.0.0\apache-tomcat-6\conf\Catalina\localhost.

If database-based user authentication does not work then check the following:

• Open the context configuration files and check the database connection properties
• If the connection properties seem to be valid open the MySQL Query Browser and try to query the user and role table, i.e. SELECT * FROM OOCSE1_TOBJ_USERS and SELECT * FROM OOCSE1_TOBJ_ROLES. If openCRX has been properly installed you should at least see the users guest and admin-Standard in the result set.