Cyprich.com

Occasionally Relevant Insights from a Software Builder

By

Installing MS SQL Server on Ubuntu

At Microsoft Connect(); 2016, it was announced that MS SQL Server was available for Linux (Ubuntu and RedHat) and MacOS. This was a real surprise and I’m not sure if its free or not. It was an easy installation on Ubuntu 16 running on HyperV on a Windows 2012 server.

The installation procedure for MSSQL and SQL Server Tools are at:

After you install the software, a brief tutorial on using it from the command line is here, but I prefer using SQL Server Management Studio (see below).

screenshot-2016-11-17-10-51-38

By

A Better Error Page on the Canada Immigration Site

Tonight during the historic US election, the Canadian Immigration site (http://www.cic.gc.ca/) was down. I’m sure it had nothing to do with Americans trying to leave their country and move to Canada in light of the imminent Trump victory. The following ASP.NET error page was displayed:

Screen Shot 2016 11 08 at 10.59.59 PM

This is a default error page that gets displayed for ASP.NET sites. This is ok, but I prefer something more friendly than this type of page which doesn’t mean much for most people. A custom error page should have information about your website and contact info for the user to let you know the site failed.

The code to redirect errors to a custom page is added to the web.config file (located in the root of the website folder). The following settings refers to Error.aspx in the /ErrorPages folder.

<configuration>
    <system.web>
        <customErrors mode="RemoteOnly" defaultRedirect="~/ErrorPages/Error.aspx" />
    </system.web>
</configuration>

By

Direct URL for a Store in XMPie uStore

You can login to an XMPie uStore using a direct URL. This is just for debugging purposes. Normally an outside user will use a friendly URL that the proxy server generates. The URL for accessing a store is:

      http://website.com/uStore/?StoreId=XX

The XX is the StoreID that you can find in the uStoreAdmin site under ID beside the Store Name. Your store’s web site goes under website.com in the URL.

By

How To Download Visual Studio 2015 for Offline Install

I don’t mind online installers. They’re convenient but if your installing a multi-gigabyte application, you don’t want to reinstall it this way. Visual Studio 2015 is one of those apps.

This, in my humble opinion, is the best software developer tool out there. If it had PHP, Ruby, and FTP/SSH, I could uminstall Eclipse. (To clarify, there is PHP available for VS but it’s a commercial product and the free Eclipse version is just as good and free. Did I mention that it was free?)

There used to be an option on the Microsoft site to download a VS ISO, but it seems to be unavailable now. You can still download the installation files (not the ISO) by running the online installer with a command line option.

First, download the installer. Then open a cmd.exe prompt as administrator. Then run the installer as follows:

    vs_community_ENU /layout

You will then be prompted for a download path, then the long download will proceed.

This will download the core features of Visual Studio and you’ll still need to go online to download all of the features you might need.

By

How to Recover a Joomla Admin Password

If you don’t login regularly to your Joomla administrator site, you may one day forget what your password is. If this unfortunate event does happen, its very easy to recover it if you have access to the database that your web site uses.

Open your database and find the table prefix_users, where prefix is the database prefix that you selected when you installed Joomla.

Open your user account for editing.

In the password field, replace the contents with

d2064d358136996bd22421584a7cb33e:trd7TvKHx6dMeoMmBVxYmg0vuXEA4199

You’ve just changed your password to the word secret. Now immediately login and change your password to something more secure.

This procedure works with Joomla 2.5 and 3.x.