One config file for multiple databases/file systems

[jayeshagwan1]

Can we use one config file for multiple databases/file systems so that the command will be same always for any type of supported system ?

[vrajat]

Do you mean something like:

[db1]
....

[db2]
....

And choose one through the command line like ?

piicatcher --config cfg.ini db --name db1

I am depending on https://pypi.org/project/click-config-file/ for config file to save effort and right now it doesn't support it.

[jayeshagwan1]

After migrating to config file, deep search is not working. I have 2 tables in db, but result is showing only 1st table.

config file :
[db]
host="10.10.XXX.XXX"
port="3306"
user="XXX"
password="XXXX"
database="XX"
connection-type="mysql"
output-format="json"
scan-type="deep"
list-all=True

[vrajat]

Checking. Just to confirm, the second table is listed of command line arguments are used ? —scan-type? Or deep scan has completely stopped working?

…

On Mon, 20 Jan 2020 at 13:57, jayeshagwan1 ***@***.***> wrote: After migrating to config file, deep search is not working. I have 2 tables in db, but result is showing only 1st table. [image: image] <https://user-images.githubusercontent.com/616970/72710150-70136180-3b8c-11ea-933a-8c206459641e.png> [image: image] <https://user-images.githubusercontent.com/616970/72710212-96d19800-3b8c-11ea-8a70-9cf0c6a2ffe1.png> config file : [db] host="10.10.XXX.XXX" port="3306" user="XXX" password="XXXX" database="XX" connection-type="mysql" output-format="json" scan-type="deep" list-all=True — You are receiving this because you commented. Reply to this email directly, view it on GitHub <#49?email_source=notifications&email_token=AAMP7GSSPNWY2SJ6G5BUPILQ6VN57A5CNFSM4KG5G4XKYY3PNVWWK3TUL52HS4DFVREXG43VMVBW63LNMVXHJKTDN5WW2ZLOORPWSZGOEJLYSLY#issuecomment-576162095>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/AAMP7GTI4NZFHLFQ5BAOOQTQ6VN57ANCNFSM4KG5G4XA> .

[jayeshagwan1]

Ohh. Even after passing --scan-type in config file, we need to explicitely pass --scan-type deep in cli. Then only it works:

[vrajat]

OK. So only the config file part is broken. I’ll fix it.

…

On Mon, 20 Jan 2020 at 20:39, jayeshagwan1 ***@***.***> wrote: Ohh. Even after passing --scan-type in config file, we need to explicitely pass *--scan-type deep* in cli. Then only it works: [image: image] <https://user-images.githubusercontent.com/616970/72737119-f2b81300-3bc4-11ea-88a4-231fff2f2622.png> — You are receiving this because you commented. Reply to this email directly, view it on GitHub <#49?email_source=notifications&email_token=AAMP7GSH4IBSG46PKUUC3S3Q6W5EJA5CNFSM4KG5G4XKYY3PNVWWK3TUL52HS4DFVREXG43VMVBW63LNMVXHJKTDN5WW2ZLOORPWSZGOEJM6B4Y#issuecomment-576315635>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/AAMP7GW5NWXXMZXBGUE5GWDQ6W5EJANCNFSM4KG5G4XA> .

[vrajat]

I made a mistake in documentation. It should scan_type and not scan-type. Can you give it a try with scan_type ? Fixing the docs

[jayeshagwan1]

Its working fine now. Just one thing. It takes around 6-10 min to return the result

[vrajat]

closing as piicatcher uses a catalog to store database info.