Loading...
 
Architecture / Installation

Architecture / Installation


Can't login after upgrade

posts: 2

I've upgraded my from Tiki 3.5 to 10.6. After the upgrade I cannot login.

I found this technote but it doesn't seem to work. https://dev.tiki.org/item4162

Previously, I tried upgrading to 12.2 and encountered the same problem. But 12.2 has a convenient "I forgot my password" link which I was able to use to get into the site. 10.6 has no such link.

I couldn't get AD authentication to work with 12.2 (and reportedly 11 has the same problems), so here I am at 10.6.

posts: 214

I do not have any experiance with AD authentication, but if having the "I forgot my password" option would help, you can turn that option on in the database using phpmyadmin.
The SQL:

Copy to clipboard
UPDATE `tiki_preferences` SET `value` = 'y' WHERE `value` = 'forgotPass';

Would set the Tiki "I forgot my password" option to "yes". And if that fails because that row is not in the table to update, then this SQL:

Copy to clipboard
INSERT INTO `tiki_preferences` (`name`, `value`) VALUES ('forgotPass', 'y');

Would insert the row for the "I forgot my password" option.

Tom


posts: 3665 United States

Moving from 3.x to 12.x (or even 10.x) is a big jump. You'll probably need to apply the Admin user fix (on the Configure General Settings of the Installer wizard), see Step #5, here. Be sure to review all of the pertinent release notes for full details].

HTH,

- Rick | My Tiki Blog | My Tiki UserPage

Why be a dummy? Get smarty! TikiForSmarties.com
Tiki for Smarties, your source for the best (and only) Tiki books, guides, and tutorials.

posts: 2

Thanks for the replies.

Setting forgotPass to y didn't work. I even searched through the php and found an additional setting that the php code seemed to be looking for, set that to y as well, and it still didn't work.

The admin user fix is no good if you cannot log in at all.

You see, I was logging in with an AD account, and I didn't know the admin pw. After the upgrade AD was broken, so I couldn't log in at all.

Anyway, I fixed it by going back to the original db, and resetting the admin pw. Then using MySQL Workbench I opened the users_users table on both the original and upgraded databases. I deleted the admin row from the db for the upgraded system I could not log into, then copied and pasted the row from the db for the original system I had just changed the pw for.

Then I could log in.


Upcoming Events

1)  18 Apr 2024 14:00 GMT-0000
Tiki Roundtable Meeting
2)  16 May 2024 14:00 GMT-0000
Tiki Roundtable Meeting
3)  20 Jun 2024 14:00 GMT-0000
Tiki Roundtable Meeting
4)  18 Jul 2024 14:00 GMT-0000
Tiki Roundtable Meeting
5)  15 Aug 2024 14:00 GMT-0000
Tiki Roundtable Meeting
6)  19 Sep 2024 14:00 GMT-0000
Tiki Roundtable Meeting
7) 
Tiki birthday
8)  17 Oct 2024 14:00 GMT-0000
Tiki Roundtable Meeting
9)  21 Nov 2024 14:00 GMT-0000
Tiki Roundtable Meeting
10)  19 Dec 2024 14:00 GMT-0000
Tiki Roundtable Meeting