Database Initialization and Admin Email Mapping issues

Resolved itpixie
(@itpixie)

10 years, 7 months ago

Hi OSE Firewall team,

Thank you so much for resolving the PDO issue (http://wordpress.org/support/topic/updated-to-202-getting-fatal-php-error-on-site)

I do have some questions/issues using the plugin, now that I can get it to work with my site:

As I was initializing the database for the first time, the process stopped/got stuck (or so it seems) half way through. So I closed the pop-up window and the page refreshed, it said everything was ready to do. How can I tell that all the database tables got created and initialized correctly? Or is there a way for me to (force) re-initialize everything?

I also notice that in the Admin Email Mapping config page there is no data. When I try to add myself to receive email alerts, my WP user ID is never shown. As I poked around my database, I noticed the table ose_app_admin is empty. I would imagine my WP user ID should be in the table… So how do I populate this table. And I assume the Admin Email Mapping config page not showing my WP user ID because ose_app_admin table is empty? Is all this a sign that my ose tables didn’t get initialized correctly?

Thank you again,
itpixie

http://wordpress.org/plugins/ose-firewall/

Viewing 5 replies - 1 through 5 (of 5 total)

Plugin Author Helix.L
(@prohelix)

10 years, 7 months ago

Hi itpixie

For the database tables creation i, we tried it again in our local testing server, it works fine, may we have the temp access your website and check it? If so, please send the login in our secure support center here:

https://www.protect-website.com/support-center/

For the Email-Admin Mapping issue, we fixed it in version 2.1.2, please upgrade to that version, the issue will be resolved.

Hope this helps 🙂
Best wishes
Helix
[ Signature moderated. ]

Plugin Author Helix.L
(@prohelix)

10 years, 7 months ago

Hi itpixie

BTW, we wrote a tutorial here for how to use Firebug to report the error messages you received in the database creation process

https://www.protect-website.com/using-firebug-report-bugs/

so you can check the error without sending the temp admin account to us, please copy-paste the error messages you see in the console so we can track down the error messages and fix it asap.

Best wishes
Helix
[ Signature moderated. ]
Thread Starter itpixie
(@itpixie)

10 years, 7 months ago
Hello Helix,

Thank you so much for the Firebug info. One of the sites that I’m having problem initializing the database has the following SQL error:
<h1>CDbException</h1>
<p>CDbCommand failed to execute the SQL statement: SQLSTATE[HY000]: General error: 1005 Can’t create table ‘fireflys_wordpressdb.ffsd_osefirewall_acl’ (errno: 121). The SQL statement executed was:

CREATE TABLE IF NOT EXISTS ffsd_osefirewall_acl (
id INT(11) NOT NULL AUTO_INCREMENT ,
name VARCHAR(300) NOT NULL ,
status TINYINT(1) NOT NULL ,
datetime DATETIME NOT NULL ,
score TINYINT(3) NOT NULL ,
country_code CHAR(2) NULL DEFAULT NULL ,
host VARCHAR(300) NULL DEFAULT NULL ,
notified TINYINT(1) NULL DEFAULT NULL ,
referers_id INT(11) NOT NULL ,
pages_id INT(11) NOT NULL ,
visits INT(11) NOT NULL ,
PRIMARY KEY (id) ,
INDEX idx1_oseacl (referers_id ASC) ,
INDEX idx2_oseacl (pages_id ASC) ,
CONSTRAINT fk1_oseacl
FOREIGN KEY (referers_id )
REFERENCES ffsd_osefirewall_referers (id )
ON UPDATE CASCADE,
CONSTRAINT fk2_oseacl
FOREIGN KEY (pages_id )
REFERENCES ffsd_osefirewall_pages (id )
ON UPDATE CASCADE)
ENGINE = InnoDB
AUTO_INCREMENT = 1
DEFAULT CHARACTER SET = utf8 (/home/fireflys/public_html/dealers/wp-content/plugins/ose-firewall/framework/db/CDbCommand.php:541)</p>
```
#0 /home/fireflys/public_html/dealers/wp-content/plugins/ose-firewall/framework/db/CDbCommand.php(376): CDbCommand->queryInternal('', 0, Array)
#1 /home/fireflys/public_html/dealers/wp-content/plugins/ose-firewall/framework/oseframework/db/oseDB2.php(58): CDbCommand->query()
#2 /home/fireflys/public_html/dealers/wp-content/plugins/ose-firewall/framework/oseframework/installer/wordpress.php(43): oseDB2->query()
#3 /home/fireflys/public_html/dealers/wp-content/plugins/ose-firewall/protected/models/DashboardModel.php(159): oseInstaller->createTables('/home/fireflys/...')
#4 /home/fireflys/public_html/dealers/wp-content/plugins/ose-firewall/protected/models/DashboardModel.php(56): DashboardModel->createTables()
#5 /home/fireflys/public_html/dealers/wp-content/plugins/ose-firewall/protected/controllers/DashboardController.php(34): DashboardModel->actionCreateTables()
#6 /home/fireflys/public_html/dealers/wp-content/plugins/ose-firewall/framework/web/actions/CInlineAction.php(49): DashboardController->actionCreateTables()
#7 /home/fireflys/public_html/dealers/wp-content/plugins/ose-firewall/framework/web/CController.php(308): CInlineAction->runWithParams(Array)
#8 /home/fireflys/public_html/dealers/wp-content/plugins/ose-firewall/framework/web/CController.php(286): CController->runAction(Object(CInlineAction))
#9 /home/fireflys/public_html/dealers/wp-content/plugins/ose-firewall/framework/web/CController.php(265): CController->runActionWithFilters(Object(CInlineAction), Array)
#10 /home/fireflys/public_html/dealers/wp-content/plugins/ose-firewall/framework/web/CWebApplication.php(282): CController->run('createTables')
#11 /home/fireflys/public_html/dealers/wp-content/plugins/ose-firewall/framework/oseframework/ajax/oseAjax.php(28): CWebApplication->runController('dashboard/creat...')
#12 [internal function]: oseAjax::runAction('')
#13 /home/fireflys/public_html/dealers/wp-includes/plugin.php(406): call_user_func_array('oseAjax::runAct...', Array)
#14 /home/fireflys/public_html/dealers/wp-admin/admin-ajax.php(72): do_action('wp_ajax_createT...')
#15 {main}
```
There are 2 WordPress installs using the same database, though each has their own set of tables (with different table prefix). Would that be the reason (2 WP installs using the same database) I’m encountering the sQL error? I had no problem initializing OSE Firewall database/tables on the 1st WP install.

My other question is:
Is there a way to force database initialization again, other than deleting the existing OSE Firewall tables?

Thanks,
itpixie
Thread Starter itpixie
(@itpixie)

10 years, 7 months ago
Hello OSE Firewall team,

After trying to re-initialize the OSE Firewall database by dropping all OSE Firewall related tables, here’s the error I see in Firebug:
Ext.Error: You’re trying to decode an invalid JSON String: <h1>CDbException</h1> <p>CDbCommand failed to execute the SQL statement: SQLSTATE[42000]: Syntax error or access violation: 1142 CREATE VIEW command denied to user ‘itpixiec_admin’@’localhost’ for table ‘itpx_osefirewall_aclipmap’. The SQL statement executed was: CREATE VIEW itpx_osefirewall_aclipmap AS select acl.id AS id,acl.name AS name,acl.status AS status,acl.datetime AS datetime,acl.score AS score,acl.visits AS visits, acl.country_code AS country_code,acl.host AS host,acl.notified AS notified,acl.referers_id AS referers_id,acl.pages_id AS pages_id,ip.id AS ipid,ip.ip32_start AS ip32_start,ip.ip32_end AS ip32_end,ip.iptype AS iptype from (itpx_osefirewall_acl acl left join itpx_osefirewall_iptable ip on((acl.id = ip.acl_id))); (/home/itpixiec/public_html/wp-content/plugins/ose-firewall/framework/db/CDbCommand.php:541)</p>
```
#0 /home/itpixiec/public_html/wp-content/plugins/ose-firewall/framework/db/CDbCommand.php(376): CDbCommand->queryInternal('', 0, Array) #1 /home/itpixiec/public_html/wp-content/plugins/ose-firewall/framework/oseframework/db/oseDB2.php(58): CDbCommand->query() #2 /home/itpixiec/public_html/wp-content/plugins/ose-firewall/protected/library/oseFirewallInstaller.php(100): oseDB2->query() #3 /home/itpixiec/public_html/wp-content/plugins/ose-firewall/protected/models/DashboardModel.php(196): oseFirewallInstaller->createACLIPView('/home/itpixiec/...') #4 /home/itpixiec/public_html/wp-content/plugins/ose-firewall/protected/models/DashboardModel.php(86): DashboardModel->createACLIPView() #5 /home/itpixiec/public_html/wp-content/plugins/ose-firewall/protected/controllers/DashboardController.php(34): DashboardModel->actionCreateTables() #6 /home/itpixiec/public_html/wp-content/plugins/ose-firewall/framework/web/actions/CInlineAction.php(49): DashboardController->actionCreateTables() #7 /home/itpixiec/public_html/wp-content/plugins/ose-firewall/framework/web/CController.php(308): CInlineAction->runWithParams(Array) #8 /home/itpixiec/public_html/wp-content/plugins/ose-firewall/framework/web/CController.php(286): CController->runAction(Object(CInlineAction)) #9 /home/itpixiec/public_html/wp-content/plugins/ose-firewall/framework/web/CController.php(265): CController->runActionWithFilters(Object(CInlineAction), Array) #10 /home/itpixiec/public_html/wp-content/plugins/ose-firewall/framework/web/CWebApplication.php(282): CController->run('createTables') #11 /home/itpixiec/public_html/wp-content/plugins/ose-firewall/framework/oseframework/ajax/oseAjax.php(28): CWebApplication->runController('dashboard/creat...') #12 [internal function]: oseAjax::runAction('') #13 /home/itpixiec/public_html/wp-includes/plugin.php(406): call_user_func_array('oseAjax::runAct...', Array) #14 /home/itpixiec/public_html/wp-admin/admin-ajax.php(72): do_action('wp_ajax_createT...') #15 {main}
```
And Admin Email mapping is still not working for me… My WP user id still doesn’t show up in the drop-down list, and I am unable to save any mapping even if I manually type in my user id.

Thanks,
itpixie
Plugin Author Helix.L
(@prohelix)

10 years, 7 months ago

Thanks itpixie

For the error, I wrote the tutorial here:

https://www.protect-website.com/create-view-command-denied-user-error/

This can resolve the problem.

For the Admin-mapping issue, we will add a manual admin email adding function into the system in the next version to resolve this.

Hope this helps. 🙂
Best wishes
Helix

Viewing 5 replies - 1 through 5 (of 5 total)

The topic ‘Database Initialization and Admin Email Mapping issues’ is closed to new replies.