| 1 | package Mail::Toaster::Setup::Vpopmail; | ||
| 2 | use strict; | ||
| 3 | use warnings; | ||
| 4 | |||
| 5 | our $VERSION = '5.50'; | ||
| 6 | |||
| 7 | use Carp; | ||
| 8 | use English '-no_match_vars'; | ||
| 9 | use Params::Validate ':all'; | ||
| 10 | |||
| 11 | use lib 'lib'; | ||
| 12 | use parent 'Mail::Toaster::Base'; | ||
| 13 | |||
| 14 | sub install { | ||
| 15 | my $self = shift; | ||
| 16 | my %p = validate( @_, { $self->get_std_opts } ); | ||
| 17 | |||
| 18 | return $p{test_ok} if defined $p{test_ok}; # for testing | ||
| 19 | |||
| 20 | if ( !$self->conf->{'install_vpopmail'} ) { | ||
| 21 | $self->audit( "vpopmail: installing, skipping (disabled)" ); | ||
| 22 | return; | ||
| 23 | } | ||
| 24 | |||
| 25 | my $version = $self->conf->{install_vpopmail} || '5.4.33'; | ||
| 26 | |||
| 27 | if ( $OSNAME eq "freebsd" ) { | ||
| 28 | # always install the port version, so subsequent ports will | ||
| 29 | # find it registered in the ports db. | ||
| 30 | $self->install_freebsd_port; | ||
| 31 | } | ||
| 32 | |||
| 33 | if ( $version ne 'port' ) { | ||
| 34 | $self->install_from_source( %p ); | ||
| 35 | }; | ||
| 36 | |||
| 37 | return $self->post_install; | ||
| 38 | }; | ||
| 39 | |||
| 40 | sub install_freebsd_port { | ||
| 41 | my $self = shift; | ||
| 42 | my %p = validate( @_, { $self->get_std_opts },); | ||
| 43 | |||
| 44 | my $conf = $self->conf; | ||
| 45 | my $version = $conf->{'install_vpopmail'}; | ||
| 46 | |||
| 47 | return $p{test_ok} if defined $p{test_ok}; # for testing only | ||
| 48 | |||
| 49 | my @defs = 'LOGLEVEL="p"'; | ||
| 50 | |||
| 51 | my $learn = $conf->{vpopmail_learn_passwords} ? 'SET' : 'UNSET'; | ||
| 52 | my $ip_alias = $conf->{vpopmail_ip_alias_domains} ? 'SET' : 'UNSET'; | ||
| 53 | my $qmail_ext= $conf->{vpopmail_qmail_ext} ? 'SET' : 'UNSET'; | ||
| 54 | my $single_dom=$conf->{vpopmail_disable_many_domains} ? 'SET' : 'UNSET'; | ||
| 55 | my $maildrop = $conf->{vpopmail_maildrop} ? 'SET' : 'UNSET'; | ||
| 56 | my $mysql = $conf->{'vpopmail_mysql'} ? 'SET' : 'UNSET'; | ||
| 57 | my $roaming = $conf->{vpopmail_roaming_users} ? 'SET' : 'UNSET'; | ||
| 58 | my $mysql_rep= my $mysql_lim = my $sql_log = my $valias = 'UNSET'; | ||
| 59 | my $auth_log = $conf->{vpopmail_auth_logging} ? 'SET' : 'UNSET'; | ||
| 60 | |||
| 61 | if ( $roaming eq 'SET' && $conf->{vpopmail_relay_clear_minutes} ) { | ||
| 62 | push @defs, 'RELAYCLEAR='.$conf->{vpopmail_relay_clear_minutes}; | ||
| 63 | }; | ||
| 64 | |||
| 65 | if ( $mysql eq 'SET' ) { | ||
| 66 | $self->error( "vpopmail_mysql is enabled but install_mysql is not. Please correct your settings" ) if ! $conf->{install_mysql}; | ||
| 67 | $mysql_rep = 'SET' if $conf->{vpopmail_mysql_replication}; | ||
| 68 | $mysql_lim = 'SET' if $conf->{vpopmail_mysql_limits}; | ||
| 69 | $valias = 'SET' if $conf->{vpopmail_valias}; | ||
| 70 | $sql_log = 'SET' if $conf->{vpopmail_mysql_logging}; | ||
| 71 | }; | ||
| 72 | |||
| 73 | $self->freebsd->install_port( 'vpopmail', | ||
| 74 | flags => join( ',', @defs ), | ||
| 75 | options => "# installed by Mail::Toaster | ||
| 76 | # Options for vpopmail-5.4.32_3 | ||
| 77 | _OPTIONS_READ=vpopmail-5.4.32_3 | ||
| 78 | _FILE_COMPLETE_OPTIONS_LIST=AUTH_LOG CLEAR_PASSWD DOCS DOMAIN_QUOTAS FILE_LOCKING FILE_SYNC FPIC IP_ALIAS LDAP LDAP_SASL LEARN_PASSWORDS MAILDROP MD5_PASSWORDS MYSQL MYSQL_LIMITS MYSQL_REPLICATION ONCHANGE_SCRIPT ORACLE PASSWD PGSQL QMAIL_EXT ROAMING SEEKABLE SINGLE_DOMAIN SMTP_AUTH_PATCH SPAMASSASSIN SPAMFOLDER SQL_LOG SQL_LOG_TRIM SUID_VCHKPW SYBASE USERS_BIG_DIR VALIAS | ||
| 79 | OPTIONS_FILE_$auth_log+=AUTH_LOG | ||
| 80 | OPTIONS_FILE_SET+=CLEAR_PASSWD | ||
| 81 | OPTIONS_FILE_SET+=DOCS | ||
| 82 | OPTIONS_FILE_UNSET+=DOMAIN_QUOTAS | ||
| 83 | OPTIONS_FILE_SET+=FILE_LOCKING | ||
| 84 | OPTIONS_FILE_UNSET+=FILE_SYNC | ||
| 85 | OPTIONS_FILE_SET+=FPIC | ||
| 86 | OPTIONS_FILE_$ip_alias+=IP_ALIAS | ||
| 87 | OPTIONS_FILE_UNSET+=LDAP | ||
| 88 | OPTIONS_FILE_UNSET+=LDAP_SASL | ||
| 89 | OPTIONS_FILE_$learn+=LEARN_PASSWORDS | ||
| 90 | OPTIONS_FILE_$maildrop+=MAILDROP | ||
| 91 | OPTIONS_FILE_SET+=MD5_PASSWORDS | ||
| 92 | OPTIONS_FILE_$mysql+=MYSQL | ||
| 93 | OPTIONS_FILE_$mysql_lim+=MYSQL_LIMITS | ||
| 94 | OPTIONS_FILE_$mysql_rep+=MYSQL_REPLICATION | ||
| 95 | OPTIONS_FILE_UNSET+=ONCHANGE_SCRIPT | ||
| 96 | OPTIONS_FILE_UNSET+=ORACLE | ||
| 97 | OPTIONS_FILE_UNSET+=PASSWD | ||
| 98 | OPTIONS_FILE_UNSET+=PGSQL | ||
| 99 | OPTIONS_FILE_$qmail_ext+=QMAIL_EXT | ||
| 100 | OPTIONS_FILE_$roaming+=ROAMING | ||
| 101 | OPTIONS_FILE_SET+=SEEKABLE | ||
| 102 | OPTIONS_FILE_$single_dom+=SINGLE_DOMAIN | ||
| 103 | OPTIONS_FILE_UNSET+=SMTP_AUTH_PATCH | ||
| 104 | OPTIONS_FILE_UNSET+=SPAMASSASSIN | ||
| 105 | OPTIONS_FILE_UNSET+=SPAMFOLDER | ||
| 106 | OPTIONS_FILE_$sql_log+=SQL_LOG | ||
| 107 | OPTIONS_FILE_UNSET+=SQL_LOG_TRIM | ||
| 108 | OPTIONS_FILE_UNSET+=SUID_VCHKPW | ||
| 109 | OPTIONS_FILE_UNSET+=SYBASE | ||
| 110 | OPTIONS_FILE_SET+=USERS_BIG_DIR | ||
| 111 | OPTIONS_FILE_$valias+=VALIAS | ||
| 112 | ", | ||
| 113 | ) or return; | ||
| 114 | |||
| 115 | my $vpopdir = $self->get_vpop_dir; | ||
| 116 | my $docroot = $self->conf->{'toaster_http_docs'}; | ||
| 117 | |||
| 118 | # add a symlink so docs are web browsable | ||
| 119 | if ( -d $docroot && ! -e "$docroot/vpopmail" ) { | ||
| 120 | if ( -d "$vpopdir/doc/man_html" ) { | ||
| 121 | symlink "$vpopdir/doc/man_html", "$docroot/vpopmail"; | ||
| 122 | } | ||
| 123 | } | ||
| 124 | } | ||
| 125 | |||
| 126 | sub install_from_source { | ||
| 127 | my $self = shift; | ||
| 128 | my %p = validate( @_, { $self->get_std_opts },); | ||
| 129 | |||
| 130 | my $conf = $self->conf; | ||
| 131 | my $version = $conf->{'install_vpopmail'} || "5.4.33"; | ||
| 132 | my $package = "vpopmail-$version"; | ||
| 133 | my $vpopdir = $self->get_vpop_dir; | ||
| 134 | |||
| 135 | $self->create_user(); # add the vpopmail user/group | ||
| 136 | my $uid = getpwnam( $conf->{'vpopmail_user'} || "vpopmail" ); | ||
| 137 | my $gid = getgrnam( $conf->{'vpopmail_group'} || "vchkpw" ); | ||
| 138 | |||
| 139 | my $installed = $self->installed_version(); | ||
| 140 | |||
| 141 | if ( $installed && $installed eq $version ) { | ||
| 142 | $self->util->yes_or_no( | ||
| 143 | "Do you want to reinstall vpopmail with the same version?", | ||
| 144 | timeout => 60, | ||
| 145 | ) or do { | ||
| 146 | $self->post_install(); | ||
| 147 | return 1; | ||
| 148 | }; | ||
| 149 | } | ||
| 150 | |||
| 151 | my $conf_args; | ||
| 152 | foreach ( qw/ rebuild_tcpserver_file ip_alias_domains valias mysql_logging | ||
| 153 | qmail_ext learn_passwords mysql / ) { | ||
| 154 | my $mt_setting = 'vpopmail_' . $_; | ||
| 155 | my $conf_arg = "--enable-$_"; | ||
| 156 | $conf_arg =~ s/_/-/g; | ||
| 157 | my $r = $conf->{$mt_setting} ? 'yes' : 'no'; | ||
| 158 | $conf_args .= " $conf_arg=$r"; | ||
| 159 | print "$conf_arg=$r\n"; | ||
| 160 | }; | ||
| 161 | |||
| 162 | if ( ! $self->is_newer( min => "5.3.30", cur => $version ) ) { | ||
| 163 | if ( defined $conf->{'vpopmail_default_quota'} ) { | ||
| 164 | $conf_args .= | ||
| 165 | " --enable-defaultquota=".$conf->{'vpopmail_default_quota'}; | ||
| 166 | print "default quota: ".$conf->{'vpopmail_default_quota'}."\n"; | ||
| 167 | } | ||
| 168 | else { | ||
| 169 | $conf_args .= " --enable-defaultquota=100000000S,10000C"; | ||
| 170 | print "default quota: 100000000S,10000C\n"; | ||
| 171 | } | ||
| 172 | } | ||
| 173 | |||
| 174 | $conf_args .= $self->roaming_users(); | ||
| 175 | |||
| 176 | if ( $OSNAME eq "darwin" && !-d "/usr/local/mysql" | ||
| 177 | && -d "/opt/local/include/mysql" ) { | ||
| 178 | $conf_args .= " --enable-incdir=/opt/local/include/mysql"; | ||
| 179 | $conf_args .= " --enable-libdir=/opt/local/lib/mysql"; | ||
| 180 | } | ||
| 181 | |||
| 182 | my $tcprules = $self->util->find_bin( "tcprules", verbose=>0 ); | ||
| 183 | $conf_args .= " --enable-tcprules-prog=$tcprules"; | ||
| 184 | |||
| 185 | my $src = $conf->{'toaster_src_dir'} || "/usr/local/src"; | ||
| 186 | |||
| 187 | $self->util->cwd_source_dir( "$src/mail" ); | ||
| 188 | |||
| 189 | my $tarball = "$package.tar.gz"; | ||
| 190 | |||
| 191 | # save having to download it again | ||
| 192 | if ( -e "/usr/ports/distfiles/vpopmail-$version.tar.gz" ) { | ||
| 193 | copy( | ||
| 194 | "/usr/ports/distfiles/vpopmail-$version.tar.gz", | ||
| 195 | "/usr/local/src/mail/" | ||
| 196 | ); | ||
| 197 | } | ||
| 198 | |||
| 199 | $self->util->sources_get( | ||
| 200 | 'package' => $package, | ||
| 201 | site => "http://" . $conf->{'toaster_sf_mirror'}, | ||
| 202 | path => "/vpopmail", | ||
| 203 | ); | ||
| 204 | |||
| 205 | if ( -d $package ) { | ||
| 206 | $self->util->source_warning( | ||
| 207 | package => $package, | ||
| 208 | src => "$src/mail", | ||
| 209 | ) or return; | ||
| 210 | } | ||
| 211 | |||
| 212 | $self->util->extract_archive( $tarball ) or die; | ||
| 213 | |||
| 214 | if ( $conf->{vpopmail_mysql} ) { | ||
| 215 | $conf_args .= $self->mysql_options(); | ||
| 216 | }; | ||
| 217 | $conf_args .= $self->logging(); | ||
| 218 | $conf_args .= $self->default_domain($version); | ||
| 219 | $conf_args .= $self->etc_passwd(); | ||
| 220 | |||
| 221 | # in case someone updates their toaster and not their config file | ||
| 222 | if ( defined $conf->{'vpopmail_qmail_ext'} | ||
| 223 | && $conf->{'vpopmail_qmail_ext'} ) { | ||
| 224 | $conf_args .= " --enable-qmail-ext=y"; | ||
| 225 | print "qmail extensions: yes\n"; | ||
| 226 | } | ||
| 227 | if ( defined $conf->{'vpopmail_maildrop'} ) { | ||
| 228 | $conf_args .= " --enable-maildrop=y"; | ||
| 229 | }; | ||
| 230 | |||
| 231 | print "fixup for longer passwords\n"; | ||
| 232 | system "sed -i -Ee '/^pw_clear_passwd char(/s/16/128/' vmysql.h"; | ||
| 233 | system "sed -i -Ee '/^pw_passwd char(/s/40/128/' vmysql.h"; | ||
| 234 | |||
| 235 | chdir($package); | ||
| 236 | print "running configure with $conf_args\n\n"; | ||
| 237 | |||
| 238 | $self->util->syscmd( "./configure $conf_args", verbose => 0 ); | ||
| 239 | $self->util->syscmd( "make", verbose => 0 ); | ||
| 240 | $self->util->syscmd( "make install-strip", verbose => 0 ); | ||
| 241 | |||
| 242 | if ( -e "vlimits.h" ) { | ||
| 243 | # this was for a bug in vpopmail 5.4.?(1-2) installer | ||
| 244 | $self->util->syscmd( "cp vlimits.h $vpopdir/include/", verbose => 0); | ||
| 245 | } | ||
| 246 | |||
| 247 | return 1; | ||
| 248 | } | ||
| 249 | |||
| 250 | sub default_domain { | ||
| 251 | my $self = shift; | ||
| 252 | my $version = shift; | ||
| 253 | |||
| 254 | my $default_domain; | ||
| 255 | |||
| 256 | if ( defined $self->conf->{'vpopmail_default_domain'} ) { | ||
| 257 | $default_domain = $self->conf->{'vpopmail_default_domain'}; | ||
| 258 | } | ||
| 259 | else { | ||
| 260 | $self->util->yes_or_no( "Do you want to use a default domain? " ) or do { | ||
| 261 | print "default domain: NONE SELECTED.\n"; | ||
| 262 | return ''; | ||
| 263 | }; | ||
| 264 | |||
| 265 | $default_domain = $self->util->ask("your default domain"); | ||
| 266 | }; | ||
| 267 | |||
| 268 | if ( ! $default_domain ) { | ||
| 269 | print "default domain: NONE SELECTED.\n"; | ||
| 270 | return ''; | ||
| 271 | }; | ||
| 272 | |||
| 273 | if ( $self->is_newer( min => "5.3.22", cur => $version ) ) { | ||
| 274 | my $vpopetc = $self->get_vpop_etc; | ||
| 275 | $self->util->file_write( "$vpopetc/defaultdomain", | ||
| 276 | lines => [ $default_domain ], | ||
| 277 | verbose => 0, | ||
| 278 | ); | ||
| 279 | |||
| 280 | $self->util->chown( "$vpopetc/defaultdomain", | ||
| 281 | uid => $self->conf->{'vpopmail_user'} || "vpopmail", | ||
| 282 | gid => $self->conf->{'vpopmail_group'} || "vchkpw", | ||
| 283 | ); | ||
| 284 | |||
| 285 | return ''; | ||
| 286 | } | ||
| 287 | |||
| 288 | print "default domain: $default_domain\n"; | ||
| 289 | return " --enable-default-domain=$default_domain"; | ||
| 290 | }; | ||
| 291 | |||
| 292 | sub vpopmail_etc { | ||
| 293 | my $self = shift; | ||
| 294 | my %p = validate( @_, { $self->get_std_opts } ); | ||
| 295 | |||
| 296 | my $vetc = $self->get_vpop_etc; | ||
| 297 | |||
| 298 | mkpath( $vetc, oct('0775') ) if ! -d $vetc; | ||
| 299 | |||
| 300 | if ( -d $vetc ) { | ||
| 301 | print "$vetc already exists.\n"; | ||
| 302 | } | ||
| 303 | else { | ||
| 304 | print "creating $vetc\n"; | ||
| 305 | mkdir( $vetc, oct('0775') ) or carp "failed to create $vetc: $!\n"; | ||
| 306 | } | ||
| 307 | |||
| 308 | $self->setup->tcp_smtp( etc_dir => $vetc ); | ||
| 309 | $self->setup->tcp_smtp_cdb( etc_dir => $vetc ); | ||
| 310 | } | ||
| 311 | |||
| 312 | sub etc_passwd { | ||
| 313 | my $self = shift; | ||
| 314 | |||
| 315 | unless ( defined $self->conf->{'vpopmail_etc_passwd'} ) { | ||
| 316 | print "\t\t CAUTION!! CAUTION!! | ||
| 317 | |||
| 318 | The system user account feature is NOT compatible with qmail-smtpd-chkusr. | ||
| 319 | If you selected that option in the qmail build, you should not answer | ||
| 320 | yes here. If you are unsure, select (n).\n"; | ||
| 321 | |||
| 322 | if ( $self->util->yes_or_no( "Do system users (/etc/passwd) get mail? (n) ")) { | ||
| 323 | print "system password accounts: yes\n"; | ||
| 324 | return " --enable-passwd"; | ||
| 325 | } | ||
| 326 | } | ||
| 327 | |||
| 328 | if ( $self->conf->{'vpopmail_etc_passwd'} ) { | ||
| 329 | print "system password accounts: yes\n"; | ||
| 330 | return " --enable-passwd"; | ||
| 331 | } | ||
| 332 | |||
| 333 | print "system password accounts: no\n"; | ||
| 334 | }; | ||
| 335 | |||
| 336 | sub get_vpop_etc { | ||
| 337 | my $self = shift; | ||
| 338 | my $base = $self->get_vpop_dir; | ||
| 339 | return "$base/etc"; | ||
| 340 | }; | ||
| 341 | |||
| 342 | sub get_vpop_dir { | ||
| 343 | my $self = shift; | ||
| 344 | return $self->{conf}{vpopmail_home_dir} || '/usr/local/vpopmail'; | ||
| 345 | }; | ||
| 346 | |||
| 347 | sub installed_version { | ||
| 348 | my $self = shift; | ||
| 349 | |||
| 350 | my $vpopdir = $self->get_vpop_dir; | ||
| 351 | return if ! -x "$vpopdir/bin/vpasswd"; | ||
| 352 | |||
| 353 | my $installed = `$vpopdir/bin/vpasswd -v | head -1 | cut -f2 -d" "`; | ||
| 354 | chop $installed; | ||
| 355 | $self->alert( "vpopmail version $installed installed." ); | ||
| 356 | return $installed; | ||
| 357 | } | ||
| 358 | |||
| 359 | sub logging { | ||
| 360 | my $self = shift; | ||
| 361 | |||
| 362 | my $conf = $self->conf; | ||
| 363 | if ( defined $conf->{vpopmail_logging} && $conf->{vpopmail_logging} ) { | ||
| 364 | if ( $conf->{'vpopmail_logging_verbose'} ) { | ||
| 365 | print "logging: verbose with failed passwords\n"; | ||
| 366 | return " --enable-logging=v"; | ||
| 367 | } | ||
| 368 | |||
| 369 | print "logging: everything\n"; | ||
| 370 | return " --enable-logging=y"; | ||
| 371 | } | ||
| 372 | |||
| 373 | if ( ! $self->util->yes_or_no( "Do you want logging enabled? (y) ")) { | ||
| 374 | return " --enable-logging=p"; | ||
| 375 | }; | ||
| 376 | |||
| 377 | if ( $self->util->yes_or_no( "Do you want verbose logging? (y) ")) { | ||
| 378 | print "logging: verbose\n"; | ||
| 379 | return " --enable-logging=v"; | ||
| 380 | } | ||
| 381 | |||
| 382 | print "logging: verbose with failed passwords\n"; | ||
| 383 | return " --enable-logging=p"; | ||
| 384 | }; | ||
| 385 | |||
| 386 | sub post_install { | ||
| 387 | my $self = shift; | ||
| 388 | $self->vpopmail_etc; | ||
| 389 | $self->mysql_privs; | ||
| 390 | $self->util->install_module( "vpopmail" ) if $self->{conf}{install_ezmlm_cgi}; | ||
| 391 | print "vpopmail: complete.\n"; | ||
| 392 | return 1; | ||
| 393 | }; | ||
| 394 | |||
| 395 | sub roaming_users { | ||
| 396 | my $self = shift; | ||
| 397 | |||
| 398 | my $roaming = $self->conf->{'vpopmail_roaming_users'}; | ||
| 399 | |||
| 400 | if ( defined $roaming && !$roaming ) { | ||
| 401 | print "roaming users: no\n"; | ||
| 402 | return " --enable-roaming-users=n"; | ||
| 403 | } | ||
| 404 | |||
| 405 | # default to enabled | ||
| 406 | if ( !defined $self->conf->{'vpopmail_roaming_users'} ) { | ||
| 407 | print "roaming users: value not set?!\n"; | ||
| 408 | } | ||
| 409 | |||
| 410 | print "roaming users: yes\n"; | ||
| 411 | |||
| 412 | my $min = $self->conf->{'vpopmail_relay_clear_minutes'}; | ||
| 413 | if ( $min && $min ne 180 ) { | ||
| 414 | print "roaming user minutes: $min\n"; | ||
| 415 | return " --enable-roaming-users=y" . | ||
| 416 | " --enable-relay-clear-minutes=$min"; | ||
| 417 | }; | ||
| 418 | return " --enable-roaming-users=y"; | ||
| 419 | }; | ||
| 420 | |||
| 421 | sub test { | ||
| 422 | my $self = shift; | ||
| 423 | my %p = validate( @_, { $self->get_std_opts },); | ||
| 424 | |||
| 425 | return $p{test_ok} if defined $p{test_ok}; | ||
| 426 | |||
| 427 | print "do vpopmail directories exist...\n"; | ||
| 428 | my $vpdir = $self->conf->{'vpopmail_home_dir'}; | ||
| 429 | foreach ( "", "bin", "domains", "etc/", "include", "lib" ) { | ||
| 430 | $self->setup->test->pretty(" $vpdir/$_", -d "$vpdir/$_" ); | ||
| 431 | } | ||
| 432 | |||
| 433 | print "checking vpopmail binaries...\n"; | ||
| 434 | foreach ( | ||
| 435 | qw/ | ||
| 436 | clearopensmtp vaddaliasdomain vadddomain | ||
| 437 | valias vadduser vchkpw | ||
| 438 | vchangepw vconvert vdeldomain | ||
| 439 | vdelivermail vdeloldusers vdeluser | ||
| 440 | vdominfo vipmap vkill | ||
| 441 | vmkpasswd vmoddomlimits vmoduser | ||
| 442 | vpasswd vpopbull vqmaillocal | ||
| 443 | vsetuserquota vuserinfo / | ||
| 444 | ) | ||
| 445 | { | ||
| 446 | $self->setup->test->pretty(" $_", -x "$vpdir/bin/$_" ); | ||
| 447 | } | ||
| 448 | |||
| 449 | print "do vpopmail libs exist...\n"; | ||
| 450 | foreach ("$vpdir/lib/libvpopmail.a") { | ||
| 451 | $self->setup->test->pretty(" $_", -e $_ ); | ||
| 452 | } | ||
| 453 | |||
| 454 | print "do vpopmail includes exist...\n"; | ||
| 455 | foreach (qw/ config.h vauth.h vlimits.h vpopmail.h vpopmail_config.h /) { | ||
| 456 | $self->setup->test->pretty(" include/$_", -e "$vpdir/include/$_" ); | ||
| 457 | } | ||
| 458 | |||
| 459 | print "checking vpopmail etc files...\n"; | ||
| 460 | my @vpetc = qw/ inc_deps lib_deps tcp.smtp tcp.smtp.cdb vlimits.default /; | ||
| 461 | push @vpetc, 'vpopmail.mysql' if $self->conf->{'vpopmail_mysql'}; | ||
| 462 | |||
| 463 | foreach ( @vpetc ) { | ||
| 464 | $self->setup->test->pretty(" $_", (-e "$vpdir/etc/$_" && -s "$vpdir/etc/$_" )); | ||
| 465 | } | ||
| 466 | } | ||
| 467 | |||
| 468 | sub create_user { | ||
| 469 | my $self = shift; | ||
| 470 | my %p = validate( @_, { $self->get_std_opts } ); | ||
| 471 | |||
| 472 | my $vpopdir = $self->get_vpop_dir; | ||
| 473 | my $vpuser = $self->conf->{vpopmail_user} || 'vpopmail'; | ||
| 474 | my $vpgroup = $self->conf->{vpopmail_group} || 'vchkpw'; | ||
| 475 | |||
| 476 | my $uid = getpwnam($vpuser); | ||
| 477 | my $gid = getgrnam($vpgroup); | ||
| 478 | |||
| 479 | if ( !$uid || !$gid ) { | ||
| 480 | $self->group_add( $vpgroup, "89" ); | ||
| 481 | $self->user_add( $vpuser, 89, 89, homedir => $vpopdir ); | ||
| 482 | } | ||
| 483 | |||
| 484 | $uid = getpwnam($vpuser); | ||
| 485 | $gid = getgrnam($vpgroup); | ||
| 486 | |||
| 487 | return $self->error( "failed to add vpopmail user or group!") | ||
| 488 | if ( !$uid || !$gid ); | ||
| 489 | |||
| 490 | return 1; | ||
| 491 | } | ||
| 492 | |||
| 493 | sub mysql_options { | ||
| 494 | my $self = shift; | ||
| 495 | my $mysql_repl = $self->conf->{vpopmail_mysql_replication}; | ||
| 496 | my $my_write = $self->conf->{vpopmail_mysql_repl_master} || 'localhost'; | ||
| 497 | my $db = $self->conf->{vpopmail_mysql_database} || 'vpopmail'; | ||
| 498 | |||
| 499 | my $opts; | ||
| 500 | if ( $self->conf->{vpopmail_mysql_limits} ) { | ||
| 501 | print "mysql qmailadmin limits: yes\n"; | ||
| 502 | $opts .= " --enable-mysql-limits=y"; | ||
| 503 | } | ||
| 504 | |||
| 505 | if ( $mysql_repl ) { | ||
| 506 | $opts .= " --enable-mysql-replication=y"; | ||
| 507 | print "mysql replication: yes\n"; | ||
| 508 | print " replication master: $my_write\n"; | ||
| 509 | } | ||
| 510 | |||
| 511 | if ( $self->conf->{vpopmail_disable_many_domains} ) { | ||
| 512 | $opts .= " --disable-many-domains"; | ||
| 513 | } | ||
| 514 | |||
| 515 | return $opts; | ||
| 516 | } | ||
| 517 | |||
| 518 | sub mysql_privs { | ||
| 519 | my $self = shift; | ||
| 520 | my %p = validate( @_, { $self->get_std_opts },); | ||
| 521 | |||
| 522 | if ( !$self->conf->{'vpopmail_mysql'} ) { | ||
| 523 | print "vpopmail mysql_privs: mysql support not selected\n"; | ||
| 524 | return; | ||
| 525 | } | ||
| 526 | |||
| 527 | my $mysql_repl = $self->conf->{vpopmail_mysql_replication}; | ||
| 528 | my $my_write = $self->conf->{vpopmail_mysql_repl_master} || 'localhost'; | ||
| 529 | my $my_write_port = $self->conf->{vpopmail_mysql_repl_master_port} || 3306; | ||
| 530 | my $my_read = $self->conf->{vpopmail_mysql_repl_slave} || 'localhost'; | ||
| 531 | my $my_read_port = $self->conf->{vpopmail_mysql_repl_slave_port} || 3306; | ||
| 532 | my $db = $self->conf->{vpopmail_mysql_database} || 'vpopmail'; | ||
| 533 | |||
| 534 | my $user = $self->conf->{'vpopmail_mysql_user'} || $self->conf->{vpopmail_mysql_repl_user}; | ||
| 535 | my $pass = $self->conf->{'vpopmail_mysql_pass'} || $self->conf->{vpopmail_mysql_repl_pass}; | ||
| 536 | |||
| 537 | my $vpopdir = $self->get_vpop_dir; | ||
| 538 | |||
| 539 | my @lines = "$my_read|0|$user|$pass|$db"; | ||
| 540 | if ($mysql_repl) { | ||
| 541 | push @lines, "$my_write|$my_write_port|$user|$pass|$db"; | ||
| 542 | } | ||
| 543 | else { | ||
| 544 | push @lines, "$my_read|$my_read_port|$user|$pass|$db"; | ||
| 545 | } | ||
| 546 | |||
| 547 | $self->util->file_write( "$vpopdir/etc/vpopmail.mysql", | ||
| 548 | lines => \@lines, | ||
| 549 | verbose => 1, | ||
| 550 | ); | ||
| 551 | |||
| 552 | my $dot = $self->mysql->parse_dot_file( ".my.cnf", "[mysql]", 0 ) | ||
| 553 | || { user => $user, pass => $pass, host => $my_write, db => $db }; | ||
| 554 | |||
| 555 | my ( $dbh, $dsn, $drh ) = $self->mysql->connect( $dot, 1 ); | ||
| 556 | if ( !$dbh ) { | ||
| 557 | $dot = { user => 'root', pass => '', host => $my_write }; | ||
| 558 | ( $dbh, $dsn, $drh ) = $self->mysql->connect( $dot, 1 ); | ||
| 559 | }; | ||
| 560 | |||
| 561 | if ( !$dbh ) { | ||
| 562 | print <<"EOMYSQLGRANT"; | ||
| 563 | |||
| 564 | WARNING: I couldn't connect to your database server! If this is a new install, | ||
| 565 | you will need to connect to your database server and run this command manually: | ||
| 566 | |||
| 567 | mysql -u root -h $my_write -p | ||
| 568 | CREATE DATABASE $db; | ||
| 569 | GRANT ALL PRIVILEGES ON $db.* TO $user\@'$my_write' IDENTIFIED BY '$pass'; | ||
| 570 | use $db; | ||
| 571 | CREATE TABLE relay ( ip_addr char(18) NOT NULL default '', | ||
| 572 | timestamp char(12) default NULL, name char(64) default NULL, | ||
| 573 | PRIMARY KEY (ip_addr)) PACK_KEYS=1; | ||
| 574 | ALTER TABLE vpopmail MODIFY pw_clear_passwd VARCHAR(128); | ||
| 575 | ALTER TABLE vpopmail MODIFY pw_passwd VARCHAR(128); | ||
| 576 | quit; | ||
| 577 | |||
| 578 | If this is an upgrade and you already use MySQL authentication, | ||
| 579 | then you can safely ignore this warning. | ||
| 580 | |||
| 581 | EOMYSQLGRANT | ||
| 582 | return; | ||
| 583 | } | ||
| 584 | |||
| 585 | my $query = "use $db"; | ||
| 586 | my $sth = $self->mysql->query( $dbh, $query, 1 ); | ||
| 587 | if ( !$sth->errstr ) { | ||
| 588 | $self->audit( "vpopmail: database setup, ok (exists)" ); | ||
| 589 | $sth->finish; | ||
| 590 | return 1; | ||
| 591 | } | ||
| 592 | |||
| 593 | print "vpopmail: no vpopmail database, creating it now...\n"; | ||
| 594 | $query = "CREATE DATABASE $db"; | ||
| 595 | $sth = $self->mysql->query( $dbh, $query ); | ||
| 596 | |||
| 597 | print "vpopmail: granting privileges to $user\n"; | ||
| 598 | $query = | ||
| 599 | "GRANT ALL PRIVILEGES ON $db.* TO $user\@'$my_write' IDENTIFIED BY '$pass'"; | ||
| 600 | $sth = $self->mysql->query( $dbh, $query ); | ||
| 601 | |||
| 602 | print "vpopmail: creating the relay table.\n"; | ||
| 603 | $query = "CREATE TABLE $db.relay ( ip_addr char(18) NOT NULL default '', timestamp char(12) default NULL, name char(64) default NULL, PRIMARY KEY (ip_addr)) PACK_KEYS=1"; | ||
| 604 | $sth = $self->mysql->query( $dbh, $query ); | ||
| 605 | $self->audit( "vpopmail: databases created, ok" ); | ||
| 606 | $sth = $self->mysql->query( $dbh, "ALTER TABLE vpopmail MODIFY pw_clear_passwd VARCHAR(128)" ); | ||
| 607 | $sth = $self->mysql->query( $dbh, "ALTER TABLE vpopmail MODIFY pw_passwd VARCHAR(128)" ); | ||
| 608 | |||
| 609 | $sth->finish; | ||
| 610 | |||
| 611 | return 1; | ||
| 612 | } | ||
| 613 | |||
| 614 | 1; |