fredag 27 januari 2017

SSH tunneling magically works

Somehow when I tried to connect and try what I tried yesterday, it worked. Instead of getting:

_mysql_exceptions.OperationalError: (2013, "Lost connection to MySQL server at 'reading initial communication packet', system error: 0")

I got the name of the database version used (I sent the SQL "SELECT VERSION()")

I checked the connections with netstat and ps aux and it seemed like yesterday.

I tried to replicate the error but it allways worked now. So I went to upload some mysql.

I got stuck like half an hour because I forgot commit()... But then I got it to work so now the database is updated every 10 min with sensordata. So now I can fully focus on the server-part. (I'm going to have problems in the future with SSH and if I have time I'll look into autossh to fix this)

Then I started to look at sending email from the server again. No significant progress but I narrowed it down to that TLS seems not to be started by my PHP-script. So Tomorrow I'll be checkin' if that's the solution to the error:

authentication failure [SMTP: STARTTLS failed (code: 220, response: 2.0.0 Ready to start TLS)]

I am also VERY happy of my troubleshooting documenting system I talked about in a previous post. This helps SO much to have all the relevant history. I also think it helps me focus about the right concepts and remember to forget about things that is not important. Get it?

Inga kommentarer:

Skicka en kommentar