MRatWork Forum by Mustafa Ramadhan

Sawo Project - Kloxo-MR Discussions => Kloxo-MR Bugs and Requests => Topic started by: postcd on 2017-03-12, 00:45:35

Title: CentOS6+CMR7 - ERROR 2002 (HY000): Can't connect to local MySQL, No such file..
Post by: postcd on 2017-03-12, 00:45:35
Hello,

on CentOS release 6.8 (Final) 32bit i installed kloxomr7-7.0.0.c-2017030803.mr.noarch according to installation instructions (https://github.com/mustafaramadhan/kloxo/blob/dev/how-to-install.txt) 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 (http://pastebin.com/Hp9jqPLV)

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
Title: Re: CentOS6+CMR7 - ERROR 2002 (HY000): Can't connect to local MySQL, No such file..
Post by: MRatWork on 2017-03-12, 04:33:45
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.
Title: Re: CentOS6+CMR7 - ERROR 2002 (HY000): Can't connect to local MySQL, No such file..
Post by: postcd on 2017-03-16, 10:45:26
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
Title: Re: CentOS6+CMR7 - ERROR 2002 (HY000): Can't connect to local MySQL, No such file..
Post by: MRatWork on 2017-03-16, 13:21:58
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.