ISPConfig say web and mysql servers are offline

Discussion in 'General' started by erkan, May 28, 2014.

  1. erkan

    erkan Member

    Under status in ISPConfig it says that my web and mysql server are offline. But everything is working fine so why should ISPConfig say they are offline?
     
  2. till

    till Super Moderator Staff Member ISPConfig Developer

    The services are shown as offline when ispconfig is not able to connect to them on localhost.
     
  3. erkan

    erkan Member

  4. till

    till Super Moderator Staff Member ISPConfig Developer

    Maybe you changed the servers to listen on the external IP only. In the guide, they listen on all IP's. you can see that e.g. with:

    netstat -tap
     
  5. erkan

    erkan Member

    I've attached the result of running netstat.
     
    Last edited: May 28, 2014
  6. till

    till Super Moderator Staff Member ISPConfig Developer

    This seems to be ok. Config changes get written to disk correctly?
     
  7. erkan

    erkan Member

    Yes. Other than that it says the web and mysql server is offline everything works as it should.
     
  8. till

    till Super Moderator Staff Member ISPConfig Developer

    are you able to connect to mysql with both commands:

    mysql -h localhost -u root -p

    and

    mysql -j 127.0.0.1 -u root -p
     
  9. erkan

    erkan Member

    Only with the first one.

    When I try the second one it just says:

    mysql: unknown option '-j'
     
  10. till

    till Super Moderator Staff Member ISPConfig Developer

    Sorry, it has to be:

    mysql -h 127.0.0.1 -u root -p
     
  11. erkan

    erkan Member

    Yes then that works too.
     
  12. erkan

    erkan Member

    I seem to have found the error. In the host file it said:

    ::1 localhost

    And I changed that too:

    127.0.0.1 localhost

    But I haven't changed the host file before so it was as standard like that. And wouldn't your commands have failed with a error in the host file?
     
  13. till

    till Super Moderator Staff Member ISPConfig Developer

    Normally yes. But it might be that the mysql command contains some workarounds or fallbacks for broken hosts files while the php socket functions do not have such workarounds.
     

Share This Page