檢視次數:
為了解決這個問題：
  1. 使用root帳號登入IMSVA CLI介面
  2. 輸入下方指令存取PostgreSQL資料庫：
  3. /opt/trend/imss/PostgreSQL/bin/psql imss sa
  4. Run the commands below in the PostgreSQL:
    1. DROP VIEW t_blockedip;
    2. CREATE VIEW t_blockedip AS SELECT t_iprule."domain", t_messagesdropped.scanner_id, t_messagesdropped.upstreammta_ip AS ip, t_messagesdropped.recordtime AS createtime, t_messagesdropped."type", t_messagesdropped.count FROM (t_messagesdropped LEFT JOIN t_iprule ON (((ipint2string(t_messagesdropped.upstreammta_ip))::text = (ipint2string(t_iprule.ip))::text)));
完整輸出畫面如下：
[root@IMSVA ~]# /opt/trend/imss/PostgreSQL/bin/psql imss sa
Welcome to psql 8.1.3, the PostgreSQL interactive terminal.
Type: \copyright for distribution terms
\h for help with SQL commands
\? for help with psql commands
\g or terminate with semicolon to execute query
\q to quit
imss=# DROP VIEW t_blockedip;
DROP VIEW
imss=# CREATE VIEW t_blockedip AS SELECT t_iprule."domain", t_messagesdropped.scanner_id, t_messagesdropped.upstreammta_ip AS ip, t_messagesdropped.recordtime AS createtime, t_messagesdropped."type", t_messagesdropped.count FROM (t_messagesdropped LEFT JOIN t_iprule ON (((ipint2string(t_messagesdropped.upstreammta_ip))::text = (ipint2string(t_iprule.ip))::text)));
CREATE VIEW
imss=# \q
[root@IMSVA85 ~]#
 
關鍵字: in progress,stuck,reports,report in progress