Uploaded image for project: 'Openfire'
  1. Openfire
  2. OF-692

Node column in ofSecurityAuditLog table should accept NULL entries

    XMLWordPrintable

    Details

      Description

      After installing Openfire with MSSQL a user gets such messages in warn.log:

      2013.08.13 14:11:07 org.jivesoftware.openfire.security.DefaultSecurityAuditProvider - Error trying to insert a new row in ofSecurityAuditLog:
      java.sql.SQLException: Cannot insert the value NULL into column 'node', table 'openfire-predev.dbo.ofSecurityAuditLog'; column does not allow nulls. INSERT fails.

      to fix this openfire_sqlserver.sql should be changed to this:

      CREATE TABLE ofSecurityAuditLog (
      msgID INTEGER NOT NULL,
      username NVARCHAR(64) NOT NULL,
      entryStamp BIGINT NOT NULL,
      summary NVARCHAR(255) NOT NULL,
      node NVARCHAR(255) NULL,
      details NTEXT,
      CONSTRAINT ofSecurityAuditLog_pk PRIMARY KEY (msgID)
      );

        Attachments

          Activity

            People

            Assignee:
            tevans Tom Evans
            Reporter:
            wroot wroot
            Votes:
            1 Vote for this issue
            Watchers:
            3 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: