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. 2017-11-07, 20:57:04

Author Topic: Mysql tidak dapat di instal  (Read 2234 times)

0 Members and 1 Guest are viewing this topic.

Offline hamzun

  • Valuable Member
  • *
  • Posts: 56
  • Karma: +0/-0
    • View Profile
    • Game Android Cheats
Mysql tidak dapat di instal
« on: 2016-06-18, 16:55:22 »
Slamat malam pak Ramadhan..............
di sysinfo mysql tdk terintal dan saya coba instal mysql/mariadb tp hasilnya
tetap tdk ada tanda terinstal
tapi selama ini tdak ada masalah dgn domain/blog (bisa di akses normal)
cuma takutnya nanti kedapan ada masalah
apa klo di biarkan saja tdk akan terjadi masalah ato harus di intal?
Code: [Select]
A. Control Panel:
   - Kloxo-MR: 7.0.0.b-2016061502
   - Web: hiawatha-10.3.0-f.1.mr.el6.x86_64
   - PHP: php54s-5.4.45-1.ius.el6 (fpm mode)
B. Plateform:
   - OS: CentOS release 6.8 (Final) x86_64
   - Hostname: ns3.domainsaya.co
C. Services:
   1. MySQL: --uninstalled--
   2. PHP:
      - Installed:
        - Branch: php54-cli-5.4.45-1.ius.el6.x86_64
        - Multiple:
          * php53m-5.3.29-1.ius.el6
          * php54m-5.4.45-1.ius.el6
          * php55m-5.5.35-1.ius.el6
          * php56m-5.6.21-1.ius.el6
          * php70m-7.0.6-1.w6
      - Used: php54m-fpm
      - Multiple: disable
   3. Web Used: nginxproxy
     - Hiawatha: hiawatha-10.3.0-f.1.mr.el6.x86_64
     - Lighttpd: lighttpd-1.4.39-3.el6.x86_64
     - Nginx: nginx-1.11.1-1.el6.ngx.x86_64
     - Apache: httpd24u-2.4.20-3.ius.el6.x86_64
       - PHP Type: php-fpm_event
       - Secondary PHP: On

Offline MRatWork

  • Administrator
  • The Elite
  • *****
  • Posts: 15,381
  • Karma: +112/-9
  • Gender: Male
    • View Profile
    • MRatWork Forum
Re: Mysql tidak dapat di instal
« Reply #1 on: 2016-06-18, 17:05:31 »
Infokan 'yum list installed mysql* MariaDB*'.
..:: MRatWork (Mustafa Ramadhan Projects) ::..
-- Server/Web-integrator - Web Hosting (Kloxo-MR READY!) --

Offline hamzun

  • Valuable Member
  • *
  • Posts: 56
  • Karma: +0/-0
    • View Profile
    • Game Android Cheats
Re: Mysql tidak dapat di instal
« Reply #2 on: 2016-06-18, 17:12:45 »
Code: [Select]
[root@ns3 ~]# yum list installed mysql* MariaDB
Loaded plugins: fastestmirror, priorities, protectbase, replace
Loading mirror speeds from cached hostfile
 * base: mirror.san.fastserv.com
 * epel: mirror.prgmr.com
 * extras: linux.mirrors.es.net
 * mratwork-epel: mirror.prgmr.com
 * mratwork-ius-stable: mirrors.kernel.org
 * mratwork-webtatic: us-east.repo.webtatic.com
 * updates: mirror.hostduplex.com
0 packages excluded due to repository protections
Error: No matching Packages to list
[root@ns3 ~]#

Offline MRatWork

  • Administrator
  • The Elite
  • *****
  • Posts: 15,381
  • Karma: +112/-9
  • Gender: Male
    • View Profile
    • MRatWork Forum
Re: Mysql tidak dapat di instal
« Reply #3 on: 2016-06-18, 17:18:03 »
Wah anda lupa kalau MariaDB juga pakai tanda *.
..:: MRatWork (Mustafa Ramadhan Projects) ::..
-- Server/Web-integrator - Web Hosting (Kloxo-MR READY!) --

Offline hamzun

  • Valuable Member
  • *
  • Posts: 56
  • Karma: +0/-0
    • View Profile
    • Game Android Cheats
Re: Mysql tidak dapat di instal
« Reply #4 on: 2016-06-18, 17:26:17 »
ow iya...tdk tercopy
ini ane ulang..
Code: [Select]
[root@ns3 ~]# yum list installed mysql* MariaDB*
Loaded plugins: fastestmirror, priorities, protectbase, replace
Loading mirror speeds from cached hostfile
 * base: mirror.san.fastserv.com
 * epel: mirror.prgmr.com
 * extras: linux.mirrors.es.net
 * mratwork-epel: mirror.prgmr.com
 * mratwork-ius-stable: mirrors.kernel.org
 * mratwork-webtatic: us-east.repo.webtatic.com
 * updates: mirror.hostduplex.com
0 packages excluded due to repository protections
Installed Packages
MariaDB-Galera-server.x86_64           10.0.25-1.el6           @mratwork-mariadb
MariaDB-client.x86_64                  10.0.25-1.el6           @mratwork-mariadb
MariaDB-common.x86_64                  10.0.25-1.el6           @mratwork-mariadb
MariaDB-compat.x86_64                  10.0.25-1.el6           @mratwork-mariadb
MariaDB-shared.x86_64                  10.0.25-1.el6           @mratwork-mariadb
[root@ns3 ~]#

Offline MRatWork

  • Administrator
  • The Elite
  • *****
  • Posts: 15,381
  • Karma: +112/-9
  • Gender: Male
    • View Profile
    • MRatWork Forum
Re: Mysql tidak dapat di instal
« Reply #5 on: 2016-06-18, 17:35:20 »
Coba 'yum remove MariaDB-Galera-server -y; yum install MariaDB-server -y'.
..:: MRatWork (Mustafa Ramadhan Projects) ::..
-- Server/Web-integrator - Web Hosting (Kloxo-MR READY!) --

Offline hamzun

  • Valuable Member
  • *
  • Posts: 56
  • Karma: +0/-0
    • View Profile
    • Game Android Cheats
Re: Mysql tidak dapat di instal
« Reply #6 on: 2016-06-18, 17:45:39 »
ok berhasil pak
cuma penggunaan memory jd lebih besar
Code: [Select]
C. Services:
   1. MySQL: MariaDB-server-10.0.25-1.el6.x86_64
   2. PHP:
      - Installed:
        - Branch: php54-cli-5.4.45-1.ius.el6.x86_64
        - Multiple:
          * php53m-5.3.29-1.ius.el6
          * php54m-5.4.45-1.ius.el6
          * php55m-5.5.35-1.ius.el6
          * php56m-5.6.21-1.ius.el6
          * php70m-7.0.6-1.w6
      - Used: php54m-fpm
      - Multiple: disable
   3. Web Used: nginxproxy
     - Hiawatha: hiawatha-10.3.0-f.1.mr.el6.x86_64
     - Lighttpd: lighttpd-1.4.39-3.el6.x86_64
     - Nginx: nginx-1.11.1-1.el6.ngx.x86_64
     - Apache: httpd24u-2.4.20-3.ius.el6.x86_64
       - PHP Type: php-fpm_event
       - Secondary PHP: On
   4. WebCache: none
     - ATS: --uninstalled--
     - Squid: --uninstalled--
     - Varnish: --uninstalled--
   5. Dns: nsd
     - Bind: --uninstalled--
     - DJBDns: --uninstalled--
     - NSD: nsd-4.1.10-1.mr.el6.x86_64
     - PowerDNS: --uninstalled--
     - Yadifa: --uninstalled--
   6. Mail: qmail-toaster-1.03-1.3.55.mr.el6.x86_64
      - pop3/imap4: courier-imap-toaster-4.1.2-1.3.19.mr.el6.x86_64
      - spam: bogofilter-1.2.4-1.el6.x86_64
D. Memory:
                total       used       free     shared    buffers     cached
   Mem:           742        612        129         32         24        192
   -/+ buffers/cache:        395        346
   Swap:            0          0          0
E. Disk Space:
   Filesystem      Size  Used Avail Use% Mounted on
   /dev/vda1        15G  4.2G  9.9G  30% /


Offline MRatWork

  • Administrator
  • The Elite
  • *****
  • Posts: 15,381
  • Karma: +112/-9
  • Gender: Male
    • View Profile
    • MRatWork Forum
Re: Mysql tidak dapat di instal
« Reply #7 on: 2016-06-18, 17:49:44 »
MariaDB-Galera-server untuk remote sedangkan MariaDB-server untuk local.

Coba perhatikan di /etc/my.cnf.d/server.cnf ada tidak 'skip-innodb' di bawah '[mysqld]'.
..:: MRatWork (Mustafa Ramadhan Projects) ::..
-- Server/Web-integrator - Web Hosting (Kloxo-MR READY!) --

Offline hamzun

  • Valuable Member
  • *
  • Posts: 56
  • Karma: +0/-0
    • View Profile
    • Game Android Cheats
Re: Mysql tidak dapat di instal
« Reply #8 on: 2016-06-18, 18:01:17 »
tidak ada pak
isi filenya gini;
Code: [Select]
#
# These groups are read by MariaDB server.
# Use it for options that only the server (but not clients) should see
#
# See the examples of server my.cnf files in /usr/share/mysql/
#

# this is read by the standalone daemon and embedded servers
[server]

# this is only for the mysqld standalone daemon
[mysqld]

# this is only for embedded server
[embedded]

# This group is only read by MariaDB servers, not by MySQL.
# If you use the same .cnf file for MySQL and MariaDB,
# you can put MariaDB-only options here
[mariadb]

# This group is only read by MariaDB-10.0 servers.
# If you use the same .cnf file for MariaDB of different versions,
# use this group for options that older servers don't understand
[mariadb-10.0]


Offline MRatWork

  • Administrator
  • The Elite
  • *****
  • Posts: 15,381
  • Karma: +112/-9
  • Gender: Male
    • View Profile
    • MRatWork Forum
Re: Mysql tidak dapat di instal
« Reply #9 on: 2016-06-18, 18:17:47 »
Tambahkan 'skip-innodb' dibawah '[mysqld]'. Kemudian restart dengan 'sh /script/restart-mysql -y'.

Lihat lagi hasilnya pakai sysinfo.
..:: MRatWork (Mustafa Ramadhan Projects) ::..
-- Server/Web-integrator - Web Hosting (Kloxo-MR READY!) --

Offline hamzun

  • Valuable Member
  • *
  • Posts: 56
  • Karma: +0/-0
    • View Profile
    • Game Android Cheats
Re: Mysql tidak dapat di instal
« Reply #10 on: 2016-06-18, 18:26:30 »
hasil penggunaan memory berkurang
tp waktu di restar error pa ga masalah pak
Code: [Select]
[root@ns3 ~]# sh /script/restart-mysql -y

Warning: skipping '!includedir /etc/my.cnf.d' directive as maximum includerecursion level was reached in file /etc/my.cnf.d/my.cnf at line 10
Warning: skipping '!includedir /etc/my.cnf.d' directive as maximum includerecursion level was reached in file /etc/my.cnf.d/my.cnf at line 10
Shutting down MySQL.. SUCCESS!
Warning: skipping '!includedir /etc/my.cnf.d' directive as maximum includerecursion level was reached in file /etc/my.cnf.d/my.cnf at line 10
Starting MySQL. ERROR!
-------------------------------------------------------------------


Offline hamzun

  • Valuable Member
  • *
  • Posts: 56
  • Karma: +0/-0
    • View Profile
    • Game Android Cheats
Re: Mysql tidak dapat di instal
« Reply #11 on: 2016-06-18, 18:33:51 »
jd tidak bisa membuka cpanel pak
login sucsses tp halaman cpnanal tdk terbuka
dan blog pun tdk bisa diakses "Error establishing a database connection"
« Last Edit: 2016-06-18, 18:47:34 by hamzun »

Offline MRatWork

  • Administrator
  • The Elite
  • *****
  • Posts: 15,381
  • Karma: +112/-9
  • Gender: Male
    • View Profile
    • MRatWork Forum
Re: Mysql tidak dapat di instal
« Reply #12 on: 2016-06-18, 18:58:06 »
Wah. Coba perlihatkan hasil 'cat /etc/my.cnf.d/my.cnf
..:: MRatWork (Mustafa Ramadhan Projects) ::..
-- Server/Web-integrator - Web Hosting (Kloxo-MR READY!) --

Offline hamzun

  • Valuable Member
  • *
  • Posts: 56
  • Karma: +0/-0
    • View Profile
    • Game Android Cheats
Re: Mysql tidak dapat di instal
« Reply #13 on: 2016-06-18, 19:02:39 »
Code: [Select]
[root@ns3 ~]# cat /etc/my.cnf.d/my.cnf
#
# This group is read both both by the client and the server
# use it for options that affect everything
#
[client-server]

#
# include all files from the config directory
#
!includedir /etc/my.cnf.d







[root@ns3 ~]#

Offline MRatWork

  • Administrator
  • The Elite
  • *****
  • Posts: 15,381
  • Karma: +112/-9
  • Gender: Male
    • View Profile
    • MRatWork Forum
Re: Mysql tidak dapat di instal
« Reply #14 on: 2016-06-18, 19:07:21 »
Hilangkan skip-innodb dan kemudian restart lagi mysql. Convert database anda dari innodb ke myisam pakai 'sh /script/mysql-convert --engine=myisam'.
..:: MRatWork (Mustafa Ramadhan Projects) ::..
-- Server/Web-integrator - Web Hosting (Kloxo-MR READY!) --

 


Top 4 Global Search Engines:    Google    Bing    Baidu    Yahoo

Page created in 0.041 seconds with 17 queries.

web stats analysis
 
Mirror created by MasterkinG32.CoM