Clement Changes

;========================================================================
Revision: 2.5.0-145.12	Date:  2012/01/11 21:10:19
;------------------------------------------------------------------------ 
Production Release

Bug Fix:
	- Group default profile was not properly found when
	  allowed user is relaying emails outside, the wrong
	  email profile (the external one) was used instead of
	  the group one.

Improvment:
	- Better indexing for 'inqueue' database table (to speed up
	  inqueue extraction).
	- Bad Helo (not a FQDN hostname), is now seen as a
	  wrong MX and detection can be overrided by setting
	  the MX flag detection to off in user profile.


;========================================================================
Revision: 2.5.0-145.10	Date:  2012/01/08 00:33:23
;------------------------------------------------------------------------ 
Production Release

Bug Fix:
	- Override directive was NOT working when email was
	  to be sent to a better MX (Internal Email server case).
	  This is major bug, you must upgrade if your clement is
	  acting as a front end to an internal Email server.

Improvment:
	- Better user's group detection when reject/warning message
	  are composed by Clement.

;========================================================================
Revision: 2.5.0-145.9	Date:  2012/01/05 19:57:28
;------------------------------------------------------------------------ 
Production Release

Bug Fix:
	- Fixed live configuration update timing.
	- Versions discrepancy is now issued when clement is already
	  EID is set to clement (This fix some clement journal log ownership).

;========================================================================
Revision: 2.5.0-145.6	Date:  2012/01/04 11:01:11
;------------------------------------------------------------------------ 
Production Release

Bug Fix:
	- Fixe BASE definition problem within support shell script quotamail.sh
	- Fixe "duplicate key violates unique constraint" within support 
	  shell script docounter.sh
	- Updating group number with WEB interface in relay definition menu.

;========================================================================
Revision: 2.5.0-145.5	Date:  2012/01/03 17:08:24
;------------------------------------------------------------------------ 
Production Release

Bug Fix:
	- Relayed user specific profile, (user from relayed origin
	  AND defined within the database with a specific working
	  profile) is now properly extracted.

;========================================================================
Revision: 2.5.0-145.4	Date:  2011/12/30 03:00:11
;------------------------------------------------------------------------ 
Production Release

Bug Fix:
	- Cron called shell script "docunter.sh" was missing from
	  RPM definition. This script is used every day by cron
	  to count the current day transactions.

;========================================================================
Revision: 2.5.0-145.3	Date:  2011/12/30 00:48:49
;------------------------------------------------------------------------ 
Production Release

Bug Fix:
	- Fixed data-base lock trouble when extracting a quarantined
	  email. This bug is MySQL data-base ONLY. If you are
	  using MySQL you must upgrade clement version (No need 
	  to update Clement if you are using PostgreSQL data-base).

;========================================================================
Revision: 2.5.0-145.1	Date:  2011/12/29 15:46:29
;------------------------------------------------------------------------ 
Production Release

Bug Fix:
	- Fixed RPM spec file, version release number was improperly
	  set to 45 instead of 145 (no impact on Clement code itself).

;========================================================================
Revision: 2.5.0-145	Date:  2011/12/27 16:16:42
;------------------------------------------------------------------------ 
Production Release

;========================================================================
Revision: 2.5.0-144.7	Date:  2011/12/22 11:12:54
;------------------------------------------------------------------------ 
Release Candidate

Bug Fix:
	- Detect 'email from domain' with MX but without IP related to MX,
	  as a without MX domain.
	- User profile 'check remote MX' status is now working properly,
	  if profile do not care about missing MX, mail will be accepted.
	- Change display status when internal remote is not responding
	  from "Grey Listing" to "Need to check user, retry later".

;========================================================================
Revision: 2.5.0-144.5.5	Date:  2011/12/19 15:35:19
;------------------------------------------------------------------------ 
Release Candidate

Bug Fix:
	- Fixed MySQL syntaxe error when updating overrides tables

;========================================================================
Revision: 2.5.0-144.5	Date:  2011/12/18 19:34:33
;------------------------------------------------------------------------ 
Release Candidate

Improvements:
	- Relayed IP/mask are now linked to a groupid (one per default)
	  and data are store within the data-base.
	- Updating Clement FAQ
	- Changing repo file, putting extra definition before
	  test repo definition.
	- Adding bubble help to major configuration interfaces
	- Checking for SPF record (type 99) within remote domain DNS before
	  to look for SPF within TXT (old standard).
	- Better journalling when remote server is sending request
	  with syntaxe error (done for both "Mail From:" and "RCPT To:"
	- When probing remote internal server for carried domain, us
	  a empty from "<>" instead of 

Bug Fix:
	- On line new configuration changes are now properly detected.
	- /etc/init.d/clement script, quoting variable "$hostipv4" and
	  "$hostipv6"
	- Taking the alias group ID as incoming group ID when aliased
	  name is to reach outside clement domain (to avoid group id 0).
	- Dovecot-2.0 was unable to deliver email localy when called
	  by deliver.sh, the problem was caused by wrong ownership
	  when calling database.
	- In MySQL setup, emltrt index components where st too small,
	  40 characters was not big enough as the 'session' record can
	  reach 50 characters. emltrt_ndx component size is now 80 
	  characters.
	- If an internal user (to be forwarder to an internal mail
	  server) is like  (including
	  a quote), storage in data-base cache was not working.

;========================================================================
Revision: 2.5.0.143-5	Date:  2011/12/14
;------------------------------------------------------------------------ 
Production Release

Adjustment:
	- Clement running with clamd 0.97-3 version

Bug Fix:
	- The m_empty case was missing in setting the email session 
	  status in case of data collection timeout.
	- Collecting stderr result from dovecot delivery program
	  to feed /var/log/clement/deliver-errors.log. This is needed
	  if /etc/dovecot/dovecot.conf set debug flags to 'yes'
	- Discarding found remote MX IP when the IP is "127.0.0.1"
	  or "::1" (to avoid mean DNS setup).
	- Adding a "Return-path: <>" in bounced email header.
	- Clement now detect if a "smart" admin set up a
	  localhost.localdomain as domain MX.

;========================================================================
Revision: 2.5.0.143-4	Date:  2011/12/10 20:40:38
;------------------------------------------------------------------------ 
Production Release

Bug Fix:
	- Better handling when a contact with an internal forwarder is not 
	  succesfully completed (ie: connection established, but no signon).
	- Fix the case where the internal forwarder do not respond to a 
	  double check about an email alias found previously (Clement was
	  doing a core dump in this unexpected configuration).
	- Use 'postmaster' instead of 'Mailer_daemon' for email's bounce.

;========================================================================
Revision: 2.5.0.143-3	Date:  2011/12/08 20:00:50
;------------------------------------------------------------------------ 
Production Release

Bug Fix:
	- MySQL language syntax error, ROOLBACK -> ROLLBACK.
	  This error trigger alarm in /var/log/messages and
	  make the data-base sometime unconsistent.
	  Update is mandatory if you running clement with
	  a MySQL database
	- Fixed comstat message about unexpected status to
	  be less prone to report an error

;========================================================================
Revision: 2.5.0.143-2	Date:  2011/11/25 15:35:23
;------------------------------------------------------------------------ 
Production Release

Bug Fix:
	- Clement install procedure now detect the case where there is 
	  no IP resolution with server name

;========================================================================
Revision: 2.5.0.143-1	Date:  2011/11/12 19:34:33
;------------------------------------------------------------------------ 
Production Release

;========================================================================
Revision: 2.5.0.142-29	Date:  2011/11/12 19:30:58
;------------------------------------------------------------------------ 
Improvement:
	- Checking current release status against clement released
	  version as reported via DNS.

;========================================================================
Revision: 2.5.0.142-28	Date:  2011/11/11 06:06:21
;------------------------------------------------------------------------ 
Test Release

Bug Fix:
	- Set a default origin group in case we are not able to assign
	  both a originator and a recipient owner group.
	- Small adjustement in transit status if senddata return ERRPROC.

Improvement:
	- Adding spare channel in IPC (case the process exit but not yet
	  detected).

;========================================================================
Revision: 2.5.0.142-27	Date:  2011/11/11 00:53:34
;------------------------------------------------------------------------ 
Test Release

Bug Fix:
	- Better handling of transit status in RCPT command.
	- properly display IP number as "?.?.?.?" if connection
	  vanished before fully establihed.

Improvement:
	- SPAM content detection apply to mail smaller than 1 MBytes,
	  previous value was 256 KBytes.

;========================================================================
Revision: 2.5.0.142-26	Date:  2011/11/10 21:03:47
;------------------------------------------------------------------------ 
Test Release

Bug Fix:
	- Catching the "BOUNCE" status within eml_getcomstat
	  procedure and returning a m_delayed status instead
	  of m_undefined.

Improvment:
	- Email current in transit status is now displayed 
	  as meaningful word instead of dry number.

;========================================================================
Revision: 2.5.0.142-24	Date:  2011/11/09 18:56:57
;------------------------------------------------------------------------ 
Test Release

Bug Fix:
	- Email to be set 'toforward' status are properly
	  set to 'empty' status if no email data is provided
	  by remote.

;========================================================================
Revision: 2.5.0.142-23	Date:  2011/11/09 12:57:10
;------------------------------------------------------------------------ 
Test Release

Bug Fix:
	- When Clement start, email to be transited already in
	  "progress" mode in the inqueue table, (Clement quick
	   shutdown without time to update inqueue), are set
	  to pending mode.
	- Better handling of the email inqueue retry counter.
	- When a warning "not yet sent" is issue for an email,
	  this email stay inqueue instead to reach the trouble queue.
	  Only when rebounce message "can't be send" is issue,
	  email is transfered to trouble queue.
	  
;========================================================================
Revision: 2.5.0.142-19	Date:  2011/11/08 21:01:28
;------------------------------------------------------------------------ 
Test Release

Bug Fix:
	- Major: 
	  Transiter process is NOT able to dispatch new
	  "tracker sender" process if one tracker process
	  in the list is still busy. Further process
	  in the tracker list are NOT checked for completion.
	  The overall email sending become slow.

;========================================================================
Revision: 2.5.0.142-18	Date:  2011/11/07 20:20:59
;------------------------------------------------------------------------ 
Test Release

Bug Fix:
	- Transit file are sometime lost from sight and stay
	  in the transit directory until manually deleted.
	- Bug fixing in the queue management process and
	  cleaning shell upgrade to remove runaway file.

;========================================================================
Revision: 2.5.0.142-17	Date:  2011/11/03 21:18:29
;------------------------------------------------------------------------ 
Test Release

Bug Fix:
	- Whitelisting when remote server IP is within
	  an IPV6 network, was not properly working.

;========================================================================
Revision: 2.5.0.142-16	Date:  2011/11/02 17:57:50
;------------------------------------------------------------------------ 
Test Release

Bug Fix:
	- Using originator from to resend email to internal
	  server instead of "postmaster@...". If the Email
	  was accepted by remote but a problem discovered
	  later on by internal server, internal server
	  postmaster was advised instead of the real original sender.
	  Now, original sender will be warned.
	- Display the "folder" icon when admin is root level
	  and domain is set remote.
	  
;========================================================================
Revision: 2.5.0.142-15	Date:  2011/10/31 06:07:16
;------------------------------------------------------------------------ 
Production Release

Bug Fix:
	- Some remote authentication could be reported as good
	  while the password is returned wrong (bad Synchronisation 
	  in Pop-3 response parsing).
	  
;========================================================================
Revision: 2.5.0.142-14	Date:  2011/10/26 03:36:37
;------------------------------------------------------------------------ 
Production Release

Bug Fix:
	- Recurring crash, if the to rebounce email subject containt
	  character like ["'`]  (shell script was confused about it).
	  Subject is now cleaned before submitted to report script.
	  The reported subject was then "Null" which was not 'expected'
	  by program.

;========================================================================
Revision: 2.5.0.142-13	Date:  2011/10/25 14:54:10
;------------------------------------------------------------------------ 
Production Release

Bug Fix:
	- Showing retry sending number within transit queue.
	- Showing the Email sender instead of postmater when
	  forwarding Email to internal server in transit queue.
	- Fixing refresh time when internal user status is
	  temporarily unknown.
	- If remote server is not responding while sending an
	  email batch, do not try to send further email remaining in 
	  batch.

;========================================================================
Revision: 2.5.0.142-11	Date:  2011/10/22 00:20:54
;------------------------------------------------------------------------ 
Production Release

Bug Fix:
	- Removing some journalling logs generated by checker module
	  but never purged from journal queue (memory leak over time).

;========================================================================
Revision: 2.5.0.142-8	Date:  2011/10/18 19:53:04
;------------------------------------------------------------------------ 
Bug Fix:
	- Sending "not yet sent" at the third strike ONLY if the email
	  third try was not successful
	- Better trace when remote host is not responding.

;========================================================================
Revision: 2.5.0.142-7	Date:  2011/10/17 15:20:50
;------------------------------------------------------------------------ 
Release Candidate

Improvements:
	- Recipient inactive status is used even if there is a specific
	  overrides directive between originator and recipient.
	- If relayed Email is not sent within 3 strikes, a warning email
	  about delay is sent to original sender.
	- Email sending traces are now available in "transit" email web page.
	- Email to be sent to remote are done in bigger crunch;
	  multiple emails and up to a total of 200 recipients.
	  Only a maximun of 3 channel is open to the same MX domain.
	- Adjusting RSET command timing delay (100 Millisec in normal mode).
	- The email resend time is weighted by the number of unsuccessful attempt
	  
Bug Fix:
	- MX host is properly found even if its TTL is defined
	  to be 0.
	- If terminal error status (>500) is sent once the email
	  was transmitted (DATA Mode), email is properly bounced
	  and discarded.
	- If the same email generat multiple error (ex: more than
	  one user unknown), as many rebounce as there is error
	  are generated. 
	- quarantinemail.sh shell script, last quarantine scan
	  was displayed without the hour:minute part when sending
	  email to users.
	- quarantinemail.sh shell script, fix error was subject
	  was a single "!".
	- Fixing LOCK acces within Postgresql data base.

;========================================================================
Revision: 2.5.0.141-13	Date:  2011/09/23 13:58:48
;------------------------------------------------------------------------ 
Production Release

Bug Fix:
	- When sending more than one Email to same host server,
	  do a RSET if an Email can't be sent (ex: recipient unknown),
	  before to start the next email.

Improvement:
	- Not checking email contents with spamassassin if Mail is
	  bigger than 256k.
	- If mail size is specified within "MAIL FROM" (SIZE=),
	  announced mail size is checked against user profile mail size
	  limit.

;========================================================================
Revision: 2.5.0.141-10	Date:  2011/09/21 01:31:52
;------------------------------------------------------------------------ 
Production Release

Bug Fix:
	- Fixing a small memory leak withing modtrt.c, some memory
	  not freed before exiting main process.

Improvement:
	- Relaying IP number, 2 ways are now possible.
	  - in the smart mode, relayed originator domain email is checked
	  - In forced mode, relayed orginator domain email is not checked
	    (email rebounce could reach a 'by-stander').
	
	- If user try to authenticate without a domain part and is
	  successful (remote authentication case), the first domain
	  with the fist group is added to name to become its access full
	  ID

;========================================================================
Revision: 2.5.0.141-9	Date:  2011/09/12 18:05:02
;------------------------------------------------------------------------ 
Production Release

Bug Fix:
	- Major Bug:
	  Attachement not always fully transmitted to a remote recipient,
	  when the link is slow and in plain transmission mode (NOT TLS).
	  (Bug introduced with 2.5.0.141-6)

;========================================================================
Revision: 2.5.0.141-7	Date:  2011/09/09 13:18:18
;------------------------------------------------------------------------ 
Production Release

Bug Fix:
	- External user (clement user with email box on another
	  system) are now receiving clement quarantine daily
	  report.

;========================================================================
Revision: 2.5.0.141-6	Date:  2011/09/09 00:04:47
;------------------------------------------------------------------------ 
Production Release

Bug Fix:
	- Fixed wrong status detection problem if E-mail was fully sent to
	  a foreign system but not acknowledged as received by the
	  remote system.

;========================================================================
Revision: 2.5.0.141-3	Date:  2011/09/06 20:56:54
;------------------------------------------------------------------------ 
Adjustement:
	- Moving web.clement directory to within /var/www/clement-2.5
	  directory instead to be /var/web/clement-2.5. selinux was
	  puzzled and is refusing to execute CGI

;========================================================================
Revision: 2.5.0.141-2	Date:  2011/09/06 18:08:17
;------------------------------------------------------------------------ 
Bug Fix:
	- Adding an index on emlogs table on session record, to
	  speed up transaction record retrieval.

;========================================================================
Revision: 2.5.0.141-1	Date:  2011/09/05 18:05:20
;------------------------------------------------------------------------ 
Improvement:
	- Session logs are store in the data-base too (seslogs 
	  table) and keep for sysconfig $timeJrl days.
	- Detailled logs are now open in specific browser Java 
	  window (next detailled log request do not overwrite 
	  previous request one).
	- Search status field is now presented in alphabetical
	  order.
	- You can set a "spam limit" within user profile, if
	  "spam limit" is not set within the user profile, 
	  spammassassin global value is used.
	- If within a alias list a component is without domain
	  name, the alias domain name is used to assign component
	  domain names.
	- If an alias include a foreign address, this external address
	  is included in the overrides table as it was directly send
	  by originator to the foreign recipient.
	- Clement WEB presentation is now part of the release (such 
	  Clement Doc is now included with release).
	- Improved email transit (out going email) logs.
	- Improved email transit search, you can now search
	  both on domain and full email for originator or
	  recipient..
	- The relayed email are checked about their protocol consistency,
	  Relayed Email must but sent using an originator domain
	  known by clement. Unrelated/foreign/none existing domain are 
	  not accepted to post relayed email UNLESS set within
	  'override' table.
	- Relayed email are checked againt loopback, as when
	  found MX reach the same IP as clement is binded to.
	- Created a demo mode ($demoversion=true within file
	  /etc/clement-2.5/clement.php) such standard user
	  can't change their password or auto-reply value.

	  
Bug Fix:
	- Mail seen "accepted with special agreement" are
	  not checked for spam level anymore.
;========================================================================
Revision: 2.5.0.139-1	Date:  2011/06/24 13:09:02
;------------------------------------------------------------------------ 

Adjustement:
	- Displaying request and field when reporting DNS record
	  anomalies found.

;========================================================================
Revision: 2.5.0.139-1	Date:  2011/06/24 13:09:02
;------------------------------------------------------------------------ 
Production Release

;========================================================================
Revision: 2.5.0.138-12	Date:  2011/06/23 23:58:41
;------------------------------------------------------------------------ 
Release Candidate

Improvement:
	- Authentication can be verified via the group remote
	  authentication server using both POP3 and POP3S protocole.
;========================================================================
Revision: 2.5.0.138-11	Date:  2011/06/22 22:22:35
;------------------------------------------------------------------------ 
Release Candidate

Adjustement:
	- New SID  is not displayed in log if the session is ended either
	  by timeout or by 'quit'
	- Session is disconnected after a Reset if the total of
	  error received is above a limit.
	- Spec file improvement to generate repo file for some distribution
	  only.

Improvement:
	- Can be compiled under sl6,el4,el5 and fedora-release distribution

;========================================================================
Revision: 2.5.0.138-4	Date:  2011/06/08 17:27:06
;------------------------------------------------------------------------ 
Release Candidate

Bug Fix:
	- when sending an email to stephan.o'reilly@domain.com, 
	  database 'overrides' table is properly updated.

Adjustement:
	- Updating SPEC file to add required package (compiling under mock)

;========================================================================
Revision: 2.5.0.138-2	Date:  2011/05/30 15:04:57
;------------------------------------------------------------------------ 
Release Candidate

Bug Fix:
	- Trouble to make difference between missing 
	  DNS (not responding) and no DNS data provided.
	- Create a specific dns routine to check if EHLO
	  data is a Fully Qualified Domain.
	- dns_gooddomdns, do not mixe up answer "no data" with 
	  "no answer", DNS request time-out is recognised as such.
	  
;========================================================================
Revision: 2.5.0.138-1	Date:  2011/05/27 18:51:38
;------------------------------------------------------------------------ 
Release Candidate

Adjustement:
	- "Too Many RCPT" SMTP return status is now a 'terminal 
	  status' (in 500 range) instead to be a temporary 
	  status (in 400 range)
	- Rebounced email transation do show up in logs now.
	- If a "to be relayed email" is to be sent to an unknown domain 
	  recipient, email is accepted if there is special directive within
	  the override data-base table. Email will be rejected later on
	  to "email originator" (instead to rejected while receiving it)
	  with the email transit process.
	  This is a bypass to address application which are not able
	  to fully comply with SMTP protocol and are not able to
	  understand a reject while sending the email.
Bug Fix:
	- Configuration check for change is now done every minute instead
	  of every second.
	- checkdeleted.sh do not try to remove the '.' and '..' drectory
	  anymore

;========================================================================
Revision: 2.5.0.137-2	Date:  2011/05/04 00:52:15
;------------------------------------------------------------------------ 
Adjustement:
	- Email header max size increased to 65536 from 32768.

;========================================================================
Revision: 2.5.0.137-2	Date:  2011/05/04 00:52:15
;------------------------------------------------------------------------ 
Bug Fix:
	- Data-base definition, sequences binding_bindid_seq,
	  overrides_ovrid_seq must be set to 1 instead of 0.
	- IP mask value within file /etc/clement-2.5 is properly
	  applied in IP match checking routine.

improvement:
	- Setting a default hostipv4 when installing in case
	  the DNS is not set properly
	- Checking if freshclam is started as daemon when starting
	  clement

;========================================================================
Revision: 2.5.0.137-1	Date:  2011/04/26 18:10:08
;------------------------------------------------------------------------ 
Production Release

Bug Fix:
	- Checking the real clement spool directory ownership, overriding
	  any symlink ownership in the middle.
	- Clement php intreface create user with right status.

;========================================================================
Revision: 2.5.0.136-16	Date:  2011/04/26 18:10:08
;------------------------------------------------------------------------ 
Release Candidate

Bug Fix:
	- When a domain owned by a group is discovered
	  (remote mode), the expiration date must be
	  kept NULL.

;========================================================================
Revision: 2.5.0.136-15	Date:  2011/04/23 14:11:58
;------------------------------------------------------------------------ 
Release Candidate

Adjustment:
	- Adding data-base backup capability in the cron.

;========================================================================
Revision: 2.5.0.136-14	Date:  2011/04/22 13:24:33
;------------------------------------------------------------------------ 
Release Candidate

Adjustment:
	- In "Advanced Search" front end space are removed from
	  searched string.

;========================================================================
Revision: 2.5.0.136-13	Date:  2011/04/22 11:56:47
;------------------------------------------------------------------------ 
Release Candidate

Improvement:
	- Advanced Search is now available to pin-point data in logs.
	- Email user can have 3 status type; Active, Inactive, Deleted.
	  * A 'deleting' script allow to move deleted user data to
	    a temporary area, then 10 day later to remove all data.

;========================================================================
Revision: 2.5.0.136-5	Date:  2011/04/04 21:09:51
;------------------------------------------------------------------------ 
Production Release

Improvement:
	- Adding time to debug SMTP protocol traceroute
	- When rebouncing an email only attach the
	  first 2000 characters instead to attache the whole Email.
	- Wording adjustment within clement "Admin Management" interface. 
	- Can now display session information in more than one pop-up window.
	- Defining a user is not mandatory anymore when defining this username
	  as alias.
	- Adding Kbytes and Mbytes in advanced research menue.
	- Adding override management interface.

;========================================================================
Revision: 2.5.0.136-1	Date:  2011/04/03 19:07:37
;------------------------------------------------------------------------ 
Production Release

;========================================================================
Revision: 2.5.0.135-12	Date:  2011/04/01 11:55:34
;------------------------------------------------------------------------ 
Bug Fix:
	- Trouble with archiving.sh, was removing all log
	  older than NOW()+60 days, instead NOW()-60 days.
	  Seems the bug fixe didn't make its way to Source!
	- Release Candidate 7

;========================================================================
Revision: 2.5.0.135-11	Date:  2011/03/31 04:14:22
;------------------------------------------------------------------------ 
Bug Fix:
	- Upgrading data-base contents With version was
	  not working (postgresql-checkdb.sh).
	- Release Candidate 6

;========================================================================
Revision: 2.5.0.135-10	Date:  2011/03/31 03:35:18
;------------------------------------------------------------------------ 
Bug Fix:
	- UPTO date record int table INQUEUE is now working in
	  MySQL mode (changing command Postgresql NOW()+'10 hour'
	  to be more generic and MySQL compatible).
	- Release Candidate 5

;========================================================================
Revision: 2.5.0.135-9	Date:  2011/03/30 19:37:52
;------------------------------------------------------------------------ 
Bug Fix:
	- Email ligne "..this is line" was not transformed to
	  ".this is line", only short line ".." was transformed
	  to "." (a single '.' is DATA-END marker in SMTP protocol).

;========================================================================
Revision: 2.5.0.135-8	Date:  2011/03/24 13:19:53
;------------------------------------------------------------------------ 
Bug Fix:
	- Trouble with archiving.sh, was removing all log
	  older than NOW()+60 days, instead NOW()-60 days.
	- Release Candidate 4

;========================================================================
Revision: 2.5.0.135-7	Date:  2011/03/23 15:24:15
;------------------------------------------------------------------------ 
Bug Fix:
	- Timing problem within CVE-2011-0411 fix, link purge
	  was done too late, while TLS connection already
	  initiated.
	- Release Candidate 3

;========================================================================
Revision: 2.5.0.135-6	Date:  2011/03/23 15:24:15
;------------------------------------------------------------------------ 
Bug Fix:
	- Fixed database time format bug
	- Release Candidate 2

;========================================================================
Revision: 2.5.0.135-5	Date:  2011/03/23 13:52:54
;------------------------------------------------------------------------ 
Bug Fix:
	- CVE-2011-0411, fix window to "plaintext command injection"
	  when requesting a TLS (crypted) SMTP connection.

Improvement:
	- Fixed shell Script to work better in both MySQL and Postgresql
	  mode;

;========================================================================
Revision: 2.5.0.135-3	Date:  2011/03/22 17:19:01
;------------------------------------------------------------------------ 
Release Candidate

;========================================================================
Revision: 2.5.0.134-18	Date:  2011/03/14 17:51:52
;------------------------------------------------------------------------ 
Bug Fix:
	- Fixed second CORE dump generation within clmsndr when user status
	  is unexpected within modckr.c (routine sortdispatch,dodispatching).
	- Fixed alarm generated by modpro.c (routine pro_reportrcpt) generating
	  an alarm as check for status 'mustfwd' was missing.
	

;========================================================================
Revision: 2.5.0.134-16	Date:  2011/03/14 01:56:21
;------------------------------------------------------------------------ 
Bug Fix:
	- Fixed CORE dump generation within clmsndr when user status
	  is unexpected.
	- Fixed statistic counting forwarded message.

;========================================================================
Revision: 2.5.0.134-14	Date:  2011/03/12 00:23:12
;------------------------------------------------------------------------ 
Adjustment:
	- Removing debugging trace about counted "Receive" line.
	- better recipient status change handling.

Bug Fix:
	- Fixed ipnum '0/0' to be accepted as IPV4 ipnum when
	  comparing IP override.

;========================================================================
Revision: 2.5.0.134-9	Date:  2011/03/11 15:20:48
;------------------------------------------------------------------------ 
Bug Fix:
	- clmsndr "unexpected status='17'" fixed.
	- Adding SPF capability 'exists'.
	- Overcome the "EXP=" SPF directive

Improvement:
	- Detecting Email looping by counting 'Receive' entries within 
	  email header.

Ajout des logs pour l'administrateurs (adminlogs)
Permettre d'annuler des entrées dans transit
;========================================================================
Revision: 2.5.0.134-8	Date:  2011/03/05 00:33:03
;------------------------------------------------------------------------ 
Adjustment:
	- Expiring old emltrt and emlogs records is now under
	  shell script archiving.sh control, expiration date can be set
	  within /etc/sysconfig/clement.

;========================================================================
Revision: 2.5.0.134-7	Date:  2011/03/04 18:53:59
;------------------------------------------------------------------------ 
Adjustment:
	- Version update handling take care of release number

;========================================================================
Revision: 2.5.0.134-5	Date:  2011/03/04 15:27:40
;------------------------------------------------------------------------ 
Improvement:
	- Better data-base version upgrade (taking care of release number).
	- Expiring old emltrt and emlogs records.

;========================================================================
Revision: 2.5.0.134-4	Date:  2011/03/04 04:32:02 
;------------------------------------------------------------------------ 
Adjustment:
	- Improving TERM signal trapping in clement 'transitr' sub-program.

;========================================================================
Revision: 2.5.0.134-3	Date: 2011/03/04 04:19:34
;------------------------------------------------------------------------ 
Bug Fix:
	- Old "intusers" record are deleted when 'upto' field is
	  older than now().

;========================================================================
Revision: 2.5.0.134-2	Date: 2011/03/03 21:13:16
;------------------------------------------------------------------------ 
Bug Fix:
	- When recalling a "StayPut" email from the quarantine area
	  the overrides data-base is updated.

Adjustment:
	- When sending a trouble report (mail not deliverable) to
	  external site, the original recipient domain is used.
	  Trouble orignator will be 

;========================================================================
Revision: 2.5.0.133-4	Date: 2011/03/02 16:02:15
;------------------------------------------------------------------------ 
Adjustment:
	- Forwarding is now done in behalf of "postmaster@'forwarded_domain'"
	- Better status Handling if clement is not able to get a clear
	  status from to forward remote server.

;========================================================================
Revision: 2.5.0.133-3	Date: 2011/03/02 14:55:31
;------------------------------------------------------------------------ 
Bug Fix:
	- case "m_mustfwd" was not counted as valid RCPT, such
	  when only one recipient in "must be forwarded" was
	  specified, Email data sequence was NOT accepted.

;========================================================================
Revision: 2.5.0.133-2	Date: 2011/03/02 12:36:03
;------------------------------------------------------------------------ 
Bug Fix:
	- case "m_mustfwd" was missing from unieml.c:upddsp, such
	  some "forced forward" case email couldn't be received.

;========================================================================
Revision: 2.5.0.133-1	Date: 2011/03/02 05:14:41
;------------------------------------------------------------------------ 
Bug Fix:
	- Better handling of forward situation when the
	  overrides status is "accept email".
	- "accept email" and "banned email" better status
	  display in logs in Forward email context.
	- Set subject "___UNSPECIFIED____" in logs when email subject
	  if found empty.
	- searching quarantine show both quarantine mode (local,and forward).

;========================================================================
Revision: 2.5.0.132-2	Date: 2011/03/01 18:34:14
;------------------------------------------------------------------------ 
Bug Fix:
	Recalling quarantined Email in mode remote make the system
	crash!. rejectto is not set.
	Forcing rejectto contents to be not null.

;========================================================================
Revision: 2.5.0.132-1	Date: 2011/02/25 15:03:42
;------------------------------------------------------------------------ 
Production Release

;========================================================================
Revision: 2.5.0.131-2	Date: 2011/02/24 20:23:04
;------------------------------------------------------------------------ 
Improvement:
	- Added "forwarded" status when an Email is sent to
	  an Internal server.
	- Alias Behalf is used only when relaying email to
	  the outside world, when mail are kept inside the
	  original originator (from) is used in logs.

;========================================================================
Revision: 2.5.0.130-1	Date: 2011/02/22 20:05:30
;------------------------------------------------------------------------ 
Bug Fix:
	- Mail without DATA part (no recipient accepted) are now
	  correctly logged within emlogs table (SQL data-base).

;========================================================================
Revision: 2.5.0.130-1	Date: 2011/02/22 03:06:18
;------------------------------------------------------------------------ 
Improvement:
	- Rebounce caused by a user aliases is sent in
	  behalf of aliase (not the original originator), this
	  to comply with SPF when forwarding Email. 
	- Icons have been reshape to have a better look.
	  

;========================================================================
Revision: 2.5.0.129-5, Date: 2011/02/17 15:07:58
;------------------------------------------------------------------------ 
Improvement:
	- Better URL within Clement quarantine report Email.

;========================================================================
Revision: 2.5.0.129, Date: 2011/02/15 00:30:00
;------------------------------------------------------------------------ 
Test Release
Improvement:
	- Clement is now able to receive/send mail from/to IPV6
	  site.

;========================================================================
Revision: 2.5.0.128, Date: 2011/02/06 19:48:00
;------------------------------------------------------------------------ 
Production Release
Bug Fix:
	- Do not disconnect if receive a protocol violation from
	  remote SMTP server, instead wait for new command.
	  (case where XXXX was send instead of EHLO).

;========================================================================
Revision: 2.5.0.126, Date: 2011/01/28 17:54:38
;------------------------------------------------------------------------ 
Production Release

;========================================================================
Revision: 2.5.0.125, Date: 2011/01/11 19:59:08
;------------------------------------------------------------------------ 
Adjustment:
	- Renaming dovecot log to be clem-dovecot and adjusting
	  logrotate file accordingly. Purpose is to avoid clash
	  with a possible dovecot genuine logrotate file.
	- Adding a 'grace' time to 'users' and 'domains' records.

;========================================================================
Revision: 2.5.0.124, Date: 2011/01/10 16:04:17
;------------------------------------------------------------------------ 
Bug Fix:
	- mkgraph.sh can generate yearly graphic now.
	- Fixed logrotate dovecot.log file syntax error.

;========================================================================
Revision: 2.5.0.123, Date: 2011/01/07 16:19:31
;------------------------------------------------------------------------ 
Improvements:
	- Clement take care of group,domain and user expiring date,
	  if expired is detected, RCPT request return 
	  536-mailbox is currently locked 

;========================================================================
Revision: 2.5.0.121, Date: 2011/01/04 02:00:30
;------------------------------------------------------------------------ 
Improvements:
	- Quarantine report is now done in user behalf, instead
	  to use "no_reply", this to avoid sending auto-reply message
	  to no reply.
	- Clement is now able to trace back domain to be rebounced.
	  and send email to be forwarded with always the same 
	  originator (postmaster@'default_domain').
	- Clement is now able to overcome loosy EHLO name (without
	  DNS Resolution) if the From: domain name is a sub-part
	  of the EHLO name. Still, From: must resolve to an MX.

;========================================================================
Revision: 2.5.0.120, Date: 2010/12/30 19:10:19 
;------------------------------------------------------------------------ 
Bug Fix:
	- clmsndr trap case where user email box is used up
	  to max space.

Improvements:
	- Adding logrotate directive to rotate file
	  /var/log/dovecot.log

;========================================================================
Revision: 2.5.0.119, Date: 2010/12/02 20:13:40
;------------------------------------------------------------------------ 
Bug Fix:
	- Auto-Reply text was "polluted" by '^M' when the
	  text was entered via Outlook browser.


;========================================================================
Revision: 2.5.0.118, Date: 2010/11/30 15:23:40
;------------------------------------------------------------------------ 
Bug Fix:
	- Quarantine report is now working with dynamickey for
	  Internal users type.

Improvements:
	- Trace new debug level in /var/log/messages when
	  sending USR1 or USR2 signal to clement application

;========================================================================
Revision: 2.5.0.117, Date: 2010/11/26 13:41:41
;------------------------------------------------------------------------ 
Bug Fix:
	- Better Handling if the remote contact is established but
	  refused (remote busy).
	- 'accept' Override is now working when user previously 
	  rejected originator email and local administrator had
	  make a global 'accept' for that originator.

;========================================================================
Revision: 2.5.0.114, Date: 2010/11/20 20:45:08
;------------------------------------------------------------------------ 
Improvements:
	- Empty from is set to authenticated email address if acces was
	  authenticated.
	- Better handling of timeout within message exchanges. Messages
	  are removed from queue and status return is ERRPROC.
	- Starting 3 checker process by default.
	
Bug Fix:
	Protecting data-base search access from (wrong) domainname with "'"
	ex: as nbnet.n.b.ca'

;========================================================================
Revision: 2.5.0.113, Date: 2010/11/17 13:35:31
;------------------------------------------------------------------------ 
Improvements:
	Standard user can change its own password.

;========================================================================
Revision: 2.5.0.112, Date: 2010/11/14 14:51:31
;------------------------------------------------------------------------ 
Improvements:
	TRANSIT web screen display trouble transit exchange
	data (by clicking on trouble time).

Bug Fix:
	dovecot-sql.conf allow the password in crypt format
	decoding (very old password setup).

;========================================================================
Revision: 2.5.0.111, Date: 2010/11/06 02:06:45
;------------------------------------------------------------------------ 
Improvements:
	Email "Undelivered in due time" are flagged "Discarded"
	instead to continue to display "Delayed".

;========================================================================
Revision: 2.5.0.109, Date: 2010/11/04 19:49:50
;------------------------------------------------------------------------ 
Improvements:
	quarantinemail.sh is now taking care of user
	language, first userprofile, then domain and last clmgroup.

Bug Fix:
	emlogs stamp record is not updated anymore when record
	status is updated.

;========================================================================
Revision: 2.5.0.108, Date: 2010/11/03 20:13:11
;------------------------------------------------------------------------ 
Improvements:
	Continue to send Email event if STARTTLS was not
	agreed with remote.
	Better tracing about remote SMTP link to report
	the information if a EMail in transit is stuck.
	quarantinemail.sh is now taking care of a last
	quarantine scan at group level.

;========================================================================
Revision: 2.5.0.106, Date: 2010/10/30 18:08:50
;------------------------------------------------------------------------ 
Production Release

;========================================================================
Revision: 2.5.0.104, Date: 2010/10/28 23:50:55
;------------------------------------------------------------------------ 
Bug Fix:
	Data-base inqueue table was not updated when 
	makecontact with remote smtp was not successful.
Improvements:
	Can extract quarantined email and send to a remote
	site (mode email forward).
	Delaying inqueue processing if emlog for session
	not yet available. Such we have "delivered"
	as status instead of "relayed", if transit processing
	is really fast.

;========================================================================
Revision: 2.5.0.102, Date: 2010/10/22 18:47:07
;------------------------------------------------------------------------ 
Improvements:
	- Duplicate RCPT are detected and return
	  CMDOK, while discarding the entry.
	- Email in relayed mode without data are
	  properly displayed as 'empty'.

;========================================================================
Revision: 2.5.0.101, Date: 2010/10/21 03:35:23
;------------------------------------------------------------------------ 
Improvements:
	- Production release.
	- Increased SMTP contact to send email to remote from
	  20 to 120 secondes.

;========================================================================
Revision: 2.5.0.99, Date: 2010/10/20 18:47:10
;------------------------------------------------------------------------ 
Improvements:
	- Release Candidat 6
	- Clement administrator web interface display 
	  email logs rather than statistics.
	- Sending Email to an internal server proved to
	  be working
;========================================================================
Revision: 2.5.0.98, Date: 2010/10/16 19:47:12
;------------------------------------------------------------------------ 
Improvements:
	- Removing 'POP before SMTP' as post authentication mean.
	- clmsndr is directly interfaced to SQL data-base, no need to 
	  listen on localhost anymore.
	- User group management interface
	- Quarantine report can be done according group time zone.

;========================================================================
Revision: 2.5.0.94, Date: 2010/10/08 01:02:51 
;------------------------------------------------------------------------ 
Improvements:
	- SQL table "emlogs" store clement group ownership to improve
	  search speed while browsing logs.