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

["Phil Beynon" <phil@xxxxxxxxxxxxxxxxxxxxxxxxx>]

> > 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)

Doesn't PostgreSQL have a LIMIT 1 like MySql as protection against that sort
of thing?

Phil


** http://www.diygear.com THE Online DIY Toolstore For DIY & Business
** Infolink Electronic Systems Ltd. http://www.infolinkelectronics.co.uk
** Professional Web Design & Cobalt Hosting Solutions
** Sun Cobalt iForce Reseller - Canon Silver Reseller
** Contact: Sales@xxxxxxxxxxxxxxxxxxxxxxxxx
** Tel / Fax 0121 458 4894 (office) 0121 441 3558 (home)