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 Web Server
  • Search

PHPMyAdmin no longer working

Questions regarding the Web Server
Apache + Nginx, Nginx + PHP5-FPM
Post Reply
  • Print view
Advanced search
17 posts
  • 1
  • 2
  • Next
Tralapo
Posts: 23
Joined: Wed Oct 15, 2014 11:25 am

PHPMyAdmin no longer working
  • Quote

Post by Tralapo » Mon Dec 15, 2014 9:50 am

Hello, I was following this guide to secure phpmyadmin: viewtopic.php?f=10&t=5271&p=16831

I changed the /phpmyadmin alias like stated in that guide and forced the use of SSL in the config.inc.php. The other things in the guide I didn't do.

The new alias is indeed working and it's indeed sending me to the SSL version, but then I get an empty white page. It just does nothing and the page stays blank, also after several refreshes.

When I look at my errorlogs, I see:

Code: Select all

phpmyadmin: Failed to load /var/lib/phpmyadmin/blowfish_secret.inc.php Check group www-data has read access and open_basedir restrictions.
phpmyadmin: Failed to load /var/lib/phpmyadmin/config.inc.php Check group www-data has read access and open_basedir restrictions.
phpmyadmin: Failed to load /etc/phpmyadmin/config-db.php Check group www-data has read access and open_basedir restrictions.
PHP Fatal error:  require_once(): Failed opening required './libraries/php-gettext/gettext.inc' (include_path='.') in /usr/share/phpmyadmin/libraries/select_lang.lib.php on line 395
I tried the following to fix it because that seemed to be te problem. But after that, I keep getting the white page and the same errors.

Code: Select all

sudo chown -R www-data:www-data /usr/share/phpmyadmin
sudo chown -R www-data:www-data /var/lib/phpmyadmin
sudo chown -R www-data:www-data /etc/phpmyadmin
What am I doing wrong, did I miss something? Anybody had this before and know how to do it? I find it strange it just happens. I also tried re-installing PHPMyAdmin and downloading the config files from Vesta, but I keep getting that error?
Top

Tralapo
Posts: 23
Joined: Wed Oct 15, 2014 11:25 am

Re: PHPMyAdmin no longer working
  • Quote

Post by Tralapo » Tue Dec 16, 2014 4:30 pm

Nobody?
Top

saosangmo
Posts: 20
Joined: Sun Sep 21, 2014 2:27 pm
Contact:
Contact saosangmo
Website Google+

Os: Ubuntu 17x
Web: nginx + php-fpm
Re: PHPMyAdmin no longer working
  • Quote

Post by saosangmo » Tue Dec 16, 2014 6:09 pm

Did you care uppercase letters when use phpMyAdmin string?
Top

Tralapo
Posts: 23
Joined: Wed Oct 15, 2014 11:25 am

Re: PHPMyAdmin no longer working
  • Quote

Post by Tralapo » Tue Dec 16, 2014 6:11 pm

saosangmo wrote:Did you care uppercase letters when use phpMyAdmin string?
What do you mean? In Ubuntu none of the phpmyadmin folders uses uppercase letters.
Top

saosangmo
Posts: 20
Joined: Sun Sep 21, 2014 2:27 pm
Contact:
Contact saosangmo
Website Google+

Os: Ubuntu 17x
Web: nginx + php-fpm
Re: PHPMyAdmin no longer working
  • Quote

Post by saosangmo » Tue Dec 16, 2014 6:23 pm

But PHP cares uppercase and lowercase letters.
Top

Tralapo
Posts: 23
Joined: Wed Oct 15, 2014 11:25 am

Re: PHPMyAdmin no longer working
  • Quote

Post by Tralapo » Tue Dec 16, 2014 6:28 pm

saosangmo wrote:But PHP cares uppercase and lowercase letters.
I don't know where you're going?
Top

saosangmo
Posts: 20
Joined: Sun Sep 21, 2014 2:27 pm
Contact:
Contact saosangmo
Website Google+

Os: Ubuntu 17x
Web: nginx + php-fpm
Re: PHPMyAdmin no longer working
  • Quote

Post by saosangmo » Tue Dec 16, 2014 7:02 pm

Do you review and try to edit step 2,3 in that post?

phpMyAdmin is written in PHP language and I think you have some missing typo.

Code: Select all

phpmyadmin: Failed to load /var/lib/phpmyadmin/blowfish_secret.inc.php Check group www-data has read access and open_basedir restrictions.
phpmyadmin: Failed to load /var/lib/phpmyadmin/config.inc.php Check group www-data has read access and open_basedir restrictions.
phpmyadmin: Failed to load /etc/phpmyadmin/config-db.php Check group www-data has read access and open_basedir restrictions.
The above lines means your system try to search files in the shared system folders which PHP usually uses.
Top

Tralapo
Posts: 23
Joined: Wed Oct 15, 2014 11:25 am

Re: PHPMyAdmin no longer working
  • Quote

Post by Tralapo » Tue Dec 16, 2014 7:09 pm

saosangmo wrote:Do you review and try to edit step 2,3 in that post?

phpMyAdmin is written in PHP language and I think you have some missing typo.

Code: Select all

phpmyadmin: Failed to load /var/lib/phpmyadmin/blowfish_secret.inc.php Check group www-data has read access and open_basedir restrictions.
phpmyadmin: Failed to load /var/lib/phpmyadmin/config.inc.php Check group www-data has read access and open_basedir restrictions.
phpmyadmin: Failed to load /etc/phpmyadmin/config-db.php Check group www-data has read access and open_basedir restrictions.
The above lines means your system try to search files in the shared system folders which PHP usually uses.
I'm sorry, but I seriously don't understand what you're saying. Is it possible for you to use more words? Step 2,3??

To be clear: from the guide I linked in my first post, I only did the "Change the default /phpmyadmin alias to something like /phpmyadmin-vcn0vgu02j0239f" and "Force SSL Connection on phpmyadmin" parts, NOT the other things, like editing /etc/apache2/conf.d/phpMyAdmin.conf

And, like I also said: I installed phpMyadmin again and downloaded the Vesta config files from the Vesta server. That didn t help and means a typo can't be the problem. Because if it was, it would have been solved by downloading the original config files again.
Top

saosangmo
Posts: 20
Joined: Sun Sep 21, 2014 2:27 pm
Contact:
Contact saosangmo
Website Google+

Os: Ubuntu 17x
Web: nginx + php-fpm
Re: PHPMyAdmin no longer working
  • Quote

Post by saosangmo » Tue Dec 16, 2014 7:20 pm

Could you post the content of /home/admin/conf/web/shttpd.conf file?

You MUST edit 2 files:
/etc/httpd/conf.d/phpMyAdmin.conf and /home/admin/conf/web/shttpd.conf

Before creating config.inc.php file in /usr/share/phpMyAdmin with the content

Code: Select all

<?php $cfg['ForceSSL'] = true; ?>
https://vipsedan.vn dell xps
Last edited by saosangmo on Sun Jul 14, 2019 5:28 pm, edited 1 time in total.
Top

Tralapo
Posts: 23
Joined: Wed Oct 15, 2014 11:25 am

Re: PHPMyAdmin no longer working
  • Quote

Post by Tralapo » Tue Dec 16, 2014 7:34 pm

saosangmo wrote:Could you post the content of /home/admin/conf/web/shttpd.conf file?

You MUST edit 2 files:
/etc/httpd/conf.d/phpMyAdmin.conf and /home/admin/conf/web/shttpd.conf

Before creating config.inc.php file in /usr/share/phpMyAdmin with the content

Code: Select all

<?php $cfg['ForceSSL'] = true; ?>
/home/admin/conf/web has no files. I do not host any website with the admin account.

I was wondering, in the guide I see in the other step it says:
edit /etc/httpd/conf.d/phpMyAdmin.conf (centos 6) and delete the following (see below) and save

Code: Select all

Alias /phpMyAdmin /usr/share/phpMyAdmin
Alias /phpmyadmin /usr/share/phpMyAdmin

<Directory /usr/share/phpMyAdmin/>
   Order Deny,Allow
   Deny from All
   Allow from All
</Directory>

<Directory /usr/share/phpMyAdmin/scripts/>
   Order Deny,Allow
   Deny from All
   Allow from All
</Directory>
I did not do that, because /etc/apache2/conf.d/phpmyadmin.conf looks completely different. It doesn't even name the same directories. Mine looks like this:

Code: Select all

Alias /mynewphpalias /usr/share/phpmyadmin

<Directory /usr/share/phpmyadmin>
        Options FollowSymLinks
        DirectoryIndex index.php

        <IfModule mod_php5.c>
                AddType application/x-httpd-php .php

                php_flag magic_quotes_gpc Off
                php_flag track_vars On
                php_flag register_globals Off
                php_admin_flag allow_url_fopen Off
                php_value include_path .
                php_admin_value upload_tmp_dir /var/lib/phpmyadmin/tmp
                php_admin_value open_basedir /usr/share/phpmyadmin/:/etc/phpmyadmin/:/var/$
        </IfModule>

</Directory>

# Authorize for setup
<Directory /usr/share/phpmyadmin/setup>
    <IfModule mod_authn_file.c>
    AuthType Basic
    AuthName "phpMyAdmin Setup"
    AuthUserFile /etc/phpmyadmin/htpasswd.setup
    </IfModule>
    Require valid-user
</Directory>

# Disallow web access to directories that don't need it
<Directory /usr/share/phpmyadmin/libraries>
    Order Deny,Allow
    Deny from All
</Directory>
<Directory /usr/share/phpmyadmin/setup/lib>
    Order Deny,Allow
    Deny from All
</Directory>
Top


Post Reply
  • Print view

17 posts
  • 1
  • 2
  • Next

Return to “Web 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