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-29, 11:11:04

Author Topic: Access denied for user 'kloxo'@'localhost' (using password: YES)  (Read 8500 times)

0 Members and 1 Guest are viewing this topic.

Offline hafidz

  • Valuable Member
  • *
  • Posts: 83
  • Karma: +0/-0
    • View Profile
selamat sore. saya mengalami masalah tidak bisa login kloxo panel. setelah saya enable debug 'sh /script/add-debug' dan 'sh /script/restart -y' saya coba login ke panel dan hasilnya

Quote
Warning: mysqli::mysqli(): (HY000/1045): Access denied for user 'kloxo'@'localhost' (using password: YES) in /usr/local/lxlabs/kloxo/httpdocs/lib/php/sqlitelib.php on line 62

Warning: mysqli::query(): Couldn't fetch mysqli in /usr/local/lxlabs/kloxo/httpdocs/lib/php/sqlitelib.php on line 116

Notice: A session had already been started - ignoring session_start() in /usr/local/lxlabs/kloxo/httpdocs/lib/php/index.php on line 93


*** Page Generation Took: : 0.05
 

- Looks Like there are some errors... Or Been asked not to redirect. Not redirecting...
- Click here to go there Anyways.

berikut hasil dari 'sh /script/sysinfo'
Quote
A. Control Panel:               
   - Kloxo-MR: 7.0.0.c-2017072303
   - Web: hiawatha-10.6.0-f.1.mr.el6.x86_64
   - PHP: php56s - 5.6.31-1.ius.centos6 (fpm mode)
B. Plateform:
   - OS: CentOS release 6.9 (Final) x86_64
   - Hostname: hosting.jogloabang.or.id
C. Services:
   1. MySQL: MariaDB-server-10.0.31-1.el6.x86_64
   2. PHP:
      - Installed:
        - Branch: php54-cli-5.4.45-1.ius.centos6.x86_64
      - Used: --PHP Branch--
      - Multiple: enable
   3. Web Used: hiawathaproxy
     - Hiawatha: hiawatha-10.6.0-f.1.mr.el6.x86_64
     - Lighttpd: lighttpd-1.4.45-1.el6.x86_64
     - Nginx: nginx-1.13.3-1.el6.ngx.x86_64
     - Apache: httpd24u-2.4.27-1.ius.centos6.x86_64
       - PHP Type: php-fpm_event (default)
       - Secondary PHP: on
   4. WebCache: none
     - ATS: --uninstalled--
     - Squid: --uninstalled--
     - Varnish: --uninstalled--
   5. Dns: nsd
     - Bind: bind-9.9.9-1.mr.el6.x86_64
     - DJBDns: djbdns-1.05-17.4.mr.el6.x86_64
     - NSD: nsd-4.1.16-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: kloxomr-stats-awstats-7.6-1.mr.noarch
D. Memory:
             total       used       free     shared    buffers     cached
Mem:         15843       9029       6813         36        112       8233
-/+ buffers/cache:        683      15159
Swap:        11999          0      11999
E. Disk Space:
Filesystem      Size  Used Avail Use% Mounted on
/dev/sda3        77G   42G   32G  58% /


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

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

Terimakasih sebelumnya..

Offline MRatWork

  • Administrator
  • The Elite
  • *****
  • Posts: 15,807
  • Karma: +119/-11
  • Gender: Male
    • View Profile
    • MRatWork Forum
Coba 'sh /script/reset-mysql-kloxo-password'.
..:: MRatWork (Mustafa Ramadhan Projects) ::..
-- Server/Web-integrator - Web Hosting (Kloxo-MR READY!) --

Offline hafidz

  • Valuable Member
  • *
  • Posts: 83
  • Karma: +0/-0
    • View Profile
sudah saya lakukan perintah 'sh /script/reset-mysql-kloxo-password' dan hasilnya
Quote
grant all on kloxo.* to kloxo@localhost identified by 'Rl857UCOM'
1045
kemudian saya mencoba jalankan 'sh /script/cleanup' ada bagian error seperti dibawah ini
Quote
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
Enter password:
Enter password:
Enter password:
saya coba masukan password root mysql tapi hasilnya Enter password:  terus... dan saya sudah melakukan tips reset root mysql password dari tautan https://forum.mratwork.com/kloxo-mr-releases-and-announcements/(tip)-reset-password/ dan kembali melakukan 'sh /script/cleanup' namun hasilnya masih tetap sama..

Offline MRatWork

  • Administrator
  • The Elite
  • *****
  • Posts: 15,807
  • Karma: +119/-11
  • Gender: Male
    • View Profile
    • MRatWork Forum
Maksudnya sudah jalankan 'sh /script/reset-mysql-root-password'?.
..:: MRatWork (Mustafa Ramadhan Projects) ::..
-- Server/Web-integrator - Web Hosting (Kloxo-MR READY!) --

Offline hafidz

  • Valuable Member
  • *
  • Posts: 83
  • Karma: +0/-0
    • View Profile
baru saja saya jalankan perintah 'sh /script/reset-mysql-root-password' kemudian 'sh /script/cleanup' pada Fix mail-all services muncul seperti dibawah ini

Quote
- Fix mail-all services
Enter password:
Enter password:
Enter password:

Offline MRatWork

  • Administrator
  • The Elite
  • *****
  • Posts: 15,807
  • Karma: +119/-11
  • Gender: Male
    • View Profile
    • MRatWork Forum
Coba lakukan reset-mysql-root-password dan fixmail-all saja (tanpa cleanup).
..:: MRatWork (Mustafa Ramadhan Projects) ::..
-- Server/Web-integrator - Web Hosting (Kloxo-MR READY!) --

Offline hafidz

  • Valuable Member
  • *
  • Posts: 83
  • Karma: +0/-0
    • View Profile
hasil dari reset-mysql-root-password
Quote
Stop MySQL service...
MySQL ROOT password reset...
Start MySQL service...
170726 18:13:22 mysqld_safe A mysqld process already exists

sedangkan hasil dari fixmail-all terdapat seperti dibawah ini
Quote
*** RoundCube Webmail setup ***
- Preparing database
- Fixing MySQL commands in import files
Enter password:
- Add Password to configuration file
Enter password:
Enter password:
Enter password:
Enter password:
Enter password:

*** Afterlogic Webmail Lite setup ***
- Preparing database
Enter password:
- Change 'setting.xml' to 'settings.xml.php' in 'settings/php'
- Generating password
- Add Password to configuration file
Enter password:

Offline MRatWork

  • Administrator
  • The Elite
  • *****
  • Posts: 15,807
  • Karma: +119/-11
  • Gender: Male
    • View Profile
    • MRatWork Forum
Coba reboot dan ulangi process.
..:: MRatWork (Mustafa Ramadhan Projects) ::..
-- Server/Web-integrator - Web Hosting (Kloxo-MR READY!) --

Offline hafidz

  • Valuable Member
  • *
  • Posts: 83
  • Karma: +0/-0
    • View Profile
setelah reboot  kembali melakukan proses reset-mysql-root-password dan fixmail-all hasilnya tetap sama pada bagian *** RoundCube Webmail setup ***
Fixing Mail accounts (also 'lists' if exists)
--------------------------
Quote
*** RoundCube Webmail setup ***
- Preparing database
- Fixing MySQL commands in import files
Enter password:
- Add Password to configuration file
Enter password:
Enter password:
Enter password:
Enter password:
Enter password:
Enter password:
Enter password:
Enter password:
Enter password:
Enter password:
Enter password:
Enter password:
Enter password:
Enter password:
Enter password:
Enter password:
Enter password:
Enter password:

Offline MRatWork

  • Administrator
  • The Elite
  • *****
  • Posts: 15,807
  • Karma: +119/-11
  • Gender: Male
    • View Profile
    • MRatWork Forum
OK, beri saya akses ke ssh dan panel anda.
..:: MRatWork (Mustafa Ramadhan Projects) ::..
-- Server/Web-integrator - Web Hosting (Kloxo-MR READY!) --

Offline hafidz

  • Valuable Member
  • *
  • Posts: 83
  • Karma: +0/-0
    • View Profile
baik mas, sudah saya kirim pm untuk akunnya..

Offline MRatWork

  • Administrator
  • The Elite
  • *****
  • Posts: 15,807
  • Karma: +119/-11
  • Gender: Male
    • View Profile
    • MRatWork Forum
Semestinya yang dijalankan adalah 'sh /script/reset-mysql-root-password PASSWORDANDA; sh /script/fixmail-all'.

Jika tanpa menambahkan password (misalnya PASSWORDANDA) maka reset password akan membuat password menjadi null yang mana 'tidak diperbolehkan'.

Biarpun demikian, saya menemukan keanehan dimana jika menjalankan cleanup akan terjadi reset password ke null lagi sehingga akan bermasalah di fixmail-all.
..:: MRatWork (Mustafa Ramadhan Projects) ::..
-- Server/Web-integrator - Web Hosting (Kloxo-MR READY!) --

Offline hafidz

  • Valuable Member
  • *
  • Posts: 83
  • Karma: +0/-0
    • View Profile
yup.. jika di set mysql root password dan melakukan cleanup pasti terjadi error Access denied for user 'root'@'localhost' (using password: NO). Jadi belum terpacahkan keanehan di tempat saya ini dan login ke panel juga tidak bisa..

Offline MRatWork

  • Administrator
  • The Elite
  • *****
  • Posts: 15,807
  • Karma: +119/-11
  • Gender: Male
    • View Profile
    • MRatWork Forum
yup.. jika di set mysql root password dan melakukan cleanup pasti terjadi error Access denied for user 'root'@'localhost' (using password: NO). Jadi belum terpacahkan keanehan di tempat saya ini dan login ke panel juga tidak bisa..
Untuk sementara jangan pakai cleanup dulu.

Atau anda edit file '/usr/local/lxlabs/kloxo/httpdocs/lib/html/lib.php' dengan mengubah 'update_database();' menjadi '//update_database();'
..:: MRatWork (Mustafa Ramadhan Projects) ::..
-- Server/Web-integrator - Web Hosting (Kloxo-MR READY!) --

Offline hafidz

  • Valuable Member
  • *
  • Posts: 83
  • Karma: +0/-0
    • View Profile
untuk  'update_database();' sudah saya comment menjadi '//update_database();'. untuk masalahnya belum bisa login ke admin panel ya... jika login di redirect ke http://xxx.xxx.xxx.xxx:7778/lib/php/ dan tampil *** Token not match. No permit for remote login. Go back to login page ***

 


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

Page created in 0.076 seconds with 18 queries.

web stats analysis