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, 18:08:24

Author Topic: How to reset password Kloxo-MR admin?  (Read 9957 times)

0 Members and 1 Guest are viewing this topic.

Offline hoangsang

  • Valuable Member
  • *
  • Posts: 97
  • Karma: +0/-0
    • View Profile
How to reset password Kloxo-MR admin?
« on: 2016-01-06, 03:20:39 »
I'm run script but error :(

[root@bns ~]# sh /script/resetpassword master 'XXXXXXX'
Notice : The resource you have requested doesn't exist. The server returned the error message: <br>  only_admin_can_modify_general nname  <br>

Please help me!

Offline MRatWork

  • Administrator
  • The Elite
  • *****
  • Posts: 15,807
  • Karma: +119/-11
  • Gender: Male
    • View Profile
    • MRatWork Forum
Re: How to reset password Kloxo-MR admin?
« Reply #1 on: 2016-01-06, 04:15:28 »
Inform here your 'sh /script/sysinfo'.

How to fix depend on your Kloxo-MR version.
..:: MRatWork (Mustafa Ramadhan Projects) ::..
-- Server/Web-integrator - Web Hosting (Kloxo-MR READY!) --

Offline hoangsang

  • Valuable Member
  • *
  • Posts: 97
  • Karma: +0/-0
    • View Profile
Re: How to reset password Kloxo-MR admin?
« Reply #2 on: 2016-01-06, 06:52:17 »
Because MySQL is stop :(
i'm run
Code: [Select]
sh /script/upcpbut show error:
Code: [Select]
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111 "Connection refused")
and MySQL restart failured
My System:
Code: [Select]
[root@bns ~]# sh /script/sysinfo
A. Kloxo-MR: 7.0.0.b-2016010501
   - Web: hiawatha-9.13.0-f.6.mr.el6.x86_64
   - PHP: php54s-5.4.41-1.ius.el6 (fpm mode)
B. Plateform:
   - OS: CentOS release 6.6 (Final) x86_64
   - Hostname: bns.cbder.com
C. Services:
   1. MySQL: MariaDB-server-10.0.20-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       7016        840          0         81       6293
   -/+ buffers/cache:        642       7215
   Swap:         7999          0       7999
E. Disk Space:
   Filesystem            Size  Used Avail Use% Mounted on
   /dev/mapper/vg_bachngoddfh-lv_root
                          50G   47G     0 100% /


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

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

« Last Edit: 2016-01-06, 07:01:01 by hoangsang »

Offline MRatWork

  • Administrator
  • The Elite
  • *****
  • Posts: 15,807
  • Karma: +119/-11
  • Gender: Male
    • View Profile
    • MRatWork Forum
Re: How to reset password Kloxo-MR admin?
« Reply #3 on: 2016-01-06, 07:04:45 »
Try:
Code: [Select]
sh /script/reset-mysql-root-password YOURPASSWORD
sh /script/mysql-optimize --select=upgrade

and then try again resetpassword
..:: MRatWork (Mustafa Ramadhan Projects) ::..
-- Server/Web-integrator - Web Hosting (Kloxo-MR READY!) --

Offline hoangsang

  • Valuable Member
  • *
  • Posts: 97
  • Karma: +0/-0
    • View Profile
Re: How to reset password Kloxo-MR admin?
« Reply #4 on: 2016-01-06, 07:15:28 »
Try:
Code: [Select]
sh /script/reset-mysql-root-password YOURPASSWORD
sh /script/mysql-optimize --select=upgrade

and then try again resetpassword
MySQL don't start :(
Code: [Select]
[root@bns script]# sh /script/reset-mysql-root-password Hongxxxx890
Stop MySQL service...
MySQL ROOT password reset...

Start MySQL service...






Offline MRatWork

  • Administrator
  • The Elite
  • *****
  • Posts: 15,807
  • Karma: +119/-11
  • Gender: Male
    • View Profile
    • MRatWork Forum
Re: How to reset password Kloxo-MR admin?
« Reply #5 on: 2016-01-06, 07:24:48 »
Inform here 'service mysql restart'.
..:: MRatWork (Mustafa Ramadhan Projects) ::..
-- Server/Web-integrator - Web Hosting (Kloxo-MR READY!) --

Offline hoangsang

  • Valuable Member
  • *
  • Posts: 97
  • Karma: +0/-0
    • View Profile
Re: How to reset password Kloxo-MR admin?
« Reply #6 on: 2016-01-06, 07:51:54 »
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")

Offline MRatWork

  • Administrator
  • The Elite
  • *****
  • Posts: 15,807
  • Karma: +119/-11
  • Gender: Male
    • View Profile
    • MRatWork Forum
Re: How to reset password Kloxo-MR admin?
« Reply #7 on: 2016-01-06, 08:07:39 »
Open '/etc/my.cnf.d/server.cnf' and change 'skip-innodb' to '#skip-innodb'.
..:: MRatWork (Mustafa Ramadhan Projects) ::..
-- Server/Web-integrator - Web Hosting (Kloxo-MR READY!) --

Offline hoangsang

  • Valuable Member
  • *
  • Posts: 97
  • Karma: +0/-0
    • View Profile
Re: How to reset password Kloxo-MR admin?
« Reply #8 on: 2016-01-06, 08:13:48 »
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!
« Last Edit: 2016-01-06, 08:21:35 by hoangsang »

Offline MRatWork

  • Administrator
  • The Elite
  • *****
  • Posts: 15,807
  • Karma: +119/-11
  • Gender: Male
    • View Profile
    • MRatWork Forum
Re: How to reset password Kloxo-MR admin?
« Reply #9 on: 2016-01-06, 09:33:29 »
Inform here 'cat /var/lib/mysql/*.err' (need 20 latest line of file content).
..:: MRatWork (Mustafa Ramadhan Projects) ::..
-- Server/Web-integrator - Web Hosting (Kloxo-MR READY!) --

Offline hoangsang

  • Valuable Member
  • *
  • Posts: 97
  • Karma: +0/-0
    • View Profile
Re: How to reset password Kloxo-MR admin?
« Reply #10 on: 2016-01-06, 09:44:23 »
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]#

Offline MRatWork

  • Administrator
  • The Elite
  • *****
  • Posts: 15,807
  • Karma: +119/-11
  • Gender: Male
    • View Profile
    • MRatWork Forum
Re: How to reset password Kloxo-MR admin?
« Reply #11 on: 2016-01-06, 10:29:00 »
There something wrong with database with innodb storage-engine (error like '[ERROR] mysqld: Table './bachngoc_bnsxen/xf_user_status' is marked as crashed and should be repaired'.
..:: MRatWork (Mustafa Ramadhan Projects) ::..
-- Server/Web-integrator - Web Hosting (Kloxo-MR READY!) --

Offline hoangsang

  • Valuable Member
  • *
  • Posts: 97
  • Karma: +0/-0
    • View Profile
Re: How to reset password Kloxo-MR admin?
« Reply #12 on: 2016-01-06, 11:41:47 »
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!

Offline MRatWork

  • Administrator
  • The Elite
  • *****
  • Posts: 15,807
  • Karma: +119/-11
  • Gender: Male
    • View Profile
    • MRatWork Forum
Re: How to reset password Kloxo-MR admin?
« Reply #13 on: 2016-01-06, 11:46:59 »
Add 'innodb_force_recovery = 1' in /etc/my.cnf.d/server.cnf under '[mysqld]' and then restart mysql with 'sh /script/restart-mysql -y'.
..:: MRatWork (Mustafa Ramadhan Projects) ::..
-- Server/Web-integrator - Web Hosting (Kloxo-MR READY!) --

Offline hoangsang

  • Valuable Member
  • *
  • Posts: 97
  • Karma: +0/-0
    • View Profile
Re: How to reset password Kloxo-MR admin?
« Reply #14 on: 2016-01-06, 15:35:50 »
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% /



 


Top 4 Global Search Engines:    Google    Bing    Baidu    Yahoo

Page created in 0.048 seconds with 22 queries.

web stats analysis