Discussions
Categories
Groups
Community Home
Categories
INTERNAL ENABLEMENT
POPULAR
PUBLIC CLOUD
PRIVATE CLOUD
Quick Links
MY LINKS
HELPFUL TIPS
Back to website
Home
Intelligence (Analytics)
Security issue
daniel_v
Hello,<br />
<br />
I have remarked that my database password appear not-encrypted into the report file under the design section.<br />
<br />
<design:DataSetParameters><br />
<design:parameterDefinitions><br />
<design:inOutMode>In</design:inOutMode><br />
<design:attributes><br />
...<br />
</design:attributes><br />
<design:inputAttributes><br />
<design:elementAttributes><br />
<design:optional>false</design:optional><br />
<design:masksValue>false</design:masksValue><br />
<design:dynamicValueChoices><br />
<design:dataSetDesign><br />
<design:name>Agents</design:name><br />
<design:odaExtensionDataSetId>org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet</design:odaExtensionDataSetId><br />
<design:dataSourceDesign><br />
<design:name>vsl</design:name><br />
<design:odaExtensionId>org.eclipse.birt.report.data.oda.jdbc</design:odaExtensionId><br />
<design:publicProperties><br />
<design:properties><br />
<design:nameValue><br />
<design:name>odaDriverClass</design:name><br />
<design:value>org.postgresql.Driver</design:value><br />
</design:nameValue><br />
</design:properties><br />
<design:properties><br />
<design:nameValue><br />
<design:name>odaURL</design:name><br />
<design:value>jdbc:postgresql://localhost/db</design:value><br />
</design:nameValue><br />
</design:properties><br />
<design:properties><br />
<design:nameValue><br />
<design:name>odaUser</design:name><br />
<design:value>postgres</design:value><br />
</design:nameValue><br />
</design:properties><br />
<design:properties><br />
<design:nameValue><br />
<design:name><strong class='bbc'>odaPassword</strong></design:name><br />
<design:value><strong class='bbc'>CLEAR_PASSWORD</strong></design:value><br />
</design:nameValue><br />
<br />
<br />
-The value of the parameter <strong class='bbc'>odaPassword</strong> is not encrypted!<br />
<br />
Just to note that the database password is encrypted for the data-source definition :<br />
<property name="odaDriverClass">org.postgresql.Driver</property><br />
<property name="odaURL">jdbc:postgresql://localhost/db</property><br />
<property name="odaUser">postgres</property><br />
<encrypted-property name="odaPassword" encryptionID="base64"><strong class='bbc'>ENCRYPTED_PASSWORD</strong></encrypted-property><br />
<br />
<br />
Any help is very appreciated.<br />
Thanks in advance.<br />
<br />
Cheers
Find more posts tagged with
Comments
daniel_v
Hi,<br />
<br />
Thanks to Jason W. this question has been answered <a class='bbc_url' href='
http://www.eclipse.org/forums/index.php/mv/msg/275607/777901/#msg_777901'>HERE
(at the eclipse.org forum)</a> :<br />
<br />
Just removing the design value, so it looks like :<br />
<design:name><strong class='bbc'>odaPassword</strong></design:name><br />
<design:value></design:value><br />
<br />
and the problem is solved, the report still works as expected and the DB password is not shown
<br />
<br />
<br />
<br />
<blockquote class='ipsBlockquote' data-author="'daniel_v'" data-cid="93791" data-time="1326092944" data-date="09 January 2012 - 12:09 AM"><p>
Hello,<br />
<br />
I have remarked that my database password appear not-encrypted into the report file under the design section.<br />
<br />
<design:DataSetParameters><br />
<design:parameterDefinitions><br />
<design:inOutMode>In</design:inOutMode><br />
<design:attributes><br />
...<br />
</design:attributes><br />
<design:inputAttributes><br />
<design:elementAttributes><br />
<design:optional>false</design:optional><br />
<design:masksValue>false</design:masksValue><br />
<design:dynamicValueChoices><br />
<design:dataSetDesign><br />
<design:name>Agents</design:name><br />
<design:odaExtensionDataSetId>org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet</design:odaExtensionDataSetId><br />
<design:dataSourceDesign><br />
<design:name>vsl</design:name><br />
<design:odaExtensionId>org.eclipse.birt.report.data.oda.jdbc</design:odaExtensionId><br />
<design:publicProperties><br />
<design:properties><br />
<design:nameValue><br />
<design:name>odaDriverClass</design:name><br />
<design:value>org.postgresql.Driver</design:value><br />
</design:nameValue><br />
</design:properties><br />
<design:properties><br />
<design:nameValue><br />
<design:name>odaURL</design:name><br />
<design:value>jdbc:postgresql://localhost/db</design:value><br />
</design:nameValue><br />
</design:properties><br />
<design:properties><br />
<design:nameValue><br />
<design:name>odaUser</design:name><br />
<design:value>postgres</design:value><br />
</design:nameValue><br />
</design:properties><br />
<design:properties><br />
<design:nameValue><br />
<design:name><strong class='bbc'>odaPassword</strong></design:name><br />
<design:value><strong class='bbc'>CLEAR_PASSWORD</strong></design:value><br />
</design:nameValue><br />
<br />
<br />
-The value of the parameter <strong class='bbc'>odaPassword</strong> is not encrypted!<br />
<br />
Just to note that the database password is encrypted for the data-source definition :<br />
<property name="odaDriverClass">org.postgresql.Driver</property><br />
<property name="odaURL">jdbc:postgresql://localhost/db</property><br />
<property name="odaUser">postgres</property><br />
<encrypted-property name="odaPassword" encryptionID="base64"><strong class='bbc'>ENCRYPTED_PASSWORD</strong></encrypted-property><br />
<br />
<br />
Any help is very appreciated.<br />
Thanks in advance.<br />
<br />
Cheers<br /></p></blockquote>