The mailing list for listmasters using Sympa

["Mail administrator, Otto Makela" <address@concealed>]

(My first attempt at this message was rejected with 550 5.7.1 Policy reason,
which is strange, what am I doing wrong here? I'll obfuscate the only URL)

Now that I've mostly got the strangeish combo of RHEL8 with RHEL7
Sympa packages mostly working, it's time to get the lists migrated.

hxxps://sympa-community.github.io/manual/upgrade/in-place.html

As suggested in this document, I've tried pulling in the mysql database
from the old installation (Sympa 6.1.4) and letting the new installation
(Sympa 6.2.62) try to upgrade it.

Doesn't really work, I get no table data transferred at all. Lists with
content from LDAP of course will regain their memebers that way, but things
like subscribed lists, owners, moderators, exclusions and so on don't
get there.

Can someone familiar with the database structure (and mysql/mariadb) fill
me in what's happening in the log below, what's going so dramatically wrong
that nothing's being transferred and how would I go about remedying this?

----

# /bin/systemctl start sympa.service
2021-08-19T17:08:47.150344+03:00 myserver sympa/health_check[15222]: info 
main:: Configuration file read, default log level 0
2021-08-19T17:08:47.177723+03:00 myserver sympa/health_check[15222]: notice 
Sympa::DatabaseManager::_check_fields() Field "last_active_date_user" (table 
"user_table"; database "sympa") was NOT found. Attempting to add it...
2021-08-19T17:08:47.184629+03:00 myserver sympa/health_check[15222]: info 
Sympa::DatabaseDriver::MySQL::add_field() Field last_active_date_user added 
to table user_table (options: )
2021-08-19T17:08:47.184845+03:00 myserver sympa/health_check[15222]: notice 
Sympa::DatabaseManager::_check_fields() Field "password_user" (table 
"user_table"; database "sympa") does NOT have awaited type (varchar(64)) 
where type in database seems to be (varchar(40)). Attempting to change it...
2021-08-19T17:08:47.184996+03:00 myserver sympa/health_check[15222]: notice 
Sympa::DatabaseDriver::MySQL::update_field() ALTER TABLE user_table CHANGE 
password_user password_user varchar(64)
2021-08-19T17:08:47.191106+03:00 myserver sympa/health_check[15222]: info 
Sympa::DatabaseDriver::MySQL::update_field() Field password_user in table 
user_table, structure updated
2021-08-19T17:08:47.192673+03:00 myserver sympa/health_check[15222]: notice 
Sympa::DatabaseManager::_check_fields() Field "date_epoch_admin" (table 
"admin_table"; database "sympa") was NOT found. Attempting to add it...
2021-08-19T17:08:47.199321+03:00 myserver sympa/health_check[15222]: info 
Sympa::DatabaseDriver::MySQL::add_field() Field date_epoch_admin added to 
table admin_table (options: )
2021-08-19T17:08:47.199432+03:00 myserver sympa/health_check[15222]: notice 
Sympa::DatabaseManager::_check_fields() Field "inclusion_admin" (table 
"admin_table"; database "sympa") was NOT found. Attempting to add it...
2021-08-19T17:08:47.206259+03:00 myserver sympa/health_check[15222]: info 
Sympa::DatabaseDriver::MySQL::add_field() Field inclusion_admin added to 
table admin_table (options: )
2021-08-19T17:08:47.206595+03:00 myserver sympa/health_check[15222]: notice 
Sympa::DatabaseManager::_check_fields() Field "inclusion_ext_admin" (table 
"admin_table"; database "sympa") was NOT found. Attempting to add it...
2021-08-19T17:08:47.213421+03:00 myserver sympa/health_check[15222]: info 
Sympa::DatabaseDriver::MySQL::add_field() Field inclusion_ext_admin added to 
table admin_table (options: )
2021-08-19T17:08:47.213519+03:00 myserver sympa/health_check[15222]: notice 
Sympa::DatabaseManager::_check_fields() Field "inclusion_label_admin" (table 
"admin_table"; database "sympa") was NOT found. Attempting to add it...
2021-08-19T17:08:47.221190+03:00 myserver sympa/health_check[15222]: info 
Sympa::DatabaseDriver::MySQL::add_field() Field inclusion_label_admin added 
to table admin_table (options: )
2021-08-19T17:08:47.221299+03:00 myserver sympa/health_check[15222]: notice 
Sympa::DatabaseManager::_check_fields() Field "update_epoch_admin" (table 
"admin_table"; database "sympa") was NOT found. Attempting to add it...
2021-08-19T17:08:47.228223+03:00 myserver sympa/health_check[15222]: info 
Sympa::DatabaseDriver::MySQL::add_field() Field update_epoch_admin added to 
table admin_table (options: )
2021-08-19T17:08:47.229588+03:00 myserver sympa/health_check[15222]: notice 
Sympa::DatabaseManager::_check_indexes() Removing obsolete index user_index
2021-08-19T17:08:47.235361+03:00 myserver sympa/health_check[15222]: info 
Sympa::DatabaseDriver::MySQL::unset_index() Table admin_table, index 
user_index dropped
2021-08-19T17:08:47.235447+03:00 myserver sympa/health_check[15222]: notice 
Sympa::DatabaseManager::_check_indexes() Index admin_user_index on table 
admin_table does not exist. Adding it
2021-08-19T17:08:47.242457+03:00 myserver sympa/health_check[15222]: info 
Sympa::DatabaseDriver::MySQL::set_index() Table admin_table, index 
admin_user_index set using fields user_admin
2021-08-19T17:08:47.243426+03:00 myserver sympa/health_check[15222]: notice 
Sympa::DatabaseManager::_check_fields() Field "usec_logs" (table 
"logs_table"; database "sympa") was NOT found. Attempting to add it...
2021-08-19T17:08:47.441601+03:00 myserver sympa/health_check[15222]: info 
Sympa::DatabaseDriver::MySQL::add_field() Field usec_logs added to table 
logs_table (options: )
2021-08-19T17:08:47.442720+03:00 myserver sympa/health_check[15222]: info 
Sympa::DatabaseManager::_check_key() Table logs_table: Found unexpected key 
part id_logs in primary key
2021-08-19T17:08:47.575827+03:00 myserver sympa/health_check[15222]: info 
Sympa::DatabaseDriver::MySQL::unset_primary_key() Table logs_table, PRIMARY 
KEY dropped
2021-08-19T17:08:47.576889+03:00 myserver sympa/health_check[15222]: notice 
Sympa::DatabaseManager::_check_fields() Field "family_exclusion" (table 
"exclusion_table"; database "sympa") was NOT found. Attempting to add it...
2021-08-19T17:08:47.579609+03:00 myserver sympa/health_check[15222]: info 
Sympa::DatabaseDriver::MySQL::add_field() Field family_exclusion added to 
table exclusion_table (options: )
2021-08-19T17:08:47.579691+03:00 myserver sympa/health_check[15222]: notice 
Sympa::DatabaseManager::_check_fields() Field "list_exclusion" (table 
"exclusion_table"; database "sympa") does NOT have awaited type (varchar(57)) 
where type in database seems to be (varchar(50)). Attempting to change it...
2021-08-19T17:08:47.579746+03:00 myserver sympa/health_check[15222]: notice 
Sympa::DatabaseDriver::MySQL::update_field() ALTER TABLE exclusion_table 
CHANGE list_exclusion list_exclusion varchar(57)
2021-08-19T17:08:47.581787+03:00 myserver sympa/health_check[15222]: info 
Sympa::DatabaseDriver::MySQL::update_field() Field list_exclusion in table 
exclusion_table, structure updated
2021-08-19T17:08:47.581862+03:00 myserver sympa/health_check[15222]: notice 
Sympa::DatabaseManager::_check_fields() Field "robot_exclusion" (table 
"exclusion_table"; database "sympa") was NOT found. Attempting to add it...
2021-08-19T17:08:47.584175+03:00 myserver sympa/health_check[15222]: info 
Sympa::DatabaseDriver::MySQL::add_field() Field robot_exclusion added to 
table exclusion_table (options: )
2021-08-19T17:08:47.585068+03:00 myserver sympa/health_check[15222]: info 
Sympa::DatabaseManager::_check_key() Table exclusion_table: Missing expected 
key part family_exclusion in primary key
2021-08-19T17:08:47.585142+03:00 myserver sympa/health_check[15222]: info 
Sympa::DatabaseManager::_check_key() Table exclusion_table: Missing expected 
key part robot_exclusion in primary key
2021-08-19T17:08:47.587372+03:00 myserver sympa/health_check[15222]: info 
Sympa::DatabaseDriver::MySQL::unset_primary_key() Table exclusion_table, 
PRIMARY KEY dropped
2021-08-19T17:08:47.589476+03:00 myserver sympa/health_check[15222]: info 
Sympa::DatabaseDriver::MySQL::set_primary_key() Table exclusion_table, 
PRIMARY KEY set on 
user_exclusion,family_exclusion,robot_exclusion,list_exclusion
2021-08-19T17:08:47.589997+03:00 myserver sympa/health_check[15222]: notice 
Sympa::DatabaseManager::_check_indexes() Removing obsolete index user_index
2021-08-19T17:08:47.592635+03:00 myserver sympa/health_check[15222]: info 
Sympa::DatabaseDriver::MySQL::unset_index() Table exclusion_table, index 
user_index dropped
2021-08-19T17:08:47.592711+03:00 myserver sympa/health_check[15222]: notice 
Sympa::DatabaseManager::_check_fields() Field "date_epoch_subscriber" (table 
"subscriber_table"; database "sympa") was NOT found. Attempting to add it...
2021-08-19T17:08:47.654775+03:00 myserver sympa/health_check[15222]: info 
Sympa::DatabaseDriver::MySQL::add_field() Field date_epoch_subscriber added 
to table subscriber_table (options: )
2021-08-19T17:08:47.654910+03:00 myserver sympa/health_check[15222]: notice 
Sympa::DatabaseManager::_check_fields() Field "inclusion_ext_subscriber" 
(table "subscriber_table"; database "sympa") was NOT found. Attempting to add 
it...
2021-08-19T17:08:47.711048+03:00 myserver sympa/health_check[15222]: info 
Sympa::DatabaseDriver::MySQL::add_field() Field inclusion_ext_subscriber 
added to table subscriber_table (options: )
2021-08-19T17:08:47.711172+03:00 myserver sympa/health_check[15222]: notice 
Sympa::DatabaseManager::_check_fields() Field "inclusion_label_subscriber" 
(table "subscriber_table"; database "sympa") was NOT found. Attempting to add 
it...
2021-08-19T17:08:47.770615+03:00 myserver sympa/health_check[15222]: info 
Sympa::DatabaseDriver::MySQL::add_field() Field inclusion_label_subscriber 
added to table subscriber_table (options: )
2021-08-19T17:08:47.770760+03:00 myserver sympa/health_check[15222]: notice 
Sympa::DatabaseManager::_check_fields() Field "inclusion_subscriber" (table 
"subscriber_table"; database "sympa") was NOT found. Attempting to add it...
2021-08-19T17:08:47.823603+03:00 myserver sympa/health_check[15222]: info 
Sympa::DatabaseDriver::MySQL::add_field() Field inclusion_subscriber added to 
table subscriber_table (options: )
2021-08-19T17:08:47.823760+03:00 myserver sympa/health_check[15222]: notice 
Sympa::DatabaseManager::_check_fields() Field "number_messages_subscriber" 
(table "subscriber_table"; database "sympa") was NOT found. Attempting to add 
it...
2021-08-19T17:08:47.877011+03:00 myserver sympa/health_check[15222]: info 
Sympa::DatabaseDriver::MySQL::add_field() Field number_messages_subscriber 
added to table subscriber_table (options: )
2021-08-19T17:08:47.877154+03:00 myserver sympa/health_check[15222]: notice 
Sympa::DatabaseManager::_check_fields() Field "update_epoch_subscriber" 
(table "subscriber_table"; database "sympa") was NOT found. Attempting to add 
it...
2021-08-19T17:08:47.930229+03:00 myserver sympa/health_check[15222]: info 
Sympa::DatabaseDriver::MySQL::add_field() Field update_epoch_subscriber added 
to table subscriber_table (options: )
2021-08-19T17:08:47.931784+03:00 myserver sympa/health_check[15222]: notice 
Sympa::DatabaseManager::_check_indexes() Removing obsolete index user_index
2021-08-19T17:08:47.969157+03:00 myserver sympa/health_check[15222]: info 
Sympa::DatabaseDriver::MySQL::unset_index() Table subscriber_table, index 
user_index dropped
2021-08-19T17:08:47.969277+03:00 myserver sympa/health_check[15222]: notice 
Sympa::DatabaseManager::_check_indexes() Index subscriber_user_index on table 
subscriber_table does not exist. Adding it
2021-08-19T17:08:48.021904+03:00 myserver sympa/health_check[15222]: info 
Sympa::DatabaseDriver::MySQL::set_index() Table subscriber_table, index 
subscriber_user_index set using fields user_subscriber
2021-08-19T17:08:48.027843+03:00 myserver sympa/health_check[15222]: notice 
Sympa::DatabaseManager::_check_fields() Field "prev_id_session" (table 
"session_table"; database "sympa") was NOT found. Attempting to add it...
2021-08-19T17:08:48.030954+03:00 myserver sympa/health_check[15222]: info 
Sympa::DatabaseDriver::MySQL::add_field() Field prev_id_session added to 
table session_table (options: )
2021-08-19T17:08:48.031134+03:00 myserver sympa/health_check[15222]: notice 
Sympa::DatabaseManager::_check_fields() Field "refresh_date_session" (table 
"session_table"; database "sympa") was NOT found. Attempting to add it...
2021-08-19T17:08:48.033991+03:00 myserver sympa/health_check[15222]: info 
Sympa::DatabaseDriver::MySQL::add_field() Field refresh_date_session added to 
table session_table (options: )
2021-08-19T17:08:48.035627+03:00 myserver sympa/health_check[15222]: notice 
Sympa::DatabaseManager::_check_indexes() Index session_prev_id_index on table 
session_table does not exist. Adding it
2021-08-19T17:08:48.039316+03:00 myserver sympa/health_check[15222]: info 
Sympa::DatabaseDriver::MySQL::set_index() Table session_table, index 
session_prev_id_index set using fields prev_id_session
2021-08-19T17:08:48.167911+03:00 myserver sympa/health_check[15222]: notice 
Sympa::Spindle::ProcessTemplate::_twist() Processing Sympa::Message::Template 
<address@concealed,3966>; 
address@concealed; 
address@concealed; recipients=ARRAY; 
address@concealed; template=listmaster_notification; 
type=db_struct_updated
2021-08-19T17:08:48.476013+03:00 myserver sympa/health_check[15222]: notice 
Sympa::Mailer::store() Done sending message Sympa::Message::Template 
<address@concealed,3966> for * (priority 1) in 0 
seconds since scheduled expedition date
[root@myserver imt]# 2021-08-19T17:08:49.113119+03:00 myserver 
sympa_msg[15230]: info main::_load() Configuration file read, default log 
level 0
2021-08-19T17:08:49.137394+03:00 myserver sympa_msg[15230]: notice 
Sympa::Process::daemonize() Starting sympa/msg daemon, PID 15234
2021-08-19T17:08:49.137520+03:00 myserver sympa_msg[15234]: notice main:: 
Sympa/msg 6.2.62 Started
2021-08-19T17:08:50.426612+03:00 myserver archived[15247]: notice main:: 
Archived 6.2.62 Started
2021-08-19T17:08:50.445160+03:00 myserver bulk[15238]: info main:: 
Configuration file read, default log level 0
2021-08-19T17:08:50.451293+03:00 myserver bulk[15238]: notice 
Sympa::Process::daemonize() Starting bulk daemon, PID 15248
2021-08-19T17:08:50.451398+03:00 myserver bulk[15248]: notice main:: Bulk 
6.2.62 Started
2021-08-19T17:08:50.459635+03:00 myserver task_manager[15237]: info main:: 
Configuration file read, default log level 0
2021-08-19T17:08:50.465894+03:00 myserver task_manager[15237]: notice 
Sympa::Process::daemonize() Starting task_manager daemon, PID 15249
2021-08-19T17:08:50.483142+03:00 myserver bounced[15250]: notice main:: 
Bounced 6.2.62 Started
2021-08-19T17:08:50.494212+03:00 myserver task_manager[15237]: notice main:: 
Task_Manager 6.2.62 Started

-- 
mailadm@mydomain (Mail Administrator, Otto J. Makela)