Page 1 of 1

Databases Locked Completely - Cannot Login

Posted: 2022-07-03 17:23
by mohamed
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

Re: Databases Locked Completely - Cannot Login

Posted: 2022-07-03 17:36
by jsetzer
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.

Re: Databases Locked Completely - Cannot Login

Posted: 2022-07-03 18:49
by mohamed
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 ...

Re: Databases Locked Completely - Cannot Login

Posted: 2022-07-03 19:35
by pbottcher
Hi,

what error do you get?

Re: Databases Locked Completely - Cannot Login

Posted: 2022-07-03 20:18
by mohamed
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

Re: Databases Locked Completely - Cannot Login

Posted: 2022-07-04 15:26
by mohamed
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..

Re: Databases Locked Completely - Cannot Login

Posted: 2022-07-04 15:54
by mohamed
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-)