problems with mysql /phpmyadmin

Discussion in 'Installation/Configuration' started by geralddelapascua, May 8, 2014.

  1. geralddelapascua

    geralddelapascua New Member

    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
     
  2. till

    till Super Moderator Staff Member ISPConfig Developer

  3. geralddelapascua

    geralddelapascua New Member

    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 ?
     
  4. geralddelapascua

    geralddelapascua New Member

    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
     

Share This Page