Mysql - OnlineSupport4u

Mysql

error while loading shared libraries: libasound.so.2: cannot open shared object file: No such file or directory

By Prasad Naik

June 22, 2020

I was gettnig error mentioned below “error while loading shared libraries: libasound.so.2:” on Centos 7 OS yum -y install alsa-lib-devel fixed the issue yum -y install alsa-lib-develLoaded plugins: fastestmirror, universal-hooksLoading mirror speeds from cached hostfile EA4: 208.74.123.61 cpanel-addons-production-feed: 208.74.123.61 cpanel-plugins: 208.74.123.61 base: www.gtlib.gatech.edu epel: mirror.oss.ou.edu extras: mirror.dal10.us.leaseweb.net nux-dextop: mirror.li.nux.ro updates: mirror.dal10.us.leaseweb.netResolving Dependencies–> Running transaction check—> […]

Mysql

Debian7 404 error

By Prasad Naik

June 19, 2020

Was working on Debian 7 server and on trying to update using command apt-get update was getting 404 error I could see 404 error on command apt-get update root@debian:/home/nvc# vi /etc/resolv.confroot@debian:/home/nvc# apt-get updateIgn cdrom://[Debian GNU/Linux 7.11.0 Wheezy – Official amd64 DVD Binary-1 20160605-17:36] wheezy Release.gpgIgn cdrom://[Debian GNU/Linux 7.11.0 Wheezy – Official amd64 DVD Binary-1 20160605-17:36] […]

Mysql

CGI download issue

By Prasad Naik

June 16, 2020

Enable CGI through .htaccess To enable CGI through .htaccess, perform the following steps: Log in to your server as the root user via SSH. Change to the /usr/local/apache/conf/ directory. Create a backup of your httpd.conf file. For example: Note: In this example, http-old.conf represents the backup file’s name. 4. Open your http.conf file with a […]

Mysql

fix corrupted named.conf in cPanel

By Prasad Naik

June 12, 2020

We had an issue where in cPanel server where we had our rDNS settings were no working. On editing and saving the file from WHM , Rdns worked Found the issue was due to corrupted named.conf Below are the steps undertaken to rebuild named.conf mv /etc/named.conf /etc/named.conf.bak /usr/local/cpanel/scripts/rebuilddnsconfig /scripts/restartsrv_named Now rdns and other records are […]

Mysql

The system received an error from the “MySQL” database “mysql”: ER_PASSWORD_NO_MATCH

By Prasad Naik

June 1, 2020

While resetting the cpanel account password from WHM I saw above error after resetting the passwor. I see the issue was due to the parameter skip-name-resolve in mysql config /etc/my.cnf Removing the command and restarting the mysql fixed the issue

Mysql

Exim Error: Failed to create directory “/var/spool/exim/db”: Permission denied

By Prasad Naik

May 20, 2020

We came across an issue where emails were not coming to server on checking logs we saw below error failed to open DB file /var/spool/exim/db/ratelimit: Permission denied (euid=47 egid=12) We executed below steps to fix the error 1003 2020-05-20 11:38:14 rm -fv /var/spool/exim/db/*1004 2020-05-20 11:38:30 service exim restart1005 2020-05-20 11:39:22 chown -R mailnull.mail /var/spool/exim1006 2020-05-20 […]

Mysql

Change SSH port on Centos 7

By Prasad Naik

April 9, 2020

Open file using command vi /etc/ssh/sshd_config #Port 22 remove the # symbol and change the default port 22 and change it accordingly to your preference save the file and exit semanage port -a -t ssh_port_t -p tcp 2244 where 1234 is my ssh port firewall-cmd --permanent --zone=public --add-port=1234/tcp firewall-cmd --reload systemctl restart sshd.service Now telnet […]

Mysql

named.service failed. Centos Web Panel

By Prasad Naik

March 13, 2020

Named on Centos webpanel was not starting on server On checking logs only below information were displayed named.service – Berkeley Internet Name Domain (DNS) Loaded: loaded (/usr/lib/systemd/system/named.service; enabled; vendor preset: disabled) Active: failed (Result: exit-code) since Fri 2020-03-13 07:30:38 EDT; 5min ago Process: 24466 ExecStartPre=/bin/bash -c if [ ! “$DISABLE_ZONE_CHECKING” == “yes” ]; then /usr/sbin/named-checkconf […]

Mysql

Invalid command ‘SetEnv’, perhaps misspelled or defined by a module not included in the server configuration,

By Prasad Naik

March 12, 2020

While working on server We saw one website giving 500 error On checking I see error was coming on .htaccess rules /docs/subdomains/my/public_html/.htaccess: Invalid command ‘SetEnv’, perhaps misspelled or defined by a module not included in the server configuration To resolve this problem, we need to install the module ‘mod_env’ manually. For easyapache4 users, #yum install […]

Mysql

“No route to host” fix for Centos 7

By Prasad Naik

February 27, 2020

After changing SSH port, If I try to SSH using new port number I was getting error “no route to host” The issue was due to IPtables I have to flush all firewall rules using IPtables -f serveice iptables restart This fixed the ssh port issue

Mysql

ERROR 1118 (42000) at line 661: Row size too large (> 8126). Changing some columns to TEXT or BLOB may help. In current row format, BLOB prefix of 0 bytes is stored inline.

By Prasad Naik

February 18, 2020

We had this issue while dumping one database We added below parameter in /etc/my.cnf innodb_strict_mode = 0 And restarted Mysql Now mysql dump worked fine

Mysql

error: Unable to read from monitor: Connection reset by peer

By Prasad Naik

January 17, 2020

KVM based VPS was giving belolw error “error: Unable to read from monitor: Connection reset by peer” The fix was to disable VNC in VPS settings and start vps which worked fine with me