Check Point – 31 Days + 4 before CCSE

Starting CCSE Training on Monday. TOPICS Management Upgrade and Migration Management High Availability Security Gateway Upgrades Advanced Check Point Maintenance Security Gateway Operations Policy Installation Gaia and Management APIs Acceleration Site-to-Site VPN Remote Access VPN Mobile Access VPN Clustering Advanced Logs and Monitoring Links https://www.checkpoint.com/downloads/training/CCSE_Overview_Flyer.pdf

BGP – Asymmetric Routing Fortigate or when it is the policy

Change the Setup to have two dedicated links from the fortigate to the Edgerouter. Internal6 and 7 on the Fortigate and eth4 on the edgerouters. Note to myself Policy blocked the traffic. Needed to change the source interfaces to include i6 and i7. config firewall policy edit 1 set srcintf internal1.997 next end Links https://community.fortinet.com/t5/FortiGate/Technical-Note-Reverse-Path-Forwarding-RPF-implementation-and/ta-p/194382

BGP – Prevent becoming a Transit-AS

AS-Path FilteringNo-export CommunityPrefix-list FilteringDistribute List Filtering AS-Path Filtering ip as-path access-list 1 permit ^$ neighbor x.x.x.x filter-list 1 out No-export Community ip bgp-community new-format route-map NO-EXPORT ​set community no-export neighbor x.x.x.x route-map NO-EXPORT in neighbor x.x.x.x send-community Prefix-list Filtering ip prefix-list NO-TRANSIT permit x.x.x.x/x neighbor x.x.x.x prefix-list NO-TRANSIT out Distribute List Filtering access-list x deny x.x.x.x y.y.y.y …

BGP – MultiHoming

Revisiting an old post. This lab started with a simple customer question: “We have two equal paths through our MPLS network. Why aren't we using both?” BGP and redundancy were already there. Load balancing wasn't. The operator's answer was essentially that this was not part of their supported operational model. Fair enough. But that left …

Kimai2 – SQL

Sample QueryCreate Stored ProcedureCall the procedure Do we have stored procedures? Sample Query SELECT u.username as Username, c.name as Customer, DATE_FORMAT(t.start_time,'%Y-%m') as Date, FORMAT(SUM(t.duration) / 3600, 0) as Duration FROM kimai2_timesheet t LEFT JOIN kimai2_projects p ON t.project_id = p.id LEFT JOIN kimai2_customers c ON p.customer_id = c.id LEFT JOIN kimai2_users u ON t.user = …

Check Point – VSX Upgrade

Note to my self. Since i am not dealing with VSX Systems that often, please be reminded. When dealing with VSX Gateways/Clusters to finalize the upgrade the SMS needs to Upgrade the VSX Objects in the SMS Database. [Expert@CheckPointSMS:0]# vsx_util upgrade ****************************************************************************************** * Note: the operation you are about to perform changes the information in …