[Mono-aspnet-list] Sqlite error in ported mvc3 razor application

rolandh87 roland.hediger at ziknet.ch
Fri Jun 10 12:23:11 EDT 2011

I am a Computer Science student experimenting with running asp applications
with Mono.
I have an application using fluent nhibernate and sqlite.
When I run the application in Windows on the asp.net Development Server
access to the database and crud operations occur without any problems. 

The code behind the index page of my website simplz opens the .db file
through nhibernate. I can load the page successfully in windows.

A couple of details on my sqlite3 config. I am using version 1.066 of the
managed only binaries of System.Data.Sqlite (could not find managed only for
later versions) with the latest sqlite3 dll This should ensure
compatability with Mono.

I use a mod_mono setup.

In Linux (Suse with latest mono and xsp4) I get a http 500 error with the
following : "unable to open Database file". :

Error Details :
System.Data.SQLite.SQLiteException: Unable to open the database file
  at System.Data.SQLite.SQLite3.Open (System.String strFilename,
SQLiteOpenFlagsEnum flags, Int32 maxPoolSize, Boolean usePool) [0x00000] in
<filename unknown>:0 
  at System.Data.SQLite.SQLiteConnection.Open () [0x00000] in <filename

I did some extensive searching. Most of the people who have a similar error,
get it because of permissions, I have the entire project directory and all
its subdirectories and files owned by apache. Nevertheless even when I run
xsp4 seperately as root I still get this error. My /tmp directory is also
writeable to everyone. I am battling to find what else I need to adjust. I
am not sure if this is because I use |DataDirectory| as part of my path to
the db file in web.config. I am not sure if Mono understands this.

Help would be greatly appreciated.


View this message in context: http://mono.1490590.n4.nabble.com/Sqlite-error-in-ported-mvc3-razor-application-tp3588822p3588822.html
Sent from the Mono - ASP.NET mailing list archive at Nabble.com.

More information about the Mono-aspnet-list mailing list