How to delete cached open connections ?

[Clusterphys]

Hello i changed main and i added backup but im getting open connections from old main, its like a cache. How can i delete them and show real connections in dashboard. Thanks

 

[noris]

Delete all logs, then restart all channels.

 

[Clusterphys]

Delete all logs, then restart all channels.

i deleted stream logs, clients logs, still same

 

[skipmack46]

If you changed main and restored backup, you have to make sure you changed domain name or IP address in the servers list, as the back restores that info as well

 

[Clusterphys]

If you changed main and restored backup, you have to make sure you changed domain name or IP address in the servers list, as the back restores that info as well

yes i know i did, strange this to happen, anyone had same issue please as im hating the fact, seeing fake open connections

 

[urgodfather]

yes i know i did, strange this to happen, anyone had same issue please as im hating the fact, seeing fake open connections

They are not fake open connections. They are connections that have not closed YET. They will time out and close on own.

 

[TheReaperZ]

Did you tried to truncate user_activity_now ?

 

[aumaletv]

Hello i changed main and i added backup but im getting open connections from old main, its like a cache. How can i delete them and show real connections in dashboard. Thanks

mysql --user=root --password=PASSWORD --database=xtream_iptvpro -s --execute="TRUNCATE client_logs;"
mysql --user=root --password=PASSWORD --database=xtream_iptvpro -s --execute="TRUNCATE user_activity;"
mysql --user=root --password=PASSWORD --database=xtream_iptvpro -s --execute="TRUNCATE stream_logs;"
mysql --user=root --password=PASSWORD --database=xtream_iptvpro -s --execute="TRUNCATE login_logs;"
mysql --user=root --password=PASSWORD --database=xtream_iptvpro -s --execute="TRUNCATE login_flood;"
mysql --user=root --password=PASSWORD --database=xtream_iptvpro -s --execute="TRUNCATE user_activity_now;"