Login doesn´t work

  • groove21

    groove21 - 2012-07-21


    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

  • Hans van der Weij

    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';
  • groove21

    groove21 - 2012-07-21

    Thanks a lot, it worked!



Cancel  Add attachments

Get latest updates about Open Source Projects, Conferences and News.

Sign up for the SourceForge newsletter:

No, thanks