I´ve got a problem in logging on to the system. It always says: Invalid signon.
I´ve also used the search engine and tried the following command in sql: update staff set pwd=password(lower('apassswordyouwillremember')) where username='admin';
But it didn´t get any better. Is there another solution?
I just updated to 0.7.1
Thanks in advance for help! Greeting from Germany
You seem to have CSS turned off.
Please don't fill out this field.
The scripts for checking passwords were changed in version 0.5.2 and you might have stumbled over this twice.
First, if the version number from your previous version is lower than 0.5.2, the database should be upgraded by running /openbiblio/install/ Then staff passwords are reset to be equal to the corresponding usernames. The upgrade script should have told you if it did.
Second, the sql that you were trying to reset the password is outdated. It works for versions lower than 0.5.2.
The following works for newer versions:
update staff set pwd=md5('admin') where username='admin';
Thanks a lot, it worked!
Sign up for the SourceForge newsletter: