Question "error":"MySQL: Connection refused"}

[prabhjot]

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)

On checking mysql service status

{"error":"MySQL: Connection refused"}chown: changing ownership of '/home/xtreamcodes/iptv_xtream_codes/GeoLite2.mmdb': Operation not permitted



/home/xtreamcodes/iptv_xtream_codes/start_services.sh: line 14: /home/xtreamcodes/iptv_xtream_codes/nginx_rtmp/sbin/nginx_rtmp: Permission denied



/home/xtreamcodes/iptv_xtream_codes/start_services.sh: line 15: /home/xtreamcodes/iptv_xtream_codes/nginx/sbin/nginx: Permission denied



root@localhost:~# service mysql status



● mysql.service - MySQL Community Server



   Loaded: loaded (/lib/systemd/system/mysql.service; enabled; vendor preset: enabled)



   Active: failed (Result: exit-code) since Tue 2020-08-11 00:37:47 UTC; 4min 15s ago



  Process: 17691 ExecStart=/usr/sbin/mysqld --daemonize --pid-file=/run/mysqld/mysqld.pid (code=exited, status=1/FAILURE)



  Process: 17668 ExecStartPre=/usr/share/mysql/mysql-systemd-start pre (code=exited, status=0/SUCCESS)







Aug 11 00:37:47 localhost systemd[1]: mysql.service: Service hold-off time over, scheduling restart.



Aug 11 00:37:47 localhost systemd[1]: mysql.service: Scheduled restart job, restart counter is at 5.



Aug 11 00:37:47 localhost systemd[1]: Stopped MySQL Community Server.



Aug 11 00:37:47 localhost systemd[1]: mysql.service: Start request repeated too quickly.



Aug 11 00:37:47 localhost systemd[1]: mysql.service: Failed with result 'exit-code'.



Aug 11 00:37:47 localhost systemd[1]: Failed to start MySQL Community Server.

Does anyone know the solution.?

 

[msn11]

with standard installation this error not arrise.backup and format server.

Install Main Server:

sudo apt-get update && sudo apt-get upgrade -y

sudo apt-get install libxslt1-dev libcurl3 libgeoip-dev python -y

wget https://xtream-ui.com/install/install.py

sudo python install.py

Type 'MAIN' and press enter.

then install admin panel with any release of xtream-ui.

Xtream UI

xtream-ui.com

Note1: if you are getting nginx permission denied error, make nginx binaries executable again.

sudo chmod +x /home/xtreamcodes/iptv_xtream_codes/nginx_rtmp/sbin/nginx_rtmp
sudo chmod +x /home/xtreamcodes/iptv_xtream_codes/nginx/sbin/nginx
sudo /home/xtreamcodes/iptv_xtream_codes/start_services.sh


Note 2: If you can't see new database tables after fresh install, add a file named ".update" in the admin folder.

then restart panel.

sudo touch /home/xtreamcodes/iptv_xtream_codes/admin/.update

sudo /home/xtreamcodes/iptv_xtream_codes/start_services.sh

Failed to update GeoLite2! Please try again.
------------------------------------
sudo chattr -i /home/xtreamcodes/iptv_xtream_codes/GeoLite2.mmdb && wget "https://xtream-ui.com/GeoLite2/GeoLite2.mmdb" -O /home/xtreamcodes/iptv_xtream_codes/GeoLite2.mmdb && sudo chown xtreamcodes:xtreamcodes /home/xtreamcodes/iptv_xtream_codes/GeoLite2.mmdb && sudo chattr +i /home/xtreamcodes/iptv_xtream_codes/GeoLite2.mmdb

------------------------------------
Install Load Balance:

sudo apt-get update && sudo apt-get upgrade -y

sudo apt-get install libxslt1-dev libcurl3 libgeoip-dev python -y

wget https://xtream-ui.com/install/install.py

sudo python install.py

Type LB and press enter,

Enter main server's IP address, Mysql "user_iptvpro" password, and server id from Manage Servers Page and proceed.

its done.

Start/Restart panel command,

sudo /home/xtreamcodes/iptv_xtream_codes/start_services.sh

If nginx Permission not solved with above command:

chattr -ai /home/xtreamcodes/iptv_xtream_codes/GeoLite2.mmdb
sudo chmod 0777 /home/xtreamcodes/iptv_xtream_codes/GeoLite2.mmdb
------------------------------------

When Stream down but server online:

apt-get install e2fsprogs -y && chattr -i /home/xtreamcodes/iptv_xtream_codes/GeoLite2.mmdb ; wget https://archive.org/download/geolite2_201910/GeoLite2.mmdb -O /home/xtreamcodes/iptv_xtream_codes/GeoLite2.mmdb && chown xtreamcodes.xtreamcodes /home/xtreamcodes/iptv_xtream_codes/GeoLite2.mmdb && chattr +i /home/xtreamcodes/iptv_xtream_codes/GeoLite2.mmdb && clear && echo "If you see this message, 500 errors are probably fixed"
------------------------------------------------------

 

[urgodfather]

WOW. you both make spam on forum with so much copy and paste! This has been answered 100 times and is posted multiple times in the XtreamUI category. This is where people make posts about XtreamUI and problems they have with it. Maybe you should learn to look more instead of make spam on forum with garbage posts. @msn11 good job for try to help but you are just as guilty with 3 multi posts of copy and paste. I lock this thread.