Monday, March 26, 2012

Building HandBrake on Gentoo, fix for aclocal-1.4 missing error

DVD/ISO to MKV using ffmpeg?:

# export WANT_AUTOMAKE=1.11
# ./configure --force --prefix=/usr --disable-gtk-update-checks



Then run gmake.

Still failing to fully compile (HandbrakeCLI still built though).

Damned python2 scripts that won't run in python3.  I'm really hating this incompatibility between versions.

HyperJuice External 100Wh Battery for Apple MacBook iPad, iPhone, iPod, USB

HyperJuice External 100Wh Battery for Apple MacBook iPad, iPhone, iPod, USB

Saturday, March 24, 2012

Virtual Memory Leak in Growl Menu? It's in 'stopped' mode and Virtual Memory is 399M ?!?

Virtual Memory Leak in Growl Menu? - Growl Discuss | Google Groups: Please run these two commands in a terminal window and send us the output:

 leaks GrowlMenu | pbcopy
 heap GrowlMenu | pbcopy

Now to post to the Growl group...

Friday, March 23, 2012

Optimize only fragmented tables in MySQL | Me in IT

Optimize only fragmented tables in MySQL | Me in IT:

#!/bin/sh

echo -n "MySQL username: " ; read username
echo -n "MySQL password: " ; stty -echo ; read password ; stty echo ; echo

mysql -u $username -p"$password" -NBe "SHOW DATABASES;" | grep -v 'lost found' | while read database ; do
mysql -u $username -p"$password" -NBe "SHOW TABLE STATUS;" $database | while read name engine version rowformat rows avgrowlength datalength maxdatalength indexlength datafree autoincrement createtime updatetime checktime collation checksum createoptions comment ; do
� if [ "$datafree" -gt 0 ] ; then
�� fragmentation=$(($datafree * 100 / $datalength))
�� echo "$database.$name is $fragmentation% fragmented."
�� mysql -u "$username" -p"$password" -NBe "OPTIMIZE TABLE $name;" "$database"
� fi
done
done

A must for default MythTV installs: Flush and Reset MySQL Binary Logs

Flush and Reset MySQL Binary Logs | LegRoom.net

Friday, March 16, 2012

Bug 396537 – app-misc/lirc: compiler driver is invoked with raw linker flags (LDFLAGS)

Bug 396537 – app-misc/lirc: compiler driver is invoked with raw linker flags (LDFLAGS): Commenting out LDFLAGS in /usr/portage/profiles/arch/amd64/make.defaults fixes the problem:

# 64bit specific settings.
CFLAGS_amd64="-m64"
#LDFLAGS_amd64="-m elf_x86_64"
CHOST_amd64="x86_64-pc-linux-gnu"

---
What a mess...

Add missing NULL in zpl_xattr_handlers � 3373550 � behlendorf/zfs � GitHub

Add missing NULL in zpl_xattr_handlers � 3373550 � behlendorf/zfs � GitHub

ZFS scare : state:UNAVAIL , scsi device files changed


# zpool status
  pool: vault
 state: UNAVAIL
status: One or more devices could not be used because the label is missing
or invalid.  There are insufficient replicas for the pool to continue
functioning.
action: Destroy and re-create the pool from
a backup source.
   see: http://zfsonlinux.org/msg/ZFS-8000-5E
 scan: none requested
config:

NAME        STATE     READ WRITE CKSUM
vault       UNAVAIL      0     0     0  insufficient replicas
 raidz2-0  UNAVAIL      0     0     0  insufficient replicas
   sdc     UNAVAIL      0     0     0
   sdd     UNAVAIL      0     0     0
   sde     FAULTED      0     0     0  corrupted data
   sdf     FAULTED      0     0     0  corrupted data
   sdg     FAULTED      0     0     0  corrupted data
   sdh     FAULTED      0     0     0  corrupted data

Why did this happen?  I have been changing around my disk layouts in the main server, and in doing so the drive order shifted down by two.  After much panicing I took a leap of faith and did an export and import.


# zpool export vault
# zpool import vault
# zpool status
  pool: vault
 state: ONLINE
 scan: scrub repaired 0 in 15h3m with 0 errors on Thu Mar  1 22:09:47 2012
config:

NAME        STATE     READ WRITE CKSUM
vault       ONLINE       0     0     0
 raidz2-0  ONLINE       0     0     0
   sde     ONLINE       0     0     0
   sdf     ONLINE       0     0     0
   sdg     ONLINE       0     0     0
   sdh     ONLINE       0     0     0
   sdi     ONLINE       0     0     0
   sdj     ONLINE       0     0     0

Thank goodness.

Now I need to figure out how to convert to import disk/by-id instead of the scsi device file so this non-sense doesn't happen again.


# zpool import -d /dev/disk/by-id/ vault
# zpool status
  pool: vault
 state: ONLINE
 scan: scrub repaired 0 in 15h3m with 0 errors on Thu Mar  1 22:09:47 2012
config:

NAME                                            STATE     READ WRITE CKSUM
vault                                           ONLINE       0     0     0
 raidz2-0                                      ONLINE       0     0     0
   ata-Hitachi_HDS5C3030ALA630_MJ13....  ONLINE       0     0     0
   ata-WDC_WD30EZRX-00MMMB0_WD-W....    ONLINE       0     0     0
   ata-Hitachi_HDS5C3030ALA630_MJ13...  ONLINE       0     0     0
   ata-WDC_WD30EZRX-00MMMB0_WD-W....    ONLINE       0     0     0
   ata-Hitachi_HDS5C3030ALA630_MJ13....  ONLINE       0     0     0
   ata-WDC_WD30EZRX-00MMMB0_WD-W....    ONLINE       0     0     0


Bingo.
Problem solved.

Special thanks to the following thread for tips:  http://forums.gentoo.org/viewtopic-t-838534-start-0.html

Persistent block device naming - ArchWiki

Persistent block device naming - ArchWiki: blkid -o list -c /dev/null

Wednesday, March 14, 2012

java - How can I make MS SQL Server available for connections? - Stack Overflow

After fighting with SQL for ten minutes, I finally found the right setting to allow SQL connection over port 1433.

java - How can I make MS SQL Server available for connections? - Stack Overflow: Open the Sql Server Configuration Manager (Start -> Programs -> Microsoft SQL Server 2008 -> Configuration Tools)

Expand SQL Server Network Configuration -> [Your Server Instance]

Double click TCP/IP

Under Protocol:

Ensure Enabled is Yes

Under IP Addresses:

Scroll to the bottom and set the TCP Port under IP All,  (Blank by default, set to 1433)

Find the IP address you want to connect to and set Enabled and Active to Yes

Tuesday, March 13, 2012

[ubuntu] Upgrade to 11.10 broke r8169-based wired ethernet when I reboot to Gentoo

[ubuntu] Upgrade to 10.04 broke r8169-based wired ethernet (working only at 10Mbps) - Ubuntu Forums

What the heck? I was running Ubuntu 11.10 for the past two weeks and I go to reboot into Gentoo and my wired network no longer works!?!  Found this post and another talking about shutting the system back down, turn off, unplugged, clear remaining power, and wait couple of minutes and plug back in.  Well tada it worked, now what in the world did Ubuntu do to my onboard r8169 cards??

Tuesday, March 6, 2012

70-200mm AF-S VR II Lens Review by Thom Hogan

70-200mm AF-S VR II Lens Review by Thom Hogan: Which brings us to VR and tripods. Once again Nikon's manuals seem to be causing some confusion. The manual is explicit: "When the lens is mounted on a tripod, set the vibration reduction ON/OFF switch to OFF." Of course, the next sentence starts the confusion: "However, set the switch to ON when using a tripod without securing the tripod head, or when using a monopod." This one is tricky. If you're a tripod on something that has vibration in it (like the deck of a cruise ship), you'll need to be in Active VR, but otherwise you want to be in Normal VR.

Some other sections of the manual will have scratching your head. For example, the description of Normal versus Active VR says "In this mode [Active], the lens does not automatically distinguish panning from camera shake." Okay, so if you're panning on a tripod, you should be in Active mode, right? Probably not. You don't want the VR to fight your panning, only to correct the motion in the axis you're not moving.

Thursday, March 1, 2012

Inside the Lytro - Graphic - NYTimes.com

Intro to the new "Light Field Camera"
Inside the Lytro - Graphic - NYTimes.com

ZFS, Where have you been all my life?

Well, I've made the jump.  Created a raidz2 (dual parity) pool using the 6 disks I've been testing lately.  Transferred 4TB to the system, and now running my first scrub!


 sudo zpool status
  pool: bigpool
 state: ONLINE
 scan: scrub in progress since Thu Mar  1 07:06:02 2012
    64.6G scanned out of 4.22T at 73.3M/s, 16h30m to go
    0 repaired, 1.50% done
config:

NAME        STATE     READ WRITE CKSUM
vault       ONLINE       0     0     0
 raidz2-0  ONLINE       0     0     0
   sdf     ONLINE       0     0     0
   sdg     ONLINE       0     0     0
   sdh     ONLINE       0     0     0
   sdi     ONLINE       0     0     0
   sdj     ONLINE       0     0     0
   sdk     ONLINE       0     0     0

Now I have to admit, 73 MB/s is what I'll call slow considering the speeds I had been seeing in my tests, and the fact I'm running across two eSATA controllers ( 3 drives each ), however, the speeds are going up everytime I check the status:


   scan: scrub in progress since Thu Mar  1 07:06:02 2012
      85.5G scanned out of 4.22T at 75.3M/s, 15h59m to go

This tracks a hell of a lot slower than my RAID controller's RAID-6 array surface scan.

I'll do some i/o tests later.  Did a dd read of a 500MB file for a quick test:

    532132088 bytes (532 MB) copied, 5.10293 s, 104 MB/s

Not bad, not shocking though.