Search This Blog

Wednesday, July 15, 2020

Tuesday, July 14, 2020

Mysql : replace special characters or any words in perticular column in UPDATE statement

Replace # symbol with empty in the given column.
 

SET SQL_SAFE_UPDATES = 0;

update table_name set col_name = replace (col_name,'#','');

Install HP Printer in Ubuntu 20.04

Goto https://developers.hp.com/hp-linux-imaging-and-printing/gethplip
download the hplib with for your OS.

> cd /home/drvijay/Downloads/

> sudo chmod +x hplip-3.20.6.run
> ./hplip-3.20.6.run

or

> sudo apt install hplip-gui

#if any error, then below command will fix

> sudo apt install $(echo $(apt-cache search hplip | sed 's/ - .*$//g'))


















windows key -> type -> hp tool box

Sunday, July 5, 2020

MySQL - Linux Ubuntu Environemnt - which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

please see one of the step will work

Step-1
In your mysql benchmark

SET GLOBAL sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY',''));

Restart your mysql service.
> service mysql restart

OR

Step-2

In Linux Terminal > sudo vi /etc/mysql/mysql.conf.d/mysqld.cnf Go to last line and add > sql_mode = "" Restart mysql server.
> service mysql restart

Friday, July 3, 2020

Failed to configure SaslClientAuthenticator Caused by: org.apache.kafka.common.KafkaException: Principal could not be determined from Subject, this may be a transient failure due to Kerberos re-login

#php
sasl.mechanisms = PLAIN

#java
//sasl.mechanism = java


props.put ( "ssl.endpoint.identification.algorithm","https");                  
props.put ( "sasl.jaas.config", "org.apache.kafka.common.security.plain.PlainLoginModule required serviceName=\"kafka\" username=\"XX\" password=\"xxx\";" );
props.put ( "sasl.mechanism", "PLAIN" );                //if it is java sasl.mechanism, for php = sasl.mechanisms


Hit Counter


View My Stats