Blog

Latest Technical Notes

cdr_mysql.c:203 mysql_log: Cannot connect to database server localhost: (1045) Access denied for user ‘freepbxuser’@’localhost’ (using password: YES)

When restoring FreePBX from backup, you may find the CDR database is not updated. This is because the cdr_mysql.conf file is not overwritten by the restore, and so the password for the CDR database is incorrect.

You can resolve it like this:

SSH onto the server
nano /etc/freepbx.conf
Find the lines:
$amp_conf['AMPDBUSER']  = 'freepbxuser';
$amp_conf['AMPDBPASS']  = '3098SADFSLa';​​

Copy the password, quit nano
nano /etc/asterisk/cdr_mysql.conf
Insert the password in the apropriate section
Save the file, quit nano​
amportal reload
You may need to restart the server to allow the password to be updated.

read more
Damiancdr_mysql.c:203 mysql_log: Cannot connect to database server localhost: (1045) Access denied for user ‘freepbxuser’@’localhost’ (using password: YES)

Office 365 SMTP Server Settings

If you want to use a scan-to-email device or other application that requires an SMTP gateway, Office 365 can be used.

In our tests, a live account must be configured for the device, otherwise you have to use a user’s credentials to send mail, which may not be desirable.

​Server: smtp.office365.com
Port: 587
Encryption: TLS
User Name: (user name)
Password: (password)

We have successfully configured a number of devices, such as Canon MFP, Konica Minolta Bizhub copiers etc with these settings.

read more
DamianOffice 365 SMTP Server Settings
end-of-life.jpg

Countdown to End-of-Support for Windows XP

Support for Windows XP ends

On April 8th 2014, Microsoft will end support for its decade-old Windows XP. This means, you will no longer receive security updates, fixes or online technical support for PCs still running Windows XP SP3 and Office 2003. The security and privacy implications of this event could have significant impacts on your business, so if you’re running either of these products you should plan to take action soon.

As a precaution, we would recommend all our clients to consider upgrading to the latest supported operating systems such as Windows 7 or Windows 8.1. Customers migrating to these platforms will benefit from enhanced security, broad device choice for a mobile workforce and higher user productivity.

Why upgrade now?

  1. No support: Microsoft support, including online and phone-based technical support, will end. As a result both Jaytag and any other IT support company will not be able to properly support Windows XP.
  2. Security Risks: Critical security updates will stop, making machines much more vulnerable to viruses. Hackers are waiting to take advantage of this insecurity. If your computer gets a virus your machine will not only not perform properly – it may shut down entirely. Moreover, you are at risk for losing files and having your personal and business information stolen. Anti-virus software will also not be able to fully protect you once Windows XP itself is unsupported.
  3. Compliance: Businesses that are governed by regulatory obligations may find that they are no longer able to satisfy compliance requirements e.g. PCI compliance.
  4. Hardware Manufacturer support: PC hardware manufacturers will stop supporting the above mentioned operating system. This will also mean that drivers required won’t be available anymore. E.g. a new HP printer won’t have drivers for the above operating system.
  5. Old technology: Windows XP was released 12 years ago, and was replaced by Windows 7 in 2009. It does not support HTML5 or the newest version of Internet Explorer nor does it support many modern hardware devices such as USB 3.0.

If you have any concerns regarding your systems, please do contact us to discuss the options that are available to you.

read more
DamianCountdown to End-of-Support for Windows XP
linksys_smashed.jpg

Has your router been cracked wide open?

linksys router smashed

We have had a number of customers report recently that their internet browsers have been hijacked. Quite simply, this means that when they try to browse to a website, such as google.com they are redirected somewhere else.

These websites that are displayed often ask for Adobe Flash player to be updated, or inform you that a virus scan needs to be completed on the computer.

These sites are not genuine. In fact, the reason that the pages are shown is because the settings on the internet router have been changed by a 3rd party.

More information about this security vulnerability is available here: http://www.isssource.com/routers-hacked-via-email/

This of course is extremely worrying, as it means an outsider has successfully accessed the computer network, and may in future try to infect connected computers with viruses, or otherwise attempt to illegally access data.

Thankfully, the fix is quite simple – the internet router password should be changed to something other than the manufacturers default, and the system administration password should be changed to something more complex.

System administration passwords should be changed regularly as a matter of course, so this is a good opportunity to ensure that this vital task has been completed.

read more
DamianHas your router been cracked wide open?

How Cloud Storage Could Help Your Small Business

Cloud Storage is the term used to describe using an online facility to store your information. These are usually operated by a third party company using data centres and there are a number of different operators providing it such as Dropbox, Skydrive, My Secure Backup, and Google Drive.

Cloud storage is an increasingly popular concept, and many small businesses are embracing it to help them. But how can cloud storage help a small business?

One popular use of cloud storage is to store your important documents such as databases, spread sheets or client projects. By doing this, it doesn’t matter if your computer breaks down, is stolen, or the file is otherwise lost; you will be able to successfully retrieve it from your cloud. You can usually set up an automatic synchronisation, so that when you save a document to a certain folder in your PC, the cloud storage facility you use will pick it up and automatically save it there too. Alternatively if you log onto your cloud storage remotely from a remote device or there web site you can upload/maintain documents and these will automatically synchronise/update on your home computer.

It is also a secure way of storing your information. You can change privacy settings of the documents so that it can only be accessed by yourself, people listed, or people who you pass the link to. This allows you to share it with people if you need it, or stash it away in a private folder if it isn’t something you want to share.

The cost of cloud storage can be considerably lower than other solutions, with many companies offering you a small amount of start-up storage for free, with higher amounts becoming available to you for a small fee, often on a monthly subscription basis.

So lets take a look at the four services I previously mentioned and see what they have to offer:

DropboxDropbox

Dropbox is a cloud storage facility which comes with an initial 2GB, which can be expanded to fit your requirements. A client application runs on your PC continuously monitoring and synchronising a specific folder so it can be set up to back up whatever you want, and all your documents are accessible from wherever you go through any PC or mobile device. It can be upgraded to Pro (designed for personal use) or Teams, which allocates space between your team. It also has management facilities so you can track the account usage of your team members and seamlessly shares documents across all devices.

Sky DriveSkydrive

This is Microsoft’s answer to cloud storage and allows users to upload their documents, again accessing them from a computer or device. New users get 7GB of free storage which can be upgraded for a small subscription fee. Because it is a Microsoft product, it has been upgraded to include Office Web Apps, which allows documents to be created, edited and shared online.

JunglediskMy Secure Backup

This is our own secure storage solution for businesses which allows secure access of all your data between teams of 2-100. All files are kept safe in Amazon’s S3 file servers in the US or EU, or RackSpace.com file servers – two very popular file hosting soultions. You can limit files that are stored locally, which unlike Dropbox or Microsoft SkyDrive’s “LiveDrive” in the event of a theft or unauthorised access you’ll benefit from the added security. You’ll also benefit from multi-way sync between machines which means that your files will never be out of date if multiple team members are working on them. My Secure Backup also offers the ability to backup multiple computers (even the main file server) on a daily basis in a single account. Remote monitoring is also a fantastic feature with configuration and ongoing support is provided by our very own Jaytag Computer, not a large faceless corporation. We also offer UK based technical support.

My Secure Backup is £10 per month for the first installation in a business which includes 50GB of storage and then £5 for each addon user per month – all users can share the same 50GB ‘pool’ of storage.

Google DriveGoogle Drive

This is Google’s own storage service which allows users to store and share documents seamlessly between anyone. Google Drive also has Google Docs built in which gives users the ability to not only create documents, spreadsheets, presentations, and drawings by themselves, but invite collaborators to help with editing

Recently Google announced that they’re merging the storage space between Google Drive, Google+, and Gmail into one giving users 15GB free to use between the three Google services.

Cloud storage is becoming an increasingly popular way for businesses to share files as well as keep them safe, secure, and always available. DropBox, SkyDrive, and Google Drive are all fantastic cloud storage services, but they’re mostly aimed at individual users. My Secure Backup is made for business and offers more storage space as well as shared storage between employees and team members.

read more
Aaron RichardsonHow Cloud Storage Could Help Your Small Business

Windows Server updates failing – Error 80072EFD

You may have found that your Windows Server won’t update via Windows Updates Services and the following error message is displayed on screen.

error2

One issue which causes Windows Updates to fail with error 80072EFD is if the Windows Server is pointing at itself or another Server on the network to find the updates.

To check this click Start > Run > type “regedit”, and accept the UAC prompt to continue.

regedit

Now navigate to HKLMSoftwarePoliciesMicrosoftWindowsWindowsUpdate.

win

Look at the keys in that folder, and check whether they look something like this:

“WUServer”=http://srv_name:8530

“WUStatusServer”=http://srv_name:8530

If these entries are listed under that folder you should backup and then delete the “WindowsUpdate” folder:

  • Right-click on the folder and select “export” to save it.
  • Delete the “WindowsUpdate” folder from the registry at HKLMSoftwarePoliciesMicrosoftWindows.

Now, click Start > Run > type “services.msc”.

services

Navigate down to the Windows Update service and restart it.

serviceslist

You should now be able to perform updates on your server.

read more
Joel JohnsonWindows Server updates failing – Error 80072EFD

GParted – “Bad sectors” Error Message

When using GParted to resize a partition on a hard drive you have cloned you may notice an exclamation mark on the drive.

exclamation mark1

When you attempt to apply the resize it will most likely fail, and you may receive an error message, similar to the one below, stating that there are “bad sectors” on the disk.

error message

If you run CHKDSK in windows it will most likely tell you that there were no bad sectors found. This is due to the fact that the old hard drive probably had bad sectors on it and when it was cloned it carried the error flags over with it to the new hard drive.

To solve this issue you will first need to run command prompt as an administrator in windows.

Next type “chkdsk /b”. The “/b” flag tells CHKDKS to perform a bad block check, it is a more thorough scan but it takes longer.

cmd prompt 1

You will most likely be trying to run CHKDSK on the drive that you are currently using. If so, you will receive a message stating that you must restart the computer before it can do so.

cmd prompt 2

Type “Y” and press enter. Now restart your computer. CHKDSK will start scanning the computer and should remove all the old error flags.

Wait for the computer to do a full reboot and then run GParted again. You should find that the yellow exclamation mark has disappeared and you are now able to resize the partition successfully.

read more
Joel JohnsonGParted – “Bad sectors” Error Message

Session setup failed: NT_STATUS_INVALID_PARAMETER

When trying to link to a Windows Vista, 7 or 8 shared printer from Mac OS 10.6 or newer, you may find that the printer gives this error message. Essentially, SMB printing from CUPS (the Mac OS printing system) seems broken – it does not pass along the correct user name and password (even when entered manually).

The solution is quite long winded…

Firstly, ensure that the printer is shared on the Windows machine, with a share name with no spaces. (i.e. not “Canon IP 6700D”, but “CanonIP6”)

Then:

On the Windows PC

  1. Click Start
  2. Click Control Panel
  3. Select Programs and Features
  4. Click Turn Windows Features on or off
  5. Under Print and Document Services, tick the LPD Print Service
  6. Click OK

Ensure you have assigned a static IP to the print server (or have noted this down) as you will need this later.

On the Mac

  1. Click into System Preferences
  2. Click Print & Fax
  3. Click + in the bottom left of the window to add a printer
  4. Right click the tool bar (next to the Windows icon) and click customize
  5. Add the Advanced button to the toolbar
  6. Select Advanced
  7. In the Type field select LPD/LPR Host or Printer
  8. In the URL field enter lpd://x.x.x.x/PrinterShare (for example lpd://192.168.1.120/CanonIP6)
  9. We found that using lpd://ServeName/PrinterShareName does not work – you must use the the IP address of the print server. Use the IP address you noted earlier.
  10. Click the Add button
read more
DamianSession setup failed: NT_STATUS_INVALID_PARAMETER

Internet Explorer and HMRC – this file could not be downloaded

If you are unable to download P60, CT100 or VAT forms from the HMRC website, you may need to check that Adobe Reader is working correctly. Often, an issue with the installation will mean the PDF file from the HMRC site will not open automatically. The error message will then appear – “this file could not be downloaded”.

Here is how to fix the problem:

  • In Internet Explorer, go to Tools (or the small cog icon) then click Internet Options
  • Select the Advanced tab
  • Check the Do not save encrypted pages to disk option is ticked in the security section
  • Click OK

Close Internet Explorer, and then Open Adobe Reader.

  • In Adobe Reader click Edit then Preferences
  • Click into Internet
  • Untick Display PDF in browser
  • Click OK

You may need to also repair the Adobe Reader installation:

  • In Adobe Reader select Help then Repair Adobe Reader installation

Once you have followed the repair instructions, you may need to restart your computer.

Finally, if this still does not work(!) you can try to upgrade your version of Adobe Reader here. You could also try a different internet browser like Mozilla Firefox or Google Chrome – either of these should work straight away.

read more
DamianInternet Explorer and HMRC – this file could not be downloaded