Login in 3.0, upgrade from 2.0b

[bcs112]

Hi all,

I upgraded version 2.0b to 3.0 today, ran the repository upgrade script and then tried to login to OpenKM. Unfortunately it seems like OpenKM doesn\'t recognize any of my login\'s anymore and always goes back to the login screen with an \"authentication error\".
This happens both in IE and in Chrome (yes people actually use Chrome). OpenKM runs on a windows 2000 server with Java 1.6.

Any ideas ?

Björn

[jllort]

1- First question, have you made a backup before trying migration ?

2- OpenKM 3.0 comes with embeded database with users, try with this user okmAdmin / admin

3- admin user is deprecated from OpenKM 3.0 for problems with some OS like windows that have admin user by default for this reason we change it ( hope definitelly ).

If you want to mantain older users, simply copy older properties files to new installation, and change login-config.xml ( or simply recreate on new integrated administration ).

[bcs112]

I tried login in with \"okmAdmin\" and password \"admin\" and it doesn\'t work. i tried it in IE7 and Chrome. I always get a login error...

To be save I \"reinstalled\" OpenKM in a fresh directory and didn\'t do any migration or anything. Same result however...

Any more ideas ?

Björn

[jllort]

Let\'s take a look at your configuration:

1- show me your login-config.xml OpenKM policy
2- The openkm-ds.xml pool
3- Take a look at files created at server/default/data/hypersonic what starts with OKM ( which are ? )

[bcs112]

Hi,

I have not changed or edited anything in any file so far. I simply copied the files in your compile on to the computer and fired up OpenKM... so basically these files the same as the one in the install.

Björn

[jllort]

The files I suggest you take a look are where autentication is defined.

Actual user is user:okmAdmin / password:admin that might be run well. ( user is case sensitive )

To ensure all is right, simply take a look at login-config.xml that policy OpenKM uses okmAuth pool. Take a look at queries, try to login to hypersonic and make the query ( ensure goes right ) and you\'ve got defined there it user. If you comes from a migration some table change could not be done on upgrading.

Or are you trying on a clean installation ?

[bcs112]

In the \"Default\\Conf\\login-Config.xml\" I found:

<!-- OpenKM -->
<application-policy name = \"OpenKM\">
<authentication>
<login-module code=\"org.jboss.security.auth.spi.DatabaseServerLoginModule\" flag = \"required\">
<module-option name=\"dsJndiName\">java:/OKMAuthDS</module-option>
<module-option name=\"principalsQuery\">select usr_pass as PASSWD from users where usr_id=? and usr_active=\'true\'</module-option>
<module-option name=\"rolesQuery\">select ur_role as ROLEID, \'Roles\' from user_role where ur_user=?</module-option>
</login-module>
</authentication>
</application-policy>

Is this what you would expect ?
And yes this is a clean install...

Björn

[bcs112]

OK, latest update...
Login in with admin/admin worked !

Björn


openkm-ds.xml:


<?xml version=\"1.0\" encoding=\"UTF-8\"?>

<datasources>
<!-- OpenKM User Activity -->
<local-tx-datasource>
<jndi-name>OKMActivityDS</jndi-name>
<connection-url>jdbc:hsqldb:${jboss.server.data.dir}${/}hypersonic${/}OKMActivity</connection-url>
<driver-class>org.hsqldb.jdbcDriver</driver-class>
<user-name>sa</user-name>
<password></password>
<min-pool-size>5</min-pool-size>
<max-pool-size>20</max-pool-size>
<idle-timeout-minutes>0</idle-timeout-minutes>
<track-statements/>
<!--<security-domain>HsqlDbRealm</security-domain>-->
<prepared-statement-cache-size>32</prepared-statement-cache-size>
<metadata>
<type-mapping>Hypersonic SQL</type-mapping>
</metadata>
<depends>jboss:service=Hypersonic,database=OKMActivity</depends>
</local-tx-datasource>

<!-- For hsqldb accessed from jboss only, in-process (standalone) mode -->
<mbean code=\"org.jboss.jdbc.HypersonicDatabase\"
name=\"jboss:service=Hypersonic,database=OKMActivity\">
<attribute name=\"Database\">OKMActivity</attribute>
<attribute name=\"InProcessMode\">true</attribute>
</mbean>

<!-- OpenKM User Auth -->
<local-tx-datasource>
<jndi-name>OKMAuthDS</jndi-name>
<connection-url>jdbc:hsqldb:${jboss.server.data.dir}${/}hypersonic${/}OKMAuth</connection-url>
<driver-class>org.hsqldb.jdbcDriver</driver-class>
<user-name>sa</user-name>
<password></password>
<min-pool-size>5</min-pool-size>
<max-pool-size>20</max-pool-size>
<idle-timeout-minutes>0</idle-timeout-minutes>
<track-statements/>
<!--<security-domain>HsqlDbRealm</security-domain>-->
<prepared-statement-cache-size>32</prepared-statement-cache-size>
<metadata>
<type-mapping>Hypersonic SQL</type-mapping>
</metadata>
<depends>jboss:service=Hypersonic,database=OKMAuth</depends>
</local-tx-datasource>

<!-- For hsqldb accessed from jboss only, in-process (standalone) mode -->
<mbean code=\"org.jboss.jdbc.HypersonicDatabase\"
name=\"jboss:service=Hypersonic,database=OKMAuth\">
<attribute name=\"Database\">OKMAuth</attribute>
<attribute name=\"InProcessMode\">true</attribute>
</mbean>

<!-- OpenKM Dashboard Stats -->
<local-tx-datasource>
<jndi-name>OKMDashboardStatsDS</jndi-name>
<connection-url>jdbc:hsqldb:${jboss.server.data.dir}${/}hypersonic${/}OKMDashboardStats</connection-url>
<driver-class>org.hsqldb.jdbcDriver</driver-class>
<user-name>sa</user-name>
<password></password>
<min-pool-size>5</min-pool-size>
<max-pool-size>20</max-pool-size>
<idle-timeout-minutes>0</idle-timeout-minutes>
<track-statements/>
<!--<security-domain>HsqlDbRealm</security-domain>-->
<prepared-statement-cache-size>32</prepared-statement-cache-size>
<metadata>
<type-mapping>Hypersonic SQL</type-mapping>
</metadata>
<depends>jboss:service=Hypersonic,database=OKMDashboardStats</depends>
</local-tx-datasource>

<!-- For hsqldb accessed from jboss only, in-process (standalone) mode -->
<mbean code=\"org.jboss.jdbc.HypersonicDatabase\"
name=\"jboss:service=Hypersonic,database=OKMDashboardStats\">
<attribute name=\"Database\">OKMDashboardStats</attribute>
<attribute name=\"InProcessMode\">true</attribute>
</mbean>
</datasources>

Files in the Hypersonic directory:

OKMActivity.lck
OKMActivity.log
OKMActivity.properties
OKMActivity.script
OKMAuth.lck
OKMAuth.log
OKMAuth.properties
OKMAuth.script
OKMDashboardStats.lck
OKMDashboardStats.log
OKMDashboardStats.properties
OKMDashboardStats.script

Next I tried login in with \"admin/admin\" and got this:

I tried login in with \"admin/admin\" now I get an error message:


HTTP Status 404 - /OpenKM/j_security_check

--------------------------------------------------------------------------------

type Status report

message /OpenKM/j_security_check

description The requested resource (/OpenKM/j_security_check) is not available.


--------------------------------------------------------------------------------

JBossWeb/2.0.1.GA

Björn




Björn