Posts tagged wordpress

WordPress: Reset Admin password

WordPress LogoI am not sure when WordPress started to create the default admin password for us  but couple times it happened that I lost my admin account password. There are serveral ways how you can perform the password reset for WordPress. Click here to read more.

This is my instrcution how I reset my “admin” account password for WordPress 2.7.1:

  • Open a linux shell and run where password is your own one: 
    echo -n password | md5sum
  • Open phpmyadmin and open your wordpress database; run following sql (please change the database to yours):
    UPDATE ’name-your-database’.'wp_users’
    SET ’user_pass’ =’ 5f4dcc3b5aa765d61d8327deb882cf99′ WHERE  ’wp_users’.'ID’ =1 LIMIT 1 ;
  • You can also run mysql; select the database with “use name-your-database;” and run the UPDATE sql from above.

 

WordPress: intranet and firewall

WordPress LogoI am huge fan of WordPress blogging platform. Recently I introduced the tool in a enterprise environment.

WordPress is running behind a restricted network and has no connection to the Internet. While installing and finalizing the virtual machine which is used to host WordPress I encountered one problem with it.  WordPress was slow!

I download  latest version of WordPress 2.7 and installed it on a Ubuntu JeOS 8.04 virtual machine appliance. The initial configuration went fine; but after I opened the admin area and the blog site it took ages before the pages were returned. WordPress was so slow within this Intranet environment that every action more than 30 seconds took.

Due to the fact virtual machine was sitting in a firewalled intranet environment the system could not connect to services sitting on the internet. 

See my worklog how I got WordPress working and pages are loaded in less than a second:

 

  • Goto ../wordpress/wp-includes and open http.php
  • Search for “ function request( $url, $args = array() ) {“
  • Add “return;”  behind global. E..g “  return;global $wp_version;” WordPress 2.7 http.php

 

Well now I disabled all interactions to the Internet, but I don’t need them in this enviroment. For more information goto here.

WordPress version 2.5 upgrade

image Two hours ago I upgraded Networknet.nl with WordPress version 2.5 and immediately after the php binaries and database were upgraded I hit my first problem. Within my Widgets Design Sidebar I have the Pages widget which shows all pages on the right side of my blog starting with “About me”.. VMware. For some topics I created pages instead of WordPress posts and linked those pages to a parent page; these two pages were excluded from “Pages Widget”. After the upgrade my pages widget become really huge showing 30+ pages. I did a search on WordPress support site and someone else already reported this problem; no response yet except me on this post. 

I didn’t want to downgrade my new WordPress version and therefore I used this method to query the parent pages and exclude them manually without doing the PHP code research how to exclude them.

  • Open phpmyadmin
  • Select your wordpress database
  • Open wp_posts and click SQL

image   

  • Paste this sql query
  <p>SELECT id<br>FROM 'wp_posts'<br>WHERE 'post_type' = 'page'<br>AND 'post_parent' NOT LIKE '0' </p>
  • Click GO button and click Export; I export to CSV to excel and copied all cells into Notepad.

image

  • Paste these pages into the exclude for your pages widget.

Dirty solution but I solved my problem in less than 5 minutes for now…