Recover ADMIN password

[kamalprem]

I haven't logged in a long time and some how I forgot my login credentials.  Is there a way to recover my password or reset it?  This is very important if I can get some help right away.

[admin]

Hi,

their is no function for this at the moment.
You only can reset it with an sql statement:

update `users` set `password`=md5('yourpassword') where `name`='admin';

Hope this helps.

Frank

[kamalprem]

That worked for adding new post and docs but it didn't get me in for the admin directory

[kamalprem]

Never mind...I figured it out.  Thanks for all the help!

[kamalprem]

oops.  Spoke too soon.  When I log in I only have the option to install extensions. could I have created cmore then one admin for this page?

[admin]

Hi,

here the answer von others to reset the admin account:
At a wrong admin login a hashvalue is shown at the bottom of the loginpage. This value can be saved in the admin config for the new login credentials.

You have only this one admin account because you only can make some configurations and install extensions.

Frank

[kamalprem]

The only thing I see when I log in is the extension option, log out, and information which only shows me the welcom epage.  Before I had a bunch of options to choose from.

[admin]

Hi,

please show me the result of the following sql statement:
select * from extensions;

You should have an entry with admin_config and an value for active as 1.

Frank

[kamalprem]

This what I get after the SQL statement:

ID      KEYNAME          ACTIVE  ADMIN

1     admin_extension     1           1     
2    admin_info               1          1    
3    admin_config       1          1    
4    libsecure               1          0


I've attached a screenshot of the interface after I log in

[admin]

Hi,

please check the system/sysext/ folder if their is a admin_config extension and you have files in this folder.

Frank

[kamalprem]

I do have that directory and I have the following files listed:

admin_config.js
class-admin_config.php
config.php
info.php
language.php

[admin]

Which Knowledgeroot Version are you using?
Which Apache/PHP/Mysql Version are you using?
Windows or Linux?

Frank