Reply to thread

Message

<blockquote data-quote="breese" data-source="post: 1135895" data-attributes="member: 114299">From what I am seing. the Gentle.config stores the user name and password (Line in RED for my mysql)This is also not Hiding the password and as such I changed the real password&lt;?xml version=&quot;1.0&quot; encoding=&quot;utf-8&quot;?&gt;&lt;Gentle.Framework&gt;&nbsp; &lt;!-- See the API documentation for the Gentle.Framework.GentleSettings class for&nbsp; detailed information on the keys available in the Options section --&gt;&nbsp; &lt;Options&gt;&nbsp; &lt;!-- the default timeout value in seconds for IDbCommand instances created by Gentle --&gt;&nbsp; &lt;CommandTimeout&gt;30&lt;/CommandTimeout&gt;&nbsp; &lt;!-- whether to enable support for Gentle-managed concurrency control columns --&gt;&nbsp; &lt;ConcurrencyControl&gt;false&lt;/ConcurrencyControl&gt;&nbsp; &lt;!-- options: Attributes or XML (XML currently unused) --&gt;&nbsp; &lt;MasterDefinition&gt;Attributes&lt;/MasterDefinition&gt;&nbsp; &lt;Analyzer&gt;&nbsp; &lt;!-- options: None, OnDemand (the default), Full --&gt;&nbsp; &lt;Level&gt;OnDemand&lt;/Level&gt;&nbsp; &lt;!-- whether to warn about unmapped columns and other non-fatal errors --&gt;&nbsp; &lt;Silent&gt;false&lt;/Silent&gt;&nbsp; &lt;/Analyzer&gt;&nbsp; &lt;Cache&gt;&nbsp; &lt;!-- default cache strategy (use only Never or Temporary) --&gt;&nbsp; &lt;DefaultStrategy&gt;Temporary&lt;/DefaultStrategy&gt;&nbsp; &lt;CacheStatements&gt;true&lt;/CacheStatements&gt;&nbsp; &lt;CacheObjects&gt;true&lt;/CacheObjects&gt;&nbsp; &lt;!-- when true Gentle will try to bypass query execution and compose&nbsp; the result from cached data alone --&gt;&nbsp; &lt;SkipQueryExecution&gt;true&lt;/SkipQueryExecution&gt;&nbsp; &lt;!-- the scope within which to ensure uniqing &nbsp; options: Thread (default), Application or WebSession --&gt;&nbsp; &lt;UniqingScope&gt;Application&lt;/UniqingScope&gt;&nbsp; &lt;/Cache&gt;&nbsp; &lt;Logging&gt;&nbsp; &lt;!-- This setting controls the lowest log level emitted. See the&nbsp; Verbosity enum for details on the available values. --&gt;&nbsp; &lt;Verbosity&gt;Warning&lt;/Verbosity&gt;&nbsp; &lt;!-- Do not edit this unless you know what you're doing. This setting&nbsp; &nbsp; controls at what level error conditions are considered fatal.&nbsp; --&gt;&nbsp; &lt;Frailty&gt;Warning&lt;/Frailty&gt;&nbsp; &lt;!-- Use values defined in the LogCategories enum to turn logging on/off&nbsp; &nbsp; for selected categories. The available values include:&nbsp;&nbsp; All (all categories)&nbsp;&nbsp; StatementExecutionRead (select statements)&nbsp;&nbsp; StatementExecutionWrite (insert/update/delete statements)&nbsp;&nbsp; StatementExecutionOther (any other kind of statement)&nbsp;&nbsp; StatementExecution (any kind of statement; same as all three groups above)&nbsp;&nbsp; Cache (cache accesses)&nbsp;&nbsp; Metadata (metadata updates)&nbsp;&nbsp; General (everything else) --&gt;&nbsp; &lt;!-- The following sample first disables all categories, then selectively&nbsp; turns on various subcategories --&gt;&nbsp; &lt;Category name=&quot;All&quot; enabled=&quot;false&quot; /&gt;&nbsp; &lt;Category name=&quot;StatementExecution&quot; enabled=&quot;false&quot; /&gt;&nbsp; &lt;Category name=&quot;Cache&quot; enabled=&quot;false&quot; /&gt;&nbsp; &lt;Category name=&quot;Metadata&quot; enabled=&quot;false&quot; /&gt;&nbsp; &lt;/Logging&gt;&nbsp; &lt;/Options&gt;&nbsp; &lt;!--&nbsp; &nbsp; &lt;NamespaceProviders&gt;&nbsp; &lt;Namespace namespace=&quot;Gentle.First&quot;&nbsp; provider=&quot;SQLServer&quot; connectionstring=&quot;...&quot; /&gt;&nbsp; &lt;Namespace namespace=&quot;Gentle.Second&quot; provider=&quot;SQLServer&quot; connectionString=&quot;...&quot; /&gt;&nbsp; &lt;/NamespaceProviders&gt;&nbsp; --&gt;&nbsp; &lt;DefaultProvider name=&quot;MySQL&quot; connectionString=&quot;Server=Bugsbunny;Database=MpTvDb;User ID=breese;Password=PASSWORD;charset=utf8;Connection Timeout=30;&quot; /&gt;&nbsp; &lt;!--&nbsp; &lt;DefaultProvider name=&quot;Firebird&quot; connectionString=&quot;User=SYSDBA;Password=masterkey;Data Source=TvLibrary.fdb;ServerType=1;Charset=UNICODE_FSS;&quot; /&gt;&nbsp; &lt;DefaultProvider name=&quot;Jet&quot; connectionString=&quot;Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Code\Gentle.NET\Source\Gentle.Framework.Tests\Database Files\Gentle_MSAccess.mdb;OLE DB Services=-1;&quot; /&gt;&nbsp; &lt;DefaultProvider name=&quot;MySQL&quot; connectionString=&quot;Server=10.0.0.2;Database=test;User ID=xxx;Password=xxx&quot; /&gt;&nbsp; &lt;DefaultProvider name=&quot;PostgreSQL&quot; connectionString=&quot;Server=10.0.0.2;Database=Test;User ID=xxx;Password=xxx&quot; /&gt;&nbsp; &lt;DefaultProvider name=&quot;Oracle&quot; connectionString=&quot;Data Source=kermit.symbiote.sporadicism.com,1521;User ID=gentle;password=xxx&quot; /&gt;&nbsp; &lt;DefaultProvider name=&quot;OracleODP&quot; connectionString=&quot;Data Source=kermit.symbiote.sporadicism.com,1521;User ID=gentle;password=xxx&quot; /&gt;&nbsp; &lt;DefaultProvider name=&quot;SQLite&quot; connectionString=&quot;URI=file:c:/Code/Gentle.NET/Source/Gentle.Framework.Tests/Database Files/Gentle_SQLite.db&quot; /&gt;&nbsp; &lt;DefaultProvider name=&quot;SQLServer&quot; connectionString=&quot;data source=127.0.0.1;initial catalog=Test;user id=xxx;password=xxx;packet size=4096&quot; /&gt;&nbsp; --&gt;&nbsp; &lt;!-- IMPORTANT: You must uncomment ONLY the providers that you will be using. If a provider &nbsp; is defined below, but Gentle cannot find or load the associated library, an exception&nbsp; will most likely be raised! --&gt;&nbsp; &lt;Providers&gt;&nbsp; &lt;!-- list known provider assemblies; the assembly .dll suffix is optional --&gt;&nbsp; &lt;!-- Provider name=&quot;CE&quot;&nbsp; assembly=&quot;Gentle.Provider.CE&quot; /--&gt;&nbsp; &lt;!-- Provider name=&quot;Firebird&quot;&nbsp; assembly=&quot;Gentle.Provider.Firebird&quot; /--&gt;&nbsp; &lt;!-- Provider name=&quot;Jet&quot;&nbsp; assembly=&quot;Gentle.Provider.Jet&quot; /--&gt;&nbsp; &lt;Provider name=&quot;MySQL&quot; assembly=&quot;Gentle.Provider.MySQL.dll&quot; /&gt;&nbsp; &lt;!-- Provider name=&quot;Oracle&quot;&nbsp; assembly=&quot;Gentle.Provider.Oracle&quot; /--&gt;&nbsp; &lt;!-- Provider name=&quot;OracleODP&quot;&nbsp; assembly=&quot;Gentle.Provider.OracleODP&quot; /--&gt;&nbsp; &lt;!-- Provider name=&quot;PostgreSQL&quot; assembly=&quot;Gentle.Provider.PostgreSQL&quot; /--&gt;&nbsp; &lt;!-- Provider name=&quot;SQLite&quot;&nbsp; assembly=&quot;Gentle.Provider.SQLite&quot; / --&gt;&nbsp; &lt;Provider name=&quot;SQLServer&quot; assembly=&quot;Gentle.Provider.SQLServer&quot; /&gt;&nbsp; &lt;!-- Provider name=&quot;Sybase&quot;&nbsp; assembly=&quot;Gentle.Provider.Sybase&quot; / --&gt;&nbsp; &lt;!-- Provider name=&quot;SybaseASA&quot;&nbsp; assembly=&quot;Gentle.Provider.SybaseASA&quot; / --&gt;&nbsp; &lt;/Providers&gt;&lt;/Gentle.Framework&gt;</blockquote>

[QUOTE="breese, post: 1135895, member: 114299"] From what I am seing. the Gentle.config stores the user name and password (Line in RED for my mysql) This is also not Hiding the password and as such I changed the real password [SIZE=1]<?xml version="1.0" encoding="utf-8"?> <Gentle.Framework>  <Options>  <CommandTimeout>30</CommandTimeout>  <ConcurrencyControl>false</ConcurrencyControl>  <MasterDefinition>Attributes</MasterDefinition> <Analyzer>  <Level>OnDemand</Level>  <Silent>false</Silent> </Analyzer> <Cache>  <DefaultStrategy>Temporary</DefaultStrategy> <CacheStatements>true</CacheStatements> <CacheObjects>true</CacheObjects>  <SkipQueryExecution>true</SkipQueryExecution>  <UniqingScope>Application</UniqingScope> </Cache> <Logging>  <Verbosity>Warning</Verbosity>  <Frailty>Warning</Frailty>   <Category name="All" enabled="false" /> <Category name="StatementExecution" enabled="false" /> <Category name="Cache" enabled="false" /> <Category name="Metadata" enabled="false" /> </Logging> </Options>  [B][COLOR=#ff0000] <DefaultProvider name="MySQL" connectionString="Server=Bugsbunny;Database=MpTvDb;User ID=breese;Password=PASSWORD;charset=utf8;Connection Timeout=30;" />[/COLOR][/B]   <Providers>     <Provider name="MySQL" assembly="Gentle.Provider.MySQL.dll" />     <Provider name="SQLServer" assembly="Gentle.Provider.SQLServer" />   </Providers> </Gentle.Framework>[/SIZE] [/QUOTE]

Verification