Page History

...

1. Add your Grid Identity to your local PO or PA database. Example shows adding '"/O=caBIG/OU=caGrid/OU=Training/OU=Dorian/CN=coppagridtest' Grid Identity" Grid Identity (an example stage grid identity would be "/O=caBIG/OU=caGrid/OU=Stage LOA1/OU=Dorian/CN=coppagridtest"). Replace "coppagridtest" with your own account as needed (or just use the coppagridtest user).

   Code Block
   title Connect to PO DB
   psql -U poadmin -d podb password: poadmin123

   Code Block
   title Connect to PA DB
   psql -U paadmin -d ctods_pa password: paadmin123

   Code Block
   sql sql
   --adding /O=caBIG/OU=caGrid/OU=Training/OU=Dorian/CN=coppagridtest as a grid client test user account INSERT INTO CSM_USER (LOGIN_NAME, FIRST_NAME, LAST_NAME, UPDATE_DATE) VALUES ('/O=caBIG/OU=caGrid/OU=Training/OU=Dorian/CN=coppagridtest', 'Test', 'GridClientUser', now()); INSERT INTO CSM_USER_GROUP (USER_ID, GROUP_ID) VALUES ((select user_id from csm_user where login_name = '/O=caBIG/OU=caGrid/OU=Training/OU=Dorian/CN=coppagridtest'), (select group_id from csm_group where group_name = 'gridClient'));