chenbojian’s gists

chenbojian / autofix-cloudsync.sh

Created September 19, 2025 03:05

Fix for Synology Cloud Sync: Sync folder does not exist

	#!/usr/bin/env bash

	output=$(ssh nas "sqlite3 /volume1/@cloudsync/db/config.sqlite 'select * from session_table where error = -12'")
	if [[ -n "$output" ]]; then
	echo "Got error in CloudSync: $output"
	ssh nas "sudo sqlite3 /volume1/@cloudsync/db/config.sqlite 'UPDATE session_table SET error = 0 WHERE error = -12'"
	ssh nas "sudo synopkg restart CloudSync"
	else
	echo "No error"
	fi

chenbojian / force-xhr-status-with-proxy.js

Created December 23, 2024 12:56 — forked from davidsharp/force-xhr-status-with-proxy.js

Proxying a XMLHttpRequest to force the status received

	XMLHttpRequest = new Proxy(XMLHttpRequest, {
	construct:function(t,a){
	const req = new t();
	return new Proxy(req, {
	get:function(o,p){
	if(p=='status')return 9001
	return typeof o[p] == 'function'?o[p].bind(o):o[p]
	},
	set: function(target, prop, value) {
	Reflect.set(target, prop, value) // or target[prop] = value

chenbojian / http-proxy-connect.js

Last active December 26, 2023 02:57

simple nodejs http proxy implementation

	# https://imququ.com/post/web-proxy.html
	var http = require('http');
	var net = require('net');
	var url = require('url');

	function connect(cReq, cSock) {
	var u = url.parse('http://' + cReq.url);

	var pSock = net.connect(u.port, u.hostname, function() {
	cSock.write('HTTP/1.1 200 Connection Established\r\n\r\n');

chenbojian / aspnetcore-cookie-authentication.cs

Last active May 16, 2023 03:31

chenbojian / auto-add-pragama-warning-disable.cs

Created March 29, 2023 23:55

	// See https://aka.ms/new-console-template for more information

	using System.Text;
	using System.Text.RegularExpressions;

	var lines = File.ReadAllLines("error.txt");
	var regex = new Regex(@"(C:\\workspace.+.cs)$(.+),(.+)$: Error CodeAnalyzer0001", RegexOptions.Compiled);
	Console.WriteLine("start");

	var fileRowsDict = new Dictionary<string, List<int>>();

chenbojian / update-sql-dataset.cs

Created September 13, 2022 14:11

	void Update(DataRow newRow, string connStr, string tableName)
	{
	using MySqlDataAdapter da = new MySqlDataAdapter(
	$"select * from {tableName}",
	connStr
	);

	da.UpdateCommand = new MySqlCommandBuilder(da).GetUpdateCommand();

	DataSet ds = new DataSet();

chenbojian / MFC-CRecordset-example.cpp

Last active September 4, 2022 02:30

MFC CRecordset

	void func() {
	CDatabase db;
	CRecordset rs(&db);
	db.OpenEx("Driver={Microsoft Access Driver (*.mdb)};Dbq=C:\\dbo.mdb;");

	db.ExecuteSQL("select * from Sporter");

	rs.Open(CRecordset::dynaset, "select * from [Sporter]", CRecordset::none);

	BOOL a = rs.CanAppend();

chenbojian / gbk-to-utf8.ps1

Created July 24, 2022 00:30

gbk to utf8

	function Convert-Gbk-To-Utf8($source, $dest) {
	$gbk = [System.Text.Encoding]::GetEncoding("gb2312")
	$utf8 = [System.Text.Encoding]::UTF8
	$text = [System.IO.File]::ReadAllText($source, $gbk)
	[System.IO.File]::WriteAllText($dest, $text, $utf8)
	}

chenbojian / Get-AzStorageAccessDetails.ps1

Last active November 26, 2020 11:11


	$roleAssignments = Get-AzRoleAssignment
	$roles = Get-AzRoleDefinition

	# https://docs.microsoft.com/en-us/azure/role-based-access-control/resource-provider-operations
	$storageActionRegexList = @('^\$', '^\/.+$', '^Microsoft\.Storage/.+$')
	$storageDataActionRegexList = @('^\$', '^\/.+$', '^Microsoft\.Storage/.+$')

	$storageManagementAccessRoles = @()
	$storageDataAccessRoles = @()

chenbojian / config-iis-log-format.ps1

Last active September 29, 2020 09:10

	# ref: https://docs.microsoft.com/en-us/iis/configuration/system.applicationhost/sites/site/logfile/
	# ref: https://forums.iis.net/t/1205491.aspx?Add+IIS+8+5+Custom+Logging+Fields+with+Powershell

	function Set-WebSiteIISLogFormat {
	param (
	$Site
	)

	$logExtFileFlags = 'Date,Time,ClientIP,UserName,ServerIP,Method,UriStem,UriQuery,HttpStatus,Win32Status,TimeTaken,ServerPort,UserAgent,Referer,Host,HttpSubStatus'
	Set-ItemProperty -Path "IIS:\Sites\$Site" -Name logfile.logExtFileFlags -Value $logExtFileFlags

	var builder = WebApplication.CreateBuilder(args);

	builder.Services.AddAuthentication(CookieAuthenticationDefaults.AuthenticationScheme)
	.AddCookie(CookieAuthenticationDefaults.AuthenticationScheme, o => { o.LoginPath = "/login"; });

	builder.Services.AddAuthorization();

	var app = builder.Build();

	app.UseAuthentication();

chen bojian chenbojian