Admin Password Unknown - Help Needed!

[Tom]

Hi,

This is for 3.0. Our admin password is unknown for whatever reason. All the other passwords for our other users are known. Can I reset the admin password? Can I retrieve it. Could I write over it with the original 3.0 password file? If so were is the file? What would be the side affects? Thanks,

[dignan]

How are you performing authorizations? Are you authing against a the users file, the local database, or LDAP?

[jllort]

If you\'ve not changed anuthing and you\'re using OpenKM by default. Must connect to hypersonic database to query about actual admin password. Database is on server/default/data/hypersonic/OKM* you can connect via jdbc for example with datastudio ( take a look at openkm-ds.xml credentials )

[dignan]

Another way to connect to Hyperion is via the HSQLDB Database Manager. It\'s not pre-compiled anywhere, but it is fairly simple to do so! Hope this helps!

[Tom]

Hi All,

I tried the DatabaseManager and it keeps telling me I have the database locked.
I see the lock files but I can\'t remove them and can\'t see any process that has them locked.
Any way around this? The OS distro is Windows SBS2008. Worst yet my script file shows the admin password but its not accept when I enter it. All the other user password work fine. So I need to unlock the database and then assign the password using the DatabaseManager that comes with the hyperion jar. Thanks,

[Tom]

Hi Folks,

I found the problem for the lock files. Even though I stopped OpenKM some java processes were still around. I assume one had the lock on the database. These processes could not be seen with the Windows task manager without going into true admin mode. Even though I belonged to the admin group I could not see these tasks. I killed the java tasks. Then I was able to use the DatabaseManager to access the OKMAuth data.

[jllort]

When jboss is running, hypersonic database is locked. If you want to login to database when jboss is running there\'s some utility under jboss ( jmx-console ) to do it, but I don\'t remember exactly where.

Take a look here or search in google for \"jboss jmx-console hypersonic\"