Monday, June 16, 2014

How I installed Owncloud v6.0.3 + on Ubuntu Server 14.04

Update; 1 Jul 14

Decided to try installing via the:

http://software.opensuse.org/download/package?project=isv:ownCloud:community&package=owncloud


The version installed was 6.0.4.1 at the time.


This gives the ability if there are updates that they will be installed automatically through apt-get updates and no more manual updates.

I crossed out the items that were not necessary with the update install version verses the manual install.

So...

1. Installed Ubuntu Server 14.04 on the computer. 
2. Installed with OpenSSH and LAMP.  Root should be the default admin account created for mysql.  Remember the password.
3. Performed updates:

sudo apt-get update

4. Performed upgrades:

sudo apt-get upgrade

5. Perform additional required installs (In Accordance With [IAW] Owncloud v6 Manual Installation):

sudo apt-get install php5-gd php5-json php5-mysql php5-curl php5-intl php5-mcrypt php5-imagick

6. Downloaded owncloud-6.0.3.tar.bz2:

sudo wget http://download.owncloud.org/community/owncloud-6.0.3.tar.bz2



sudo sh -c "echo 'deb http://download.opensuse.org/repositories/isv:/ownCloud:/community/xUbuntu_14.04/ /' >> /etc/apt/sources.list.d/owncloud.list"

sudo apt-get update

wget http://download.opensuse.org/repositories/isv:ownCloud:community/xUbuntu_14.04/Release.key

sudo apt-key add - < Release.key

sudo apt-get install owncloud

7. Extracted the contents:

sudo tar xjf owncloud-6.0.3.tar.bz2

8. Moved the owncloud directory to the proper location /var/www/html/owncloud:

sudo mv owncloud /var/www/html/

9. Changed permission on the owncloud directory recursively:

sudo chown -R www-data:www-data /var/www/html/owncloud


10. Enabled ssl within Apache2"

sudo a2enmod ssl 
sudo a2ensite default-ssl 
sudo service apache2 restart
 
11. Modified the default-ssl file for Apache2:


sudo nano /etc/apache2/sites-available/default-ssl.conf

 

Add ServerName; 

 



 Add owncloud;



<Directory /var/www/html/owncloud>
    Options Indexes FollowSymLinks MultiViews
    AllowOverride All
    Require all granted
</Directory>

 


12. Enable mod_rewrite

 

sudo a2enmod rewrite

sudo service apache2 restart 

13. Might get error "Could not reliably determine the server's fully qualified domain name"

Add FQDN to /etc/hosts

sudo nano /etc/hosts





sudo service apache2 restart

14. Log into your owncloud via http
-You will get a warning that your data directory is exposed.  We'll change that later.
-Create an admin account name with password.
-Leave the data folder alone.
-Hopefully you remembered the mysql root password.
-Call you database "owncloud_db".
-The database will be located on the "localhost".





15. Close the client download window.
-Select admin (upper right corner) --> users

 


16. Create your first user.
-Provide that user with enough storage space.
-Select admin again and logout.




17. Lets fix the data folder.  You can ultimately determine were you want your data folder.  I choose the root.

sudo mv /var/www/html/owncloud/data /


18. Now we also have to tell owncloud where it went:


You will need to edit the config.php file and add the fqdn:

sudo nano /var/www/html/owncloud/config/config.php

Change; 'datadirectory' => '/data',
Add your FQDN; 1=> 'owncloud.no-ip.info'


 


19. You should be able to access https now without complaint.  Running owncloud through http is not healthy.  It should be running under https.  If you check the ssl cert (view certificates) the default cert used should be from the ubuntu installation and have the computer name in the "issued to" "issued by".




20. OPTIONAL if you dont like the default sizes to upload make these changes:

sudo nano /etc/php5/apache2/php.ini

Change;
post_max_size = 4G
cgi.fix_pathinfo = 0
upload_max_filesize = 4G
date.timezone = "America/New_York"

21. You should be good to go.

UPDATE; 16 Jun 14



1. If you get the following error: isWebDAVWorking: NO - Reason: [CURL] Error while making request: SSL: certificate subject name 'XXXXX' does not match target host name 'YYYYY'

sudo nano /var/www/html/owncloud/3rdparty/Sabre/DAV/client.php

Find; <ctrl w>
curlsettings

Add below;

CURLOPT_SSL_VERIFYPEER => 0,
CURLOPT_SSL_VERIFYHOST => 0,


 

sudo service apache2 restart

2. I also added my own self created certs instead of using the default.


Now to get https ssl working with OwnCloud I created self-signed certs.  Remember the self signed password as it will ask you again.

sudo openssl genrsa -des3 -out /etc/ssl/server.key 4096

sudo openssl req -new -key /etc/ssl/server.key -out /etc/ssl/server.csr

sudo openssl x509 -req -days 3650 -in /etc/ssl/server.csr -signkey /etc/ssl/server.key -out /etc/ssl/server.crt

sudo openssl rsa -in /etc/ssl/server.key -out /etc/ssl/server.key.insecure

sudo mv /etc/ssl/server.key /etc/ssl/server.key.secure


sudo mv /etc/ssl/server.key.insecure /etc/ssl/server.key

sudo mkdir /etc/apache2/ssl

sudo cp /etc/ssl/server.key /etc/apache2/ssl

sudo cp /etc/ssl/server.crt /etc/apache2/ssl

sudo ln -s /etc/apache2/sites-available/default-ssl.conf /etc/apache2/sites-enabled/000-default-ssl.conf

sudo nano /etc/apache2/sites-available/default-ssl.conf

#   SSL Engine Switch:
#   Enable/Disable SSL for this virtual host.
SSLEngine on
#   A self-signed (snakeoil) certificate can be created by installing

#   the ssl-cert package. See
#   /usr/share/doc/apache2.2-common/README.Debian.gz for more info.
#   If both key and certificate are stored in the same file, only the
#   SSLCertificateFile directive is needed.
SSLCertificateFile      /etc/apache2/ssl/server.crt
SSLCertificateKeyFile   /etc/apache2/ssl/server.key

#   SSLCertificateFile    /etc/ssl/certs/ssl-cert-snakeoil.pem
#   SSLCertificateKeyFile /etc/ssl/private/ssl-cert-snakeoil.key


sudo service apache2 restart
 

Tuesday, February 25, 2014

My quest for commercial free recorded TV...

I've been on this quest for quite some time and have recently sank additional time into its partial successful.  I say partial because it would appear that nothing in the world of network television is absolute.  By that I mean commercials.

This is more of a how to and extension onto my PVR write up.  This takes into effect that you have a running Win7 or Win8 Media Center (MC) that is recording your TV shows.  To reiterate I despise having to rent set-top boxes from my carrier.  They are incredibly costly to rent over time.  With the FCC changes to CableCards (MCard) this provides a reasonable rate to acquire HDTV.  Through the use of PVR's in connection with your rented MCard you can have your TV the way you want it, cheaper.  There might be more than one way to get your recorded TV.  You could pay for your own DVR's such as Moxi, build your own or if you already have a PC add a TV Tuner such as Ceton PCIe or USB Tuners.

I chose the PC using a Ceton PCIe Tuner with Win8 MC.  Reasoning for the choice was the existing XBOX360 throughout the house act as MC Extenders.  Notice I wrote XBOX360 (360) and not XBOXOne (XB1).  XB1 does not come with extender capabilities or DLNA.  Thats right you heard me correctly.  So get to your local pawn shop or used game store to pick up a 360.  There has been no official word I know of to date that Microsoft is enabling the feature on XB1.  Why you ask?  MC is apparently a dieing feature.  Win7 came with MC automatically.  Win8 you have to buy it extra.  Its entirely possible that the next OS Microsoft puts out MC might not be available at all.  It appears MC users only account for 5% of the population therefore not profitable.  So what should you do?  Well Win8's lifecycle is quite a ways off at 10 Jan 2023 so in the next nine years I should be able to save approximately $6480 in equipment rentals and that's only putting that at $60 per month.

So in my quest to have commercial free TV...

I've looked at MC-TVConverter and MCEBuddy.  The reason I went with MCEBuddy was because of support.  It would appear MC-TVConverter was last updated in 2011 as of version 2.1.0.  As of this writing that was three years ago.  I have no idea if the project is still ongoing.

I needed a program that would run as a service on my PC and convert my TV shows to a usable format.  The .wtv file format is very large in size and is not easily taken to mobile devices or streamed.  One thing also that needs to be discussed when dealing with recordings is timing.  I think by default MC set the default recording at 2 minute prior and 3 minutes after.  I have set my recorder to start on time and off on time.  Recording prior and after has a way of screwing with the commercials.  Also make sure your computer clock on the Media Center is set to update routinely to keep the right time and not to magically go offset.


By usable format/container I mean .mp4, .m4v or even .avi.  I'm on the road occasionally and it would be nice to copy the TV show to my mobile device and watch it while say on the plane, exercising on the treadmill, or what ever.

MCEBuddy provides that.  MCEBuddy is free but there is also a latest and greatest version that if you donate, to date $20, you will get the latest version.  Now I decided to write this while I was testing MCEBuddy so I'm using the free version typically one version older than the latest.  I don't need to explain MCEBuddy's feature because you can get that from their page.

I installed MCEBuddy on my Win8 MC.  The default install settings.  Nothing special there.  Now I will advise if you are upgrading, word to the wise uninstall the old version before installing the new.

When using MCEBoddy there are a number of components that work with MCEBuddy.  Namely Comskip since we're dealing with the focus of this rambling.  Comskip is a free program and is already housed within MCEBuddy.  MCEBuddy gives you two choices for commercial skipping.  ShowAnalyzer and Comskip.  At the time of this writing to my knowledge ShowAnalyzer does not have any active support to continue the project.  Comskip however is actively supported.  You have the ability to purchase a donated version for $10 or more which gives you access to a version that supports .wtv and will also process it faster.  For this purpose if you want to scan your .wtv files and determine where the commercials are within your video and trouble shot you will have to purchase the donator version of Comskip.  I donated and received my login and password promptly.  The author does state that this is a manual process and could take time to receive.

The research that I have done has been merely web related of what I could figure out.  Bare in mind I am not an expert in this field by any stretch of the mind so proceed at your own risk.  Now Comskip has a number of helpful pages available to describe the different options available.  Setting up... I decide to create a directory on my MC and copied a test .wtv file.


I felt the TMZ show was pretty difficult to narrow down the commercials and remove.  Reason being there is a lot of fast pace video.  I have also extracted my donator Comskip version.


The file of importance here is comskip.ini and the comskipgui.exe.  Notice I have made a copy of the comskip.ini and renamed it comskip.ini.orig.  This is merely to protect the original configuration file.  Additionally its nice to create a shortcut of the comskipgui.exe on the desktop.  This will easy our ability to drag and drop video file etc on to the program for faster processing.  You can download my comskip.ini from here with the mods already completed for TMZ.  Overwrite the existing comskip.ini.



By default the default comskip.ini does not produce the .log file that we need.  Modify or add the following lines within the comskip.ini.  Mine they already exist. The file is read linear so each line is read.  The ";" only comments out after input so dont start the line with read format ie. "; output_mls=0 ; blah blah" because it will be read first in and have the second line "output_mls=1 ; blah blah" because the =0 version will be the one assumed.  No spaces between the call = number.

verbose=10 (This should be 10 for available logging.  When complete we should make this 0 when in production mode.)

delete_logo_file=0 (This does not remove the .txt file of the logo rendition.)

output_framearray=1 (This is believe is the .csv file that is created.)

output_debugwindow=1 (This I believe is the GUI window to see the video.)

This is already done on my comskip.ini.


Now switch over to your test directory and drag and drop the .wtv video file onto your shortcut comskipgui.exe.  A window will appear processing the video to detect commercials.  Mind you this is the default comskip.ini with added logging or mine with mods depending on which one you used.



The color graph lines mean tested aspects of the video like audio, logo, and black screens.  Once the video has completed we can take a look at what was detected.

Default comskip.ini:


Notice the bar across the top of the window.  These are the recognized commercials.  This is however not completely correct.



Now I am focused on the second commercial area just to the right.  Notice the pink line, not horizontal but vertical.  This is my location in the video.  Now the screen shows clearly a commercial but the black and grey bar do not extend beyond indicating a commercial cut area.


Lets try to fix this by modifying some of the comskip.ini settings.  Close the graphic window above.  There will also be a command prompt windows behind and that needs to be closed as well.  Now I have done a little research into individual comskip.ini files that others have created here.

The first line is probably one of the most important.  I recommend only changing one thing at a time and than process the video again or at least the .csv file for faster output. I'll explain but lets modify the .ini first. and explain the numbering.

1=black frame, 2=logo, 4=scene change, 8=fuzzy logic, 16=closed captions, 32=aspect ration, 64=silence, 128=cutscenes, 255=all

The default is 43.  Clearly 43 is not listed.  This is merely an addition issue.  The closest number to 43 is 32 + 8 + 2 + 1 = 43.  So this means commercial detection is using aspect ration, fuzzy logic, logo, and black frame to detect commercials.

Now again doing some research on other peoples work here the FOX.ini detect_method=119.  That means:

64=silence
32=aspect ration
16=closed captions
4=secen change
2=logo
1=black frame
119 total

TMZ is a FOX program.

The only other line I modified was the min_show_segment_size=4 to 90.  Sometimes some commercials aren't recognized and that insists that when a commercial starts it will be at least 90 seconds long but could be longer.  Reason being was the point above and it did not detect a portion of the remaining commercials.

Now if you've used my comskip.ini just replace yours.  You still have a copy .orig.

Notice the files in your test area.  The important one now is the .csv file.  This file when added to comskipgui.exe shortcut will reprocess without having to go through all the video.  You only have to re-run the video if you change anything dealing with the logo or brightness.


Drag and drop the .csv file onto the comskipgui.exe.  It will process the video with the new conskip.ini.  Notice now the commericial area was originally like this:


Looks like this now at detect_method=119:


Looks like this now at detect_method=117 (without logo detection -2).  Note that logo detection is important in network shows.  Now for removing commercial in shows like Black Sails, STARZ.  Yes no commericials but you still want to remove the highlights before and after.  This would not require logo detection because there aren't any.


The logo in the case of TMZ is important.

Now this isn't fool proof but adjustments like this can make your commercial automated efforts better.  What I have notice is at the end of TMZ during the final credits the logo does not appear and confuses Comskip into thinking its still a commercial.  Notice the red box looking for the logo. Control+g removed the graphic lines bottom of the linked page.  F1 provides a legend.


I've found it very difficult to attempt and manipulate the settings to fix this ie. brightness, black screen, etc.  Ultimately I decide to keep the last 360 seconds of the show.  Remember I'm recording on time to on time.  Not any time extra before or after the show.


Now I've decide to do these config files for each show.  Others have done it via channel.  Reasons being that if for any reason these need to change I know that if the config file works with multiple then changing it wont effect the other shows.  So I decided one for one.  This will also minimize efforts under MCEBuddy as well later on.

Now that I think I have the comskip.ini file narrow down to a possible match what can I do with it now?

Time to add to MCEBuddy.  After installing MCEBuddy open the application.


The application will appear running like so.


To process our .wtv TMZ file or what ever show to decided to edit the comskip.ini file for.

Select --> Settings


Now you can see monitor location and conversion tasks already outline in my MCEBuddy.  Yours will be blank.

First lets set the monitor location.

Select --> Add


Monitor name --> Recorded TV

Monitor path --> [This is the location were your Recorded TV or .wtv files are located]

Search pattern --> [This is empty. You could put *.wtv but empty will search all]

OK

Now add a conversion task.



Task name --> TMZ [or whatever you comskip.ini file is for]

Profile --> MP4 HQ seems to work with all of my devices (360, Android, PS3, O!play, Sharp TV DLNA, etc)

Destination --> [decide where your output video file should go...I choose a separate hard disk drive (HDD) from the Recorded TV because it will read from the Recorded TV HDD and write to a separate HDD]

Remove ads --> Yes (Comskip)

OK

The TMZ task should be present.


Now I decided to store my comskip.ini files separate from MCEBuddy installation files as MCEBuddy is routinely upgraded.  So decide on a location and save.





Now from Conversion tasks window highlight your task and select --> Change



Select --> advance settings drop down


Enable custom file naming -->

1. %showname% S%season%E%episode% 

2. %showname% %airdayshort% %airday% %airmonthshort% %airyear%

I would recommend either way.  TMZ since its a weekday show doesn't record season and episode so date is a better way to say when the recording happened.

File name match --> TMZ*

Comskip INI --> [Locate your configuration file]


OK

OK

If you get the communication error message you will have to start over.  Unknown why this happens.


Select Start on MCEBuddy.


It should locate your TMZ recording(s) and start converting. This process takes a while for good quality video.  It ultimately matters on the recording either HD or SD and HD quality will take longer.


UPDATE 140228;

Had an issue with my operating system HDD not having enough space.  Its a 90GB SSD for speed.  It was reporting only 25GB of space left and American Idol 2hr show failed to convert.

c:\program files\MCEBuddy2x\log\mcebuddy.log

"Error Insufficient disk space using Conversion Task"

If your run into this problem you'll have to move the temporary location where the files can be processed by MCEBuddy to a larger HDD.

I moved mine to a separate HDD from the HDD that stores my Recorded TV (.wtv) files.

Modify here or within MCEBuddy.  g:\MCEBuddy_Temp was my location.


UPDATE 140320;

Posted the configuration files that I have been toying with for approximately a month.  If I update them I'll continue to post the new ones here.

https://drive.google.com/folderview?id=0B2ad8pKdMeSsaGF1aW5HV042WE0&usp=sharing