thesoftwarehouse / fogger Goto Github PK

It's amazing tool for developers to achive data anonymization. Thanks for making it available to public.
I recently tried the tool locally. I notice fogger:run runs 0% to 99% real fast then it keep stuck at 99% for days.

I am new to this tool and could anyone suggest anything to fix it ?

Also PRs are not checked in Travis.

Hi everyone!

Thanks for your efforts!

It looks like fogger doesn't work with Postgres Enum type

worker_1  | In AbstractPlatform.php line 479:
worker_1  |                                                                                
worker_1  |   Unknown database type enum_paymentdocuments_transactiontype requested, Doct  
worker_1  |   rine\DBAL\Platforms\PostgreSQL94Platform may not support it.     

Hey,

I am looking for a tool like this, but I can see this tool has not had updates since 2019. Is it still being maintained? If not do anyone know a similar service that can:

• Copy data from one database to another
• Obfuscate personal data
• Be containerised with Docker
• Work with mSQL

From the comments you added support for MSSQL in 2019 and init does indeed recognise connection strings such as:

sqlsrv://user:pass@server/db

However whenever I try and spin up the container, I get the following error:

In SQLSrvException.php line 57:
SQLSTATE [IMSSP, -8]: An invalid connection option key type was received. Option key types must be strings.

I have tried various combinations of connection string such as:
sqlsrv://user:pass@server\db
sqlsrv://user:pass@server\\db
sqlsrv://user:pass@server:port/db
sqlsrv://user:{pass}@server/db

and also variations of

sqlsrv://server/db;username=user;password=pass;

But I keep getting the same error.

Please can you add an example for sql server to the README.md ?

I am interestimg is your software support postgress database masking? If yes, where can i see connection parameters syntax?
Thanks in advance,
Aleksandar Lukic

In faker one can choose the locale being used to generate values by using Faker\Factory::create('pt_BR');, how can I do something similar with fogger?

Hi, this looks promising for a data masking tool - however, I'm not hugely familiar with docker, compose etc. - does anyone have a simplified user guide for installing fogger. For example, do I need to git clone the repo, then from there do I need to modify the template docker-compose.yml file? will it install redis and all the other associated dependencies?

thanks!

WARNING: channel "pecl.php.net" has updated its protocols, use "pecl channel-update pecl.php.net" to update
pecl/sqlsrv requires PHP (version >= 7.3.0), installed version is 7.2.3
No valid packages found
install failed

If I update the version to 7.4 (errors with 7,3) there are additional issues.

Is there a Dockerfile for php 7.4?

Hi Guys,

First of all thank you for such a tool.

I am trying to add SOURCE_DATABASE_URL and TARGET_DATABASE_URL for SQL Server db in "docker-compose.yml" file like this.
environment:
SOURCE_DATABASE_URL: sqlsrv://MydbUser:MyPassword@MyHostname:port/MySourceDb
TARGET_DATABASE_URL: sqlsrv://MydbUser:MyPassword@MyHostName: port/MyTargetDb

I am getting below error when I fire "docker-compose up -d"
In SQLSrvException.php line 57:
SQLSTATE [IMSSP, -8]: An invalid connection option key type was received. Option key types must be strings.

Please let me know does fogger support SQL Server? If yes then what is wrong in my database URL?

Please add project description in github, so we can read it on projects list https://github.com/TheSoftwareHouse

Eg. composer.json description

GDPR friendly database masker

Hello, we try to use fogger to copy data between 2 PostgreSQL 11 databases, but getting the following error

SQLSTATE[25P02]: In failed sql transaction: 7 ERROR: current transaction is aborted, commands ignored until end of transaction block INSERT INTO "schema"."schema_migrations" ("version", "dirty") VALUES('39', '')

schema_migrations.dirty field type is boolean, but instead of inserting boolean value it inserts empty string

Some formal files needs to be included.

Hi all,

Great to have this!

I keep on getting this error

 Unknown database type _text requested, Doctrine\DBAL\Platforms\PostgreSQL100Platform may not support it.

is there a work around this?

Hi guys!
I am trying to mask the azure sql DB in a secure manner. Therefore, can I connect fogger with azure and I don't want to make a seperate dump.I want to deploy the changes in the existing DB.Is it possible with fogger?

For example:

I need to generate "National Insurance Numbers", these must match the pattern:
AB123456C

Faker doesn't have direct support for this, but I'm hoping I could do it by using three mask strategies and concatenating the results.

• Generate two random letters
• Generate six random digits
• Generate one random digit

Is this possible? Thanks.

Hi, does fogger support MSSQL? if so can you point me in the direction of some example config - in my case I don't want to import from a dump file, but rather point to the DB directly - is this possible?

Hello I want to install the fogger but I got error like in the previous image, the error is after do the docker-compose up.
i have the follow :
Windows 10 Pro
Docker Desktop Version 4.0.0

When we try to run a docker build by using the available docker file in the repo, its throws following errors

ERROR: failed to solve: process "/bin/sh -c apt-get update && apt-get install --no-install-recommends -y libpq-dev libzip-dev libpng-dev openssh-server libxrender1 libfontconfig1 libxext6 libfreetype6-dev libjpeg62-turbo-dev zlib1g-dev libicu-dev g++ unixodbc-dev libxml2-dev libaio-dev libmemcached-dev freetds-dev libssl-dev openssl nano wget curl" did not complete successfully: exit code: 100

anyone can help real quick ?

when I run docker-compose run --rm fogger fogger:init I get the error Command "fogger:init" is not defined.

Following the example from the readme, but I'm not sure what I missed.

Thanks!