• If you are still using CentOS 7.9, it's time to convert to Alma 8 with the free centos2alma tool by Plesk or Plesk Migrator. Please let us know your experiences or concerns in this thread:
    CentOS2Alma discussion

Problem with module psa-firewall

C

CesarV

Guest
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.
 
Is there any useful information in /tmp/autoinstaller3.log and /tmp/psa-firewall....log ?
 
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
 
How can I solve this problem?

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.

What can I do in this case?

Help me please.
 
Back
Top