badlop
commented
3 years ago I haven't checked your files, because I prefer mi solution. I have a way to setup ejabberd, mysql, create the database, fill with example accounts, and setup MySQL web administration service. Try my example, and adapt it to your needs.
- Create a new docker-compose.yml with this content:
```yaml
version: '3.7'
volumes:
main_conf:
name: main_conf
main_logs:
name: main_logs
main_data:
name: main_data
main_uplo:
name: main_uplo
mysql_data:
name: mysql_data
services:
main:
hostname: main
container_name: main
image: ejabberd/ecs:latest
depends_on:
mysql:
condition: service_healthy
environment:
- CTL_ON_CREATE=register admin localhost asd ;
register user1my mysql.localhost asd
- CTL_ON_START=stats registeredusers ;
status
command: ["foreground"]
healthcheck:
test: netstat -nl | grep -q 5222
start_period: 5s
interval: 5s
timeout: 5s
retries: 120
ports:
- "5222:5222"
- "5269:5269"
- "5280:5280"
- "5443:5443"
volumes:
- main_conf:/home/ejabberd/conf
- main_data:/home/ejabberd/database
- main_logs:/home/ejabberd/logs
- main_uplo:/home/ejabberd/upload
- ./ejabberd.yml:/home/ejabberd/conf/ejabberd.yml:ro
mysql:
image: mysql:latest
container_name: mysql
volumes:
- mysql_data:/var/lib/mysql
- ./mysql.sql:/docker-entrypoint-initdb.d/mysql.sql:ro
command: --default-authentication-plugin=mysql_native_password
restart: always
healthcheck:
test: mysqladmin ping -h 127.0.0.1 -u $$MYSQL_USER --password=$$MYSQL_PASSWORD
interval: 10s
retries: 120
environment:
MYSQL_ROOT_PASSWORD: example
MYSQL_DATABASE: ejabberd_test
MYSQL_USER: ejabberd_test
MYSQL_PASSWORD: ejabberd_test
adminer:
image: adminer
container_name: adminer
restart: always
depends_on:
mysql:
condition: service_healthy
main:
condition: service_healthy
ports:
- 8080:8080
```
- Download ejabberd.yml and setup those lines at the beginning:
hosts:
- localhost
- mysql.localhost
host_config:
mysql.localhost:
sql_port: 3306
sql_type: mysql
sql_server: "mysql"
sql_database: "ejabberd_test"
sql_username: "ejabberd_test"
sql_password: "ejabberd_test"
sql_pool_size: 1
auth_method: sql
default_db: sql-
Download ejabberd's mysql.sql file, as it will be used to prepare the database.
-
Start docker-compose. It takes several minutes to fully start MySQL, be patient
sudo docker-compose up- After some minutes, the console will show this:
Creating network "ecs_default" with the default driver
Creating volume "main_conf" with default driver
Creating volume "main_logs" with default driver
Creating volume "main_data" with default driver
Creating volume "main_uplo" with default driver
Creating volume "mysql_data" with default driver
Creating mysql ... done
Creating main ... done
Creating adminer ... done
Attaching to mysql, main, adminer
...
main | 2021-05-13 10:23:54.208771+00:00 [info] ejabberd 21.4.0 is started in the node ejabberd@main in 11.25s
main | 2021-05-13 10:23:54.215446+00:00 [info] Start accepting TCP connections at [::]:5269 for ejabberd_s2s_in
main | 2021-05-13 10:23:54.216246+00:00 [info] Start accepting TLS connections at [::]:5443 for ejabberd_http
main | 2021-05-13 10:23:54.216604+00:00 [info] Start accepting TCP connections at [::]:5280 for ejabberd_http
main | 2021-05-13 10:23:54.217225+00:00 [info] Start accepting TCP connections at [::]:1883 for mod_mqtt
main | 2021-05-13 10:23:54.217693+00:00 [info] Start accepting TCP connections at [::]:5222 for ejabberd_c2s
main | 2021-05-13 10:23:54.218102+00:00 [warning] No HTTP listeners for ACME challenges are configured, automatic certificate requests are aborted. Hint: configure the listener and restart/reload ejabberd. Or set acme->auto option to `false` to suppress this warning.
main | 2021-05-13 10:23:54.235688+00:00 [info] Start accepting TCP connections at 172.21.0.3:7777 for mod_proxy65_stream
main | :> ejabberdctl register admin localhost asd
main | User admin@localhost successfully registered
main | :> ejabberdctl register user1my mysql.localhost asd
main | User user1my@mysql.localhost successfully registered
main | :> ejabberdctl stats registeredusers
main | 2
main | :> ejabberdctl status
main | The node ejabberd@main is started with status: started
main | ejabberd 21.4.0 is running in that node- Now you can:
- Login to the registered XMPP accounts with a XMPP client, or register new ones.
- Enter the ejabberd WebAdmin in http://localhost:5280/admin/ with username:
admin@localhostand password:asd - Enter the MySQL web adminer: http://localhost:8080/?server=mysql&username=ejabberd_test&db=ejabberd_test&select=users
juancar0505
Im trying to use mysql database on ejabberd with docker-compose.
My configuration file is this:
I clarify that my dockerfile from the mysql_ejabberd image is the following, only create the database of ejabberd:
I dont know if i need to add something on my .yml or dockerfile Can u someone help me pls?