MRatWork Forum by Mustafa Ramadhan

Sawo Project - Kloxo-MR Discussions => Kloxo-MR Technical Helps => Topic started by: ace674 on 2017-04-21, 15:07:03

Title: Can't login into phpMyAdmin anymore
Post by: ace674 on 2017-04-21, 15:07:03
Hello,

I can no longer log into phpMyAdmin. Everytime I try to login using the "SQL Manager" shortcut in the panel, it just returns the login screen. When I try to login with the root db or  any user db, the login screen just returns. Can anybody advise what this might be. Only started happening a few days ago. I have run several of the sh fix commands to no avail.

ace674.
Title: Re: Can't login into phpMyAdmin anymore
Post by: MRatWork on 2017-04-21, 15:14:33
Try change mysql root password via 'admin > reset mysql password' or via ssh with 'sh /script/reset-mysql-root-password'.
Title: Re: Can't login into phpMyAdmin anymore
Post by: ace674 on 2017-04-21, 15:46:17
That did not work I'm afraid, the results are the same.
Title: Re: Can't login into phpMyAdmin anymore
Post by: MRatWork on 2017-04-21, 15:47:47
Inform here 'sh /script/sysinfo'.
Title: Re: Can't login into phpMyAdmin anymore
Post by: ace674 on 2017-04-21, 16:51:22
Here it is:

Code: [Select]
A. Control Panel:               
   - Kloxo-MR: 7.0.0.c-2017042101
   - Web: hiawatha-10.5.0-f.2.mr.el6.x86_64
   - PHP: php54s-5.4.45-1.ius.centos6 (fpm mode)
B. Plateform:
   - OS: CentOS release 6.9 (Final) x86_64
   - Hostname: hostingrent.info
C. Services:
   1. MySQL: MariaDB-server-10.0.30-1.el6.x86_64
   2. PHP:
      - Installed:
        - Branch: php56w-cli-5.6.30-1.w6.x86_64
        - Multiple:
          * php52m-5.2.17-102.mr.el6
          * php53m-5.3.29-1.ius.centos6
          * php54m-5.4.45-1.ius.centos6
          * php55m-5.5.38-1.ius.centos6
          * php56m-5.6.30-2.ius.centos6
          * php70m-7.0.17-1.ius.centos6
          * php71m-7.1.3-1.ius.centos6
      - Used: php56m-fpm
      - Multiple: disable
   3. Web Used: apache
     - Hiawatha: hiawatha-10.5.0-f.2.mr.el6.x86_64
     - Lighttpd: lighttpd-1.4.45-1.el6.x86_64
     - Nginx: nginx-1.12.0-1.el6.ngx.x86_64
     - Apache: httpd-2.2.31-1.mr.el6.x86_64
       - PHP Type: php-fpm_event
       - Secondary PHP: off
   4. WebCache: none
     - ATS: --uninstalled--
     - Squid: --uninstalled--
     - Varnish: varnish-3.0.7-1.el6.x86_64
   5. Dns: bind
     - Bind: bind-9.9.9-1.mr.el6.x86_64
     - DJBDns: djbdns-1.05-17.4.mr.el6.x86_64
     - NSD: nsd-4.1.14-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: none
      - smtp: none
      - 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.5-1.mr.noarch
D. Memory:
             total       used       free     shared    buffers     cached
Mem:          7999        608       7391          2         49        197
-/+ buffers/cache:        361       7638
Swap:         8191          0       8191
E. Disk Space:
Filesystem      Size  Used Avail Use% Mounted on
/dev/vda1       288G   43G  231G  16% /


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

* Note: run 'sh /script/sysinfo -y' if you want run 'fix-service-list' also
        (importance after Kloxo-MR update)
Title: Re: Can't login into phpMyAdmin anymore
Post by: MRatWork on 2017-04-21, 17:20:57
Try 'sh /script/phpm-installer php56s; sh /script/fixlxphpexe php56s; sh /script/restart'.
Title: Re: Can't login into phpMyAdmin anymore
Post by: ace674 on 2017-04-24, 11:28:22
I did that but with no success; still the same result. I'm hoping I won't have to do a complete reinstall.
Title: Re: Can't login into phpMyAdmin anymore
Post by: MRatWork on 2017-04-24, 11:42:20
Try reinstall with 'yum reinstall *phpmyadmin* -y'.
Title: Re: Can't login into phpMyAdmin anymore
Post by: ace674 on 2017-04-24, 15:33:06
Didn't work either, sorry! :(
Title: Re: Can't login into phpMyAdmin anymore
Post by: MRatWork on 2017-04-24, 15:40:19
Ok, give me your ssh and panel access. Send via PM.
Title: Re: Can't login into phpMyAdmin anymore
Post by: ace674 on 2017-04-24, 15:54:22
Done.
Title: Re: Can't login into phpMyAdmin anymore
Post by: MRatWork on 2017-04-24, 16:08:04
I didn't found any issues if access to phpmyadmin (from panel) or login manually (enter root and root password).

Try clear browser cache and history. Or try using new browser.
Title: Re: Can't login into phpMyAdmin anymore
Post by: ace674 on 2017-04-25, 10:53:54
After doing that, I found you were correct. Thank you for being so helpful in this regard and quick to respond. Your panel is the best I have found so far! :)