Archive for month: August, 2013

You are here: / / / August

HOWTO: Export a list with SP

When you try to export a SharePoint list you get an error messages saying it can’t be done.

SharePoint ExportList

“To export a list, you must have a Microsoft SharePoint Foundation-compatible application.”

Searching this error message easily finds the root of the problem. There is a problem with the Office 64 bit version. It doesn’t work with SP. These solutions generally tell you to uninstall your 64 bit office and install a 32 bit version. Happily there is a much easier solution.

Despite the error message the export actually works! Notice the yellow bar at the bottom of your browser. Simply save the .iqy file normally and open it with Excel. It’s that simple. The error message is certainly a nuisance but does not actually stop the export.

SaveAnyway

See our IT Services Page for more information on ways we can help you!

For more information about Microsoft, visit the Official Site:

https://www.microsoft.com/en-us/

/2 Comments/by

Windows Remote Host Licensing Mode

Official Windows Logo

Windows Problem

Server 2012’s Terminal Server services are proving to be much different than prior versions of windows. The initial remote desktop based roles wizard is easier to use, but making changes after they are installed can be a hassle.

A lot of the configuration is done in Server Manager -> Remote Desktop Services -> Deployment Overview -> Tasks -> Edit Deployment Properties.

Solution

The setting that I missed was one under RD Licensing -> Select the Remote Desktop licensing mode: Per Device or Per User.

After activating our licensing for Enterprise Agreement for Windows 8 VDI Per Device CAL’s, I assumed that the licensing mode would default to Per Device. It did not, and remote desktop did not work to VM’s on the terminal server.

Be aware that if you have the licensing server installed and activated that these items do not default to the CAL’s you purchased and configured. This applies to RD virtualization host and session host roles.

See our Technology Service Page for more ways we can help you!

/by

SOLVED: SFTP Fatal in Selinux Log

Problem

When trying to configure sftp, you encounter “fatal: safely_chroot permission denied” in your SElinux audit.log.

Problem Scenario:

When you disable selinux with setenforce 0, sftp works.

When you enable selinux with setenforce 1, sftp fails and gives an error like:
Aug 7 18:01:19 server1 sshd[36015]: fatal: safely_chroot: stat(“/var/www”): Permission denied

Important facts:

You must have:
setsebool -P ssh_chroot_rw_homedirs=1
This will often error if you have an sftp user that also has a login shell (a big no-no), set it to /sbin/nologin with:
usermod -s /sbin/nologin mySFTPUser

But sftp still won’t work because the internal SELinux policies don’t allow sftp chroot. Create a custom SELinux policy to allow the chroot using audit2allow:
yum install setroubleshoot (to get audit2allow)

or

yum install policycoreutils-python (alternate package with audit2allow)
cd /root
grep chroot_user_t /var/log/audit/audit.log | audit2allow -M sftp_chroot_custom_policy > sftp_chroot_custom_policy.text
semodule -i sftp_chroot_custom_pol.pp

NOTE: The normal out put of this would be the .pp file generated by the -M flag. The .text file contains the human readable equivalent. You must use the .pp binary file with the semodule -i command.

This applies to Centos 6. It may apply to other Linux operating systems.

See our Linux Support and Consulting for more information on how we can help you or simply visit our IT Services Page.

/1 Comment/by
Meet our Team Get a Quote Read Reviews

CONTACT US

  • Call: 314-343-1800
  • Contact

    Use red “Contact Us” button (right)

  • Chat

    Use red “We are online” button (bottom)

BUSINESS HOURS

Monday – Friday: 8am – 5pm
Saturday – Sunday: Closed
24 Hour Support Service Available

Customers Receiving Support:

Disclaimer: Acumen Consulting is an independent service provider of technical service for business networks. We have reseller partner agreements with all of the companies and brands for which we are offering service on acumenitsupport.com. All partner trademarks, registers trademarks, company names, product names, and brand names, are the property of their respective owners. We provide ONLY reseller services for the products listed.

Call Now