Convert postgres db into a mysql db for Hex-Ray's Lumina server.

[ThisIsMyAltAccount]

Would anyone happen to know how to easily convert the postgres db into a mysql db use by the Hex-Rays Lumina server? Database's are a bit over my head.

There are two versions of Hex-Rays Lumina Server software. One version for IDA 7.2 - 8.0 and another one for IDA 8.1 and newer due to password auth.

A new database is created via:

./lumina_server_pro -v --config-file lumina.conf --recreate-schema 
Hex-Rays IDA Pro Lumina Server v8.1 Hex-Rays (c) 2022
Loading configuration file "lumina.conf"
Using connection string provided in configuration file "lumina.conf".
Executing: "DROP TABLE IF EXISTS schema_info;"
Executing: "DROP TABLE IF EXISTS history;"
Executing: "DROP TABLE IF EXISTS calcrel_hash;"
Executing: "DROP TABLE IF EXISTS func_freqs;"
Executing: "DROP TABLE IF EXISTS pushes;"
Executing: "DROP TABLE IF EXISTS funcs;"
Executing: "DROP TABLE IF EXISTS idbs;"
Executing: "DROP TABLE IF EXISTS inputs;"
Executing: "DROP TABLE IF EXISTS hostnames;"
Executing: "DROP TABLE IF EXISTS tlm_events;"
Executing: "DROP TABLE IF EXISTS tlm_sessions;"
Executing: "DROP TABLE IF EXISTS tlm_strings;"
Executing: "DROP VIEW IF EXISTS tlm_events_view;"
Executing: "DROP TABLE IF EXISTS users;"
Executing: "CREATE TABLE users( id int NOT NULL AUTO_INCREMENT, CONSTRAINT PK_users_id PRIMARY KEY(id),user_name varchar(255) not null,salt int DEFAULT null,passhash binary(32) DEFAULT null,passhash_nrounds int DEFAULT 0 not null,license_name varchar(255) not null,license_email varchar(255),license_id char(16),is_admin tinyint DEFAULT 0 not null,is_deleted tinyint default 0 not null,karma int DEFAULT 0 not null,last_active timestamp DEFAULT 0 , CONSTRAINT UNIQUE_users_user_name UNIQUE(user_name)) CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci;"
Executing: "CREATE TABLE hostnames( id int NOT NULL AUTO_INCREMENT, CONSTRAINT PK_hostnames_id PRIMARY KEY(id),name varchar(191),CONSTRAINT UNIQUE_hostnames_name UNIQUE(name)) CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci;"
Executing: "CREATE TABLE inputs( id int NOT NULL AUTO_INCREMENT, CONSTRAINT PK_inputs_id PRIMARY KEY(id),path varchar(760),hash binary(16),fk_hostname int,CONSTRAINT FK_inputs_hostname FOREIGN KEY(fk_hostname) REFERENCES hostnames(id)) CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci;"
Executing: "CREATE INDEX IND_inputs_hash on inputs(hash);"
Executing: "CREATE INDEX IND_inputs_path on inputs(path);"
Executing: "CREATE TABLE idbs( id int NOT NULL AUTO_INCREMENT, CONSTRAINT PK_idbs_id PRIMARY KEY(id),path varchar(760),fk_hostname int,fk_input int,fk_user int,CONSTRAINT FK_idbs_hostname FOREIGN KEY(fk_hostname) REFERENCES hostnames(id),CONSTRAINT FK_idbs_input FOREIGN KEY(fk_input) REFERENCES inputs(id),CONSTRAINT FK_idbs_user FOREIGN KEY(fk_user) REFERENCES users(id)) CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci;"
Executing: "CREATE TABLE pushes( id int NOT NULL AUTO_INCREMENT, CONSTRAINT PK_pushes_id PRIMARY KEY(id),time timestamp DEFAULT CURRENT_TIMESTAMP,fk_idb int,fk_user int,CONSTRAINT fk_push_idb FOREIGN KEY(fk_idb) REFERENCES idbs(id),CONSTRAINT fk_push_user FOREIGN KEY(fk_user) REFERENCES users(id)) CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci;"
Executing: "CREATE TABLE funcs( id int NOT NULL AUTO_INCREMENT, CONSTRAINT PK_funcs_id PRIMARY KEY(id),name varchar(4096),size int,ea bigint unsigned,metadata blob) CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci;"
Executing: "CREATE TABLE calcrel_hash(hash binary(16),fk_func int,CONSTRAINT PK_calcrel_hash_hash PRIMARY KEY(hash),CONSTRAINT FK_calcrel_hash_func FOREIGN KEY(fk_func) REFERENCES funcs(id)) CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci;"
Executing: "CREATE TABLE func_freqs(fk_func int,counter int,CONSTRAINT FK_func_freqs_func FOREIGN KEY(fk_func) REFERENCES funcs(id)) CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci;"
Executing: "CREATE INDEX IND_func_freqs_counter on func_freqs(counter);"
Executing: "CREATE TABLE history( id bigint NOT NULL AUTO_INCREMENT, CONSTRAINT PK_history_id PRIMARY KEY(id),time timestamp DEFAULT CURRENT_TIMESTAMP,fk_func int,fk_idb int,fk_push int,name varchar(4096),ea bigint unsigned,metadata blob,CONSTRAINT FK_history_func FOREIGN KEY(fk_func) REFERENCES funcs(id),CONSTRAINT FK_history_idb FOREIGN KEY(fk_idb) REFERENCES idbs(id),CONSTRAINT FK_history_push FOREIGN KEY(fk_push) REFERENCES pushes(id)) CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci;"
Executing: "CREATE INDEX IND_history_func_id on history(fk_func, id);"
Executing: "CREATE TABLE tlm_sessions( id bigint NOT NULL AUTO_INCREMENT, CONSTRAINT PK_tlm_sessions_id PRIMARY KEY(id),fk_user int,time timestamp DEFAULT CURRENT_TIMESTAMP,CONSTRAINT FK_tlm_sessions_user FOREIGN KEY(fk_user) REFERENCES users(id)) CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci;"
Executing: "CREATE TABLE tlm_strings( id int NOT NULL AUTO_INCREMENT, CONSTRAINT PK_tlm_strings_id PRIMARY KEY(id),data varchar(4096)) CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci;"
Executing: "INSERT INTO tlm_strings(data) VALUES('');"
Executing: "CREATE TABLE tlm_events( id bigint NOT NULL AUTO_INCREMENT, CONSTRAINT PK_tlm_events_id PRIMARY KEY(id),fk_sessions_id bigint,type int,widget int,time timestamp,arg0 int unsigned,arg1 int unsigned,arg2 int unsigned,arg3 int unsigned,arg4 int unsigned,CONSTRAINT FK_tlm_events_session FOREIGN KEY(fk_sessions_id) REFERENCES tlm_sessions(id),CONSTRAINT FK_tlm_events_widget FOREIGN KEY(widget) REFERENCES tlm_strings(id)) CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci;"
Executing: "CREATE VIEW tlm_events_view AS SELECT id, fk_sessions_id, type, widget, time, arg0, arg1, arg2, arg3, arg4,(select data from tlm_strings where tlm_strings.id = widget) as widget_s,(SELECT data from tlm_strings where((tlm_strings.id << 4) | 2) = arg0) as arg0_s,(SELECT data from tlm_strings where((tlm_strings.id << 4) | 2) = arg1) as arg1_s,(SELECT data from tlm_strings where((tlm_strings.id << 4) | 2) = arg2) as arg2_s,(SELECT data from tlm_strings where((tlm_strings.id << 4) | 2) = arg3) as arg3_s,(SELECT data from tlm_strings where((tlm_strings.id << 4) | 2) = arg4) as arg4_s FROM tlm_events;"
Executing: "CREATE TABLE schema_info (version int not null, authmode tinyint not null) CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci;"
Executing: "INSERT INTO schema_info values(1, 1);"
2022-10-18 01:24:11 Database has been initialized; exiting.

Sample db, (GitHub hates .sql file extention. Saved with .txt) I ran it on cmd.exe with a .pdb file and pushed metadata:

lumina.txt

Note: I had to run update users set id=0; inside mariadb since I do not have IDA 8.1. I also redacted my PC name. Also redacted a password for the 'alice' user that is used for managing the db via lc command.