server error log filling up
-
So I am using your iThemes plugin on my multisite installation. All was fine from a front end perspective, but then my database guy informed me our httpd error.log is filling up. We are using staged servers with 4 multiple public web servers, so the error I am getting a each web server is:
[Tue May 12 06:17:00 2015] [error] [client 10.28.192.9] WordPress database error CREATE command denied to user 'user'@'webserver1' for table 'wp_itsec_lockouts' for query CREATE TABLE wp_itsec_lockouts (\n\t\t\t\tlockout_id bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,\n\t\t\t\tlockout_type varchar(20) NOT NULL,\n\t\t\t\tlockout_start datetime NOT NULL,\n\t\t\t\tlockout_start_gmt datetime NOT NULL,\n\t\t\t\tlockout_expire datetime NOT NULL,\n\t\t\t\tlockout_expire_gmt datetime NOT NULL,\n\t\t\t\tlockout_host varchar(20),\n\t\t\t\tlockout_user bigint(20) UNSIGNED,\n\t\t\t\tlockout_username varchar(20),\n\t\t\t\tlockout_active int(1) NOT NULL DEFAULT 1,\n\t\t\t\tPRIMARY KEY (lockout_id),\n\t\t\t\tKEY lockout_expire_gmt (lockout_expire_gmt),\n\t\t\t\tKEY lockout_host (lockout_host),\n\t\t\t\tKEY lockout_user (lockout_user),\n\t\t\t\tKEY lockout_username (lockout_username),\n\t\t\t\tKEY lockout_active (lockout_active)\n\t\t\t\t) DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci made by require('wp-load.php'), require_once('wp-config.php'), require_once('/path/to/wordpress/wp-configs/wp-config-prod.php'), require_once('wp-settings.php'), do_action('init'), call_user_func_array, ITSEC_Lockout->check_lockout, ITSEC_Lib::create_database_tables, dbDelta
So where it says user’@’webserver1′, on each server error.log it indicates its server name “webserver2”, “webserver3”, etc in that error message. But there are no errors on my staging servers. My DBA says that since the user has CREATE privileges on staging, that should be applied to the public servers as well.
Does anyone know how to fix this error.log issue? Or have experienced this before.
- The topic ‘server error log filling up’ is closed to new replies.