Problems getting MojoPortal Up & Running with Firebird

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.
7/29/2008 5:40:11 PM
Ace Grace
Gravatar
Total Posts 10
View Posts

Problems getting MojoPortal Up & Running with Firebird

Hi,

I am having a few problems:

1) I have downloaded the source version of Mojoportal, added the following line into the web.config file:

<connectionStrings>
<add name ="FirebirdConnectionString" connectionString="Data Source=localhost;Server Type=0;Port Number=3050;Database=C:\Users\mike\Firebird Databases\MojoPortal.FDB;Dialect=3;Charset=UTF8;Pooling=True;Min Pool Size=0;Max Pool Size=200;Connection Timeout=10;Connection Lifetime=60;Fetch Size=200;User Id=SYSDBA;Password=xyz"
providerName="FirebirdSql.Data.FirebirdClient" />
</connectionStrings>

built the solution and navigated to the setup/default.aspx. However I keep getting the following error:

Probing system...
File system permissions ok.
The system cannot connect to the FirebirdSql database. Please check your connection string.

FirebirdSql.Data.FirebirdClient.FbException: I/O error for file CreateFile (open) "C:\Users\JoeAudette\devprojects\mojoportal\mojoportal.fdb" Error while trying to open file ---> I/O error for file CreateFile (open) "C:\Users\JoeAudette\devprojects\mojoportal\mojoportal.fdb" Error while trying to open file --- End of inner exception stack trace --- at FirebirdSql.Data.FirebirdClient.FbConnectionInternal.Connect() in C:\Users\JoeAudette\devprojects\mojoportal\joesandbox2\FirebirdSql.Data.FirebirdClient\FirebirdClient\FbConnectionInternal.cs:line 229 at FirebirdSql.Data.FirebirdClient.FbConnectionPool.Create() in C:\Users\JoeAudette\devprojects\mojoportal\joesandbox2\FirebirdSql.Data.FirebirdClient\FirebirdClient\FbConnectionPool.cs:line 238 at FirebirdSql.Data.FirebirdClient.FbConnectionPool.CheckOut() in C:\Users\JoeAudette\devprojects\mojoportal\joesandbox2\FirebirdSql.Data.FirebirdClient\FirebirdClient\FbConnectionPool.cs:line 161 at FirebirdSql.Data.FirebirdClient.FbConnection.Open() in C:\Users\JoeAudette\devprojects\mojoportal\joesandbox2\FirebirdSql.Data.FirebirdClient\FirebirdClient\FbConnection.cs:line 608 at mojoPortal.Data.DBPortal.DatabaseHelperGetConnectionError(String overrideConnectionInfo) in C:\MojoPortal\mojoPortal.Data.FirebirdSql\dbPortal.cs:line 520

The database does exist.

2) Why is there nothing in connection strings section in the web.config? Some example connection strings would be good.

3) Why does the web.config file in the source version look completely different to the one in the release zip file?

 

Regards

7/29/2008 5:48:05 PM
Joe Audette
Gravatar
Total Posts 18439
View Posts

Re: Problems getting MojoPortal Up & Running with Firebird

Hi,

Its not using the connection string you added. Even though ASP.NET 2.0 came out with the <connectionStrings section, we don't use it because it has disadvantages compared to just using <appSettings section.

If you look in <appSettings section of web.config, the connection string is already there, you just need to edit it:

<add key="FirebirdConnectionString" value="Data Source=localhost;Server Type=0;Port Number=3050;Database=C:\Users\JoeAudette\devprojects\mojoportal\mojoportal.fdb;Dialect=3;Charset=UTF8;Pooling=True;Min Pool Size=0;Max Pool Size=200;Connection Timeout=10;Connection Lifetime=60;Fetch Size=200;User Id=SYSDBA;Password=masterkey" />

But really what you should do is create a user.config file and put your connection string there, that way you have no svn conflict when you get updates because user.config is not under source control and it overrides what is in Web.config <appSettings

See my article on Web.config here for more info:

http://www.mojoportal.com/webconfig.aspx

Hope it helps,

Joe
 

7/29/2008 5:52:28 PM
Joe Audette
Gravatar
Total Posts 18439
View Posts

Re: Problems getting MojoPortal Up & Running with Firebird

Maybe you got the .zip download, but if you decide to work with it on an ongoing basis, I rcommend get the code from svn trunk:

http://www.mojoportal.com/tortoisesvn.aspx

Its always more up to date and generally stable, if any significant bug is reported about svn turnk it is usually fixed within 24 hours.

Best,

Joe

7/30/2008 3:13:39 AM
Ace Grace
Gravatar
Total Posts 10
View Posts

Re: Problems getting MojoPortal Up & Running with Firebird

Hi Joe,

Thanks for your help. I was editing a web.config file in the wrong folder. I have reextracted verything from SVN, created a user.config in the right place put in my firebird connection string, changed the reference to firebird in the business project and it works! :-)


Regards

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