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
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
Databases Locked Completely - Cannot Login
Databases Locked Completely - Cannot Login
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
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
Re: Databases Locked Completely - Cannot Login
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.
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
AppGini 24.10 Revision 1579 + all AppGini Helper tools
<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 readabilityAppGini 24.10 Revision 1579 + all AppGini Helper tools
Re: Databases Locked Completely - Cannot Login
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 ...
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
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
Re: Databases Locked Completely - Cannot Login
Hi,
what error do you get?
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.
Re: Databases Locked Completely - Cannot Login
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
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 (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
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
Re: Databases Locked Completely - Cannot Login
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..
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
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
Re: Databases Locked Completely - Cannot Login
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
Thank and sorry for the trouble
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
Thank and sorry for the trouble
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
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