>you could change any field
that uses file:files/*.txt to DB: and then it will use the Database
configuration for that config parameter.
THIS IS WRONG !
>I can't find where I read this now
It was never written.
>Did I read something incorrectly here?
YES
>Can we use DB: for things like
noProcessingIPs,noProcessing,noProcessingFrom?
NO
All parameters that could be changed/set to 'DB:', shows this in the GUI
description!
The hint to 'persblackdb' is missing in the description of 'importDBDir' -
sorry!
Thomas
Von: jg00d3 <sysadmr...@gmail.com>
An: assp-user@lists.sourceforge.net,
Datum: 27.12.2013 20:59
Betreff: [Assp-user] mySQL data import
We've been running ASSP for several years and our production box is
V1.9.0.
We have setup a new server and have V2.3.3 configured and have mySQL setup
and appears to be configured proplerly and we are almost ready to switch
over. Our goal is to have 2 ASSP servers running and have as many entries
in the assp.cfg use DB: (our mySQL server) as possible.
I was able to configure the following and then used the .add after the
import filename to get them to import into the database:
- pbdb.back.db.(add|rpl)
- pbdb.batv.db.(add|rpl)
- pbdb.black.db.(add|rpl)
- pbdb.dkim.db.(add|rpl)
- pbdb.mxa.db.(add|rpl)
- pbdb.ptr.db(add|rpl)
- pbdb.rbl.db.(add|rpl)
- pbdb.rwl.db.(add|rpl)
- pbdb.sb.db.(add|rpl)
- pbdb.spf.db.(add|rpl)
- pbdb.trap.db.(add|rpl)
- pbdb.uribl.db.(add|rpl)
- pbdb.white.db.(add|rpl)
- ldaplist.(add|rpl)
- redlist.(add|rpl)
- whitelist.(add|rpl)
- spamdb.(add|rpl)
- spamdb.helo.(add|rpl)
- delaydb.(add|rpl)
- delaydb.white.(add|rpl)
- adminusers.(add|rpl)
- adminusersright.(add|rpl)
I read on a post/thread somewhere that as of like V2.2 (I can't find where
I
read this now, so the version is probably wrong) you could change any
field
that uses file:files/*.txt to DB: and then it will use the Database
configuration for that config parameter.
I've modified a few of them changing them from file:files/ to DB: and them
moved the file that used to be listed in that config parameter to the
dbimport directory and removed the .txt and replaced with .add. Restarted
the ASSP services and it doesn't change the file name to .OK and there is
no
new table created in the mySQL database.
I've also notice that when I change the config parameter to DB: and then
apply changes that a new file is created in the ASSP\Files\optRE folder
with
the corrosponding config parameter name.txt.
Did I read something incorrectly here?
Can we use DB: for things like
noProcessingIPs,noProcessing,noProcessingFrom?
Is there a specific filename that should be used for the .add file that
goes
into the dbimport folder for each of these config parameters?
If I click on edit list for like the noProcessing the file editor comes up
and is blank. I'm not sure how to manually add info into the file editor
box. It asks for it to be formatted as key|::|value, but I am unsure how
to
add that for values like what noProcessing accepts. Would it be
u...@domain.com|::| ?
I've added some data into the file editor and saved, but I can't determine
where that info is being save.
Thanks in advance for your help with this. We are really excited to move
to
V2, but I want to make sure I don't blow anything up.
JMG
--
View this message in context:
http://anti-spam-smtp-proxy-server.996265.n3.nabble.com/mySQL-data-import-tp37939.html
Sent from the assp-user mailing list archive at Nabble.com.
------------------------------------------------------------------------------
Rapidly troubleshoot problems before they affect your business. Most IT
organizations don't have a clear picture of how application performance
affects their revenue. With AppDynamics, you get 100% visibility into your
Java,.NET, & PHP application. Start your 15-day FREE TRIAL of AppDynamics
Pro!
http://pubads.g.doubleclick.net/gampad/clk?id=84349831&iu=/4140/ostg.clktrk
_______________________________________________
Assp-user mailing list
Assp-user@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/assp-user
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!
*******************************************************
------------------------------------------------------------------------------
Rapidly troubleshoot problems before they affect your business. Most IT
organizations don't have a clear picture of how application performance
affects their revenue. With AppDynamics, you get 100% visibility into your
Java,.NET, & PHP application. Start your 15-day FREE TRIAL of AppDynamics Pro!
http://pubads.g.doubleclick.net/gampad/clk?id=84349831&iu=/4140/ostg.clktrk
_______________________________________________
Assp-user mailing list
Assp-user@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/assp-user
