Re: [cobalt-users] Meta-Verify -- Drop Tables

[Duncan Laurie <duncan@xxxxxxxxxxxxxxx>]

On 01/22/2001 at 09:49 AM, Craig Napier wrote:
| Q: Can meta-verify be run in just "verbose" mode without forcing you to make 
| changes if errors are found..?  The script doesn't really document that 
| option... it just says it'll "Verify and repair".. I'd first want to review 
| any suggested changes to my user backend database...

Unfortunately meta-verify doesn't have the greatest documentation.  But
luckily it can do what you are asking...  To check for invalid users and
display their settings as it finds them, prompting you before making any
changes, run "meta-verify -uiv".  Of course if this doesn't find any
invalid users (users that exist in the database but not on the system,
or on the system but not in the database) it will not need to make any
changes so it will not prompt.

If you want to do an exhaustive verification of each valid user, again
prompting before making any changes, run "meta-verify -uav".  The same
can be done for virtual sites by using '-s' instead of '-u' in the
above examples.

| Also, why would the "drop table" flag be included as an option..? Wouldn't 
| that be the *LAST* thing you'd want to do to your back-end database on the 
| RaQ..? If you flagged this option, you'd drop your entire user database off 
| the system, correct..?

In some situations the users or vsite table may become damaged beyond
repair, and meta-verify was originally intended only to recreate the
databases from the system config files.  The drop table option is just
to save the hassle of using 'psql' to drop the offending table if it
cannot be repaired.  (designed to make the tech support job easier)

At any rate if you do drop the table from the database, just run
meta-verify again and it will be recreated from the current system
state for you.

  -duncan