Database setup

This forum is only for questions or discussions about working with the mojoPortal source code in Visual Studio, obtaining the source code from the repository, developing custom features, etc. If your question is not along these lines this is not the right forum. Please try to post your question in the appropriate forum.

Please do not post questions about design, CSS, or skinning here. Use the Help With Skins Forum for those questions.

This forum is for discussing mojoPortal development

You can monitor commits to the repository from this page. We also recommend developers to subscribe to email notifications in the developer forum as occasionally important things are announced.

Before posting questions here you might want to review the developer documentation.

Do not post questions about design, CSS, or skinning here. Use the Help With Skins Forum for those questions.

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

4/9/2009 12:12:59 AM

GotoHell

Total Posts 1

View Posts

Database setup

Hi,

I read about installation and deployment but havent tried anything yet,

I want to know all about the Database, rite from creation deployment and using it in my site.

I have created a blank database on the web server where i want to host my site.

Now how do i use the same database in my site, ( You have mentioned about the config file, that is understood)

but how does MOJO help me for this.

The dataAccess layer dll provided will help me to call the SP in the database, rite?

But if am using the pages created on mojo for my site, how do i access database in those pages?

I am really confused about the database.

Can you please tell me the whole procedure for the database creation and use?

Thanks & Regards,

Pramod

4/9/2009 5:26:33 AM

Joe Audette

Total Posts 18439

View Posts

Re: Database setup

Hi,

After you

1. upload all the mojoportal files

2. make sure the /Data folder is writable by the web process (this is nt the database its just where files get uploaded the server log is written, files are created etc.

3. rename user.config.sample to user.config and set the correct connection string for your database.

4. now visit yoursiteroot or yoursiteroot/Setup/Default.aspx

actually it should normally redirect from yoursiteroot to yoursiteroot;/Setup/Default.aspx if it detects that the database is not the correct version (ie no tables yet)

The setup page will detect if the mp_Sites table exists, if it does not it assumes its a new installation, if it does exist it assumes its an upgrade.

It will run a series of sql scripts to create the tables and stored procedures, ten your installation will be up to date and yu can access your site at yoursiteroot. It will create a home page with sme initial content and it will create and admin user with admin@admin.com and pwd = admin. You can login and change it.

If you want to learn how to develop your own features, start by the Hello World examples, then study the source code of an existing feature. There are lots of examples for how to do anything you need like connecting to the database. Its open source, get the code and learn from it.

Hope it helps,

Joe

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