Category Archives: MySQL/MariaDB

MySQL и MariaDB – are an open source relational database management systems.

AWS RDS: “SQLSTATE[22001] – Data too long for column” using MariaDB 10.2

8 August 2019
 

 We have a PHP-application with the AWS RDS MariaDB as a backend. On the previously used 10.0 version all was good, but right after we upgraded to the MariaDB 10.2 – got errors during tests: PDOException: SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column ‘name’ at row 1 in /data/projects/projectname/vendor/yiisoft/yii2/db/Command.php:1290 The first… Read More »

AWS: MariaDB RDS – kill: You are not owner of thread

14 May 2019
 

 We have AWS RDS with MariaDB. The error below and its solution aren’t specific to AWS RDS and MariaDB. The next error appears during attempt to kill() a thread in MySQL: The solution is to use the mysql.rds_kill() procedure instead: Execute it: For Azure MySQL, there is a similar procedure mysql.az_kill(). Done.

TestRail: reset admin password

13 May 2019
 

 We have a TestRail installation but suddenly lose its Admin user password. The Reset Password says that “Email sending failed” although email was configured and users are able to get emails from the server. Also, the log /var/www/testrail.example.com/logs/log-2019-05-13.php didn’t says anything so will reset password in another way – by update this TestRail MySQL database… Read More »

MySQL/MariaDB: like Petya ransomware for MySQL and ‘root’@’%’ access

3 April 2019
 

  This story happened on 10/06/2017, adding this post in English now. The original post (Rus) was written almost right after the well-known Not a Petya attack in Ukraine – that’s why it’s used in the title. I had a new project assigned to me. When I started its existing setup investigation – was just… Read More »

TestRail: QA Test Case Management installation on Linux

22 March 2019
 

 TestRail – Test Case Management Software for QA and Development Teams. Well – that’s all needed as a description) Below – its installation on Debian Linux with NGINX, Let’s Encrypt, PHP-FPM, MariaDB, and Exim. Project’s homepage – www.gurock.com/testrail Installation official documentation – here>>>. Setup will be on an AWS EC2. LEMP and SSL Login to… Read More »

NextCloud: installing server on Debian behind NGINX with PHP-FPM and client on Arch Linux

17 March 2019
 

 After the news that Dropbox adds a new limitation for users by the three devices only – I’m finally ready to install my own NextCloud to store and synchronize data. The sad thing is not exactly the three devices limit (and it will be applied for a new users only – old user who already… Read More »