I have made updates to the plug and I have a problem

OSExcel,

I believe this is the line you are looking for from the databases.

(43,'file_ext','htm,html,shtm,shtml,css,js,php,php3,php4,php5,inc,
phtml,jpg,jpeg,gif,png,bmp,c,sh,pl,perl,cgi,txt','vsscan'),

I will have to confirm that is the actual backup from the site prior to restoration, see below.

Here are the other issues we encountered: some of which I think you are or have addressed,

version 2.02 I think : running WordPress 3.6. – 3.6.1

– 400k lines of code to the databases of even a brand new, fresh install of WordPress. (fresh blank WP less then 500k size DB, OSEFW fresh install 2 megs). (being addressed you said)

– over 250k lines of SQL code related to just GEO IP aspect (must be a better method)

– we encountered errors with the ability to import the sql sections of the DB backups as they pertained to the OSE Firewall. This was due to additional restrictions between foreign key and master key access within the DB. This meant we could not do an active import of the SQL database as long as the OSE SQL sections were intact. (upon deleting ose tables and structure elements import worked fine)

– Additionally the SQL Import required DB Privileges that were inappropriate to traditional website DB Server access (Master DB USER RIGHTS instead of a Standard DB USER RIGHTS).

mysql> GRANT SUPER ON *.* TO user@'localhost' IDENTIFIED BY 'password';

We consider this to be a potentially risky issue. Don’t have the error message handy, Wanted “SUPER” access (I believe was the error) and could not import with my normal full privileged user in phpmyadmin. (cpanel hosted)

As I stated, I can go back through my files and send you copies of the DB sections from your plugin. Please just try a more standardized path that end user might take.

TO get the DB errors I simply took my standard zipped sql dump file and deleted all tables and tried to do a fresh import. It would not process directly within the phpadmin panel.

I do not know if this would impact other “re-installation methods”, as I like using mysql. ?? however this is the first plugin to which I would need to alter db permissions to make the import.

Thanks Shadowood

Re: (43,’file_ext’,’htm,html,shtm,shtml,css,js,php,php3,php4,php5,inc,
phtml,jpg,jpeg,gif,png,bmp,c,sh,pl,perl,cgi,txt’,’vsscan’),

— This has been improved in since 2.1.0

Re: version 2.02 I think : running WordPress 3.6. – 3.6.1 – 400k lines of code to the databases of even a brand new, fresh install of WordPress. (fresh blank WP less then 500k size DB, OSEFW fresh install 2 megs). (being addressed you said)

— This is improved as well in 2.1.0,

Re: – over 250k lines of SQL code related to just GEO IP aspect (must be a better method)

— This table is dropped in 2.1.0, we utilized the remote querying method to achieve the goal

Re: – Additionally the SQL Import required DB Privileges that were inappropriate to traditional website DB Server access (Master DB USER RIGHTS instead of a Standard DB USER RIGHTS).

— Actually it is not necessary to grant super to the user, we only need to create views, e.g.

GRANT CREATE VIEW ON abcd.* TO ‘user’@’localhost’;

We chose to use views for better organization of the codes. However, since some hosting company does not provide create view privilege to their users, we will drop the views in 2.3.0 and use run-time SQL queries instead.

Thank you for your report. They are really helpful. ??
Best wishes
Helix

OSExcel,

Always glad to help out fellow programmers. when you get 2.3 out of the gate I will reevaluate and retest for any issues.

You guys keep up the good work.

Hi shadowood,

Recently, we improved our plugin’s features and UI, even added 2 new functions (Country Blocking and Backup) for free. We have released the new beta version for developers only, If you are interested in testing this new version and provide feedback, it will be very much appreciated! Thank you very much in advanced!

Best Regards,

Chase