[Assp-test] Antwort: Re: Antwort: Re: SQL setup ?

Tue, 18 Mar 2008 10:48:14 -0700

There are two possible reasons (for you) that the following message is not shown at ASSP startup:
 
....... Try using mysql database <your dbname> for selected tables
 
1. There is no mysql DBI driver in your installation - (all available drivers are shown in WebConfig < DBdriver>
2.. There is no DB usage configured for any possible list (whitedb, delaydb .....) - you have to set them to  DB:   !!!!!
 
this is the important cfg-part for DB usage!
.....
spamdb:=DB:
whitelistdb:=DB:
redlistdb:=DB:
griplist:=griplist
delaydb:=DB:
ldaplistdb:=DB:
myhost:=localhost
DBdriver:=mysql
mydb:=assp
mysqlSlaveMode:=
myuser:=root
mypassword:=*******
importDBDir:=mysql/dbimport
ImportMysqlDB:=
exportDBDir:=mysql/dbexport
ExportMysqlDB:=
backupDBDir:=mysql/dbbackup
.....
 
Thomas
[EMAIL PROTECTED] schrieb: -----

An: "ASSP development mailing list" <[email protected]>
Von: "Daniel K. Du Vall" <[EMAIL PROTECTED]>
Gesendet von: [EMAIL PROTECTED]
Datum: 18.03.2008 18:14
Thema: Re: [Assp-test] Antwort: Re: SQL setup ?

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.04: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

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