Jump to content

GDPR Compliance - Supporttopic

Fosters

By Fosters
in Marketplace

 Share

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
Share on other sites
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
Share on other sites
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
Share on other sites
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
Share on other sites
  • 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
Share on other sites
  • 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
Share on other sites
  • 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
Share on other sites
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
Share on other sites
  • 11 months later...
  • 2 months later...
  • 2 weeks later...
  • 1 year later...
derpunker Enthusiast

derpunker

Posted
Posted

@Fosters

New version has the same error as the old version.
Unfortunately not usable.

grafik.thumb.png.bd0279e77b3579276f2791b7a5a47abf.png

 

Please see 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.

 

Link to comment
Share on other sites
 Share
Go to topic listing

  • Recently Browsing   0 members

    • No registered users viewing this page.
Invision Community © 2023 IPS, Inc.
×
×
  • Create New...