[freeside] sql-mail table

[Mitchell Clay]

I'm just kinda wondering, for example...which file to
edit?
Does this help any?

testmail=> \d 
          List of relations
 Schema |  Name   | Type  |  Owner   
--------+---------+-------+----------
 public | aliases | table | freeside
 public | domains | table | freeside
 public | users   | table | freeside
(3 rows)


             Table "public.domains"
  Column  |         Type          | Modifiers 
----------+-----------------------+-----------
 d_id     | integer               | not null
 d_domain | character varying(95) | 
 d_ip     | character varying(16) | 
Indexes: domains_pkey primary key btree (d_id),
         ddomain btree (d_domain)

             Table "public.aliases"
  Column  |         Type          | Modifiers 
----------+-----------------------+-----------
 a_alias  | character varying(63) | 
 a_domain | character varying(95) | 
 a_userid | integer               | not null
Indexes: aalias btree (a_alias),
         adomain btree (a_domain)

             Table "public.users"
         Column         |          Type          |
Modifiers 
------------------------+------------------------+-----------
 u_type                 | integer                | 
 u_id                   | integer                | not
null
 u_alias                | character varying(255) | 
 u_domain               | character varying(95)  | 
 u_antispamindex        | integer                | 
 u_name                 | character varying(127) | 
 u_mailbox              | character varying(127) | 
 u_accountdisabled      | character varying(1)   | 
 u_accountvalid         | character varying(1)   | 
 u_accountvalidtill     | date                   | 
 u_allowremote          | character varying(1)   | 
 u_validityreport       | character varying(1)   | 
 u_validityreportdays   | integer                | 
 u_ntpassword           | character varying(1)   | 
 u_imap                 | character varying(1)   | 
 u_imapmailbox          | character varying(63)  | 
 u_dontshowmessagessize | integer                | 
 u_dontshowmessages     | character varying(1)   | 
 u_anypassword          | character varying(1)   | 
 u_etrn                 | character varying(1)   | 
 u_deleteexpire         | character varying(1)   | 
 u_null                 | character varying(1)   | 
 u_password             | character varying(63)  | 
 u_ntpasswordvalue      | character varying(63)  | 
 u_domainadminindex     | integer                | 
 u_domainadmin          | character varying(1)   | 
 u_mailboxpath          | character varying(127) | 
 u_admin                | character varying(1)   | 
 u_maxbox               | character varying(1)   | 
 u_maxboxsize           | integer                | 
 u_forcefrom            | character varying(1)   | 
 u_respond              | character varying(1)   | 
 u_onlylocaldomain      | integer                | 
 u_useremoteaddress     | character varying(1)   | 
 u_forwardto            | character varying(255) | 
 u_respondwith          | character varying(127) | 
 u_mailin               | character varying(127) | 
 u_mailout              | character varying(127) | 
 u_validreport          | character varying(127) | 
 u_deleteolder          | character varying(1)   | 
 u_deleteolderdays      | integer                | 
 u_forwardolder         | character varying(1)   | 
 u_forwardolderdays     | integer                | 
 u_forcefromaddress     | character varying(127) | 
 u_forwardolderto       | character varying(127) | 
 u_remoteaddress        | character varying(127) | 
 u_nomaillist           | character varying(1)   | 
 u_numbersendlimit      | integer                | 
 u_megabytesendlimit    | integer                | 
Indexes: users_pkey primary key btree (u_id),
         ualiasdomain btree (u_alias, u_domain),
         udomain btree (u_domain),
         udomaintype btree (u_domain, u_type),
         umailboxpassword btree (u_mailbox,
u_password),
         umailboxtype btree (u_mailbox, u_type),
         unametype btree (u_name, u_type)




--- Kristian Hoffmann <khoff at pc-intouch.com> wrote:
> In the export options, you have to specify the name
> of the table that you
> want to export each service type to.  I don't know
> what your mail database
> schema looks like, so I can't help much more than
> that.
> 
> Kristian Hoffmann
> PC-InTOUCH/FireToWire System Administrator
> khoff at pc-intouch.com
> ---
> 
> On Mon, 5 Apr 2004, Mitchell Clay wrote:
> 
> > I was wondering if anyone could help me with a
> problem
> > I am having.
> >
> > I am using Freeside 1.4.1, perl 5.6.1, postgresql
> > 7.3.4, and apache 1.3.29 on FreeBSD 5.2.1.
> >
> > Freeside seems to be working great so far, even
> with
> > our radius server.  My problem however is getting
> > email to work.  We are using Merak/Icewarp
> > (www.icewarp.com) using postgresql as database.
> > I have added a sqlmail export to the local
> postgresql
> > database with the connection string:
> >
> > DBI:pg;host=auth.westweb1.net;database=testmail
> >
> > Now when I try to provision services I get the
> > following:
> >
> > Errors Output
> > Export table not defined for svcdb: svc_acct at
> >
>
/usr/local/lib/perl5/site_perl/5.6.1//FS/part_export/sqlmail.pm
> > line 18. ,
> > /usr/local/lib/perl5/site_perl/5.6.1/Apache/ASP.pm
> > line 1518
> > Debug Output
> > Export table not defined for svcdb: svc_acct at
> >
>
/usr/local/lib/perl5/site_perl/5.6.1//FS/part_export/sqlmail.pm
> > line 18. ,
> > /usr/local/lib/perl5/site_perl/5.6.1/Apache/ASP.pm
> > line 1518
> >
> >
> > Any ideas?
> > TIA,
> > Mitchell


__________________________________
Do you Yahoo!?
Yahoo! Small Business $15K Web Design Giveaway 
http://promotions.yahoo.com/design_giveaway/