Technology Insights

Analyze A Video File To See The Codec Needed To Play The Video

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.

Technology Insights

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.

Technology Insights

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.