Someone deploy Linkace (simple) using Ansible?

[esturniolo]

Hi everybody.
I deploy all my containers using Ansible, but in this case I can't make it work with Linkace.

Anyone can deploy it successfully?

Can you share your playbook?

I can't find anything regarding this here.

Thanks!

[Kovah]

If you give me some time, I could post my Ansible setup that I use to deploy both the official Demo and my own instance.

[Kovah]

@esturniolo
Playbook: https://gist.github.com/Kovah/e76519e42984d8da7542b2f5f5cf987f
Vars: https://gist.github.com/Kovah/6d45070192f871cb8e5f226aca1d44ee
docker-compose template: https://gist.github.com/Kovah/bd94e3e16dc81bbb44c12dc55734cbf3
env template: https://gist.github.com/Kovah/c47e1d13f9c6fbdc3f2c3b4472e19c13

[esturniolo]

Oh that's will be great!!

I've all the time in the world.

Thanks!!

[esturniolo]

Hi @Kovah!
Do you have any news about your Ansible setup?

Thanks a lot!!

[Kovah]

Thanks for the reminder, totally forgot about this. Will put something together later.

[esturniolo]

Sorry for bother you @Kovah.
I think that I made it, but I've some problem with the nginx part (I'm using the advanced setup).

I've this "template" for all my selfhosted services but I don't know how to tweak it with the values on your nginx config file of your release.
I'm actually has that nasty "502 Bad Gateway" message.

Thanks!

server {
    listen 443 ssl http2;
    listen [::]:443 ssl http2;
    server_name linkace.example.com;

    client_max_body_size 50M;

    gzip            on;
    gzip_proxied    any;
    gzip_types      text/plain text/css text/js application/xml application/json application/x-javascript application/javascript;
    
    ssl_certificate /etc/letsencrypt/live/example.com/fullchain.pem;
    ssl_certificate_key /etc/letsencrypt/live/example.com/privkey.pem;
    
    ssl_protocols TLSv1.2 TLSv1.3;
    ssl_prefer_server_ciphers on;
    ssl_ciphers TLS13-CHACHA20-POLY1305-SHA256:TLS13-AES-256-GCM-SHA384:TLS13-AES-128-GCM-SHA256:EECDH+CHACHA20:EECDH+AESGCM:EECDH+AES;

    add_header Strict-Transport-Security "max-age=15552000";

    location / {
        proxy_pass       http://172.20.0.23; # internal docker container IP. Linkace works in which port? Because I need to put it here.
        proxy_set_header X-Real-IP $remote_addr;
        proxy_set_header Host $host;
        proxy_set_header Scheme	$scheme;
        proxy_set_header X-Forwarded-For $proxy_add_x_forwarded_for;
        proxy_set_header X-Forwarded-Proto $scheme;
        proxy_set_header X-Forwarded-Host $host;
        proxy_set_header X-Forwarded-Ssl on;
        # proxy_set_header Upgrade $http_upgrade;
        # proxy_set_header Connection "upgrade";
        # proxy_http_version 1.1;
        proxy_redirect   off;
    }
}

server {
    listen 80;

    server_name linkace.example.com;
    return 301 https://linkace.example.com$request_uri;
}

[esturniolo]

I was trying to use the advanced one. So I'll try with the simple config and I'll come back to you.

[esturniolo]

In the meantime, the logs said something like this:

2022-11-16T14:56:37.787250260Z 2022/11/16 14:56:32 [emerg] 1#1: host not found in upstream "app" in /etc/nginx/conf.d/023-linkace.conf:53
2022-11-16T14:56:37.787322177Z nginx: [emerg] host not found in upstream "app" in /etc/nginx/conf.d/023-linkace.conf:53

I think that the problem is the app folder that you mention in your nginx.conf

BTW, I saw quickly the simple config and I don't see differences to use it in ansible nor nginx.
Am I wrong?

[Kovah]

The simple one has a web server built into it and is definitely the way to go for 99% of the use cases.

[martadinata666]

From what im reading, the error about 502 is caused by the nginx cant connect to the linkace app, essentially another container. In docker compose case the app and nginx should be sharing a single custom network that automatically created on the docker compose up -d command. Im not proficient enough to talk about ansible networking, but that is essentially your issue.

[esturniolo]

The simple one has a web server built into it and is definitely the way to go for 99% of the use cases.

Ohhh I see... The image is different. Thanks!

@martadinata666 Thanks for this.

Now the error 502 has gone, but now I've error 500... (Even from inside the container running a curl localhost)

The logs from the app is this one:

11/17/2022 12:17:53 PM
2022-11-17 15:17:53,188 INFO Set uid to user 0 succeeded
11/17/2022 12:17:53 PM
2022-11-17 15:17:53,193 INFO supervisord started with pid 1
11/17/2022 12:17:54 PM
2022-11-17 15:17:54,196 INFO spawned: 'php-fpm' with pid 7
11/17/2022 12:17:54 PM
2022-11-17 15:17:54,199 INFO spawned: 'nginx' with pid 8
11/17/2022 12:17:54 PM
[17-Nov-2022 15:17:54] NOTICE: fpm is running, pid 7
11/17/2022 12:17:54 PM
[17-Nov-2022 15:17:54] NOTICE: ready to handle connections
11/17/2022 12:17:55 PM
2022-11-17 15:17:55,266 INFO success: php-fpm entered RUNNING state, process has stayed up for > than 1 seconds (startsecs)
11/17/2022 12:17:55 PM
2022-11-17 15:17:55,266 INFO success: nginx entered RUNNING state, process has stayed up for > than 1 seconds (startsecs)
11/17/2022 12:19:20 PM
127.0.0.1 -  17/Nov/2022:15:19:20 +0000 "GET /index.php" 500
11/17/2022 12:19:20 PM
172.20.0.5 - - [17/Nov/2022:15:19:20 +0000] "GET / HTTP/1.0" 500 5333 "-" "Mozilla/5.0 (X11; Linux x86_64; rv:106.0) Gecko/20100101 Firefox/106.0" "MY.IP"
11/17/2022 12:19:22 PM
127.0.0.1 -  17/Nov/2022:15:19:22 +0000 "GET /index.php" 500
11/17/2022 12:19:22 PM
172.20.0.5 - - [17/Nov/2022:15:19:22 +0000] "GET / HTTP/1.0" 500 5333 "-" "Mozilla/5.0 (X11; Linux x86_64; rv:106.0) Gecko/20100101 Firefox/106.0" "MY.IP"
11/17/2022 12:19:48 PM
127.0.0.1 -  17/Nov/2022:15:19:48 +0000 "GET /index.php" 500
11/17/2022 12:19:48 PM
172.20.0.5 - - [17/Nov/2022:15:19:48 +0000] "GET / HTTP/1.0" 500 5333 "-" "Mozilla/5.0 (X11; Linux x86_64; rv:106.0) Gecko/20100101 Firefox/106.0" "MY.IP"
11/17/2022 12:21:29 PM
127.0.0.1 -  17/Nov/2022:15:21:29 +0000 "GET /index.php" 500
11/17/2022 12:21:29 PM
172.20.0.5 - - [17/Nov/2022:15:21:29 +0000] "GET / HTTP/1.0" 500 5333 "-" "Mozilla/5.0 (X11; Linux x86_64; rv:106.0) Gecko/20100101 Firefox/106.0" "MY.IP"
11/17/2022 12:21:58 PM
127.0.0.1 -  17/Nov/2022:15:21:58 +0000 "GET /index.php" 500
11/17/2022 12:21:58 PM
127.0.0.1 - - [17/Nov/2022:15:21:58 +0000] "GET / HTTP/1.1" 500 5269 "-" "curl/7.83.1" "-"

• 172.20.0.5 is my nginx where I've all my other apps running
• instead of MY.IP, of course here appears my public IP.

Now the MariaDB log:

11/17/2022 12:17:49 PM
2022-11-17 15:17:49+00:00 [Note] [Entrypoint]: Entrypoint script for MariaDB Server 1:10.7.7+maria~ubu2004 started.
11/17/2022 12:17:49 PM
2022-11-17 15:17:49+00:00 [Note] [Entrypoint]: Switching to dedicated user 'mysql'
11/17/2022 12:17:49 PM
2022-11-17 15:17:49+00:00 [Note] [Entrypoint]: Entrypoint script for MariaDB Server 1:10.7.7+maria~ubu2004 started.
11/17/2022 12:17:49 PM
2022-11-17 15:17:49+00:00 [Note] [Entrypoint]: MariaDB upgrade not required
11/17/2022 12:17:49 PM
2022-11-17 15:17:49 0 [Note] mysqld (server 10.7.7-MariaDB-1:10.7.7+maria~ubu2004) starting as process 1 ...
11/17/2022 12:17:49 PM
2022-11-17 15:17:49 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
11/17/2022 12:17:49 PM
2022-11-17 15:17:49 0 [Note] InnoDB: Using transactional memory
11/17/2022 12:17:49 PM
2022-11-17 15:17:49 0 [Note] InnoDB: Number of transaction pools: 1
11/17/2022 12:17:49 PM
2022-11-17 15:17:49 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions
11/17/2022 12:17:49 PM
2022-11-17 15:17:49 0 [Note] mysqld: O_TMPFILE is not supported on /tmp (disabling future attempts)
11/17/2022 12:17:49 PM
2022-11-17 15:17:49 0 [Note] InnoDB: Using Linux native AIO
11/17/2022 12:17:49 PM
2022-11-17 15:17:49 0 [Note] InnoDB: Initializing buffer pool, total size = 134217728, chunk size = 134217728
11/17/2022 12:17:49 PM
2022-11-17 15:17:49 0 [Note] InnoDB: Completed initialization of buffer pool
11/17/2022 12:17:49 PM
2022-11-17 15:17:49 0 [Note] InnoDB: 128 rollback segments are active.
11/17/2022 12:17:49 PM
2022-11-17 15:17:49 0 [Note] InnoDB: Creating shared tablespace for temporary tables
11/17/2022 12:17:49 PM
2022-11-17 15:17:49 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
11/17/2022 12:17:49 PM
2022-11-17 15:17:49 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
11/17/2022 12:17:49 PM
2022-11-17 15:17:49 0 [Note] InnoDB: 10.7.7 started; log sequence number 42404; transaction id 14
11/17/2022 12:17:49 PM
2022-11-17 15:17:49 0 [Note] Plugin 'FEEDBACK' is disabled.
11/17/2022 12:17:49 PM
2022-11-17 15:17:49 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
11/17/2022 12:17:49 PM
2022-11-17 15:17:49 0 [Note] InnoDB: Buffer pool(s) load completed at 221117 15:17:49
11/17/2022 12:17:49 PM
2022-11-17 15:17:49 0 [Warning] You need to use --log-bin to make --expire-logs-days or --binlog-expire-logs-seconds work.
11/17/2022 12:17:49 PM
2022-11-17 15:17:49 0 [Note] Server socket created on IP: '0.0.0.0'.
11/17/2022 12:17:49 PM
2022-11-17 15:17:49 0 [Note] Server socket created on IP: '::'.
11/17/2022 12:17:49 PM
2022-11-17 15:17:49 0 [Note] mysqld: ready for connections.
11/17/2022 12:17:49 PM
Version: '10.7.7-MariaDB-1:10.7.7+maria~ubu2004'  socket: '/run/mysqld/mysqld.sock'  port: 3306  mariadb.org binary distribution

I think that the connection between app and db it's ok. In a previous attempt I had a typo and the db log said that the "user can't connect with the database", so I assume that now, the connection is established.

Any clue?