Larry Brouwer

... just my personal technology sandbox

Connect

Installing OpenCart on Windows Server 2008

By Leave a Comment

Today, I’m attempting to install OpenCart, an open source ecommerce package. OpenCart was chosen as the runner-up of the 2010 Open Source Awards as published by Packt Publishing.

I first looked through the OpenCart Online Documentation. The most current stable release as of this writing is OpenCart v1.4.9.3. OpenCart requires PHP, and MySQL. I currently have both installed on my Windows Server 2008 platform. It should also work fine running  under Windows IIS 7.

As a side note, the OpenCart Tools section outlines some great suggestions for free tools. I use some of them, like Jing, others I’m excited to check out.

[Read more…]

Installing Google Analytics for WordPress

By Leave a Comment

I’ve been creating a new Web Site for one of my clients, Clear Lake Auto Service, using WordPress, and the client is wanting to see statistics regarding Web Site traffic. My first thought is to add Google Analytics to the site. Here are the steps I took to get analytics up and running for him.

First, I logged into the WordPress site, and installed the Google Analytics for WordPress v4.0.9.

Second, I created a new Google Analytics account under his Google mail id.

Third, I activated the WordPress plugin, selecting his new account. The plugin automatically verified the Account and Profile to use.

Forth, added my email account as an Administrator to the profile.

That’s it!

SmarterMail Exception System.OutOfMemory Exception Errors

By Leave a Comment

Today, I discovered that my SmarterMail is acting up again. When I attempted to check my emails, I get a really nice aspx error page.

My first thought is that someone has hacked my mail system, and is sending out spam again. I’ve had this problem before, and outlined the steps I undertook in order fix the problem in my post entitled, SmarterMail Security Lockdown Prodecures.

I shut down the SmarterMail Service and started looking at the mail logs, and event logs. I can see the out of memory errors, but I still don’t know what’s causing the problems.

I then restarted the SmarterMail Service and logged into my account to look at the reports being generated. There is nothing in the reports that are out of the ordinary.

[Read more…]

Installing PrestaShop on Windows Server 2008

By Leave a Comment

This morning, I’m working on installing open source ecommerce packages on my Windows Server 2008 box. This is mainly for experimental and learning purposes.

The first package I choose to install is PrestaShop. PrestaShop was chosen as the winner of the 2010 Open Source Awards as published by Packt Publishing.

My first step was to read through the most current PrestaShop User Guide. The most current stable version as of this writing is PrestaShop v.1.3.5. PrestaShop uses a MySql Database, so my first task is to install the current release of MySql (5.5.8) on my Windows 2008 server.

Since I’m not currently using MySql on a daily basis, I also made sure all of my workstation components (i.e. workbench, connector, etc.) are also up to date.

[Read more…]

Installed Windows Azure tools for Visual Studio 2010

By Leave a Comment

I finally got around to setting up a Microsoft Azure service for doing some cloud test development this afternoon.

After logging into my MSDN account a activating my Azure service, I went into VS 2010 and installed the Windows Azure SDK and Windows Azure Tools for Microsoft Visual Studio (November 2010). There are several downloads available.

Copying Sql Server 2008 database from Prod to Dev

By Leave a Comment

I had the pleasure of refreshing the development instance of the Harris County Master Gardener’s database this morning. Basically, Dev was getting too old to conduct testing on, so took the most recent Production backup (from last night), and using MS SSMS I was able to restore the database without much incident.

However, my troubles then began when I attempted to pull up the Development Web Site. The application couldn’t connect to the database. I’ve had this type of thing happen in the past, but as usual, I’ve forgotten how to fix it.

After some researching on the Web, I came up with a Microsoft Support Article entitled, Troubleshooting Orhpaned Users, and I was able to fix the problem with relative ease. Look under the section “Steps to Resolve Orphaned Users”.

The following are the steps I undertook:

1. Using MS SSMS, connect to the Sql Server instance where the copied database exists.

2. Open a New Query window and enter: Use DataB go sp_change_users_login ‘report’

3. The stored procedure will display output for all of the affected login’s

4. Open a New Query window and enter: Use DataB go sp_change_users_login ‘update_one’, ‘test’, ‘test’ for each login.

That should fix the problem!

Windows XP Remote Desktop problems printing locally

By Leave a Comment

While setting up a client for remote desktop using Windows XP Pro to remotely access Windows Server 2008, I discovered that the clients local printers weren’t accessible by the server. After much Google searching, I discovered that (mstsc.exe) RDS 7.0 is now available for XP. This solves the problem with RDS Easy Print. The latest RDS 7.0 is available here.

Here’s a great post that describes Windows Terminal Services Easy Print in detail.

Good troubleshooting tips are provided at Remote Desktop Services troubleshooting.

Update. The client was able to initially print to the local printer after installing the update. However, it was not reliable and the printer did not always show up.

To solve the problem I actually physically connected the printer to the server and installed the drivers from the originally installation disk. The driver downloaded off the Canon website would not install without the printer being physically installed.

After doing this, the printing now works great from Server 2008 to Windows XP Home.