Related

Product Now Available: Managed MySQL Databases Product
Two domains using same mqsql database Question Question
phpmyadmin for multi site on one VPS Question Question

Question

Has anyone solved this error?A PHP Error was encountered Severity: Warning Msg: mysqli:real_connect(): (HY000/2002): Connection refused

Posted August 23, 2019 11.5k views
UbuntuMySQLPHP

error 1
A PHP Error was encountered

Severity: Warning

Message: mysqli::real_connect(): (HY000/2002): Connection refused

Filename: mysqli/mysqli_driver.php

Line Number: 201

error 2
A PHP Error was encountered

Severity: Warning

Message: fopen(/var/www/arquiv/htdocs/application/ciarquivsessions/ci_sessionunb9drq50aqrr8buagl3tfe4tf4qnh6d): failed to open stream: No space left on device

Filename: drivers/Sessionfilesdriver.php

error3
An uncaught Exception was encountered

Type: Error

Message: Failed to create(read) session ID: user

Add a comment
By:
thiago20
Add a comment
1 comment
  • dilipkumar July 16, 2020
    Reply Report

    Hi, I am having same error. I checked Disk Space, it looks good but still, Mysql is Crashing.
    Result of df -h
    Filesystem Size Used Avail Use% Mounted on
    udev 480M 0 480M 0% /dev
    tmpfs 99M 11M 88M 11% /run
    /dev/vda1 58G 4.1G 54G 7% /
    tmpfs 493M 0 493M 0% /dev/shm
    tmpfs 5.0M 0 5.0M 0% /run/lock
    tmpfs 493M 0 493M 0% /sys/fs/cgroup
    /dev/vda15 105M 3.6M 101M 4% /boot/efi
    tmpfs 99M 0 99M 0% /run/user/0

These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.

×
1 answer
bobbyiliev August 23, 2019

Hello,

It looks like that your server is running out of disk space. You can check that with this command:

df -h

My guess would be that the server ran out of space and MySQL crashed, that is why you are getting the first error. The second error on the other hand is self explanatory: No space left on device.

You would have to extend your disk space or clear some old files in order to free up some space and then start MySQL.

Hope that this helps!
Regards,
Bobby

Reply Report
  • thiago20 August 23, 2019

    Fixed space issue, now nginx is giving 502 bad gateway error , do you know how to fix?

    Reply Report
    • bobbyiliev August 25, 2019

      Hello,

      I would recommend checking your error log at /var/log/nginx/error.log. This would give you more information on what could be causing the issue.

      Regards,
      Bobby

      Reply Report
      • thiago20 August 25, 2019

        these errors appeared:
        nginx: [emerg] bind() to [::]:18915 failed (98: Address already in use)
        nginx: [emerg] bind() to [::]:443 failed (98: Address already in use)
        nginx: [emerg] bind() to [::]:80 failed (98: Address already in use)
        nginx: [emerg] bind() to [::]:80 failed (98: Address already in use)
        nginx: [emerg] bind() to [::]:80 failed (98: Address already in use

        Do you know how to solve them?

        Reply Report
        • bobbyiliev August 26, 2019

          Hello,

          Yes it looks like that another service is using port 80 at the moment, and it is not possible to have two services listening on the same port at the same time.

          To find out which service is using the port you could run this command:

          netstat -plant | grep 80

          Then if you do not need this service you could stop it and disable it so that it does not start on boot.

          After that you should be able to start Nginx as normal.

          Hope that this helps!
          Regards,
          Bobby

          Reply Report
Submit an Answer

Related

Looking for something else?

Ask a new question Search for more help