[01:21]  fabricius joined #tikiwiki
[01:55]  jonnyb joined #tikiwiki
[02:31]  fabricius joined #tikiwiki
[10:36]  fabricius joined #tikiwiki
[10:43]  robertokir joined #tikiwiki
[11:28]  jonnybradley joined #tikiwiki
[11:49]  Caarrie|away joined #tikiwiki
[12:25]  robertokir joined #tikiwiki
[13:41]  RadoS joined #tikiwiki
[13:41]  trebmuh joined #tikiwiki
[14:45]  jonnyb joined #tikiwiki
[15:41]  rsevero joined #tikiwiki
[15:43] rsevero Hi. Just trying to try tikiwiki for the first time. Unfortunately I can't get past initial login as the "admin" user with "admin" password isn't accepted. Even tried to reset the admin password through phpmyadmin but Tikiwiki still says I entered the wrong password when trying to login.
[15:46] rsevero I tried the instructions available at https://doc.tiki.org/Lost-admin-password and at http://www.trevorbowen.com/2008/11/20/resetting-tikiwikis-admin-password-and-email-with-mysql/ but I don't think Tikiwiki still uses md5 to hash it's passwords as the final hash is way smaller than the original one.
[15:46] rsevero How can I reset tikiwiki's admin password?
[15:57] Jyhem That's odd. Which Tiki version?
[15:58] Jyhem rsevero: Try this:
[15:58] Jyhem UPDATE users_users SET email='noreply@tiki.org', pass_confirm=NOW(), provpass='', hash= md5('admin') WHERE login='admin'
[15:59] rsevero Version 19.1
[15:59] rsevero Will try now. Just a moment.
[16:00] rsevero Got thew following SQL error:
[16:00] rsevero #1264 - Out of range value for column 'pass_confirm' at row 1
[16:10] Jyhem Hmmmm, then something changed between 18.x and 19.x :-(
[16:11] Jyhem which probably also breaks demo.tiki.org as it's wher I found the command :-(
[16:14] Jyhem Since it's a new install and you won't lose anything, you can reset a new database from command line:
[16:15] Jyhem php console.php database:install
[16:18] Jyhem or try UPDATE users_users SET email='noreply@tiki.org', provpass='', hash= md5('admin') WHERE login='admin'
[16:18] Jyhem (untested)
[16:18] rsevero I've done it. Couldn't login either. And the original password hash is way longer the the md5 one. I believe the ahsh used for passwords in Tikiwiki 19 has been changed and it's not working that well...
[16:19] rsevero Tried UPDATE users_users SET email='noreply@tiki.org', pass_confirm=20190425, provpass='', hash= md5('admin') WHERE login='admin'
[16:19] rsevero Still can't login
[16:22] Jyhem Sorry, I can't help more. Is that the svn version of Tiki19? I suggest you can ask on https://wikisuite.chat/XMPP or the mailing list, or forums, or write a bug report on dev.tiki.org :-(
[16:25] rsevero Ok. thank you. I will try version 18.x
[16:30] Jyhem BTW: version 18.x is a Long Term Support version while 19.x will be obsoleted by 20.x in 2-3 months.
[16:31] Jyhem So it's probably for the best. Thanks for the report anyway
[16:35]  jonnyb joined #tikiwiki
[17:00]  jonnyb joined #tikiwiki
[20:02]  Jyhem_laptop joined #tikiwiki
[20:07]  fabricius joined #tikiwiki
[20:22]  jonnyb joined #tikiwiki
[20:40]  fabricius joined #tikiwiki
[21:59]  fabricius joined #tikiwiki
[23:59]  xavi joined #tikiwiki