By Randy Carey on Wednesday, 04 July 2018
Posted in Technical Issues
Replies 3
Likes 0
Views 572
Votes 0
After some research, it appears that the assets being pulled from S3 are on an S3 account owned by a previous (and now defunct) company. They are not stored on my client's S3 account. Apparently, for the time being, that S3 account is still active and allowing my client's site to access those assets. However, my client reports that, because the previous company no longer is open for business, they have no way to reconnect with the previous company nor to log in to this S3 account.

[A] Is there a way to pull the assets from the current S3 account (for which we do not have login access) back into the web server?

[B] Could you tell me what db table contains info as to which items are on S3 instead of on the local server? I would like to query the db to see how many items are out there, and to know when I have everything. I know that only some images/documents are on that S3 account while others are still on the server, so I assume there is someway that the web pages know whether to reference either S3 or the local server.

[C] For what it is worth, people previous to me have pushed some images to two other S3 buckets on the client's S3 account. Because EasySocial expects only one bucket, some links are broken. Do you have any recommendation for how to merge all of these assets into one location (be that the local server or on S3 bucket)?
[A] Is there a way to pull the assets from the current S3 account (for which we do not have login access) back into the web server?

Yes, that is possible to fetch back those data from Amazon S3 to your web server.
1. setup cronjob on your server https://stackideas.com/docs/easysocial/administrators/cronjobs
2. set these storage location to 'local server' from backend setting http://take.ms/TUYH0
3. when the cronjob kick in, it will fetch data from Amazon S3 to your web server, but it need more time to process this.


[B] Could you tell me what db table contains info as to which items are on S3 instead of on the local server? I would like to query the db to see how many items are out there, and to know when I have everything. I know that only some images/documents are on that S3 account while others are still on the server, so I assume there is someway that the web pages know whether to reference either S3 or the local server.

You can check following tables under the `storage` column.
1. Videos - #__social_video
2. Links image - #__social_links_images
3. Photos - #__social_photos
4. Avatars - #__social_avatars
5. Files - #__social_files
6. Audios - #__social_audios

If `storage` column stored it as 'amazon' , mean this media file already pushed to Amazon S3.
If `storage` column stored it as 'joomla' , mean this media file still under your web server.

[C] For what it is worth, people previous to me have pushed some images to two other S3 buckets on the client's S3 account. Because EasySocial expects only one bucket, some links are broken. Do you have any recommendation for how to merge all of these assets into one location (be that the local server or on S3 bucket)?

Hm, it seems like this a little bit tricky and currently i do not have experience for this.

Based on what i think, first try to pull back any media file from Amazon S3 under this current S3 bucket.

Once you done this, then set it up back your second S3 bucket info from backend Easysocial storage setting part.

Before you setup this again, you have to make sure those those broken image link is it still exist on second S3 bucket, i mean those media storage path location.
e.g. ../media/com_easysocial/photos/2/1/image.jpg

If match and this media data `storage` value still stored it as 'amazon' from your database, i believe it still possible to pull back those media file from Amazon S3 to your webserver.
·
Wednesday, 04 July 2018 13:09
·
0 Likes
·
0 Votes
·
0 Comments
·
Thanks, Arlex. This is the info I was looking for! I will start to work on these.

Knowing your answer to [A], I think your suggested solution to [C] is one that will work.
·
Wednesday, 04 July 2018 19:23
·
0 Likes
·
0 Votes
·
0 Comments
·
You're most welcome.
·
Wednesday, 04 July 2018 19:24
·
0 Likes
·
0 Votes
·
0 Comments
·
View Full Post