Sponsor:

Server and Web Integrator
Link:
Kloxo-MR logo
6.5.0 or 7.0.0
Click for "How to install"
Donation/Sponsorship:
Kloxo-MR is open-source.
Donate and or Sponsorship always welcome.
Click to:
Click Here
Please login or register. 2024-03-29, 08:24:24

Author Topic: CentOS6+CMR7 - ERROR 2002 (HY000): Can't connect to local MySQL, No such file..  (Read 3158 times)

0 Members and 1 Guest are viewing this topic.

Offline postcd

  • Junior Member
  • *
  • Posts: 26
  • Karma: +0/-0
    • View Profile
Hello,

on CentOS release 6.8 (Final) 32bit i installed kloxomr7-7.0.0.c-2017030803.mr.noarch according to installation instructions including yum update. I noticed some issues during the process:

https://s8.postimg.org/683ms3v8l/kloxomr7_errors_install_cent6.gif

When i ran "sh /script/cleanup" this appeared:

Quote
- Create database interface template (Forced)
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2 "No such file or directory")

Quote
ERROR! MySQL server PID file could not be found!
Starting MySQL.170311 18:35:43 mysqld_safe Logging to '/var/lib/mysql/vps.centos6.tld.err'.
170311 18:35:43 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
 ERROR!
-------------------------------------------------------------------

Stopping php-fpm (PHP Used):                               [FAILED]
Starting php-fpm (PHP Used): [11-Mar-2017 18:35:44] ERROR: failed to open configuration file '/opt/configs/php-fpm/conf/php/php-fpm.conf': No such file or directory (2)
[11-Mar-2017 18:35:44] ERROR: failed to load configuration file '/opt/configs/php-fpm/conf/php/php-fpm.conf'
[11-Mar-2017 18:35:44] ERROR: FPM initialization failed
                                                           [FAILED]
-------------------------------------------------------------------

Then i also ran "sh /script/upcp -y" but it not helped (same mysql error).

I think i ran yum erase mysql* before install. Also i seen this error (probably during "sh /script/upcp -y"):

Quote
--> Processing Conflict: mysql55-libs-5.5.54-1.ius.centos6.i686 conflicts mysql-libs < 5.5
--> Finished Dependency Resolution
Error: mysql55-libs conflicts with MariaDB-compat-10.0.30-1.el6.i686
 You could try using --skip-broken to work around the problem
 You could try running: rpm -Va --nofiles --nodigest

yum list mysql* result here

tried update /etc/yum.conf to contain:
exclude=mysql5* MariaDB*
or
exclude=mysql51* mysql56* MariaDB*
and then run:
sh /script/upcp -y
but same mysql error

server details:
Quote
# sh /script/sysinfo
A. Control Panel:
   - Kloxo-MR: 7.0.0.c-2017030803
   - Web: hiawatha-10.5.0-f.2.mr.el6.i686
   - PHP: php56s-5.6.30-1.ius.centos6 (fpm mode)
B. Plateform:
   - OS: CentOS release 6.8 (Final) i686
   - Hostname: vps.centos6.tld
C. Services:
   1. MySQL: MariaDB-server-10.0.30-1.el6.i686
   2. PHP:
      - Installed:
        - Branch: php56u-cli-5.6.30-1.ius.centos6.i686
      - Used: --PHP Branch--
      - Multiple: disable
   3. Web Used: apache
     - Hiawatha: hiawatha-10.5.0-f.2.mr.el6.i686
     - Lighttpd: lighttpd-1.4.45-1.el6.i686
     - Nginx: nginx-1.11.10-1.el6.ngx.i386
     - Apache: httpd24u-2.4.25-3.ius.centos6.i686
       - PHP Type: php-fpm_event (default)
       - Secondary PHP: off

Can i try to fix it anyhow please? How to install it successfully? Thank You
« Last Edit: 2017-03-12, 03:18:47 by postcd »

Offline MRatWork

  • Administrator
  • The Elite
  • *****
  • Posts: 15,807
  • Karma: +119/-11
  • Gender: Male
    • View Profile
    • MRatWork Forum
There are something wrong with your server. Kloxo-MR 7 must be 'Kloxo-MR: 7.0.0.c-2017030803' (8 Mar 2017) instead 'Kloxo-MR: 7.0.0.c-2017031002' or more (10 Mar 2017).

Try:
Code: [Select]
'rm' -f /var/lib/rpm/__db*
rpm --rebuilddb

yum clean all
yum update -y
before running Kloxo-MR install steps.
..:: MRatWork (Mustafa Ramadhan Projects) ::..
-- Server/Web-integrator - Web Hosting (Kloxo-MR READY!) --

Offline postcd

  • Junior Member
  • *
  • Posts: 26
  • Karma: +0/-0
    • View Profile
When i executed Yours mentioned commands before installation, the installation of 7.0.0.c-2017031002.mr apparently succeeded regarding mysql

Quote
*** Process for MYSQL/MARIADB service ***
  - Process: restart
Shutting down MySQL.... SUCCESS!
Starting MySQL170316 05:42:22 mysqld_safe Logging to '/var/lib/mysql/vps.centos6.tld.err'.
.170316 05:42:22 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
... SUCCESS!

Might be good to add your commands right to the installation script

Offline MRatWork

  • Administrator
  • The Elite
  • *****
  • Posts: 15,807
  • Karma: +119/-11
  • Gender: Male
    • View Profile
    • MRatWork Forum
When i executed Yours mentioned commands before installation, the installation of 7.0.0.c-2017031002.mr apparently succeeded regarding mysql

Quote
*** Process for MYSQL/MARIADB service ***
  - Process: restart
Shutting down MySQL.... SUCCESS!
Starting MySQL170316 05:42:22 mysqld_safe Logging to '/var/lib/mysql/vps.centos6.tld.err'.
.170316 05:42:22 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
... SUCCESS!

Might be good to add your commands right to the installation script

I didn't touched mysql/mariadb service file.
..:: MRatWork (Mustafa Ramadhan Projects) ::..
-- Server/Web-integrator - Web Hosting (Kloxo-MR READY!) --

 


MRatWork Affiliates:    BIGRAF(R) Inc.    House of LMAR    EFARgrafix
Click Here

Page created in 0.069 seconds with 19 queries.

web stats analysis