can't login to phpmyadmin

Having issues with your DietPi installation, or, found a bug? Post it here.
dzooky
Posts: 12
Joined: Wed Jun 20, 2018 10:58 pm

can't login to phpmyadmin

Post by dzooky »

Hi guys

I'm newbie here. I have installed DietPi on my RPi3 with LEAP + phpmyadmin but I can't login there.
I tried user phpmyadmin with right password but I can't. While I'm login in there is no error message only refresh login page.

Same is also if I will create new user from command line.

Thanks for help
User avatar
johnvick
Legend
Posts: 693
Joined: Wed Jun 08, 2016 11:53 am
Location: New Zealand

Re: can't login to phpmyadmin

Post by johnvick »

I think the new user needs root privileges to be able to login - if you haven't tried this do so. You cannot login as root hence need to create new user.

John
dzooky
Posts: 12
Joined: Wed Jun 20, 2018 10:58 pm

Re: can't login to phpmyadmin

Post by dzooky »

I'm not sure if I need root rights.
Then I install Adminer and there it works fine.
So probably there is problem with installation of phpMyAdmin or with settings.
User avatar
MichaIng
Site Admin
Posts: 2419
Joined: Sat Nov 18, 2017 6:21 pm

Re: can't login to phpmyadmin

Post by MichaIng »

Indeed the MariaDB unix_socket authentication prevents other users to login to MariaDB root user.

Thus for phpMyAdmin our install script creates a new user "phpmyadmin" with full database permissions to use for login. Password is by default the one for new software installations you were ask to change on v6.9 update.
dzooky
Posts: 12
Joined: Wed Jun 20, 2018 10:58 pm

Re: can't login to phpmyadmin

Post by dzooky »

Yes I've changed my password but as I said after click on login it will reload login page.
User avatar
MichaIng
Site Admin
Posts: 2419
Joined: Sat Nov 18, 2017 6:21 pm

Re: can't login to phpmyadmin

Post by MichaIng »

Sorry I did not read your initial post carefully. I will try to replicate later.

Could you meanwhile post results of:
tail /var/log/php7.0-fpm.log
tail /var/log/nginx/error.log
journalctl -f -t mysqld
right after login attempt? Not 100% sure about the nginx log location, in case have a look into the log directory, where exactly it is placed.

Also the browser console might give a hint. Did you try login with a different browser?
dzooky
Posts: 12
Joined: Wed Jun 20, 2018 10:58 pm

Re: can't login to phpmyadmin

Post by dzooky »

I check logs but there is nothing regarding this.
I must find where is nginx log.
dzooky
Posts: 12
Joined: Wed Jun 20, 2018 10:58 pm

Re: can't login to phpmyadmin

Post by dzooky »

Another step.
I've downloaded phpmyadmin from webe and after login there is message: Failed to set session cookie. Maybe you are using HTTP instead of HTTPS to access phpMyAdmin.

So problem will be with configuration of mphMyAdmin
User avatar
MichaIng
Site Admin
Posts: 2419
Joined: Sat Nov 18, 2017 6:21 pm

Re: can't login to phpmyadmin

Post by MichaIng »

Hmm, looks like an issue on phpMyAdmin side: https://github.com/phpmyadmin/phpmyadmin/issues/14184

But this error didn't show up in the first place?

Did you setup HTTPS/SSL connection? It looks like there are issues, if you switch from HTTP to HTTPS and backwards, thus automated redirection to HTTPS would be needed in this case, that you cannot connect via HTTP any more, once the secure cookie was set.

Of course that means, that you could test to remove the cookies for you phpMyAdmin site and retry.

Nginx perhaps also logs to syslog/journald, you could check:
journalctl -t nginx
journalctl -u nginx
dzooky
Posts: 12
Joined: Wed Jun 20, 2018 10:58 pm

Re: can't login to phpmyadmin

Post by dzooky »

No actually I have only unsecure HTTP but under Firefox is working, only in opera it doesnt work.
Post Reply