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: 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 »
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.
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 »
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 – 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 »
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 »
Please note – this is absolutely not a complete guide about all MySQL commands usage – but just examples of the most commonly used ones. mysql> at the begin of the line means it’s executed from the MySQL console. Symbols # or $ means it’s executed from the Linux shell. UPD 03.03.2019 This post… Read More »