Hello.
db_schema.mysql creates web admin user with this line:
INSERT INTO ocp_admin_privileges (username,password,first_name,last_name,ha1,available_tools,permissions) values ('admin','opensips','Super','Admin',md5('admin:opensips'),'all','all');
Internal function md5 was removed in MySQL 9.6.
ERROR 1305 (42000) at line 16: FUNCTION opensips.md5 does not exist
Workaround - use MySQL 9.5 or lower.
Hello.
db_schema.mysql creates web admin user with this line:
INSERT INTO ocp_admin_privileges (username,password,first_name,last_name,ha1,available_tools,permissions) values ('admin','opensips','Super','Admin',md5('admin:opensips'),'all','all');Internal function md5 was removed in MySQL 9.6.
ERROR 1305 (42000) at line 16: FUNCTION opensips.md5 does not existWorkaround - use MySQL 9.5 or lower.