Hi. Any suggestions about changing DB_PREFIX during the remote provisioning, would love to see database tables begin with {db_prefix}? Tried to change production/wordpress_sites.yml and wordpress-setup/tasks/database.yml with no luck

[image] eshimischi: Tried to change production/wordpress_sites.yml and wordpress-setup/tasks/database.yml with no luck Specifically what did you try? (Post code) I haven’t tried it, but setting a DB_PREFIX env var before provisioning your site should work

I’m confused about the use case for doing this honestly. Wouldn’t you just want to change your table prefix during development to whatever it was going to be, then this becomes a non issue.

As you know its a kind of security issue, there were a lot of articles about it, one more extra way to protect your wordpress blog and database against hackers.

So sorry for my english, but Bedrock has config/application.php with $table_prefix = env(‘DB_PREFIX’) ?: ‘wp_’; as i do understand DB_PREFIX may come from .env file that generated during the provisioning , but how to add this DB_PREFIX to .env during the generation. I thought about adding a line to …

See: [image] Custom env variables trellis trellis If you want custom variables in the .env file created on deploy, each WP site will create env variables using the wordpress_env_defaults from deploy.yml. To override or add to these env variables, you can edit group_vars/<e…

If I want to rerun the server.yml playbook tag that generates the .env file, what tag would I run?

just add a parameter to the env block in group_vars/<environment>/vault.yml: db_prefix: "wpextended_" In there with db_password, auth_key, etc. That’s the source for the environment variables trellis inserts into the Bedrock installation, if I understand correctly.

What I meant is that I don’t want to rerun all of the tasks in the playbook. So I was wondering which specific task controls the .env creation. Also, it seems from my tests that once a .env is created, you can no longer change it through the playbook. Does anyone else experience this?

.env creation would be app specific so it would be a task in the deploy.yml playbook not server.yml. And as far as I know with deploys, you shouldn’t/can’t run specific tags (unless you want to check the connection ). Each deploy is it’s own release, unlike the server which is being modified when it’…

How to change WordPress DB prefix during provisioning

trellis

ben December 2, 2016, 8:28pm 6

See:

Also env in https://roots.io/trellis/docs/wordpress-sites/