[Rocks-Discuss] Wordpress error

[Bart Brashers]

On my fresh Rocks 5.4.3 x86_64 install, I opened the firewall to www/tcp
by doing:

# rocks add firewall host=wclyn-linux1 network=public protocol=tcp
service=www chain=INPUT action=ACCEPT rulename=A41-WWW-OPEN-TCP
# rocks sync host firewall frontend

(and then a "service iptables restart" when that failed, due to root
using tcsh). Looks like I can get through.

But... all I see is big letters saying "Error establishing a database
connection".

Looked in the mailing list, found
http://marc.info/?l=npaci-rocks-discussion&m=128026432703679&w=2

The mighty gb suggested these two diagnostics:

# /opt/rocks/bin/mysql -u wordpress wordpress
ERROR 1044 (42000): Access denied for user ''@'localhost' to database
'wordpress'

# rocks list roll
NAME VERSION ARCH ENABLED
area51: 5.4.3 x86_64 yes
base: 5.4.3 x86_64 yes
ganglia: 5.4.3 x86_64 yes
hpc: 5.4.3 x86_64 yes
java: 5.4.3 x86_64 yes
kernel: 5.4.3 x86_64 yes
perl: 5.4.3 x86_64 yes
python: 5.4.3 x86_64 yes
web-server: 5.4.3 x86_64 yes
data-transfer: 5.4 x86_64 yes
R: 5.4 x86_64 yes
mpi_gnu+intel+pgi_mx_mpich+mpich2+openmpi: 5.4 x86_64 yes
torque: 5.4.0 x86_64 yes
envmodules: 5.4 x86_64 yes
scipy_gnu+intel: 5.4 x86_64 yes
Final: 5.4.3 x86_64 yes
Final: 5.4.3 x86_64 yes

(The "Final" roll shows up twice because CentOS 5.6 now spans 2 DVDs).

I have already applied the following from
ftp://www.rocksclusters.org/pub/rocks/updates/5.4.3/x86_64/RPMS/

pdsh-2.26-1.x86_64.rpm
rocks-command-5.4.3-6.x86_64.rpm
rocks-config-server-5.4.3-1.x86_64.rpm
rocks-openmpi-1.4.3-2.x86_64.rpm
rocks-secattr-plugins-5.4.3-1.x86_64.rpm
rocks-sec-channel-server-5.4.3-2.x86_64.rpm

Any hints?

Bart

This message contains information that may be confidential, privileged or otherwise protected by law from disclosure. It is intended for the exclusive use of the Addressee(s). Unless you are the addressee or authorized agent of the addressee, you may not review, copy, distribute or disclose to anyone the message or any information contained within. If you have received this message in error, please contact the sender by electronic reply to em...@environcorp.com and immediately delete all copies of the message.

[Ian Kaufman]

Hi Bart,

You need to figure out why the user "wordpress" cannot connect to the
database "wordpress".

Can you access the MySQL database as root? Can you check if the user
"wordpress" has the appropriate access? Can root connect to the
"wordpress"database?

Ian

--
Ian Kaufman
Research Systems Administrator
UC San Diego, Jacobs School of Engineering ikaufman AT ucsd DOT edu

[Bart Brashers]

Hi Ian,

I'm a wordpress newbie, so I'm going to guess the correct command line would be

# /opt/rocks/bin/mysql -u root wordpress
ERROR 1049 (42000): Unknown database 'wordpress'

Not a good sign. I can connect to mysql, though:

# /opt/rocks/bin/mysql -u root
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 35
Server version: 5.1.56 Source distribution

Copyright (c) 2000, 2010, Oracle and/or its affiliates. All rights reserved.
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL v2 license

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql>

Doing a "grep mysql /root/*.log /root/*.debug" gets a bunch of lines, but none that look like errors creating the "wordpress" user. That's not a real user (in the sense that there's no entry for wordpress in /etc/passwd), is it?

Bart

[Ian Kaufman]

Hi Bart,

OK, after accessing the MySQL database as root, just for confirmation, do:

show databases;

I suspect there is no "wordpress" database based upon the errors, but
this will provide confirmation. So, basically, wordpress did not get
installed, or did not install properly. According to the changelog,
Wordpress 3.1.3 is part of the web-server roll.

Ian

[Bart Brashers]

Yup:

# /opt/rocks/bin/mysql -u root
Welcome to the MySQL monitor. Commands end with ; or \g.

Your MySQL connection id is 36

Server version: 5.1.56 Source distribution

Copyright (c) 2000, 2010, Oracle and/or its affiliates. All rights reserved.
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL v2 license

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| #mysql50#.mozilla |
| TEMPTABLES |
| cluster |
| mysql |
| test |
+--------------------+
6 rows in set (0.06 sec)

mysql>

So how do I go about creating the wordpress database? I included the web-server roll.

Bart

[Ian Kaufman]

Is this a new install? If so, you might want to start all over. You
cannot add the web-server roll after the fact, and it appears
something went wrong during installation.

Can you find a Wordpress installation anywhere on the frontend? It
should be in /var/www/html/wordpress I believe.

Ian

On Thu, Dec 1, 2011 at 10:08 AM, Bart Brashers

[Bart Brashers]

Yes, there's a bunch of files in /var/www/html/wordpress.

If someone can suggest how to create the wordpress database, and the wordpress user, perhaps it would work.

Re-installing isn't much of an option, given other time constraints.

Bart