search

nightflyza / Ubilling

Ubilling is opensource ISP billing system based on stargazer
https://ubilling.net.ua
GNU General Public License v2.0
134 stars 105 forks source link

MultiGen installation mysql error #812

Closed jukfiuune closed 1 year ago

jukfiuune commented 1 year ago

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?

jukfiuune commented 1 year ago

Forgot to mention, Im using FreeBSD 13.2, and I installed UBilling yesterday, just like in the documentation

l1ght13aby commented 1 year ago

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

nightflyza commented 1 year ago

Closed because careless reading of the documentation is not a issue that needs to be resolved.

mort1k commented 1 year ago

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