[cobalt-users] Re: Unable to add/remove domains - RaQ4

[Bruce Timberlake <bruce@xxxxxxxxxx>]

> problem solved: can add/delete domains again (yay)
> problem not solved: ghost listing in GUI ...
>
> Does any kind soul have a pointer to fixing the GUI listing to remove 
> the gremlin or ghost domain that still appears in the list?
>
> I'll try rebuilding the slocate.db again, but any additional help would 
> be appreciated. Thanks folks!

slocate.db has nothing to do with the domains, etc on the system for the 
UI. It just maintains a location listing of *every* file on the system, 
allowing you to quickly determine where something is.

The UI on the RaQ 4 is generated from the PostgreSQL database. If the 
directories for the "gremlin" site don't exist anymore (check 
/home/sites and /usr/local/majordomo), then there's just a "stuck" entry 
in the database.

To connect to the db manually and remove the site, do:

shell in as root

cat /etc/cobalt/.meta.id  (password for admin user)

psql -U admin cobalt
(paste in password from above when prompted)

select * from vsite where fqdn='www.example.com';
(confirm the entry is there, and that there's only one)

delete * from vsite where fqdn='www.example.com';
(MAKE SURE you put the qualifying "where..." piece in or else you will 
delete *every* site in the database!)

\q (to exit psql)