X-Git-Url: http://git.freeside.biz/gitweb/?p=freeside.git;a=blobdiff_plain;f=FS%2Fbin%2Ffreeside-setup;h=a6908e17226a6db7a9562dab6b06fee92a4fe842;hp=a51dfd7a07d070e3dbfb75e119ed37e32412bab7;hb=ac8410cdb67639afeb84c84e975fffadf3e6cce1;hpb=c8cccb4a92adceb943c635fe62dad0d034462ce0 diff --git a/FS/bin/freeside-setup b/FS/bin/freeside-setup index a51dfd7a0..a6908e172 100755 --- a/FS/bin/freeside-setup +++ b/FS/bin/freeside-setup @@ -1,83 +1,51 @@ -#!/usr/bin/perl -Tw +#!/usr/bin/perl -w #to delay loading dbdef until we're ready BEGIN { $FS::Schema::setup_hack = 1; } +#to allow initial insert +use FS::part_pkg; +$FS::part_pkg::setup_hack = 1; +$FS::part_pkg::setup_hack = 1; + use strict; -use vars qw($opt_u $opt_d $opt_v); +use vars qw($opt_u $opt_d $opt_v $opt_q); use Getopt::Std; use FS::UID qw(adminsuidsetup datasrc checkeuid getsecrets); use FS::CurrentUser; use FS::Schema qw( dbdef_dist reload_dbdef ); -use FS::Record; +use FS::Record qw( qsearch ); #use FS::raddb; use FS::Setup qw(create_initial_data); +use FS::Conf; die "Not running uid freeside!" unless checkeuid(); #my %attrib2db = # map { lc($FS::raddb::attrib{$_}) => $_ } keys %FS::raddb::attrib; -getopts("u:vd:"); -#my $user = shift or die &usage; +getopts("u:vqd:"); +$opt_v = 1 unless $opt_q; #verbose by default now -getsecrets($opt_u); #$user); +my $config_dir = shift || '%%%DIST_CONF%%%' ; +$config_dir =~ /^([\w.:=\/]+)$/ + or die "unacceptable configuration directory name"; +$config_dir = $1; -#needs to match FS::Record -my($dbdef_file) = "/usr/local/etc/freeside/dbdef.". datasrc; +getsecrets(); -### +#needs to match FS::Record +my($dbdef_file) = "%%%FREESIDE_CONF%%%/dbdef.". datasrc; -#print "\nEnter the maximum username length: "; -#my($username_len)=&getvalue; -my $username_len = 32; #usernamemax config file - -#print "\n\n", <); -# chop $x; -# $x; -#} -# -#sub _yesno { -# print " [y/N]:"; -# my $x = scalar(); -# $x =~ /^y/i; -#} - -#my @check_attributes = (); #add later -#my @attributes = (); #add later -#my $ship = $opt_s; +my $username_len = 32; ### # create a dbdef object from the old data structure ### -my $dbdef = dbdef_dist; +warn "Loading schema objects\n" if $opt_v; + +my $dbdef = dbdef_dist(datasrc); #important $dbdef->save($dbdef_file); @@ -87,14 +55,19 @@ $dbdef->save($dbdef_file); # create 'em ### +warn "Connecting to database\n" if $opt_v; + $FS::CurrentUser::upgrade_hack = 1; +$FS::UID::callback_hack = 1; my $dbh = adminsuidsetup $opt_u; #$user; +$FS::UID::callback_hack = 0; #create tables $|=1; +warn "Creating tables and indices\n" if $opt_v; + foreach my $statement ( $dbdef->sql($dbh) ) { - warn $statement if $statement =~ /TABLE cdr/; $dbh->do( $statement ) or die "CREATE error: ". $dbh->errstr. "\ndoing statement: $statement"; } @@ -105,13 +78,34 @@ dbdef_create($dbh, $dbdef_file); delete $FS::Schema::dbdef_cache{$dbdef_file}; #force an actual reload reload_dbdef($dbdef_file); -create_initial_data('domain' => $opt_d); - -warn "Freeside database initialized - commiting transaction\n" if $opt_v; +warn "Tables and indices created - commiting transaction\n" if $opt_v; +$dbh->commit or die $dbh->errstr; +$dbh->disconnect or die $dbh->errstr; +warn "Database schema committed successfully\n" if $opt_v; + +warn "Initializing configuration\n" if $opt_v; +$FS::UID::callback_hack = 1; +$dbh = adminsuidsetup $opt_u; +$FS::UID::callback_hack = 0; +if (!scalar(qsearch('conf', {}))) { + my $error = FS::Conf::init_config($config_dir); + if ($error) { + $dbh->rollback or die $dbh->errstr; + die $error; + } +} +warn "Configuration initialized - commiting transaction\n" if $opt_v; $dbh->commit or die $dbh->errstr; $dbh->disconnect or die $dbh->errstr; +warn "Configuration committed successfully\n" if $opt_v; + +$dbh = adminsuidsetup $opt_u; +create_initial_data('domain' => $opt_d); +warn "Database initialized - commiting transaction\n" if $opt_v; +$dbh->commit or die $dbh->errstr; +$dbh->disconnect or die $dbh->errstr; warn "Database initialization committed successfully\n" if $opt_v; sub dbdef_create { # reverse engineer the schema from the DB and save to file @@ -121,9 +115,10 @@ sub dbdef_create { # reverse engineer the schema from the DB and save to file } sub usage { - die "Usage:\n freeside-setup -d domain.name [ -v ]\n" + die "Usage:\n freeside-setup -d domain.name [ -q ] [ config/dir ]\n" # [ -u user ] for devel/multi-db installs } 1; +