Using ssh over https for

Recently i tried to access my bitbucket repository from inside a corporate network which blocks all traffic on port 22. After several unsuccessful trials to simply use https, I looked for another possibility. The solution was quite simple: ssh over https

The default clone command of a repository will be something like:

git clone${YOURUSER}/${YOURPROJECT}.git

Thanks to this site: CraigTP’s Blog i found out that bitbucket provides access to ssh over port 443 with an alternative url:

In order to get access using ssh, I did this:

  1. Added my company account/email as a user to the according repository(becasue we also use git within the company)
  2. Registered with this mail and put my public ssh key to bitbucket
  3. Modified the .ssh/config as shown below
# Added content for ~/.ssh/config
   Port 443

This finally gave me access 🙂





Posted in Uncategorized | Leave a comment

Easy Conditional formatting based on values of another column in Google Sheets

Before i’ve known the following tip, i used to format my cells in a google sheet based on the current day with indirection functions and such stuff. To check if the column A of the current row contains a date later than today, i used the following expression:


After a recent discussion with a colleague it could be made WAY easier. To conditionally format, e.g. the range of D6:N36 based on the date of the column A in the current row simply use instead:

=$A6 > TODAY()

and your’e done!

Sometimes life is way more simple than you think 🙂

Posted in Uncategorized | Leave a comment

Setting personalized ShortKeys in Xfce4 Terminal in LinuxLite (tested with 3.2)

Afaik, in newer versions of XFCE it’s possible to enable Menu Accelerators like in GTK+. LinuxLite 3.2 hasn’t this option enabled by default. For me i wanted that XFCE4 Terminal behaves like the gnome terminal, so i can move tabs using Shift+Ctrl+{PgUp|PgDown}.

The first step doing this is enabling the editable menu accelerators in the Settings:

Menu -> Settings -> SettingsManager -> Appearance -> Settings:
Activate “[] Enable editable accelerators”

see also:

Afterwards simply open a menu item and press the desired Keyboard Combination to be used as ShortKey. To remove it, use Backspace. I don’t know if you can undo this.

Posted in Uncategorized | Leave a comment

Changing Line Styles of multiple lines in Enterprise Architect at once

  1. Open the relationship view: CTRL+SHIFT+2
  2. Select all elements on your diagram using the mouse and dragging a selection box around them (Ctrl + A does not work in this tip). Easiest way is to zoom out until the whole diagram is visible.
  3. This displays the Relationships dialog where you should see all the relationships for your diagram.
  4. Select one or more relationships in this dialog. Here you can use CTRL+A as you like
  5. Right-click and select Appearance… to change the width / colour of all selected relationships.
  6. Right-click and select Line Style to change the line style of all selected relationships.

Tested using Enterprise Architect 13

The original tip comes from:


Posted in Uncategorized | Leave a comment

Keeping active edges with synergy

Consider you have two screens right beside each other:

 Curly        Moe
-----------   |XXXXXXXXXXXXXX|
|         |   |              |
|         |   |              |
|         |   |              |
-----------   ----------------

X – marks a region where you want to have a non-switching region, e.g. if you have active edges or different monitor heights.

For this case, synergy supports ranges in the links section. The ranges are given as percentages. For the case above, to exclude a small portion of the screen Moe, use the following setup:

section: links
        # the full right edge of Curly is mapped to 5% - 100% of 
        # the left edge of Moe
        right        = Moe(5,100)
        # same config but for the other side
        left(5,100)  = Curly

Using this feature you can realize partial overlaps on both sides as well. For detailed information look at the full synergy config documentation: Synergy Text_Config



Posted in Uncategorized | Leave a comment

Installing chrome as non root user

If you want to install google chrome as a non root user in debian (e.g. jessie) you have to simply:

1. Unpack the .deb manually

dpkg -x google-chrome-stable_current_amd64.deb /local/mysoft/chrome

2. Start chrome with –no-sandbox option

/local/mysoft/chrome/opt/google/chrome/chrome --no-sandbox
Posted in Uncategorized | Leave a comment

Redirecting the output of scp to a log file

Logging the output of scp (and similar commands) doesn’t work the straightforward way of a simple redirection because scp uses direct terminal codes and if it detects a redirection, it doesn’t output anything.

Fortunately there is a command called script which is able to simulate a terminal so the output could be recorded.

To trace the output of

scp $REMOTE_SERVER:~/test/test.file /dev/null

Wrap a script command around

# fetch the file, but don't store it locally
script -q -c "scp $REMOTE_SERVER:~/test/test.file /dev/null" 2>&1 | tee scpLog
# replace carriage return with newline
sed -i -e 's/\r/\n/g' scpLog

And your’e done

Posted in Uncategorized | Leave a comment