Server Error in '/' Application
Can't cast Line into any valid DbType.

Description: HTTP 500. Error processing request.

Stack Trace:

System.InvalidCastException: Can't cast Line into any valid DbType.
at Npgsql.NpgsqlParameter..ctor (System.String parameterName, NpgsqlDbType parameterType, Int32 size, System.String sourceColumn) [0x00000]
at Npgsql.NpgsqlParameter..ctor (System.String parameterName, NpgsqlDbType parameterType) [0x00000]
at (wrapper remoting-invoke-with-check) Npgsql.NpgsqlParameter:.ctor (string,NpgsqlTypes.NpgsqlDbType)
at mojoPortal.Data.DBBlog.GetDrafts (Int32 moduleId) [0x00000]
at mojoPortal.Business.Blog.GetDrafts (Int32 moduleId) [0x00000]
at mojoPortal.Business.Blog.CountOfDrafts (Int32 moduleId) [0x00000]
at mojoPortal.Web.BlogUI.BlogModule.LoadSettings () [0x00000]
at mojoPortal.Web.BlogUI.BlogModule.Page_Load (System.Object sender, System.EventArgs e) [0x00000]
at System.Web.UI.Control.OnLoad (System.EventArgs e) [0x00000]
at System.Web.UI.Control.LoadRecursive () [0x00000]
at System.Web.UI.Control.LoadRecursive () [0x00000]
at System.Web.UI.Control.LoadRecursive () [0x00000]
at System.Web.UI.Control.LoadRecursive () [0x00000]
at System.Web.UI.Control.LoadRecursive () [0x00000]
at System.Web.UI.Control.LoadRecursive () [0x00000]
at System.Web.UI.Page.ProcessLoad () [0x00000]
at System.Web.UI.Page.ProcessPostData () [0x00000]
at System.Web.UI.Page.InternalProcessRequest () [0x00000]
at System.Web.UI.Page.ProcessRequest (System.Web.HttpContext context) [0x00000]

Version information: Mono Version: 2.0.50727.1433; ASP.NET Version: 2.0.50727.1433

Server Error in '/' Application
Could not load type 'mojoPortal.Web.MonoCompilationSection, mojoPortal.Web'.

Description: HTTP 500. Error processing request.

Stack Trace:

System.TypeLoadException: Could not load type 'mojoPortal.Web.MonoCompilationSection, mojoPortal.Web'.
at (wrapper managed-to-native) System.Type:internal_from_name (string,bool,bool)
at System.Type.GetType (System.String typeName, Boolean throwOnError) [0x00000]
at Mono.Web.Util.SettingsMapping.get_MapperType () [0x00000]
at Mono.Web.Util.SettingsMapping.MapSection (System.Object input, System.Type type) [0x00000]
at Mono.Web.Util.SettingsMappingManager.MapSection (System.Object input, System.Type type) [0x00000]
at Mono.Web.Util.SettingsMappingManager.MapSection (System.Object input) [0x00000]
at System.Web.Configuration.WebConfigurationManager.GetSection (System.String sectionName, System.String path) [0x00000]
at System.Web.Configuration.WebConfigurationManager.GetSection (System.String sectionName) [0x00000]
at System.Web.Compilation.AppResourcesAssemblyBuilder..ctor (System.String canonicAssemblyName, System.String baseAssemblyPath, System.Web.Compilation.AppResourcesCompiler appres) [0x00000]
at System.Web.Compilation.AppResourcesCompiler.CompileGlobal () [0x00000]
at System.Web.Compilation.AppResourcesCompiler.Compile () [0x00000]
at System.Web.HttpApplicationFactory.InitType (System.Web.HttpContext context) [0x00000]

Version information: Mono Version: 2.0.50727.1433; ASP.NET Version: 2.0.50727.1433

I get this error, after a fresh install of mojoPortal from your latest release c.

What i did:

1. wwwroot from ms-release as base.

2. copied over mysql-layer into the bin folder of the base.

3. copied user.sample.config to user.config.

4. replaced my db connection and commented the other db-connectionstrings, after i dropped all tables in the mysql-db.

---

Any idea what i could have missed?

Or maybe, whats wrong ?

CombinedRSS is already false...

hmm...

could you please rename the release file to:

mojoportal-2-2-8-2-c-pgsqlreleasefiles-for-mono_H_E_F_T_I__Y_O_U__M_U_S_T__T_A_K_E__T_H_I_S__O_N_E__F_O_R__M_O_N_O_!!!!!.zip

Lol, thankyou again.

This could be the source of all problems, but after that i got the next error on Setup :(
I will try to copy these files by hand.. Permissions are correct btw.

mojoPortal Content Management System Welcome to mojoPortal Setup
Probing system...
File system permissions problems found.
An Error Occurred:Could not find a part of the path "/home/xna-germany/wwwroot/Data/Sites/1/GalleryImages/test.config".
Source:mscorlib
Stack Trace at System.IO.FileStream..ctor (System.String path, FileMode mode, FileAccess access, FileShare share, Int32 bufferSize, Boolean anonymous, FileOptions options) [0x00000] at System.IO.FileStream..ctor (System.String path, FileMode mode, FileAccess access, FileShare share) [0x00000] at (wrapper remoting-invoke-with-check) System.IO.FileStream:.ctor (string,System.IO.FileMode,System.IO.FileAccess,System.IO.FileShare) at System.IO.StreamWriter..ctor (System.String path, Boolean append, System.Text.Encoding encoding, Int32 bufferSize) [0x00000] at System.IO.StreamWriter..ctor (System.String path, Boolean append) [0x00000] at (wrapper remoting-invoke-with-check) System.IO.StreamWriter:.ctor (string,bool) at System.IO.File.CreateText (System.String path) [0x00000] at mojoPortal.Web.mojoSetup.TouchTestFile (System.String pathToFile) [0x00000] at mojoPortal.Web.UI.Pages.SetupHome.GetFolderDetailsHtml () [0x00000] at mojoPortal.Web.UI.Pages.SetupHome.ProbeSystem () [0x00000] at mojoPortal.Web.UI.Pages.SetupHome.Page_Load (System.Object sender, System.EventArgs e) [0x00000] at System.Web.UI.Control.OnLoad (System.EventArgs e) [0x00000] at System.Web.UI.Control.LoadRecursive () [0x00000] at System.Web.UI.Page.ProcessLoad () [0x00000] at System.Web.UI.Page.ProcessPostData () [0x00000] at System.Web.UI.Page.InternalProcessRequest () [0x00000] at System.Web.UI.Page.ProcessRequest (System.Web.HttpContext context) [0x00000]

yep, i found out the same and just wanted to post it here.

There could be a little improvement in the setupscript.

I had to create the GalleryImages folder by hand, to get to the position, where the script tells me, that the permissions are wrong.

Without that folder, this message is not displayed, which is not very useful.

So it would be cool, if the order of these permission-checks could be changed.

Now he is complaining about my Data-Connection.

I tried to use the user.config this time, such it was mentioned in the web.config.

But it seems not to work like it should.

<appSettings file="user.config">  -- default line from web.config.

in my root folder, there is a user.config with the working connectionstring from the previous install.

Do i have to place the user.config anywhere else?

mojoPortal Content Management System Welcome to mojoPortal Setup
Probing system...
File system permissions ok.
The system cannot connect to the MySQL database. Please check your connection string.

MySql.Data.MySqlClient.MySqlException: Access denied for user 'mojouser'@'localhost' (using password: YES) at MySql.Data.MySqlClient.MySqlStream.OpenPacket () [0x00000] at MySql.Data.MySqlClient.NativeDriver.Authenticate411 () [0x00000] at MySql.Data.MySqlClient.NativeDriver.Authenticate () [0x00000] at MySql.Data.MySqlClient.NativeDriver.Open () [0x00000] at MySql.Data.MySqlClient.Driver.Create (MySql.Data.MySqlClient.MySqlConnectionStringBuilder settings) [0x00000] at MySql.Data.MySqlClient.MySqlPool.CreateNewPooledConnection () [0x00000] at MySql.Data.MySqlClient.MySqlPool.GetPooledConnection () [0x00000] at MySql.Data.MySqlClient.MySqlPool.TryToGetDriver () [0x00000]

Note: This page shows some information that is helpful during setup and upgrades but for security it would be best not to show any information when the system is up to date. You can disable setup and suppress all information on this page by setting DisableSetup=true in Web.config. When you need to upgrade, you can set this back to false. If you are logged in as Administrator setup will run and you will be able to see this page even if it is disabled in Web.config so you can easily leave it disabled and just login before upgrading. But if you are not logged in you will need to enable setup in Web.config.

thats part of your default settings, which i should not touch in web.config:

<!-- ******* Database Settings *********************************** -->^
<!-- Note that each db platform has its own connection string, but the database used depends on which data dlls are in the bin folder^
it is not determined by configuration settings.^
-->^
^
<!-- MS SQL Database Settings *************************************** -->^
<add key="MSSQLConnectionString" value="server=yourservername;UID=yourdatabaseusername;PWD=yourdatabaseuserpassword;database=yourdatabasename" />^
<!-- ^
For using MS SQL set this to true for best performance but if running the web on mono you may need to set this to false. -->^
<add key="CacheMSSQLParameters" value="true" />^
<!-- do not change this unless you understand the workings of the code^
and have a reason to change it. -->^
<add key="MSSQLOwnerPrefix" value="[dbo]." />^
<!-- end MS SQL Database Settings *************************************** -->^
^
<add key="PostgreSQLConnectionString" value="Server=localhost;Port=5432;Encoding=unicode;User Id=mojouser;Password=mojo123;Database=mojoportal;Pooli
<add key="MySqlConnectionString" value="Data Source=localhost;Database=mojoportal;User ID=mojouser;Password=mojo123;Charset=utf8;" />^
<add key="FirebirdConnectionString" value="Data Source=localhost;Server Type=0;Port Number=3050;Database=C:\Users\JoeAudette\devprojects\mojoportal\
<add key="SqliteConnectionString" value="defaultdblocation" />^
<!--^
you can use a fully qualified file path as shown below^
or if you are using the default db at /Data/sqlitedb/mojo.db.config^
just leave this set to "defaultdblocation"^
<add key="SqliteConnectionString" value="version=3,URI=file:C:\\Projects\mojoportal\Web\Data\sqlitedb\mojoportal.db" />^
-->^
<!-- ******* End Database Settings *********************************** -->^
^

i am using a complete other username, which definitive works.
 

After a refresh, i get this message:

I verified this, but the permissions are set for the user global and db. everything except the administration-stuff.

strange...

mojoPortal Content Management System Welcome to mojoPortal Setup
Probing system...
File system permissions ok.
MySQL database connection ok.
mojoSetup has detected that the database user does not have permission to alter the database schema. You need to correct this or provide a connection string with sufficient permission.

database initial schema needs to be created.
Note: This page shows some information that is helpful during setup and upgrades but for security it would be best not to show any information when the system is up to date. You can disable setup and suppress all information on this page by setting DisableSetup=true in Web.config. When you need to upgrade, you can set this back to false. If you are logged in as Administrator setup will run and you will be able to see this page even if it is disabled in Web.config so you can easily leave it disabled and just login before upgrading. But if you are not logged in you will need to enable setup in Web.config.

After this 2 execptions which forced me to restart the xsp2 server, i finally got this page:

Welcome to mojoPortal Setup
Probing system...
File system permissions ok.
MySQL database connection ok.
database permissions are sufficient to alter schema.
database initial schema already exists.
database core schema is up to date.
1 site(s) found.
Configuring feature HTML-Inhalt - 00:00:00.1535660
Configuring feature Seitenstatistik - 00:00:00.3626420
Running script blog - 0.0.0.1 - 00:00:00.4281670
Running script blog - 0.0.0.2 - 00:00:00.4939200
Running script blog - 0.0.0.3 - 00:00:00.5074380
Running script blog - 0.0.0.4 - 00:00:00.6937380
Running script blog - 0.0.0.5 - 00:00:00.6976850
Running script blog - 0.0.0.6 - 00:00:00.7022800
Configuring feature Blog - 00:00:00.7183800
Running script contactform - 0.0.0.1 - 00:00:00.9739870
Running script contactform - 0.0.0.2 - 00:00:01.0172170
Configuring feature Kontaktformular - 00:00:01.0337400
Running script eventcalendar - 0.0.0.1 - 00:00:01.0663910
Running script eventcalendar - 0.0.0.2 - 00:00:01.0802870
Configuring feature Kalender - 00:00:01.1016410
Running script feed-manager - 0.0.0.1 - 00:00:01.1383360
Running script feed-manager - 0.0.0.2 - 00:00:01.2059990
Running script feed-manager - 0.0.0.3 - 00:00:01.2117660
Configuring feature Feed Manager - 00:00:01.2211570
Configuring feature Image Gallery (Simple Folder Version) - 00:00:01.3223980
Running script forums - 0.0.0.1 - 00:00:01.3299320
Running script forums - 0.0.0.2 - 00:00:01.4928670
Configuring feature Foren - 00:00:01.4993280
Configuring feature Google Map - 00:00:01.5514910
Configuring feature Html Fragment include - 00:00:01.6439830
Running script imagegallery - 0.0.0.1 - 00:00:01.6601100
Running script imagegallery - 0.0.0.2 - 00:00:01.6903600
Configuring feature Bildgalerie - 00:00:01.7030810
Running script linksmodule - 0.0.0.1 - 00:00:01.7784350
Running script linksmodule - 0.0.0.2 - 00:00:01.8128560
Configuring feature Link-Tabelle - 00:00:01.8197190
Running script pollfeature-byChristianFredh - 0.0.0.1 - 00:00:01.8405530
Running script pollfeature-byChristianFredh - 0.0.0.2 - 00:00:01.8828760
Running script pollfeature-byChristianFredh - 0.0.0.3 - 00:00:01.8896550
Configuring feature Poll - 00:00:01.9327040
Running script sharedfiles - 0.0.0.1 - 00:00:01.9393140
Running script sharedfiles - 0.0.0.2 - 00:00:02.0134640
Configuring feature Gemeinsam benutzte Dateien - 00:00:02.0246650
Running script surveyfeature - 0.0.1.0 - 00:00:02.0455380
Running script surveyfeature - 0.0.1.1 - 00:00:02.1141550
Running script surveyfeature - 0.0.1.2 - 00:00:02.1219430
Running script surveyfeature - 0.0.1.3 - 00:00:02.1371020
Configuring feature Survey - 00:00:02.1492700
Running script webstore - 0.0.0.1 - 00:00:02.1559320
Running script webstore - 0.0.0.3 - 00:00:03.8401860
Running script webstore - 0.0.0.4 - 00:00:03.8526680
Running script webstore - 0.0.0.5 - 00:00:03.8557390
Running script webstore - 0.0.0.6 - 00:00:03.8744790
Running script webstore - 0.0.0.7 - 00:00:03.8906960
Running script webstore - 0.0.0.8 - 00:00:03.8949530
Running script webstore - 0.0.0.9 - 00:00:03.9015250
Running script webstore - 0.0.1.0 - 00:00:03.9198570
Running script webstore - 0.0.1.1 - 00:00:03.9402200
Running script webstore - 0.0.1.2 - 00:00:04.1842270
Running script webstore - 0.0.1.3 - 00:00:04.4050200
Running script webstore - 0.0.1.4 - 00:00:04.4383340
Running script webstore - 0.0.1.5 - 00:00:04.5115570
Running script webstore - 0.0.1.6 - 00:00:04.5223660
Running script webstore - 0.0.1.7 - 00:00:04.5403740
Running script webstore - 0.0.1.8 - 00:00:04.5472420
Running script webstore - 0.0.1.9 - 00:00:04.5934290
Running script webstore - 0.0.2.0 - 00:00:04.6304000
Running script webstore - 0.0.2.1 - 00:00:04.6456800
Running script webstore - 0.0.2.2 - 00:00:04.6769430
Running script webstore - 0.0.2.3 - 00:00:04.8079300
Running script webstore - 0.0.2.4 - 00:00:04.9115640
Running script webstore - 0.0.2.5 - 00:00:05.0513070
Running script webstore - 0.0.2.6 - 00:00:05.0813990
Running script webstore - 0.0.2.7 - 00:00:05.0895090
Running script webstore - 0.0.2.8 - 00:00:05.1112550
Running script webstore - 0.0.2.9 - 00:00:05.1169780
Running script webstore - 0.0.3.0 - 00:00:05.1479210
Running script webstore - 0.0.3.1 - 00:00:05.2142440
Running script webstore - 0.0.3.2 - 00:00:05.2234290
Running script webstore - 0.0.3.3 - 00:00:05.3285120
Running script webstore - 0.0.3.4 - 00:00:05.3432980
Running script webstore - 0.0.3.5 - 00:00:05.3592220
Configuring feature Web Store - 00:00:05.4107740
Configuring feature Xml/Xsl - 00:00:05.4370730
Ensuring all features are installed in server admin sites... - 00:00:05.4430560
No pages found so creating default content...
Setup is complete, click the link below to go to the home page.
Site Home Page

Database PlatformMySQL
Version2.2.8.2
StatusYour installation is up to date.

Note: This page shows some information that is helpful during setup and upgrades but for security it would be best not to show any information when the system is up to date. You can disable setup and suppress all information on this page by setting DisableSetup=true in Web.config. When you need to upgrade, you can set this back to false. If you are logged in as Administrator setup will run and you will be able to see this page even if it is disabled in Web.config so you can easily leave it disabled and just login before upgrading. But if you are not logged in you will need to enable setup in Web.config.

Sorry,

i forget.

I am using Debian 4.0 etch, 2.6.18 custom-kernel on a parallels virtual guest os of my provider.

the mono-version should be 2.2, since i compiled it from source of latest release (to get the latest release on debian 4.0).

Mono JIT compiler version 20090112 (tarball Tue Jan 13 00:15:13 CET 2009)
Copyright (C) 2002-2008 Novell, Inc and Contributors. www.mono-project.com
TLS: __thread
GC: Included Boehm (with typed GC)
SIGSEGV: altstack
Notifications: epoll
Architecture: x86
Disabled: none
 

which is 4 days old now...

hrmpf...

I really noticed that you are doing your best.

You will get a bear later as well, its just i am frustrated about LINUX, mono  stuff etc.

one error -> fixed -> two new errors -> ...

:(

*g* and maybe its 01:08 local time here, so.. i am a bit tired. But hey, its weekend.

k,

iam trying the 2.2 stable now, maybe i made a mistake with the versions of mono the last days... *confused*

My problem fixed. I'm not sure how I missed it, but my db user did not have drop permissions. Of course, all I was looking for was ALTER perms, so didnt know i needed DROP, until i walked through the setup code.

Now getting error on Woopra resource not found, but I'm hopeful now that I'm really close!