base-1.3.5 bugs on ora9

BASE-user
edenCC
2007-04-11
2013-06-03
  • edenCC

    edenCC - 2007-04-11

    Hi, list;
    I've got some faults in the table creating script, here is a patch, it's working on oracle 9.

    and it seems that base-1.3.5 cannot work well with oracle.
    --- ./sql/create_base_tbls_oracle.sql   2007-02-20 09:48:24.000000000 +0800
    +++ /tmp/create_base_tbls_oracle.sql    2007-04-10 23:12:50.000000000 +0800
    @@ -57,7 +57,7 @@
    create INDEX idx_acid_2 on acid_event(sig_name);
    create INDEX idx_acid_3 on acid_event(sig_class_id);
    create INDEX idx_acid_4 on acid_event(sig_priority);
    -create INDEX idx_acid_5 on acid_event("timestamp");
    +create INDEX idx_acid_5 on acid_event(timestamp);
    create INDEX idx_acid_6 on acid_event(ip_src);
    create INDEX idx_acid_7 on acid_event(ip_dst);
    create INDEX idx_acid_8 on acid_event(ip_proto);
    @@ -75,13 +75,13 @@
    commit work;
     
    drop sequence seq_acid_ag_id;
    -CREATE SEQUENCE snort.seq_acid_ag_id START WITH 1 INCREMENT BY 1;
    +CREATE SEQUENCE seq_acid_ag_id START WITH 1 INCREMENT BY 1;
     
    CREATE or replace TRIGGER tr_acid_ag_id
    BEFORE INSERT ON acid_ag
    FOR EACH ROW
    BEGIN
    -SELECT snort.seq_acid_ag_id.nextval INTO :new.ag_id FROM dual;
    +SELECT seq_acid_ag_id.nextval INTO :new.ag_id FROM dual;
    END;
    /
     
    @@ -104,7 +104,7 @@
    PRIMARY KEY (ipc_ip) );
    commit work;
     
    -drop table snort.base_roles;
    +drop table base_roles;
    CREATE TABLE base_roles ( role_id int NOT NULL,
    role_name varchar2(20) NOT NULL,
    role_desc varchar2(75) NOT NULL,
    @@ -128,4 +128,4 @@
    INSERT INTO base_roles (role_id, role_name, role_desc) VALUES (10000, 'Anonymous', 'Anonymous User' );
    INSERT INTO base_roles (role_id, role_name, role_desc) VALUES ( 50, 'ag_editor', 'Alert Group Editor' );
     
    -commit work;
    \ No newline at end of file
    +commit work;

     
    • edenCC

      edenCC - 2007-04-11

      thanks, Nikns Siankin,
      and the baseplus works much better than base-1.3.5
      "Nikns Siankin" < n i k n s @ s e c u r e . l v >
      >there are lot more improvements for ora9 in BASE+ project.
      >Try that: http://sourceforge.net/projects/baseplus

      >On Wed, Apr 11, 2007 at 01:36:55AM -0700, SourceForge.net wrote:
      >>
      >>Read and respond to this message at:
      >>https://sourceforge.net/forum/message.php?msg_id=4254726

       
      • Kevin Johnson

        Kevin Johnson - 2007-04-11

        I am biased but I would disagree. <grin>  But good luck with that.

        Kevin

         
    • Kevin Johnson

      Kevin Johnson - 2007-04-11

      I will look at this for the next release.

      Thanks
      Kevin

       

Get latest updates about Open Source Projects, Conferences and News.

Sign up for the SourceForge newsletter:





No, thanks