mojoPortal install using MS SQL Server

has excellent installation documentation available here.  However that documentation is not specific to installing your mojoPortal CMS  on Arvixe into your own ASP Hosting package.
Lets get started.

Download the latest mojoPortal deployment files here.
Once there, simply click on a Download image button like this
and the latest version of mojoPortal (about 20 Meg) will start downloading.

On your PC copy the downloaded file into a new empty folder and extract it’s zipped content.
The contents of the folder will look like this.

To install mojoportal we need all the folder and files inside the this wwwroot folder to be copied to the server.  That’s almost 8,000 files and we are only concerned with editing one.  Before we do that lets first Login to your Arvixe Control Panel and create your mojoPortal MS SQL database and User, because we need that database information to edit the file.

Login to your Control Panel and click Web Sites on the Web icon like below.


We don’t need to select a specific Web Site because the database is independent of individual Web Sites.


From the menu at the left select Databases > SQL Server 2008.

The next screen lists all your existing databases and users you have created.

First lets create your database user.  Click on the Create User button.


Please, for security reasons enter a complex password!  You are not the only person using this database engine.
Enter a new User Name then enter a new Password twice then click the Save button.

Next let’s create a Database and assign your new User to that database.

Enter the new database name then select the checkbox with the new user you just created then click Save.
That’s it for creating a new Database and User.  Easy!

Editing the connection string in the user.config file.

Now lets go back to our new mojoPortal files.  Open the wwwroot folder and scroll down to the file user.config.sample and open it with notepad or another text editor.  We are just going to edit a few values on one line in the file.  In the picture below I show the existing line with the revised line below it.

The line we are editing is the connection string where we tell mojoPortal how to connect to the new database you just created.  Change the text after the =
1) change UID=mojouser to the new user you just created.
2) change the PWD=mojo123 to the password you assigned to your new user
3) change the database=mojo to the name of your new SQL Server 2008 database you just created.
NOTE: server=(local) and server=localhost will both work.
The SQL Server 2008 database engine being used on your Arvixe ASP package is MS SQL EXPRESS.

Save the file and then either copy it or rename it from user.config.sample to user.config.
There that’s the only file you need to change.

Uploading the files

Now we can upload/copy all 8000 folders and files in the wwwroot folder into you websites wwwroot folder.
I like to zip up all the files into one zip file and then copy that one zip file to the Web Site but both ways work.

In your Control Panel we will use the File Manager.  The menu link for File Manager is 2 below the Database menu item as can be seen in the image below.

When you open File Manager your Web Site Name will be listed there like my hubka.com site below.

Simply click on the name of your Web Site (it is a link) and we will navigate to the folders inside it.
After clicking hubka.com I have a few folders with one called wwwroot which is the root of your Web Site.  Se below.

Click on the word/link wwwroot and we are taken into that folder where all our mojoPortal folders and files need to be.  If there is a few html files in this folder now, you should delete them now before we start by clicking the checkbox on the left of the file names and then click the delete button to the upper right which will delete all checked files.

Now, let’s upload the mojoPortal folders and files.

Clicking on the Upload button above will allow you to upload files from your PC to the wwwroot folder of your Web Site.  Go ahead and upload the single zip file now.  The time is takes to upload the files to the server depends on the speed of your internet connection.  Once the upload is complete we can unzip the file as seen below.

Simply click the checkbox to the left of the zip file you uploaded then click the Unzip button.

We are almost done.  After uploading the files we need to make sure the /App_Data and  /Data folders are writable.  However we can deal with this later because, by default on a new Web Site with Arvixe, all folders and files in your Web Site are Read and Write which allows the mojoPortal setup to run with no problems (I hope).

After the installation the Security aspects of full Read and Write needs to be changed and is covered by me in another blog.  See the end of this blog for more information.

Finally, we run the mojoPortal Setup

To run the mojoPortal setup scripts and create your new mojoPortal CMS we need to navigate to the Setup Folder on your new site like the image below.  The setup is run from the setup folder.  Simply replace my last name (hubka.com) with your Web Site URL and the Setup process will run.  The major part of the setup process is creating database tables and other data related things for your new Web Site.

Once setup completes you will see a link which you click to go to your new mojoPortal CMS and you will be able to sign in using admin@admin.com and the password admin.  The next thing you should do is go to the MyAccount page and change the password and change the email address to your own email address.  After doing that you should sign out and then sign in again using your real email address and new password.

Done!

Well almost.  There is some security items that should be dealt with very soon.  I cover the 2 main security issues in two blogs already posted on Arvixe under the mojoPortal Category and here are the links.

Setting Folder/File permissions for mojoPortal

Securing mojoPortal with a Custom Machine Key

Well there we have it.  Enjoy your new mojoPortal CMS Web Site.

Take Care and Happy Hosting

Rick Hubka

Tags: , , , , , , , | Posted under ASP .NET 3.5, MojoPortal, MSSQL, Using Arvixe | RSS 2.0

2 Comments on mojoPortal install using MS SQL Server

  1. Nasser says:

    Hi,
    useful documentation, thank you ,

  2. Hennadiy says:

    Thanks Rick, this info is very usefull….

Leave a Reply

Your email address will not be published. Required fields are marked *


+ 3 = 7

You may use these HTML tags and attributes: <a href="" title="" rel=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>