MultiGen installation mysql error
Closed this issue · 4 comments
Hello. First of all i would like to say thank you for the amazing software you have made.
Anyways, I was trying to set up MultiGen today with the help your documentation, but when running mysql -u root -p stg < ./docs/multigen/dump.sql from the FreeRADIUS3 configuration section, I typed the password in, but i got the following error:
ERROR 1060 (42S21) at line 175: Duplicate column name 'modifier'
How do I fix this?
Forgot to mention, Im using FreeBSD 13.2, and I installed UBilling yesterday, just like in the documentation
Hello,
For new installations you do not need to setup and configure manually MultiGen.
Refer to: https://wiki.ubilling.net.ua/doku.php?id=multigen#%D0%BF%D0%BE%D0%BF%D0%B5%D1%80%D0%B5%D0%B4%D0%BD%D1%94_%D0%BD%D0%B0%D0%BB%D0%B0%D1%88%D1%82%D1%83%D0%B2%D0%B0%D0%BD%D0%BD%D1%8F
You just need to enable and start the radiusd service
Closed because careless reading of the documentation is not a issue that needs to be resolved.
If you have separate instalation ub+stg and mysql:
It is advisable to upload dumps from the host on which billing is installed, otherwise problems may arise with the backup module when restore VIEWS.
https://dev.mysql.com/doc/refman/5.7/en/mysqlpump.html#option_mysqlpump_skip-definer
https://stackoverflow.com/questions/9446783/remove-definer-clause-from-mysql-dumps