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. 2018-07-21, 05:49:29

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

Pages: [1] 2 3 ... 7
1
Kloxo-MR Releases / Re: Error after update MRKloxo
« on: 2016-01-23, 18:53:14 »
Go to 'webserver configure' and then select 'php-fpm_event' for 'php type'.
The problem is latest version of apr. Downgrade with 'yum downgrade apr*' make httpd running well

2
Kloxo-MR Releases / Re: Error after update MRKloxo
« on: 2016-01-23, 17:35:47 »
Try 'sh /script/mysql-optimize --select=repair; sh /script/restart-all -y'. And make sure set '#skip-innodb' in /etc/my.cnf.d/server.cnf.
Okie. I'm log in  Admin control panel. How to changr php-type?

3
Kloxo-MR Releases / Re: Error after update MRKloxo
« on: 2016-01-23, 17:13:25 »
Inform here 'sh /script/restart-all -y'.
Still displaying notices Alert: Login Unsuccessful :(
I show sysinfo and see
Code: [Select]
3. Httpd: httpd-2.2.31-1.mr.el6.x86_64
      - PHP Type: [unknown]
Maybe PHP Type errors? how to fix it?

4
Kloxo-MR Releases / Re: Error after update MRKloxo
« on: 2016-01-23, 17:03:26 »
Try reset mysql root password with 'sh /script/reset-mysql-root-password YOURPASSWORD'.
After run 'sh /script/reset-mysql-root-password YOURPASSWORD'. And login Kloxo-MR is show Alert: Login Unsuccessful :(

And server don't run php file :(

5
Kloxo-MR Releases / Re: Error after update MRKloxo
« on: 2016-01-23, 16:51:24 »
For 'supervise: fatal: unable to start log/run: file does not exist' issue, try:
Code: [Select]
rm -f /var/qmail/supervise/clamav; sh /script/restart-mail -y
Thanks!
But login to Kloxo-MR (admin control panel) show Alert: Login Unsuccessful :(
And webpage is page space

6
Kloxo-MR Releases / Re: Error after update MRKloxo
« on: 2016-01-23, 16:33:38 »


Code: [Select]
[root@bns ~]# sh /script/sysinfo
A. Control Panel:
   - Kloxo-MR: 7.0.0.b-2016012103
   - 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: bns.bbbh.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
      - Multiple:
        * php52m-5.2.17-102.mr.el6
        * php53m-5.3.29-1.ius.el6
        * php54m-5.4.41-1.ius.el6
        * php55m-5.5.25-1.ius.el6
        * php56m-5.6.9-1.ius.el6
      - Used: --Use PHP Branch--
   3. Httpd: httpd-2.2.31-1.mr.el6.x86_64
      - PHP Type: [unknown]
   4. Lighttpd: --uninstalled--
   5. Hiawatha: --unused--
   6. Nginx: --uninstalled--
   7. Cache: --uninstalled--
   8. Dns: bind-9.9.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:          7857        670       7186          0         45        292
   -/+ buffers/cache:        332       7524
   Swap:         7999          0       7999
E. Disk Space:
   Filesystem            Size  Used Avail Use% Mounted on
   /dev/mapper/vg_bbbh-lv_root
                          50G   36G   11G  77% /



7
Kloxo-MR Releases / Error after update MRKloxo
« on: 2016-01-23, 16:26:44 »
After update MRKloxo (via sh sh /script/upcp -y ).
Serrver is error:
1. Kloxo-MR login Alert: Login Unsuccessful
2. Run sh /script/restart-all show error:
Code: [Select]
supervise: fatal: unable to start clamd/run: file does not exist
supervise: fatal: unable to start log/run: file does not exist
supervise: fatal: unable to start clamd/run: file does not exist
supervise: fatal: unable to start log/run: file does not exist
supervise: fatal: unable to start clamd/run: file does not exist
supervise: fatal: unable to start log/run: file does not exist
supervise: fatal: unable to start clamd/run: file does not exist
supervise: fatal: unable to start log/run: file does not exist
supervise: fatal: unable to start clamd/run: file does not exist
supervise: fatal: unable to start log/run: file does not exist
supervise: fatal: unable to start clamd/run: file does not exist
supervise: fatal: unable to start log/run: file does not exist
supervise: fatal: unable to start clamd/run: file does not exist
supervise: fatal: unable to start log/run: file does not exist
supervise: fatal: unable to start clamd/run: file does not exist
..........................................
3. Access website (use code xenforo) is page space ( http://bachngocsach.com/forum )

Please help me.

8
Kloxo-MR Technical Helps / Re: How to update phpMyAdmin?
« on: 2016-01-16, 08:28:09 »
Thanks! This is ok. :)

9
Kloxo-MR Technical Helps / How to update phpMyAdmin?
« on: 2016-01-16, 08:15:09 »
A newer version of phpMyAdmin is available and you should consider upgrading. The newest version is 4.4.15.2, released on 2015-12-25. How to udate it?
My sys:
Code: [Select]
[root@bns /]# sh /script/sysinfo
A. Kloxo-MR: 7.0.0.b-2016011401
   - Web: hiawatha-10.0.0-f.6.mr.el6.x86_64
   - PHP: php54s-5.4.41-1.ius.el6 (fpm mode)
B. Plateform:
   - OS: CentOS release 6.7 (Final) x86_64
   - Hostname: bns.bnscbd.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
      - Multiple:
        * php52m-5.2.17-102.mr.el6
        * php53m-5.3.29-1.ius.el6
        * php54m-5.4.41-1.ius.el6
        * php55m-5.5.25-1.ius.el6
        * php56m-5.6.9-1.ius.el6
      - Used: --Use PHP Branch--
   3. Httpd: httpd-2.2.31-1.mr.el6.x86_64
      - PHP Type: php-fpm_event
   4. Lighttpd: --uninstalled--
   5. Hiawatha: --unused--
   6. Nginx: --uninstalled--
   7. Cache: --uninstalled--
   8. Dns: bind-9.9.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


10
Your / (root) directory is full. Not able to move to other directory.
But /home directory is avail 429GB

Code: [Select]
[root@bns ~]# df -h
Filesystem            Size  Used Avail Use% Mounted on
/dev/mapper/vg_bachngocsach-lv_root
                       50G   49G     100% /
tmpfs                 3.9G     0  3.9G   0% /dev/shm
/dev/sda1             477M   73M  379M  17% /boot
/dev/mapper/vg_bachngocsach-lv_home
                      492G   39G  429G   9% /home

Move mysql database to other path?

11
Add 'innodb_force_recovery = 1' in /etc/my.cnf.d/server.cnf under '[mysqld]' and then restart mysql with 'sh /script/restart-mysql -y'.
MySQL stops due to full disk filesystem.
Currently my SQL subdirectory of /var/lib/mysql/. How long do I move it to the directory /home/DB/ ?
Code: [Select]
Filesystem            Size  Used Avail Use% Mounted on
   /dev/mapper/vg_bachngoddfh-lv_root
                          50G   47G     0 100% /



12
MySQL is Stop :(
Log file :(
160106 17:43:14 [Note] InnoDB: Initializing buffer pool, size = 128.0M
160106 17:43:14 [Note] InnoDB: Completed initialization of buffer pool
160106 17:43:14 [Note] InnoDB: Highest supported file format is Barracuda.
160106 17:43:14 [Note] InnoDB: The log sequence numbers 159528416482 and 159528416482 in ibdata files do not match the log sequence number 162756977297 in the ib_logfiles!
160106 17:43:14 [Note] InnoDB: Database was not shutdown normally!
160106 17:43:14 [Note] InnoDB: Starting crash recovery.
160106 17:43:14 [Note] InnoDB: Reading tablespace information from the .ibd files...
160106 17:43:14 [Note] InnoDB: Restoring possible half-written data pages
160106 17:43:14 [Note] InnoDB: from the doublewrite buffer...
InnoDB: 1 transaction(s) which must be rolled back or cleaned up
InnoDB: in total 1 row operations to undo
InnoDB: Trx id counter is 21706496
160106 17:43:14 [Note] InnoDB: 128 rollback segment(s) are active.
InnoDB: Starting in background the rollback of uncommitted transactions
2016-01-06 17:43:14 7f16943ff700  InnoDB: Rolling back trx with id 21706000, 1 rows to undo
160106 17:43:14 [Note] InnoDB: Waiting for purge to start
2016-01-06 17:43:14 7f16943ff700 InnoDB: Error: Write to file ./bachngoc_bnsdru/cache_menu.ibd failed at offset 16840130560.
InnoDB: 1048576 bytes should have been written, only 307200 were written.
InnoDB: Operating system error number 28.
InnoDB: Check that your OS and file system support files of this size.
InnoDB: Check also that the disk is not full or a disk quota exceeded.
InnoDB: Error number 28 means 'No space left on device'.
InnoDB: Some operating system error numbers are described at
InnoDB: http://dev.mysql.com/doc/refman/5.6/en/operating-system-error-codes.html
FAIL160106 17:43:14 [Note] InnoDB:  Percona XtraDB (http://www.percona.com) 5.6.24-72.2 started; log sequence number 162756977297
160106 17:43:14 [Note] Plugin 'FEEDBACK' is disabled.
160106 17:43:14 [Note] Server socket created on IP: '::'.
160106 17:43:14 [ERROR] mysqld: Error writing file '/var/lib/mysql/bns.bachngocsach.com.pid' (Errcode: 28 "No space left on device")
160106 17:43:14 [ERROR] Can't start server: can't create PID file: No space left on device
160106 17:43:14 mysqld_safe Number of processes running now: 0
160106 17:43:14 mysqld_safe mysqld restarted
160106 17:43:14 [Note] /usr/sbin/mysqld (mysqld 10.0.20-MariaDB) starting as process 28619 ...
160106 17:43:14 [Note] InnoDB: Using mutexes to ref count buffer pool pages
160106 17:43:14 [Note] InnoDB: The InnoDB memory heap is disabled
160106 17:43:14 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
160106 17:43:14 [Note] InnoDB: Memory barrier is not used
160106 17:43:14 [Note] InnoDB: Compressed tables use zlib 1.2.3
160106 17:43:14 [Note] InnoDB: Using CPU crc32 instructions
160106 17:43:14 [Note] InnoDB: Initializing buffer pool, size = 128.0M
160106 17:43:14 [Note] InnoDB: Completed initialization of buffer pool
160106 17:43:14 [Note] InnoDB: Highest supported file format is Barracuda.
160106 17:43:14 [Note] InnoDB: The log sequence numbers 159528416482 and 159528416482 in ibdata files do not match the log sequence number 162756977297 in the ib_logfiles!
160106 17:43:14 [Note] InnoDB: Database was not shutdown normally!
160106 17:43:14 [Note] InnoDB: Starting crash recovery.
160106 17:43:14 [Note] InnoDB: Reading tablespace information from the .ibd files...
160106 17:43:14 [Note] InnoDB: Restoring possible half-written data pages
16010[root@bns ~]# service mysql restart
 ERROR! MySQL server PID file could not be found!
Starting MySQL...^C

Please help me!

13
Inform here 'cat /var/lib/mysql/*.err' (need 20 latest line of file content).
MySQL is running, but website error
Mysqli prepare error: Can't find file: './bachngoc_bnsxen/xf_thread_view.MYI' (errno: 2 "No such file or directory")
Log.
Code: [Select]
160106 15:29:03 [Note] /usr/sbin/mysqld (mysqld 10.0.20-MariaDB) starting as process 29438 ...
160106 15:29:03 [Note] InnoDB: Using mutexes to ref count buffer pool pages
160106 15:29:03 [Note] InnoDB: The InnoDB memory heap is disabled
160106 15:29:03 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
160106 15:29:03 [Note] InnoDB: Memory barrier is not used
160106 15:29:03 [Note] InnoDB: Compressed tables use zlib 1.2.3
160106 15:29:03 [Note] InnoDB: Using CPU crc32 instructions
160106 15:29:03 [Note] InnoDB: Initializing buffer pool, size = 128.0M
160106 15:29:03 [Note] InnoDB: Completed initialization of buffer pool
160106 15:29:03 [Note] InnoDB: Highest supported file format is Barracuda.
160106 15:29:03 [Note] InnoDB: 128 rollback segment(s) are active.
160106 15:29:03 [Note] InnoDB: Waiting for purge to start
160106 15:29:03 [Note] InnoDB:  Percona XtraDB (http://www.percona.com) 5.6.24-72.2 started; log sequence number 158940094253
160106 15:29:03 [Note] Plugin 'FEEDBACK' is disabled.
160106 15:29:03 [Note] Server socket created on IP: '::'.
160106 15:29:03 [Note] Event Scheduler: Loaded 0 events
160106 15:29:03 [Note] /usr/sbin/mysqld: ready for connections.
Version: '10.0.20-MariaDB'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MariaDB Server
160106 15:29:04 [ERROR] mysqld: Table './bachngoc_bnsxen/xf_error_log' is marked as crashed and should be repaired
160106 15:29:04 [Warning] Checking table:   './bachngoc_bnsxen/xf_error_log'
160106 15:29:04 [Warning] Recovering table: './bachngoc_bnsxen/xf_error_log'
160106 15:29:45 [Warning] mysqld: Disk is full writing './bachngoc_bnsxen/xf_error_log.MYD' (Errcode: 28 "No space left on device"). Waiting for someone to free space... (Expect up to 60 secs delay for server to continue after freeing disk space)
160106 15:29:45 [Warning] mysqld: Retry in 60 secs. Message reprinted in 600 secs
2016-01-06 15:29:46 7f9de7bff700 InnoDB: Error: Write to file ./bachngoc_bnsdru/cache_menu.ibd failed at offset 13333692416.
InnoDB: 1048576 bytes should have been written, only 0 were written.
InnoDB: Operating system error number 28.
InnoDB: Check that your OS and file system support files of this size.
InnoDB: Check also that the disk is not full or a disk quota exceeded.
InnoDB: Error number 28 means 'No space left on device'.
InnoDB: Some operating system error numbers are described at
InnoDB: http://dev.mysql.com/doc/refman/5.6/en/operating-system-error-codes.html
FAIL160106 15:29:46 [ERROR] mysqld: The table 'cache_menu' is full
FAIL160106 15:29:48 [ERROR] mysqld: The table 'cache_menu' is full
FAIL160106 15:29:54 [ERROR] mysqld: The table 'cache_menu' is full
FAIL160106 15:29:54 [ERROR] mysqld: The table 'cache_menu' is full
FAIL160106 15:29:54 [ERROR] mysqld: The table 'cache_menu' is full
FAIL160106 15:31:55 [ERROR] mysqld: The table 'cache_menu' is full
160106 15:34:11 [ERROR] mysqld: Table './bachngoc_bnsxen/xf_mail_queue' is marked as crashed and should be repaired
160106 15:34:11 [Warning] Checking table:   './bachngoc_bnsxen/xf_mail_queue'
160106 15:34:11 [ERROR] mysqld: Table './bachngoc_bnsxen/xf_poll_response' is marked as crashed and should be repaired
160106 15:34:11 [Warning] Checking table:   './bachngoc_bnsxen/xf_poll_response'
160106 15:34:11 [ERROR] mysqld: Table './bachngoc_bnsxen/xf_poll_vote' is marked as crashed and should be repaired
160106 15:34:11 [Warning] Checking table:   './bachngoc_bnsxen/xf_poll_vote'
160106 15:34:11 [ERROR] mysqld: Table './bachngoc_bnsxen/xf_store_product' is marked as crashed and should be repaired
160106 15:34:11 [Warning] Checking table:   './bachngoc_bnsxen/xf_store_product'
160106 15:34:12 [ERROR] mysqld: Table './bachngoc_bnsxen/xf_store_transaction' is marked as crashed and should be repaired
160106 15:34:12 [Warning] Checking table:   './bachngoc_bnsxen/xf_store_transaction'
160106 15:34:12 [ERROR] mysqld: Table './bachngoc_bnsxen/xf_user_status' is marked as crashed and should be repaired
160106 15:34:[root@bns tmp]#

14
Open '/etc/my.cnf.d/server.cnf' and change 'skip-innodb' to '#skip-innodb'.
this file changed
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]
max_connections = 400
max_user_connections=600
performance_schema=on
default-storage-engine=myisam
#skip-innodb
#OpenVZ AIO bug fix
innodb_use_native_aio=0
#
#
max_allowed_packet=18M
#
#
# 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]

~
~
but don't start MySQL

 ERROR! MySQL is not running, but lock file (/var/lock/subsys/mysql) exists

[root@bns ~]# rm -f /var/lock/subsys/mysql
[root@bns ~]# service mysql restart
 ERROR! MySQL server PID file could not be found!
Starting MySQL... ERROR!

15
Inform here 'service mysql restart'.
Code: [Select]
[root@bns script]# service mysql restart
 ERROR! MySQL server PID file could not be found!
Starting MySQL...
and
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111 "Connection refused")

Pages: [1] 2 3 ... 7

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

Page created in 0.054 seconds with 22 queries.

web stats analysis