($Id: CHANGES 14 2005-12-03 17:17:22Z ggw $) mysqlSendmail ------------- Brief outline of major changes from release to release --- 1.1 -> 1.2 main.c, tuserfunc.h: Added code for uMailFilter procmail system Added LICENSE Added this CHANGES Changed makefile for LICENSE and CHANGES into distribution. Changed taliasfunc.h for anounce (sic) fix -to announce- and better dir choice for list. Changed tJob for Root users: Added [Purge] button. Changed tJob and tJobStatus.txt: Added mysqlISP_Waiting status. Changed mail.c added code for uMailFilter fake ISP jobs. --- 1.2 --> 1.21 main.c release update makefile same INSTALL cleanup tconfiguration.c wrap changed for procmail non standard line continuation mail.c umask fixed for .procmailrc file data/tConfiguration.txt changed for working .procmailrc default docs/tutorial.html updated to show slave spam iso server crontab setup. --- 1.21 --> 1.3 FreeBSD support Production tests data and docs 1.21 release mistakes fixed main.c release update to 1.3 main.c fix for root level users view via tTablePullDownOwner() New dir layout cleaned-up spam-system makefile changed for optional -DFreeBSD mysqlrad.h changed for -DFreeBSD lckpwdf.c added for FreeBSD support All t*.c Createt*(void) like functions upgraded for mySQL 4.1 auto inc no 0 default allowed. data/tConfiguration.txt modified wrapped \ lines (do not work in procmail. See 1.21 release notes.) spam-system/HOWTO and README expanded and explained docs/tutorial.html spam-system cluster iso server crontab added. Tons of changes in many standard .c and .h files for Customer/Reseller support. docs/tutorial.html Customer/Reseller support step by step example test method. This CHANGES file updated of course :) --- 1.3 --> 1.4 tclientfunc.h root/reseller/customer tree like in new mysqlBind Focused on the 4 levels of authorized user interface. docs/tutorial expansion. --- 1.4 --> 1.41 Returned non cvs release 1.4 back into cvs Added qpopper dir to distro Added optional makefile and tUser UpdateInfo() and mail on make. See local.h --- 1.41 --> 1.42 RELEASE Added experimental end pop3/imap user passwd change capability this must be tested, and interfaced with mysqlISP if controlling this subsystem. This meant changing several files. Changed makefile mail on make for minor uname info, so as to not need to check mail headers for this public info. Also supplies OS name. Fixed root level access to tAuthorize mods. Added template and alias cgi method for above self help user passwd change system. tConfiguration finally corrected and expanded for self help system templates. docs/tutorial.html expanded for the initial self-help (web console) interface. --- 1.42 --> 1.43 Added NotifyISPSupport() in tuserfunc.h for use with self-help modules. A simple tConfiguration based emailer. Fixed INSTALL for no version info. Changed release info into local.h. Now all we need to edit is makefile and local.h to change release number. Fixed const char * mySQL 4 issue compile warning issues. --- 1.43 --> 1.5 RELEASE Added tClient [Report] (button) and simple text report for tUser,tDomain,tAccess ,tLocal,tVUT. Added NotifyISPSupport tConfiguration sample entries. Please change if used. --- 1.5 --> 1.51 RELEASE Added GetConfiguration for announce.list (cAnnounceList) Fixed [Make Home Dir] in tUser to allow for perm level reseller. Changed WordToLower to allow . (for ex. in tAlias.) Must see if this may create problems elsewhere. Added MD5 Support. Only for changing via md5 paste and import support. Fixed mySQL 4 NULL on MAX call in UpdateInfo. Only applies to installs where tUser table is empty. Added MD5 support to end user ChangeUserPass.cgi symbolic link to mysqlSendmail.cgi. Note that MD5 support requires glibc2. --- 1.51 --> 1.52 rc Added "error:nouser No such user" support for tVUTEntries. Added more mysql_real_connect args. Added enhanced mysqlISP connect. Added tConfiguration based mysql root passwd for ps scan security. Eliminated usually unneeded menu links. Added W3C compliance headers. Added mysqlISP uISPClient suppport for external jobs. Added support for mysqlISP jobs with cMailFilter=procmail-spamiso where procmail-spamiso is in tMailFilter.cLabel. Then if tConfiguration cLabel=procmail-default (or a per user based procmail-joe) exists cValue should have a server target for a mysqlSendmail slave job: (FakeISPJob,MakeHomeDir=Yes,...Passwd='passwd'.) This is the case for a spamassassin procmail that forwards spam mail to a remote server where users can via webmail dispose of faster. Or just ignore (in that case a crontab job would clean out.) --- 1.52rc2 --> 1.52rc3 Added server=None (in tConfiguration.cLabel) for tMailFilter/tConfiguration system when we need no remote job for special mysqlSendmail slave. FreeBSD clean up, sendmail interfacing, courtesy of David Hiebert: Mods in makefile, INSTALL. mysqlrad.h Change all useradd/usermod and userdel to tConfiguration name/value pairs. All optional linux based defaults (use #ifdef for FreeBSD?.) Relevant tConfiguration.cLabel's: cUserAddWithHomeDir cUserAdd cUserDelCommand cUserModForHomeDir cUserModForGIDError cUserModForUIDError --- 1.52rc3 --> 1.52rc4 Fixed tCreateX() for mySQL 5 PRIMARY KEY compatability. Changed local.h defined feedback to off by default. Added sedall.sh for: More FreeBSD support changes, casts added. Tested at DE ISP. Thanks Mela! --- 1.52rc4 --> 1.52rc5 Adding lost mysqlISP mysqlSendmail sync when tUser insert failed based on the tUser.cLogin already used and deployed. See notes in mail.c Fixing missing mysql_close() for error log cleanup. Adding quick tDomain add to tAccess, tLocal and tVUT. Adding new main link host name and release info. Changed nav button widths. Adding special "_private" cEnterPasswd value to hide clear text passwds after cPasswd is already setup.. --- 1.52rc5 --> 1.53 Added command line MigrateUsers utility to move tUser's from one mysqlSendmail server to another in a somewhat organized fashion. --- TODO SECTION DETAILS (New section for things we need to do for future releases) Ref# May be related to feature or bug request tracking number or internal. Ref# Starting with i are internal entries (mentioned in here first, but should be cross checked with sourceforge trackers) Priority levels attached to entries: -H High -L Low -M Medium -U Unknown --- TODO Items Ref-PL Explanation i1-H Experimental login for pop3/imap users, has a minor uPermLevel problem on login. tUser is not visible or uPermLevel label. i2-L Provide examples on using mod_auth_mysql with tClient/tAuthorize derived table to access a given cgi-bin for more security with reseller/customer level webconsoles. These should always be SSL only of course. Good starting point: http://www.cgi101.com/class/password/mod_auth_mysql.html // vim:tw=78