Re: does anyone else have problems sending mails to this list ?
> please refrain from answering when you have no clue how DNS blacklists are > working and what about others are talking Well, excuse me! Someone put on their bossy pants this morning! A simple “That’s not what’s going on here” would have been much nicer. J -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
Re: Conditional ODER BY Clause HELP
2016/03/18 12:54 ... Don Wieland: Trying to get the correct syntax on this: ORDER BY CASE WHEN tr.Placed = "X" THEN r.Division ASC, FIELD(tr.Place,"1","2","3","4","5","6","7","8","R","WD","Exc","E","S”), tr.Score DESC WHEN tr.Placed != "X" THEN tr.ride_time ASC END How does one deal with CONDITION study like this? That certainly is quite wrong. It is ORDER BY f1 [ASC/DESC], f2 [ASC/DESC], ... where each "f" may be a formula. This is valid: ORDER BY CASE WHEN tr.Placed = "X" THEN r.Division ELSE tr.ride_time END ASC, FIELD(tr.Place,"1","2","3","4","5","6","7","8","R","WD","Exc","E","S”), tr.Score DESC but maybe you don't want that. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
Re: need help from the list admin
- On Mar 19, 2016, at 3:28 PM, Reindl Harald h.rei...@thelounge.net wrote: > Am 19.03.2016 um 15:23 schrieb Reindl Harald: >> >> >> Am 19.03.2016 um 15:17 schrieb Lentes, Bernd: >>> one further question: >>> if some of my e-mails get through (like this one) and others don't, it >>> does not depend on theh reputation of our domain or mailserver ? Right ? >>> So the reason has to be that particular e-Mail? >> >> both >> >> a spamfilter is typically score based and combines a ton of rules, some >> add points, some remove points and the decision is made of the summary >> >> when you have a bad server reputation you start with a penalty, some >> other rules hitting and a not well trained bayes makes the rest >> >> "How do i have to provide the ip" in case of RBLs? >> https://en.wikipedia.org/wiki/Reverse_DNS_lookup > > and that your domain even don't provide a "~all" SPF policy if you can't > or don't want a stricht "-all" makes things not better, typically a > SPF_PASS gives benefits in spamfilter scorings > > Received-SPF: none (helmholtz-muenchen.de: No applicable sender policy > available) receiver=amysql-list-wsv01.oracle.com; identity=mailfrom; > envelope-from="bernd.len...@helmholtz-muenchen.de"; > helo=mtaextp1.scidom.de; client-ip=146.107.103.20 > OK guys. I asked our computing center to provide a SPF ressource record for our outgoing mta in the DNS and to take care that the ip of our outgoing mta appears on https://www.dnswl.org/ (our domain is listed already). I hope they will do. The score of our mta raised already: sunhb58820:~ # nslookup 20.103.107.146.score.senderscore.com. Server: 146.107.1.88 Address:146.107.1.88#53 Non-authoritative answer: Name: 20.103.107.146.score.senderscore.com Address: 127.0.4.76 = 76 isn't bad. But nevertheless it must also have to do with the e-mail itself. I sent it from gmx.de and web.de, both werde declined. My other mails (like this one) arrive. I shrinked the mail already, but also this did not help. You can have a look on the two mails i tried: https://hmgubox.helmholtz-muenchen.de:8001/d/dc1ec4eb38/ I'm thankful for any hint what else i can do, also with the mail itself. Bernd Helmholtz Zentrum Muenchen Deutsches Forschungszentrum fuer Gesundheit und Umwelt (GmbH) Ingolstaedter Landstr. 1 85764 Neuherberg www.helmholtz-muenchen.de Aufsichtsratsvorsitzende: MinDir'in Baerbel Brumme-Bothe Geschaeftsfuehrer: Prof. Dr. Guenther Wess, Dr. Alfons Enhsen, Renate Schlusen (komm.) Registergericht: Amtsgericht Muenchen HRB 6466 USt-IdNr: DE 129521671 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
