Difference between revisions of "SAC:Admin and Troubleshooting"

From OSGeo
Jump to navigation Jump to search
m (add new section for mysql)
Line 20: Line 20:
  
 
== MySQL Cleanup for Drupal ==
 
== MySQL Cleanup for Drupal ==
 +
If a report in drupal starts saying a table is crashed and needs repair, log into mysql and run the following, for example for the cache table:
 +
REPAIR TABLE cache QUICK;

Revision as of 09:38, 29 March 2007

Troubleshooting

NFS Mount Missing

For some reason, the /home mount on the various servers is often lost.

To fix...

LDAP Server Down

The LDAP server runs on .220, and if it needs to be restarted it can be done as root with the command:

/opt/fedora/slapd-ldapt/start-slapd

Peer1 LDAP Server Hanging

If there is a power outage like there was on 2-20-07, slapd's database will need to be recovered.

sudo /usr/sbin/slapd_db_recover -h /var/lib/ldap/osgeo2

MySQL Cleanup for Drupal

If a report in drupal starts saying a table is crashed and needs repair, log into mysql and run the following, for example for the cache table:

REPAIR TABLE cache QUICK;