Enable Region to new Project/Partner

 Update WebstoreInstallationProfiles Table 

Region need to add :WEU

InstallationTypeId : 4 // customized

PartnerId : 5AFFFDF6-21DA-4E30-92C1-4A8D55DBFE9C


SELECT * FROM dbo.WebstoreInstallationProfiles SanaRegionCode

where SanaRegionCode ='WEU' and 

InstallationTypeId = 4 

PartnerId='5AFFFDF6-21DA-4E30-92C1-4A8D55DBFE9C'


Copy last data and past for new line 

Update ConnectwithProfile field as latest id : 40

Update PartnerId field :



Then Login platform portal and check changes are applied.

[ClusterId] should not null --> correct cluster can find from  [dbo].[AKSClusters] table 

isActivate should true






to avoid issue copy record "Upgrade cronjob project" working project item 


Verify with webstore azure settings table 

for testing

When Creating a new Partner it will create 2 recodes on  [PartnerViewPermissionMaps] Table

  1. Sana Commerce partner
  2. Same partner 


SELECT TOP (1000) [Id]
,[PartnerGroupID]
,[PartnerGroupViewID]
,[CreatedUser]
,[CreatedDateTime]
,[ModifiedUser]
,[ModifiedDateTime]
FROM [dbo].[PartnerViewPermissionMaps]
where [PartnerGroupViewID] = 'CB9D1A20-824F-44B6-B5A4-D95B29E7C682'

SELECT*  FROM [dbo].[Partners]
where name in ('Cy_PartnerQQ','Sana Commerce')




To view Other Partners webstores , record needs to add manually to [PartnerViewPermissionMaps] Table.










sana Subscription to instralltion

 only for Saas and customized projects 

 Task 165771: [QA]: Add property subscription to Installation


The license owner needs to have a subscription 

CRM data will sync every 2/5 minutes with the platform through a web job.

CRM data --> Tables [SanaCommunityCustomers] --> [SanaCommunitySubscriptions]



we need to update is IsActive True to enable the scbscribe drop down 

Update [dbo].[SanaCommunitySubscriptions] set IsActive =1 where [AccountId] = 'E1E75F2A-4DAD-E911-A85E-000D3AB0DA57'




for Live :- a single subscription can only have 1 installation of Hosting Level

for Beta - a single subscription can have many installations


To install new webstore you need to add data to [SanaCommunityCustomers] --> [SanaCommunitySubscriptions] and continue.









Create release package

 video : C:\Users\s.kodagoda\Downloads\create release package 

file:///C:/Users/s.kodagoda/Downloads/installCustomized%20project.webm


power shell use from Core team to create push release packages

D:\PushReleasePackage (New)\PushReleasePackage (New)


open Microsoft azure storage explore 

local & Attached > Storeage Accounts >  

Azure > Container registries > search "Sanaacweu01" > repositories. 








sanaacrweu01 azure container registry


Repositoies 


already installed 

core /customized projects changes push to this location.





image repository


toolkit (its not change frequently) 



The story behind the process

create a new partner

Create a Project by Partner


Create a customized Project


8 navigates to sanaplatform prod storage account in azure






11 go to 












 



















Add custom domain Multi shop

 Go to webstore and copy the name of webstore.



copy the ip address from webstore overview > properties section.


Go to Azure portal 
https://portal.azure.com/#@ism-egroup.com/resource/subscriptions/865d29cc-727d-4207-8aa3-c00ccdb7710a/resourceGroups/RG-DNS-SANA/providers/Microsoft.Network/dnszones/sanastores.net/overview

DNS 

sanastores.net (DNS zone)

sana-commerce.com


click record id
give copy name with id ( unique name )
TTL unit  set to second 
past the ip address.
before clicking Ok copy the name you give to record set.
then click ok.




Go to custom Doman 
give id and name.
past the copied recordset name from the azure portal.
upload certificate pw : abc123
click add domain.


Then shedule and Approve it.
Then custo domain will create.


1. 



2. it will combine URL saduntestsana(webstore name) + sanastore02(website name) + .sana-test-cloud.net(default site domain)




3. it will 




4, need to bind from azure side.

 



//-----------------------------------------

Copy content from another website

NO separate permission for this

it will create a new website, copy all the images, menu, languages, add-ons,

it will not copy customer-related data, baskets, orders, etc.



Verify on 

1. Lens > Network > ingress > search by webstoreId 

Newly added webstores are applied here.














2. Verify the License file

 old file should revoke and a new file should be added.


https://upgrade-community.sana-test-cloud.net/MySana/Licensepage.aspx



new Fastly changes when add sana-commerce.lk













How to use Blaze Meter with JMeter

1. Go to the Site that needs to be tested.

2. click blazer icon (need to install blazer Extention)-> click red record button




3. Navigate few pages and click stop
4. Click JMeter and save it.
click Blazer icon > save  (log with gmail)


5. open Jmetre File > Open (select saved file)

6.Thread Group > right click > Add > Listner > View Result in Table
C:\JMeter\bin\jmeter > double click




add traffic by increasing following 











Enable Open Vpn

1. Find the correct Pod
2. Before applying any changes check container count(green dot count)
eg: one container (one green dot) 





before add vpn

3. Upload the VPN file and give the schedule date and submit.

Sample VPN file can find here: vpn File on drive



4. Then approve the request then go to all web store 


after instraltion compleated/ active 
go to Lenc >  it will show folowing
  • 2 instrance 
  • Vpn section 




















Resource Allocation

 file:///C:/Users/s.kodagoda/Downloads/Resource%20Allocation2022.3.9.webm

customize / Saas > stagin prod 

internal trial > stagin demo





 first search on Workloads > Pods 

the webstore is correctly assign to pod.


Configuration > HPA (Horizontal Pod Autoscaler)



Then add traffic to the site  eg:testsadunadvancecustomized.sana-test-cloud.net

once increase  the traffic,  it will increase the Replica count 




Q1 CPU / Memory new values how to check on "Lens" software








Subscribe to: Posts (Atom)