phpmyadmin.sh Addon

[crit] 2418#0: *10 connect() to unix:/tmp/phpfpm_myadmin.sock failed (13: Permission denied) while connecting to upstream, client: <ip here>, server: <hostname here>, request: "GET /22399_mysqladmin4181/ HTTP/1.1", upstream: "fastcgi://unix:/tmp/phpfpm_myadmin.sock:", host: "<hostname here>"

---

I got such error and I'm out of idea what to do next, any advice?

 

what version of Centmin Mod ?
The latest available version

how old was the initial installation of it ?
Maybe less than 24 hour before I start the thread

how old is the initial phpmyadmin.sh addon installation ?
As soon as Centmin Mod installation done

Code:

[phpmyadmin]
user = phpmyadmin
group = nginx

;listen = 127.0.0.1:9001
listen = /tmp/phpfpm_myadmin.sock
listen.allowed_clients = 127.0.0.1

I find that I didn't have

Code:

listen.owner=phpmyadmin
listen.group=nginx

so i add it on the conf file and do the nprestart and open it again..

Code:

2014/09/22 01:24:38 [crit] 6533#0: *2 connect() to unix:/tmp/phpfpm_myadmin.sock failed (2: No such file or directory) while connecting to upstream, client: <myip>, server: <myhostname>, request: "GET /28590_mysqladmin2193/ HTTP/1.1", upstream: "fastcgi://unix:/tmp/phpfpm_myadmin.sock:", host: "<myhostname>"
[root@server ~]# date
Mon Sep 22 01:36:52 UTC 2014
[root@server ~]#

Still have the same result 502 bad gateway.

 

So I check again on phpmyadmin_https.conf and it appear that allow 127.0.0.1 has been commented so I removed it and it work like a charm now. Thanks for the help.

Code:

        auth_basic      "Private Access";
        auth_basic_user_file  /usr/local/nginx/conf/htpassphpmyadmin;
        allow 127.0.0.1;
        #allow 175.138.232.197;
        #deny all;
}

 

STATICIP='n'

I access phpmyadmin from my own laptop not from the client machine. After I disable 127.0.0.1, I have the same problem again not being able to access the phpmyadmin. My guess is that if you disable 127.0.0.1 it will block phpmyadmin which cause sock fail.

I hope there is more input from other user to back up this finding.

 

Hi @eva; can you share your own current practice for administrating SQL with GUI?
I asked this because I'd like to centminmod. However; it seems that there is not another solution like phpmyadmin. Anyways I do not like to install phpmyadmin in same server as I worry about security...

 

I uninstall it and install again and all working great but i just got a notice:

Code:

nginx: [emerg] "fastcgi_pass" directive is duplicate in /usr/local/nginx/conf/php_15396_mysqladmin5546.conf:8
nginx: configuration file /usr/local/nginx/conf/nginx.conf test failed

I can see that the parameter is duplicated and i just comment the second one and is ok now....

Code:

    fastcgi_pass phpbackend;
    fastcgi_keep_conn on;
    # fastcgi_pass   unix:/tmp/phpfpm_myadmin.sock;

 

Also the recommended web url never works for me:

Code:

https://server.mydomain.com/15396_mysqladmin5546

I am getting
This webpage is not available
DNS_PROBE_FINISHED_NXDOMAIN

Instead i use:

Code:

https://serverip/15396_mysqladmin5546

I also check that after uninstalling and installing phpmyadmin the code in location / is wrong:

Code:

    location / {
        return 302 http://;
    }

  include /usr/local/nginx/conf/phpmyadmin_https.conf;
  include /usr/local/nginx/conf/staticfiles.conf;
  #include /usr/local/nginx/conf/php.conf;
  include /usr/local/nginx/conf/drop.conf;
  include /usr/local/nginx/conf/errorpage.conf;
}

so i manually edit it to:

Code:

    location / {
        return 302 http://$server_name$request_uri;
    }

and then i restart nginx and phpfpm and it works again with the ip only...

Thanks

 

In /etc/hosts i was use old entry for server.mydomain.com ...

I edit it and now it works

 

Hello, I recently installed this addon and I was getting the 502 gateway error.
Just wanted to note that I had to manually add the below to phpfpm_myadmin.conf for it to work properly. I have the latest addon installed and static ip set to Yes.

Code:

listen.owner=phpmyadmin
listen.group=nginx

 

hi eva, i'll try this tomorrow and let you know.