1. Please take a little time for this simple survey! Thank you for participating!
    Dismiss Notice
  2. Dear Pleskians, please read this carefully! New attachments and other rules Thank you!
    Dismiss Notice
  3. Dear Pleskians, I really hope that you will share your opinion in this Special topic for chatter about Plesk in the Clouds. Thank you!
    Dismiss Notice

Problem with module psa-firewall

Discussion in 'Plesk 9.x for Linux Issues, Fixes, How-To' started by CesarV, Apr 19, 2010.

  1. CesarV

    CesarV Guest

    0
     
    Good afternoon. I'm having problem in module psa-firewall in Plesk 9.5.1 with CentOS 5.4. When I try to install the module, gives the following error:

    N) Install packages;
    S) show the list of packages, L) Return to list primary components;
    Q) Cancel installing;
    Select an action [N]:
    File downloading PSA_9.5.1/dist-rpm-CentOS-5-i386/opt/modules/firewall/psa-firewall-1.0.1-cos5.build95100410.11.i586.rpm: was skipped because of md5 checksum match.
    Starting installation of packages
    Installing the package psa-firewall-1.0.1-cos5.build95100410.11.i586
    Trying to start service mysqld ... done
    Trying to establish "test connection ... connected
    done
    ===> Setting up FILE owners
    ===> Installing database
    error:% post (psa-firewall-1.0.1-cos5.build95100410.11.i586) scriptlet failed, exit status 1

    I need to disable the iptables service? And in the case of psa-spamassassin, I also must disable the spamassassin service and just let the psa-spamassassin running?

    Thanks.
     
  2. IgorG

    IgorG Forums Analyst Staff Member

    49
    24%
    Joined:
    Oct 27, 2009
    Messages:
    24,572
    Likes Received:
    1,243
    Location:
    Novosibirsk, Russia
    Is there any useful information in /tmp/autoinstaller3.log and /tmp/psa-firewall....log ?
     
  3. CesarV

    CesarV Guest

    0
     
    Good morning IgorG. Thanks for your help.

    In the log file to install the module psa-firewall, appears the following information:

    cat psa-firewall_1.0.1_cos5.build95100410.11_installing.100420.09.40.log
    START psa-firewall-1.0.1-cos5.build95100410.11 installing AT Tue Apr 20 09:40:44 BRT 2010
    Trying to start service mysqld... mysqld (pid 3047) is running...
    done
    Trying to establish test connection... connected
    done
    ===> Unregistering module
    ===> Uninstalling configuration files
    Trying to unregister service psa-firewall... using /sbin/chkconfig
    ===> Uninstalling database
    ERROR 1051 (42S02) at line 1: Unknown table 'module_firewall_objects'

    =====================================
    100420 9:40:44 INNODB MONITOR OUTPUT
    =====================================
    Per second averages calculated from the last 12 seconds
    ----------
    SEMAPHORES
    ----------
    OS WAIT ARRAY INFO: reservation count 4369, signal count 4361
    Mutex spin waits 0, rounds 31555, OS waits 219
    RW-shared spins 8058, OS waits 3982; RW-excl spins 211, OS waits 155
    ------------
    TRANSACTIONS
    ------------
    Trx id counter 0 60740150
    Purge done for trx's n:eek: < 0 60740113 undo n:eek: < 0 0
    History list length 0
    Total number of lock structs in row lock hash table 0
    LIST OF TRANSACTIONS FOR EACH SESSION:
    ---TRANSACTION 0 0, not started, process no 3047, OS thread id 2422209424
    MySQL thread id 922508, query id 21549667 localhost admin
    show innodb status
    --------
    FILE I/O
    --------
    I/O thread 0 state: waiting for i/o request (insert buffer thread)
    I/O thread 1 state: waiting for i/o request (log thread)
    I/O thread 2 state: waiting for i/o request (read thread)
    I/O thread 3 state: waiting for i/o request (write thread)
    Pending normal aio reads: 0, aio writes: 0,
    ibuf aio reads: 0, log i/o's: 0, sync i/o's: 0
    Pending flushes (fsync) log: 0; buffer pool: 0
    11607 OS file reads, 102237 OS file writes, 90510 OS fsyncs
    0.17 reads/s, 16384 avg bytes/read, 1.42 writes/s, 1.00 fsyncs/s
    -------------------------------------
    INSERT BUFFER AND ADAPTIVE HASH INDEX
    -------------------------------------
    Ibuf: size 1, free list len 3, seg size 5,
    1214 inserts, 1214 merged recs, 260 merges
    Hash table size 34679, used cells 12988, node heap has 17 buffer(s)
    2194.65 hash searches/s, 44.08 non-hash searches/s
    ---
    LOG
    ---
    Log sequence number 0 2706266410
    Log flushed up to 0 2706266410
    Last checkpoint at 0 2706266410
    0 pending log writes, 0 pending chkp writes
    83856 log i/o's done, 0.50 log i/o's/second
    ----------------------
    BUFFER POOL AND MEMORY
    ----------------------
    Total memory allocated 19784214; in additional pool allocated 1048576
    Buffer pool size 512
    Free buffers 0
    Database pages 495
    Modified db pages 0
    Pending reads 0
    Pending writes: LRU 0, flush list 0, single page 0
    Pages read 16358, created 783, written 17681
    0.17 reads/s, 0.00 creates/s, 0.75 writes/s
    Buffer pool hit rate 1000 / 1000
    --------------
    ROW OPERATIONS
    --------------
    0 queries inside InnoDB, 0 queries in queue
    1 read views open inside InnoDB
    Main thread process no. 3047, id 2996927376, state: sleeping
    Number of rows inserted 74442, updated 6323, deleted 3726, read 73152153
    0.00 inserts/s, 0.42 updates/s, 0.00 deletes/s, 1606.62 reads/s
    ----------------------------
    END OF INNODB MONITOR OUTPUT
    ============================

    ERROR 1051 (42S02) at line 1: Unknown table 'module_firewall_rules'

    =====================================
    100420 9:40:44 INNODB MONITOR OUTPUT
    =====================================
    Per second averages calculated from the last 0 seconds
    ----------
    SEMAPHORES
    ----------
    OS WAIT ARRAY INFO: reservation count 4369, signal count 4361
    Mutex spin waits 0, rounds 31555, OS waits 219
    RW-shared spins 8058, OS waits 3982; RW-excl spins 211, OS waits 155
    ------------
    TRANSACTIONS
    ------------
    Trx id counter 0 60740150
    Purge done for trx's n:eek: < 0 60740113 undo n:eek: < 0 0
    History list length 0
    Total number of lock structs in row lock hash table 0
    LIST OF TRANSACTIONS FOR EACH SESSION:
    ---TRANSACTION 0 0, not started, process no 3047, OS thread id 2433981328
    MySQL thread id 922515, query id 21549687 localhost admin
    show innodb status
    --------
    FILE I/O
    --------
    I/O thread 0 state: waiting for i/o request (insert buffer thread)
    I/O thread 1 state: waiting for i/o request (log thread)
    I/O thread 2 state: waiting for i/o request (read thread)
    I/O thread 3 state: waiting for i/o request (write thread)
    Pending normal aio reads: 0, aio writes: 0,
    ibuf aio reads: 0, log i/o's: 0, sync i/o's: 0
    Pending flushes (fsync) log: 0; buffer pool: 0
    11607 OS file reads, 102237 OS file writes, 90510 OS fsyncs
    0.00 reads/s, 0 avg bytes/read, 0.00 writes/s, 0.00 fsyncs/s
    -------------------------------------
    INSERT BUFFER AND ADAPTIVE HASH INDEX
    -------------------------------------
    Ibuf: size 1, free list len 3, seg size 5,
    1214 inserts, 1214 merged recs, 260 merges
    Hash table size 34679, used cells 12988, node heap has 17 buffer(s)
    0.00 hash searches/s, 0.00 non-hash searches/s
    ---
    LOG
    ---
    Log sequence number 0 2706266410
    Log flushed up to 0 2706266410
    Last checkpoint at 0 2706266410
    0 pending log writes, 0 pending chkp writes
    83856 log i/o's done, 0.00 log i/o's/second
    ----------------------
    BUFFER POOL AND MEMORY
    ----------------------
    Total memory allocated 19784214; in additional pool allocated 1048576
    Buffer pool size 512
    Free buffers 0
    Database pages 495
    Modified db pages 0
    Pending reads 0
    Pending writes: LRU 0, flush list 0, single page 0
    Pages read 16358, created 783, written 17681
    0.00 reads/s, 0.00 creates/s, 0.00 writes/s
    No buffer pool page gets since the last printout
    --------------
    ROW OPERATIONS
    --------------
    0 queries inside InnoDB, 0 queries in queue
    1 read views open inside InnoDB
    Main thread process no. 3047, id 2996927376, state: sleeping
    Number of rows inserted 74442, updated 6323, deleted 3726, read 73152153
    0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s
    ----------------------------
    END OF INNODB MONITOR OUTPUT
    ============================

    STOP psa-firewall-1.0.1-cos5.build95100410.11 installing AT Tue Apr 20 09:40:44 BRT 2010
     
  4. CesarV

    CesarV Guest

    0
     
    How can I solve this problem?

    What can I do in this case?

    Help me please.
     
Loading...