Databases Locked Completely - Cannot Login

Please report bugs and any annoyances here. Kindly include all possible details: steps to reproduce, expected result, actual result, screenshots, ... etc.
Post Reply
mohamed
Veteran Member
Posts: 80
Joined: 2020-04-19 16:18

Databases Locked Completely - Cannot Login

Post by mohamed » 2022-07-03 17:23

Hi All,

I have a strange problem, that after Installing the new Windows Server with PHP 8.1.7 and MySQL 8.0.29 .. a fresh installation
and then Restore the databases from the Source Server.

I am not able to long in using any user inlcuidng admin :cry:

although that I have tried:
1. to reset the 'admin' password using the procedure in https://bigprof.com/appgini/faqs#faq14
AND
2. Restablising the databse setup by Deletinig both files; Config.PHP and Setup.MD5

I am not sure if PHP or MySQL new versions has anything to do it with it!

1. Have anybody come across such problem ?

2. Is there another way to reset Users or Settings other than deleting the files Config.PHP and Setup.MD5 ?



SOURCE SERVER:
- OS: Windows Server
- PHP: 8.1.4
- AppGini: 22.14
- MySQL: 8.0.28



DESTINATION SERVER:
- OS: Windows Server (identical to source)
- PHP: 8.1.7
- AppGini: 22.14
- MySQL: 8.0.29
THANK YOU...
AppGini Pro 24.11 -
Calendar - Search Page Maker - Summary Reports - Mass Update - DataTalk -
bizzworxx AppGini Helper JabaScript Library - bizzworxx Inline Detail-View - bizzworxx Helper Pack - AppGini Helper Packaging Tool -
Udemy course

User avatar
jsetzer
AppGini Super Hero
AppGini Super Hero
Posts: 1807
Joined: 2018-07-06 06:03
Location: Kiel, Germany
Contact:

Re: Databases Locked Completely - Cannot Login

Post by jsetzer » 2022-07-03 17:36

Just for clarification:

Can you access the database itself (not the web app) using a database tool like phpMyAdmin or Adminer, for example as standard user "root" with the defined password for "root"?

If the database itself is accessible for the root user, then check user and password in config.php.

Sometimes when installing an XAMPP/WAMP/LAMP/MAMP... package the password for root is left blank by default. You will have to set it manually. Usually there are scripts in package folder for setting the root-user password.
Kind regards,
<js />

My AppGini Blog:
https://appgini.bizzworxx.de/blog

You can help us helping you:
Please always put code fragments inside [code]...[/code] blocks for better readability

AppGini 24.10 Revision 1579 + all AppGini Helper tools

mohamed
Veteran Member
Posts: 80
Joined: 2020-04-19 16:18

Re: Databases Locked Completely - Cannot Login

Post by mohamed » 2022-07-03 18:49

Hi Jan,


Yes, I am able to logon to the database easily.
Nothing seems wrong with datatabase as well as the passwords in the script.


I am using Windows IIS


Thanks ...
THANK YOU...
AppGini Pro 24.11 -
Calendar - Search Page Maker - Summary Reports - Mass Update - DataTalk -
bizzworxx AppGini Helper JabaScript Library - bizzworxx Inline Detail-View - bizzworxx Helper Pack - AppGini Helper Packaging Tool -
Udemy course

pbottcher
AppGini Super Hero
AppGini Super Hero
Posts: 1635
Joined: 2018-04-01 10:12

Re: Databases Locked Completely - Cannot Login

Post by pbottcher » 2022-07-03 19:35

Hi,

what error do you get?
Any help offered comes with the best of intentions. Use it at your own risk. In any case, please make a backup of your existing environment before applying any changes.

mohamed
Veteran Member
Posts: 80
Joined: 2020-04-19 16:18

Re: Databases Locked Completely - Cannot Login

Post by mohamed » 2022-07-03 20:18

Hi pböttcher,

I have attached the actual screen, however the errors are as follows:
- in the URL: TheHost/DB/index.php?loginFailed=1

- in the Page: Your previous login atempt filed. Try again

However, its getting more weired, becuase I have copied/restrored 2 databases to the new server.
That the errors I am getting metioned above are of DB1
BUT
The 2nd DB, I just discovered that I am only able to login if I Check or select Remember me at the login page !! ;)

--> tried to Check Remember me for DB1 but no use its inaccessible in all cases.

Thank you
Attachments
Login Problem.PNG
Login Problem.PNG (106.91 KiB) Viewed 1414 times
THANK YOU...
AppGini Pro 24.11 -
Calendar - Search Page Maker - Summary Reports - Mass Update - DataTalk -
bizzworxx AppGini Helper JabaScript Library - bizzworxx Inline Detail-View - bizzworxx Helper Pack - AppGini Helper Packaging Tool -
Udemy course

mohamed
Veteran Member
Posts: 80
Joined: 2020-04-19 16:18

Re: Databases Locked Completely - Cannot Login

Post by mohamed » 2022-07-04 15:26

Hello ALL,

I have jhust thought of changing/downgranding the PHP version.
The Producton/old or Source Server running PHP v8.1.4
While
The New/Destination Server is urnning PHP v8.1.7

So, when I removed v8.1.7 and copied the PHP 8.1.4 from the other server, it started to work!!

I have no clue OR What feature or settings in PHP.INI or .DLLs could cause such weired behaviour!! :|

Thanks..
THANK YOU...
AppGini Pro 24.11 -
Calendar - Search Page Maker - Summary Reports - Mass Update - DataTalk -
bizzworxx AppGini Helper JabaScript Library - bizzworxx Inline Detail-View - bizzworxx Helper Pack - AppGini Helper Packaging Tool -
Udemy course

mohamed
Veteran Member
Posts: 80
Joined: 2020-04-19 16:18

Re: Databases Locked Completely - Cannot Login

Post by mohamed » 2022-07-04 15:54

Hello Again,

it seems I have not download the right PHP version for my IIS which is Non-Thread Safe (NTS), because when I downloaded this PHP NTS version 8.1.7 the databases worked successfully.

I should change my glasses :geek:


Thank and sorry for the trouble 8-)
THANK YOU...
AppGini Pro 24.11 -
Calendar - Search Page Maker - Summary Reports - Mass Update - DataTalk -
bizzworxx AppGini Helper JabaScript Library - bizzworxx Inline Detail-View - bizzworxx Helper Pack - AppGini Helper Packaging Tool -
Udemy course

Post Reply