1 package FS::part_export;
4 use vars qw( @ISA @EXPORT_OK %exports );
7 use FS::Record qw( qsearch qsearchs dbh );
9 use FS::part_export_option;
12 @ISA = qw(FS::Record);
13 @EXPORT_OK = qw(export_info);
17 FS::part_export - Object methods for part_export records
23 $record = new FS::part_export \%hash;
24 $record = new FS::part_export { 'column' => 'value' };
26 #($new_record, $options) = $template_recored->clone( $svcpart );
28 $error = $record->insert( { 'option' => 'value' } );
29 $error = $record->insert( \%options );
31 $error = $new_record->replace($old_record);
33 $error = $record->delete;
35 $error = $record->check;
39 An FS::part_export object represents an export of Freeside data to an external
40 provisioning system. FS::part_export inherits from FS::Record. The following
41 fields are currently supported:
45 =item exportnum - primary key
47 =item machine - Machine name
49 =item exporttype - Export type
51 =item nodomain - blank or "Y" : usernames are exported to this service with no domain
61 Creates a new export. To add the export to the database, see L<"insert">.
63 Note that this stores the hash reference, not a distinct copy of the hash it
64 points to. You can ask the object for a copy with the I<hash> method.
68 # the new method can be inherited from FS::Record, if a table method is defined
70 sub table { 'part_export'; }
76 #An alternate constructor. Creates a new export by duplicating an existing
77 #export. The given svcpart is assigned to the new export.
79 #Returns a list consisting of the new export object and a hashref of options.
85 # my $class = ref($self);
86 # my %hash = $self->hash;
87 # $hash{'exportnum'} = '';
88 # $hash{'svcpart'} = shift;
89 # ( $class->new( \%hash ),
90 # { map { $_->optionname => $_->optionvalue }
91 # qsearch('part_export_option', { 'exportnum' => $self->exportnum } )
98 Adds this record to the database. If there is an error, returns the error,
99 otherwise returns false.
101 If a hash reference of options is supplied, part_export_option records are
102 created (see L<FS::part_export_option>).
106 #false laziness w/queue.pm
110 local $SIG{HUP} = 'IGNORE';
111 local $SIG{INT} = 'IGNORE';
112 local $SIG{QUIT} = 'IGNORE';
113 local $SIG{TERM} = 'IGNORE';
114 local $SIG{TSTP} = 'IGNORE';
115 local $SIG{PIPE} = 'IGNORE';
117 my $oldAutoCommit = $FS::UID::AutoCommit;
118 local $FS::UID::AutoCommit = 0;
121 my $error = $self->SUPER::insert;
123 $dbh->rollback if $oldAutoCommit;
127 foreach my $optionname ( keys %{$options} ) {
128 my $part_export_option = new FS::part_export_option ( {
129 'exportnum' => $self->exportnum,
130 'optionname' => $optionname,
131 'optionvalue' => $options->{$optionname},
133 $error = $part_export_option->insert;
135 $dbh->rollback if $oldAutoCommit;
140 $dbh->commit or die $dbh->errstr if $oldAutoCommit;
148 Delete this record from the database.
152 #foreign keys would make this much less tedious... grr dumb mysql
155 local $SIG{HUP} = 'IGNORE';
156 local $SIG{INT} = 'IGNORE';
157 local $SIG{QUIT} = 'IGNORE';
158 local $SIG{TERM} = 'IGNORE';
159 local $SIG{TSTP} = 'IGNORE';
160 local $SIG{PIPE} = 'IGNORE';
162 my $oldAutoCommit = $FS::UID::AutoCommit;
163 local $FS::UID::AutoCommit = 0;
166 my $error = $self->SUPER::delete;
168 $dbh->rollback if $oldAutoCommit;
172 foreach my $part_export_option ( $self->part_export_option ) {
173 my $error = $part_export_option->delete;
175 $dbh->rollback if $oldAutoCommit;
180 foreach my $export_svc ( $self->export_svc ) {
181 my $error = $export_svc->delete;
183 $dbh->rollback if $oldAutoCommit;
188 $dbh->commit or die $dbh->errstr if $oldAutoCommit;
194 =item replace OLD_RECORD HASHREF
196 Replaces the OLD_RECORD with this one in the database. If there is an error,
197 returns the error, otherwise returns false.
199 If a hash reference of options is supplied, part_export_option records are
200 created or modified (see L<FS::part_export_option>).
208 local $SIG{HUP} = 'IGNORE';
209 local $SIG{INT} = 'IGNORE';
210 local $SIG{QUIT} = 'IGNORE';
211 local $SIG{TERM} = 'IGNORE';
212 local $SIG{TSTP} = 'IGNORE';
213 local $SIG{PIPE} = 'IGNORE';
215 my $oldAutoCommit = $FS::UID::AutoCommit;
216 local $FS::UID::AutoCommit = 0;
219 my $error = $self->SUPER::replace($old);
221 $dbh->rollback if $oldAutoCommit;
225 foreach my $optionname ( keys %{$options} ) {
226 my $old = qsearchs( 'part_export_option', {
227 'exportnum' => $self->exportnum,
228 'optionname' => $optionname,
230 my $new = new FS::part_export_option ( {
231 'exportnum' => $self->exportnum,
232 'optionname' => $optionname,
233 'optionvalue' => $options->{$optionname},
235 $new->optionnum($old->optionnum) if $old;
236 my $error = $old ? $new->replace($old) : $new->insert;
238 $dbh->rollback if $oldAutoCommit;
243 #remove extraneous old options
245 grep { !exists $options->{$_->optionname} } $old->part_export_option
247 my $error = $opt->delete;
249 $dbh->rollback if $oldAutoCommit;
254 $dbh->commit or die $dbh->errstr if $oldAutoCommit;
262 Checks all fields to make sure this is a valid export. If there is
263 an error, returns the error, otherwise returns false. Called by the insert
271 $self->ut_numbern('exportnum')
272 || $self->ut_domain('machine')
273 || $self->ut_alpha('exporttype')
275 return $error if $error;
277 $self->machine =~ /^([\w\-\.]*)$/
278 or return "Illegal machine: ". $self->machine;
281 $self->nodomain =~ /^(Y?)$/ or return "Illegal nodomain: ". $self->nodomain;
284 $self->deprecated(1); #BLAH
293 #Returns the service definition (see L<FS::part_svc>) for this export.
299 # qsearchs('part_svc', { svcpart => $self->svcpart } );
304 croak "FS::part_export::part_svc deprecated";
305 #confess "FS::part_export::part_svc deprecated";
310 Returns a list of associated FS::svc_* records.
316 map { $_->svc_x } $self->cust_svc;
321 Returns a list of associated FS::cust_svc records.
327 map { qsearch('cust_svc', { 'svcpart' => $_->svcpart } ) }
328 grep { qsearch('cust_svc', { 'svcpart' => $_->svcpart } ) }
334 Returns a list of associated FS::export_svc records.
340 qsearch('export_svc', { 'exportnum' => $self->exportnum } );
343 =item part_export_option
345 Returns all options as FS::part_export_option objects (see
346 L<FS::part_export_option>).
350 sub part_export_option {
352 qsearch('part_export_option', { 'exportnum' => $self->exportnum } );
357 Returns a list of option names and values suitable for assigning to a hash.
363 map { $_->optionname => $_->optionvalue } $self->part_export_option;
366 =item option OPTIONNAME
368 Returns the option value for the given name, or the empty string.
374 my $part_export_option =
375 qsearchs('part_export_option', {
376 exportnum => $self->exportnum,
379 $part_export_option ? $part_export_option->optionvalue : '';
384 Reblesses the object into the FS::part_export::EXPORTTYPE class, where
385 EXPORTTYPE is the object's I<exporttype> field. There should be better docs
386 on how to create new exports (and they should live in their own files and be
387 autoloaded-on-demand), but until then, see L</NEW EXPORT CLASSES>.
393 my $exporttype = $self->exporttype;
394 my $class = ref($self). "::$exporttype";
397 bless($self, $class);
400 =item export_insert SVC_OBJECT
407 $self->_export_insert(@_);
413 # my $method = $AUTOLOAD;
414 # #$method =~ s/::(\w+)$/::_$1/; #infinite loop prevention
415 # $method =~ s/::(\w+)$/_$1/; #infinite loop prevention
416 # $self->$method(@_);
419 =item export_replace NEW OLD
426 $self->_export_replace(@_);
436 $self->_export_delete(@_);
446 $self->_export_suspend(@_);
449 =item export_unsuspend
453 sub export_unsuspend {
456 $self->_export_unsuspend(@_);
459 #fallbacks providing useful error messages intead of infinite loops
462 return "_export_insert: unknown export type ". $self->exporttype;
465 sub _export_replace {
467 return "_export_replace: unknown export type ". $self->exporttype;
472 return "_export_delete: unknown export type ". $self->exporttype;
475 #fallbacks providing null operations
477 sub _export_suspend {
479 #warn "warning: _export_suspened unimplemented for". ref($self);
483 sub _export_unsuspend {
485 #warn "warning: _export_unsuspend unimplemented for ". ref($self);
495 =item export_info [ SVCDB ]
497 Returns a hash reference of the exports for the given I<svcdb>, or if no
498 I<svcdb> is specified, for all exports. The keys of the hash are
499 I<exporttype>s and the values are again hash references containing information
502 'desc' => 'Description',
504 'option' => { label=>'Option Label' },
505 'option2' => { label=>'Another label' },
507 'nodomain' => 'Y', #or ''
508 'notes' => 'Additional notes',
514 return $exports{$_[0]} if @_;
515 #{ map { %{$exports{$_}} } keys %exports };
516 my $r = { map { %{$exports{$_}} } keys %exports };
519 #=item exporttype2svcdb EXPORTTYPE
521 #Returns the applicable I<svcdb> for an I<exporttype>.
525 #sub exporttype2svcdb {
526 # my $exporttype = $_[0];
527 # foreach my $svcdb ( keys %exports ) {
528 # return $svcdb if grep { $exporttype eq $_ } keys %{$exports{$svcdb}};
533 tie my %sysvshell_options, 'Tie::IxHash',
534 'crypt' => { label=>'Password encryption',
535 type=>'select', options=>[qw(crypt md5)],
540 tie my %bsdshell_options, 'Tie::IxHash',
541 'crypt' => { label=>'Password encryption',
542 type=>'select', options=>[qw(crypt md5)],
547 tie my %shellcommands_options, 'Tie::IxHash',
548 #'machine' => { label=>'Remote machine' },
549 'user' => { label=>'Remote username', default=>'root' },
550 'useradd' => { label=>'Insert command',
551 default=>'useradd -c $finger -d $dir -m -s $shell -u $uid -p $crypt_password $username'
552 #default=>'cp -pr /etc/skel $dir; chown -R $uid.$gid $dir'
554 'useradd_stdin' => { label=>'Insert command STDIN',
558 'userdel' => { label=>'Delete command',
559 default=>'userdel -r $username',
560 #default=>'rm -rf $dir',
562 'userdel_stdin' => { label=>'Delete command STDIN',
566 'usermod' => { label=>'Modify command',
567 default=>'usermod -c $new_finger -d $new_dir -m -l $new_username -s $new_shell -u $new_uid -p $new_crypt_password $old_username',
568 #default=>'[ -d $old_dir ] && mv $old_dir $new_dir || ( '.
569 # 'chmod u+t $old_dir; mkdir $new_dir; cd $old_dir; '.
570 # 'find . -depth -print | cpio -pdm $new_dir; '.
571 # 'chmod u-t $new_dir; chown -R $uid.$gid $new_dir; '.
575 'usermod_stdin' => { label=>'Modify command STDIN',
579 'usermod_pwonly' => { label=>'Disallow username changes',
582 'suspend' => { label=>'Suspension command',
585 'suspend_stdin' => { label=>'Suspension command STDIN',
588 'unsuspend' => { label=>'Unsuspension command',
591 'unsuspend_stdin' => { label=>'Unsuspension command STDIN',
596 tie my %shellcommands_withdomain_options, 'Tie::IxHash',
597 'user' => { label=>'Remote username', default=>'root' },
598 'useradd' => { label=>'Insert command',
601 'useradd_stdin' => { label=>'Insert command STDIN',
603 #default=>"$_password\n$_password\n",
605 'userdel' => { label=>'Delete command',
608 'userdel_stdin' => { label=>'Delete command STDIN',
612 'usermod' => { label=>'Modify command',
615 'usermod_stdin' => { label=>'Modify command STDIN',
617 #default=>"$_password\n$_password\n",
619 'usermod_pwonly' => { label=>'Disallow username changes',
622 'suspend' => { label=>'Suspension command',
625 'suspend_stdin' => { label=>'Suspension command STDIN',
628 'unsuspend' => { label=>'Unsuspension command',
631 'unsuspend_stdin' => { label=>'Unsuspension command STDIN',
636 tie my %www_shellcommands_options, 'Tie::IxHash',
637 'user' => { label=>'Remote username', default=>'root' },
638 'useradd' => { label=>'Insert command',
639 default=>'mkdir /var/www/$zone; chown $username /var/www/$zone; ln -s /var/www/$zone $homedir/$zone',
641 'userdel' => { label=>'Delete command',
642 default=>'[ -n "$zone" ] && rm -rf /var/www/$zone; rm $homedir/$zone',
644 'usermod' => { label=>'Modify command',
645 default=>'[ -n "$old_zone" ] && rm $old_homedir/$old_zone; [ "$old_zone" != "$new_zone" -a -n "$new_zone" ] && mv /var/www/$old_zone /var/www/$new_zone; [ "$old_username" != "$new_username" ] && chown -R $new_username /var/www/$new_zone; ln -s /var/www/$new_zone $new_homedir/$new_zone',
649 tie my %apache_options, 'Tie::IxHash',
650 'user' => { label=>'Remote username', default=>'root' },
651 'httpd_conf' => { label=>'httpd.conf snippet location',
652 default=>'/etc/apache/httpd-freeside.conf', },
657 <VirtualHost $domain> #generic
658 #<VirtualHost ip.addr> #preferred, http://httpd.apache.org/docs/dns-caveats.html
659 DocumentRoot /var/www/$zone
663 #LargeFileLimit 4096 12288
670 tie my %router_options, 'Tie::IxHash',
674 options => [qw(telnet ssh)],
675 default => 'telnet'},
676 'insert' => {label=>'Insert command', default=>'' },
677 'delete' => {label=>'Delete command', default=>'' },
678 'replace' => {label=>'Replace command', default=>'' },
679 'Timeout' => {label=>'Time to wait for prompt', default=>'20' },
680 'Prompt' => {label=>'Prompt string', default=>'#' }
683 tie my %domain_shellcommands_options, 'Tie::IxHash',
684 'user' => { label=>'Remote username', default=>'root' },
685 'useradd' => { label=>'Insert command',
688 'userdel' => { label=>'Delete command',
691 'usermod' => { label=>'Modify command',
696 tie my %textradius_options, 'Tie::IxHash',
697 'user' => { label=>'Remote username', default=>'root' },
698 'users' => { label=>'users file location', default=>'/etc/raddb/users' },
701 tie my %sqlradius_options, 'Tie::IxHash',
702 'datasrc' => { label=>'DBI data source ' },
703 'username' => { label=>'Database username' },
704 'password' => { label=>'Database password' },
707 tie my %sqlradius_withdomain_options, 'Tie::IxHash',
708 'datasrc' => { label=>'DBI data source ' },
709 'username' => { label=>'Database username' },
710 'password' => { label=>'Database password' },
713 tie my %cyrus_options, 'Tie::IxHash',
714 'server' => { label=>'IMAP server' },
715 'username' => { label=>'Admin username' },
716 'password' => { label=>'Admin password' },
719 tie my %cp_options, 'Tie::IxHash',
720 'port' => { label=>'Port number' },
721 'username' => { label=>'Username' },
722 'password' => { label=>'Password' },
723 'domain' => { label=>'Domain' },
724 'workgroup' => { label=>'Default Workgroup' },
727 tie my %infostreet_options, 'Tie::IxHash',
728 'url' => { label=>'XML-RPC Access URL', },
729 'login' => { label=>'InfoStreet login', },
730 'password' => { label=>'InfoStreet password', },
731 'groupID' => { label=>'InfoStreet groupID', },
734 tie my %vpopmail_options, 'Tie::IxHash',
735 #'machine' => { label=>'vpopmail machine', },
736 'dir' => { label=>'directory', }, # ?more info? default?
737 'uid' => { label=>'vpopmail uid' },
738 'gid' => { label=>'vpopmail gid' },
739 'restart' => { label=> 'vpopmail restart command',
740 default=> 'cd /home/vpopmail/domains; for domain in *; do /home/vpopmail/bin/vmkpasswd $domain; done; /var/qmail/bin/qmail-newu; killall -HUP qmail-send',
744 tie my %communigate_pro_options, 'Tie::IxHash',
745 'port' => { label=>'Port number', default=>'106', },
746 'login' => { label=>'The administrator account name. The name can contain a domain part.', },
747 'password' => { label=>'The administrator account password.', },
748 'accountType' => { label=>'Type for newly-created accounts',
750 options=>[qw( MultiMailbox TextMailbox MailDirMailbox )],
751 default=>'MultiMailbox',
753 'externalFlag' => { label=> 'Create accounts with an external (visible for legacy mailers) INBOX.',
756 'AccessModes' => { label=>'Access modes',
757 default=>'Mail POP IMAP PWD WebMail WebSite',
761 tie my %bind_options, 'Tie::IxHash',
762 #'machine' => { label=>'named machine' },
763 'named_conf' => { label => 'named.conf location',
764 default=> '/etc/bind/named.conf' },
765 'zonepath' => { label => 'path to zone files',
766 default=> '/etc/bind/', },
767 'bind_release' => { label => 'ISC BIND Release',
769 options => [qw(BIND8 BIND9)],
770 default => 'BIND8' },
771 'bind9_minttl' => { label => 'The minttl required by bind9 and RFC1035.',
775 tie my %bind_slave_options, 'Tie::IxHash',
776 #'machine' => { label=> 'Slave machine' },
777 'master' => { label=> 'Master IP address(s) (semicolon-separated)' },
778 'named_conf' => { label => 'named.conf location',
779 default => '/etc/bind/named.conf' },
780 'bind_release' => { label => 'ISC BIND Release',
782 options => [qw(BIND8 BIND9)],
783 default => 'BIND8' },
784 'bind9_minttl' => { label => 'The minttl required by bind9 and RFC1035.',
788 tie my %http_options, 'Tie::IxHash',
789 'method' => { label =>'Method',
791 #options =>[qw(POST GET)],
792 options =>[qw(POST)],
794 'url' => { label => 'URL', default => 'http://', },
796 label => 'Insert data',
798 default => join("\n",
799 'DomainName $svc_x->domain',
800 'Email ( grep { $_ ne "POST" } $svc_x->cust_svc->cust_pkg->cust_main->invoicing_list)[0]',
802 'reseller $svc_x->cust_svc->cust_pkg->part_pkg->pkg =~ /reseller/i',
806 label => 'Delete data',
808 default => join("\n",
812 label => 'Replace data',
814 default => join("\n",
819 tie my %sqlmail_options, 'Tie::IxHash',
820 'datasrc' => { label => 'DBI data source' },
821 'username' => { label => 'Database username' },
822 'password' => { label => 'Database password' },
824 label => 'Server type',
826 options => [qw(dovecot_plain dovecot_crypt dovecot_digest_md5 courier_plain
828 default => ['dovecot_plain'], },
829 'svc_acct_table' => { label => 'User Table', default => 'user_acct' },
830 'svc_forward_table' => { label => 'Forward Table', default => 'forward' },
831 'svc_domain_table' => { label => 'Domain Table', default => 'domain' },
832 'svc_acct_fields' => { label => 'svc_acct Export Fields',
833 default => 'username _password domsvc svcnum' },
834 'svc_forward_fields' => { label => 'svc_forward Export Fields',
835 default => 'domain svcnum catchall' },
836 'svc_domain_fields' => { label => 'svc_domain Export Fields',
837 default => 'srcsvc dstsvc dst' },
838 'resolve_dstsvc' => { label => q{Resolve svc_forward.dstsvc to an email address and store it in dst. (Doesn't require that you also export dstsvc.)},
839 type => 'checkbox' },
843 tie my %ldap_options, 'Tie::IxHash',
844 'dn' => { label=>'Root DN' },
845 'password' => { label=>'Root DN password' },
846 'userdn' => { label=>'User DN' },
847 'attributes' => { label=>'Attributes',
851 'mail $username\@$domain',
861 'mailmessagestore $dir',
862 'userpassword $crypt_password',
864 'answer $sec_phrase',
865 'objectclass top,person,inetOrgPerson',
868 'radius' => { label=>'Export RADIUS attributes', type=>'checkbox', },
871 tie my %forward_shellcommands_options, 'Tie::IxHash',
872 'user' => { label=>'Remote username', default=>'root' },
873 'useradd' => { label=>'Insert command',
876 'userdel' => { label=>'Delete command',
879 'usermod' => { label=>'Modify command',
884 #export names cannot have dashes...
889 'Batch export of /etc/passwd and /etc/shadow files (Linux/SysV).',
890 'options' => \%sysvshell_options,
892 'notes' => 'MD5 crypt requires installation of <a href="http://search.cpan.org/search?dist=Crypt-PasswdMD5">Crypt::PasswdMD5</a> from CPAN. Run bin/sysvshell.export to export the files.',
896 'Batch export of /etc/passwd and /etc/master.passwd files (BSD).',
897 'options' => \%bsdshell_options,
899 'notes' => 'MD5 crypt requires installation of <a href="http://search.cpan.org/search?dist=Crypt-PasswdMD5">Crypt::PasswdMD5</a> from CPAN. Run bin/bsdshell.export to export the files.',
903 # 'Batch export of /etc/global/passwd and /etc/global/shadow for NIS ',
907 'desc' => 'Real-time export to a text /etc/raddb/users file (Livingston, Cistron)',
908 'options' => \%textradius_options,
909 'notes' => 'This will edit a text RADIUS users file in place on a remote server. Requires installation of <a href="http://search.cpan.org/search?dist=RADIUS-UserFile">RADIUS::UserFile</a> from CPAN. If using RADIUS::UserFile 1.01, make sure to apply <a href="http://rt.cpan.org/NoAuth/Bug.html?id=1210">this patch</a>. Also make sure <a href="http://rsync.samba.org/">rsync</a> is installed on the remote machine, and <a href="../docs/ssh.html">SSH is setup for unattended operation</a>.',
913 'desc' => 'Real-time export via remote SSH (i.e. useradd, userdel, etc.)',
914 'options' => \%shellcommands_options,
916 'notes' => 'Run remote commands via SSH. Usernames are considered unique (also see shellcommands_withdomain). You probably want this if the commands you are running will not accept a domain as a parameter. You will need to <a href="../docs/ssh.html">setup SSH for unattended operation</a>.<BR><BR>Use these buttons for some useful presets:<UL><LI><INPUT TYPE="button" VALUE="Linux/NetBSD/OpenBSD" onClick=\'this.form.useradd.value = "useradd -c $finger -d $dir -m -s $shell -u $uid -p $crypt_password $username"; this.form.useradd_stdin.value = ""; this.form.userdel.value = "userdel -r $username"; this.form.userdel_stdin.value=""; this.form.usermod.value = "usermod -c $new_finger -d $new_dir -m -l $new_username -s $new_shell -u $new_uid -p $new_crypt_password $old_username"; this.form.usermod_stdin.value = "";\'><LI><INPUT TYPE="button" VALUE="FreeBSD" onClick=\'this.form.useradd.value = "pw useradd $username -d $dir -m -s $shell -u $uid -g $gid -c $finger -h 0"; this.form.useradd_stdin.value = "$_password\n"; this.form.userdel.value = "pw userdel $username -r"; this.form.userdel_stdin.value=""; this.form.usermod.value = "pw usermod $old_username -d $new_dir -m -l $new_username -s $new_shell -u $new_uid -c $new_finger -h 0"; this.form.usermod_stdin.value = "$new__password\n";\'><LI><INPUT TYPE="button" VALUE="Just maintain directories (use with sysvshell or bsdshell)" onClick=\'this.form.useradd.value = "cp -pr /etc/skel $dir; chown -R $uid.$gid $dir"; this.form.useradd_stdin.value = ""; this.form.usermod.value = "[ -d $old_dir ] && mv $old_dir $new_dir || ( chmod u+t $old_dir; mkdir $new_dir; cd $old_dir; find . -depth -print | cpio -pdm $new_dir; chmod u-t $new_dir; chown -R $new_uid.$new_gid $new_dir; rm -rf $old_dir )"; this.form.usermod_stdin.value = ""; this.form.userdel.value = "rm -rf $dir"; this.form.userdel_stdin.value="";\'></UL>The following variables are available for interpolation (prefixed with new_ or old_ for replace operations): <UL><LI><code>$username</code><LI><code>$_password</code><LI><code>$quoted_password</code> - unencrypted password quoted for the shell<LI><code>$crypt_password</code> - encrypted password<LI><code>$uid</code><LI><code>$gid</code><LI><code>$finger</code> - GECOS, already quoted for the shell (do not add additional quotes)<LI><code>$dir</code> - home directory<LI><code>$shell</code><LI><code>$quota</code><LI>All other fields in <a href="../docs/schema.html#svc_acct">svc_acct</a> are also available.</UL>',
919 'shellcommands_withdomain' => {
920 'desc' => 'Real-time export via remote SSH (vpopmail, etc.).',
921 'options' => \%shellcommands_withdomain_options,
922 'notes' => 'Run remote commands via SSH. username@domain (rather than just usernames) are considered unique (also see shellcommands). You probably want this if the commands you are running will accept a domain as a parameter, and will allow the same username with different domains. You will need to <a href="../docs/ssh.html">setup SSH for unattended operation</a>.<BR><BR>Use these buttons for some useful presets:<UL><LI><INPUT TYPE="button" VALUE="vpopmail" onClick=\'this.form.useradd.value = "/home/vpopmail/bin/vadduser $username\\\@$domain $quoted_password"; this.form.useradd_stdin.value = ""; this.form.userdel.value = "/home/vpopmail/bin/vdeluser $username\\\@$domain"; this.form.userdel_stdin.value=""; this.form.usermod.value = "/home/vpopmail/bin/vpasswd $new_username\\\@$new_domain $new_quoted_password"; this.form.usermod_stdin.value = ""; this.form.usermod_pwonly.checked = true;\'></UL>The following variables are available for interpolation (prefixed with <code>new_</code> or <code>old_</code> for replace operations): <UL><LI><code>$username</code><LI><code>$domain</code><LI><code>$_password</code><LI><code>$quoted_password</code> - unencrypted password quoted for the shell<LI><code>$crypt_password</code> - encrypted password<LI><code>$uid</code><LI><code>$gid</code><LI><code>$finger</code> - GECOS, already quoted for the shell (do not add additional quotes)<LI><code>$dir</code> - home directory<LI><code>$shell</code><LI><code>$quota</code><LI>All other fields in <a href="../docs/schema.html#svc_acct">svc_acct</a> are also available.</UL>',
926 'desc' => 'Real-time export to LDAP',
927 'options' => \%ldap_options,
928 'notes' => 'Real-time export to arbitrary LDAP attributes. Requires installation of <a href="http://search.cpan.org/search?dist=Net-LDAP">Net::LDAP</a> from CPAN.',
932 'desc' => 'Real-time export to SQL-backed RADIUS (FreeRADIUS, ICRADIUS, Radiator)',
933 'options' => \%sqlradius_options,
935 'notes' => 'Real-time export of radcheck, radreply and usergroup tables to any SQL database for <a href="http://www.freeradius.org/">FreeRADIUS</a>, <a href="http://radius.innercite.com/">ICRADIUS</a> or <a href="http://www.open.com.au/radiator/">Radiator</a>. This export does not export RADIUS realms (see also sqlradius_withdomain). An existing RADIUS database will be updated in realtime, but you can use <a href="../docs/man/bin/freeside-sqlradius-reset">freeside-sqlradius-reset</a> to delete the entire RADIUS database and repopulate the tables from the Freeside database. See the <a href="http://search.cpan.org/doc/TIMB/DBI/DBI.pm#connect">DBI documentation</a> and the <a href="http://search.cpan.org/search?mode=module&query=DBD%3A%3A">documentation for your DBD</a> for the exact syntax of a DBI data source.<ul><li>Using FreeRADIUS 0.9.0 with the PostgreSQL backend, the db_postgresql.sql schema and postgresql.conf queries contain incompatible changes. This is fixed in 0.9.1. Only new installs with 0.9.0 and PostgreSQL are affected - upgrades and other database backends and versions are unaffected.<li>Using ICRADIUS, add a dummy "op" column to your database: <blockquote><code>ALTER TABLE radcheck ADD COLUMN op VARCHAR(2) NOT NULL DEFAULT \'==\'<br>ALTER TABLE radreply ADD COLUMN op VARCHAR(2) NOT NULL DEFAULT \'==\'<br>ALTER TABLE radgroupcheck ADD COLUMN op VARCHAR(2) NOT NULL DEFAULT \'==\'<br>ALTER TABLE radgroupreply ADD COLUMN op VARCHAR(2) NOT NULL DEFAULT \'==\'</code></blockquote><li>Using Radiator, see the <a href="http://www.open.com.au/radiator/faq.html#38">Radiator FAQ</a> for configuration information.</ul>',
938 'sqlradius_withdomain' => {
939 'desc' => 'Real-time export to SQL-backed RADIUS (FreeRADIUS, ICRADIUS, Radiator) with realms',
940 'options' => \%sqlradius_withdomain_options,
942 'notes' => 'Real-time export of radcheck, radreply and usergroup tables to any SQL database for <a href="http://www.freeradius.org/">FreeRADIUS</a>, <a href="http://radius.innercite.com/">ICRADIUS</a> or <a href="http://www.open.com.au/radiator/">Radiator</a>. This export exports domains to RADIUS realms (see also sqlradius). An existing RADIUS database will be updated in realtime, but you can use <a href="../docs/man/bin/freeside-sqlradius-reset">freeside-sqlradius-reset</a> to delete the entire RADIUS database and repopulate the tables from the Freeside database. See the <a href="http://search.cpan.org/doc/TIMB/DBI/DBI.pm#connect">DBI documentation</a> and the <a href="http://search.cpan.org/search?mode=module&query=DBD%3A%3A">documentation for your DBD</a> for the exact syntax of a DBI data source.<ul><li>Using FreeRADIUS 0.9.0 with the PostgreSQL backend, the db_postgresql.sql schema and postgresql.conf queries contain incompatible changes. This is fixed in 0.9.1. Only new installs with 0.9.0 and PostgreSQL are affected - upgrades and other database backends and versions are unaffected.<li>Using ICRADIUS, add a dummy "op" column to your database: <blockquote><code>ALTER TABLE radcheck ADD COLUMN op VARCHAR(2) NOT NULL DEFAULT \'==\'<br>ALTER TABLE radreply ADD COLUMN op VARCHAR(2) NOT NULL DEFAULT \'==\'<br>ALTER TABLE radgroupcheck ADD COLUMN op VARCHAR(2) NOT NULL DEFAULT \'==\'<br>ALTER TABLE radgroupreply ADD COLUMN op VARCHAR(2) NOT NULL DEFAULT \'==\'</code></blockquote><li>Using Radiator, see the <a href="http://www.open.com.au/radiator/faq.html#38">Radiator FAQ</a> for configuration information.</ul>',
946 'desc' => 'Real-time export to SQL-backed mail server',
947 'options' => \%sqlmail_options,
949 'notes' => 'Database schema can be made to work with Courier IMAP and Exim. Others could work but are untested. (...extended description from pc-intouch?...)',
953 'desc' => 'Real-time export to Cyrus IMAP server',
954 'options' => \%cyrus_options,
956 'notes' => 'Integration with <a href="http://asg.web.cmu.edu/cyrus/imapd/">Cyrus IMAP Server</a>. Cyrus::IMAP::Admin should be installed locally and the connection to the server secured. <B>svc_acct.quota</B>, if available, is used to set the Cyrus quota. '
960 'desc' => 'Real-time export to Critical Path Account Provisioning Protocol',
961 'options' => \%cp_options,
962 'notes' => 'Real-time export to <a href="http://www.cp.net/">Critial Path Account Provisioning Protocol</a>. Requires installation of <a href="http://search.cpan.org/search?dist=Net-APP">Net::APP</a> from CPAN.',
966 'desc' => 'Real-time export to InfoStreet streetSmartAPI',
967 'options' => \%infostreet_options,
969 'notes' => 'Real-time export to <a href="http://www.infostreet.com/">InfoStreet</a> streetSmartAPI. Requires installation of <a href="http://search.cpan.org/search?dist=Frontier-Client">Frontier::Client</a> from CPAN.',
973 'desc' => 'Real-time export to vpopmail text files',
974 'options' => \%vpopmail_options,
975 'notes' => 'Real time export to <a href="http://inter7.com/vpopmail/">vpopmail</a> text files. <a href="http://search.cpan.org/search?dist=File-Rsync">File::Rsync</a> must be installed, and you will need to <a href="../docs/ssh.html">setup SSH for unattended operation</a> to <b>vpopmail</b>@<i>export.host</i>.',
978 'communigate_pro' => {
979 'desc' => 'Real-time export to a CommuniGate Pro mail server',
980 'options' => \%communigate_pro_options,
981 'notes' => 'Real time export to a <a href="http://www.stalker.com/CommuniGatePro/"> mail server. The <a href="http://www.stalker.com/CGPerl/">CommuniGate Pro Perl Interface</a> must be installed as CGP::CLI.',
989 'desc' =>'Batch export to BIND named',
990 'options' => \%bind_options,
991 'notes' => 'Batch export of BIND zone and configuration files to primary nameserver. <a href="http://search.cpan.org/search?dist=File-Rsync">File::Rsync</a> must be installed. Run bin/bind.export to export the files.',
995 'desc' =>'Batch export to slave BIND named',
996 'options' => \%bind_slave_options,
997 'notes' => 'Batch export of BIND configuration file to a secondary nameserver. Zones are slaved from the listed masters. <a href="http://search.cpan.org/search?dist=File-Rsync">File::Rsync</a> must be installed. Run bin/bind.export to export the files.',
1001 'desc' => 'Send an HTTP or HTTPS GET or POST request',
1002 'options' => \%http_options,
1003 'notes' => 'Send an HTTP or HTTPS GET or POST to the specified URL. <a href="http://search.cpan.org/search?dist=libwww-perl">libwww-perl</a> must be installed. For HTTPS support, <a href="http://search.cpan.org/search?dist=Crypt-SSLeay">Crypt::SSLeay</a> or <a href="http://search.cpan.org/search?dist=IO-Socket-SSL">IO::Socket::SSL</a> is required.',
1007 'desc' => 'Real-time export to SQL-backed mail server',
1008 'options' => \%sqlmail_options,
1010 'notes' => 'Database schema can be made to work with Courier IMAP and Exim. Others could work but are untested. (...extended description from pc-intouch?...)',
1013 'domain_shellcommands' => {
1014 'desc' => 'Run remote commands via SSH, for domains.',
1015 'options' => \%domain_shellcommands_options,
1016 'notes' => 'Run remote commands via SSH, for domains. You will need to <a href="../docs/ssh.html">setup SSH for unattended operation</a>.<BR><BR>Use these buttons for some useful presets:<UL><LI><INPUT TYPE="button" VALUE="qmail catchall .qmail-domain-default maintenance" onClick=\'this.form.useradd.value = "[ \"$uid\" -a \"$gid\" -a \"$dir\" -a \"$qdomain\" ] && [ -e $dir/.qmail-$qdomain-default ] || { touch $dir/.qmail-$qdomain-default; chown $uid:$gid $dir/.qmail-$qdomain-default; }"; this.form.userdel.value = ""; this.form.usermod.value = "";\'></UL>The following variables are available for interpolation (prefixed with <code>new_</code> or <code>old_</code> for replace operations): <UL><LI><code>$domain</code><LI><code>$qdomain</code> - domain with periods replaced by colons<LI><code>$uid</code> - of catchall account<LI><code>$gid</code> - of catchall account<LI><code>$dir</code> - home directory of catchall account<LI>All other fields in <a href="../docs/schema.html#svc_domain">svc_domain</a> are also available.</UL>',
1024 'desc' => 'Real-time export to SQL-backed mail server',
1025 'options' => \%sqlmail_options,
1027 'notes' => 'Database schema can be made to work with Courier IMAP and Exim. Others could work but are untested. (...extended description from pc-intouch?...)',
1030 'forward_shellcommands' => {
1031 'desc' => 'Run remote commands via SSH, for forwards',
1032 'options' => \%forward_shellcommands_options,
1033 'notes' => 'Run remote commands via SSH, for forwards. You will need to <a href="../docs/ssh.html">setup SSH for unattended operation</a>.<BR><BR>Use these buttons for some useful presets:<UL><LI><INPUT TYPE="button" VALUE="text vpopmail maintenance" onClick=\'this.form.useradd.value = "[ -d /home/vpopmail/domains/$domain/$username ] && { echo \"$destination\" > /home/vpopmail/domains/$domain/$username/.qmail; chown vpopmail:vchkpw /home/vpopmail/domains/$domain/$username/.qmail; }"; this.form.userdel.value = "rm /home/vpopmail/domains/$domain/$username/.qmail"; this.form.usermod.value = "mv /home/vpopmail/domains/$old_domain/$old_username/.qmail /home/vpopmail/domains/$new_domain/$new_username; [ \"$old_destination\" != \"$new_destination\" ] && { echo \"$new_destination\" > /home/vpopmail/domains/$new_domain/$new_username/.qmail; chown vpopmail:vchkpw /home/vpopmail/domains/$new_domain/$new_username/.qmail; }";\'></UL>The following variables are available for interpolation (prefixed with <code>new_</code> or <code>old_</code> for replace operations): <UL><LI><code>$username</code><LI><code>$domain</code><LI><code>$destination</code> - forward destination<LI>All other fields in <a href="../docs/schema.html#svc_forward">svc_forward</a> are also available.</UL>',
1038 'www_shellcommands' => {
1039 'desc' => 'Run remote commands via SSH, for virtual web sites.',
1040 'options' => \%www_shellcommands_options,
1041 'notes' => 'Run remote commands via SSH, for virtual web sites. You will need to <a href="../docs/ssh.html">setup SSH for unattended operation</a>.<BR><BR>The following variables are available for interpolation (prefixed with <code>new_</code> or <code>old_</code> for replace operations): <UL><LI><code>$zone</code><LI><code>$username</code><LI><code>$homedir</code><LI>All other fields in <a href="../docs/schema.html#svc_www">svc_www</a> are also available.</UL>',
1045 'desc' => 'Export an Apache httpd.conf file snippet.',
1046 'options' => \%apache_options,
1047 'notes' => 'Batch export of an httpd.conf snippet from a template. Typically used with something like <code>Include /etc/apache/httpd-freeside.conf</code> in httpd.conf. <a href="http://search.cpan.org/search?dist=File-Rsync">File::Rsync</a> must be installed. Run bin/apache.export to export the files.',
1051 'svc_broadband' => {
1053 'desc' => 'Send a command to a router.',
1054 'options' => \%router_options,
1062 =head1 NEW EXPORT CLASSES
1064 Should be added to the %export hash here, and a module should be added in
1065 FS/FS/part_export/ (an example may be found in eg/export_template.pm)
1069 All the stuff in the %exports hash should be generated from the specific
1072 Hmm... cust_export class (not necessarily a database table...) ... ?
1074 deprecated column...
1078 L<FS::part_export_option>, L<FS::export_svc>, L<FS::svc_acct>,
1080 L<FS::svc_forward>, L<FS::Record>, schema.html from the base documentation.