Monthly Archives: December 2011

Linux

MediaTomb Media Server

December 22, 2011 – 4:37 pm

I bought a new 4 bedroom house that has 2 living room back in September and I’m just now getting around to furnishing it.  The one thing I got was a new Toshiba TV.  I noticed that you could plug a USB flash drive into it and so I put one in and launch the media player on the TV and was shocked to see my tablet on there.  After some investigating these new TV’s are UPnP aware and have a media player that can play from a UPnP server.  Turns out it’s incredibly easy to do this on FC16 using MediaTomb as the server.  Let me relay the steps to doing this.

  1. In this case I’m using FC16 stock install with MySQL installed, let me point out it’s the default MySQL install, see the post on starting MySQL to hear about that nightmare, this is the reason that I had to do that.
  2. Instal MediaTomb by typing ‘yum install mediatomb’.  This will also create the mediatomb user in the system that the service will use to run as (although not the home directory which is a great place to house the media, more later on this point).
  3. You’ll have to create a new MySQL database, this should be second nature but if not here is a link to the documentation on it.
  4. Now you’ll have to edit the mediatomb.conf which is located /etc/mediatomb.conf directory.  It’s nice and easy as the only thing you really need to do is bind it to an interface with the MT_INTERFACE =”[interface]”.  To find what you need to put in here, do an ifconfig and put in whatever is the active network connection is.  Oh make note of the MT_PORT number while you are here.
  5. Now we are ready to start the service, done by typing ‘service mediatomb start’ into BASH.  By extension stop, restart and status work too.
  6. You are up and running and from the server type in the following in for the URL:  http://localhost:[MT_PORT] where the port is what you made note of in the mediatomb.conf in step 4.
  7. You can now use the UI (user interface) to add directories to the server.

I would be derelict in my reporting without telling you the last steps but at this point the server is up and running so here is the rest of the story.

You’ll need to get the media over there.  I’d recommend FTP (see related post).  And you’ll need a directory to store this media.  What I did was create a /home/mediatomb and then uploaded the media via FTP.  Just chown the media to mediatomb and place it in this directory and then using the user interface specify /home/mediatomb as the directory to check, do so recrusive and I’m using the timed (I’ve heard bad things about Inotify and MP3’s set to full and recursive.  I didn’t include hidden anything and left the scan interval at 30 minutes (1800 seconds).

That’s it, you’re done.  I put about 110Gb of music into the directory and it took about 3 or 4 hours to move, and it’s now in the process of scanning them in no apparent order.  I’m not sure how long it will take but will try to update if I can figure it out.  But if you’re anything like me it’s time to go make a drink and I’ll check back on it tomorrow when I can almost guarantee that it’ll be done:)  Okay here is the update, takes about as long as it does to transfer as it does to index.

Permalink | Comments Off on MediaTomb Media Server
Linux

FTP on Fedora Core 16

December 22, 2011 – 11:55 am

As you know one of the important reasons that you have a Linux server is so you can use it to store and transfer files.  File Transfer Protocol is your friend in this case.  The basic flavor you get when you install FTP on FC16 is VSFTP or (very secure file transfer protocol).  Now my first glance opinion on this wasn’t favorable, this primarily stems from the fact that there is no webmin module that can control this server and  I have no idea how to use it.  Turns out I was wrong and the damn thing is so simple to use even I was shocked when I figured it out.  Here is a quick list of commands for working with the service.

Use the chkconfig command to start the service at boot:  chkcongif vsftpd on

Starting, stopping and restarting like so:
service vsftpd start
service vsftpd stop
service vsftpd restart

Viewing the status:
service vsftpd status
pgrep vsftpd (this will give you the process Id’s)

I’m going to give a shout out to http://www.linuxhomenetworking.com and the article here for shedding light on the situation.  I’ll have to do some poking around on their site.  Very helpful:)

Permalink | Comments Off on FTP on Fedora Core 16
MySQL

Starting MySQL in Fedora Core 16

December 21, 2011 – 2:42 pm

We’re going through a hardware upgrade at work and we were given the chance to take home our old computer when they swapped it out with a new one.  Yeah, needless to say I jumped at the chance to have my old 2.2Ghz with 4Gb of RAM dev box as my new Linux server.  I installed FC 16 and had to monkey around with MySQL to install it, eventually uninstalling the default instance and downloading it direct from MySQL.  This first gave me problems installing MediaTomb with this cryptic error:

file /usr/share/mysql/charsets/README from install of mysql-libs-5.5.18-1.fc16.i686 conflicts with file from package MySQL-server-5.5.18-1.linux2.6.i386

So by removing the default and installing the generic I managed to cause some damage.  I went into webmin and uninstalled the following:

MySQL-client 5.5.18-1.linux2.6 Applications/Databases MySQL – Client
MySQL-devel 5.5.18-1.linux2.6 Applications/Databases MySQL – Development header files and libraries
MySQL-server 5.5.18-1.linux2.6 Applications/Databases MySQL: a very fast and reliable SQL database server
MySQL-shared 5.5.18-1.linux2.6 Applications/Databases MySQL – Shared libraries

I then installed MySQL from yum.  It loaded fine but I couldn’t for the life me find out how to start it, the standard /etc/rc.d/init.d/mysqld was not to be found.

I found this in a post and it worked (logged in as root) so I figured I’d better document it so I don’t forget:

systemctl start mysqld.service

Permalink | Comments Off on Starting MySQL in Fedora Core 16
Linux

Installing a SSL certificate in a LAMP environment

December 20, 2011 – 11:12 am

Wow, if you’re reading this you are doing so over a 256 bit encrypted link.  To give you an idea of what that means my bank only uses 128 bit encryption.  Now for a while I was doing this with a self signed certificate.  But then you run into all kinds of hassles that when you send a link to your non-geek friend they get all upset because they get a warning when they try to go to it.  Aside from that hassle (which I can live with) I ran into an issue with the flash uploader on my Gallery 3 site.  It seems that if you have a self signed certificate the flash uploader will not work leaving the only way to upload anything to the server was the ‘server add’ option that would have meant I whole bunch of work that I just didn’t feel like doing right now.

The Solution?  Get a signed certificate from a CA.  Yeah that seems a little obvious but here’s the thing.  I’m not selling anything meaning I’m not making anything and I don’t really want to pay for it.  Free SSL certificates?  Turns out yes they do exist.  I went with StartSSL and was very pleased with the experience.  The first thing I had to do was start by validating my email and getting a certification for that and then it was time to get the SSL/TLS Server cert.  Here is how I did it so I’ll know how to do it next time.

Telnet into the server and issue the following command:

openssl req -new -newkey rsa:2048 -nodes -keyout myserver.key -out server.csr

This will give you two files.
myserver.key: this is your encryption key.
server.csr: this is the Certificate Signing Request that you will submit to the CA

In my case (running Fedora Core 16) I placed the myserver.key file in the /etc/pki/tls/private/ directory.
When you submit it to the CA, they will have you cut and paste the returned text into a ssl.cert file. Get that onto your server and I put it in /etc/pki/tls/certs/. Then you need to find the ssl.conf file and change the SSLCertificateFile and SSLCertificateKeyFile file locations and names. Save the file, restart Apache and you are good to go.

UPDATE
Okay, got home and got a message that I missed a couple of files.  To this end let me say these are the files that were missing:

SSLCertificateChainFile /usr/local/apache/conf/sub.class1.server.ca.pem
SSLCACertificateFile /usr/local/apache/conf/ca.pem

I put them into /etc/pki/tls and just linked them in the ssl.conf and it worked fine and seemed to fix any issues I saw so don’t forget to do this next time.

Permalink | Comments Off on Installing a SSL certificate in a LAMP environment
Blogs/Blogging

New Code Highlighter

December 15, 2011 – 7:34 am

I had a devil of a time figuring out which syntax highlighter to install but I think that I finally found one that I am happy with.  It’s SyntaxHighlighter Evolved and I’ll be using it going forward.

Permalink | Comments Off on New Code Highlighter
C# SSIS

C# to move files in SSIS script task

December 14, 2011 – 2:43 pm

Most of the time that I’m creating integration packages, I have a central working directory where all the action is taking place, at the end of the package execution is where I’ll archive files so that should they be needed to troubleshoot an issue I’ve got them in a handy place.  This is a script that I created for that process.  Note that lines 7 through 19 are generated by the Visual Studio Tools for Applications in SSIS when you create the script task.

using System;
using System.IO;
using System.Data;
using Microsoft.SqlServer.Dts.Runtime;
using System.Windows.Forms;

namespace ST_218640c1eafd4eb9ab909245d34e01c7.csproj
{
[System.AddIn.AddIn("ScriptMain", Version = "1.0", Publisher = "", Description = "")]
public partial class ScriptMain : Microsoft.SqlServer.Dts.Tasks.ScriptTask.VSTARTScriptObjectModelBase
{

#region VSTA generated code
enum ScriptResults
{
Success = Microsoft.SqlServer.Dts.Runtime.DTSExecResult.Success,
Failure = Microsoft.SqlServer.Dts.Runtime.DTSExecResult.Failure
};
#endregion

public void Main()
{
string strOriginalFileName = @"C:\TCC\20110722-UpdateCandidate\UpdateHireEmpStatus.csv";
string strArchivedFileName;
string strDate;
DateTime dtDate = DateTime.Now;

strDate = String.Format("{0:yyyyMMdd_HH_mm_ss}", dtDate);

strArchivedFileName = @"C:\TCC\20110722-UpdateCandidate\Archive\UpdateHireEmpStatus-" + strDate + ".csv";

File.Move(strOriginalFileName, strArchivedFileName);
Dts.TaskResult = (int)ScriptResults.Success;
}
}
}
Permalink | Comments Off on C# to move files in SSIS script task
C#

C# to delete files older than X days from a directory

December 14, 2011 – 12:02 pm

The vast majority of the time, when I build an integration I archive all the files so that they can be used to track down where something is going wrong.  Unfortunately if left unchecked these files can grow and grow and it becomes impossible (or rather terribly difficult) to sort through the files to see if there was indeed an issue.  The answer to this is to cull down the files when you archive them.  To this end it’s good to kill all files older than X days.  This is a console application that can do this, it actually does this in 3 directories.  Path, path1 and path2 define the directories and days is the amount of days back to delete.

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.IO;

namespace TestConsoleApplication
{
class Program
{
static void Main(string[] args)
{
string path, path2, path3;
int days;
System.DateTime date;
System.DateTime keepdate;
path = "Y:\\SQL_Backups\\SFDC_Data";
path2 = "Y:\\SQL_Backups\\TaleoData";
path3 = "Y:\\SQL_Backups\\dnn5_test";
days = 10;
date = (DateTime.Now);
keepdate = date.AddDays(-days);

DirectoryInfo fileListing = new DirectoryInfo(@path);

foreach (FileInfo f in fileListing.GetFiles())

{
if (f.LastWriteTime <= keepdate)
f.Delete();
}

DirectoryInfo fileListing2 = new DirectoryInfo(@path2);

foreach (FileInfo f in fileListing2.GetFiles())
{
if (f.LastWriteTime <= keepdate)
f.Delete();
}

DirectoryInfo fileListing3 = new DirectoryInfo(@path3);

foreach (FileInfo f in fileListing3.GetFiles())
{
if (f.LastWriteTime <= keepdate)
f.Delete();
}

}
}
}

I have yet to get this functionality to work in SSIS but will post how to do that once I figure it out.

Permalink | Comments Off on C# to delete files older than X days from a directory
Blogs/Blogging

Google Syntax Highlighter

December 14, 2011 – 11:19 am

Because I’m going to be using this site to store bits of information that happen to be code, I’ve decided to utilize Google syntax highlighter for this functionality.  The main problem is it’s pretty complicated to use.  So this post has the information I’ll need to use it.

The usage wiki for GSH can be found here and here is an example for the HTML:

Here’s a list of supported languages and their aliases:

Language Aliases
C++ cpp, c, c++
C# c#, c-sharp, csharp
CSS css
Delphi delphi, pascal
Java java
Java Script js, jscript, javascript
PHP php
Python py, python
Ruby rb, ruby, rails, ror
Sql sql
VB vb, vb.net
XML/HTML xml, html, xhtml, xslt
Permalink | Comments Off on Google Syntax Highlighter
Blogs/Blogging

Welcome to the new blog

December 14, 2011 – 8:55 am

Hello, my latest attempt at a blog is here.  Got some updated hardware and a fresh install of Fedora Core 16 and the latest and greatest WordPress installed and away we go.  I’ll be using this blog to post bits and pieces of computer wisdom that I acquire in my day to day dealings as an integration engineer.  We’ll have a mix of transact SQL, some C# and Java along with some rather obscure details of dealing with TCC (Taleo connect client), data loader (the Salesforce.com integration engine) as well as SSIS.  Feel free to contact me if you have any questions or concerns.

Permalink | Comments Off on Welcome to the new blog