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.
CyberHosting CyberPanel Discord

Howdy, Stranger!

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