Jump to content

GDPR Compliance - Supporttopic

Fosters

By Fosters
in Marketplace

Recommended Posts

derpunker Enthusiast

derpunker

Posted
Posted

Hello,

First of all, I would like to say thank you for this plugin ??

I reviewed it and I think that there are still two tables left, where the IP addresses are not deleted.

  1. core_members_known_ip_addresses
    -> there is a association between IP address and member_id
  2. core_members
    -> there is the "joined" IP address saved

 

It would be nice if the plugin would clean up these tables too.

 

Link to comment
Fosters Veteran

Fosters

Posted
  • Author
Posted
11 hours ago, Michael Grote said:

Is there anything to configure related to this tool?

No, there are no settings yet, this application uses the default IP address prune setting from IPS .

Quote

This will remove IP addresses from user posted content after the specified number of days

 

8 hours ago, derpunker said:

Hello,

First of all, I would like to say thank you for this plugin ??

I reviewed it and I think that there are still two tables left, where the IP addresses are not deleted.

  1. core_members_known_ip_addresses
    -> there is a association between IP address and member_id
  2. core_members
    -> there is the "joined" IP address saved

 

It would be nice if the plugin would clean up these tables too.

 

Thanks.

A new version was uploaded to the Marketplace addressing this 2 issues:)

Link to comment
derpunker Enthusiast

derpunker

Posted
Posted (edited)

I think there is a little problem.

When running the task, i got this error:

image.png.e86ec9d52e9e216374b6d394155e96b5.png

 

The database column for timestamp in the table core_members_known_ip_addresses is named "last_seen".

image.thumb.png.c20d27711c9cce3e3b46c5cbd5e25cc3.png

 

I have changed the column name temporary in the filesystem and after the change I got this error:

image.png.7ccf50f8950931d192cc967c00424403.png

Cleaning this table seems not to be so easy.
The column "ip_address" is marked as ip_address "UNIQUE" und a lot of empty strings are not unique ?
What do you think about removing the whole database row instead of cleaning only the ip_address field?

 

I new version would be nice. All other tables are cleaned as expected.

Edited by derpunker
Link to comment
Michael Grote Explorer

Michael Grote

Posted
Posted (edited)

Hi,

I installed version 1.0.5. one week ago. The ACP setting (Remove IP addresses after) is set to 90 days.

When looking at the IP addresses belonging to a member (via ACP -> Member -> <selecting a member> -> View all IP Addresses) there are still a lot of members with IP addresses older than the 90 days threshold (even back to 1999).

Edited by Michael Grote
Link to comment
  • 8 months later...
  • 2 weeks later...
derpunker Enthusiast

derpunker

Posted
Posted

Thx for the IPS4.4 release 🙂

I found some files where the '\' is missing in the file header.

if ( !\defined( '\IPS\SUITE_UNIQUE_KEY' ) )
{
    header( ( isset( $_SERVER['SERVER_PROTOCOL'] ) ? $_SERVER['SERVER_PROTOCOL'] : 'HTTP/1.0' ) . ' 403 Forbidden' );
    exit;
}

Link to comment
  • 2 weeks later...
jamesluck01 Rookie

jamesluck01

Posted
Posted
On 6/8/2018 at 11:01 AM, Fosters said:

https://invisioncommunity.com/files/file/9017-gdpr-compliance/

Roadmap:

  • Include Support for all our other released apps and plugins, so that they can register their database tables and columns where IP Addresses are logged

I purchased this and I am now being told I need to re-purchase it. I have a paypal receipt / transaction but no access to download the file. @Fosters

Link to comment
  • 3 months later...
Michael Grote Explorer

Michael Grote

Posted
Posted

 Hi,

after the upgrade to IPS 4.4.4 with the actual GDPR CompliIance the tasks fails with 

Exception:
IPS\Db\Exception Object
(
    [query] => DELETE FROM `ibf_core_members_known_ip_addresses` WHERE time<=1555573982
    [binds] => Array
        (
        )

    [message:protected] => Unknown column 'time' in 'where clause'
    [string:Exception:private] => 
    [code:protected] => 1054
    [file:protected] => /var/customers/webs/mgfvlw/test/system/Db/Db.php
    [line:protected] => 631
    [trace:Exception:private] => Array
        (
            [0] => Array
                (
                    [file] => /var/customers/webs/mgfvlw/test/system/Db/Db.php
                    [line] => 1280
                    [function] => preparedQuery
                    [class] => IPS\_Db
                    [type] => ->
                    [args] => Array
                        (
                            [0] => /*IPS\gdprannoyance\tasks\_pruneOtherIpAddresses::execute:255*/ DELETE FROM `ibf_core_members_known_ip_addresses` WHERE time<=1555573982
                            [1] => Array
                                (
                                )

                        )

                )

            [1] => Array
                (
                    [file] => /var/customers/webs/mgfvlw/test/applications/gdprannoyance/tasks/pruneOtherIpAddresses.php
                    [line] => 86
                    [function] => delete
                    [class] => IPS\_Db
                    [type] => ->
                    [args] => Array
                        (
                            [0] => core_members_known_ip_addresses
                            [1] => Array
                                (
                                    [0] => time<=1555573982
                                )

                        )

                )

            [2] => Array
                (
                    [file] => /var/customers/webs/mgfvlw/test/system/Task/Task.php
                    [line] => 255
                    [function] => execute
                    [class] => IPS\gdprannoyance\tasks\_pruneOtherIpAddresses
                    [type] => ->
                    [args] => Array
                        (
                        )

                )

            [3] => Array
                (
                    [file] => /var/customers/webs/mgfvlw/test/system/Task/Task.php
                    [line] => 224
                    [function] => run
                    [class] => IPS\_Task
                    [type] => ->
                    [args] => Array
                        (
                        )

                )

            [4] => Array
                (
                    [file] => /var/customers/webs/mgfvlw/test/applications/core/interface/task/task.php
                    [line] => 62
                    [function] => runAndLog
                    [class] => IPS\_Task
                    [type] => ->
                    [args] => Array
                        (
                        )

                )

        )

    [previous:Exception:private] => 
)

Any ideas?

Michael

Link to comment
derpunker Enthusiast

derpunker

Posted
Posted (edited)

I think it's the same problem like here

 

On 3/19/2019 at 11:20 PM, derpunker said:

I found a new bug:

image.thumb.png.d9f0c1119433b85b5ae3b4e7a0001560.png

 

==> the task is not running!

 

The database column is named "last_seen".

The column id was changed in the last updated (1.1.0), which seems to be a mistake.

Meanwhile I fixed it by my self, because no patch was provided.

Edited by derpunker
Link to comment
  • 11 months later...
  • 2 months later...
  • 2 weeks later...
  • 1 year later...
Go to topic listing

  • Recently Browsing   0 members

    • No registered users viewing this page.

  • Upcoming Events

    No upcoming events found
Invision Community © 2024 IPS, Inc.
×
×
  • Create New...