Geek Projects – Linux, Apache, MySQL, PHP, DNS A Linux Sysadmin

April 9, 2010

Reset the GroundWork Monitor 6.0 Password

Filed under: Linux,Systems Administration — Matt @ 8:38 pm

The GroundWork Monitor is a simple way to deploy Nagios monitoring to networks. It does a great job of monitoring Linux servers, and anything that speaks SNMP.

I recently needed to make some updates to a GroundWork Community Edition VM, and found myself in a situation where the admin user’s dashboard (web browser interface) password had been changed to an unknown value. I was able to SSH into the GroundWork VM though (it’s CentOS Linux based). There’s info floating around the net on how to reset the admin password, but it was written for older versions of GroundWork, so some of the default password, and MySQL schema details have changed.

Here’s what I did to reset the admin user’s password on GroundWork Monitor 6.0 Community Edition:

  • SSH into the GroundWork VM. If you haven’t changed the root user’s default password, then it’s going to be “opensource”
  • Login to MySQL, and run a query to reset the “admin” user’s password to “admin”. The admin password entered below uses a hash:
  • /usr/local/groundwork/mysql/bin/mysql -u root monarch
    update users set password='21232f297a57a5a743894a0e4a801fc3' where user_name='admin';

January 20, 2010

Install UltraVNC from within an RDP Session

Filed under: Systems Administration — Matt @ 11:29 pm

Here’s how to install and start up an UltraVNC server from within an RDP session. This has been tested with UltraVNC 1.0.8 and a remote desktop session into a Windows XP Professional SP3 installation, but should work in other Windows / UltraVNC combinations as well.

  1. RDP into the target system, and install UltraVNC. Be sure to select the checkboxes for registering VNC as a service, and starting up the service at boot time.
  2. Set a VNC password for the currently logged in user by starting up the VNC server (Start > All Programs > UltraVNC > UltraVNC Server > Start UltraVNC Service), then entering a password when prompted
  3. Open up Regedit (Start > Run > regedit)
  4. Copy the HKEY_CURRENT_USER\Software\ORL\WinVNC3\Password entry’s current value
  5. Create a new binary value entry located at “HKEY_LOCAL_MACHINE\SOFTWARE\ORL\WinVNC3\Default\Password”. Paste in the value you copied in the previous step to this new entry’s value
  6. Reboot

That’s it! It may be possible to get VNC going without the reboot, but this is the combination that got a working installation going for me.

July 31, 2009

Joining the ACM – A Linux Sysadmin’s Perpective

Filed under: Linux,Systems Administration — Matt @ 9:07 pm

The ACM, or the Association of Computing Machinery describes itself as “the world’s largest educational and scientific computing society”. Until recently, I assumed that since I was out of academia, and focused more on things that sysadmins do, like developing, and implementing real-world solutions than the stuff of research papers, the ACM didn’t have much to offer me.

A contributor to this bias was the fact that I joined the ACM a few years ago while I was in college. I was working with a couple professors on a project that involved using Linux virtualization to teach networking concepts. Anyway, the reason I joined the ACM was that I was asked to give a presentation at an academic computing conference. As I recall, the two requirements for being a presenter were having a .edu email address (check), and ACM membership. I quickly signed up, and failed to investigate what benefits ACM membership would bring.

Fast forward to today. I spend a lot of time reading to keep up on current technologies, and while I am able to do most of this online, I still spend a lot of money each year buying books. A significant portion of these are published by O’Reilly, which writes a lot of excellent Linux, Unix, and development books. Cisco Press’ books make up another significant portion of my collection. Most of the networking products that I work with run either Linux or one of the BSDs, but I’m yet to find a publisher that consistently covers such a wide range of networking topics as well as Cisco Press does.

Many of these O’Reilly and Cisco Press books are available online through Safari. I was once a subscriber, and was happy with their service overall, but at $23/month, membership dues added up. This is where ACM membership comes in. For $99/year, they offer a number of benefits, including the one that I was most interested in – access to a large portion (600) of Safari’s collection of books. Restarting my ACM membership seemed like a no-brainer, given that I was about to spend $60 on one of the Cisco Press titles included in the collection.

I just joined, and taking a look at what else the ACM offers members, like what I see:

  • Access to 500 of Books24x7’s books. Looking over the list, I can see that this would be especially useful to those who are more involved in the Microsft and/or management side of things than I am. 🙂 Actually, there are a few Sybex books on that list that look interesting. I’ve been meaning to brush up on my Java and Oracle, and also see a number of books covering those topics. The Linux books on the list include:
    • Ubuntu Linux Bible
    • Professional Linux 10 Programming
    • Setting up LAMP; Getting Linux, Apache, MySQL, and PHP Working Together
    • Linux Firewalls: Attack Detection and Response with iptables, psad, and fwsnort
  • All 184 issues of the Linux Journal. If you’re not familiar with this magazine, it’s an excellent resource covering all things Linux.
  • Element K courses and simulators. I haven’t used these before, but see a course listed for Cisco’s BCMSN exam, which I’m scheduled to take in a few weeks. I’ll check it out.

I feel like I’ve just scratched the service. Even if I don’t find anything else in the membership benefits worth using, $99/year for access to this collection of information is a bargain for a sysadmin who’s serious about learning.

January 6, 2009

Linksys PAP2T-NA Gizmo Settings

Filed under: Systems Administration — Matt @ 9:11 pm

Here are the settings that I used to get a Linksys PAP2T-NA working with Gizmo:

  1. Browse to the PAP2T-NA’s web page, for example http://192.168.111.100
  2. Click the PAP2T-NA’s “Admin Login” link
  3. Click on the “Line 1” tab
  4. Fill in the following three values, and hit submit:
    1. Proxy: proxy01.sipphone.com
    2. Display Name: Your Name
    3. User ID: Your Gizmo SIP number, for example 17471234567
    4. Password: Your Gizmo password
  5. Click the “Save Settings” button

That’s it! Your Linksys PAP2T-NA is now configured to use your Gizmo account.

August 23, 2008

Enable the “Remember my password” checkbox for network shares in Windows XP Professional

Filed under: Systems Administration — Matt @ 6:12 pm

Windows XP Professional offers a Remember my password checkbox when mapping to a network drive, or other password protected network resource.
Unfortunately, once you’ve set a password, the Remember my password box disappears, so future username or password changes can result in repeated password prompts. Here’s how to clear your previously set username and password, and get the Remember my password checkbox back:

  1. Click Start -> Run
  2. Type in control userpasswords2, and press Enter
  3. Click on the Advanced tab
  4. Click the Manage Passwords button
  5. Select the server for which you wish to delete existing settings, then click the Remove button
  6. Click Close
  7. Click OK
  8. Logout of Windows XP, then back in
  9. Connect to the password protected server. You should now be prompted for your username and password, along with the previously missing Remember my password checkbox

The above may work in other version of Windows, but I haven’t tested this out. Please post a comment if you’ve been able to use this procedure to get the Remember my password box back under your Windows version!

May 6, 2008

SMTP relay with FreeBSD and sendmail

Filed under: Systems Administration — Matt @ 10:42 pm

Here’s a guide to setting up a FreeBSD server to relay emails for a set of IP addresses and/or hostnames. Be very careful to only enable relaying for trusted machines. Ideally, you’d setup your FreeBSD sendmail server to require authentication.

  1. Enable sendmail on your FreeBSD server by adding the following line to the /etc/rc.conf file:
  2. sendmail_enable="YES"

  3. Start sendmail using FreeBSD’s rc.d system.
  4. /etc/rc.d/sendmail start

  5. Add the IP address or IP addresses that you’d like sendmail to relay mail for to the /etc/mail/access file. For example, the following lines enable relaying for all emails coming from 10.0.2.1, and any IP address starting with 192.168.0.
  6. 10.0.2.1 RELAY
    192.168.0 RELAY

  7. cd to your FreeBSD server’s /etc/mail directory, and run make to apply your changes to sendmail.
  8. cd /etc/mail
    make

April 24, 2008

Printing to a Cannon ImageRunner 5075 from Microsoft Word 97

Filed under: Systems Administration — Matt @ 1:34 pm

One of my customers recently had a Canon ImageRunner 5075 coper/printer/fax unit installed in their office. Everything seemed to be working until someone tried to print a document in Microsoft Word 97. It seems that Microsoft Word 97 didn’t like the new printer. It would crash every time someone went to File -> Print, and selected the Canon printer, but strangely enough, it printed just fine if the Canon IR 5075 was set as the default, and they just clicked on the Print icon.

None of the other printers caused Microsoft Word 97, or any of the other Microsoft Office 97 apps to crash. As a workaround while I tracked down the problem, I asked them to print their word documents as PDFs, then print the PDFs to the Canon ImageRunner 5075.

Needless to say, that kludge wasn’t a good long term solution for the printing problems.What I found was that Microsoft Word 97, and the rest of Microsoft Office 97 for that matter didn’t like Canon’s UFR (Ultra Fast Rendering) drivers. I found a PCL 6 driver for the ImageRunner 5075 on Canon’s website, switched to it, and the crashes ceased.

January 9, 2008

Make Thunderbird show the time and date of replied to messages

Filed under: Systems Administration — Matt @ 2:04 pm

Once thing that I’ve missed since switching from Apple’s Mail to Mozilla’s Thunderbird, is the way that Mail includes the time and date that the message being replied to was received. Thunderbird does not do this by default, but it’s to make it.

  1. Go to the Preferences window.
    • In Linux: Edit -> Preferences
    • In Windows: Tools -> Options
    • In Mac OS X: Thunderbird -> Preferences
  2. Click on the Advanced button.
  3. Thunderbird Advanced Preferences

  4. Click on the Config Editor… button.
  5. Thunderbird Config Editor

  6. Type mailnews.reply_header_type into the Filter: box.
  7. Double-click on mailnews.reply_header_type, enter the number 3 as the new value, and click OK.

Powered by WordPress