armindocachada / openvpn-docker-googleauth Goto Github PK

I get the following error.

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
  File "docker-compose", line 3, in <module>
  File "compose/cli/main.py", line 81, in main
  File "compose/cli/main.py", line 200, in perform_command
  File "compose/cli/command.py", line 70, in project_from_options
  File "compose/cli/command.py", line 153, in get_project
  File "compose/cli/docker_client.py", line 43, in get_client
  File "compose/cli/docker_client.py", line 170, in docker_client
  File "docker/api/client.py", line 197, in __init__
  File "docker/api/client.py", line 222, in _retrieve_server_version
docker.errors.DockerException: Error while fetching server API version: ('Connection aborted.', FileNotFoundError(2, 'No such file or directory'))
[2422] Failed to execute script docker-compose

after renaming and .env_template to .env and changing things
installs fine then running
http://localhost:8080/index.php?installation
works but when submitting the sql quetry dies
running on debian 11

I have created 2 folders openvpn_config and db_data. However, after creating it, I can't access webadmin. If I don't create the folder everything works properly. Where am I wrong?

ADD ";" in line 6 on pod webadmin route /var/www/html/sql/schema-5.sql before run localhost:8080/index.php?installation

alter table user ADD COLUMN user_2factor tinyint(1) NOT NULL DEFAULT '1';

Fatal error: Uncaught PDOException: SQLSTATE[HY000] [1045] Access denied for user 'openvpn-admin'@'172.18.0.5' (using password: YES) in /var/www/html/include/connect.php:5 Stack trace: #0 /var/www/html/include/connect.php(5): PDO->__construct('mysql:host=db;p...', 'openvpn-admin', 'aRandomPassword', Array) #1 /var/www/html/index.php(5): require('/var/www/html/i...') #2 {main} thrown in /var/www/html/include/connect.php on line 5

I am not sure how to fix this issue

Once installed immediately after creating an Administrator account, it gives this error:

SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'alter table user ADD COLUMN user_2factor_scode varchar(255) COLLATE utf8...' at line 2

I have following problem that docker-compose writes me following:

=> CACHED [ 9/15] RUN sed -i "s/$host\ =\ 'localhost'/$host = 'db'/" "/var/www/html/include/config.php" && sed -i "s/$pass\ =\ ''/$pass = getenv('OPENVPN_ADMIN_PASSWORD')/" "/var/www/html/inc 0.0s
=> ERROR [10/15] RUN curl -L https://npmjs.org/install.sh | sh 3.2s

[10/15] RUN curl -L https://npmjs.org/install.sh | sh:
0.273 % Total % Received % Xferd Average Speed Time Time Time Current
0.273 Dload Upload Total Spent Left Speed
0 0 0 0 0 0 0 0 --:--:-- --:--:-- --:--:-- 0
100 3755 100 3755 0 0 9778 0 --:--:-- --:--:-- --:--:-- 87325
1.992 fetching: https://registry.npmjs.org/npm/-/npm-10.2.3.tgz
2.745 removing existing npm
2.861 ERROR: npm v10.2.3 is known not to run on Node.js v12.22.12. This version of npm supports the following node versions: ^18.17.0 || >=20.5.0. You can find the latest version at https://nodejs.org/.
2.861
2.861 ERROR:
2.863 /tmp/npm.15/package/lib/utils/exit-handler.js:19
2.863 const hasLoadedNpm = npm?.config.loaded
2.863 ^
2.863
2.863 SyntaxError: Unexpected token '.'
2.863 at wrapSafe (internal/modules/cjs/loader.js:915:16)
2.863 at Module._compile (internal/modules/cjs/loader.js:963:27)
2.863 at Object.Module._extensions..js (internal/modules/cjs/loader.js:1027:10)
2.863 at Module.load (internal/modules/cjs/loader.js:863:32)
2.863 at Function.Module._load (internal/modules/cjs/loader.js:708:14)
2.863 at Module.require (internal/modules/cjs/loader.js:887:19)
2.863 at require (internal/modules/cjs/helpers.js:74:18)
2.863 at module.exports (/tmp/npm.15/package/lib/cli-entry.js:15:23)
2.863 at module.exports (/tmp/npm.15/package/lib/es6/validate-engines.js:39:10)
2.863 at module.exports (/tmp/npm.15/package/lib/cli.js:4:31)
2.866 failed!

Dockerfile_webadmin:22

20 | sed -i "s/$user\ =\ ''/$user = getenv('OPENVPN_ADMIN_USER')/" "/var/www/html/include/config.php" &&
21 | sed -i "s/$app_name\ =\ ''/$app_name = getenv('OPENVPN_APP_NAME')/" "/var/www/html/include/config.php"
22 | >>> RUN curl -L https://npmjs.org/install.sh | sh
23 |
24 | WORKDIR /var/www/html

ERROR: failed to solve: process "/bin/sh -c curl -L https://npmjs.org/install.sh | sh" did not complete successfully: exit code: 1
ERROR: Service 'webadmin' failed to build : Build failed
root@sebastian-MiniAir-11:/home/sebastian/OpenVPN-Docker-GoogleAuth# node --version
v20.5.1

As you see node v20.5.1 is installed.

Hello,

This error happens when exec docker-composer up -d:

WARNING: The HOST_SSL_PORT variable is not set. Defaulting to a blank string.
WARNING: The MYSQL_ROOT_PASSWORD variable is not set. Defaulting to a blank string.
WARNING: The OPENVPN_ADMIN_DATABASE variable is not set. Defaulting to a blank string.
WARNING: The OPENVPN_ADMIN_USER variable is not set. Defaulting to a blank string.
WARNING: The OPENVPN_ADMIN_PASSWORD variable is not set. Defaulting to a blank string.
ERROR: The Compose file './docker-compose.yml' is invalid because:
services.openvpn.ports contains an invalid type, it should be a number, or an object