Vesta Control Panel - Forum

Community Forum

Skip to content

Advanced search
  • Quick links
    • Main site
    • Github repo
    • Google Search
  • FAQ
  • Login
  • Register
  • Board index Main Section Database Server
  • Search

phpMyAdmin error on login screen - cannot login

Questions regarding the Database Server
MySQL, PostgreSQL, MariaDB, Percona Server, phpMyAdmin, phpPgAdmin
Post Reply
  • Print view
Advanced search
30 posts
  • Previous
  • 1
  • 2
  • 3
blackyangell
Posts: 12
Joined: Mon May 19, 2014 6:11 am

Os: CentOS 6x
Web: nginx + php-fpm
Re: phpMyAdmin error on login screen - cannot login
  • Quote

Post by blackyangell » Wed Apr 15, 2015 1:38 pm

I had the same problem (CentOS 6.4). Everything is updated with 'yum update'.

'chmod 777 /var/lib/php/session' helps to solve this problem. But can it cause any security issues?
Top

skurudo
VestaCP Team
Posts: 8099
Joined: Fri Dec 26, 2014 2:23 pm
Contact:
Contact skurudo
Website Facebook Google+ Skype
Twitter

Re: phpMyAdmin error on login screen - cannot login
  • Quote

Post by skurudo » Wed Apr 15, 2015 2:25 pm

blackyangell wrote:I had the same problem (CentOS 6.4). Everything is updated with 'yum update'.
'chmod 777 /var/lib/php/session' helps to solve this problem. But can it cause any security issues?
It's all recommended method - if you still worry. try to change permissions to 775 / 770
Top

7thkey
Posts: 8
Joined: Wed Aug 06, 2014 4:49 pm

Re: phpMyAdmin error on login screen - cannot login
  • Quote

Post by 7thkey » Wed Jun 10, 2015 5:37 pm

I still get the blowfish_secret warning inside panel. Any ideas?

chmod 777 /var/lib/php/session/ did the trick to solve the login screen error.
Top

cmroanirgo
Posts: 3
Joined: Fri Jun 12, 2015 1:45 pm

Re: phpMyAdmin error on login screen - cannot login
  • Quote

Post by cmroanirgo » Fri Jun 12, 2015 1:54 pm

I'm not sure if this information is relevant to you all, but check out Stack Overflow: http://stackoverflow.com/questions/3694 ... phpmyadmin

If that bug sounds like you, then read on:

EDIT: Read my next comment, which is a better fix (& fixes a slew of other problems on a blank vestacp install): viewtopic.php?f=14&t=7500&p=28169#p28169
Last edited by cmroanirgo on Sat Jun 13, 2015 2:51 am, edited 1 time in total.
Top

cmroanirgo
Posts: 3
Joined: Fri Jun 12, 2015 1:45 pm

Re: phpMyAdmin error on login screen - cannot login
  • Quote

Post by cmroanirgo » Sat Jun 13, 2015 2:49 am

If, like me you are running Ubuntu 14.04 (& probably others), and having DB issues with "can't login", then the problem seems to be due to the mysql config missing a "bind-address" setting.

Edit /etc/mysql/my.cnf and add the missing "bind-address" line to the [mysqld] section:

Code: Select all

[mysqld]
...
bind-address            = 127.0.0.1
...
After making the change, don't forget to restart mysql:

Code: Select all

sudo service mysql restart
This fixes 3 issues in one go:
1. can't login to myphpadmin
2. roundcube "DATABASE ERROR"
3. can't create a DB from the vestacp

PS: This bug appears when you install vestacp on a blank ubuntu machine (ie nothing installed, but maybe openssh).
Top

kandalf
Posts: 87
Joined: Tue May 13, 2014 11:53 pm

Re: phpMyAdmin error on login screen - cannot login
  • Quote

Post by kandalf » Thu Jun 18, 2015 10:39 pm

I have exactly the same problem with the session. And after fix the issue I found this post with the same fix. I lose an hour because I don't do a search here in this forum :/
Top

arafatx
Posts: 25
Joined: Tue Aug 11, 2015 4:51 pm

Re: phpMyAdmin error on login screen - cannot login
  • Quote

Post by arafatx » Tue Aug 11, 2015 5:05 pm

I solved this problem without chmod the sesion folder to 777. Please correct me if I'm wrong here:

I think during installation of VestaCP, some of the configuration files were set to belong to admin owner. So, I changed the session folder to owner 'admin' and it works.

This method works for the blowfish part too. The configuration file, /etc/phpMyAdmin/config.inc.php need to be admin owner from the folder phpMyAdmin.
Last edited by arafatx on Wed Aug 12, 2015 4:05 am, edited 1 time in total.
Top

skurudo
VestaCP Team
Posts: 8099
Joined: Fri Dec 26, 2014 2:23 pm
Contact:
Contact skurudo
Website Facebook Google+ Skype
Twitter

Re: phpMyAdmin error on login screen - cannot login
  • Quote

Post by skurudo » Tue Aug 11, 2015 10:32 pm

arafatx wrote:I solved this problem without chmod the sesion folder to 777. Please correct me if I'm wrong here:
I think during installation of VestaCP, some of the configuration files were set to belong to admin owner. So, I changed the session folder to owner 'admin' and it works.
Something like this. With installation/upgrade latest phpmyadmin from repo appear this bug (in centos/rhel only). Debian/Ubuntu not have this bug.
Top

arafatx
Posts: 25
Joined: Tue Aug 11, 2015 4:51 pm

Re: phpMyAdmin error on login screen - cannot login
  • Quote

Post by arafatx » Wed Aug 12, 2015 4:02 am

skurudo wrote:
arafatx wrote:I solved this problem without chmod the sesion folder to 777. Please correct me if I'm wrong here:
I think during installation of VestaCP, some of the configuration files were set to belong to admin owner. So, I changed the session folder to owner 'admin' and it works.
Something like this. With installation/upgrade latest phpmyadmin from repo appear this bug (in centos/rhel only). Debian/Ubuntu not have this bug.
When this bug will be fixed? I love VestaCP a lot.
Top

skurudo
VestaCP Team
Posts: 8099
Joined: Fri Dec 26, 2014 2:23 pm
Contact:
Contact skurudo
Website Facebook Google+ Skype
Twitter

Re: phpMyAdmin error on login screen - cannot login
  • Quote

Post by skurudo » Wed Aug 12, 2015 6:45 am

arafatx wrote: When this bug will be fixed? I love VestaCP a lot.
Dunno, may be with new update phpmyadmin.
Top


Post Reply
  • Print view

30 posts
  • Previous
  • 1
  • 2
  • 3

Return to “Database Server”



  • Board index
  • All times are UTC
  • Delete all board cookies
  • The team
Powered by phpBB® Forum Software © phpBB Limited
*Original Author: Brad Veryard
*Updated to 3.2 by MannixMD
 

 

Login  •  Register

I forgot my password