2009-02-10 06:48:42 UTC
My client has installed OpenCRX version 2.0 on Tomcat LWS (Tomcat Version 6.0.14) and Postgres 8 database. I believe I have configured the server correctly for database authentication ( I no longer see errors about "connection refused" or the role in the log file), but login still does not work. Incidently, using pgAdmin III to view the database, it appears that the passwords don't conform to MD5/base64. The passwords in the credentials tables appear to be in base64, but they do not decode to the MD5 of the passwords I originally set for my users. The realm configuration for the app context is as follows:
<Realm className="org.apache.catalina.realm.ExtendedJDBCRealm"
debug="0"
digest="MD5"
digestEncoding="UTF-8"
digestFormat="base64"
flag="sufficient"
driverName="org.postgresql.Driver"
connectionURL="jdbc:postgresql://xxx.xxx.xxx.xxx/crx-CRX"
connectionName="[NAME]" connectionPassword="[PASSWORD]"
userTable="OOCSE1_TOBJ_USERS" userNameCol="principal_name" userCredCol="passwd"
userRoleTable="OOCSE1_TOBJ_ROLES" roleNameCol="role_name"
/>
Can someone tell me what the problem is? I REALLY need to get this resolved to meet my deadline. I understand that first response may be to upgrade to the latest version, but I have yet to find information on how to upgrade an existing OpenCRX install with database in tact. Can someone provide this information?
