Install SSL with ngnix for apache server

Hello,

i'am trying to install some compose docker apache / phpmyadmin / sql with an ssl cerficate with ngnix.

i don't know how to modify config files to have all working.

i tried to change some ports in apache config but without sucess.

thank's in advance

server apache config:

Zitat

---

version: "2"

services:

dev-db:

image: mariadb:latest

container_name: dev-db

environment:

- TZ=Europe/Paris

- MYSQL_ROOT_PASSWORD=*************

- MYSQL_DATABASE=sql_data

- MYSQL_USER=sql_user

- MYSQL_PASSWORD=*********************

- MYSQL_ALLOW_EMPTY_PASSWORD=no

volumes:

- /media/db:/var/lib/mysql

ports:

- 3306:3306

networks:

- developarea

restart: unless-stopped

dev-data:

image: php:7.4-apache

container_name: dev-data

volumes:

- /srv/dev-disk-by-uuid-17bdfa8b-f043-4009-bcf7-dc86ea35a847/www:/var/www/html

ports:

- 80:80

******************************************************

i tried: to change the config file with

ports:

- 8080:8080

environment:

- APACHE_PORT=11000

*******************************************************

links:

- dev-db:mysql

networks:

- developarea

restart: always

dev-pma:

depends_on:

- dev-db

image: phpmyadmin/phpmyadmin

container_name: dev-pma

environment:

PMA_HOST: dev-db

MYSQL_ROOT_PASSWORD: ----------------------

MYSQL_USER: sql_user

ports:

- 81:80

links:

- dev-db:mysql

networks:

- developarea

restart: always

networks:

developarea:

Alles anzeigen

NGNIX file

Zitat

version: '3.8'

services:

app:

image: 'jc21/nginx-proxy-manager:latest'

restart: unless-stopped

ports:

- '80:80'

- '443:443'

- '81:81'

environment:

PUID: ${PUID}

PGID: ${PGID}

X_FRAME_OPTIONS: "sameorigin"

volumes:

- ./data:/data

- ./letsencrypt:/etc/letsencrypt

Alles anzeigen

Hello,

Thank you for your reply

my OMV port is 8888

i change many ports

http://192.168.0.170:11000/ don't work

http://192.168.0.170:81/ ngnix portal

http://192.168.0.170:80/ welcome to ngnix portal "log in to portal ..."

http://192.168.0.170:83/ phpmyadmin login

http://192.168.0.170:82/ don't work

Zitat

---

version: "2"

services:

dev-db:

image: mariadb:latest

container_name: dev-db

environment:

- TZ=Europe/Paris

- MYSQL_ROOT_PASSWORD=*********

- MYSQL_DATABASE=sql_data

- MYSQL_USER=sql_user

- MYSQL_PASSWORD=***********

- MYSQL_ALLOW_EMPTY_PASSWORD=no

volumes:

- /media/db:/var/lib/mysql

ports:

- 3306:3306

networks:

- developarea

restart: unless-stopped

dev-data:

image: php:7.4-apache

container_name: dev-data

volumes:

- /srv/dev-disk-by-uuid-17bdfa8b-f043-4009-bcf7-dc86ea35a847/www:/var/www/html

ports:

- 11000:11000

links:

- dev-db:mysql

networks:

- developarea

restart: always

dev-pma:

depends_on:

- dev-db

image: phpmyadmin/phpmyadmin

container_name: dev-pma

environment:

PMA_HOST: dev-db

MYSQL_ROOT_PASSWORD: ************

MYSQL_USER: sql_user

ports:

- 83:80

links:

- dev-db:mysql

networks:

- developarea

restart: always

networks:

developarea:

Alles anzeigen

Zitat

version: '3.8'

services:

app:

image: 'jc21/nginx-proxy-manager:latest'

restart: unless-stopped

ports:

- '80:80'

- '443:443'

- '81:81'

environment:

PUID: ${PUID}

PGID: ${PGID}

X_FRAME_OPTIONS: "sameorigin"

volumes:

- ./data:/data

- ./letsencrypt:/etc/letsencrypt

Alles anzeigen

hello

i modify some settings, port 82, and apache port to 111000:80

http://192.168.0.170:81/ ngnix portal

http://192.168.0.170:80/ welcome to ngnix portal "log in to portal ..."

http://192.168.0.170:82/ phpmyadmin login

http://192.168.0.170:11000/ is my website

https://*******.fr is my website

it works (i must test several other)

now i must set proftp to acess my www folder

Zitat

---

version: "2"

services:

dev-db:

image: mariadb:latest

container_name: dev-db

environment:

- TZ=Europe/Paris

- MYSQL_ROOT_PASSWORD=******

- MYSQL_DATABASE=sql_data

- MYSQL_USER=sql_user

- MYSQL_PASSWORD=********

- MYSQL_ALLOW_EMPTY_PASSWORD=no

volumes:

- /media/db:/var/lib/mysql

ports:

- 3306:3306

restart: unless-stopped

dev-data:

image: php:7.4-apache

container_name: dev-data

volumes:

- /www:/var/www/html

ports:

- 11000:80

links:

- dev-db:mysql

restart: always

dev-pma:

depends_on:

- dev-db

image: phpmyadmin/phpmyadmin

container_name: dev-pma

environment:

PMA_HOST: dev-db

MYSQL_ROOT_PASSWORD: *************

MYSQL_USER: sql_user

ports:

- 82:80

links:

- dev-db:mysql

restart: always

Alles anzeigen

hello

after many difficults now i'am trying to connect with my db with my index.php.

every time i have an error when i'am trying to connect at the db.

index.php:

$conn = new mysqli($DB_DSN, $DB_USER, $DB_PASSWORD, $dbname);

i also tried:

$conn = new mysqli($MYSQL_DATABASE, $MYSQL_USER, $MYSQL_PASSWORD, $MYSQL_DATABASE);

or

$conn = new mysqli(localhost, sql_user, *************,sql_data);

compose environnement file:

Zitat

PUID=1000

PGID=100

TZ=Europe/Paris

DB_DSN=mysql:host=db;

dbname=sql_data

DB_USER=sql_user

DB_PASSWORD=*********

Alles anzeigen

compose apache

Zitat

---

version: "3.6"

services:

dev-db:

image: mariadb:latest

container_name: dev-db

environment:

- TZ=Europe/Paris

- MYSQL_ROOT_PASSWORD=********

- MYSQL_DATABASE=sql_data

- MYSQL_USER=sql_user

- MYSQL_PASSWORD=*********

- MYSQL_ALLOW_EMPTY_PASSWORD=no

volumes:

- /media/db:/var/lib/mysql

ports:

- 3306:3306

restart: unless-stopped

dev-data:

container_name: "apache-php"

image: "apachephpcontainer"

volumes:

- /www:/var/www/html

ports:

- 11000:80

links:

- dev-db:mysql

restart: always

dev-pma:

depends_on:

- dev-db

image: phpmyadmin/phpmyadmin

container_name: dev-pma

environment:

PMA_HOST: dev-db

MYSQL_ROOT_PASSWORD: *******

MYSQL_USER: sql_user

ports:

- 82:80

links:

- dev-db:mysql

restart: always

Alles anzeigen

docker files: apachephpcontainer

Zitat

FROM php:7.4-apache

RUN docker-php-ext-install mysqli

nginx

Zitat

version: '3.8'

services:

app:

image: 'jc21/nginx-proxy-manager:latest'

restart: unless-stopped

ports:

- '80:80'

- '443:443'

- '81:81'

environment:

PUID: ${PUID}

PGID: ${PGID}

X_FRAME_OPTIONS: "sameorigin"

volumes:

- ./data:/data

- ./letsencrypt:/etc/letsencrypt

Alles anzeigen

solved;

localhost or 127.0.0.1 don't work, must use my local lan ipv4: 192.168.0.xxx:3306

it's realy strange !