Author: Konkretor

scaleway rclone s3 example

/ Konkretor / Leave a comment

If you are searching for an alternative for Backblaze Backup. You can try rclone with s3 storage from Scaleway.

In these Blogpost you can find out how to install and configure it. But how to use it? I have some example for you.

https://www.scaleway.com/en/docs/tutorials/encrypt-s3-data-rclone/

https://www.scaleway.com/en/docs/storage/object/api-cli/installing-rclone/

Thats for a Windows machine, on Linux only other path K:test = /home/ubuntu/myfiles

rclone sync --progress K:\test Scaleway:allmybackup

If you want to store your data directly in to the GLACIER storage you can use

rclone sync --progress --s3-storage-class=GLACIER K:\test Scaleway:allmybackup

or you can configre rclone directly to use GLACIER directy without define storage class

Simple example if you are using encryption with rclone

rclone sync --progress K:\test crypt:

Now we have more options for bandwith usage

Attention rclone is using Megabyte not Megabit 1M are 8Mbit

rclone sync --progress --log-file=rclone_log.txt --bwlimit "06:00,2M 23:00,4M" K:\test crypt:

bash script detect os and execute command

/ Konkretor / Leave a comment

If you have multi servers Linux Distribution and should check only Ubuntu. Then you can use this script to select the os and if only match the OS then execute the command. 

##!/bin/bash
if [ -e "/etc/issue" ] ;
then
issue=`cat /etc/issue`
set -- $issue
if [ $1 = "Ubuntu" ] ;
then
    nginx -v 2>&1 | grep -o 1.* | cut -c1-6 
fi
fi

apache AH01070: Error parsing script headers

/ Konkretor / Leave a comment

If you are using Magento 2 and you got this 500 error from admin login page. Your Content Security Policy header are too long. Use Nginx or reduce your headers.

Problem is AP_IOBUFSIZE cannot be changed by a conf file it is hardcoded in to the sourcecode. You have only 8192 Bytes and this os offen to low. If you reach this limit your apache will crash and restart. 

AP_IOBUFSIZE 8192


Look at the Bugzilla from Apache Webserver

https://bz.apache.org/bugzilla/show_bug.cgi?id=64919

php oauth curl request engine

/ Konkretor / Leave a comment

How to enable php oauth with curl support.

cd/usr/include&& sudoln-s x86_64-linux-gnu/curl

 apt installphp-dev

 apt-installlibpcre3-dev

 apt installphp7.4-dev

apt remove php-oauth php7.4-oauth

apt autoremove

update-alternatives --setphpize /usr/bin/phpize7.4

update-alternatives --setphpdbg /usr/bin/phpdbg7.4

update-alternatives --setphp-config /usr/bin/php-config7.4

pear config-setphp_ini `php7.4 --ini | grep"Loaded Configuration"| sed-e "s|.*:\s*||"` system

pecl installoauth

pecl uninstall oauth

pecl installoauth

printf"; priority=20\nextension=oauth.so\n"> /etc/php/7.4/mods-available/oauth.ini

The Solr *Optimize Now* Button for Sitecore Use Cases

/ Konkretor / Leave a comment

Sitecore Architecture

If you’ve worked with Sitecore and Solr, you’re no stranger to the Solr Admin UI.  There are great aspects to that UI, and some exciting extension points with Sitecore implications too, but I know one element of that Solr UI that causes some head-scratching . . . the “optimize now” feature:

OptimizeNow.JPG

The inclusion of the badcauses people to think “something is wrong . . . red bad . . . must click now!”

What is this Optimize?

I’m writing this for the benefit of Sitecore developers who may not be coming at this from a deep search background: do not worry if your Solr cores show this badicon encouraging you to optimize now.  Fight that instinct.  For standard Sitecore Solr cores that are frequently updating, such as the sitecore_core_index, sitecore_master_index, sitecore_analytics_index, and — depending on your publishing strategy — sitecore_web_index, one may notice these…

View original post 696 more words

bash script mysql commands

/ Konkretor / Leave a comment

I want to use this script to run with Ansible. My requirements were to read the maximum connections in mysql server. Also I want to write the output from mysql client in to a file.

You can use 

mysql -e "show status like 'max_used_connections';" 

Or you can use

mysql <<EOF
tee /tmp/mysql_max.txt
show variables like 'max_connections';
show status like 'max_used_connections';
EOF


output

Logging to file '/tmp/mysql_max.txt'
Variable_name   Value
max_connections 100
Variable_name   Value
Max_used_connections    10

Found here

https://www.shellhacks.com/mysql-run-query-bash-script-linux-command-line/

https://alvinalexander.com/mysql/how-save-output-mysql-query-file/

the ‘information_schema global_status feature is disabled

/ Konkretor / Leave a comment

If you want to import a MySQL dump in to your MySQL server 5.7 and you got following error

The 'INFORMATION_SCHEMA.SESSION_VARIABLES' feature is disabled; see the documentation for 'show_compatibility_56'

Login in to your mysql root console and send this command to your mysql server

set @@global.show_compatibility_56=ON;

SHOW VARIABLES LIKE '%compatibility%'; 
+-----------------------+-------+ 
| Variable_name         | Value | 
+-----------------------+-------+ 
| show_compatibility_56 | ON    | 
+-----------------------+-------+ 
1 row in set (0.00 sec)