MRatWork Forum by Mustafa Ramadhan - Mysql tidak dapat di instal

Sponsor:
Server and Web Integrator
Link:
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:

MRatWork Forum | Please login or register. | 2017-11-07, 20:56:57

- MRatWork Forum by Mustafa Ramadhan »
- Language Specific Discussions »
- Indonesia Users »
- Mysql tidak dapat di instal

« previous next »

- Print

Pages: [1] 2 Go Down

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

0 Members and 1 Guest are viewing this topic.

#### hamzun

- Valuable Member
- Posts: 56
- Karma: +0/-0

##### 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

Logged

#### MRatWork

- Administrator
- The Elite
- Posts: 15,381
- Karma: +112/-9
- Gender:

##### Re: Mysql tidak dapat di instal

« Reply #1 on: 2016-06-18, 17:05:31 »
Infokan 'yum list installed mysql* MariaDB*'.
Logged
..:: MRatWork (Mustafa Ramadhan Projects) ::..
-- Server/Web-integrator - Web Hosting (Kloxo-MR READY!) --

#### hamzun

- Valuable Member
- Posts: 56
- Karma: +0/-0

##### 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 ~]#

Logged

#### MRatWork

- Administrator
- The Elite
- Posts: 15,381
- Karma: +112/-9
- Gender:

##### Re: Mysql tidak dapat di instal

« Reply #3 on: 2016-06-18, 17:18:03 »
Wah anda lupa kalau MariaDB juga pakai tanda *.
Logged
..:: MRatWork (Mustafa Ramadhan Projects) ::..
-- Server/Web-integrator - Web Hosting (Kloxo-MR READY!) --

#### hamzun

- Valuable Member
- Posts: 56
- Karma: +0/-0

##### 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 ~]#

Logged

#### MRatWork

- Administrator
- The Elite
- Posts: 15,381
- Karma: +112/-9
- Gender:

##### 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'.
Logged
..:: MRatWork (Mustafa Ramadhan Projects) ::..
-- Server/Web-integrator - Web Hosting (Kloxo-MR READY!) --

#### hamzun

- Valuable Member
- Posts: 56
- Karma: +0/-0

##### 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% /

Logged

#### MRatWork

- Administrator
- The Elite
- Posts: 15,381
- Karma: +112/-9
- Gender:

##### 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]'.
Logged
..:: MRatWork (Mustafa Ramadhan Projects) ::..
-- Server/Web-integrator - Web Hosting (Kloxo-MR READY!) --

#### hamzun

- Valuable Member
- Posts: 56
- Karma: +0/-0

##### 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]

Logged

#### MRatWork

- Administrator
- The Elite
- Posts: 15,381
- Karma: +112/-9
- Gender:

##### 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.
Logged
..:: MRatWork (Mustafa Ramadhan Projects) ::..
-- Server/Web-integrator - Web Hosting (Kloxo-MR READY!) --

#### hamzun

- Valuable Member
- Posts: 56
- Karma: +0/-0

##### 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!
    -------------------------------------------------------------------

Logged

#### hamzun

- Valuable Member
- Posts: 56
- Karma: +0/-0

##### 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 »
Logged

#### MRatWork

- Administrator
- The Elite
- Posts: 15,381
- Karma: +112/-9
- Gender:

##### 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
Logged
..:: MRatWork (Mustafa Ramadhan Projects) ::..
-- Server/Web-integrator - Web Hosting (Kloxo-MR READY!) --

#### hamzun

- Valuable Member
- Posts: 56
- Karma: +0/-0

##### 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 ~]#

Logged

#### MRatWork

- Administrator
- The Elite
- Posts: 15,381
- Karma: +112/-9
- Gender:

##### 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'.
Logged
..:: MRatWork (Mustafa Ramadhan Projects) ::..
-- Server/Web-integrator - Web Hosting (Kloxo-MR READY!) --

- Print

Pages: [1] 2 Go Up
« previous next »

- MRatWork Forum by Mustafa Ramadhan »
- Language Specific Discussions »
- Indonesia Users »
- Mysql tidak dapat di instal

Top 4 Global Search Engines: Google Bing Baidu Yahoo

- Design By SMFSimple.com
- SMF 2.0.14 | SMF © 2017, Simple Machines

Page created in 0.05 seconds with 18 queries.

Mirror created by MasterkinG32.CoM