Closed NetaliDev closed 1 year ago
Hi @NetaliDev
The migrations fail on initial setup.
I can't replicate this for on initial setup - it works fine via the installer script on Ubuntu 20.04 and 22.04.
I can replicate the issue when I wipe and migrate again.
The difference here is the installer is running as root MySQL user and the artisan script runs as the ixpmanager user.
I've committed the privilege escalation required to make this work as the artisan ixpmanager MySQL user now.
ISSUE TYPE
Bug Report
OS
NixOS 23.05
VERSION
ENVIRONMENT
CONFIGURATION
SUMMARY
The migrations fail on initial setup.
STEPS TO REPRODUCE
artisan migrate --force
twiceEXPECTED RESULTS
The migrations should finish without errors.
ACTUAL RESULTS
IMPORTANCE
I try to package IXP-Manager for NixOS for our new IXP and encountered this issue.
ADDITIONAL INFORMATION
My current workaround is to remove everything that relates to the
ixp
andcustomer_to_ixp
tables from2021-as-at-end-v5.sql
and then delete the failing migration2020_09_18_095136_delete_ixp_table
, but I would feel better if the migrations would work out of the box.