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-03-29, 15:38:51

Show Posts

This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.


Messages - velf

Pages: [1] 2
1
Hi please i really help to fix my vps. Problem such as

- web server is down
- mysql/mariadb can not work
- mail service

Chronology
1. At first everything run well until i made yum update and reboot server
2. After reboot server http webserver is down, i fix this after reading some forum post it seems problem with apache2 and apache 2.4
3. After webserver is working, but i still saw my website still not running
4. but hiawata is down, and i can not login to kloxo panel
5. I try to run 'sh cleanup' and 'sh upcp -y'
5. and everything start from here.
6. after all my MariaDb database always crash, and some critical application can not installed


Here is my sysinfo

Code: [Select]

A. Control Panel:               
   - Kloxo-MR: 7.0.0.c-2019070501
   - Web: hiawatha-10.9.0-f.2.mr.el6.x86_64
   - PHP: php56s - 5.6.40-1.ius.el6 (fpm mode)
B. Plateform:
   - OS: CentOS release 6.10 (Final) x86_64
   - Hostname: xxxx.com
C. Services:
   1. MySQL: MariaDB-server-10.2.31-1.el6.x86_64
   2. PHP:
      - Installed:
        - Branch: php71u-cli-7.1.33-1.el6.ius.x86_64
        - Multiple:
          * php52m - 5.2.17-102.mr.el6
          * php53m - 5.3.29-1.ius.centos6
          * php54m - 5.4.45-1.ius.centos6
          * php55m - 5.5.38-1.ius.centos6
          * php56m - 5.6.30-1.ius.el6
          * php70m - 7.0.30-1.ius.centos6
          * php71m - 7.1.17-1.ius.centos6
      - Used: --PHP Branch--
      - Multiple: enable
   3. Web Used: apache
     - Hiawatha: hiawatha-10.9.0-f.2.mr.el6.x86_64
     - Lighttpd: --uninstalled--
     - Nginx: --uninstalled--
     - Apache: --uninstalled--
       - PHP Type: php-fpm_event (default)
       - Secondary PHP: on
   4. WebCache: none
     - ATS: --uninstalled--
     - Squid: --uninstalled--
     - Varnish: --uninstalled--
   5. Dns: bind
     - Bind: --uninstalled--
     - DJBDns: --uninstalled--
     - NSD: --uninstalled--
     - PowerDNS: --uninstalled--
     - Yadifa: --uninstalled--
   6. Mail: --uninstalled--
      - pop3/imap4: none
      - smtp: none
      - spam: bogofilter-1.2.4-1.el6.x86_64
   7. FTP: pure-ftpd
      - pure-ftpd: pure-ftpd-1.0.49-1.mr.el6.x86_64
   8. Stats: awstats
      - awstats: kloxomr-stats-awstats-7.7-1.mr.noarch
D. Memory:
             total       used       free     shared    buffers     cached
Mem:         18432       2888      15543          5          0       2504
-/+ buffers/cache:        383      18048
Swap:            0          0          0
E. Disk Space:
Filesystem      Size  Used Avail Use% Mounted on
/dev/simfs       90G   68G   23G  76% /


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

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



If i ran 'sh upcp -y' i still got some problems, and here is log from terminal

Code: [Select]

Fix services
- Fix dns services
- Fix webcache services
- Fix ssl services
- Fix php services
- Fix web services
- Fix mail-all services
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
Enter password: /script/setup-roundcube: line 30: 21674 Terminated              mysql -f -u root -p"${rootpass}" < ${path}/SQL/mysql.initial.sql > /dev/null 2>&1
Enter password: /script/setup-roundcube: line 68: 21705 Terminated              mysql -u root -p"${rootpass}" -e "${SQL}" > /dev/null 2>&1
Enter password: /script/setup-roundcube: line 72: 22302 Terminated              mysql -f -u root -p"${rootpass}" < ${x} > /dev/null 2>&1


Please check complete log about 'sh upcp -y' at https://pastebin.com/pyDYtnLy

It seems problem with MariaDb in kloxo, and if i run service mysql restart it wont start.
Error in terminal

Code: [Select]

[root@yubster ~]# service mysql restart
MariaDB server PID file could not be found!                [FAILED]
Starting MariaDB.200211 03:04:32 mysqld_safe Logging to '/var/lib/mysql/yubster.com.err'.
200211 03:04:32 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
/etc/init.d/mysql: line 264: kill: (23091) - No such process
                                                           [FAILED]
Failed to restart server.                                  [FAILED]


and here is log from mysql

Code: [Select]
2020-02-11  3:04:32 140470652475360 [Note] Plugin 'InnoDB' is disabled.
2020-02-11  3:04:32 140470652475360 [Note] Plugin 'FEEDBACK' is disabled.
2020-02-11  3:04:32 140470652475360 [ERROR] Could not open mysql.plugin table. Some plugins may be not loaded
2020-02-11  3:04:32 140470652475360 [Note] Recovering after a crash using mysql-bin
2020-02-11  3:04:32 140470652475360 [Note] Starting crash recovery...
2020-02-11  3:04:32 140470652475360 [Note] Crash recovery finished.
2020-02-11  3:04:32 140470236649216 [Warning] Failed to load slave replication state from table mysql.gtid_slave_pos: 1286: Unknown storage engine 'InnoDB'
2020-02-11  3:04:32 140470652475360 [ERROR] Can't open and lock privilege tables: Unknown storage engine 'InnoDB'
2020-02-11  3:04:32 140470652475360 [Note] Server socket created on IP: '::'.
2020-02-11  3:04:32 140470652475360 [ERROR] Fatal error: Can't open and lock privilege tables: Unknown storage engine 'InnoDB'
2020-02-11  3:06:30 139896682899424 [Note] Plugin 'InnoDB' is disabled.
2020-02-11  3:06:30 139896682899424 [Note] Plugin 'FEEDBACK' is disabled.
2020-02-11  3:06:30 139896682899424 [ERROR] Could not open mysql.plugin table. Some plugins may be not loaded
2020-02-11  3:06:30 139896682899424 [Note] Recovering after a crash using mysql-bin
2020-02-11  3:06:30 139896682899424 [Note] Starting crash recovery...
2020-02-11  3:06:30 139896682899424 [Note] Crash recovery finished.
2020-02-11  3:06:30 139896265717504 [Warning] Failed to load slave replication state from table mysql.gtid_slave_pos: 1286: Unknown storage engine 'InnoDB'
2020-02-11  3:06:30 139896682899424 [ERROR] Can't open and lock privilege tables: Unknown storage engine 'InnoDB'
2020-02-11  3:06:30 139896682899424 [Note] Server socket created on IP: '::'.
2020-02-11  3:06:30 139896682899424 [ERROR] Fatal error: Can't open and lock privilege tables: Unknown storage engine 'InnoDB'


Please help to solve this problem

2
Indonesia Users / ioncube loader
« on: 2018-12-12, 19:44:50 »
Dear teman-teman, apa ada yg pernah install Ioncube loader dan compatible dgn kloxo-mr?? saya baca2 installnya mudah hanya tinggal yum
Code: [Select]
install php53u-ioncube*, artikel tsb di tulis thn 2015. pertanyaan saya

1. apa cara tsb masih berlaku?
2. bagaimana dgn yg php7 or yang lainnya? krn ada beberapa web saya yg menggunakan beda versi php, contoh 2 web pakai php7, 3 web pakai php 5.3


mohon infonya, trims

3
Indonesia Users / Re: [ASK] Cara memperbarui SSL letsencrypt
« on: 2016-12-13, 20:07:32 »
Semestinya pada update terakhir sudah otomatis ter-renew.

Periksa saja tanggal expire ssl anda.

Saya menggunakan kloxo 7.0.0.b-2016121201 . Kalau belum bisa perpanjang otomatis apa caranya sperti yg saya bilang di atas pak?

4
Indonesia Users / [ASK] Cara memperbarui SSL letsencrypt
« on: 2016-12-13, 09:25:14 »
Kawan-kawan saya mau tanya bagaimana cara renew sertifikat SSL Letsencrypt yg sudah expired, apa cukup dengan menghapus SSL sebelumnya lalu membuat ulang sertifikatnya? Mohon infonya

5
Indonesia Users / [ASK] cara bikin cronjob di kloxo mr 7
« on: 2016-10-08, 03:08:16 »
Saya mau tanya cara bikin cronjob di kloxo mr 7, soalnya saya liat kok di panelnya ngga ada cron job ya?

ini sysinfo saya

Quote
A. Control Panel:               
   - Kloxo-MR: 7.0.0.b-2016100303
   - 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: yubster.com
C. Services:
   1. MySQL: MariaDB-server-10.0.27-1.el6.x86_64
   2. PHP:
      - Installed:
        - Branch: php56u-cli-5.6.26-1.ius.el6.x86_64
        - Multiple:
          * php52m-5.2.17-102.mr.el6
          * php53m-5.3.29-1.ius.el6
          * php54m-5.4.45-1.ius.el6
          * php55m-5.5.38-1.ius.el6
          * php56m-5.6.26-1.ius.el6
          * php70m-7.0.11-1.w6
      - Used: php56m-fpm
      - Multiple: disable
   3. Web Used: nginxproxy
     - Hiawatha: hiawatha-10.3.0-f.1.mr.el6.x86_64
     - Lighttpd: lighttpd-1.4.41-1.el6.x86_64
     - Nginx: nginx-1.11.4-1.el6.ngx.x86_64
     - Apache: httpd-2.2.31-1.mr.el6.x86_64
       - PHP Type: php-fpm_event
       - Secondary PHP: off
   4. WebCache: none
     - ATS: --uninstalled--
     - Squid: --uninstalled--
     - Varnish: --uninstalled--
   5. Dns: bind
     - Bind: bind-9.9.7-1.mr.el6.x86_64
     - DJBDns: --uninstalled--
     - NSD: --uninstalled--
     - PowerDNS: --uninstalled--
     - Yadifa: --uninstalled--
   6. Mail: qmail-toaster-1.03-1.3.55.mr.el6.x86_64
      - pop3/imap4: dovecot-toaster-2.2.24-1.mr.el6.x86_64
      - smtp: qmail-toaster-1.03-1.3.55.mr.el6.x86_64
      - spam: bogofilter-1.2.4-1.el6.x86_64
   7. Stats: awstats



6
Indonesia Users / Re: SSL Website whitepage
« on: 2016-09-26, 09:39:53 »
Biasanya tampilan 'whitepage' karena error report/display di-disable dimana seharusnya akan ditampilkan error (dari php misalnya).

Coba saja telurusi apa sebabnya melalui 'log manager' (terutama untuk 'php' dan 'php-fpm').

Kalo melihat di php error, banyak sekali warning karena tidak bisa meload module di /opt/php54s apa karena faktor ini pak makanya jadi whitepage.

7
Indonesia Users / Re: SSL Website whitepage
« on: 2016-09-26, 08:55:25 »
Problem whitepagenya masih terjadi lagi. kemungkinan ini bukan dari force httpnya. Saya pakai PHP 56u di PHP Branch nya, karena script saya tidak jalan di bawah php56u. ada masukan lain dari teman2 ?

8
Indonesia Users / Re: SSL Website whitepage
« on: 2016-09-25, 16:51:21 »
Jika sudah pakai letsencrypt (atau ssl lain yang sudah authorize) anda tidak perlu force ke ssl. Malah bisa jadi jika di-force akan menimbulkan masalah. Browser akan otomatis redirect ke https karena ada 'isyarat' dari header agar redirect ke https.

Terima kasih pak, untuk saat ini saya copot force httpsnya. saya infokan lagi jika masih berlanjut masalahnya.

9
Indonesia Users / SSL Website whitepage
« on: 2016-09-25, 11:55:14 »
Saya menggunakan kloxo 7 dan di domain saya, saya menggunakan SSL LetEncrypt dan force to HTTPS. Terkadang webnya jadi white page. kira2 ada yang pernah mengalami hal yang nama nda ya??

berikut ini sysinfo saya
Quote
A. Control Panel:
   - Kloxo-MR: 7.0.0.b-2016092501
   - 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: yubster.com
C. Services:
   1. MySQL: MariaDB-server-10.0.27-1.el6.x86_64
   2. PHP:
      - Installed:
        - Branch: php56u-cli-5.6.26-1.ius.el6.x86_64
        - Multiple:
          * php52m-5.2.17-102.mr.el6
          * php53m-5.3.29-1.ius.el6
          * php54m-5.4.45-1.ius.el6
          * php55m-5.5.38-1.ius.el6
          * php56m-5.6.26-1.ius.el6
          * php70m-7.0.11-1.w6
      - Used: --PHP Branch--
      - Multiple: disable
   3. Web Used: nginxproxy
     - Hiawatha: hiawatha-10.3.0-f.1.mr.el6.x86_64
     - Lighttpd: lighttpd-1.4.41-1.el6.x86_64
     - Nginx: nginx-1.11.4-1.el6.ngx.x86_64
     - Apache: httpd-2.2.31-1.mr.el6.x86_64
       - PHP Type: php-fpm_event
       - Secondary PHP: off
   4. WebCache: none
     - ATS: --uninstalled--
     - Squid: --uninstalled--
     - Varnish: --uninstalled--
   5. Dns: bind
     - Bind: bind-9.9.7-1.mr.el6.x86_64
     - DJBDns: --uninstalled--
     - NSD: --uninstalled--
     - PowerDNS: --uninstalled--
     - Yadifa: --uninstalled--
   6. Mail: qmail-toaster-1.03-1.3.55.mr.el6.x86_64
      - pop3/imap4: dovecot-toaster-2.2.24-1.mr.el6.x86_64
      - smtp: qmail-toaster-1.03-1.3.55.mr.el6.x86_64
      - spam: bogofilter-1.2.4-1.el6.x86_64
   7. Stats: awstats

kalo saya panggil web saya dari lynx terminal ini hasilnya

Quote
Looking up hafana.com first
Looking up hafana.com
Making HTTP connection to hafana.com
Sending HTTP request.
HTTP request sent; waiting for response.
HTTP/1.1 301 Moved Permanently
Data transfer complete
HTTP/1.1 301 Moved Permanently
Using https://hafana.com/
Looking up hafana.com
Making HTTPS connection to hafana.com
Retrying connection without TLS.
Looking up hafana.com
Making HTTPS connection to hafana.com
Alert!: Unable to make secure connection to remote host.

lynx: Can't access startfile http://hafana.com/

Biasanya ini bisa normal lagi ketika saya melakukan fixall dan restart-all.


mohon masukannya

10
Kloxo-MR Technical Helps / Re: Let's Encrypt
« on: 2016-09-18, 15:15:23 »
Hello sir mr, after i installed letsencrypt in my domain.com and then i try to open domain.com but it said "Unable to connect" what's wrong with this? I also install on another domain and it still same.

pls help
Inform here your 'sh /script/sysinfo'.

The problem is in varnish, i used ssl with varnish, after i remove varnish it's running smooth. Is it possible to use SSL with Cache server like varnish or trafficserver?

11
Kloxo-MR Technical Helps / Re: Let's Encrypt
« on: 2016-09-18, 14:35:15 »
Hello sir mr, after i installed letsencrypt in my hafana.com and then i try to open hafana.com but it said "Unable to connect" what's wrong with this? I also install on another domain digitalasset.id and it still same.

pls help

12
Indonesia Users / Re: [ASK] Kloxo varnish error 503
« on: 2016-08-13, 12:23:01 »
wah sama abis update dapat error seperti di atas,
Code: [Select]

*** Process for NGINX service ***
  - Process: restart
Stopping nginx:                                            [FAILED]
Starting nginx: nginx: [emerg] "server" directive is not allowed here in /opt/configs/nginx/conf/domains/aplikasipersuratan.com.conf:77
                                                           [FAILED]

saya reboot masih sama ndak ilang error nya,  :(
mungkin mimin bisa bantu

itu ditambahkan '}' tanpa tanda kutip sebelum line 77 gan, punya ane sudah works.  cuma masalahnya kalo filenya ada banyak pegel  ::)

13
Indonesia Users / Re: [ASK] Kloxo varnish error 503
« on: 2016-08-13, 11:13:42 »
Informasikan hasil 'sh /script/restart-all -y'.

Shutting down system logger:                               [  OK  ]
Starting system logger:                                    [  OK  ]
-------------------------------------------------------------------

Stopping httpry:                                           [  OK  ]
Starting httpry:                                           [  OK  ]
-------------------------------------------------------------------

Shutting down MySQL. SUCCESS!
Starting MySQL. SUCCESS!
-------------------------------------------------------------------

Stopping named: .                                          [  OK  ]
Starting named:                                            [  OK  ]
-------------------------------------------------------------------

Stopping Varnish Cache:                                    [  OK  ]
Starting Varnish Cache:                                    [  OK  ]
-------------------------------------------------------------------

Stopping php55m-fpm (PHP Used):                            [  OK  ]
Starting php55m-fpm (PHP Used):                            [  OK  ]
-------------------------------------------------------------------

Stopping php52m-fpm (Multiple Php):                        [  OK  ]
Stopping php53m-fpm (Multiple Php):                        [  OK  ]
Stopping php54m-fpm (Multiple Php):                        [  OK  ]
Stopping php55m-fpm (Multiple Php):                        [  OK  ]
Stopping php56m-fpm (Multiple Php):                        [  OK  ]

Starting php52m-fpm (Multiple Php):                        [  OK  ]
Starting php53m-fpm (Multiple Php):                        [  OK  ]
Starting php54m-fpm (Multiple Php):                        [  OK  ]
Starting php55m-fpm (Multiple Php):                        [  OK  ]
Starting php56m-fpm (Multiple Php):                        [  OK  ]
-------------------------------------------------------------------

Stopping spawn-fcgi:                                       [FAILED]
Starting spawn-fcgi:                                       [FAILED]
-------------------------------------------------------------------

nginx: [emerg] "server" directive is not allowed here in /opt/configs/nginx/conf/domains/alakadarnya.net.conf:77
nginx: configuration file /etc/nginx/nginx.conf test failed
-------------------------------------------------------------------

Stopping httpd:                                            [  OK  ]
Starting httpd:                                            [  OK  ]
-------------------------------------------------------------------


*** Process for QMAIL service ***
Stopping qmail-toaster: svscan qmail logging.
qmail-send: no process killed
Starting qmail-toaster: svscan.
-------------------------------------------------------------------

- For help, type '/script/restart-mail [--help|-h]'
-------------------------------------------------------------------

Stopping pure-ftpd:                                        [  OK  ]
Starting pure-ftpd:                                        [  OK  ]
-------------------------------------------------------------------

Stopping kloxo-phpcgi:                                     [  OK  ]
Starting kloxo-phpcgi ('php54s' in 'fpm' mode):            [  OK  ]
Stopping kloxo-hiawatha:                                   [  OK  ]
Starting kloxo-hiawatha:                                   [  OK  ]
-------------------------------------------------------------------


apa solusinya sama seperti thread ini pak https://forum.mratwork.com/indonesia-users/nginx-nginx-proxy-error-file-conf/

sebelumnya meskipun ada error sprti itu dia ttep jalan.

14
Indonesia Users / Re: [ASK] Kloxo varnish error 503
« on: 2016-08-13, 10:30:00 »
klo configurasi panelnya
Nginx proxy - yes
Cache       - none
hasilnya

Dari cloudflare Error 521 - webserver down

15
Indonesia Users / [ASK] Kloxo varnish error 503
« on: 2016-08-13, 10:25:57 »
Mohon bantuan rekan-rekan disini saya mengalami Varnish Error 503 Service Unavailable , ini sysinfo saya. Saya menggunakan Nginx proxy dan varnish, sebelumnya tidak pernah ada masalah dengan ini. domain hafana.com

Quote
A. Control Panel:
   - Kloxo-MR: 7.0.0.b-2016081102
   - Web: hiawatha-10.3.0-f.1.mr.el6.i686
   - PHP: php54s-5.4.45-2.w6 (fpm mode)
B. Plateform:
   - OS: CentOS release 6.8 (Final) i686
   - Hostname: yubster.com
C. Services:
   1. MySQL: MariaDB-server-10.0.26-1.el6.i686
   2. PHP:
      - Installed:
        - Branch: php54-cli-5.4.45-1.ius.el6.i686
        - Multiple:
          * php52m-5.2.17-102.mr.el6
          * php53m-5.3.29-1.ius.el6
          * php54m-5.4.45-2.w6
          * php55m-5.5.38-1.ius.el6
          * php56m-5.6.24-1.ius.el6
      - Used: php55m-fpm
      - Multiple: enable
   3. Web Used: nginxproxy
     - Hiawatha: hiawatha-10.3.0-f.1.mr.el6.i686
     - Lighttpd: lighttpd-1.4.39-3.el6.i686
     - Nginx: nginx-1.11.3-1.el6.ngx.i386
     - Apache: httpd24u-2.4.23-2.ius.el6.i686
       - PHP Type: php-fpm_event
       - Secondary PHP: on
   4. WebCache: varnish
     - ATS: --uninstalled--
     - Squid: --uninstalled--
     - Varnish: varnish-3.0.7-1.el6.i686
   5. Dns: bind
     - Bind: bind-9.9.7-1.mr.el6.i386
     - DJBDns: --uninstalled--
     - NSD: --uninstalled--
     - PowerDNS: --uninstalled--
     - Yadifa: --uninstalled--
   6. Mail: qmail-toaster-1.03-1.3.55.mr.el6.i386
      - pop3/imap4: dovecot-toaster-2.2.24-1.mr.el6.i686
      - smtp: package none-toaster is not installed
      - spam: package spamassassin is not installed
   7. Stats: awstats
D. Memory:
                total       used       free     shared    buffers     cached
   Mem:          6144       3111       3032         14          0       2638
   -/+ buffers/cache:        472       5671
   Swap:            0          0          0
E. Disk Space:
   Filesystem      Size  Used Avail Use% Mounted on
   simfs            30G   18G   13G  60% /


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

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


Error varnish cache server

Quote
Error 503 Service Unavailable

Service Unavailable
Guru Meditation:

XID: 1143971715

Varnish cache server

saya sudah coba fixweb, fix-service-list, restart server tapi masih sama.

mohon bantuannya ya.

Pages: [1] 2

Top 4 Global Search Engines:    Google    Bing    Baidu    Yahoo

Page created in 0.07 seconds with 20 queries.

web stats analysis