1 (edited by nicolasfo 2018-02-20 20:31:20)

Topic: [SOLVED] Install phpMyAdmin on frech iRedMail install

==== Required information ====
- iRedMail version (check /etc/iredmail-release):
- Linux/BSD distribution name and version:
- Store mail accounts in which backend (LDAP/MySQL/PGSQL):
- Web server (Apache or Nginx):
- Manage mail accounts with iRedAdmin-Pro?
- [IMPORTANT] Related original log or error message is required if you're experiencing an issue.
======== Required information ====
- iRedMail version (check /etc/iredmail-release): 0.9.3
- Linux/BSD distribution name and version: Debian 9.3.0 x64
- Store mail accounts in which backend (LDAP/MySQL/PGSQL): MySQL
- Web server (Apache or Nginx): Nginx
- Manage mail accounts with iRedAdmin-Pro? Yes
- [IMPORTANT] Related original log or error message is required if you're experiencing an issue.
====

Hello,
I'd like to install phpMyAdmin on a fresh IredMail install.
First, I installed iRedMail with Nginx as webserver.
When finished, I installed phpMyAdmin and uncheck any webserver configuration.
I created a file : /etc/nginx/sites-conf.d/default-ssl/90-include-tmpl-phpmyadmin.conf with content :

include /etc/nginx/templates/phpmyadmin.tmpl;

And a file /etc/nginx/templates/phpmyadmin.tmpl with content :

location /phpmyadmin {
  root /usr/share/;
  index index.php;
  try_files $uri $uri/ =404;

  location ~ ^/phpmyadmin/(doc|sql|setup)/ {
    deny all;
  }

  location ~ /phpmyadmin/(.+\.php)$ {
    fastcgi_pass unix:/run/php/php7.0-fpm.sock;
    fastcgi_param SCRIPT_FILENAME $document_root$fastcgi_script_name;
    include fastcgi_params;
    include snippets/fastcgi-php.conf;
  }
}

After a Nginx restart, I get this error in /var/log/nginx/error.log :

2018/02/19 11:09:19 [crit] 1563#1563: *5 connect() to unix:/run/php/php7.0-fpm.sock failed (2: No such file or directory) while connecting to upstream, client: xxx.xxx.xxx.xxx, server: _, request: "GET /phpmyadmin/ HTTP/1.1", upstream: "fastcgi://unix:/run/php/php7.0-fpm.sock:", host: "xxx.xxx.xxx.xxx"

I checked, it's true, /run/php/php7.0-fpm.sock doesn't exists. However, I checked in /etc/php/7.0/fpm/pool.d/www.conf  and I have this conf :

listen = /var/run/php7.0-fpm.socket

Despite it's not the good name (need to tune it in the Nginx phpMyAdmin conf file) I should have a *.socket file under /var/run, but it's not the case. I only have a *.pid file in this directory.

I also check if sockets were enabled in php using a phpinfo page and they're activated.

All rights access are OK.

Any help ?

Thanks

Nicolas

----

Spider Email Archiver: On-Premises, lightweight email archiving software developed by iRedMail team. Supports Amazon S3 compatible storage and custom branding.

2

Re: [SOLVED] Install phpMyAdmin on frech iRedMail install

Just done a new test :
Installed a fresh Debian server, installed Nginx, php7.0-fpm, MySQLServer and phpMyAdmin. All of this, without installing iRedMail : phpMyAdmin works fine.
After this, I installed iRedMail. phpMyAdmin stopped to "work" and the file /var/run/php7.0-fpm.socket dissappears.

What's the config that makes phpMyAdmin don't works ?

Thanks
Nicolas

3

Re: [SOLVED] Install phpMyAdmin on frech iRedMail install

The answer was in the question, I just add a "php" in the *socket path...

No problem sorry.

Nicolas

4

Re: [SOLVED] Install phpMyAdmin on frech iRedMail install

Better use https://www.adminer.org instead of phpmyadmin.