hello i am getting "(1146, “Table ‘cyberpanel.loginSystem_administrator’ doesn’t exist”) error, please let me know how to resolve it
(1146, “Table ‘cyberpanel.loginSystem_administrator’ doesn’t exist”)
Request Method: GET
Request URL: https://139.99.122.206:8090/
Django Version: 1.11
Exception Type: ProgrammingError
Exception Value:
(1146, “Table ‘cyberpanel.loginSystem_administrator’ doesn’t exist”)
Exception Location: /usr/lib64/python2.7/site-packages/MySQLdb/connections.py in defaulterrorhandler, line 36
Python Executable: /usr/bin/python
Python Version: 2.7.5
Python Path:
[‘/usr/local/CyberCP’,
‘/usr/bin’,
‘/usr/lib/python2.7/site-packages/gunicorn-19.8.1-py2.7.egg’,
‘/usr/lib64/python27.zip’,
‘/usr/lib64/python2.7’,
‘/usr/lib64/python2.7/plat-linux2’,
‘/usr/lib64/python2.7/lib-tk’,
‘/usr/lib64/python2.7/lib-old’,
‘/usr/lib64/python2.7/lib-dynload’,
‘/usr/lib64/python2.7/site-packages’,
‘/usr/lib/python2.7/site-packages’]
Server time: Wed, 23 May 2018 16:22:23 +0000
What steps did you take, just before this error?
just installed cyberpanel, after that i tried to login, but its not happened
It looks like migrations does not worked, can you paste the install log?
ok
[12-11-12-Thu-May-2018] Starting CyberPanel installation…
[12-11-12-Thu-May-2018] SELinux Check OK. [checkIfSeLinuxDisabled]
[12-11-12-Thu-May-2018] SUDO successfully installed!
[12-11-12-Thu-May-2018] CyberPanel user added!
[12-11-13-Thu-May-2018] CyberPanel user was successfully added to SUDO group!
[12-11-13-Thu-May-2018] Successfully created Let’s Encrypt directory!
[12-11-13-Thu-May-2018] YUM UPDATE ran successfully.
[12-11-14-Thu-May-2018] CyberPanel Repo added!
[12-11-17-Thu-May-2018] EPEL Repo added!
[12-11-24-Thu-May-2018] PIP successfully installed!
[12-11-29-Thu-May-2018] Python development tools successfully installed!
[12-11-29-Thu-May-2018] GCC Successfully installed!
[12-11-29-Thu-May-2018] Python setup tools Successfully installed!
[12-11-32-Thu-May-2018] DJANGO successfully installed!
[12-11-34-Thu-May-2018] pexpect successfully installed!
[12-11-37-Thu-May-2018] MySQL-python successfully installed!
[12-11-38-Thu-May-2018] GUNICORN successfully installed!
[12-11-40-Thu-May-2018] psutil successfully installed!
[12-11-40-Thu-May-2018] Configuring Gunicorn…
[12-11-40-Thu-May-2018] Gunicorn Configured!
[12-11-40-Thu-May-2018] Gunicorn can now start after system restart!
[12-11-40-Thu-May-2018] Gunicorn successfully started!
[12-11-52-Thu-May-2018] OpenLiteSpeed successfully installed!
[12-11-52-Thu-May-2018] Changing default port to 80…
[12-11-52-Thu-May-2018] Default port is now 80 for OpenLiteSpeed!
[12-11-54-Thu-May-2018] OpenLiteSpeed successfully restarted!
[12-11-54-Thu-May-2018] Setting up Filemanager files…
[12-11-54-Thu-May-2018] Filemanager files are set!
[12-13-37-Thu-May-2018] LiteSpeed PHPs successfully installed!
[12-13-58-Thu-May-2018] LiteSpeed PHP 7.1 successfully installed!
[12-14-21-Thu-May-2018] LiteSpeed PHP 7.1 successfully installed!
[12-14-21-Thu-May-2018] Fixing OpenLiteSpeed configurations!
[12-14-21-Thu-May-2018] OpenLiteSpeed Configurations fixed!
[12-14-23-Thu-May-2018] OpenLiteSpeed successfully restarted!
[12-14-23-Thu-May-2018] Setting up MariaDB Repo…
[12-14-23-Thu-May-2018] MariaDB repo set!
[12-15-04-Thu-May-2018] MariaDB successfully installed!
[12-15-04-Thu-May-2018] Setting up MariaDB configurations!
[12-15-04-Thu-May-2018] MariaDB configurations set!
[12-15-16-Thu-May-2018] Data directories created for second MariaDB instance!
[12-15-16-Thu-May-2018] First MariaDB instance successfully started!
[12-15-16-Thu-May-2018] First MariaDB instance successfully enabled at system restart!
[12-15-18-Thu-May-2018] MariaDB instance successfully started!
[12-15-18-Thu-May-2018] MariaDB instance successfully enabled at system restart!
[12-15-18-Thu-May-2018] Changing MariaDB root password…
[12-15-18-Thu-May-2018] End Of File (EOF). Exception style platform.
<pexpect.pty_spawn.spawn object at 0x7f119a4ddbd0>
command: /usr/bin/mysql
args: [’/usr/bin/mysql’, ‘-u’, ‘root’, ‘-p’]
buffer (last 100 chars): ‘’
before (last 100 chars): “ERROR 1045 (28000): Access denied for user ‘root’@‘localhost’ (using password: NO)\r
\x07\x1b(B\x1b[0;7m\x1b(B\x1b[m”
after: <class ‘pexpect.exceptions.EOF’>
match: None
match_index: None
exitstatus: None
flag_eof: True
pid: 14094
child_fd: 5
closed: False
timeout: 5
delimiter: <class ‘pexpect.exceptions.EOF’>
logfile: None
logfile_read: None
logfile_send: None
maxread: 2000
ignorecase: False
searchwindowsize: None
delaybeforesend: 0.05
delayafterclose: 0.1
delayafterterminate: 0.1
searcher: searcher_re:
0: re.compile(“clear the current input statement.”) Exception EOF [changeMYSQLRootPassword]
[12-15-18-Thu-May-2018] Changing CyberPanel MariaDB root password…
[12-15-18-Thu-May-2018] CyberPanel MariaDB root password changed!
[12-15-18-Thu-May-2018] MariaDB instance successfully started!
[12-15-23-Thu-May-2018] PureFTPD successfully installed!
[12-15-23-Thu-May-2018] PureFTPD successfully enabled at system restart!
[12-15-24-Thu-May-2018] System group for FTP successfully created!
[12-15-24-Thu-May-2018] System user for FTP successfully created!
[12-15-24-Thu-May-2018] Configuring PureFTPD…
[12-15-24-Thu-May-2018] SSL for PureFTPD successfully created!
[12-15-24-Thu-May-2018] PureFTPD configured!
[12-15-24-Thu-May-2018] Failed to start PureFTPD instance, you can do this manually later using systemctl start pure-ftpd [startPureFTPD]
[12-15-27-Thu-May-2018] PowerDNS Repositories successfully installed!
[12-15-29-Thu-May-2018] PowerDNS Repositories successfully installed!
[12-15-42-Thu-May-2018] PowerDNS successfully installed!
[12-15-42-Thu-May-2018] Configuring PowerDNS…
[12-15-42-Thu-May-2018] PowerDNS configured!
[12-15-43-Thu-May-2018] PowerDNS successfully enabled at system restart!
[12-15-43-Thu-May-2018] PowerDNS instance successfully started!
[12-15-43-Thu-May-2018] Starting LSCPD installation…
[12-15-47-Thu-May-2018] LSCPD prerequisites successfully installed!
[12-15-53-Thu-May-2018] LSCPD prerequisites successfully installed!
[12-15-53-Thu-May-2018] LSCPD successfully extracted!
[12-17-17-Thu-May-2018] LSCPD successfully configured!
[12-17-52-Thu-May-2018] LSCPD successfully complied!
[12-18-20-Thu-May-2018] LSCPD successfully complied!
[12-18-20-Thu-May-2018] SSL for LSCPD successfully created!
[12-18-20-Thu-May-2018] LSCPD successfully installed!
[12-18-20-Thu-May-2018] fix_selinux_issue problem
[12-18-21-Thu-May-2018] psmisc successfully installed!
[12-18-28-Thu-May-2018] Unable to install Postfix, you will not be able to send mails and rest should work fine! [install_postfix_davecot]
[12-18-34-Thu-May-2018] Unable to install install Dovecot and Dovecot-MySQL, you will not be able to send mails and rest should work fine! [install_postfix_davecot]
[12-18-34-Thu-May-2018] Setting up authentication for Postfix and Dovecot…
[12-18-34-Thu-May-2018] Authentication for Postfix and Dovecot set.
[12-18-34-Thu-May-2018] Configuring postfix and dovecot…
[12-18-34-Thu-May-2018] SSL for Postfix generated!
[12-18-34-Thu-May-2018] SSL generated for Dovecot!
[12-18-34-Thu-May-2018] Permissions changed for mysql-virtual_domains.cf!
[12-18-34-Thu-May-2018] Permissions changed for mysql-virtual_forwardings.cf!
[12-18-34-Thu-May-2018] Permissions changed for mysql-virtual_mailboxes.cf!
[12-18-34-Thu-May-2018] Permissions changed for mysql-virtual_email2email.cf!
[12-18-34-Thu-May-2018] Permissions changed for /etc/postfix/main.cf!
[12-18-34-Thu-May-2018] Permissions changed for /etc/postfix/master.cf!
[12-18-34-Thu-May-2018] Group changed for mysql-virtual_domains.cf!
[12-18-34-Thu-May-2018] Group changed for mysql-virtual_forwardings.cf!
[12-18-34-Thu-May-2018] Group changed for mysql-virtual_mailboxes.cf!
[12-18-34-Thu-May-2018] Group changed for mysql-virtual_email2email.cf!
[12-18-34-Thu-May-2018] Group changed for /etc/postfix/main.cf!
[12-18-34-Thu-May-2018] Group changed for /etc/postfix/master.cf!
[12-18-34-Thu-May-2018] System group vmail created successfully!
[12-18-35-Thu-May-2018] System user vmail created successfully!
[12-18-35-Thu-May-2018] Failed to enable Postfix to run at system restart you can manually do this using systemctl enable postfix.service! [setup_postfix_davecot_config]
[12-18-35-Thu-May-2018] postfix.service started successfully!
[12-18-35-Thu-May-2018] Group changed for /etc/dovecot/dovecot-sql.conf.ext!
[12-18-35-Thu-May-2018] Permissions changed for /etc/dovecot/dovecot-sql.conf.ext!
[12-18-35-Thu-May-2018] dovecot.service successfully enabled!
[12-18-35-Thu-May-2018] dovecot.service successfully started!
[12-18-35-Thu-May-2018] dovecot.service successfully restarted!
[12-18-35-Thu-May-2018] Permissions changed for /etc/postfix/main.cf!
[12-18-35-Thu-May-2018] Postfix and Dovecot configured
[12-18-36-Thu-May-2018] unzip successfully installed!
[12-18-37-Thu-May-2018] zip successfully installed!
[12-18-38-Thu-May-2018] Succcessfully installed rsync!
[12-18-38-Thu-May-2018] Owner changed for /usr/local/lscp/cyberpanel/!
[12-18-38-Thu-May-2018] Rainloop Downloaded!
[12-18-39-Thu-May-2018] Rainloop successfully unzipped!
[12-18-39-Thu-May-2018] Rainloop permissions changed!
[12-18-41-Thu-May-2018] Rainloop permissions changed!
[12-18-41-Thu-May-2018] Rainloop owner changed!
[12-18-42-Thu-May-2018] PHPMYAdmin successfully downloaded!
[12-18-42-Thu-May-2018] PHPMYAdmin unzipped!
[12-18-42-Thu-May-2018] PHPMYAdmin Successfully installed!
[12-18-48-Thu-May-2018] FirewallD successfully installed!
[12-18-48-Thu-May-2018] FirewallD successfully started!
[12-18-49-Thu-May-2018] FirewallD successfully enabled on system startup!
[12-18-56-Thu-May-2018] FirewallD installed and configured!
[12-18-56-Thu-May-2018] Trying to setup LSCPD Daemon!
[12-18-56-Thu-May-2018] Successfully changed permissions for /usr/local/lscp/bin/lscpdctrl!
[12-18-56-Thu-May-2018] LSCPD Successfully enabled at system startup!
[12-18-58-Thu-May-2018] LSCPD successfully started!
[12-18-58-Thu-May-2018] LSCPD Daemon Set!
[12-19-00-Thu-May-2018] urllib3 module Successfully installed!
[12-19-02-Thu-May-2018] Requests module Successfully installed!
[12-19-02-Thu-May-2018] Succcessfully created default SSH keys!
[12-19-06-Thu-May-2018] pyOpenSSL successfully installed! [pip]
[12-19-11-Thu-May-2018] CertBot successfully installed! [pip]
[12-19-24-Thu-May-2018] CyberPanel successfully downloaded!
[12-19-26-Thu-May-2018] Successfully extracted CyberPanel!
[12-19-26-Thu-May-2018] Updating settings.py!
[12-19-26-Thu-May-2018] settings.py updated!
[12-19-26-Thu-May-2018] Unable to prepare migrations file. You can try to install on fresh OS again, exiting installer! [download_install_CyberPanel]
So this is the issue:
[12-19-26-Thu-May-2018] Unable to prepare migrations file. You can try to install on fresh OS again, exiting installer! [download_install_CyberPanel]
Which centos version is it and VPS (OpenVZ or KVM) or dedicated.
It’s dedicated, cent os 7.4 64bit
I will reinstall OS and panel then
Reinstalling now