How to start second MySQL instance on boot on Ubuntu 20.04?

I have a second MySQL 8 instance running on Ubunut 20.04, started by this command:

mysqld_safe --defaults-file=/home/user/mysqld_replica.cnf & 

The config file contains all needed settings like port, socket and data dir. That works well but I can not figure out how to start the second instance on boot.

What would be the recommended way to start both instances at boot time?

The SQL Server replication subscriber cannot start: ‘No agent status information is available.’

I am trying to run merge replication of the database between two servers (both are SQL Server version 15). Both servers are in the domain. On both I am logged using this domain account (all server roles enabled like sysadmin, serveradmin, setupadmin).

I created publication using wizard and selected following options:

  • ‘Merge publication’
  • ‘SQL Server 2008 or later’
  • Then I selected one table as object to publish
  • No filters
  • I unchecked ‘Schedule the Snapshot Agent to run at the following times’
  • Snapshot Agent: ‘Run under the following windows account’ – I entered my domain account + password
  • Connect to the publisher: ‘By impersonating the process account’

Publication has been created successfully.

I created subscription using wizard and selected following options:

  • Publication dialog – I have selected publication which I have just created
  • ‘Run each agent at its Subscriber (pull subscription)’
  • I have selected the database on the destination server (I created it before running subscription wizard)
  • Merge agent security dialog: again I have entered my domain credentials, Connect to Distributor: ‘by impersonating…’, Connect to Subscriber: ‘by impersonating…’
  • Synchronization schedule dialog: ‘Subscriber’, ‘Run continuously’
  • Initialize Synchronizations dialog: ‘Initialize’, ‘At first synchronization’
  • Subscription Type: ‘Client’, ‘First to Publisher wins’

Subscription has been created successfully

But when I right click on subscriber and select ‘View synchronization status’ the message appears:

'No agent status information is available.' 

and when I try to click ‘Start’ button then the error message appears:

'The agent could not be started. SQLServerAgent Error: Request to run job DEV-SQL1\DB1-ag_publ5-ag_publication_5_2-DEV-SQL2\DB1-ag_subs5- 0 (from User sa) refused because the job is already running from a request by User sa. Changed database context to 'ag_subs5'. (Microsoft SQL Server, Error: 22022) ' 

I created snapshots on the publisher site, stop the related job on the subscriber site and then pressed ‘Start’ button in ‘View synchronization status’ dialog, but the result is always as described above.

Any suggestion how can I start my subscriber are kindly appreciated.

Was youtube-nocookie.com always serving cookies or did it start recently? Is it a scam?

I’ve been using Youtube embeds in enhanced privacy mode by

chang[ing] the domain for the embed URL in your HTML from https://www.youtube.com to https://www.youtube-nocookie.com

I remember checking via DevTools (Application/Storage tab) that no cookie was actually set.

A customer just notified me that they did find cookies set by the domain .youtube-nocookie.com — weirdly, something about "consent pending", which does not change when I click play, as other sources state.
They have also alerted me to some shenanigans in Local Storage, namely an item with the key yt-remote-device-id, which has a UUID and an expiration date 10 years in the future.

I have always suspected that Enhanced Privacy Mode is somewhat of a exaggeration, but this seems to defeat the purpose almost entirely. And it makes youtube-nocookie practically useless w.r.t. a less painful GDPR-compliant user experience.

Is this a recent change? Is there any documentation or changelog on that?

Forcing a fresh start with Postgres after updating major version

On my Manjaro machine, I updated packages, and Postgres got updated to version 13.2-1.

Before the update, I had some databases on the previous version. Now Postgres won’t start because it recognises that the existing databases are from the old version. When I attempt to start Postgres, I get:

~|⇒ sudo systemctl status postgresql ● postgresql.service - PostgreSQL database server      Loaded: loaded (/usr/lib/systemd/system/postgresql.service; disabled; vendor preset: disabled)      Active: failed (Result: exit-code) since Fri 2021-03-12 21:30:02 GMT; 2min 53s ago     Process: 3173 ExecStartPre=/usr/bin/postgresql-check-db-dir $  {PGROOT}/data (code=exited, status=1/FAILURE)  Mar 12 21:30:01 xps systemd[1]: Starting PostgreSQL database server... Mar 12 21:30:02 xps postgres[3173]: An old version of the database format was found. Mar 12 21:30:02 xps postgres[3173]: See https://wiki.archlinux.org/index.php/PostgreSQL#Upgrading_PostgreSQL Mar 12 21:30:02 xps systemd[1]: postgresql.service: Control process exited, code=exited, status=1/FAILURE Mar 12 21:30:02 xps systemd[1]: postgresql.service: Failed with result 'exit-code'. Mar 12 21:30:02 xps systemd[1]: Failed to start PostgreSQL database server. 

Those databases weren’t important. They were for my personal pet projects and I’m happy to delete them.

How do I do that? Postgres won’t start, so I can’t delete them through psql. How can I force the latest version to start afresh? Ignore or delete the existing databases.

OpenXR device not present in Start or Awake methods in Unity C# script

I’m developing a VR game using OpenXR in Unity (specifically developing on a Valve Index). When I try to access the input devices through the InputDevices.GetDevices() function, I get 0 devices back when I call this function from my script’s Awake() or Start() methods. But when I call the same function from my script’s Update() method, I see all the devices (e.g. head set, left controller, right controller).

Why can’t I see the devices in the Awake() or Start() methods?

So what do I do when a player gets bad luck at the start of the session?

As an introduction, I am a novice- ah hem, trainee GM. A pro D&D/Dungeon World player has been helping me, but I ran into a problem while running Dungeon World.

One of my players (A female Salamander Immolator) was at camp with a vampire attacking and almost all of the roles she made had a consequence with it, and I ended up having to have them rescued. It has also happened to me as a player and I am wondering how I could make the first encounter easy even when the player has bad luck?

Drop servicing business, 2 buyers + 1 seller(s) (mid-sized comp.) are ready to start, $3/Prospect

* An old business listing is being reused, old comments may be irrelevant.

$ 3 Cost Per Prospect (Upwork Virtual Assistants, real humans, no ads/bots)

I am selling this site to cash out before doing it again.

Client information is confidential please dm/comment for that
Tools used/taught after/during the sale: Discord, G Maps, Upwork (for Discord VAs + telemarketing VAs)

We do not have a website, only a LinkedIn. For this dire reason, before the sale, I can…

.. get you…

Drop servicing business, 2 buyers + 1 seller(s) (mid-sized comp.) are ready to start, $ 3/Prospect

*Cheapest reseller hosting – start $3 /M – Free Domain, Auto SSL – Hostpoco.com!!!

Are you interested to Start your Own Hosting Business or you have a large number of sites under your control? Our cheapest reseller hosting is the perfect hosting solution for you. we provide hosting to designers, small to medium-sized companies, or the large scale personal user with an emphasis on providing superior customer support and building relationships. We pride ourselves on our reliability and trust securing strong business relationships with our customers.

We allow unlimited accounts and domains for your reseller accounts. Your reseller accounts inherit multiple activities like CPanel account creation, adding/editing packages, suspension/unsuspension of accounts, managing SSL’s, limiting resources, assigning IP’s, etc. We offer both Linux and Windows reseller hosting to expand your selling options. You also get everything you need to run your web hosting business including a free domain, cPanel, WHMCS, and website transfer.

Why choose Hostpoco for Reseller hosting?
~ Unlimited Accounts/Domains
~ Linux or Windows
~ DDOS Protection
~ Reliability and Performance
~ 99.99% Uptime
~ FREE Auto SSL Included
~ FREE Private Nameservers
~ Daily Backups
~ Softaculous
~ Free Domain/cPanel
~ Unlimited Email Hosting
~ Unlimited Addon Domains
~ Free Setup/Migration/Transfer
~ Experienced Reseller Web Hosting Provider

Linux Reseller Web Hosting Packages:

*Reseller Startup:$3 /Monthly
~ 10 cPanel Accounts
~ 25GB Web Space
~ 250GB Bandwidth
~ Tier 3 Technical Support

*Reseller Pro:$6 /Monthly
~ 15 cPanel Accounts
~ 50GB Web Space
~ 500GB Bandwidth
~ Tier 3 Technical Support

*Reseller Premium:$9 /Monthly
~ 25 cPanel Accounts
~ 75GB Web Space
~ 750GB Bandwidth
~ Tier 4 Technical Support

*Reseller Elite:$12 /Monthly
~ 60 cPanel Accounts
~ Unlimited Web Space
~ Unlimited Bandwidth
~ Tier 4 Technical Support

For more about the cheapest reseller hosting plan please check our Website
www.hostpoco.com

If you have any questions, please do not hesitate to contact us.
Sales@hostpoco.com

Can I start to develop my website on WordPress.org before purchasing my web hosting?

I am currently in the process of starting a blog, but as of right now I only want to start designing the site, creating the layout before I go live. Is there a way that I could do that on WordPress.org, and then place my domain name to my web hoster? I only ask because I don’t want to purchase everything at once and waste the money that I spent on web hosting while my site wasn’t active yet due to the design process