在 pfsense 中启动 barnyard2 失败

[Terenc3]

我在 pfsense 2.3.2-RELEASE-p1 (amd64)中安装 snort 3.2.9.2_15 和 barnyard2-1.13 。

在启动 snort 时一切正常并工作良好，却无法启动 barnyard2 ，日志如下：

Jan 25 03:19:36 barnyard2 47694 INFO database: Defaulting Reconnect/Transaction Error limit to 10 Jan 25 03:19:36 barnyard2 47694 INFO database: Defaulting Reconnect sleep time to 5 second Jan 25 03:19:36 barnyard2 47814 FATAL ERROR: database [DatabaseInitFinalize()]: CacheSynchronize() call failed ... Jan 25 03:19:37 barnyard2 47814 database: Closing connection to database "barnyard2" Jan 25 03:19:52 barnyard2 74975 INFO database: Defaulting Reconnect/Transaction Error limit to 10 Jan 25 03:19:52 barnyard2 74975 INFO database: Defaulting Reconnect sleep time to 5 second Jan 25 03:19:52 barnyard2 75092 FATAL ERROR: database [DatabaseInitFinalize()]: CacheSynchronize() call failed ... Jan 25 03:19:52 barnyard2 75092 database: Closing connection to database "barnyard2" Jan 25 03:20:16 barnyard2 80172 INFO database: Defaulting Reconnect/Transaction Error limit to 10 Jan 25 03:20:16 barnyard2 80172 INFO database: Defaulting Reconnect sleep time to 5 second Jan 25 03:20:16 barnyard2 80317 FATAL ERROR: database [DatabaseInitFinalize()]: CacheSynchronize() call failed ... Jan 25 03:20:16 barnyard2 80317 database: Closing connection to database "barnyard2" Jan 25 03:21:16 barnyard2 6196 INFO database: Defaulting Reconnect/Transaction Error limit to 10 Jan 25 03:21:16 barnyard2 6196 INFO database: Defaulting Reconnect sleep time to 5 second Jan 25 03:21:16 barnyard2 6347 ERROR database: executing Select() with Query [SELECT vseq FROM schema] Jan 25 03:21:16 barnyard2 6347 FATAL ERROR: database problems with schema version, bailing... Jan 25 03:21:16 barnyard2 6347 database: Closing connection to database "barnyard2" Jan 25 03:22:04 barnyard2 40661 INFO database: Defaulting Reconnect/Transaction Error limit to 10 Jan 25 03:22:04 barnyard2 40661 INFO database: Defaulting Reconnect sleep time to 5 second Jan 25 03:22:04 barnyard2 40699 ERROR database: executing Select() with Query [SELECT vseq FROM schema] Jan 25 03:22:04 barnyard2 40699 FATAL ERROR: database problems with schema version, bailing... Jan 25 03:22:04 barnyard2 40699 database: Closing connection to database "barnyard2" Jan 25 03:23:45 barnyard2 73909 INFO database: Defaulting Reconnect/Transaction Error limit to 10 Jan 25 03:23:45 barnyard2 73909 INFO database: Defaulting Reconnect sleep time to 5 second Jan 25 03:23:45 barnyard2 74168 [ClassificationPullDataStore()]: No Classification found in database ... Jan 25 03:23:45 barnyard2 74168 [SignaturePullDataStore()]: No signature found in database ... Jan 25 03:23:46 barnyard2 74168 FATAL ERROR: database [DatabaseInitFinalize()]: CacheSynchronize() call failed ... Jan 25 03:23:46 barnyard2 74168 database: Closing connection to database "barnyard2"

在过去的三天我一直寻找原因与不断尝试启动，但都失败了。请问有类似问题的人吗？

[orzfly]

你这帖子格式乱地谁想帮你看啊……

Jan 25 03:19:36 barnyard2 47694 INFO database: Defaulting Reconnect/Transaction Error limit to 10
Jan 25 03:19:36 barnyard2 47694 INFO database: Defaulting Reconnect sleep time to 5 second
Jan 25 03:19:36 barnyard2 47814 FATAL ERROR: database [DatabaseInitFinalize()]: CacheSynchronize() call failed ...
Jan 25 03:19:37 barnyard2 47814 database: Closing connection to database "barnyard2"
Jan 25 03:19:52 barnyard2 74975 INFO database: Defaulting Reconnect/Transaction Error limit to 10
Jan 25 03:19:52 barnyard2 74975 INFO database: Defaulting Reconnect sleep time to 5 second
Jan 25 03:19:52 barnyard2 75092 FATAL ERROR: database [DatabaseInitFinalize()]: CacheSynchronize() call failed ...
Jan 25 03:19:52 barnyard2 75092 database: Closing connection to database "barnyard2"
Jan 25 03:20:16 barnyard2 80172 INFO database: Defaulting Reconnect/Transaction Error limit to 10
Jan 25 03:20:16 barnyard2 80172 INFO database: Defaulting Reconnect sleep time to 5 second
Jan 25 03:20:16 barnyard2 80317 FATAL ERROR: database [DatabaseInitFinalize()]: CacheSynchronize() call failed ...
Jan 25 03:20:16 barnyard2 80317 database: Closing connection to database "barnyard2"
Jan 25 03:21:16 barnyard2 6196 INFO database: Defaulting Reconnect/Transaction Error limit to 10
Jan 25 03:21:16 barnyard2 6196 INFO database: Defaulting Reconnect sleep time to 5 second
Jan 25 03:21:16 barnyard2 6347 ERROR database: executing Select() with Query [SELECT vseq FROM `schema`]
Jan 25 03:21:16 barnyard2 6347 FATAL ERROR: database problems with schema version, bailing...
Jan 25 03:21:16 barnyard2 6347 database: Closing connection to database "barnyard2"
Jan 25 03:22:04 barnyard2 40661 INFO database: Defaulting Reconnect/Transaction Error limit to 10
Jan 25 03:22:04 barnyard2 40661 INFO database: Defaulting Reconnect sleep time to 5 second
Jan 25 03:22:04 barnyard2 40699 ERROR database: executing Select() with Query [SELECT vseq FROM `schema`]
Jan 25 03:22:04 barnyard2 40699 FATAL ERROR: database problems with schema version, bailing...
Jan 25 03:22:04 barnyard2 40699 database: Closing connection to database "barnyard2"
Jan 25 03:23:45 barnyard2 73909 INFO database: Defaulting Reconnect/Transaction Error limit to 10
Jan 25 03:23:45 barnyard2 73909 INFO database: Defaulting Reconnect sleep time to 5 second
Jan 25 03:23:45 barnyard2 74168 [ClassificationPullDataStore()]: No Classification found in database ...
Jan 25 03:23:45 barnyard2 74168 [SignaturePullDataStore()]: No signature found in database ...
Jan 25 03:23:46 barnyard2 74168 FATAL ERROR: database [DatabaseInitFinalize()]: CacheSynchronize() call failed ...
Jan 25 03:23:46 barnyard2 74168 database: Closing connection to database "barnyard2"

[orzfly]

看起来数据库问题，在 barnyard2 数据库查询 SELECT vseq FROM `schema` 失败了……

[orzfly]

你是不是虽然配置了数据库，但是没在数据库里建表啊……

[orzfly]

https://github.com/firnsy/barnyard2/blob/master/schemas/create_mysql

[Terenc3]

@orzfly 真是太不好意思了，格式确实没弄好。

[Terenc3]

@orzfly 这很奇怪呢，我确实是导入的这个数据库，而且数据库中也含有这个 schema 表，可是依旧出现这个错误。

我能确定权限也是正确的。