The mailing list for listmasters using Sympa

[Michael Redinger <address@concealed>]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Hi,

I am having some troubles updating our mailing list system from 5.1 to 5.3:
My old lists are not shown on the web page (in the list of lists).

To test the upgrade, I installed a second system with the latest stable
Sympa release. I configured it and tested sending mails - everything
works fine.

I then made a clone of the old database (Oracle) and configured the
new Sympa system to use that database.
I also copied all the mailing list directories in expl/ to the new
system.
Next I ran
sympa.pl --upgrade --from=5.1 --to=5.3

This generates lots of mails to the list admin - one for each list,
stating that there is no owner for the list.
When I run the convert script a second time, there are hardly any
errors. No new error mails are generated.
(For some lists I get an error that a template cannot be converted from
utf-8 to utf-8.)

I tried this again (copied database and files again), with debugging
turned on (2).
Basically, sympa does not find the list owner in the database. Therefore
it tries to insert it into the database (based on the owner found in
the config file). However, this fails because of an Oracle error:
ORA-00001: unique constraint (SYMPA.IND_ADMIN) violated (DBD ERROR:
OCIStmtExecute)

When I open the sympa web page, the mailing lists do not appear in the
list of lists (even when I am listadmin).
However, I can access them by manually choosing the correct URL
(eg. ...../info/[list]).
When editing the list description, I can see that the owner of the list
is set correctly.
(When I manually add a list, it is shown correctly in the list of lists.)

The next thing I noted:
All the list directories are located in ~sympa/expl/ . On the
testserver, the domain is set to the same name as on the previous server
(lists.mydomain.com) in sympa.conf (domain ...).
However, _all_ lists (new and old ones) on the testserver are shown with
the hostname of the test server as robot name (lists2.mydomain.com).
Also, on the sympa admin web page, the robot of the testserver is
shown (lists2.mydomain.com), not the one configured.
So maybe this is the problem?
However, I do not know sympa determines the main robot. I thought this
can be set using domain ... in sympa.conf . Seems like it does not.
And if it is: Why are some (the new) lists shown and others (the old
ones) are not?

There are a number of other questions.
- - How do I fix the Oracle (obvious) error? Can I simply delete the
  content of the admin_table?
- - I added the logs and netidmap tables to the database.
  Do I have to make any additional changes?
- - How is the list of lists on the web page generated?
  Under which circumstances is a list that is perfectly accessible
  (eg. by listmaster) not listed here?
- - Did I forget anything - anything else I should have done during the
  update process?

I simply do not know where to start, so I thought maybe someone can
help me with this problem.

Thanks,
Michael
- --
Michael Redinger
Zentraler Informatikdienst (Central IT Services)
Universitaet Innsbruck
Technikerstrasse 13                    Tel.: ++43 512 507 2335
6020 Innsbruck                         Fax.: ++43 512 507 949 02335
Austria                                Mail: address@concealed
BB98 D2FE 0F2C 2658 3780  3CB1 0FD7 A9D9 65C2 C11D
http://homepage.uibk.ac.at/~c102mr/mred-pubkey.asc
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.7 (GNU/Linux)
Comment: Using GnuPG with Fedora - http://enigmail.mozdev.org

iD8DBQFHqEtWD9ep2WXCwR0RAi63AKDEg2HFBu2ciNfMej748J0ETb/GYgCgwd6r
sRr+0u6UYJxn3OmLnOc1bas=
=PI5Q
-----END PGP SIGNATURE-----
Feb  5 11:01:58 lists2 sympa[25559]: List::new() List::new(samplelist, lists.mydomain.com, reload_config)
Feb  5 11:01:58 lists2 sympa[25559]: List::load() List::load(samplelist, lists.mydomain.com, reload_config)
Feb  5 11:01:58 lists2 sympa[25559]: Lock::new() Lock::new(/home/sympa/expl/samplelist/config,)
Feb  5 11:01:58 lists2 sympa[25559]: Lock::lock() Lock::lock(/home/sympa/expl/samplelist/config.lock,read)
Feb  5 11:01:58 lists2 sympa[25559]: Lock::_lock_file() Lock::_lock_file(/home/sympa/expl/samplelist/config.lock,read,5)
Feb  5 11:01:58 lists2 sympa[25559]: Lock::_lock_file() Got lock for read on /home/sympa/expl/samplelist/config.lock
Feb  5 11:01:58 lists2 sympa[25559]: Lock::unlock() Lock::unlock(/home/sympa/expl/samplelist/config.lock)
Feb  5 11:01:58 lists2 sympa[25559]: Lock::_unlock_file() Lock::_unlock_file(/home/sympa/expl/samplelist/config.lock)
Feb  5 11:01:58 lists2 sympa[25559]: Lock::_unlock_file() Release lock on /home/sympa/expl/samplelist/config.lock
Feb  5 11:01:58 lists2 sympa[25559]: List::sync_include_admin() List:sync_include_admin(samplelist)
Feb  5 11:01:58 lists2 sympa[25559]: List::get_first_admin_user() List::get_first_admin_user(samplelist,owner,domain,0,0)
Feb  5 11:01:58 lists2 sympa[25559]: Lock::new() Lock::new(/home/sympa/expl/samplelist/include_admin_user,)
Feb  5 11:01:58 lists2 sympa[25559]: Lock::lock() Lock::lock(/home/sympa/expl/samplelist/include_admin_user.lock,read)
Feb  5 11:01:58 lists2 sympa[25559]: Lock::_lock_file() Lock::_lock_file(/home/sympa/expl/samplelist/include_admin_user.lock,read,20)
Feb  5 11:01:58 lists2 sympa[25559]: Lock::_lock_file() Got lock for read on /home/sympa/expl/samplelist/include_admin_user.lock
Feb  5 11:01:58 lists2 sympa[25559]: List::get_first_admin_user() SQL: SELECT user_admin "email", comment_admin "gecos", reception_admin "reception", ((to_number(to_char(date_admin,'J')) - to_number(to_char(t
o_date('01/01/1970','dd/mm/yyyy'), 'J'))) * 86400) +to_number(to_char(date_admin,'SSSSS')) "date", ((to_number(to_char(update_admin,'J')) - to_number(to_char(to_date('01/01/1970','dd/mm/yyyy'), 'J'))) * 86400
) +to_number(to_char(update_admin,'SSSSS')) "update_date", info_admin "info", profile_admin "profile", subscribed_admin "subscribed", included_admin "included", include_sources_admin "id", substr(user_admin,i
nstr(user_admin,'@')+1) "dom"  FROM admin_table WHERE (list_admin = 'samplelist' AND robot_admin = 'lists.mydomain.com' AND role_admin = 'owner' ) ORDER BY "dom"
Feb  5 11:01:58 lists2 sympa[25559]: Lock::new() Lock::new(/home/sympa/expl/samplelist/include_admin_user,)
Feb  5 11:01:58 lists2 sympa[25559]: Lock::unlock() Lock::unlock(/home/sympa/expl/samplelist/include_admin_user.lock)
Feb  5 11:01:58 lists2 sympa[25559]: Lock::_unlock_file() Lock::_unlock_file(/home/sympa/expl/samplelist/include_admin_user.lock)
Feb  5 11:01:58 lists2 sympa[25559]: Lock::_unlock_file() Release lock on /home/sympa/expl/samplelist/include_admin_user.lock
Feb  5 11:01:58 lists2 sympa[25559]: List::_load_admin_users_include() List::_load_admin_users_include(owner) for list samplelist
Feb  5 11:01:58 lists2 sympa[25559]: List::_load_admin_users_config() List::_load_admin_users_config(owner) for list samplelist
Feb  5 11:01:58 lists2 sympa[25559]: Lock::new() Lock::new(/home/sympa/expl/samplelist/include_admin_user,)
Feb  5 11:01:58 lists2 sympa[25559]: Lock::lock() Lock::lock(/home/sympa/expl/samplelist/include_admin_user.lock,write)
Feb  5 11:01:58 lists2 sympa[25559]: Lock::_lock_file() Lock::_lock_file(/home/sympa/expl/samplelist/include_admin_user.lock,write,20)
Feb  5 11:01:58 lists2 sympa[25559]: Lock::_lock_file() Got lock for write on /home/sympa/expl/samplelist/include_admin_user.lock
Feb  5 11:01:58 lists2 sympa[25559]: List::sync_include_admin() List:sync_include_admin: adding owner address@concealed to list samplelist
Feb  5 11:01:58 lists2 sympa[25559]: List::add_admin_user() List::add_admin_user
Feb  5 11:01:58 lists2 sympa[25559]: List::add_admin_user() Unable to execute SQL statement "INSERT INTO admin_table (user_admin, comment_admin, list_admin, robot_admin, date_admin, update_admin, reception_ad
min,subscribed_admin,included_admin,include_sources_admin, role_admin, info_admin, profile_admin) VALUES ('address@concealed', NULL, 'samplelist', 'lists.mydomain.com', to_date(to_char(round(1202205718/86400)
+ to_number(to_char(to_date('01/01/1970','dd/mm/yyyy'), 'J'))) || ':' ||to_char(mod(1202205718,86400)), 'J:SSSSS'), to_date(to_char(round(1202205718/86400) + to_number(to_char(to_date('01/01/1970','dd/mm/yyyy
'), 'J'))) || ':' ||to_char(mod(1202205718,86400)), 'J:SSSSS'), 'mail', 1, 0, NULL, 'owner', NULL, 'privileged')" : ORA-00001: unique constraint (SYMPA.IND_ADMIN) violated (DBD ERROR: OCIStmtExecute)
Feb  5 11:01:58 lists2 sympa[25559]: List::sync_include_admin() List:sync_include_admin(owner): Failed to add new samplelists
Feb  5 11:01:58 lists2 sympa[25559]: List::new() List::new() : sync_include_admin_failed
Feb  5 11:01:58 lists2 sympa[25559]: List::get_first_admin_user() List::get_first_admin_user(samplelist,owner,domain,0,0)
Feb  5 11:01:58 lists2 sympa[25559]: Lock::new() Lock::new(/home/sympa/expl/samplelist/include_admin_user,)
Feb  5 11:01:58 lists2 sympa[25559]: Lock::lock() Lock::lock(/home/sympa/expl/samplelist/include_admin_user.lock,read)
Feb  5 11:01:58 lists2 sympa[25559]: Lock::lock() Lock again /home/sympa/expl/samplelist/include_admin_user.lock ; total 2
Feb  5 11:01:58 lists2 sympa[25559]: List::get_first_admin_user() SQL: SELECT user_admin "email", comment_admin "gecos", reception_admin "reception", ((to_number(to_char(date_admin,'J')) - to_number(to_char(t
o_date('01/01/1970','dd/mm/yyyy'), 'J'))) * 86400) +to_number(to_char(date_admin,'SSSSS')) "date", ((to_number(to_char(update_admin,'J')) - to_number(to_char(to_date('01/01/1970','dd/mm/yyyy'), 'J'))) * 86400
) +to_number(to_char(update_admin,'SSSSS')) "update_date", info_admin "info", profile_admin "profile", subscribed_admin "subscribed", included_admin "included", include_sources_admin "id", substr(user_admin,i
nstr(user_admin,'@')+1) "dom"  FROM admin_table WHERE (list_admin = 'samplelist' AND robot_admin = 'lists.mydomain.com' AND role_admin = 'owner' ) ORDER BY "dom"
Feb  5 11:01:58 lists2 sympa[25559]: Lock::new() Lock::new(/home/sympa/expl/samplelist/include_admin_user,)
Feb  5 11:01:58 lists2 sympa[25559]: Lock::unlock() Lock::unlock(/home/sympa/expl/samplelist/include_admin_user.lock)
Feb  5 11:01:58 lists2 sympa[25559]: List::new() The list "samplelist" has got no owner defined
Feb  5 11:01:58 lists2 sympa[25559]: List::set_status_error_config() The list "samplelist" is set in status error_config
Feb  5 11:01:58 lists2 sympa[25559]: List::send_notify_to_listmaster() List::send_notify_to_listmaster(no_owner_defined,lists.mydomain.com )
Feb  5 11:01:58 lists2 sympa[25559]: List::send_global_file() List::send_global_file(listmaster_notification, address@concealed, lists.mydomain.com)
Feb  5 11:01:58 lists2 sympa[25559]: List::get_user_db() List::get_user_db(address@concealed)
Feb  5 11:01:58 lists2 sympa[25559]: tools::decrypt_password() tools::decrypt_password (crypt.8s0DIPbk3JR2eLmcHHSQsmi5tRrr5A==
Feb  5 11:01:58 lists2 )
Feb  5 11:01:58 lists2 sympa[25559]: mail::mail_file() mail::mail_file(/home/sympa/bin/etc/mail_tt2/listmaster_notification.tt2, address@concealed, )