CyberHosting

MySQL Strict Mode is not set for database connection

Hi team, I receive this warning message during cyberpanel Installation ( Centos 7 ) whats mean?
Provider: Cloud4box

Virtualization Type: VMZ ( i guess)

System: CentOS-7-amd64

Installation option: since during the installation.


OLS or Enterprise?
OLS

Installing from official server or mirror server?
mirror


Replace JS/CSS files to JS Delivr?
yes
Install Memcached extension for PHP?
yes

Install LiteSpeed Memcached?
yes

Install Memcached?
yes

Install Redis extension for PHP?
yes

Install Redis?
yes


Problem:


?: (mysql.W002) MySQL Strict Mode is not set for database connection 'default'

HINT: MySQL's Strict Mode fixes many data integrity problems in MySQL, such as data truncation upon insertion, by escalating warnings into errors. It is strongly recommended you activate it. See: https://docs.djangoproject.com/en/1.11/ref/databases/

?: (mysql.W002) MySQL Strict Mode is not set for database connection 'rootdb'

HINT: MySQL's Strict Mode fixes many data integrity problems in MySQL, such as data truncation upon insertion, by escalating warnings into errors. It is strongly recommended you activate it. See: https://docs.djangoproject.com/en/1.11/ref/databases/

and the installation process stopped here:
Applying websiteFunctions.0001_initial...^CTraceback (most recent call last):

File "install.py", line 3773, in

main()

File "install.py", line 3723, in main

checks.download_install_CyberPanel(installCyberPanel.InstallCyberPanel.mysqlPassword, mysql)

File "install.py", line 1042, in download_install_CyberPanel

'CyberPanel Migrate',1, 1, os.EX_OSERR)

File "install.py", line 211, in call

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

File "/usr/lib64/python2.7/subprocess.py", line 524, in call

return Popen(*popenargs, **kwargs).wait()

File "/usr/lib64/python2.7/subprocess.py", line 1376, in wait

pid, sts = _eintr_retry_call(os.waitpid, self.pid, 0)

File "/usr/lib64/python2.7/subprocess.py", line 478, in _eintr_retry_call

return func(*args)

KeyboardInterrupt

Something went wrong...

[root@vps ~]# Traceback (most recent call last):

File "manage.py", line 22, in

execute_from_command_line(sys.argv)

File "/usr/lib64/python2.7/site-packages/django/core/management/__init__.py", line 363, in execute_from_command_line

utility.execute()

File "/usr/lib64/python2.7/site-packages/django/core/management/__init__.py", line 355, in execute

self.fetch_command(subcommand).run_from_argv(self.argv)

File "/usr/lib64/python2.7/site-packages/django/core/management/base.py", line 283, in run_from_argv

self.execute(*args, **cmd_options)

File "/usr/lib64/python2.7/site-packages/django/core/management/base.py", line 330, in execute

output = self.handle(*args, **options)

File "/usr/lib64/python2.7/site-packages/django/core/management/commands/migrate.py", line 204, in handle

fake_initial=fake_initial,

File "/usr/lib64/python2.7/site-packages/django/db/migrations/executor.py", line 115, in migrate

state = self._migrate_all_forwards(state, plan, full_plan, fake=fake, fake_initial=fake_initial)

File "/usr/lib64/python2.7/site-packages/django/db/migrations/executor.py", line 145, in _migrate_all_forwards

state = self.apply_migration(state, migration, fake=fake, fake_initial=fake_initial)

File "/usr/lib64/python2.7/site-packages/django/db/migrations/executor.py", line 244, in apply_migration

state = migration.apply(state, schema_editor)

File "/usr/lib64/python2.7/site-packages/django/db/migrations/migration.py", line 129, in apply

operation.database_forwards(self.app_label, schema_editor, old_state, project_state)

File "/usr/lib64/python2.7/site-packages/django/db/migrations/operations/models.py", line 97, in database_forwards

schema_editor.create_model(model)

File "/usr/lib64/python2.7/site-packages/django/db/backends/base/schema.py", line 302, in create_model

self.execute(sql, params or None)

File "/usr/lib64/python2.7/site-packages/django/db/backends/base/schema.py", line 119, in execute

cursor.execute(sql, params)

File "/usr/lib64/python2.7/site-packages/django/db/backends/utils.py", line 63, in execute

return self.cursor.execute(sql)

File "/usr/lib64/python2.7/site-packages/django/db/backends/mysql/base.py", line 101, in execute

return self.cursor.execute(query, args)

File "/usr/lib64/python2.7/site-packages/MySQLdb/cursors.py", line 190, in execute

r = self._query(query)

File "/usr/lib64/python2.7/site-packages/MySQLdb/cursors.py", line 354, in _query

rowcount = self._do_query(q)

File "/usr/lib64/python2.7/site-packages/MySQLdb/cursors.py", line 318, in _do_query

db.query(q)

KeyboardInterrupt
Sign In or Register to comment.
CyberPanel Discord

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!