November 25, 2005

Sweet Potatoe Casserole Notes

Notes for the most recent attempt.

Cut into relatively small chunks - worked very well.

Used rectangle pan 9x12

Don't use pineapple juice any more - pinapple chunks - yes - pineapple juice no.

Uses 3/8 pound of butter - too much - reduce.

Used 1/2 cup of OJ - reduce to 1/4 cup next time.

Put full layer of marshmellows - that worked - but by the time we got to the place they all had vaporized. Next time, use mini marshmellows and put on at the last minute - perhaps use a microwave at the destination to soften marshmellows.

Next time, put some cornstarch into the OJ. This stayed too soupy.

Remember that the potatoes give off liquid.

Posted by csev at 10:59 AM

November 23, 2005

Google Video Success

After failing miserably trying to use Google Video with MPEG4 from the Mac, I have reached success. I think that the flaw was the AAC encoder. Google wants MP3 audio.

I have had great success now with Pinnacle Studio v9. I bought the MPEG 2 upgrade for $5.00.

The following works swell:

MPEG2 - DVD Preset - 60 Meg for 1:21 - did not look great on Google

MPEG2 - 1400kbps Video - 192kbps audio 640x480 - CBR - looked good - 14 Meg for 1:21 - this will be my sweet spot for short materials - 5 minutes or less

MPEG1 - 750kbps video - 128kbps audo - looked yucky

Will need to explore what to do with an hour of video.

All of these used MP2 Audio which Google seemed happy with.

Posted by csev at 09:50 PM

November 21, 2005

Wrestling With Google Video

So far I have had trouble with Google Video meeting their technical requirements. This does NOT work:

Any form of Quicktime MP4 export does not work - I think that this is because Google demands MP3 audio and Apple only supports AAC audio.

So my next try is to use Pinnacle on the PC - I have tried both MPEG-1 Video and MPEG-2 Video. The audio is MP2 rather than MP3 - we shall see if it cracks the Google video viability filter.

I had to upgrade my Pinnacle 9.1 to get the MPEG-2 encoder.

If MPEG-2 works - that could be really cool.

Posted by csev at 07:23 AM

November 06, 2005

Chuck's MySql Notes

This is just my own internal notes so I don't have to keep them on my desktop...

sudo sh
safe_mysqld &
mysql

drop database sakai;

create database sakai default character set utf8;

grant all on sakai.* to sakaiuser@'localhost' identified by 'sakaipassword';

grant all on sakai.* to sakaiuser@'127.0.0.1' identified by 'sakaipassword';

http://cvs.sakaiproject.org/release/2.0.1/SourceInstallGuide.html#Database

Edit ./kernel/component/src/config/org/sakaiproject/config/sakai.properties

***** NEVER EVER CHECK THIS BACK IN *****

Fix these lines a the top:

jdbc.defaultTransactionIsolation=java.sql.Connection.TRANSACTION_READ_COMMITTED

hibernate.dialect=net.sf.hibernate.dialect.MySQLDialect

Add these at the end

vendor@org.sakaiproject.service.framework.sql.SqlService=mysql
driverClassName@javax.sql.BaseDataSource=com.mysql.jdbc.Driver
url@javax.sql.BaseDataSource=jdbc:mysql://127.0.0.1:3306/sakai?useUnicode=true&characterEncoding=UTF-8
username@javax.sql.BaseDataSource=sakaiuser
password@javax.sql.BaseDataSource=sakaipassword
validationQuery@javax.sql.BaseDataSource=select 1 from DUAL

Compile and deploy sakai into Tomcat.

Add the MySql connector

cp ~/dev/keepzips/mysql-connector-java-3.1.11/mysql-connector-java-3.1.11-bin.jar ~/dev/jakarta-tomcat-5.5.9/common/lib/

NOTE: When switching back and forth from mysql to hsql, make sure to deal with the jakarta-tomcat-5.5.9/sakai/sakai.properties file

Posted by csev at 12:29 PM