Announcement

#1 2021-09-26 17:25:29

sierra.bmwcca
Member
2021-09-26
12

Can't login after upgrade to 11.50

Hello/Hi/Greetings,

I just upgraded to 11.50 and am receiving "Invalid username or password!" I have reset the password receiving an email link and still get the same error. I have two admin accounts and this occurs on both (I have reset both). I am using cloudflare and tried removing it from it and still nothing.

( Sorry can't get in! Copy here your environment details, found on your Piwigo page [Administration > Tools > Maintenance])

Piwigo URL: https://gallery.sierrabmwcarclub.org/

Any help on this is greatly appreciated.

Offline

 

#2 2021-09-29 22:41:15

tiagoc
Member
2021-09-28
8

Re: Can't login after upgrade to 11.50

Were you able to solve this issue?

When looking at your gallery, there are many 508 errors: "Resource Limit Is Reached - The website is temporarily unable to service your request as it exceeded resource limit. Please try again later.".

Do you have access to the DB?

Offline

 

#3 2021-09-29 23:24:04

sierra.bmwcca
Member
2021-09-26
12

Re: Can't login after upgrade to 11.50

Yes, Is there i can do anything on the back end?
I have some large images there. I was hoping to install OptiPic images optimization and WebP convertion

Offline

 

#4 2021-09-30 01:28:36

erAck
Only trying to help
2015-09-06
1414

Re: Can't login after upgrade to 11.50

Resource Limit Reached means your server is under-equipped. Either for the tasks it is to perform, or for the number of requests it has to serve. Or you're DoS'ed.

But as your page is served by cloudflare it may also be at their end. Though they claim to exist to prevent exactly that.
(I for example get for a request by Curl an "Error 406 - Not Acceptable" from them, whatever their shitty excuse might be for that).


Running Piwigo at https://erack.net/gallery/

Offline

 

#5 2021-09-30 10:50:50

tiagoc
Member
2021-09-28
8

Re: Can't login after upgrade to 11.50

sierra.bmwcca wrote:

Yes, Is there i can do anything on the back end?

Go to the "aaa_users" table (replace "aaa" with the prefix you're using) and check your admin users. Make sure the usernames are correct (username and password are case-sensitive). If they are, run this SQL query (replace "aaa" with the prefix you're using):

update aaa_users set password=md5('secret') where id=1;

"id=1" is the id of your admin user. Since you have 2, you need to run the query twice and change the id for the other admin user.

Then, you should be able to login using the password "secret" (username and password are case-sensitive). Don't forget to change the password after you login.

I hope this helps.

Offline

 

#6 2021-09-30 17:46:29

sierra.bmwcca
Member
2021-09-26
12

Re: Can't login after upgrade to 11.50

I apologize, not a big sql user.

I entered your query with the proper changes and it was giving me some warnings. So I used the autofill to recreate the query. It still produced the same warnings:
Unrecognized keyword. (near set password)
Unrecognized token. (near-)
Unrecognized keyword. (near ()
Unexpected token. (near 'secret')
Unexpected token. (near ))

Then I simulated the query and it gave me:
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'FROM `gal_users` WHERE id=1' at line 1

Thanks again,

Offline

 

#7 2021-09-30 17:55:35

sierra.bmwcca
Member
2021-09-26
12

Re: Can't login after upgrade to 11.50

Sorry running MySQL 5.7

Offline

 

#8 2021-09-30 19:12:26

tiagoc
Member
2021-09-28
8

Re: Can't login after upgrade to 11.50

The simulation may be incorrect because it is referring a FROM not included in the original statement.

Try this command, to check the existence of the function:

select md5('secret')

And see if there are errors.

Offline

 

#9 2021-09-30 20:13:02

sierra.bmwcca
Member
2021-09-26
12

Re: Can't login after upgrade to 11.50

I ran both queries successfully. Tried to login with both accounts on several browsers and same thing. I compared the md5('secret') with the password fields in the records and they match!

UGH! Any other ideas?

Offline

 

#10 2021-09-30 21:35:35

tiagoc
Member
2021-09-28
8

Re: Can't login after upgrade to 11.50

Just to confirm, you used the password "secret", without quotes or single quotes, right? ;)

Try to set a blank password using the query:

update gal_users set password="" where id=1;

Offline

 

#11 2021-09-30 21:42:10

sierra.bmwcca
Member
2021-09-26
12

Re: Can't login after upgrade to 11.50

Yes, I entered it in as secret
I tried the blank password and the same thing.

Offline

 

#12 2021-10-01 02:07:55

tiagoc
Member
2021-09-28
8

Re: Can't login after upgrade to 11.50

I'm not sure if this will work because the passwords are encrypted in the database using a unique string created during the installation. Anyway, try this:

update gal_users set password="$P$GIYAokr6WHWYFovrT81UuVUrNitJMA1" where id=1;

and try to login using "secret" as the password for the username with id=1 in the database.

If it still fails, I believe the only option will be (if no one else has better suggestions):

1) make a new installation of Piwigo (let's call it "instance B")

2) go to the database of your original installation of Piwigo (let's call it "instance A"), table "gal_config", param="secret_key", and copy the string in the value field

3) update the database of "instance B", table "gal_config", param="secret_key", and set the value to the string copied in #2:

update <PREFIX>_config set value="<STRING>" where param="secret_key"
(or just paste the string in the correct field, if you're using a MySQL client that allows you to do it)

4) register a new user in the frontend of "instance B" (with any username) and set the password as "secret"

5) go to the database of "instance B", table "gal_users", and copy the string in the password field

6) go to the database of "instance A", table "gal_users", and paste the string copied before (in #5) to the password field of your admin user

7) test the login of your admin user in the frontend of "instance A"

8) if #7 is successful:
a) change the password in the frontend to something more complex
b) repeat #6, #7 and #8a for the other admin user

9) delete/remove "instance B"

If #7 doesn't work.... I'm out of ideas ;)

Offline

 

#13 2021-10-01 10:41:30

erAck
Only trying to help
2015-09-06
1414

Re: Can't login after upgrade to 11.50


Running Piwigo at https://erack.net/gallery/

Offline

 

#14 2021-10-01 22:48:37

sierra.bmwcca
Member
2021-09-26
12

Re: Can't login after upgrade to 11.50

In 4) I wasn't able to create a user from the front end but I created it on the back end then proceeded with 5-7 and the same thing. :(

Is there any way I can transfer the site into this new site from file manager? They are both on the same version.

Is there any way I can reset the login module? As all my galleries are there?

Offline

 

#15 2021-10-02 00:31:07

tiagoc
Member
2021-09-28
8

Re: Can't login after upgrade to 11.50

I tried this solution (I had seen it before) but it didn't work for me: the output wasn't the same as the string I have in the DB (for the same password and without having changed the $conf['password_hash'])

tiagoc wrote:

If #7 doesn't work.... I'm out of ideas ;)

One other idea (more simple than the previous):
- register a new user in your current Piwigo (instance A)
- go to the DB and copy the password from the new user to the admin user, or run the query: update gal_users set password = (select password from gal_users where id=1) where id=<ID-OF-YOUR-NEW-USER>
- login using the admin user and the password from the nem user

To move you installation to the new one, you'll need to restore some tables, from one DB to the other. It'll require some manual work, to export some things and not others (for example: export image-related data, from categories, comments, favorites, images, ... but don't export nothing related to the admin users or some  entries from the config table that are specific)

Offline

 

Board footer

Powered by FluxBB

github twitter newsletter Donate Piwigo.org © 2002-2022 · Contact