sqlite - Service account throwing SQLiteException on NServiceBus startup -


i'm getting following exception when try start nservicebus.host.exe service account credentials:

    database not configured through database method.   system.data.sqlite.sqliteexception: unable open database file   @ system.data.sqlite.sqlite3.open(string strfilename, sqliteopenflagsenum flags, int32 maxpoolsize, boolean usepool)   @ system.data.sqlite.sqliteconnection.open() @ nhibernate.connection.driverconnectionprovider.getconnection() in :line 0 @ nhibernate.tool.hbm2ddl.suppliedconnectionproviderconnectionhelper.prepare() in :line 0 @ nhibernate.tool.hbm2ddl.schemametadataupdater.getreservedwords(dialect dialect, iconnectionhelper connectionhelper) in :line 0 @ nhibernate.tool.hbm2ddl.schemametadataupdater.update(isessionfactory sessionfactory) in :line 0 @ nhibernate.impl.sessionfactoryimpl..ctor(configuration cfg, imapping mapping, settings settings, eventlisteners listeners) in :line 0 @ fluentnhibernate.cfg.fluentconfiguration.buildsessionfactory() in d:\dev\fluent-nhibernate\src\fluentnhibernate\cfg\fluentconfiguration.cs:line 93 --- end of inner exception stack trace --- @ fluentnhibernate.cfg.fluentconfiguration.buildsessionfactory() in d:\dev\fluent-nhibernate\src\fluentnhibernate\cfg\fluentconfiguration.cs:line 100 @ nservicebus.sagapersisters.nhibernate.config.internal.sessionfactorybuilder.build(idictionary^2 nhibernateproperties, boolean updateschema) in c:\dev\dotnet\nservicebus\src\impl\sagapersisters\nhibernatesagapersister\nservicebus.sagapersisters.nhibernate.config\internal\sessionfactorybuilder.cs:line 48 --- end of inner exception stack trace --- @ nservicebus.sagapersisters.nhibernate.config.internal.sessionfactorybuilder.build(idictionary^2 nhibernateproperties, boolean updateschema) in c:\dev\dotnet\nservicebus\src\impl\sagapersisters\nhibernatesagapersister\nservicebus.sagapersisters.nhibernate.config\internal\sessionfactorybuilder.cs:line 55 @ nservicebus.configurenhibernatesagapersister.nhibernatesagapersister(configure config, idictionary^2 nhibernateproperties, boolean autoupdateschema) in c:\dev\dotnet\nservicebus\src\impl\sagapersisters\nhibernatesagapersister\nservicebus.sagapersisters.nhibernate.config\configurenhibernatesagapersister.cs:line 80 @ ibfx.backoffice.services.newaccounts.newaccountsendpoint.init() in c:\dev\tfs\omega\src\svcs\newaccounts\src\service\newaccountsendpoint.cs:line 67 @ nservicebus.host.internal.generichost.start() in c:\dev\dotnet\nservicebus\src\host\nservicebus.host\internal\generichost.cs:line 56 

everything works fine if run host using own account, if run host service domain credentials or use same credentials runas command above exception. permissions need configure service work?

here's config:

        var configure = nservicebus.configure.with()             .log4net<log4netloggeradapter>(a => { })             .unitybuilder(container)             .xmlserializer()             .rijndaelencryptionservice()             .msmqtransport()                 .istransactional(false)                 .purgeonstartup(false)                 .msmqsubscriptionstorage();          configure.configurer.configurecomponent<msmqsubscriptionstorage>(                     componentcallmodelenum.none).configureproperty(p => p.dontuseexternaltransaction                     , true                 );          ibus bus = configure.unicastbus()             .impersonatesender(true)             .loadmessagehandlers()             .sagas()             .nhibernatesagapersister()         .createbus()         .start(); 

and have nservicebus.host.exe.config file following:

<?xml version="1.0" encoding="utf-8" ?> <configuration> <startup uselegacyv2runtimeactivationpolicy="true"> <supportedruntime version="v4.0"/> </startup> </configuration>

what happens when temporarily give , anonymous logon full control on directory specified? if solves exception, it's security issue. using |datadirectory| in connection string? sure process looking @ directory think it's looking at?

following that, try using sqlite in memory connection string settings see if it's able @ least create database , use it:

":memory:;version=3;new=true;pooling=true;max pool size=1;"

the above string uses in-memory sqlite keeps single connection open tables , data continue exist until process exits.

another strategy use change saga persister sql flavor, such ms sql see if solves it.


Comments

Popular posts from this blog

python - Scipy curvefit RuntimeError:Optimal parameters not found: Number of calls to function has reached maxfev = 1000 -

c# - How to add a new treeview at the selected node? -

java - netbeans "Please wait - classpath scanning in progress..." -