Posts

Showing posts from April, 2016

OpenAM

ssoadm/openam/bin/ssoadm get-attr-defs  -u amadmin -f passwd -s iPlanetAMPlatformService -t global -a "iplanet-am-platform-cookie-domains" 1.  At times when you create a new module instance under a newly created realm , it does not show up the in list of module instances.  But if I delete it using ssoadm and recreate it , it shows up.

mySQL

1. Concatenating the fields SELECT CONCAT('http://www.abc.com?parentCategoryId=' ,CATEGORY_ID,'&categoryId=', RELATED_CATEGORY_ID ) FROM RELATED_CATEGORY WHERE CATEGORY_ID IN (SELECT CATEGORY_ID FROM CATALOG_TO_CATEGORY WHERE CATALOG_ID = 1 AND ACTIVE_FLAG='Y') 2.  ERROR 1148 (42000): The used command is not allowed with this MySQL version .  LOAD DATA LOCAL INFILE 'users.txt' INTO TABLE  users FIELDS TERMINATED BY  ',' ENCLOSED BY '"'  LINES TERMINATED BY '\n' (userid,fistname); Throws an error something like " ERROR 1148 (42000): The used command is not allowed with this MySQL version ."  For me the mysql server was an RDS and I was trying to load data from another ec2 instance.  When I google around I got suggestions to restart mysqld as "mysql -u user -p --local-infile menagerie" , which was not possible as it was an RDS service. To get it working I had to add following in /etc/mysq