Import and Apply Excel Data in Indesign Templates

Recently, the SITCON Hour of Code programming event has ended! We are also preparing thank-you notes for the teaching assistants. This time, we asked 小妘 to help design the template, so I want to record how to import Excel data and apply the template in Indesign. Prepare Excel document First, we organize the data in the Excel document and put the “data name” in the first row. The data name here will replace the text in Indesign, so it is strongly recommended to use English....

February 19, 2023 · SteveYi

PVE Configuration of Arista LACP Link Aggregation

Recently, we encountered a machine using two NVIDIA Mellanox ConnectX-4 network cards, with maximum speed support of 25G. However, since our optical module is only 10G, and Arista 7050QX also cannot support 25G Only, we decided to set up LACP. Environment Arista 7050QX-32S Proxmox VE ovs-vsctl (Open vSwitch) 2.15.0 LACP Configuration on Arista This is divided into two steps: Establish a Port Channel Assign Port Channel to physical network cards Note: Keep the switchport part as is, and remember to set up both Port Channel and Ethernet Interface on both ends....

February 7, 2023 · SteveYi

Cisco N3K-C3048TP-1GE Upgrade from 6.x to 9.x Full Process

Recently, I had a N3K-C3048TP-1GE switch with an outdated version causing some issues, so I decided to upgrade to a new version to solve these problems! Major version upgrades have certain risks, so please read this article and the official document before deciding whether to proceed! Environment Before Upgrading Model: N3K-C3048TP-1GE-SUP NXOS: 6.0(2)U3(4) Important reminder: Please follow the guide to upgrade this switch and do not upgrade to the latest version at once!...

February 6, 2023 · SteveYi

How to Upgrade Your iOS Device to Beta Version

Recently, iOS 16.3 RC was released, and as usual, the release of the RC version means that the official version update will be released in a week as well, and the two versions are no different. So, let’s take a look at how to upgrade your iOS device to RC/Beta version. How to Get Testing Qualifications There are basically two ways to download the iOS Beta version testing qualifications: Apple Beta Software Program Apple Developer Program Apple Beta Software Program Apple Beta Software Program is a public testing program provided by Apple....

January 19, 2023 · SteveYi

Configuring OOB Network on Arista

Recently deployed an Arista switch. As L3 Routing was configured on this switch, it was not possible to set the OOB network as the default route. To solve this problem, we created a VRF to isolate the OOB network. Configuration Steps First, we define a new VRF and rd vrf definition OOB rd 10:1 Next, we configure the MGMT interface interface Management1 vrf forwarding OOB ip address 10.39.0.2/24 Set a static route and enable the routing feature of VRF...

July 5, 2022 · SteveYi Yo

Encountering Dynamic Linking Library Missing Issue when Building Golang

Hi! Recently, I have been working on some Golang projects. While using Docker build image, I encountered some issues. Issue After Docker image build is completed, the following error occurs when executing docker run: standard_init_linux.go:211: exec user process caused "no such file or directory" Cause Taking the project URL-Shortener that I am currently working on as an example. In this project, I use the Library go-sqlite3. We can notice that go-sqlite3 is written in C programming language....

April 7, 2022 · SteveYi

Make a RESTFul API to upload files to S3 with Golang

I have two S3 bucket services, one is sponsored by @Licson, another is Backblaze B2. I usally upload my static asset file or resource file to them. Today, I want to make a RESTFul API to upload files to S3. Let’s do it! Environment Package list: github.com/aws/aws-sdk-go v1.43.28 github.com/gin-contrib/cors v1.3.1 github.com/gin-gonic/gin v1.7.7 github.com/joho/godotenv v1.4.0 Write a gin router Before start, Let me quick to introduce the gin framework. Gin is a web framework for Go....

March 31, 2022 · SteveYi

A capitalizations name issue can not build golang app

Recently, I’m working on a project which is a URL Shortener with Golang. Here is current architecture. steveyiyo@SteveYis-MacBook-Pro-2 URL-Shortener % tree . ├── README.md ├── config.yaml ├── config.yaml.example ├── data.db ├── details.md ├── dockerfile ├── go.mod ├── go.sum ├── internal │ ├── cache │ │ ├── cache.go │ │ └── cache_test.go │ ├── Database │ │ └── database.go │ └── Tools │ └── tools.go ├── main.go └── package └── utils └── utils....

March 29, 2022 · SteveYi

Acquires AS7480 (Inter-RIR transfer)

History IANA earlier assigned AS7467 - 7722 to APNIC and APNIC assigned it to their members or other legal entities. % IANA WHOIS server % for more information on IANA, visit http://www.iana.org % This query returned 1 object refer: whois.apnic.net as-block: 7467-7722 organisation: Assigned by APNIC whois: whois.apnic.net descr: Assigned by APNIC source: IANA Recently, Jason decided to change their network service provider. It’s mean they didn’t need multihoming, so he decided to transfer AS Number to me....

March 8, 2022 · SteveYi Yo

Implementing Virtual WAN Multi-PPPoe on Linux

The other day, I remembered that my ISP (Chunghwa Telecom) at home can obtain 7 floating Public IPv4 Addresses through dial-up, so I decided to implement it! Environment The following information was generated through the bench.sh script. ---------------------------------------------------------------------- CPU Model : Intel(R) Celeron(R) CPU 3865U @ 1.80GHz CPU Cores : 2 CPU Frequency : 1278.526 MHz CPU Cache : 2048 KB Total Disk : 14.9 GB (6.6 GB Used) Total Mem : 1910 MB (256 MB Used) Total Swap : 2047 MB (0 MB Used) System uptime : 3 days, 18 hour 30 min Load average : 0....

July 19, 2021 · SteveYi