reinernippes / selfhosted_on_docker Goto Github PK

Thank you for your great job.
A small issue:
in the file https://github.com/ReinerNippes/selfhosted_on_docker/blob/master/roles/docker_base/tasks/portainer.yml

• With your syntax:
  traefik.frontend.rule: "Host:{{ app_server_fqdn }}; PathPrefixStrip: /portainer"
  -> I've just got a blank page with label "Loading Portainer..." and that's all!! Can't connect/manage

• With subdomain :
  traefik.frontend.rule: "Host: portainer.{{ app_server_fqdn }}"
  -> My selfhosted Portainer.io is well load and works fine: I can connect and manage docker configuration.

I would prefer your syntax "<base_domain>/portainer" instead of "portainer.<base_domain>". But I'm too noob to understand what's wrong with traefik syntax.

Hello ;D
At first, sorry for my bad englisch, I comes from germany ;D
So, ok, I have install over your Script the apps, but at last comes this message over the top
https://paste.md-5.net/exaxelohuj.sql

My system ist Ubuntu 18.04, is the error my fail or is that a bug ?

Have a nice Day ;D
Bogus

Add the "base." prefix to the {{base_domain}} to give: base.{{ base_domain }}

# adminer is a webfront end for your database at https://base.{{ base_domain }}/adminer
adminer_enabled: false

# portainer is a webfront end for docker host at https://base.{{ base_domain }}/portainer/
portainer_enabled: true

# user for traefik dashboard at https://base.{{ base_domain }}/traefik
traefik_api_enabled: false

Wordpress upload file is limited to 2M. How to increase it?
Is the the php.ini file https://github.com/ReinerNippes/selfhosted_on_docker/blob/master/roles/docker_wordpress/files/php.ini used?
I changed the value upload_max_filesize but no way.
I'm really noob in docker.... How to change a php configuration after container is built. How to apply changed?

Thank you by advance for any help

Thank you for your great job

prepare_ansible.sh
I've got a yellow message for DEPRECATION: Python 2.7
I don't know if it's a problem for 2020??

message:

DEPRECATION: Python 2.7 will reach the end of its life on January 1st, 2020. Please upgrade your Python as Python 2.7 won't be maintained after that date. A future version of pip will drop support for Python 2.7. More details about Python 2 support in pip, can be found at https://pip.pypa.io/en/latest/development/release-process/#python-2-support

I'm getting a failure when I call ./prepare_site.yml for nextcloud:

TASK [docker_nextcloud : testnc5 | first setup nextcloud] ****************************************************************************************
Wednesday 05 February 2020 21:19:10 +0000 (0:00:00.076) 0:01:53.935 ****
fatal: [localhost]: FAILED! => {"changed": true, "cmd": "docker exec --user www-data testnc5 php occ maintenance:install --database mysql --database-host testnc5-db --database-name nextcloud --database-table-prefix oc_ --database-user nextcloud --database-pass 1P2aMOLiulaii62puB3xX2YKRWTXXmfH --admin-user admin --admin-pass cVmLoyLJ09V9LJD7DIVtNr7UD81oYNl5 --data-dir /var/nc-data\n", "delta": "0:00:01.163908", "end": "2020-02-05 21:19:11.943165", "msg": "non-zero return code", "rc": 1, "start": "2020-02-05 21:19:10.779257", "stderr": "", "stderr_lines": [], "stdout": "Error while trying to create admin user: Failed to connect to the database: An exception occurred in driver: SQLSTATE[HY000] [1044] Access denied for user 'nextcloud'@'%' to database 'nextcloud'\n -> ", "stdout_lines": ["Error while trying to create admin user: Failed to connect to the database: An exception occurred in driver: SQLSTATE[HY000] [1044] Access denied for user 'nextcloud'@'%' to database 'nextcloud'", " -> "]}

To debug this I entered the testnc5 container:

docker exec -it testnc5 sh

and added the mysql client:

apk add mysql-client

The "equivalent" mysql to the occ command above (I suppose...) would be:

/var/www/html # mysql -u nextcloud -p'1P2aMOLiulaii62puB3xX2YKRWTXXmfH' \
>     -h testnc5-db  \
>     -D nextcloud

which gives:

````ERROR 1044 (42000): Access denied for user 'nextcloud'@'%' to database 'nextcloud'
`

This looks like the same error message as above (occ command)
I can log in using the password in testnc5_mysql_root_secret and root

mysql -u root -p'Cov04wxaA6zmkskNgrbDpv6DzKxTvgAJ' \
    -h testnc5-db  

and here I see e.g.:

MariaDB [(none)]> show databases;
+--------------------+
| Database           |
+--------------------+
| default            |
| information_schema |
| mysql              |
| performance_schema |
+--------------------+
4 rows in set (0.004 sec)

Hello Reiner,
would you mind to consider the integration of the Draw.io server docker into your selfhosted_on_docker ansibles?
That would be cool to gain a real self-hosted nextcloud installation even when using the draw.io NC app.
The draw.io server for docker can be found here: https://github.com/jgraph/docker-drawio
That would be awesome, as it would cover another piece from the wishlist regarding an easy-to-set-up self-hosting work environment for small projects etc.
Thanks a lot for all your work already done!