Get all Root-Category-IDs of all stores

SheldonNo Comments

This snippet gives you all entity_id’s of all Root-IDs of the Magento instance: /** * @return array Root-IDs of all stores */ public function getAllRootIds(){# $aRootIds = array(); $aRootIds[Mage_Catalog_Model_Category::TREE_ROOT_ID] = Mage_Catalog_Model_Category::TREE_ROOT_ID; $aAllStores = Mage::app()->getStores(); foreach ($aAllStores as $iID => $store){ $rootID = $store->getRootCategoryId(); $aRootIds[$rootID]=$rootID; } return array_keys($aRootIds); }  

Error cause by DEFINER in MySQL-dumps

SheldonNo Comments

When importing MySQL- dumps of a Magento database sometimes you get an error message like that (although you can connect to the database via shell f.e.): ERROR 1044 (42000) at line 592: Access denied for user ‘sheldon’@’localhost’ to database ‘magento’ In these cases you’ ll recognize that the user, who tries to connect, is wrong […]

Reset Icons And Logos After Upgrade

SheldonNo Comments

All images are laying in the root folder of dokuwiki. So you can do $> cp -f favicon.ico lib/tpl/dokuwiki/images/favicon.ico $> cp -f logo.png lib/tpl/dokuwiki/images/logo.png $> cp -f apple_icon.png lib/tpl/dokuwiki/images/apple-touch-icon.png $> touch conf/local.php $> rm -rf data/cache/* from within the root. The $> touch conf/local.php resets the update hints (yellow boxes). Or just use this bash script: […]

Default password Bananian Linux

SheldonNo Comments

The default credentials for Bananian Linux are: User: root Password: pi You should change the default password on first startup via: $> passwd root  

Raspbian default user password (for pi) on Raspberry Pi

SheldonNo Comments

The default password for the default user pi on a Raspbian operating system is raspberry. You should change it to a secure password on first connect via ssh. Therefore you can use: $> sudo passwd pi  

Extract single file or folder

Sheldon1 Comment

You know the problem when trying to get just one file or folder out of your GIT repository? For example if you had a repository for all your Magento modules you’ve written, you might  want to extract only one of them to a new project. Sure  you can use subtree but sometimes you only want to get […]

MySQL root-user and password under Plesk Parallels

SheldonNo Comments

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: $> mysql -uadmin […]

Plesk Parallels add authorized keys authentication

SheldonNo Comments

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: $> ssh-copy-id -i .ssh/deploy_rsa.pub user@ask-sheldon.com Thats why you have to do this: Edit ssh deamon configuration: $> sudo nano /etc/ssh/sshd_config Add the following line: AuthorizedKeysFile […]

Install attribute in entity main table

SheldonNo Comments

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: <?xml version=”1.0″?> […]