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. 2017-11-07, 22:57:11

Author Topic: myphpadmin asks for user/pass instead of login automatically  (Read 2333 times)

0 Members and 1 Guest are viewing this topic.

Offline crossing

  • Senior Member
  • *
  • Posts: 336
  • Karma: +0/-0
    • View Profile
I changed mysql pass using 'Database Admins' and since then each time I access myphpadmin it asks for user/pass http://postimg.org/image/dttn88qlt/. I need to automatically login as it was initially.

Seen this problem I changed kloxo.pass content with new password, then 'service mysqld restart' ,  but still the same.
« Last Edit: 1970-01-01, 01:00:00 by Guest »
Kloxo-MR -> Great Panel ->  Great person behind it ->  Mustafa

Offline chrisf

  • Senior Master
  • **
  • Posts: 883
  • Karma: +11/-1
  • Gender: Male
  • Be the change that you wish to see in the world.
    • View Profile
    • Conviction's Hosting
Re: myphpadmin asks for user/pass instead of login automatic
« Reply #1 on: 2013-08-24, 13:21:37 »
Login to phpadmin as root (using root password you changed to)

Click database: kloxo
click table: dbadmin

Find the row for root (will be the only one if you have not added any database admins) find the password column and edit it to your new password for root.

Fixed :)
« Last Edit: 1970-01-01, 01:00:00 by Guest »
Christopher

Knowledge in: PHP, Perl, MySQL, Javascript, Actionscript, FLASH, HTML, CSS
Server Administrator / Developer: https://convictionshosting.com

Offline crossing

  • Senior Member
  • *
  • Posts: 336
  • Karma: +0/-0
    • View Profile
Re: myphpadmin asks for user/pass instead of login automatic
« Reply #2 on: 2013-08-24, 19:21:38 »
It is exactly the same as my root pass ( even copy/paste it on pass field to be sure and works) and still not work, when click ony myphpadmin I get http://postimg.org/image/vf1g9unal/.
« Last Edit: 1970-01-01, 01:00:00 by Guest »
Kloxo-MR -> Great Panel ->  Great person behind it ->  Mustafa

Offline chrisf

  • Senior Master
  • **
  • Posts: 883
  • Karma: +11/-1
  • Gender: Male
  • Be the change that you wish to see in the world.
    • View Profile
    • Conviction's Hosting
Re: myphpadmin asks for user/pass instead of login automatic
« Reply #3 on: 2013-08-24, 19:27:36 »
Hmmm....
« Last Edit: 1970-01-01, 01:00:00 by Guest »
Christopher

Knowledge in: PHP, Perl, MySQL, Javascript, Actionscript, FLASH, HTML, CSS
Server Administrator / Developer: https://convictionshosting.com

Offline MRatWork

  • Administrator
  • The Elite
  • *****
  • Posts: 15,381
  • Karma: +112/-9
  • Gender: Male
    • View Profile
    • MRatWork Forum
Re: myphpadmin asks for user/pass instead of login automatic
« Reply #4 on: 2013-08-24, 19:33:31 »
Kloxo-MR panel open phpmyadmin via cookie-based mechanism. Sometimes, clear browser cache and reboot browser will be fix your issue
« Last Edit: 1970-01-01, 01:00:00 by Guest »
..:: MRatWork (Mustafa Ramadhan Projects) ::..
-- Server/Web-integrator - Web Hosting (Kloxo-MR READY!) --

Offline crossing

  • Senior Member
  • *
  • Posts: 336
  • Karma: +0/-0
    • View Profile
Re: myphpadmin asks for user/pass instead of login automatic
« Reply #5 on: 2013-08-24, 23:00:29 »
Its not working, I cleared all catched on all browser. As seen in screeshoot it looks like when I access myphpamin its using wrong credentials http://postimg.org/image/vf1g9unal/.
« Last Edit: 1970-01-01, 01:00:00 by Guest »
Kloxo-MR -> Great Panel ->  Great person behind it ->  Mustafa

Offline crossing

  • Senior Member
  • *
  • Posts: 336
  • Karma: +0/-0
    • View Profile
Re: myphpadmin asks for user/pass instead of login automatic
« Reply #6 on: 2013-08-24, 23:08:31 »
I wonder if changing pass inside  '/usr/local/lxlabs/kloxo/etc/conf/kloxo.pass' with mysql password did any harm ?
« Last Edit: 1970-01-01, 01:00:00 by Guest »
Kloxo-MR -> Great Panel ->  Great person behind it ->  Mustafa

Offline MRatWork

  • Administrator
  • The Elite
  • *****
  • Posts: 15,381
  • Karma: +112/-9
  • Gender: Male
    • View Profile
    • MRatWork Forum
Re: myphpadmin asks for user/pass instead of login automatic
« Reply #7 on: 2013-08-25, 00:04:42 »
kloxo.pass content password for kloxo database. Root password for database inside dbadmin.
« Last Edit: 1970-01-01, 01:00:00 by Guest »
..:: MRatWork (Mustafa Ramadhan Projects) ::..
-- Server/Web-integrator - Web Hosting (Kloxo-MR READY!) --

Offline crossing

  • Senior Member
  • *
  • Posts: 336
  • Karma: +0/-0
    • View Profile
Re: myphpadmin asks for user/pass instead of login automatic
« Reply #8 on: 2013-08-25, 00:46:45 »
Any other command can fix my problem ? Or some file to check ?
« Last Edit: 1970-01-01, 01:00:00 by Guest »
Kloxo-MR -> Great Panel ->  Great person behind it ->  Mustafa

Offline crossing

  • Senior Member
  • *
  • Posts: 336
  • Karma: +0/-0
    • View Profile
Re: myphpadmin asks for user/pass instead of login automatic
« Reply #9 on: 2013-08-25, 01:19:33 »
« Last Edit: 1970-01-01, 01:00:00 by Guest »
Kloxo-MR -> Great Panel ->  Great person behind it ->  Mustafa

Offline crossing

  • Senior Member
  • *
  • Posts: 336
  • Karma: +0/-0
    • View Profile
Re: myphpadmin asks for user/pass instead of login automatic
« Reply #10 on: 2013-08-25, 02:18:33 »
I followed this Mustafa tutorial 'adventure' to fix the the problem :

Quote from: "MRatWork"
There are something wrong for Kloxo-MR in Centos 6.

In my experience, better update mysql to mariadb from centalt with follow:

1. Change /etc/yum.repos.d/kloxo-mr.repo:

from:
Code: [Select]
[kloxo-mr-centalt]
name=Kloxo-MR - centalt - $basearch
baseurl=http://centos.alt.ru/repository/centos/$releasever/$basearch/
mirrorlist=http://rpms.potissima.com/repo/mirrors/centalt-centos-$releasever-$basearch-mirrors.txt
enabled=1
gpgcheck=0
exclude=openssh* perl* mariadb*
to:
Code: [Select]
[kloxo-mr-centalt]
name=Kloxo-MR - centalt - $basearch
baseurl=http://centos.alt.ru/repository/centos/$releasever/$basearch/
mirrorlist=http://rpms.potissima.com/repo/mirrors/centalt-centos-$releasever-$basearch-mirrors.txt
enabled=1
gpgcheck=0
exclude=openssh* perl*

2. Run:
Code: [Select]
yum clean all
yum update

3. copy '/etc/my.cnf.rpmsave' to '/etc/my.cnf.d/my.cnf'.

4. Restart mysql with 'service mysqld restart'.

Than I got 'Could not open database connection' then fix it with this Mustafa solution from http://forum.lxcenter.org/index.php?t=msg&th=15343:

http://forum.lxcenter.org/index.php?t=msg&th=15343

Quote from: " mustafaramadhan"
Ok.

Run PHPMyAdmin and then click 'Priviliges'. Click action at 'kloxo' user. Click 'check all' at 'Global privileges' and type new password at 'Password'.

Or (from ssh):
Code: [Select all] [Show/ hide]
mysql -u root -p
mysql> grant all on kloxo.* to kloxo@localhost identified by '{new password}';
mysql> flush privileges;
mysql> quit


End then (from ssh):
Code: [Select all] [Show/ hide]
cat "{new password}" > /usr/local/lxlabs/kloxo/etc/conf/kloxo.pass
sh /script/restart


Note: change {new password} with your new password.

Now I can login automatically when access phpmyadmin but 'mysql>' is changed to 'MariaDB [(none)]>'.
Was this related as you said Mustafa due to CentOS 6.4 (my case too) ? I did wrong ? Should I restore all things back ?
« Last Edit: 1970-01-01, 01:00:00 by Guest »
Kloxo-MR -> Great Panel ->  Great person behind it ->  Mustafa

Offline crossing

  • Senior Member
  • *
  • Posts: 336
  • Karma: +0/-0
    • View Profile
Re: myphpadmin asks for user/pass instead of login automatic
« Reply #11 on: 2013-08-25, 02:31:54 »
I have tried to reverse the process now by adding back 'mariadb*' to '/etc/yum.repos.d/kloxo-mr.repo' and all steps but it does not go back to mysql.
« Last Edit: 1970-01-01, 01:00:00 by Guest »
Kloxo-MR -> Great Panel ->  Great person behind it ->  Mustafa

 


MRatWork Affiliates:    BIGRAF(R) Inc.    House of LMAR    EFARgrafix

Page created in 0.056 seconds with 18 queries.

web stats analysis
 
Mirror created by MasterkinG32.CoM