SAP – SD Enterprise structure

Sales and Distribution covers the entire order-to-cash process chain from customer inquiry and sales order to the products delivery to customer’s destination through billing and payment collection. The components of logistics execution are integrated and include picking, packaging and shipping.
Continue reading

LINUX – Move MySQL data directory

LinuxIn newer versions of Linux it’s not easily possible to just move the MySQL data directory to another location and modify my.cnf or create a symbolic link. There is a secutity/protection “daemon” running in background checking which locations is some process trying to access. If it’s allowed, then access is granted, otherwise the process is unable to read/write the required data. This guardian is called “APPARMOR” Continue reading

GIT – Change author or committer

If you want to change author’s and/or committer’s name and/or email in given GIT revisions, you can use the following script:

git filter-branch -f --commit-filter '
  if [ "$GIT_AUTHOR_NAME" = "Old Author" ];
  then
    export GIT_AUTHOR_NAME    = "New Author";
    export GIT_AUTHOR_EMAIL   = "new_author@example.com";
    export GIT_COMMITTER_NAME  = "New Author";
    export GIT_COMMITTER_EMAIL = "new_author@example.com";
  fi;
  git commit-tree "$@"'

Now update the remote (bare) repository

git push --force --tags origin 'refs/heads/*'

Secured FTP – ProFTP + TLS in Ubuntu

FTP is considered as very insecure protocol because all data transferred using this protocol is passed between client and server in clear text and can be hacked by someone listening on your line. But you can easily encrypt the whole communication by enabling/forcing TLS and make FTP much more secure. This article explains how to set up ProFTPd with TLS on an Ubuntu server. Continue reading

LFTP – Backup website over FTP

LinuxI was facing task how to schedule an automatic backup/mirror of a website which allows connecting over FTP. PHP command exec was forbidden by the provider so it was not possible to run OS commands. PHP script execution time was set to quite short time so it was neither possible to zip using PHP functions and send the whole backup file somewhere easily. Continue reading

ABAP – Export Transport request to local file system

SAPAll development or customizing in SAP is written into a transport request unless it is a local object not intended to be transported ($TMP package). Sometimes it might be useful to backup your development but in SAP this task is quite complicated to export all programs, classes, standard texts, …

Therefore there is an option to export the whole development encapsulated on a transport request level. And that’s what this article is about – exporting development encapsulated in a transport request to local file system. Continue reading