[SAC] [OSGeo] #2406: Setup picture gallery to replace flickr

#2406: Setup picture gallery to replace flickr
---------------------------+-----------------------
Reporter: robe | Owner: sac@…
     Type: task | Status: new
Priority: normal | Milestone: Unplanned
Component: Systems Admin | Keywords:
---------------------------+-----------------------
I set up an lxd container on osgeo3 called gallery which will hopefully be
new home for our past flickr pictures.

Brian Hamlin has script pulling the pictures from flickr and spearheading
the setup.

What is being setup is prism a photo gallery app written in golang -
GitHub - photoprism/photoprism: AI-Powered Photos App for the Decentralized Web 🌈💎✨

Once it's ready for prime time, we'll expose as gallery.osgeo.org which
apparently is a domain that once existed as it seems to resolve to
140.211.15.68 (got to check what that was)

--
Ticket URL: <https://trac.osgeo.org/osgeo/ticket/2406&gt;
OSGeo <Gter - OSGeo;
OSGeo committee and general foundation issue tracker.

#2406: Setup picture gallery to replace flickr
---------------------------+------------------------
Reporter: robe | Owner: sac@…
     Type: task | Status: new
Priority: normal | Milestone: Unplanned
Component: Systems Admin | Resolution:
Keywords: |
---------------------------+------------------------

Comment (by neteler):

Replying to [ticket:2406 robe]:
> Once it's ready for prime time, we'll expose as gallery.osgeo.org which
apparently is a domain that once existed as it seems to resolve to
140.211.15.68 (got to check what that was)

It was a kind of user story gallery, see here:
https://web.archive.org/web/20091223033534/http://gallery.osgeo.org:80/

--
Ticket URL: <https://trac.osgeo.org/osgeo/ticket/2406#comment:1&gt;
OSGeo <https://osgeo.org/&gt;
OSGeo committee and general foundation issue tracker.

#2406: Setup picture gallery to replace flickr
---------------------------+------------------------
Reporter: robe | Owner: sac@…
     Type: task | Status: new
Priority: normal | Milestone: Unplanned
Component: Systems Admin | Resolution:
Keywords: |
---------------------------+------------------------

Comment (by robe):

okay found remnants of old gallery on old-webextra container. It was only
in available sites and not in enabled, so assume it's been dead for a
while. Repointing that now to osgeo4.

Looks like it was somesort of django app and I see a bunch of pictures
from it in
osgeo7-old-webextra - /var/www/gallery/old/gallery-site

--
Ticket URL: <https://trac.osgeo.org/osgeo/ticket/2406#comment:2&gt;
OSGeo <https://osgeo.org/&gt;
OSGeo committee and general foundation issue tracker.

#2406: Setup picture gallery to replace flickr
---------------------------+------------------------
Reporter: robe | Owner: sac@…
     Type: task | Status: new
Priority: normal | Milestone: Unplanned
Component: Systems Admin | Resolution:
Keywords: |
---------------------------+------------------------

Comment (by robe):

We are still working on pulling the picks but repointed gallery

https://gallery.osgeo.org/

so it's now using the photoprism thing. We are still working out how all
this works.

--
Ticket URL: <https://trac.osgeo.org/osgeo/ticket/2406#comment:3&gt;
OSGeo <https://osgeo.org/&gt;
OSGeo committee and general foundation issue tracker.

#2406: Setup picture gallery to replace flickr
---------------------------+------------------------
Reporter: robe | Owner: sac@…
     Type: task | Status: new
Priority: normal | Milestone: Unplanned
Component: Systems Admin | Resolution:
Keywords: |
---------------------------+------------------------
Comment (by robe):

adding notes from --
https://lists.osgeo.org/pipermail/sac/2022-August/014526.html

----
Dear SAC members,

during FOSS4G 2022 we collected several pictures that we would like to
share with the community. Before flick was used but now the license
changed and it is not possible anymore.

Could be possible to set up a service to share these photos.
I found few possible candidates:
- Nextcloud (OSGeo already have a running instance)
- Piwigo https://piwigo.org/
- LibrePhoto https://github.com/LibrePhotos/librephotos
- Lychee https://github.com/LycheeOrg/Lychee

I would like to have any feedback from your side.

Thanks a lot

--
ciao
Luca

----

As a note we did setup https://gallery.nextcloud.osgeo.org with plans to
store photos there. Not sure how far that got.
--
Ticket URL: <https://trac.osgeo.org/osgeo/ticket/2406#comment:4&gt;
OSGeo <https://osgeo.org/&gt;
OSGeo committee and general foundation issue tracker.

#2406: Setup picture gallery to replace flickr
---------------------------+------------------------
Reporter: robe | Owner: sac@…
     Type: task | Status: new
Priority: normal | Milestone: Unplanned
Component: Systems Admin | Resolution:
Keywords: |
---------------------------+------------------------
Comment (by strk):

https://pixelfed.org/ is also to be considered
--
Ticket URL: <https://trac.osgeo.org/osgeo/ticket/2406#comment:5&gt;
OSGeo <https://osgeo.org/&gt;
OSGeo committee and general foundation issue tracker.

#2406: Setup picture gallery to replace flickr
---------------------------+------------------------
Reporter: robe | Owner: sac@…
     Type: task | Status: new
Priority: normal | Milestone: Unplanned
Component: Systems Admin | Resolution:
Keywords: |
---------------------------+------------------------
Comment (by robe):

Replying to [comment:5 strk]:
> https://pixelfed.org/ is also to be considered

Looks like repo here. https://github.com/pixelfed/pixelfed

Has anyone tried this one and have an opinion?

At a glance looks like it has

1) Supports LDAP integration

https://docs.pixelfed.org/running-pixelfed/optional-features/ldap-
authentication/

2) Supports PostgreSQL

https://docs.pixelfed.org/running-pixelfed/prerequisites/

3) allows for federation, I assume that is why it's called Fed
--
Ticket URL: <https://trac.osgeo.org/osgeo/ticket/2406#comment:6&gt;
OSGeo <https://osgeo.org/&gt;
OSGeo committee and general foundation issue tracker.

#2406: Setup picture gallery to replace flickr
---------------------------+------------------------
Reporter: robe | Owner: sac@…
     Type: task | Status: new
Priority: normal | Milestone: Unplanned
Component: Systems Admin | Resolution:
Keywords: |
---------------------------+------------------------
Changes (by robe):

* cc: lucadelu (added)

Comment:

I'm going to start working on a new server for this and hopefully I will
succeed.

Luca,

Once I have it set up, I'll let you know so you can start uploading the
FOSS4G photos.
--
Ticket URL: <https://trac.osgeo.org/osgeo/ticket/2406#comment:7&gt;
OSGeo <https://osgeo.org/&gt;
OSGeo committee and general foundation issue tracker.

#2406: Setup picture gallery to replace flickr
---------------------------+------------------------
Reporter: robe | Owner: sac@…
     Type: task | Status: new
Priority: normal | Milestone: Unplanned
Component: Systems Admin | Resolution:
Keywords: |
---------------------------+------------------------
Changes (by jsanz):

* cc: jsanz (added)

--
Ticket URL: <https://trac.osgeo.org/osgeo/ticket/2406#comment:8&gt;
OSGeo <https://osgeo.org/&gt;
OSGeo committee and general foundation issue tracker.

#2406: Setup picture gallery to replace flickr
---------------------------+----------------------------------------
Reporter: robe | Owner: sac@…
     Type: task | Status: new
Priority: normal | Milestone: Sysadmin Contract 2022-II
Component: Systems Admin | Resolution:
Keywords: |
---------------------------+----------------------------------------
Changes (by strk):

* milestone: Unplanned => Sysadmin Contract 2022-II

--
Ticket URL: <https://trac.osgeo.org/osgeo/ticket/2406#comment:9&gt;
OSGeo <https://osgeo.org/&gt;
OSGeo committee and general foundation issue tracker.

#2406: Setup picture gallery to replace flickr
---------------------------+----------------------------------------
Reporter: robe | Owner: sac@…
     Type: task | Status: new
Priority: normal | Milestone: Sysadmin Contract 2022-II
Component: Systems Admin | Resolution:
Keywords: |
---------------------------+----------------------------------------
Comment (by lucadelu):

Replying to [comment:7 robe]:
> I'm going to start working on a new server for this and hopefully I will
succeed.
>
> Luca,
>
> Once I have it set up, I'll let you know so you can start uploading the
FOSS4G photos.

Ok, I'm a little bit worried because pixelfed seems one-man-show project.

Thanks for your support
Luca
--
Ticket URL: <https://trac.osgeo.org/osgeo/ticket/2406#comment:10&gt;
OSGeo <https://osgeo.org/&gt;
OSGeo committee and general foundation issue tracker.

#2406: Setup picture gallery to replace flickr
---------------------------+----------------------------------------
Reporter: robe | Owner: sac@…
     Type: task | Status: new
Priority: normal | Milestone: Sysadmin Contract 2022-II
Component: Systems Admin | Resolution:
Keywords: |
---------------------------+----------------------------------------
Comment (by darkblueb):

stage one flickr project contents

{{{
@gallery:/home/shared/OSGeo/flickr_works$ ls
1990381@N20.info d0_lastzero flickcurl_dl_group.sh
grp_osgeonl
2244553@N22.info d_agnesoli flickcurl_dl_set.sh
grp_osgeopt
2728498@N23.info d_astrid flickcurl_getInfo_group.sh
grp_photos_info2.csv
2747640@N22.info d_ebatty flickcurl_help.txt
grp_qgissc
2840621@N22.info d_gstein flickcurl_man.txt
lic_texts.csv
2926401@N22.info d_jodygarnett g_eu
mmtrackoutRR.txt
2943065@N20.info d_justb4 g_osgeo
oHBjfx.html
3522675@N24.info d_mloskot grp_ec15
olic_groups.csv
3720585@N20.info d_msilikale0 grp_foss4geu
osgeo_pics_lic.csv
697379@N25.info d_ominiverdi grp_foss4g_ko14
pinfo_rsing.txt
a2020.txt d_ortelius grp_foss4gna
py2_misc
alb_foss4g15ko d_osgeo grp_foss4gna18
some_lic_counts.txt
alb_foss4g2008_costa downloads grp_ko15
test0.txt
alb_foss4g2008_crschmidt d_rajsingh grp_osgeo
alb_fossgis16 d_spatialguru grp_osgeolive
backup_flickr.py d_stevenfeldman grp_osgeo_nl

}}}
--
Ticket URL: <https://trac.osgeo.org/osgeo/ticket/2406#comment:11&gt;
OSGeo <https://osgeo.org/&gt;
OSGeo committee and general foundation issue tracker.

#2406: Setup picture gallery to replace flickr
---------------------------+----------------------------------------
Reporter: robe | Owner: sac@…
     Type: task | Status: new
Priority: normal | Milestone: Sysadmin Contract 2022-II
Component: Systems Admin | Resolution:
Keywords: |
---------------------------+----------------------------------------
Comment (by robe):

I'm still working on setting this up.

I have it here:

https://photo.osgeo.org

but troubleshooting why the ldap integration isn't working
--
Ticket URL: <https://trac.osgeo.org/osgeo/ticket/2406#comment:12&gt;
OSGeo <https://osgeo.org/&gt;
OSGeo committee and general foundation issue tracker.

#2406: Setup picture gallery to replace flickr
---------------------------+----------------------------------------
Reporter: robe | Owner: sac@…
     Type: task | Status: new
Priority: normal | Milestone: Sysadmin Contract 2022-II
Component: Systems Admin | Resolution:
Keywords: |
---------------------------+----------------------------------------
Comment (by strk):

I've created a https://wiki.osgeo.org/wiki/Gallery page with what we had
in https://wiki.osgeo.org/wiki/SAC_Service_Status#gallery

Regina I think that's the place to document what we have
--
Ticket URL: <https://trac.osgeo.org/osgeo/ticket/2406#comment:13&gt;
OSGeo <https://osgeo.org/&gt;
OSGeo committee and general foundation issue tracker.

#2406: Setup picture gallery to replace flickr
---------------------------+----------------------------------------
Reporter: robe | Owner: sac@…
     Type: task | Status: new
Priority: normal | Milestone: Sysadmin Contract 2022-II
Component: Systems Admin | Resolution:
Keywords: |
---------------------------+----------------------------------------
Comment (by robe):

Okay I created a new entry after --
https://wiki.osgeo.org/wiki/SAC_Service_Status#pixelfed

We can decide later how to document what we have. I'm not using the
current gallery since it has a lot of scraping tools and extra stuff.
Once it's set up, we can migrate the photos over to pixelfed
--
Ticket URL: <https://trac.osgeo.org/osgeo/ticket/2406#comment:14&gt;
OSGeo <https://osgeo.org/&gt;
OSGeo committee and general foundation issue tracker.

#2406: Setup picture gallery to replace flickr
---------------------------+----------------------------------------
Reporter: robe | Owner: sac@…
     Type: task | Status: new
Priority: normal | Milestone: Sysadmin Contract 2022-II
Component: Systems Admin | Resolution:
Keywords: |
---------------------------+----------------------------------------
Comment (by robe):

Update I have ldap working, but still some kinks to work out.

You should be able to log in https://photo.osgeo.org using the email
address you have registered with your osgeo account.

The issues uncovered, thanks Brian Hamlin for testing :slight_smile:

1) Admin mode, seems to require another password, I think it's probably an
outstanding ldap issue, cause LDAP is pretty new feature on pixelfed

2) Mail is not sending

3) When you like a post or follow someone, that doesn't seem to work

Replying to [comment:10 lucadelu]:
> Replying to [comment:7 robe]:
> > I'm going to start working on a new server for this and hopefully I
will succeed.
> >
> > Luca,
> >
> > Once I have it set up, I'll let you know so you can start uploading
the FOSS4G photos.
>
> Ok, I'm a little bit worried because pixelfed seems one-man-show
project.
>
> Thanks for your support
> Luca

Yah I'm a bit concerned about that too and the fact it has not reached
1.0, but does have over 100 contributors which looks promising, and jsanz
has used it and liked it.

Nextcloud is still on the table -- the most mature of all (and we have
already running with LDAP/Postgres etc), but I feel it does too much so
you'd get lost trying to find the photos.

https://github.com/LycheeOrg/Lychee - This one looks good, sports PHP 8,
supports PostgreSQL.
It uses a lot of the same dependencies as pixelfed (and is Laravel based
just like pixelfed), so if pixelfed doesn't pan out, Lychee would be my
next bet, since I can easily reuse all the setup I did for pixelfed. It
however doesn't seem to have LDAP support, but since it's laravel based, I
can probably inject LDAP in there. The work pixelfed did for LDAP was
mostly just requiring the laravel ldap plugin and still required some
manual change of code to work.

https://github.com/LibrePhotos/librephotos looks good - has some
compelling features I don't see in the others, supports PostgreSQL, offers
a docker container. Cons: Seems to lack LDAP support and it too appears to
be a 1 man show.

https://github.com/Piwigo/Piwigo -things I don't like about it: lacks LDAP
support, is MySQL based, feels kind of old given they are focussed on PHP
5 and 7 with not even a mention of 7.3 or 7.4
on the plus not a one man show and has been around for a while.
--
Ticket URL: <https://trac.osgeo.org/osgeo/ticket/2406#comment:15&gt;
OSGeo <https://osgeo.org/&gt;
OSGeo committee and general foundation issue tracker.

#2406: Setup picture gallery to replace flickr
---------------------------+----------------------------------------
Reporter: robe | Owner: sac@…
     Type: task | Status: new
Priority: normal | Milestone: Sysadmin Contract 2022-II
Component: Systems Admin | Resolution:
Keywords: |
---------------------------+----------------------------------------
Comment (by lucadelu):

Replying to [comment:15 robe]:
> Update I have ldap working, but still some kinks to work out.
>
> You should be able to log in https://photo.osgeo.org using the email
address you have registered with your osgeo account.
>
> The issues uncovered, thanks Brian Hamlin for testing :slight_smile:
>
> 1) Admin mode, seems to require another password, I think it's probably
an outstanding ldap issue, cause LDAP is pretty new feature on pixelfed
>
> 2) Mail is not sending
>
> 3) When you like a post or follow someone, that doesn't seem to work
>

I did some test, I can confirm 3 and also I was not able to add any image
to a collection.

>
> Yah I'm a bit concerned about that too and the fact it has not reached
1.0, but does have over 100 contributors which looks promising, and jsanz
has used it and liked it.
>

yes I agree, however it looks like a social network more than a service to
share images

> Nextcloud is still on the table -- the most mature of all (and we have
already running with LDAP/Postgres etc), but I feel it does too much so
you'd get lost trying to find the photos.
>

I would like to give him a chance, it is already working in OSGeo
infrastructure, it seems that is it possible to connect different folder.
It's quite simple to use, I don't know how could be improved for
visualization, there could be some app to test
--
Ticket URL: <https://trac.osgeo.org/osgeo/ticket/2406#comment:16&gt;
OSGeo <https://osgeo.org/&gt;
OSGeo committee and general foundation issue tracker.

#2406: Setup picture gallery to replace flickr
---------------------------+----------------------------------------
Reporter: robe | Owner: sac@…
     Type: task | Status: new
Priority: normal | Milestone: Sysadmin Contract 2022-II
Component: Systems Admin | Resolution:
Keywords: |
---------------------------+----------------------------------------
Comment (by robe):

Replying to [comment:16 lucadelu]:
> Replying to [comment:15 robe]:

> > Nextcloud is still on the table -- the most mature of all (and we have
already running with LDAP/Postgres etc), but I feel it does too much so
you'd get lost trying to find the photos.
> >
>
> I would like to give him a chance, it is already working in OSGeo
infrastructure, it seems that is it possible to connect different folder.
It's quite simple to use, I don't know how could be improved for
visualization, there could be some app to test.

Luca -- so we have two instances

https://nextcloud.gallery.osgeo.org (on osgeo3 but it's older and needs
updating)

https://nextcloud.osgeo.org #this one is a little slow cause we are having
network issues with osgeo7, which hopefully will be resolved once the new
OSUOSL LinkOregon line is in place.

Can you upload some of the foss4g photos to one and see how you like it.
You should be able to get in fine with your osgeo account on both. Both
instances have over 500GB of space.
--
Ticket URL: <https://trac.osgeo.org/osgeo/ticket/2406#comment:17&gt;
OSGeo <https://osgeo.org/&gt;
OSGeo committee and general foundation issue tracker.

#2406: Setup picture gallery to replace flickr
---------------------------+----------------------------------------
Reporter: robe | Owner: sac@…
     Type: task | Status: new
Priority: normal | Milestone: Sysadmin Contract 2022-II
Component: Systems Admin | Resolution:
Keywords: |
---------------------------+----------------------------------------
Comment (by robe):

Oh another list of options was mentioned on osgeo sac

https://docs.librephotos.com/2/features/
--
Ticket URL: <https://trac.osgeo.org/osgeo/ticket/2406#comment:18&gt;
OSGeo <https://osgeo.org/&gt;
OSGeo committee and general foundation issue tracker.

#2406: Setup picture gallery to replace flickr
---------------------------+----------------------------------------
Reporter: robe | Owner: sac@…
     Type: task | Status: new
Priority: normal | Milestone: Sysadmin Contract 2022-II
Component: Systems Admin | Resolution:
Keywords: |
---------------------------+----------------------------------------
Comment (by robe):

@lucadelu -- I went back to the work darkblueb did with photoprism and
scraping all those pictures, great work Brian :slight_smile:

Photoprism is the best photo gallery wise I think, however the user
management is very immature. Only allows one user. I'm still trying to
figure out how to make display public without logging in.

However I discovered it does have a webdav interface so I created a group
folder called photoprism-sync on our https://nextcloud.osgeo.org.

I've just added you as a user of that folder, so you should see the
folder, in your home folder when you log into nextcloud. Can you create a
folder in that group folder for the pictures you have and throw all of
them in.

I did a test run and did see photoprism pick them up.
--
Ticket URL: <https://trac.osgeo.org/osgeo/ticket/2406#comment:19&gt;
OSGeo <https://osgeo.org/&gt;
OSGeo committee and general foundation issue tracker.