Hello Team ,
I am getting an error messages please advise how to proceed with this.
[root@frsellaappesc12 data]# sudo mysqld_safe --skip-grant-tables --skip-networking
220331 05:10:25 mysqld_safe Logging to ‘//data/frsellaappesc12.err’.
220331 05:10:25 mysqld_safe Starting mysqld daemon with databases from //data
[root@frsellaappesc12 data]# ps -ef |grep mysql
root 3452 19948 0 05:11 pts/0 00:00:00 grep --color=auto mysql
tomcat 28912 1 13 mars14 ? 2-05:15:43 /usr/lib/jvm/java-1.8.0-openjdk-1.8.0.312.b07-1.el7_9.x86_64/jre/bin/java -Dmariadb_connectionString_escmdata=jdbc:mysql://localhost/escmdata_hermes?useSSL=false -Dmariadb_connectionString_escmparameters=jdbc:mysql://localhost/escmparameters_hermes?useSSL=false -Dmariadb_connectionString_habilitation=jdbc:mysql://localhost/habilitation_hermes?useSSL=false -Dmariadb_connectionString_portail=jdbc:mysql://localhost/portail_hermes?useSSL=false -Dmariadb_password=K09a2@eR$fN3mqPXV$69KjTHe -Dmariadb_username=escm -Dws_po_url=https://rct-esb-corp.atlas.hermes/services/manufacturing/purchaseordermanagement/corp/v1 -Dws_pkl_url=https://rct-esb-corp.atlas.hermes/services/manufacturing/packinglistmanagement/corp/v1 -Dws_ts_url=https://rct-esb-corp.atlas.hermes/services/manufacturing/controlsheetmanagement/v1 -Dws_login=esb_r_ws_esc -Dws_password=64a4b98f9b -Xms512m -Xmx4096m -XX:+UseParallelGC -server -classpath /opt/rh/jws5/root/usr/share/tomcat/bin/bootstrap.jar:/opt/rh/jws5/root/usr/share/tomcat/bin/tomcat-juli.jar -Dcatalina.base=/opt/rh/jws5/root/usr/share/tomcat -Dcatalina.home=/opt/rh/jws5/root/usr/share/tomcat -Djava.endorsed.dirs= -Djava.io.tmpdir=/var/opt/rh/jws5/cache/tomcat/temp -Djava.util.logging.config.file=/opt/rh/jws5/root/usr/share/tomcat/conf/logging.properties -Djava.util.logging.manager=org.apache.juli.ClassLoaderLogManager -Djava.library.path=/opt/rh/jws5/root/usr/lib64 org.apache.catalina.startup.Bootstrap start
[root@frsellaappesc12 data]# mysql -u root
ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ‘/var/lib/mysql/mysql.sock’ (2)
[root@frsellaappesc12 data]# systemctl start mysql
Job for mariadb.service failed because the control process exited with error code. See “systemctl status mariadb.service” and “journalctl -xe” for details.
[root@frsellaappesc12 data]#
I found the below process are running for TCP
[root@frsellaappesc12 data]# lsof -i:3306
COMMAND PID USER FD TYPE DEVICE SIZE/OFF NODE NAME
java 28912 tomcat 70u IPv6 401284919 0t0 TCP localhost:35802->localhost:mysql (CLOSE_WAIT)
java 28912 tomcat 71u IPv6 400571341 0t0 TCP localhost:58816->localhost:mysql (CLOSE_WAIT)
java 28912 tomcat 72u IPv6 400590128 0t0 TCP localhost:58844->localhost:mysql (CLOSE_WAIT)
Regards
Prashant