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-04-28, 01:03:58

Author Topic: MySQL Going down  (Read 4262 times)

0 Members and 1 Guest are viewing this topic.

Offline shohag121

  • Junior Member
  • *
  • Posts: 15
  • Karma: +0/-0
    • View Profile
MySQL Going down
« on: 2015-01-12, 05:40:40 »
At a certain time of a day mysql is going down.
browser showing.

Your PHP installation appears to be missing the MySQL extension

its solving after running sh /script/cleanup

what can i do to solve it permanently.

Offline MRatWork

  • Administrator
  • The Elite
  • *****
  • Posts: 15,807
  • Karma: +119/-11
  • Gender: Male
    • View Profile
    • MRatWork Forum
Re: MySQL Going down
« Reply #1 on: 2015-01-12, 20:47:46 »
Inform here your 'sh /script/sysinfo; yum list installed|grep phpmyadmin'.
..:: MRatWork (Mustafa Ramadhan Projects) ::..
-- Server/Web-integrator - Web Hosting (Kloxo-MR READY!) --

Offline shohag121

  • Junior Member
  • *
  • Posts: 15
  • Karma: +0/-0
    • View Profile
Re: MySQL Going down
« Reply #2 on: 2015-01-13, 09:30:41 »
Inform here your 'sh /script/sysinfo; yum list installed|grep phpmyadmin'.

A. Kloxo-MR: 7.0.0.b-2015011302

B. OS: CentOS release 6.6 (Final) i686

C. Apps:
   1. MySQL: mysql55-5.5.41-2.ius.el6.i686
   2. PHP: php54-5.4.36-1.ius.el6.i686
   3. Httpd: httpd-2.2.29-1.mr.el6.i386
   4. Lighttpd: --uninstalled--
   5. Hiawatha: hiawatha-9.10.1-f.1.mr.el6.i386
   6. Nginx: nginx-1.7.9-1.el6.ngx.i386
   7. Cache: --uninstalled--
   8. Dns: djbdns-1.05-17.4.mr.el6.i386
   9. Qmail: qmail-toaster-1.03-1.3.45.mr.el6.i386
      - with: courier-imap-toaster-4.1.2-1.3.18.mr.el6.i386

D. Php-type (for Httpd/proxy): php-fpm_event

E. Memory:
                total       used       free     shared    buffers     cached
   Mem:          1893        731       1161          0        168        300
   -/+ buffers/cache:        261       1631
   Swap:         1023          1       1022

kloxomr7-thirdparty-phpmyadmin.noarch
« Last Edit: 2015-01-13, 09:35:56 by shohag121 »

Offline shohag121

  • Junior Member
  • *
  • Posts: 15
  • Karma: +0/-0
    • View Profile
Re: MySQL Going down
« Reply #3 on: 2015-01-15, 03:54:01 »
Any body can help?

Please help to solvethis problem.

Offline MRatWork

  • Administrator
  • The Elite
  • *****
  • Posts: 15,807
  • Karma: +119/-11
  • Gender: Male
    • View Profile
    • MRatWork Forum
Re: MySQL Going down
« Reply #4 on: 2015-01-15, 04:09:17 »
Try 'yum clean all; yum update' and then after Kloxo-MR updated, run 'sh /script/cleanup'.
..:: MRatWork (Mustafa Ramadhan Projects) ::..
-- Server/Web-integrator - Web Hosting (Kloxo-MR READY!) --

Offline shohag121

  • Junior Member
  • *
  • Posts: 15
  • Karma: +0/-0
    • View Profile
Re: MySQL Going down
« Reply #5 on: 2015-01-15, 04:26:44 »
I'm fetching this problem after installing APC and mod_pagespeed for nginx .

is there any relation with those?

Offline MRatWork

  • Administrator
  • The Elite
  • *****
  • Posts: 15,807
  • Karma: +119/-11
  • Gender: Male
    • View Profile
    • MRatWork Forum
Re: MySQL Going down
« Reply #6 on: 2015-01-15, 06:02:11 »
Do you mean PhpMyAdmin in website and not in Kloxo-MR panel?.
..:: MRatWork (Mustafa Ramadhan Projects) ::..
-- Server/Web-integrator - Web Hosting (Kloxo-MR READY!) --

Offline shohag121

  • Junior Member
  • *
  • Posts: 15
  • Karma: +0/-0
    • View Profile
Re: MySQL Going down
« Reply #7 on: 2015-01-15, 06:44:31 »
mysql in kloxo-MR seems ok because i can login in Kloxo-MR and mysqld showing green in service page.

but for my wordpress installation it showing "Your PHP installation appears to be missing the MySQL extension"

yum clean all
yum update
sh /script/cleanup

couldn't solve the problem permanently
 
« Last Edit: 2015-01-15, 06:49:35 by shohag121 »

Offline MRatWork

  • Administrator
  • The Elite
  • *****
  • Posts: 15,807
  • Karma: +119/-11
  • Gender: Male
    • View Profile
    • MRatWork Forum
Re: MySQL Going down
« Reply #8 on: 2015-01-15, 09:27:57 »
What's php version installed in your server. Inform here 'yum list installed php*'.
..:: MRatWork (Mustafa Ramadhan Projects) ::..
-- Server/Web-integrator - Web Hosting (Kloxo-MR READY!) --

Offline shohag121

  • Junior Member
  • *
  • Posts: 15
  • Karma: +0/-0
    • View Profile
Re: MySQL Going down
« Reply #9 on: 2015-01-17, 04:06:18 »

Installed Packages
php54.i686                      5.4.36-1.ius.el6            @mratwork-ius-stable
php54-cli.i686                  5.4.36-1.ius.el6            @mratwork-ius-stable
php54-common.i686               5.4.36-1.ius.el6            @mratwork-ius-stable
php54-embedded.i686             5.4.36-1.ius.el6            @mratwork-ius-stable
php54-fpm.i686                  5.4.36-1.ius.el6            @mratwork-ius-stable
php54-imap.i686                 5.4.36-1.ius.el6            @mratwork-ius-stable
php54-intl.i686                 5.4.36-1.ius.el6            @mratwork-ius-stable
php54-ldap.i686                 5.4.36-1.ius.el6            @mratwork-ius-stable
php54-litespeed.i686            5.4.36-1.ius.el6            @mratwork-ius-stable
php54-mbstring.i686             5.4.36-1.ius.el6            @mratwork-ius-stable
php54-mcrypt.i686               5.4.36-1.ius.el6            @mratwork-ius-stable
php54-mysql.i686                5.4.36-1.ius.el6            @mratwork-ius-stable
php54-pdo.i686                  5.4.36-1.ius.el6            @mratwork-ius-stable
php54-pear.noarch               1:1.9.5-2.ius.el6           @mratwork-ius-stable
php54-pecl-geoip.i686           1.0.8-3.ius.el6             @mratwork-ius-stable
php54-process.i686              5.4.36-1.ius.el6            @mratwork-ius-stable
php54-pspell.i686               5.4.36-1.ius.el6            @mratwork-ius-stable
php54-recode.i686               5.4.36-1.ius.el6            @mratwork-ius-stable
php54-snmp.i686                 5.4.36-1.ius.el6            @mratwork-ius-stable
php54-soap.i686                 5.4.36-1.ius.el6            @mratwork-ius-stable
php54-tidy.i686                 5.4.36-1.ius.el6            @mratwork-ius-stable
php54-xml.i686                  5.4.36-1.ius.el6            @mratwork-ius-stable

Offline MRatWork

  • Administrator
  • The Elite
  • *****
  • Posts: 15,807
  • Karma: +119/-11
  • Gender: Male
    • View Profile
    • MRatWork Forum
Re: MySQL Going down
« Reply #10 on: 2015-01-17, 04:56:08 »
Try 'yum install php54-mysqlnd php54-pecl-mysqlnd-ms -y; sh /script/restart-web -y'
..:: MRatWork (Mustafa Ramadhan Projects) ::..
-- Server/Web-integrator - Web Hosting (Kloxo-MR READY!) --

Offline shohag121

  • Junior Member
  • *
  • Posts: 15
  • Karma: +0/-0
    • View Profile
Re: MySQL Going down
« Reply #11 on: 2015-01-17, 07:54:24 »
Try 'yum install php54-mysqlnd php54-pecl-mysqlnd-ms -y; sh /script/restart-web -y'

Resolving Dependencies
--> Running transaction check
---> Package php54-mysqlnd.i686 0:5.4.36-1.ius.el6 will be installed
---> Package php54-pecl-mysqlnd-ms.i686 0:1.5.2-1.ius.el6 will be installed
--> Processing Conflict: php54-mysql-5.4.36-1.ius.el6.i686 conflicts php54-mysqlnd
--> Finished Dependency Resolution
Error: php54-mysql conflicts with php54-mysqlnd-5.4.36-1.ius.el6.i686
 You could try using --skip-broken to work around the problem
 You could try running: rpm -Va --nofiles --nodigest

Offline MRatWork

  • Administrator
  • The Elite
  • *****
  • Posts: 15,807
  • Karma: +119/-11
  • Gender: Male
    • View Profile
    • MRatWork Forum
Re: MySQL Going down
« Reply #12 on: 2015-01-17, 08:25:50 »
Try 'rpm -e --nodeps php54-mysql; yum install php54-mysqlnd php54-pecl-mysqlnd-ms -y; sh /script/restart-web -y'
..:: MRatWork (Mustafa Ramadhan Projects) ::..
-- Server/Web-integrator - Web Hosting (Kloxo-MR READY!) --

 


Top 4 Global Search Engines:    Google    Bing    Baidu    Yahoo
Click Here

Page created in 0.031 seconds with 18 queries.

web stats analysis