V2EX = way to explore
V2EX 是一个关于分享和探索的地方
现在注册
已注册用户请  登录
Terenc3
V2EX  ›  数据库

在 pfsense 中启动 barnyard2 失败

  •  
  •   Terenc3 · 2017-01-25 03:50:37 +08:00 · 770 次点击
    这是一个创建于 2859 天前的主题,其中的信息可能已经有所发展或是发生改变。

    我在 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"

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

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

    我能确定权限也是正确的。
    关于   ·   帮助文档   ·   博客   ·   API   ·   FAQ   ·   实用小工具   ·   2816 人在线   最高记录 6679   ·     Select Language
    创意工作者们的社区
    World is powered by solitude
    VERSION: 3.9.8.5 · 23ms · UTC 07:37 · PVG 15:37 · LAX 23:37 · JFK 02:37
    Developed with CodeLauncher
    ♥ Do have faith in what you're doing.