MRatWork Forum by Mustafa Ramadhan - Access denied for user 'kloxo'@'localhost' (using password: YES)

Sponsor:
Server and Web Integrator
Link:
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:

MRatWork Forum | Please login or register. | 2017-11-07, 15:23:23

- MRatWork Forum by Mustafa Ramadhan »
- Language Specific Discussions »
- Indonesia Users »
- Access denied for user 'kloxo'@'localhost' (using password: YES)

« previous next »

- Print

Pages: [1] 2 Go Down

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

0 Members and 1 Guest are viewing this topic.

#### hafidz

- Valuable Member
- Posts: 83
- Karma: +0/-0

##### Access denied for user 'kloxo'@'localhost' (using password: YES)

« on: 2017-07-26, 12:28:28 »
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..
Logged

#### MRatWork

- Administrator
- The Elite
- Posts: 15,381
- Karma: +112/-9
- Gender:

##### Re: Access denied for user 'kloxo'@'localhost' (using password: YES)

« Reply #1 on: 2017-07-26, 12:59:00 »
Coba 'sh /script/reset-mysql-kloxo-password'.
Logged
..:: MRatWork (Mustafa Ramadhan Projects) ::..
-- Server/Web-integrator - Web Hosting (Kloxo-MR READY!) --

#### hafidz

- Valuable Member
- Posts: 83
- Karma: +0/-0

##### Re: Access denied for user 'kloxo'@'localhost' (using password: YES)

« Reply #2 on: 2017-07-26, 13:10:59 »
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 kloxo-mr-releases-and-announcementstip-reset-password.html dan kembali melakukan 'sh /script/cleanup' namun hasilnya masih tetap sama..
Logged

#### MRatWork

- Administrator
- The Elite
- Posts: 15,381
- Karma: +112/-9
- Gender:

##### Re: Access denied for user 'kloxo'@'localhost' (using password: YES)

« Reply #3 on: 2017-07-26, 13:18:55 »
Maksudnya sudah jalankan 'sh /script/reset-mysql-root-password'?.
Logged
..:: MRatWork (Mustafa Ramadhan Projects) ::..
-- Server/Web-integrator - Web Hosting (Kloxo-MR READY!) --

#### hafidz

- Valuable Member
- Posts: 83
- Karma: +0/-0

##### Re: Access denied for user 'kloxo'@'localhost' (using password: YES)

« Reply #4 on: 2017-07-26, 13:42:09 »
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:

Logged

#### MRatWork

- Administrator
- The Elite
- Posts: 15,381
- Karma: +112/-9
- Gender:

##### Re: Access denied for user 'kloxo'@'localhost' (using password: YES)

« Reply #5 on: 2017-07-26, 13:46:25 »
Coba lakukan reset-mysql-root-password dan fixmail-all saja (tanpa cleanup).
Logged
..:: MRatWork (Mustafa Ramadhan Projects) ::..
-- Server/Web-integrator - Web Hosting (Kloxo-MR READY!) --

#### hafidz

- Valuable Member
- Posts: 83
- Karma: +0/-0

##### Re: Access denied for user 'kloxo'@'localhost' (using password: YES)

« Reply #6 on: 2017-07-26, 13:56:22 »
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:

Logged

#### MRatWork

- Administrator
- The Elite
- Posts: 15,381
- Karma: +112/-9
- Gender:

##### Re: Access denied for user 'kloxo'@'localhost' (using password: YES)

« Reply #7 on: 2017-07-26, 14:00:02 »
Coba reboot dan ulangi process.
Logged
..:: MRatWork (Mustafa Ramadhan Projects) ::..
-- Server/Web-integrator - Web Hosting (Kloxo-MR READY!) --

#### hafidz

- Valuable Member
- Posts: 83
- Karma: +0/-0

##### Re: Access denied for user 'kloxo'@'localhost' (using password: YES)

« Reply #8 on: 2017-07-26, 14:11:52 »
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:

Logged

#### MRatWork

- Administrator
- The Elite
- Posts: 15,381
- Karma: +112/-9
- Gender:

##### Re: Access denied for user 'kloxo'@'localhost' (using password: YES)

« Reply #9 on: 2017-07-26, 14:25:03 »
OK, beri saya akses ke ssh dan panel anda.
Logged
..:: MRatWork (Mustafa Ramadhan Projects) ::..
-- Server/Web-integrator - Web Hosting (Kloxo-MR READY!) --

#### hafidz

- Valuable Member
- Posts: 83
- Karma: +0/-0

##### Re: Access denied for user 'kloxo'@'localhost' (using password: YES)

« Reply #10 on: 2017-07-26, 14:29:46 »
baik mas, sudah saya kirim pm untuk akunnya..
Logged

#### MRatWork

- Administrator
- The Elite
- Posts: 15,381
- Karma: +112/-9
- Gender:

##### Re: Access denied for user 'kloxo'@'localhost' (using password: YES)

« Reply #11 on: 2017-07-26, 15:08:46 »
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.
Logged
..:: MRatWork (Mustafa Ramadhan Projects) ::..
-- Server/Web-integrator - Web Hosting (Kloxo-MR READY!) --

#### hafidz

- Valuable Member
- Posts: 83
- Karma: +0/-0

##### Re: Access denied for user 'kloxo'@'localhost' (using password: YES)

« Reply #12 on: 2017-07-26, 15:20:01 »
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..
Logged

#### MRatWork

- Administrator
- The Elite
- Posts: 15,381
- Karma: +112/-9
- Gender:

##### Re: Access denied for user 'kloxo'@'localhost' (using password: YES)

« Reply #13 on: 2017-07-26, 15:27:57 »
Quote from: hafidz on 2017-07-26, 15:20:01

> 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();'
Logged
..:: MRatWork (Mustafa Ramadhan Projects) ::..
-- Server/Web-integrator - Web Hosting (Kloxo-MR READY!) --

#### hafidz

- Valuable Member
- Posts: 83
- Karma: +0/-0

##### Re: Access denied for user 'kloxo'@'localhost' (using password: YES)

« Reply #14 on: 2017-07-26, 15:38:48 »
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 ***
Logged

- Print

Pages: [1] 2 Go Up
« previous next »

- MRatWork Forum by Mustafa Ramadhan »
- Language Specific Discussions »
- Indonesia Users »
- Access denied for user 'kloxo'@'localhost' (using password: YES)

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

- Design By SMFSimple.com
- SMF 2.0.14 | SMF © 2017, Simple Machines

Page created in 0.052 seconds with 17 queries.

Mirror created by MasterkinG32.CoM