Gecko [ aodai.devttt.com ]

Name	Size	Permission
dns	[ DIR ]	drwxr-xr-x
dns-one	[ DIR ]	drwxr-xr-x
email-configs	[ DIR ]	drwxr-xr-x
email-configs-one	[ DIR ]	drwxr-xr-x
gun-configs	[ DIR ]	drwxr-xr-x
litespeed	[ DIR ]	drwxr-xr-x
lscpd	[ DIR ]	drwxr-xr-x
mysql	[ DIR ]	drwxr-xr-x
php-configs	[ DIR ]	drwxr-xr-x
phpconfigs	[ DIR ]	drwxr-xr-x
pure-ftpd	[ DIR ]	drwxr-xr-x
pure-ftpd-one	[ DIR ]	drwxr-xr-x
rainloop	[ DIR ]	drwxr-xr-x
CyberPanel8.repo	133 B	-rw-r--r--
__init__.py	0 B	-rw-r--r--
composer.sh	190 B	-rw-r--r--
composer_cn.sh	363 B	-rw-r--r--
cyberso.pub	386 B	-rw-r--r--
dns_cyberpanel.sh	1.68 KB	-rw-r--r--
env_generator.py	8.13 KB	-rw-r--r--
filesPermsUtilities.py	6.17 KB	-rw-r--r--
filesPermsUtilities.py.bak	6.17 KB	-rw-r--r--
firewallUtilities.py	3.03 KB	-rw-r--r--
install.py	124.6 KB	-rw-r--r--
install.py.bak	92.74 KB	-rw-r--r--
install.xml	512 B	-rw-r--r--
installCyberPanel.py	45.88 KB	-rw-r--r--
installLog.py	1.06 KB	-rw-r--r--
install_utils.py	12.75 KB	-rw-r--r--
lscp.tar.gz	36.19 MB	-rw-r--r--
mysqlUtilities.py	3.21 KB	-rw-r--r--
postfix-files	20.76 KB	-rw-r--r--
randomPassword.py	364 B	-rw-r--r--
setup_env.py	3.22 KB	-rw-r--r--
test.py	0 B	-rw-r--r--
unInstall.py	4.73 KB	-rw-r--r--
venvsetup.sh	41.49 KB	-rw-r--r--
venvsetup.sh.bak	41 KB	-rw-r--r--

Code Editor : mysqlUtilities.py

import subprocess, shlex
import install
import time

class mysqlUtilities:

@staticmethod
    def createDatabase(dbname, dbuser, dbpassword, publicip):

try:
            createDB = "CREATE DATABASE " + dbname

try:
                from json import loads
                mysqlData = loads(open("/etc/cyberpanel/mysqlPassword", 'r').read())

initCommand = 'mariadb -h %s --port %s -u %s -p%s -e "' % (mysqlData['mysqlhost'], mysqlData['mysqlport'], mysqlData['mysqluser'], mysqlData['mysqlpassword'])
                remote = 1
            except:
                passFile = "/etc/cyberpanel/mysqlPassword"

f = open(passFile)
                data = f.read()
                password = data.split('\n', 1)[0]

initCommand = 'mariadb -u root -p' + password + ' -e "'
                remote = 0

command = initCommand + createDB + '"'

if install.preFlightsChecks.debug:
                print(command)
                time.sleep(10)

cmd = shlex.split(command)
            res = subprocess.call(cmd)

if res == 1:
                return 0

if remote:
                createUser = "CREATE USER '" + dbuser + "'@'%s' IDENTIFIED BY '" % (publicip) + dbpassword + "'"
            else:
                createUser = "CREATE USER '" + dbuser + "'@'localhost' IDENTIFIED BY '" + dbpassword + "'"

command = initCommand + createUser + '"'

if install.preFlightsChecks.debug:
                print(command)
                time.sleep(10)

cmd = shlex.split(command)
            res = subprocess.call(cmd)

if res == 1:
                return 0
            else:

if remote:

### DO Check

if mysqlData['mysqlhost'].find('ondigitalocean') > -1:

alterUserPassword = "ALTER USER 'cyberpanel'@'%s' IDENTIFIED WITH mysql_native_password BY '%s'" % (
                        publicip, dbpassword)
                        command = initCommand + alterUserPassword + '"'

if install.preFlightsChecks.debug:
                            print(command)
                            time.sleep(10)

cmd = shlex.split(command)
                        subprocess.call(cmd)

## RDS Check

if mysqlData['mysqlhost'].find('rds.amazon') == -1:
                        dropDB = "GRANT ALL PRIVILEGES ON " + dbname + ".* TO '" + dbuser + "'@'%s'" % (publicip)
                    else:
                        dropDB = "GRANT INDEX, DROP, UPDATE, ALTER, CREATE, SELECT, INSERT, DELETE ON " + dbname + ".* TO '" + dbuser + "'@'%s'" % (publicip)
                else:
                    dropDB = "GRANT ALL PRIVILEGES ON " + dbname + ".* TO '" + dbuser + "'@'localhost'"

command = initCommand + dropDB + '"'

if install.preFlightsChecks.debug:
                    print(command)
                    time.sleep(10)

cmd = shlex.split(command)
                res = subprocess.call(cmd)

if res == 1:
                    return 0

return 1
        except BaseException as msg:
            return 0

${this.title}

Code Editor : mysqlUtilities.py