Donnerstag, 24. Mai 2012

Start free for log4job.com - a refrigeration management system

At the first of June 2012 we start operating http://www.log4job.com, a management system for refrigeration units, as well as general actions taken on user defined objects.

For the refrigeration business, http://www.log4job.com offers a complete management of master data, refrigeration units and used refrigerants. With the built in analyses  you can quick get an overview of the trend on used refrigerants e.g.
As all the data are optional, you are - if wanted - able to manage your units quite anonymous.

http://www.log4job.com is a multi lingual system. For the moment, the languages english, german, french, italian, polish, spanish and swedish are native supported.
We intend to implement approximately 30 languages.

State of the art technology has made it possible to keep the price very low. As we won‘t calculate any fee for the sole management, there is no reason more to use excel tables.

In a forthcoming extension of the system, we will integrate a document management system, where you can store you units documentation.

Startschuss für log4job.com - ein Verwaltungssystem für Kälteanlagen

An dem 01.06.2012 geben wir den Startschuss für http://www.log4job.com, ein Verwaltungssystem für sowohl Kälteanlagen als auch allgemeine Tätigkeiten an frei zu definierenden Objekten.

Für die Kältebranche bietet http://www.log4job.com eine vollständige Verwaltung von Stammdaten, Anlagen und eingesetztes Kältemittel. Mit Hilfe der Auswertungen kann schnell der Trend z.B. in Sachen Leckagerate ermittelt werden.
Da alle Daten optional sind, kann - falls erwünscht - die Anlagen relativ „Anonym“ verwaltet werden.

http://www.log4job.com ist ein mehrsprachiges System. Zunächst werden die Sprachen English, Deutsch, Französisch, Italienisch, Polnisch, Spanisch und Schwedisch unterstützt. Das Ziel liegt bei Ca. 30 Sprachen.

Neuste Technik hat uns erlaubt, den Preis sehr niedrig zu halten. Da für de Verwaltung alleine keine Gebühren erhoben werden, gibt es jetzt kein Grund mehr Excel-Tabellen mehr zu nutzen.

In eine kommende Ausbaustufen, ist ein integriertes Dokument-Management-System geplant. In dem Archiv, kann z.B. Schaltpläne und ähnliches elektronisch hinterlegt werden.

Start för log4job.com - ett förvaltningssystem för kylanläggningar

Den förta juni 2012 startar vi http://www.log4job.com, ett förvaltningssystem för kylanläggningar så väl som generella aktiviteter på fri definierbara objekter.

För kylbranschen erbjuder http://www.log4job.com en fullständig förvaltning av stamdata, anläggningar och använt kylmedel. Med hjälp av utvärderingarna kan man snabbt utläsa trenden gällande tex. graden av kylmedel läckage.
Eftersom alla data är valfria, kan - om önskvärt - anläggningarna förvaltas relativ „anonymt“.

http://www.log4job.com är ett mångspråkigt system. Till att börja med, är språken engelska, tyska, franska, italienska, polska, spanska och svenska omsatta. Målet ligger vid Ca. 30 språk.

Nyaste teknik, har gjort det möjligt, att hålla priset väldigt lågt. Eftersom vi inte tar några avgifter för själva förvaltningen, så finns det inga skäl längre att använde excel tabeller.

I en kommande utbyggnad av systemet, är ett dokument förvaltnings-system planerat. I det arkivet, kan man tex. lagra dokumentationen till anläggningarna.

Mittwoch, 9. Mai 2012

Setting up SSL on Heroku

Recently i bought an Thawte SSL certificate for my Heroku application, and i thought it would be useful for you if i wrote down my „how to do“ cook book to get it up and running.
By the way. I'm a Mac user, so for Windows there could be slightly differences...

Please note, that www.domain.com is a placeholder for your domain.

1. Generate a Private Key

-> openssl md5 * > rand.dat
-> openssl genrsa -rand rand.dat -des 2048 > www.domain.com.key
Now you are asked to enter a pass phrase.
Please remember the phrase well, you will need it later!

2. Create a CSR

To be able to order a certificate, you have to supply some information. That bundle of information is called an Certificate Signing Request (CSR).

You generate it using your recently generated key, with the command below.

-> openssl req -new -key www.domain.com.key -out www.domain.com.csr

Now you are asked to enter your pass phrase, entered in step 1 above.
Further more, you have to answer the questions asked:
- Two letter country code: DE (for Germany e.g.)
- State or Province: Bavaria (e.g.)
- Locality Name (e.g. city): Gerbrunn
- Organization Name (e.g. company): Company Ltd (e.g.)
- Organizational Unit Name (e.g. section): CEO
- Common Name (the domain name used with the SSL cert.): www.domain.com
- Email Address: foo@fie.com

'extra' attributes to be sent with the certificate request
- A challenge password: (just return to leave empty)
- An optional company name: (just return to leave empty)

Please note, that according to what certificate you want to order, the data entered here must be the same as in the whois record for the domain. In my case, ordering the certificate "Limitbreaker" provided by http://www.psw.net that wasn't necessary

3. Order a certificate

Copy the content of the www.domain.com.csr to your clipboard, and paste it into the order form.
For mac users. This command transfers the content of the file into the clipboard:
-> pbcopy < www.domain.com.csr

(Hint: "pbpaste > file.txt" is the opposit command ;-)

You can check you CSR here:
https://secure.comodo.net/utilities/decodeCSR.html

When you have gotten the certificate (my mail or download), save it in the file www.domain.com.crt

The certificate that i acquired by Thawte also has an intermediate certificate, that has to be installed in order for the certificate to function properly.
Save that in the file: www.domain.com.intermediate.crt

To keep older browser and mobile devices support, i ALSO had to install the Thawte Cross Root CA Certificate (as additional intermediate certificate).
 Save that in the file www.domain.com.crossroot.crt

Now use a simple and pure text editor to combine all three certificates in one file.
The content of the new file should look like this:

-----BEGIN CERTIFICATE-----
... content of the file www.domain.com.crt ...
-----END CERTIFICATE-----
-----BEGIN CERTIFICATE-----
... content of the file www.domain.com.intermediate.crt ...
-----END CERTIFICATE-----
-----BEGIN CERTIFICATE-----
... content of the file www.domain.com.crossroot.crt ...
-----END CERTIFICATE-----

Save this in the file www.domain.com.all.crt

4. Remove passphrase from key

Later on we need the generated key without the pass phrase, so we have to remove it here:

-> openssl rsa -in www.domain.com.key -out www.domain.com.no_pass.key

Now you have to enter the pass phrase again, and you get the answer: "writing RSA key"

5. Add the Heroku SSL Addon "SSL"

What Heroku SSL service you choose, depends on what you need and on what stack your app is runnig. My app is unfortunately running on the cedar stack, so i have to choose the Endpoint SSL.
(I dont understand, why that cost $20,- / month.)

You add the ssl addon with this command, in the root directory of your project:

-> heroku addons:add ssl:endpoint

6. Add the certificate to your app on Heroku

Copy the files www.domain.com.all.crt and www.domain.com.no_pass.key to your project root directory and enter the command:

-> heroku ssl:add www.domain.com.all.crt www.domain.com.no_pass.key

Update:
Now, as the ssl:endpoint has gon "main stream" on the cedar stack, you add the certificate using this command:
-> heroku certs:add www.domain.com.all.crt www.domain.com.no_pass.key  

7. Check

This Heroku command lists some usefull commands:

-> heroku ssl --help

To get the ssl info for your application, just type this command in the root directory of your project:

-> heroku ssl

8. Self signed Certificate

If you have any problems, you could check if everything else is ok, by creating a self signed certificate.
There exist a Heroku docu on that:

Here are the steps taken from the Heroku doku:
Generate Key:
-> genrsa -des3 -out site.key 2048

Copy key:
-> mv site.key site.orig.key

Remove pass phrase from key:
-> openssl rsa -in site.orig.key -out site.key

Create CSR:
-> openssl req -new -key site.key -out site.csr

Create Certificate:
-> openssl x509 -req -days 365 -in site.csr -signkey site.key -out final.crt

Install on Heroku:
-> cd [root directory of your project]
-> heroku ssl:add final.crt site.key

9. Further reading

Regarding file name extensions:
https://devcenter.heroku.com/articles/ssl-file-extensions

Have fun!
Comments and hints are welcome.