Help with mysql install

Post here for help with installing or upgrading mojoPortal pre-compiled release packages. When posting in this forum, please provide all relevant details. You may also want to review the installation or upgrading documentation.

If you have questions about using the source code or working with mojoPortal in Visual Studio, please post in the Developer forum.

Post here for help with installation of mojoPortal pre-compiled release packages

When posting in this forum, please try to provide as many relevant details as possible. Particularly the following:

  • What operating system were you running when the bug appeared?
  • What database platform is your site using?
  • What version of mojoPortal are you running?
  • What version of .NET do you use?
  • What steps are necessary to reproduce the issue? Compare expected results vs actual results.

You may also want to review the installation or upgrading documentation.

If you have questions about using the source code or working with mojoPortal in Visual Studio, please post in the Developer forum.

This thread is closed to new posts. You must sign in to post in the forums.
10/27/2009 4:07:40 PM
Gravatar
Total Posts 4

Help with mysql install

I am out of ideas I am hoping you all can help me. I am installing mojoPortal v2-3-1-9 at godaddy.com using mysql. I believe I followed all the documentation but obviously I must not otherwise I would have been successful. I uploaded all files to the root. Changed mediumtrust.user.config to user.config. Installed msql data layer dll's. I configured mysql server 5.0 per godaddy's documentation  I am getting an error "The system cannot connect to the MySQL database. Please check your connection string."

My database is named mojofpna2 and same user name. Here is the string I added to both user.config (password has been x'd out) : "<add key="MySqlConnectionString" value="Server=mojofpna2.db.5138866.hostedsource.com;Database=mojofpna2;Uid=mojofpna2;Pwd=Hxxx9" /> 

and web.config: "<add key="MSSQLConnectionString" value="server=mojofpna2.db.5138866.hostedsource.com;UID=mojofpna2;PWD=Hxxx9;database=mojofpna2" />"

Here is the pertinent part of the log as well: 2009-10-27 13:36:41,395 ERROR mojoPortal.Business.WebHelpers.CacheHelper - Error trying to obtain siteSettings
MySql.Data.MySqlClient.MySqlException: Unable to connect to any of the specified MySQL hosts.

Anyone have any idea what is my problem? Thanks in advance for your help.

Gregg

10/27/2009 5:10:10 PM
Gravatar
Total Posts 2162

Re: Help with mysql install

Are you sure you have the correct server name for your GoDaddy hosted MySQL server?

-Joe D.

10/27/2009 5:24:56 PM
Gravatar
Total Posts 4

Re: Help with mysql install

First let me say thanks for looking at my issue.  Here's what I copied from their configuration string for

  • Connector/Net 1.0 (.NET):
  • Server=mojofpna2.db.5138866.hostedresource.com; Port=3306; Database=mojofpna2; Uid=mojofpna2; Pwd='your password';
  • Thanks again.

    Gregg

    10/27/2009 5:30:20 PM
    Gravatar
    Total Posts 2162

    Re: Help with mysql install

    look closely at that Server= string. That isn't what you used. :-)

    I think your mojo connection string should be

    <add key="MySqlConnectionString" value="Server=mojofpna2.db.5138866.hostedresource.com;Database=mojofpna2;Uid=mojofpna2;Pwd=Hxxx9" />

    Put that in your user.config and then open and save your web.config.

    HTH,
    Joe D.

    10/27/2009 5:30:51 PM
    Gravatar
    Total Posts 18439

    Re: Help with mysql install

    Hi, 

    I'm pretty sure Joe Davis is right on this.

    It's extremely unlikely that they setup a special server name just for your db with the word mojo in it.

    Please try changing your server name to just 5138866.hostedresource.com or db.5138866.hostedresource.com and see if that solves it.

    Hope it helps,

    Joe

    10/28/2009 9:54:05 AM
    Gravatar
    Total Posts 4

    Re: Help with mysql install

    Joe. D nailed it. I needed an extra set of eyes. Thank you both for looking at it. I am buying you both a beer! Although others have written up their installs. I will also do a step by step of mine. It might help someone else and will be my guide for future reference.

    Gregg

    12/9/2009 11:40:22 AM
    Gravatar
    Total Posts 1

    Re: Help with mysql install

    Hello

    I also try to install mojo with MySQL database , I read document but not clear much about this step:

    ======================================================================

    What this means is that if you want to use MySQL with mojoPortal, you should download the MS SQL release files and the MySQL Data Layer for mojoPortal. Then you should copy the dlls from the MySql data layer download into the /bin folder overwriting any files by the same name.

    ======================================================================

    => I see the DLL Files but not know what the /bin folder belong to? In the source code directory or in Web Host folder? COuld anyone clarify more?

    Khoa

    12/10/2009 10:00:44 AM
    Gravatar
    Total Posts 2162

    Re: Help with mysql install

    If you are simply trying to run mojoPortal and you will not be developing custom modules or anything like that, you shouldn't use the Source Code. You should use the Deployment files. All you need to do to use MySQL is download the mojoportal-2-3-3-0-mssql-deploymentfiles.zip and the mojoportal-2-3-3-0-mysqldatalayer-GPL.zip. After downloading, extract both zip files and copy the dll's from the mysqldatalayer zip to the bin directory of the mssql-deploymentfiles (it's inside of wwwroot).

    HTH,
    Joe D.

    12/10/2009 12:08:48 PM
    Gravatar
    Total Posts 18439

    Re: Help with mysql install

    Joe Davis is correct the MySql dll download is only for production deployment of pre-compiled files not for working with source code.

    If you are working with the source code no separate download is needed, you just have to change the references from the business layer projects to the corresponding MySql Data layer projects.

    Hope it helps,

    Joe

    You must sign in to post in the forums. This thread is closed to new posts.