You are here
randrews - Sun, 2012/04/22 - 23:50
Hi,
How do I modify these settings? The WordPress Address and Site Address are both populated with the private IP address my VM is using (under Settings > General from the wp-admin page). No where in the setup or config did I see a prompt to change these. The boxes are both gray and I cannot change the fields.
The problem is some plugins use these, and they fail with the private IP. For example, a google XML site map does not work with http://privateip/xml.
Thanks
Forum:
Requires wp-config.php and database tweaks
The default configuration is to support all hostnames dynamically, but you change that in /var/www/wordpress/wp-config.php
There is a gotcha though, as wordpress stores those values in the database. You can change them as follows:
Thanks I modified my
Thanks I modified my config.php. I'm not sure on the DB side though - what's the easiest way to tweak that?
Thanks
Just run the code...
Just run the code that I posted above to update the database, but make sure your set SITE to your domain name before you do...
Hi, I'm getting this when I
Hi,
I'm getting this when I enter this from the CLI:
mysql --defaults-extra-file=/etc/mysql/debian.cnf <USE $NAME;
-bash: USE: No such file or directory
Hmm strange.
The command should be run by MySQL not bash (hence the mysql at the start). I don't know why it's not working because I don't know much about using MySQL at the commandline. From what I can gather the line should be launching MySQL command prompt as the default debian user and loading the wordpress DB. But I just tested it myself and sure enough, it errors. This is not quite so tidy, but do this instead (assuming your domain name is www.yoursite.com):
Which should open a priveledged mysql command prompt that looks like this:
At that prompt type these lines (substituting your real site url & pressing <enter> after each line):
I'm not sure why Alons code didn't work (perhaps it needs to be run as a script instead of just typed at the commandline?) but I tested what I posted here and it works.
Oops! bad html'ization
Sorry about that, the copy/paste I did to the comment area lost the formatting when converting to html, thats why it didn't work - there is a missing << EOF
Thanks Jeremy. Your code got
Thanks Jeremy. Your code got me through it.
Add new comment