Sprinklino

really want to get my workshop…

really want to get my workshop back up and running

today we press the grapes

today we press the grapes

the beard is dead

the beard is dead

Nitrogen Monitoring

Wondering how hard it would be to add nitrogen monitoring. You can apparently determine nitrogen content by checking how green the leaves are so I’m thinking I can hook up a color sensor, shine a light on the leaves at night (to eliminate ambient light changes) and track how green it is over time. If I start to see yellowing then it’s time to fertilize (or at least monitor things more closely)

waiting for veraison…

waiting for veraison…

Big delay

So work on this kinda ground to a halt what with moving house and assorted stuff but finding myself with 50 pinot noir vines I’m going to get started again so stay tuned :)

Gypsum Sensors Completed

So I went a slightly different route to build the soil moisture sensors as I wasn’t having much luck with the drinking straw method (too fiddly).

My solution was to drill a hole between two pieces of MDF with a flat bottomed forstner bit and then to drill two smaller holes into the bottom of it where the wires would go.

The two pieces clamped together made a really nice mold for the plaster of paris and I could ensure that the wires were a consistent distance apart. I covered the surfaces with vaseline so that the two sides of the mold would seperate easily.

I’ll post pictures of the sensors later today. But it worked really well.

Successful Test of VirtualWire

So I got my TTL RS232 converter from Modern Devices which enabled me to finally fire up my BBB with the VirtualWire transmitter software running on it, with my Arduino Diecimila running the receiver, and it worked flawlessly :) I need to get another breadboard so I can start doing some range tests with it (and play with antenna design) but so far so good and so much cheaper than the XBee modules :)

Multiplexer Test

So tested out the CD4051B 8 Channel Multiplexer today and everything worked as expected. I’m using a multiplexer so that I can use more sensors than I have digital i/o pins.

It’s very simple to use, you send the chip a 3 bit address, and that is the pin that is connected to the output.

To get the Arduino to select each input in turn I did a loop and wrote value directly to the port data register PORTD


void loop() // run over and over again
{
for(int i = 0 ; i <= 16 ; i++)
{
byte b = (byte)i << 2; // Shift to the left so that I don't mess with pins 1 & 2
PORTD = b; // Write bits to the i/o pins
delay(50);
}
}

I have my LED resistor connected to the common pin so that I only need to use one, and LEDs connected to all the output pins, et voila disco lights :)

Although you can’t see it in this pic the leds are being lit one after another. You can also see the RX4 ASK receiver in this pic but it isn’t hooked up yet as I’m waiting on the TTL/RS232 converter to arrive to program my other Arduino which will control the transmitter.

wp-forum fixed!

So just got the wp-forum plugin fixed, lots of problems with the db.

For starters it doesn’t create the tables you need, so I found the sql script (that cunningly has a .txt suffic) forum_db.txt and ran that directly against my db.

That didn’t work either because I was using a different prefix for my wp tables so I had to change all the wp_forum* table names to myprefix_forum* instead.

The other problem was that the code was referencing a bunch of columns that weren’t created either. I’ve included the actual script you need to run here at which point it all works as expected.

Enjoy!


-- --------------------------------------------------------

--
-- Table structure for table `wp_forum_threads`
--

DROP TABLE IF EXISTS `wp_forum_threads`;
CREATE TABLE IF NOT EXISTS `wp_forum_threads` (
`id` int(11) NOT NULL auto_increment,
`forum_id` int(11) NOT NULL default '0',
`views` int(11) NOT NULL default '0',
`subject` varchar(255) NOT NULL default '',
`date` datetime NOT NULL default '0000-00-00 00:00:00',
`last_post` date NOT NULL default '0000-00-00',
`status` varchar(50) NOT NULL default '',
`starter` varchar(50) NOT NULL default '',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

DROP TABLE IF EXISTS `wp_forum_posts`;
CREATE TABLE IF NOT EXISTS `wp_forum_posts` (
`id` int(11) NOT NULL auto_increment,
`author_name` varchar(255) default NULL,
`author_email` varchar(255) default NULL,
`author_web` varchar(255) default NULL,
`text` longtext,
`thread_id` int(11) NOT NULL default '0',
`date` datetime NOT NULL default '0000-00-00 00:00:00',
`author_id` int(11) NOT NULL default '0',
`subject` varchar(255) NOT NULL default '',
`views` int(11) NOT NULL default '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

DROP TABLE IF EXISTS `wp_forum_forums`;
CREATE TABLE IF NOT EXISTS `wp_forum_forums` (
`id` int(11) NOT NULL auto_increment,
`name` varchar(255) NOT NULL default '',
`parent_id` int(11) NOT NULL default '0',
`description` varchar(255) NOT NULL default '',
`views` int(11) NOT NULL default '0',
`sort` int(11) NOT NULL default '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

DROP TABLE IF EXISTS `wp_forum_groups`;
CREATE TABLE IF NOT EXISTS `wp_forum_groups` (
`id` int(11) NOT NULL auto_increment,
`name` varchar(255) NOT NULL default '',
`sort` int(11) default NULL,
`passwd` varchar(20) default NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;