Sporadic "access denied" on Trellis Multisite

olafjlindstrom · September 3, 2015, 9:01am

I started out a project yesterday with a Trellis/Bedrock-based multisite. Vagrant up worked just fine and the site works for a while.

But after some random amount of time(a few minutes) it returns:

Warning: mysqli_real_connect(): (HY000/1045): Access denied for user 'devuser'@'localhost' (using password: YES) in /srv/www/sitename.com/current/web/wp/wp-includes/wp-db.php on line 1443

Deprecated: mysql_connect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in /srv/www/sitename.com/current/web/wp/wp-includes/wp-db.php on line 1473

Warning: mysql_connect(): Access denied for user 'devuser'@'localhost' (using password: YES) in /srv/www/sitename.com/current/web/wp/wp-includes/wp-db.php on line 1473

Checking the logs gives something like this whatever url you try to access(front end/admin doesn’t matter):

2015/09/03 08:53:21 [error] 29655#0: *231 FastCGI sent in stderr: "PHP message: PHP Notice:  Undefined index: jvcf7_highlight_error_field in /srv/www/sitename.com/current/web/app/plugins/jquery-validation-for-contact-form-7/plugin_interface.php on line 39" while reading response header from upstream, client: 192.168.90.1, server: sitename.dev, request: "GET /wp/wp-admin/options-general.php?page=jquery-validation-for-contact-form-7%2Fplugin_interface.php&hidemsg=1 HTTP/1.1", upstream: "fastcgi://unix:/var/run/php5-fpm-wordpress.sock:", host: "sitename.dev", referrer: "http://sitename.dev/wp/wp-admin/"

The wierd thing is that after some time it starts working again, seems really random.

No other errors or things that I could think of to fix this issue. Tried checking for solutions in:

github.com/roots/trellis

Fix Multisite

opened 04:18PM - 08 Jul 15 UTC

closed 08:11PM - 29 Aug 15 UTC

austinpray

bug help wanted

1. clone trellis 2. clone blank bedrock 3. configure development for multisite a…s per wiki instructions. For posterity here are the current multisite wiki instructions: https://gist.github.com/austinpray/b800ed3ec89987e6d784 4. vagrant up It will error out. There are three problems I can see: - [ ] wiki needs updating - [x] [wp installed?](https://github.com/roots/trellis/blob/70ebd4527978ee88bfddd2d1b240f7c01ed20158/roles/wordpress-install/tasks/main.yml#L23-L30) task will always fail - [x] No wildcard in nginx `server_name` ### wiki needs updating I'm pretty sure you cannot add this stuff: ``` define('WP_ALLOW_MULTISITE', true); define('MULTISITE', true); define('SUBDOMAIN_INSTALL', true); // Set to false if using subdirectories define('DOMAIN_CURRENT_SITE', getenv('DOMAIN_CURRENT_SITE')); define('PATH_CURRENT_SITE', '/'); define('SITE_ID_CURRENT_SITE', 1); define('BLOG_ID_CURRENT_SITE', 1); ``` Before running the playbook or it will cause DB errors. ### [wp installed?](https://github.com/roots/trellis/blob/70ebd4527978ee88bfddd2d1b240f7c01ed20158/roles/wordpress-install/tasks/main.yml#L23-L30) task will always fail WordPress multisite will ALWAYS spit out garbage when trying to install. Which makes this: https://github.com/roots/trellis/blob/70ebd4527978ee88bfddd2d1b240f7c01ed20158/roles/wordpress-install/tasks/main.yml#L30 kinda flimsy. Perhaps we should just look at exit codes? ### No wildcard in nginx `server_name` for subdomains We need to do this for subdomains: ``` server_name example.dev *.example.dev ``` Here is my hacked together code: ``` server_name {% for host in item.value.site_hosts %} {{ host }} {% if item.value.multisite.subdomains %} *.{{ host }} {% endif %} {% endfor %} ``` Please tell me jinja2 has some sort of prefix filter I don't know about.

https://discourse.roots.io/t/error-establishing-a-database-connection/3818

Also checked that there’s no manual entries for the urls in my host machines /etc/hosts-file.

Anyone having a clue on how to fix this? Would be really appreciated!

mathewc · September 3, 2015, 8:51pm

Second error notice is unrelated to db connection issues - are you seeing any other errors in your logs?

Do you get the errors if you disable all plugins?

olafjlindstrom · September 7, 2015, 3:20pm

The problem lied inside one of the plugins, that used “mysql_connect” instead of WPDB.

Didn’t seem like it at first but after a while of not having the plugin activated the problem didn’t show up anymore. Guessing it was the microcache that I had activated.

Thank you for your answer and for taking your time alanc!