hey thanks! that really helps
----- Original Message ----- From: "Paul Adamson" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> 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" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > 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 > > [EMAIL PROTECTED] > > http://list.cobalt.com/mailman/listinfo/cobalt-developers > > > > _______________________________________________ > cobalt-developers mailing list > [EMAIL PROTECTED] > http://list.cobalt.com/mailman/listinfo/cobalt-developers _______________________________________________ cobalt-developers mailing list [EMAIL PROTECTED] http://list.cobalt.com/mailman/listinfo/cobalt-developers
