{ "version": "https:\/\/jsonfeed.org\/version\/1.1", "title": "Воронин: заметки с тегом bayes", "_rss_description": "воронин, voronin, it", "_rss_language": "ru", "_itunes_email": "", "_itunes_categories_xml": "", "_itunes_image": "", "_itunes_explicit": "", "home_page_url": "https:\/\/voronin.one\/tags\/bayes\/", "feed_url": "https:\/\/voronin.one\/tags\/bayes\/json\/", "icon": "https:\/\/voronin.one\/pictures\/userpic\/userpic@2x.jpg?1658757233", "authors": [ { "name": "Алексей Воронин", "url": "https:\/\/voronin.one\/", "avatar": "https:\/\/voronin.one\/pictures\/userpic\/userpic@2x.jpg?1658757233" } ], "items": [ { "id": "47", "url": "https:\/\/voronin.one\/all\/perenosim-bazu-spamassassin-bayes-v-mysql\/", "title": "переносим базу SpamAssassin bayes в MySQL", "content_html": "

для начала проверим версию SpamAssassin<\/p>\n

$ sudo spamassassin -V\nSpamAssassin version 3.4.6\n  running on Perl version 5.32.1<\/code><\/pre>
в нашем случае это 3.4.6<\/p>\n
теперь качаем нужный файл со структурой mysql<\/p>\n
$ cd ~\n$ wget http:\/\/svn.apache.org\/repos\/asf\/spamassassin\/tags\/spamassassin_release_3_4_6\/sql\/bayes_mysql.sql<\/code><\/pre>
подключаемся к движку базы и загружаем структуру<\/p>\n
$ mysql -uroot -p\nMariaDB [(none)]> CREATE DATABASE sa_bayes;\nMariaDB [(none)]> USE sa_bayes;\nMariaDB [(none)]> SOURCE ~\/bayes_mysql.sql;<\/code><\/pre>
создадим пользователя sa_user<\/b> с паролем Pa$$W0rd<\/b> (замените на свой) и правами на нашу базу<\/p>\n
MariaDB [(none)]> GRANT SELECT, INSERT, UPDATE, DELETE ON sa_bayes.* TO sa_user@localhost IDENTIFIED BY 'Pa$$W0rd';\nMariaDB [(none)]> FLUSH PRIVILEGES;\nMariaDB [sa_bayes]> quit;<\/code><\/pre>
отредактируем конфиг \/etc\/mail\/spamassassin\/local.cf<\/b><\/p>\n
use_bayes          1\nbayes_auto_learn   1\nbayes_auto_expire  1\n\n# Store bayesian data in MySQL.\n# Please make sure you have correct server address, port and database name.\nbayes_store_module Mail::SpamAssassin::BayesStore::MySQL\nbayes_sql_dsn      DBI:mysql:sa_bayes:127.0.0.1:3306\n\n# Store bayesian data in PostgreSQL.\n# Please make sure you have correct server address, port and database name.\n#bayes_store_module Mail::SpamAssassin::BayesStore::PgSQL\n#bayes_sql_dsn      DBI:Pg:database=sa_bayes;host=127.0.0.1;port=5432\n\n# SQL username and password.\nbayes_sql_username sa_user\nbayes_sql_password Pa$$W0rd\n\n# Override the username used for storing data in the database.\n# This could be used to group users together to share bayesian filter data.\n# You can also use this config option to trick sa-learn to learn data as a specific user.\n#bayes_sql_override_username vmail\nbayes_sql_override_username amavis<\/code><\/pre>
рестартим службу<\/p>\n
$ sudo service amavis restart<\/code><\/pre>
проверяем, скармливаем тестовое сообщение<\/p>\n
$ sa-learn --spam --username=amavis \/usr\/share\/doc\/spamassassin\/examples\/sample-spam.txt\nLearned tokens from 1 message(s) (1 message(s) examined)<\/code><\/pre>
и проверим наполняемость базы<\/p>\n
$ mysql -uroot -p\nMariaDB [(none)]> USE sa_bayes;\nMariaDB [sa_bayes]> SELECT username,spam_count,ham_count FROM bayes_vars;\n+----------+------------+-----------+\n| username | spam_count | ham_count |\n+----------+------------+-----------+\n| amavis   |          1 |         1 |\n+----------+------------+-----------+\n1 row in set (0,000 sec)\nMariaDB [sa_bayes]> quit;<\/code><\/pre>
и не забудьте отредактировать файл резервирования \/var\/vmail\/backup\/backup_mysql.sh<\/b>, чтобы добавить и нашу базу<\/p>\n
# Databases we should backup.\n# Multiple databases MUST be seperated by SPACE.\nexport DATABASES='mysql vmail roundcubemail amavisd iredadmin sogo iredapd sa_bayes'<\/code><\/pre>
PS мне скрипт резервирования не пришлось менять, там уже быза бала прописана<\/p>\n",
            "date_published": "2023-06-13T17:59:28+03:00",
            "date_modified": "2023-06-15T16:04:56+03:00",
            "tags": [
                "bayes",
                "iRedMail",
                "MySQL",
                "SpamAssassin"
            ],
            "_date_published_rfc2822": "Tue, 13 Jun 2023 17:59:28 +0300",
            "_rss_guid_is_permalink": "false",
            "_rss_guid": "47",
            "_e2_data": {
                "is_favourite": false,
                "links_required": [
                    "highlight\/highlight.js",
                    "highlight\/highlight.css"
                ],
                "og_images": []
            }
        }
    ],
    "_e2_version": 4171,
    "_e2_ua_string": "Aegea 11.4 (v4171)"
}