It DIED :(

So I connected to the weather station the other day to be greeted with SD Card not detected. Poo, is about all I think about that. I am not sure yet if it was the card that died, or if it was the card reader that died. So I figure that its time to make some hard decisions and do what I probably should have done in the beginning and that was use a MYSQL database and just send the data across the home network or across the interwebs to my webserver that hosts this blog. Which kind of sucks because I have been putting off having to learn SQL or PHP for a long time.

So off to google to do some google foo and I find that there is a nice MYSQL library that takes care of all the drudgery, which is good as it will save me a lot of work.

First step was to jump on the webserver and make a new database and a table to save the data to. Job Done!

Next up was to write some code to connect to my home network and then connect to the database. Job Done!

Fire it up and it connects to the network and the database and sends the data just fine. Now all i have to do is pull the weather station down, bring it inside and upload the now modified code as well as fix the problem i was having with the rain sensor. It kind of sucks that I have lost all or most of the Febuary data, but it is what it is and I should never have relied on an SD card to do the job long term. Less moving part, less things to go wrong, oh well, i know for next time.


One thought on “It DIED :(

  1. You should be so lucky that your OS permits you to connect to your weather station. I presume that your station uses non-proprietary software and can dump data to your PC into MySQL without conversion.
    Yes “Poo” on the SD card dumping. Have a similar situation with one in my cellular phone. Prior to 3 weeks ago my phone could read it with no difficulty. Now it doesn’t recognize and wants to format the SD (Android phone).
    I looked you up on You are the second Australian I have encountered with a 2 X 4 call sign. The other fella told me that your license bureau doesn’t renew former used licenses for 100 hundred years, I guess with the thought that most people don’t live much past 85 years, but there are so many licensed hams in Australia that the 2 X 3 call signs have run out.
    I used to have weather station in place but when I dismantled it, to move to a different home, the temperature sensor was damaged. Shortly after moving I incurred an injury which prevented the remounting of the WX station. That was around 1998. The software required a Microsoft OS. Around late 1990’s I was experimenting with Linux (formerly experimented with FreeBSD Unix). By the time I got around to replacing the damaged temperature sensor I had changed from Microsoft windoze to Linux. Too many OS crashes, costly antivirus software was required to protect my PC’s data, and I was put out by paying to use an operating system that loaded with bugs that I couldn’t fix because the source code of the OS was proprietary.
    Switching to Linux only solved my computer AV software problems. I was fully aware how many pieces of hardware were not supported to operate with Linux/Unix family of OS’s. Over the years that has improved been some very smart people that were able to engineer the software to operate hardware they didn’t manufacture. Anyway, I’ve found a couple software applications that will read the data from Davis WX station that runs on Linux. My station is not operational yet but if I can get some physical help from young people it will be installed this year. I’m not a ‘young chicken’ anymore. I’ll be 72 in December.
    So, I’ve rambled on too much. You have a nice day. Hope your station is up soon.

    Best 73,
    Terry Morris, KB8AMZ

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.