Michael Jay Lissner

Setting up etherpad with postgres on Windows

2012-12-27T11:20:36-08:00

There don’t seem to be any successful installation instructions for postgres on Windows. It’s not that hard, but there are a couple things you need to do.

I haven’t gone through these instructions to make sure they work, but this is roughly what I’ve done to get my Postgres/Windows/Node/Etherpad working together:

Install git
Install node.js
Install python
- add PYTHON as an env
Install postgres
- add C:\Program Files\PostgreSQL\9.2\bin to your path
Download etherpad-lite with git
Run the etherpad-lite windows installer per the instructions
start etherpad-lite
- make sure it works with the dirty DB before getting exotic
Set up postgres
- npm install pg (will throw an error about msbuild version, but ignore that, the native JS drivers are installed)
- add a user using pgadmin
- add a DB using pgadmin and the user created a second ago
- reconfigure to use postgres in the settings.json file
Run start.bat to make sure it works
Turn down the log messages to only ERROR in the settings.json file.
Use NSSM to daemonize it, per the instructions here.

Note that NSSM doesn’t yet have stdout and stderr redirection built in. Thus, to start the daemon with these working, you have to create a little script like this:

@ECHO OFF
@REM This runs etherpad with stdout and stderr getting redirected to special logs
call D:\etherpad\etherpad-lite\start.bat >> D:\etherpad\etherpad-lite\logs\stdout.log 2>> D:\etherpad\etherpad-lite\logs\stderr.log

A Fresh Install of Vista on an HP Laptop

2009-07-23T21:59:02-07:00

I just used a recovery disk to install Vista on an HP laptop. I’m shocked by what it came with. Just looking at the desktop shows the following software that was installed without me even being able to stop it:

A shortcut to AOL Sign Up
Easy Internet Services
A shortcut to eBay
A “Get Vontage” shortcut
A High-Speed Services shortcut
HP Help and Support
HP Total Care Advisor
MS Office 60 Day Trial
A shortcut to MSN
My HP Games
Norton Antivirus
Photosmart Essential 2.0
Quickplay
Rhapsody
Vongo Free Trial
A giant Easy Sign-up dialog box
A Yahoo! search bar

Good god. And I paid for this? Unbelievable.

Remap Caps Lock as Backspace in Windows and Linux

2008-04-29T21:33:41-07:00

A while back my wrist started hurting from reaching for the cursed backspace key. I was making too many mistakes. My solution was to remap the caps lock key on all the computers I use to act as an additional backspace key. How did I do it? Well, I’m glad you asked. I’ll tell you.

In Windows

EDIT: I noticed that the picture doesn’t have all the detail you need. The easier way to do this, is to download this registry key post, and to right click it, selecting merge. After that, restart the computer, and you should be all set.

To remap the caps lock to function as a backspace key in Windows, one must edit the registry keys. To do that, go to Start > Run..., and type in regedit. In the editor that opens up, navigate to the key shown in the picture below, and create a new key named Scancode Map of the type REG_BINARY. Give it the value shown in the picture, restart, and you’re set. If things get wacky, delete the key and try again.

In Ubuntu

For versions newer than 14.10

This can easily be done using the Ubuntu Tweak tool. Simply open it up, go to the section on Typing, and then reconfigure the CapsLock key.

For versions prior to Ubuntu 14.10

I have tested the following in all versions between Ubuntu 7.04 and 14.04. Start by opening a terminal, and running the xev program. Once that is running, press the caps lock key, and it will tell you the numerical value of that key. For example, my output from that command looks like this:

mlissner@opal2% xev
KeyPress event, serial 28, synthetic NO, window 0x4800001,
root 0x59, subw 0x0, time 2775892, (373,636), root:(376,685),
state 0x0, **keycode 66** (keysym 0xff08, Caps_Lock), same_screen YES,
XKeysymToKeycode returns keycode: 22
XLookupString gives 1 bytes: (08) "
XmbLookupString gives 1 bytes: (08) "
XFilterEvent returns: False

In there, you will see the keycode for the capslock key, in my case, number 66. Using that, create a file in your home directory called .Xmodmap, and put the following in it:

!
! Make the caps lock button a backspace button
!
remove Lock = Caps_Lock
keycode 66 = BackSpace

Once that is done, the next time you log in, your caps lock will function as a backspace. The only remaining problem is that it still does not have the auto-repeat function that backspace should have. To fix that, run:

xset r 66

That will make things work properly, but you need to run that every time you log in, or else it won’t work properly. To fix that run:

sudo gedit /etc/X11/Xsession.d/50x11-common_determine-startup

And add xset r 66 to the bottom.

That should do it.

Source