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