Loading...
 
Architecture / Installation

Architecture / Installation

Forum List Topic List

Forums » Architecture / Installation » Help! - my login & password not recognized even if in SQL database
 
Thread actions
PDF Print this page
  • Print all pages

    • Help! - my login & password not recognized even if in SQL database

    Posted by dwommack posts: 9

    Not being able to login, I followed the instructions on:

    http://doc.tikiwiki.org/tiki-index.php?page=Lost+admin+password&highlight=passwords

    browsed the user_user database file & made sure I was using the correct userid & password, but trying it just gives error message:

    invalid username or password.

    WHAT CAN I DO? I TRIED REPAIRING THE DATABASE. NO DIFFERENCE. I TRIED CHANGING THE PASSWORD. NO DIFFERENCE

    Reads: 2110
    Link
    Posted by dwommack posts: 9
    Both myself & my chief programmer tried your suggested solution. Could't get it to work. Any more suggestions?
    Link
    Posted by dwommack posts: 9

    I get no error when I run the SQL statement:
    UPDATE `users_users` SET `password`='admin', `hash`= md5('adminadmin') WHERE
    `login`='admin';

    And when I browse the user_user file I see the change to admin & admin for the id & password fields.

    One thing should be mentioned: 2 relevant databases are shown in my PHP admin section of Cpanel — and I'm actually not sure which is "active". One is labeled tiki1 and one is labeled naturecebu. I did the update on both. Both now show admin & admin in the user_user file for id & password. However when I first tried to login to the site after changing the tiki1 file, I get the message: invalid user name or password. I then updated the naturecebu file, I get no error message but nothing changes — I'm still not "logged in" & am just a user. The screen simply reverts to the unlogged in user screen.

    Link

    Posted by dwommack posts: 9
    Both myself and my chief programmer tried to follow your instructions, but no luck. Any more suggestions?
    Link

    Posted by dwommack posts: 9
    Please explain what you mean by authentication method? I just use id & password. id = admin
    Link
    Posted by dwommack posts: 9
    I believe we are using Tiki & Just Tiki authentication. Installed via Fantastico Sept 2007. Where do I look (in SQl database tiwi1?) for the version number?
    Link

    Posted by dwommack posts: 9
    I believe it is Version 1.9.5 (CVS)
    Link

    Posted by mmb5 posts: 1
    I would also like to add I am having the same difficulty — I cannot login as admin — even after trying the changes listed on the Lost Admin Password page. I'm running a single setup that I updated today from 1.97 to 2.0.
    Link

    Posted by dwommack posts: 9
    What else can we tell you to help solve this problem. I can't get into the website til I solve this.
    Link

    Posted by rnethers posts: 2

    I too am having the exact same problem.

    I am using CentOS 5.2, tikiwiki 3.1, php 5.1.6, mysql 5.0.45, apache 2.2.3. I am using Tiki authentication, only. I have php set in php.ini to log every error in /var/log--nothing. (Albeit, I might have it improperly configured.) The only way I can log in is if I reset the password, and login through the email I receive. Today, I started fresh, a totally new database, totally new tikiwiki install. The tikiuser in mysql has been granted all for the tikidb.

    With regard to the last posting, where does tiki write php session information? Help?

    Thanks,
    Randy

    Link