21 Feb
2019
21 Feb
'19
4:21 p.m.
Hi,
Am Do., 21. Feb. 2019 um 15:32 Uhr schrieb Lars Vogdt
<Lars.Vogdt(a)suse.com>om>:
As such, maintaining 447 [1] openSUSE members should not depend on a
single tool. Especially not if the used tool has open, well known
security issues since years[2].
On Thu, 21 Feb 2019 11:41:19 +0100 Richard Brown wrote:
This isn't the first time I've asked this
question on a public stage,
but in the hope that this time I get an answer;
Who volunteers to tackle the problem with connect.o.o and drive
forward a solution?
I made my proposal already and I stand the point: shut down an insecure
system!
what does "drive forward a solution" mean? Can we integrate the
functions of connect.o.o into other services at openSUSE which are
allready maintained like the openSUSE wiki? A form for travel support
for example?
An application for membership could be done by e-mail to an e-mail
address of the membership officials. Elections could be done with an
eVote software like https://github.com/mdipierro/evote for example, but
probably there are better tools.
What did I miss?
I think Lars is right an we should shutdown this insecure system as soon
as possible.
Regards
Christian Imhorst
--
To unsubscribe, e-mail: opensuse-project+unsubscribe(a)opensuse.org
To contact the owner, email: opensuse-project+owner(a)opensuse.org
21 Feb
21 Feb
6:42 p.m.
New subject: [opensuse-project] huge amount of SPAM on opensuse-connect
On Thu, 21 Feb 2019 at 16:21, <christian.imhorst(a)posteo.de> wrote:
what does "drive forward a solution" mean?
Can we integrate the
functions of connect.o.o into other services at openSUSE which are
allready maintained like the openSUSE wiki? A form for travel support
for example?
Suggestions like that all sound technically viable, so in a technical
sense 'drive forward a solution' means picking, and doing, good
engineering stuff like that
But the problem isn't just one that exists in the technical sphere.
There are a number of stakeholders that will be impacted by any change
in this area
This will affect how Membership works and their membership data is
stored, so the Membership of the project have to be on board, either
informally via discussions on this list, or formally in the term of
votes of any changes to their membership database. We can't have a
functioning Membership scheme if the Members dont like how their data
is being stored (and I agree with the sentiment that our Members
shouldn't like the Status quo..but..also I cant argue with the fact
that our Members collectively haven't been as motivated to address
this as they appear to be right now..)
This will affect how Membership is approved. This means the Membership
committee need to be spoken to, they need to agree to work with any
new technical solution. We can't have a functioning Membership scheme
without their approval.
This will involve infrastructure, either the decommissioning or
commissioning of new stuff. That means the openSUSE Heroes need to be
involved. No point trying to fix this without them.
So, "driving this forward" means doing the technical stuff, and the
human stuff, talking to the right people, getting them on board,
encouraging them to contribute to a solution.
If we all agree that this is a problem that needs to be fixed, then
lets get started and help fix it - This isn't somebody elses job, it
impacts all of us, we all should be doing something to help.
--
To unsubscribe, e-mail: opensuse-project+unsubscribe(a)opensuse.org
To contact the owner, email: opensuse-project+owner(a)opensuse.org
9:57 p.m.
New subject: [opensuse-project] huge amount of SPAM on opensuse-connect
On 2/21/19 9:42 AM, Richard Brown wrote:
On Thu, 21 Feb 2019 at 16:21,
<christian.imhorst(a)posteo.de> wrote:
functioning Membership scheme if the Members dont like how their data
is being stored (and I agree with the sentiment that our Members
shouldn't like the Status quo..but..also I cant argue with the fact
that our Members collectively haven't been as motivated to address
this as they appear to be right now..)
"appear to be" is a good way to put it.
Despite so many posts from so many "concerned" openSUSE-ers, I still
really do not see an "I'll Do It!", do you?
--
-Gerry Makaro
openSUSE Member
openSUSE Global Moderator
openSUSE Contributor
YaST Contributor
aka Fraser_Bell on the Forums, OBS, IRC, and mail at openSUSE.org
Fraser-Bell on Github
--
To unsubscribe, e-mail: opensuse-project+unsubscribe(a)opensuse.org
To contact the owner, email: opensuse-project+owner(a)opensuse.org
10:23 p.m.
New subject: [opensuse-project] huge amount of SPAM on opensuse-connect
On 21/02/2019 21.57, Fraser_Bell wrote:
On 2/21/19 9:42 AM, Richard Brown wrote:
No? :-o
--
Cheers / Saludos,
Carlos E. R.
(from 15.0 x86_64 at Telcontar)
On Thu, 21 Feb 2019 at 16:21,
<christian.imhorst(a)posteo.de> wrote:
functioning Membership scheme if the Members dont like how their data
is being stored (and I agree with the sentiment that our Members
shouldn't like the Status quo..but..also I cant argue with the fact
that our Members collectively haven't been as motivated to address
this as they appear to be right now..)
"appear to be" is a good way to put it.
Despite so many posts from so many "concerned" openSUSE-ers, I still
really do not see an "I'll Do It!", do you? 
11:28 p.m.
New subject: [opensuse-project] huge amount of SPAM on opensuse-connect
Op donderdag 21 februari 2019 21:57:06 CET schreef Fraser_Bell:
On 2/21/19 9:42 AM, Richard Brown wrote:
Even a 'hey, who
could help me do it?" would do.
--
Gertjan Lettink a.k.a. Knurpht
openSUSE Board Member
openSUSE Forums Team
--
To unsubscribe, e-mail: opensuse-project+unsubscribe(a)opensuse.org
To contact the owner, email: opensuse-project+owner(a)opensuse.org
On Thu, 21 Feb 2019 at 16:21,
<christian.imhorst(a)posteo.de> wrote:
functioning Membership scheme if the Members dont like how their data
is being stored (and I agree with the sentiment that our Members
shouldn't like the Status quo..but..also I cant argue with the fact
that our Members collectively haven't been as motivated to address
this as they appear to be right now..)
"appear to be" is a good way to put it.
Despite so many posts from so many "concerned" openSUSE-ers, I still
really do not see an "I'll Do It!", do you? 
22 Feb
22 Feb
8:43 a.m.
New subject: [opensuse-project] huge amount of SPAM on opensuse-connect
Le 21/02/2019 à 23:28, Knurpht-openSUSE a écrit :
Even a 'hey, who could help me do it?" would
do.
I use a free galette instance we could certainly use also. It keeps
membership, allow each member to edit his data...
my lug one
https://galette.culte.org/
it's more than able to cope with 400 members
http://galette.eu/dc/?navlang=en
when I managed my own server, I couldn't make it work with openSUSE, but
I'm pretty sure heroes could do eventually
jdd
--
http://dodin.org
--
To unsubscribe, e-mail: opensuse-project+unsubscribe(a)opensuse.org
To contact the owner, email: opensuse-project+owner(a)opensuse.org
21 Feb
21 Feb
10:09 p.m.
New subject: [opensuse-project] huge amount of SPAM on opensuse-connect
On 22/02/2019 01:51, christian.imhorst(a)posteo.de wrote:
Hi,
Am Do., 21. Feb. 2019 um 15:32 Uhr schrieb Lars Vogdt
<Lars.Vogdt(a)suse.com>om>:
As such, maintaining 447 [1] openSUSE members should not depend on a
single tool. Especially not if the used tool has open, well known
security issues since years[2].
On Thu, 21 Feb 2019 11:41:19 +0100 Richard Brown wrote:
The hard part, Storing members personal information in a secure way such
that the people who need to be able to access it can access it and
everyone else can not.
--
Simon Lees (Simotek) http://simotek.net
Emergency Update Team keybase.io/simotek
SUSE Linux Adelaide Australia, UTC+10:30
GPG Fingerprint: 5B87 DB9D 88DC F606 E489 CEC5 0922 C246 02F0 014B
--
To unsubscribe, e-mail: opensuse-project+unsubscribe(a)opensuse.org
To contact the owner, email: opensuse-project+owner(a)opensuse.org
This isn't the first time I've asked this
question on a public stage,
but in the hope that this time I get an answer;
Who volunteers to tackle the problem with connect.o.o and drive
forward a solution?
I made my proposal already and I stand the point: shut down an insecure
system!
what does "drive forward a solution" mean? Can we integrate the
functions of connect.o.o into other services at openSUSE which are
allready maintained like the openSUSE wiki? A form for travel support
for example?
An application for membership could be done by e-mail to an e-mail
address of the membership officials. Elections could be done with an
eVote software like https://github.com/mdipierro/evote for example, but
probably there are better tools.
What did I miss? 
10:22 p.m.
New subject: [opensuse-project] huge amount of SPAM on opensuse-connect
Am Donnerstag, 21. Februar 2019, 22:09:27 CET schrieb Simon Lees:
The hard part, Storing members personal information in
a secure way such
that the people who need to be able to access it can access it and
everyone else can not.
Came up twice already: take a Nextcloud, drop an LibreOffice Calc document
there. It's not the shiny knight on a white horse solution but it should be
enough to
a) keep the membership committee working
b) store the member's data safe
c) get rid of this ugly spam dump called connect.o.o
Regards,
vinz.
--
To unsubscribe, e-mail: opensuse-project+unsubscribe(a)opensuse.org
To contact the owner, email: opensuse-project+owner(a)opensuse.org
22 Feb
22 Feb
1:01 a.m.
New subject: [opensuse-project] huge amount of SPAM on opensuse-connect
On 22/02/2019 07:52, Vinzenz Vietzke wrote:
Am Donnerstag, 21. Februar 2019, 22:09:27 CET schrieb
Simon Lees:
Yes this discussion has got somewhere further then last time which
leaves us with the remaining questions.
Where should we install nextcloud?
Who would like to install it and keep it running?
--
Simon Lees (Simotek) http://simotek.net
Emergency Update Team keybase.io/simotek
SUSE Linux Adelaide Australia, UTC+10:30
GPG Fingerprint: 5B87 DB9D 88DC F606 E489 CEC5 0922 C246 02F0 014B
--
To unsubscribe, e-mail: opensuse-project+unsubscribe(a)opensuse.org
To contact the owner, email: opensuse-project+owner(a)opensuse.org
The hard part, Storing members personal
information in a secure way such
that the people who need to be able to access it can access it and
everyone else can not.
Came up twice already: take a Nextcloud, drop an LibreOffice Calc document
there. It's not the shiny knight on a white horse solution but it should be
enough to
a) keep the membership committee working
b) store the member's data safe
c) get rid of this ugly spam dump called connect.o.o
8:44 a.m.
New subject: [opensuse-project] huge amount of SPAM on opensuse-connect
Le 22/02/2019 à 01:01, Simon Lees a écrit :
Where should we install nextcloud?
Who would like to install it and keep it running?
and why is a *cloud* storage needed to manage membership?
jdd
--
http://dodin.org
--
To unsubscribe, e-mail: opensuse-project+unsubscribe(a)opensuse.org
To contact the owner, email: opensuse-project+owner(a)opensuse.org
9:26 a.m.
New subject: [opensuse-project] huge amount of SPAM on opensuse-connect
jdd(a)dodin.org wrote:
Le 22/02/2019 à 01:01, Simon Lees a écrit :
To make it more easily accessible to those who have a need to access it.
It could also just be stored on an ftp server, but using a nextcloud
instance does make it easier to share.
Simon asked:
Where should we install nextcloud?
Who would like to install it and keep it running?
and why is a *cloud* storage needed to manage membership? - Where should we install nextcloud?
It only needs a fixed ip, apache, php and a database. If we don't have a
webserver with those, I'm sure we can get one.
Who would like to install it and keep it running?
Show of hands please.
--
Per Jessen, Zürich (7.6°C)
http://www.cloudsuisse.com/ - your owncloud, hosted in Switzerland.
--
To unsubscribe, e-mail: opensuse-project+unsubscribe(a)opensuse.org
To contact the owner, email: opensuse-project+owner(a)opensuse.org
10:02 a.m.
New subject: [opensuse-project] huge amount of SPAM on opensuse-connect
On Fri, Feb 22, 2019 at 3:28 PM Per Jessen <per(a)computer.org> wrote:
Simon asked:
Hi,
If you give me an access, I will volunteer for this.
--
Edwin
--
To unsubscribe, e-mail: opensuse-project+unsubscribe(a)opensuse.org
To contact the owner, email: opensuse-project+owner(a)opensuse.org
- Where should we install nextcloud?
It only needs a fixed ip, apache, php and a database. If we don't have a
webserver with those, I'm sure we can get one.
Who would like to install it and keep it running?
Show of hands please.
--
Per Jessen, Zürich (7.6°C)
11:05 a.m.
New subject: [opensuse-project] huge amount of SPAM on opensuse-connect
Le 22/02/2019 à 09:26, Per Jessen a écrit :
https://www.zaclys.com/
offers a service with 1Gb free
and
https://cloud.zaclys.com/Le-cloud-a-quoi-ca-sert-exemple-dutilisation-du-se…
this I could manage for openSUSE if necessary. it's even encrypted if
you want to
you may think it's a provocation, and it is... why is it so hard to
share such service on openSUSE? I managed one myself for years..
jdd
--
http://dodin.org
--
To unsubscribe, e-mail: opensuse-project+unsubscribe(a)opensuse.org
To contact the owner, email: opensuse-project+owner(a)opensuse.org
Who would like
to install it and keep it running?
Show of hands please.
11:59 a.m.
New subject: [opensuse-project] huge amount of SPAM on opensuse-connect
jdd(a)dodin.org wrote:
Le 22/02/2019 à 09:26, Per Jessen a écrit :
https://www.zaclys.com/
offers a service with 1Gb free
and
https://cloud.zaclys.com/Le-cloud-a-quoi-ca-sert-exemple-dutilisation-du-se…
this I could manage for openSUSE if necessary. it's even encrypted if
you want to
you may think it's a provocation, and it is... why is it so hard to
share such service on openSUSE? I managed one myself for years..
I'm sure it isn't hard nor difficult. My company also provide cloud
storage, but for openSUSE we already have our own hardware in a secure
location, with physical access. Creating a new vm instance and asking
someone to run a nextcloud instance is no big deal, we only need to
make sure it is the right solution.
--
Per Jessen, Zürich (9.8°C)
http://www.hostsuisse.com/ - virtual servers, made in Switzerland.
--
To unsubscribe, e-mail: opensuse-project+unsubscribe(a)opensuse.org
To contact the owner, email: opensuse-project+owner(a)opensuse.org
Who would
like to install it and keep it running?
Show of hands please.
12:23 p.m.
New subject: [opensuse-project] huge amount of SPAM on opensuse-connect
Am Freitag, 22. Februar 2019, 11:59:00 CET schrieb Per Jessen:
I'm sure it isn't hard nor difficult. My
company also provide cloud
storage, but for openSUSE we already have our own hardware in a secure
location, with physical access. Creating a new vm instance and asking
someone to run a nextcloud instance is no big deal, we only need to
make sure it is the right solution.
Yeah, I would object to kill some service by adding just another one outside
of openSUSE's infrastructure.
So as an alternative to some Nextcloud why not just go with a private section
of Bugzilla? That should handle the whole process of application, decision and
documentation all in one.
Plus it's already there and maintained.
Regards,
vinz.
--
To unsubscribe, e-mail: opensuse-project+unsubscribe(a)opensuse.org
To contact the owner, email: opensuse-project+owner(a)opensuse.org
3:55 p.m.
New subject: [opensuse-project] huge amount of SPAM on opensuse-connect
Vinzenz Vietzke wrote:
Am Freitag, 22. Februar 2019, 11:59:00 CET schrieb Per
Jessen:
It might be an option, but bugzilla is currently run by SUSE IT, not
openSUSE.
--
Per Jessen, Zürich (11.2°C)
http://www.hostsuisse.com/ - dedicated server rental in Switzerland.
--
To unsubscribe, e-mail: opensuse-project+unsubscribe(a)opensuse.org
To contact the owner, email: opensuse-project+owner(a)opensuse.org
I'm sure it isn't hard nor difficult. My
company also provide cloud
storage, but for openSUSE we already have our own hardware in a
secure
location, with physical access. Creating a new vm instance and
asking someone to run a nextcloud instance is no big deal, we only
need to make sure it is the right solution.
Yeah, I would object to kill some service by adding just another one
outside of openSUSE's infrastructure.
So as an alternative to some Nextcloud why not just go with a private
section of Bugzilla? That should handle the whole process of
application, decision and documentation all in one.
Plus it's already there and maintained. 
12:35 p.m.
New subject: [opensuse-project] huge amount of SPAM on opensuse-connect
Hi all,
I have the same question like Carlos: I would volunteer but I don't now what to do. I
have no experience with Elgg and don't know how to maintain a forum.
Carlos E. R. wrote:
If I were to volunteer for that, what would I need to
do?
It seems to me that it is another forum. I know nothing of maintaining
a forum in order to reduce spam, so all I can think of is manually
deleting posts and killing those posters,
Regards
Christian Imhorst
--
To unsubscribe, e-mail: opensuse-project+unsubscribe(a)opensuse.org
To contact the owner, email: opensuse-project+owner(a)opensuse.org
8:47 a.m.
New subject: [opensuse-project] huge amount of SPAM on opensuse-connect
Hi folks,
On 2/22/19 1:22 AM, Vinzenz Vietzke wrote:
Came up twice already: take a Nextcloud, drop an LibreOffice Calc document
there. It's not the shiny knight on a white horse solution but it should be
enough to
a) keep the membership committee working
b) store the member's data safe
c) get rid of this ugly spam dump called connect.o.o
Agreed. We start simple.
I volunteer for this. Will check Heroes where I can set this up.
Regards,
Ish Sookun
--
To unsubscribe, e-mail: opensuse-project+unsubscribe(a)opensuse.org
To contact the owner, email: opensuse-project+owner(a)opensuse.org
23 Feb
23 Feb
1:49 a.m.
New subject: [opensuse-project] huge amount of SPAM on opensuse-connect
Hello,
[ I have about 50 unread mails in this discussion, so I might not have
seen all relevant comment yet.
One thing I noticed is that we have several volunteers. I'm really
happy about that :-) Please forgive me for answering only to one of
you ;-)
]
Am Freitag, 22. Februar 2019, 08:47:36 CET schrieb Ish Sookun:
On 2/22/19 1:22 AM, Vinzenz Vietzke wrote:
In a mail nearby, jdd asked the right question:
and why is a *cloud* storage needed to manage membership?
Using nextcloud with a LibreOffice Calc document in it would be a bad
idea IMHO. Not because my personal preference is ownCloud ;-) but
because it makes things more complicated than necessary. For example,
extracting the mail aliases out of a LibreOffice table would be a PITA,
or in general, automating anything would be a PITA.
So let's start even more simple and less cloudy, please ;-)
If we go for "a table that can only be edited by the membership
committee", then I'd propose to use
a MySQL database + phpMyAdmin
The interface would look a bit more "technical", but not too different/
difficult, and it would have several advantages:
- extracting the mail aliases out of a database is boring and easy
(much easier than extracting them from a binary[1] LibreOffice file)
- setting up the server is easy
- we could easily track changes, for example with a daily CSV export
that gets auto-commited to a git repo (not a requirement for the
initial implementation, just an idea for the future)
- if we setup a "request membership" form, writing to a database is much
easier than writing to a LibreOffice document
The hard part is to convert the data from connect.o.o to the new
database scheme. (I never looked at the database scheme used by
connect.o.o, therefore I have no idea how hard this will be.)
Writing/updating the export scripts (for example for the mail aliases)
is also some work, but not really hard.
Came up twice already: take a Nextcloud, drop an
LibreOffice Calc
document there. It's not the shiny knight on a white horse solution
but it should be enough to
a) keep the membership committee working
b) store the member's data safe
c) get rid of this ugly spam dump called connect.o.o
Agreed. We start simple. I volunteer for this. Will check Heroes where I can
set this up.
I'm happy to hear that :-)
Getting a VM (IMHO: for phpMyAdmin and an empty database) shouldn't be
too hard ;-) Please write a mail to the heroes mailinglist to request
it, and while on it, please also request access to the VPN and the
connect.o.o database.
Until that setup is done, you can already start on the drawing board
with stuff like "which columns will we need?" I know it sounds boring,
but I'm also sure nobody will get this right on the first attemp ;-)
On the positive side, adding a column later is easy, so don't worry too
much.
Regards,
Christian Boltz
[1] I know that LibreOffice documents are basically zipped XML, but that
doesn't make things much easier ;-)
--
Ich soll keine fünfzeiligen Sigs schreiben.
Ich soll keine fünfzeiligen Sigs schreiben.
Ich soll keine fünfzeiligen Sigs schreiben.
Ich soll keine fünfzeiligen Sigs schreiben.
Ich soll keine fünf...
--
To unsubscribe, e-mail: opensuse-project+unsubscribe(a)opensuse.org
To contact the owner, email: opensuse-project+owner(a)opensuse.org
1:58 a.m.
New subject: [opensuse-project] huge amount of SPAM on opensuse-connect
On 23/02/2019 01.49, Christian Boltz wrote:
Hello,
[ I have about 50 unread mails in this discussion, so I might not have
seen all relevant comment yet.
One thing I noticed is that we have several volunteers. I'm really
happy about that :-) Please forgive me for answering only to one of
you ;-)
]
Notice that some of us volunteered only to take care of spam while
others think and prepare a more permanent solution.
--
Cheers / Saludos,
Carlos E. R.
(from 15.0 x86_64 at Telcontar)
3:37 a.m.
New subject: [opensuse-project] huge amount of SPAM on opensuse-connect
On 2/22/19 4:58 PM, Carlos E. R. wrote:
On 23/02/2019 01.49, Christian Boltz wrote:
If we can get moving on the Provide Alternate and Dump Connect idea,
there will be no need to bother with the spam, as it will disappear with
Connect.
Just sayin'
If you help, even with just some of it, that helps move that process
forward towards fruition.
;-)
(... and, I would enjoy working with you, again.)
--
-Gerry Makaro
openSUSE Member
openSUSE Global Moderator
openSUSE Contributor
YaST Contributor
aka Fraser_Bell on the Forums, OBS, IRC, and mail at openSUSE.org
Fraser-Bell on Github
--
To unsubscribe, e-mail: opensuse-project+unsubscribe(a)opensuse.org
To contact the owner, email: opensuse-project+owner(a)opensuse.org
Hello,
[ I have about 50 unread mails in this discussion, so I might not have
seen all relevant comment yet.
One thing I noticed is that we have several volunteers. I'm really
happy about that :-) Please forgive me for answering only to one of
you ;-)
]
Notice that some of us volunteered only to take care of spam while
others think and prepare a more permanent solution.
3:31 a.m.
New subject: [opensuse-project] huge amount of SPAM on opensuse-connect
On 2/22/19 4:49 PM, Christian Boltz wrote:
Hello,
[ I have about 50 unread mails in this discussion, so I might not have
seen all relevant comment yet.
One thing I noticed is that we have several volunteers. I'm really
happy about that :-) Please forgive me for answering only to one of
you ;-)
]
Am Freitag, 22. Februar 2019, 08:47:36 CET schrieb Ish Sookun:
Yes, jdd is offering up some good comments.
On 2/22/19 1:22 AM, Vinzenz Vietzke wrote:
In a mail nearby, jdd asked the right question:
and why is a *cloud* storage needed to manage membership? Came up twice already: take a Nextcloud, drop an
LibreOffice Calc
document there. It's not the shiny knight on a white horse solution
but it should be enough to
a) keep the membership committee working
b) store the member's data safe
c) get rid of this ugly spam dump called connect.o.o
Agreed. We start simple.
Using nextcloud with a LibreOffice Calc document in it would be a bad
idea IMHO. Not because my personal preference is ownCloud ;-) but
because it makes things more complicated than necessary. For example,
extracting the mail aliases out of a LibreOffice table would be a PITA,
or in general, automating anything would be a PITA.
Yep.
So let's start even more simple and less cloudy, please ;-)
If we go for "a table that can only be edited by the membership
committee", then I'd propose to use
a MySQL database + phpMyAdmin
My idea, exactly.
The interface would look a bit more "technical", but not too different/
difficult, and it would have several advantages:
- extracting the mail aliases out of a database is boring and easy
(much easier than extracting them from a binary[1] LibreOffice file)
- setting up the server is easy
- we could easily track changes, for example with a daily CSV export
that gets auto-commited to a git repo (not a requirement for the
initial implementation, just an idea for the future)
- if we setup a "request membership" form, writing to a database is much
easier than writing to a LibreOffice document
The hard part is to convert the data from connect.o.o to the new
database scheme. (I never looked at the database scheme used by
connect.o.o, therefore I have no idea how hard this will be.)
Actually, there are currently only 446 openSUSE Members. That is a
number that could easily be split up between Ish, Edwin, Carlos and me
-- or more if we can find more -- and that would be less than 112 each.
That would make it possible to convert with manual input, even some cut
& paste?
Getting a VM (IMHO: for phpMyAdmin and an empty
database) shouldn't be
too hard ;-) Please write a mail to the heroes mailinglist to request
it, and while on it, please also request access to the VPN and the
connect.o.o database.
Until that setup is done, you can already start on the drawing board
with stuff like "which columns will we need?" I know it sounds boring,
but I'm also sure nobody will get this right on the first attemp ;-)
On the positive side, adding a column later is easy, so don't worry too
much.
Problem is, I know nothing about setting up or working with the current
databases. Last time I did any database work was in Borland dBase
III/IV. This new stuff is completely foreign to me: Not that I am a
database racist or anything, I just do not understand anything about it. ;-)
--
-Gerry Makaro
openSUSE Member
openSUSE Global Moderator
openSUSE Contributor
YaST Contributor
aka Fraser_Bell on the Forums, OBS, IRC, and mail at openSUSE.org
Fraser-Bell on Github
--
To unsubscribe, e-mail: opensuse-project+unsubscribe(a)opensuse.org
To contact the owner, email: opensuse-project+owner(a)opensuse.org
7:08 a.m.
New subject: [opensuse-project] huge amount of SPAM on opensuse-connect
Hi Gerry
On 2/23/19 6:31 AM, Fraser_Bell wrote:
That would make it possible to convert with manual input, even some cut
& paste?
Let's not focus on the "how" at this moment. Important is that we try
the possible alternatives to see what they're capable of. Something
which I am doing already.
Problem is, I know nothing about setting up or working with the current
databases. Last time I did any database work was in Borland dBase
III/IV. This new stuff is completely foreign to me: Not that I am a
database racist or anything, I just do not understand anything about it.
;-)
Thanks for stepping too, Gerry.
I'll update you, Edwin and jdd about the solutions I am testing. We can
then get in touch the membership officials for a trial.
Regards,
Ish
--
To unsubscribe, e-mail: opensuse-project+unsubscribe(a)opensuse.org
To contact the owner, email: opensuse-project+owner(a)opensuse.org
7:49 a.m.
New subject: [opensuse-project] huge amount of SPAM on opensuse-connect
On Sat, Feb 23, 2019 at 1:08 PM Ish Sookun <ish.sookun(a)lasentinelle.mu> wrote:
Hi Gerry
On 2/23/19 6:31 AM, Fraser_Bell wrote:
Ish,
I browse the 2 alternatives you sent earlier. I didn't try it or read
in detail but seems it lacks something. Connect now has something like
social network function and everyone can login using openSUSE
credentials which is made through other applications (CMIIW). Spam
usually come from bot account, not necessary though, a real
human/account can do that too. Of course bot account can easily
rejected using some kind mechanism like captcha but the real human
account who the intention is making spam might be a bit hard. That
usually need an admin works. If the logic/business process can be
change so that the new system only for the member it seems more easy,
but if the process should follow the existing one we should discuss it
more deeper.
Anyway I'll wait your propose solutions. If we already have something
more real it will be more easier for my slow brain to discuss. I hope
my hand still have some magic left :-)
best wishes,
--
Edwin
--
To unsubscribe, e-mail: opensuse-project+unsubscribe(a)opensuse.org
To contact the owner, email: opensuse-project+owner(a)opensuse.org
That would make it possible to convert with manual input, even some cut
& paste?
Let's not focus on the "how" at this moment. Important is that we try
the possible alternatives to see what they're capable of. Something
which I am doing already.
Problem is, I know nothing about setting up or working with the current
databases. Last time I did any database work was in Borland dBase
III/IV. This new stuff is completely foreign to me: Not that I am a
database racist or anything, I just do not understand anything about it.
;-)
Thanks for stepping too, Gerry.
I'll update you, Edwin and jdd about the solutions I am testing. We can
then get in touch the membership officials for a trial.
Regards,
Ish
--
4:33 p.m.
New subject: [opensuse-project] huge amount of SPAM [membership system evaluation]
Let me start a fork of this thread to focus on evaluation of possible
solution and list of volunteers to do so
Voluteers (may be) are:
christian Boltz (data base)
jdd (galette and more)
Ish Sookun
Edwin
Carlos (?)
(add or remove yourself :-)
needs to fulfill:
* manage a member database with identification, allowing members to
check they data and keep them safe
* manage a way to allow people to ask to be a members
* connect the present base to the new one
solution proposed are:
opensource for sure:
* plain paper
* Nextcloud session + libreoffice calc
* galette (http://galette.eu/dc/?navlang=en)
* mysql + phpmyadmin
probably opensource (to check):
* admidio (https://www.admidio.org/)
* clubmaster (http://www.clubmaster.org/)
* civicrm (http://groupspaces.com/)
please ad ideas here at will, but fork to add comments (change subject
or open a new one) thanks
jdd
--
http://dodin.org
--
To unsubscribe, e-mail: opensuse-project+unsubscribe(a)opensuse.org
To contact the owner, email: opensuse-project+owner(a)opensuse.org
8:10 p.m.
New subject: [opensuse-project] huge amount of SPAM [membership system evaluation]
On 23/02/2019 16.33, jdd(a)dodin.org wrote:
Let me start a fork of this thread to focus on
evaluation of possible
solution and list of volunteers to do so
Voluteers (may be) are:
christian Boltz (data base)
jdd (galette and more)
Ish Sookun
Edwin
Carlos (?)
Yes, but me only for clearing spam in the Connect platform, so that
others have time to evaluate possibilities. Maybe I can do other things
related to that platform when/if I find out how it works etc.
--
Cheers / Saludos,
Carlos E. R.
(from 15.0 x86_64 at Telcontar)
8:15 p.m.
New subject: [opensuse-project] huge amount of SPAM [membership system evaluation]
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
On Saturday, 2019-02-23 at 20:10 +0100, Carlos E. R. wrote:
On 23/02/2019 16.33, jdd(a)dodin.org wrote:
I see Stefan Seyfried also volunteers for this.
- --
Cheers,
Carlos E. R.
(from openSUSE 15.0 x86_64 at Telcontar)
Let me start a fork of this thread to focus on
evaluation of possible
solution and list of volunteers to do so
Voluteers (may be) are:
christian Boltz (data base)
jdd (galette and more)
Ish Sookun
Edwin
Carlos (?)
Yes, but me only for clearing spam in the Connect platform, so that
others have time to evaluate possibilities. Maybe I can do other things
related to that platform when/if I find out how it works etc. -----BEGIN PGP SIGNATURE-----
iHoEARECADoWIQQZEb51mJKK1KpcU/W1MxgcbY1H1QUCXHGb4Bwccm9iaW4ubGlz
dGFzQHRlbGVmb25pY2EubmV0AAoJELUzGBxtjUfVG+EAn1Pk18ZmZWffGl9emAa1
fVOHBdacAJ9wSuPWxyNyiRlcMDYwGVRPzdI1Ow==
=UOJq
-----END PGP SIGNATURE-----
--
To unsubscribe, e-mail: opensuse-project+unsubscribe(a)opensuse.org
To contact the owner, email: opensuse-project+owner(a)opensuse.org
8:49 p.m.
New subject: membership system evaluation (was: Re: [opensuse-project] huge amount of SPAM)
Am February 23, 2019 3:33:36 PM UTC schrieb "jdd(a)dodin.org"
<jdd(a)dodin.org>rg>:
Let me start a fork of this thread to focus on
evaluation of possible
solution and list of volunteers to do so
Voluteers (may be) are:
christian Boltz (data base)
jdd (galette and more)
Ish Sookun
Edwin
Carlos (?)
(add or remove yourself :-)
I would join, but I don't have a good relationship with our chairman and probably
some other members any longer, so I don't expect that my help is welcome. Which I
accept, btw, no worries.
But as I explained my problems in this thread and these complaints might be one of the
starting points of the whole discussion, you can add Lars as general contact for technical
questions. I'm not sure if I'm allowed to do some hands on stuff, but I will for
sure do my best to answer any question or offer help in other areas.
needs to fulfill:
* manage a member database with identification, allowing members to
check they data and keep them safe
* manage a way to allow people to ask to be a members
* connect the present base to the new one
solution proposed are:
opensource for sure:
* plain paper
* Nextcloud session + libreoffice calc
* galette (http://galette.eu/dc/?navlang=en)
* mysql + phpmyadmin
probably opensource (to check):
* admidio (https://www.admidio.org/)
* clubmaster (http://www.clubmaster.org/)
* civicrm (http://groupspaces.com/)
please ad ideas here at will, but fork to add comments (change subject
or open a new one) thanks
I've one addition:
* FreeIPA + maybe some additional forms
But be warned: the idea behind this is bigger than a replacement of connect and might end
up in more work.
The idea behind:
Establish a new user directory for openSUSE.
You might know that the heroes use FreeIPA internally since a while for authentication and
DNS. FreeIPA is utilizing 389 directory (I will call it LDAP from now, as I'm too old
to remember numbers ;-) and has a bunch of other features. Especially around
authentication and systems management.
I think we should be able to define some new groups like "hero",
"board", "election_commitee", "member",
"applicant", "user", ... and assign users to these groups. -> all
in LDAP. This needs ~10min initial work on the already established system.
The freeipa server is running inside the private network. No setup needed. The system is
productive and maintained by the heroes already. Exporting members with their Email
settings might not even be needed: using an ldapsearch with a special filter on the mail
systems will already do the trick. For the IRC nicknames export script, its about the
adaption of the mysql to a ldap query...
Funnily, bugzilla, wikis and other openSUSE tools allow authentication against LDAP since
a long time. It might be possible to add the "freeipa LDAP" as authorization
source to the running services (in addition or as replacement). This needs migration,
cooperation, trust and some time - but would in the end mean that openSUSE would become a
bit more independent.
FreeIPA already has a WebUI, that would allow to manage the group membership and other
details very user friendly.
So, what is missing?
* There is currently no WebUI available in the public. The Heroes could forward the
existing UI to the public (especially for evaluation by the membership committee), but
this has to be discussed with them (in CC).
* There could be a form, that allows users to request their membership. This could end up
in a flag in LDAP, which in turn might result in a notification to the membership
committee - but IMHO a mailing list or a real ticket system might be better for membership
requests. This has to be discussed with the membership committee (in CC).
* Once approved, members could be added in FreeIPA. Either by asking them to fill out a
registration form or by someone with enough rights in FreeIPA. Of course: the best way
might be to let them register themselves before they submit their request. In this case,
someone could simply add them the the right group and everybody is happy. We need to
discuss if they should/could use the same username as they have now, but this is a
detail.
* After some evaluation and testing, the community might want to migrate the current
Novell/openSUSE login stuff to FreeIPA - but this is not the question here and should be
discussed with the openSUSE community (in TO :-).
Regards,
Lars
--
To unsubscribe, e-mail: opensuse-project+unsubscribe(a)opensuse.org
To contact the owner, email: opensuse-project+owner(a)opensuse.org
9:20 p.m.
New subject: membership system evaluation (was: Re: [opensuse-project] huge amount of SPAM)
On Sat, 23 Feb 2019 at 20:49, Lars Vogdt <lrupp(a)suse.de> wrote:
I would join, but I don't have a good
relationship with our chairman and probably some other members any longer, so I don't
expect that my help is welcome. Which I accept, btw, no worries.
From my perspective your contributions to this solution
would be
absolutely welcome.
But as I explained my problems in this thread and
these complaints might be one of the starting points of the whole discussion, you can add
Lars as general contact for technical questions. I'm not sure if I'm allowed to do
some hands on stuff, but I will for sure do my best to answer any question or offer help
in other areas.
I don't know what you mean by "if I'm allowed".
From my view there is nothing that should prevent you
or any other
volunteer from being allowed to do hands on stuff to solve this issue.
If there are factors I'm unaware of, then I'd suggest we discuss that
offlist. I'm prepared to help in any way I can to remove any such
blockers.
If it would make you more comfortable, I'd suggest emailing
board(a)opensuse.org if you wish an alternative to contacting me
directly.
I've one addition:
* FreeIPA + maybe some additional forms
But be warned: the idea behind this is bigger than a replacement of connect and might end
up in more work.
The idea behind:
Establish a new user directory for openSUSE.
You might know that the heroes use FreeIPA internally since a while for authentication
and DNS. FreeIPA is utilizing 389 directory (I will call it LDAP from now, as I'm too
old to remember numbers ;-) and has a bunch of other features. Especially around
authentication and systems management.
I think we should be able to define some new groups like "hero",
"board", "election_commitee", "member",
"applicant", "user", ... and assign users to these groups. -> all
in LDAP. This needs ~10min initial work on the already established system.
The freeipa server is running inside the private network. No setup needed. The system is
productive and maintained by the heroes already. Exporting members with their Email
settings might not even be needed: using an ldapsearch with a special filter on the mail
systems will already do the trick. For the IRC nicknames export script, its about the
adaption of the mysql to a ldap query...
Funnily, bugzilla, wikis and other openSUSE tools allow authentication against LDAP
since a long time. It might be possible to add the "freeipa LDAP" as
authorization source to the running services (in addition or as replacement). This needs
migration, cooperation, trust and some time - but would in the end mean that openSUSE
would become a bit more independent.
FreeIPA already has a WebUI, that would allow to manage the group membership and other
details very user friendly.
So, what is missing?
* There is currently no WebUI available in the public. The Heroes could forward the
existing UI to the public (especially for evaluation by the membership committee), but
this has to be discussed with them (in CC).
* There could be a form, that allows users to request their membership. This could end up
in a flag in LDAP, which in turn might result in a notification to the membership
committee - but IMHO a mailing list or a real ticket system might be better for membership
requests. This has to be discussed with the membership committee (in CC).
* Once approved, members could be added in FreeIPA. Either by asking them to fill out a
registration form or by someone with enough rights in FreeIPA. Of course: the best way
might be to let them register themselves before they submit their request. In this case,
someone could simply add them the the right group and everybody is happy. We need to
discuss if they should/could use the same username as they have now, but this is a
detail.
* After some evaluation and testing, the community might want to migrate the current
Novell/openSUSE login stuff to FreeIPA - but this is not the question here and should be
discussed with the openSUSE community (in TO :-).
Oh boy, talk about a comprehensive solution.
This solution would also be compatible with some casual enquiries
discussed with the Board recently.
If this is an idea the community likes and is willing to work behind,
I can see potential in this solution to tie together nicely with other
requirements that are currently coalescing over the horizon.
Might be worth the work
--
To unsubscribe, e-mail: opensuse-project+unsubscribe(a)opensuse.org
To contact the owner, email: opensuse-project+owner(a)opensuse.org
9:30 p.m.
New subject: [opensuse-project] Re: membership system evaluation
Le 23/02/2019 à 21:20, Richard Brown a écrit :
Might be worth the work
good, thanks
jdd
--
http://dodin.org
--
To unsubscribe, e-mail: opensuse-project+unsubscribe(a)opensuse.org
To contact the owner, email: opensuse-project+owner(a)opensuse.org
9:56 p.m.
New subject: [opensuse-project] Re: membership system evaluation
HUGE, HUGE, HUGE SUPER THANKS!!!!
Super Thanks to all the people who are stepping up to offer help on one
aspect or another with the remake of Membership database and cleanup of
our existing system.
This is what I, personally, needed to see to reinvigorate my energy to
work on openSUSE problems.
A Community, Volunteering as Community Members, to solve a pressing
Community Issue.
Thanks, everyone!!! Up till now, it was beginning to depress me that
calls for help seemed to be constantly ignored.
Now, I am beginning to feel Very Proud of being a Member of this Community!
--
-Gerry Makaro
openSUSE Member
openSUSE Global Moderator
openSUSE Contributor
YaST Contributor
aka Fraser_Bell on the Forums, OBS, IRC, and mail at openSUSE.org
Fraser-Bell on Github
--
To unsubscribe, e-mail: opensuse-project+unsubscribe(a)opensuse.org
To contact the owner, email: opensuse-project+owner(a)opensuse.org
9:38 p.m.
New subject: [opensuse-project] Re: membership system evaluation
Am 2019-02-23 21:20, schrieb Richard Brown:
On Sat, 23 Feb 2019 at 20:49, Lars Vogdt
<lrupp(a)suse.de> wrote:
Well: I was kicked from machines in the past, without any further
information. So I assume that there was either an order from someone or
someone inside the heroes team did not want me to contribute any longer.
As I explained the weeks before that event that I probably have to step
back because my time for the heroes in 2019 is limited, I accepted the
removal of my keys (while I still not understand that nobody talked to
me about this in front or explained me the reasons). More details are on
the heroes list.
So from my point of view, I'm asking the heroes if I'm allowed to help.
But as I explained my problems in this thread and
these complaints
might be one of the starting points of the whole discussion, you can
add Lars as general contact for technical questions. I'm not sure if
I'm allowed to do some hands on stuff, but I will for sure do my best
to answer any question or offer help in other areas.
I don't know what you mean by "if I'm allowed". > I've one addition:
> * FreeIPA + maybe some additional forms
[...]
Might be worth the work
Thanks.
Lars
--
To unsubscribe, e-mail: opensuse-project+unsubscribe(a)opensuse.org
To contact the owner, email: opensuse-project+owner(a)opensuse.org
10 p.m.
New subject: [opensuse-project] Re: membership system evaluation
On 2/23/19 12:20 PM, Richard Brown wrote:
On Sat, 23 Feb 2019 at 20:49, Lars Vogdt
<lrupp(a)suse.de> wrote:
Ahhh. As I thought. Thanks, Richard.
--
-Gerry Makaro
openSUSE Member
openSUSE Global Moderator
openSUSE Contributor
YaST Contributor
aka Fraser_Bell on the Forums, OBS, IRC, and mail at openSUSE.org
Fraser-Bell on Github
--
To unsubscribe, e-mail: opensuse-project+unsubscribe(a)opensuse.org
To contact the owner, email: opensuse-project+owner(a)opensuse.org
I would join, but I don't have a good
relationship with our chairman and probably some other members any longer, so I don't
expect that my help is welcome. Which I accept, btw, no worries.
From my perspective your contributions to this
solution would be
absolutely welcome.
But as I explained my problems in this thread and
these complaints might be one of the starting points of the whole discussion, you can add
Lars as general contact for technical questions. I'm not sure if I'm allowed to do
some hands on stuff, but I will for sure do my best to answer any question or offer help
in other areas.
I don't know what you mean by "if I'm allowed".
From my view there is nothing that should prevent
you or any other
volunteer from being allowed to do hands on stuff to solve this
issue.
If there are factors I'm unaware of, then I'd suggest we discuss that
offlist. I'm prepared to help in any way I can to remove any such
blockers.
If it would make you more comfortable, I'd suggest emailing
board(a)opensuse.org if you wish an alternative to contacting me
directly.
9:59 p.m.
New subject: [opensuse-project] Re: membership system evaluation
On 2/23/19 11:49 AM, Lars Vogdt wrote:
Am February 23, 2019 3:33:36 PM UTC schrieb
"jdd(a)dodin.org" <jdd(a)dodin.org>rg>:
Nonsense! You are fully welcome, in fact *definitely wanted* to join in
this Community Exercise! If anyone gives you grief, the rest of us -- I
am sure -- will set them straight.
I bet Richard agrees with me, and I bet many others here do, too.
--
-Gerry Makaro
openSUSE Member
openSUSE Global Moderator
openSUSE Contributor
YaST Contributor
aka Fraser_Bell on the Forums, OBS, IRC, and mail at openSUSE.org
Fraser-Bell on Github
--
To unsubscribe, e-mail: opensuse-project+unsubscribe(a)opensuse.org
To contact the owner, email: opensuse-project+owner(a)opensuse.org
Let me start a fork of this thread to focus on
evaluation of possible
solution and list of volunteers to do so
Voluteers (may be) are:
christian Boltz (data base)
jdd (galette and more)
Ish Sookun
Edwin
Carlos (?)
(add or remove yourself :-)
I would join, but I don't have a good relationship with our chairman and probably
some other members any longer, so I don't expect that my help is welcome. Which I
accept, btw, no worries.
10:28 p.m.
New subject: [opensuse-project] Re: membership system evaluation
Op zaterdag 23 februari 2019 21:59:26 CET schreef Fraser_Bell:
Nonsense! You are fully welcome, in
fact *definitely wanted* to join in
this Community Exercise! If anyone gives you grief, the rest of us -- I
am sure -- will set them straight.
I bet Richard agrees with me, and I bet many others here do, too. +1 here.
--
Gertjan Lettink a.k.a. Knurpht
openSUSE Board Member
openSUSE Forums Team
--
To unsubscribe, e-mail: opensuse-project+unsubscribe(a)opensuse.org
To contact the owner, email: opensuse-project+owner(a)opensuse.org
On 2/23/19 11:49 AM, Lars Vogdt wrote:
> Am February 23, 2019 3:33:36 PM UTC schrieb "jdd(a)dodin.org"
<jdd(a)dodin.org>rg>:
Let me start a fork of this thread to focus on
evaluation of possible
solution and list of volunteers to do so
Voluteers (may be) are:
christian Boltz (data base)
jdd (galette and more)
Ish Sookun
Edwin
Carlos (?)
(add or remove yourself :-)
I would join, but I don't have a good relationship with our chairman and
probably some other members any longer, so I don't expect that my help
is welcome. Which I accept, btw, no worries.
10:35 p.m.
New subject: [opensuse-project] Re: membership system evaluation
On 2/23/19 1:28 PM, Knurpht-openSUSE wrote:
Op zaterdag 23 februari 2019 21:59:26 CET schreef
Fraser_Bell:
Nonsense! You are fully welcome, in
fact *definitely wanted* to join in
this Community Exercise! If anyone gives you grief, the rest of us -- I
am sure -- will set them straight.
I bet Richard agrees with me, and I bet many others here do, too. +1 here.
LOL!
I absolutely *love it* when I get to say: "See, toldya so!"
--
-Gerry Makaro
openSUSE Member
openSUSE Global Moderator
openSUSE Contributor
YaST Contributor
aka Fraser_Bell on the Forums, OBS, IRC, and mail at openSUSE.org
Fraser-Bell on Github
--
To unsubscribe, e-mail: opensuse-project+unsubscribe(a)opensuse.org
To contact the owner, email: opensuse-project+owner(a)opensuse.org
On 2/23/19 11:49 AM, Lars Vogdt wrote:
> Am February 23, 2019 3:33:36 PM UTC schrieb "jdd(a)dodin.org"
<jdd(a)dodin.org>rg>:
Let me start a fork of this thread to focus on
evaluation of possible
solution and list of volunteers to do so
Voluteers (may be) are:
christian Boltz (data base)
jdd (galette and more)
Ish Sookun
Edwin
Carlos (?)
(add or remove yourself :-)
I would join, but I don't have a good relationship with our chairman and
probably some other members any longer, so I don't expect that my help
is welcome. Which I accept, btw, no worries. 
24 Feb
24 Feb
9:47 a.m.
New subject: [heroes] membership system evaluation (was: Re: [opensuse-project] huge amount of SPAM)
On 2/23/19 8:49 PM, Lars Vogdt wrote:
* After some evaluation and testing, the community
might want to
migrate the current Novell/openSUSE login stuff to FreeIPA - but this
is not the question here and should be discussed with the openSUSE
community (in TO :-).
Note my proposal a couple of months ago:
"Proposal: Use Æ-DIR instead of FreeIPA"
https://lists.opensuse.org/heroes/2018-07/msg00002.html
I've done a PoC installation:
https://progress.opensuse.org/issues/39872
I will also present Æ-DIR (see https://ae-dir.com) at oSC 2019.
In the mean-time someone implemented a aehostd state for CentOS and
Debian which could be probably pretty easily adapted to openSUSE:
https://git.webmeisterei.com/saltstack-formulas/ae-dir-formula
Ciao, Michael.
--
To unsubscribe, e-mail: opensuse-project+unsubscribe(a)opensuse.org
To contact the owner, email: opensuse-project+owner(a)opensuse.org
23 Feb
23 Feb
9:56 p.m.
New subject: [opensuse-project] huge amount of SPAM [membership system evaluation]
On 2/23/19 7:33 AM, jdd(a)dodin.org wrote:
Let me start a fork of this thread to focus on
evaluation of possible
solution and list of volunteers to do so
Voluteers (may be) are:
christian Boltz (data base)
jdd (galette and more)
Ish Sookun
Edwin
Carlos (?)
(add or remove yourself :-)
Did you forget someone? ;-)
... and, no, Christian Boltz has not volunteered, yet, as he is quite
busy, although he will be involved in some ways. He was talking to me
at the Heroes meeting about me doing something about the Connect
problem, was willing to help me get started with it, but it would be me
who was taking it on, not Christian.
He was only offering at the time to point me in the right directions to
get the necessary access and technical structure.
Also at the time, we were discussing using the Wiki itself for the
Member Profile Pages, in a Members sub-heading, editable *only* by the
Admins, necessary people (Membership Committee, f.e.), and the Member
themself (so they have full control over their information).
needs to fulfill:
* manage a member database with identification, allowing members to
check they data and keep them safe
See above, as one solution.
* manage a way to allow people to ask to be a members
Website Forms, with captcha and/or other verification system, nothing
new. The form would then send the e-mail to the Membership Committee.
* connect the present base to the new one
MySQL, php. And, no, NOT connect the present base, but replace it with
a new one. Data can be ported, no problem, then edited if necessary.
solution proposed are:
opensource for sure:
Absolutely
* plain paper
* Nextcloud session + libreoffice calc
* galette (http://galette.eu/dc/?navlang=en)
* mysql + phpmyadmin
YEP! My vote.
... in a VM instance we (openSUSE) have full control over.
And, as I said, I am willing to join the Heroes team and be ONE OF a
group of people who will help keep it maintained after it is set up.
Thanks, again, jdd, for joining in.
--
-Gerry Makaro
openSUSE Member
openSUSE Global Moderator
openSUSE Contributor
YaST Contributor
aka Fraser_Bell on the Forums, OBS, IRC, and mail at openSUSE.org
Fraser-Bell on Github
--
To unsubscribe, e-mail: opensuse-project+unsubscribe(a)opensuse.org
To contact the owner, email: opensuse-project+owner(a)opensuse.org
10:05 p.m.
New subject: [opensuse-project] huge amount of SPAM [membership system evaluation]
Le 23/02/2019 à 21:56, Fraser_Bell a écrit :
alrady asked the heroes team about this (I don't expect an answer during
week end :-()
thanks
jdd
--
http://dodin.org
--
To unsubscribe, e-mail: opensuse-project+unsubscribe(a)opensuse.org
To contact the owner, email: opensuse-project+owner(a)opensuse.org
On 2/23/19 7:33 AM, jdd(a)dodin.org wrote:
I was unsure so I added the "add yourself"
Let me start a fork of this thread to focus on
evaluation of possible
solution and list of volunteers to do so
Voluteers (may be) are:
christian Boltz (data base)
jdd (galette and more)
Ish Sookun
Edwin
Carlos (?)
(add or remove yourself :-)
Did you forget someone? ;-)
... and, no, Christian Boltz has not volunteered,
it as him that proposed the phpmyadmin solution, so I figured out hi
wanted to setup one :-)
opensource for sure:
Absolutely
* plain paper
* Nextcloud session + libreoffice calc
* galette (http://galette.eu/dc/?navlang=en)
* mysql + phpmyadmin
YEP! My vote.
... in a VM instance we (openSUSE) have full control over.
10:32 p.m.
New subject: [opensuse-project] huge amount of SPAM [membership system evaluation]
Okay, so the first thing we need to do is get this all organized, get
everyone willing to help with *whatever* section of this project all on
the same page.
We need to split the categories, for one, and we need to select a Team
Leader for each of those. Otherwise we will be thrashing around and
accidentally stepping on each others toes, not a good thing at all and
would probably kill the whole project.
When that is done, the people who are stepping up to offer their help
can safely choose what they believe they can do and are willing to do,
as little or as much as they each feel like doing.
We need to set some goals and get everyone headed in the same direction.
I propose we arrange an IRC Meeting on either #opensuse-admin or
#opensuse-project ASAP. So, first order of business is getting a time
all those offering to help can attend.
I can make myself available after 11:00 a.m. Pacific Standard Time
(America-Vancouver) most days, which is UTC -08:00.
Who else?
(And, no, I am not trying to take over, I think we probably have better
and more sociable Team Leaders here than me, although I would accept if
others insist.)
--
-Gerry Makaro
openSUSE Member
openSUSE Global Moderator
openSUSE Contributor
YaST Contributor
aka Fraser_Bell on the Forums, OBS, IRC, and mail at openSUSE.org
Fraser-Bell on Github
--
To unsubscribe, e-mail: opensuse-project+unsubscribe(a)opensuse.org
To contact the owner, email: opensuse-project+owner(a)opensuse.org
10:39 p.m.
New subject: [opensuse-project] huge amount of SPAM [membership system evaluation]
On sob, lut 23, 2019 at 10:32 PM, Fraser_Bell
<Fraser_Bell(a)openSUSE.org> wrote:
Okay, so the first thing we need to do is get this all
organized, get
everyone willing to help with *whatever* section of this project all
on the same page.
We need to split the categories, for one, and we need to select a
Team Leader for each of those. Otherwise we will be thrashing around
and accidentally stepping on each others toes, not a good thing at
all and would probably kill the whole project.
When that is done, the people who are stepping up to offer their help
can safely choose what they believe they can do and are willing to
do, as little or as much as they each feel like doing.
We need to set some goals and get everyone headed in the same
direction.
I propose we arrange an IRC Meeting on either #opensuse-admin or
#opensuse-project ASAP. So, first order of business is getting a
time all those offering to help can attend.
I can make myself available after 11:00 a.m. Pacific Standard Time
(America-Vancouver) most days, which is UTC -08:00.
Who else?
(And, no, I am not trying to take over, I think we probably have
better and more sociable Team Leaders here than me, although I would
accept if others insist.)
Eh, out of all that shitposting I started making some quick and easy
replacement for connect on Friday.
Initial mockup:
https://cdn.discordapp.com/attachments/407993213425680384/54856502532597350…
Current state:
https://cdn.discordapp.com/attachments/407993213425680384/54894856195014657…
(and some more equally unfinished parts of the interface)
I suspect I will have something usable on monday (and if not my next
free time is on the next friday).
Although I would much appreciate less spam in mailing lists so I can
focus on that instead of reading emails :P
LCP [Stasiek]
https://lcp.world
--
To unsubscribe, e-mail: opensuse-project+unsubscribe(a)opensuse.org
To contact the owner, email: opensuse-project+owner(a)opensuse.org
10:59 p.m.
New subject: [opensuse-project] huge amount of SPAM [membership system evaluation]
On 2/23/19 1:39 PM, hellcp(a)opensuse.org wrote:
On sob, lut 23, 2019 at 10:32 PM, Fraser_Bell <Fraser_Bell(a)openSUSE.org>
wrote:
Looking good!!! Thank you!!!
Can I help in any way?
--
-Gerry Makaro
openSUSE Member
openSUSE Global Moderator
openSUSE Contributor
YaST Contributor
aka Fraser_Bell on the Forums, OBS, IRC, and mail at openSUSE.org
Fraser-Bell on Github
--
To unsubscribe, e-mail: opensuse-project+unsubscribe(a)opensuse.org
To contact the owner, email: opensuse-project+owner(a)opensuse.org
Okay, so the first thing we need to do is get
this all organized, get
everyone willing to help with *whatever* section of this project all
on the same page.
We need to split the categories, for one, and we need to select a Team
Leader for each of those. Otherwise we will be thrashing around and
accidentally stepping on each others toes, not a good thing at all and
would probably kill the whole project.
When that is done, the people who are stepping up to offer their help
can safely choose what they believe they can do and are willing to do,
as little or as much as they each feel like doing.
We need to set some goals and get everyone headed in the same direction.
I propose we arrange an IRC Meeting on either #opensuse-admin or
#opensuse-project ASAP. So, first order of business is getting a time
all those offering to help can attend.
I can make myself available after 11:00 a.m. Pacific Standard Time
(America-Vancouver) most days, which is UTC -08:00.
Who else?
(And, no, I am not trying to take over, I think we probably have
better and more sociable Team Leaders here than me, although I would
accept if others insist.)
Eh, out of all that shitposting I started making some quick and easy
replacement for connect on Friday.
Initial mockup:
https://cdn.discordapp.com/attachments/407993213425680384/54856502532597350…
Current state:
https://cdn.discordapp.com/attachments/407993213425680384/54894856195014657…
(and some more equally unfinished parts of the interface)
I suspect I will have something usable on monday (and if not my next
free time is on the next friday).
Although I would much appreciate less spam in mailing lists so I can
focus on that instead of reading emails :P
LCP [Stasiek]
https://lcp.world
11:08 p.m.
New subject: [opensuse-project] membership system evaluation CALL FOR IRC MEETING
On 2/23/19 1:32 PM, Fraser_Bell wrote:
Okay, so the first thing we need to do is get this all
organized, get
everyone willing to help with *whatever* section of this project all on
the same page.
We need to split the categories, for one, and we need to select a Team
Leader for each of those. Otherwise we will be thrashing around and
accidentally stepping on each others toes, not a good thing at all and
would probably kill the whole project.
When that is done, the people who are stepping up to offer their help
can safely choose what they believe they can do and are willing to do,
as little or as much as they each feel like doing.
We need to set some goals and get everyone headed in the same direction.
I propose we arrange an IRC Meeting on either #opensuse-admin or
#opensuse-project ASAP. So, first order of business is getting a time
all those offering to help can attend.
I can make myself available after 11:00 a.m. Pacific Standard Time
(America-Vancouver) most days, which is UTC -08:00.
Who else?
(And, no, I am not trying to take over, I think we probably have better
and more sociable Team Leaders here than me, although I would accept if
others insist.)
Repeating this highlighting objective in Heading.
--
-Gerry Makaro
openSUSE Member
openSUSE Global Moderator
openSUSE Contributor
YaST Contributor
aka Fraser_Bell on the Forums, OBS, IRC, and mail at openSUSE.org
Fraser-Bell on Github
--
To unsubscribe, e-mail: opensuse-project+unsubscribe(a)opensuse.org
To contact the owner, email: opensuse-project+owner(a)opensuse.org
24 Feb
24 Feb
9:16 a.m.
New subject: [opensuse-project] membership system evaluation CALL FOR IRC MEETING
Le 23/02/2019 à 23:08, Fraser_Bell a écrit :
Repeating this highlighting objective in Heading.
sorry, it was sleep time for me :-( - I just come again and with little
time right now :-(
IRC is not friendly with users all around the world :-(
jdd
--
http://dodin.org
--
To unsubscribe, e-mail: opensuse-project+unsubscribe(a)opensuse.org
To contact the owner, email: opensuse-project+owner(a)opensuse.org
9:43 a.m.
New subject: [opensuse-project] membership system evaluation CALL FOR IRC MEETING
Am Sonntag, 24. Februar 2019, 09:16:50 CET schrieb jdd(a)dodin.org:
Le 23/02/2019 à 23:08, Fraser_Bell a écrit :
annoincing this kinbd of stuff a bit more in advance would be the thing to
do. Not everybody checks their email every five minutes, especially at 11pm.
Repeating this highlighting objective in Heading.
sorry, it was sleep time for me :-( - I just come again and with little
time right now :-(
IRC is not friendly with users all around the world :-(
jdd
not just irc...
Cheers
MH
--
Mathias Homann
Senior Systems Engineer, IT Consultant. IT Trainer
Mathias.Homann(a)openSUSE.org
http://www.tuxonline.tech
gpg key fingerprint: 8029 2240 F4DD 7776 E7D2 C042 6B8E 029E 13F2 C102
11:21 p.m.
New subject: [opensuse-project] membership system evaluation CALL FOR IRC MEETING
On 2/24/19 12:16 AM, jdd(a)dodin.org wrote:
Le 23/02/2019 à 23:08, Fraser_Bell a écrit :
Sorry, jdd. Miscommunication. I am suggesting an IRC Meeting sometime
this week, say Tuesday, Wednesday or Thursday. I announced the hours I
would be available for such a meeting.
I was instead hoping all taking part would announce their available
hours, so we can set a day and time we all could meet.
It is just a suggestion, but I think an important one, because we have a
few people working on things.
I would hate to see someone work hard on an idea, only to find out
things are going in a different direction.
Such a result would tend to discourage a Contributor from volunteering
for things in the future.
I am suggesting we take every step we can to make sure someone does not
waste time going in the wrong direction, and we take every step to
encourage everyone who wants to step in here, *not* discourage them.
In any case, somehow we need to get things organized, divided into steps
and/or Teams, with those stepping up choosing what they can, cannot, or
want to do.
Sorry for my miscommunication, here.
--
-Gerry Makaro
openSUSE Member
openSUSE Global Moderator
openSUSE Contributor
YaST Contributor
aka Fraser_Bell on the Forums, OBS, IRC, and mail at openSUSE.org
Fraser-Bell on Github
--
To unsubscribe, e-mail: opensuse-project+unsubscribe(a)opensuse.org
To contact the owner, email: opensuse-project+owner(a)opensuse.org
Repeating this highlighting objective in
Heading.
sorry, it was sleep time for me :-( - I just come again and with little
time right now :-(
IRC is not friendly with users all around the world :-(
jdd
23 Feb
23 Feb
10:09 p.m.
New subject: [opensuse-project] huge amount of SPAM [membership system evaluation] [galette]
Le 23/02/2019 à 16:33, jdd(a)dodin.org a écrit :
* galette (http://galette.eu/dc/?navlang=en)
I created on my own (shared) domain a galette instance (15" time)
http://dodin.org/galette/webroot//login
I expect some of you to mimic a membership subscription: create your own
profile.
you may as well ask for admin account, no problem
jdd
--
http://dodin.org
--
To unsubscribe, e-mail: opensuse-project+unsubscribe(a)opensuse.org
To contact the owner, email: opensuse-project+owner(a)opensuse.org
24 Feb
24 Feb
12:02 p.m.
New subject: [opensuse-project] huge amount of SPAM [membership system evaluation]
Am Samstag, 23. Februar 2019, 16:33:36 CET schrieb jdd(a)dodin.org:
Let me start a fork of this thread to focus on
evaluation of possible
solution and list of volunteers to do so
Voluteers (may be) are:
christian Boltz (data base)
jdd (galette and more)
Ish Sookun
Edwin
Carlos (?)
(add or remove yourself :-)
needs to fulfill:
* manage a member database with identification, allowing members to
check they data and keep them safe
* manage a way to allow people to ask to be a members
* connect the present base to the new one
solution proposed are:
opensource for sure:
* plain paper
* Nextcloud session + libreoffice calc
* galette (http://galette.eu/dc/?navlang=en)
* mysql + phpmyadmin
Free ERP system - would allow to manage accounts/payments as well (TSP...)
Cheers
Axel
--
To unsubscribe, e-mail: opensuse-project+unsubscribe(a)opensuse.org
To contact the owner, email: opensuse-project+owner(a)opensuse.org
6:04 p.m.
New subject: [opensuse-project] huge amount of SPAM [membership system evaluation]
Hello all.
I think at the moment a wiki page to summarize the propositions could be
useful.
are you OK? can I process?
thanks
jdd
--
http://dodin.org
--
To unsubscribe, e-mail: opensuse-project+unsubscribe(a)opensuse.org
To contact the owner, email: opensuse-project+owner(a)opensuse.org
7:55 p.m.
New subject: [opensuse-project] huge amount of SPAM [membership system evaluation]
Hi jdd,
On 2/24/19 9:04 PM, jdd(a)dodin.org wrote:
I think at the moment a wiki page to summarize the propositions could be
useful.
are you OK? can I process?
Sure, that'll be nice.
Regards,
Ish
--
To unsubscribe, e-mail: opensuse-project+unsubscribe(a)opensuse.org
To contact the owner, email: opensuse-project+owner(a)opensuse.org
11:25 p.m.
New subject: [opensuse-project] huge amount of SPAM [membership system evaluation]
On 2/24/19 9:04 AM, jdd(a)dodin.org wrote:
Hello all.
I think at the moment a wiki page to summarize the propositions could be
useful.
are you OK? can I process?
thanks
jdd
That sounds like a very good idea to me, jdd.
--
-Gerry Makaro
openSUSE Member
openSUSE Global Moderator
openSUSE Contributor
YaST Contributor
aka Fraser_Bell on the Forums, OBS, IRC, and mail at openSUSE.org
Fraser-Bell on Github
--
To unsubscribe, e-mail: opensuse-project+unsubscribe(a)opensuse.org
To contact the owner, email: opensuse-project+owner(a)opensuse.org
25 Feb
25 Feb
9:40 a.m.
New subject: [opensuse-project] huge amount of SPAM [wiki page]
Le 24/02/2019 à 23:25, Fraser_Bell a écrit :
On 2/24/19 9:04 AM, jdd(a)dodin.org wrote:
done:
https://en.opensuse.org/openSUSE_talk:Membership_officials
I used the talk page of the Membership_official, it's free to write
there with any openSUSE account (it can be moved if a better place if found)
Please read the page and edit it at will, for the content and for the
language, my English is limited :-(.
Feel free to open also sub-pages if what you have to say is a bit long
thanks
jdd
--
http://dodin.org
--
To unsubscribe, e-mail: opensuse-project+unsubscribe(a)opensuse.org
To contact the owner, email: opensuse-project+owner(a)opensuse.org
Hello all.
I think at the moment a wiki page to summarize the propositions could be
useful.
are you OK? can I process?
thanks
jdd
That sounds like a very good idea to me, jdd.
8:38 p.m.
New subject: [opensuse-project] huge amount of SPAM [wiki page]
On 2/25/19 12:40 AM, jdd(a)dodin.org wrote:
Le 24/02/2019 à 23:25, Fraser_Bell a écrit :
I will take care of that later today, jdd. Thanks.
--
-Gerry Makaro
openSUSE Member
openSUSE Global Moderator
openSUSE Contributor
YaST Contributor
aka Fraser_Bell on the Forums, OBS, IRC, and mail at openSUSE.org
Fraser-Bell on Github
--
To unsubscribe, e-mail: opensuse-project+unsubscribe(a)opensuse.org
To contact the owner, email: opensuse-project+owner(a)opensuse.org
On 2/24/19 9:04 AM, jdd(a)dodin.org wrote:
done:
https://en.opensuse.org/openSUSE_talk:Membership_officials
I used the talk page of the Membership_official, it's free to write
there with any openSUSE account (it can be moved if a better place if
found)
Please read the page and edit it at will, for the content and for the
language, my English is limited :-(.
Feel free to open also sub-pages if what you have to say is a bit long
thanks
jdd
Hello all.
I think at the moment a wiki page to summarize the propositions could be
useful.
are you OK? can I process?
thanks
jdd
That sounds like a very good idea to me, jdd.
23 Feb
23 Feb
8:27 a.m.
New subject: [opensuse-project] huge amount of SPAM on opensuse-connect
On 23/02/2019 11:19, Christian Boltz wrote:
Hello,
[ I have about 50 unread mails in this discussion, so I might not have
seen all relevant comment yet.
One thing I noticed is that we have several volunteers. I'm really
happy about that :-) Please forgive me for answering only to one of
you ;-)
]
Am Freitag, 22. Februar 2019, 08:47:36 CET schrieb Ish Sookun:
Depends on how you define PITA and simple but i'm not doing the work so
I only care that its maintainable, for example you could export the
spreadsheet to a CSV then it'd just take some basic commandline tools to
split out the email address's
On 2/22/19 1:22 AM, Vinzenz Vietzke wrote:
In a mail nearby, jdd asked the right question:
and why is a *cloud* storage needed to manage membership?
Using nextcloud with a LibreOffice Calc document in it would be a bad
idea IMHO. Not because my personal preference is ownCloud ;-) but
because it makes things more complicated than necessary. For example,
extracting the mail aliases out of a LibreOffice table would be a PITA,
or in general, automating anything would be a PITA.
Came up twice already: take a Nextcloud, drop an
LibreOffice Calc
document there. It's not the shiny knight on a white horse solution
but it should be enough to
a) keep the membership committee working
b) store the member's data safe
c) get rid of this ugly spam dump called connect.o.o
Agreed. We start simple. So let's start even more simple and less cloudy,
please ;-)
If we go for "a table that can only be edited by the membership
committee", then I'd propose to use
a MySQL database + phpMyAdmin
The interface would look a bit more "technical", but not too different/
difficult, and it would have several advantages:
- extracting the mail aliases out of a database is boring and easy
(much easier than extracting them from a binary[1] LibreOffice file)
- setting up the server is easy
- we could easily track changes, for example with a daily CSV export
that gets auto-commited to a git repo (not a requirement for the
initial implementation, just an idea for the future)
- if we setup a "request membership" form, writing to a database is much
easier than writing to a LibreOffice document
The hard part is to convert the data from connect.o.o to the new
database scheme. (I never looked at the database scheme used by
connect.o.o, therefore I have no idea how hard this will be.)
Writing/updating the export scripts (for example for the mail aliases)
is also some work, but not really hard.
On the other hand expecting all the membership officials to learn how to
do direct database entry could be considered more of a PITA so please
make sure there willing to learn if we go down this route.
--
Simon Lees (Simotek) http://simotek.net
Emergency Update Team keybase.io/simotek
SUSE Linux Adelaide Australia, UTC+10:30
GPG Fingerprint: 5B87 DB9D 88DC F606 E489 CEC5 0922 C246 02F0 014B
--
To unsubscribe, e-mail: opensuse-project+unsubscribe(a)opensuse.org
To contact the owner, email: opensuse-project+owner(a)opensuse.org
I volunteer for this. Will check Heroes where I
can set this up.
I'm happy to hear that :-)
Getting a VM (IMHO: for phpMyAdmin and an empty database) shouldn't be
too hard ;-) Please write a mail to the heroes mailinglist to request
it, and while on it, please also request access to the VPN and the
connect.o.o database.
Until that setup is done, you can already start on the drawing board
with stuff like "which columns will we need?" I know it sounds boring,
but I'm also sure nobody will get this right on the first attemp ;-)
On the positive side, adding a column later is easy, so don't worry too
much.
10:12 p.m.
New subject: [opensuse-project] huge amount of SPAM on opensuse-connect
On 2/22/19 11:27 PM, Simon Lees wrote:
On the other hand expecting all the membership officials to learn how to
do direct database entry could be considered more of a PITA so please
make sure there willing to learn if we go down this route.
I do not think that should be necessary, at all.
Simple forms, automated, should be all that is necessary.
Note that if it is MySQL, f.e., it can be secured, and can also be
accessible across the infrastructure to the authorized individuals, and
can allow real-time web access and generation for any future needs.
--
-Gerry Makaro
openSUSE Member
openSUSE Global Moderator
openSUSE Contributor
YaST Contributor
aka Fraser_Bell on the Forums, OBS, IRC, and mail at openSUSE.org
Fraser-Bell on Github
--
To unsubscribe, e-mail: opensuse-project+unsubscribe(a)opensuse.org
To contact the owner, email: opensuse-project+owner(a)opensuse.org
693
days inactive
697
days old
54 comments
19 participants
participants (19)
-
Axel Braun -
Carlos E. R. -
Christian Boltz -
Christian Imhorst -
christian.imhorst＠posteo.de -
Fraser_Bell -
hellcp＠opensuse.org -
Ish Sookun -
jdd＠dodin.org -
Knurpht-openSUSE -
Lars Vogdt -
Mathias Homann -
medwinz -
medwinz -
Michael Ströder -
Per Jessen -
Richard Brown -
Simon Lees -
Vinzenz Vietzke