java.sql.SQLException: Incorrect string value: ‘\xF0\x9F\x96\xA4\xE2\x9C…’ for column

When your application tries to store 4-byte Unicode characters in a MySQL database you may get the error rmessage java.sql.SQLException: Incorrect string value: ‘\x..\x..\x..\x..\x..\x…’ for column   To store 4-byte Unicode characters in MySQL you need a modern version of the database engine, version 5.5 or later, set the column collation to COLLATE utf8mb4_unicode_ci in the database, …

The security database on the server does not have a computer account for this workstation trust relationship

Time to time Windows servers may lose the trust of the domain. When you try to log in with your domain credentials you get the dreaded message: The security database on the server does not have a computer account for this workstation trust relationship This can have many causes, and the most effective way to fix …

SQL Server AWS RDS instance ALARM FreeableMemory <=... MB

The SQL database servers use the available memory for caching to speed up the database operation. If we do not restrict the SQL database server memory usage, the operating system will not have enough memory to run. This setting is also necessary for an AWS RDS instance, otherwise, you will get the alert ALARM FreeableMemory <=… MB In AWS …

Terraform provider.aws: no suitable version installed

The new versions of Terraform do not contain all plugins after the application installation. When you try to access a provider the first time, Terraform may not be able to communicate with it. * provider.aws: no suitable version installed version requirements: “(any version)” versions installed: none To download the necessary plugins, initialize the Terraform script …

Display all teams you belong to in GitHub

To get the information on all teams you are part of in Github Open a Terminal window Execute this command with your Personal Access Token curl -H “Authorization: token YOUR_PERSONAL_ACCESS_TOKEN” https://api.github.com/user/teams The returned JSON will display all information on the teams you belong to. To generate a personal access token See Create a Personal Access Token …

Chef NoMethodError, undefined method

When you try to bootstrap a node to a Chef server, you may get the error message Compiling Cookbooks… ============================================================== Recipe Compile Error in c:/chef/cache/cookbooks/…/attributes/default.rb ============================================================== NoMethodError ————- undefined method `…=’ for #<Chef::Node::VividMash:0x0000000004ca3268> … Relevant File Content: >> default. … In my case, the cookbook compiler could not interpret the dot notation in the recipes. …

Restore Windows Server 2012 R2 from backup

Windows Server contains the Windows Backup functionality. It can create full backups of your server that contain all volumes. With the bare metal recovery, you are able to fully restore the server even if the hard disks fail, after a virus attack, or security breach. Depending on the size of the server drives and the backup media, …

Tomcat web server installation

Tomcat is one of the most popular free web servers. Tomcat runs on the Linux, Macintosh, and Windows operating systems. To install Tomcat Install the Java Runtime Environment (JRE) Download the Java JRE from http://www.oracle.com/technetwork/java/javase/downloads/index.html Install the Java JRE On Windows Execute the downloaded .exe file Create an environment variable to point to the installed Java If you installed …

Enable Single Sign-On (SSO) in TeamCity

Enable Single Sign-On (SSO) in TeamCity TeamCity can use the Windows Active Directory to authenticate users. To configure TeamCity to automatically log in users who are already logged into the Windows domain enable the Single Sign-On (SSO) functionality. In the upper right corner of the TeamCity web interface select Administration, On the left side in the Server …