Microsoft ups the BI game

powerbissrs2

Microsoft is trying to give the other “on-Demand” Business Intelligence vendors a run for their money.  The enterprise folks didn’t give Power-BI a second glance when they leanered the only way to publish was to the cloud.  Cloud = Bad.   There was talk of SSRS being able to be the portal for all things Power-BI and now some if this has come true.

Microsoft has an Azure appliance that you can “play with” while Microsoft tunes things up.  I think this is going to be a look-see for me in the near future.  I will post what I find.

nextCloud upgrade to Version 10 on Bluehost.

NextCloudBlueHost.pngWe are running a nextCloud V9 instance on our BlueCloud shared hosting.  We use SSH to do most of work on this shared server.  One thing I miss is that SUDO is not allowed.  This makes the nextCloud Update application unusable.  The Updater app automates many of the steps of upgrading an nextCloud installation. It is useful for installations that do not have root access, such as shared hosting, for installations with a smaller number of users and data.

So it’s off to the manual upgrade method.  Backups, can I repeat that “Backups”.  The applications, database, documents and settings.  The database and documents backups should be done more frequently than when a new nextCloud update comes along.

Backup scenarios

FileZilla

You can do your backups from a Windows system and just use FileZilla to connect to the BlueHost and copy the files someplace secure.  It is even possible to set up a SFTP connection and use a key file to better secure this scenario.  However this isn’t as automatic or as scheduled as I want.

CGYWIN and RSYNC

If you are a Linux diehard using a Windows workstation you might have a Linux like environment called CGYWIN set up where you can run your standard Linux RSYNC command.  I like this approach as it allows for scheduled backups and could be run from with your Windows environment or Linux environment.  Most Windows folks I know don’t have CGYWIN installed or understand the somewhat complex options for the Linux RSYNC command.

Free FileSync

Free File Sync is an Open source, cross platform GUI based tool for doing and scheduling backups.  I have used RoboCopy and SyncToy and find that FreeFileSync us much better.  The UI is a little dated. like something from the 80’s, but it is a solid functional tool.

Bluehost SSH

To connect to our nextCloud document directory we need to use a SFTP connection to the BlueHost.  SFTP is not turned on by default and to turn it on you will need SSH access to your Bluehost account.  Now this sounds like a pain but it is something you should have configured if you are managing your Bluehost server correctly.  Bluehost has a good article on getting SSH access configured.

BlueHost SFTP

For a more secure FTP client upload, use SFTP (Secure File Transfer Protocol port 22).You will need to enable SSH/Shell access on your account. If you do not already have SSH/Shell access, Click Here to learn how.  Note: Only your main FTP/cPanel username can be used for SFTP access. FTP accounts created using the FTP Accounts tool will not work.  We use FileZilla just to verify the SFTP we set up works correctly.  I wished that we could use our SSH keys to secure the connection.

NextCloud document directory

If you followed the nextCloud installation instructions you have put the place where the documents are stored NOT in or under the public_html directory where web hackers can get to it.  It’s a good idea to create a special directory under the BlueHost root directory (ie: nextCloud).

nextCloud01.png

So lets start up FreeFileSync from the Windows start menu and start to configure a backup scenario.  The left panel is where the data is COMING FROM.  In this case it is the BlueHost system.

ffs01.png

Then we can provide the creditentials for the SFTP connection, remember they are identical to BlueHost control panel creditentials.

ffs02.png

Use the (Browse) button.  1. It will test if your creditentials are correct and 2. Make it much easier to local the exact named nextCloud document directory.

ffs03.png

Then we need to tell Free File Sync the TO DIRECTORY where the nextCloud document files will be backed up to.

ffs04.png

We should tell Free File Sync how we want this scenario to function, so click on the big Blue Compare (Gear) ICON.

ffs05.png

Start with how File Sync will compare what is on BlueHost agsint where our backup is.\

ffs06.png

Then tell Free File Sync you want to compare everything.

ffs07.png

Lastly explain you want to update everything on the DESTINATION (TO) right hand side of the page.

ffs08.png

Now we should compare the differences, since this is the first time I ran this everything will be differnt.

ffs09.png

ffs10.jpg

 

What we have been waiting for folks….

 

 

 

ffs11.png

Now the Sync process begins and the little man at the top of the form starts to dig.  Don’t understand why digging is associated with synchronization but…

ffs12.png

In God We Trust, everything else we verify, so lets do the (Compare) again.

ffs13.png

Now it would be a good idea to save this scenario also known as a (ffs_gui).  This file can used with the Coomand Line version of Free File Sync and either a PowerShell or CMD script to schedule it.

ffs14.png

Because I have a lot of things I sync up I’ve come up with a naming standard.

Server_Application_DataContent.ffs_gui
So the Free File Sync config file named  BlueHost_NextCloud_Documents.ffs_giu

BlueHost – Server
nextCloud – Application
Dcouments – Data Content

Summary: Yea I know this is a lot that is not directly related to getting Version 10 of nextCloud upgraded, but backups are important.  Free File Sync can help reduce the headache associated with doing backups, maybe you might actually do them more often!

Free File Sync is available on Windows, MAc and Linux.  Microsoft Powershell is available on Windows, Mac and Linux, do you see a pattern here?

nextCloud Application directory

The nextCloud instructions indicate you only need to back up certain directories.  I’m going to do the entire directory because I would end up missing one of required directories.