Technical

Technical To Do

LDAP

To create LDAP users, login to phpLDAPadmin with DN cn=admin,dc=artefactual,dc=com

• Double check user id attribute is not 1000
• Check username and home directory match.

SQL Backup

1. ssh to amos.artefactual.com (use -X to forward X clients)
2. Become `administrator` user: `sudo -u administrator bash` (backups are done as the administrator user, which is a local vs. an LDAP user)
3. Try ssh to the server being backed up: `ssh icaatom@ica-atom.org`
   1. If the server requires a password, append the administrator user's ssh public key to the server's `authorized_keys` file: `ssh icaatom@ica-atom.org cat \>\> .ssh/authorized_keys < /home/administrator/.ssh/id_dsa.pub`
4. Change directory to `/home/administrator/src`: `cd /home/administrator/src`
5. Edit the `site5-backup` script: `gvim site5-backup` or `emacs site5-backup`
6. Add new line with:

• • Server username
  • Server address
  • Database username
  • Database password
  • Database name
  • Destination file