URGENT HELP, I can't login , error: not_admin_cannot_modify_general

[crossing]

After I added new client I can't login to admin area anymore, actually some wordpress client websites lost connection to database. I reboot it the server and clients websites work fine now but I can't access admin area anymore with my pass. I tried to reset it but :


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

[root@shared ~]# /script/update --class=client  --name=admin  --subaction=password  --v-password=crossing1976
object_doesnt_exist: name: admin

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



I need urgent help please !

[crossing]

I updated kloxomr and works fine now .

[crossing]

The problem come back again.. All wrodpress clients websites give this error "Error establishing a database connection" . I reboot it the server and things are back to normal but I'm sure the problem will come again soon..

Mustafa please help me ! I don't want my clients to suffer and keep complaining.

[MRatWork]

Inform here 'sh /script/sysinfo'.

[crossing]

I just updated yum fe minutes ago, was 175MB , this is after update :

A. Kloxo-MR: 6.5.0.f-2015010801

B. OS: CentOS release 6.6 (Final) x86_64

C. Apps:
   1. MySQL: mysql55-5.5.42-1.ius.el6.x86_64
   2. PHP: php53u-5.3.29-1.ius.el6.x86_64
   3. Httpd: httpd-2.2.29-1.mr.el6.x86_64
   4. Lighttpd: --uninstalled--
   5. Nginx: nginx-1.7.10-1.el6.ngx.x86_64
   6. Qmail: qmail-toaster-1.03-1.3.48.mr.el6.x86_64
      - with: courier-imap-toaster-4.1.2-1.3.18.mr.el6.x86_64
   7. Dns: bind-9.9.5-1.el6.x86_64

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

E. Memory:
                total       used       free     shared    buffers     cached
   Mem:           996        900         95          0         17        154
   -/+ buffers/cache:        728        267
   Swap:            0          0          0

[MRatWork]

Try go to 'webserver config' and select 'optimize' for 'apache optimize'.

[crossing]

Try go to 'webserver config' and select 'optimize' for 'apache optimize'.

I will try that, thanks.

[crossing]

The problem its still there I noticed exactly when happened , I was trying to upload on picture to one of my clients wordpress websites and the error occured :

"Error establishing a database connection"  on ALL clients wordpress websites and I'm not able to login to admin.  I reboot the server as usual to solve the problem. I'm a little affraid to be honest.. I may not be infront of my PC when this happen and my clients will be very unhappy

[MRatWork]

If you found error in applications (like wordpress) possible you need mysql optimizing (use /script/mysql-optimize for repair and or optimize and mysqtuner for mysql setting).

[crossing]

Thank you Mustafa, I just optimized all databases using phpMyAdmin. Hopefully I will not have this error anymore.

[MRatWork]

Install mysqltuner with 'yum install mysqltuner -y' and then check your mysql setting with running 'mysqltuner --user root --pass yourmysqlrootpassword'. Get this password from /usr/local/lxlabs/kloxo/etc/slavedb/dbadmin file.

[crossing]

Install mysqltuner with 'yum install mysqltuner -y' and then check your mysql setting with running 'mysqltuner --user root --pass yourmysqlrootpassword'. Get this password from /usr/local/lxlabs/kloxo/etc/slavedb/dbadmin file.

I just got the error again so I reboot it the server and read your post after. I followed the give steps and I got this result on  'mysqltuner --user root --pass yourmysqlrootpassword' :

Code: [Select]

>>  MySQLTuner 1.1.1 - Major Hayden <major@mhtx.net>
 >>  Bug reports, feature requests, and downloads at http://mysqltuner.com/
 >>  Run with '--help' for additional options and output filtering
[OK] Logged in using credentials passed on the command line

-------- General Statistics --------------------------------------------------
[--] Skipped version check for MySQLTuner script
[OK] Currently running supported MySQL version 5.5.42
[OK] Operating on 64-bit architecture

-------- Storage Engine Statistics -------------------------------------------
[--] Status: -Archive -BDB -Federated +InnoDB -ISAM -NDBCluster
[--] Data in MyISAM tables: 4M (Tables: 137)
[--] Data in InnoDB tables: 28M (Tables: 91)
[--] Data in PERFORMANCE_SCHEMA tables: 0B (Tables: 17)
[!!] Total fragmented tables: 91

-------- Security Recommendations  -------------------------------------------
[!!] User 'root' has no password set.
[!!] User 'root' has no password set.
[!!] User 'root' has no password set.
[!!] User '' has no password set.
[!!] User '' has no password set.

-------- Performance Metrics -------------------------------------------------
[--] Up for: 2m 24s (412 q [2.861 qps], 19 conn, TX: 1M, RX: 50K)
[--] Reads / Writes: 96% / 4%
[--] Total buffers: 272.0M global + 4.2M per thread (151 max threads)
[!!] Maximum possible memory usage: 913.8M (91% of installed RAM)
[OK] Slow queries: 0% (0/412)
[OK] Highest usage of available connections: 3% (5/151)
[OK] Key buffer size / total MyISAM indexes: 64.0M/1.1M
[!!] Key buffer hit rate: 0.0% (3 cached / 3 reads)
[OK] Query cache efficiency: 55.5% (206 cached / 371 selects)
[OK] Query cache prunes per day: 0
[OK] Sorts requiring temporary tables: 0% (0 temp sorts / 39 sorts)
[!!] Temporary tables created on disk: 30% (6 on disk / 20 total)
[OK] Thread cache hit rate: 73% (5 created / 19 connections)
[OK] Table cache hit rate: 86% (46 open / 53 opened)
[OK] Open file limit used: 0% (32/65K)
[OK] Table locks acquired immediately: 100% (216 immediate / 216 locks)
[OK] InnoDB data size / buffer pool: 28.0M/128.0M

-------- Recommendations -----------------------------------------------------
General recommendations:
    Run OPTIMIZE TABLE to defragment tables for better performance
    MySQL started within last 24 hours - recommendations may be inaccurate
    Reduce your overall MySQL memory footprint for system stability
    Enable the slow query log to troubleshoot bad queries
    When making adjustments, make tmp_table_size/max_heap_table_size equal
    Reduce your SELECT DISTINCT queries without LIMIT clauses
Variables to adjust:
  *** MySQL's maximum memory usage is dangerously high ***
  *** Add RAM before increasing MySQL buffer variables ***
    tmp_table_size (> 32M)
    max_heap_table_size (> 64M)
It seems like 1Gb RAM its not enough for 3 Wordpress websites.. I upgrade it the RAM to 4Gb. Anything else I should do ?

Result after RAM upgrade:

Code: [Select]

>>  MySQLTuner 1.1.1 - Major Hayden <major@mhtx.net>
 >>  Bug reports, feature requests, and downloads at http://mysqltuner.com/
 >>  Run with '--help' for additional options and output filtering
[OK] Logged in using credentials passed on the command line

-------- General Statistics --------------------------------------------------
[--] Skipped version check for MySQLTuner script
[OK] Currently running supported MySQL version 5.5.42
[OK] Operating on 64-bit architecture

-------- Storage Engine Statistics -------------------------------------------
[--] Status: -Archive -BDB -Federated +InnoDB -ISAM -NDBCluster
[--] Data in MyISAM tables: 4M (Tables: 137)
[--] Data in InnoDB tables: 28M (Tables: 91)
[--] Data in PERFORMANCE_SCHEMA tables: 0B (Tables: 17)
[!!] Total fragmented tables: 91

-------- Security Recommendations  -------------------------------------------
[!!] User 'root' has no password set.
[!!] User 'root' has no password set.
[!!] User 'root' has no password set.
[!!] User '' has no password set.
[!!] User '' has no password set.

-------- Performance Metrics -------------------------------------------------
[--] Up for: 2m 50s (728 q [4.282 qps], 130 conn, TX: 2M, RX: 106K)
[--] Reads / Writes: 92% / 8%
[--] Total buffers: 272.0M global + 4.2M per thread (151 max threads)
[OK] Maximum possible memory usage: 913.8M (23% of installed RAM)
[OK] Slow queries: 0% (0/728)
[OK] Highest usage of available connections: 3% (5/151)
[OK] Key buffer size / total MyISAM indexes: 64.0M/1.1M
[!!] Key buffer hit rate: 82.4% (85 cached / 15 reads)
[OK] Query cache efficiency: 44.2% (237 cached / 536 selects)
[OK] Query cache prunes per day: 0
[OK] Sorts requiring temporary tables: 0% (0 temp sorts / 43 sorts)
[!!] Joins performed without indexes: 1
[!!] Temporary tables created on disk: 41% (20 on disk / 48 total)
[OK] Thread cache hit rate: 96% (5 created / 130 connections)
[OK] Table cache hit rate: 90% (69 open / 76 opened)
[OK] Open file limit used: 0% (66/65K)
[OK] Table locks acquired immediately: 100% (366 immediate / 366 locks)
[OK] InnoDB data size / buffer pool: 28.0M/128.0M

-------- Recommendations -----------------------------------------------------
General recommendations:
    Run OPTIMIZE TABLE to defragment tables for better performance
    MySQL started within last 24 hours - recommendations may be inaccurate
    Enable the slow query log to troubleshoot bad queries
    Adjust your join queries to always utilize indexes
    When making adjustments, make tmp_table_size/max_heap_table_size equal
    Reduce your SELECT DISTINCT queries without LIMIT clauses
Variables to adjust:
    join_buffer_size (> 1.0M, or always use indexes with joins)
    tmp_table_size (> 32M)
    max_heap_table_size (> 64M)


[MRatWork]

Set mysql root password in 'reset mysql password' from panel or 'sh /script/resetmysqlrootpassword yourpassword'.

You need modified /etc/my.cnf (under '[mysqld]') for param like 'join_buffer_size'. After add/update, restart your mysql with 'service mysqld restart' (if using mysql) or 'service mysql restart' (if using mariadb). And then run again mysqltuner.

[MRatWork]

Inform here 'cat /etc/my.cnf'.

[crossing]

I updated the values as advices, now I get:

Variables to adjust:
    query_cache_limit (> 1M, or use smaller result sets)

If I increase the 1M value to 2M and test again it say "query_cache_limit (> 2M, or use smaller result sets)"

Here is my.cnf content:

Code: [Select]

[mysqld]
#OpenVZ AIO bug fix
innodb_use_native_aio=0

## General
datadir                         = /var/lib/mysql
tmpdir                          = /var/lib/mysqltmp
socket                          = /var/lib/mysql/mysql.sock
skip-name-resolve
sql-mode                        = NO_ENGINE_SUBSTITUTION
#event-scheduler                = 1

## Cache
thread-cache-size               = 16
table-open-cache                = 4096
table-definition-cache          = 2048
query-cache-size                = 32M
query-cache-limit               = 1M

## Per-thread Buffers
sort-buffer-size                = 1M
read-buffer-size                = 1M
read-rnd-buffer-size            = 1M
join-buffer-size                = 2M

## Temp Tables
tmp-table-size                  = 64M
max-heap-table-size             = 128M

## Networking
back-log                        = 100
#max-connections                = 200
## General
datadir                         = /var/lib/mysql
tmpdir                          = /var/lib/mysqltmp
socket                          = /var/lib/mysql/mysql.sock
skip-name-resolve
sql-mode                        = NO_ENGINE_SUBSTITUTION
#event-scheduler                = 1

## Cache
thread-cache-size               = 16
table-open-cache                = 4096
table-definition-cache          = 2048
query-cache-size                = 32M
query-cache-limit               = 1M

## Per-thread Buffers
sort-buffer-size                = 1M
read-buffer-size                = 1M
read-rnd-buffer-size            = 1M
join-buffer-size                = 1M

## Temp Tables
tmp-table-size                  = 64M
max-heap-table-size             = 128M

## Networking
back-log                        = 100
#max-connections                = 200
max-connect-errors              = 10000
max-allowed-packet              = 16M
interactive-timeout             = 3600
wait-timeout                    = 600

### Storage Engines
#default-storage-engine         = InnoDB
innodb                          = FORCE

## MyISAM
key-buffer-size                 = 64M
myisam-sort-buffer-size         = 128M

## InnoDB
#innodb-buffer-pool-size        = 128M
#innodb-log-file-size           = 100M
#innodb-log-buffer-size         = 8M
#innodb-file-per-table          = 1
#innodb-open-files              = 300

## Replication
server-id                       = 1
#log-bin                        = /var/log/mysql/bin-log
#relay-log                      = /var/log/mysql/relay-log
relay-log-space-limit           = 16G
expire-logs-days                = 7
#read-only                      = 1
#sync-binlog                    = 1
#log-slave-updates              = 1

max-connect-errors              = 10000
max-allowed-packet              = 16M
interactive-timeout             = 3600
wait-timeout                    = 600

### Storage Engines
#default-storage-engine         = InnoDB
innodb                          = FORCE

## MyISAM
key-buffer-size                 = 64M
myisam-sort-buffer-size         = 128M

## InnoDB
#innodb-buffer-pool-size        = 128M
#innodb-log-file-size           = 100M
#innodb-log-buffer-size         = 8M
#innodb-file-per-table          = 1
#innodb-open-files              = 300

## Replication
server-id                       = 1
#log-bin                        = /var/log/mysql/bin-log
#relay-log                      = /var/log/mysql/relay-log
relay-log-space-limit           = 16G
expire-logs-days                = 7
#read-only                      = 1
#sync-binlog                    = 1
#log-slave-updates              = 1
#binlog-format                  = STATEMENT
#auto-increment-offset          = 1
#auto-increment-increment       = 2

## Logging
#log-output                      = FILE
#slow-query-log                  = 1
#slow-query-log-file             = /var/log/mysql/slow-log
#log-slow-slave-statements
#long-query-time                 = 2

[mysqld_safe]
log-error                       = /var/log/mysqld.log
open-files-limit                = 65535

[mysql]
no-auto-rehash