I'm testing a clean install on my testserver. The upgrade went ok on my production server (after I upgraded django south to the latest version) But now I'm testing my installation again on a testserver with a clean install and I can't seem to get "Mailscanner --lint" to run
So I'm a bit worried, cause I need to do another install in a few days and I can't get my testserver to install a default version without errors. After comparing mysql databases I can see I'm quite a few tables short in my testserver. (see below) It seems that baruwa-admin syncdb is unable to initialize a new 'empty' db. Rob on the testserver showtables; +----------------------------+ | Tables_in_baruwa | +----------------------------+ | auth_group | | auth_group_permissions | | auth_message | | auth_permission | | auth_user | | auth_user_groups | | auth_user_user_permissions | | celery_taskmeta | | celery_tasksetmeta | | django_content_type | | django_session | | djcelery_crontabschedule | | djcelery_intervalschedule | | djcelery_periodictask | | djcelery_periodictasks | | djcelery_taskstate | | djcelery_workerstate | | domain_signatures | | signature_imgs | | south_migrationhistory | | user_signatures | +----------------------------+ 21 rows in set (0.00 sec) as to the one on production: show tables; +----------------------------+ | Tables_in_baruwa | +----------------------------+ | archive | | auth_group | | auth_group_permissions | | auth_hosts | | auth_message | | auth_permission | | auth_user | | auth_user_groups | | auth_user_user_permissions | | celery_taskmeta | | celery_tasksetmeta | | deliveryinfo | | django_content_type | | django_session | | djcelery_crontabschedule | | djcelery_intervalschedule | | djcelery_periodictask | | djcelery_periodictasks | | djcelery_taskstate | | djcelery_workerstate | | domain_signatures | | htmlsigs | | lists | | mail_hosts | | mailq | | message_recipients | | messages | | ms_rulesets | | profiles | | quarantine_releases | | report_filters | | sa_rules | | scanner_config | | scanner_config_sections | | scanners | | sigimgfiles | | sigimgs | | signature_imgs | | south_migrationhistory | | textsigs | | user_addresses | | user_signatures | +----------------------------+ 42 rows in set (0.01 sec) Rob My error: MailScanner --lint DBD::mysql::st execute failed: Table 'baruwa.scanner_config' doesn't exist [for Statement "SELECT value FROM scanner_config, scanners WHERE scanner_config.host_id = scanners.id AND external = ? AND scanners.address = ?" with ParamValues: 0='mailscannerversionnumber', 1='meppen3.dnpa.nl'] at /usr/share/MailScanner//MailScanner/ConfigSQL.pm line 134. DBD::mysql::st execute failed: Table 'baruwa.scanner_config' doesn't exist [for Statement "SELECT value FROM scanner_config, scanners WHERE scanner_config.host_id = scanners.id AND external = ? AND scanners.address = ?" with ParamValues: 0='mailscannerversionnumber', 1='meppen3.dnpa.nl'] at /usr/share/MailScanner//MailScanner/ConfigSQL.pm line 134. 2011/10/23 Dave Jones <[email protected]> > > > On Sun, Oct 23, 2011 at 10:06 AM, Andrew Colin Kissa <[email protected] > > wrote: > >> >> On 23 Oct 2011, at 5:02 PM, Dave Jones wrote: >> >> > Reading configuration file /etc/MailScanner/MailScanner.conf >> > Reading configuration file /etc/MailScanner/conf.d/baruwa.conf >> > Reading ruleset htmlsigs for keyword inlinehtmlsig >> > Can't use an undefined value as an ARRAY reference at >> /usr/share/MailScanner/MailScanner/Config.pm line 2588, <DATA> line 500. >> > >> > When I comment these, they should use the values in the MailScanner.conf >> so they should be defined as empty values. >> >> If you comment out the SQL you need to comment out the other values that >> use the sql rulesets as indicated by hans >> >> # Inline HTML Signature = htmlsigs.customize >> # Inline Text Signature = textsigs.customize >> # Signature Image Filename = sigimgfiles.customize >> # Signature Image <img> Filename = sigimgs.customize >> >> Commented those 4 lines above and MailScanner --lint is clean but I still > can't get any mail to pass through MailScanner. I have disabled the postfix > header_checks so mail will continue to flow. This baruwa instance is mainly > for reporting purposes and doesn't do any spam scanning. It's an internal > mail relay for outbound delivery and not receiving from the Internet. > > I will continue testing with MailScanner --debug in a few hours since I > need to go out for a while. > > Thanks for everyone's help. > > -- >> Baruwa - www.baruwa.org >> >> _______________________________________________ >> Keep Baruwa FREE - http://pledgie.com/campaigns/12056 >> > > > _______________________________________________ > Keep Baruwa FREE - http://pledgie.com/campaigns/12056 > >
_______________________________________________ Keep Baruwa FREE - http://pledgie.com/campaigns/12056
