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

["Rob Johnson" <dillybar1@xxxxxxxxxxxxxx>]

hey thanks! that really helps


----- Original Message -----
From: "Paul Adamson" <mail@xxxxxxxxxxxxxxxxx>
To: <cobalt-developers@xxxxxxxxxxxxxxx>
Sent: Thursday, November 29, 2001 8:33 PM
Subject: Re: [cobalt-developers] Connecting to the cobalt postrgres
database...


> 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
> >
>
> _______________________________________________
> cobalt-developers mailing list
> cobalt-developers@xxxxxxxxxxxxxxx
> http://list.cobalt.com/mailman/listinfo/cobalt-developers