Download Xtream UI Released old posts!

[adilos]

loadbalancer not working

 

[NeySlim]

I made SQL requests to migrate users, reg_users, bouquets and streams from XC1.6 panel to XC 2 panel.
Be careful, the panel tries to start the streams on the main and on the loadbalancers that have ID matching the xc 1.6 one.

You first have to create a database named xtream_old and restore you v1 backup inside of it:

mysql -u root -p "CREATE xtream_old"
mysql -u root -p < ./xtream_iptvpro_WHATEVER.sql

Then run this requests:

( mysql -u root -p  to login mysql first )


TRUNCATE TABLE xtream_iptvpro.bouquets;
INSERT INTO xtream_iptvpro.bouquets (id, bouquet_name, bouquet_channels)
SELECT id, bouquet_name, bouquet_channels
from xtream_old.bouquets;

TRUNCATE TABLE xtream_iptvpro.member_groups;
INSERT INTO xtream_iptvpro.member_groups (group_id, group_name, group_color, is_banned, is_admin, is_reseller, total_allowed_gen_trials, total_allowed_gen_in, delete_users)
select  group_id, group_name, group_color, is_banned, is_admin, is_reseller, total_allowed_gen_trials, total_allowed_gen_in, can_delete
from xtream_old.member_groups;

TRUNCATE TABLE xtream_iptvpro.reg_users;
INSERT INTO xtream_iptvpro.reg_users (id, username, password, email, ip, date_registered, verify_key, last_login, member_group_id, verified, credits, notes, status, default_lang)
select id, username, password, email, ip, date_registered, verify_key, last_login, member_group_id, verified, credits, notes, status, default_lang
from xtream_old.reg_users;

TRUNCATE TABLE xtream_iptvpro.streams;
INSERT INTO xtream_iptvpro.streams (id,`type`,category_id,stream_display_name,stream_source,stream_icon,notes,created_channel_location,enable_transcode,transcode_attributes,custom_ffmpeg,movie_propeties,movie_subtitles,read_native,target_container,stream_all,remove_subtitles,custom_sid,epg_id,channel_id,epg_lang,`order`,auto_restart,transcode_profile_id,pids_create_channel,cchannel_rsources,gen_timestamps,added)
SELECT id,`type`,category_id,stream_display_name,stream_source,stream_icon,notes,created_channel_location,enable_transcode,transcode_attributes,custom_ffmpeg,movie_propeties,movie_subtitles,read_native,target_container_id,stream_all,remove_subtitles,custom_sid,epg_id,channel_id,epg_lang,`order`,auto_restart,transcode_profile_id,pids_create_channel,create_channel_queue,gen_pts,added
FROM xtream_old.streams;

TRUNCATE TABLE xtream_iptvpro.streams_options;
INSERT INTO xtream_iptvpro.streams_options (id, stream_id, argument_id, `value`)
SELECT id, stream_id, argument_id, `value`
FROM xtream_old.streams_options;

TRUNCATE TABLE xtream_iptvpro.streams_sys;
INSERT INTO xtream_iptvpro.streams_sys (server_stream_id, stream_id, server_id, parent_id, pid, to_analyze, stream_status, stream_started, stream_info, current_source)
SELECT server_stream_id, stream_id, server_id, parent_id, pid, to_analyze, stream_status, stream_started, stream_info, current_source
FROM xtream_old.streams_sys;

TRUNCATE TABLE xtream_iptvpro.stream_categories;
INSERT INTO xtream_iptvpro.stream_categories (id,category_type,category_name)
SELECT id, category_type, category_name
FROM xtream_old.stream_categories;

TRUNCATE TABLE xtream_iptvpro.users;
INSERT INTO xtream_iptvpro.users  (id, member_id, username, password, exp_date, admin_enabled, enabled, admin_notes, reseller_notes, bouquet, max_connections, is_restreamer, allowed_ips, allowed_ua, is_trial, created_at, created_by, pair_id, is_mag, force_server_id, is_isplock, as_number, isp_desc, forced_country, is_stalker)
SELECT `id`, `member_id`, `username`, `password`, `exp_date`, `admin_enabled`, `enabled`, `admin_notes`, `reseller_notes`, `bouquet`, `max_connections`, `is_restreamer`, `allowed_ips`, `allowed_ua`, `is_trial`, `created_at`, `created_by`, `pair_id`, `is_mag`, `force_server_id`, `is_isplock`, `as_number`, `isp_desc`, `forced_country`, `is_stalker`
FROM xtream_old.users;

TRUNCATE TABLE xtream_iptvpro.user_output;
INSERT INTO xtream_iptvpro.user_output (`id`, `user_id`, `access_output_id`)
SELECT `id`, `user_id`, `access_output_id`
FROM xtream_old.user_output;

Here is for migrating mag devices, I don't use mag, can't tell if it's enough:

TRUNCATE TABLE xtream_iptvpro.mag_devices;
INSERT INTO xtream_iptvpro.mag_devices (`mag_id`, `user_id`, `bright`, `contrast`, `saturation`, `aspect`, `video_out`, `volume`, `playback_buffer_bytes`, `playback_buffer_size`, `audio_out`, `mac`, `ip`, `ls`, `ver`, `lang`, `locale`, `city_id`, `hd`, `main_notify`, `fav_itv_on`, `now_playing_start`, `now_playing_type`, `now_playing_content`, `time_last_play_tv`, `time_last_play_video`, `hd_content`, `image_version`, `last_change_status`, `last_start`, `last_active`, `keep_alive`, `playback_limit`, `screensaver_delay`, `stb_type`, `sn`, `last_watchdog`, `created`, `country`, `plasma_saving`, `ts_enabled`, `ts_enable_icon`, `ts_path`, `ts_max_length`, `ts_buffer_use`, `ts_action_on_exit`, `ts_delay`, `video_clock`, `rtsp_type`, `rtsp_flags`, `stb_lang`, `display_menu_after_loading`, `record_max_length`, `plasma_saving_timeout`, `now_playing_link_id`, `now_playing_streamer_id`, `device_id`, `device_id2`, `hw_version`, `parent_password`, `spdif_mode`, `show_after_loading`, `play_in_preview_by_ok`, `hdmi_event_reaction`, `mag_player`, `play_in_preview_only_by_ok`, `watchdog_timeout`, `fav_channels`)
SELECT `mag_id`, `user_id`, `bright`, `contrast`, `saturation`, `aspect`, `video_out`, `volume`, `playback_buffer_bytes`, `playback_buffer_size`, `audio_out`, `mac`, `ip`, `ls`, `ver`, `lang`, `locale`, `city_id`, `hd`, `main_notify`, `fav_itv_on`, `now_playing_start`, `now_playing_type`, `now_playing_content`, `time_last_play_tv`, `time_last_play_video`, `hd_content`, `image_version`, `last_change_status`, `last_start`, `last_active`, `keep_alive`, `playback_limit`, `screensaver_delay`, `stb_type`, `sn`, `last_watchdog`, `created`, `country`, `plasma_saving`, `ts_enabled`, `ts_enable_icon`, `ts_path`, `ts_max_length`, `ts_buffer_use`, `ts_action_on_exit`, `ts_delay`, `video_clock`, `rtsp_type`, `rtsp_flags`, `stb_lang`, `display_menu_after_loading`, `record_max_length`, `plasma_saving_timeout`, `now_playing_link_id`, `now_playing_streamer_id`, `device_id`, `device_id2`, `hw_version`, `parent_password`, `spdif_mode`, `show_after_loading`, `play_in_preview_by_ok`, `hdmi_event_reaction`, `mag_player`, `play_in_preview_only_by_ok`, `watchdog_timeout`, `fav_channels`
FROM xtream_old.mag_devices;

 

[bigomod]

loadbalancer not working

loadbalancing is fully working follow instruction in page 6

 

[senkron24]

whats about ımport m3u lıst one to one ıts take long tımeççç

 

[felconx]

I managed to install it on ubuntu 18.04 on proxmox, it still lacks a lot.

 

[kskturk]

so good

 

[mohamed.nabil001]

its working?

 

[brando]

Yes all is work is the best one in this moment

 

[mr.more]

Yes all is work is the best one in this moment

on -demand and mag is work ?

 

[crewockeez]

it work ?

 

[Kato]

thank you!

 

[dindin]

1 like lz

 

[IPtvnordic]

any reseller panel yet ?

 

[popmar88]

Hello, can someone please like me so I can see how to install load balancer? I need to have one like to be able to see the instruction.

 

[Primadev]

hope its correct so @urgodfather

How to install LB

No quote

Is those steps works when I'm installing from scratch (on fresh ubuntu 18.04 server)?

 

[pk21x]

Is those steps works when I'm installing from scratch (on fresh ubuntu 18.04 server)?

yes

 

[onsitbin]

i will try some day this stuffs for my projects hehe.... tanks man

 

[Yenom]

installing error

Codes
/home/xtreamcodes/iptv_xtream_codes/php/bin/php: error while loading shared libraries : libexslt.so.0: cannot open shared object file: No such file or directory
/home/xtreamcodes/iptv_xtream_codes/php/sbin/php-fpm: error while loading shared libr aries: libexslt.so.0: cannot open shared object file: No such file or directory
/home/xtreamcodes/iptv_xtream_codes/php/sbin/php-fpm: error while loading shared libr aries: libexslt.so.0: cannot open shared object file: No such file or directory
/home/xtreamcodes/iptv_xtream_codes/php/sbin/php-fpm: error while loading shared libr aries: libexslt.so.0: cannot open shared object file: No such file or directory

Run as root: apt-get install libxslt1-dev libcurl3 libgeoip-dev

 

[tousleserver]

after install Loadbalance
when i need creat new line
i have it without ip
any idea ?

 

[eggs]

thats only a beta i have there website for the main 0ne