this is structure on my server:<div><div>Tables_in_mailscanner | </div><div>+-----------------------+ </div>
<div>| audit_log | </div><div>| blacklist | </div>
<div>| geoip_country | </div><div>| inq | </div>
<div>| maillog |</div><div>| mcp_rules |</div><div>| mtalog |</div><div>| outq |</div><div>| sa_rules |</div><div>| saved_filters |</div><div>
| spamscores |</div><div>| user_filters |</div><div>| users |</div><div>| whitelist </div><div>and tables look like this:</div><div><div>describe audit_log;</div><div>+------------+-------------+------+-----+-------------------+-----------------------------+</div>
<div>| Field | Type | Null | Key | Default | Extra |</div><div>+------------+-------------+------+-----+-------------------+-----------------------------+</div><div>| timestamp | timestamp | NO | | CURRENT_TIMESTAMP | on update CURRENT_TIMESTAMP |</div>
<div>| user | varchar(20) | NO | | | |</div><div>| ip_address | varchar(15) | NO | | | |</div><div>| action | text | NO | | NULL | |</div>
<div>+------------+-------------+------+-----+-------------------+-----------------------------+</div><div>4 rows in set (0.08 sec)</div></div><div><div>describe blacklist;</div><div>+--------------+---------+------+-----+---------+----------------+</div>
<div>| Field | Type | Null | Key | Default | Extra |</div><div>+--------------+---------+------+-----+---------+----------------+</div><div>| id | int(11) | NO | PRI | NULL | auto_increment |</div>
<div>| to_address | text | YES | MUL | NULL | |</div><div>| to_domain | text | YES | | NULL | |</div><div>| from_address | text | YES | | NULL | |</div>
<div>+--------------+---------+------+-----+---------+----------------+</div><div>4 rows in set (0.00 sec)</div></div><div><div>describe geoip_country;</div><div>+------------------+-------------+------+-----+---------+-------+</div>
<div>| Field | Type | Null | Key | Default | Extra |</div><div>+------------------+-------------+------+-----+---------+-------+</div><div>| begin_ip | varchar(15) | YES | | NULL | |</div>
<div>| end_ip | varchar(15) | YES | | NULL | |</div><div>| begin_num | bigint(20) | YES | MUL | NULL | |</div><div>| end_num | bigint(20) | YES | MUL | NULL | |</div>
<div>| iso_country_code | char(2) | YES | | NULL | |</div><div>| country | text | YES | | NULL | |</div><div>+------------------+-------------+------+-----+---------+-------+</div>
<div>6 rows in set (0.00 sec)</div></div><div><div>describe inq;</div><div>+--------------+------+------+-----+---------+-------+</div><div>| Field | Type | Null | Key | Default | Extra |</div><div>+--------------+------+------+-----+---------+-------+</div>
<div>| id | text | YES | | NULL | |</div><div>| cdate | date | YES | | NULL | |</div><div>| ctime | time | YES | | NULL | |</div><div>| from_address | text | YES | | NULL | |</div>
<div>| to_address | text | YES | | NULL | |</div><div>| subject | text | YES | | NULL | |</div><div>| message | text | YES | | NULL | |</div><div>| size | text | YES | | NULL | |</div>
<div>| priority | text | YES | | NULL | |</div><div>| attempts | text | YES | | NULL | |</div><div>| lastattempt | text | YES | | NULL | |</div><div>| hostname | text | YES | MUL | NULL | |</div>
<div>+--------------+------+------+-----+---------+-------+</div><div>12 rows in set (0.00 sec)</div></div><div><div>describe maillog;</div><div>+-----------------+--------------+------+-----+-------------------+-----------------------------+</div>
<div>| Field | Type | Null | Key | Default | Extra |</div><div>+-----------------+--------------+------+-----+-------------------+-----------------------------+</div><div>
| timestamp | timestamp | NO | | CURRENT_TIMESTAMP | on update CURRENT_TIMESTAMP |</div><div>| id | text | YES | MUL | NULL | |</div><div>| size | bigint(20) | YES | | 0 | |</div>
<div>| from_address | text | YES | MUL | NULL | |</div><div>| from_domain | text | YES | MUL | NULL | |</div><div>
| to_address | text | YES | MUL | NULL | |</div><div>| to_domain | text | YES | MUL | NULL | |</div><div>| subject | text | YES | | NULL | |</div>
<div>| clientip | text | YES | MUL | NULL | |</div><div>| archive | text | YES | | NULL | |</div><div>
| isspam | tinyint(1) | YES | | 0 | |</div><div>| ishighspam | tinyint(1) | YES | | 0 | |</div><div>| issaspam | tinyint(1) | YES | | 0 | |</div>
<div>| isrblspam | tinyint(1) | YES | | 0 | |</div><div>| isfp | tinyint(1) | YES | | 0 | |</div><div>
| isfn | tinyint(1) | YES | | 0 | |</div><div>| spamwhitelisted | tinyint(1) | YES | | 0 | |</div><div>| spamblacklisted | tinyint(1) | YES | | 0 | |</div>
<div>| sascore | decimal(7,2) | YES | | 0.00 | |</div><div>| spamreport | text | YES | | NULL | |</div><div>
| virusinfected | tinyint(1) | YES | | 0 | |</div><div>| nameinfected | tinyint(1) | YES | | 0 | |</div><div>| otherinfected | tinyint(1) | YES | | 0 | |</div>
<div>| report | text | YES | | NULL | |</div><div>| ismcp | tinyint(1) | YES | | 0 | |</div><div>
| ishighmcp | tinyint(1) | YES | | 0 | |</div><div>| issamcp | tinyint(1) | YES | | 0 | |</div><div>| mcpwhitelisted | tinyint(1) | YES | | 0 | |</div>
<div>| mcpblacklisted | tinyint(1) | YES | | 0 | |</div><div>| mcpsascore | decimal(7,2) | YES | | 0.00 | |</div><div>
| mcpreport | text | YES | | NULL | |</div><div>| hostname | text | YES | MUL | NULL | |</div><div>| date | date | YES | MUL | NULL | |</div>
<div>| time | time | YES | | NULL | |</div><div>| headers | text | YES | | NULL | |</div><div>
| quarantined | tinyint(1) | YES | MUL | 0 | |</div><div>+-----------------+--------------+------+-----+-------------------+-----------------------------+</div><div>36 rows in set (0.01 sec)</div>
</div><div><div>describe mtalog;</div><div>+-----------+-------------+------+-----+---------+-------+</div><div>| Field | Type | Null | Key | Default | Extra |</div><div>+-----------+-------------+------+-----+---------+-------+</div>
<div>| timestamp | datetime | YES | MUL | NULL | |</div><div>| host | text | YES | | NULL | |</div><div>| type | text | YES | MUL | NULL | |</div><div>| msg_id | varchar(20) | YES | | NULL | |</div>
<div>| relay | text | YES | | NULL | |</div><div>| dsn | text | YES | | NULL | |</div><div>| status | text | YES | | NULL | |</div><div>| delay | time | YES | | NULL | |</div>
<div>+-----------+-------------+------+-----+---------+-------+</div><div>8 rows in set (0.00 sec)</div></div><div><br></div><div><div>describe mcp_rules</div><div> -> ;</div><div>+-----------+-----------+------+-----+---------+-------+</div>
<div>| Field | Type | Null | Key | Default | Extra |</div><div>+-----------+-----------+------+-----+---------+-------+</div><div>| rule | char(100) | NO | PRI | | |</div><div>| rule_desc | char(200) | NO | | | |</div>
<div>+-----------+-----------+------+-----+---------+-------+</div><div>2 rows in set (0.00 sec)</div></div><div><div>> describe outq;</div><div>+--------------+------+------+-----+---------+-------+</div><div>| Field | Type | Null | Key | Default | Extra |</div>
<div>+--------------+------+------+-----+---------+-------+</div><div>| id | text | YES | | NULL | |</div><div>| cdate | date | YES | | NULL | |</div><div>| ctime | time | YES | | NULL | |</div>
<div>| from_address | text | YES | | NULL | |</div><div>| to_address | text | YES | | NULL | |</div><div>| subject | text | YES | | NULL | |</div><div>| message | text | YES | | NULL | |</div>
<div>| size | text | YES | | NULL | |</div><div>| priority | text | YES | | NULL | |</div><div>| attempts | text | YES | | NULL | |</div><div>| lastattempt | text | YES | | NULL | |</div>
<div>| hostname | text | YES | MUL | NULL | |</div><div>+--------------+------+------+-----+---------+-------+</div><div>12 rows in set (0.00 sec)</div><div><div>describe sa_rules;</div><div>+-----------+--------------+------+-----+---------+-------+</div>
<div>| Field | Type | Null | Key | Default | Extra |</div><div>+-----------+--------------+------+-----+---------+-------+</div><div>| rule | varchar(100) | NO | PRI | | |</div><div>| rule_desc | varchar(200) | NO | | | |</div>
<div>+-----------+--------------+------+-----+---------+-------+</div><div>2 rows in set (0.00 sec)</div></div></div><div><div> describe saved_filters;</div><div>+----------+------+------+-----+---------+-------+</div><div>
| Field | Type | Null | Key | Default | Extra |</div><div>+----------+------+------+-----+---------+-------+</div><div>| name | text | NO | MUL | NULL | |</div><div>| col | text | NO | | NULL | |</div>
<div>| operator | text | NO | | NULL | |</div><div>| value | text | NO | | NULL | |</div><div>| username | text | NO | | NULL | |</div><div>+----------+------+------+-----+---------+-------+</div>
<div>5 rows in set (0.00 sec)</div></div><div><div>describe spamscore;</div><div>ERROR 1146 (42S02): Table 'mailscanner.spamscore' doesn't exist</div><div>mysql> describe spamscores;</div><div>+---------------+---------------+------+-----+---------+-------+</div>
<div>| Field | Type | Null | Key | Default | Extra |</div><div>+---------------+---------------+------+-----+---------+-------+</div><div>| user | varchar(40) | NO | PRI | | |</div>
<div>| lowspamscore | decimal(10,0) | NO | | 0 | |</div><div>| highspamscore | decimal(10,0) | NO | | 0 | |</div><div>+---------------+---------------+------+-----+---------+-------+</div>
<div>3 rows in set (0.00 sec)</div><div><div>describe user_filters;</div><div>+------------+---------------+------+-----+---------+-------+</div><div>| Field | Type | Null | Key | Default | Extra |</div><div>
+------------+---------------+------+-----+---------+-------+</div><div>| username | varchar(60) | NO | MUL | | |</div><div>| filter | text | YES | | NULL | |</div><div>| verify_key | varchar(32) | NO | | | |</div>
<div>| active | enum('N','Y') | YES | | N | |</div><div>+------------+---------------+------+-----+---------+-------+</div><div>4 rows in set (0.00 sec)</div></div></div><div><div>describe users;</div>
<div>+-------------------+---------------------------+------+-----+---------+-------+</div><div>| Field | Type | Null | Key | Default | Extra |</div><div>+-------------------+---------------------------+------+-----+---------+-------+</div>
<div>| username | varchar(60) | NO | PRI | | |</div><div>| password | varchar(32) | YES | | NULL | |</div><div>| fullname | varchar(50) | NO | | | |</div>
<div>| type | enum('A','D','U','R','H') | YES | | NULL | |</div><div>| quarantine_report | tinyint(1) | YES | | 0 | |</div>
<div>| spamscore | tinyint(4) | YES | | 0 | |</div><div>| highspamscore | tinyint(4) | YES | | 0 | |</div><div>| noscan | tinyint(1) | YES | | 0 | |</div>
<div>| quarantine_rcpt | varchar(60) | YES | | NULL | |</div><div>+-------------------+---------------------------+------+-----+---------+-------+</div><div>9 rows in set (0.00 sec)</div></div>
<div><div>describe whitelist;</div><div>+--------------+---------+------+-----+---------+----------------+</div><div>| Field | Type | Null | Key | Default | Extra |</div><div>+--------------+---------+------+-----+---------+----------------+</div>
<div>| id | int(11) | NO | PRI | NULL | auto_increment |</div><div>| to_address | text | YES | MUL | NULL | |</div><div>| to_domain | text | YES | | NULL | |</div>
<div>| from_address | text | YES | | NULL | |</div><div>+--------------+---------+------+-----+---------+----------------+</div><div>4 rows in set (0.00 sec)</div></div><div><br></div><div><br></div>
<div>is this you looking for?? </div><div>i hope this help you.</div><div>Milenko Letic</div><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"><p>Oh God THANK YOU Peter!!!</p><p>You seems to be only one who really got it. I thought it's obvious what I meant, but I was probably wrong. Still I can't figure it out.</p>
<p>Please creators of MailScanner the great great, may be the best free mighty tool. Can you write me the table structure that actually works with MailScanner? I'm probably stupid, because I can't get it from the manual. Can you accept my stupidity and write me the table structure? I would be very thankful and may be even donate your great project!</p>
<p>Many many thanks.</p>
<div class="gmail_quote">Tom</div><div class="gmail_quote"><br></div><div class="gmail_quote">Dňa 5.4.2012 15:43, "Peter Bonivart" <<a href="mailto:bonivart@opencsw.org" target="_blank">bonivart@opencsw.org</a>> napísal(-a):<div>
<div class="h5"><br type="attribution">
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
On Thu, Apr 5, 2012 at 3:11 PM, Joolee <<a href="mailto:mailscanner@joolee.nl" target="_blank">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" target="_blank">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><br>
<br>
Before posting, read <a href="http://wiki.mailscanner.info/posting" target="_blank">http://wiki.mailscanner.info/posting</a><br>
<br>
Support MailScanner development - buy the book off the website!<br>
</blockquote></div></div></div>
<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><br>
<br>
Before posting, read <a href="http://wiki.mailscanner.info/posting" target="_blank">http://wiki.mailscanner.info/posting</a><br>
<br>
Support MailScanner development - buy the book off the website!<br>
<br></blockquote></div><br></div>