이 문서는 Crowd user와 Group 정보를 이미 존재하는 Crowd에 머지하는 방법을 정리한다.
MySQL의 경우 default는 파일 출력을 허용하지 않으므로, file 저장이 가능하도록 설정변경 필요
[mysqld] secure-file-priv = "" |
User 목록 내보내기
SELECT 'Username', 'First Name', 'Last Name', 'Email Address', 'Password' UNION ( SELECT u.user_name, u.first_name, u.last_name, u.email_address, u.credential AS password FROM cwd_user u WHERE u.directory_id = 851969 ORDER BY 2 ASC, 1 ASC INTO OUTFILE '/tmp/users-almdemo.csv' FIELDS TERMINATED BY ',' ENCLOSED BY '"' LINES TERMINATED BY '\n' ); |
Group membership 내보내기
SELECT 'Username', 'Groupname' UNION ( SELECT u.user_name, g.group_name FROM cwd_user u JOIN cwd_directory d ON u.directory_id = d.id JOIN cwd_membership m ON u.id = m.child_id JOIN cwd_group g ON g.id = m.parent_id WHERE u.directory_id = 851969 ORDER BY 2 ASC, 1 ASC INTO OUTFILE '/tmp/memberships.csv' FIELDS TERMINATED BY ',' ENCLOSED BY '"' LINES TERMINATED BY '\n'); |
Crowd의 관리자 기능을 이용해 user와 membership 정보 import