Archive for the ‘ Work ’ Category

A bug in Bugzilla 4.0.4

There was a request to have a new tool custom report tool created for our Bugzilla installation so I had to re-deploy a copy of Bugzilla onto our development environment. Installation was a bit tricky with a specific Perl module (YAML) being the main issue. The install script keeps saying that this is missing:

Checking for YAML (any) not found

Checking the system, YAML is indeed installed and available. What is actually broken is the CPAN.pm file in the Bugzilla package – it doesn’t require the module.

To fix this, add the YAML module into the CPAN.pm file found in the bugzilla/lib directory. Search for:

use Text::Wrap ();

And replace with:

use Text::Wrap ();
use YAML;

Running the install script now works with no errors.

WDS Deployment spanning multiple subnets

This turned out to be simpler than I had first imagined. Reading the Microsoft documentation looked like we had to make changes to the DHCP, however this was not the case.

To make it clearer, our current environment looks like this:

  1. DHCP is a Linux CentOS Server
  2. WDS and DHCP servers are on the same subnet
  3. Client machines are on various subnets
  4. Cisco core switch and router stack

For our setup, we only needed to make sure the Cisco ip helper-address was set to point to the IP address of BOTH the DHCP and WDS. Once this was done, everything went as intended.

WDS Installation and Deployment

We’re deploying a new WDS (Windows Deployment Service) server at work and at first everything looked alright until I ran into my first snag – I wasn’t able to start the role / server after I installed it.

Looking everywhere on the manuals and guides provided by Microsoft didn’t help either. All they say is to add the role to the server and then configure the server with deployment images etc.

Upon closer inspection, it seems like you need to initialize the server before it will even start. In order to do this, you need to run a command via an elevated command prompt window:

wdsutil.exe /initialize-server /reminst:<path to WDS data files>

I created my own folder for the WDS data files and then plugged that into the command. WDS started up with no further issues.

Next posting… how to get WDS to work with multiple subnets. I’ll post that when I get it sorted out! :)

VMware vSphere Client cannot mount local optical drive

Another quick post regarding a nagging issue I’ve had for awhile now. Every time I wanted to connect to my local optical drive it would complain with the following error immediately:

Remote device disconnect
The remote device on <host> connected to <path> is disconnected.

Digging around I found that the cause of this is because of Windows 7 permissions again. Running the application as Administrator or checking off the “Run this program as an administrator” under the Compatibility tab of the vSphere Client shortcut solved the issue!

Hope this helps you all as well.

Restoring a gziped MySQL DB backup file

Short post… just for reference:

gunzip < [backupfile.sql.gz] | mysql -u [uname] -p[pass] [dbname]

CDONTS on Windows Server 2008 R2

As old as it may be, we still use a sendmail API from way back to NT4! Having said that, there was a slight blip when we migrated to a new Server 2008 R2 server, the dll file was missing! I had to copy the file from the old server and move it to the new server.

  1. Copy CDONTS.dll from another server to C:\Windows\SysWOW64 and C:\Windows\System32
  2. Run regsvr32 c:\windows\SysWOW64\cdonts.dll
  3. Run regsvr32 c:\windows\System32\cdonts.dll
  4. Grant the appropriate permissions on C:\inetpub\mailroot\pickup (I granted USERS group Modify permissions). You could get permission denied if the folder security isn’t adjusted.

You don’t need to restart the server at all, just hit your site and again it will work!

Jivesoftware – SBS 4.5 and MySQL

It has been awhile, but I’m still alive. Anyway, installed SBS 4.5 from Jive Software today, however the JDBC for MySQL wasn’t included in the installer.

Downloaded the files from the following link:
http://dev.mysql.com/downloads/connector/j/

Extracted the mysql-connector-java-5.1.12-bin.jar file (versions may be different as there are newer ones available) and copied it to the following folder:
/usr/local/jive/tomcat/lib/

Restarted the Jive application and the connector worked!
service jive-application restart

Hope that helps, and remember to have fun!

Microsoft Dynamics CRM 4.0 and Outlook 2010

Although both products are from Microsoft, they don’t seem to play nice together. Most likely due to the fact Office 2010 came out recently and has changed the way it interacts with the system. Either way, when installing CRM the following error showed up:

(Error) Setup failed to determine whether a supported version of Microsoft Outlook is installed

The only solution is the ignore this manually. To do so, create the following into the registry (the entry does not yet exist):

[HKEY_CURRENT_USER \ SOFTWARE \ Microsoft \MSCRMClient]
Key Type: DWORD
Key: IgnoreChecks
Value: 1

The installer will still state the error but it will now allow you to continue with the install! Good luck!

Windows 2008 and IIS 7.5

We got a new server at work and got some time to play around with Windows 208 R2. One thing I liked most was the new Server Manager UI. This basically gives you a full overview of what the server is set to do and you can add / remove role (services) here.

With that in mind, I started configuring the FTP service. The first thing that occurred to me is that I wanted to isolate users to their own directories. Selecting the “FTP User Isolation”, there were three options for isolation.

  1. User name directory
  2. User name physical directory

Both options didn’t seem to work even though I had created folders with the user names on the root FTP directory. The reason was that I was missing a root folder “LocalUser” before each of the user directories. So our new directory structure is as follows:

D:\FTP\LocalUser\username

After that, we could log users into the FTP site. However, the next issue popped up. We could not get the users to see any virtual directories (directories which point to certain directories that are outside of the user’s home directory).

In order to accomplish this, we had to right-click on the user’s directory within the IIS manager and select “Add Virtual Directory”. Additionally, we had to select “User name directory (disable global virtual directories) and ensure that virtual directories is enabled in the site’s “FTP Directory Browsing” options.

After all that, it is now working for us! Hope it works for you too!

Force feeding Windows Server 2003

Another day at work, another interesting problem. A user was connecting to a terminal server and tried to print to a printer that was installed locally on her PC. Logging into the terminal server via RDC showed no printers available.

First step was to ensure that the printer was a shared local resource. This was alright, however the printer still does not want to show up. Frustrated, I tried to install the printer locally by downloading the printer drivers on the terminal server. Running the install file did nothing so I had to find another way to force the drivers onto the system.

Logging onto the terminal server as Administrator, I found a way to trick the server and force feed it the drivers.

  1. Enter into the control panel and install a new local printer. Install manually and do not search for a printer.
  2. Select a printer port to be “FILE: (Print to File)” and choose your own printer drivers (select have disk).
  3. From the downloaded driver file, select the INF or if it is already in the list of available drivers, select your printer from there.
  4. Continue through with the installation and allow the printer to be installed. Remember to name it something random as this is only temporary and you will delete this printer after.
  5. Once the dummy print to file printer is installed, log off the terminal server and re-log back in.
  6. As you log in, you will notice that Windows has now installed the printer that was having troubles.
  7. Remove the dummy printer so that it doesn’t show up in the printer list!

So, that’s what I did to make this work. You can also check in the system logs to see that whether or not this method is necessary. In the system log, you will see an 1111 error code stating that the printer driver could not be found and the printer was not installed.

Hope this helps!