PHPMyAdmin gone after change to nginx

[Brian Chabot]

After switching to nginx in Advanced Options, the link to phpmyadmin is now 404.

[ehcpdeveloper (ehcpdeveloper)]

anyone that offers a solution for this ?

[Brian Chabot (bchabot)]

I don't yet, but I can offer the direction:

Translate phpmyadmin.conf from Apache config to nginx config and save it.

(Perhaps as ehcp/etc/nginx/phpmyadmin.nginx)

Then add in the server section of apachetemplate.nginx add the following line:

include phpmyadmin.nginx

Not sure about how to do the translation yet though. If someone else knows nginx and can crank it out, great. Otherwise, I'll figure it out eventually and post it here.

[Brian Chabot (bchabot)]

Temp work-around:

# cp -r /usr/share/phpmyadmin /var/www/vhosts[path_to]httpdocs/

[ehcpdeveloper (ehcpdeveloper)]

Today, I tried a few conf, as described in
http://forum.nginx.org/read.php?2,753,1036
but, none worked..
i give up on this for a while, until someone suggests a solution..

[Raghu Veer Dendukuri (webmaster-securitywonks)]

Dear Mr.Bahattin

http://forum.nginx.org/read.php?2,753,1036

did you try all solutions in this thread?

as OP has an answer in there.

=====================================

thinking towards solution, tell me, if this works,

Method 1:

One method, which my server admin did is install phpmyadmin in every ssh account, i.e.

a) since, we can run multiple websites and manage them with an ssh account which offers shell access and sftp support (especially when all websites belong to a particular user/webmaster), we can install phpmyadmin on a subdomain or in a sub-folder of any domain name hosted under his ssh account (I mean where his ssh account has privileges to access phpmyadmin install) and configure the Phpmyadmin to manage only those MySQL databases that are related to websites of this particular user/webmaster kind of...

This is easy solution, which enables us to define seperate username/password for each ssh account, as it is seperate phpmyadmin installation on a ssh account basis (irrespective of how many websites are managed using that ssh account).

But, when we think about PHPMyAdmin updates in every install in every ssh account (after every stable release of PHPMyAdmin), all locations need to be updated while caring config to allow access to only databases that belong to the particular user/webmaster kind of...

Note: This solution is done for easyness on manually managed nginx only based server (where we use few ssh/sftp accounts to manage different websites under each ssh/sftp account).

Method 2:

Since, EHCP is a control panel, and , since, we have option to either use apache or totally change to nginx as http server and since, we need to try handling and managing one phpmyadmin install for all ssh user accounts, please post configuration information of php-fpm, nginx etc, whatever other information required, which I will show to my server admin, for a possible solution hopefully.

My server admin (who is nginx geek and who know his game with nginx, as he maintained nginx servers from long time and along with php-fpm project too) may propose a solution for this situation, thank you

just some thoughts, thank you

A Clarification please: you had enabled nginx with php-fpm know in EHCP, like we discussed long back, thank you

With Best Regards
Raghu Veer

[Brian Chabot (bchabot)]

Did you try the alias or the symbolic link or both?

The alias seems to not work as per your linked thread, but a symbolic link works for me for Roundcube and the EHCP panel itself.

[Salman (salman-chohan)]

For nginx users

Download this phpmyadmin file to your server
http://www.7skyhost.com/phpmyadmin.zip

just extract this zip file under this directory
/var/www/new

and phpmyadmin will work for nginx ;)

Thank You

[ehcpdeveloper (ehcpdeveloper)]

fixed in new upcoming ehcp version 0.30.9 and later.