Tuesday, March 26, 2013

Excel Spreadsheet prints to two pages

q: Today we were shown an Excel Spreadsheet whose right border was printing on the left side of page two.   What's the easiest way to resolve this?
a: Click File-Print - and in the print preview window, select "Fit Sheet on One Page".


Wednesday, March 6, 2013

Reset admin password on Nessus Appliance

q: The customer installed the Nessus Appliance and then forgot the admin password to the appliance.  They could still log into the application hosted on the appliance though.

a: Well we hate to post this because we're afraid they'll remove it, but here goes.
  1. Download the CentOS-6.3-x86_64-bin-DVD1.iso 
  2. Mount the ISO to the virtual appliance & configure it to boot from the ISO
  3. Accept all the default questions/answers (You can select no on the network ques.)
  4. When you're finally able to run shell do that.
  5. Navigate to: /opt/appconfig
  6. NOTE: We wish we was making this up
  7. Look for a file called setpass and remove it by running 'rm setpass'
  8. Run Exit, then Exit again, then reboot the box & let it boot to the hard drive
  9. When we tried to log into the nessus appliance on port 8000 it asked us to set the password. It took us here https://servername:8000/password.html, we set the password and we were done.