Installation issue

[satishahlawat]

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

[MattCaleb165]

This issue is fixed by going into the webadmin docker container, going into the /var/www/html/sql directory and edit the schema-5.sql file. Remote lines 6-8 "ALTER TABLE user ADD COLUMN...". It should work then. The redirect after setting up the admin login probably won't work -- but you can then login as an admin and set up your user accounts.

[sm00v]

This issue is fixed by going into the webadmin docker container, going into the /var/www/html/sql directory and edit the schema-5.sql file. Remote lines 6-8 "ALTER TABLE user ADD COLUMN...". It should work then. The redirect after setting up the admin login probably won't work -- but you can then login as an admin and set up your user accounts.

This definitely doesn't work. The only thing i've been able to do to get your fork to load is manually go into the config.sh on the openvpn server and config.php on the webmin server and manually input the IP address of the mysql server for the $host/HOST variable. There is something wrong with the way the compose is built I think. It does not initialize the database/ will not create database and tables.

When you go to index.php?installation after getting the UI going, when submitting the admin creds, it fails as well. This is just broken.

Edit: I also had to run these commands on the sql server: mysql -u root -p Enter password: <enter password> mysql>GRANT ALL ON *.* to root@'123.123.123.123' IDENTIFIED BY 'put-your-password'; mysql>FLUSH PRIVILEGES; mysql>exit

which you can then check access to the mysql server from webmin and openvpn server with: mysql -u root -h 'any ip address here' -p

[Vlkino]

I tried one of the forked repo ( https://github.com/dpnkvrm/OpenVPN-Docker-GoogleAuth ) and its working likes its in the readme. @dpnkvrm make some changes and most of it was connected with db, check his repo.