Andrew Que Sites list Photos
Projects Contact
Main

June 18, 2014

Happy Birthday Tyson

Tyson

Tyson

So I have been thinking about a project for ππ and I think I am going to try turning it into a solar powered web server. The specifications say the Raspberry Pi runs at 5VDC at 700 mA, or 3.5 watts. Naturally the solar panel needs to produce at least this much power, but the overall setup is more complected. There is only sunlight during the day, and in Wisconsin that can be between 9 and 15 hours. So worst case sunlight energy needs to be stored for the 15 hours of darkness where there is no solar energy. For this a simple lead acid battery can be used and the kind found in any UPS will work fine. The basic setup is to have the solar panel charge the battery, and the Pi run off this battery. At night the Pi will run off the battery. During the day the solar panel needs to supply enough energy to power the Pi and recharge the battery from the previous nights usage.

This is all fairly straight forward, but solar panels specify their output for full sun light conditions. Cloudy days, shade, temperature, and not directly facing the sun will all reduce the output of a solar panel. There are too many factors to do a direct calculation with the data I have. So I've decided to try an experiment. I have ordered a digital luminosity sensor I can connect to ππ. This will allow me to log the amount of sunlight in a given location over many days. With this information I should have the data I need for selecting a solar panel.  Details to follow.

Router, ππ and switch

Router, ππ and switch

   When I setup ππ I needed more Ethernet feeds than the router had so I dug out my 16 port switch.  Until the other day I had no need for the switch and it had been setting idle.  After I plugged it in the cords were a mess so I today I decided to put together a little shelve.  It sits nicely above my main computer, and under my display shelve.  By elevating a platform in the shelve I setup my switch, router, a weather transmitter, and ππ.  The elevated shelve allows Ethernet cables to fold under the devices and go to their various runs.  This gave me time to straighten up the network cables.  Our cable modem has to sit in the worst location.  The installer gave us just enough cable so the modem can connect to the coaxial cable and the telephone wire, but not an inch more.  This means the modem has to sit in the ceiling joists.  Until today I also put the router in this location.  Now just the modem sits in this ridiculous location.
Autum and Tiffany

Autum and Tiffany

Decided to play with some numbers.  Here is a graph of the number of photos I've taken over 10 years, grouped by month.

Chart

The average is around 1000 pictures/month, but clearly there are some months where I shot a lot more and months were I shot far less.  The big spikes are around times when I had photography projects.  The four months of no pictures in 2010 was when my camera died.  Clearly my slowest year was 2011—not a good year for photography. 

1 comment has been made.

From TRB

June 18, 2014 at 12:33 AM

:)

June 15, 2014

Gaius Octavian Dermious the The Solarian

Ready to game.

Ready to game.

   Our battle with the Stone Lady continued and the creature was extremely powerful.  She knocked Andle unconscious twice and seemed to be able to regenerate hit points after a person was bloodied.  Ellonoria (my character) did no damage to her what so ever as the Stone Lady's AC was too high for me to hit.  Instead Ellonoria focused on two songs: a song of battle which gave AC bonuses, and a song of healing which gave temporary hit points.  Ellonoria also used several healing potions and her healing staff to cure both Marv and Andle.  As usual, Marv did huge amounts of dammage with his Dwarven Warhammer and took a brunt of the attacks.  His enlarged size and rage made it so he hit every round when not stunned.  One of the Stone Lady's special attacks was some kind of mind attack that always hit because it was against will power.  Aside from being a strong attack it also stunned.  Analiss proved a worthy opponent for the Stone Lady as well.  With her bonuses for flanking attacks, which she always went for, Analiss did a far amount of damage herself.  She also took a fair amount of damage, but was always in range of the song of healing.  However, it was the crazy wizard Jokeing who finished off the Stone Lady.  He delivered healing potions using spells and cast several magic missiles against the Stone Lady, the last of which destroyed her.
   With our powerful foe reduced to a heap of rubble, Ellonoria went about repairing the damage.  Andle and Marv were nursed back to health.  Our wizard lost no time in searching through the pile of dead bodies the Stone Lady was standing around and we found quite the bounty from those who were not as good as we were.  Observing from the edges were our Kobold friends who were too scared of the Stone Lady to fight.  We offered them the bodies of their fallen friends.  Despite them not being bound to us, they decided to continue to follow us.
   The Stone Lady was guarding a door into an other room.  Analiss quickly figured out the lock and had the door open.  It was a corridor full of doors, and after inspection each of the doors was a holding cell.  All but one holding cell was empty, and in it was a large glass stasis container with a very tall Solarian.  We opened the container and Ellonoria nursed the Solarian back to consciousness.  When he awoke he started yelling in the ancient Solarian language which only Andle could mildly understand.  He believed we were executioners coming to take him to his death and spouted a series of colorful insults, only parts of which Andle could pick up.  After figuring out we were not his executioners (we were clearly not Solarian) he began in some other languages.  When he started speaking Orcish several of us could understand him.
   Our Solarian was Gaius Octavian Dermious who had once worked in these labs.  He had been imprisoned for defying his emperor Josephus Menggilous.  Their empire had been fighting what he called Void Creatures, exceedingly powerful creatures of unknown origin.  The lab was established to study ones they can captured.  Among these creatures was the elvish creature who we found in stasis.  She was so powerful she took out two legions of 13,000 and it took an army of wizards to defeat her.  Although dead her body was kept at the lab as it was known such powerful creatures have a tendency not to stay dead.  Gaius seemed worried we had released one or more of these creatures, but we had not.  However, were was one empty holding tank.  We had observed this before.  After some reading, Gaius believes the empty cell is an other elvish creature.  He desires to find this creature and we decided to travel to the city.
   Gaius went to a secret safe and retried some items.  Among them was a wand that allowed him to speak in the common tong.  On our travels Ellonoria talked to him constantly.  The Stone Lady was actually a guardian that was originally protecting the lab, but after Gaius' imprisonment had been moved to the door of his holding area.  His stasis was worse than the others as he was kept in a dream-like state.  Josephus had imprisoned him when he refused to do experements on people trying to mix them with Void Creatures.  After looking at the carvings of emperors he saw that Josephus was the defaced emperor, he did not recognize the next emperor, and the last emperor was actually his nephew who was 4-years-old at the time of his imprisonment.  So the empire fell not long after.
   The group reached the Citadel, a floating religious structure.  It had been a military outpost in Solarian times, but had since become a kind of Vatican City.  In it's shadow was a market of snake oil vendors and religious evangelists.  After asking around we found one trustworthy vendor who was able to recharge my staff of healing at a good price.  Ellonoria has strong opinions about religion and wanted to leave quickly.  Our Kobold friends rejoined us with adorned in tons of trinkets and other overpriced junk, and they seemed very pleased with themselves.  It is our guess they also have no gold now.  So after the staff was recharged the group set out for the city.

1 comment has been made.

From Xen

Our house, in the middle of the street.

June 16, 2014 at 11:08 AM

Annaliss, my character, did not do as well as she would. She did not crit once, which is unusual, and she did not have a blunt weapon, so slash or stab affects didn't really do much damage.

Desirae and Allison

Desirae and Allison

   I've noticed watching my logging screen more traffic to the online polynomial regression calculator.  Wondering where this traffic has come from I brought up my log analyzer only to find that I have no search terms at all for the entire sub-domain.  Thinking there was something wrong with the analyzer, I checked the raw log file.  Almost all my search redirects come from Google, but for whatever reason the search query is not listed.  So I have no idea what people are searching that leads them to the regression calculator. Despite noticing the traffic, the overall polynomial regression sub-domain has not significantly increased in traffic.
   I moved the location of the Ratrap scripts, but messed up and changed their ownership.  This caused the Ratrap to basically stop functioning because it could not change the database.  It is fixed now, but what a dumb mistake.
ππ

ππ

   As a gift to those who participated in his wedding, Pluvius gave his groomsmen a Raspberry Pi.  I don't have a project in mind right now for this device, but decided to get it setup.  Doesn't take long to install an OS, and I soon had the device running with an SSH connection.  I've named the device ππ.  I decided to install a LAMP server just to see how it worked and soon the device was able to host web pages.  Mostly because I can, I've made the server public at pipi.drque.net.  There isn't anything on the server, but that may change.
 

1 comment has been made.

From N

June 12, 2014 at 11:16 AM

Looks cool - I'll be very interested to see any future projects you use the Pi for!

June 10, 2014

Ratrap ver 2.1 released

An Other Rat Catcher

An Other Rat Catcher

   After a lot of cleanup and retooling, I have released a new version of the Ratrap.  Version 2.1 includes all the changes I've made to work with PHP Data Objects (PDO) with SQLite.  In theory it should also work with MySQL or any other PDO database implementation.  This is almost a rewrite of the scripts, hence the version 2. 
   On DrQue.net, the Ratrap has banned over 760 IP addresses, and at the time of this writing has 122 addresses banned.  I have been keeping an eye on the list of 404 requests coming into the server.  Although many are broken links or legitimate non-existing files, many are also looking for scripts to exploit.  Requests for such exploits are routed to an instant ban using the Ratrap.  And the new Ratrap database layout allows me to see how many times an individual IP address has been banned so repeat offenders can be identified.