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

Author Topic: (ASK) Error Login  (Read 6689 times)

0 Members and 1 Guest are viewing this topic.

Offline gp313

  • Valuable Member
  • *
  • Posts: 73
  • Karma: +0/-0
    • View Profile
(ASK) Error Login
« on: 2015-12-08, 18:01:35 »
setalah menjalankan ini

rm -f /etc/yum.repos.d/*.rpm
yum clean all
sh /script/upcp -y

tidak bisa login dan tidak bisa reset password
dan pas restart service dapet error ini
"Starting MySQL. ERROR!
  - Process: reload
 ERROR! MySQL PID file could not be found!
No message for reload"


sysinfo

A. Kloxo-MR: 7.0.0.b-2015103001
   - Web: hiawatha-9.15.0-f.6.mr.el6.i686
   - PHP: php54s-5.4.45-1.ius.el6 (cgi mode)
B. Plateform:
   - OS: CentOS release 6.7 (Final) i686
   - Hostname: server.domain.ku
C. Services:
   1. MySQL: MariaDB-server-10.0.22-1.el6.i686
   2. PHP:
      - Branch: php54-cli-5.4.45-1.ius.el6.i686
      - Used: --Use PHP Branch--
   3. Httpd: httpd-2.2.31-1.mr.el6.i386
      - PHP Type: [unknown]
   4. Lighttpd: --uninstalled--
   5. Hiawatha: --unused--
   6. Nginx: --uninstalled--
   7. Cache: --uninstalled--
   8. Dns: bind-9.9.7-1.mr.el6.i386
   9. Qmail: qmail-toaster-1.03-1.3.55.mr.el6.i386
      - with: courier-imap-toaster-4.1.2-1.3.18.mr.el6.i386
D. Memory:
                total       used       free     shared    buffers     cached
   Mem:           576        236        339          0          0        187
   -/+ buffers/cache:         49        526
   Swap:            0          0          0
« Last Edit: 2015-12-08, 18:22:09 by gp313 »

Offline MRatWork

  • Administrator
  • The Elite
  • *****
  • Posts: 15,807
  • Karma: +119/-11
  • Gender: Male
    • View Profile
    • MRatWork Forum
Re: (ASK) Error Login
« Reply #1 on: 2015-12-08, 18:49:09 »
Coba infokan 'cat /var/lib/mysql/*.err'.
..:: MRatWork (Mustafa Ramadhan Projects) ::..
-- Server/Web-integrator - Web Hosting (Kloxo-MR READY!) --

Offline gp313

  • Valuable Member
  • *
  • Posts: 73
  • Karma: +0/-0
    • View Profile
Re: (ASK) Error Login
« Reply #2 on: 2015-12-08, 19:21:59 »
Info dari
cat /var/lib/mysql/*.err
masih banyak yg lain, ini saja yg bisa di pos.

Status information:

Current dir: /var/lib/mysql/
Running threads: 0  Stack size: 294912
Current locks:
lock: 0x8bf56a88:

lock: 0x8bf70e08:

lock: 0x8bf70d48:

lock: 0x8bf70c88:

lock: 0x8bf70a48:

lock: 0x8bf70988:

lock: 0x8bf708c8:

lock: 0x8bf56848:

lock: 0x8bf56788:

lock: 0x8bf566c8:

lock: 0x8bf56608:

lock: 0x8bf56548:

lock: 0x8bf56488:

lock: 0x8bf563c8:

lock: 0x8bf56308:

lock: 0x8bf56248:

lock: 0x8bf56188:

lock: 0x8bf560c8:

lock: 0x8cdb400:

lock: 0x8cdb380:

lock: 0x8cdaa80:

lock: 0x8cdaa00:

lock: 0x8cda980:

lock: 0x8cdab80:

lock: 0x8cd9a80:

lock: 0x8cdb300:

lock: 0x8cd9e80:

lock: 0x8cda000:

lock: 0x8cd9e00:

lock: 0x8cd9f80:

lock: 0x8cd9d80:

lock: 0x8cd9f00:

lock: 0x8cda300:

lock: 0x8cda280:

lock: 0x8cda200:

lock: 0x8cd9d00:

lock: 0x8cd9b80:

lock: 0x8cd9c80:

lock: 0x8cd9b00:

lock: 0x8cd9c00:

lock: 0x8cda180:

lock: 0x8cda100:

lock: 0x8cda080:

lock: 0x8cdb100:

lock: 0x8cdb280:

lock: 0x8cdb200:

lock: 0x8cdb180:

lock: 0x8cdaf00:

lock: 0x8cdae80:

lock: 0x8cdae00:

lock: 0x8cdad80:

lock: 0x8cdad00:

lock: 0x8cdb000:

lock: 0x8cdac80:

lock: 0x8cdac00:

lock: 0x8cdaf80:

lock: 0x8cdab00:

lock: 0x8cda880:

lock: 0x8cda900:

lock: 0x8cda800:

lock: 0x8cda780:

lock: 0x8cda580:

lock: 0x8cda700:

lock: 0x8cda680:

lock: 0x8cda500:

lock: 0x8cda600:

lock: 0x8cda480:

lock: 0x8cda400:

lock: 0x8cda380:

lock: 0x8cdb080:


Key caches:
default
Buffer_size:     134217728
Block_size:           1024
Division_limit:        100
Age_threshold:         300
Partitions:              0
blocks used:             0
not flushed:             0
w_requests:              0
writes:                  0
r_requests:              0
reads:                   0


handler status:
read_key:         1845
read_next:        3007
read_rnd           112
read_first:       1797
write:             197
delete             187
update:            250

Table status:
Opened tables:         76
Open tables:           18
Open files:             4
Open streams:           0

Alarm status:
Active alarms:   0
Max used alarms: 0
Next alarm time: 0

Memory status:
Non-mmapped space allocated from system: 0
Number of free chunks:                   1
Number of fastbin blocks:                0
Number of mmapped regions:               0
Space in mmapped regions:                0
Maximum total allocated space:           0
Space available in freed fastbin blocks: 0
Total allocated space:                   0
Total free space:                        0
Top-most, releasable space:              0
Estimated memory (with thread stack):    0



Events status:
LLA = Last Locked At  LUA = Last Unlocked At
WOC = Waiting On Condition  DL = Data Locked
The Event Scheduler is disabled

151208 19:12:19 [ERROR] Missing system table mysql.roles_mapping; please run mysql_upgrade to create it
151208 19:15:53 mysqld_safe A mysqld process already exists

Offline MRatWork

  • Administrator
  • The Elite
  • *****
  • Posts: 15,807
  • Karma: +119/-11
  • Gender: Male
    • View Profile
    • MRatWork Forum
Re: (ASK) Error Login
« Reply #3 on: 2015-12-08, 19:34:12 »
Coba lakukan:
Code: [Select]
sh /script/reset-mysql-root-password PASSWORDANDA
mysql_upgrade --user=root --password=PASSWORDANDA --force
service mysql restart
..:: MRatWork (Mustafa Ramadhan Projects) ::..
-- Server/Web-integrator - Web Hosting (Kloxo-MR READY!) --

Offline gp313

  • Valuable Member
  • *
  • Posts: 73
  • Karma: +0/-0
    • View Profile
Re: (ASK) Error Login
« Reply #4 on: 2015-12-08, 19:41:13 »
Masih error SQL nya pak

[root@server /]# sh /script/reset-mysql-root-password PASSWORD
Stop MySQL service...
MySQL ROOT password reset...
Start MySQL service...
Connect failed: No such file or directory
[root@server /]# mysql_upgrade --user=root --password=PASSWORD --force
Version check failed. Got the following error when calling the 'mysql' command line client
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2 "No such file or directory")
FATAL ERROR: Upgrade failed
[root@server /]# service mysql restart
 ERROR! MySQL server PID file could not be found!
Starting MySQL. ERROR!

Offline MRatWork

  • Administrator
  • The Elite
  • *****
  • Posts: 15,807
  • Karma: +119/-11
  • Gender: Male
    • View Profile
    • MRatWork Forum
Re: (ASK) Error Login
« Reply #5 on: 2015-12-08, 23:46:15 »
Ini new install atau update?.
..:: MRatWork (Mustafa Ramadhan Projects) ::..
-- Server/Web-integrator - Web Hosting (Kloxo-MR READY!) --

Offline gp313

  • Valuable Member
  • *
  • Posts: 73
  • Karma: +0/-0
    • View Profile
Re: (ASK) Error Login
« Reply #6 on: 2015-12-09, 02:07:19 »
saya  update trus karena gak ada perubahan new install, dan sepertinya tetap tak ada perubahan pak MR,
« Last Edit: 2015-12-09, 02:18:48 by gp313 »

Offline MRatWork

  • Administrator
  • The Elite
  • *****
  • Posts: 15,807
  • Karma: +119/-11
  • Gender: Male
    • View Profile
    • MRatWork Forum
Re: (ASK) Error Login
« Reply #7 on: 2015-12-09, 03:03:06 »
Jika sebelumnya berjalan lancar maka bisa jadi penyebabnya space atau inode habis.
..:: MRatWork (Mustafa Ramadhan Projects) ::..
-- Server/Web-integrator - Web Hosting (Kloxo-MR READY!) --

Offline gp313

  • Valuable Member
  • *
  • Posts: 73
  • Karma: +0/-0
    • View Profile
Re: (ASK) Error Login
« Reply #8 on: 2015-12-09, 04:27:08 »
Trus bagaimana itu solusinya pak MR?

Offline MRatWork

  • Administrator
  • The Elite
  • *****
  • Posts: 15,807
  • Karma: +119/-11
  • Gender: Male
    • View Profile
    • MRatWork Forum
Re: (ASK) Error Login
« Reply #9 on: 2015-12-09, 05:22:34 »
Coba hapus file yang ada di:
1. /tmp
2. /usr/local/lxlabs/kloxo/serverfile
3. /home/kloxo/client/<client_or_admin>/__backup
..:: MRatWork (Mustafa Ramadhan Projects) ::..
-- Server/Web-integrator - Web Hosting (Kloxo-MR READY!) --

Offline gp313

  • Valuable Member
  • *
  • Posts: 73
  • Karma: +0/-0
    • View Profile
Re: (ASK) Error Login
« Reply #10 on: 2015-12-09, 06:03:14 »
hapus direktori di dalam ini ya pak atau hanya file yg ada di direktori tsb??
1. /tmp
2. /usr/local/lxlabs/kloxo/serverfile
3. /home/kloxo/client/<client_or_admin>/__backup
untuk point 3 berarti dua folder ya??

tidak harus di back up dulukah?saya belum tau backup via console,

setelah itu?
« Last Edit: 2015-12-09, 06:06:15 by gp313 »

Offline MRatWork

  • Administrator
  • The Elite
  • *****
  • Posts: 15,807
  • Karma: +119/-11
  • Gender: Male
    • View Profile
    • MRatWork Forum
Re: (ASK) Error Login
« Reply #11 on: 2015-12-09, 06:08:44 »
Isi dari directory tersebut (bukan directorynya) baik file maupun directory didalamnya.
..:: MRatWork (Mustafa Ramadhan Projects) ::..
-- Server/Web-integrator - Web Hosting (Kloxo-MR READY!) --

Offline gp313

  • Valuable Member
  • *
  • Posts: 73
  • Karma: +0/-0
    • View Profile
Re: (ASK) Error Login
« Reply #12 on: 2015-12-09, 06:29:49 »
oke sekarang ketiga folder tsb sudah kosong pak MR, selanjutnya?

Offline MRatWork

  • Administrator
  • The Elite
  • *****
  • Posts: 15,807
  • Karma: +119/-11
  • Gender: Male
    • View Profile
    • MRatWork Forum
Re: (ASK) Error Login
« Reply #13 on: 2015-12-09, 06:35:37 »
COba saja 'sh /script/restart-all -y'.

Infokan 'df -h /; df -ih /'
..:: MRatWork (Mustafa Ramadhan Projects) ::..
-- Server/Web-integrator - Web Hosting (Kloxo-MR READY!) --

Offline gp313

  • Valuable Member
  • *
  • Posts: 73
  • Karma: +0/-0
    • View Profile
Re: (ASK) Error Login
« Reply #14 on: 2015-12-09, 07:16:54 »
sudah saya restart all,
masih error
" ERROR! MySQL server PID file could not be found!
Starting MySQL. ERROR!
"

Hasil Info 'df -h /; df -ih /'

[root@server ~]# df -h /
Filesystem      Size  Used Avail Use% Mounted on
/dev/simfs       16G  2.3G   14G  14% /
[root@server ~]# df -ih
Filesystem     Inodes IUsed IFree IUse% Mounted on
/dev/simfs       8.0M   87K  8.0M    2% /
none              72K   151   72K    1% /dev

 


Top 10 Social Networking:    Facebook    Twitter    LinkedIn    Pinterest    Google Plus    Tumblr    Instagram    VK    Flickr    Vine
Click Here

Page created in 0.076 seconds with 21 queries.

web stats analysis