Bug Tracker item #3018940, was opened at 2010-06-21 11:02 Message generated for change (Tracker Item Submitted) made by vit_s You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=1126467&aid=3018940&group_id=250683
Please note that this message will contain a full copy of the comment thread, including the initial issue submission, for this request, not just the latest update. Category: None Group: None Status: Open Resolution: None Priority: 5 Private: No Submitted By: Vitauts Stočka (vit_s) Assigned to: Nobody/Anonymous (nobody) Summary: dspam_maintenance MySQL cleanup fails if root/.my.cnf exists Initial Comment: If root user has .my.cnf MySQL options file with password= option set (even empty), dspam_maintenance script data storage cleanup fails with ERROR 1045 (28000): Access denied for user 'dspam'@'localhost' (using password: NO) Reason is the way dspam_maintenance assigns password from tmp file with --defaults-extra-file mysql option. This way .my.cnf from root home directory takes precedence and password from tmp file is never used. Solution is to change --defaults-extra-file to --defaults-file. We don't expect mysql options to be defined anywhere else so it seems safe to use --defaults-file here, which according the documentation "Use only the given option file". See http://dev.mysql.com/doc/refman/5.0/en/option-files.html#option_general_defaults-extra-file This small change solves my problem. Patch attached. With best regards, Vitauts ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=1126467&aid=3018940&group_id=250683 ------------------------------------------------------------------------------ ThinkGeek and WIRED's GeekDad team up for the Ultimate GeekDad Father's Day Giveaway. ONE MASSIVE PRIZE to the lucky parental unit. See the prize list and enter to win: http://p.sf.net/sfu/thinkgeek-promo _______________________________________________ Dspam-devel mailing list Dspam-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspam-devel
