Re: [cobalt-developers] Connecting to the cobalt postrgres database...

["Paul Adamson" <mail@xxxxxxxxxxxxxxxxx>]

This diagram you wanted is called the database schema.
you can use a program called pg_dump (sorta) like this

pg_dump -s cobalt -f cobalt.shema -u

on a good day with a lot of luck and a tail wind, this should ask you for
the postgres username and password (_not_ the same as root user/pass) and
then dump the schema for database cobalt to a file called cobalt.schema
(pick whatever you want.)

If you're any good with sql then you will be able to interpret this to tell
you the database structure. otherwise, import it as sql into access to give
you lots of pretty pictures to look at.

Fcuk it, i'll just paste the version i have here. :P

this basicaly tells you the tables,  and column names and types. hope it
helps:

CREATE TABLE "vsite" (
 "emaildomain" text,
 "name" text,
 "suspend" text,
 "userlist_sort" text,
 "type" text,
 "userlist_range" int4,
 "user_quota" int4,
 "fqdn" text,
 "quota" int4,
 "ftp" text,
 "user_fpx" text,
 "fpx" text,
 "user_apop" text,
 "ssi" text,
 "apop" text,
 "ssl" text,
 "cgi" text,
 "gid" int4,
 "ftpquota" int4,
 "ipaddr" text,
 "webdomain" text,
 "user_shell" text,
 "bwlimit" text,
 "shell" text,
 "maxusers" int4,
 "domain" text,
 "user_namegen" int4,
 "ftpusers" int4,
 "hostname" text,
 "modify" datetime);
CREATE TABLE "bw" (
 "bwlimit" text,
 "name" text,
 "method" text,
 "direction" text,
 "protocol" text,
 "type" text,
 "port" text,
 "modify" datetime);
CREATE TABLE "cpu" (
 "type" text,
 "name" text,
 "load1" float8,
 "load5" float8,
 "load15" float8,
 "uptime" int8,
 "procs" int8,
 "model_name" text,
 "mhz" int4,
 "temperature" int4,
 "modify" datetime);
CREATE TABLE "defcon" (
 "type" text,
 "name" text,
 "special" text,
 "defcon" int4,
 "modify" datetime);
CREATE TABLE "memory" (
 "type" text,
 "name" text,
 "total" int8,
 "free" int8,
 "used" int8,
 "percent" int4,
 "modify" datetime);
CREATE TABLE "network" (
 "type" text,
 "name" text,
 "in_bytes" int8,
 "in_packets" int8,
 "out_bytes" int8,
 "out_packets" int8,
 "errors" int8,
 "collisions" int8,
 "modify" datetime);
CREATE TABLE "service" (
 "type" text,
 "name" text,
 "state" text,
 "modify" datetime);
CREATE TABLE "users" (
 "apop" text,
 "name" text,
 "aliases" text,
 "altname" text,
 "uid" int4,
 "suspend" text,
 "type" text,
 "fullname" text,
 "forward" text,
 "vacation" text,
 "shell" text,
 "admin" text,
 "quota" int4,
 "vsite" text,
 "vacationmsg" text,
 "fpx" text,
 "modify" datetime);
CREATE TABLE "quota" (
 "type" text,
 "name" text,
 "total" float8,
 "free" float8,
 "used" float8,
 "percent" float8,
 "modify" datetime);

----- Original Message -----
From: "Matthew Nuzum" <cobalt@xxxxxxxxxxxxx>
To: <cobalt-developers@xxxxxxxxxxxxxxx>
Sent: Wednesday, November 28, 2001 5:48 PM
Subject: RE: [cobalt-developers] Connecting to the cobalt postrgres
database...


> > I've been digging through the Cobalt modules trying to find how the
> admin
> > interface connects to the Cobalt database, and it's proving rather
> > frustrating.
> >
> > Any one know the default postgresql username/password used by cobalt?
> is
> > there any documentation on the database anywhere such as a diagram of
> > tables, fields and relationships?
>
>
> Hey!  The easy way to find your connect info for postgres is to look in
> the file: /etc/cobalt/.meta.id
> You must be root to see it though.
>
> Matthew Nuzum
> 5`//337-31337
>
> followers.net
>
> _______________________________________________
> cobalt-developers mailing list
> cobalt-developers@xxxxxxxxxxxxxxx
> http://list.cobalt.com/mailman/listinfo/cobalt-developers
>