Change your MySQL setting

[Apollo]

Hello,

If you want to change your DB server info, use this python script:

#!/usr/bin/python
# -*- coding: utf-8 -*-

import os,sys
from itertools import cycle, izip

def encrypt(rHost="127.0.0.1", rUsername="user_iptvpro", rPassword="", rDatabase="xtream_iptvpro", rServerID=1, rPort=7999):
    print ("Encrypting...")
    try: os.remove("/home/xtreamcodes/iptv_xtream_codes/config")
    except: pass
    rf = open('/home/xtreamcodes/iptv_xtream_codes/config', 'wb')
    rf.write(''.join(chr(ord(c)^ord(k)) for c,k in izip('{\"host\":\"%s\",\"db_user\":\"%s\",\"db_pass\":\"%s\",\"db_name\":\"%s\",\"server_id\":\"%d\", \"db_port\":\"%d\"}' % (rHost, rUsername, rPassword, rDatabase, rServerID, rPort), cycle('5709650b0d7806074842c6de575025b1'))).encode('base64').replace('\n', ''))
    rf.close()
    print ("Done...")


encrypt("SERVER_IP", "USERNAME", "PASSWORD", "DATABASE")

Change SERVER_IP, USERNAME, PASSWORD, DATABASE to you new server and run script "python changeDB.py"

* Don't try using MariaDB. XtreamUI don't work with MariaDB, only with MySQL DB

 

[urgodfather]

Hello,

If you want to change your DB server info, use this python script:

#!/usr/bin/python
# -*- coding: utf-8 -*-

import os,sys
from itertools import cycle, izip

def encrypt(rHost="127.0.0.1", rUsername="user_iptvpro", rPassword="", rDatabase="xtream_iptvpro", rServerID=1, rPort=7999):
    print ("Encrypting...")
    try: os.remove("/home/xtreamcodes/iptv_xtream_codes/config")
    except: pass
    rf = open('/home/xtreamcodes/iptv_xtream_codes/config', 'wb')
    rf.write(''.join(chr(ord(c)^ord(k)) for c,k in izip('{\"host\":\"%s\",\"db_user\":\"%s\",\"db_pass\":\"%s\",\"db_name\":\"%s\",\"server_id\":\"%d\", \"db_port\":\"%d\"}' % (rHost, rUsername, rPassword, rDatabase, rServerID, rPort), cycle('5709650b0d7806074842c6de575025b1'))).encode('base64').replace('\n', ''))
    rf.close()
    print ("Done...")


encrypt("SERVER_IP", "USERNAME", "PASSWORD", "DATABASE")

Change SERVER_IP, USERNAME, PASSWORD, DATABASE to you new server and run script "python changeDB.py"

* Don't try using MariaDB. XtreamUI don't work with MariaDB, only with MySQL DB

Thanks for re-sharing this! Oh, XtreamUI DOES work with MariaDB if you configure it properly.

 

[Apollo]

Thanks for re-sharing this! Oh, XtreamUI DOES work with MariaDB if you configure it properly.

How ?
I try using docker to set it with MariaDB but seem php class not adding new record to database.

 

[urgodfather]

See!!!! You try to use Docker instance and then make assumption that XtreamUI does not work with MariaDB at all when really you found that XtreamUI does not work with YOUR Docker instance, probably because of some misconfiguration.

 

[Apollo]

See!!!! You try to use Docker instance and then make assumption that XtreamUI does not work with MariaDB at all when really you found that XtreamUI does not work with YOUR Docker instance, probably because of some misconfiguration.

Thank you Chief

 

[urgodfather]

You are welcome and if you need help with MariaDB then ask. ? Just know that it is not officially supported.

 

[Delta19]

thanks for the great job

as conclusion cant be used with XUI !?

 

[urgodfather]

No, conclusion is if you choose to make major changes outside of base install such as MariaDB instead of MySQL, you should be prepared to support yourself. No one has way to know if you use MariaDB and MariaDB is not MySQL. Is not fun to play guessing game. ? I will confirm that it DOES work when configured properly. I have multiple installs with it and no issues.