Genesys CTI User Forum

Genesys CTI User Forum => Genesys CTI Technical Discussion => Topic started by: SorinM on March 14, 2013, 03:17:12 PM

Title: Datamart user password encryption in ETl files
Post by: SorinM on March 14, 2013, 03:17:12 PM: Hello,

It is written that ETL Runtime has a password encryption option for cfguser passowrd and also for datamart user password.
Can somebody tell me hot to encrypt this? It is like for config server, to run etl application with -p parameter?

Thank you!
Title: Re: Datamart user password encryption in ETl files
Post by: Kubig on March 14, 2013, 03:36:50 PM: There is no reason for encrypt etl.properties file. This file is necessary only during the deployment and first start-up.
Title: Re: Datamart user password encryption in ETl files
Post by: Fra on March 14, 2013, 04:38:42 PM: [quote author=Kubig link=topic=7715.msg33366#msg33366 date=1363275410]
There is no reason for encrypt etl.properties file. This file is necessary only during the deployment and first start-up.
[/quote]
Not true. etl.properties file is used during runtime.

On top of that, I think the question was around the *password* encryption of the cfguser, not the file encryption.

SorinM, were you referring to the CfgUserPasswordEncrypted option? If you were, you can encrypt your password by using the gutils.jar utility included in the Data Mart package, as far as I recall.

Fra
Title: Re: Datamart user password encryption in ETl files
Post by: cavagnaro on March 14, 2013, 04:40:50 PM: I though the same Fra, but found one deployment where the properties files were empty (no config done) and ETL was working fine....I was surprised too...seems ETL uses CfgServer now to get those options from the DAP
Title: Re: Datamart user password encryption in ETl files
Post by: Fra on March 14, 2013, 04:56:16 PM: I know, that is a bit of a grey area, however, the CCAnalyzer command lines usually indicate a -conf option that points to the etl.properties file; not sure what it happens when that is not configured..

Fra
Title: Re: Datamart user password encryption in ETl files
Post by: cavagnaro on March 14, 2013, 06:21:06 PM: Yes I know that, that was my understanding too. But I found this deployment and works...I will have to do a lab to be able to understand it more correctly but so far seems properties files are no longer needed unless running from bat files.
Title: Re: Datamart user password encryption in ETl files
Post by: Timur Karimov on March 14, 2013, 07:30:14 PM: [quote author=cavagnaro link=topic=7715.msg33371#msg33371 date=1363285266]
...unless running from bat files.
[/quote]
Exactly
Title: Re: Datamart user password encryption in ETl files
Post by: Kubig on March 14, 2013, 08:16:41 PM: Yes, as I wrote this file is no longer need (I think from 7.0+) for running properly. rather is better have file empty or with "dummy" values, because if anyone,who does not know about that,can start ETL backend script (purge, createdb,..) and re-write existing data,I know that is a unlikely scenario, but never say never :-)
Title: Re: Datamart user password encryption in ETl files
Post by: SorinM on March 15, 2013, 07:21:39 AM: Thanks all for answers!

I was talking about the cfguser and also DBA user in etl.properties. I will make a test with dummy passwords after finishing the upgrade to see it's ok
Title: Re: Datamart user password encryption in ETl files
Post by: GMG on March 19, 2013, 04:50:36 PM: Hi,

Which ETL version you are using, I remember 7.6XX has a bug, it wouldn’t Encrypt the password

--
Gaurav Gupta
Title: Re: Datamart user password encryption in ETl files
Post by: SorinM on March 19, 2013, 04:53:55 PM: Hello,

Yes, I am 7.6
Title: Re: Datamart user password encryption in ETl files
Post by: GMG on March 19, 2013, 05:26:19 PM: Tell me the exact Version.

mean while try to use lower version... like 7.5XXX..... Tomorrow I will check and tell you the stable version. :)

--
Gaurav Gupta