CredScan: replace some benign passwords with [PLACEHOLDER] (#20915)

* CredScan: replace some benign passwords with [PLACEHOLDER]

* s/\blinq2\b/[PLACEHOLDER]/g

* Remove mcs/class/System.Data.Linq/examples/DbLinq.Ingres.Example/Program.cs from the CredScan suppression file; the "password" has been replaced by a CredScan-friendly placeholder

16 files changed, 24 insertions, 24 deletions

diff --git a/mcs/class/Mono.ServiceModel.IdentitySelectors/Test/resources/managed.xml b/mcs/class/Mono.ServiceModel.IdentitySelectors/Test/resources/managed.xml
index c66be3675d2..36c39269efb 100644
--- a/mcs/class/Mono.ServiceModel.IdentitySelectors/Test/resources/managed.xml
+++ b/mcs/class/Mono.ServiceModel.IdentitySelectors/Test/resources/managed.xml
@@ -64,7 +64,7 @@
       <BackgroundColor>0</BackgroundColor>

     </InformationCardMetaData>

     <InformationCardPrivateData>

-      <MasterKey>01234567890123456789IOverwroteThisAreaHeheh=</MasterKey>

+      <MasterKey>[PLACEHOLDER]</MasterKey>

     </InformationCardPrivateData>

   </RoamingInformationCard>

 </RoamingStore>

diff --git a/mcs/class/System.Data.Linq/examples/DbLinq.FbSql.Example/sql/create_Northwind.sql b/mcs/class/System.Data.Linq/examples/DbLinq.FbSql.Example/sql/create_Northwind.sql
index 07854159bb2..3ae55d634b5 100644
--- a/mcs/class/System.Data.Linq/examples/DbLinq.FbSql.Example/sql/create_Northwind.sql
+++ b/mcs/class/System.Data.Linq/examples/DbLinq.FbSql.Example/sql/create_Northwind.sql
@@ -7,7 +7,7 @@
 /*DROP USER 'LinqUser'@'%';*/

 

 

-/*## create user LinqUser, password: 'linq2'

+/*## create user LinqUser, password: '[PLACEHOLDER]'

 CREATE USER 'LinqUser'@'%'

   IDENTIFIED BY PASSWORD '*247E8BFCE2F07F00D7FD773390A282540001077B';*/

 

diff --git a/mcs/class/System.Data.Linq/examples/DbLinq.Ingres.Example/Program.cs b/mcs/class/System.Data.Linq/examples/DbLinq.Ingres.Example/Program.cs
index 704c35d47b2..50e3fd94460 100644
--- a/mcs/class/System.Data.Linq/examples/DbLinq.Ingres.Example/Program.cs
+++ b/mcs/class/System.Data.Linq/examples/DbLinq.Ingres.Example/Program.cs
@@ -43,7 +43,7 @@ namespace DbLinq.Ingres.Example
             icsb.Server = "(server)";

             icsb.Port = "II7";

             icsb.UserID = "LinqUser";

-            icsb.Password = "linq2";

+            icsb.Password = "[PLACEHOLDER]";

             icsb.Database = "northwind";

             nwind.Northwind db = new nwind.Northwind(new IngresConnection(icsb.ConnectionString));

 

diff --git a/mcs/class/System.Data.Linq/examples/DbLinq.MySql.Example/Program.cs b/mcs/class/System.Data.Linq/examples/DbLinq.MySql.Example/Program.cs
index a102194f8c7..9341d0e7fee 100644
--- a/mcs/class/System.Data.Linq/examples/DbLinq.MySql.Example/Program.cs
+++ b/mcs/class/System.Data.Linq/examples/DbLinq.MySql.Example/Program.cs
@@ -64,7 +64,7 @@ namespace DbLinq.MySql.Example
             string dbServer = Environment.GetEnvironmentVariable("DbLinqServer") ?? "localhost";

             // BUG: contexts must to be disposable

             string connStr = String.Format("server={0};user id={1}; password={2}; database={3}"

-                , dbServer, "LinqUser", "linq2", "Northwind");

+                , dbServer, "LinqUser", "[PLACEHOLDER]", "Northwind");

 

             Northwind db = new Northwind(new MySqlConnection(connStr));

 

@@ -175,7 +175,7 @@ namespace DbLinq.MySql.Example
         static void Main2(string[] args)

         {

             string connStr = String.Format("server={0};user id={1}; password={2}; database={3}"

-                , "localhost", "LinqUser", "linq2", "AllTypes");

+                , "localhost", "LinqUser", "[PLACEHOLDER]", "AllTypes");

             AllTypesExample.AllTypes db = new AllTypesExample.AllTypes(connStr);

             

 

@@ -184,4 +184,4 @@ namespace DbLinq.MySql.Example
         }

 #endif

     }

-}
\ No newline at end of file
+}

diff --git a/mcs/class/System.Data.Linq/examples/DbLinq.MySql.Example/nwind/Northwind_from_mysql.dbml b/mcs/class/System.Data.Linq/examples/DbLinq.MySql.Example/nwind/Northwind_from_mysql.dbml
index b45ada80a30..53fe94b3134 100644
--- a/mcs/class/System.Data.Linq/examples/DbLinq.MySql.Example/nwind/Northwind_from_mysql.dbml
+++ b/mcs/class/System.Data.Linq/examples/DbLinq.MySql.Example/nwind/Northwind_from_mysql.dbml
@@ -2,7 +2,7 @@
 <!-- Represents schema of Northwind sample database.

      Used for NUnit testing of SqlMetal functionality.

      Generated from Mysql via following command:

-     SqlMetal.exe -provider=MySql -database:Northwind -server:localhost -user:LinqUser -password:linq2 -namespace:nwind -dbml:Northwind_from_mysql.dbml -sprocs     

+     SqlMetal.exe -provider=MySql -database:Northwind -server:localhost -user:LinqUser -password:[PLACEHOLDER] -namespace:nwind -dbml:Northwind_from_mysql.dbml -sprocs     

 -->

 

 <Database xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" Name="Northwind" Class="Northwind" xmlns="http://schemas.microsoft.com/linqtosql/dbml/2007">

@@ -176,4 +176,4 @@
     <Parameter Name="custID" Type="int" DbType="int" Direction="In" />

     <Parameter Name="prodId" Type="int" DbType="int" Direction="In" />

   </Function>

-</Database>
\ No newline at end of file
+</Database>

diff --git a/mcs/class/System.Data.Linq/examples/DbLinq.MySql.Example/nwind/generate_AllTypes.bat b/mcs/class/System.Data.Linq/examples/DbLinq.MySql.Example/nwind/generate_AllTypes.bat
index c69a28eeb68..83703fcad7b 100644
--- a/mcs/class/System.Data.Linq/examples/DbLinq.MySql.Example/nwind/generate_AllTypes.bat
+++ b/mcs/class/System.Data.Linq/examples/DbLinq.MySql.Example/nwind/generate_AllTypes.bat
@@ -1,3 +1,3 @@
 REM you need to have DbMetal.exe compiled in the standard directory
 
-..\..\..\DbMetal\bin\DbMetal.exe -Provider=MySql -server:localhost -user:LinqUser -password:linq2 -database:AllTypes -namespace:AllTypesExample -code:AllTypes.cs 
\ No newline at end of file
+..\..\..\DbMetal\bin\DbMetal.exe -Provider=MySql -server:localhost -user:LinqUser -password:[PLACEHOLDER] -database:AllTypes -namespace:AllTypesExample -code:AllTypes.cs 
diff --git a/mcs/class/System.Data.Linq/examples/DbLinq.MySql.Example/sql/create_Northwind.sql b/mcs/class/System.Data.Linq/examples/DbLinq.MySql.Example/sql/create_Northwind.sql
index cfd6e70db57..dcc2896db3b 100644
--- a/mcs/class/System.Data.Linq/examples/DbLinq.MySql.Example/sql/create_Northwind.sql
+++ b/mcs/class/System.Data.Linq/examples/DbLinq.MySql.Example/sql/create_Northwind.sql
@@ -13,7 +13,7 @@ USE `Northwind`;
 /*DROP USER 'LinqUser'@'%';*/

 

 

-## create user LinqUser, password: 'linq2'

+## create user LinqUser, password: '[PLACEHOLDER]'

 ##CREATE USER 'LinqUser'@'%'

 ##  IDENTIFIED BY PASSWORD '*247E8BFCE2F07F00D7FD773390A282540001077B';

 

@@ -337,4 +337,4 @@ SET OrderDate=Now()
 WHERE ProductId=prodId AND CustomerID=custId;

 END $$

 

-DELIMITER ;
\ No newline at end of file
+DELIMITER ;

diff --git a/mcs/class/System.Data.Linq/examples/DbLinq.MySql.Example/sql/create_User.sql b/mcs/class/System.Data.Linq/examples/DbLinq.MySql.Example/sql/create_User.sql
index 0c47e3dfadc..0a1722a6466 100644
--- a/mcs/class/System.Data.Linq/examples/DbLinq.MySql.Example/sql/create_User.sql
+++ b/mcs/class/System.Data.Linq/examples/DbLinq.MySql.Example/sql/create_User.sql
@@ -1,5 +1,5 @@
-CREATE USER 'LinqUser'@'%'; SET PASSWORD FOR 'LinqUser'@'%' = PASSWORD('linq2');

+CREATE USER 'LinqUser'@'%'; SET PASSWORD FOR 'LinqUser'@'%' = PASSWORD('[PLACEHOLDER]');

 

 ##

 GRANT Select, Insert, Update, Delete, EXECUTE ON `Northwind`.* TO 'LinqUser'@'%';

-  FLUSH PRIVILEGES;
\ No newline at end of file
+  FLUSH PRIVILEGES;

diff --git a/mcs/class/System.Data.Linq/examples/DbLinq.MySql.Example/sql/run_myAndrus.bat b/mcs/class/System.Data.Linq/examples/DbLinq.MySql.Example/sql/run_myAndrus.bat
index 173cc0ed473..c8cf9d2a4b9 100644
--- a/mcs/class/System.Data.Linq/examples/DbLinq.MySql.Example/sql/run_myAndrus.bat
+++ b/mcs/class/System.Data.Linq/examples/DbLinq.MySql.Example/sql/run_myAndrus.bat
@@ -1,5 +1,5 @@
 REM: note that the '-sprocs' option is turned on
 
-..\..\..\SqlMetal\bin\MySqlMetal.exe -database:Andrus -server:localhost -user:LinqUser -password:linq2 -namespace:andrusDB -code:..\nwind\Andrus.cs -sprocs
+..\..\..\SqlMetal\bin\MySqlMetal.exe -database:Andrus -server:localhost -user:LinqUser -password:[PLACEHOLDER] -namespace:andrusDB -code:..\nwind\Andrus.cs -sprocs
 
 
diff --git a/mcs/class/System.Data.Linq/examples/DbLinq.Pgsql.Example/sql/install_readme.txt b/mcs/class/System.Data.Linq/examples/DbLinq.Pgsql.Example/sql/install_readme.txt
index 92fbcee5d15..ae71d844770 100644
--- a/mcs/class/System.Data.Linq/examples/DbLinq.Pgsql.Example/sql/install_readme.txt
+++ b/mcs/class/System.Data.Linq/examples/DbLinq.Pgsql.Example/sql/install_readme.txt
@@ -1,4 +1,4 @@
-Create user "LinqUser" with password: linq2

+Create user "LinqUser" with password: [PLACEHOLDER]

 

 In order to install the sql scripts you need to use "psql" located in you \bin directory

  of your PostgreSql installation:

@@ -13,4 +13,4 @@ If you are using PgAdmin3 you first need to execute the create database part of
 and then change to the newly created database in order to execute the rest of the script.

 

 Currently there are names in the scripts with mixed case names, but because quotes are not used around the names

-Postgresql accepts them as lower case names! You can then access them only by naming them lower case. 
\ No newline at end of file
+Postgresql accepts them as lower case names! You can then access them only by naming them lower case. 

diff --git a/mcs/class/System.Data.Linq/examples/DbLinq.SQLite.Example/sql/create_User.sql b/mcs/class/System.Data.Linq/examples/DbLinq.SQLite.Example/sql/create_User.sql
index 0c47e3dfadc..0a1722a6466 100644
--- a/mcs/class/System.Data.Linq/examples/DbLinq.SQLite.Example/sql/create_User.sql
+++ b/mcs/class/System.Data.Linq/examples/DbLinq.SQLite.Example/sql/create_User.sql
@@ -1,5 +1,5 @@
-CREATE USER 'LinqUser'@'%'; SET PASSWORD FOR 'LinqUser'@'%' = PASSWORD('linq2');

+CREATE USER 'LinqUser'@'%'; SET PASSWORD FOR 'LinqUser'@'%' = PASSWORD('[PLACEHOLDER]');

 

 ##

 GRANT Select, Insert, Update, Delete, EXECUTE ON `Northwind`.* TO 'LinqUser'@'%';

-  FLUSH PRIVILEGES;
\ No newline at end of file
+  FLUSH PRIVILEGES;

diff --git a/mcs/tools/sqlmetal/src/DbMetal/run_ingMetal.bat b/mcs/tools/sqlmetal/src/DbMetal/run_ingMetal.bat
index 1c4a7297399..b8f5260a4bd 100644
--- a/mcs/tools/sqlmetal/src/DbMetal/run_ingMetal.bat
+++ b/mcs/tools/sqlmetal/src/DbMetal/run_ingMetal.bat
@@ -1,3 +1,3 @@
-bin\DbMetal.exe -user:LinqUser -database:Northwind -server:localhost -password:linq2 -namespace:nwind -Provider=Ingres /entityInterfaces=IModified /pluralize /sprocs
+bin\DbMetal.exe -user:LinqUser -database:Northwind -server:localhost -password:[PLACEHOLDER] -namespace:nwind -Provider=Ingres /entityInterfaces=IModified /pluralize /sprocs
 
 
diff --git a/mcs/tools/sqlmetal/src/DbMetal/run_myMetal.bat b/mcs/tools/sqlmetal/src/DbMetal/run_myMetal.bat
index 36388c49930..ae877682736 100644
--- a/mcs/tools/sqlmetal/src/DbMetal/run_myMetal.bat
+++ b/mcs/tools/sqlmetal/src/DbMetal/run_myMetal.bat
@@ -1,5 +1,5 @@
 REM: note that the '-sprocs' option is turned on
 
-bin\DbMetal.exe -provider=MySql -database:Northwind -server:localhost -user:LinqUser -password:linq2 -namespace:nwind -code:Northwind.cs -sprocs
+bin\DbMetal.exe -provider=MySql -database:Northwind -server:localhost -user:LinqUser -password:[PLACEHOLDER] -namespace:nwind -code:Northwind.cs -sprocs
 
 
diff --git a/mcs/tools/sqlmetal/src/DbMetal/run_oraMetal.bat b/mcs/tools/sqlmetal/src/DbMetal/run_oraMetal.bat
index d28441124f4..4eb9aa0be53 100644
--- a/mcs/tools/sqlmetal/src/DbMetal/run_oraMetal.bat
+++ b/mcs/tools/sqlmetal/src/DbMetal/run_oraMetal.bat
@@ -1,5 +1,5 @@
 REM ##
-REM OracleMetal.exe -user:LinqUser -server:localhost -password:linq2 -namespace:nwind -renamesFile:oraFieldRenames.xml
+REM OracleMetal.exe -user:LinqUser -server:localhost -password:[PLACEHOLDER] -namespace:nwind -renamesFile:oraFieldRenames.xml
 
-bin\DbMetal.exe -user:Northwind -database:Northwind -server:localhost -password:linq2 -namespace:nwind -renamesFile:oraFieldRenames.xml
+bin\DbMetal.exe -user:Northwind -database:Northwind -server:localhost -password:[PLACEHOLDER] -namespace:nwind -renamesFile:oraFieldRenames.xml
 
diff --git a/mcs/tools/sqlmetal/src/DbMetal/run_pgMetal.bat b/mcs/tools/sqlmetal/src/DbMetal/run_pgMetal.bat
index 08435cba2b9..52d0a8f0667 100644
--- a/mcs/tools/sqlmetal/src/DbMetal/run_pgMetal.bat
+++ b/mcs/tools/sqlmetal/src/DbMetal/run_pgMetal.bat
@@ -1 +1 @@
-bin\DbMetal.exe /provider=PostgreSql /code=Northwind.cs -user:LinqUser -database:northwind -server:%%DbLinqServer??localhost -password:linq2 -namespace:nwind -renamesFile:pgsqlFieldRenames.xml -sprocs
+bin\DbMetal.exe /provider=PostgreSql /code=Northwind.cs -user:LinqUser -database:northwind -server:%%DbLinqServer??localhost -password:[PLACEHOLDER] -namespace:nwind -renamesFile:pgsqlFieldRenames.xml -sprocs
diff --git a/mcs/tools/sqlmetal/src/DbMetal/run_sqliteMetal.bat b/mcs/tools/sqlmetal/src/DbMetal/run_sqliteMetal.bat
index 75b6dbd0c45..93c42219e8e 100644
--- a/mcs/tools/sqlmetal/src/DbMetal/run_sqliteMetal.bat
+++ b/mcs/tools/sqlmetal/src/DbMetal/run_sqliteMetal.bat
@@ -7,7 +7,7 @@ type ..\Example\DbLinq.SQLite.Example\sql\create_Northwind.sql | sqlite3 Northwi
 type ..\Example\DbLinq.SQLite.Example\sql\create_AllTypes.sql | sqlite3 Northwind.db3
 
 REM: note that the '-sprocs' option is turned on
-REM MySqlMetal.exe -database:Northwind -server:localhost -user:LinqUser -password:linq2 -namespace:nwind -dbml:nwind_mysql.dbml -sprocs
+REM MySqlMetal.exe -database:Northwind -server:localhost -user:LinqUser -password:[PLACEHOLDER] -namespace:nwind -dbml:nwind_mysql.dbml -sprocs
 bin\SQLiteMetal.exe -database:Northwind.db3 -namespace:nwind -code:Northwind.cs
 
 pause