Block Skype ads

Go to Control Panel > Network and Internet > Internet Options > Security Tab > Restricted Sites   Then click sites, and add https://apps.skype.com/ Works for me with no loss…

Comments Off on Block Skype ads

FreeBSD, odd SSL related problems

You probably either don't have security/ca_root_nss installed or it was installed with ETCSYMLINK enabled. /usr/ports/security/ca_root_nss/

Comments Off on FreeBSD, odd SSL related problems

FreeBSD & vmtools

https://www.vmware.com/support/ws55/doc/ws_newguest_tools_freebsd.html http://kb.vmware.com/selfservice/microsites/search.do?language=en_US&cmd=displayKC&externalId=10185 Click VM -> Guest -> Install / Upgrade VMware Tools (which inserts the virtual CD) # mkdir /mnt/cdrom # mount -t cd9660 /dev/cd0 /mnt/cdrom # cd /tmp/ # tar…

Comments Off on FreeBSD & vmtools

Avast + Exchange + Queue

Mail remains in exchange queue with Avast 8 installed. Problem arises is ESP is using self signed certificates. Checking %ALLUSERSPROFILE%\AVAST Software\Avast\log\Mail.log you'll find Cannot establish TLS with SMTP server A.B.C.D:25, SSL_connect error…

Comments Off on Avast + Exchange + Queue

my MySQL default configuration

my.cnf file. Try and use this before you start MySQL Server for the first time! [mysqld] log-output=TABLE expire_logs_days=1 general_log=ON general_log_file=/var/db/mysql/mysqld-queries.log slow_query_log=ON slow_query_log_file=/var/db/mysql/mysqld-slow-queries.log log_queries_not_using_indexes=ON log-error=/var/db/mysql/mysqld-error.log default-storage-engine=innodb innodb_file_per_table Run the following SQL…

Comments Off on my MySQL default configuration

Avast opens Browser on Windows Boot Up

Log in to the Small Office Administration Console Click the "Network" menu item You should be on "Group View" automatically, but if not, click that menu item underneath "Network". Click…

Comments Off on Avast opens Browser on Windows Boot Up

Excel VBA Search in a Range

Define a Range in Excel by selecting a series of records and entering a name in the NameBox Public Function IsInRange(RangeName As String, FindString As String) Dim Rng As Range…

Comments Off on Excel VBA Search in a Range

databases/db48 installed / upgraded repeatedly

# portmaster -DaG ===>>> Starting check of installed ports for available updates ===>>> The databases/db47 port moved to databases/db48 ===>>> Reason: Superseded by databases/db48 ===>>> Launching child to reinstall db47-4.7.25.4…

Comments Off on databases/db48 installed / upgraded repeatedly

Malformed conditional (${PERL_LEVEL} < 501001)

Updating ports and getting this... ===>>> Currently installed version: p5-Version-Requirements-0.101020_1 ===>>> Port directory: /usr/ports/devel/p5-Version-Requirements "Makefile", line 25: Malformed conditional (${PERL_LEVEL} < 501001) "Makefile", line 29: if-less endif make: fatal errors…

Comments Off on Malformed conditional (${PERL_LEVEL} < 501001)

FreeNAS, Ownclound, SSL (change Port?)

First things first, setup DNS to point owncloud.stephen-scotter.net to correct IP address. Failing to do this at the beginning will cause your problems. Next, edit /usr/pbi/owncloud-amd64/www/owncloud/config/config.php (within the jail) and add…

Comments Off on FreeNAS, Ownclound, SSL (change Port?)

FreeNAS, OwnCloud, change listening port

Nano /mnt/zfs1/jails/owncloud_1/usr/pbi/owncloud-amd64/etc/apache22/extra/httpd-ssl.conf Edit all instants of 443 to new port number. Line:Text --------- 35:# Listen directives: "Listen [::]:443" and "Listen 0.0.0.0:443" 37:Listen 5443 74:<VirtualHost _default_:5443> 78:ServerName www.example.com:5443 Restart OwnCloud by…

Comments Off on FreeNAS, OwnCloud, change listening port

Windows Updates 0x80070005

Spent days trying to get to the bottom of this error. 0x80070005 apparently means "Access Denied". While researching the error and trying all the normal things you'd do to resolve a…

Comments Off on Windows Updates 0x80070005

MySQL function to calculate the distance between two latitude and latitude GPS pairs

CREATE DEFINER=`root`@`localhost` FUNCTION `FIND_DISTANCE`(`src_latitude` float,`src_longitude` float, `dest_latitude` float,`dest_longitude` float) RETURNS int(11) BEGIN /* This function takes four parameterss, two sets of latitude and latitude pairs and returns the distance between…

Comments Off on MySQL function to calculate the distance between two latitude and latitude GPS pairs

FreeBSD Update Survival Guide

A pretty conclusive document about keeping FreeBSD up to date. http://www.zytrax.com/tech/survival/freebsd-update.html

Comments Off on FreeBSD Update Survival Guide

VSS Writers

Excellent list of services to restart when a VSS Writer is playing up (and thus avoids a whole server restart) http://www.planetcobalt.net/sdb/vss_writers.shtml  

Comments Off on VSS Writers

Open Windows Firewall Ports for SQL Server

http://blogs.msdn.com/b/jorgepc/archive/2009/08/25/open-firewall-ports-for-sql-server-the-easy-way.aspx @echo =========  SQL Server Ports  ===================  @echo Enabling SQLServer default instance port 1433  netsh firewall set portopening TCP 1433 "SQLServer"  @echo Enabling Dedicated Admin Connection port 1434  netsh firewall…

Comments Off on Open Windows Firewall Ports for SQL Server

VSSFix

http://kb.macrium.com/KnowledgebaseArticle50010.aspx VSSfix 32bit - download VSSfix 64bit - download Unable to confirm this software is helpful at this time (it didn't solve the problem I had when I found it) but could…

Comments Off on VSSFix

V-79-10000-11226 – VSS Snapshot error. The Microsoft Volume Shadow Copy Service (VSS) snapshot provider selected returned: “Unexpected provider error”. Ensure that all provider services are enabled and can be started. Check the Windows Event Viewer for details.

Problems initially presented as a Backup Exec job completing with exceptions with the following message in the Job Log Backup- PTISVR2 - AOFO: Initialization failure on: "D:". Advanced Open File…

Comments Off on V-79-10000-11226 – VSS Snapshot error. The Microsoft Volume Shadow Copy Service (VSS) snapshot provider selected returned: “Unexpected provider error”. Ensure that all provider services are enabled and can be started. Check the Windows Event Viewer for details.

Copying Guests or Moving HD’s between ESXi hosts

To copy a guest between ESXi hosts you can use SCP. # scp -rC /vmfs/volumes/datastoreABC/GuestXYX root@newesxihost:/vmfs/volumes/datastoreEFG/ Note 1: SSH is required to be running on the destination server and highly likely…

Comments Off on Copying Guests or Moving HD’s between ESXi hosts