problems with mysql /phpmyadmin

I have recently set up a server which I'm using to develop apps hopefullly when I get it working,

I set up the default server as described in the perfect server thread, centos 6.4 with ispconfig 3.

I've had some challanges but resolved the issues.

So I installed phpmyadmin, which seemed much more complicated than the days when you just put it in a single folder ! but never mind it seemed to work,

then I wanted to use joomla, which said it needed a later release of php,
and I noticed centos 6.5 was out,

so I upgraded centos to 6.5, and upgraded php to 5.4.28, I meant to go to 5.5, but followed some instructions and it only went to 5.4
( I used this http://www.servermom.org/how-to-install-lamp-with-php-v5-5-0-and-mysql-v5-5-32/857/ )

at that point I noticed phpmyadmin wasn't working, so I removed and reinstalled but still nothing. have I installed an incompatible version of php ? sounds unlikely ?

I ran mysql -V this gives,
mysql Ver 14.14 Distrib 5.5.37, for Linux (x86_64) using readline 5.1

do I need to upgrade this too ?

I'm wondering if I've done something to mysql unintentionally,
I ran the htf-common-issues.php,
and this says,

##### ISPCONFIG #####
ISPConfig version is 3.0.5.3

[WARN] Could not connect to mysql with given user data.


this is only a warning, not sure what this means ?

there are sql back ground tasks running
7154 pts/1 S+ 0:00 grep sql
11534 ? S 0:00 /bin/sh /usr/bin/mysqld_safe --datadir=/var/lib/mysql --socket=/var/lib/mysql/mysql.sock --pid-file=/var/run/mysqld/mysqld.pid --basedir=/usr --user=mysql
11741 ? Sl 0:18 /usr/libexec/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib64/mysql/plugin --user=mysql --log-error=/var/log/mysqld.log --pid-file=/var/run/mysqld/mysqld.pid --socket=/var/lib/mysql/mysql.sock

but if I go to my to mydomain.com/phpmyadmin I get the icon on the tab showing phpmyadmin, so it's picked something up, but it gives a page saying 404 from ispconfig.

Now it must be finding something, but there must be an error, which is kicking this off.
Normally I would look in the http logs to see what problems are reported there. In this case I'm seeing in access_log
for each time I'm trying to go to mydomain.com/phpmyadmin

90.195.60.182 - - [08/May/2014:12:52:17 +0100] "GET /phpmyadmin/ HTTP/1.1" 304 - "-" "Mozilla/5.0 (Windows NT 6.1) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/34.0.1847.131 Safari/537.36"
90.195.60.182 - - [08/May/2014:12:52:17 +0100] "GET /phpmyadmin/js/querywindow.js HTTP/1.1" 304 - "http://www.mydomain.co.uk/phpmyadmin/" "Mozilla/5.0 (Windows NT 6.1) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/34.0.1847.131 Safari/537.36"
90.195.60.182 - - [08/May/2014:12:52:17 +0100] "GET /phpmyadmin/navigation.php%3C?php%20echo%20$url_query;%20?%3E HTTP/1.1" 404 1806 "http://www.mydomain.co.uk/phpmyadmin/" "Mozilla/5.0 (Windows NT 6.1) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/34.0.1847.131 Safari/537.36"
90.195.60.182 - - [08/May/2014:12:52:17 +0100] "GET /phpmyadmin/%3C?php%20echo%20$main_target;%20?%3E HTTP/1.1" 404 1806 "http://www.mydomain.co.uk/phpmyadmin/" "Mozilla/5.0 (Windows NT 6.1) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/34.0.1847.131 Safari/537.36"
90.195.60.182 - - [08/May/2014:12:52:17 +0100] "GET /phpmyadmin/navigation.php%3C?php%20echo%20$url_query;%20?%3E HTTP/1.1" 404 1806 "http://www.mydomain.co.uk/phpmyadmin/" "Mozilla/5.0 (Windows NT 6.1) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/34.0.1847.131 Safari/537.36"

so this appears to be telling me that it's finding the file, but then looking for other files like navigation.php, and perhaps for some reason this is failing ????

my ispconfig seems to be working so it's can't be that mysql isn't working at all (I presume that runs on mysql too ? )

I'm a bit stuck to know how to proceed, I have some experience using phpmyadmin, and it'd be great to have that to use, and look at mysql, I'm certainly not knowing how to use mysql without it.

Could anyone with some experience suggest what I should do to try to progress this ?

I was going to upgrade mysql to 5.6 as well, but I'm not sure adding more changes to the system will make fixing things easier.

I'm not sure which version of phpmyadmin I have installed perhaps its picked up a new verison from epel ? maybe that's incompatible with the mysql or php I have ?

If you get this far, many thanks for reading all this, I'm very new to linix, having come from a freebsd background, would really appreciate any help with getting this going so I can get to some real work,

thanks in advance,

G

 

rather alarmingly

rather alarmingly, I'm seeing in my http logs calls to a file,
phpmyadmin/scripts/setup.php

from more than one unknown ip address, is this a known issue, is it possible that someone else has damaged my phpmyadmin installation by running the setup scripts and changing something ?

I'm seeing calls to this from for example,
198.66.57.97 and
188.226.218.61

I don't recognise these ip's so who is trying to run setup on my server ?

should I be worried about this ?

 

ok, I appreciate that worked, I initially installed from the 6.4 perfect server thread that looks pretty much identical, but as I explained I have upgraded php 5.4, although I can't say this caused the problem,

I am trying to diagnose a problem, I can't go back a do a clean install when I hit an issue, I have uninstalled and reinstalled phpmyadmin, but no change,

I have followed the steps in the guide step 9
where it says
yum -y install ntp httpd mod_ssl mysql-server php php-mysql php-mbstring phpmyadmin

and then the updating of
vi /etc/httpd/conf.d/phpmyadmin.conf
and
vi /usr/share/phpmyadmin/config.inc.php
which I have changed exactly as per the instructions.

Many thanks for your fast reply, but is there anything diagnostic wise that I could try to get to the bottom of this issue ?

thanks again,

Gerald