{"id":221,"date":"2020-07-07T07:51:01","date_gmt":"2020-07-07T06:51:01","guid":{"rendered":"http:\/\/blog.c-hase.de\/?p=221"},"modified":"2020-08-11T13:52:20","modified_gmt":"2020-08-11T12:52:20","slug":"configuration-c-livemysqlserver-vs-localmysqlserver","status":"publish","type":"post","link":"https:\/\/blog.c-hase.de\/?p=221","title":{"rendered":"configuration c# LiveMySqlServer vs. LocalMySqlServer"},"content":{"rendered":"<p>in der web.config<\/p>\n<p>die Zeilen:<\/p>\n<p>&lt;membership defaultProvider=&#8220;MySQLMembershipProvider&#8220;&gt;<br \/>\n&lt;providers&gt;<br \/>\n&lt;remove name=&#8220;MySQLMembershipProvider&#8220; \/&gt;<br \/>\n&lt;add name=&#8220;MySQLMembershipProvider&#8220; autogenerateschema=&#8220;true&#8220; type=&#8220;MySql.Web.Security.MySQLMembershipProvider, MySql.Web, Version=6.7.9.0, Culture=neutral, PublicKeyToken=c5687fc88969c44d&#8220; connectionStringName=&#8220;LiveMySqlServer&#8220; enablePasswordRetrieval=&#8220;false&#8220; enablePasswordReset=&#8220;true&#8220; requiresQuestionAndAnswer=&#8220;true&#8220; applicationName=&#8220;\/&#8220; requiresUniqueEmail=&#8220;false&#8220; passwordFormat=&#8220;Clear&#8220; maxInvalidPasswordAttempts=&#8220;5&#8243; minRequiredPasswordLength=&#8220;7&#8243; minRequiredNonalphanumericCharacters=&#8220;1&#8243; passwordAttemptWindow=&#8220;10&#8243; passwordStrengthRegularExpression=&#8220;&#8220; \/&gt;<br \/>\n&lt;\/providers&gt;<br \/>\n&lt;\/membership&gt;<br \/>\n&lt;profile defaultProvider=&#8220;MySQLProfileProvider&#8220;&gt;<br \/>\n&lt;providers&gt;<br \/>\n&lt;remove name=&#8220;MySQLProfileProvider&#8220; \/&gt;<br \/>\n&lt;add name=&#8220;MySQLProfileProvider&#8220; autogenerateschema=&#8220;true&#8220; type=&#8220;MySql.Web.Profile.MySQLProfileProvider, MySql.Web, Version=6.7.9.0, Culture=neutral, PublicKeyToken=c5687fc88969c44d&#8220; connectionStringName=&#8220;LiveMySqlServer&#8220; applicationName=&#8220;\/&#8220; \/&gt;<br \/>\n&lt;\/providers&gt;<br \/>\n&lt;\/profile&gt;<br \/>\n&lt;roleManager defaultProvider=&#8220;MySQLRoleProvider&#8220;&gt;<br \/>\n&lt;providers&gt;<br \/>\n&lt;remove name=&#8220;MySQLRoleProvider&#8220; \/&gt;<br \/>\n&lt;add name=&#8220;MySQLRoleProvider&#8220; autogenerateschema=&#8220;true&#8220; type=&#8220;MySql.Web.Security.MySQLRoleProvider, MySql.Web, Version=6.7.9.0, Culture=neutral, PublicKeyToken=c5687fc88969c44d&#8220; connectionStringName=&#8220;LiveMySqlServer&#8220; applicationName=&#8220;\/&#8220; \/&gt;<br \/>\n&lt;\/providers&gt;<br \/>\n&lt;\/roleManager&gt;<\/p>\n<p>unter der Rubrik: &lt;system.web&gt;rausgenommen.<\/p>\n<p>Hatte den Fatalen Fehler zur Folge, dass der Transfer nicht mehr funktionierte.<\/p>\n<p>L\u00f6sung ist:<\/p>\n<p>Put the following in the web.config:<\/p>\n<p>&lt;connectionStrings configSource=&#8220;ConnectionStrings.config&#8220;&gt;<br \/>\n&lt;\/connectionStrings&gt;<\/p>\n<p>and then just maintain different ConnectionString.config files in each deployment.<\/p>\n<p>&lt;connectionStrings&gt;<br \/>\n&lt;add name=&#8220;ConnectionStringxxx&#8220; connectionString=&#8220;Data Source=xxx.xxx.xxx.xxx;Initial Catalog=Master;Integrated Security=True&#8220;<br \/>\nproviderName=&#8220;System.Data.SqlClient&#8220; \/&gt;<br \/>\n&lt;\/connectionStrings&gt;<\/p>\n<p>Your code can always refer to ConnectionStringxxx<\/p>\n","protected":false},"excerpt":{"rendered":"<p>in der web.config die Zeilen: &lt;membership defaultProvider=&#8220;MySQLMembershipProvider&#8220;&gt; &lt;providers&gt; &lt;remove name=&#8220;MySQLMembershipProvider&#8220; \/&gt; &lt;add name=&#8220;MySQLMembershipProvider&#8220; autogenerateschema=&#8220;true&#8220; type=&#8220;MySql.Web.Security.MySQLMembershipProvider, MySql.Web, Version=6.7.9.0, Culture=neutral, PublicKeyToken=c5687fc88969c44d&#8220; connectionStringName=&#8220;LiveMySqlServer&#8220; enablePasswordRetrieval=&#8220;false&#8220; enablePasswordReset=&#8220;true&#8220; requiresQuestionAndAnswer=&#8220;true&#8220; applicationName=&#8220;\/&#8220; requiresUniqueEmail=&#8220;false&#8220; passwordFormat=&#8220;Clear&#8220; maxInvalidPasswordAttempts=&#8220;5&#8243; minRequiredPasswordLength=&#8220;7&#8243; minRequiredNonalphanumericCharacters=&#8220;1&#8243; passwordAttemptWindow=&#8220;10&#8243; passwordStrengthRegularExpression=&#8220;&#8220; \/&gt; &lt;\/providers&gt; &lt;\/membership&gt; &lt;profile defaultProvider=&#8220;MySQLProfileProvider&#8220;&gt; &lt;providers&gt; &lt;remove name=&#8220;MySQLProfileProvider&#8220; \/&gt; &hellip; <a href=\"https:\/\/blog.c-hase.de\/?p=221\">Weiterlesen <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-221","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"_links":{"self":[{"href":"https:\/\/blog.c-hase.de\/index.php?rest_route=\/wp\/v2\/posts\/221","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.c-hase.de\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.c-hase.de\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.c-hase.de\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.c-hase.de\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=221"}],"version-history":[{"count":4,"href":"https:\/\/blog.c-hase.de\/index.php?rest_route=\/wp\/v2\/posts\/221\/revisions"}],"predecessor-version":[{"id":226,"href":"https:\/\/blog.c-hase.de\/index.php?rest_route=\/wp\/v2\/posts\/221\/revisions\/226"}],"wp:attachment":[{"href":"https:\/\/blog.c-hase.de\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=221"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.c-hase.de\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=221"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.c-hase.de\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=221"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}