Hi Mike, I understand sometimes communication with CB is very hard.

I am thinking of a work-around, not perfect solution but acceptable.

What I suggest is to implement (in my case) a generic search and replace function because I assume when your S3 move is completed all files are moved to S3, therefore it would be safe to replace all references to where they originally were stored.

So I would foresee the following scenario working:

1) Video and photo files are moved to S3 every 5 minutes
2) When completed, all Simgallery text references within the databases are searched and replaced to reflect the move (not taking in to account which files were actually moved)
3) There is a small risk that files that were not moved yet will display broken link because of the search and replace, but acceptable because that will be fixed in the next 5 min run.

Hope my scenario is clear Mike? show less

Btw Mike, I assume when you move the files to S3, you update tables in the database already to point to the new location? So we could extend that query? show less

OK cool, so immediately after the cron job is triggered the SQL action should be launched. Can it easily be added to the cron job? the SQL statement I showed you earlier could do the trick? Maybe it should be a bit more refined? show less

Would there be a way to launch from your php script the following query for example:

UPDATE `w20zb_comprofiler_plugin_activity` SET message = REPLACE(message, 'old.domain.com', 's3-eu-west-1.amazonaws.com') WHERE INSTR(message, 'old.domain.com') > 0; show less

I believe there are 2 possibilities:
1) Auto Actions which you can use for that purpose..
https://www.joomlapo[...]cb-auto-actions
2) Direct writing to the database tables, would it not be as easy as search and replace? show less

Hi Mike, just a quick question, how far are you on getting the issues resolved? Can I help with additional product/UAT tests? show less

Hi Mike, it looks like the CB Activity streams are not updated after the files are moved to the S3 location. Do you want me to test the photo albums as well? Or do you think these have the same issues? show less

Hi Mike, I think I found out for you why files are not played correctly via the S3. You need to set the correct content type...for example Content Type: video/mp4 when copying the mp4 file. Hope this helped you resolving it. https://foliovision.[...]mazon-mime-type show less

Hi Mike, the tumbnail images within the Activity stream are not being updated and showing up as broken images...they all point to the old original file locations. show less

Hi Mike, I have update the security policy on the bucket itself to explicitly deny everyone..so this security setting is resolved. Thanks show less

Hi Mike, I just tested. The background images are working correctly, same as youtube vids. But the uploaded videos are not playing, but downloading as a file instead. show less

Hi Mike, I cant get the FTP account working with write access. Thats because of ownership of the files and who is running under which account. FTP server is a different user and group as the web server. I am not sure how others setup their FTP accounts. Linux is very strict on ownerships of files. show less

Hi Mike, thanks for the updates. I have tested 31+32 but you must have missed something. After installing the update(I installed only the com_simgallery) I have the new SSL and end point configurations. I have updated the configuration and saved it (btw, Save and Close button still gives me errors). I tried to upload the video's youtube and self-hosted. That went OK. After running the cronjob and checking the video and background image sources, the URL's are still written with the old configuration and not working. You can check yourself logging in with the test profile danny... show less

Issue 29 is solved. Thanks show less

issue 34: There is no security at all launching the cron job via the browser (pasting the full url) It executes fine but this is a big security flaw. Anyone pasting this URL will be able to launch the cron job. show less

Issue 33: There is something wrong with the cron job command as displayed within Simgallery configuration page. I get an error: wget: invalid option -- '0' show less

Issue 32: On the amazon bucket i have enabled a security policy that only files can be accessed when a particular referrer is used (my website). However, this is overridden when the files are copied to the bucket, all files are downloadable by Everyone. show less

Issue 31: I have enabled Amazon s3 (for video only for now...)but I think your script is creating by default URL's for the US region, but my buckets are in the Europe region: https://s3-eu-west-1.amazonaws.com. The files are copied just fine within the correct bucket so I think only the URL creation has an issue?. show less

Hi Mike, for issue 30, on our site it is not supposed to see anything but the homepage for non logged in users. How can I protect SimGallery from being used by non logged in users. Even when an album is defined as public it means public for all logged in users only, not public to the Internet (guests) show less

Hi Mike, are you looking at issues 28, 29 and 30? Havent had a reply for a week now.
Anyway, more issues found:
Issue 31: Adding an uploaded video now fully works, but the video link thats added to the activity stream gets a 404 page.
Issue 32: When going to the video album, opening the uploaded video it launches the full website in a new frame. The videos added via the URL option works as it should. show less