Tuesday 4 October 2016

ERROR 2049 (HY000): Connection using old (pre-4.1.1) authentication protocol ref used (client option 'secure_auth' enabled)

Issue:-

ERROR 2049 (HY000): Connection using old (pre-4.1.1) authentication protocol ref used (client option 'secure_auth' enabled)..

Solution:-

On the command line, use below ....

mysql -uUSERNAME -pPASSWD DbName -h HostName --skip-secure-auth

OR

Login to mysql DB with root user.

show variables like 'old_passwords';
+-----------------+-------+
| Variable_name   | Value |
+-----------------+-------+
| old_passwords   | ON    |
|-----------------+-------+

old_passwords is ON is clearly the problem,
So temporarily changed it:


set session old_passwords = 'OFF';

show variables like 'old_passwords';

+-----------------+-------+
| Variable_name   | Value |
+-----------------+-------+
| old_passwords   | OFF   |
------------------+-------+

Created a new user:

create user 'username' IDENTIFIED BY 'passwd';

than try to connect DB.


mysqlbackup: WARNING: binlog file 'mysql-bin.000161' does not exist. It could have been purged. PITR will not be possible from this backup.

Issue:-
  
  Tape mysqlbackup failed because of below WARNING msg.
  
  mysqlbackup: WARNING: binlog file 'mysql-bin.000161' does not exist. It could have been purged. PITR will not be possible from this backup.
   
 
  Solution:-
 
  login to mysqlDB & check master status.
 
  show master status;
 
  if you see multiple Executed_Gtid_Set
 
  reset master;

  show master status;
 
  this time get single Executed_Gtid_Set
 

  re-run Tape mysqlbackup & check error log.

Thursday 21 April 2016

send-mail: warning: inet_protocols: IPv6 support is disabled: Address family not supported by protocol


Issue :--

send-mail: warning: inet_protocols: IPv6 support is disabled: Address family not supported by protocol
send-mail: warning: inet_protocols: configuring for IPv4 support only
postdrop: warning: inet_protocols: IPv6 support is disabled: Address family not supported by protocol
postdrop: warning: inet_protocols: configuring for IPv4 support only




Solution :--

Check below :- inet_protocols in /etc/postfix/main.cf file 

 more /etc/postfix/main.cf | grep inet_protocols
inet_protocols = all


To disable the messsage, go to /etc/postfix/main.cf and change from:

inet_protocols = all

TO

inet_protocols = ipv4


# /etc/init.d/postfix restart