# Help needed - phpmyadmin/ssh/nginx troubles

**URL:** <https://www.ruby-forum.com/t/help-needed-phpmyadmin-ssh-nginx-troubles/199601>\
**Category:** NGINX\
**Created:** [November 24, 2010, 8:35pm UTC](https://www.ruby-forum.com/t/help-needed-phpmyadmin-ssh-nginx-troubles/199601 "2010-11-24T20:35:41Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![Dobai-Pataky\_BSSSSl](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/d/77aa72/32.png) [@Dobai-Pataky\_BSSSSl](https://www.ruby-forum.com/u/Dobai-Pataky_BSSSSl)\
**Post date:** [November 24, 2010, 8:35pm UTC](https://www.ruby-forum.com/t/help-needed-phpmyadmin-ssh-nginx-troubles/199601/1 "2010-11-24T20:35:41Z")

</div>

Hi All,

I have a very strange problem. I link through to my VPS using SSH - and  
all works fast and reliably except for phpmyadmin.  
The terminal works fine. I’ve removed the local firewall at this end  
(and it made no difference).  
Other sites work fine for me over SSH which narrows the search down  
further.  
Other sites work fine for other people coming in to the server using  
SSH.  
Most of my 8 sites use php, so the problem is unlikely to be PHP.

The main symptom is that GET using PHPMyAdmin are rather unreliable.  
When the work, the reply is \< 2 secs. When they don’t I get no reply.  
30% of GET requests work, 70% fail. With POSTs it is another story.  
95%+ of POSTS fail.

Checking the MySQL log it appears that the break is in the send part  
(browser → nginx → php → phpMysql → MySQL). There is no problem  
getting back. If MySQL logs anything, I get a reply.

I have never had a part transaction. It either fails totally (with no  
error message or log entry I can find) or it succeeds quickly.

The config is…

ian@ianhobson/etc/nginx/sites-available $ cat phpmyadmin

# server for phpmyadmin

server {  
listen 127.0.0.1:80;  
server\_name localhost phpmyadmin ;  
root /home/ian/websites/example;  
index index.htm index.html index.php;  
fastcgi\_index index.php;  
location ^~ /phpmyadmin/ {  
root /usr/share;  
include /etc/nginx/fastcgi\_params;  
fastcgi\_pass 127.0.0.1:9000;  
}  
location ~ .php$ {  
fastcgi\_pass 127.0.0.1:9000;  
include /etc/nginx/fastcgi\_params;  
}  
}

ian@ianhobson/etc/nginx/sites-available $ cat default

# Statements for default virtual host

server {  
listen 80 default ;  
#  
server\_name 212.13.194.210 ;  
root /home/ian/websites/default;  
index index.htm;  
access\_log /var/www/access\_log;

}  
ian@ianhobson/etc/nginx/sites-available $

Default shown to show it can’t pick up the domain “localhost”. I am  
using it on address [http://localhost:8080/phpmyadmin.index.php](http://localhost:8080/phpmyadmin.index.php) This  
was tunnelled through to 127.0.0.1:80. I have also tried tunnelling  
to localhost:80 - neither works reliably.

Does anyone have any idea what might be going wrong? OR even what to  
look for?

Regards

Ian

p.s. 6 months ago it used to work much better, with only an occasional  
glitches. Sonce then it has got steadily worse and worse.