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 'mysqlUs...
If trying isql from server gives the following error, IM002][unixODBC][Driver Manager]Data source name not found, and no default driver specified [ISQL]ERROR: Could not SQLConnect Then check the results of following commands in servers odbcinst -q -s odbcinst -q -d if you find any error means that the server is unable to read both odbc.ini and odbcinst.ini files. To resolve this configure the environment variable of server as export ODBCSYSINI=/etc/ export ODBCINI=/etc/odbc.ini this should fix the error.
The default RPMforge repository does not replace any CentOS base packages. In the past it used to, but those packages are now in a separate repository (rpmforge-extras) which is disabled by default. You can find a complete listing of the RPMforge package packages at http://packages.sw.be/ Download the rpmforge-release package. Choose one of the two links below, selecting to match your host's architecture. If you are unsure of which one to use you can check your architecture with the command uname -i i386 http://packages.sw.be/rpmforge-release/rpmforge-release-0.5.2-2.el5.rf.i386.rpm x86_64 http://packages.sw.be/rpmforge-release/rpmforge-release-0.5.2-2.el5.rf.x86_64.rpm The preferred rpmforge-release package to retrieve and to install in order to enable that repository is one of the two listed above. Install DAG's GPG key rpm --import http://apt.sw.be/RPM-GPG-KEY.dag.txt Verify the package you have downloaded rpm -K rpmforge-release-0.5.2-2.el5.rf.*.rpm Securi...
Comments
Post a Comment