WordPress: Hoʻoponopono Hoʻopilikia

Ua haki ka WordPress

ʻO ka pōʻino ʻo Hindenburgka hope mau lā I've been working furiously on getting my good friend Pat Coyle's blog back up. (My vacation continues to get more interesting – today it's snowing slightly… in April! Whatever happened to Global Warming?)

Makemake wau e kaʻana i ka mea i hana ʻia a laila kūkā e pili ana i nā hana pale aʻu i lawe ai a me pehea i hoʻoponopono ai.

Here's what happened:

  1. A pākuʻina kau Ua hele ka lawelawe ma ka fritz. A pākuʻina kau unuhi ke kikowaena i nā huakaʻi hele mai i kahi inoa kikowaena a hoʻohuli iā ia i ka kikowaena pūnaewele kūpono. Me kēia hanana, ua hoʻokaʻawale ʻo ia i 2 mau ʻano o ke kamaʻilio - ka inoa kikowaena i ka pūnaewele a me ka pūnaewele i ka waihona (ʻo kāna ʻikepili i kēia manawa i kahi kaʻana like).
  2. I complicated things by quickly moving his blog over to another server, not realizing that there was a DNS issue. This adds another level of complexity. Passwords in WordPress (and most other database applications) are uniquely encrypted by the server that they are on. If you move the site to another server, you've just disabled your ability to decrypt that password. Thankfully, WordPress (another great feature) has a password recovery system where you can reset your password via a link in an email.

Here's the immediate action that I took:

  1. Before this ever occurred, I have to say that I'm with a fantastic web hosting company who does comprehensive backups. I've never had an issue that they weren't able to correct through backups. I've heard nightmares from other folks on their blogs and sites being totally lost. I can't imagine what it's like to go through that. (E hoʻomoe i kaʻu hānai RSS a hiki iā ʻoe ke kiʻi i kahi coupon no kahi makahiki manuahi me kaʻu mea hoʻokipa).
  2. Ua hiki iaʻu ke ʻeʻe i ka Pūnaewele ma o FTP a loaʻa nā pūnaewele ʻelua a ka waihona pūnaewele. ʻO kekahi hiʻohiʻona o kaʻu pūʻali hoʻokipa ʻo ia hiki iaʻu ke komo i ka holoʻokoʻa VDS ma ʻō aku o ka pūnaewele maoli. Mālama ʻo MySQL i nā hōkeo ʻikepili i kahi waihona waihona (/ var / lib / MySQL /). Ua hiki iaʻu ke hoʻoiho i ka waihona ma ka kope ʻana i ka papa kuhikuhina kūloko. E kamaʻilio e pili ana i kahi papaʻa maikaʻi! ʻAʻohe mea lawe mai, ʻaʻohe mea hoʻolilo, ʻaʻohe nui o nā faila e hiki ke hana me… FTP wale nō.

I kēia manawa i loaʻa iaʻu ka pūnaewele a me ka waihona kikowaena kūloko, ua hanu wau i kahi hoʻomaha. Inā wau i kū wale ma aneʻi a hoʻomanawanui, inā ua holo ka pilikia DNS a hoʻi hou ʻo Pat i hope. Ua hōʻoia wau e kuhikuhi mau ana ka Domain Name i nā Servers inoa kūpono o kaʻu mea hoʻohana e hoʻohana ana Whois.net. Inā ʻoe e nānā i kāu kikowaena ma laila, aia nā kikowaena pūnaewele ma lalo pono o ka hōʻike.

ʻO kēia ka mea i alakaʻi iaʻu e manaʻo he hiki paha i ka pūnaewele ke hack. Pololei ka inoa kikowaena akā ʻo ka ʻaoʻao e piʻi aʻe nei kekahi ʻaoʻao weliweli e like me ka spam. Ua hoʻohana wau i ka Pākuʻi Live Headers to Firefox to ensure I actually wasn't being redirected – the typical hack that many people see. The site wasn't being redirected. I could have done some additional troubleshooting; however, I entered a support ticket with my host so their experts could begin investigating.

Ke hoʻihoʻi nei i kāu pūnaewele i kahi moʻokāki ʻokoʻa a hoʻokipa paha:

ʻAʻole wau i hōʻano hou iā Pat i ka mana hou loa o WordPress 2.1, PHP, a me MySQL i kēia manawa, no laila ua hoʻoholo wau ʻaʻohe manawa ʻoi aku ka maikaʻi ma mua o kēia manawa! Ua holoi wau i kāna moʻokāki kahiko a hoʻouka i kahi moʻokāki hou. Ua komo hou wau i kāna leka uila i ka ʻikepili a hoʻouka i ka waihona. WordPress 2.1 and Pat's content:

  • wp-ʻikepili hoʻouka papa kuhikuhi - ʻo kēia kahi e noho ai kāu mau kiʻi i hoʻoiho ʻia.
  • papa kuhikuhona wp-ʻikepili plugins - kāu plugins āpau (e hana i kēia ma hope ʻoiai he mau pilikia mana paha kāu.
  • papa kuhikuhi poʻomanaʻo wp-ʻikepili - kāu kumuhana.

I hope in a future release of WordPress that these 3 directories are root directories rather than sub-directories. It would make upgrading much easier! By this time, my host had found the DNS issue and properly redirected the site. Whew! Now Pat's page was coming back up with a WordPress Upgrade message. I clicked through to upgrade the database and he was back up… almost.

Remember the encryption issue I spoke about? Yea, Pat couldn't login because of it. His password no longer decrypted the value in the database properly so I had one more correction to make. I physically logged into the database and changed Pat's reply email address in the user table to my email address. I then utilized the “Lost my Password” feature to email myself a link to reset the password. After resetting the password, I logged in and changed Pat's email address back.

And now Pat is back up! Hindsight is 20/20… had I simply waited on my host, the issue would have been corrected. I really complicated the issue. However, Pat's now upgraded and running the best versions of everything. I'm sorry he was down so long, though. It doesn't take long to bounce back from downtime, but it is a nasty inconvenience! Sorry, Pat!

Ua aʻo ʻia nā haʻawina:

  1. Make sure you're with a host that has great backups.
  2. Papaʻa i kāu pūnaewele a me ka waihona pūnaewele a mālama iā lākou i kahi wahi palekana.
  3. If you're with a good host, rely on them to find and correct the issue.
  4. Inā pono ʻoe, neʻe i kahi hoʻokipa hou a i ʻole moʻokāki a hoʻomaopopo pehea e hoʻihoʻi ai i ka pūnaewele, database, a loaʻa hou kāu ʻōlelo huna.

ʻO kekahi ʻike hou aku

I kēia mau lā ua hoʻonui ka nui o nā noi i ka pili pūnaewele wikiwiki. ʻOiai, i kēia honua neʻe o ka pūnaewele, kelepona ukali ua hōʻoia i kona waiwai. Ke hiki mai i ka pūnaewele uea ʻole, aia nō i ka poʻe ke pili a nīnau Internet uea pehea mahalo nui ʻia no lākou. ʻOi aku no nā luna pūnaewele ka mea nui o uwea DSL ʻaʻole he nīnau hou. ʻO ka hapa nui o kēia mau luna pūnaewele makemake hale hana hoʻolālā pūnaewele no ka hoʻolālā a laila pono i kēia pilina wikiwiki e hoʻoiho iā ia. Ma ke ʻano he pae hou aʻe koi ʻia kēia pili wikiwiki i ke kaʻina o kalepa kūʻai aku ʻo search engine. He kanaka e loaʻa ana Microsoft hōʻoia hiki ke maʻalahi i nā pilikia āpau i ka pūnaewele ʻana o kēia mau pilina.

Pehea kou manaʻo?

Ke hoʻohana nei kēia pūnaewele i ka Akismet e ho'ēmi i ka spam. E aʻo pehea e hanaʻia ai kāuʻikeʻikepili.