published by Jim on Mon, 06/04/2009 - 20:32
Passwordless ssh, originally from
translucentcode:
- local$ ssh-keygen
- local$ scp ~/.ssh/id_rsa.pub remote
- local$ ssh username@remote
- remote$ cat ~/id_rsa.pub >> ~/.ssh/authorized_keys
- remote$ chmod 644 ~/.ssh/authorized_keys
published by Jim on Mon, 06/04/2009 - 20:30
- Apt-get for mac is known as MacPorts, very nice for getting linux'y stuff.
- You can drag network shares to the desktop to create a shortcut for later on.
- Mounting NTFS drives as read/write. Warning this can corrupt your drive. There are instructions Here at insaelymac.com. You may also want iMountit which is a nice app that can remount a ntfs drive as read/write by dragging the drive onto the app.
- Some command line applications that are on the Mac can be different to their linux counter-parts. In my case "ld" didn't work the same. Virtual Box is a free virtual machine application. I use this with an Ubuntu install for my linux needs. Also there is a page at My Debian about setting up Virtual box so you can ssh into that machine.
- There is a very nice OS X screenshot application that puts each application window on a different layer so you can move them around or delete them before saving the image. Very nice. http://www.flyingmeat.com/acorn/
- To connect to a mac fileshare from Windows Vista connect to //macipaddress. When asked for username and password the username must be in the form of macipaddress/macshortusername
- Gmail imap with Mac Mail.app doesn't work so well. Whats missing from the gmail docs is you need to add "[Gmail]" (without quotes) as the imap prefix in the advanced tab for the account. Also add "Advanced IMAP Controls" from the Labs and in the Labels tab you can uncheck the All Mail folder.
- Use SSHFS to mount directories on servers. See MacFuse and MacFusion.
- ssh -L <localport>:relative_server:22 remote_server
- Set up MacFusion to localhost on <localport> with the username/password of relative_server
- Profit... This is really good when doing dev work on a server on a different network :D
published by Jim on Mon, 06/04/2009 - 20:30
SELECT contactID, RTRIM( xmlagg (xmlelement (c, subjectName || ‘,’) order by subjectName).extract (’//text()’), ‘,’ ) AS concatenated
FROM tableExperts
GROUP BY contactID;
This will convert:
contactID | subjectName
5| 279
5| 701
5| 909
To:
5| 279,701,090
published by Jim on Mon, 06/04/2009 - 20:30
- To connect to a mac fileshare from Windows Vista see this hint
- To hide files that start with a '.' (ie, Mac and linux hidden files) use attrib +s +h filename. +s for system and +h for hidden.
- When using a wireless connection on Vista there is lag every 60 seconds while Vista rescans for close networks. During this scan there is no traffic which is bad for games. To fix this go to: http://www.martin-majowski.de/wlanoptimizer/
- Since Vista SP1 you cannot mount a FAT32 partition bigger than 32GB. This is a crappy policy enforced by Vista. You also cannot format a partition bigger than 32GB on Vista SP1 without using their crappy FAT partition scheme that isn't detected on the PS3 :(
