Posts Tagged ‘upgrade’

WordPress Mu 2.7.1 and Multi-Site Manager

Friday, April 24th, 2009

I have neglected this blog due to routine work lately. I have done some things, but not much to write home about, and being swamped with work, I just lacked the initiative to add new stuff, or to dwell into new technologies and problems. Routine is routine, and upgrade to WordPress Mu sometimes introduces new issues.

A very useful plugin called “Multi-Site Manager” is available for, well, managing easily multi-site configuration of a single WPMU from the GUI.

I have been using it for a while, and I was happy with it, however, after the latest Mu upgrade (2.7.1), a single problem appeared – you cannot manage sites from a newly created domain. Already existing domains functionality was not changed, but only new ones.

I through myself knee deep into its MySQL data, and got to the following workaround. This should be incorporated into the code, but me being such a lame PHP coder, maybe it’s not the best idea that I do it…

Problem:

You have created a new site, but from within its admin you cannot view the site admin panel. Manually entering the URL results in a “Permission Denied” error message.

Solution:

Login to your MySQL DB.

Use the MU database.

Find your new site ID:

select * from wp_site;

Write down the site number. Also, write down another site number – a small site would be best.

Get the correct entry for site_admins from some other blog

Select * from wp_sitemeta where meta_key=’site_admins’;

Response should look something like this:

+———+———+————-+——————————————+
| meta_id | site_id | meta_key | meta_value |
+———+———+————-+——————————————+
| 8 | 1 | site_admins | a:1:{i:0;s:5:”adm”;} |
| 467 | 21 | site_admins | a:1:{i:0;s:5:”adm”;} |
| 245 | 13 | site_admins | a:1:{i:0;s:5:”adm”;} |
| 45 | 3 | site_admins | a:1:{i:0;s:5:”adm”;} |
| 28 | 2 | site_admins | a:1:{i:0;s:5:”adm”;} |
| 62 | 5 | site_admins | a:1:{i:0;s:5:”adm”;} |
| 126 | 8 | site_admins | a:1:{i:0;s:5:”adm”;} |
+———+———+————-+——————————————+

Create a site_admin entry for your new site:

insert into wp_sitemeta (site_id,meta_key,meta_value) values (’22’,’site_admins’,’a:1:{i:0;s:5:”adm”;}’);

Im my example, 22 is the site ID, obtained from the first query.

Following that, refresh your dashboard GUI and you should be able to find your “Site Admin” panel there. From here you can define your desired settings for the site as you see fit.

Forgot to mention kernel update

Saturday, June 17th, 2006

Kernel version 2.6.16.9, so I will supply its config file here config-2.6.16.9.txt. Same procedure as before.

Good luck.

Kernel update – 2.6.15.1

Friday, March 3rd, 2006

Alongside a newer kernel, I’m enjoying a newer Software Suspend2 package. I am not crazy about betas, or RCs, so now I’m on the 2.2 stable. I have hibernated only once since I’ve upgraded kernel, but it went just fine on the first try, so I’m rather ok with it without setting a set of cover-it-all tests.

Here’s my kernel config, if anyone’s interested – config-2.6.15.1.txt

Also, you can get the latest swsusp2 and fbsplash from the right places, as described in my post here. It’s good I use this blog – it keeps my memories for me.

Kernel update – 2.6.14.2

Saturday, December 24th, 2005

My tiny laptop has worked rather well so far, but I’ve decided, due to some unexplained problems, to upgrade it to a newer version of kernel, aka 2.6.14.2.

Based on my own blog’s entry (what good are blogs if not to hold some long forgotten knowledge?), which can be found here, I’ve upgraded my kernel and used the following config file config-2.6.14.2.txt.

One thing which I’ve had to do, maybe due to some upgrade of mkinitrd tools, or the likes, and it took me one misserable hibernation and restore (or a failed restore) to discover was to add the line “echo >/proc/suspend2/do_resume” to /usr/share/initrd-tools/linuxrc (my exact file is linuxrc.txt), so that the system would actually restore from hibernation. Now it works correctly.

On another issue, I’ve been asked to advise during Oracle DB installation on Linux setup, with High Availability solution. Although, long time ago, I’ve installed Oracle on both Solaris and Windows (without fine-tuniing it, anyhow), I’ve started searching the net, and came to the following link. The documents linked there are worth their weight in gold and diamonds. I’ll be testing them in the next few days, for my own personal advantage, but I think it’s gonna succeed, and as it seems the place for such issues, I can only put my thumb up for such sites and information sources on the web. It reminds me of the good in it. I was very impressed.