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
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
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
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).
Offline
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
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
Sorry running MySQL 5.7
Offline
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
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
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
Yes, I entered it in as secret
I tried the blank password and the same thing.
Offline
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
Offline
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
erAck wrote:
See [Forum, post 181215 by erAck in topic 31381] Lost password.
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