Posts

Showing posts from 2019

redhat free cost Developer subscription

Create a new login in  https://developers.redhat.com An email will be send from redhat for the activation to the email ID with which the new login is created. Once confirmed by clicking the link, login to  https://developers.redhat.com to verify the correct login. Afterwards login to   https://access.redhat.com/  to verify the active subscription . Then login to the Newly installed redhat server via ssh and execute the following commands sudo subscription-manager register when username and password is asked, provide the login credentials created previously. after that if an error comes like this: ================= HTTP error (401 - Unauthorized): You must first accept Red Hat's Terms and conditions.  Please visit https://www.redhat.com/wapps/tnc/ackrequired?site=candlepin&event=signOn . You may have to log out of and back into the  Customer Portal in order to see the terms. ================= login to the link provided and accept the terms and

CDbConnection failed to open the DB connection mysql 8

Image
While accessing web configured with mysql 8 and php and you see the following error: CDbConnection failed to open the DB connection: SQLSTATE[HY000] [2054] The server requested authentication method unknown to the client OR  PHP Fatal error:  Uncaught PDOException: PDO::__construct(): The server requested authentication method unknown to the client [caching_sha2_password]  It maybe due to  PHP devs might have not implemented the MySQL's 8.0 connection protocol ( auth with caching_sha2_password ) within the newer PHP versions. If you want to use mysql >= 8 and you dont care about caching_sha2_password,  If you are running a fresh install of mysql 8, just select the second option as shown in the image. Otherwise, you need to  configure MySQL 8.0 to run in mysql_native_password mode. As it can't configured in my.cnf, change the user profile as:- ALTER USER 'mysqlUsername'@'localhost' IDENTIFIED WITH mysql_native_password BY 'mysqlUse