jamesej / lyniconanc Goto Github PK

Is it planned to move?

Hi, was trying to initialize the project via console commands following the instructions on the setup section of the readme.
I'm not used to .NET Core at all so I try to follow those instructions to the letter. Maybe there's something obvious that I had to do previously with .NET Core and this question is silly.

Anyway, when I tried to run this command:
dotnet run -- --lynicon initialize-database
or simply build:
dotnet build

I get the following error:

'LyniconANC.csproj' targets '.NETStandard,Version=v2.0; .NETFramework,Version=v4.6.1'. It cannot be referenced by a project that targets '.NETCoreApp,Version=v2.0'

After this, I tried to restore dependencies with nuget with a restore (dotnet restore) and try again.
Shows the same error at build.

How can I solve this issue?
Thanks in advance.

Steps to reproduce:

1. dotnet run -- --lynicon initialize-database
2. Execute src\LyniconANC.Release\Areas\Lynicon\Admin\SQL\TilesSiteContentSetup.sql against database

Observation:
Msg 207, Level 16, State 1, Line 3
Invalid column name 'Locale'.

Hi,

I'm attempting to follow the manual setup instructions in the wiki, but am getting a "502 Proxy Error" when attempting to download https://www.lynicon.com/install/lyniconanc.0.0.1.zip?

Thanks,
Rob

If you are
logged in as editor
go to a url which has no content but matches a dataroute template, and has no type specified by query string

you get an error. This should give you an editor in the blank url.

When I try to run this against a postgres database I get exceptions related to the connection string. Are there any instructions on how to get this working with postgres?

System.ArgumentException: Keyword not supported: 'port'.
at System.Data.Common.DbConnectionOptions.ParseInternal(Dictionary2 parsetable, String connectionString, Boolean buildChain, Dictionary2 synonyms, Boolean firstKey)
at System.Data.Common.DbConnectionOptions..ctor(String connectionString, Dictionary`2 synonyms)
at System.Data.SqlClient.SqlConnectionString..ctor(String connectionString)
at System.Data.SqlClient.SqlConnectionFactory.CreateConnectionOptions(String connectionString, DbConnectionOptions previous)

Thanks for the help!

Haven't seen any activity in a long time.

Need to delete various views which have been left in Areas/Lynicon/Views which won't compile

Other than a not null check, no validation is performed on click events performed on the del-link class within LyniconItems.cshtml

Only when the non-indexing route params have no defaults. It should supply dummy values for these params or the route won't match.

I'm trying to find a headless CMS that supports .NET Core 3. Doesn't look like this project is ready for that yet.

Thoughts?

I tried setting up a completely new project following the guide at lynicon.atlassian.net

Target framework: .NET Core 2.1
LyniconANC 0.2.2.24
Microsoft.AspNetCore.App 2.1.1
Database: SQL Server 14.0.2002.14

I used dotnet run -- --lynicon initialize-database
From what I can tell the database is set up fine. I see 3 tables (ContentItems, DbChanges, Users) in my database.

Then i use dotnet run -- --lynicon initialize-admin --password <redacted> which gives me the following error.

C:\projects\tryouts\LyniconTest\LyniconTest>dotnet run -- --lynicon initialize-admin --password <redacted> Die Starteinstellungen von C:\projects\tryouts\LyniconTest\LyniconTest\Properties\launchSettings.json werden verwendet. info: Microsoft.AspNetCore.DataProtection.KeyManagement.XmlKeyManager[0] User profile is available. Using 'C:\Users\norbert.winkler\AppData\Local\ASP.NET\DataProtection-Keys' as key repository and Windows DPAPI to encrypt keys at rest. Application startup exception: System.ArgumentNullException: Value cannot be null. Parameter name: relationalTypeMapping at Microsoft.EntityFrameworkCore.Utilities.Check.NotNull[T](T value, String parameterName) at Microsoft.EntityFrameworkCore.Storage.Internal.TypeMappedRelationalParameter..ctor(String invariantName, String name, RelationalTypeMapping relationalTypeMapping, Nullable1 nullable)
at Microsoft.EntityFrameworkCore.Storage.Internal.RelationalParameterBuilder.AddParameter(String invariantName, String name, IProperty property)
at Microsoft.EntityFrameworkCore.Storage.RelationalCommandBuilderExtensions.AddParameter(IRelationalCommandBuilder commandBuilder, String invariantName, String name, IProperty property)
at Microsoft.EntityFrameworkCore.Update.ReaderModificationCommandBatch.CreateStoreCommand()
at Microsoft.EntityFrameworkCore.Update.ReaderModificationCommandBatch.Execute(IRelationalConnection connection)
at Microsoft.EntityFrameworkCore.Update.Internal.BatchExecutor.Execute(DbContext _, ValueTuple2 parameters) at Microsoft.EntityFrameworkCore.SqlServer.Storage.Internal.SqlServerExecutionStrategy.Execute[TState,TResult](TState state, Func3 operation, Func3 verifySucceeded) at Microsoft.EntityFrameworkCore.Update.Internal.BatchExecutor.Execute(IEnumerable1 commandBatches, IRelationalConnection connection)
at Microsoft.EntityFrameworkCore.Storage.RelationalDatabase.SaveChanges(IReadOnlyList1 entries) at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.StateManager.SaveChanges(IReadOnlyList1 entriesToSave)
at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.StateManager.SaveChanges(Boolean acceptAllChangesOnSuccess)
at Microsoft.EntityFrameworkCore.DbContext.SaveChanges(Boolean acceptAllChangesOnSuccess)
at Microsoft.EntityFrameworkCore.DbContext.SaveChanges()
at Lynicon.DataSources.CoreDataSource.SaveChanges()
at Lynicon.Repositories.BasicRepository.Set(List1 items, Dictionary2 setOptions)
at Lynicon.Repositories.Repository.<>c__DisplayClass48_0.b__1(IGrouping2 igroup) at System.Linq.Enumerable.SelectManySingleSelectorIterator2.ToList()
at Lynicon.Repositories.Repository.Set(List1 items, Dictionary2 setOptions)
at Lynicon.Collation.BasicCollator.Set(Address a, Object data, Dictionary2 setOptions) at Lynicon.Collation.Collator.Set(Address address, Object data, Dictionary2 setOptions)
at Lynicon.Collation.Collator.Set(Address address, Object data, Nullable1 create, Boolean bypassChecks) at Lynicon.Collation.Collator.Set(Address address, Object data, Nullable1 create)
at Lynicon.Collation.Collator.Set(Object data, Nullable1 create) at Lynicon.Membership.SecurityManager.EnsureAdminUser(String password) at Lynicon.Commands.InitializeAdminCmd.Execute(String[] args) at Lynicon.Commands.CommandRunner.<>c__DisplayClass8_0.<GetCommand>b__1() at Lynicon.Commands.CommandRunner.InterceptAndRunCommands(String[] args) at Lynicon.Commands.CommandRunner.InterceptAndRunCommands(IServiceProvider services, String[] args) at Lynicon.Commands.CommandRunner.InterceptRunStartupFilter.<>c__DisplayClass2_0.<Configure>b__0(IApplicationBuilder builder) at Microsoft.AspNetCore.HostFilteringStartupFilter.<>c__DisplayClass0_0.<Configure>b__0(IApplicationBuilder app) at Microsoft.AspNetCore.Hosting.Internal.AutoRequestServicesStartupFilter.<>c__DisplayClass0_0.<Configure>b__0(IApplicationBuilder builder) at Microsoft.AspNetCore.Hosting.Internal.WebHost.BuildApplication() crit: Microsoft.AspNetCore.Hosting.Internal.WebHost[6] Application startup exception System.ArgumentNullException: Value cannot be null. Parameter name: relationalTypeMapping at Microsoft.EntityFrameworkCore.Utilities.Check.NotNull[T](T value, String parameterName) at Microsoft.EntityFrameworkCore.Storage.Internal.TypeMappedRelationalParameter..ctor(String invariantName, String name, RelationalTypeMapping relationalTypeMapping, Nullable1 nullable)
at Microsoft.EntityFrameworkCore.Storage.Internal.RelationalParameterBuilder.AddParameter(String invariantName, String name, IProperty property)
at Microsoft.EntityFrameworkCore.Storage.RelationalCommandBuilderExtensions.AddParameter(IRelationalCommandBuilder commandBuilder, String invariantName, String name, IProperty property)
at Microsoft.EntityFrameworkCore.Update.ReaderModificationCommandBatch.CreateStoreCommand()
at Microsoft.EntityFrameworkCore.Update.ReaderModificationCommandBatch.Execute(IRelationalConnection connection)
at Microsoft.EntityFrameworkCore.Update.Internal.BatchExecutor.Execute(DbContext _, ValueTuple2 parameters) at Microsoft.EntityFrameworkCore.SqlServer.Storage.Internal.SqlServerExecutionStrategy.Execute[TState,TResult](TState state, Func3 operation, Func3 verifySucceeded) at Microsoft.EntityFrameworkCore.Update.Internal.BatchExecutor.Execute(IEnumerable1 commandBatches, IRelationalConnection connection)
at Microsoft.EntityFrameworkCore.Storage.RelationalDatabase.SaveChanges(IReadOnlyList1 entries) at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.StateManager.SaveChanges(IReadOnlyList1 entriesToSave)
at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.StateManager.SaveChanges(Boolean acceptAllChangesOnSuccess)
at Microsoft.EntityFrameworkCore.DbContext.SaveChanges(Boolean acceptAllChangesOnSuccess)
at Microsoft.EntityFrameworkCore.DbContext.SaveChanges()
at Lynicon.DataSources.CoreDataSource.SaveChanges()
at Lynicon.Repositories.BasicRepository.Set(List1 items, Dictionary2 setOptions)
at Lynicon.Repositories.Repository.<>c__DisplayClass48_0.b__1(IGrouping2 igroup) at System.Linq.Enumerable.SelectManySingleSelectorIterator2.ToList()
at Lynicon.Repositories.Repository.Set(List1 items, Dictionary2 setOptions)
at Lynicon.Collation.BasicCollator.Set(Address a, Object data, Dictionary2 setOptions) at Lynicon.Collation.Collator.Set(Address address, Object data, Dictionary2 setOptions)
at Lynicon.Collation.Collator.Set(Address address, Object data, Nullable1 create, Boolean bypassChecks) at Lynicon.Collation.Collator.Set(Address address, Object data, Nullable1 create)
at Lynicon.Collation.Collator.Set(Object data, Nullable`1 create)
at Lynicon.Membership.SecurityManager.EnsureAdminUser(String password)
at Lynicon.Commands.InitializeAdminCmd.Execute(String[] args)
at Lynicon.Commands.CommandRunner.<>c__DisplayClass8_0.b__1()
at Lynicon.Commands.CommandRunner.InterceptAndRunCommands(String[] args)
at Lynicon.Commands.CommandRunner.InterceptAndRunCommands(IServiceProvider services, String[] args)
at Lynicon.Commands.CommandRunner.InterceptRunStartupFilter.<>c__DisplayClass2_0.b__0(IApplicationBuilder builder)
at Microsoft.AspNetCore.HostFilteringStartupFilter.<>c__DisplayClass0_0.b__0(IApplicationBuilder app)
at Microsoft.AspNetCore.Hosting.Internal.AutoRequestServicesStartupFilter.<>c__DisplayClass0_0.b__0(IApplicationBuilder builder)
at Microsoft.AspNetCore.Hosting.Internal.WebHost.BuildApplication()

Unhandled Exception: System.ArgumentNullException: Value cannot be null.
Parameter name: relationalTypeMapping
at Microsoft.EntityFrameworkCore.Utilities.Check.NotNull[T](T value, String parameterName)
at Microsoft.EntityFrameworkCore.Storage.Internal.TypeMappedRelationalParameter..ctor(String invariantName, String name, RelationalTypeMapping relationalTypeMapping, Nullable1 nullable) at Microsoft.EntityFrameworkCore.Storage.Internal.RelationalParameterBuilder.AddParameter(String invariantName, String name, IProperty property) at Microsoft.EntityFrameworkCore.Storage.RelationalCommandBuilderExtensions.AddParameter(IRelationalCommandBuilder commandBuilder, String invariantName, String name, IProperty property) at Microsoft.EntityFrameworkCore.Update.ReaderModificationCommandBatch.CreateStoreCommand() at Microsoft.EntityFrameworkCore.Update.ReaderModificationCommandBatch.Execute(IRelationalConnection connection) at Microsoft.EntityFrameworkCore.Update.Internal.BatchExecutor.Execute(DbContext _, ValueTuple2 parameters)
at Microsoft.EntityFrameworkCore.SqlServer.Storage.Internal.SqlServerExecutionStrategy.Execute[TState,TResult](TState state, Func3 operation, Func3 verifySucceeded)
at Microsoft.EntityFrameworkCore.Update.Internal.BatchExecutor.Execute(IEnumerable1 commandBatches, IRelationalConnection connection) at Microsoft.EntityFrameworkCore.Storage.RelationalDatabase.SaveChanges(IReadOnlyList1 entries)
at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.StateManager.SaveChanges(IReadOnlyList1 entriesToSave) at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.StateManager.SaveChanges(Boolean acceptAllChangesOnSuccess) at Microsoft.EntityFrameworkCore.DbContext.SaveChanges(Boolean acceptAllChangesOnSuccess) at Microsoft.EntityFrameworkCore.DbContext.SaveChanges() at Lynicon.DataSources.CoreDataSource.SaveChanges() at Lynicon.Repositories.BasicRepository.Set(List1 items, Dictionary2 setOptions) at Lynicon.Repositories.Repository.<>c__DisplayClass48_0.<Set>b__1(IGrouping2 igroup)
at System.Linq.Enumerable.SelectManySingleSelectorIterator2.ToList() at Lynicon.Repositories.Repository.Set(List1 items, Dictionary2 setOptions) at Lynicon.Collation.BasicCollator.Set(Address a, Object data, Dictionary2 setOptions)
at Lynicon.Collation.Collator.Set(Address address, Object data, Dictionary2 setOptions) at Lynicon.Collation.Collator.Set(Address address, Object data, Nullable1 create, Boolean bypassChecks)
at Lynicon.Collation.Collator.Set(Address address, Object data, Nullable1 create) at Lynicon.Collation.Collator.Set(Object data, Nullable1 create)
at Lynicon.Membership.SecurityManager.EnsureAdminUser(String password)
at Lynicon.Commands.InitializeAdminCmd.Execute(String[] args)
at Lynicon.Commands.CommandRunner.<>c__DisplayClass8_0.b__1()
at Lynicon.Commands.CommandRunner.InterceptAndRunCommands(String[] args)
at Lynicon.Commands.CommandRunner.InterceptAndRunCommands(IServiceProvider services, String[] args)
at Lynicon.Commands.CommandRunner.InterceptRunStartupFilter.<>c__DisplayClass2_0.b__0(IApplicationBuilder builder)
at Microsoft.AspNetCore.HostFilteringStartupFilter.<>c__DisplayClass0_0.b__0(IApplicationBuilder app)
at Microsoft.AspNetCore.Hosting.Internal.AutoRequestServicesStartupFilter.<>c__DisplayClass0_0.b__0(IApplicationBuilder builder)
at Microsoft.AspNetCore.Hosting.Internal.WebHost.BuildApplication()
at Microsoft.AspNetCore.Hosting.Internal.WebHost.StartAsync(CancellationToken cancellationToken)
at Microsoft.AspNetCore.Hosting.WebHostExtensions.RunAsync(IWebHost host, CancellationToken token, String shutdownMessage)
at Microsoft.AspNetCore.Hosting.WebHostExtensions.RunAsync(IWebHost host, CancellationToken token)
at Microsoft.AspNetCore.Hosting.WebHostExtensions.Run(IWebHost host)
at LyniconTest.Program.Main(String[] args) in C:\projects\tryouts\LyniconTest\LyniconTest\Program.cs:line 20`

The admin user isn't created. I cannot login going to /lynicon/login. It gives me the message "The user name or password provided is incorrect".
The Users table in the database is also empty.