Category Archives: Computers

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 1:error:14090086:SSL routines:SSL3_GET_SERVER_CERTIFICATE:certificate verify failed Resolution Remove the mail server / domain from the list which your exchange server is having problems connecting to. The message… Read More »

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 script to update the logs to use MyISAM (instead of CSV!). SET @old_log_state = @@global.general_log; SET GLOBAL general_log = ‘OFF’; TRUNCATE TABLE general_log; ALTER TABLE… Read More »

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 the “Edit group settings” button, it will be on the right above the computer icons. At the bottom of the list is “Expert settings” Find… Read More »

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 With Sheets(“Ranges”).Range(RangeName) Set Rng = .Find(What:=FindString, _ After:=.Cells(1), _ LookIn:=xlValues, _ LookAt:=xlWhole, _ SearchOrder:=xlByRows, _ SearchDirection:=xlPrevious, _ MatchCase:=False) If Not Rng Is Nothing Then ‘Application.Goto… Read More »

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 ===>>> All >> db47-4.7.25.4 (1/1) ===>>> The databases/db47 port moved to databases/db48 ===>>> Reason: Superseded by databases/db48 ===>>> Currently installed version: db48-4.8.30.0_2 ===>>> Port directory:… Read More »

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 encountered — cannot continue “Makefile”, line 25: Malformed conditional (${PERL_LEVEL} < 501001) “Makefile”, line 29: if-less endif make: fatal errors encountered — cannot continue ===>>>… Read More »

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 your new hostname to the trusted_domains setting. If you plan of changing the Port, add that now as well. ‘trusted_domains’ => array ( 0 =>… Read More »

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 going to FreeNAS web gui, clicking Plugins along the top, and switching the Owncloud service off then on again.

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 Windows Update issue I felt it was likely a NTFS / Registry permission error as I had also had issues on the laptop in question… Read More »

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 them in miles. Example use SELECT * , FIND_DISTANCE(home_latitude, home_longitude, 52.5, -1) AS distance FROM users WHERE deleted = 0; */ RETURN ( 3959 *… Read More »

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  

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 set portopening TCP 1434 “SQL Admin Connection”  @echo Enabling conventional SQL Server Service Broker port 4022   netsh firewall set portopening TCP 4022 “SQL Service Broker” … Read More »

Security policies were propagated with warning. 0x534 : No mapping between account names and security IDs was done.

Security policies were propagated with warning. 0x534 : No mapping between account names and security IDs was done. Advanced help for this problem is available on http://support.microsoft.com. Query for “troubleshooting 1202 events”. Error 0x534 occurs when a user account in one or more Group Policy objects (GPOs) could not be resolved to a SID. This… Read More »

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 prove useful in the future. vssfix incase links go bad

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 Option used: Microsoft Volume Shadow Copy Service (VSS). V-79-10000-11226 – VSS Snapshot error. The Microsoft Volume Shadow Copy Service (VSS) snapshot provider selected returned: “Unexpected… Read More »

0xe000fed1 – A failure occurred querying the Writer status. See the job log for details about the error.

Job ended: 05 April 2014 at 01:12:06 Completed status: Failed Final error: 0xe000fed1 – A failure occurred querying the Writer status. See the job log for details about the error. Final error category: Resource Errors For additional information regarding this error refer to link V-79-57344-65233 — As per… http://answers.microsoft.com/en-us/windows/forum/windows_other-performance/backups-failing-during-the-night/af99f1ba-48fd-42d4-b784-eb517d205cce Hi, What type of files are… Read More »

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 to be require on the source server unless you’re issuing the SCP command from the console. the -C compresses the transfer and in my experience… Read More »

Renaming virtual disks

SSH to server, CD to directory disk is held in. vmkfstools -E ‘examplevm.vmdk’ ‘examplevm-renamed.vmdk’ eg vmkfstools -E Windows\ 2008-000001.vmdk Clubhouse-HD1.vmdk May be wise to delete any snapshots associated with the disk first?

SNMP Software

Not PowerSNMP (can’t do much with it) Not Tembria (nice, but can’t get the OIDs) Possibly iReasoning MIB Browser – qwerky but has what I need