You can use Sieve mail filters to control how mail is delivered.

After mounting a NTFS partiton in read/write, a NFS partition and just last week a LVM2_member partition. Its time for a new episode in the series: How to mount an unknown file-type in Linux. As they say, the saga continues. Note that I use proxmox (Debian spin) on this machines, this makes that ZFS was already installed. Installing ZFS is easy, and I done it before on Mint, the official ZFS (on linux) information is also a huge help, so head over there if you wan’t up-to-date install & configuration help.

Contact management for non-profits, powered by Free Software.

If you have any kind of server connected to the Internet, you are no doubt aware that no matter how small or unimportant it might seem, it is frequently probed, tested or subject to various attempts at abuse.

I’ve started working with a new sysadmin the last few weeks (hey Dan if he’s reading). Like all sysadmins, they bring a new flavour to the game of work. Dan shared this with me, which I…

Postmortem of a Linux honeypot server attack using Sysdig syscall interception to find out what the hackers did.

Taiga

Simply superior glass. Tank beakers are hand blown in Los Angeles, CA and made to last.

Established in 2002, Taperssection.com is the forum community of live concert recordists. Taperssection is full of archived information and professional recordists who are ready to help you with your live sound recording questions

Benchmarks & Tips for Big Data, Hadoop, AWS, Google Cloud, PostgreSQL, Spark, Python & More...

Real-time barometer of IT freelancer workload, demand, and outlook. Community-driven insights from developers, engineers, and product professionals worldwide.

I was dismayed to see Citrix’s recent announcement about Xenserver 7.3 removing several key features from the free version. Xenserver’s free features are the reason I switched over to them in the first place back in 2014. Xenserver has been rock solid; I haven’t had any complaints until now. Their removal of xenmotion and migration … Continue reading Migrate from Xenserver to Proxmox →

We run small projects that help normalize Palestinian humanity in different ways. #freepalestine

{{ $description }}

Informacijska tehnologija, družba in človekove pravice.

http://youtu.be/RVVaWoxHKJo The python script which controls the LED's can be found here: https://docs.google.com/file/d/0B1i26... The two entries i made to the /etc/rc.local file are: python /scripts/wardrivestatus.py & kismet_server & Adding these entries will allow everything to start automatically on boot. The model number of GPS receiver is BU-353. The network card is an: Alfa networks AWUS036H…

Tessel 2, revitalized by BairesDev, accelerates IoT and robotics with Node.JS. Explore plug-and-play modules and join our open-source community

The new bee shed is in an apiary with space for about a dozen additional hives around it. The apiary is fenced and heavily sheltered from cold easterly winds by a convenient strip of woodland. However, the site is open and exposed to westerlies. These can whip in across the

There's plenty written about this show, not the least because it was the first Dick's Pick. I'll just stick up for my favorite Nobody's Fault and especially the jam that follows, so it doesn't get overshadowed by Latvala's "monster" Here Comes Sunshine. I put up a 320 of the show. The link should be good…

Best Photos, Videos, Gifs and Memes about Humanity - Isn't humanity great?! Browse our humanity content to get inspired by humankind! Restore faith in humanity with these pictures, memes and video clips - Keep Calm and Chive On!

The Closing of Winterland

Someone who spends too much time on computers.

Few weeks ago I spend some time to playing with SNMPv3 on OpenBSD. Now I rewrite my old SNMPv2c script. New script is implemented in Python3, uses easysnmp library and supports all three authentication methods of SNMPv3. New version of script supports everything what supports old one. It's standard monitoring stuff (common used by Icinga/Nagios/Centreon)…

Few weeks ago I spend some time to playing with SNMPv3 on OpenBSD. Now I rewrite my old SNMPv2c script. New script is implemented in Python3, uses easysnmp library and supports all three authentication methods of SNMPv3. New version of script supports everything what supports old one. It's standard monitoring stuff (common used by Icinga/Nagios/Centreon)…

Graylog is a centralized log management solution to capture, store and analyze log files in real-time. Starting with the latest minor release 4.3 Graylog announced to no longer support Elasticsearch (ES) due to licensing and structural changes Elastic introduced in v7.11. For this reason, the last supported ES version is 7.10, which has already reached EOL on May 11, 2022.

A Hacker's Blog of Unintended Use and Insomnia.

Introduction My first encounter with docker goes back to early 2015. Docker was experimented with to find out whether it could benefit us. At the time it wasn't possible to run a container [in the background] and there wasn't any command to see what was running, debug or ssh into the container. The experiment was…

ChatGPT can harm an individual’s critical thinking over time, a study released this month suggests. Researchers at MIT’s Media Lab asked subjects to write several SAT essays and separated sub…

Holybet777 adalah agen situs slot online terpercaya dengan bocoran slot gacor hari ini dari slot88 yang paling viral di tahun 2024 ini

In light of last month's Juniper news, we examined published NSA documents about encryption and decided to un-redact a previously controversial redaction.

Apple fights to keep the U.S. government out of its phones. Cellebrite is the leader in helping break in. An inside look at the secretive Israeli company.

I had long been aware of the [effort of cznic](https://gitlab.com/cznic/sqlite) to automatically translate the C source of SQLite to Go while avoiding the complexity CGo would introduce. SQLite was always meant to be a database you embed into your application, and I was curious what tradeoffs that meant, if any, and just generally how it differed from the usual suspects (PostgreSQL, etc.). To explore these trade-offs and differences, I decided to dive deeper into the usage of this library. SQLite is a single-writer multiple-reader database. Using just a single instance of database/sql.DB will not work well with this, because it will make it hard to avoid receiving SQLITE_BUSY errors when multiple writers try to run at the same time (because sql.DB is a connection pool). So we will need to separate readers from writers by making two instances of database/sql.DB and limiting the writer to a single [MaxOpenConn](https://pkg.go.dev/database/sql#DB.SetMaxOpenConns) and the reader to as many as you require. So far, SQLite is behaving remarkably like other databases apart from the single-writer gotcha; we still have connections and per-connection settings. The usual way to pass these settings is usually in the DSN you pass to [sql.Open](https://pkg.go.dev/database/sql#Open) and this is [definitely possible](https://pkg.go.dev/modernc.org/sqlite#Driver.Open), but I find that it would be more straightforward if I could just run my custom SQL when a new connection is made[1]. We can do that with [sqlite.RegisterConnectionHook](https://pkg.go.dev/modernc.org/sqlite#RegisterConnectionHook). Now the question is what settings to use, because [there are quite a few of them](https://www.sqlite.org/pragma.html). These are the ones I am using personally: - `PRAGMA journal_mode = WAL;` Use write-ahead-logging. Better concurrency, but with an edge-case: with heavy writers, the wal can grow idefinitely ([see for more](https://www.sqlite.org/cgi/src/doc/wal2/doc/wal2.md)). I don't expect this will happen in my use-case. For a good description on the various jornal modes, [see this blogpost](https://www.mycelial.com/learn/sqlite-journal-mode-options). - `PRAGMA synchronous = NORMAL;` Since with the WAL journal mode, this is safe, there is no reason to use FULL. - `PRAGMA temp_store = MEMORY;` Let's store temporary indices, tables, etc. in memory, my use-case is not very resource-constrained to require using the filesystem (also, [this is a fun read](https://www.sqlite.org/fasterthanfs.html) if we are talking about additional syscalls to the kernel) - `PRAGMA mmap_size = 30000000000; -- 30GB` Just making sure, access to my database is always done with memory-mapped I/O. - `PRAGMA busy_timeout = 5000;` How much time to wait in milliseconds after which SQLITE_BUSY is returned when waiting for the db to unlock. - `PRAGMA automatic_index = true;` Make sure [automatic indexing](https://www.sqlite.org/optoverview.html#autoindex) is enabled, it can only help, and is a great way to get warnings about indexes that should be created. - `PRAGMA foreign_keys = ON;` Make sure foreign key enforcement is enabled. - `PRAGMA analysis_limit = 1000;` Make sure [ANALYZE](https://www.sqlite.org/lang_analyze.html#approx) returns quickly in case the DB gets large. - `PRAGMA trusted_schema = OFF;` No idea what security audited functions are, but this setting makes sure only those can be run. The manual page tells me to turn it off anyway, so let's do that. Not all of these settings are per-connection settings, but it doesn't hurt to always run all of these on every connection, and having a single "Init SQL" makes things simpler. Let's deal with explicit transactions next. The default transaction mode is DEFERRED, meaning that it depends on the next statement what type of transaction is started (if a SELECT statement comes first, a read transaction is started, with the possibility of upgrading it to a write transaction depending on the statements that follow). With our setup, there should never be multiple writers concurrently, so making all transactions write transactions from the get-go (with BEGIN IMMEDIATE) can only help us show if this invariant is violated. Putting this all together, this is the code we arrive at: ```go package main import ( "bytes" "context" "crypto/sha1" "database/sql" "database/sql/driver" "encoding/hex" "fmt" "time" "modernc.org/sqlite" ) type DB struct { dbPath string Read *sql.DB Write *sql.DB } const initSQL = ` PRAGMA journal_mode = WAL; PRAGMA synchronous = NORMAL; PRAGMA temp_store = MEMORY; PRAGMA mmap_size = 30000000000; -- 30GB PRAGMA busy_timeout = 5000; PRAGMA automatic_index = true; PRAGMA foreign_keys = ON; PRAGMA analysis_limit = 1000; PRAGMA trusted_schema = OFF; ` func New(ctx context.Context, dbPath string) (db *DB, err error) { db = &DB{ dbPath: dbPath, } // make sure every opened connection has the settings we expect sqlite.RegisterConnectionHook(func(conn sqlite.ExecQuerierContext, _ string) error { _, err = conn.ExecContext(ctx, initSQL, nil) return err }) write, err := sql.Open("sqlite", "file:"+db.dbPath) if err != nil { return } // only a single writer ever, no concurrency write.SetMaxOpenConns(1) write.SetConnMaxIdleTime(time.Minute) if err != nil { return } read, err := sql.Open("sqlite", "file:"+db.dbPath) if err != nil { return } // readers can be concurrent read.SetMaxOpenConns(100) read.SetConnMaxIdleTime(time.Minute) db.Read = read db.Write = write return } func (db *DB) InTransaction(ctx context.Context, tx func(context.Context, *sql.Conn) error) (err error) { // cancel anything that takes longer than 5 seconds var cancel func() ctx, cancel = context.WithTimeout(ctx, time.Duration(5*time.Second)) defer cancel() // separate conn thats just for us // so that the transactions queries are executed together conn, err := db.Write.Conn(ctx) if err != nil { return } defer conn.Close() _, err = conn.ExecContext(ctx, "BEGIN IMMEDIATE TRANSACTION") if err != nil { return } defer func() { if r := recover(); r != nil || err != nil { if _, err = conn.ExecContext(ctx, "ROLLBACK"); err != nil { return } } }() err = tx(ctx, conn) if err != nil { return } _, err = conn.ExecContext(ctx, "COMMIT") return } ``` Just as a small added bonus, it's also very easy to register our own go functions that we can then call from SQL. In this example, we define the sha1 function, receiving and returning a single argument, and always returning the same output for the same input (thus the deterministic). For more information, [see the docs](https://www.sqlite.org/appfunc.html) ```go func registerFuncs() { // lets add our own sha1 hash function usable from SQL sqlite.MustRegisterDeterministicScalarFunction( "sha1", 1, func(ctx *sqlite.FunctionContext, args []driver.Value) (driver.Value, error) { var arg *bytes.Buffer switch argTyped := args[0].(type) { case string: arg = bytes.NewBuffer([]byte(argTyped)) case []byte: arg = bytes.NewBuffer(argTyped) default: return nil, fmt.Errorf("expected argument to be a string, got: %T", argTyped) } h := sha1.Sum(arg.Bytes()) return hex.EncodeToString(h), nil }, ) } ``` In conclusion, this solution works perfectly well for most of the usage scenarios out there where immense scaling is neither expected nor needed. There are faster ways to use SQLite with Go (see the [excellent cvilsmeier benchmarks](https://github.com/cvilsmeier/go-sqlite-bench)), but its still plenty-fast enough, and avoiding CGo makes it very convenient also. [1]: This is another thing that database/sql.DB being a connection pool makes harder.

We make available to the public the supply chain, inventory and production details about our products. This post contains information from a specific product production run.  More information about our product production logs is here. Inventory and Production Notes This is the production log for eggs from our chickens. We categorize our egg production based on

Motherhood marriage insanity friendship family

This article describes the ideas behind the system I designed and built myself. It started out as a "I wonder what it would sound like if..." exercise, and turned into the system I would choose to listen to even if I had the chance to swap it for commercial gear. It includes the first speakers I ever…

sand·wich gen·er·a·tion; noun: a generation of people, typically in their thirties or forties, responsible for bringing up their own children and for the care of their aging parents.

sand·wich gen·er·a·tion; noun: a generation of people, typically in their thirties or forties, responsible for bringing up their own children and for the care of their aging parents.

This rare album contains 75 minutes of unreleased pure DAT soundboard recordings. All tracks are originals that were to be included on the next Grateful Dead CD prior to the passing of Jerry Garcia. This is a really nice collection of post-Built To Last songs, taken from live recordings between 1993 and 1995 just before…

A router jig that will help you flatten your workbench as well as other wide and unwieldy boards.

The Split-Top Roubo Workbench is a modern twist on the classic Roubo design, inspired by Plate 11 of Andre Roubo's L'Art du Menuisier. This is a time-tested design will serve as a lifetime workbench and will never need to be replaced. Whether you're into hand tools, power tools, or both, this bench will serve all of your work-holding needs. This course is for the workbench only and does not include the cabinet. You can purchase that course here. The bench measures 87" Long x 24" Deep x 35" High. Get 5% off this course today by becoming a Guild+ Subscriber! Find out more!

Open-source firmware for Ingenic SoC IP cameras.

Tiger Style is a coding philosophy focused on safety, performance, and developer experience.