在 pfsense 中启动 barnyard2 失败

2017-01-25 03:50:37 +08:00
 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"

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

708 次点击
所在节点    数据库
6 条回复
orzfly
2017-01-25 10:27:29 +08:00
你这帖子格式乱地谁想帮你看啊……

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
2017-01-25 10:28:09 +08:00
看起来数据库问题，在 barnyard2 数据库查询 SELECT vseq FROM `schema` 失败了……
orzfly
2017-01-25 10:29:18 +08:00
你是不是虽然配置了数据库，但是没在数据库里建表啊……
orzfly
2017-01-25 10:29:54 +08:00
https://github.com/firnsy/barnyard2/blob/master/schemas/create_mysql
Terenc3
2017-01-28 14:37:48 +08:00
@orzfly 真是太不好意思了，格式确实没弄好。
Terenc3
2017-01-28 14:41:54 +08:00
@orzfly 这很奇怪呢，我确实是导入的这个数据库，而且数据库中也含有这个 schema 表，可是依旧出现这个错误。

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

这是一个专为移动设备优化的页面（即为了让你能够在 Google 搜索结果里秒开这个页面），如果你希望参与 V2EX 社区的讨论，你可以继续到 V2EX 上打开本讨论主题的完整版本。

https://www.v2ex.com/t/336796

V2EX 是创意工作者们的社区，是一个分享自己正在做的有趣事物、交流想法，可以遇见新朋友甚至新机会的地方。

V2EX is a community of developers, designers and creative people.

© 2021 V2EX