Hi,
I tried to create Tenant with separate DB approach but I got errors and my tenant didn't create. Do I need to ask something to hosting provider? Below is log file errors
INFO 2017-07-26 00:02:38,065 [41 ] ore.Mvc.Internal.ControllerActionInvoker - Executing action method MyCompanyName.AbpZeroTemplate.MultiTenancy.TenantAppService.CreateTenant (MyCompanyName.AbpZeroTemplate.Application) with arguments (MyCompanyName.AbpZeroTemplate.MultiTenancy.Dto.CreateTenantInput) - ModelState is Valid
ERROR 2017-07-26 00:02:38,190 [12 ] Mvc.ExceptionHandling.AbpExceptionFilter - CREATE DATABASE permission denied in database 'master'.
System.Data.SqlClient.SqlException: CREATE DATABASE permission denied in database 'master'.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource1 completion, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite, String methodName)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at Microsoft.EntityFrameworkCore.Storage.Internal.RelationalCommand.Execute(IRelationalConnection connection, String executeMethod, IReadOnlyDictionary2 parameterValues, Boolean closeConnection) at Microsoft.EntityFrameworkCore.Storage.Internal.RelationalCommand.ExecuteNonQuery(IRelationalConnection connection, IReadOnlyDictionary2 parameterValues)
at Microsoft.EntityFrameworkCore.Migrations.Internal.MigrationCommandExecutor.ExecuteNonQuery(IEnumerable1 migrationCommands, IRelationalConnection connection) at Microsoft.EntityFrameworkCore.Storage.Internal.SqlServerDatabaseCreator.Create() at Microsoft.EntityFrameworkCore.Migrations.Internal.Migrator.Migrate(String targetMigration) at Abp.Zero.EntityFrameworkCore.AbpZeroDbMigrator1.CreateOrMigrate(AbpTenantBase tenant, Action`1 seedAction)
at MyCompanyName.AbpZeroTemplate.MultiTenancy.TenantManager.
Hi, Is there any good ways to migrate existing db ( sp,view,udf ) to aspnetzero structure? Any suggestions would be appreciated.
Thanks & Best Regards
Hi ismcagdas, I also want to know step by step approach of migrations for existing DB table and sp,udf to aspzero starter app flow.:)
Thanks
Hi velu, if I am not wrong you can use this approach ASP.NET Core & Angular 2+ NEW
thanks
Hi ismcagdas ,
I want to use .net core with angular 2 but because of limited time i have to chose .net core mvc or mvc 5 with kendo ui. My current project used crystal reports and don't know it is fit for .net core.
Thanks
Hi ,
Now I have to convert Window application to web application. Window application used Store Procedure and View object 90% in project. I got only few month to convert the whole system and I have to reuse SP and View. So what is the best way for me to convert window to web in this case?
Thanks & Best Regards
Thanks reply....
Web.Host.. { "ConnectionStrings": { "Default": "Server=DESKTOP-VLV4U5Q\SQL2014; Database=abd; uid=sa;password=sa;Trusted_Connection=True;" }, "Abp": { "RedisCache": { "ConnectionString": "localhost", "DatabaseId": -1 } }, "App": { "WebSiteRootAddress": "http://localhost:4200/", "CorsOrigins": "http://localhost:4200" }, "Authentication": { "Facebook": { "IsEnabled": "false", "AppId": "", "AppSecret": "" }, "Google": { "IsEnabled": "false", "ClientId": "", "ClientSecret": "" }, "Microsoft": { "IsEnabled": "false", "ConsumerKey": "", "ConsumerSecret": "" }, "JwtBearer": { "IsEnabled": "true", "SecurityKey": "AbpZeroTemplate_8CFB2EC534E14D56", "Issuer": "AbpZeroTemplate", "Audience": "AbpZeroTemplate" } }, "Recaptcha": { "SiteKey": "6LfD-wUTAAAAACULAVXvL61K0w02RIsjhI8EyiS-", "SecretKey": "6LfD-wUTAAAAADm3h7vomd9FtaAlAwexki29BtXC" } }
Client "name": "abp-zero-template", "version": "0.0.0", "license": "MIT", "angular-cli": {}, "scripts": { "ng": "ng", "start": "ng serve --host 0.0.0.0 --port 4200 --live-reload-port 4201", "hmr": "ng serve --host 0.0.0.0 --port 4200 --live-reload-port 4201 --hmr -e=hmr", "test": "ng test", "pree2e": "webdriver-manager update --standalone false --gecko false", "e2e": "protractor"
Thanks all akl
Here.....
DEBUG 2017-03-16 15:21:28,627 [libuv] Microsoft.AspNetCore.Server.Kestrel - Connection id "0HL3C95ME3CLO" received FIN.
DEBUG 2017-03-16 15:21:28,627 [libuv] Microsoft.AspNetCore.Server.Kestrel - Connection id "0HL3C95ME3CLP" received FIN.
DEBUG 2017-03-16 15:21:28,627 [libuv] Microsoft.AspNetCore.Server.Kestrel - Connection id "0HL3C95ME3CLN" received FIN.
DEBUG 2017-03-16 15:21:28,627 [libuv] Microsoft.AspNetCore.Server.Kestrel - Connection id "0HL3C95ME3CLS" received FIN.
DEBUG 2017-03-16 15:21:28,627 [libuv] Microsoft.AspNetCore.Server.Kestrel - Connection id "0HL3C95ME3CLR" received FIN.
DEBUG 2017-03-16 15:21:28,627 [libuv] Microsoft.AspNetCore.Server.Kestrel - Connection id "0HL3C95ME3CLQ" received FIN.
DEBUG 2017-03-16 15:21:28,627 [16 ] Microsoft.AspNetCore.Server.Kestrel - Connection id "0HL3C95ME3CLO" disconnecting.
DEBUG 2017-03-16 15:21:28,627 [6 ] Microsoft.AspNetCore.Server.Kestrel - Connection id "0HL3C95ME3CLQ" disconnecting.
DEBUG 2017-03-16 15:21:28,628 [3 ] Microsoft.AspNetCore.Server.Kestrel - Connection id "0HL3C95ME3CLS" disconnecting.
DEBUG 2017-03-16 15:21:28,628 [18 ] Microsoft.AspNetCore.Server.Kestrel - Connection id "0HL3C95ME3CLR" disconnecting.
DEBUG 2017-03-16 15:21:28,628 [libuv] Microsoft.AspNetCore.Server.Kestrel - Connection id "0HL3C95ME3CLO" sending FIN.
DEBUG 2017-03-16 15:21:28,628 [libuv] Microsoft.AspNetCore.Server.Kestrel - Connection id "0HL3C95ME3CLR" sending FIN.
DEBUG 2017-03-16 15:21:28,628 [20 ] Microsoft.AspNetCore.Server.Kestrel - Connection id "0HL3C95ME3CLN" disconnecting.
DEBUG 2017-03-16 15:21:28,628 [17 ] Microsoft.AspNetCore.Server.Kestrel - Connection id "0HL3C95ME3CLP" disconnecting.
DEBUG 2017-03-16 15:21:28,628 [libuv] Microsoft.AspNetCore.Server.Kestrel - Connection id "0HL3C95ME3CLP" sending FIN.
DEBUG 2017-03-16 15:21:28,628 [libuv] Microsoft.AspNetCore.Server.Kestrel - Connection id "0HL3C95ME3CLQ" sending FIN.
DEBUG 2017-03-16 15:21:28,629 [libuv] Microsoft.AspNetCore.Server.Kestrel - Connection id "0HL3C95ME3CLN" sending FIN.
DEBUG 2017-03-16 15:21:28,629 [libuv] Microsoft.AspNetCore.Server.Kestrel - Connection id "0HL3C95ME3CLS" sending FIN.
DEBUG 2017-03-16 15:21:28,631 [libuv] Microsoft.AspNetCore.Server.Kestrel - Connection id "0HL3C95ME3CLQ" sent FIN with status "0".
DEBUG 2017-03-16 15:21:28,631 [libuv] Microsoft.AspNetCore.Server.Kestrel - Connection id "0HL3C95ME3CLP" sent FIN with status "0".
DEBUG 2017-03-16 15:21:28,631 [libuv] Microsoft.AspNetCore.Server.Kestrel - Connection id "0HL3C95ME3CLN" sent FIN with status "0".
DEBUG 2017-03-16 15:21:28,631 [libuv] Microsoft.AspNetCore.Server.Kestrel - Connection id "0HL3C95ME3CLS" sent FIN with status "0".
DEBUG 2017-03-16 15:21:28,632 [libuv] Microsoft.AspNetCore.Server.Kestrel - Connection id "0HL3C95ME3CLQ" stopped.
DEBUG 2017-03-16 15:21:28,632 [libuv] Microsoft.AspNetCore.Server.Kestrel - Connection id "0HL3C95ME3CLS" stopped.
DEBUG 2017-03-16 15:21:28,632 [libuv] Microsoft.AspNetCore.Server.Kestrel - Connection id "0HL3C95ME3CLO" sent FIN with status "0".
DEBUG 2017-03-16 15:21:28,632 [libuv] Microsoft.AspNetCore.Server.Kestrel - Connection id "0HL3C95ME3CLN" stopped.
DEBUG 2017-03-16 15:21:28,633 [libuv] Microsoft.AspNetCore.Server.Kestrel - Connection id "0HL3C95ME3CLO" stopped.
DEBUG 2017-03-16 15:21:28,633 [libuv] Microsoft.AspNetCore.Server.Kestrel - Connection id "0HL3C95ME3CLR" sent FIN with status "0".
DEBUG 2017-03-16 15:21:28,633 [libuv] Microsoft.AspNetCore.Server.Kestrel - Connection id "0HL3C95ME3CLR" stopped.
DEBUG 2017-03-16 15:21:28,632 [libuv] Microsoft.AspNetCore.Server.Kestrel - Connection id "0HL3C95ME3CLP" stopped.
DEBUG 2017-03-16 15:21:28,633 [libuv] Microsoft.AspNetCore.Server.Kestrel - Connection id "0HL3C95ME3CLT" started.
INFO 2017-03-16 15:21:28,635 [20 ] soft.AspNetCore.Hosting.Internal.WebHost - Request starting HTTP/1.1 OPTIONS <a class="postlink" href="http://localhost:22742/AbpUserConfiguration/GetAll">http://localhost:22742/AbpUserConfiguration/GetAll</a>
DEBUG 2017-03-16 15:21:28,647 [20 ] Microsoft.AspNetCore.Server.Kestrel - Connection id "0HL3C95ME3CLT" completed keep alive response.
INFO 2017-03-16 15:21:28,647 [20 ] soft.AspNetCore.Hosting.Internal.WebHost - Request finished in 12.4298ms 204
INFO 2017-03-16 15:21:28,652 [3 ] soft.AspNetCore.Hosting.Internal.WebHost - Request starting HTTP/1.1 GET <a class="postlink" href="http://localhost:22742/AbpUserConfiguration/GetAll">http://localhost:22742/AbpUserConfiguration/GetAll</a> application/json
INFO 2017-03-16 15:21:28,656 [3 ] entication.JwtBearer.JwtBearerMiddleware - Bearer was not authenticated. Failure message: No SecurityTokenValidator available for token: null
DEBUG 2017-03-16 15:21:28,657 [3 ] NetCore.StaticFiles.StaticFileMiddleware - The request path /AbpUserConfiguration/GetAll does not match a supported file type
DEBUG 2017-03-16 15:21:28,657 [3 ] Microsoft.AspNetCore.Routing.RouteBase - Request successfully matched the route with name 'defaultWithArea' and template '{area}/{controller=Home}/{action=Index}/{id?}'.
DEBUG 2017-03-16 15:21:28,657 [3 ] .AspNetCore.Mvc.Internal.MvcRouteHandler - No actions matched the current request
DEBUG 2017-03-16 15:21:28,657 [3 ] Microsoft.AspNetCore.Routing.RouteBase - Request successfully matched the route with name 'default' and template '{controller=Home}/{action=Index}/{id?}'.
DEBUG 2017-03-16 15:21:28,661 [3 ] ore.Mvc.Internal.ControllerActionInvoker - Executing action Abp.AspNetCore.Mvc.Controllers.AbpUserConfigurationController.GetAll (Abp.AspNetCore)
WARN 2017-03-16 15:21:28,670 [3 ] Abp.MultiTenancy.TenantResolver - System.ArgumentOutOfRangeException: Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
at System.ThrowHelper.ThrowArgumentOutOfRangeException(ExceptionArgument argument, ExceptionResource resource)
at Abp.AspNetCore.MultiTenancy.DomainTenantResolveContributor.ResolveTenantId()
at Abp.MultiTenancy.TenantResolver.GetTenantIdFromContributors()
System.ArgumentOutOfRangeException: Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
at System.ThrowHelper.ThrowArgumentOutOfRangeException(ExceptionArgument argument, ExceptionResource resource)
at Abp.AspNetCore.MultiTenancy.DomainTenantResolveContributor.ResolveTenantId()
at Abp.MultiTenancy.TenantResolver.GetTenantIdFromContributors()
INFO 2017-03-16 15:21:28,671 [3 ] ore.Mvc.Internal.ControllerActionInvoker - Executing action method Abp.AspNetCore.Mvc.Controllers.AbpUserConfigurationController.GetAll (Abp.AspNetCore) with arguments ((null)) - ModelState is Valid
ERROR 2017-03-16 15:21:28,725 [16 ] Mvc.ExceptionHandling.AbpExceptionFilter - No language defined!
System.ApplicationException: No language defined!
at Abp.Localization.MultiTenantLocalizationDictionaryProvider.GetDefaultDictionary()
at Abp.Localization.MultiTenantLocalizationDictionaryProvider.get_DefaultDictionary()
at Abp.Localization.Dictionaries.DictionaryBasedLocalizationSource.GetAllStrings(CultureInfo culture, Boolean includeDefaults)
at Abp.Web.Configuration.AbpUserConfigurationBuilder.GetUserLocalizationConfig()
at Abp.Web.Configuration.AbpUserConfigurationBuilder.<GetAll>d__13.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at Abp.AspNetCore.Mvc.Controllers.AbpUserConfigurationController.<GetAll>d__2.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at Microsoft.AspNetCore.Mvc.Internal.ObjectMethodExecutor.<CastToObject>d__40`1.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at Microsoft.AspNetCore.Mvc.Internal.ControllerActionInvoker.
Thanks
Hi All;
I have been cloned from <a class="postlink" href="https://github.com/aspnetzero/aspnet-zero-core">https://github.com/aspnetzero/aspnet-zero-core</a> now. Then I type npm install and npm start in VS Code and run for Client side , it is all ok. Server side also show me Swagger UI api. But when i put localhost:4200 on url and run it, show me
Please, help me
Thanks and Best Regards ALL AKL
Hi, This grid table also very nice.. <a class="postlink" href="https://akveo.github.io/ng2-smart-table/">https://akveo.github.io/ng2-smart-table/</a> :D :D