Mysql error

[denominator]

Any ideas why I'd get this error? It's a Mysql error message.

System.ArgumentException: Keyword not supported.
Parameter name: integrated security

[Spirited]

Originally Posted by denominator

Any ideas why I'd get this error? It's a Mysql error message.

System.ArgumentException: Keyword not supported.
Parameter name: integrated security

Integrated security? Isn't that a Microsoft SQL connection string param?

[denominator]

Originally Posted by Spirited

Integrated security? Isn't that a Microsoft SQL connection string param?

Correct but I'm trying to even find that reference in the source as all I am able to find is Persist Security Info=True;

Full error message is

[Sun, 19 May 2024 20:01:36 GMT] System.ArgumentException: Keyword not supported.
Parameter name: integrated security
   at MySql.Data.MySqlClient.MySqlConnectionStringBuilder.ValidateKeyword(String keyword)
   at MySql.Data.MySqlClient.MySqlConnectionStringBuilder.set_Item(String keyword, Object value)
   at System.Data.Common.DbConnectionStringBuilder.set_ConnectionString(String value)
   at MySql.Data.MySqlClient.MySqlConnection.set_ConnectionString(String value)
   at ConQuerSquad.Database.DataHolder.get_MySqlConnection() in D:\6711 Alinaser\Source 6711 3D\7Conquer Source\Database\DataHolderTable.cs:line 32
   at ConQuerSquad.Database.MySqlReader..ctor(MySqlCommand command) in D:\6711 Alinaser\Source 6711 3D\7Conquer Source\Database\MySql\MySqlReader.cs:line 40
   at ConQuerSquad.Server.Run() in D:\6711 Alinaser\Source 6711 3D\7Conquer Source\Server.cs:line 1047
   at ConQuerSquad.Program.Main(String[] args) in D:\6711 Alinaser\Source 6711 3D\7Conquer Source\Program.cs:line 26
System.ArgumentException: Keyword not supported.
Parameter name: integrated security
   at MySql.Data.MySqlClient.MySqlConnectionStringBuilder.ValidateKeyword(String keyword)
   at MySql.Data.MySqlClient.MySqlConnectionStringBuilder.set_Item(String keyword, Object value)
   at System.Data.Common.DbConnectionStringBuilder.set_ConnectionString(String value)
   at MySql.Data.MySqlClient.MySqlConnection.set_ConnectionString(String value)
   at ConQuerSquad.Database.DataHolder.get_MySqlConnection() in D:\6711 Alinaser\Source 6711 3D\7Conquer Source\Database\DataHolderTable.cs:line 32
   at ConQuerSquad.Database.MySqlReader..ctor(MySqlCommand command) in D:\6711 Alinaser\Source 6711 3D\7Conquer Source\Database\MySql\MySqlReader.cs:line 40
   at ConQuerSquad.Server.Run() in D:\6711 Alinaser\Source 6711 3D\7Conquer Source\Server.cs:line 1047
   at ConQuerSquad.Program.Main(String[] args) in D:\6711 Alinaser\Source 6711 3D\7Conquer Source\Program.cs:line 26

Line 32 is as follows MYSQLCONNECTION conn = new MYSQLCONNECTION

[Spirited]

Wow, I had no idea MySQL even supported Windows authentication.


Well, it looks like in the MySQL version of the connection string, it's one word - not two.

[denominator]

Originally Posted by Spirited

Wow, I had no idea MySQL even supported Windows authentication.


Well, it looks like in the MySQL version of the connection string, it's one word - not two.

Regardless I still don't see Integrated security or Integratedsecurity in the source?

[Spirited]

Originally Posted by denominator

Regardless I still don't see Integrated security or Integratedsecurity in the source?

I'd assume it's in a configuration file.

[denominator]

<?xml version="1.0"?>
<configuration>
  <configSections>
    <section name="SubSonicService" type="SubSonic.SubSonicSection, SubSonic" requirePermission="false"/>
  </configSections>
  <connectionStrings>
    <add name="Conquer_Server" connectionString="Server=localhost;Port=3306;Database=cq;Uid=root;Password=mypassword;Persist Security Info=True;Pooling=true; Min Pool Size = 32;  Max Pool Size = 300;" providerName="MySql.Data.MySqlClient"/>
  </connectionStrings>
  <SubSonicService defaultProvider="Conquer_Server">
    <providers>
      <clear/>
      <add name="Conquer_Server" type="SubSonic.MySqlDataProvider, SubSonic" connectionStringName="Conquer_Server" generatedNamespace="Conquer.Database"/>
    </providers>
  </SubSonicService>
  <runtime>
    <disableStackOverflowProbing enabled="true"/>
    <legacyUnhandledExceptionPolicy enabled="true"/>
    <assemblyBinding xmlns="urn:schemas-microsoft-com:asm.v1">
      <dependentAssembly>
        <assemblyIdentity name="SubSonic" publicKeyToken="EADB47849839A332" culture="neutral"/>
        <bindingRedirect oldVersion="0.0.0.0-2.2.0.0" newVersion="2.2.0.0"/>
      </dependentAssembly>
      <dependentAssembly>
        <assemblyIdentity name="MySql.Data" publicKeyToken="C5687FC88969C44D" culture="neutral"/>
        <bindingRedirect oldVersion="0.0.0.0-6.3.6.0" newVersion="6.3.6.0"/>
      </dependentAssembly>
    </assemblyBinding>
  </runtime>
  <appSettings>
    <add key="ClientSettingsProvider.ServiceUri" value=""/>
  </appSettings>
  <system.web>
    <membership defaultProvider="ClientAuthenticationMembershipProvider">
      <providers>
        <add name="ClientAuthenticationMembershipProvider" type="System.Web.ClientServices.Providers.ClientFormsAuthenticationMembershipProvider, System.Web.Extensions, Version=4.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35" serviceUri=""/>
      </providers>
    </membership>
    <roleManager enabled="true" defaultProvider="ClientRoleProvider">
      <providers>
        <add name="ClientRoleProvider" type="System.Web.ClientServices.Providers.ClientRoleProvider, System.Web.Extensions, Version=4.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35" serviceUri="" cacheTimeout="86400"/>
      </providers>
    </roleManager>
  </system.web>
  <startup>
    <supportedRuntime version="v4.0" sku=".NETFramework,Version=v4.0"/>
  </startup>
</configuration>

About the only form of config that I can find, error has been fixed thanks to a good friend