PCPIN Chat / IP filter not configured " SP: Blog

PCPIN Chat is a popular chat system which is also used by many STREAMPANEL customers.

PCPIN Chat: https://www.pcpin.com/
Version: 6.23 from Jul 3rd, 2013

The last development status of the chat system is now more than 4 years ago. Generally it is advisable to look for alternatives. In the current version of the chat system 6.23 it comes in newer MySQL versions, which are used by STREAMPANEL to compatibility problems.

Error message: "IP filter not configured"

The following instructions will help you to solve the problem accordingly:

Access the web-based administration of your web hosting package.
Open the menu item: "phpMyAdmin".
Click on your database name on the left side.
Click on the tab: "SQL" at the top.

Copy the following content into the input window

DROP TABLE IF EXISTS `pcpin_ipfilter`;
CREATE TABLE `pcpin_ipfilter` (
  `id` int(11) NOT NULL,
  `address` varchar(45) CHARACTER SET ascii NOT NULL DEFAULT '',
  `added_on` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `expires` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `description` text NOT NULL,
  `action` enum('d','a') NOT NULL DEFAULT 'd',
  `type` varchar(4) CHARACTER SET ascii COLLATE ascii_bin NOT NULL DEFAULT 'IPv4'
) ENGINE=MyISAM DEFAULT CHARSET=utf8 PACK_KEYS=0;

INSERT INTO `pcpin_ipfilter` (`id`, `address`, `added_on`, `expires`, `description`, `action`, `type`) VALUES
(1, '*.*.*.*', '2017-06-04 22:40:10', '0000-00-00 00:00:00', 'This rule allows all IPv4 addresses', 'a', 'IPv4'),
(2, '*', '2017-06-04 22:40:10', '0000-00-00 00:00:00', 'This rule allows all IPv6 addresses', 'a', 'IPv6');

ALTER TABLE `pcpin_ipfilter`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `address_2` (`address`,`action`),
  ADD KEY `address` (`address`),
  ADD KEY `added_on` (`added_on`),
  ADD KEY `expires` (`expires`),
  ADD KEY `action` (`action`),
  ADD KEY `type` (`type`);

If necessary, you must specify the prefix according to your tables. The example uses the default prefix "pcpin_".

After you have copied the code block in the input window, click OK at the bottom right.

Your PCPIN installation should now work as usual.