Thanks!!!!!! A great write-up!!! As I was reading through the docker manual I was beginning to suspect that something was missing, but I found a partial mysq installation in the container (accessing it through the shell). But it was only a partial installation, so I tried to repair as was going to modify the settings.py to use mysql, but then your blog post arrived.
A couple of warnings from the mysql installation: * The root password for mysql was not set * Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened. root@orca:/home/mark/mayan2-docker# docker run -d --name mayan-mysql --restart=always --env-file env.list -v mayan_mysql:/var/lib/mysql --net=mayan mysql:latest Unable to find image 'mysql:latest' locally latest: Pulling from library/mysql ad74af05f5a2: Pull complete 0639788facc8: Pull complete de70fa77eb2b: Pull complete 724179e94999: Pull complete 50c77fb16ba6: Pull complete d51f459239fb: Pull complete 937bbdd4305a: Pull complete 35369f9634e1: Pull complete f6016aab25f1: Pull complete 5f1901e920da: Pull complete fdf808213c5b: Pull complete Digest: sha256:96edf37370df96d2a4ee1715cc5c7820a0ec6286551a927981ed50f0273d 9b43 Status: Downloaded newer image for mysql:latest 537501f942aad43f956343327ac3853021b62d44b044b92dbc3206e6db229156 root@orca:/home/mark/mayan2-docker# docker logs mayan-mysql Initializing database 2017-07-27T15:13:35.448969Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2017-07-27T15:13:36.931315Z 0 [Warning] InnoDB: New log files created, LSN=45790 2017-07-27T15:13:37.257390Z 0 [Warning] InnoDB: Creating foreign key constraint system tables. 2017-07-27T15:13:37.366858Z 0 [Warning] No existing UUID has been found, so we assume that this is the first time that this server has been started. Generating a new UUID: 2a28206b-72de-11e7-ad79-0242ac120002. 2017-07-27T15:13:37.399268Z 0 [Warning] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened. 2017-07-27T15:13:37.399779Z 1 [Warning] root@localhost is created with an empty password ! Please consider switching off the --initialize-insecure option. The mayan installation went well - no errors. root@orca:/home/mark/mayan2-docker# docker run -d --name mayan-edms --restart=always --env-file env.list -v mayan_data:/var/lib/mayan --net=mayan -p 9005:80 mayanedms/mayanedms:2.6.4-3 Unable to find image 'mayanedms/mayanedms:2.6.4-3' locally 2.6.4-3: Pulling from mayanedms/mayanedms e0a742c2abfd: Pull complete 486cb8339a27: Pull complete dc6f0d824617: Pull complete 4f7a5649a30e: Pull complete 672363445ad2: Pull complete efb1cec07b5e: Pull complete a801f5e9adaa: Pull complete 8eb23d7c826c: Pull complete 92fbf659e773: Pull complete c0f0219c11c6: Pull complete e77aab94a7a9: Pull complete 4741b155d5ce: Pull complete cdf3d5b0c8fe: Pull complete cf2f940f4cc5: Pull complete a22f7b8219aa: Pull complete b06c1d87e40c: Pull complete ba3f50217ec1: Pull complete 427849b0be68: Pull complete 4284e8fc0cb3: Pull complete 99227ced2705: Pull complete 60a3086c3d00: Pull complete 5ce3b814e326: Pull complete 7f69be0f8504: Pull complete d43efc48a70f: Pull complete 6b060a72026e: Pull complete c42c5eba1b9b: Pull complete f195e5af15a9: Pull complete 2b37d227a29d: Pull complete 5113bad4a09d: Pull complete 2ec6a0237cc8: Pull complete 9fd5f74e7daf: Pull complete 68b2e131502b: Pull complete 5f64c354aef1: Pull complete 7a1d9773d33e: Pull complete bc702ec47793: Pull complete Digest: sha256:de00429beb8736db87ad41ad1645787e5330beae11aed1479323a79ef40d 1231 Status: Downloaded newer image for mayanedms/mayanedms:2.6.4-3 51cbdb670142c55aa764b4bf018ce9377e6d4a26229bcf60e04ba2c29bf7a376 Except I don't know the internally generated mayan admin password. The login screen did not present the admin password at the first login, so I have no way to login to the mayan installation. The forgot password email link does not work because there is no email set up for the docker container. How do I get the password for the mayan admin login? Thanks! Mark On Wed, Jul 26, 2017 at 11:14 PM, Roberto Rosario <roberto.rosario.gonzalez@ gmail.com> wrote: > Made a blog post with the full set of steps to use a MySQL container with > the Mayan container: http://www.mayan-edms.org/post/deploy-mayan-docke > r-mysql/ > > In summary you are configuring the Mayan container but are not launching a > separate MySQL container. > > I tried to explain as much as possible in the post starting with some > Docker basics. Hope you enjoy it and helps you. > > On Wednesday, July 26, 2017 at 11:51:24 AM UTC-4, Mark Phillips wrote: > >> Regarding environment variables, I tried to install mayan 2.6.1 two ways, >> and cannot get it to work. I am trying to use docker to create mayan 2.6.1 >> with mysql as per the instructions - https://gitlab.com/mayan-edm >> s/mayan-edms-docker/tree/2.6.1. >> >> 1. I created a root shell (Ubuntu 14.01) and created the following shell >> environment variables using the following script - >> >> #!/bin/sh >> MAYAN_DATABASE_DRIVER=\'django.db.backends.mysql\' >> MAYAN_DATABASE_NAME=\'memorabilia\' >> MAYAN_DATABASE_USER=\'mayan\' >> MAYAN_DATABASE_PASSWORD=\'ooTh7ietieT0aKea\' >> MAYAN_DATABASE_HOST=\'localhost\' >> MAYAN_DATABASE_PORT=\'3306\' >> export MAYAN_DATABASE_DRIVER >> export MAYAN_DATABASE_NAME >> export MAYAN_DATABASE_USER >> export MAYAN_DATABASE_PASSWORD >> export MAYAN_DATABASE_HOST >> export MAYAN_DATABASE_PORT >> echo $MAYAN_DATABASE_DRIVER >> echo $MAYAN_DATABASE_NAME >> echo $MAYAN_DATABASE_USER >> echo $MAYAN_DATABASE_PASSWORD >> echo $MAYAN_DATABASE_HOST >> echo $MAYAN_DATABASE_PORT >> >> The mayan instructions seem to indicate that the shell environment >> variables need to single quotes around them. Is this correct, or are then >> unquoted values? It the single quotes are not needed, I did not get an >> error message about this. >> >> I then followed the instruction referenced above to pull mayan 2.6.1 and >> then run mayan 2.6.1. I was able to access mayan from http://localhost, >> but after looking into the settings.py file for this container, I found >> that it was using sqlite and not mysql as the db backend. >> >> 2. I removed the above container and image and started again. I pulled >> mayan 2.6.1, and created an env.list file as shown in the docker >> instructions for passing environemnt variables to docker: >> >> MAYAN_DATABASE_DRIVER=django.db.backends.mysql >> MAYAN_DATABASE_NAME=memorabilia >> MAYAN_DATABASE_USER=mayan >> MAYAN_DATABASE_PASSWORD=ooTh7ietieT0aKea >> MAYAN_DATABASE_HOST=localhost >> MAYAN_DATABASE_PORT=3306 >> >> I then ran mayan 2.6.1 with this command, passing the environment >> variables as shown in the docker user guide >> >> docker run -d --name mayan-edms --restart=always -p 9005:80 --env-file >> ./env.list -v mayan_data:/var/lib/mayan mayanedms/mayanedms:2.6.1 >> >> The container never started, or more specifically, it would start and >> stop continuously. I removed the container and image as it was broken. >> >> How do I create a mayan 2.6.1 instance using docker and using mysql as >> the backend database? It does not appear the environment variables are >> working Or I don't understand how to use them!), although the terminology >> is rather confusing. Are they docker environment variables (as in #2 >> above), or environment variables from the shell where docker is run (as in >> #1 above)? >> >> Thanks! >> >> Mark >> >> On Mon, Jul 24, 2017 at 8:27 PM, Roberto Rosario <roberto.rosa....z@ >> gmail.com> wrote: >> >>> Yes, it is a less involved process and all dependencies are taken care >>> of. >>> >>> 1. Correct, there is no need to use Python's virtualenv since the Docker >>> container itself is already isolated from the OS. >>> 2. Environment variables are only needed when the container is first >>> created, afterwards it can be stopped and restarted and their values will >>> persist internally in the container. >>> >>> On Wednesday, July 19, 2017 at 1:31:26 PM UTC-4, Mark Phillips wrote: >>>> >>>> I read the Docker install instructions for Mayan 2.6. Seems easy, but I >>>> have a couple of questions - >>>> >>>> 1. After reading some about Docker, as I understand it, we don't need >>>> to create a virtualenv for the Docker image. Is that correct? If not, I am >>>> not sure how to combine the docker image with a virtualenv. >>>> >>>> 2. I see the environment variables make it easier to install with a >>>> non-SQLite backend. Are these environment variables only for the install >>>> process, or do then need to be a permanent feature? In other words, do I >>>> set the environment variables in the current shell, or do they need to go >>>> in my .profile so every time I log in they are present? >>>> >>>> Thanks! >>>> >>>> Mark >>>> >>> -- >>> >>> --- >>> You received this message because you are subscribed to the Google >>> Groups "Mayan EDMS" group. >>> To unsubscribe from this group and stop receiving emails from it, send >>> an email to mayan-edms+unsubscr...@googlegroups.com. >>> For more options, visit https://groups.google.com/d/optout. >>> >> >> -- > > --- > You received this message because you are subscribed to the Google Groups > "Mayan EDMS" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to mayan-edms+unsubscr...@googlegroups.com. > For more options, visit https://groups.google.com/d/optout. > -- --- You received this message because you are subscribed to the Google Groups "Mayan EDMS" group. To unsubscribe from this group and stop receiving emails from it, send an email to mayan-edms+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.