Search This Blog

Thursday, August 4, 2016

Joomla, Low Cost Intranet Solution - Best Plugins & Modules for Your Joomla Intranet

Intranets are an excellent way to foster communication between staff and a way to have quick, easy to access information that can save your employees time and your business money.  Many business chose to use Sharepoint as their intranet, but Sharepoint can not only be extremely expensive but it can also be very time consuming to maintain for the IT staff.  Many companies that invest in Sharepoint end up hiring Sharepoint Administrators and even Sharepoint Designers/Developers.  That's just not feasible for all businesses.  This is where Joomla may shine for some.  It's open source so the base of the system is free.  Add a few great, low-cost, modules and plugins, and you have a very nice company intranet.



I love Joomla.  I'll admit it's not for everyone and it certainly isn't what I would choose for a more simple site but it's a very customizable platform and it's great for the more complex sites.  It's even better for intranets given that they are inside the firewall and therefore security is not nearly as much of a headache as when it's a public facing site.

I researched Joomla and intranets and didn't have an easy time of identifying plugins and extensions that would be best used for an intranet application so I thought I would share my favorites that I've implemented on other intranet sites.

Akeeba Backup
Don't go without backing up your company intranet.  Let this awesome little tool handle the backups for you. It's a good complimentary backup to your regular backups.

RS Form Pro
This is by far the best form creation plugin I've used.  Easy to create forms and very reasonably priced.

MaxiMenu
Really great menu creation tool if you want to add drop downs to your theme.  For our intranet I actually chose to customize the default theme to simplify upgrading/changes.  It didn't have a drop down menu and so this was a great way to add one.

JMapMyLDAP
We use this to map our LDAP into our intranet.  It allows you to map groups in Joomla to groups from Active Directory.  I use this and in conjunction I create group or user specific menus in Joomla that only certain groups can see.  The new version of this software even allows you to connect to multiple domains.

Community Builder
If you want to create an internal social network on your intranet, then Community Builder is your app. Let your employees create profiles, create ad-hoc mass mailings, message each other and have group discussions, let employees post status updates on their page regarding their projects or other happenings.

Then of course there are many other extensions you can use to make your intranet site great.  There are so many extensions for some of these categories that I'm not going to list links or names because it's best to find the one that fits your intranet perfectly.


  • Polls - create polls for your employees
  • Calendar - create one or multiple calendars for the company or departments
  • Galleries - photo albums for internal company photos, customer events, marketing events or even product photos
  • Wiki/FAQ - Create a company or department FAQ or Wiki to help employees find the answers quickly, this can be used for internal procedures, customer service, etc.  The great thing about an FAQ or WIKI module or plugin is that you can create categories and use this knowledge source for multiple purposes
  • Document Management - Document management allows your users to find and download documents on the intranet, think health forms, customer forms, checklists, product documentation, even sales orders.
I haven't even covered all the options you could add to a Joomla based intranet and yet you can see here, it's a powerful tool that has the possibility to bring some wonderful unity to your company. 

Does your company need an intranet site implemented?  Contact tyjustice@liquidwerks.comtyjustice@liquidwerks.com for a free consultation.

Dell Optiplex 7040 Desktops Major Issue with Intermittent Power Problems

Here is a topic that irritates me. We have 9 new Dell Optiplex 7040 desktops that we ordered and deployed in various locations. All nine have been intermittently exhibiting power issues in that you may push the power button and get no response, none. Push the test button on the rear of the power supply, nothing. Unplug the computer, wait several seconds, plug it back in again, it boots fine. The issue was so intermittent and the computers were located in labs and conference rooms so we think that at first, most people were not reporting the issues. After having them for a few months, we have now had these issues on most of the machines. We called Dell to order parts and they wanted to replace just about every part inside the PC except the case. I refused the shotgun approach as I want to know what is causing the issue so we can fix the other 8 machines. So far, we have replaced the power supply on one machine and it seems to be working well again but we will have to see how it's going for another week to call it fixed. Here is the irritation. We have 9 of these things. NINE. We contact Dell and tell them about this problem that we believe is a power supply issue and they reply to let them know how testing is going, blah, blah, blah. With nine machines exhibiting this problem there is obviously a real problem with the product and yet they act as if it's an unknown issue rather than just proactively fixing it once we notified them of the issue. If it's really this widespread they should be sending out power supplies NOW rather than letting consumers and businesses deal with their junk. We pay a huge premium for the business machines because they are supposed to be stress tested and higher quality. They used to be this way but it seems more and more we are receiving equipment that is faulty and it may affect all of a particular model. Where has the quality gone? Other than the three-year warranty, I don't see any huge quality difference between what Dell sells to businesses and what I can buy at Best Buy and it's hugely disappointing. There needs to be more follow through on the business products when it comes to issues affecting multiple machines. It should be more proactive and we should receive notices when there are a bunch of machines having the same problem. Are you having problems with a 7040 desktop and power issues?

Monday, July 25, 2016

Avoid Computer Viruses By Following These Rules

I send out emails to our users at work all of the time and figured I would share it here so others can use it as well.  Viruses are more prevalent and malicious than ever and it's important to constantly educate yourself on how you might avoid a disaster.  

Please be cautious when clicking links or opening documents, even when you know the person who sent the item.  We are seeing more infections of very dangerous viruses that can take down not just your PC but all the servers you have access to on your network.

Here is a PDF download that is a prettier version of this post.  Download it.  Print it out and post it by your computer or hand it out to your users at work.

Download Liquidwerks.com Virus Printout

Don't download attachments from a source you don't know. Email attachments are the number 1 way that viruses and other malware get spread. You should never click an attachment or link in an email from someone you don't recognize. If you are unsure of the sender, get confirmation from them that the file is legitimate before downloading it.

When in doubt about an email, send a separate email to the sender or call them and ask if they did indeed send it.

Download from trusted locations only. If you are downloading a program or other piece of software, it is always advisable to try to download it from the developer's site as opposed to a download service. Many of these services install their own download managers, and can infect your browser with adware.
Downloading illegal files will always be a lottery when it comes to getting viruses and worms. If you can, download from "trusted" sources in the community to reduce the risk of infection.

Look at the extension. Mischievous files often have fake extensions designed to trick you, such as ".txt.vb" or ".jpg.exe". Windows will often hide common file extensions to make browsing through your files and programs more visually appealing. Double extensions exploit this by hiding the second, dangerous extension. If you normally don't see extensions on your computer and it all of a sudden appears on a file that you've downloaded, you may have downloaded a malicious file that is hiding as something else.

To make your file extensions visible, open Windows Explorer, click the View tab/menu and select Options. Click the View tab in the Folder Options window, and uncheck the "Hide extensions for known file types" box.

Don't open anything you don't trust completely. A virus or worm can do nothing unless you actually run the program that it is attached to. That means that simply downloading a file does not put you in any real danger. If you decide after downloading that you don't exactly trust the file, avoid opening it or delete it until you can confirm its integrity.

Be careful with USB drives. USB drives are a popular vehicle for virus transmissions, usually without the owner being aware at all. You could get an infection just by inserting the USB drive, or could get your USB drive infected by plugging it into a public computer. Try to use other methods for file sharing, such as online storage or email to send files.

Avoid clicking on popups & banners. There are thousands of banner ads and popups on the internet that are designed to get your attention and make you click. Due to the way most modern browsers work, there are very few ways for you to get infected with something online UNLESS you click on it yourself. This means you should avoid clicking on banners for offers that are too good to be true.
Make sure your browser is configured to always ask before running files and downloading automatically. If you have to confirm everything, you are much less likely to get infected.

Beware of misleading popups. Some of the most nefarious popups on the internet are designed to mimic the look of legitimate anti-virus software. These popups attempt to trick the user into thinking their antivirus software has found an infection. When you click the popup, however, the adware is actually installed.
Instead of clicking the warning, close the popup window and open the antivirus program on your computer. You most likely will not see any warnings. If you are still worried, run a scan using your installed software.

Don't try clicking the "X" to close the popup window, as this can lead to more popups. Instead, use the Task Manager to get rid of it. (cntl - alt - delete > start task manager)
Other popups may warn of an infection that only their software can fix. No legitimate antivirus company will advertise their product this way, so avoid clicking on any of these popups.
Check to ensure that your browser is configured to block popups.

Don't go where you're not supposed to. As viruses are illegal, they thrive on other illegal sites. Avoid sites that let you download copyrighted content or other illegal communities. File sharing is a quick way to get infected files. You will find that your computer is much less prone to infection if you avoid things you shouldn't be doing.
Besides viruses from files you download, many of these sites will have a litany of annoying popups and misleading advertisements. All of these could lead to virus and spyware infection.

Be selective with your downloads. There are programs available for nearly every task you can think of, but ask yourself if you really need the program that you are about to download. Do a little research about your task; you may find that you already have a program capable of what you want to do. Downloading extra programs for every task you want to complete increases the likelihood that you'll download something malicious.

Beware of odd emails from companies you do business with. A popular phishing technique is to copy the style of a company email and include links that look similar to the regular URL, but instead send you to a fake site ("povver" instead of "power", for example). These sites then collect personal information that you though was going to a trusted server.

Any legitimate company will never ask you for passwords or other personal information through email.

Thursday, June 16, 2016

Kingston DataTraveler Locker + G3 Encrypted USB Flash Drive

Most people now own at least one USB flash drive.  If you're like me, you probably own dozens of them and when you have that many you are apt to lose track of them.  If you have the wrong kind of information on the drive, this could be detrimental to you or your company.

Kingston offers a Kingston DataTraveler Locker + G3 Encrypted USB Flash Drive that is an excellent, low-cost, alternative to the unencrypted USB drives that most of us are using today.  This drive encrypts the data you put on the USB drive and requires a password to unlock/decrypt the information.  If you lose the drive or someone steals it, they will not be able to get to the information on the USB flash drive.  The drives use AES 256 bit encryption; which at this time is very strong encryption.  The drives also have an antivirus engine that runs on them in order to reduce the chances of you infecting your USB drive or computer with a virus.

You can order the drive by clicking the following link:


If you store any sensitive information on your USB drives for either personal or business reasons you should be ordering this drive today.  At a little over $1 per GB these drives are an excellent value.

The encryption software is built into the drive itself, making it simple to setup and use.  While we do not use this on my network (because of Internation Trade in Arms controls) the USB drive offers a free service, clevX USB to cloud backup.  For small businesses and personal users, this is a great feature.

When you plug the drive into your PC the first time it will mount as a drive letter and mount a secondary drive with the encryption software on it.  Just click the drive on the left with the Kingston icon to start the setup.


The setup will ask you to set a password on the device.  Make sure you don't forget this password because there is no way to recover it once you forget it.  Once you put in the password you want to use the system will ask you to put in Contact Info so that if someone finds the drive they can get your contact info to return the drive.  I recommend putting a phone number and/or email on the details pane.  Make sure your password is not derived from any of the information you put in your contact information.


Once you complete the setup the system will ask about the cloud backup. If you want you USB to be backed up for you click Accept and follow through the prompts.



Once you have setup your USB drive password and contact info you can eject your drive and use it anywhere.  When you insert the drive in a PC, you will again click the Kingston logo drive that is loaded, but this time, it will ask you to input the password instead of the setup.  Once the password is correctly entered, your data is available to you!  




Tuesday, March 29, 2016

HippoRemote Great Alternative For Buggy Bluetooth Mouse



I've used a Mac Mini as my home theater computer for several years with an Apple Bluetooth mouse and keyboard.  We bought a new home and moved in last August and after moving I started having problems with my Bluetooth mouse and keyboard.  The seating is four feet further from the equipment cabinet than it was in our last home but previously (with an older model Mac Mini we had it just as far away and didn't have any issues.  Now, the mouse is jumpy, if it works at all.  The keyboard is slow and unresponsive.

Since this machine is used primarly as my home theater machine I don't do a lot of typing on it.  I was going to replace the bluetooth with an external USB version to see if it was better but then I discovered this little gem of an iOS application, HippoRemote.  Amazing.  This app works like a charm.  Install a little application on the PC or Mac that you want to control and set a password.  As long as the PC/Mac and the device you're using to control it (your iPhone or iPad) is on the same wireless network, you can use your device as a mousepad and keyboard.  



HippoRemote works great for our Home Theater.  We use Plex, Netflix, Hulu and more and it's great to just have a remote mouse on our phones to control the machine.   This app would work great for conference rooms and training rooms as well.  

Here are the setup instructions from the application developer:

  1. Download and run HippoConnect.
  2. Toggle the switch to turn HippoConnect on.
  3. Assign a password.
  4. You can now quit HippoConnect. It will keep running in the background.
  5. Make sure your iPhone/iPod/iPad is connected to Wi-Fi and start HippoRemote.
  6. Tap on your Mac’s name in the Detected Serverssection, enter the password and start remoting!

Lynda.com Pro license changes expensive for small businesses

I first saw Lynda.com at MacWorld in San Francisco, I think in 2007 or 2008.  I loved what I saw and I signed up my company for five licenses while at the show.  I've been a Pro subscriber ever since and have administered Lynda.com accounts for at leat 8 years at this point.

The thing that appealed most to me was that we could buy 5 or 10 licenses and then shuffle the licenses from user to user.  You could create users in their (terribly designed) admin interface and make the license active or inactive.  If you had 5 licenses you could have 5 active users.

The reason this model was appealing is that we could offer up open training to anyone for anything, whether it was for their existing job or for a hobby they wanted to explore off work hours and it didn't really matter what they did with it unless it was a mandatory training per their supervisor or job.

  • If I assigned a user an account and they logged in once and watched five minutes of video and then never logged in again, no problem.   This happened quite often actually.
  • If someone wanted to watch 20 minutes worth of video just to learn more about excel pivot tables, great.  
  • If I wanted to know how to create a mask in Illustrator, awesome.
LinkedIn bought them and bam... they jack with the accounts and cost skyrockets because of their new licensing rules.

Our account rep called me about renewing our licenses and informed me on the phone that we would need 3-4 times the accounts thus costing 3-4 times what we previously paid for it.   I explained that changing our pricing to up to 4x the original cost was something that would require budgeting and that we were unable to buy the other accounts.  She was rude about the questions we had about licensing.  I thought it was just me but later my employee told me he felt like she was insinuating we were somehow stealing from them before with the previous licensing.

Now with the new licensing at Lynda.com you can switch accounts only four times after it's originally assigned; that means a total of five users for one account.  The last time you assign a user to an account, they get the account for the remainder of the subscription.  You can't swap it back to one of the other four that were originally assigned to it.

This makes no sense.  Why orphan an account with the final user?  I understand them wanting to make more money but the way they went about it was silly.  My guess is this is the first wave of completely eliminating swapping users on accounts.  This completely eliminates the ability for us to let users use it for just a couple of videos, unless we want to lose an account switch for that one use.  We will now likely refer them to online videos on YouTube or other sources.

I was also surprised to see they designed a new admin interface to track the account moves and yet made no improvements to the interface or user experience when they changed it.  It's still clunky and confusing and badly designed.

My recommendation to Lynda.com is to change the licensing to be 3 users per account with unlimited swaps between those three accounts and fix the horrible administrator interface so that it's easy to use.

Thursday, February 25, 2016

Downgrade from Microsoft SQL Enterprise to Standard & Keep all settings / databases

I had a request to upgrade one of our SQL Servers from SQL 2005 to SQL 2008 R2.  Upon looking at the SQL 2005 server I realized it had the Enterprise version rather than the Standard version installed.   We are not using Enterprise functions and our license is for Standard so I needed to get this server to the Standard version before upgrading it to SQL 2008 R2 as you cannot upgrade from Enterprise to Standard, it must be Standard to Standard or Enterprise to Enterprise.  I would imagine this would work for any type of downgrade such as Developer to Standard, etc.

I successfully uninstalled 2005 Enterprise, reinstalled 2005 Standard and then upgraded to 2008 R2 Standard.  All databases, logins, settings, etc were still present when completed.

To change from Enterprise to Standard:

First and foremost, make sure you have a full backup of your server. I am not responsible if you hose your server, back it up.  :)

  1. Document server collation (right click server in Management Studio > Properties) as you must set it to the same when you install the Standard version later.  Mine was set to SQL_Latin1_General_CP1_CI_AS.  This is important as it determines how your server orders items in the databases so it's critical it's the same during the Standard install.  
  2. Document Version.  This tells you what the latest service pack and/or update that is installed on the server as you need to get Standard to this same version later.   Here is an article on how to determine your version number.  Find the year of SQL server and click the link to the right of it that says SQL Server xxxx Builds and there you can find out which updates were installed last.  https://support.microsoft.com/en-us/kb/321185


  3. Stop all the SQL Server services
  4. Copy all of the system databases to another location as a backup for later as we will need to copy them back once we have reinstalled the software.  My system databases are stored apart from the others so I backed up the entire Data folder that contained them.  The databases I backed up were templog, msdblog, ssdbdata, model, mastlog, master, and dismdl.  Be sure to backup both the ldf and mdf files.
  5. Uninstall SQL Server completely.  Uninstall components but document which components.  I saw another post where someone said to leave the shared components but you should not do this as I ran into an issue with the upgrade to 2008 R2 in that it detected that Integration Services were originally installed with the Enterprise version and this caused the upgrade advisor to fail the upgrade.  I had to later go back and remove this component and then reinstall it to fix this issue.

  6. Install SQL Server Standard.  Remember to choose the correct collation.  I should note that when I reinstalled mine that it listed the version as SQL_Latin1_General_CI_AS and did not include the words CP1 as in my original setup.  Once installed though it listed it correctly so just make sure you get the options correct.  Also make sure to install the correct components that you uninstalled previously.

  7. Download and install the updates necessary to bring your newly installed SQL version up to the same one as it was previously.
  8. Stop the SQL Server services if they are running
  9. Copy all the system databases back into the SQL Server folder where they were previously, you can just overwrite the ones that are there from the new install.
  10. Start the SQL Server services
  11. All databases should now be present and you should be able to create or use an ODBC and connect to them to test.  
Once I completed these steps I upgraded to 2008 R2 Standard through normal procedures.  As I said previously I had originally left the shared components installed and this then triggered an error that meant I could not upgrade because it was not an approved path.  After reading through the logs I determined this to be the fault of Integration Services so I went to the control panel > Programs and Features and I clicked Change on the 2005 SQL Server install and uninstalled IS, then reinstalled it by running the 2005 Standard install again and only choosing Integration Services.  Once complete I ran 2008 R2 Standard upgrade and everything went smoothly.

Monday, February 8, 2016

Setup Plex to Transcode using RAM & Speed Up Plex

My family uses my Plex server from several locations so there are times I will have multiple videos transcoding on my machine which can cause delays and slow transcoding.  I noticed that even though my main disk was SSD, it could not keep up with transcoding more than two streams at a time.

I found some info on this on reddit and then searched around a bit before I found the entire process I would need to do this so that it created the disk on every startup.

My system is Windows 7 Pro so these directions are for Win 7 but can likely be adapted for other OSes with a little research.

Since my machine has an extreme amount of RAM in it I use 32gb of the ram as a disk on startup and then set my Plex to use this to transcode videos. Mind you, I will not use all of this space for transcoding but I'm not using this RAM for anything else right now and I plan to move my Temp space for Windows and some browser files to this ramdisk in the future.  The great part is that it can be changed anytime by editing the batch file we will create below.

Keep in mind, that doing this takes active RAM (memory) away from your system so if you only have 2gb of RAM and you're running Windows this probably isn't a great solution for you without upgrading the RAM on your system.

It's really easy to make this change.

Create your RAMdisk batch file


  • First, download and install IMDisk here:  http://www.ltr-data.se/opencode.html/

  • Then open a notepad file and put this line in it:
    • imdisk -a -s 2g -m T: -p "/fs:ntfs /q /y"
Customize this line to your system by changing the 2 to whatever number of gigabytes of ram you want to use for this disk.  If you want to use mb instead then just change the 2g to 512mb intstead.

The T: is the drive letter so you can change this to any letter you want.  


  • Save the notepad file to your hard drive to a location like C:\ImdiskStartup and name it imdisk-startup.bat

Setup a Startup Task to create your RAMdisk on every boot

  • Search for Task Scheduler on your PC and open it
  • Open Task Scheduler Library > Microsoft > Windows and then make sure Windows is highlighted.  Then right click in the empty pane and click Create New Task
Settings for task:

General
Name:  Doesn't really matter, named mine 'IMDisk RAM startup'
Description:  Not required
Security Options:  Click Change User or Group, type SYSTEM in all Uppercase and click OK.  This should change the user account to NT AUTHORITY\SYSTEM
Check the box that says "Run with highest priveledges" 

Triggers
Click New > On Begin the task choose At startup and click OK

Actions
Click New > Click Browse > Browse to the .bat file you saved earlier in the C:\IMdiskStartup folder (imdisk-startup.bat), choose the file and click OK

Conditions
Turn off Start the task only if computer is on AC power

Settings
Click box for Run task as soon as possible after a scheduled start is missed

Click OK to save the schedule

Change Plex to use the new RAMdisk

  • Login to your Plex server and go to Settings > Server > Transcoder
  • Click Show Advanced
  • Change Transcoder Temporary Directory to your new drive letter
  • Click Save