Problems with sqlite

["Michael Davies" <michael msdavies net>]

I'm having trouble getting beagle going on Ubuntu - specifically the
connection to sqlite.  (Embarrassingly enough I've compiled and had beagle
running on FC1/2, but now I'm having some issues on an Ubuntu machine)

I've looked at both the Ubuntu and Beagle wikis, but I'm struggling to see
why the connection ain't happening.

This is the exception that I'm getting:

mrd shadowfax:~ $ beagled --fg --debug
INFO: Starting Beagle Daemon (version 0.0.3)
DEBUG: Command Line: /usr/local/lib/beagle/BeagleDaemon.exe --fg --debug
DEBUG: Initializing D-BUS
DEBUG: Acquiring com.novell.Beagle D-BUS service
DEBUG: Constructing QueryDriver
ERROR: Caught exception while instantiating Files backend
ERROR: System.Reflection.TargetInvocationException: Exception has been
thrown by the target of an invocation. ---> System.DllNotFoundException:
sqlite
in <0x00053> (wrapper managed-to-native)
Mono.Data.SqliteClient.SqliteConnection:sqlite_open (string,int,string&)
in [0x00031] (at
/build/buildd/mcs-1.0.1/class/Mono.Data.SqliteClient/Mono.Data.SqliteClient/SqliteConnection.cs:157)
Mono.Data.SqliteClient.SqliteConnection:Open ()
in [0x0001e] (at
/home/mrd/cvs/beagle/beagled/FileAttributesStore_Sqlite.cs:150)
Beagle.Daemon.FileAttributesStore_Sqlite:Open (string)
in [0x000fa] (at
/home/mrd/cvs/beagle/beagled/FileAttributesStore_Sqlite.cs:93)
Beagle.Daemon.FileAttributesStore_Sqlite:.ctor (string,string)
in [0x00015] (at
/home/mrd/cvs/beagle/beagled/FileAttributesStore_Mixed.cs:40)
Beagle.Daemon.FileAttributesStore_Mixed:.ctor (string,string)
in [0x00007] (at
/home/mrd/cvs/beagle/beagled/FileSystemQueryable/FileSystemQueryable.cs:114)
Beagle.Daemon.FileSystemQueryable.FileSystemQueryable:BuildFileAttributesStore
(string)
in [0x00040] (at /home/mrd/cvs/beagle/beagled/LuceneQueryable.cs:52)
Beagle.Daemon.LuceneQueryable:.ctor (string)
in [0x0004f] (at
/home/mrd/cvs/beagle/beagled/FileSystemQueryable/FileSystemQueryable.cs:105)
Beagle.Daemon.FileSystemQueryable.FileSystemQueryable:.ctor ()
in (unmanaged) (wrapper managed-to-native)
System.Reflection.MonoCMethod:InternalInvoke (object,object[])
in <0x00004> (wrapper managed-to-native)
System.Reflection.MonoCMethod:InternalInvoke (object,object[])
in [0x00033] (at
/build/buildd/mcs-1.0.1/class/corlib/System.Reflection/MonoMethod.cs:280)
System.Reflection.MonoCMethod:Invoke
(object,System.Reflection.BindingFlags,System.Reflection.Binder,object[],System.Globalization.CultureInfo)
--- End of inner exception stack trace ---

in [0x00052] (at
/build/buildd/mcs-1.0.1/class/corlib/System.Reflection/MonoMethod.cs:284)
System.Reflection.MonoCMethod:Invoke
(object,System.Reflection.BindingFlags,System.Reflection.Binder,object[],System.Globalization.CultureInfo)
in [0x00007] (at
/build/buildd/mcs-1.0.1/class/corlib/System.Reflection/MonoMethod.cs:289)
System.Reflection.MonoCMethod:Invoke
(System.Reflection.BindingFlags,System.Reflection.Binder,object[],System.Globalization.CultureInfo)
in [0x00017] (at
/build/buildd/mcs-1.0.1/class/corlib/System.Reflection/ConstructorInfo.cs:62)
System.Reflection.ConstructorInfo:Invoke (object[])
in [0x00074] (at
/build/buildd/mcs-1.0.1/class/corlib/System/Activator.cs:260)
System.Activator:CreateInstance (System.Type,bool)
in [0x00002] (at
/build/buildd/mcs-1.0.1/class/corlib/System/Activator.cs:151)
System.Activator:CreateInstance (System.Type)
in [0x0006e] (at /home/mrd/cvs/beagle/beagled/QueryDriver.cs:107)
Beagle.Daemon.QueryDriver:ScanAssembly (System.Reflection.Assembly)

Now I have sqlite built and installed, in the usual place:

mrd shadowfax:~ $ locate sqlite
[snip]
/usr/bin/sqlite/usr/lib/libsqlite.so.0.8.6
/usr/lib/libsqlite.so.0

and...

mrd shadowfax:~ $ echo $LD_LIBRARY_PATH
/usr/lib:/usr/local/lib:/usr/lib/evolution/2.0/

Any ideas why sqlite isn't being found?  It's got me stumped right now.

Thanks in advance,

Michael...
-- 
michael at msdavies dot net
http://michaeldavies.org/weblog