Change filestore and resources

[J. Manuel Velasco]

Hello,

I am working on an upgrade from an old RS version. I am now at the point I want to move the data from the old installation to the upgraded one.
Anyone has done this work before? Is there some tools ready for that? I hear/read about migration tools, but not sure about what is the way to do it.

I will keep looking into it but in the mean time I will appreciate any hint from someone who knows how to safely do it.

Thanks in advance.

[R Snider]

Hi Manuel,

It kind of depends on what you're upgrading.

There's the Resourcespace web application which lives on your server, there's the database and there's the filestore (which may or may not live on your server).

Export your database via the Admin/System/Export Data and create a backup of your filestore before you do anything.

Import the database to the new SQL server and adjust your database connection in your includes/config.php, point to your filestore, and you should be all set.

Obviously, there's things like permissions to sort out to make sure you can upload to the new filestore – again, it depends on what you're doing.

Cheers.

Rob

[J. Manuel Velasco]

Hi Rob, thanks for your reply. I have followed these steps:

1. dump both databases (old installation and current)
2. update the database attached to the latest RS version by the one from the old installation
3. run the update scripts (/upgrade/upgrade.php) (needed to convert RS into the new nodes architecture)
4. set the scramble global parameter at config.php to the same value it has at the old installation. This is needed to create the right paths for the filestore
5. update the filestore virtualpath at IIS by the new one and also update the symbolic link in the file system

Then I have had to work a little bit in the admin interface since the database has not all the settings I had, for example colors for the nav-header, display options for some metadata fields,...

From your reading I feel curious about the filestore not living on my server. I have not played too much with staticsync since I thougt that was to use a custom folder out from the RS application as filestore, not to be able to have the filestore kept in machine. I am going to investigate that, have you successfully set up the following scenario?

box1: hosting RS application under IIS and MySQL
box2: keep the filestore (transcoding process - ffmpeg - will be executed on this machine)

[R Snider]

Hi Manuel,

My situation is as follows:

Internal box running Ubuntu with Apache, PHP & MySQL with Resourcespace. I've installed all the modules for dependencies like ffmpeg, ghostscript etc. on this box, so all processing is done on this server setup.

My filestore is hosted on our local network, outside my server. I've set up an alias as outlined on the wiki. I did however have difficulty with permissions when writing to the filestore on my setup (I solved this by commenting out some php that was trying to chmod a directory/file after it was created – see some of my previous posts to this group.) I haven't used staticsync for this – I do all file management via Resourcespace.

I'm not sure if you could install the binaries for modules on a separate machine – I believe the php calls the binary directly, so I believe it would have to be on the same machine that's hosting/running the DAM. Maybe someone else has had success pushing the transcoding/preview generation to another machine and can let us know?

Cheers.

Rob

[J. Manuel Velasco]

Hi Rob, thanks for the follow up.

Yes, a mounted file system will work always the web server reaches that folder. It could be a NFS or windows network unit, mounted partition, ... That is fine. My idea is to use a storage in a different machine so I can let the ffmeg workload to that machine and keep the web server resources free to server the web. I thought maybe staticsync is made for that, but not sure. I haven't had time yet to look at it slowly.

Regarding your permissions issues, I already had some in the past too, but our RS is stored in a windows box. Reviewing the permissions defined for the folder might solve this kind of issues. To hack the core of RS is not advised, if you want to upgrade it at some point in the future to add some new feature from Montala and/or fix some bug you won't be able to do it without losing your custom changes. You will always find the way to do it with the help of diff and similar commands, but it will be hard to keep everything synchronized.

I am not sure to understand what you mean with install binaries ...

My idea to have the transcoded in another machine is transfer the files between machines. It is the only way I have in mind, but as you have said if staticsync can do the magic and someone around have the experience it will be great to know how to achieve that.

Cheers,

·_-

--
ResourceSpace: Open Source Digital Asset Management
http://www.resourcespace.com
---
You received this message because you are subscribed to the Google Groups "ResourceSpace" group.
To unsubscribe from this group and stop receiving emails from it, send an email to resourcespace+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[R Snider]

Hi Manuel,

The problem I encountered was a chmod call to a file that Resourcespace created. My networked fileserver has a particular setup that was having difficulty with the chmod call which seems odd since the directory was created by Resourcespace in the first place. I've had no problem upgrading with SVN and merging my change.

Sorry, I just calling them binaries (I'm using a Unix box), but they're the modules that you require for the transcoding and other functionality of Resourcespace (ffmpeg, ghostscript, etc.)

The only problem with pushing off the transcoding to a separate machine is the way Resourcespace is set up to do it. I believe ffmpeg_processing.php makes the command line call to generate the preview files and add the records to the database.

I would imagine you *could* push processing off to another machine if you used staticsync for keeping track of the files in Resourcespace, but you would have to set up a means for ffmpeg to transcode the files, like a script or a watched folder.

Best of luck.

Rob.

To unsubscribe from this group and stop receiving emails from it, send an email to resourcespac...@googlegroups.com.