The mailing list for listmasters using Sympa

[Tim Kuehn <address@concealed>]

I'm working through a test upgrade from 5.4.7 to 6.2.4.

The current "/etc/sympa/sympa.conf" file is owned by "sympa:sympa as
is everything under /home/sympa
I made a copy of my "5.4.7" system, then installed the 6.2.4 code,
then as root ran

./sympa_wizard.pl --check
./sympa.pl --upgrade

Most of the upgrade process looks good, I'm concerned about some
run-time errors being reported during the upgrade. Samples of the
specific errors I'm concerned about follow. Should I be concerned or
are these spurious errors I can safely ignored?

Tim

closedir() attempted on invalid dirhandle DIR at
/home/sympa/bin/Sympa/Tools/File.pm line 356.

Use of uninitialized value $v in sprintf at
/home/sympa/bin/Sympa/Upgrade.pm line 1200.

Unable to rename /etc/sympa/sympa.conf: Permission denied at
/home/sympa/bin/Sympa/Upgrade.pm line 1211.

Unable to rename /etc/sympa/wwsympa.conf: Permission denied at
/home/sympa/bin/Sympa/Upgrade.pm line 1236.

err main::#797 > Sympa::Upgrade::upgrade#1460 >
Sympa::Upgrade::fix_colors#1989 Unable to rename /etc/sympa/sympa.conf
file: Permission denied. Web interface might look buggy after upgrade

---

The entire upgrade text follows:


---
[root@sympa bin]# ./sympa.pl --upgrade
err Conf::_detect_unknown_parameters_in_config() Line 17 of
sympa.conf, parameter localedir is now obsolete
err Conf::_detect_unknown_parameters_in_config() Line 158 of
sympa.conf, parameter openssl is now obsolete
err Conf::_detect_unknown_parameters_in_config() Line 11 of
sympa.conf, parameter pidfile is now obsolete
notice Conf::_load_server_specific_secondary_config_files()
/etc/sympa/wwsympa.conf was found but it is no longer loaded.  Please
run sympa.pl --upgrade to migrate it
err main::#248 > main::_load#1048 >
Sympa::DatabaseManager::instance#54 >
Sympa::DatabaseDriver::MySQL::connect#53 >
Sympa::Database::connect#155 Can't connect to Database
Sympa::DatabaseDriver::MySQL
<db_host=localhost;db_name=sympa;db_user=sympa>
Database sympa defined in sympa.conf is unreachable. verify db_xxx
parameters in sympa.conf
[root@sympa bin]# ./sympa.pl --upgrade
notice Conf::_load_server_specific_secondary_config_files()
/etc/sympa/wwsympa.conf was found but it is no longer loaded.  Please
run sympa.pl --upgrade to migrate it
notice Conf::_load_server_specific_secondary_config_files()
/etc/sympa/wwsympa.conf was found but it is no longer loaded.  Please
run sympa.pl --upgrade to migrate it
notice Conf::checkfiles_as_root() Created missing file /etc/mail/sympa_aliases
notice main:: Sympa 6.2.4 Started
notice main:: Upgrade process...
notice main:: Upgrading from 5.4.7 to 6.2.4...
notice Sympa::DatabaseManager::probe_db() Table conf_table created in
database sympa
notice Sympa::DatabaseManager::probe_db() Table notification_table
created in database sympa
notice Sympa::DatabaseManager::probe_db() Table exclusion_table
created in database sympa
notice Sympa::DatabaseManager::probe_db() Table stat_counter_table
created in database sympa
notice Sympa::DatabaseManager::probe_db() Table list_table created in
database sympa
notice Sympa::DatabaseManager::probe_db() Table one_time_ticket_table
created in database sympa
notice Sympa::DatabaseManager::probe_db() Table stat_table created in
database sympa
notice Sympa::DatabaseManager::_check_fields() Field "label_conf"
(table "conf_table"; database "sympa") was NOT found. Attempting to
add it...
notice Sympa::DatabaseManager::_check_fields() Field "robot_conf"
(table "conf_table"; database "sympa") was NOT found. Attempting to
add it...
notice Sympa::DatabaseManager::_check_fields() Field "value_conf"
(table "conf_table"; database "sympa") was NOT found. Attempting to
add it...
notice Sympa::DatabaseManager::_check_primary_key() Primary key
conf_table [robot_conf,label_conf] is missing. Adding it
notice Sympa::DatabaseManager::_check_fields() Field
"arrival_date_notification" (table "notification_table"; database
"sympa") was NOT found. Attempting to add it...
notice Sympa::DatabaseManager::_check_fields() Field
"arrival_epoch_notification" (table "notification_table"; database
"sympa") was NOT found. Attempting to add it...
notice Sympa::DatabaseManager::_check_fields() Field
"date_notification" (table "notification_table"; database "sympa") was
NOT found. Attempting to add it...
notice Sympa::DatabaseManager::_check_fields() Field
"list_notification" (table "notification_table"; database "sympa") was
NOT found. Attempting to add it...
notice Sympa::DatabaseManager::_check_fields() Field
"message_id_notification" (table "notification_table"; database
"sympa") was NOT found. Attempting to add it...
notice Sympa::DatabaseManager::_check_fields() Field "pk_notification"
(table "notification_table"; database "sympa") was NOT found.
Attempting to add it...
notice Sympa::DatabaseManager::_check_fields() Field
"reception_option_notification" (table "notification_table"; database
"sympa") was NOT found. Attempting to add it...
notice Sympa::DatabaseManager::_check_fields() Field
"recipient_notification" (table "notification_table"; database
"sympa") was NOT found. Attempting to add it...
notice Sympa::DatabaseManager::_check_fields() Field
"robot_notification" (table "notification_table"; database "sympa")
was NOT found. Attempting to add it...
notice Sympa::DatabaseManager::_check_fields() Field
"status_notification" (table "notification_table"; database "sympa")
was NOT found. Attempting to add it...
notice Sympa::DatabaseManager::_check_fields() Field
"type_notification" (table "notification_table"; database "sympa") was
NOT found. Attempting to add it...
notice Sympa::DatabaseManager::_check_fields() Field
"last_active_date_user" (table "user_table"; database "sympa") was NOT
found. Attempting to add it...
notice Sympa::DatabaseManager::_check_fields() Field
"last_login_date_user" (table "user_table"; database "sympa") was NOT
found. Attempting to add it...
notice Sympa::DatabaseManager::_check_fields() Field
"last_login_host_user" (table "user_table"; database "sympa") was NOT
found. Attempting to add it...
notice Sympa::DatabaseManager::_check_fields() Field
"wrong_login_count_user" (table "user_table"; database "sympa") was
NOT found. Attempting to add it...
notice Sympa::DatabaseManager::_check_fields() Field "date_exclusion"
(table "exclusion_table"; database "sympa") was NOT found. Attempting
to add it...
notice Sympa::DatabaseManager::_check_fields() Field
"family_exclusion" (table "exclusion_table"; database "sympa") was NOT
found. Attempting to add it...
notice Sympa::DatabaseManager::_check_fields() Field "list_exclusion"
(table "exclusion_table"; database "sympa") was NOT found. Attempting
to add it...
notice Sympa::DatabaseManager::_check_fields() Field "robot_exclusion"
(table "exclusion_table"; database "sympa") was NOT found. Attempting
to add it...
notice Sympa::DatabaseManager::_check_fields() Field "user_exclusion"
(table "exclusion_table"; database "sympa") was NOT found. Attempting
to add it...
notice Sympa::DatabaseManager::_check_primary_key() Primary key
exclusion_table
[user_exclusion,robot_exclusion,family_exclusion,list_exclusion] is
missing. Adding it
notice Sympa::DatabaseManager::_check_fields() Field
"beginning_date_counter" (table "stat_counter_table"; database
"sympa") was NOT found. Attempting to add it...
notice Sympa::DatabaseManager::_check_fields() Field "count_counter"
(table "stat_counter_table"; database "sympa") was NOT found.
Attempting to add it...
notice Sympa::DatabaseManager::_check_fields() Field "data_counter"
(table "stat_counter_table"; database "sympa") was NOT found.
Attempting to add it...
notice Sympa::DatabaseManager::_check_fields() Field
"end_date_counter" (table "stat_counter_table"; database "sympa") was
NOT found. Attempting to add it...
notice Sympa::DatabaseManager::_check_fields() Field "list_counter"
(table "stat_counter_table"; database "sympa") was NOT found.
Attempting to add it...
notice Sympa::DatabaseManager::_check_fields() Field "robot_counter"
(table "stat_counter_table"; database "sympa") was NOT found.
Attempting to add it...
notice Sympa::DatabaseManager::_check_fields() Field "prev_id_session"
(table "session_table"; database "sympa") was NOT found. Attempting to
add it...
notice Sympa::DatabaseManager::_check_fields() Field
"refresh_date_session" (table "session_table"; database "sympa") was
NOT found. Attempting to add it...
notice Sympa::DatabaseManager::_check_fields() Field
"creation_email_list" (table "list_table"; database "sympa") was NOT
found. Attempting to add it...
notice Sympa::DatabaseManager::_check_fields() Field
"creation_epoch_list" (table "list_table"; database "sympa") was NOT
found. Attempting to add it...
notice Sympa::DatabaseManager::_check_fields() Field "family_list"
(table "list_table"; database "sympa") was NOT found. Attempting to
add it...
notice Sympa::DatabaseManager::_check_fields() Field "name_list"
(table "list_table"; database "sympa") was NOT found. Attempting to
add it...
notice Sympa::DatabaseManager::_check_fields() Field "robot_list"
(table "list_table"; database "sympa") was NOT found. Attempting to
add it...
notice Sympa::DatabaseManager::_check_fields() Field "searchkey_list"
(table "list_table"; database "sympa") was NOT found. Attempting to
add it...
notice Sympa::DatabaseManager::_check_fields() Field "status_list"
(table "list_table"; database "sympa") was NOT found. Attempting to
add it...
notice Sympa::DatabaseManager::_check_fields() Field "topics_list"
(table "list_table"; database "sympa") was NOT found. Attempting to
add it...
notice Sympa::DatabaseManager::_check_fields() Field "total_list"
(table "list_table"; database "sympa") was NOT found. Attempting to
add it...
notice Sympa::DatabaseManager::_check_fields() Field
"update_email_list" (table "list_table"; database "sympa") was NOT
found. Attempting to add it...
notice Sympa::DatabaseManager::_check_fields() Field
"update_epoch_list" (table "list_table"; database "sympa") was NOT
found. Attempting to add it...
notice Sympa::DatabaseManager::_check_fields() Field
"web_archive_list" (table "list_table"; database "sympa") was NOT
found. Attempting to add it...
notice Sympa::DatabaseManager::_check_primary_key() Primary key
list_table [name_list,robot_list] is missing. Adding it
notice Sympa::DatabaseManager::_check_indexes() Removing obsolete
index user_index
notice Sympa::DatabaseManager::_check_indexes() Index admin_user_index
on table admin_table does not exist. Adding it
notice Sympa::DatabaseManager::_check_fields() Field
"data_one_time_ticket" (table "one_time_ticket_table"; database
"sympa") was NOT found. Attempting to add it...
notice Sympa::DatabaseManager::_check_fields() Field
"date_one_time_ticket" (table "one_time_ticket_table"; database
"sympa") was NOT found. Attempting to add it...
notice Sympa::DatabaseManager::_check_fields() Field
"email_one_time_ticket" (table "one_time_ticket_table"; database
"sympa") was NOT found. Attempting to add it...
notice Sympa::DatabaseManager::_check_fields() Field
"remote_addr_one_time_ticket" (table "one_time_ticket_table"; database
"sympa") was NOT found. Attempting to add it...
notice Sympa::DatabaseManager::_check_fields() Field
"robot_one_time_ticket" (table "one_time_ticket_table"; database
"sympa") was NOT found. Attempting to add it...
notice Sympa::DatabaseManager::_check_fields() Field
"status_one_time_ticket" (table "one_time_ticket_table"; database
"sympa") was NOT found. Attempting to add it...
notice Sympa::DatabaseManager::_check_fields() Field
"ticket_one_time_ticket" (table "one_time_ticket_table"; database
"sympa") was NOT found. Attempting to add it...
notice Sympa::DatabaseManager::_check_fields() Field
"number_messages_subscriber" (table "subscriber_table"; database
"sympa") was NOT found. Attempting to add it...
notice Sympa::DatabaseManager::_check_fields() Field
"suspend_end_date_subscriber" (table "subscriber_table"; database
"sympa") was NOT found. Attempting to add it...
notice Sympa::DatabaseManager::_check_fields() Field
"suspend_start_date_subscriber" (table "subscriber_table"; database
"sympa") was NOT found. Attempting to add it...
notice Sympa::DatabaseManager::_check_fields() Field
"suspend_subscriber" (table "subscriber_table"; database "sympa") was
NOT found. Attempting to add it...
notice Sympa::DatabaseManager::_check_indexes() Removing obsolete
index user_index
notice Sympa::DatabaseManager::_check_indexes() Index
subscriber_user_index on table subscriber_table does not exist. Adding
it
notice Sympa::DatabaseManager::_check_fields() Field "daemon_stat"
(table "stat_table"; database "sympa") was NOT found. Attempting to
add it...
notice Sympa::DatabaseManager::_check_fields() Field "date_stat"
(table "stat_table"; database "sympa") was NOT found. Attempting to
add it...
notice Sympa::DatabaseManager::_check_fields() Field "email_stat"
(table "stat_table"; database "sympa") was NOT found. Attempting to
add it...
notice Sympa::DatabaseManager::_check_fields() Field "list_stat"
(table "stat_table"; database "sympa") was NOT found. Attempting to
add it...
notice Sympa::DatabaseManager::_check_fields() Field "operation_stat"
(table "stat_table"; database "sympa") was NOT found. Attempting to
add it...
notice Sympa::DatabaseManager::_check_fields() Field "parameter_stat"
(table "stat_table"; database "sympa") was NOT found. Attempting to
add it...
notice Sympa::DatabaseManager::_check_fields() Field "read_stat"
(table "stat_table"; database "sympa") was NOT found. Attempting to
add it...
notice Sympa::DatabaseManager::_check_fields() Field "robot_stat"
(table "stat_table"; database "sympa") was NOT found. Attempting to
add it...
notice Sympa::DatabaseManager::_check_fields() Field "user_ip_stat"
(table "stat_table"; database "sympa") was NOT found. Attempting to
add it...
notice Sympa::DatabaseManager::_check_indexes() Index stats_user_index
on table stat_table does not exist. Adding it
notice Sympa::Message::new_from_template() Processing Sympa::Message
<address@concealed,7745>;
address@concealed; recipients=ARRAY;
address@concealed; template=listmaster_notification;
type=db_struct_updated
notice Sympa::Mailer::store() Done sending message Sympa::Message
<address@concealed,7745> for * (priority 1) in 0
seconds since scheduled expedition date
notice Sympa::Upgrade::upgrade() Rebuilding config.bin files for ALL
lists...it may take a while...
notice Sympa::Upgrade::upgrade() Rebuilding the admin_table...
notice Sympa::Upgrade::upgrade() Removing obsolete OTHER/ bounce directories
notice Sympa::Upgrade::upgrade() Directory
/address@concealed/OTHER removed
notice Sympa::Upgrade::upgrade() Directory
/address@concealed/OTHER removed
notice Sympa::Upgrade::upgrade() Directory
/address@concealed/OTHER removed
notice Sympa::Upgrade::upgrade() Directory
/address@concealed/OTHER removed
notice Sympa::Upgrade::upgrade() Directory
/address@concealed/OTHER removed
notice Sympa::Upgrade::upgrade() Directory
/address@concealed/OTHER removed
notice Sympa::Upgrade::upgrade() Directory
/address@concealed/OTHER removed
notice Sympa::Upgrade::upgrade() Directory
/address@concealed/OTHER removed
notice Sympa::Upgrade::upgrade() Directory
/address@concealed/OTHER removed
notice Sympa::Upgrade::upgrade() Directory
/address@concealed/OTHER removed
notice Sympa::Upgrade::upgrade() Directory
/address@concealed/OTHER removed
notice Sympa::Upgrade::upgrade() Directory
/address@concealed/OTHER removed
notice Sympa::Upgrade::upgrade() Directory
/address@concealed/OTHER
removed
notice Sympa::Upgrade::upgrade() Directory
/address@concealed/OTHER
removed
notice Sympa::Upgrade::upgrade() Directory
/address@concealed/OTHER removed
notice Sympa::Upgrade::upgrade() Fixing Q-encoding of web document 
filenames...
notice Sympa::Upgrade::upgrade() Processing list address@concealed...
closedir() attempted on invalid dirhandle DIR at
/home/sympa/bin/Sympa/Tools/File.pm line 356.
notice Sympa::Upgrade::upgrade() Processing list address@concealed...
closedir() attempted on invalid dirhandle DIR at
/home/sympa/bin/Sympa/Tools/File.pm line 356.
notice Sympa::Upgrade::upgrade() Processing list address@concealed...
closedir() attempted on invalid dirhandle DIR at
/home/sympa/bin/Sympa/Tools/File.pm line 356.
closedir() attempted on invalid dirhandle DIR at
/home/sympa/bin/Sympa/Tools/File.pm line 356.
closedir() attempted on invalid dirhandle DIR at
/home/sympa/bin/Sympa/Tools/File.pm line 356.
closedir() attempted on invalid dirhandle DIR at
/home/sympa/bin/Sympa/Tools/File.pm line 356.
closedir() attempted on invalid dirhandle DIR at
/home/sympa/bin/Sympa/Tools/File.pm line 356.
closedir() attempted on invalid dirhandle DIR at
/home/sympa/bin/Sympa/Tools/File.pm line 356.
closedir() attempted on invalid dirhandle DIR at
/home/sympa/bin/Sympa/Tools/File.pm line 356.
closedir() attempted on invalid dirhandle DIR at
/home/sympa/bin/Sympa/Tools/File.pm line 356.
closedir() attempted on invalid dirhandle DIR at
/home/sympa/bin/Sympa/Tools/File.pm line 356.
closedir() attempted on invalid dirhandle DIR at
/home/sympa/bin/Sympa/Tools/File.pm line 356.
closedir() attempted on invalid dirhandle DIR at
/home/sympa/bin/Sympa/Tools/File.pm line 356.
closedir() attempted on invalid dirhandle DIR at
/home/sympa/bin/Sympa/Tools/File.pm line 356.
closedir() attempted on invalid dirhandle DIR at
/home/sympa/bin/Sympa/Tools/File.pm line 356.
closedir() attempted on invalid dirhandle DIR at
/home/sympa/bin/Sympa/Tools/File.pm line 356.
closedir() attempted on invalid dirhandle DIR at
/home/sympa/bin/Sympa/Tools/File.pm line 356.
closedir() attempted on invalid dirhandle DIR at
/home/sympa/bin/Sympa/Tools/File.pm line 356.
closedir() attempted on invalid dirhandle DIR at
/home/sympa/bin/Sympa/Tools/File.pm line 356.
closedir() attempted on invalid dirhandle DIR at
/home/sympa/bin/Sympa/Tools/File.pm line 356.
closedir() attempted on invalid dirhandle DIR at
/home/sympa/bin/Sympa/Tools/File.pm line 356.
notice Sympa::Upgrade::upgrade() Processing list
address@concealed...
closedir() attempted on invalid dirhandle DIR at
/home/sympa/bin/Sympa/Tools/File.pm line 356.
closedir() attempted on invalid dirhandle DIR at
/home/sympa/bin/Sympa/Tools/File.pm line 356.
notice Sympa::Upgrade::upgrade() Processing list
address@concealed...
closedir() attempted on invalid dirhandle DIR at
/home/sympa/bin/Sympa/Tools/File.pm line 356.
notice Sympa::Upgrade::upgrade() Processing list
address@concealed...
closedir() attempted on invalid dirhandle DIR at
/home/sympa/bin/Sympa/Tools/File.pm line 356.
notice Sympa::Upgrade::upgrade() Processing list
address@concealed...
closedir() attempted on invalid dirhandle DIR at
/home/sympa/bin/Sympa/Tools/File.pm line 356.
notice Sympa::Upgrade::upgrade() Fixing robot column of exclusion table
notice Sympa::Upgrade::upgrade() Caching all list config to database...
notice Sympa::Upgrade::upgrade() ...done
notice Sympa::Upgrade::upgrade() Migrating wwsympa.conf...
Use of uninitialized value $v in sprintf at
/home/sympa/bin/Sympa/Upgrade.pm line 1200.
Use of uninitialized value $v in sprintf at
/home/sympa/bin/Sympa/Upgrade.pm line 1200.
Use of uninitialized value $v in sprintf at
/home/sympa/bin/Sympa/Upgrade.pm line 1200.
Use of uninitialized value $v in sprintf at
/home/sympa/bin/Sympa/Upgrade.pm line 1200.
Use of uninitialized value $v in sprintf at
/home/sympa/bin/Sympa/Upgrade.pm line 1200.
Unable to rename /etc/sympa/sympa.conf: Permission denied at
/home/sympa/bin/Sympa/Upgrade.pm line 1211.
notice Sympa::Upgrade::upgrade() /etc/sympa/sympa.conf has been
updated.  Previous version has been saved as
/etc/sympa/sympa.conf.03.Sep.2015-15.04.06
Unable to rename /etc/sympa/wwsympa.conf: Permission denied at
/home/sympa/bin/Sympa/Upgrade.pm line 1236.
notice Sympa::Upgrade::upgrade() /etc/sympa/wwsympa.conf will NO
LONGER be used.  Previous version has been saved as
/etc/sympa/wwsympa.conf.03.Sep.2015-15.04.06
notice Sympa::Upgrade::upgrade() Creating HTML view of moderation spool...
notice Sympa::Upgrade::upgrade() Upgrading automatic spool...
notice Sympa::Upgrade::upgrade() Upgrading list config...
notice Sympa::Upgrade::upgrade() Setting web interface colors to new defaults.
err main::#797 > Sympa::Upgrade::upgrade#1460 >
Sympa::Upgrade::fix_colors#1989 Unable to rename /etc/sympa/sympa.conf
file: Permission denied. Web interface might look buggy after upgrade
notice Sympa::Upgrade::save_web_tt2() /home/sympa/etc/web_tt2
directory saved as /home/sympa/etc/web_tt2.upgrade03.Sep.2015-15.04.17
notice Sympa::Tools::WWW::update_css() TT2 file
/home/sympa/default/web_tt2/css.tt2 has changed; updating static CSS
file /home/sympa/static_content/css/style.css; previous file renamed
notice Sympa::Tools::WWW::update_css() TT2 file
/home/sympa/default/web_tt2/css.tt2 has changed; updating static CSS
file /home/sympa/static_content/css/print.css; previous file renamed
notice Sympa::Tools::WWW::update_css() TT2 file
/home/sympa/default/web_tt2/css.tt2 has changed; updating static CSS
file /home/sympa/static_content/css/fullPage.css; previous file
renamed
notice Sympa::Tools::WWW::update_css() TT2 file
/home/sympa/default/web_tt2/css.tt2 has changed; updating static CSS
file /home/sympa/static_content/css/print-preview.css; previous file
renamed
notice Sympa::Message::new_from_template() Processing Sympa::Message
<address@concealed,6858>;
address@concealed; recipients=ARRAY;
address@concealed; template=listmaster_notification;
type=css_updated
notice Sympa::Mailer::store() Done sending message Sympa::Message
<address@concealed,6858> for * (priority 1) in 0
seconds since scheduled expedition date
notice Sympa::Upgrade::upgrade() Web interface colors defaulted to new values.
notice Sympa::Upgrade::upgrade() Upgrading digest spool.
notice Sympa::Upgrade::upgrade() Upgrading archive spool.
notice main:: Upgrade process finished

---
Tim Kuehn:  Senior Consultant  - TDK Consulting Services
Course Instructor: Intro to OO Concepts for Procedural Programmers
Sign up on my mailing list to learn about future training
opportunities @ www.tdkcs.com
President - Ontario PUG
Program Committee Chair - PUG Challenge Americas,

Skype: timothy.kuehn
Ph: 519-576-8100
Cell: 519-781-0081