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-28, 20:20:04

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

Pages: 1 2 [3] 4 5 ... 12
31
Kloxo-MR Technical Helps / How to monitor hardware failure
« on: 2017-04-23, 07:42:02 »
I have a dedicated server with CentOS 6.9, Hardware Raid 1, 2 SSD hard drive. How can I monitor server's hard disk before it fails? I want to get email notify before it fails, so that I can ask my datacenter to replace it. Any help?

32
Kloxo-MR Technical Helps / Re: Cron Job
« on: 2017-04-15, 15:05:22 »

33
Kloxo-MR Technical Helps / Re: Enable PHP extension
« on: 2017-04-15, 12:25:04 »
Select 'php56m' for 'php used' in 'webserver configure'.
Yes, this works and now it is ok. Thank you.

34
Kloxo-MR Technical Helps / Re: Enable PHP extension
« on: 2017-04-15, 11:37:10 »
Inform here 'sh /script/sysinfo'.

Here is the information -

Code: [Select]
[root@s1 ~]# sh /script/sysinfo
A. Control Panel:
   - Kloxo-MR: 7.0.0.c-2017041002
   - Web: hiawatha-10.5.0-f.2.mr.el6.x86_64
   - PHP: php56s-5.6.30-2.ius.centos6 (fpm mode)
B. Plateform:
   - OS: CentOS release 6.9 (Final) x86_64
   - Hostname: s1.ultracorporatepixel.com
C. Services:
   1. MySQL: MariaDB-server-10.0.30-1.el6.x86_64
   2. PHP:
      - Installed:
        - Branch: php56u-cli-5.6.30-2.ius.centos6.x86_64
        - Multiple:
          * php54m-5.4.45-1.ius.centos6
          * php55m-5.5.38-1.ius.centos6
          * php56m-5.6.30-2.ius.centos6
          * php70m-7.0.17-1.ius.centos6
      - Used: --PHP Branch--
      - Multiple: enable
   3. Web Used: apache
     - Hiawatha: hiawatha-10.5.0-f.2.mr.el6.x86_64
     - Lighttpd: lighttpd-1.4.45-1.el6.x86_64
     - Nginx: nginx-1.12.0-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.9-1.mr.el6.x86_64
     - DJBDns: djbdns-1.05-17.4.mr.el6.x86_64
     - NSD: nsd-4.1.14-1.el6.x86_64
     - PowerDNS: pdns-4.0.3-1.el6.MIND.x86_64
     - Yadifa: yadifa-2.2.3-1.mr.el6.x86_64
   6. Mail: qmail-toaster-1.03-1.3.56.mr.el6.x86_64
      - pop3/imap4: courier-imap-toaster-4.1.2-1.3.20.mr.el6.x86_64
      - smtp: qmail-toaster-1.03-1.3.56.mr.el6.x86_64
      - spam: bogofilter-1.2.4-1.el6.x86_64
   7. FTP: pure-ftpd
      - pure-ftpd: pure-ftpd-1.0.37-1.mr.el6.x86_64
   8. Stats: awstats
      - awstats: --uninstalled--
D. Memory:
             total       used       free     shared    buffers     cached
Mem:         31940       3072      28867          1        188       1835
-/+ buffers/cache:       1048      30892
Swap:        11439          0      11439
E. Disk Space:
Filesystem            Size  Used Avail Use% Mounted on
/dev/mapper/vg_s1-lv_root
                       50G  3.3G   44G   8% /


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

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

35
Kloxo-MR Technical Helps / Enable PHP extension
« on: 2017-04-15, 10:58:10 »
When installing drupal on Kloxo-mr, an error is displaying and it says that it need php extension gd and PHP mbstring extension.

How can I enable these two extensions through kloxo-mr?
Please see the attached image.

36
Kloxo-MR Technical Helps / Re: Cron Job
« on: 2017-04-14, 19:18:18 »
I am using drupal. Drupal has own cron. But its cron only run when any user visit the website. And so it slow down the website when cron run.

So, I am thinking that how to run cron on time basis?

Drupal gives me this command to run cron -

"To run cron from outside the site, go to http://ultraserver1.tk/HostingUltraso/docroot/cron.php?cron_key=f5xh-GcAKVpfSMRjMetwShMIM1FnYztI9Y8psBhBSEw"

I have added this command in Kloxo mr by simple method. Please check the attachment.

How do I confirm that cron has been run? I think cron is not running. Is my settings is correct or any more setup should I do?

37
Kloxo-MR Technical Helps / Re: Bind service not starting
« on: 2017-04-14, 17:46:53 »
Run 'sh /script/cleanup' will be fixed this issue.

Yes, this works, now Bind service started. Thank you.

Code: [Select]
[root@s1 ~]# sh /script/restart-dns

*** Process for BIND service ***
  - Process: restart
Stopping named: .                                          [  OK  ]
Starting named:                                            [  OK  ]
-------------------------------------------------------------------

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

38
Kloxo-MR Technical Helps / Bind service not starting
« on: 2017-04-14, 11:21:47 »
When I am giving this command 'sh /script/restart-dns'. Bind service never start properly. Before restarting I have given the command '/script/fix-all'.


Code: [Select]
[root@s1 ~]# sh /script/restart-dns

*** Process for BIND service ***
  - Process: restart
Stopping named:                                            [  OK  ]
Starting named:                                            [FAILED]
-------------------------------------------------------------------

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

Server information is given below -

Code: [Select]
[root@s1 ~]# sh /script/sysinfo
A. Control Panel:
   - Kloxo-MR: 7.0.0.c-2017041002
   - Web: hiawatha-10.5.0-f.2.mr.el6.x86_64
   - PHP: php56s-5.6.30-2.ius.centos6 (fpm mode)
B. Plateform:
   - OS: CentOS release 6.9 (Final) x86_64
   - Hostname: s1.ultracorporatepixel.com
C. Services:
   1. MySQL: MariaDB-server-10.0.30-1.el6.x86_64
   2. PHP:
      - Installed:
        - Branch: php56u-cli-5.6.30-2.ius.centos6.x86_64
        - Multiple:
          * php54m-5.4.45-1.ius.centos6
          * php55m-5.5.38-1.ius.centos6
          * php56m-5.6.30-2.ius.centos6
          * php70m-7.0.17-1.ius.centos6
      - Used: --PHP Branch--
      - Multiple: disable
   3. Web Used: apache
     - Hiawatha: hiawatha-10.5.0-f.2.mr.el6.x86_64
     - Lighttpd: lighttpd-1.4.45-1.el6.x86_64
     - Nginx: nginx-1.12.0-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.9-1.mr.el6.x86_64
     - DJBDns: djbdns-1.05-17.4.mr.el6.x86_64
     - NSD: nsd-4.1.14-1.el6.x86_64
     - PowerDNS: pdns-4.0.3-1.el6.MIND.x86_64
     - Yadifa: yadifa-2.2.3-1.mr.el6.x86_64
   6. Mail: qmail-toaster-1.03-1.3.56.mr.el6.x86_64
      - pop3/imap4: courier-imap-toaster-4.1.2-1.3.20.mr.el6.x86_64
      - smtp: qmail-toaster-1.03-1.3.56.mr.el6.x86_64
      - spam: bogofilter-1.2.4-1.el6.x86_64
   7. FTP: pure-ftpd
      - pure-ftpd: pure-ftpd-1.0.37-1.mr.el6.x86_64
   8. Stats: awstats
      - awstats: --uninstalled--
D. Memory:
             total       used       free     shared    buffers     cached
Mem:         31940        737      31202          0         23        184
-/+ buffers/cache:        529      31411
Swap:        11439          0      11439
E. Disk Space:
Filesystem            Size  Used Avail Use% Mounted on
/dev/mapper/vg_s1-lv_root
                       50G  2.8G   44G   6% /


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

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

Can you please help to start the Bind service?

39
Kloxo-MR Technical Helps / ASP.NET on Kloxo MR
« on: 2016-11-29, 14:51:10 »
Will ".NET, ASP.NET, .asp, .aspx" website or application run on Kloxo MR 7 on CentOS 6.7?

Which database we need to install for asp.net?

40
Kloxo-MR Technical Helps / Re: Cron Job
« on: 2016-07-17, 14:42:44 »
In 'admin > servers > localhost > Cron Tasks'.

How it is possible to run by them, who does not have access to admin ?

41
Kloxo-MR Technical Helps / Cron Job
« on: 2016-07-17, 14:13:21 »
How to setup cron job through Kloxo-Mr 7 ?

42
Project Roadmaps / Re: Uploading progress
« on: 2016-07-08, 07:23:14 »
Please investigate and request simple php code for this function.

I must spend many times to find out php code in google. It's not easy.

Check here, probably help you - http://stackoverflow.com/questions/849237/upload-progress-bar-in-php

43
Done 'high' for 'apache optimize' in 'webserver config'. But it is still happening.

Is this happening because server has only 2 GB RAM ?
Memory is enough but need optimize mysql. Usually using mysqltuner.

Install mysqltuner and run the command - 'perl mysqltuner.pl'. Below is the output -

Code: [Select]
[root@server1 ~]# perl mysqltuner.pl
 >>  MySQLTuner 1.6.13 - Major Hayden <major@mhtx.net>
 >>  Bug reports, feature requests, and downloads at http://mysqltuner.com/
 >>  Run with '--help' for additional options and output filtering
Please enter your MySQL administrative login: hoxxinxxxxx---
Please enter your MySQL administrative password:
[--] Skipped version check for MySQLTuner script
[!!] failed to execute: SHOW SLAVE STATUS\G
[!!] FAIL Execute SQL / return code: 256
[!!] failed to execute: SHOW SLAVE HOSTS
[!!] FAIL Execute SQL / return code: 256
[OK] Currently running supported MySQL version 10.0.25-MariaDB
[OK] Operating on 64-bit architecture

-------- Storage Engine Statistics -----------------------------------------------------------------
[--] Status: +ARCHIVE +Aria +BLACKHOLE +CSV +FEDERATED +InnoDB +MEMORY +MRG_MyISAM +MyISAM +PERFORMANCE                   _SCHEMA
[--] Data in InnoDB tables: 5G (Tables: 1790)
[!!] Total fragmented tables: 1

-------- Security Recommendations ------------------------------------------------------------------
[!!] failed to execute: SELECT CONCAT(user, '@', host) FROM mysql.user WHERE TRIM(USER) = '' OR USER IS NULL
[!!] FAIL Execute SQL / return code: 256
[OK] There are no anonymous accounts for any database users
[!!] failed to execute: SELECT CONCAT(user, '@', host) FROM mysql.user WHERE (password = '' OR password IS N              ULL) AND plugin NOT IN ('unix_socket', 'win_socket')
[!!] FAIL Execute SQL / return code: 256
[OK] All database users have passwords assigned
[!!] failed to execute: SELECT CONCAT(user, '@', host) FROM mysql.user WHERE CAST(password as Binary) = PASS              WORD(user) OR CAST(password as Binary) = PASSWORD(UPPER(user)) OR CAST(password as Binary) = PASSWORD(UPPER(              LEFT(User, 1)) + SUBSTRING(User, 2, LENGTH(User)))
[!!] FAIL Execute SQL / return code: 256
[!!] failed to execute: SELECT CONCAT(user, '@', host) FROM mysql.user WHERE HOST='%'
[!!] FAIL Execute SQL / return code: 256
[!!] There is no basic password file list!

-------- CVE Security Recommendations --------------------------------------------------------------
[--] Skipped due to --cvefile option undefined
[!!] failed to execute: SHOW ENGINE PERFORMANCE_SCHEMA STATUS
[!!] FAIL Execute SQL / return code: 256
[!!] failed to execute: SHOW ENGINE PERFORMANCE_SCHEMA STATUS
[!!] FAIL Execute SQL / return code: 256

-------- Performance Metrics -----------------------------------------------------------------------
[--] Up for: 16h 46m 22s (2M q [35.049 qps], 18K conn, TX: 10G, RX: 2G)
[--] Reads / Writes: 95% / 5%
[--] Binary logging is disabled
[--] Physical Memory     : 990.6M
[--] Max MySQL memory    : 836.0M
[--] Other process memory: 562.2M
[--] Total buffers: 416.0M global + 2.8M per thread (151 max threads)
[!!] failed to execute: SHOW ENGINE PERFORMANCE_SCHEMA STATUS
[!!] FAIL Execute SQL / return code: 256
[--] P_S Max memory usage: 0B
[--] Galera GCache Max memory usage: 0B
[OK] Maximum reached memory usage: 454.9M (45.92% of installed RAM)
[OK] Maximum possible memory usage: 836.0M (84.39% of installed RAM)
[!!] Overall possible memory usage with other process exceeded memory
[OK] Slow queries: 0% (25/2M)
[OK] Highest usage of available connections: 9% (14/151)
[OK] Aborted connections: 1.87%  (338/18047)
[!!] name resolution is active : a reverse name resolution is made for each new connection and can reduce performance
[!!] Query cache may be disabled by default due to mutex contention.
[OK] Sorts requiring temporary tables: 0% (0 temp sorts / 1M sorts)
[OK] No joins without indexes
[OK] Temporary tables created on disk: 6% (531 on disk / 8K total)
[!!] Table cache hit rate: 2% (399 open / 19K opened)
[OK] Open file limit used: 0% (5/20K)
[OK] Table locks acquired immediately: 99% (2M immediate / 2M locks)

-------- ThreadPool Metrics ------------------------------------------------------------------------
[--] ThreadPool stat is enabled.
[--] Thread Pool Size: 1 thread(s).
[--] Using default value is good enough for your version (10.0.25-MariaDB)

-------- Performance schema ------------------------------------------------------------------------
[--] Performance schema is enabled.
[!!] failed to execute: SHOW ENGINE PERFORMANCE_SCHEMA STATUS
[!!] FAIL Execute SQL / return code: 256
[--] Memory used by P_S: 0B
[--] Sys schema isn't installed.

-------- MyISAM Metrics ----------------------------------------------------------------------------
[!!] Key buffer used: 18.2% (24M used / 134M cache)
[!!] Cannot calculate MyISAM index size - re-run script as root user

-------- AriaDB Metrics ----------------------------------------------------------------------------
[--] AriaDB is enabled.
[OK] Aria pagecache size / total Aria indexes: 128.0M/1B
[OK] Aria pagecache hit rate: 99.7% (77K cached / 244 reads)

-------- InnoDB Metrics ----------------------------------------------------------------------------
[--] InnoDB is enabled.
[!!] InnoDB buffer pool / data size: 128.0M/5.2G
[!!] InnoDB buffer pool <= 1G and innodb_buffer_pool_instances(!=1).
[OK] InnoDB Used buffer: 87.50% (7167 used/ 8191 total)
[OK] InnoDB Read buffer efficiency: 93.07% (263036560 hits/ 282631949 total)
[OK] InnoDB Write log efficiency: 99.96% (599060211 hits/ 599304638 total)
[!!] InnoDB log waits: 0.01% (19 waits / 244427 writes)

-------- TokuDB Metrics ----------------------------------------------------------------------------
[--] TokuDB is disabled.

-------- Galera Metrics ----------------------------------------------------------------------------
[--] Galera is disabled.

-------- Replication Metrics -----------------------------------------------------------------------
[--] Galera Synchronous replication: NO
[--] No replication slave(s) for this server.
[--] This is a standalone server.

-------- Recommendations ---------------------------------------------------------------------------
General recommendations:
    Run OPTIMIZE TABLE to defragment tables for better performance
      OPTIMIZE TABLE hostingultraso1_hostingultraso.cache_form; -- can free 178 MB
    Total freed space after theses OPTIMIZE TABLE : 178 Mb
    MySQL started within last 24 hours - recommendations may be inaccurate
    Dedicated this server to your database for highest performance.
    Configure your accounts with ip or subnets only, then update your configuration with skip-name-resolve=1
    Increase table_open_cache gradually to avoid file descriptor limits
    Read this before increasing table_open_cache over 64: http://bit.ly/1mi7c4C
    Beware that open_files_limit (20480) variable
    should be greater than table_open_cache ( 400)
Variables to adjust:
    query_cache_type (=0)
    table_open_cache (> 400)
    innodb_buffer_pool_size (>= 5G) if possible.
    innodb_buffer_pool_instances (=1)
    innodb_log_buffer_size (>= 8M)
[root@server1 ~]#

44
Now when giving command 'service httpd restart'. Stopping httpd failed. Any suggestion ?

Code: [Select]
[root@server1 ~]# service httpd restart
Stopping httpd:                                            [FAILED]
Starting httpd:                                            [  OK  ]
[root@server1 ~]#

Also phpmyadmin login link is not showing in database list page. See the attached file.

Pages: 1 2 [3] 4 5 ... 12

MRatWork Affiliates:    BIGRAF(R) Inc.    House of LMAR    EFARgrafix

Page created in 0.033 seconds with 17 queries.

web stats analysis