Thanks, I have all the prerequisites and I am not getting the messages
your saying. Its like I is not even there for MySql. 

 

Mar-18-08 11:03:09 ASSP version 1.3.6(6.12) (Perl 5.008008) initializing


Mar-18-08 11:03:09 File::Scan::ClamAV module version 1.8 installed and
available

Mar-18-08 11:03:09 ASSP running on server: MAINE (127.0.0.1)

Mar-18-08 11:03:09 Net::LDAP module version 0.34 installed and available

Mar-18-08 11:03:09 Net::DNS module version 0.63 installed and available

Mar-18-08 11:03:09 Email::Valid module version 0.179 installed and
available

Mar-18-08 11:03:09 Mail::SPF::Query module version 1.999001 installed
and available

Mar-18-08 11:03:09 Mail::SPF module version 2.005 installed and
available

Mar-18-08 11:03:09 Mail::SRS module version 0.31 installed - Sender
Rewriting Scheme available

Mar-18-08 11:03:09 Compress::Zlib module version 2.008 installed - HTTP
compression available

Mar-18-08 11:03:09 Digest::MD5 module version 2.36 installed - delaying
can use MD5 keys for

                   hashes

Mar-18-08 11:03:09 File::ReadBackwards module version 1.04 installed -
searching of log files

                   enabled

Mar-18-08 11:03:09 Time::HiRes module version 1.86 installed - CPU usage
statistics available

Mar-18-08 11:03:09 Sys::Syslog module version 0.13 installed - Unix
centralized logging enabled

Mar-18-08 11:03:09 Net::Syslog module version 0.03 installed - network
Syslog logging enabled

Mar-18-08 11:03:09 Tie::RDBM module version 0.70 installed - database
usage available

Mar-18-08 11:03:09 Net::IP::Match::Regexp module version 1.00 installed
- CIDR notation for IP range

                   available

Mar-18-08 11:03:09 Net::CIDR::Lite module version 0.20 installed -
hyphenated IP address range

                   available

Mar-18-08 11:03:09 Net::SenderBase module version 1.01 installed - Query
the senderbase service

                   available

Mar-18-08 11:03:09 LWP::Simple module version 1.41 installed -
procedural LWP interface available

Mar-18-08 11:03:09 Email::MIME::Modifier module version 1.442 installed
- MIME charset conversion

                   interface available

Mar-18-08 11:03:09 MIME::Types module version 1.23 installed - TNEF
conversion may possible

Mar-18-08 11:03:09 Convert::TNEF module version 0.17 installed - TNEF
conversion is available

Mar-18-08 11:03:09 Mail::DKIM::Verifier module version 0.30 installed -
DKIM verification is

                   available

Mar-18-08 11:03:10 Mail::SpamAssassin module version 3.002004 installed
- SpamAssassin is available

Mar-18-08 11:03:10 Listening for SMTP connections on 172.16.0.4:25

Mar-18-08 11:03:10 Listening for admin HTTP connections on 55555

Mar-18-08 11:03:10 Listening for stat HTTP connections on 55554

Mar-18-08 11:03:10 Starting PID: 20055

 

 

From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Thomas
Eckardt/eck
Sent: Tuesday, March 18, 2008 2:16 AM
To: ASSP development mailing list
Subject: [Assp-test] Antwort: Re: SQL setup ?

 

1. Install Tie::RDBM  and  the perl DBI driver for your DB

2. you need the file  assp_db_import.cfg in your assp base directory

3. create the DB (tablesace / schema / ....) depends on the DB-type

5. create a DB-user with full rights to this DB (minimum is
create/alter/delete table)

6. go to ASSP-web configuration section <File Path and Database>

7. configure the db <myhost> <DBdriver> (the available are shown in help
text) <mydb> <myuser> <mypassword>

8. configure any of the following ASSP-options of your choice to the
value  DB:  (case sensitive!!!!)

spamdb

whitelistdb

redlistdb

delaydb

ldaplistdb

pbdb  (in section penalty box)

 

9. stop and start ASSP

 

 

you should see the following messages on ASSP start:

 

Mar-18-08 08:20:15 Tie::RDBM module version 0.70 installed - database
usage available

.....

Mar-18-08 08:20:16 Try using mysql database <your dbname> for selected
tables

 

(the name of my DB is  assp)

 

Mar-18-08 08:20:18 Using table <whitelist>      in mysql Database <assp>
instead of file c:\assp/whitelist
Mar-18-08 08:20:18 Using table <redlist>        in mysql Database <assp>
instead of file c:\assp/redlist
Mar-18-08 08:20:18 Using table <delaydb>        in mysql Database <assp>
instead of file c:\assp/delaydb
Mar-18-08 08:20:18 Using table <delaywhitedb>   in mysql Database <assp>
instead of file c:\assp/delaydb.white
Mar-18-08 08:20:19 Using table <PBWhite>        in mysql Database <assp>
instead of file c:\assp/pb/pbdb.white.db
Mar-18-08 08:20:19 Using table <PBBlack>        in mysql Database <assp>
instead of file c:\assp/pb/pbdb.black.db
Mar-18-08 08:20:19 Using table <RBLCache>       in mysql Database <assp>
instead of file c:\assp/pb/pbdb.rbl.db
Mar-18-08 08:20:19 Using table <URIBLCache>     in mysql Database <assp>
instead of file c:\assp/pb/pbdb.uribl.db
Mar-18-08 08:20:20 Using table <PTRCache>       in mysql Database <assp>
instead of file c:\assp/pb/pbdb.ptr.db
Mar-18-08 08:20:20 Using table <MXACache>       in mysql Database <assp>
instead of file c:\assp/pb/pbdb.mxa.db
Mar-18-08 08:20:20 Using table <RWLCache>       in mysql Database <assp>
instead of file c:\assp/pb/pbdb.rwl..db
Mar-18-08 08:20:21 Using table <SPFCache>       in mysql Database <assp>
instead of file c:\assp/pb/pbdb.spf.db
Mar-18-08 08:20:21 Using table <SBCache>        in mysql Database <assp>
instead of file c:\assp/pb/pbdb.sb.db
Mar-18-08 08:20:21 Using table <PBTrap>         in mysql Database <assp>
instead of file c:\assp/pb/pbdb.trap.db
Mar-18-08 08:20:21 Using table <spamdb>         in mysql Database <assp>
instead of file c:\assp/spamdb
Mar-18-08 08:20:21 Using table <spamdbhelo>     in mysql Database <assp>
instead of file c:\assp/spamdb.helo
Mar-18-08 08:20:22 Using table <ldaplist>       in mysql Database <assp>
instead of file c:\assp/ldaplist

 

Thomas

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!

-------------------------------------------------------------------------
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2008.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
_______________________________________________
Assp-test mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/assp-test

Reply via email to