phpMyAdmin gives 500 error or saves file to disk at login

[annabu]

Hallo,
I am runing ubuntu server 64bit with plesk v.11.5.30, phpmyadmin v.4:3.4.10.1-1.
Need help to solve the phpmyadmin issue.
When i try to acces phpmyadmin from : myserverIP/phpmyadmin - it gives me 500 error.
When I try to acces phpmyadmin from: mydomainserver/phpmyadmin - it saves file at login into the disk instead login.
I was going through different threads on the web to solve that problem but no success at all. If anybody experienced this problem, pls help.
I have real basic knowledge about webservers, phpmyadmin and mysql server. I am runing my first cloud server just few days.

What disappoint me very much is that there is no possibility to access preconfigured phpmyadmin from plesk according that thread: link
So what for do I need plesk?
So I have decided to register to this forums to look for the help and spare my time searching the web. I am very thankful every advise to configure phpmyadmin before i go for fresh install of the system on the server without plesk (that was the recommendation of the support service of my hoster- i am not kidding! )

Regards
a

 

[IgorG]

Open Plesk /usr/local/psa/admin/conf/php.ini file.
Find memory_limit value and increase it, for example:

memory_limit = 256M

Restart psa service:

# /etc/init.d/psa stopall
# /etc/init.d/psa start

 

[annabu]

Open Plesk /usr/local/psa/admin/conf/php.ini file.
Find memory_limit value and increase it, for example:

memory_limit = 256M

Restart psa service:

# /etc/init.d/psa stopall
# /etc/init.d/psa start

Thank you so much for your fast response. I did it but the problem is still exists. I have a question: Is it possible that my own installation of phpmyadmin made some missmatch into phpmyadmin from plesk (if its included there as standard)? I cant also manage my DB in mysql in normal way. Because i had to go to root console and give this command:
root: mysql -uadmin -p`cat /etc/psa/.psa.shadow` psa to reach mysql (!!). So how i tell phpmyadmin, which I installed by self, to use this command?
I dont find step by step documentation to setup phpmyadmin with plesk.

additional infos:

 sudo  /etc/init.d/psa start
Starting psa...  * Starting Plesk engine pool manager sw-engine-fpm      [ OK ] 
                                                                     done
Starting xinetd service...                                           done
Starting sw-cp-server service...                                     done
Starting mysql service...                                            done
perl: warning: Setting locale failed.
perl: warning: Please check that your locale settings:
    LANGUAGE = (unset),
    LC_ALL = (unset),
    LC_PAPER = "de_DE.UTF-8",
    LC_ADDRESS = "de_DE.UTF-8",
    LC_MONETARY = "de_DE.UTF-8",
    LC_NUMERIC = "de_DE.UTF-8",
    LC_TELEPHONE = "de_DE.UTF-8",
    LC_IDENTIFICATION = "de_DE.UTF-8",
    LC_MEASUREMENT = "de_DE.UTF-8",
    LC_TIME = "de_DE.UTF-8",
    LC_NAME = "de_DE.UTF-8",
    LANG = "C"
    are supported and installed on your system.
perl: warning: Falling back to the standard locale ("C").

 

[IgorG]

Do you mean that you have your custom phpmyadmin installation on this server instead of default Plesk phpmyadmin?

 

[annabu]

yes i made installation of phpmyadmin as I have discovered that i have no acces to the DB via plesk interface. and also i dont understand why plesk is searching for german locals beacause i have rented server with english system

 

[annabu]

Update:
i have fixed the locals perl complaing. Now they are set correct to en_US.UTF-8.
Try to reinstall phpmyadmin and reload apache I get:

* Reloading web server config apache2     
... [warn] The Alias directive in /etc/phpmyadmin/apache.conf at line 3 will probably never match because it overlaps an earlier Alias.

apache.conf file:

# phpMyAdmin default Apache configuration

Alias /phpmyadmin /usr/share/phpmyadmin

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

        <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/lib/phpmyadmin/
        </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>

so how can I fix it? Maybe this is the main problem of 500 error at login to phpmyadmin panel?