[hibernate-dev] Forum database banned emails issue

[Sanne Grinovero]

I Vlad,
I'm sorry, it seems my credentials expired. I opened a ticket, it
might take some time though.
You might want to open a ticket to get credentials too.

Sanne

On 16 January 2016 at 11:42, Vlad Mihalcea <mihalcea.vlad at gmail.com> wrote:
> Thanks Sanne,
>
> In the Administration Control Panel -> Maintenance, there's the Admin log.
> You can see there the emails that I added to the ban, along with the date
> they were submitted: Fri Jan 15, 2016 9:16 am
>
> I was thinking of deleting 5k emails from the ban list that were added at
> that date.
> I hope the DB records the time-stamp info, or at least we can use the Ids.
>
> I added those progressively and when there were 40k/45k entries, the page
> was still loading.
>
> Vlad
>
> On Sat, Jan 16, 2016 at 1:25 PM, Sanne Grinovero <sanne at hibernate.org>
> wrote:
>>
>> It is documented here:
>>  - https://developer.jboss.org/wiki/ForumsAdministrationAccess
>>
>> However as you can see it's not easy to get to. You need to hop around
>> several security checks and get authorization from each party.
>>
>> I can help with this as I already have access - if I remember the
>> whole process ;-) - but you'll have to describe what you want me to do
>> exactly. Do I need to wipe a large amount of data from a table? And do
>> you have some example data to help me make sure I'm wiping the right
>> table? Also please let me know if this is urgent: seems like a quite
>> delicate matter and since I'm having a bit of fever now I'm afraid I'd
>> mess up with the production db :)
>>
>> Sanne
>>
>> On 15 January 2016 at 22:09, Steve Ebersole <steve at hibernate.org> wrote:
>> > Sorry, I have no idea.  That information is not listed in our private
>> > wiki
>> > area.  For anyone who knows this information, could you also update that
>> > resources page?
>> >
>> > On Fri, Jan 15, 2016 at 4:57 AM Vlad Mihalcea <mihalcea.vlad at gmail.com>
>> > wrote:
>> >
>> >> Hi,
>> >>
>> >> I tried to import the last 24 hour forum spam emails form
>> >> https://www.stopforumspam.com/, which is around 50k email entries.
>> >>
>> >> The email were imported, but now the banned email page of the forum
>> >> doesn't
>> >> load anymore.
>> >> The problem is related to how phpBB renders the page since there's a
>> >> dropdown where all emails must listed.
>> >>
>> >> Could someone delete a part of those entries or give me access to the
>> >> DB so
>> >> I can remove them myself?
>> >>
>> >> Vlad
>> >> _______________________________________________
>> >> hibernate-dev mailing list
>> >> hibernate-dev at lists.jboss.org
>> >> https://lists.jboss.org/mailman/listinfo/hibernate-dev
>> >>
>> > _______________________________________________
>> > hibernate-dev mailing list
>> > hibernate-dev at lists.jboss.org
>> > https://lists.jboss.org/mailman/listinfo/hibernate-dev
>
>