在 pfsense 中启动 barnyard2 失败 - V2EX
V2EX = way to explore
V2EX 是一个关于分享和探索的地方
现在注册
已注册用户请  登录
Terenc3
V2EX    数据库

在 pfsense 中启动 barnyard2 失败

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

    我在 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     Solana     1037 人在线   最高记录 6679       Select Language
    创意工作者们的社区
    World is powered by solitude
    VERSION: 3.9.8.5 23ms UTC 18:45 PVG 02:45 LAX 11:45 JFK 14:45
    Do have faith in what you're doing.
    ubao msn snddm index pchome yahoo rakuten mypaper meadowduck bidyahoo youbao zxmzxm asda bnvcg cvbfg dfscv mmhjk xxddc yybgb zznbn ccubao uaitu acv GXCV ET GDG YH FG BCVB FJFH CBRE CBC GDG ET54 WRWR RWER WREW WRWER RWER SDG EW SF DSFSF fbbs ubao fhd dfg ewr dg df ewwr ewwr et ruyut utut dfg fgd gdfgt etg dfgt dfgd ert4 gd fgg wr 235 wer3 we vsdf sdf gdf ert xcv sdf rwer hfd dfg cvb rwf afb dfh jgh bmn lgh rty gfds cxv xcv xcs vdas fdf fgd cv sdf tert sdf sdf sdf sdf sdf sdf sdf sdf sdf sdf sdf sdf sdf sdf sdf sdf sdf sdf sdf sdf sdf sdf sdf sdf sdf sdf sdf sdf sdf sdf sdf sdf sdf sdf sdf sdf sdf sdf sdf sdf shasha9178 shasha9178 shasha9178 shasha9178 shasha9178 liflif2 liflif2 liflif2 liflif2 liflif2 liblib3 liblib3 liblib3 liblib3 liblib3 zhazha444 zhazha444 zhazha444 zhazha444 zhazha444 dende5 dende denden denden2 denden21 fenfen9 fenf619 fen619 fenfe9 fe619 sdf sdf sdf sdf sdf zhazh90 zhazh0 zhaa50 zha90 zh590 zho zhoz zhozh zhozho zhozho2 lislis lls95 lili95 lils5 liss9 sdf0ty987 sdft876 sdft9876 sdf09876 sd0t9876 sdf0ty98 sdf0976 sdf0ty986 sdf0ty96 sdf0t76 sdf0876 df0ty98 sf0t876 sd0ty76 sdy76 sdf76 sdf0t76 sdf0ty9 sdf0ty98 sdf0ty987 sdf0ty98 sdf6676 sdf876 sd876 sd876 sdf6 sdf6 sdf9876 sdf0t sdf06 sdf0ty9776 sdf0ty9776 sdf0ty76 sdf8876 sdf0t sd6 sdf06 s688876 sd688 sdf86