How to start the framework maintenance screens, which logon user ? Cancel The title field is required!

1. Carl Verbiest

   

   59 posts
   Registered:
   12 Oct 2018
   13 Dec 2018

   Link to this post

   When starting Consultingwerk\Windows\Framework\Reference\start.p
   it requires a .applicationsettings
   
   I found none so I used one we already have within our own application

   {
       "authenticationDb": "LISA",
       "homePageUrl": "http://www.cce.be",
       "frameworkLoader": "be.cce.SmartTools.SmartFramework.CceFrameworkLoader",
       "defaultPartition": "default_local",
       "maintainPasswordInSmartUser": "false",
       "AppServerKeepAlivePeriod": "300"
   }

   I now get a logon screen but I cannot log on using a user present in the LISA database.
   Our smartdb is a newly created smartdb using the setup / upgrade procedure
   
   

    
2. Mike Fechner

   

   319 posts
   Registered:
   14 Sep 2016
   13 Dec 2018 in reply to Carl Verbiest

   Link to this post

   This document describes how to create a default user and login company in the SmartDB:
   
   https://documentation.consultingwerkcloud.com/display/SCL/Steps+to+create+a+new+SmartDB+and+setup+data+and+config+for+SmartDB.SmartUser+based+authentication
3. Carl Verbiest

   

   59 posts
   Registered:
   12 Oct 2018
   13 Dec 2018 in reply to Mike Fechner

   Link to this post

   Ok, but with the application settings I'm using I was expecting to be able to log on using LISA._user users.
   
   I ran create user, it gave no feedback so I guess there were no errors.
   The logon dialog now show "Demo company"
   Cannot log on using admin + password
   
   I changed "applicationSettings" in Consultingwerk/Windows/Framework/Reference/startup_gui_fatclient.json to
   
   

       "applicationSettings": "reference.applicationsettings",

   
   and created reference.applicationsettings containing
   

   {
       "authenticationDb": "SmartDB",
       "homePageUrl": "http://www.cce.be",
       "frameworkLoader": "be.cce.SmartTools.SmartFramework.CceFrameworkLoader",
       "defaultPartition": "default_local",
       "maintainPasswordInSmartUser": "true",
       "AppServerKeepAlivePeriod": "300"
   }

   result remains the same, can't logon with admin+password
   also tried config below, error "Unable to login due to invalid user credentials!" remains
   

   {
       "homePageUrl": "http://www.cce.be",
       "defaultPartition": "default_local",
       "maintainPasswordInSmartUser": "true",
       "AppServerKeepAlivePeriod": "300"
   }

   
   

    
4. Carl Verbiest

   

   59 posts
   Registered:
   12 Oct 2018
   13 Dec 2018 in reply to Carl Verbiest

   Link to this post

   Still no success
   
   SmartDB _user table is empty
   SmartUser contains 1 entry for admin user

   Authentication logon, Using custom entry Authentication:3
   trimmed to the relevant part (as far as I can tell)
   
   

   [18/12/13@16:26:53.567+0100] P-014224 T-007696 1 4GL ServiceInt     InvokeMethod Request to Business Entity: Consultingwerk.SmartFramework.Authentication.UserBusinessEntity
   [18/12/13@16:26:53.567+0100] P-014224 T-007696 1 4GL ServiceInt        Serialized Params: {
   [18/12/13@16:26:53.567+0100] P-014224 T-007696 1 4GL ServiceInt       "SerializedType": "Consultingwerk.SmartFramework.Authentication.AuthenticationParameter",
   [18/12/13@16:26:53.567+0100] P-014224 T-007696 1 4GL ServiceInt       "CompanyKey": "e8a86a29-f030-33a2-4914-0366c076c416",
   [18/12/13@16:26:53.567+0100] P-014224 T-007696 1 4GL ServiceInt       "CompanyName": "Demo Company",
   [18/12/13@16:26:53.567+0100] P-014224 T-007696 1 4GL ServiceInt       "Password": "password",
   [18/12/13@16:26:53.567+0100] P-014224 T-007696 1 4GL ServiceInt       "UserName": "admin",
   [18/12/13@16:26:53.567+0100] P-014224 T-007696 1 4GL ServiceInt       "ClientPrincipal": ""
   [18/12/13@16:26:53.567+0100] P-014224 T-007696 1 4GL ServiceInt     }
   [18/12/13@16:26:53.569+0100] P-014224 T-007696 1 4GL ServiceInt     InvokeMethod Request to Business Entity: Consultingwerk.SmartFramework.Authentication.UserBusinessEntity
   [18/12/13@16:26:53.569+0100] P-014224 T-007696 1 4GL ServiceInt        Method-Name:       PerformDatabaseAuthentication
   [18/12/13@16:26:53.569+0100] P-014224 T-007696 1 4GL ServiceInt        Dataset:           <no dataset>
   [18/12/13@16:26:53.569+0100] P-014224 T-007696 1 4GL ServiceInt        Parameter Object:  Consultingwerk.SmartFramework.Authentication.AuthenticationParameter
   [18/12/13@16:26:53.636+0100] P-014224 T-007696 1 4GL DataAccess     Client-Query: FOR EACH eSmartSecurityObject WHERE eSmartSecurityObject.SecurityObjectName EQ "Consultingwerk.SmartFramework.Authentication.UserBusinessEntity"
   [18/12/13@16:26:53.636+0100] P-014224 T-007696 1 4GL DataAccess     Default-Query: FOR EACH SmartSecurityObject INDEXED-REPOSITION
   [18/12/13@16:26:53.638+0100] P-014224 T-007696 1 4GL DataAccess     Prepare-Query: FOR EACH SmartSecurityObject WHERE SmartSecurityObject.SecurityObjectName EQ "Consultingwerk.SmartFramework.Authentication.UserBusinessEntity" INDEXED-REPOSITION
   [18/12/13@16:26:53.638+0100] P-014224 T-007696 1 4GL DataAccess     Index Information on Buffer SmartSecurityObject: SecurityObjectName
   [18/12/13@16:26:53.644+0100] P-014224 T-007696 1 4GL DataAccess     Restart-Rowid for Table eSmartSecurityObject: ?
   [18/12/13@16:26:53.645+0100] P-014224 T-007696 1 4GL DataAccess     Next-Rowid for Table eSmartSecurityObject: ?
   [18/12/13@16:26:53.645+0100] P-014224 T-007696 1 4GL DataAccess     Last-Batch for Table eSmartSecurityObject: yes
   [18/12/13@16:26:53.678+0100] P-014224 T-007696 1 4GL DataAccess     Client-Query: FOR EACH eSmartSecurityToken WHERE eSmartSecurityToken.SecurityTokenCode EQ "ServiceInterface.Invoke.PerformDatabaseAuthentication"
   [18/12/13@16:26:53.678+0100] P-014224 T-007696 1 4GL DataAccess     Default-Query: FOR EACH SmartSecurityToken INDEXED-REPOSITION
   [18/12/13@16:26:53.681+0100] P-014224 T-007696 1 4GL DataAccess     Prepare-Query: FOR EACH SmartSecurityToken WHERE SmartSecurityToken.SecurityTokenCode EQ "ServiceInterface.Invoke.PerformDatabaseAuthentication" INDEXED-REPOSITION
   [18/12/13@16:26:53.681+0100] P-014224 T-007696 1 4GL DataAccess     Index Information on Buffer SmartSecurityToken: SecurityTokenCode
   [18/12/13@16:26:53.681+0100] P-014224 T-007696 1 4GL DataAccess     Restart-Rowid for Table eSmartSecurityToken: ?
   [18/12/13@16:26:53.682+0100] P-014224 T-007696 1 4GL DataAccess     Next-Rowid for Table eSmartSecurityToken: ?
   [18/12/13@16:26:53.682+0100] P-014224 T-007696 1 4GL DataAccess     Last-Batch for Table eSmartSecurityToken: yes
   [18/12/13@16:26:53.691+0100] P-014224 T-007696 1 4GL APPL           ----------------------------------------
   [18/12/13@16:26:53.693+0100] P-014224 T-007696 1 4GL Authentica     Authenticating user: admin e8a86a29-f030-33a2-4914-0366c076c416 Demo Company Database: SmartDB
   [18/12/13@16:26:53.695+0100] P-014224 T-007696 1 4GL ServiceInt     FetchData Request to Business Entity: Consultingwerk.SmartFramework.System.LoginCompanyBusinessEntity
   [18/12/13@16:26:53.695+0100] P-014224 T-007696 1 4GL ServiceInt        Tables:        eSmartLoginCompany
   [18/12/13@16:26:53.695+0100] P-014224 T-007696 1 4GL ServiceInt        Queries:       FOR EACH eSmartLoginCompany WHERE eSmartLoginCompany.LoginCompanyGuid = "e8a86a29-f030-33a2-4914-0366c076c416"
   [18/12/13@16:26:53.695+0100] P-014224 T-007696 1 4GL ServiceInt        NumRecords:    0
   [18/12/13@16:26:53.695+0100] P-014224 T-007696 1 4GL ServiceInt        Context:       
   [18/12/13@16:26:53.695+0100] P-014224 T-007696 1 4GL ServiceInt        CustomContext: 
   [18/12/13@16:26:53.700+0100] P-014224 T-007696 1 4GL DataAccess     Client-Query: FOR EACH eSmartLoginCompany WHERE eSmartLoginCompany.LoginCompanyGuid = "e8a86a29-f030-33a2-4914-0366c076c416"
   [18/12/13@16:26:53.700+0100] P-014224 T-007696 1 4GL DataAccess     Default-Query: FOR EACH SmartLoginCompany INDEXED-REPOSITION
   [18/12/13@16:26:53.702+0100] P-014224 T-007696 1 4GL DataAccess     Prepare-Query: FOR EACH SmartLoginCompany WHERE SmartLoginCompany.LoginCompanyGuid = "e8a86a29-f030-33a2-4914-0366c076c416" INDEXED-REPOSITION
   [18/12/13@16:26:53.702+0100] P-014224 T-007696 1 4GL DataAccess     Index Information on Buffer SmartLoginCompany: LoginCompanyGuid
   [18/12/13@16:26:53.702+0100] P-014224 T-007696 1 4GL DataAccess     Restart-Rowid for Table eSmartLoginCompany: ?
   [18/12/13@16:26:53.704+0100] P-014224 T-007696 1 4GL DataAccess     Next-Rowid for Table eSmartLoginCompany: ?
   [18/12/13@16:26:53.704+0100] P-014224 T-007696 1 4GL DataAccess     Last-Batch for Table eSmartLoginCompany: yes
   [18/12/13@16:26:53.704+0100] P-014224 T-007696 1 4GL BUFFER         Buffer eSmartLoginCompany: record with ROWID 0x000000000002e900
   [18/12/13@16:26:53.706+0100] P-014224 T-007696 1 4GL APPL            ROW-STATE: ROW-UNMODIFIED
   [18/12/13@16:26:53.706+0100] P-014224 T-007696 1 4GL APPL           eSmartLoginCompany.LoginCompanyGuid <character>: "e8a86a29-f030-33a2-4914-0366c076c416"
   [18/12/13@16:26:53.706+0100] P-014224 T-007696 1 4GL APPL           eSmartLoginCompany.LoginCompanyName <character>: "Demo Company"
   [18/12/13@16:26:53.706+0100] P-014224 T-007696 1 4GL APPL           eSmartLoginCompany.LoginCompanyShort <character>: "demo"
   [18/12/13@16:26:53.706+0100] P-014224 T-007696 1 4GL APPL           eSmartLoginCompany.LoginCompanyImageLarge <character>: ""
   [18/12/13@16:26:53.706+0100] P-014224 T-007696 1 4GL APPL           eSmartLoginCompany.LoginCompanyImageSmall <character>: ""
   [18/12/13@16:26:53.706+0100] P-014224 T-007696 1 4GL APPL           eSmartLoginCompany.LoginCompanyReferenceChar <character>: ""
   [18/12/13@16:26:53.706+0100] P-014224 T-007696 1 4GL APPL           eSmartLoginCompany.LoginCompanyReferenceDecimal <decimal>: 0
   [18/12/13@16:26:53.706+0100] P-014224 T-007696 1 4GL APPL           eSmartLoginCompany.LoginCompanyReferenceInteger <integer>: 0
   [18/12/13@16:26:53.706+0100] P-014224 T-007696 1 4GL APPL           eSmartLoginCompany.LoginCompanyTenantDomain <character>: "demo"
   [18/12/13@16:26:53.709+0100] P-014224 T-007696 1 4GL Authentica     Authenticating: admin@demo Result: no
   [18/12/13@16:26:53.709+0100] P-014224 T-007696 1 4GL APPL           ----------------------------------------
   [18/12/13@16:26:53.714+0100] P-014224 T-007696 1 4GL APPL           An Consultingwerk.Framework.Exceptions.AuthenticationException has occurred:
   [18/12/13@16:26:53.714+0100] P-014224 T-007696 1 4GL APPL           Unable to login due to invalid user credentials!

    
5. Mike Fechner

   

   319 posts
   Registered:
   14 Sep 2016
   13 Dec 2018 in reply to Carl Verbiest

   Link to this post

   If you want to Authenticate against passwords in the LISA DB, set the authenticatenDB setting in the .applicationsettingsfile to LISA and make sure you are using the DatabaseAuthenticationService.
   
   The AuthenticationService authenticates against a password in the SmartUser record.
   
   For both AuthenticationService implementations you will need to create SmartUser records.
   
   "admin" has no special role. It's just our chosen default.
6. Carl Verbiest

   

   59 posts
   Registered:
   12 Oct 2018
   13 Dec 2018 in reply to Mike Fechner

   Link to this post

   Hi Mike,
   
   I don't mind which authentication is used.
   I'm happy to use the default if I can get it working
   
   I want to have a look at the smartrelations
   
   PS: I don't receive emails when you post an update,
   if I click email subscription it shows "You have already subscribed to new posts via email"