YAFLogo

tha_watcha
  • tha_watcha
  • 100% (Exalted)
  • YAF.NET Project Lead 🤴 YAF Version: 4.0.0 rc 2
a year ago
I added the properties to the YAF.Data.PostgreSQL project file. Can you pull the latest commit and try again.
ora
  • ora
  • 83% (Honored)
  • YAF Forumling Topic Starter YAF Version: v4 RC
a year ago
That did it! It;s running! 🎉

Thanks very much!


ora
  • ora
  • 83% (Honored)
  • YAF Forumling Topic Starter YAF Version: v4 RC
a year ago
I stand corrected That was enough to get it past first run but upon standing it up I'm seeing the same issue I was originally facing with SQLite:

NoValidDbAccessProviderFoundException: Unable to Locate Provider Named "Microsoft.Data.SqlClient" in Data Access Providers (DLL Not Located in Bin Directory?).

This is particularly odd because I can see Microsoft.Data.SqlClient.dll does exist in the publish folder.


tha_watcha
  • tha_watcha
  • 100% (Exalted)
  • YAF.NET Project Lead 🤴 YAF Version: 4.0.0 rc 2
a year ago
Depending on what data provider you are using, you need to modify the appsettings.json where you define the provider and the connection string.

For SQLite it would be under connectionstrings...

  "DefaultConnection": "Data Source=databasename.db;Version=3;"

and under BoardConfiguration

"ConnectionProviderName": "System.Data.SQLite"

for Postgres it would be...

 "DefaultConnection": "Server=localhost;Port=5432;User Id=postgres;Password=XXXX;Database=databasename;"

and under BoardConfiguration

"ConnectionProviderName": "Npgsql Data Provider"

Â