Page 2 of 2
Re: PHPMyAdmin no longer working
Posted: Tue Dec 16, 2014 7:47 pm
by saosangmo
Did you try to edit file /home/admin/conf/web/sapache2.conf and paste the following (see below) before this line </VirtualHost> and save
Code: Select all
Alias /phpmyadmins-GENERATE-RANDOM-PASS-CODE-HERE /usr/share/phpMyAdmin
<Directory /usr/share/phpMyAdmin/>
AllowOverride All
SSLRequireSSL
Options +Includes -Indexes +ExecCGI
</Directory>
<Directory /usr/share/phpMyAdmin/scripts/>
AllowOverride All
SSLRequireSSL
Options +Includes -Indexes +ExecCGI
</Directory>
Then you must restart apache service
Other config files, you can see at
http://vestacp.com/docs/#config-log-loc ... ian-ubuntu
Re: PHPMyAdmin no longer working
Posted: Tue Dec 16, 2014 7:54 pm
by Tralapo
saosangmo wrote:Did you try to edit file /home/admin/conf/web/sapache2.conf and paste the following (see below) before this line </VirtualHost> and save
I believe I just said that folder is empty, because I do not host any website in /admin
saosangmo wrote:
Code: Select all
Alias /phpmyadmins-GENERATE-RANDOM-PASS-CODE-HERE /usr/share/phpMyAdmin
<Directory /usr/share/phpMyAdmin/>
AllowOverride All
SSLRequireSSL
Options +Includes -Indexes +ExecCGI
</Directory>
<Directory /usr/share/phpMyAdmin/scripts/>
AllowOverride All
SSLRequireSSL
Options +Includes -Indexes +ExecCGI
</Directory>
But why do I have to enter this, if the originial file is totaly different and includes other <directory> listings? Shouldn't I include the same things as in my original file? (did you read my post??)
As I said before, the original file now looks like this (see below). I don't see the /usr/share/phpMyAdmin/scripts/ you want to inlcude in the new file. But I see others. What should I delete from the original file and what should I put in the new file.
It doesn't seem right that old and new is not the same. Please read my post carefully and give proper answers.
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>
Re: PHPMyAdmin no longer working
Posted: Tue Dec 16, 2014 9:11 pm
by Tralapo
But allright. I followed the guide again, like you suggest.
Still the same. Blank page. Error log:
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'm almost at the point to completely re-installing my webserver. But I don't like that, putting down several websites. And it seems to me a very big step for something that shouldn't be that hard?! But it appears to be....
Re: PHPMyAdmin no longer working
Posted: Wed Dec 17, 2014 4:56 am
by joem
Tralapo wrote:But allright. I followed the guide again, like you suggest.
Still the same. Blank page. Error log:
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'm almost at the point to completely re-installing my webserver. But I don't like that, putting down several websites. And it seems to me a very big step for something that shouldn't be that hard?! But it appears to be....
Whats the user:group of /var/lib/phpmyadmin/ and /etc/phpmyadmin/config-db.php? also can you provide a link to phpinfo page
Re: PHPMyAdmin no longer working
Posted: Wed Dec 17, 2014 2:39 pm
by Tralapo
joem wrote:Whats the user:group of /var/lib/phpmyadmin/ and /etc/phpmyadmin/config-db.php? also can you provide a link to phpinfo page
It's all www-data as it's supposed to be. Because the first thing I tried was (see below). That's why I don't understand the error.
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
Re: PHPMyAdmin no longer working
Posted: Thu Dec 18, 2014 12:35 pm
by Tralapo
Nobody else who can think of something that went wrong? I shure don't like re-installing my whole server, but it looks like I have to?
Re: PHPMyAdmin no longer working
Posted: Sat Dec 20, 2014 11:21 am
by Tralapo
Tralapo wrote:Nobody else who can think of something that went wrong? I shure don't like re-installing my whole server, but it looks like I have to?
Seems like that's the only thing left to do. Nobody seems to know this problem.