Earlier today I was asked by a user via a Question Defense comment on how to play a WMV file that would not play by default via Windows Media Player. There are numerous tools available that will provide information about audio/video files and the codecs needed to play them but I have found that AVIcodec works really well in most situations. Below is information on how to install AVIcodec and how to analyze video files once AVIcodec is installed.
Earlier I was testing an issue with scanning to a Brother printer at the computer shop and needed to flush the DNS cache on my Windows 7 laptop after I made an entry on the local DNS server. Flushing the DNS cache on Windows 7 is easy using the command line from a Windows Command Prompt. Follow the directions below to clear the Windows 7 DNS cache.
Earlier this week I was asked by someone at work if there was a way to have Redmine email them when a file was uploaded to the Files section of a specific Redmine project. At first I wasn’t sure if it was possible but after digging around the Redmine interface I was able to find an easy solution. Follow the directions below to have Redmine send a email notification every time a file is uploaded to a specific project.
Redmine: The following error occured while sending email notification: 530 5.7.0 Must issue a STARTTLS command first.
Recently while working on a CentOS Linux server I downgraded Ruby version 1.8.7 p302 to Ruby version 1.8.6 p399 because of a project that was built for Ruby 1.8.6. The server is a development CentOS Linux server with numerous other projects already operational on it and so downgrading Ruby caused a couple issues one of which was with Redmine project management software. The issue was with sending email notifications for things such as file uploads, added issues, issue updates, etc. Below I describe the error in more detail, the reason for the error, and how to resolve the error sending email notifications.
How To Remove Role Privileges Created By The PostgreSQL GRANT Command, Shell Script To Remove PostgreSQL Access Privileges
PostgreSQL isn’t the most friendly when it comes to creating access to various databases or tables within those databases however with a couple easy shell scripts it becomes much easier. I previously wrote this article regarding a shell script created to provide SELECT access, which is essentially read only access, to every table located within a specified database. The problem now might be if you want to remove a user from having access to that database you will be required to manually remove each access privilege for the role you created. Below is the reverse of the initial shell script which will remove SELECT access from each table within a specified database.