Firebird is working.
Jul-18-12 14:02:18 [init] Using table <whitelist> in Firebird
Database <assp> instead of file c:/assp/whitelist
Jul-18-12 14:02:18 [init] Using table <redlist> in Firebird
Database <assp> instead of file c:/assp/redlist
Jul-18-12 14:02:18 [init] Using table <delaydb> in Firebird
Database <assp> instead of file c:/assp/delaydb
Jul-18-12 14:02:18 [init] Using table <delaywhitedb> in Firebird
Database <assp> instead of file c:/assp/delaydb.white
Jul-18-12 14:02:18 [init] Using table <PBWhite> in Firebird
Database <assp> instead of file c:/assp/pb/pbdb.white.db
Jul-18-12 14:02:18 [init] Using table <PBBlack> in Firebird
Database <assp> instead of file c:/assp/pb/pbdb.black.db
Jul-18-12 14:02:18 [init] Using table <RBLCache> in Firebird
Database <assp> instead of file c:/assp/pb/pbdb.rbl.db
Jul-18-12 14:02:18 [init] Using table <URIBLCache> in Firebird
Database <assp> instead of file c:/assp/pb/pbdb.uribl.db
Jul-18-12 14:02:18 [init] Using table <PTRCache> in Firebird
Database <assp> instead of file c:/assp/pb/pbdb.ptr.db
Jul-18-12 14:02:18 [init] Using table <MXACache> in Firebird
Database <assp> instead of file c:/assp/pb/pbdb.mxa.db
Jul-18-12 14:02:18 [init] Using table <RWLCache> in Firebird
Database <assp> instead of file c:/assp/pb/pbdb.rwl.db
Jul-18-12 14:02:18 [init] Using table <SPFCache> in Firebird
Database <assp> instead of file c:/assp/pb/pbdb.spf.db
Jul-18-12 14:02:18 [init] Using table <SBCache> in Firebird
Database <assp> instead of file c:/assp/pb/pbdb.sb.db
Jul-18-12 14:02:18 [init] Using table <PBTrap> in Firebird
Database <assp> instead of file c:/assp/pb/pbdb.trap.db
Jul-18-12 14:02:18 [init] Using table <DKIMCache> in Firebird
Database <assp> instead of file c:/assp/pb/pbdb.dkim.db
Jul-18-12 14:02:18 [init] Using table <BATVTag> in Firebird
Database <assp> instead of file c:/assp/pb/pbdb.batv.db
Jul-18-12 14:02:18 [init] Using table <BackDNS> in Firebird
Database <assp> instead of file c:/assp/pb/pbdb.back.db
Jul-18-12 14:02:18 [init] Using table <spamdb> in Firebird
Database <assp> instead of file c:/assp/spamdb
Jul-18-12 14:02:18 [init] Using table <spamdbhelo> in Firebird
Database <assp> instead of file c:/assp/spamdb.helo
Jul-18-12 14:02:18 [init] Using table <ldaplist> in Firebird
Database <assp> instead of file c:/assp/ldaplist
Jul-18-12 14:02:18 [init] Info: adminusersdb (c:/assp/adminusers) - loaded
Jul-18-12 14:02:18 [init] Info: adminusersdb (c:/assp/adminusers.right) -
loaded
Jul-18-12 14:02:18 [init] Start analyze spamdb
Jul-18-12 14:02:20 [init] Spamdb has 234541 records
Jul-18-12 14:02:20 [init] Start analyze whitelist
Jul-18-12 14:02:20 [init] Whitelist has 0 records
Jul-18-12 14:02:20 [init] Warning: whitelist has only 0 records: (ignore
if this is a new install)
NET-SNMP version 5.6 AgentX subagent connected
Jul-18-12 14:02:20 [init] Info: saving Stats in file asspstats.sav
Jul-18-12 14:02:20 [init] Info: (re)scheduled SaveStatsEvery ->
NextSaveStats for Jul-18-12 14:32:20
Jul-18-12 14:02:20 [init] Info: saving Stats in file asspstats.sav
Jul-18-12 14:02:20 [init] Info: (re)scheduled SaveStatsEvery ->
NextSaveStats for Jul-18-12 14:32:20
Jul-18-12 14:02:20 [init] Info: saving Stats in file asspstats.sav
Jul-18-12 14:02:20 [init] Info: (re)scheduled SaveStatsEvery ->
NextSaveStats for Jul-18-12 14:32:20
Jul-18-12 14:02:22 [init] Info: initalized SNMP OIDs
Jul-18-12 14:02:22 [init] Info: saving Stats in file asspstats.sav
Jul-18-12 14:02:22 [init] Info: (re)scheduled SaveStatsEvery ->
NextSaveStats for Jul-18-12 14:32:22
Jul-18-12 14:02:22 [init] Info: SNMP read application OIDs .1.0 - .1.36
Jul-18-12 14:02:22 [init] Info: SNMP read worker status OIDs .1.30.1 -
1.30.10001.2
Jul-18-12 14:02:22 [init] Info: SNMP read database status OIDs .1.31.0 -
.1.31.23
Jul-18-12 14:02:22 [init] Info: SNMP read regular expression status OID
.1.32.0
Jul-18-12 14:02:22 [init] Info: SNMP read configuration OIDs .2.0 -
.2.45.14006.4
Jul-18-12 14:02:22 [init] Info: SNMP read perl module configuration OIDs
.3.0.0 - 3.59.4
Jul-18-12 14:02:22 [init] Info: SNMP read Stats
Jul-18-12 14:02:22 [init] Info: SNMP read Stat OIDs .4.1.1.0 - .4.4.109.2
Jul-18-12 14:02:22 [init] Info: SNMP registered API OIDs .5.0.0 - 5.1.0
Jul-18-12 14:02:22 [init] Info: SNMP registered 8465 OIDs from
asspSNMP.1.0.0 to asspSNMP.5.1.0
Jul-18-12 14:02:23 [init] Listening for SMTP connections on 0.0.0.0:25
[::]:25
Jul-18-12 14:02:24 [init] Listening for SMTPS (SSL) connections on
0.0.0.0:456 [::]:456
Jul-18-12 14:02:24 [init] Listening for admin HTTP connections on
0.0.0.0:55555 [::]:55555
Jul-18-12 14:02:24 [init] Listening for stat HTTPS connections on
0.0.0.0:55553 [::]:55553
Jul-18-12 14:02:24 [init] Listening for additional SMTP connections on
0.0.0.0:555 [::]:555
Jul-18-12 14:02:24 [init] Listening for SMTP relay connections on
0.0.0.0:625 [::]:625
Jul-18-12 14:02:24 [init] Starting PID: 1356
Thomas
Von: "Daniel L. Miller" <dmil...@amfes.com>
An: assp-test@lists.sourceforge.net,
Datum: 16.07.2012 20:31
Betreff: Re: [Assp-test] fixes in assp 2.2.2 build 12196:
On 7/14/2012 11:25 AM, Thomas Eckardt wrote:
> Hi all,
>
> fixed in assp 2.2.2 build 12196:
>
> - ASSP is now able to handle the different and buggy versions of
> Win32::Unicode
> all version from 0.33 to 0.36 will be ignored and all unicode
features
> will be disabled
>
> changed:
>
> - The Firebird is now supported (not recommended) by assp. To use this
> database, the new released
> file assp_db_import.cfg has to be used or the following line must be
> added to this file.
>
> Firebird|*|NOOP|NOOP|$sql_sm="execute block as begin UPDATE OR INSERT
INTO
> $mysqlTable VALUES "|$sql_sm="($k,$v,0);"|$sql_sm="UPDATE OR INSERT INTO
> $mysqlTable VALUES "|80|$sql_sm=" end"
>
Trying to use Firebird - I get the following:
Jul-16-12 11:21:49 [init] Starting maintenance worker thread [10000] -
ThreadCycleTime is set to 3000 microseconds
Jul-16-12 11:21:50 [Worker_10000] Whitelist database error: Can't
initialize data table: This operation is not defined for system tables.
-unsuccessful metadata update
-Table WHITELIST already exists at sub main::initDBHashes line
43 thread 1
Jul-16-12 11:21:50 [Worker_10000] Worker_10000 started
Jul-16-12 11:21:50 [Worker_10000] Info: watching the running script
'/opt/assp2/assp.pl' for changes
Jul-16-12 11:21:50 [Worker_10000] Uploading stats via direct connection
Jul-16-12 11:21:50 [init] Starting rebuild SpamDB worker thread [10001]
- ThreadCycleTime is set to 30 microseconds
Jul-16-12 11:21:50 [Worker_10001] Worker_10001 started
Jul-16-12 11:21:50 [Worker_10001] Info: found module
/opt/assp2/lib/rebuildspamdb.pm version 5.07
Jul-16-12 11:21:50 [init] Starting SMTP-worker-threads with
ThreadCycleTime set to 3000 microseconds
Jul-16-12 11:21:50 [init] Starting communication worker threads [1 to 3]
Jul-16-12 11:21:51 [Worker_1] Whitelist database error: Can't initialize
data table: This operation is not defined for system tables.
-unsuccessful metadata update
-Table WHITELIST already exists at sub main::initDBHashes line
43 thread 3
Jul-16-12 11:21:51 [Worker_1] Worker_1 started
Jul-16-12 11:21:51 [Worker_10000] Downloading griplist.conf via direct
HTTP connection
Jul-16-12 11:21:51 [Worker_2] Whitelist database error: Can't initialize
data table: This operation is not defined for system tables.
-unsuccessful metadata update
-Table WHITELIST already exists at sub main::initDBHashes line
43 thread 4
Jul-16-12 11:21:51 [Worker_2] Worker_2 started
Jul-16-12 11:21:52 [Worker_3] Whitelist database error: Can't initialize
data table: This operation is not defined for system tables.
-unsuccessful metadata update
-Table WHITELIST already exists at sub main::initDBHashes line
43 thread 5
Jul-16-12 11:21:52 [Worker_3] Worker_3 started
Jul-16-12 11:21:54 [init] All Threads are started
Jul-16-12 11:21:54 [init] Try using Firebird database
</var/lib/firebird/2.5/data/assp.fdb> for selected tables
Jul-16-12 11:21:54 [init] Info: list Griplist is using 'BerkeleyDB'
version 5.1 - cachesize is 648.0kB
Jul-16-12 11:21:54 [init] Whitelist database error: Can't initialize
data table: This operation is not defined for system tables.
-unsuccessful metadata update
-Table WHITELIST already exists at sub main::initDBHashes line 43
Jul-16-12 11:21:54 [init] Warning: can not use defined database -
switching over to use files instead of database
/var/lib/firebird/2.5/data/assp.fdb!
Jul-16-12 11:21:54 [init] Error : DB-failover loading hashes from files
Jul-16-12 11:21:54 [init] Warning : setting configvalue for adminusersdb
to adminusers
Jul-16-12 11:21:54 [init] Warning : setting configvalue for adminusersdb
to adminusers
Jul-16-12 11:21:54 [init] Info: adminusersdb (/opt/assp2/) - loaded
Jul-16-12 11:21:54 [init] Info: adminusersdb (/opt/assp2/.right) - loaded
Jul-16-12 11:21:54 [init] Error: COUNT: Can't call method "_prepare" on
unblessed reference at sub main::rdbm_COUNT line 8.
-
Jul-16-12 11:21:54 [init] Warning: Bayesian spam database has only 0
records
Jul-16-12 11:21:54 [init] Error: COUNT: Can't call method "_prepare" on
unblessed reference at sub main::rdbm_COUNT line 8.
-
Jul-16-12 11:21:54 [init] Warning: whitelist has only 0 records: (ignore
if this is a new install)
--
Daniel
------------------------------------------------------------------------------
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and
threat landscape has changed and how IT managers can respond. Discussions
will include endpoint security, mobile security and the latest in malware
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
_______________________________________________
Assp-test mailing list
Assp-test@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/assp-test
DISCLAIMER:
*******************************************************
This email and any files transmitted with it may be confidential, legally
privileged and protected in law and are intended solely for the use of the
individual to whom it is addressed.
This email was multiple times scanned for viruses. There should be no
known virus in this email!
*******************************************************
------------------------------------------------------------------------------
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and
threat landscape has changed and how IT managers can respond. Discussions
will include endpoint security, mobile security and the latest in malware
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
_______________________________________________
Assp-test mailing list
Assp-test@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/assp-test
