Topics

46

Indonesia Users / Gagal Switch : djbdns: Permission denied kloxo mr

« on: 2016-09-19, 06:25:06 »

Mohon bantuannya para masta,
Awalnya saya memakai Nginxproxi, jalan berbulan2 tidak ada masalah. Tapi pas tadi saya coba reboot vps djbdns malah gagal running. Saya cek statusnya permission denied terus. Sudah saya coba reinstall djbdns tetap gagal juga.

"djbdns: Permission denied kloxo mr"

[root@server1 ~]# sh /script/sysinfo

A. Kloxo-MR: 6.5.0.f-2015072101

B. OS: CentOS release 6.6 (Final) i686

C. Apps:
   1. MySQL: mysql55-5.5.52-1.ius.el6.i686
   2. PHP: php53u-5.3.29-1.ius.el6.i686
   3. Httpd: --uninstalled--
   4. Lighttpd: --uninstalled--
   5. Nginx: nginx-1.11.4-1.el6.ngx.i386
   6. Qmail: qmail-toaster-1.03-1.3.55.mr.el6.i386
      - with: courier-imap-toaster-4.1.2-1.3.18.mr.el6.i386
   7. Dns: --uninstalled--

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

E. Memory:
                total       used       free     shared    buffers     cached
   Mem:          1514        915        598          1        189        342
   -/+ buffers/cache:        382       1131
   Swap:         3071          0       3071

[root@server1 ~]#

Mohon petunjuknya

47

Indonesia Users / Multiple PHP pada Kloxo MR

« on: 2016-07-28, 17:31:01 »

Dear masta Kloxo,

Di vps saya ada website yg hanya bisa jalan di PHP 5.3 ke bawah, sementara website lain ingin bisa menggunakan PHP 5.5 ke atas karena ada fitur yg mengharusnya PHP terbaru.

Bisakah dalam 1 VPS Kloxo jalan 2 versi php (5.3 dan 5.6) untuk kebutuhan websitenya masing-masing?

Terima kasih

48

Indonesia Users / Cara akses webmail pada IP dedicated dan Email yang selalu bouncing

« on: 2016-04-02, 02:07:58 »

DH,

Saya menambahkan 2 IP baru ke VPS saya sehingga total ada 3 IP. IP ke 2 dan 3 saya gunakan untuk SSL. Keduanya berhasil, namun saya bingung cara mengakses webmail masing-masing domain.
Saya sudah coba setting MANAGE DNS domain ke 2 dan 3 ke IP baru, tapi tetap tidak bisa akses : webmail.domain.com

permasalahan kedua, email dari VPS tidak bisa terkirim, selalu bouncing, terlihat banyak antrian di mail queue. Adakah yang salah dengan settingan saya?

A. Control Panel:
   - Kloxo-MR: 7.0.0.b-2016032701
   - Web: hiawatha-10.1.0-f.6.mr.el6.i686
   - PHP: php54s-5.4.42-1.ius.el6 (fpm mode)
B. Plateform:
   - OS: CentOS release 6.7 (Final) i686
   - Hostname: server80.xbackbone.com
C. Services:
   1. MySQL: MariaDB-server-10.0.24-1.el6.i686
   2. PHP:
      - Branch: php54-cli-5.4.45-1.ius.el6.i686
      - Used: --Use PHP Branch--
   3. Web Used: nginx
     - Hiawatha: --unused--
     - Lighttpd: --uninstalled--
     - Nginx: nginx-1.9.13-1.el6.ngx.i386
     - Httpd: --uninstalled--
       - PHP Type:
   4. WebCache: none
     - ATS: --uninstalled--
     - Squid: --uninstalled--
     - Varnish: --uninstalled--
   5. Dns: nsd
     - Bind: --uninstalled--
     - DJBDns: --uninstalled--
     - NSD: nsd-4.1.7-3.el6.i686
     - PowerDNS: --uninstalled--
     - Yadifa: --uninstalled--
   6. Mail: qmail-toaster-1.03-1.3.55.mr.el6.i386
      - pop3/imap4: courier-imap-toaster-4.1.2-1.3.18.mr.el6.i386
      - spam: bogofilter
D. Memory:
                total       used       free     shared    buffers     cached
   Mem:          1006        902        103        233         50        466
   -/+ buffers/cache:        385        620
   Swap:         1023        147        876
E. Disk Space:
   Filesystem      Size  Used Avail Use% Mounted on
   /dev/vda1        19G  6.6G   12G  37% /

Terima kasih atas bantuannya

49

Indonesia Users / IP baru tak muncul di Kloxo MR

« on: 2016-03-09, 06:21:23 »

Dear masta,

Saya menambahkan IP baru di VPS, tapi saya cek di Kloxo IP baru tersebut tidak muncul. Kenapa ya?

A. Kloxo-MR: 7.0.0.b-2015102301
   - Web: hiawatha-9.15.0-f.6.mr.el6.i686
   - PHP: php54s-5.4.42-1.ius.el6 (cgi mode)
B. Plateform:
   - OS: CentOS release 6.7 (Final) i686
   - Hostname: server80.xbackbone.com
C. Services:
   1. MySQL: MariaDB-server-10.0.21-1.el6.i686
   2. PHP:
      - Branch: php54-cli-5.4.45-1.ius.el6.i686
      - Used: --Use PHP Branch--
   3. Httpd: --uninstalled--
      - PHP Type: [unknown]
   4. Lighttpd: --uninstalled--
   5. Hiawatha: --unused--
   6. Nginx: nginx-1.9.5-1.el6.ngx.i386
   7. Cache: --uninstalled--
   8. Dns: nsd-4.1.5-1.mr.el6.i686
   9. Qmail: qmail-toaster-1.03-1.3.55.mr.el6.i386
      - with: courier-imap-toaster-4.1.2-1.3.18.mr.el6.i386
D. Memory:
                total       used       free     shared    buffers     cached
   Mem:          1006        613        392         27         49        318
   -/+ buffers/cache:        245        760
   Swap:         1023          0       1023
E. Disk Space:
   Filesystem      Size  Used Avail Use% Mounted on
   /dev/vda1        19G  5.9G   12G  34% /

Mohon pencerahannya, terima kasih

50

Indonesia Users / Cara memprotect web dengan password

« on: 2016-02-15, 00:36:21 »

Dear masta,
Vps saya pake nginx. Hanya orang tertentu yang bisa akses web. Bagaimana cara memprotect website dengan password?
Apakah menggunakan menu "protected directory" pada panel Kloxo MR? Sedang yang saya inginkan memprotect halaman depan, bukan direktorinya saja.

A. Control Panel:
   - Kloxo-MR: 7.0.0.b-2016020101
   - Web: hiawatha-10.0.0-f.6.mr.el6.i686
   - PHP: php54s-5.4.45-1.ius.el6 (cgi mode)
B. Plateform:
   - OS: CentOS release 6.7 (Final) i686
   - Hostname: server50.xbackbone.com
C. Services:
   1. MySQL: MariaDB-server-10.0.23-1.el6.i686
   2. PHP:
      - Branch: php54-cli-5.4.45-1.ius.el6.i686
      - Used: --Use PHP Branch--
   3. Httpd: --uninstalled--
      - PHP Type: [unknown]
   4. Lighttpd: --uninstalled--
   5. Hiawatha: --unused--
   6. Nginx: nginx-1.9.10-1.el6.ngx.i386
   7. Cache: --uninstalled--
   8. Dns: nsd-4.1.7-3.el6.i686
   9. Qmail: qmail-toaster-1.03-1.3.55.mr.el6.i386
      - with: courier-imap-toaster-4.1.2-1.3.18.mr.el6.i386
D. Memory:
                total       used       free     shared    buffers     cached
   Mem:           750        650        100          7         25        416
   -/+ buffers/cache:        207        542
   Swap:         1535         98       1437
E. Disk Space:
   Filesystem      Size  Used Avail Use% Mounted on
   /dev/vda1        19G  6.3G   12G  36% /

51

Indonesia Users / Cara merestore web dari filebackup yang versi MR nya berbeda

« on: 2016-02-13, 05:24:38 »

Dear all,

Saya sering gagal merestore web dari MR 6.5 ke MR 7.

sepertinya butuh trik khusus. Adakah yang mengetahui caranya?

[root@server20 ~]# sh /script/sysinfo

A. Kloxo-MR: 6.5.0.f-2014102601

B. OS: CentOS release 6.6 (Final) i686

C. Apps:
   1. MySQL: mysql55-5.5.43-1.ius.el6.i686
   2. PHP: php54-5.4.40-1.ius.el6.i686
   3. Httpd: httpd-2.2.29-2.mr.el6.i386
   4. Lighttpd: --uninstalled--
   5. Nginx: nginx-1.8.0-1.el6.ngx.i386
   6. Qmail: qmail-toaster-1.03-1.3.53.mr.el6.i386
      - with: courier-imap-toaster-4.1.2-1.3.18.mr.el6.i386
   7. Dns: djbdns-1.05-17.4.mr.el6.i386

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

E. Memory:
                total       used       free     shared    buffers     cached
   Mem:          1024        545        478         93          0        303
   -/+ buffers/cache:        241        782
   Swap:            0          0          0

Terima kasih

52

Indonesia Users / Tidak bisa terima email

« on: 2016-01-16, 12:57:20 »

Dear masta,

VPS saya tidak bisa terima email. Pesan yang diterima email pengirim sebagai berikut.
Mohon pencerahannya.

Delivery to the following recipient failed permanently:

     fans@xxxyyy.com

Technical details of permanent failure:
The recipient server did not accept our requests to connect. Learn more at https://support.google.com/mail/answer/7720

----- Original message -----

DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=gmail.com; s=20120113;
        h=mime-version:reply-to:date:message-id:subject:from:to:content-type;
        bh=6Zyjq1nSW9tPBmQ9bFJCUGeHN670sAAOFjMqUL/xKhw=;
        b=UbHGWv+IJC0uKIi8XwUfwH/+fyS4zSFDNd0nktgD0Da8jmVPbnh/ORQAl8jK+RWyFE
         /PaUTrGEBoQW0MxgAF5Ag1yGclIsLExIE2Hcgux506L7mD6ifkAhnQYlOZMetRA/N5yr
         54w0viyqNLU4QZgQPbDwwK4cY03+KTik4KrZBLJpLBR4KQOCxxnSnENyndxNmK9W7SJy
         dDcQYIgiFm70GDYWeWlxG3pUPQLnIJGGL+ZKByLJxC1YuOx1exTA3hG0w2te7DefBB1r
         AqNl1kGfnVSj6nrOtM156OHxpyQ2kw1spz0fmvthuTaSW+VQoYuo/RZ7Nrf2+nk85RrT
         AMSQ==
X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=1e100.net; s=20130820;
        h=x-gm-message-state:mime-version:reply-to:date:message-id:subject
         :from:to:content-type;
        bh=6Zyjq1nSW9tPBmQ9bFJCUGeHN670sAAOFjMqUL/xKhw=;
        b=Oahha/7ACiUtrHwelyaqgwwzCG8lsiLyhtlMBLhJgPBkyrfwW7BJiKc9iHCxS3ZOdJ
         RVaAD1ihJyCxP3cQ4xXho6JpWRDQ4vVURRgk/PPHLLM4d8CqF4YybLdZlXL2OkrQi0l4
         ZZLp7z4kkvcRhZJKC9ZmvWRn10J+H1EEoUo38/ZowU9rTmkm1m8h5AlCDajW3tORbjjt
         8P/VhMm0Y4bctpMkteh6qhbnAuslAjxXm6BLqWhiyRIwmzjfXWpdbcEKBVxAsqivNg9R
         waKvyMA9xozhaIAKtiAlw/i9AEHiytSiDd/4HyFtBqDHyA628pSdrWFTcKKn7DjWkZNl
         CmGg==
X-Gm-Message-State: ALoCoQmUupGzG7dwgWHe/0gciClZ7wo5s8Ro3FTxUrl4Ol3cdu+5sVxHbSUu8+nw35dxLeiaQqgQNgmZ3J+4fgMyU49X2VmfLA==

Sysinfo

A. Kloxo-MR: 6.5.0.f-2015072101

B. OS: CentOS release 6.6 (Final) i686

C. Apps:
   1. MySQL: mysql55-5.5.44-2.ius.el6.i686
   2. PHP: php53u-5.3.29-1.ius.el6.i686
   3. Httpd: httpd-2.2.31-1.mr.el6.i386
   4. Lighttpd: --uninstalled--
   5. Nginx: nginx-1.9.3-1.el6.ngx.i386
   6. Qmail: qmail-toaster-1.03-1.3.55.mr.el6.i386
      - with: courier-imap-toaster-4.1.2-1.3.18.mr.el6.i386
   7. Dns: djbdns-1.05-17.4.mr.el6.i386

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

E. Memory:
                total       used       free     shared    buffers     cached
   Mem:          1514       1397        116         61         81        507
   -/+ buffers/cache:        808        705
   Swap:         3071         64       3007

53

Indonesia Users / Cara Web tampil dengan mengetikkan alamat IP

« on: 2015-12-23, 23:06:01 »

Dear masta,

Saya ingin web bisa tampil hanya dengan mengetikkan alamat IP. Saya sudah unggah file web di dir /home/admin/public_html/ tapi hasilnya tetap dianggap ada kesalahan spt ini :

If you are seeing this page, it means that web has not been configured for this domain on this server.

This could be due to the following causes:

    Kloxo has not restarted the web server yet after you added the domain. Please wait for the web server to restart.
     
    The domain is pointing to the wrong Kloxo server. Ping the domain and make sure that the IP matches one of the IPaddress seen in admin home -> ipaddresses
     
    If you are seeing this page when you try to access an IP like http://192.168.1.1, then that means that the IP has not yet been mapped to a domain. Go to client home -> ipaddresses -> ipaddress home -> domain config and map an IP to a domain.
     
    Once you map an IP to a domain, then you have to make sure that the domain pings back to the same IP. Otherwise, if you try to access the domain, you will get this page. So IP -> domain.com should mean that domain.com pings to the same IP.

[root@jibas2 ~]# sh /script/sysinfo
A. Kloxo-MR: 7.0.0.b-2015122201
   - Web: hiawatha-10.0.0-f.6.mr.el6.x86_64
   - PHP: php54s-5.4.45-2.w6 (cgi mode)
B. Plateform:
   - OS: CentOS release 6.7 (Final) x86_64
   - Hostname: jibas2.xbackbone.com
C. Services:
   1. MySQL: MariaDB-server-10.0.23-1.el6.x86_64
   2. PHP:
      - Branch: php54-cli-5.4.45-1.ius.el6.x86_64
      - Used: --Use PHP Branch--
   3. Httpd: --uninstalled--
      - PHP Type: mod_php_ruid2
   4. Lighttpd: --uninstalled--
   5. Hiawatha: --unused--
   6. Nginx: nginx-1.9.9-1.el6.ngx.x86_64
   7. Cache: --uninstalled--
   8. Dns: nsd-4.1.7-1.mr.el6.x86_64
   9. Qmail: qmail-toaster-1.03-1.3.55.mr.el6.x86_64
      - with: courier-imap-toaster-4.1.2-1.3.18.mr.el6.x86_64
D. Memory:
                total       used       free     shared    buffers     cached
   Mem:          1024        475        548         76          0        225
   -/+ buffers/cache:        250        773
   Swap:         1024          0       1024
E. Disk Space:
   Filesystem      Size  Used Avail Use% Mounted on
   /dev/simfs       25G  2.3G   23G   9% /


*** Process Time: 00:00:00:01.1954 (dd:hh:mm:ss:xxxxxx) ***

* Note: run 'sh /script/sysinfo -y' if you want run 'fix-service-list' also
        (importance after Kloxo-MR update)

[root@jibas2 ~]#

Mohon bantuannya.

54

Indonesia Users / MYSQL tiba-tiba ERROR!

« on: 2015-11-03, 18:48:25 »

Dear masta, mohon bantuannya.
Mysql tiba-tiba error. Cek status hasilnya :

[root@server100 ~]# service mysql status
 ERROR! MySQL is not running, but lock file (/var/lock/subsys/mysql) exists

Jika di cleanup ada baris spt ini

- Get process
- 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")
>>> Execute driverload.php <<<

Sysinfo:

A. Kloxo-MR: 7.0.0.b-2015103001
   - Web: hiawatha-9.15.0-f.6.mr.el6.i686
   - PHP: php54s-5.4.45-1.ius.el6 (cgi mode)
B. Plateform:
   - OS: CentOS release 6.7 (Final) i686
   - Hostname: server100.xbackbone.com
C. Services:
   1. MySQL: MariaDB-server-10.0.22-1.el6.i686
   2. PHP:
      - Branch: php54-cli-5.4.45-1.ius.el6.i686
      - Used: --Use PHP Branch--
   3. Httpd: httpd-2.2.31-1.mr.el6.i386
      - PHP Type: [unknown]
   4. Lighttpd: --uninstalled--
   5. Hiawatha: --unused--
   6. Nginx: --uninstalled--
   7. Cache: --uninstalled--
   8. Dns: bind-9.9.7-1.mr.el6.i386
   9. Qmail: qmail-toaster-1.03-1.3.55.mr.el6.i386
      - with: courier-imap-toaster-4.1.2-1.3.18.mr.el6.i386
D. Memory:
                total       used       free     shared    buffers     cached
   Mem:          1024        335        688          5          0         40
   -/+ buffers/cache:        294        729
   Swap:            0          0          0
E. Disk Space:
   Filesystem      Size  Used Avail Use% Mounted on
   /dev/simfs       30G  5.2G   25G  18% /

55

Indonesia Users / Tanya cara Rebuild DNS seluruh domain

« on: 2015-10-25, 05:28:49 »

Dear masta,

Saat migrasi VPS atau pas VPS ganti IP saya biasanya merebuild domain satu per satu. Adakah cara efektif agar proses rebuild cukup dilakukan sekali saja dan otomatis semua domain DNS nya menyesuaikan dengan IP baru?

Terima kasih atas pencerahannya

56

Indonesia Users / Sudah berkali-kali diswitch "none" tapi tetap gagal run djbdns dan php-fpm

« on: 2015-10-08, 04:11:36 »

Dear masta,

Saya sudah berkali-kali switch program ke "none", kemudian pilih nginx, djbdns, dan antispam tapi selalu gagal run djbdns dan phpfpm. Jika di upcp -y akan berhenti lama di proses maridDB.

[root@server50 ~]# sh /script/sysinfo
cat: /etc/rc.d/init.d/php-fpm: No such file or directory

A. Kloxo-MR: 7.0.0.b-2015092401
   - Web: hiawatha-9.14.0-f.6.mr.el6.i386
   - PHP: php54s-5.4.45-1.ius.el6 (cgi mode)
B. Plateform:
   - OS: CentOS release 6.7 (Final) i686
   - Hostname: server50.xbackbone.com
C. Services:
   1. MySQL: --uninstalled--
   2. PHP:
      - Branch: --uninstalled--
      - Used: --Use PHP Branch--
   3. Httpd: --uninstalled--
      - PHP Type:
   4. Lighttpd: --uninstalled--
   5. Hiawatha: --unused--
   6. Nginx: nginx-1.9.5-1.el6.ngx.i386
   7. Cache: --uninstalled--
   8. Dns: djbdns-1.05-17.4.mr.el6.i386
   9. Qmail: --uninstalled--
D. Memory:
                total       used       free     shared    buffers     cached
   Mem:           750        378        371          0         58        162
   -/+ buffers/cache:        157        593
   Swap:         1535          0       1535
E. Disk Space:
   Filesystem      Size  Used Avail Use% Mounted on
   /dev/vda1        19G  6.3G   12G  37% /

Mohon bantuannya. Terima kasih

57

Indonesia Users / Cara menjalankan Antivirus

« on: 2015-09-07, 06:28:55 »

Dear master,

Satu VPS saya sering terkena virus, dan menyebar di banyak akun. Bagaimana cara menjalankan clamav yang sudah pre-installed di kloxo MR?

Spec VPS: Kloxo MR 7.0, Centos 6, Nginx, PHP 5.4.

Terima kasih atas pencerahannya

58

Indonesia Users / Cara mengetahui penyebab Mysql bekerja berat?

« on: 2015-08-02, 10:03:24 »

Dear masta,

Satu VPS saya dipakai untuk wordpress multisite. Akhir-akhir ini kenirja sangat berat. Beberapa plugin saya matikan tetap berat juga. Bagaimana cara mengetahui penyebab proses berjalan berat?

Mohon pencerahannya.

Htop terlampir.

Nginx log access:

61.240.144.64 - - [02/Aug/2015:13:13:34 +0700] "GET / HTTP/1.0" 200 3075 "-" "masscan/1.0 (https://github.com/robertdavidgraham/masscan)" "-"
111.248.114.16 - - [02/Aug/2015:13:26:59 +0700] "CONNECT vip163mx01.mxmail.netease.com:25 HTTP/1.0" 400 172 "-" "-" "-"
115.230.127.237 - - [02/Aug/2015:14:26:21 +0700] "GET http://zc.qq.com/cgi-bin/common/attr?id=260714&r=0.4268894392661096 HTTP/1.1" 200 1168 "-" "Mozilla/5.0 (compatible; MSIE 9.0; Windows NT 6.1; Trident/5.0; 360SE)" "-"
61.19.250.141 - - [02/Aug/2015:14:44:52 +0700] "GET //MyAdmin/scripts/setup.php HTTP/1.1" 404 47 "-" "-" "-"
61.19.250.141 - - [02/Aug/2015:14:44:52 +0700] "GET //phpMyAdmin/scripts/setup.php HTTP/1.1" 404 47 "-" "-" "-"
61.19.250.141 - - [02/Aug/2015:14:44:52 +0700] "GET //dbadmin/scripts/setup.php HTTP/1.1" 404 47 "-" "-" "-"
61.19.250.141 - - [02/Aug/2015:14:44:52 +0700] "GET //myadmin/scripts/setup.php HTTP/1.1" 404 47 "-" "-" "-"
61.19.250.141 - - [02/Aug/2015:14:44:52 +0700] "GET //phpmyadmin/scripts/setup.php HTTP/1.1" 404 47 "-" "-" "-"
61.19.250.141 - - [02/Aug/2015:14:44:52 +0700] "GET //pma/scripts/setup.php HTTP/1.1" 404 47 "-" "-" "-"
61.19.250.141 - - [02/Aug/2015:14:44:52 +0700] "GET /muieblackcat HTTP/1.1" 200 1168 "-" "-" "-"
61.19.250.141 - - [02/Aug/2015:14:44:52 +0700] "GET //scripts/setup.php HTTP/1.1" 404 47 "-" "-" "-"
61.19.250.141 - - [02/Aug/2015:14:44:52 +0700] "GET //mysql/scripts/setup.php HTTP/1.1" 404 47 "-" "-" "-"
61.19.250.141 - - [02/Aug/2015:14:44:52 +0700] "GET //sqladmin/scripts/setup.php HTTP/1.1" 404 47 "-" "-" "-"
61.19.250.141 - - [02/Aug/2015:14:44:52 +0700] "GET //phpadmin/scripts/setup.php HTTP/1.1" 404 47 "-" "-" "-"
61.19.250.141 - - [02/Aug/2015:14:44:52 +0700] "GET //MySqlAdmin/scripts/setup.php HTTP/1.1" 404 47 "-" "-" "-"
61.19.250.141 - - [02/Aug/2015:14:44:52 +0700] "GET //web/phpMyAdmin/scripts/setup.php HTTP/1.1" 404 47 "-" "-" "-"
61.19.250.141 - - [02/Aug/2015:14:44:52 +0700] "GET / HTTP/1.1" 200 1168 "-" "-" "-"
61.19.250.141 - - [02/Aug/2015:14:44:52 +0700] "GET / HTTP/1.1" 200 1168 "-" "-" "-"
61.19.250.141 - - [02/Aug/2015:14:44:52 +0700] "GET //mysqladmin/scripts/setup.php HTTP/1.1" 404 47 "-" "-" "-"
61.19.250.141 - - [02/Aug/2015:14:44:52 +0700] "GET //pma/scripts/setup.php HTTP/1.1" 404 47 "-" "-" "-"

Sysinfo

A. Kloxo-MR: 7.0.0.b-2015073001
   - Web: hiawatha-9.14.0-f.6.mr.el6.i386
   - PHP: php54s-5.4.41-1.ius.el6 (cgi mode)
B. Plateform:
   - OS: CentOS release 6.6 (Final) i686
   - Hostname: server30.xbackbone.com
C. Services:
   1. MySQL: MariaDB-server-10.0.20-1.el6.i686
   2. PHP:
      - Branch: php54-cli-5.4.43-1.ius.el6.i686
      - Used: --Use PHP Branch--
   3. Httpd: --uninstalled--
      - PHP Type:
   4. Lighttpd: --uninstalled--
   5. Hiawatha: --unused--
   6. Nginx: nginx-1.9.3-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.55.mr.el6.i386
      - with: courier-imap-toaster-4.1.2-1.3.18.mr.el6.i386
D. Memory:
                total       used       free     shared    buffers     cached
   Mem:          1006        940         66          0         68        403
   -/+ buffers/cache:        467        538
   Swap:            0          0          0
E. Disk Space:
   Filesystem      Size  Used Avail Use% Mounted on
   /dev/sda1        40G   27G   11G  72% /

59

Indonesia Users / MariaDB gagal import backup SQL

« on: 2015-07-29, 19:07:19 »

Dear masta,

Saya mau install jibas di VPS. Tapi saat import sql ditengah jalan berhenti dengan warning : "ERROR 1071 (42000) at line 8317: Specified key was too long; max key length is 1000 bytes."

Apakah ini terkait database yang menggunakan MariaDB? Adakah solusi mengatasi error tersebut?

Sysinfo VPS

A. Kloxo-MR: 7.0.0.b-2015072103
   - Web: hiawatha-9.13.0-f.6.mr.el6.i386
   - PHP: php54s-5.4.43-1.ius.el6 (cgi mode)
B. Plateform:
   - OS: CentOS release 6.6 (Final) i686
   - Hostname: server100.xbackbone.com
C. Services:
   1. MySQL: MariaDB-server-10.0.20-1.el6.i686
   2. PHP:
      - Branch: php54-cli-5.4.43-1.ius.el6.i686
      - Used: --Use PHP Branch--
   3. Httpd: --uninstalled--
      - PHP Type: suphp
   4. Lighttpd: --uninstalled--
   5. Hiawatha: --unused--
   6. Nginx: nginx-1.9.3-1.el6.ngx.i386
   7. Cache: --uninstalled--
   8. Dns: nsd-4.1.3-1.mr.el6.i386
   9. Qmail: qmail-toaster-1.03-1.3.55.mr.el6.i386
      - with: courier-imap-toaster-4.1.2-1.3.18.mr.el6.i386
D. Memory:
                total       used       free     shared    buffers     cached
   Mem:          1024        177        846         70          0        163
   -/+ buffers/cache:         14       1009
   Swap:            0          0          0
E. Disk Space:
   Filesystem      Size  Used Avail Use% Mounted on
   /dev/simfs       30G  2.2G   28G   8% /

60

Indonesia Users / Install Kloxo MR selalu berhenti lama di MariaDB

« on: 2015-07-28, 16:48:23 »

Mungkin sudah 5x saya lakukan installasi ulang VPS, karena proses installasi selalu berhenti lama di download MariaDB. Apakah memang filenya besar atau download dari sumbernya yang susah.
Saya sudah coba centos 6.4 dan 6.3 tetap sama hasilnya. Ganti ISP pun juga demikian. Selalu berhenti di mariaDB.

Mohon pencerahan cara problem installasi saya ini. Terima kasih.

Tahap saat proses berhenti

--> Running transaction check
---> Package MariaDB-compat.i686 0:10.0.20-1.el6 will be installed
--> Finished Dependency Resolution

Dependencies Resolved

================================================================================
 Package            Arch     Version              Repository               Size
================================================================================
Installing:
 MariaDB-server     i686     10.0.20-1.el6        mratwork-mariadb-32      44 M
 MariaDB-shared     i686     10.0.20-1.el6        mratwork-mariadb-32     1.1 M
Installing for dependencies:
 MariaDB-client     i686     10.0.20-1.el6        mratwork-mariadb-32      11 M
 MariaDB-common     i686     10.0.20-1.el6        mratwork-mariadb-32      41 k
 MariaDB-compat     i686     10.0.20-1.el6        mratwork-mariadb-32     2.6 M

Transaction Summary
================================================================================
Install       5 Package(s)

Total download size: 58 M
Installed size: 234 M
Downloading Packages: