Koozali.org: home of the SME Server

WordPress install problem on SME 7.3

Offline fahrenheit

  • 2
  • +0/-0
WordPress install problem on SME 7.3
« on: September 10, 2008, 03:33:36 AM »
Dear All,

I followed http://wiki.contribs.org/Wordpress ton install WP on new(almost fresh) SME 7.3
Installed contribs: fetchmail, eGroupWare, AWstats

- No problem with the YUM part
- No problem either with, worked fine  http://servername/wordpress/wp-admin/upgrade.php
Then the WP contrib mentions I should setup: http://servername/wordpress
--> there I get a WP "MyBlog" and "not found" error

I'm a bit confused as the contrib also mentions to "Apply any changes to the URL or domain property before setting up wordpress"   (I have nothing to change to mine... IMHO)

Wanted to check the Options, but http://wiki.contribs.org/Generic_WebApp_rpm#New_DB_settings
seems a bit sick at the mo.
Havent found any info about WP in the FAQ nor in the HOWO
There are a few posts, but didn't help really

Thanks for any advise
Cheers
PAB

Offline mmccarn

  • *
  • 2,651
  • +10/-0

Offline fahrenheit

  • 2
  • +0/-0
Re: WordPress install problem on SME 7.3
« Reply #2 on: September 10, 2008, 04:35:34 PM »
Thank you for your link

Tried several DB "config setprop..."  didn't bring much, so I tried uninstalling wordpress
BTW : the    DELETE FROM user WHERE user = 'username';   
found there      http://wiki.contribs.org/MySQL#Remove_a_user     didn't work well,
mysql> DELETE FROM mysql.user
      -> WHERE User='user_name';
mysql> FLUSH PRIVILEGES;
worked fine for me
--------------------------------
New install:  Almost the same as before, the first 2 steps worked fine
yum --enablerepo=smecontribs install smeserver-wordpress
http://servername/wordpress/wp-admin/upgrade.php
--------------------------------------------------------------------------
WordPress database error: [table 'wordpress.wp_categories' doesn't exist]
SELECT cat_ID, cat_name, category_nicename FROM wp_categories

WordPress database error: [table 'wordpress.wp_post2cat' doesn't exist]
SELECT DISTINCT post_id FROM wp_post2cat

WordPress database error: [table 'wordpress.wp_categories' doesn't exist]
ALTER TABLE `wp_categories` ADD INDEX ( `category_nicename` )

WordPress database error: [Unknown column 'user_nickname' in 'field list']
SELECT ID, user_nickname, user_nicename FROM wp_users

WordPress database error: [table 'wordpress.wp_categories' doesn't exist]
SELECT * FROM wp_categories ORDER BY cat_ID

WordPress database error: [table 'wordpress.wp_post2cat' doesn't exist]
SELECT post_id, category_id FROM wp_post2cat GROUP BY post_id, category_id

WordPress database error: [table 'wordpress.wp_linkcategories' doesn't exist]
SELECT cat_id, cat_name FROM wp_linkcategories
Upgrade Complete

Your WordPress database has been successfully upgraded!

(are all these errors "normal", and the reason for the upgrade?)
-------------------------------------------------------------
then issued some commands:
config setprop wordpress status enabled
config setprop wordpress domain www.mydomain.net   (static pages are visible from world, so is egroupware, so I guess DNS should be okay)

Problem:
http://servername/wordpress   brings a nice white snow page, not that I dislike it but...
Now, same as 1st install, I get a wordpress "Myblog" page saying:
"Not Found, Sorry, but you are looking for something that isn't here."

Tried http://hostname/wordpress  http://mydomain.net/wordpress    http://www.mydomain.net/wordpress
Now even the server-manager  is 404 (not found)
-----
checked  http://wiki.contribs.org/Web_Application_Redirect_Tutorial

/etc/httpd/conf/httpd.conf      looked fine (to MY eyes), wordpress seemed mentionning the right main and virtual hosts & domains, pointing to the right ibays

Checked for more information on Ixus.net
No related information found on wordpress sites (EN and FR)

Bit more on the config:
SME 7.3 sitting on 192.168.2.2
No access problem from LAN 192.168.0.X
Port forwarding from WAN to SME (80, 443 and a couple more) (HTTP static pages visible from www)
Installed (contribs)
- AWstats
- fetchmail
- System Monitor
- eGroupWare  (https://myserver/egroupware/ still working fine...)

main domain:  www.mydomain.net   pointing to ibay  mydomainibay
virtual hostnames & domains, self, pointing each to an ibay
Primary ibay:  present, not used

mysql: wordpress DB: present   user wordpress: present
Server has been rebooted since install

The problem might well be between a chair somewhereand and a keyboard , I'm missing something
Any ideas where to digg ?

No I havent tried to install wordpress in an Ibay, I think installing in /opt should be right, at least in my case (several virtual hosts), I'd rather put websites, or (maybe) some small web apps, in Ibays, correct me if I'm wrong, I'm noob in this (I'm sure you've noticed...))

Cheers
PAB
============================
Edit: On the "myblog" page I get with the error mentionned above, on the right in META, there is a LOGIN
If I click that I get asked for user/password (I don't know of course...)  (tried admin etc...)
same as Yourserver.net/wordpress/wp-login.php of course
I'll dig a bit deeper there

Should I do something like this (the password recovery part by fiddling in mysql):
http://www.mydigitallife.info/2008/06/26/how-to-reset-wordpress-password-to-recover-forgotten-secret/

When I try       http://www.epinglier.net/wp-admin/install.php
I get:             Already Installed, You appear to have already installed WordPress. To reinstall please clear your old database tables first.
(trying from outside, iE with a proxy, also... such as TOR)

« Last Edit: September 10, 2008, 05:34:55 PM by fahrenheit »

Offline MSmith

  • *
  • 675
  • +0/-0
Re: WordPress install problem on SME 7.3
« Reply #3 on: November 14, 2008, 05:17:12 PM »
I too have this exact problem with a fresh Wordpress install on an up-to-date SME 7.3.  No server-manager, no configuration/setup pages displayed during install.  Did you ever figure it out?
...

Offline cactus

  • *
  • 4,880
  • +3/-0
    • http://www.snetram.nl
Re: WordPress install problem on SME 7.3
« Reply #4 on: November 16, 2008, 04:27:15 PM »
I too have this exact problem with a fresh Wordpress install on an up-to-date SME 7.3.  No server-manager, no configuration/setup pages displayed during install.  Did you ever figure it out?
What is the output of
Code: [Select]
httpd -t
Be careful whose advice you buy, but be patient with those who supply it. Advice is a form of nostalgia, dispensing it is a way of fishing the past from the disposal, wiping it off, painting over the ugly parts and recycling it for more than its worth ~ Baz Luhrmann - Everybody's Free (To Wear Sunscreen)