Topic: Installing Wordpress on SME 8. Fresh Install.

[interrupt]

I've been waiting to do this on the server however I have come to a point I have to have it done.  I have followed the instructions issuing the following syntax:


yum --enablerepo=smecontribs install smeserver-wordpress

At the end of the process it echo's back:

Setting up Install Process
No package smeserver-wordpress available.
Nothing to do

Is there a specific label for the package?

[johnp]

Read here about setting up the 7 contrib repo
http://wiki.contribs.org/SME8.0_Contribs_QA

[interrupt]

The install apparantly went well except for mysql intergration.  The only think i can come up with is that i should have made a db for mysql prior to the install?


[root@amecgaserver wp-admin]# yum install smeserver-wordpress --enablerepo=sme7contribs
Loaded plugins: fastestmirror, protect-packages, smeserver
Repository 'sme7contribs' is missing name in configuration, using id
Loading mirror speeds from cached hostfile
 * base: hpc.arc.georgetown.edu
 * sme7contribs: smemirror.fullnet.co.uk
 * smeaddons: smemirror.fullnet.co.uk
 * smeextras: smemirror.fullnet.co.uk
 * smeos: smemirror.fullnet.co.uk
 * smeupdates: smemirror.fullnet.co.uk
 * updates: hpc.arc.georgetown.edu
sme7contribs                                                      | 1.9 kB     00:00
sme7contribs/primary_db                                           | 420 kB     00:02
Excluding Packages from CentOS - os
Finished
Excluding Packages from CentOS - updates
Finished
Setting up Install Process
Resolving Dependencies
--> Running transaction check
---> Package smeserver-wordpress.noarch 0:1.0-2.el4.sme set to be updated
--> Processing Dependency: wordpress for package: smeserver-wordpress
--> Running transaction check
---> Package wordpress.noarch 0:2.6.2-1.el4.sme set to be updated
--> Finished Dependency Resolution

Dependencies Resolved

=========================================================================================
 Package                   Arch         Version                 Repository          Size
=========================================================================================
Installing:
 smeserver-wordpress       noarch       1.0-2.el4.sme           sme7contribs        16 k
Installing for dependencies:
 wordpress                 noarch       2.6.2-1.el4.sme         sme7contribs       1.3 M

Transaction Summary
=========================================================================================
Install       2 Package(s)
Upgrade       0 Package(s)

Total download size: 1.3 M
Is this ok [y/N]: y
Downloading Packages:
(1/2): smeserver-wordpress-1.0-2.el4.sme.noarch.rpm               |  16 kB     00:00
(2/2): wordpress-2.6.2-1.el4.sme.noarch.rpm                       | 1.3 MB     00:08
-----------------------------------------------------------------------------------------
Total                                                    146 kB/s | 1.3 MB     00:09
Running rpm_check_debug
Running Transaction Test
Finished Transaction Test
Transaction Test Succeeded
Running Transaction
  Installing     : wordpress                                                         1/2
  Installing     : smeserver-wordpress                                               2/2
Migrating existing database configuration
Migrating existing database domains
Migrating existing database yum_updates
Migrating existing database yum_repositories
Migrating existing database accounts
Migrating existing database networks
Migrating existing database hosts
Migrating existing database mailpatterns
Migrating existing database yum_installed
Migrating existing database backups
Migrating existing database spamassassin
Migrating existing database yum_available
Loading 20mysql_migrate_horde into mysql [FAILED]
Loading 21horde.mysql_set_password into mysql [FAILED]
Loading 30horde_mysql_create_tables into mysql [FAILED]
Loading 31horde_upgrade into mysql [FAILED]
Loading 35imp_mysql_create_tables into mysql [FAILED]
Loading 36imp_upgrade into mysql [FAILED]
Loading 40mysql.create.turba into mysql [FAILED]
Loading 50turba_upgrade into mysql [FAILED]
Loading 57turba_mysql_reset_addressbook_pref into mysql [FAILED]
Loading 77horde_mysql_update_privs into mysql [FAILED]
Loading 78mysql.create.ingo into mysql [FAILED]
Loading 79ingo_upgrade into mysql [FAILED]
Loading 80wordpress into mysql [FAILED]

see wiki.contribs.org/wordpress
Migrating existing database configuration
Migrating existing database domains
Migrating existing database yum_updates
Migrating existing database yum_repositories
Migrating existing database accounts
Migrating existing database networks
Migrating existing database hosts
Migrating existing database mailpatterns
Migrating existing database yum_installed
Migrating existing database backups
Migrating existing database spamassassin
Migrating existing database yum_available

Installed:
  smeserver-wordpress.noarch 0:1.0-2.el4.sme

Dependency Installed:
  wordpress.noarch 0:2.6.2-1.el4.sme

Complete!

[cactus]

The install apparantly went well except for mysql intergration.  The only think i can come up with is that i should have made a db for mysql prior to the install?

That is a bit too quick to say that, normally that would not be required. I think there is some other issue here.

Loading 20mysql_migrate_horde into mysql [FAILED]
Loading 21horde.mysql_set_password into mysql [FAILED]
Loading 30horde_mysql_create_tables into mysql [FAILED]
Loading 31horde_upgrade into mysql [FAILED]
Loading 35imp_mysql_create_tables into mysql [FAILED]
Loading 36imp_upgrade into mysql [FAILED]
Loading 40mysql.create.turba into mysql [FAILED]
Loading 50turba_upgrade into mysql [FAILED]
Loading 57turba_mysql_reset_addressbook_pref into mysql [FAILED]
Loading 77horde_mysql_update_privs into mysql [FAILED]
Loading 78mysql.create.ingo into mysql [FAILED]
Loading 79ingo_upgrade into mysql [FAILED]
Loading 80wordpress into mysql [FAILED]

Judging from above I doubt if you MySQL configuration and/or user permissions are correct. Did you in the past change the mysql root user password perhaps?

What is the output of the following commands:

Code: [Select]

service mysqld status
db configuration show mysqld
mysql -e "SHOW DATABASES;"

[interrupt]

What actually occurred was that the db for wordpress nor the user was setup.  secondly i had forgotten the pw for root for wordpress.  So it blew up when i did that install via repository.  But I figured it out and made the correct adjustments. But what really ruined the whole thing in the end is that the version in the repository is so old that it was not eligible for the upgrade via wordpress and i have to now uninstall the install as well as a bunch of nightmarish crapola.  So i feel that the server is now vulnerable with this exercise in futility.

I am so frustrated with the whole thing.  I hate to have to redo the server over because it has run very well now for a few years.  But i mean i dont trust it at this point.  I have to figure out if i can export the horde db for email and import it back on a new build but i dont even know where to begin with that nightmare as well.

i will just probably run wordpress on another server and just forget about ever trying it again in sme server. 

I dunno.  I have an issue now..

[interrupt]

What i meant to say was i forgot the root pw for mysql.  I didnt want to go through resetting it and fortunately i remembered it after a bit. 

I already have an appliance for wordpress so I will just use that instead on another box.

Atleast that is what the plan is at this second   

Thanks

[cactus]

What i meant to say was i forgot the root pw for mysql.  I didnt want to go through resetting it and fortunately i remembered it after a bit.

Well there you have your issue. You DO NOT NEED the root password. You should only use the root account to do administration. Since SME Server is equiped with a seemless login for mysql root when you are logged in as root user on the command line you do not need to know the password.

Please read up the MySQL FAQ (http://wiki.contribs.org/MySQL) as to me it seems it is you who is making the system vulnerable, even before installing wordpress. Please get into the habit of creating different users for all applications you install and make sure they only have the privileges they need on the database(s) they need.

First thing you will need to do is to reset the root password as the situation you are in now is that even upgrades might fail as the webmail scripts also seem to fail. Instructions on how to do this are in the wiki.

After that make sure all web applications have a proper account.

But what really ruined the whole thing in the end is that the version in the repository is so old that it was not eligible for the upgrade via wordpress and i have to now uninstall the install as well as a bunch of nightmarish crapola.  So i feel that the server is now vulnerable with this exercise in futility.

Last you should then be able to install wordpress from the SME Contribs repository. You can after that upgrade with the source from wordpress if you like following the wordpress upgrade instructions that can be found on their site.

[cactus]

I am so frustrated with the whole thing.  I hate to have to redo the server over because it has run very well now for a few years.  But i mean i dont trust it at this point.  I have to figure out if i can export the horde db for email and import it back on a new build but i dont even know where to begin with that nightmare as well.

A simple standard backup would do that for you. Did you ever study the manual?

i will just probably run wordpress on another server and just forget about ever trying it again in sme server. 

That would be silly, making mistakes is human, learning from them is human too. It is not that bad as you think it is.

I dunno.  I have an issue now..

A minor one. Restore the root password. Remove wordpress and reinstall it and you should be fine.