+1-888-365-2779
Try Now
More in this section

Forums / Bugs & Issues / Sitefinity instructions for using MySql

Sitefinity instructions for using MySql

11 posts, 0 answered
  1. Sam Eads
    Sam Eads avatar
    5 posts
    Registered:
    02 Dec 2009
    08 Dec 2009
    Link to this post
    I'm evaluating CMS solutions for our company and I saw that Sitefinity supported MySql, which is a requirement for our solution.

    So after futzing with this for 3 hours I'm ready to concede that I need the Sitefinity installation specifics for MySql support.  Can you point me to them, as they are not included in InstallationGuide_3_7.pdf?
  2. Radoslav Georgiev
    Radoslav Georgiev avatar
    3370 posts
    Registered:
    01 Feb 2016
    08 Dec 2009
    Link to this post
    Hello Sam Eads,

    Thank you for your interest in our CMS.

    Let me guide you through the steps of configuring Sitefinity to use MySQL database.

    1) Create a new user in MySQL Administrator (otherwise you will have to use root credentials).

    2) Create a new schema in MySQL Administrator.

    3) Assign privileges to the new user you have created for the new database.

    4) Run Sitefinity Project Manager, choose to create a new website. At the point for choosing the DB choose MySQL, enter the server address, user name, password and the schema name.

    Please refer to attached images for guidance.

    Best wishes,
    Radoslav Georgiev
    the Telerik team

    Instantly find answers to your questions on the new Telerik Support Portal.
    Watch a video on how to optimize your support resource searches and check out more tips on the blogs.
  3. Sam Eads
    Sam Eads avatar
    5 posts
    Registered:
    02 Dec 2009
    08 Dec 2009
    Link to this post
    thanks but I had already done that and was at step 7 and gave up:

    5) Setup procedure blows up trying to select from 'proc' table in mysql schema

    6) give user select access to 'proc' table in mysql schema

    7) get another error, give up and post question on message board.  error:

    [MySqlException (0x80004005): There is already an open DataReader associated with this Connection which must be closed first.]
       MySql.Data.MySqlClient.MySqlCommand.CheckState() +291
       MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior) +59
       MySql.Data.MySqlClient.MySqlCommand.ExecuteNonQuery() +43
       MySql.Data.MySqlClient.MySqlTransaction.Rollback() +86
       Nolics.ORMapper.DataProviders.Connection.EndTransaction() +37
       Nolics.ORMapper.DataProviders.SQLDataProvider.ReleaseConnection(Connection con) +63
       Nolics.ORMapper.DataProviders.SQLBlockBuilder.Dispose() +38
       Nolics.ORMapper.DataProviders.SQLDataProvider.Update(DataSet updateData) +2014
       Nolics.ORMapper.Base.Transaction.Commit(Boolean fCleanIfSuccess) +910
       Nolics.ORMapper.Base.Transaction.Commit() +10
       Telerik.DataAccess.AspnetProviders.Application.GetApplication(String name, OdbDataProvider odbProvider) +306
       Telerik.DataAccess.AspnetProviders.TelerikRoleProvider.get_Application() +29
       Telerik.DataAccess.AspnetProviders.TelerikRoleProvider.RoleExists(String roleName) +11
       Telerik.Security.UserManager.RoleExists(String roleName) +34
       Telerik.Cms.Web.AdministratorPane.ValidateMembership() +68
       Telerik.Cms.Web.AdministratorPane.RaisePostBackEvent(String eventArgument) +45
       System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +13
       System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +175
       System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1565


  4. Radoslav Georgiev
    Radoslav Georgiev avatar
    3370 posts
    Registered:
    01 Feb 2016
    08 Dec 2009
    Link to this post
    Hello Sam Eads,

    The error says that there is another process that is accessing data from this schema and requires that this DataReader is closed first before you can continue. Can you, please close all connections to this DB before running the project start-up wizard?

    Also you should use at least MySql 5.1 as Sitefinity does not support MySql versions prior to that.

    All the best,
    Radoslav Georgiev
    the Telerik team

    Instantly find answers to your questions on the new Telerik Support Portal.
    Watch a video on how to optimize your support resource searches and check out more tips on the blogs.
  5. Sam Eads
    Sam Eads avatar
    5 posts
    Registered:
    02 Dec 2009
    08 Dec 2009
    Link to this post
    No, that's NOT what it says.  It says, your code tried to open 2 data readers using one database connection (i.e. there's a bug in your code, or at least you have code that can't handle an improperly configured setup).  The improperly configured setup could exist because there is no information on how to configure MySql with Sitefinity.

    I know I'm new to the board, but don't assume that I'm a junior level system admin.  I'm a senior level developer who develops in .NET using M$SQL and MySql.

    other warts I've found:

    1. Building Sitefinity with MySql connector 5.0.7.0 but installing it with 6.0.3.0
    2. assuming default.aspx is a default document type in IIS

    I've installed other CMS such as Joomla and blog software such as Wordpress and I have to say this Sitefinity install is the most difficult install I've had in a while.  If I didn't have my current level of understanding of IIS and ASP.NET, I would have been stuck a long time ago.

    Your QA people need to take a fresh MySQL install on a fresh Windows install and run through this process.
  6. Radoslav Georgiev
    Radoslav Georgiev avatar
    3370 posts
    Registered:
    01 Feb 2016
    08 Dec 2009
    Link to this post
    Hi Sam Eads,

    Thank you for getting back to me.

    By default Sitefinity ships with MySql connector 5.07, so there is no need that you use MySql connector additionally to create Sitefinity websites connected to MySql databases. We have tested using Sitefinity with MySql db and have not came across this issue before. Could you please list a complete set of steps that you have taken to reach this exception. When I am using the steps from my first post I am not able to reproduce this behavior? Also that is the version of the MySql server which you are using? On my side it is MySql 5.1.37.

    Can you, please try the steps I have outlined in a new project, which does not have a reference to the MySql connector version 6.0.3.

    As for the installation documentation - we are aware that the documentation is lacking information regarding certain topics. I want to assure you that we are currently working on improving this.

    Looking forward to your response. We would be more than happy to help you set up Sitefinity.

    Sincerely yours,
    Radoslav Georgiev
    the Telerik team

    Instantly find answers to your questions on the new Telerik Support Portal.
    Watch a video on how to optimize your support resource searches and check out more tips on the blogs.
  7. Sam Eads
    Sam Eads avatar
    5 posts
    Registered:
    02 Dec 2009
    08 Dec 2009
    Link to this post
    system:

    My Dell development workstation:
    XP SP3
    Visual Studio 2008
    M$SQL Tools 2005
    M$SQL Tools 2008
    MySql GUI Tools 1.2.17
    No local MySQL server
    MySql .NET Connector V5.2.3 installed
    No other MySql .NET connector versions installed i.e 6.0.3 came ONLY from the Sitefinity distribution

    tried running using MySql 5.0.22 on Linux but ended up getting error selecting from 'proc' table

    installed FRESH MySql 5.1.41 on Windows 2008 Server
    went through the creating site stuff and gave READ access to the 'proc' table in mysql schema

    -------------------------
    Here's the issue:  Your site setup thing is putting 6.0.3.0 connector in the directory.  I have no idea why it's doing that.  I overwrote it with the version we support (5.2.3.0), changed the web.config appropriately and it works now. 

    This leaves two questions:
    1. Where are you pulling 6.0.3.0 from into the site "bin" directory?
    2. Do we have to edit the web.config file to change the dependentAssemby section every time we create a new site?

  8. Sam Eads
    Sam Eads avatar
    5 posts
    Registered:
    02 Dec 2009
    08 Dec 2009
    Link to this post
    I just search my entire system.  The ONLY places I found the version 6.0.3.0 were:

    1. 3 sitefinity sites bin directory
    2. GAC for above 3 sites
    3. and the offender:
    C:\Program Files\Telerik\Sitefinity3.7\ProjectManager\App_Data-EmptyProject.zip

    to solve the root issue I did this:

    Edited C:\Program Files\Telerik\Sitefinity3.7\ProjectManager\App_Data-EmptyProject.zip:

    - replaced Mysql.data.dll with the 5.2.3.0 version
    - edit web.config to allow that dll to be substituted by adding this to the runtime section of the web.config:

      <runtime>
            .
            .
            .
            <assemblyIdentity name="MySql.Data" publicKeyToken="c5687fc88969c44d" />
            <bindingRedirect oldVersion="5.0.7.0" newVersion="5.2.3.0" />
          </dependentAssembly>
        </assemblyBinding>
      </runtime>

    Now when I create the site, it works without other tweaks.
  9. Radoslav Georgiev
    Radoslav Georgiev avatar
    3370 posts
    Registered:
    01 Feb 2016
    09 Dec 2009
    Link to this post
    Hello Sam Eads,

    Thank you for getting back to me.

    I have investigated the issue a bit more and with the information provided by you I can say that we have a bug in the latest SP of Sitefinity. Let me try to explain a little bit why it will not work with the assembly that is in the latest release. For data related operations we do use Nolics.NET ORM, Nolics by default works with MySql.Data v. 5.0.7.0 and this is the assembly that gets distributed with other versions of Sitefinity. We have been looking at the source control and this is the assembly that Sitefinity references to. However MySqlData 6.0.3.0 got into this version because when we built the project there was a piece of functionality referencing this assembly. So the new assembly replaces the one Sitefinity should work with.

    With the information provided by you we were able to pinpoint the issue and will fix it for next 3.x release. in the mean time what you can do is either to perform a binding redirect to the assembly that you use 5.2.3.0 or simply replace the one in the bin folder of your Sitefinity websites with the one that is attached to this thread. Note that Nolics.Net cannot work with MySql.Data v 6.0.3.0, therefore you get the data reader exception. 

    I have updated your Telerik Poits as this qualifies for a bug reported.

    If you have more questions or experience any other troubles, please feel free to contact Telerik Support or post in our forums.


    All the best,
    Radoslav Georgiev
    the Telerik team

    Instantly find answers to your questions on the new Telerik Support Portal.
    Watch a video on how to optimize your support resource searches and check out more tips on the blogs.
  10. diego
    diego avatar
    1 posts
    Registered:
    06 Apr 2011
    12 Apr 2011
    Link to this post
    hi, i have problems in configuring mysql with sitefinity
    the problem is that i can't see the mysql server in the set-database list (only sql express)
    my sitefinity version is 4.0 community edition
    can you hrlp me, please?
    thanx
    diego
  11. Ivan Dimitrov
    Ivan Dimitrov avatar
    16072 posts
    Registered:
    09 Dec 2016
    12 Apr 2011
    Link to this post
    Hi diego,

    Sitefinity 4.0 does not support MySql . We will provide the MySql support on a later stage, but not before Q2.

    Kind regards,
    Ivan Dimitrov
    the Telerik team

Register for webinar
11 posts, 0 answered