Web Platform Installer Script for creating database tables does not work.

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.
11/24/2010 4:42:34 PM
Gravatar
Total Posts 9

Web Platform Installer Script for creating database tables does not work.

Every time I try to install MojoPortal via Web Platform Installer I get an error when it attempts to create the database files.  I used the SQL Server management Studio to create the database before my install attempt.  Here is the text in the log file:

[15:51:248]Source setAcl (wwwroot/Data) does not match destination (mojoportal//Data) differing in attributes (isDest,setAclUser,setAclAccess). Update pending.
[15:51:248]Adding setAcl (mojoportal//Data).
Details:
operationType: Add
providerName: setAcl
path: mojoportal//Data
[15:51:850]Source dbFullSql (msdeploy.config) does not match destination (data source=DAVID-LT\SQLExpress;database=mojoportal;uid=mojoadmin) differing in attributes (databaseName). Update pending.
[15:51:850]Adding dbFullSql (data source=DAVID-LT\SQLExpress;database=mojoportal;uid=mojoadmin).
Details:
operationType: Add
providerName: dbFullSql
path: data source=DAVID-LT\SQLExpress;database=mojoportal;uid=mojoadmin
[15:51:162]The database 'mojoportal' could not be created. 
Retrying operation 'Add' on object dbFullSql (data source=DAVID-LT\SQLExpress;database=mojoportal;uid=mojoadmin). Attempt 1 of 5.
Details:
originalMessage: The database 'mojoportal' could not be created.
operationType: Add
retryAttempt: 1
retryCount: 5
[15:51:347]The database 'mojoportal' could not be created. 

Is there a script that gets installed that I can use from within the SQL Management Studio?

Also, I updated my web.config to point to the correct database server, username and database.  <add key="MSSQLConnectionString" value="server=DAVID-LT\SQLEXPRESS;UID=mojoadmin;PWD=damar7714;database=mojoportal"/>

  When I attempt to run MojoPortal in VS2008, I get the following error:

Welcome to mojoPortal Setup
Probing system...
File system permissions ok.

The system cannot connect to the MSSQL database. Please check your connection string.


System.Data.SqlClient.SqlException: Login failed for user 'mojoadmin'. at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) at System.Data.SqlClient.SqlConnection.Open() at mojoPortal.Data.DBPortal.DatabaseHelperGetConnectionError(String overrideConnectionInfo)

Any suggestions?

Dave Martin

11/24/2010 5:03:57 PM
Gravatar
Total Posts 1201
Proud member of the mojoPortal team

Help support mojoPortal!
Add-on modules

Re: Web Platform Installer Script for creating database tables does not work.

Well, first off you should probably change your database password, since you inadvertently posted it here (unless that's randomized).

Secondly, I'm pretty sure that mojoPortal is only compatible with Visual Studio 2010 as of about five months ago.

I'm not an expert on SQL Server, but have you tried dropping the database? I assume it's empty since you are performing a new installation?

Also, be sure to check out this video. It's for a manual installation, but may help with any connection string issues and initializing the database.

If you are able to install Visual Studio 2010 and do a manual installation from the source, I'd recommend that route rather than the WPI.

Jamie

11/24/2010 7:54:29 PM
Gravatar
Total Posts 2192

Re: Web Platform Installer Script for creating database tables does not work.

Hi,

It seems to me like you are creating your database manually and then using the web platform installer to create your database. If you create a database named mojoportal and then run WPI and instruct it to create the database mojoportal, you will run into errors.

You can either instruct WPI to use an existing database or create the database, either way the schema for the database will be created because it isn't created by WPI anyway, it is created by the mojoPortal Setup routine (http://yoursite.url/Setup/default.aspx). As far as the database goes, all WPI is doing is either 1) creating the database (no schema) and writing the connection information to the user.config or 2) collecting the connection information from you and writing it to the user.config.

HTH,
Joe D.

 

 

11/25/2010 7:28:35 AM
Gravatar
Total Posts 18439

Re: Web Platform Installer Script for creating database tables does not work.

Hi,

There are a few common issues when using the platform installer. Your SQL Server must be configured for Mixed Mode Authentication so you can use sql users instead of windows users.

In order for it to create the db for you, you must know the sa user password (or another admin user). It does not validate this so if you enter something incorrect it just fails in an ugly way.

When you enter the information to create the new db user, is where things often go wrong and the error messages are not helpful. What you need to know is that it enforces some password rules, the password must be at least a certain length, it must have at least one upper case, one lower case, and one numeric , and one special character, a password example that meets the criteria is $Secret123

Note that the platform installer does not install the source code, it only installs a pre-compiled package, there is no C# source code included and no project or solution files, so when you open it in VS, it opens it as a "Web Site Project", but really our actual source code is not a Web Site Project but a lot of different projects in a solution and our main web project is a "Web Application Project" which has a .csproj file and lots of C# code files. To work with our actual source code you do need VS 2010 and you should get the code using TortoiseHG.

Note also that our package in the Web App Gallery is currently a package for .NET 3.5, once the Web Platform Installer 3.0 comes out of beta we will be changing our Web App Gallery Package to  .NET 4. Our source code is pre-configured for  .NET 4.

Hope it helps,

Joe

11/26/2010 11:55:50 AM
Gravatar
Total Posts 9

Re: Web Platform Installer Script for creating database tables does not work.

Thanks to everyone for their quick responses.  It's good to know if I take the plunge with this great tool, there will be someone there to help and help quickly. 

I finally got things to work.  I think I'm going to go ahead and install VS2010 and download the source code and try everything again.  I figure practice makes perfect.

I hope everyone had a wonderful Thanksgiving!

Dave :-)

12/8/2010 3:05:30 PM
Gravatar
Total Posts 9

Re: Web Platform Installer Script for creating database tables does not work.

I've actually used TortoiseHG and downloaded the source code.  I've got a few more questions now.  I want to use MojoPortal to create a customized portal.  I really don't want to modify any of the base code unless I have to.  I was actually thinking of using MP as is but add some special functionality to it.  Basically, it would work as designed and I'd point certain pages to my own apps that would run within the context of the MP framework.

My question is, when I approach it from this standpoint, do I still need all of the source code or is what's provided in the Web Platform Installer all I really need?

If I do need the source code, do I just copy the code from where I put the repository to my application folder or should I have created my repository in my application folder.

I'm hoping to create many web-sites with MP in the future.  I just want to make sure I start out on the right foot.

Any advise will be most appreciated.  Thanks!

Dave :-)

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