git-svn-id: https://subversion.renater.fr/sympa/branches/sympa-6.2-branch@10311 05aa8bb8-cd2b-0410-b1d7-8918dfa770ce

[dev] Added test harness for unit tests under t/.  Since olver versions of automake won't support such as LOG_DRIVER, Test::Harness will be used instead.


git-svn-id: https://subversion.renater.fr/sympa/branches/sympa-6.2-branch@10310 05aa8bb8-cd2b-0410-b1d7-8918dfa770ce

[bug][#7289][Reported by D Launay, RENATER] Signed mail body are altered.  Fixed by making following functions not to alter such parts:
- Bulk::merge_msg()
- List::_append_parts()


git-svn-id: https://subversion.renater.fr/sympa/branches/sympa-6.2-branch@10309 05aa8bb8-cd2b-0410-b1d7-8918dfa770ce

git-svn-id: https://subversion.renater.fr/sympa/branches/sympa-6.2-branch@10308 05aa8bb8-cd2b-0410-b1d7-8918dfa770ce

[*feature] Added "Add subscriber" button to modindex page if the sender is not subscribed.  It may be useful because users need not know about SUB command and sympa command address.  The buttons appear only when Web user is the list owner.


git-svn-id: https://subversion.renater.fr/sympa/branches/sympa-6.2-branch@10306 05aa8bb8-cd2b-0410-b1d7-8918dfa770ce

git-svn-id: https://subversion.renater.fr/sympa/branches/sympa-6.2-branch@10305 05aa8bb8-cd2b-0410-b1d7-8918dfa770ce

der field.
- New mandatory CPAN module TimeDate.
- time_utils.pm borrowed from MHonArc will retire.


git-svn-id: https://subversion.renater.fr/sympa/branches/sympa-6.2-branch@10302 05aa8bb8-cd2b-0410-b1d7-8918dfa770ce

git-svn-id: https://subversion.renater.fr/sympa/branches/sympa-6.2-branch@10301 05aa8bb8-cd2b-0410-b1d7-8918dfa770ce

git-svn-id: https://subversion.renater.fr/sympa/branches/sympa-6.2-branch@10300 05aa8bb8-cd2b-0410-b1d7-8918dfa770ce

This feature allows to package code to be used in templates.

It enables foreign data integration in Sympa's UI and emails, user
specific UI enhancement and much more !

Integrating user targeted data retreived through a call to a webservice
becomes possible in a simple way, automatically adding info from a
database to outgoing emails as well !

Further details here : https://www.sympa.org/manual/templates_plugins




git-svn-id: https://subversion.renater.fr/sympa/branches/sympa-6.2-branch@10299 05aa8bb8-cd2b-0410-b1d7-8918dfa770ce

- List::XXX_global_user() have been obsoleted.  Functions of Sympa::User may be used, and new methods would be better to be used:
  delete_global_user()  -> $user->expire()
  get_global_user()     -> Sympa::User->new()
  get_all_global_user() -> Sympa::User::get_users()
  update_global_user()  -> $user->save()
  add_global_user()     -> $user->save()
  And $user->moveto()


git-svn-id: https://subversion.renater.fr/sympa/branches/sympa-6.2-branch@10269 05aa8bb8-cd2b-0410-b1d7-8918dfa770ce

[-dev] (con'd 10266) Sympa::LockedFile::open(): Special mode "+" for pure locking (not to open target file).


git-svn-id: https://subversion.renater.fr/sympa/branches/sympa-6.2-branch@10268 05aa8bb8-cd2b-0410-b1d7-8918dfa770ce

git-svn-id: https://subversion.renater.fr/sympa/branches/sympa-6.2-branch@10267 05aa8bb8-cd2b-0410-b1d7-8918dfa770ce

Sympa::LockedFile is full rewrite of Lock.  It will carry out lock & open / close & unlock at once.  flock() will never be used: File::NFSLock will be entirely used.

Note:
- File::NFSLock is mandatory.
- An unit test LockedFile.t was added but it may not work at present.


git-svn-id: https://subversion.renater.fr/sympa/branches/sympa-6.2-branch@10266 05aa8bb8-cd2b-0410-b1d7-8918dfa770ce

git-svn-id: https://subversion.renater.fr/sympa/branches/sympa-6.2-branch@10247 05aa8bb8-cd2b-0410-b1d7-8918dfa770ce

[dev] Refactoring.  Language::GetSupportedLanguages() was moved to tools::get_supported_languages().  Dependency loop between Language & Conf was solved.


git-svn-id: https://subversion.renater.fr/sympa/branches/sympa-6.2-branch@10245 05aa8bb8-cd2b-0410-b1d7-8918dfa770ce

[feature] Now sympa_wizard.pl detects encoding of the console automatically.  Optional Encode-Locale module is required.


git-svn-id: https://subversion.renater.fr/sympa/branches/sympa-6.2-branch@10244 05aa8bb8-cd2b-0410-b1d7-8918dfa770ce

[bug] sympa_wizard.pl --create dies when any of CPAN modules had not been installed.  Check if modules can be loaded at first.  And in case, try to fallback to Text::Wrap.


git-svn-id: https://subversion.renater.fr/sympa/branches/sympa-6.2-branch@10243 05aa8bb8-cd2b-0410-b1d7-8918dfa770ce

git-svn-id: https://subversion.renater.fr/sympa/branches/sympa-6.2-branch@10241 05aa8bb8-cd2b-0410-b1d7-8918dfa770ce

git-svn-id: https://subversion.renater.fr/sympa/branches/sympa-6.2-branch@10240 05aa8bb8-cd2b-0410-b1d7-8918dfa770ce

[-bug] sympa.pl: Thease parameters tried to refer vhost values but they cat not be robot-specific: sleep, loop_command_sampling_delay, loop_command_max, loop_command_decrese_factor, misaddressed_commands.


git-svn-id: https://subversion.renater.fr/sympa/branches/sympa-6.2-branch@10239 05aa8bb8-cd2b-0410-b1d7-8918dfa770ce

git-svn-id: https://subversion.renater.fr/sympa/branches/sympa-6.2-branch@10238 05aa8bb8-cd2b-0410-b1d7-8918dfa770ce

- Makefile.am: no longer create wwsympa.conf during installation.
- sympa_wizard.pl: --create argument disallows "wwsympa.conf" option.
- Upgrade.pm: migrate wwsympa.conf during upgrade process.
- wwslib::load_config() were renamed to Conf::_load_wwsconf().

Note: Run "sympa.pl --upgrade" to migrate wwsympa.conf into sympa.conf.


git-svn-id: https://subversion.renater.fr/sympa/branches/sympa-6.2-branch@10237 05aa8bb8-cd2b-0410-b1d7-8918dfa770ce

[dev] Now wwsympa.conf is optional.  When it exists, its content overrides sympa.conf settings (along with possible defaults, even if the file is empty).
This is a part of work to migrate wwsympa.conf into sympa.conf.

- All "$wwsconf->{'paramname'}" in sources has been replaced with "$Conf::Conf{'paramname'}".
- On all executables, location of sympa.conf may be specified by command line "--config" option, SYMPA_CONFIG environment variable or compile-time default (in this priority).  wwsympa.conf may be specified by SYMPA_WWSCONFIG env. var. or default.
-- *Exception*: sympa_wizard.pl always uses compile-time defaults.
- Move wwslib::load_config() to Conf::_load_wwsconf() so that dependencies to wwslib are reduced.


git-svn-id: https://subversion.renater.fr/sympa/branches/sympa-6.2-branch@10236 05aa8bb8-cd2b-0410-b1d7-8918dfa770ce

[dev] SDM: Double type should be explicitly bound for mysql & Pg.  SQLite binds double type to real.  Not yet tested by Oracle & Sybase.


git-svn-id: https://subversion.renater.fr/sympa/branches/sympa-6.2-branch@10235 05aa8bb8-cd2b-0410-b1d7-8918dfa770ce

git-svn-id: https://subversion.renater.fr/sympa/branches/sympa-6.2-branch@10234 05aa8bb8-cd2b-0410-b1d7-8918dfa770ce

[bug][#7459][Originally submitted by Mitar] SDM/PostgreSQL: probe_db() scanned tables only in "public" schema, therefore, tables in user schema and so on were omitted.
Getting available schemas in search_path then use it, instead of the workaround on 6.1.

Note: PostgreSQL 7.4 or later is required to use array support of DBD::Pg >= 2.00.  PostgreSQL 7.3.x and earlier are no longer supported.


git-svn-id: https://subversion.renater.fr/sympa/branches/sympa-6.2-branch@10233 05aa8bb8-cd2b-0410-b1d7-8918dfa770ce

[dev] PostgreSQL: Auto-update of database structure fails because conversion between timestamp and integer is not obvious.  Recreate column and convert values by date_part() function.


git-svn-id: https://subversion.renater.fr/sympa/branches/sympa-6.2-branch@10232 05aa8bb8-cd2b-0410-b1d7-8918dfa770ce

Repaired mergeinfo.


git-svn-id: https://subversion.renater.fr/sympa/branches/sympa-6.2-branch@10231 05aa8bb8-cd2b-0410-b1d7-8918dfa770ce

- SQLite won't support many standard SQL features.  So, when table structure (primary keys, column types) will be changed, copy table contents to new structure.  Older tables will be saved as table with unique suffixes.  Some SDM manipulator features still lack: DROP COLUMN does not work, and so on.
- To prevent "database is locked" error on slightly busy systems, Set "sqlite_use_immediate_transaction" attribute to acquire "immediate" lock on each query so that they wait for the other locks.  Some queries need to acquire lock in this manner.

Note: SQLite 2 or earlier is no longer supported.  Users may have to migrate database to SQLite3.

DBD::SQLite 1.31 or later is required.  Tested by DBD::SQLite 1.33 and SQLite 3.7.7.
ToDo: Add config parameter to tune "busy_timeout" SQLite configuration (defaults to be 5000 ms) to allow longer database lock timeout.


git-svn-id: https://subversion.renater.fr/sympa/branches/sympa-6.2-branch@10230 05aa8bb8-cd2b-0410-b1d7-8918dfa770ce

[bug] SDM/PostgreSQL: PostgreSQL does not have 'ALTER TABLE ... DROP PRIMARY KEY'.  Instead, get a name of constraint then drop it.


git-svn-id: https://subversion.renater.fr/sympa/branches/sympa-6.2-branch@10229 05aa8bb8-cd2b-0410-b1d7-8918dfa770ce

- SDM::probe_db(): check only tables defined in database description.  Tables defined by user will be intact.
- Cosmetic concern: Now SDM::do_query() and SDM::do_prepared_query() normalize whitespaces in the query strings.  Multiline query can be used more safely.
- New SDM::AS_BLOB() to bind BLOB parameters by SDM::do_prepared_query().  Tested by PostgreSQL 9.1 and SQLite 3, not yet by Oracle.


git-svn-id: https://subversion.renater.fr/sympa/branches/sympa-6.2-branch@10228 05aa8bb8-cd2b-0410-b1d7-8918dfa770ce

get_list_address([OPTS]), get_bounce_address(), get_list_id(), add_list_header(OPTS).


git-svn-id: https://subversion.renater.fr/sympa/branches/sympa-6.2-branch@10227 05aa8bb8-cd2b-0410-b1d7-8918dfa770ce

git-svn-id: https://subversion.renater.fr/sympa/branches/sympa-6.2-branch@10226 05aa8bb8-cd2b-0410-b1d7-8918dfa770ce

Note: Perl 5.16.0 and later have built-in fc().  For earlier Perl Unicode::CaseFold will be used.  Since Perl 5.8.0 won't support it, lc() will be used instead.


git-svn-id: https://subversion.renater.fr/sympa/branches/sympa-6.2-branch@10225 05aa8bb8-cd2b-0410-b1d7-8918dfa770ce

git-svn-id: https://subversion.renater.fr/sympa/branches/sympa-6.2-branch@10224 05aa8bb8-cd2b-0410-b1d7-8918dfa770ce

- "email_gecos" parameter during alpha releases was renamed to "gecos".
- Encodes display name (taken from gecos parameters) using tools::addrrencode().

Note: MIME::EncWords >= 1.012 & MIME::Charset >= 1.008.2 are required to use 'DISPNAME' feature by current MIME::EncWords.


git-svn-id: https://subversion.renater.fr/sympa/branches/sympa-6.2-branch@10223 05aa8bb8-cd2b-0410-b1d7-8918dfa770ce

git-svn-id: https://subversion.renater.fr/sympa/branches/sympa-6.2-branch@10217 05aa8bb8-cd2b-0410-b1d7-8918dfa770ce

git-svn-id: https://subversion.renater.fr/sympa/branches/sympa-6.2-branch@10216 05aa8bb8-cd2b-0410-b1d7-8918dfa770ce

git-svn-id: https://subversion.renater.fr/sympa/branches/sympa-6.2-branch@10215 05aa8bb8-cd2b-0410-b1d7-8918dfa770ce