MySQL root-user and password under Plesk Parallels

Plesk changes the root user name to admin and stores the corresponding password in /etc/psa/.psa.shadow. The value inside this file looks really strange – like an encrypted key or hash. But that’s really your password for the admin user! If you’re lazy – like me – you can login as admin like that:


Plesk Parallels add authorized keys authentication

In Parallels Plesk 9.x, 10.x and 11.x for Linux (in this case CentOS 6.6) there is a bug. You can not authenticate via ssh key or add one f.e. with:

Thats why you have to do this: Edit ssh deamon configuration:

Add the following line:

Restart the SSH Deamon:

Now the […]

Install attribute in entity main table

Sometimes it is useful to add some fields to the attribute main table (f.e.: IDs from external systems like a middleware or a PIM). In the following example you can see how to add ID-fields to the category entity. Therefore I created a setupscript as an instance of Mage_Catalog_Model_Resource_Setup. Setup-model declaration in config.xml:

Setup-script: […]

String helper class

Export image file statistics to csv

To get a CSV export of all image files with name, last access date, last change date, last modification date and filesize in byte in a folder including all subfolders, you can use this linux command:

or separated by tabs:

Further readings: