search

Part-DB / Part-DB-legacy

[LEGACY Version] Open Source Electronic Parts Database using PHP and MySQL
GNU General Public License v2.0
158 stars 35 forks source link

Cannot login with either admin or user pass #122

Closed ObligedTester closed 9 months ago

ObligedTester commented 9 months ago

Hello,

Started up my old install of partdb legacy today to begin the migration work to another server and the latest version.

I encountered a strange issue, im not able to login to neither of my user accout or my admin account. I checked the users directly in the phpadmin interface, and i am using the correct login information. Is there a lockout timer for to many attempts? I might have used the incorrect info a couple of time before checking it in phpmyadmin

jbtronics commented 9 months ago

The permissions system was changed and therefore all user permissions were reset. To prevent problems, all users except the admin account with ID: 1.

Check which user has this ID by running: php bin/console partdb:users:list

It should be possible to login with the old password. However it that does not work you can reset the password with php bin/console partdb:users:set-password [username]

Afterwards login as the admin user, check the permissions of the other user and remove the checkbox at User disabled to allow them to login again

ObligedTester commented 9 months ago

Thanks for your reply! I will try this and get back to you.

However, i have not updated anything yet. This is my old install that worked before being offline for quite some time. So its still legacy version. Any clues why it wont accept the password that is stored when checking the database?

jbtronics commented 9 months ago

Does any error messages show up in Part-DB or in the browser console?

If you have accessed Part-DB in the past via https and now using just http, the browser might not accept a new cookie.

ObligedTester commented 9 months ago

The only error is the usual "incorrect username / password" on top of the page

ObligedTester commented 9 months ago

Alright I deleted my old confusing post.. I was able to get this to work. Fortunately I think my anonymous user had plenty of permissions. So i was able to via the GUI go in and change the other users passwords. I guess these needs to be generated and cannot be entered directly in phpmyadmin?

Looks like everything is working now, so im all set to move this to the new server and off from the slow rpi