Use the following to convert an ip address to a domain name:
nslookup ipaddress
Rotating Text in SharePoint with JavaScript
Find duplicates in text file
Use the Unix command, to print duplicate lines
uniq -d filename.txt
sort your input file and you can use the following command to count the duplicates
uniq -c sortedfile.txt
List does not exist error message
I ran into an issue today where users could not access as SharePoint 2007 Publishing Site Page. The error message was:List does not exist.
The page you selected contains a list that does not exist. It may have been deleted by another user. Troubleshoot issues with Windows SharePoint Services. I had no problem viewing my site and couldn't figure out what was wrong. I then looked at the URL for the page which was:
http://[sharepoint-site-URL]/_layouts/AccessDenied.aspx?Source=[SharePoint-site-URL]&Type=list&name=%7B2007BFAB%2D9CC4%2D41DA%2D8ED0%2D7E4C5BDAE90C%7D
The key here was the AccessDenied pages and the name query string value:
7B2007BFAB%2D9CC4%2D41DA%2D8ED0%2D7E4C5BDAE90C%7D
After decoding the html encoded characters out I got a GUID of:
{2007BFAB-9CC4-41DA-8ED0-7E4C5BDAE90C}
If you look at the name, it is actually the id of "list item" that the user has been denied access from viewing. I then went to central administration to get the name of the content database of the site I was working on, and then went to SQL Server Management Studio and expanded my content database to dbo.AllLists. I ran a query against my content database for the list that users have been denied access to.
select * from dbo.alllists
where tp_id='{2007BFAB-9CC4-41DA-8ED0-7E4C5BDAE90C}'
I received one result with a tp_Title of "Master Page Gallery." That was all I needed. I then went to my page and looked at the template it was using. It was using a custom page layout I created. I proceeded to look at my Master Page Gallery and saw that the page layout it was using was never checked in and was in a ‘pending’ status.
Not the best error message, but the lesson here is that users cannot access pages using page layouts that have never been checked it. Makes sense, but a more meaninful error message would have been nice.
Using sed for text search across multiple lines
Simple command is:
sed -n '/begin/,/end/p' input.txt
Note: the search string "begin" and the search string "end" must be on separate lines.
Firefox keeps asking for proxy credentials
Attempted to change with about:config
Set network.negotiate-auth.allow-proxies to false
Did not quite work, filtered on "proxies" and set everything back to default values.
Also, set all of the "No Proxy" settings for the browser.
Currently this appears to be a networking issue with Firefox. Currently none of my attempts to fix the problem have worked.
Use wget with -c parameter to download larger files
Using the -c parameter allows you to resume:
wget -c http://www.sharepointpodshow.com/shows/sharepointpodshow_episode_10.mp3
Setup an SSH SOCKS proxy!
Refer: http://www.mattlestock.com/
Software goodie: plink.exe
For episode 416 of HAK5, I showed how easy it really is to tunnel all kinds of traffic from HTTP, FTP, and more over a secure SSH Socks proxy.
What you’ll need is:
- An SSH server to act as your proxy.
Simple enough really! If you’re using windows I highly recommend freeSSHd. If you’re on a mac check out this page for instructions on how to enable remote logon. Linux users, you should know how to do this. - An SSH client on the computer you’re using.
Mac and *nix machines have SSH built right in at the command line. Windows users can do like I did in the episode and download plink (available here). There are other people out there that will recommend Cygwin, but for this purpose, it’s really overkill.
How proxies work
In a nutshell, what you’re doing with a proxy is setting up a middle-person (no not a pineapple, but close) between you and the internet. Using the proxy, your browser hands off web page requests to the proxy server, which handles the request and fetches the page for you from the internet. The web site actually thinks the request is coming from the proxy server, not your computer, which is a good way to obscure your originating IP address.
Additionally, the connection between your computer and the proxy happens over SSH, an encrypted protocol. This prevents wifi sniffers from seeing what you’re doing online.
Start your SSH tunnel
So you’ve got your ssh server setup at your house or workplace. Great! To connect to it we’re going to setup a local proxy server on your client that you’ll be browsing the internet from, which will then “tunnel” web traffic from your local machine to the remote server over SSH. The command to run on your linux / mac client in a terminal window is : ssh -ND 9999 you@example.com
For Windows it’s as simple as browsing to the directory you saved plink to and running
plink.exe -N -D 9999 you@example.com
Of course, you’re going to replace the you with your username on your SSH server and example.com with your server domain name or IP address. What that command does is accept requests from your local machine on port 9999 and hands that request off to your server at example.com for processing.
When you execute either of those commands, you’ll be prompted for your password. After you authenticate, nothing will happen. The -N tells ssh not to open an interactive prompt, so it will just hang there, waiting. That’s exactly what you want.
Set Firefox to use SOCKS proxy
Once your proxy’s up and running, configure Firefox to use it. From Firefox’s Tools menu, choose Options, and from the Advanced section choose the Network tab. Next to “Configure how Firefox connects to the Internet” hit the “Settings” button and enter the SOCKS information, which is the server name (localhost) and the port you used (in the example above, 9999.)
Save those settings and hit up a web page. When it loads, visit http://www.ipchicken.com to see if it’s using your remote ssh server to tunnel traffic. If you are, GOLDEN!
If you feel there’s something I’ve missed, hit me up here (http://www.mattlestock.com)
PS: Remember that you’ll need to open your firewall a bit by cracking open port 9999 on your local machine and port 22 on your server for SSH.
grep multiple strings with egrep
Example syntax is as follows:
egrep -i "string1|string2" /logs/webhalwCluster/* > research.txt
Writing a thank you card
1. Greet the Giver
Dear Aunt Sally,
That’s the easy part, but you’d be surprised how many people forget it. Dale Carnegie taught us people love to hear their own names and Direct Marketing is sure we also love to read them in ink. That’s right, ink. Blue-black is always the number-one choice, but black will suffice in a pinch. Don’t let a whimsical marker color be the most stunning part of your note: instead let the words sing without the amplification of rainbow hues. Even if your handwriting is poor, you must still hand-write your notes. Do not type them or, worse, use a word processor. No excuses.
2. Express Your Gratitude
Thank you so much for the slippers.
This first paragraph seems like it would be the easiest, but it is actually the most complicated. Beware the just writing trap. You are not ‘just writing to say’ as in I am just writing to say; that’s stating the obvious. If the giver is reading, clearly you have already written. Therefore use the present-perfect tense, which essentially means write as if whatever you say is happening in the moment.
Also—and this is important—never directly mention money. ‘Thank you for the hundred bucks’ could instead be ‘Thank you for your generosity.’ All cash denominations become ‘your generosity’ or ‘your kindness.’ If you feel the giver overspent, the farthest you can go is appreciated: ‘Your generosity is appreciated,’ or ‘It is such an extravagant gift—your kindness is appreciated.’
If you’re writing to thank someone for an intangible (such as them putting you up at their place while you were in town for the weekend), first define what the intangible thing is, and then make the gift sound as attractive as possible. In other words, don’t say: ‘Thanks for letting us crash at your place.’ Instead say: ‘Thank you for your hospitality.’ Don’t worry if it sounds too simple; the point of writing the note is to create a simple expression of a heartfelt sentiment.
3. Discuss Use
It gets very chilly here in the winter, so they will get a lot of use when winter comes.
Say something nice about the item and how you will use it. Let’s say it’s something you actually love and use incessantly—then say so: ‘Ever since I got the slippers I have only taken them off to shower and go to work. I’d wear them to the office if I thought I could get away with it.’
But don’t lie, even though some etiquette books may tell you it’s okay. After all, there’s always a truth that can be extracted. Let’s say you hate the slippers. How to say thanks? Find the one thing about them that’s nice and discuss it—but don’t get carried away. ‘They are such a lovely shade of blue’ works, and is more honest than ‘These slippers make my heart sing like a choir of angels,’ which is overkill. If it was a gesture, like letting you stay at their place, you can follow the lines of ‘It’s so nice to make a personal connection while traveling. I really appreciated my time with your family.’
If the gift was cash, allude to how you will use the money, but do not itemize your planned purchases line by line, instead simply say: ‘It will be a great help when we purchase our new home/toaster/lava lamp/whatever.’
You can get arty here, but not flowery. It’s a fine line. Small, realistic statements like ‘I put the flowers on the kitchen table and they are still looking fresh and beautiful after a week,’ or ‘I don’t know which is more fun, actually using the Cuisinart, or reading recipes and thinking I could do that in the Cuisinart!’ Having fun is alright, so have at it.
4. Mention the Past, Allude to the Future
It was great to see you at my birthday party, and I hope to see you at Dad’s retirement in February.
Why did they give you the gift? What does it mean to your relationship with the giver? Let the giver know how they fit into the fabric of your life. If it’s someone you see infrequently, say whatever you know: ‘Mom tells me you’re doing great at Stanford, and I hope we cross paths soon.’ If it’s someone you’re in regular contact with: ‘I’ll call you soon, but I wanted to take time to say thanks.’ If it’s some errant family member you have little or no contact with, simply go with ‘You are in my thoughts and I hope you are well.’ Nice, right?
5. Grace
Thanks again for your gift.
It’s not overkill to say thanks again. So say it.
6. Regards
Love,
Leslie
Simply wrap it up. Use whatever works for you: Love, Yours Truly, With Love. Then sign your name and you’re done.
What’s Not There
Any news about your life. This isn’t the time to brag about your new job, a hot girlfriend, or number of surgeries. The thank-you is exclusively about thanking somebody for their kindness. While you may want more than anything to show them once and for all you amounted to something, this is not the forum. Save that for your annual Christmas letter.