Question I have two cron jobs that run the rebuildspamdb.sh
<https://172.16.0.4:10000/cron/edit_cron.cgi?idx=6> is it necessary to
run both now for each assp or only one for the main ASSP now that I am
using Mysql?
Daniel Du Vall
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Daniel K.
Du Vall
Sent: Tuesday, March 18, 2008 12:50 PM
To: ASSP development mailing list
Subject: Re: [Assp-test] Antwort: Re: Antwort: Re: SQL setup ?
Thanks for sticking with me on this it is now working.
I over looked the DB: (DUH)
Any how its working and All I have to do is get the other assp that I am
ruing to share the Database.
Thanks Much!
Daniel Du Vall
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Thomas
Eckardt/eck
Sent: Tuesday, March 18, 2008 11:48 AM
To: ASSP development mailing list
Subject: [Assp-test] Antwort: Re: Antwort: Re: SQL setup ?
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
