shupp / vegadns-api Goto Github PK

files are not located in root, missing sql/ path prefix
mysql -u vegadns -p -h localhost vegadns < sql/new_tables_only.sql
mysql -u vegadns -p -h localhost vegadns < alter-01.sql
mysql -u vegadns -p -h localhost vegadns < alter-02.sql
mysql -u vegadns -p -h localhost vegadns < alter-03.sql
mysql -u vegadns -p -h localhost vegadns < sql/data_api_keys_only.sql
should be:
mysql -u vegadns -p -h localhost vegadns < sql/new_tables_only.sql
mysql -u vegadns -p -h localhost vegadns < sql/alter-01.sql
mysql -u vegadns -p -h localhost vegadns < sql/alter-02.sql
mysql -u vegadns -p -h localhost vegadns < sql/alter-03.sql
mysql -u vegadns -p -h localhost vegadns < sql/data_api_keys_only.sql

[email protected] <--- is a valid email address, yet the api thinks it isn't.

Hi, I am using VEGADNS now for more than 10 years :) Found your api/ui docker image, which I managed to run, but where can I get the list of ENV variables I can use? I need to setup mysql and stuff and import my old database from 13.3 somehow.

Converted swagger 2 to 3

vegadns.txt

After download change extension file from txt to yaml

• Hard coded python3 interpreter in the Makefile
• After changing that ... the command source not found .. as csh is the default shell.

ReadMe says to run the commands below to import sql files when using a legacy mysql database. I did this however I received an error on the default records page in the ui and when selecting a domain. After some checking it appears there are 2 new columns (weight & port) in these mysql tables (records & default_records) that arent added by these sql files causing a read error in the ui on these pages. Adding these columns to the tables fixed the issue on the ui and it was then able to display. Commands I used are below. Is there anything else I need to do to ensure the legacy database is fully functional?

mysql -u vegadns -p -h localhost vegadns < /vegadns-api/sql/new_tables_only.sql
mysql -u vegadns -p -h localhost vegadns < /vegadns-api/sql/alter-01.sql
mysql -u vegadns -p -h localhost vegadns < /vegadns-api/sql/alter-02.sql
mysql -u vegadns -p -h localhost vegadns < /vegadns-api/sql/alter-03.sql
mysql -u vegadns -p -h localhost vegadns < /vegadns-api/sql/data_api_keys_only.sql

ALTER TABLE default_records add column weight int(4) after distance;
ALTER TABLE default_records add column port int(4) after weight;
ALTER TABLE records add column weight int(4) after distance;
ALTER TABLE records add column port int(4) after weight;