If you find an error such as shown below
=================
Connection refused_ 421 4.3.0 deliver: couldn't connect to lmtpd_ )
=================
fix is shown below
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.
Howto: Make Your Own Cert With OpenSSL on Windows Courtesy — Mr. Didier Stevens https://blog.didierstevens.com/ For your info: The author of this document Mr.Stevens have a video showing this howto . First of all, on Windows you will need to install OpenSLL from binaries . I got these binaries . I installed the latest version (v1.0.2a) and choose the 32-bit version (Win32). I choose the 32-bit version because this will work for every Windows machine: the 32-bit version works on 32-bit and 64-bit machines. If you start the installation and get the following message: then you need to cancel the installation and install the Visual C++ 2008 Redistributables first. You can find download links on the same page . If you install Win32 OpenSSL (32-bit), install Visual C++ 2008 Redistributables, and if you install Win64 OpenSSL (64-bit), install Visual C++ 2008 Redistributables (x64). The installation of the Redistributables is easy: After this, you can r...
Comments
Post a Comment