[Dspam-devel] [ dspam-Bug Tracker-2989885 ] maintenance script does not work properly on FreeBSD 8
Bug Tracker item #2989885, was opened at 2010-04-20 13:08 Message generated for change (Tracker Item Submitted) made by You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=1126467&aid=2989885&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: contrib/thunderbird Group: v3.9.0 Status: Open Resolution: None Priority: 5 Private: No Submitted By: https://www.google.com/accounts () Assigned to: Nobody/Anonymous (nobody) Summary: maintenance script does not work properly on FreeBSD 8 Initial Comment: When the script is run, one gets this: [: 0: unexpected operator [: 0: unexpected operator [: NO: unexpected operator I have no idea which tests are failing -- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=1126467&aid=2989885&group_id=250683 -- Download Intel® Parallel Studio Eval Try the new software tools for yourself. Speed compiling, find bugs proactively, and fine-tune applications for parallel performance. See why Intel Parallel Studio got high marks during beta. http://p.sf.net/sfu/intel-sw-dev ___ Dspam-devel mailing list Dspam-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspam-devel
[Dspam-devel] [ dspam-Bug Tracker-2989885 ] maintenance script does not work properly on FreeBSD 8
Bug Tracker item #2989885, was opened at 2010-04-20 15:08 Message generated for change (Comment added) made by sbajic You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=1126467&aid=2989885&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: contrib/thunderbird Group: v3.9.0 >Status: Closed >Resolution: Fixed Priority: 5 Private: No Submitted By: https://www.google.com/accounts () >Assigned to: Stevan Bajic (sbajic) Summary: maintenance script does not work properly on FreeBSD 8 Initial Comment: When the script is run, one gets this: [: 0: unexpected operator [: 0: unexpected operator [: NO: unexpected operator I have no idea which tests are failing -- >Comment By: Stevan Bajic (sbajic) Date: 2010-04-20 15:18 Message: Please check latest version from GIT: http://dspam.git.sourceforge.net/git/gitweb.cgi?p=dspam/dspam;a=blob;f=contrib/dspam_maintenance/dspam_maintenance.sh;hb=HEAD Maybe you need to change the shebang from /bin/bash to /usr/local/bin/bash. Let me know if you still have issues with the script. -- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=1126467&aid=2989885&group_id=250683 -- Download Intel® Parallel Studio Eval Try the new software tools for yourself. Speed compiling, find bugs proactively, and fine-tune applications for parallel performance. See why Intel Parallel Studio got high marks during beta. http://p.sf.net/sfu/intel-sw-dev ___ Dspam-devel mailing list Dspam-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspam-devel
[Dspam-devel] [ dspam-Bug Tracker-2989981 ] maintenance script: MySQL purge password denied
Bug Tracker item #2989981, was opened at 2010-04-20 16:31 Message generated for change (Tracker Item Submitted) made by You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=1126467&aid=2989981&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: contrib/thunderbird Group: v3.9.0 Status: Open Resolution: None Priority: 5 Private: No Submitted By: interfaSys () Assigned to: Nobody/Anonymous (nobody) Summary: maintenance script: MySQL purge password denied Initial Comment: I've just tested the new version of the script which has improved a lot, but the SQL purge script cannot be run. I'm guessing the password is not correctly extracted from the config file? Maybe the script has a problem with special characters? Enabled drivers are: mysql_drv Running dspam_logrotate in the background Active driver is: mysql_drv Running MySQL storage driver data cleanup ERROR 1045 (28000): Access denied for user 'dspam2010'@'localhost' (using password: YES) MySQL purge script returned error code 1 Running dspam_clean ... * without purging old signatures -- -- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=1126467&aid=2989981&group_id=250683 -- Download Intel® Parallel Studio Eval Try the new software tools for yourself. Speed compiling, find bugs proactively, and fine-tune applications for parallel performance. See why Intel Parallel Studio got high marks during beta. http://p.sf.net/sfu/intel-sw-dev ___ Dspam-devel mailing list Dspam-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspam-devel
[Dspam-devel] [ dspam-Bug Tracker-2989981 ] maintenance script: MySQL purge password denied
Bug Tracker item #2989981, was opened at 2010-04-20 18:31 Message generated for change (Comment added) made by sbajic You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=1126467&aid=2989981&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: contrib/thunderbird Group: v3.9.0 Status: Open Resolution: None Priority: 5 Private: No Submitted By: interfaSys () >Assigned to: Stevan Bajic (sbajic) Summary: maintenance script: MySQL purge password denied Initial Comment: I've just tested the new version of the script which has improved a lot, but the SQL purge script cannot be run. I'm guessing the password is not correctly extracted from the config file? Maybe the script has a problem with special characters? Enabled drivers are: mysql_drv Running dspam_logrotate in the background Active driver is: mysql_drv Running MySQL storage driver data cleanup ERROR 1045 (28000): Access denied for user 'dspam2010'@'localhost' (using password: YES) MySQL purge script returned error code 1 Running dspam_clean ... * without purging old signatures -- -- >Comment By: Stevan Bajic (sbajic) Date: 2010-04-20 18:37 Message: Hallo interfaSys Run the script with "/bin/bash -x /path/to/dspam_maintenance.sh" and mail me the output. Please look at the output and replace the password used with something like XXX. Stevan -- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=1126467&aid=2989981&group_id=250683 -- Download Intel® Parallel Studio Eval Try the new software tools for yourself. Speed compiling, find bugs proactively, and fine-tune applications for parallel performance. See why Intel Parallel Studio got high marks during beta. http://p.sf.net/sfu/intel-sw-dev ___ Dspam-devel mailing list Dspam-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspam-devel
[Dspam-devel] [ dspam-Bug Tracker-2989984 ] maintenance script: command run twice in a row?
Bug Tracker item #2989984, was opened at 2010-04-20 16:38 Message generated for change (Tracker Item Submitted) made by You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=1126467&aid=2989984&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: contrib/thunderbird Group: v3.9.0 Status: Open Resolution: None Priority: 5 Private: No Submitted By: interfaSys () Assigned to: Nobody/Anonymous (nobody) Summary: maintenance script: command run twice in a row? Initial Comment: The script generates this statement twice in a row: SET timestamp=1271780703; SELECT token,spam_hits,innocent_hits,unix_timestamp(last_hit) FROM dspam_token_data WHERE uid=14; Since it's quite a costly operation, wouldn't it be possible to only call it once? This must be from dspam_clean. I'm calling it like this: /usr/local/bin/dspam_maintenance.sh --logdays=30 --signatures=30 --unused=60 --with-sql-optimization --verbose and the result is Enabled drivers are: mysql_drv Running dspam_logrotate in the background Active driver is: mysql_drv Running dspam_clean ... * without purging old signatures -- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=1126467&aid=2989984&group_id=250683 -- Download Intel® Parallel Studio Eval Try the new software tools for yourself. Speed compiling, find bugs proactively, and fine-tune applications for parallel performance. See why Intel Parallel Studio got high marks during beta. http://p.sf.net/sfu/intel-sw-dev ___ Dspam-devel mailing list Dspam-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspam-devel
[Dspam-devel] [ dspam-Bug Tracker-2989981 ] maintenance script: MySQL purge password denied
Bug Tracker item #2989981, was opened at 2010-04-20 16:31 Message generated for change (Comment added) made by You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=1126467&aid=2989981&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: contrib/thunderbird Group: v3.9.0 Status: Open Resolution: None Priority: 5 Private: No Submitted By: interfaSys () Assigned to: Stevan Bajic (sbajic) Summary: maintenance script: MySQL purge password denied Initial Comment: I've just tested the new version of the script which has improved a lot, but the SQL purge script cannot be run. I'm guessing the password is not correctly extracted from the config file? Maybe the script has a problem with special characters? Enabled drivers are: mysql_drv Running dspam_logrotate in the background Active driver is: mysql_drv Running MySQL storage driver data cleanup ERROR 1045 (28000): Access denied for user 'dspam2010'@'localhost' (using password: YES) MySQL purge script returned error code 1 Running dspam_clean ... * without purging old signatures -- -- >Comment By: interfaSys () Date: 2010-04-20 16:45 Message: Hello Stevan, I just ran the script and I can tell you that the password is wrong. It seems the maintenance script doesn't like special characters. Do you still want a copy of the whole output? Cheers, Olivier -- Comment By: Stevan Bajic (sbajic) Date: 2010-04-20 16:37 Message: Hallo interfaSys Run the script with "/bin/bash -x /path/to/dspam_maintenance.sh" and mail me the output. Please look at the output and replace the password used with something like XXX. Stevan -- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=1126467&aid=2989981&group_id=250683 -- Download Intel® Parallel Studio Eval Try the new software tools for yourself. Speed compiling, find bugs proactively, and fine-tune applications for parallel performance. See why Intel Parallel Studio got high marks during beta. http://p.sf.net/sfu/intel-sw-dev ___ Dspam-devel mailing list Dspam-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspam-devel
[Dspam-devel] [ dspam-Bug Tracker-2989981 ] maintenance script: MySQL purge password denied
Bug Tracker item #2989981, was opened at 2010-04-20 18:31 Message generated for change (Comment added) made by sbajic You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=1126467&aid=2989981&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: contrib/thunderbird Group: v3.9.0 Status: Open Resolution: None Priority: 5 Private: No Submitted By: interfaSys () Assigned to: Stevan Bajic (sbajic) Summary: maintenance script: MySQL purge password denied Initial Comment: I've just tested the new version of the script which has improved a lot, but the SQL purge script cannot be run. I'm guessing the password is not correctly extracted from the config file? Maybe the script has a problem with special characters? Enabled drivers are: mysql_drv Running dspam_logrotate in the background Active driver is: mysql_drv Running MySQL storage driver data cleanup ERROR 1045 (28000): Access denied for user 'dspam2010'@'localhost' (using password: YES) MySQL purge script returned error code 1 Running dspam_clean ... * without purging old signatures -- -- >Comment By: Stevan Bajic (sbajic) Date: 2010-04-20 18:57 Message: Hallo Oliver, no. I then don't need the output. But I need to know what special character you used? Give me a hint. Stevan -- Comment By: interfaSys () Date: 2010-04-20 18:45 Message: Hello Stevan, I just ran the script and I can tell you that the password is wrong. It seems the maintenance script doesn't like special characters. Do you still want a copy of the whole output? Cheers, Olivier -- Comment By: Stevan Bajic (sbajic) Date: 2010-04-20 18:37 Message: Hallo interfaSys Run the script with "/bin/bash -x /path/to/dspam_maintenance.sh" and mail me the output. Please look at the output and replace the password used with something like XXX. Stevan -- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=1126467&aid=2989981&group_id=250683 -- Download Intel® Parallel Studio Eval Try the new software tools for yourself. Speed compiling, find bugs proactively, and fine-tune applications for parallel performance. See why Intel Parallel Studio got high marks during beta. http://p.sf.net/sfu/intel-sw-dev ___ Dspam-devel mailing list Dspam-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspam-devel
[Dspam-devel] [ dspam-Bug Tracker-2989981 ] maintenance script: MySQL purge password denied
Bug Tracker item #2989981, was opened at 2010-04-20 16:31 Message generated for change (Comment added) made by You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=1126467&aid=2989981&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: contrib/thunderbird Group: v3.9.0 Status: Open Resolution: None Priority: 5 Private: No Submitted By: interfaSys () Assigned to: Stevan Bajic (sbajic) Summary: maintenance script: MySQL purge password denied Initial Comment: I've just tested the new version of the script which has improved a lot, but the SQL purge script cannot be run. I'm guessing the password is not correctly extracted from the config file? Maybe the script has a problem with special characters? Enabled drivers are: mysql_drv Running dspam_logrotate in the background Active driver is: mysql_drv Running MySQL storage driver data cleanup ERROR 1045 (28000): Access denied for user 'dspam2010'@'localhost' (using password: YES) MySQL purge script returned error code 1 Running dspam_clean ... * without purging old signatures -- -- >Comment By: interfaSys () Date: 2010-04-20 17:11 Message: OK, I sent it to you via the SF messaging system Olivier -- Comment By: Stevan Bajic (sbajic) Date: 2010-04-20 16:57 Message: Hallo Oliver, no. I then don't need the output. But I need to know what special character you used? Give me a hint. Stevan -- Comment By: interfaSys () Date: 2010-04-20 16:45 Message: Hello Stevan, I just ran the script and I can tell you that the password is wrong. It seems the maintenance script doesn't like special characters. Do you still want a copy of the whole output? Cheers, Olivier -- Comment By: Stevan Bajic (sbajic) Date: 2010-04-20 16:37 Message: Hallo interfaSys Run the script with "/bin/bash -x /path/to/dspam_maintenance.sh" and mail me the output. Please look at the output and replace the password used with something like XXX. Stevan -- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=1126467&aid=2989981&group_id=250683 -- Download Intel® Parallel Studio Eval Try the new software tools for yourself. Speed compiling, find bugs proactively, and fine-tune applications for parallel performance. See why Intel Parallel Studio got high marks during beta. http://p.sf.net/sfu/intel-sw-dev ___ Dspam-devel mailing list Dspam-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspam-devel
[Dspam-devel] [ dspam-Bug Tracker-2989981 ] maintenance script: MySQL purge password denied
Bug Tracker item #2989981, was opened at 2010-04-20 16:31 Message generated for change (Comment added) made by You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=1126467&aid=2989981&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: contrib/thunderbird Group: v3.9.0 Status: Open Resolution: None Priority: 5 Private: No Submitted By: interfaSys () Assigned to: Stevan Bajic (sbajic) Summary: maintenance script: MySQL purge password denied Initial Comment: I've just tested the new version of the script which has improved a lot, but the SQL purge script cannot be run. I'm guessing the password is not correctly extracted from the config file? Maybe the script has a problem with special characters? Enabled drivers are: mysql_drv Running dspam_logrotate in the background Active driver is: mysql_drv Running MySQL storage driver data cleanup ERROR 1045 (28000): Access denied for user 'dspam2010'@'localhost' (using password: YES) MySQL purge script returned error code 1 Running dspam_clean ... * without purging old signatures -- -- >Comment By: interfaSys () Date: 2010-04-21 06:13 Message: I've tested version 1.17 and rechecked the logs. The problem is with the eval function. The password is correct before that. -- Comment By: interfaSys () Date: 2010-04-20 17:11 Message: OK, I sent it to you via the SF messaging system Olivier -- Comment By: Stevan Bajic (sbajic) Date: 2010-04-20 16:57 Message: Hallo Oliver, no. I then don't need the output. But I need to know what special character you used? Give me a hint. Stevan -- Comment By: interfaSys () Date: 2010-04-20 16:45 Message: Hello Stevan, I just ran the script and I can tell you that the password is wrong. It seems the maintenance script doesn't like special characters. Do you still want a copy of the whole output? Cheers, Olivier -- Comment By: Stevan Bajic (sbajic) Date: 2010-04-20 16:37 Message: Hallo interfaSys Run the script with "/bin/bash -x /path/to/dspam_maintenance.sh" and mail me the output. Please look at the output and replace the password used with something like XXX. Stevan -- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=1126467&aid=2989981&group_id=250683 -- ___ Dspam-devel mailing list Dspam-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspam-devel
[Dspam-devel] [ dspam-Bug Tracker-2989981 ] maintenance script: MySQL purge password denied
Bug Tracker item #2989981, was opened at 2010-04-20 18:31 Message generated for change (Comment added) made by sbajic You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=1126467&aid=2989981&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: contrib/thunderbird Group: v3.9.0 Status: Open Resolution: None Priority: 5 Private: No Submitted By: interfaSys () Assigned to: Stevan Bajic (sbajic) Summary: maintenance script: MySQL purge password denied Initial Comment: I've just tested the new version of the script which has improved a lot, but the SQL purge script cannot be run. I'm guessing the password is not correctly extracted from the config file? Maybe the script has a problem with special characters? Enabled drivers are: mysql_drv Running dspam_logrotate in the background Active driver is: mysql_drv Running MySQL storage driver data cleanup ERROR 1045 (28000): Access denied for user 'dspam2010'@'localhost' (using password: YES) MySQL purge script returned error code 1 Running dspam_clean ... * without purging old signatures -- -- >Comment By: Stevan Bajic (sbajic) Date: 2010-04-21 08:17 Message: Hallo Oliver I have not received any mail from you over SF. Could you send a mail to stevan at bajic dot name with an debug output (aka /bin/bash -x dspam_maintenance.sh)? Stevan -- Comment By: interfaSys () Date: 2010-04-21 08:13 Message: I've tested version 1.17 and rechecked the logs. The problem is with the eval function. The password is correct before that. -- Comment By: interfaSys () Date: 2010-04-20 19:11 Message: OK, I sent it to you via the SF messaging system Olivier -- Comment By: Stevan Bajic (sbajic) Date: 2010-04-20 18:57 Message: Hallo Oliver, no. I then don't need the output. But I need to know what special character you used? Give me a hint. Stevan -- Comment By: interfaSys () Date: 2010-04-20 18:45 Message: Hello Stevan, I just ran the script and I can tell you that the password is wrong. It seems the maintenance script doesn't like special characters. Do you still want a copy of the whole output? Cheers, Olivier -- Comment By: Stevan Bajic (sbajic) Date: 2010-04-20 18:37 Message: Hallo interfaSys Run the script with "/bin/bash -x /path/to/dspam_maintenance.sh" and mail me the output. Please look at the output and replace the password used with something like XXX. Stevan -- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=1126467&aid=2989981&group_id=250683 -- ___ Dspam-devel mailing list Dspam-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspam-devel
[Dspam-devel] [ dspam-Bug Tracker-2989981 ] maintenance script: MySQL purge password denied
Bug Tracker item #2989981, was opened at 2010-04-20 18:31 Message generated for change (Comment added) made by sbajic You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=1126467&aid=2989981&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: contrib/thunderbird Group: v3.9.0 Status: Open Resolution: None Priority: 5 Private: No Submitted By: interfaSys () Assigned to: Stevan Bajic (sbajic) Summary: maintenance script: MySQL purge password denied Initial Comment: I've just tested the new version of the script which has improved a lot, but the SQL purge script cannot be run. I'm guessing the password is not correctly extracted from the config file? Maybe the script has a problem with special characters? Enabled drivers are: mysql_drv Running dspam_logrotate in the background Active driver is: mysql_drv Running MySQL storage driver data cleanup ERROR 1045 (28000): Access denied for user 'dspam2010'@'localhost' (using password: YES) MySQL purge script returned error code 1 Running dspam_clean ... * without purging old signatures -- -- >Comment By: Stevan Bajic (sbajic) Date: 2010-04-21 08:28 Message: btw: What special character do you use? -- Comment By: Stevan Bajic (sbajic) Date: 2010-04-21 08:17 Message: Hallo Oliver I have not received any mail from you over SF. Could you send a mail to stevan at bajic dot name with an debug output (aka /bin/bash -x dspam_maintenance.sh)? Stevan -- Comment By: interfaSys () Date: 2010-04-21 08:13 Message: I've tested version 1.17 and rechecked the logs. The problem is with the eval function. The password is correct before that. -- Comment By: interfaSys () Date: 2010-04-20 19:11 Message: OK, I sent it to you via the SF messaging system Olivier -- Comment By: Stevan Bajic (sbajic) Date: 2010-04-20 18:57 Message: Hallo Oliver, no. I then don't need the output. But I need to know what special character you used? Give me a hint. Stevan -- Comment By: interfaSys () Date: 2010-04-20 18:45 Message: Hello Stevan, I just ran the script and I can tell you that the password is wrong. It seems the maintenance script doesn't like special characters. Do you still want a copy of the whole output? Cheers, Olivier -- Comment By: Stevan Bajic (sbajic) Date: 2010-04-20 18:37 Message: Hallo interfaSys Run the script with "/bin/bash -x /path/to/dspam_maintenance.sh" and mail me the output. Please look at the output and replace the password used with something like XXX. Stevan -- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=1126467&aid=2989981&group_id=250683 -- ___ Dspam-devel mailing list Dspam-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspam-devel