The Acumen IT Support blog provides you with helpful articles useful for computer support and solutions.

Business Computer Support

Zabbix frontend shows “zabbix server is running” No

, ,

Zabbix Problem & Solution 

Zabbix Official Logo

 

This occurs when you confirm that the service is running, but the frontend still won’t show server is running.


Found that turning off SELinux with setenforce 0 would fix the problem, so it is clearly SELinux related. The problem is that by default, SELinux prevents apache/php from connecting to network ports, even on localhost. To fix this, you must allow the SELinux rule: httpd_can_network_connect.


Zabbix Solution


sudo setsebool httpd_can_network_connect on

sudo may not be necessary in your environment

sudo getsebool -a | grep httpd

look for httpd_can_network_connect –> on

sudo setenforce 1

This ensures that SELinux is running.


Do NOT just turn off SELinux. It is very effective at protecting your machine from attack.

We can provide assistance for your project. Please see our Linux consulting pages.

For more information, visit their Official Site.

https://www.linux.org/

Chrome Full Screen Alt-Tab Closes Window

,

Our computer support team noticed an annoying bug in the latest version of Chrome. When trying to view full screen windows for streaming applications or just in general. Normally when in Full Screen view a Windows user can press Alt-Tab to switch to another window. With the new version of Chrome this causes the Full Screen window to close. Arg. Google is aware of the problem and promises to fix it with the next update.

Solution

A temporary workaround is to install a Full Screen tool. It’s relatively simple and a handy extension for when you want to use Full Screen with an application that doesn’t have a button to do so. Here are the instructions

  1. Start Chrome Normally
  2. Click Customize Chrome button in the upper right corner of the browser.
  3. Choose Settings.
  4. Click Extensions in the upper left corner of the window.
  5. Scroll to the bottom and click Get More Extensions
  6. Type “Fullscreen Anything” in the search
  7. Click + Free next to the Fullscreen Anything Extension
  8. Click Add
  9. Close and Restart Chrome
  10. Navigate to whatever site you wish to view Full Screen and click the Fullscreen icon in the upper right or from the drop-down menu.

I hope that alleviates a frustrating problem. I know it did for me.

See our Computer Support Pagefor more information on desktop support and computer productivity.

Excel Footer Images Overlap Text

,

Our computer support team was asked to help a customer with an Excel footer problem.

It is not uncommon to use an image file for a header or footer in Excel. Sometimes these are fairly large images that you want to spill out of the header or footer region and into the text. In both cases the images seems to appear behind the text but when the image is in a footer and you go to print the image is actually covering the text on the spreadsheet. This is not a problem with the header. There is no real solution, so I found partial workaround.

Excel Footer Solution:

The header section is allowed to have three images, left section, center section, and right section. So, instead of putting the image you want in the footer simply place it into an available section of the header. Then you have to Format the image with a negative crop. After you insert the image normally click the Format Picture button in the Header/Footer Elements group of the Header & Footer Tools Design contextual tab.

From this dialog box click the second tab, Picture, and crop down to make a negative crop. This will essentially add space to the top, bottom, left, or right of the image and you can push it into the right spot through trial and error.

It’s a really stupid way to achieve the desired ends and it won’t work with different margins and paper sizes but as far as I can tell it’s the only way to make it work properly. Hopefully Microsoft will eventually make images in the footer work the same way they do in the header and appear behind text.

See our Computer Support Team for more ways we can improve your productivity!

Excel 2010 Slicers for Tables (not Pivot Tables)

,

Excel 2010 Slicers

I’ve been doing a lot of work with Excel 2010 and the Table feature lately. One of the things that I would love to incorporate into Tables is the handy Slicers available in Pivot Tables. I hoped to be able to use the Slicer technology in a table rather than having to create a Pivot Table. Sadly, this is not possible. But, don’t let that deter you. It’s really quite simple to turn your Table into a Pivot Table that shows the data in a similar fashion. Then use the Slicer normally. See below for an example and instructions.

A table has the advantage of showing each line-item as a row whereas a Pivot Table does not allow for this sort of data display. Each field you add to a Pivot Table creates an item with subtotal items below it. The trick is to leave off the field or fields you want to “slice”. For example. We do SEO work here at Acumen and one thing I try to keep track of what keyphrases are useful for each of our pages. This table includes three columns, the Page, the Keyphrase, and the Site.

So, I create a Pivot Table with the Page as the first item with each Keyphrase listed underneath. Then I add the Slicer for the Site. Thus I can click on whichever site desired and see the pages and keyphrases associated with it. I might even think about just having the Keyphrases as the list and using both Page and Site as Slicers.

It’s a bit of a cumbersome workaround until Microsoft decides to make Slicers available for tables but will have to do.

See our Computer Support page for more ways we can improve your productivity!