YellowJug.com

After years of nonstop listening to reggae music, I realized that the lyrics of reggae songs, in most of the cases, are rather predictable.

Here is my proof of concept, just for fun: Reggae Song Lyrics Generator, check it out :)

Gmail recently added a new anti-phishing feature that seems to not like too much mailing lists managed with Mailman (hosting providers often integrate this software in their control panel).

Several e-mails sent through those mailing lists are now “flagged” with the following warning:

This message may not have been sent by:

sendername@gmail.com Learn More Report Phishing

I currently have a couple of mailing list hosted by my personal server: due to the popularity of Gmail, this systematically displayed message is quite annoying, and tends to “alarm” some users of the mailing list.

If you are hosting a mailing list in your server, and you experience the same issue, here is a simple solution…

As Google recommends in the Gmail support section, you can create an SPF (Sender Policy Framework) record to your domain, so your mailing list will be authenticated.

To create an SPF record for your domain, access the Control Panel (e.g. CPanel) provided by your Hosting Company:

1. Go to the section where you can edit the DNS (e.g. In Cpanel, “DNS -> Advanced DNS zone editor”)
2. Add a new TXT record where the record name will be yourdomain.com. (NB. Do not add any www prefix, just the domain name and don’t forget the . after your domain name, it’s important!)
3. In the TXT Data field, write: v=spf1 ip4:123.456.789.000 ~all (don’t forget to replace the IP in this example with your real IP)
4. Leave the default value in the field TTL

(Needless to say/repeat, replace yourdomain.com with your domain name, and 123.456.789.000 with the IP of your server).

That’s it. There are different possible values you can add to your SPF record, they may be more or less “permissive” (e.g. emails sent just from some subdomains etc…). However the aforementioned example should work for everyone, if you need something more specific then start from here and follow the links.

It may take a while to have these changes to your DNS propagated worldwide (up to 48 hours), then, once the SPF record in your domain is active, the email sent through your mailing list(s) won’t display any more the phishing warning in Gmail. That’s it :)

How to check whether your SPF record works correctly?

• Go here, for example: http://www.kitterman.com/spf/validate.html

• Write your domain name in the field “Domain name:” (do not put any www., use just the domain name and the extension e.g. yourdomain.com) and press “Get SPF record (if any)“.
• If the result is positive you’ll have a response which will look like “The TXT records found for your domain are:” etc… (the page will also display a validation of the record). Otherwise, you’ll obtain this error “No type SPF records found.” (This may mean that there is something wrong in your SPF record, or that your DNS are not propagated yet).

There is also a way to check whether your SPF record is active and works properly. You can enter Gmail and give a look to the headers of the emails sent through your mailing list.

The headers of the e-mails sent to a mailing list whose domain doesn’t have an SPF record, report a section similar to this one:

Received-SPF: neutral (google.com: 184.154.xxx.xxx is neither permitted nor denied by best guess record for domain of mailing-list@yourdomain.com) client-ip=184.154.xxx.xxx;

While an active SPF record in your domain would produce the following header:

Authentication-Results: mx.google.com; spf=pass (google.com: domain of mailing-list@yourdomain.com designates 184.154.xxx.xxx as permitted sender) smtp.mail=mailing-list@yourdomain.com; dkim=neutral (body hash did not verify) header.i=@gmail.com

Thus avoiding the annoying Phishing warning in the Gmail webmail interface.

Tempo fa avevo confezionato una serie di esercizi progressivi sui fogli di calcolo (Openoffice Calc ed Excel) per la preparazione all’esame di informatica degli studenti dell’Università di Bergamo.

Ho deciso di metterli a disposizione di tutti coloro che desiderino migliorare le proprie conoscenze sui fogli di calcolo.

E’ possibile scaricare liberamente tali esercizi in versione Openoffice Calc oppure in versione Excel (esportata dall’originale in Openoffice): il file contiene tutti gli esercizi in ordine progressivo, comprensivi di suggerimenti, unitamente alle soluzioni finali in un foglio separato, che serviranno a verificare i propri risultati.

Il materiale qui distribuito è rilasciato attraverso una licenza Creative Commons By-Nc-Nd, e secondo tali criteri va utilizzato.

Di seguto una lista delle tematiche trattate:

• operazioni aritmetiche elementari
• somme e calcolo dei totali
• calcolo della media e dei valori massimi e minimi
• operatori di confronto
• operazioni su celle ed aree contigue o non contigue
• ordinamento dati e creazione di grafici
• calcolo percentuali
• calcolo percentuali e proporzionalità
• funzioni, arrotondamenti decimali e grafici
• gestione ed elaborazione dei dati
• gestione bilancio
• utilizzo riferimenti assoluti
• moltiplicazioni, riferimenti relativi e assoluti
• formule, proporzionalità, percentuali e riferimenti assoluti

Scarica gli esercizi:

• Versione Openoffice Calc – CONSIGLIATO [File compresso ZIP, 96KB]
• Versione Excel [File compresso ZIP, 20KB]

Puoi scaricare Openoffice.org, suite d’ufficio libera e gratuita (comprendente foglio di calcolo, programma di videoscrittura, presentazioni etc…) all’indirizzo http://www.openoffice.org.