Changeset 323

Timestamp:

07/22/06 23:25:39 (2 years ago)

Author:

ogawa

Message:

Refine configuration options.

Location:

mysqldump2email/trunk

Files:

• config.yaml.sample (modified) (1 diff)
• mysqldump2email (modified) (7 diffs)

mysqldump2email/trunk/config.yaml.sample

@@ -1 @@
-username: your-mysql-username
-password: your-mysql-password
+mysqldump:
+  command: /usr/local/bin/mysqldump
+  username: your-mysql-username
+  password: your-mysql-password
+  #host: localhost
 
-mailfrom: address@example.com
-mailto:   address@example.com
-mailroute:
-  via:  smtp
-  host: localhost:25
-#mailroute:
-# via:  sendmail
+zip:
+  command: /usr/local/bin/zip
+  # if encryption needed
+  #password: your-zip-password
 
-mysqldump-command: /usr/local/bin/mysqldump
-zip-command:       /usr/local/bin/zip
+mail:
+  from: address@example.com
+  to:   address@example.com
+  route:
+    via:  smtp
+    host: localhost:25
+  #route:
+  #  via:  sendmail
 
-# if encryption needed
-#zip-password: your-zip-password
+tmpdir: /tmp

mysqldump2email/trunk/mysqldump2email

@@ -25 +25 @@
 my $zipfile = dump_mysql($cfg, $dt);
 
-my $mailroute = $cfg->{mailroute} || { via => 'smtp', host => 'localhost' };
+my $cfg_mail = $cfg->{mail}
+    or die 'No "mail" setting found in config.yaml';
+
+my $mailroute = $cfg_mail->{route} || { via => 'smtp', host => 'localhost' };
 MIME::Lite->send($mailroute->{via},
                  $mailroute->{host} ? ($mailroute->{host}) : ());
@@ -31 +34 @@
 my $msg = MIME::Lite->new(
     Date => DateTime::Format::Mail->format_datetime($dt),
-    From => __PACKAGE__ . ' <' . $cfg->{mailfrom} . '>',
-    To => $cfg->{mailto},
+    From => __PACKAGE__ . ' <' . $cfg_mail->{from} . '>',
+    To => $cfg_mail->{to},
     Subject => encode('MIME-Header', __PACKAGE__),
     Type => 'multipart/mixed',
@@ -51 +54 @@
 sub dump_mysql {
     my ($cfg, $dt) = @_;
+    my $cfg_mdump = $cfg->{mysqldump}
+        or die 'No "mysqldump" setting found in config.yaml';
+    my $cfg_zip = $cfg->{zip}
+        or die 'No "zip" setting found in config.yaml';
+
     my $ts = $dt->ymd('') . $dt->hms('');
-
     my $tmpdir = $cfg->{'tmpdir'} || '/tmp';
     my $fname = __PACKAGE__ . '.' . $ts;
@@ -58 +65 @@
     my $zipfile = $dumpfile . '.zip';
 
-    system($cfg->{'mysqldump-command'} || 'mysqldump',
+    system($cfg_mdump->{command} || 'mysqldump',
            '--all-databases',
-           '--user=' . $cfg->{username},
-           '--password=' . $cfg->{password},
+           ($cfg_mdump->{username} ? ('--user=' . $cfg_mdump->{username}) : ()),
+           ($cfg_mdump->{password} ? ('--password=' . $cfg_mdump->{password}) : ()),
+           ($cfg_mdump->{host} ? ('--host=' . $cfg_mdump->{host}) : ()),
            '--result-file=' . $dumpfile) == 0
         or die 'Failed to execute "mysqldump" command';
-    system($cfg->{'zip-command'} || 'zip',
+    system($cfg_zip->{command} || 'zip',
            '-9mqj',
-           ($cfg->{'zip-password'} ? ('-P', $cfg->{'zip-password'}) : ()),
+           ($cfg_zip->{password} ? ('-P', $cfg_zip->{password}) : ()),
            $zipfile, $dumpfile) == 0
         or die 'Failed to execute "zip" command';
@@ -126 +134 @@
 =over 4
 
+=item mysqldump:
+
+=over 4
+
+=item command
+
+Set the full path of C<mysqldump> command in your box.
+
 =item username, password
 
 Set your username and password for MySQL.
 
-=item mailfrom
-
-Set email address for this application, which is used as C<From:> header.
-
-=item mailto
-
-Set the target email address, which is sent emails to.
-
-=item mailroute
-
-Set how to send emails. Default is to use SMTP.
-
-=mysqldump-command, zip-command
-
-Set the path to C<mysqldump> and C<zip> commands.
-
-=zip-password (Optional)
+=item host (Optional)
+
+Set your hostname of MySQL server.
+
+=back
+
+=item zip:
+
+=over 4
+
+=item command
+
+Set the full path of C<zip> command in your box.
+
+=item password (Optional)
 
 Set the password for encrypting/decrypting zip files.  If not set, no
@@ -153 +167 @@
 =back
 
+=item mail:
+
+=over 4
+
+=item from
+
+Set email address for this application, which is used as C<From:> header.
+
+=item to
+
+Set the target email address, which is sent emails to.
+
+=item route
+
+Set how to send emails. Default is to use SMTP.
+
+=back
+
+=item tmpdir:
+
+Set the temporary directory for this application.
+
+=back
+
 =head1 DEVELOPMENT
 
@@ -158 +196 @@
 subversion repository:
 
-  http://code.as-is.net/svn/public/mysqldump2email/trunk
+http://code.as-is.net/svn/public/mysqldump2email/trunk
 
 You can browse the files via viewvc from the following:
 
-  http://code.as-is.net/viewvc/public/browse/mysqldump2email/trunk/
+http://code.as-is.net/viewvc/public/browse/mysqldump2email/trunk/
 
 Any comments, suggestions, or patches are welcome.