aha ok, so i am at home now, i will send you that info tomorow morrnig. <br>Milenko Letic<br><br><div class="gmail_quote">2012/4/5 Tomáš Kurinec <span dir="ltr"><<a href="mailto:tomb.stoney@gmail.com">tomb.stoney@gmail.com</a>></span><br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">Thank you. It looks like mailwatch table structures, am I right? I<br>
have mailwatch fully functional, but in mailscanner.conf there is:<br>
# This should be a valid SQL statement that has a single placeholder argument<br>
# and must return two columns and one or more rows. The first column must be<br>
# a numeric starting at 1 and in ascending order and the second column should<br>
# be the rule string. The placeholder will contain the ruleset name.<br>
#<br>
# Example: SQL Ruleset = SELECT num, rule FROM ruleset WHERE<br>
rulesetname=? ORDER BY num ASC<br>
<br>
So it's saying that you need num and rule columns and rulesetname as<br>
placeholder. What do you have in SQL Ruleset = ? Or do you use just<br>
mailwatch without setting this? If yes, than this is not what I was<br>
loooking for, but thank you very much for the effort.<br>
<br>
Tom<br>
<br>
Dňa 5. apríla 2012 16:38, Milenko Letic <<a href="mailto:mikoletic@gmail.com">mikoletic@gmail.com</a>> napísal/a:<br>
<div class="HOEnZb"><div class="h5">> this is structure on my server:<br>
> Tables_in_mailscanner |<br>
><br>
><br>
> +-----------------------+<br>
><br>
><br>
> | audit_log |<br>
><br>
><br>
> | blacklist |<br>
><br>
><br>
> | geoip_country |<br>
><br>
><br>
> | inq |<br>
><br>
><br>
> | maillog |<br>
> | mcp_rules |<br>
> | mtalog |<br>
> | outq |<br>
> | sa_rules |<br>
> | saved_filters |<br>
> | spamscores |<br>
> | user_filters |<br>
> | users |<br>
> | whitelist<br>
> and tables look like this:<br>
> describe audit_log;<br>
> +------------+-------------+------+-----+-------------------+-----------------------------+<br>
> | Field | Type | Null | Key | Default | Extra<br>
> |<br>
> +------------+-------------+------+-----+-------------------+-----------------------------+<br>
> | timestamp | timestamp | NO | | CURRENT_TIMESTAMP | on update<br>
> CURRENT_TIMESTAMP |<br>
> | user | varchar(20) | NO | | |<br>
> |<br>
> | ip_address | varchar(15) | NO | | |<br>
> |<br>
> | action | text | NO | | NULL |<br>
> |<br>
> +------------+-------------+------+-----+-------------------+-----------------------------+<br>
> 4 rows in set (0.08 sec)<br>
> describe blacklist;<br>
> +--------------+---------+------+-----+---------+----------------+<br>
> | Field | Type | Null | Key | Default | Extra |<br>
> +--------------+---------+------+-----+---------+----------------+<br>
> | id | int(11) | NO | PRI | NULL | auto_increment |<br>
> | to_address | text | YES | MUL | NULL | |<br>
> | to_domain | text | YES | | NULL | |<br>
> | from_address | text | YES | | NULL | |<br>
> +--------------+---------+------+-----+---------+----------------+<br>
> 4 rows in set (0.00 sec)<br>
> describe geoip_country;<br>
> +------------------+-------------+------+-----+---------+-------+<br>
> | Field | Type | Null | Key | Default | Extra |<br>
> +------------------+-------------+------+-----+---------+-------+<br>
> | begin_ip | varchar(15) | YES | | NULL | |<br>
> | end_ip | varchar(15) | YES | | NULL | |<br>
> | begin_num | bigint(20) | YES | MUL | NULL | |<br>
> | end_num | bigint(20) | YES | MUL | NULL | |<br>
> | iso_country_code | char(2) | YES | | NULL | |<br>
> | country | text | YES | | NULL | |<br>
> +------------------+-------------+------+-----+---------+-------+<br>
> 6 rows in set (0.00 sec)<br>
> describe inq;<br>
> +--------------+------+------+-----+---------+-------+<br>
> | Field | Type | Null | Key | Default | Extra |<br>
> +--------------+------+------+-----+---------+-------+<br>
> | id | text | YES | | NULL | |<br>
> | cdate | date | YES | | NULL | |<br>
> | ctime | time | YES | | NULL | |<br>
> | from_address | text | YES | | NULL | |<br>
> | to_address | text | YES | | NULL | |<br>
> | subject | text | YES | | NULL | |<br>
> | message | text | YES | | NULL | |<br>
> | size | text | YES | | NULL | |<br>
> | priority | text | YES | | NULL | |<br>
> | attempts | text | YES | | NULL | |<br>
> | lastattempt | text | YES | | NULL | |<br>
> | hostname | text | YES | MUL | NULL | |<br>
> +--------------+------+------+-----+---------+-------+<br>
> 12 rows in set (0.00 sec)<br>
> describe maillog;<br>
> +-----------------+--------------+------+-----+-------------------+-----------------------------+<br>
> | Field | Type | Null | Key | Default | Extra<br>
> |<br>
> +-----------------+--------------+------+-----+-------------------+-----------------------------+<br>
> | timestamp | timestamp | NO | | CURRENT_TIMESTAMP | on<br>
> update CURRENT_TIMESTAMP |<br>
> | id | text | YES | MUL | NULL |<br>
> |<br>
> | size | bigint(20) | YES | | 0 |<br>
> |<br>
> | from_address | text | YES | MUL | NULL |<br>
> |<br>
> | from_domain | text | YES | MUL | NULL |<br>
> |<br>
> | to_address | text | YES | MUL | NULL |<br>
> |<br>
> | to_domain | text | YES | MUL | NULL |<br>
> |<br>
> | subject | text | YES | | NULL |<br>
> |<br>
> | clientip | text | YES | MUL | NULL |<br>
> |<br>
> | archive | text | YES | | NULL |<br>
> |<br>
> | isspam | tinyint(1) | YES | | 0 |<br>
> |<br>
> | ishighspam | tinyint(1) | YES | | 0 |<br>
> |<br>
> | issaspam | tinyint(1) | YES | | 0 |<br>
> |<br>
> | isrblspam | tinyint(1) | YES | | 0 |<br>
> |<br>
> | isfp | tinyint(1) | YES | | 0 |<br>
> |<br>
> | isfn | tinyint(1) | YES | | 0 |<br>
> |<br>
> | spamwhitelisted | tinyint(1) | YES | | 0 |<br>
> |<br>
> | spamblacklisted | tinyint(1) | YES | | 0 |<br>
> |<br>
> | sascore | decimal(7,2) | YES | | 0.00 |<br>
> |<br>
> | spamreport | text | YES | | NULL |<br>
> |<br>
> | virusinfected | tinyint(1) | YES | | 0 |<br>
> |<br>
> | nameinfected | tinyint(1) | YES | | 0 |<br>
> |<br>
> | otherinfected | tinyint(1) | YES | | 0 |<br>
> |<br>
> | report | text | YES | | NULL |<br>
> |<br>
> | ismcp | tinyint(1) | YES | | 0 |<br>
> |<br>
> | ishighmcp | tinyint(1) | YES | | 0 |<br>
> |<br>
> | issamcp | tinyint(1) | YES | | 0 |<br>
> |<br>
> | mcpwhitelisted | tinyint(1) | YES | | 0 |<br>
> |<br>
> | mcpblacklisted | tinyint(1) | YES | | 0 |<br>
> |<br>
> | mcpsascore | decimal(7,2) | YES | | 0.00 |<br>
> |<br>
> | mcpreport | text | YES | | NULL |<br>
> |<br>
> | hostname | text | YES | MUL | NULL |<br>
> |<br>
> | date | date | YES | MUL | NULL |<br>
> |<br>
> | time | time | YES | | NULL |<br>
> |<br>
> | headers | text | YES | | NULL |<br>
> |<br>
> | quarantined | tinyint(1) | YES | MUL | 0 |<br>
> |<br>
> +-----------------+--------------+------+-----+-------------------+-----------------------------+<br>
> 36 rows in set (0.01 sec)<br>
> describe mtalog;<br>
> +-----------+-------------+------+-----+---------+-------+<br>
> | Field | Type | Null | Key | Default | Extra |<br>
> +-----------+-------------+------+-----+---------+-------+<br>
> | timestamp | datetime | YES | MUL | NULL | |<br>
> | host | text | YES | | NULL | |<br>
> | type | text | YES | MUL | NULL | |<br>
> | msg_id | varchar(20) | YES | | NULL | |<br>
> | relay | text | YES | | NULL | |<br>
> | dsn | text | YES | | NULL | |<br>
> | status | text | YES | | NULL | |<br>
> | delay | time | YES | | NULL | |<br>
> +-----------+-------------+------+-----+---------+-------+<br>
> 8 rows in set (0.00 sec)<br>
><br>
> describe mcp_rules<br>
> -> ;<br>
> +-----------+-----------+------+-----+---------+-------+<br>
> | Field | Type | Null | Key | Default | Extra |<br>
> +-----------+-----------+------+-----+---------+-------+<br>
> | rule | char(100) | NO | PRI | | |<br>
> | rule_desc | char(200) | NO | | | |<br>
> +-----------+-----------+------+-----+---------+-------+<br>
> 2 rows in set (0.00 sec)<br>
>> describe outq;<br>
> +--------------+------+------+-----+---------+-------+<br>
> | Field | Type | Null | Key | Default | Extra |<br>
> +--------------+------+------+-----+---------+-------+<br>
> | id | text | YES | | NULL | |<br>
> | cdate | date | YES | | NULL | |<br>
> | ctime | time | YES | | NULL | |<br>
> | from_address | text | YES | | NULL | |<br>
> | to_address | text | YES | | NULL | |<br>
> | subject | text | YES | | NULL | |<br>
> | message | text | YES | | NULL | |<br>
> | size | text | YES | | NULL | |<br>
> | priority | text | YES | | NULL | |<br>
> | attempts | text | YES | | NULL | |<br>
> | lastattempt | text | YES | | NULL | |<br>
> | hostname | text | YES | MUL | NULL | |<br>
> +--------------+------+------+-----+---------+-------+<br>
> 12 rows in set (0.00 sec)<br>
> describe sa_rules;<br>
> +-----------+--------------+------+-----+---------+-------+<br>
> | Field | Type | Null | Key | Default | Extra |<br>
> +-----------+--------------+------+-----+---------+-------+<br>
> | rule | varchar(100) | NO | PRI | | |<br>
> | rule_desc | varchar(200) | NO | | | |<br>
> +-----------+--------------+------+-----+---------+-------+<br>
> 2 rows in set (0.00 sec)<br>
> describe saved_filters;<br>
> +----------+------+------+-----+---------+-------+<br>
> | Field | Type | Null | Key | Default | Extra |<br>
> +----------+------+------+-----+---------+-------+<br>
> | name | text | NO | MUL | NULL | |<br>
> | col | text | NO | | NULL | |<br>
> | operator | text | NO | | NULL | |<br>
> | value | text | NO | | NULL | |<br>
> | username | text | NO | | NULL | |<br>
> +----------+------+------+-----+---------+-------+<br>
> 5 rows in set (0.00 sec)<br>
> describe spamscore;<br>
> ERROR 1146 (42S02): Table 'mailscanner.spamscore' doesn't exist<br>
> mysql> describe spamscores;<br>
> +---------------+---------------+------+-----+---------+-------+<br>
> | Field | Type | Null | Key | Default | Extra |<br>
> +---------------+---------------+------+-----+---------+-------+<br>
> | user | varchar(40) | NO | PRI | | |<br>
> | lowspamscore | decimal(10,0) | NO | | 0 | |<br>
> | highspamscore | decimal(10,0) | NO | | 0 | |<br>
> +---------------+---------------+------+-----+---------+-------+<br>
> 3 rows in set (0.00 sec)<br>
> describe user_filters;<br>
> +------------+---------------+------+-----+---------+-------+<br>
> | Field | Type | Null | Key | Default | Extra |<br>
> +------------+---------------+------+-----+---------+-------+<br>
> | username | varchar(60) | NO | MUL | | |<br>
> | filter | text | YES | | NULL | |<br>
> | verify_key | varchar(32) | NO | | | |<br>
> | active | enum('N','Y') | YES | | N | |<br>
> +------------+---------------+------+-----+---------+-------+<br>
> 4 rows in set (0.00 sec)<br>
> describe users;<br>
> +-------------------+---------------------------+------+-----+---------+-------+<br>
> | Field | Type | Null | Key | Default |<br>
> Extra |<br>
> +-------------------+---------------------------+------+-----+---------+-------+<br>
> | username | varchar(60) | NO | PRI | |<br>
> |<br>
> | password | varchar(32) | YES | | NULL |<br>
> |<br>
> | fullname | varchar(50) | NO | | |<br>
> |<br>
> | type | enum('A','D','U','R','H') | YES | | NULL |<br>
> |<br>
> | quarantine_report | tinyint(1) | YES | | 0 |<br>
> |<br>
> | spamscore | tinyint(4) | YES | | 0 |<br>
> |<br>
> | highspamscore | tinyint(4) | YES | | 0 |<br>
> |<br>
> | noscan | tinyint(1) | YES | | 0 |<br>
> |<br>
> | quarantine_rcpt | varchar(60) | YES | | NULL |<br>
> |<br>
> +-------------------+---------------------------+------+-----+---------+-------+<br>
> 9 rows in set (0.00 sec)<br>
> describe whitelist;<br>
> +--------------+---------+------+-----+---------+----------------+<br>
> | Field | Type | Null | Key | Default | Extra |<br>
> +--------------+---------+------+-----+---------+----------------+<br>
> | id | int(11) | NO | PRI | NULL | auto_increment |<br>
> | to_address | text | YES | MUL | NULL | |<br>
> | to_domain | text | YES | | NULL | |<br>
> | from_address | text | YES | | NULL | |<br>
> +--------------+---------+------+-----+---------+----------------+<br>
> 4 rows in set (0.00 sec)<br>
><br>
><br>
> is this you looking for??<br>
> i hope this help you.<br>
> Milenko Letic<br>
><br>
> 2012/4/5 Tomáš Kurinec <<a href="mailto:tomb.stoney@gmail.com">tomb.stoney@gmail.com</a>><br>
>><br>
>> Oh God THANK YOU Peter!!!<br>
>><br>
>> You seems to be only one who really got it. I thought it's obvious what I<br>
>> meant, but I was probably wrong. Still I can't figure it out.<br>
>><br>
>> Please creators of MailScanner the great great, may be the best free<br>
>> mighty tool. Can you write me the table structure that actually works with<br>
>> MailScanner? I'm probably stupid, because I can't get it from the manual.<br>
>> Can you accept my stupidity and write me the table structure? I would be<br>
>> very thankful and may be even donate your great project!<br>
>><br>
>> Many many thanks.<br>
>><br>
>> Tom<br>
>><br>
>> Dňa 5.4.2012 15:43, "Peter Bonivart" <<a href="mailto:bonivart@opencsw.org">bonivart@opencsw.org</a>> napísal(-a):<br>
>><br>
>>> On Thu, Apr 5, 2012 at 3:11 PM, Joolee <<a href="mailto:mailscanner@joolee.nl">mailscanner@joolee.nl</a>> wrote:<br>
>>> > Well, if you did read the manual, you'd seen that there is a property<br>
>>> > called "SQL Debug" you can set to "Yes" to get more information from<br>
>>> > Mailscanner about the MySQL connection.<br>
>>> > You tell us MailScanner connected to MySQL properly? In that case, you<br>
>>> > can tell us what queries your MailScanner sends to MySQL and what<br>
>>> > answers it receives. How do you know that Mailscanner connects<br>
>>> > properly and the configured queries give the correct results?<br>
>>><br>
>>> What he's asking for is to how to set up the database needed, he even<br>
>>> gives an example of what he wants in his first post. Still people just<br>
>>> post stuff like RTFM, turn debugging on, read the source, if you don't<br>
>>> understand it you shouldn't run it and so on.<br>
>>><br>
>>> I have snapped at people too but I have never seen so many feel<br>
>>> obliged to reply to this guy without actually helping him the way he<br>
>>> wants to be helped. If you can't or won't help him why do feel a need<br>
>>> to tell him so? Can't you just ignore his post?<br>
>>><br>
>>> If you have figured out how to set up a working database it wouldn't<br>
>>> be so hard to dump the structure of it so he could import it. Maybe<br>
>>> someone could post it to a wiki and help the next guy out as well.<br>
>>><br>
>>> /peter<br>
>>> --<br>
>>> MailScanner mailing list<br>
>>> <a href="mailto:mailscanner@lists.mailscanner.info">mailscanner@lists.mailscanner.info</a><br>
>>> <a href="http://lists.mailscanner.info/mailman/listinfo/mailscanner" target="_blank">http://lists.mailscanner.info/mailman/listinfo/mailscanner</a><span onmouseout="cancel = false; window.setTimeout(WRCHideContent, 1000); clearTimeout(showTimer);" onmouseover=" var self = this; showTimer = window.setTimeout(function(){WRCShowContent({'rating':{'value':-1,'weight':-1},'flags':{},'single':false,'ttl':7200,'expireTime':'20120402063904'}, self.className)},600);" class="wrc0" style="padding-right:16px;width:16px;height:16px"></span><br>
>>><br>
>>> Before posting, read <a href="http://wiki.mailscanner.info/posting" target="_blank">http://wiki.mailscanner.info/posting</a><span onmouseout="cancel = false; window.setTimeout(WRCHideContent, 1000); clearTimeout(showTimer);" onmouseover=" var self = this; showTimer = window.setTimeout(function(){WRCShowContent({'rating':{'value':-1,'weight':-1},'flags':{},'single':false,'ttl':7200,'expireTime':'20120402063904'}, self.className)},600);" class="wrc0" style="padding-right:16px;width:16px;height:16px"></span><br>
>>><br>
>>> Support MailScanner development - buy the book off the website!<br>
>><br>
>><br>
>> --<br>
>> MailScanner mailing list<br>
>> <a href="mailto:mailscanner@lists.mailscanner.info">mailscanner@lists.mailscanner.info</a><br>
>> <a href="http://lists.mailscanner.info/mailman/listinfo/mailscanner" target="_blank">http://lists.mailscanner.info/mailman/listinfo/mailscanner</a><span onmouseout="cancel = false; window.setTimeout(WRCHideContent, 1000); clearTimeout(showTimer);" onmouseover=" var self = this; showTimer = window.setTimeout(function(){WRCShowContent({'rating':{'value':-1,'weight':-1},'flags':{},'single':false,'ttl':7200,'expireTime':'20120402063904'}, self.className)},600);" class="wrc0" style="padding-right:16px;width:16px;height:16px"></span><br>
>><br>
>> Before posting, read <a href="http://wiki.mailscanner.info/posting" target="_blank">http://wiki.mailscanner.info/posting</a><span onmouseout="cancel = false; window.setTimeout(WRCHideContent, 1000); clearTimeout(showTimer);" onmouseover=" var self = this; showTimer = window.setTimeout(function(){WRCShowContent({'rating':{'value':-1,'weight':-1},'flags':{},'single':false,'ttl':7200,'expireTime':'20120402063904'}, self.className)},600);" class="wrc0" style="padding-right:16px;width:16px;height:16px"></span><br>
>><br>
>> Support MailScanner development - buy the book off the website!<br>
>><br>
><br>
><br>
> --<br>
> MailScanner mailing list<br>
> <a href="mailto:mailscanner@lists.mailscanner.info">mailscanner@lists.mailscanner.info</a><br>
> <a href="http://lists.mailscanner.info/mailman/listinfo/mailscanner" target="_blank">http://lists.mailscanner.info/mailman/listinfo/mailscanner</a><span onmouseout="cancel = false; window.setTimeout(WRCHideContent, 1000); clearTimeout(showTimer);" onmouseover=" var self = this; showTimer = window.setTimeout(function(){WRCShowContent({'rating':{'value':-1,'weight':-1},'flags':{},'single':false,'ttl':7200,'expireTime':'20120402063904'}, self.className)},600);" class="wrc0" style="padding-right:16px;width:16px;height:16px"></span><br>
><br>
> Before posting, read <a href="http://wiki.mailscanner.info/posting" target="_blank">http://wiki.mailscanner.info/posting</a><span onmouseout="cancel = false; window.setTimeout(WRCHideContent, 1000); clearTimeout(showTimer);" onmouseover=" var self = this; showTimer = window.setTimeout(function(){WRCShowContent({'rating':{'value':-1,'weight':-1},'flags':{},'single':false,'ttl':7200,'expireTime':'20120402063904'}, self.className)},600);" class="wrc0" style="padding-right:16px;width:16px;height:16px"></span><br>
><br>
> Support MailScanner development - buy the book off the website!<br>
><br>
--<br>
MailScanner mailing list<br>
<a href="mailto:mailscanner@lists.mailscanner.info">mailscanner@lists.mailscanner.info</a><br>
<a href="http://lists.mailscanner.info/mailman/listinfo/mailscanner" target="_blank">http://lists.mailscanner.info/mailman/listinfo/mailscanner</a><span onmouseout="cancel = false; window.setTimeout(WRCHideContent, 1000); clearTimeout(showTimer);" onmouseover=" var self = this; showTimer = window.setTimeout(function(){WRCShowContent({'rating':{'value':-1,'weight':-1},'flags':{},'single':false,'ttl':7200,'expireTime':'20120402063904'}, self.className)},600);" class="wrc0" style="padding-right:16px;width:16px;height:16px"></span><br>
<br>
Before posting, read <a href="http://wiki.mailscanner.info/posting" target="_blank">http://wiki.mailscanner.info/posting</a><span onmouseout="cancel = false; window.setTimeout(WRCHideContent, 1000); clearTimeout(showTimer);" onmouseover=" var self = this; showTimer = window.setTimeout(function(){WRCShowContent({'rating':{'value':-1,'weight':-1},'flags':{},'single':false,'ttl':7200,'expireTime':'20120402063904'}, self.className)},600);" class="wrc0" style="padding-right:16px;width:16px;height:16px"></span><br>
<br>
Support MailScanner development - buy the book off the website!<br>
</div></div></blockquote></div><br>