Effective handover-meeting and SSH-tunneling

Today we started the day with a meeting. Tomas came by and we asked a lot of questions. Much confusion and information flew in the office.



When the meeting was announced to take place, I created a document to write down all the questions I had. So I would get the info I needed as much as possible. This was very usefull.

Apparently files I needed to access was on a server where a password was forgotten. There was a green sd-card with the same files on it but it seems impossible to crack...



The files where impossible to open in windows, it just loaded forever... So we tried installing vm ware workstation, mounting a virtual ubuntu to run and opening the files... But to no avail. First I got an error where the sd-card crashed the vm ware workstation. Then later it started bluescreening the computer. this is getting a bit interesting...

Anyway I learned a lot about what servers they use and where data is stored and how to get it. I also learned that the r-pi is just going to take the raw data from the can-cards to upload it to the MySQL server.


SSH tunnel

After leaving the files I just looked and programmed some python to create the SSH-tunnel. It was quite easy but one problem occured. I had switched the name in the port-title or whatever with the number.

It should be:
test-123.mysql.binero.se
not:
123-test.mysql.binero.se

This was tricky because our domain provider had the wrong as a standard and just used the other combination when making an ssh-tunnel. Anyway, it was solved by going through every possible thing as usual.

Python MySQL

So when I got that working I got the MySQL commands to work in python as well.

# execute SQL query using execute() method.
cursor.execute("SELECT VERSION()") 

>>> "5.5.42-MariaDB-cll-lve"

Yay!

Next week I have planned to make a marketing-analysis... We'll see how that goes... I just do it because it's needed for passing the program I'm studying. Not really keen on it.