Closed krypto29s closed 7 years ago
The errors indicate that you are running php 5.3. Make sure you follow the instructions from the install directory, especially when it comes to setting up scl.
On Jul 6, 2017 3:37 AM, "krypto29s" notifications@github.com wrote:
I followed the install guide according, and when I start the process everything appears to start but I am not able to access http://misp/user/login url. I am getting an error 500. sudo su -s /bin/bash apache -c 'scl enable rh-php56 /var/www/MISP/app/Console/worker/start.sh' [sudo] password for sjohn345: Stopping workers Stopping 12950 ... Done Stopping the Scheduler Worker ... Done Stopping 12968 ... Done Stopping 12986 ... Done Stopping 13004 ... Done
Creating workers Starting worker ... Done
Creating workers Starting worker ... Done
Creating workers Starting worker ... Done
Creating workers Starting worker ... Done
Creating the scheduler workers Starting scheduler worker ... Done ! more misp.local_error.log [Wed Jul 05 21:28:56.478562 2017] [:error] [pid 11684] [client ::1:51188] PHP Fatal error: Can't use function return value in write context in /var/www/MISP/app/Controller/UsersController.php on line 97 [Wed Jul 05 21:28:56.479803 2017] [:error] [pid 11684] [client ::1:51188] PHP Fatal error: Can't use function return value in write context in /var/www/MISP/app/Controller/AppController.php on line 305 [Wed Jul 05 21:29:02.058256 2017] [:error] [pid 2369] [client ::1:51190] PHP Fatal error: Can't use function return value in write context in /var/www/MISP/app/Controller/AppController.php on line 305
— You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHub https://github.com/MISP/misp-book/issues/54, or mute the thread https://github.com/notifications/unsubscribe-auth/ADf6wH-Z4492HLwgVX-GlrG-Xg3NmtNYks5sLDppgaJpZM4OPDzm .
I have followed the instructions located here. https://github.com/MISP/MISP/blob/2.4/INSTALL/xINSTALL.centos7.txt.
Am I missing something?
This is from /var/www/MISP/app/tmp/logs/error.log Request URL: /user/login Stack Trace:
2017-07-05 21:35:57 Error: Fatal Error (64): Can't use function return value in write context in [/var/www/MISP/app/Controller/AppController.php, line 305] 2017-07-05 21:35:57 Error: [InternalErrorException] Internal Server Error Request URL: /user/login Stack Trace:
2017-07-06 08:16:35 Error: Fatal Error (64): Can't use function return value in write context in [/var/www/MISP/app/Controller/UsersController.php, line 97] 2017-07-06 08:16:35 Error: [InternalErrorException] Internal Server Error Request URL: /users/login Stack Trace:
2017-07-06 08:16:42 Error: Fatal Error (64): Can't use function return value in write context in [/var/www/MISP/app/Controller/AppController.php, line 305] 2017-07-06 08:16:42 Error: [InternalErrorException] Internal Server Error Request URL: / Stack Trace:
This is from: /var/www/MISP/app/tmp/logs/debug.log
2017-07-06 08:16:42 Notice: Notice (8): Undefined variable: debugMode in [/var/www/MISP/app/View/Layouts/default.ctp, line 11] Trace: ErrorHandler::handleError() - APP/Lib/cakephp/lib/Cake/Error/ErrorHandler.php, line 230 include - APP/View/Layouts/default.ctp, line 11 View::_evaluate() - APP/Lib/cakephp/lib/Cake/View/View.php, line 971 View::_render() - APP/Lib/cakephp/lib/Cake/View/View.php, line 933 View::renderLayout() - APP/Lib/cakephp/lib/Cake/View/View.php, line 546 View::render() - APP/Lib/cakephp/lib/Cake/View/View.php, line 481 Controller::render() - APP/Lib/cakephp/lib/Cake/Controller/Controller.php, line 963 ExceptionRenderer::_outputMessage() - APP/Lib/cakephp/lib/Cake/Error/ExceptionRenderer.php, line 292 ExceptionRenderer::error500() - APP/Lib/cakephp/lib/Cake/Error/ExceptionRenderer.php, line 260 ExceptionRenderer::render() - APP/Lib/cakephp/lib/Cake/Error/ExceptionRenderer.php, line 190 ErrorHandler::handleException() - APP/Lib/cakephp/lib/Cake/Error/ErrorHandler.php, line 127 call_user_func - [internal], line ?? ErrorHandler::handleFatalError() - APP/Lib/cakephp/lib/Cake/Error/ErrorHandler.php, line 269 ErrorHandler::handleError() - APP/Lib/cakephp/lib/Cake/Error/ErrorHandler.php, line 212 call_user_func - [internal], line ?? App::_checkFatalError() - APP/Lib/cakephp/lib/Cake/Core/App.php, line 970 App::shutdown() - APP/Lib/cakephp/lib/Cake/Core/App.php, line 943 [main] - [internal], line ??
2017-07-06 08:16:42 Notice: Notice (8): Undefined variable: me in [/var/www/MISP/app/View/Layouts/default.ctp, line 21] Trace: ErrorHandler::handleError() - APP/Lib/cakephp/lib/Cake/Error/ErrorHandler.php, line 230 include - APP/View/Layouts/default.ctp, line 21 View::_evaluate() - APP/Lib/cakephp/lib/Cake/View/View.php, line 971 View::_render() - APP/Lib/cakephp/lib/Cake/View/View.php, line 933 View::renderLayout() - APP/Lib/cakephp/lib/Cake/View/View.php, line 546 View::render() - APP/Lib/cakephp/lib/Cake/View/View.php, line 481 Controller::render() - APP/Lib/cakephp/lib/Cake/Controller/Controller.php, line 963 ExceptionRenderer::_outputMessage() - APP/Lib/cakephp/lib/Cake/Error/ExceptionRenderer.php, line 292 ExceptionRenderer::error500() - APP/Lib/cakephp/lib/Cake/Error/ExceptionRenderer.php, line 260 ExceptionRenderer::render() - APP/Lib/cakephp/lib/Cake/Error/ExceptionRenderer.php, line 190 ErrorHandler::handleException() - APP/Lib/cakephp/lib/Cake/Error/ErrorHandler.php, line 127 call_user_func - [internal], line ?? ErrorHandler::handleFatalError() - APP/Lib/cakephp/lib/Cake/Error/ErrorHandler.php, line 269 ErrorHandler::handleError() - APP/Lib/cakephp/lib/Cake/Error/ErrorHandler.php, line 212 call_user_func - [internal], line ?? App::_checkFatalError() - APP/Lib/cakephp/lib/Cake/Core/App.php, line 970 App::shutdown() - APP/Lib/cakephp/lib/Cake/Core/App.php, line 943 [main] - [internal], line ??
2017-07-06 08:16:42 Notice: Notice (8): Undefined variable: debugMode in [/var/www/MISP/app/View/Elements/global_menu.ctp, line 1] Trace: ErrorHandler::handleError() - APP/Lib/cakephp/lib/Cake/Error/ErrorHandler.php, line 230 include - APP/View/Elements/global_menu.ctp, line 1 View::_evaluate() - APP/Lib/cakephp/lib/Cake/View/View.php, line 971 View::_render() - APP/Lib/cakephp/lib/Cake/View/View.php, line 933 View::_renderElement() - APP/Lib/cakephp/lib/Cake/View/View.php, line 1224 View::element() - APP/Lib/cakephp/lib/Cake/View/View.php, line 418 include - APP/View/Layouts/default.ctp, line 46 View::_evaluate() - APP/Lib/cakephp/lib/Cake/View/View.php, line 971 View::_render() - APP/Lib/cakephp/lib/Cake/View/View.php, line 933 View::renderLayout() - APP/Lib/cakephp/lib/Cake/View/View.php, line 546 View::render() - APP/Lib/cakephp/lib/Cake/View/View.php, line 481 Controller::render() - APP/Lib/cakephp/lib/Cake/Controller/Controller.php, line 963 ExceptionRenderer::_outputMessage() - APP/Lib/cakephp/lib/Cake/Error/ExceptionRenderer.php, line 292 ExceptionRenderer::error500() - APP/Lib/cakephp/lib/Cake/Error/ExceptionRenderer.php, line 260 ExceptionRenderer::render() - APP/Lib/cakephp/lib/Cake/Error/ExceptionRenderer.php, line 190 ErrorHandler::handleException() - APP/Lib/cakephp/lib/Cake/Error/ErrorHandler.php, line 127 call_user_func - [internal], line ?? ErrorHandler::handleFatalError() - APP/Lib/cakephp/lib/Cake/Error/ErrorHandler.php, line 269 ErrorHandler::handleError() - APP/Lib/cakephp/lib/Cake/Error/ErrorHandler.php, line 212 call_user_func - [internal], line ?? App::_checkFatalError() - APP/Lib/cakephp/lib/Cake/Core/App.php, line 970 App::shutdown() - APP/Lib/cakephp/lib/Cake/Core/App.php, line 943 [main] - [internal], line ??
2017-07-06 08:16:42 Notice: Notice (8): Undefined variable: me in [/var/www/MISP/app/View/Elements/global_menu.ctp, line 10] Trace: ErrorHandler::handleError() - APP/Lib/cakephp/lib/Cake/Error/ErrorHandler.php, line 230 include - APP/View/Elements/global_menu.ctp, line 10 View::_evaluate() - APP/Lib/cakephp/lib/Cake/View/View.php, line 971 View::_render() - APP/Lib/cakephp/lib/Cake/View/View.php, line 933 View::_renderElement() - APP/Lib/cakephp/lib/Cake/View/View.php, line 1224 View::element() - APP/Lib/cakephp/lib/Cake/View/View.php, line 418 include - APP/View/Layouts/default.ctp, line 46 View::_evaluate() - APP/Lib/cakephp/lib/Cake/View/View.php, line 971 View::_render() - APP/Lib/cakephp/lib/Cake/View/View.php, line 933 View::renderLayout() - APP/Lib/cakephp/lib/Cake/View/View.php, line 546 View::render() - APP/Lib/cakephp/lib/Cake/View/View.php, line 481 Controller::render() - APP/Lib/cakephp/lib/Cake/Controller/Controller.php, line 963 ExceptionRenderer::_outputMessage() - APP/Lib/cakephp/lib/Cake/Error/ExceptionRenderer.php, line 292 ExceptionRenderer::error500() - APP/Lib/cakephp/lib/Cake/Error/ExceptionRenderer.php, line 260 ExceptionRenderer::render() - APP/Lib/cakephp/lib/Cake/Error/ExceptionRenderer.php, line 190 ErrorHandler::handleException() - APP/Lib/cakephp/lib/Cake/Error/ErrorHandler.php, line 127 call_user_func - [internal], line ?? ErrorHandler::handleFatalError() - APP/Lib/cakephp/lib/Cake/Error/ErrorHandler.php, line 269 ErrorHandler::handleError() - APP/Lib/cakephp/lib/Cake/Error/ErrorHandler.php, line 212 call_user_func - [internal], line ?? App::_checkFatalError() - APP/Lib/cakephp/lib/Cake/Core/App.php, line 970 App::shutdown() - APP/Lib/cakephp/lib/Cake/Core/App.php, line 943 [main] - [internal], line ??
2017-07-06 08:16:42 Notice: Notice (8): Undefined variable: debugMode in [/var/www/MISP/app/View/Layouts/default.ctp, line 48] Trace: ErrorHandler::handleError() - APP/Lib/cakephp/lib/Cake/Error/ErrorHandler.php, line 230 include - APP/View/Layouts/default.ctp, line 48 View::_evaluate() - APP/Lib/cakephp/lib/Cake/View/View.php, line 971 View::_render() - APP/Lib/cakephp/lib/Cake/View/View.php, line 933 View::renderLayout() - APP/Lib/cakephp/lib/Cake/View/View.php, line 546 View::render() - APP/Lib/cakephp/lib/Cake/View/View.php, line 481 Controller::render() - APP/Lib/cakephp/lib/Cake/Controller/Controller.php, line 963 ExceptionRenderer::_outputMessage() - APP/Lib/cakephp/lib/Cake/Error/ExceptionRenderer.php, line 292 ExceptionRenderer::error500() - APP/Lib/cakephp/lib/Cake/Error/ExceptionRenderer.php, line 260 ExceptionRenderer::render() - APP/Lib/cakephp/lib/Cake/Error/ExceptionRenderer.php, line 190 ErrorHandler::handleException() - APP/Lib/cakephp/lib/Cake/Error/ErrorHandler.php, line 127 call_user_func - [internal], line ?? ErrorHandler::handleFatalError() - APP/Lib/cakephp/lib/Cake/Error/ErrorHandler.php, line 269 ErrorHandler::handleError() - APP/Lib/cakephp/lib/Cake/Error/ErrorHandler.php, line 212 call_user_func - [internal], line ?? App::_checkFatalError() - APP/Lib/cakephp/lib/Cake/Core/App.php, line 970 App::shutdown() - APP/Lib/cakephp/lib/Cake/Core/App.php, line 943 [main] - [internal], line ??
2017-07-06 08:16:42 Notice: Notice (8): Undefined variable: debugMode in [/var/www/MISP/app/View/Layouts/default.ctp, line 50] Trace: ErrorHandler::handleError() - APP/Lib/cakephp/lib/Cake/Error/ErrorHandler.php, line 230 include - APP/View/Layouts/default.ctp, line 50 View::_evaluate() - APP/Lib/cakephp/lib/Cake/View/View.php, line 971 View::_render() - APP/Lib/cakephp/lib/Cake/View/View.php, line 933 View::renderLayout() - APP/Lib/cakephp/lib/Cake/View/View.php, line 546 View::render() - APP/Lib/cakephp/lib/Cake/View/View.php, line 481 Controller::render() - APP/Lib/cakephp/lib/Cake/Controller/Controller.php, line 963 ExceptionRenderer::_outputMessage() - APP/Lib/cakephp/lib/Cake/Error/ExceptionRenderer.php, line 292 ExceptionRenderer::error500() - APP/Lib/cakephp/lib/Cake/Error/ExceptionRenderer.php, line 260 ExceptionRenderer::render() - APP/Lib/cakephp/lib/Cake/Error/ExceptionRenderer.php, line 190 ErrorHandler::handleException() - APP/Lib/cakephp/lib/Cake/Error/ErrorHandler.php, line 127 call_user_func - [internal], line ?? ErrorHandler::handleFatalError() - APP/Lib/cakephp/lib/Cake/Error/ErrorHandler.php, line 269 ErrorHandler::handleError() - APP/Lib/cakephp/lib/Cake/Error/ErrorHandler.php, line 212 call_user_func - [internal], line ?? App::_checkFatalError() - APP/Lib/cakephp/lib/Cake/Core/App.php, line 970 App::shutdown() - APP/Lib/cakephp/lib/Cake/Core/App.php, line 943 [main] - [internal], line ??
2017-07-06 08:16:42 Notice: Notice (8): Undefined variable: debugMode in [/var/www/MISP/app/View/Elements/footer.ctp, line 1] Trace: ErrorHandler::handleError() - APP/Lib/cakephp/lib/Cake/Error/ErrorHandler.php, line 230 include - APP/View/Elements/footer.ctp, line 1 View::_evaluate() - APP/Lib/cakephp/lib/Cake/View/View.php, line 971 View::_render() - APP/Lib/cakephp/lib/Cake/View/View.php, line 933 View::_renderElement() - APP/Lib/cakephp/lib/Cake/View/View.php, line 1224 View::element() - APP/Lib/cakephp/lib/Cake/View/View.php, line 418 include - APP/View/Layouts/default.ctp, line 81 View::_evaluate() - APP/Lib/cakephp/lib/Cake/View/View.php, line 971 View::_render() - APP/Lib/cakephp/lib/Cake/View/View.php, line 933 View::renderLayout() - APP/Lib/cakephp/lib/Cake/View/View.php, line 546 View::render() - APP/Lib/cakephp/lib/Cake/View/View.php, line 481 Controller::render() - APP/Lib/cakephp/lib/Cake/Controller/Controller.php, line 963 ExceptionRenderer::_outputMessage() - APP/Lib/cakephp/lib/Cake/Error/ExceptionRenderer.php, line 292 ExceptionRenderer::error500() - APP/Lib/cakephp/lib/Cake/Error/ExceptionRenderer.php, line 260 ExceptionRenderer::render() - APP/Lib/cakephp/lib/Cake/Error/ExceptionRenderer.php, line 190 ErrorHandler::handleException() - APP/Lib/cakephp/lib/Cake/Error/ErrorHandler.php, line 127 call_user_func - [internal], line ?? ErrorHandler::handleFatalError() - APP/Lib/cakephp/lib/Cake/Error/ErrorHandler.php, line 269 ErrorHandler::handleError() - APP/Lib/cakephp/lib/Cake/Error/ErrorHandler.php, line 212 call_user_func - [internal], line ?? App::_checkFatalError() - APP/Lib/cakephp/lib/Cake/Core/App.php, line 970 App::shutdown() - APP/Lib/cakephp/lib/Cake/Core/App.php, line 943 [main] - [internal], line ??
2017-07-06 08:16:42 Notice: Notice (8): Undefined variable: me in [/var/www/MISP/app/View/Layouts/default.ctp, line 87] Trace: ErrorHandler::handleError() - APP/Lib/cakephp/lib/Cake/Error/ErrorHandler.php, line 230 include - APP/View/Layouts/default.ctp, line 87 View::_evaluate() - APP/Lib/cakephp/lib/Cake/View/View.php, line 971 View::_render() - APP/Lib/cakephp/lib/Cake/View/View.php, line 933 View::renderLayout() - APP/Lib/cakephp/lib/Cake/View/View.php, line 546 View::render() - APP/Lib/cakephp/lib/Cake/View/View.php, line 481 Controller::render() - APP/Lib/cakephp/lib/Cake/Controller/Controller.php, line 963 ExceptionRenderer::_outputMessage() - APP/Lib/cakephp/lib/Cake/Error/ExceptionRenderer.php, line 292 ExceptionRenderer::error500() - APP/Lib/cakephp/lib/Cake/Error/ExceptionRenderer.php, line 260 ExceptionRenderer::render() - APP/Lib/cakephp/lib/Cake/Error/ExceptionRenderer.php, line 190 ErrorHandler::handleException() - APP/Lib/cakephp/lib/Cake/Error/ErrorHandler.php, line 127 call_user_func - [internal], line ?? ErrorHandler::handleFatalError() - APP/Lib/cakephp/lib/Cake/Error/ErrorHandler.php, line 269 ErrorHandler::handleError() - APP/Lib/cakephp/lib/Cake/Error/ErrorHandler.php, line 212 call_user_func - [internal], line ?? App::_checkFatalError() - APP/Lib/cakephp/lib/Cake/Core/App.php, line 970 App::shutdown() - APP/Lib/cakephp/lib/Cake/Core/App.php, line 943 [main] - [internal], line ??
2017-07-06 08:16:42 Notice: Notice (8): Undefined variable: debugMode in [/var/www/MISP/app/View/Layouts/default.ctp, line 102] Trace: ErrorHandler::handleError() - APP/Lib/cakephp/lib/Cake/Error/ErrorHandler.php, line 230 include - APP/View/Layouts/default.ctp, line 102 View::_evaluate() - APP/Lib/cakephp/lib/Cake/View/View.php, line 971 View::_render() - APP/Lib/cakephp/lib/Cake/View/View.php, line 933 View::renderLayout() - APP/Lib/cakephp/lib/Cake/View/View.php, line 546 View::render() - APP/Lib/cakephp/lib/Cake/View/View.php, line 481 Controller::render() - APP/Lib/cakephp/lib/Cake/Controller/Controller.php, line 963 ExceptionRenderer::_outputMessage() - APP/Lib/cakephp/lib/Cake/Error/ExceptionRenderer.php, line 292 ExceptionRenderer::error500() - APP/Lib/cakephp/lib/Cake/Error/ExceptionRenderer.php, line 260 ExceptionRenderer::render() - APP/Lib/cakephp/lib/Cake/Error/ExceptionRenderer.php, line 190 ErrorHandler::handleException() - APP/Lib/cakephp/lib/Cake/Error/ErrorHandler.php, line 127 call_user_func - [internal], line ?? ErrorHandler::handleFatalError() - APP/Lib/cakephp/lib/Cake/Error/ErrorHandler.php, line 269 ErrorHandler::handleError() - APP/Lib/cakephp/lib/Cake/Error/ErrorHandler.php, line 212 call_user_func - [internal], line ?? App::_checkFatalError() - APP/Lib/cakephp/lib/Cake/Core/App.php, line 970 App::shutdown() - APP/Lib/cakephp/lib/Cake/Core/App.php, line 943 [main] - [internal], line ??
Which version of PHP are using?
~]$ php -v PHP 5.4.16 (cli) (built: Nov 6 2016 00:29:02) Copyright (c) 1997-2013 The PHP Group Zend Engine v2.4.0, Copyright (c) 1998-2013 Zend Technologies
This is weird; I just had to rerun the below; scl enable rh-php56 bash
~]$ php -v PHP 5.6.25 (cli) (built: Oct 21 2016 18:00:07) Copyright (c) 1997-2016 The PHP Group Zend Engine v2.6.0, Copyright (c) 1998-2016 Zend Technologies ~]$ sudo su -s /bin/bash apache -c 'scl enable rh-php56 /var/www/MISP/app/Console/worker/start.sh'
Still same error
Yes, scl enable rh-php56 bash enables scl for your current shell. It will however not change anything for apache.
I have uninstalled php 5.4. The only version of php is 5.6. I will put a phpinfo in the web root, and let let you know how that works.
1
--
# rh-php56-php only provided mod_php for httpd24-httpd from SCL
| # if we want to use httpd from CentOS base we can use rh-php56-php-fpm instead
| systemctl enable rh-php56-php-fpm.service
| systemctl start rh-php56-php-fpm.service
Did you do this?
Yes I did
php info wasn't working. That told me that I had some integration issues with the web server. I ran a pecl upgrade-all. phpinfo now shows me that php version is still 5.4. Not sure how that is, because php 5.4 is uninstalled. Crazy thing is php -v now shows it is back... ugh.
php 5.4 being back isn't a problem, the important part is to go through the SCL 5.6 intallation. Did you use and modify the CentOS apache conf file?
https://github.com/MISP/MISP/blob/2.4/INSTALL/apache.misp.centos7
Yes sir, I did. I executed the below. cp /var/www/MISP/INSTALL/apache.misp.centos7 /etc/httpd/conf.d/misp.conf
FYI, i just bounced the apache service, and phpinfo now shows 5.6, and I still getting error 500.
What is the stack trace now? While running 5.6 that is? Because the previous error was a 5.4 error.
On Thu, Jul 6, 2017 at 3:38 PM, krypto29s notifications@github.com wrote:
Yes sir, I did. I executed the below. cp /var/www/MISP/INSTALL/apache.misp.centos7 /etc/httpd/conf.d/misp.conf
FYI, i just bounced the apache service, and phpinfo now shows 5.6, and I still getting error 500.
— You are receiving this because you commented. Reply to this email directly, view it on GitHub https://github.com/MISP/misp-book/issues/54#issuecomment-313398481, or mute the thread https://github.com/notifications/unsubscribe-auth/ADf6wJwXd61nfCSGAC92OR7Mvk3OnuXQks5sLONQgaJpZM4OPDzm .
2017-07-06 09:48:43 Notice: Notice (8): Undefined variable: debugMode in [/var/www/MISP/app/View/Layouts/default.ctp, line 11] Trace: ErrorHandler::handleError() - APP/Lib/cakephp/lib/Cake/Error/ErrorHandler.php, line 230 include - APP/View/Layouts/default.ctp, line 11 View::_evaluate() - APP/Lib/cakephp/lib/Cake/View/View.php, line 971 View::_render() - APP/Lib/cakephp/lib/Cake/View/View.php, line 933 View::renderLayout() - APP/Lib/cakephp/lib/Cake/View/View.php, line 546 View::render() - APP/Lib/cakephp/lib/Cake/View/View.php, line 481 Controller::render() - APP/Lib/cakephp/lib/Cake/Controller/Controller.php, line 963 ExceptionRenderer::_outputMessage() - APP/Lib/cakephp/lib/Cake/Error/ExceptionRenderer.php, line 292 ExceptionRenderer::error500() - APP/Lib/cakephp/lib/Cake/Error/ExceptionRenderer.php, line 260 ExceptionRenderer::render() - APP/Lib/cakephp/lib/Cake/Error/ExceptionRenderer.php, line 190 ErrorHandler::handleException() - APP/Lib/cakephp/lib/Cake/Error/ErrorHandler.php, line 127 [main] - [internal], line ??
2017-07-06 09:48:43 Notice: Notice (8): Undefined variable: me in [/var/www/MISP/app/View/Layouts/default.ctp, line 21] Trace: ErrorHandler::handleError() - APP/Lib/cakephp/lib/Cake/Error/ErrorHandler.php, line 230 include - APP/View/Layouts/default.ctp, line 21 View::_evaluate() - APP/Lib/cakephp/lib/Cake/View/View.php, line 971 View::_render() - APP/Lib/cakephp/lib/Cake/View/View.php, line 933 View::renderLayout() - APP/Lib/cakephp/lib/Cake/View/View.php, line 546 View::render() - APP/Lib/cakephp/lib/Cake/View/View.php, line 481 Controller::render() - APP/Lib/cakephp/lib/Cake/Controller/Controller.php, line 963 ExceptionRenderer::_outputMessage() - APP/Lib/cakephp/lib/Cake/Error/ExceptionRenderer.php, line 292 ExceptionRenderer::error500() - APP/Lib/cakephp/lib/Cake/Error/ExceptionRenderer.php, line 260 ExceptionRenderer::render() - APP/Lib/cakephp/lib/Cake/Error/ExceptionRenderer.php, line 190 ErrorHandler::handleException() - APP/Lib/cakephp/lib/Cake/Error/ErrorHandler.php, line 127 [main] - [internal], line ??
2017-07-06 09:48:43 Notice: Notice (8): Undefined variable: debugMode in [/var/www/MISP/app/View/Elements/global_menu.ctp, line 1] Trace: ErrorHandler::handleError() - APP/Lib/cakephp/lib/Cake/Error/ErrorHandler.php, line 230 include - APP/View/Elements/global_menu.ctp, line 1 View::_evaluate() - APP/Lib/cakephp/lib/Cake/View/View.php, line 971 View::_render() - APP/Lib/cakephp/lib/Cake/View/View.php, line 933 View::_renderElement() - APP/Lib/cakephp/lib/Cake/View/View.php, line 1224 View::element() - APP/Lib/cakephp/lib/Cake/View/View.php, line 418 include - APP/View/Layouts/default.ctp, line 46 View::_evaluate() - APP/Lib/cakephp/lib/Cake/View/View.php, line 971 View::_render() - APP/Lib/cakephp/lib/Cake/View/View.php, line 933 View::renderLayout() - APP/Lib/cakephp/lib/Cake/View/View.php, line 546 View::render() - APP/Lib/cakephp/lib/Cake/View/View.php, line 481 Controller::render() - APP/Lib/cakephp/lib/Cake/Controller/Controller.php, line 963 ExceptionRenderer::_outputMessage() - APP/Lib/cakephp/lib/Cake/Error/ExceptionRenderer.php, line 292 ExceptionRenderer::error500() - APP/Lib/cakephp/lib/Cake/Error/ExceptionRenderer.php, line 260 ExceptionRenderer::render() - APP/Lib/cakephp/lib/Cake/Error/ExceptionRenderer.php, line 190 ErrorHandler::handleException() - APP/Lib/cakephp/lib/Cake/Error/ErrorHandler.php, line 127 [main] - [internal], line ??
2017-07-06 09:48:43 Notice: Notice (8): Undefined variable: me in [/var/www/MISP/app/View/Elements/global_menu.ctp, line 10] Trace: ErrorHandler::handleError() - APP/Lib/cakephp/lib/Cake/Error/ErrorHandler.php, line 230 include - APP/View/Elements/global_menu.ctp, line 10 View::_evaluate() - APP/Lib/cakephp/lib/Cake/View/View.php, line 971 View::_render() - APP/Lib/cakephp/lib/Cake/View/View.php, line 933 View::_renderElement() - APP/Lib/cakephp/lib/Cake/View/View.php, line 1224 View::element() - APP/Lib/cakephp/lib/Cake/View/View.php, line 418 include - APP/View/Layouts/default.ctp, line 46 View::_evaluate() - APP/Lib/cakephp/lib/Cake/View/View.php, line 971 View::_render() - APP/Lib/cakephp/lib/Cake/View/View.php, line 933 View::renderLayout() - APP/Lib/cakephp/lib/Cake/View/View.php, line 546 View::render() - APP/Lib/cakephp/lib/Cake/View/View.php, line 481 Controller::render() - APP/Lib/cakephp/lib/Cake/Controller/Controller.php, line 963 ExceptionRenderer::_outputMessage() - APP/Lib/cakephp/lib/Cake/Error/ExceptionRenderer.php, line 292 ExceptionRenderer::error500() - APP/Lib/cakephp/lib/Cake/Error/ExceptionRenderer.php, line 260 ExceptionRenderer::render() - APP/Lib/cakephp/lib/Cake/Error/ExceptionRenderer.php, line 190 ErrorHandler::handleException() - APP/Lib/cakephp/lib/Cake/Error/ErrorHandler.php, line 127 [main] - [internal], line ??
2017-07-06 09:48:43 Notice: Notice (8): Undefined variable: debugMode in [/var/www/MISP/app/View/Layouts/default.ctp, line 48] Trace: ErrorHandler::handleError() - APP/Lib/cakephp/lib/Cake/Error/ErrorHandler.php, line 230 include - APP/View/Layouts/default.ctp, line 48 View::_evaluate() - APP/Lib/cakephp/lib/Cake/View/View.php, line 971 View::_render() - APP/Lib/cakephp/lib/Cake/View/View.php, line 933 View::renderLayout() - APP/Lib/cakephp/lib/Cake/View/View.php, line 546 View::render() - APP/Lib/cakephp/lib/Cake/View/View.php, line 481 Controller::render() - APP/Lib/cakephp/lib/Cake/Controller/Controller.php, line 963 ExceptionRenderer::_outputMessage() - APP/Lib/cakephp/lib/Cake/Error/ExceptionRenderer.php, line 292 ExceptionRenderer::error500() - APP/Lib/cakephp/lib/Cake/Error/ExceptionRenderer.php, line 260 ExceptionRenderer::render() - APP/Lib/cakephp/lib/Cake/Error/ExceptionRenderer.php, line 190 ErrorHandler::handleException() - APP/Lib/cakephp/lib/Cake/Error/ErrorHandler.php, line 127 [main] - [internal], line ??
2017-07-06 09:48:43 Notice: Notice (8): Undefined variable: debugMode in [/var/www/MISP/app/View/Layouts/default.ctp, line 50] Trace: ErrorHandler::handleError() - APP/Lib/cakephp/lib/Cake/Error/ErrorHandler.php, line 230 include - APP/View/Layouts/default.ctp, line 50 View::_evaluate() - APP/Lib/cakephp/lib/Cake/View/View.php, line 971 View::_render() - APP/Lib/cakephp/lib/Cake/View/View.php, line 933 View::renderLayout() - APP/Lib/cakephp/lib/Cake/View/View.php, line 546 View::render() - APP/Lib/cakephp/lib/Cake/View/View.php, line 481 Controller::render() - APP/Lib/cakephp/lib/Cake/Controller/Controller.php, line 963 ExceptionRenderer::_outputMessage() - APP/Lib/cakephp/lib/Cake/Error/ExceptionRenderer.php, line 292 ExceptionRenderer::error500() - APP/Lib/cakephp/lib/Cake/Error/ExceptionRenderer.php, line 260 ExceptionRenderer::render() - APP/Lib/cakephp/lib/Cake/Error/ExceptionRenderer.php, line 190 ErrorHandler::handleException() - APP/Lib/cakephp/lib/Cake/Error/ErrorHandler.php, line 127 [main] - [internal], line ??
2017-07-06 09:48:43 Notice: Notice (8): Undefined variable: debugMode in [/var/www/MISP/app/View/Elements/footer.ctp, line 1] Trace: ErrorHandler::handleError() - APP/Lib/cakephp/lib/Cake/Error/ErrorHandler.php, line 230 include - APP/View/Elements/footer.ctp, line 1 View::_evaluate() - APP/Lib/cakephp/lib/Cake/View/View.php, line 971 View::_render() - APP/Lib/cakephp/lib/Cake/View/View.php, line 933 View::_renderElement() - APP/Lib/cakephp/lib/Cake/View/View.php, line 1224 View::element() - APP/Lib/cakephp/lib/Cake/View/View.php, line 418 include - APP/View/Layouts/default.ctp, line 81 View::_evaluate() - APP/Lib/cakephp/lib/Cake/View/View.php, line 971 View::_render() - APP/Lib/cakephp/lib/Cake/View/View.php, line 933 View::renderLayout() - APP/Lib/cakephp/lib/Cake/View/View.php, line 546 View::render() - APP/Lib/cakephp/lib/Cake/View/View.php, line 481 Controller::render() - APP/Lib/cakephp/lib/Cake/Controller/Controller.php, line 963 ExceptionRenderer::_outputMessage() - APP/Lib/cakephp/lib/Cake/Error/ExceptionRenderer.php, line 292 ExceptionRenderer::error500() - APP/Lib/cakephp/lib/Cake/Error/ExceptionRenderer.php, line 260 ExceptionRenderer::render() - APP/Lib/cakephp/lib/Cake/Error/ExceptionRenderer.php, line 190 ErrorHandler::handleException() - APP/Lib/cakephp/lib/Cake/Error/ErrorHandler.php, line 127 [main] - [internal], line ??
2017-07-06 09:48:43 Notice: Notice (8): Undefined variable: me in [/var/www/MISP/app/View/Layouts/default.ctp, line 87] Trace: ErrorHandler::handleError() - APP/Lib/cakephp/lib/Cake/Error/ErrorHandler.php, line 230 include - APP/View/Layouts/default.ctp, line 87 View::_evaluate() - APP/Lib/cakephp/lib/Cake/View/View.php, line 971 View::_render() - APP/Lib/cakephp/lib/Cake/View/View.php, line 933 View::renderLayout() - APP/Lib/cakephp/lib/Cake/View/View.php, line 546 View::render() - APP/Lib/cakephp/lib/Cake/View/View.php, line 481 Controller::render() - APP/Lib/cakephp/lib/Cake/Controller/Controller.php, line 963 ExceptionRenderer::_outputMessage() - APP/Lib/cakephp/lib/Cake/Error/ExceptionRenderer.php, line 292 ExceptionRenderer::error500() - APP/Lib/cakephp/lib/Cake/Error/ExceptionRenderer.php, line 260 ExceptionRenderer::render() - APP/Lib/cakephp/lib/Cake/Error/ExceptionRenderer.php, line 190 ErrorHandler::handleException() - APP/Lib/cakephp/lib/Cake/Error/ErrorHandler.php, line 127 [main] - [internal], line ??
2017-07-06 09:48:43 Notice: Notice (8): Undefined variable: debugMode in [/var/www/MISP/app/View/Layouts/default.ctp, line 102] Trace: ErrorHandler::handleError() - APP/Lib/cakephp/lib/Cake/Error/ErrorHandler.php, line 230 include - APP/View/Layouts/default.ctp, line 102 View::_evaluate() - APP/Lib/cakephp/lib/Cake/View/View.php, line 971 View::_render() - APP/Lib/cakephp/lib/Cake/View/View.php, line 933 View::renderLayout() - APP/Lib/cakephp/lib/Cake/View/View.php, line 546 View::render() - APP/Lib/cakephp/lib/Cake/View/View.php, line 481 Controller::render() - APP/Lib/cakephp/lib/Cake/Controller/Controller.php, line 963 ExceptionRenderer::_outputMessage() - APP/Lib/cakephp/lib/Cake/Error/ExceptionRenderer.php, line 292 ExceptionRenderer::error500() - APP/Lib/cakephp/lib/Cake/Error/ExceptionRenderer.php, line 260 ExceptionRenderer::render() - APP/Lib/cakephp/lib/Cake/Error/ExceptionRenderer.php, line 190 ErrorHandler::handleException() - APP/Lib/cakephp/lib/Cake/Error/ErrorHandler.php, line 127 [main] - [internal], line ??
more error.log 2017-07-06 09:48:43 Error: [MissingTableException] Table logs for model Log was not found in datasource default. Exception Attributes: array ( 'table' => 'logs', 'class' => 'Log', 'ds' => 'default', ) Request URL: / Stack Trace:
The previous post was just notices. But the logs table missing doesn't sound good.
Could you run the following?
mysql -u misp -p misp
Show tables;
mysql -u misp -p misp Enter password: Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A
Welcome to the MariaDB monitor. Commands end with ; or \g. Your MariaDB connection id is 8 Server version: 5.5.52-MariaDB MariaDB Server
Copyright (c) 2000, 2016, Oracle, MariaDB Corporation Ab and others.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
MariaDB [misp]> show tables; +----------------+ | Tables_in_misp | +----------------+ | admin_settings | | attribute_tags | | attributes | | bruteforces | | cake_sessions | +----------------+ 5 rows in set (0.00 sec)
Yeah, that looks like your table import failed. Could you redo the steps for the MYSQL.sql import? Something went REALLY wrong over there during installation.
mysql -u misp -p misp < INSTALL/MYSQL.sql Enter password: ERROR 1214 (HY000) at line 94: The used table type doesn't support FULLTEXT indexes
what version of MISP is this?
The latest on Git. I executed git clone https://github.com/MISP/MISP.git.
Is there a command to get that info? This is a new install.
In your MISP installation could you paste the contents of the following files?
/var/www/MISP/VERSION.json
/var/www/MISP/INSTALL/MYSQL.sql
more VERSION.json {"major":2, "minor":4, "hotfix":76}
more /var/www/MISP/INSTALL/MYSQL.sql
admin_settings
CREATE TABLE IF NOT EXISTS admin_settings
(
id
int(11) NOT NULL AUTO_INCREMENT,
setting
varchar(255) COLLATE utf8_bin NOT NULL,
value
text COLLATE utf8_bin NOT NULL,
PRIMARY KEY (id
)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
attributes
CREATE TABLE IF NOT EXISTS attributes
(
id
int(11) NOT NULL AUTO_INCREMENT,
event_id
int(11) NOT NULL,
category
varchar(255) COLLATE utf8_bin NOT NULL,
type
varchar(100) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
value1
text CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
value2
text CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
to_ids
tinyint(1) NOT NULL DEFAULT 1,
uuid
varchar(40) COLLATE utf8_bin NOT NULL,
timestamp
int(11) NOT NULL DEFAULT 0,
distribution
tinyint(4) NOT NULL DEFAULT 0,
sharing_group_id
int(11) NOT NULL,
comment
text COLLATE utf8_bin,
deleted
tinyint(1) NOT NULL DEFAULT 0,
disable_correlation
tinyint(1) NOT NULL DEFAULT 0,
PRIMARY KEY (id
),
INDEX event_id
(event_id
),
INDEX value1
(value1
(255)),
INDEX value2
(value2
(255)),
INDEX type
(type
),
INDEX category
(category
),
INDEX sharing_group_id
(sharing_group_id
),
UNIQUE INDEX uuid
(uuid
)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
attribute_tags
CREATE TABLE IF NOT EXISTS attribute_tags
(
id
int(11) NOT NULL AUTO_INCREMENT,
attribute_id
int(11) NOT NULL,
event_id
int(11) NOT NULL,
tag_id
int(11) NOT NULL,
PRIMARY KEY (id
),
INDEX attribute_id
(attribute_id
),
INDEX event_id
(event_id
),
INDEX tag_id
(tag_id
)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
bruteforces
CREATE TABLE IF NOT EXISTS bruteforces
(
ip
varchar(255) COLLATE utf8_bin NOT NULL,
username
varchar(255) COLLATE utf8_bin NOT NULL,
expire
datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
cake_sessions
CREATE TABLE IF NOT EXISTS cake_sessions
(
id
varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
data
text COLLATE utf8_bin NOT NULL,
expires
int(11) NOT NULL,
PRIMARY KEY (id
),
INDEX expires
(expires
)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
correlations
CREATE TABLE IF NOT EXISTS correlations
(
id
int(11) NOT NULL AUTO_INCREMENT,
value
text COLLATE utf8_bin NOT NULL,
1_event_id
int(11) NOT NULL,
1_attribute_id
int(11) NOT NULL,
event_id
int(11) NOT NULL,
attribute_id
int(11) NOT NULL,
org_id
int(11) NOT NULL,
distribution
tinyint(4) NOT NULL,
a_distribution
tinyint(4) NOT NULL,
sharing_group_id
int(11) NOT NULL,
a_sharing_group_id
int(11) NOT NULL,
date
date NOT NULL,
info
text COLLATE utf8_bin NOT NULL,
PRIMARY KEY (id
),
FULLTEXT INDEX value
(value
),
INDEX event_id
(event_id
),
INDEX 1_event_id
(1_event_id
),
INDEX attribute_id
(attribute_id
),
INDEX 1_attribute_id
(1_attribute_id
),
INDEX org_id
(org_id
),
INDEX sharing_group_id
(sharing_group_id
),
INDEX a_sharing_group_id
(a_sharing_group_id
)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
events
CREATE TABLE IF NOT EXISTS events
(
id
int(11) NOT NULL AUTO_INCREMENT,
org_id
int(11) NOT NULL,
date
date NOT NULL,
info
text COLLATE utf8_bin NOT NULL,
user_id
int(11) NOT NULL,
uuid
varchar(40) COLLATE utf8_bin NOT NULL,
published
tinyint(1) NOT NULL DEFAULT 0,
analysis
tinyint(4) NOT NULL,
attribute_count
int(11) unsigned DEFAULT 0,
orgc_id
int(11) NOT NULL,
timestamp
int(11) NOT NULL DEFAULT 0,
distribution
tinyint(4) NOT NULL DEFAULT 0,
sharing_group_id
int(11) NOT NULL,
proposal_email_lock
tinyint(1) NOT NULL DEFAULT 0,
locked
tinyint(1) NOT NULL DEFAULT 0,
threat_level_id
int(11) NOT NULL,
publish_timestamp
int(11) NOT NULL DEFAULT 0,
disable_correlation
tinyint(1) NOT NULL DEFAULT 0,
PRIMARY KEY (id
),
UNIQUE INDEX uuid
(uuid
),
FULLTEXT INDEX info
(info
(255)),
INDEX sharing_group_id
(sharing_group_id
),
INDEX org_id
(org_id
),
INDEX orgc_id
(orgc_id
)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
CREATE TABLE IF NOT EXISTS event_blacklists
(
id
int(11) NOT NULL AUTO_INCREMENT,
event_uuid
varchar(40) COLLATE utf8_bin NOT NULL,
created
datetime NOT NULL,
event_info
TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
comment
TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci,
event_orgc
VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
PRIMARY KEY (id
),
INDEX event_uuid
(event_uuid
),
INDEX event_orgc
(event_orgc
)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
event_blacklists
CREATE TABLE IF NOT EXISTS event_blacklists
(
id
int(11) NOT NULL AUTO_INCREMENT,
event_uuid
varchar(40) COLLATE utf8_bin NOT NULL,
created
datetime NOT NULL,
PRIMARY KEY (id
),
event_info
TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
comment
TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
event_orgc
VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
event_delegations
CREATE TABLE IF NOT EXISTS event_delegations
(
id
int(11) NOT NULL AUTO_INCREMENT,
org_id
int(11) NOT NULL,
requester_org_id
int(11) NOT NULL,
event_id
int(11) NOT NULL,
message
text,
distribution
tinyint(4) NOT NULL DEFAULT -1,
sharing_group_id
int(11),
PRIMARY KEY (id
),
INDEX org_id
(org_id
),
INDEX event_id
(event_id
)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
event_tags
CREATE TABLE IF NOT EXISTS event_tags
(
id
int(11) NOT NULL AUTO_INCREMENT,
event_id
int(11) NOT NULL,
tag_id
int(11) NOT NULL,
PRIMARY KEY (id
),
INDEX event_id
(event_id
),
INDEX tag_id
(tag_id
)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
favourite_tags
CREATE TABLE IF NOT EXISTS favourite_tags
(
id
int(11) NOT NULL AUTO_INCREMENT,
tag_id
int(11) NOT NULL,
user_id
int(11) NOT NULL,
PRIMARY KEY (id
),
INDEX user_id
(user_id
),
INDEX tag_id
(tag_id
)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
feeds
CREATE TABLE IF NOT EXISTS feeds
(
id
int(11) NOT NULL AUTO_INCREMENT,
name
varchar(255) COLLATE utf8_bin NOT NULL,
provider
varchar(255) COLLATE utf8_bin NOT NULL,
url
varchar(255) COLLATE utf8_bin NOT NULL,
rules
text COLLATE utf8_bin DEFAULT NULL,
enabled
tinyint(1) DEFAULT 0,
distribution
tinyint(4) NOT NULL DEFAULT 0,
sharing_group_id
int(11) NOT NULL DEFAULT 0,
tag_id
int(11) NOT NULL DEFAULT 0,
default
tinyint(1) DEFAULT 0,
source_format
varchar(255) COLLATE utf8_bin DEFAULT 'misp',
fixed_event
tinyint(1) NOT NULL DEFAULT 0,
delta_merge
tinyint(1) NOT NULL DEFAULT 0,
event_id
int(11) NOT NULL DEFAULT 0,
publish
tinyint(1) NOT NULL DEFAULT 0,
override_ids
tinyint(1) NOT NULL DEFAULT 0,
settings
text,
input_source
varchar(255) COLLATE utf8_bin NOT NULL DEFAULT "network",
delete_local_file
tinyint(1) DEFAULT 0,
lookup_visible
tinyint(1) DEFAULT 0,
PRIMARY KEY (id
),
INDEX input_source
(input_source
)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
galaxies
CREATE TABLE IF NOT EXISTS galaxies (
id
int(11) NOT NULL AUTO_INCREMENT,
uuid
varchar(255) COLLATE utf8_bin NOT NULL,
name
varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
type
varchar(255) COLLATE utf8_bin NOT NULL,
description
text COLLATE utf8_bin NOT NULL,
version
varchar(255) COLLATE utf8_bin NOT NULL,
PRIMARY KEY (id),
INDEX name
(name
),
INDEX uuid
(uuid
),
INDEX type
(type
)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
galaxy_clusters
CREATE TABLE IF NOT EXISTS galaxy_clusters (
id
int(11) NOT NULL AUTO_INCREMENT,
uuid
varchar(255) COLLATE utf8_bin NOT NULL,
type
varchar(255) COLLATE utf8_bin NOT NULL,
value
text COLLATE utf8_bin NOT NULL,
tag_name
varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
description
text COLLATE utf8_bin NOT NULL,
galaxy_id
int(11) NOT NULL,
source
varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
authors
text COLLATE utf8_bin NOT NULL,
PRIMARY KEY (id),
INDEX value
(value
(255)),
INDEX uuid
(uuid
),
INDEX tag_name
(tag_name
),
INDEX type
(type
)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
galaxy_elements
CREATE TABLE IF NOT EXISTS galaxy_elements (
id
int(11) NOT NULL AUTO_INCREMENT,
galaxy_cluster_id
int(11) NOT NULL,
key
varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
value
text COLLATE utf8_bin NOT NULL,
PRIMARY KEY (id
),
INDEX key
(key
),
INDEX value
(value
(255))
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
galaxy_reference
CREATE TABLE IF NOT EXISTS galaxy_reference (
id
int(11) NOT NULL AUTO_INCREMENT,
galaxy_cluster_id
int(11) NOT NULL,
referenced_galaxy_cluster_id
int(11) NOT NULL,
referenced_galaxy_cluster_uuid
varchar(255) COLLATE utf8_bin NOT NULL,
referenced_galaxy_cluster_type
text COLLATE utf8_bin NOT NULL,
referenced_galaxy_cluster_value
text COLLATE utf8_bin NOT NULL,
PRIMARY KEY (id),
INDEX galaxy_cluster_id
(galaxy_cluster_id
),
INDEX referenced_galaxy_cluster_id
(referenced_galaxy_cluster_id
),
INDEX referenced_galaxy_cluster_value
(referenced_galaxy_cluster_value
(255)),
INDEX referenced_galaxy_cluster_type
(referenced_galaxy_cluster_type
(255))
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
jobs
CREATE TABLE IF NOT EXISTS jobs
(
id
int(11) NOT NULL AUTO_INCREMENT,
worker
varchar(32) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
job_type
varchar(32) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
job_input
text CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
status
tinyint(4) NOT NULL DEFAULT 0,
retries
int(11) NOT NULL DEFAULT 0,
message
text CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
progress
int(11) NOT NULL DEFAULT 0,
org_id
int(11) NOT NULL DEFAULT 0,
process_id
varchar(32) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
date_created
datetime NOT NULL,
date_modified
datetime NOT NULL,
PRIMARY KEY (id
)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
logs
CREATE TABLE IF NOT EXISTS logs
(
id
int(11) NOT NULL AUTO_INCREMENT,
title
text CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
created
datetime NOT NULL,
model
varchar(20) COLLATE utf8_bin NOT NULL,
model_id
int(11) NOT NULL,
action
varchar(20) COLLATE utf8_bin NOT NULL,
user_id
int(11) NOT NULL,
change
text COLLATE utf8_bin,
email
varchar(255) COLLATE utf8_bin NOT NULL DEFAULT "",
org
varchar(255) COLLATE utf8_bin NOT NULL DEFAULT "",
description
text CHARACTER SET utf8 COLLATE utf8_bin,
PRIMARY KEY (id
)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
news
CREATE TABLE IF NOT EXISTS news
(
id
int(11) NOT NULL AUTO_INCREMENT,
message
text COLLATE utf8_bin NOT NULL,
title
text COLLATE utf8_bin NOT NULL,
user_id
int(11) NOT NULL,
date_created
int(11) unsigned NOT NULL,
PRIMARY KEY (id
)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
org_blacklists
CREATE TABLE IF NOT EXISTS org_blacklists
(
id
int(11) NOT NULL AUTO_INCREMENT,
org_uuid
varchar(40) COLLATE utf8_bin NOT NULL,
created
datetime NOT NULL,
PRIMARY KEY (id
),
org_name
varchar(255) COLLATE utf8_bin NOT NULL,
comment
TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
organisations
CREATE TABLE organisations
(
id
int(11) NOT NULL AUTO_INCREMENT,
name
varchar(255) COLLATE utf8_bin NOT NULL,
date_created
datetime NOT NULL,
date_modified
datetime NOT NULL,
description
text CHARACTER SET utf8 COLLATE utf8_unicode_ci,
type
varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci,
nationality
varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci,
sector
varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci,
created_by
int(11) NOT NULL DEFAULT 0,
uuid
varchar(40) COLLATE utf8_bin DEFAULT NULL,
contacts
text CHARACTER SET utf8 COLLATE utf8_unicode_ci,
local
tinyint(1) NOT NULL DEFAULT 0,
landingpage
text CHARACTER SET utf8 COLLATE utf8_unicode_ci,
PRIMARY KEY (id
),
INDEX uuid
(uuid
),
FULLTEXT INDEX name
(name
)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
CREATE TABLE IF NOT EXISTS org_blacklists
(
id
int(11) NOT NULL AUTO_INCREMENT,
org_uuid
varchar(40) COLLATE utf8_bin NOT NULL,
created
datetime NOT NULL,
org_name
varchar(255) COLLATE utf8_bin NOT NULL,
comment
TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci,
PRIMARY KEY (id
),
INDEX org_uuid
(org_uuid
),
INDEX org_name
(org_name
)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
posts
CREATE TABLE IF NOT EXISTS posts
(
id
int(11) NOT NULL AUTO_INCREMENT,
date_created
datetime NOT NULL,
date_modified
datetime NOT NULL,
user_id
int(11) NOT NULL,
contents
text CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
post_id
int(11) NOT NULL DEFAULT 0,
thread_id
int(11) NOT NULL DEFAULT 0,
PRIMARY KEY (id
),
INDEX post_id
(post_id
),
INDEX thread_id
(thread_id
)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
regexp
CREATE TABLE IF NOT EXISTS regexp
(
id
int(11) NOT NULL AUTO_INCREMENT,
regexp
varchar(255) COLLATE utf8_bin NOT NULL,
replacement
varchar(255) COLLATE utf8_bin NOT NULL,
type
varchar(100) COLLATE utf8_bin NOT NULL DEFAULT 'ALL',
PRIMARY KEY (id
)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
roles
CREATE TABLE IF NOT EXISTS roles
(
id
int(11) NOT NULL AUTO_INCREMENT,
name
varchar(100) COLLATE utf8_bin NOT NULL,
created
datetime DEFAULT NULL,
modified
datetime DEFAULT NULL,
perm_add
tinyint(1) DEFAULT NULL,
perm_modify
tinyint(1) DEFAULT NULL,
perm_modify_org
tinyint(1) DEFAULT NULL,
perm_publish
tinyint(1) DEFAULT NULL,
perm_delegate
tinyint(1) NOT NULL DEFAULT 0,
perm_sync
tinyint(1) DEFAULT NULL,
perm_admin
tinyint(1) DEFAULT NULL,
perm_audit
tinyint(1) DEFAULT NULL,
perm_full
tinyint(1) DEFAULT NULL,
perm_auth
tinyint(1) NOT NULL DEFAULT 0,
perm_site_admin
tinyint(1) NOT NULL DEFAULT 0,
perm_regexp_access
tinyint(1) NOT NULL DEFAULT 0,
perm_tagger
tinyint(1) NOT NULL DEFAULT 0,
perm_template
tinyint(1) NOT NULL DEFAULT 0,
perm_sharing_group
tinyint(1) NOT NULL DEFAULT 0,
perm_tag_editor
tinyint(1) NOT NULL DEFAULT 0,
perm_sighting
tinyint(1) NOT NULL DEFAULT 0,
default_role
tinyint(1) NOT NULL DEFAULT 0,
PRIMARY KEY (id
)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
servers
CREATE TABLE IF NOT EXISTS servers
(
id
int(11) NOT NULL AUTO_INCREMENT,
name
varchar(255) COLLATE utf8_bin NOT NULL,
url
varchar(255) COLLATE utf8_bin NOT NULL,
authkey
varchar(40) COLLATE utf8_bin NOT NULL,
org_id
int(11) NOT NULL,
push
tinyint(1) NOT NULL,
pull
tinyint(1) NOT NULL,
lastpulledid
int(11) DEFAULT NULL,
lastpushedid
int(11) DEFAULT NULL,
organization
varchar(10) COLLATE utf8_bin DEFAULT NULL,
remote_org_id
int(11) NOT NULL,
publish_without_email
tinyint(1) NOT NULL DEFAULT 0,
unpublish_event
tinyint(1) NOT NULL DEFAULT 0,
self_signed
tinyint(1) NOT NULL,
pull_rules
text COLLATE utf8_bin NOT NULL,
push_rules
text COLLATE utf8_bin NOT NULL,
cert_file
varchar(255) COLLATE utf8_bin DEFAULT NULL,
client_cert_file
varchar(255) COLLATE utf8_bin DEFAULT NULL,
internal
tinyint(1) NOT NULL DEFAULT 0,
PRIMARY KEY (id
),
INDEX org_id
(org_id
),
INDEX remote_org_id
(remote_org_id
)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
`)ributes
CREATE TABLE IF NOT EXISTS shadow_attributes
(
id
int(11) NOT NULL AUTO_INCREMENT,
old_id
int(11) DEFAULT 0,
event_id
int(11) NOT NULL,
type
varchar(100) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
category
varchar(255) COLLATE utf8_bin NOT NULL,
value1
text COLLATE utf8_bin,
to_ids
tinyint(1) NOT NULL DEFAULT 1,
uuid
varchar(40) COLLATE utf8_bin NOT NULL,
value2
text COLLATE utf8_bin,
org_id
int(11) NOT NULL,
email
varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
event_org_id
int(11) NOT NULL,
comment
text COLLATE utf8_bin NOT NULL,
event_uuid
varchar(40) COLLATE utf8_bin NOT NULL,
deleted
tinyint(1) NOT NULL DEFAULT 0,
timestamp
int(11) NOT NULL DEFAULT 0,
proposal_to_delete
BOOLEAN NOT NULL DEFAULT 0,
disable_correlation
tinyint(1) NOT NULL DEFAULT 0,
PRIMARY KEY (id
),
INDEX event_id
(event_id
),
INDEX event_uuid
(event_uuid
),
INDEX event_org_id
(event_org_id
),
INDEX uuid
(uuid
),
INDEX old_id
(old_id
),
INDEX value1
(value1
(255)),
INDEX value2
(value2
(255)),
INDEX type
(type
),
INDEX category
(category
)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
shadow_attribute_correlations
CREATE TABLE IF NOT EXISTS shadow_attribute_correlations
(
id
int(11) NOT NULL AUTO_INCREMENT,
org_id
int(11) NOT NULL,
value
text NOT NULL,
distribution
tinyint(4) NOT NULL,
a_distribution
tinyint(4) NOT NULL,
sharing_group_id
int(11),
a_sharing_group_id
int(11),
attribute_id
int(11) NOT NULL,
1_shadow_attribute_id
int(11) NOT NULL,
event_id
int(11) NOT NULL,
1_event_id
int(11) NOT NULL,
info
text COLLATE utf8_bin NOT NULL,
PRIMARY KEY (id
),
INDEX org_id
(org_id
),
INDEX attribute_id
(attribute_id
),
INDEX a_sharing_group_id
(a_sharing_group_id
),
INDEX event_id
(event_id
),
INDEX 1_event_id
(1_event_id
),
INDEX sharing_group_id
(sharing_group_id
),
INDEX 1_shadow_attribute_id
(1_shadow_attribute_id
)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
sharing_group_orgs
CREATE TABLE sharing_group_orgs
(
id
int(11) NOT NULL AUTO_INCREMENT,
sharing_group_id
int(11) NOT NULL,
org_id
int(11) NOT NULL,
extend
tinyint(1) NOT NULL DEFAULT 0,
PRIMARY KEY (id
),
INDEX org_id
(org_id
),
INDEX sharing_group_id
(sharing_group_id
)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
sharing_group_servers
CREATE TABLE sharing_group_servers
(
id
int(11) NOT NULL AUTO_INCREMENT,
sharing_group_id
int(11) NOT NULL,
server_id
int(11) NOT NULL,
all_orgs
tinyint(1) NOT NULL,
PRIMARY KEY (id
),
INDEX server_id
(server_id
),
INDEX sharing_group_id
(sharing_group_id
)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
sharing_groups
CREATE TABLE sharing_groups
(
id
int(11) NOT NULL AUTO_INCREMENT,
name
varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
releasability
text CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
description
text CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
uuid
varchar(40) COLLATE utf8_bin NOT NULL,
organisation_uuid
varchar(40) COLLATE utf8_bin NOT NULL,
org_id
int(11) NOT NULL,
sync_user_id
int(11) NOT NULL DEFAULT 0,
active
tinyint(1) NOT NULL,
created
datetime NOT NULL,
modified
datetime NOT NULL,
local
tinyint(1) NOT NULL,
roaming
tinyint(1) NOT NULL DEFAULT 0,
PRIMARY KEY (id
),
INDEX org_id
(org_id
),
INDEX sync_user_id
(sync_user_id
),
UNIQUE INDEX uuid
(uuid
),
INDEX organisation_uuid
(organisation_uuid
)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
CREATE TABLE IF NOT EXISTS sightings (
id
int(11) NOT NULL AUTO_INCREMENT,
attribute_id
int(11) NOT NULL,
event_id
int(11) NOT NULL,
org_id
int(11) NOT NULL,
date_sighting
bigint(20) NOT NULL,
uuid
varchar(255) COLLATE utf8_bin DEFAULT "",
source
varchar(255) COLLATE utf8_bin DEFAULT "",
type
int(11) DEFAULT 0,
PRIMARY KEY (id),
INDEX attribute_id
(attribute_id
),
INDEX event_id
(event_id
),
INDEX org_id
(org_id
),
INDEX uuid
(uuid
),
INDEX source
(source
),
INDEX type
(type
)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
tags
CREATE TABLE IF NOT EXISTS tags
(
id
int(11) NOT NULL AUTO_INCREMENT,
name
varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
colour
varchar(7) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
exportable
tinyint(1) NOT NULL,
org_id
tinyint(1) NOT NULL DEFAULT 0,
hide_tag
tinyint(1) NOT NULL DEFAULT 0,
PRIMARY KEY (id
),
FULLTEXT INDEX name
(name
),
INDEX org_id
(org_id
)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
tasks
CREATE TABLE IF NOT EXISTS tasks
(
id
int(11) NOT NULL AUTO_INCREMENT,
type
varchar(100) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
timer
int(11) NOT NULL,
scheduled_time
varchar(8) NOT NULL DEFAULT '6:00',
process_id
varchar(32) DEFAULT NULL,
description
varchar(255) NOT NULL,
next_execution_time
int(11) NOT NULL,
message
varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
PRIMARY KEY (id
)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
taxonomies
CREATE TABLE IF NOT EXISTS taxonomies
(
id
int(11) NOT NULL AUTO_INCREMENT,
namespace
varchar(255) COLLATE utf8_bin NOT NULL,
description
text COLLATE utf8_bin NOT NULL,
version
int(11) NOT NULL,
enabled
tinyint(1) NOT NULL DEFAULT 0,
PRIMARY KEY (id
)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
taxonomy_entries
CREATE TABLE IF NOT EXISTS taxonomy_entries
(
id
int(11) NOT NULL AUTO_INCREMENT,
taxonomy_predicate_id
int(11) NOT NULL,
value
text COLLATE utf8_bin NOT NULL,
expanded
text COLLATE utf8_bin,
colour
varchar(7) CHARACTER SET utf8 COLLATE utf8_bin,
PRIMARY KEY (id
),
INDEX taxonomy_predicate_id
(taxonomy_predicate_id
)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
taxonomy_predicates
CREATE TABLE IF NOT EXISTS taxonomy_predicates
(
id
int(11) NOT NULL AUTO_INCREMENT,
taxonomy_id
int(11) NOT NULL,
value
text COLLATE utf8_bin NOT NULL,
expanded
text COLLATE utf8_bin,
colour
varchar(7) CHARACTER SET utf8 COLLATE utf8_bin,
PRIMARY KEY (id
),
INDEX taxonomy_id
(taxonomy_id
)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
templates
CREATE TABLE IF NOT EXISTS templates
(
id
int(11) NOT NULL AUTO_INCREMENT,
name
varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
description
varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
org
varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
share
tinyint(1) NOT NULL,
PRIMARY KEY (id
)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
template_elements
CREATE TABLE IF NOT EXISTS template_elements
(
id
int(11) NOT NULL AUTO_INCREMENT,
template_id
int(11) NOT NULL,
position
int(11) NOT NULL,
element_definition
varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
PRIMARY KEY (id
)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
template_element_attributes
CREATE TABLE IF NOT EXISTS template_element_attributes
(
id
int(11) NOT NULL AUTO_INCREMENT,
template_element_id
int(11) NOT NULL,
name
varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
description
text CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
to_ids
tinyint(1) NOT NULL DEFAULT 1,
category
varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
complex
tinyint(1) NOT NULL,
type
varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
mandatory
tinyint(1) NOT NULL,
batch
tinyint(1) NOT NULL,
PRIMARY KEY (id
)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
template_element_files
CREATE TABLE IF NOT EXISTS template_element_files
(
id
int(11) NOT NULL AUTO_INCREMENT,
template_element_id
int(11) NOT NULL,
name
varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
description
text CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
category
varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
malware
tinyint(1) NOT NULL,
mandatory
tinyint(1) NOT NULL,
batch
tinyint(1) NOT NULL,
PRIMARY KEY (id
)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
template_element_texts
CREATE TABLE IF NOT EXISTS template_element_texts
(
id
int(11) NOT NULL AUTO_INCREMENT,
name
varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
template_element_id
int(11) NOT NULL,
text
text CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
PRIMARY KEY (id
)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
template_tags
CREATE TABLE IF NOT EXISTS template_tags
(
id
int(11) NOT NULL AUTO_INCREMENT,
template_id
int(11) NOT NULL,
tag_id
int(11) NOT NULL,
PRIMARY KEY (id
)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
threads
CREATE TABLE IF NOT EXISTS threads
(
id
int(11) NOT NULL AUTO_INCREMENT,
date_created
datetime NOT NULL,
date_modified
datetime NOT NULL,
distribution
tinyint(4) NOT NULL,
user_id
int(11) NOT NULL,
post_count
int(11) NOT NULL,
event_id
int(11) NOT NULL,
title
varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
org_id
int(11) NOT NULL,
sharing_group_id
int(11) NOT NULL,
PRIMARY KEY (id
),
INDEX user_id
(user_id
),
INDEX event_id
(event_id
),
INDEX org_id
(org_id
),
INDEX sharing_group_id
(sharing_group_id
)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
threat_levels
CREATE TABLE IF NOT EXISTS threat_levels
(
id
int(11) NOT NULL AUTO_INCREMENT,
name
varchar(50) NOT NULL,
description
varchar(255) DEFAULT NULL,
form_description
varchar(255) NOT NULL,
PRIMARY KEY (id
)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
users
CREATE TABLE IF NOT EXISTS users
(
id
int(11) NOT NULL AUTO_INCREMENT,
password
varchar(40) COLLATE utf8_bin NOT NULL,
org_id
int(11) NOT NULL,
server_id
int(11) NOT NULL DEFAULT 0,
email
varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
autoalert
tinyint(1) NOT NULL DEFAULT 0,
authkey
varchar(40) COLLATE utf8_bin DEFAULT NULL,
invited_by
int(11) NOT NULL DEFAULT 0,
gpgkey
longtext COLLATE utf8_bin,
certif_public
longtext COLLATE utf8_bin,
nids_sid
int(15) NOT NULL DEFAULT 0,
termsaccepted
tinyint(1) NOT NULL DEFAULT 0,
newsread
int(11) unsigned DEFAULT 0,
role_id
int(11) NOT NULL DEFAULT 0,
change_pw
tinyint(4) NOT NULL DEFAULT 0,
contactalert
tinyint(1) NOT NULL DEFAULT 0,
disabled
BOOLEAN NOT NULL DEFAULT 0,
expiration
datetime DEFAULT NULL,
current_login
int(11) DEFAULT 0,
last_login
int(11) DEFAULT 0,
force_logout
tinyint(1) NOT NULL DEFAULT 0,
PRIMARY KEY (id
),
INDEX email
(email
),
INDEX org_id
(org_id
),
INDEX server_id
(server_id
)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
warninglists
CREATE TABLE IF NOT EXISTS warninglists
(
id
int(11) NOT NULL AUTO_INCREMENT,
name
varchar(255) COLLATE utf8_bin NOT NULL,
type
varchar(255) COLLATE utf8_bin NOT NULL DEFAULT 'string',
description
text COLLATE utf8_bin NOT NULL,
version
int(11) NOT NULL DEFAULT '1',
enabled
tinyint(1) NOT NULL DEFAULT 0,
warninglist_entry_count
int(11) unsigned DEFAULT NULL,
PRIMARY KEY (id
)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
warninglist_entries
CREATE TABLE IF NOT EXISTS warninglist_entries
(
id
int(11) NOT NULL AUTO_INCREMENT,
value
text CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
warninglist_id
int(11) NOT NULL,
PRIMARY KEY (id
),
INDEX warninglist_id
(warninglist_id
)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
warninglist_types
CREATE TABLE IF NOT EXISTS warninglist_types
(
id
int(11) NOT NULL AUTO_INCREMENT,
type
varchar(255) COLLATE utf8_bin NOT NULL,
warninglist_id
int(11) NOT NULL,
PRIMARY KEY (id
)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
whitelist
CREATE TABLE IF NOT EXISTS whitelist
(
id
int(11) NOT NULL AUTO_INCREMENT,
name
text CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
PRIMARY KEY (id
)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
INSERT INTO admin_settings
(id
, setting
, value
) VALUES
(1, 'db_version', '2.4.66');
INSERT INTO feeds
(id
, provider
, name
, url
, distribution
, default
, enabled
) VALUES
(1, 'CIRCL', 'CIRCL OSINT Feed', 'https://www.circl.lu/doc/misp/feed-osint', 3, 1, 0),
(2, 'Botvrij.eu', 'The Botvrij.eu Data', 'http://www.botvrij.eu/data/feed-osint', 3, 1, 0);
INSERT INTO regexp
(id
, regexp
, replacement
, type
) VALUES
(1, '/.:.ProgramData./i', '%ALLUSERSPROFILE%\\', 'ALL'),
(2, '/.:.Documents and Settings.All Users./i', '%ALLUSERSPROFILE%\\', 'ALL'),
(3, '/.:.Program Files.Common Files./i', '%COMMONPROGRAMFILES%\\', 'ALL'),
(4, '/.:.Program Files (x86).Common Files./i', '%COMMONPROGRAMFILES(x86)%\\', 'ALL'),
(5, '/.:.Users\\(.?)\\AppData.Local.Temp./i', '%TEMP%\\', 'ALL'),
(6, '/.:.ProgramData./i', '%PROGRAMDATA%\\', 'ALL'),
(7, '/.:.Program Files./i', '%PROGRAMFILES%\\', 'ALL'),
(8, '/.:.Program Files (x86)./i', '%PROGRAMFILES(X86)%\\', 'ALL'),
(9, '/.:.Users.Public./i', '%PUBLIC%\\', 'ALL'),
(10, '/.:.Documents and Settings\\(.?)\\Local Settings.Temp./i', '%TEMP%\\', 'ALL'),
(11, '/.:.Users\\(.?)\\AppData.Local.Temp./i', '%TEMP%\\', 'ALL'),
(12, '/.:.Users\\(.?)\\AppData.Local./i', '%LOCALAPPDATA%\\', 'ALL'),
(13, '/.:.Users\\(.?)\\AppData.Roaming./i', '%APPDATA%\\', 'ALL'),
(14, '/.:.Users\\(.?)\\Application Data./i', '%APPDATA%\\', 'ALL'),
(15, '/.:.Windows\\(.?)\\Application Data./i', '%APPDATA%\\', 'ALL'),
(16, '/.:.Users\\(.?)\\/i', '%USERPROFILE%\\', 'ALL'),
(17, '/.:.DOCUME~1.\\(.?)\\/i', '%USERPROFILE%\\', 'ALL'),
(18, '/.:.Documents and Settings\\(.?)\\/i', '%USERPROFILE%\\', 'ALL'),
(19, '/.:.Windows./i', '%WINDIR%\\', 'ALL'),
(20, '/.:.Windows./i', '%WINDIR%\\', 'ALL'),
(21, '/.REGISTRY.USER.S(-[0-9]{1}){2}-[0-9]{2}(-[0-9]{9}){1}(-[0-9]{10}){1}-[0-9]{9}-[0-9]{4}/i', 'HKCU', 'ALL'),
(22, '/.REGISTRY.USER.S(-[0-9]{1}){2}-[0-9]{2}(-[0-9]{10}){2}-[0-9]{9}-[0-9]{4}/i', 'HKCU', 'ALL'),
(23, '/.REGISTRY.USER.S(-[0-9]{1}){2}-[0-9]{2}(-[0-9]{10}){3}-[0-9]{4}/i', 'HKCU', 'ALL'),
(24, '/.REGISTRY.MACHINE./i', 'HKLM\\', 'ALL'),
(25, '/.Registry.Machine./i', 'HKLM\\', 'ALL'),
(26, '/%USERPROFILE%.Application Data.Microsoft.UProof/i', '', 'ALL'),
(27, '/%USERPROFILE%.Local Settings.History/i', '', 'ALL'),
(28, '/%APPDATA%.Microsoft.UProof/i ', '', 'ALL'),
(29, '/%LOCALAPPDATA%.Microsoft.Windows.Temporary Internet Files/i', '', 'ALL');
INSERT INTO roles
(id
, name
, created
, modified
, perm_add
, perm_modify
, perm_modify_org
, perm_publish
, perm_sync
, perm_admin
, perm_audit
, perm_full
, perm_auth
, perm_regexp_access
, perm_tagger
, perm_site_admin
, perm_template
, perm_sharing_group
, perm_tag_editor
, perm_delegate
, perm_sighting
, default_role
)
VALUES (1, 'admin', NOW(), NOW(), 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 0);
INSERT INTO roles
(id
, name
, created
, modified
, perm_add
, perm_modify
, perm_modify_org
, perm_publish
, perm_sync
, perm_admin
, perm_audit
, perm_full
, perm_auth
, perm_regexp_access
, perm_tagger
, perm_site_admin
, perm_template
, perm_sharing_group
, perm_tag_editor
, perm_delegate
, perm_sighting
, default_role
)
VALUES (2, 'Org Admin', NOW(), NOW(), 1, 1, 1, 1, 1, 1, 1, 0, 1, 0, 1, 0, 1, 1, 1, 1, 1, 0);
INSERT INTO roles
(id
, name
, created
, modified
, perm_add
, perm_modify
, perm_modify_org
, perm_publish
, perm_sync
, perm_admin
, perm_audit
, perm_full
, perm_auth
, perm_regexp_access
, perm_tagger
, perm_site_admin
, perm_template
, perm_sharing_group
, perm_tag_editor
, perm_delegate
, perm_sighting
, default_role
)
VALUES (3, 'User', NOW(), NOW(), 1, 1, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 1, 1);
INSERT INTO roles
(id
, name
, created
, modified
, perm_add
, perm_modify
, perm_modify_org
, perm_publish
, perm_sync
, perm_admin
, perm_audit
, perm_full
, perm_auth
, perm_regexp_access
, perm_tagger
, perm_site_admin
, perm_template
, perm_sharing_group
, perm_tag_editor
, perm_delegate
, perm_sighting
, default_role
)
VALUES (4, 'Publisher', NOW(), NOW(), 1, 1, 1, 1, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 1, 1, 0);
INSERT INTO roles
(id
, name
, created
, modified
, perm_add
, perm_modify
, perm_modify_org
, perm_publish
, perm_sync
, perm_admin
, perm_audit
, perm_full
, perm_auth
, perm_regexp_access
, perm_tagger
, perm_site_admin
, perm_template
, perm_sharing_group
, perm_tag_editor
, perm_delegate
, perm_sighting
, default_role
)
VALUES (5, 'Sync user', NOW(), NOW(), 1, 1, 1, 1, 1, 0, 0, 0, 1, 0, 0, 0, 0, 1, 0, 1, 1, 0);
INSERT INTO roles
(id
, name
, created
, modified
, perm_add
, perm_modify
, perm_modify_org
, perm_publish
, perm_sync
, perm_admin
, perm_audit
, perm_full
, perm_auth
, perm_regexp_access
, perm_tagger
, perm_site_admin
, perm_template
, perm_sharing_group
, perm_tag_editor
, perm_delegate
, perm_sighting
, default_role
)
VALUES (6, 'Read Only', NOW(), NOW(), 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0);
INSERT INTO threat_levels
(id
, name
, description
, form_description
)
VALUES
(1, 'High', 'high means sophisticated APT malware or 0-day attack', 'Sophisticated APT malware or 0-day attack'),
(2, 'Medium', 'medium means APT malware', 'APT malware'),
(3, 'Low', 'low means mass-malware', 'Mass-malware'),
(4, 'Undefined', 'undefined no risk', 'No risk');
INSERT INTO templates
(id
, name
, description
, org
, share
) VALUES
(1, 'Phishing E-mail', 'Create a MISP event about a Phishing E-mail.', 'MISP', 1),
(2, 'Phishing E-mail with malicious attachment', 'A MISP event based on Spear-phishing containing a malicious attachment. This event can include anything from the description of the e-mail itself, the malicious attachment and its description as well as the results of the analysis done on the malicious f', 'MISP', 1),
(3, 'Malware Report', 'This is a template for a generic malware report. ', 'MISP', 1),
(4, 'Indicator List', 'A simple template for indicator lists.', 'MISP', 1);
INSERT INTO template_elements
(id
, template_id
, position
, element_definition
) VALUES
(1, 1, 2, 'attribute'),
(2, 1, 3, 'attribute'),
(3, 1, 1, 'text'),
(4, 1, 4, 'attribute'),
(5, 1, 5, 'text'),
(6, 1, 6, 'attribute'),
(7, 1, 7, 'attribute'),
(8, 1, 8, 'attribute'),
(11, 2, 1, 'text'),
(12, 2, 2, 'attribute'),
(13, 2, 3, 'text'),
(14, 2, 4, 'file'),
(15, 2, 5, 'attribute'),
(16, 2, 10, 'text'),
(17, 2, 6, 'attribute'),
(18, 2, 7, 'attribute'),
(19, 2, 8, 'attribute'),
(20, 2, 9, 'attribute'),
(21, 2, 11, 'file'),
(22, 2, 12, 'attribute'),
(23, 2, 13, 'attribute'),
(24, 2, 14, 'attribute'),
(25, 2, 15, 'attribute'),
(26, 2, 16, 'attribute'),
(27, 2, 17, 'attribute'),
(28, 2, 18, 'attribute'),
(29, 3, 1, 'text'),
(30, 3, 2, 'file'),
(31, 3, 4, 'text'),
(32, 3, 9, 'text'),
(33, 3, 11, 'text'),
(34, 3, 10, 'attribute'),
(35, 3, 12, 'attribute'),
(36, 3, 3, 'attribute'),
(37, 3, 5, 'attribute'),
(38, 3, 6, 'attribute'),
(39, 3, 7, 'attribute'),
(40, 3, 8, 'file'),
(41, 3, 13, 'text'),
(42, 3, 14, 'attribute'),
(43, 3, 15, 'attribute'),
(44, 3, 16, 'attribute'),
(45, 4, 1, 'text'),
(46, 4, 2, 'attribute'),
(47, 4, 3, 'attribute');
INSERT INTO template_element_attributes
(id
, template_element_id
, name
, description
, to_ids
, category
, complex
, type
, mandatory
, batch
) VALUES
(1, 1, 'From address', 'The source address from which the e-mail was sent.', 1, 'Payload delivery', 0, 'email-src', 1, 1),
(2, 2, 'Malicious url', 'The malicious url in the e-mail body.', 1, 'Payload delivery', 0, 'url', 1, 1),
(3, 4, 'E-mail subject', 'The subject line of the e-mail.', 0, 'Payload delivery', 0, 'email-subject', 1, 0),
(4, 6, 'Spoofed source address', 'If an e-mail address was spoofed, specify which.', 1, 'Payload delivery', 0, 'email-src', 0, 0),
(5, 7, 'Source IP', 'The source IP from which the e-mail was sent', 1, 'Payload delivery', 0, 'ip-src', 0, 1),
(6, 8, 'X-mailer header', 'It could be useful to capture which application and which version thereof was used to send the message, as described by the X-mailer header.', 1, 'Payload delivery', 0, 'text', 0, 1),
(7, 12, 'From address', 'The source address from which the e-mail was sent', 1, 'Payload delivery', 0, 'email-src', 1, 1),
(8, 15, 'Spoofed From Address', 'The spoofed source address from which the e-mail appears to be sent.', 1, 'Payload delivery', 0, 'email-src', 0, 1),
(9, 17, 'E-mail Source IP', 'The IP address from which the e-mail was sent.', 1, 'Payload delivery', 0, 'ip-src', 0, 1),
(10, 18, 'X-mailer header', 'It could be useful to capture which application and which version thereof was used to send the message, as described by the X-mailer header.', 1, 'Payload delivery', 0, 'text', 0, 0),
(11, 19, 'Malicious URL in the e-mail', 'If there was a malicious URL (or several), please specify it here', 1, 'Payload delivery', 0, 'ip-dst', 0, 1),
(12, 20, 'Exploited vulnerablity', 'The vulnerabilities exploited during the payload delivery.', 0, 'Payload delivery', 0, 'vulnerability', 0, 1),
(13, 22, 'C2 information', 'Command and Control information detected during the analysis.', 1, 'Network activity', 1, 'CnC', 0, 1),
(14, 23, 'Artifacts dropped (File)', 'Any information about the files dropped during the analysis', 1, 'Artifacts dropped', 1, 'File', 0, 1),
(15, 24, 'Artifacts dropped (Registry key)', 'Any registry keys touched during the analysis', 1, 'Artifacts dropped', 0, 'regkey', 0, 1),
(16, 25, 'Artifacts dropped (Registry key + value)', 'Any registry keys created or altered together with the value.', 1, 'Artifacts dropped', 0, 'regkey|value', 0, 1),
(17, 26, 'Persistance mechanism (filename)', 'Filenames (or filenames with filepaths) used as a persistence mechanism', 1, 'Persistence mechanism', 0, 'regkey|value', 0, 1),
(18, 27, 'Persistence mechanism (Registry key)', 'Any registry keys touched as part of the persistence mechanism during the analysis ', 1, 'Persistence mechanism', 0, 'regkey', 0, 1),
(19, 28, 'Persistence mechanism (Registry key + value)', 'Any registry keys created or modified together with their values used by the persistence mechanism', 1, 'Persistence mechanism', 0, 'regkey|value', 0, 1),
(20, 34, 'C2 Information', 'You can drop any urls, domains, hostnames or IP addresses that were detected as the Command and Control during the analysis here. ', 1, 'Network activity', 1, 'CnC', 0, 1),
(21, 35, 'Other Network Activity', 'Drop any applicable information about other network activity here. The attributes created here will NOT be marked for IDS exports.', 0, 'Network activity', 1, 'CnC', 0, 1),
(22, 36, 'Vulnerability', 'The vulnerability or vulnerabilities that the sample exploits', 0, 'Payload delivery', 0, 'vulnerability', 0, 1),
(23, 37, 'Artifacts Dropped (File)', 'Insert any data you have on dropped files here.', 1, 'Artifacts dropped', 1, 'File', 0, 1),
(24, 38, 'Artifacts dropped (Registry key)', 'Any registry keys touched during the analysis', 1, 'Artifacts dropped', 0, 'regkey', 0, 1),
(25, 39, 'Artifacts dropped (Registry key + value)', 'Any registry keys created or altered together with the value.', 1, 'Artifacts dropped', 0, 'regkey|value', 0, 1),
(26, 42, 'Persistence mechanism (filename)', 'Insert any filenames used by the persistence mechanism.', 1, 'Persistence mechanism', 0, 'filename', 0, 1),
(27, 43, 'Persistence Mechanism (Registry key)', 'Paste any registry keys that were created or modified as part of the persistence mechanism', 1, 'Persistence mechanism', 0, 'regkey', 0, 1),
(28, 44, 'Persistence Mechanism (Registry key and value)', 'Paste any registry keys together with the values contained within created or modified by the persistence mechanism', 1, 'Persistence mechanism', 0, 'regkey|value', 0, 1),
(29, 46, 'Network Indicators', 'Paste any combination of IP addresses, hostnames, domains or URL', 1, 'Network activity', 1, 'CnC', 0, 1),
(30, 47, 'File Indicators', 'Paste any file hashes that you have (MD5, SHA1, SHA256) or filenames below. You can also add filename and hash pairs by using the following syntax for each applicable column: filename|hash ', 1, 'Payload installation', 1, 'File', 0, 1);
INSERT INTO template_element_files
(id
, template_element_id
, name
, description
, category
, malware
, mandatory
, batch
) VALUES
(1, 14, 'Malicious Attachment', 'The file (or files) that was (were) attached to the e-mail itself.', 'Payload delivery', 1, 0, 1),
(2, 21, 'Payload installation', 'Payload installation detected during the analysis', 'Payload installation', 1, 0, 1),
(3, 30, 'Malware sample', 'The sample that the report is based on', 'Payload delivery', 1, 0, 0),
(4, 40, 'Artifacts dropped (Sample)', 'Upload any files that were dropped during the analysis.', 'Artifacts dropped', 1, 0, 1);
INSERT INTO template_element_texts
(id
, name
, template_element_id
, text
) VALUES
(1, 'Required fields', 3, 'The fields below are mandatory.'),
(2, 'Optional information', 5, 'All of the fields below are optional, please fill out anything that''s applicable.'),
(4, 'Required Fields', 11, 'The following fields are mandatory'),
(5, 'Optional information about the payload delivery', 13, 'All of the fields below are optional, please fill out anything that''s applicable. This section describes the payload delivery, including the e-mail itself, the attached file, the vulnerability it is exploiting and any malicious urls in the e-mail.'),
(6, 'Optional information obtained from analysing the malicious file', 16, 'Information about the analysis of the malware (if applicable). This can include C2 information, artifacts dropped during the analysis, persistance mechanism, etc.'),
(7, 'Malware Sample', 29, 'If you can, please upload the sample that the report revolves around.'),
(8, 'Dropped Artifacts', 31, 'Describe any dropped artifacts that you have encountered during your analysis'),
(9, 'C2 Information', 32, 'The following field deals with Command and Control information obtained during the analysis. All fields are optional.'),
(10, 'Other Network Activity', 33, 'If any other Network activity (such as an internet connection test) was detected during the analysis, please specify it using the following fields'),
(11, 'Persistence mechanism', 41, 'The following fields allow you to describe the persistence mechanism used by the malware'),
(12, 'Indicators', 45, 'Just paste your list of indicators based on type into the appropriate field. All of the fields are optional, so inputting a list of IP addresses into the Network indicator field for example is sufficient to complete this template.');
INSERT INTO org_blacklists
(org_uuid
, created
, org_name
, comment
) VALUES
('58d38339-7b24-4386-b4b4-4c0f950d210f', NOW(), 'Setec Astrononomy', 'default example'),
('58d38326-eda8-443a-9fa8-4e12950d210f', NOW(), 'Acme Finance', 'default example');
Indeed, could you get the latest commit? Simply
git checkout 2.4
git pull origin 2.4
The latest commit doesn't have fulltext indeces!
10-4. Rerun the sql import?
yup!
Good news is the tables are all there; show tables; +-------------------------------+ | Tables_in_misp | +-------------------------------+ | admin_settings | | attribute_tags | | attributes | | bruteforces | | cake_sessions | | correlations | | event_blacklists | | event_delegations | | event_tags | | events | | favourite_tags | | feeds | | galaxies | | galaxy_clusters | | galaxy_elements | | galaxy_reference | | jobs | | logs | | news | | org_blacklists | | organisations | | posts | | regexp | | roles | | servers | | shadow_attribute_correlations | | shadow_attributes | | sharing_group_orgs | | sharing_group_servers | | sharing_groups | | sightings | | tags | | tasks | | taxonomies | | taxonomy_entries | | taxonomy_predicates | | template_element_attributes | | template_element_files | | template_element_texts | | template_elements | | template_tags | | templates | | threads | | threat_levels | | users | | warninglist_entries | | warninglist_types | | warninglists | | whitelist | +-------------------------------+
Bad news is I am getting perms errors now sudo su -s /bin/bash apache -c 'scl enable rh-php56 /var/www/MISP/app/Console/worker/start.sh' /var/tmp/sclov0oHd: line 8: /var/www/MISP/app/Console/worker/start.sh: Permission denied
looks like perms on the webroot were reset. Do I need to do anything other than reset to permissions?
nope, you should be good to go.
Same thing. Below is the dbug log. I will post error seperately more debug.log 2017-07-06 10:40:56 Notice: Notice (8): Undefined variable: debugMode in [/var/www/MISP/app/View/Layouts/default.ctp, line 11] Trace: ErrorHandler::handleError() - APP/Lib/cakephp/lib/Cake/Error/ErrorHandler.php, line 230 include - APP/View/Layouts/default.ctp, line 11 View::_evaluate() - APP/Lib/cakephp/lib/Cake/View/View.php, line 971 View::_render() - APP/Lib/cakephp/lib/Cake/View/View.php, line 933 View::renderLayout() - APP/Lib/cakephp/lib/Cake/View/View.php, line 546 View::render() - APP/Lib/cakephp/lib/Cake/View/View.php, line 481 Controller::render() - APP/Lib/cakephp/lib/Cake/Controller/Controller.php, line 963 ExceptionRenderer::_outputMessage() - APP/Lib/cakephp/lib/Cake/Error/ExceptionRenderer.php, line 292 ExceptionRenderer::error500() - APP/Lib/cakephp/lib/Cake/Error/ExceptionRenderer.php, line 260 ExceptionRenderer::render() - APP/Lib/cakephp/lib/Cake/Error/ExceptionRenderer.php, line 190 ErrorHandler::handleException() - APP/Lib/cakephp/lib/Cake/Error/ErrorHandler.php, line 127 [main] - [internal], line ??
2017-07-06 10:40:56 Notice: Notice (8): Undefined variable: me in [/var/www/MISP/app/View/Layouts/default.ctp, line 21] Trace: ErrorHandler::handleError() - APP/Lib/cakephp/lib/Cake/Error/ErrorHandler.php, line 230 include - APP/View/Layouts/default.ctp, line 21 View::_evaluate() - APP/Lib/cakephp/lib/Cake/View/View.php, line 971 View::_render() - APP/Lib/cakephp/lib/Cake/View/View.php, line 933 View::renderLayout() - APP/Lib/cakephp/lib/Cake/View/View.php, line 546 View::render() - APP/Lib/cakephp/lib/Cake/View/View.php, line 481 Controller::render() - APP/Lib/cakephp/lib/Cake/Controller/Controller.php, line 963 ExceptionRenderer::_outputMessage() - APP/Lib/cakephp/lib/Cake/Error/ExceptionRenderer.php, line 292 ExceptionRenderer::error500() - APP/Lib/cakephp/lib/Cake/Error/ExceptionRenderer.php, line 260 ExceptionRenderer::render() - APP/Lib/cakephp/lib/Cake/Error/ExceptionRenderer.php, line 190 ErrorHandler::handleException() - APP/Lib/cakephp/lib/Cake/Error/ErrorHandler.php, line 127 [main] - [internal], line ??
2017-07-06 10:40:56 Notice: Notice (8): Undefined variable: debugMode in [/var/www/MISP/app/View/Elements/global_menu.ctp, line 1] Trace: ErrorHandler::handleError() - APP/Lib/cakephp/lib/Cake/Error/ErrorHandler.php, line 230 include - APP/View/Elements/global_menu.ctp, line 1 View::_evaluate() - APP/Lib/cakephp/lib/Cake/View/View.php, line 971 View::_render() - APP/Lib/cakephp/lib/Cake/View/View.php, line 933 View::_renderElement() - APP/Lib/cakephp/lib/Cake/View/View.php, line 1224 View::element() - APP/Lib/cakephp/lib/Cake/View/View.php, line 418 include - APP/View/Layouts/default.ctp, line 46 View::_evaluate() - APP/Lib/cakephp/lib/Cake/View/View.php, line 971 View::_render() - APP/Lib/cakephp/lib/Cake/View/View.php, line 933 View::renderLayout() - APP/Lib/cakephp/lib/Cake/View/View.php, line 546 View::render() - APP/Lib/cakephp/lib/Cake/View/View.php, line 481 Controller::render() - APP/Lib/cakephp/lib/Cake/Controller/Controller.php, line 963 ExceptionRenderer::_outputMessage() - APP/Lib/cakephp/lib/Cake/Error/ExceptionRenderer.php, line 292 ExceptionRenderer::error500() - APP/Lib/cakephp/lib/Cake/Error/ExceptionRenderer.php, line 260 ExceptionRenderer::render() - APP/Lib/cakephp/lib/Cake/Error/ExceptionRenderer.php, line 190 ErrorHandler::handleException() - APP/Lib/cakephp/lib/Cake/Error/ErrorHandler.php, line 127 [main] - [internal], line ??
2017-07-06 10:40:56 Notice: Notice (8): Undefined variable: me in [/var/www/MISP/app/View/Elements/global_menu.ctp, line 10] Trace: ErrorHandler::handleError() - APP/Lib/cakephp/lib/Cake/Error/ErrorHandler.php, line 230 include - APP/View/Elements/global_menu.ctp, line 10 View::_evaluate() - APP/Lib/cakephp/lib/Cake/View/View.php, line 971 View::_render() - APP/Lib/cakephp/lib/Cake/View/View.php, line 933 View::_renderElement() - APP/Lib/cakephp/lib/Cake/View/View.php, line 1224 View::element() - APP/Lib/cakephp/lib/Cake/View/View.php, line 418 include - APP/View/Layouts/default.ctp, line 46 View::_evaluate() - APP/Lib/cakephp/lib/Cake/View/View.php, line 971 View::_render() - APP/Lib/cakephp/lib/Cake/View/View.php, line 933 View::renderLayout() - APP/Lib/cakephp/lib/Cake/View/View.php, line 546 View::render() - APP/Lib/cakephp/lib/Cake/View/View.php, line 481 Controller::render() - APP/Lib/cakephp/lib/Cake/Controller/Controller.php, line 963 ExceptionRenderer::_outputMessage() - APP/Lib/cakephp/lib/Cake/Error/ExceptionRenderer.php, line 292 ExceptionRenderer::error500() - APP/Lib/cakephp/lib/Cake/Error/ExceptionRenderer.php, line 260 ExceptionRenderer::render() - APP/Lib/cakephp/lib/Cake/Error/ExceptionRenderer.php, line 190 ErrorHandler::handleException() - APP/Lib/cakephp/lib/Cake/Error/ErrorHandler.php, line 127 [main] - [internal], line ??
2017-07-06 10:40:56 Notice: Notice (8): Undefined variable: debugMode in [/var/www/MISP/app/View/Layouts/default.ctp, line 48] Trace: ErrorHandler::handleError() - APP/Lib/cakephp/lib/Cake/Error/ErrorHandler.php, line 230 include - APP/View/Layouts/default.ctp, line 48 View::_evaluate() - APP/Lib/cakephp/lib/Cake/View/View.php, line 971 View::_render() - APP/Lib/cakephp/lib/Cake/View/View.php, line 933 View::renderLayout() - APP/Lib/cakephp/lib/Cake/View/View.php, line 546 View::render() - APP/Lib/cakephp/lib/Cake/View/View.php, line 481 Controller::render() - APP/Lib/cakephp/lib/Cake/Controller/Controller.php, line 963 ExceptionRenderer::_outputMessage() - APP/Lib/cakephp/lib/Cake/Error/ExceptionRenderer.php, line 292 ExceptionRenderer::error500() - APP/Lib/cakephp/lib/Cake/Error/ExceptionRenderer.php, line 260 ExceptionRenderer::render() - APP/Lib/cakephp/lib/Cake/Error/ExceptionRenderer.php, line 190 ErrorHandler::handleException() - APP/Lib/cakephp/lib/Cake/Error/ErrorHandler.php, line 127 [main] - [internal], line ??
2017-07-06 10:40:56 Notice: Notice (8): Undefined variable: debugMode in [/var/www/MISP/app/View/Layouts/default.ctp, line 50] Trace: ErrorHandler::handleError() - APP/Lib/cakephp/lib/Cake/Error/ErrorHandler.php, line 230 include - APP/View/Layouts/default.ctp, line 50 View::_evaluate() - APP/Lib/cakephp/lib/Cake/View/View.php, line 971 View::_render() - APP/Lib/cakephp/lib/Cake/View/View.php, line 933 View::renderLayout() - APP/Lib/cakephp/lib/Cake/View/View.php, line 546 View::render() - APP/Lib/cakephp/lib/Cake/View/View.php, line 481 Controller::render() - APP/Lib/cakephp/lib/Cake/Controller/Controller.php, line 963 ExceptionRenderer::_outputMessage() - APP/Lib/cakephp/lib/Cake/Error/ExceptionRenderer.php, line 292 ExceptionRenderer::error500() - APP/Lib/cakephp/lib/Cake/Error/ExceptionRenderer.php, line 260 ExceptionRenderer::render() - APP/Lib/cakephp/lib/Cake/Error/ExceptionRenderer.php, line 190 ErrorHandler::handleException() - APP/Lib/cakephp/lib/Cake/Error/ErrorHandler.php, line 127 [main] - [internal], line ??
2017-07-06 10:40:56 Notice: Notice (8): Undefined variable: debugMode in [/var/www/MISP/app/View/Elements/footer.ctp, line 1] Trace: ErrorHandler::handleError() - APP/Lib/cakephp/lib/Cake/Error/ErrorHandler.php, line 230 include - APP/View/Elements/footer.ctp, line 1 View::_evaluate() - APP/Lib/cakephp/lib/Cake/View/View.php, line 971 View::_render() - APP/Lib/cakephp/lib/Cake/View/View.php, line 933 View::_renderElement() - APP/Lib/cakephp/lib/Cake/View/View.php, line 1224 View::element() - APP/Lib/cakephp/lib/Cake/View/View.php, line 418 include - APP/View/Layouts/default.ctp, line 81 View::_evaluate() - APP/Lib/cakephp/lib/Cake/View/View.php, line 971 View::_render() - APP/Lib/cakephp/lib/Cake/View/View.php, line 933 View::renderLayout() - APP/Lib/cakephp/lib/Cake/View/View.php, line 546 View::render() - APP/Lib/cakephp/lib/Cake/View/View.php, line 481 Controller::render() - APP/Lib/cakephp/lib/Cake/Controller/Controller.php, line 963 ExceptionRenderer::_outputMessage() - APP/Lib/cakephp/lib/Cake/Error/ExceptionRenderer.php, line 292 ExceptionRenderer::error500() - APP/Lib/cakephp/lib/Cake/Error/ExceptionRenderer.php, line 260 ExceptionRenderer::render() - APP/Lib/cakephp/lib/Cake/Error/ExceptionRenderer.php, line 190 ErrorHandler::handleException() - APP/Lib/cakephp/lib/Cake/Error/ErrorHandler.php, line 127 [main] - [internal], line ??
2017-07-06 10:40:56 Notice: Notice (8): Undefined variable: me in [/var/www/MISP/app/View/Layouts/default.ctp, line 87] Trace: ErrorHandler::handleError() - APP/Lib/cakephp/lib/Cake/Error/ErrorHandler.php, line 230 include - APP/View/Layouts/default.ctp, line 87 View::_evaluate() - APP/Lib/cakephp/lib/Cake/View/View.php, line 971 View::_render() - APP/Lib/cakephp/lib/Cake/View/View.php, line 933 View::renderLayout() - APP/Lib/cakephp/lib/Cake/View/View.php, line 546 View::render() - APP/Lib/cakephp/lib/Cake/View/View.php, line 481 Controller::render() - APP/Lib/cakephp/lib/Cake/Controller/Controller.php, line 963 ExceptionRenderer::_outputMessage() - APP/Lib/cakephp/lib/Cake/Error/ExceptionRenderer.php, line 292 ExceptionRenderer::error500() - APP/Lib/cakephp/lib/Cake/Error/ExceptionRenderer.php, line 260 ExceptionRenderer::render() - APP/Lib/cakephp/lib/Cake/Error/ExceptionRenderer.php, line 190 ErrorHandler::handleException() - APP/Lib/cakephp/lib/Cake/Error/ErrorHandler.php, line 127 [main] - [internal], line ??
2017-07-06 10:40:56 Notice: Notice (8): Undefined variable: debugMode in [/var/www/MISP/app/View/Layouts/default.ctp, line 102] Trace: ErrorHandler::handleError() - APP/Lib/cakephp/lib/Cake/Error/ErrorHandler.php, line 230 include - APP/View/Layouts/default.ctp, line 102 View::_evaluate() - APP/Lib/cakephp/lib/Cake/View/View.php, line 971 View::_render() - APP/Lib/cakephp/lib/Cake/View/View.php, line 933 View::renderLayout() - APP/Lib/cakephp/lib/Cake/View/View.php, line 546 View::render() - APP/Lib/cakephp/lib/Cake/View/View.php, line 481 Controller::render() - APP/Lib/cakephp/lib/Cake/Controller/Controller.php, line 963 ExceptionRenderer::_outputMessage() - APP/Lib/cakephp/lib/Cake/Error/ExceptionRenderer.php, line 292 ExceptionRenderer::error500() - APP/Lib/cakephp/lib/Cake/Error/ExceptionRenderer.php, line 260 ExceptionRenderer::render() - APP/Lib/cakephp/lib/Cake/Error/ExceptionRenderer.php, line 190 ErrorHandler::handleException() - APP/Lib/cakephp/lib/Cake/Error/ErrorHandler.php, line 127 [main] - [internal], line ??
2017-07-06 10:41:02 Notice: Notice (8): Undefined variable: debugMode in [/var/www/MISP/app/View/Layouts/default.ctp, line 11] Trace: ErrorHandler::handleError() - APP/Lib/cakephp/lib/Cake/Error/ErrorHandler.php, line 230 include - APP/View/Layouts/default.ctp, line 11 View::_evaluate() - APP/Lib/cakephp/lib/Cake/View/View.php, line 971 View::_render() - APP/Lib/cakephp/lib/Cake/View/View.php, line 933 View::renderLayout() - APP/Lib/cakephp/lib/Cake/View/View.php, line 546 View::render() - APP/Lib/cakephp/lib/Cake/View/View.php, line 481 Controller::render() - APP/Lib/cakephp/lib/Cake/Controller/Controller.php, line 963 ExceptionRenderer::_outputMessage() - APP/Lib/cakephp/lib/Cake/Error/ExceptionRenderer.php, line 292 ExceptionRenderer::error400() - APP/Lib/cakephp/lib/Cake/Error/ExceptionRenderer.php, line 236 ExceptionRenderer::render() - APP/Lib/cakephp/lib/Cake/Error/ExceptionRenderer.php, line 190 ErrorHandler::handleException() - APP/Lib/cakephp/lib/Cake/Error/ErrorHandler.php, line 127 [main] - [internal], line ??
2017-07-06 10:41:02 Notice: Notice (8): Undefined variable: me in [/var/www/MISP/app/View/Layouts/default.ctp, line 21] Trace: ErrorHandler::handleError() - APP/Lib/cakephp/lib/Cake/Error/ErrorHandler.php, line 230 include - APP/View/Layouts/default.ctp, line 21 View::_evaluate() - APP/Lib/cakephp/lib/Cake/View/View.php, line 971 View::_render() - APP/Lib/cakephp/lib/Cake/View/View.php, line 933 View::renderLayout() - APP/Lib/cakephp/lib/Cake/View/View.php, line 546 View::render() - APP/Lib/cakephp/lib/Cake/View/View.php, line 481 Controller::render() - APP/Lib/cakephp/lib/Cake/Controller/Controller.php, line 963 ExceptionRenderer::_outputMessage() - APP/Lib/cakephp/lib/Cake/Error/ExceptionRenderer.php, line 292 ExceptionRenderer::error400() - APP/Lib/cakephp/lib/Cake/Error/ExceptionRenderer.php, line 236 ExceptionRenderer::render() - APP/Lib/cakephp/lib/Cake/Error/ExceptionRenderer.php, line 190 ErrorHandler::handleException() - APP/Lib/cakephp/lib/Cake/Error/ErrorHandler.php, line 127 [main] - [internal], line ??
2017-07-06 10:41:02 Notice: Notice (8): Undefined variable: debugMode in [/var/www/MISP/app/View/Elements/global_menu.ctp, line 1] Trace: ErrorHandler::handleError() - APP/Lib/cakephp/lib/Cake/Error/ErrorHandler.php, line 230 include - APP/View/Elements/global_menu.ctp, line 1 View::_evaluate() - APP/Lib/cakephp/lib/Cake/View/View.php, line 971 View::_render() - APP/Lib/cakephp/lib/Cake/View/View.php, line 933 View::_renderElement() - APP/Lib/cakephp/lib/Cake/View/View.php, line 1224 View::element() - APP/Lib/cakephp/lib/Cake/View/View.php, line 418 include - APP/View/Layouts/default.ctp, line 46 View::_evaluate() - APP/Lib/cakephp/lib/Cake/View/View.php, line 971 View::_render() - APP/Lib/cakephp/lib/Cake/View/View.php, line 933 View::renderLayout() - APP/Lib/cakephp/lib/Cake/View/View.php, line 546 View::render() - APP/Lib/cakephp/lib/Cake/View/View.php, line 481 Controller::render() - APP/Lib/cakephp/lib/Cake/Controller/Controller.php, line 963 ExceptionRenderer::_outputMessage() - APP/Lib/cakephp/lib/Cake/Error/ExceptionRenderer.php, line 292 ExceptionRenderer::error400() - APP/Lib/cakephp/lib/Cake/Error/ExceptionRenderer.php, line 236 ExceptionRenderer::render() - APP/Lib/cakephp/lib/Cake/Error/ExceptionRenderer.php, line 190 ErrorHandler::handleException() - APP/Lib/cakephp/lib/Cake/Error/ErrorHandler.php, line 127 [main] - [internal], line ??
2017-07-06 10:41:02 Notice: Notice (8): Undefined variable: me in [/var/www/MISP/app/View/Elements/global_menu.ctp, line 10] Trace: ErrorHandler::handleError() - APP/Lib/cakephp/lib/Cake/Error/ErrorHandler.php, line 230 include - APP/View/Elements/global_menu.ctp, line 10 View::_evaluate() - APP/Lib/cakephp/lib/Cake/View/View.php, line 971 View::_render() - APP/Lib/cakephp/lib/Cake/View/View.php, line 933 View::_renderElement() - APP/Lib/cakephp/lib/Cake/View/View.php, line 1224 View::element() - APP/Lib/cakephp/lib/Cake/View/View.php, line 418 include - APP/View/Layouts/default.ctp, line 46 View::_evaluate() - APP/Lib/cakephp/lib/Cake/View/View.php, line 971 View::_render() - APP/Lib/cakephp/lib/Cake/View/View.php, line 933 View::renderLayout() - APP/Lib/cakephp/lib/Cake/View/View.php, line 546 View::render() - APP/Lib/cakephp/lib/Cake/View/View.php, line 481 Controller::render() - APP/Lib/cakephp/lib/Cake/Controller/Controller.php, line 963 ExceptionRenderer::_outputMessage() - APP/Lib/cakephp/lib/Cake/Error/ExceptionRenderer.php, line 292 ExceptionRenderer::error400() - APP/Lib/cakephp/lib/Cake/Error/ExceptionRenderer.php, line 236 ExceptionRenderer::render() - APP/Lib/cakephp/lib/Cake/Error/ExceptionRenderer.php, line 190 ErrorHandler::handleException() - APP/Lib/cakephp/lib/Cake/Error/ErrorHandler.php, line 127 [main] - [internal], line ??
2017-07-06 10:41:02 Notice: Notice (8): Undefined variable: debugMode in [/var/www/MISP/app/View/Layouts/default.ctp, line 48] Trace: ErrorHandler::handleError() - APP/Lib/cakephp/lib/Cake/Error/ErrorHandler.php, line 230 include - APP/View/Layouts/default.ctp, line 48 View::_evaluate() - APP/Lib/cakephp/lib/Cake/View/View.php, line 971 View::_render() - APP/Lib/cakephp/lib/Cake/View/View.php, line 933 View::renderLayout() - APP/Lib/cakephp/lib/Cake/View/View.php, line 546 View::render() - APP/Lib/cakephp/lib/Cake/View/View.php, line 481 Controller::render() - APP/Lib/cakephp/lib/Cake/Controller/Controller.php, line 963 ExceptionRenderer::_outputMessage() - APP/Lib/cakephp/lib/Cake/Error/ExceptionRenderer.php, line 292 ExceptionRenderer::error400() - APP/Lib/cakephp/lib/Cake/Error/ExceptionRenderer.php, line 236 ExceptionRenderer::render() - APP/Lib/cakephp/lib/Cake/Error/ExceptionRenderer.php, line 190 ErrorHandler::handleException() - APP/Lib/cakephp/lib/Cake/Error/ErrorHandler.php, line 127 [main] - [internal], line ??
2017-07-06 10:41:02 Notice: Notice (8): Undefined variable: debugMode in [/var/www/MISP/app/View/Layouts/default.ctp, line 50] Trace: ErrorHandler::handleError() - APP/Lib/cakephp/lib/Cake/Error/ErrorHandler.php, line 230 include - APP/View/Layouts/default.ctp, line 50 View::_evaluate() - APP/Lib/cakephp/lib/Cake/View/View.php, line 971 View::_render() - APP/Lib/cakephp/lib/Cake/View/View.php, line 933 View::renderLayout() - APP/Lib/cakephp/lib/Cake/View/View.php, line 546 View::render() - APP/Lib/cakephp/lib/Cake/View/View.php, line 481 Controller::render() - APP/Lib/cakephp/lib/Cake/Controller/Controller.php, line 963 ExceptionRenderer::_outputMessage() - APP/Lib/cakephp/lib/Cake/Error/ExceptionRenderer.php, line 292 ExceptionRenderer::error400() - APP/Lib/cakephp/lib/Cake/Error/ExceptionRenderer.php, line 236 ExceptionRenderer::render() - APP/Lib/cakephp/lib/Cake/Error/ExceptionRenderer.php, line 190 ErrorHandler::handleException() - APP/Lib/cakephp/lib/Cake/Error/ErrorHandler.php, line 127 [main] - [internal], line ??
2017-07-06 10:41:02 Notice: Notice (8): Undefined variable: debugMode in [/var/www/MISP/app/View/Elements/footer.ctp, line 1] Trace: ErrorHandler::handleError() - APP/Lib/cakephp/lib/Cake/Error/ErrorHandler.php, line 230 include - APP/View/Elements/footer.ctp, line 1 View::_evaluate() - APP/Lib/cakephp/lib/Cake/View/View.php, line 971 View::_render() - APP/Lib/cakephp/lib/Cake/View/View.php, line 933 View::_renderElement() - APP/Lib/cakephp/lib/Cake/View/View.php, line 1224 View::element() - APP/Lib/cakephp/lib/Cake/View/View.php, line 418 include - APP/View/Layouts/default.ctp, line 81 View::_evaluate() - APP/Lib/cakephp/lib/Cake/View/View.php, line 971 View::_render() - APP/Lib/cakephp/lib/Cake/View/View.php, line 933 View::renderLayout() - APP/Lib/cakephp/lib/Cake/View/View.php, line 546 View::render() - APP/Lib/cakephp/lib/Cake/View/View.php, line 481 Controller::render() - APP/Lib/cakephp/lib/Cake/Controller/Controller.php, line 963 ExceptionRenderer::_outputMessage() - APP/Lib/cakephp/lib/Cake/Error/ExceptionRenderer.php, line 292 ExceptionRenderer::error400() - APP/Lib/cakephp/lib/Cake/Error/ExceptionRenderer.php, line 236 ExceptionRenderer::render() - APP/Lib/cakephp/lib/Cake/Error/ExceptionRenderer.php, line 190 ErrorHandler::handleException() - APP/Lib/cakephp/lib/Cake/Error/ErrorHandler.php, line 127 [main] - [internal], line ??
2017-07-06 10:41:02 Notice: Notice (8): Undefined variable: me in [/var/www/MISP/app/View/Layouts/default.ctp, line 87] Trace: ErrorHandler::handleError() - APP/Lib/cakephp/lib/Cake/Error/ErrorHandler.php, line 230 include - APP/View/Layouts/default.ctp, line 87 View::_evaluate() - APP/Lib/cakephp/lib/Cake/View/View.php, line 971 View::_render() - APP/Lib/cakephp/lib/Cake/View/View.php, line 933 View::renderLayout() - APP/Lib/cakephp/lib/Cake/View/View.php, line 546 View::render() - APP/Lib/cakephp/lib/Cake/View/View.php, line 481 Controller::render() - APP/Lib/cakephp/lib/Cake/Controller/Controller.php, line 963 ExceptionRenderer::_outputMessage() - APP/Lib/cakephp/lib/Cake/Error/ExceptionRenderer.php, line 292 ExceptionRenderer::error400() - APP/Lib/cakephp/lib/Cake/Error/ExceptionRenderer.php, line 236 ExceptionRenderer::render() - APP/Lib/cakephp/lib/Cake/Error/ExceptionRenderer.php, line 190 ErrorHandler::handleException() - APP/Lib/cakephp/lib/Cake/Error/ErrorHandler.php, line 127 [main] - [internal], line ??
2017-07-06 10:41:02 Notice: Notice (8): Undefined variable: debugMode in [/var/www/MISP/app/View/Layouts/default.ctp, line 102] Trace: ErrorHandler::handleError() - APP/Lib/cakephp/lib/Cake/Error/ErrorHandler.php, line 230 include - APP/View/Layouts/default.ctp, line 102 View::_evaluate() - APP/Lib/cakephp/lib/Cake/View/View.php, line 971 View::_render() - APP/Lib/cakephp/lib/Cake/View/View.php, line 933 View::renderLayout() - APP/Lib/cakephp/lib/Cake/View/View.php, line 546 View::render() - APP/Lib/cakephp/lib/Cake/View/View.php, line 481 Controller::render() - APP/Lib/cakephp/lib/Cake/Controller/Controller.php, line 963 ExceptionRenderer::_outputMessage() - APP/Lib/cakephp/lib/Cake/Error/ExceptionRenderer.php, line 292 ExceptionRenderer::error400() - APP/Lib/cakephp/lib/Cake/Error/ExceptionRenderer.php, line 236 ExceptionRenderer::render() - APP/Lib/cakephp/lib/Cake/Error/ExceptionRenderer.php, line 190 ErrorHandler::handleException() - APP/Lib/cakephp/lib/Cake/Error/ErrorHandler.php, line 127 [main] - [internal], line ??
2017-07-06 10:41:19 Notice: Notice (8): Undefined variable: debugMode in [/var/www/MISP/app/View/Layouts/default.ctp, line 11] Trace: ErrorHandler::handleError() - APP/Lib/cakephp/lib/Cake/Error/ErrorHandler.php, line 230 include - APP/View/Layouts/default.ctp, line 11 View::_evaluate() - APP/Lib/cakephp/lib/Cake/View/View.php, line 971 View::_render() - APP/Lib/cakephp/lib/Cake/View/View.php, line 933 View::renderLayout() - APP/Lib/cakephp/lib/Cake/View/View.php, line 546 View::render() - APP/Lib/cakephp/lib/Cake/View/View.php, line 481 Controller::render() - APP/Lib/cakephp/lib/Cake/Controller/Controller.php, line 963 ExceptionRenderer::_outputMessage() - APP/Lib/cakephp/lib/Cake/Error/ExceptionRenderer.php, line 292 ExceptionRenderer::error500() - APP/Lib/cakephp/lib/Cake/Error/ExceptionRenderer.php, line 260 ExceptionRenderer::render() - APP/Lib/cakephp/lib/Cake/Error/ExceptionRenderer.php, line 190 ErrorHandler::handleException() - APP/Lib/cakephp/lib/Cake/Error/ErrorHandler.php, line 127 [main] - [internal], line ??
2017-07-06 10:41:19 Notice: Notice (8): Undefined variable: me in [/var/www/MISP/app/View/Layouts/default.ctp, line 21] Trace: ErrorHandler::handleError() - APP/Lib/cakephp/lib/Cake/Error/ErrorHandler.php, line 230 include - APP/View/Layouts/default.ctp, line 21 View::_evaluate() - APP/Lib/cakephp/lib/Cake/View/View.php, line 971 View::_render() - APP/Lib/cakephp/lib/Cake/View/View.php, line 933 View::renderLayout() - APP/Lib/cakephp/lib/Cake/View/View.php, line 546 View::render() - APP/Lib/cakephp/lib/Cake/View/View.php, line 481 Controller::render() - APP/Lib/cakephp/lib/Cake/Controller/Controller.php, line 963 ExceptionRenderer::_outputMessage() - APP/Lib/cakephp/lib/Cake/Error/ExceptionRenderer.php, line 292 ExceptionRenderer::error500() - APP/Lib/cakephp/lib/Cake/Error/ExceptionRenderer.php, line 260 ExceptionRenderer::render() - APP/Lib/cakephp/lib/Cake/Error/ExceptionRenderer.php, line 190 ErrorHandler::handleException() - APP/Lib/cakephp/lib/Cake/Error/ErrorHandler.php, line 127 [main] - [internal], line ??
2017-07-06 10:41:19 Notice: Notice (8): Undefined variable: debugMode in [/var/www/MISP/app/View/Elements/global_menu.ctp, line 1] Trace: ErrorHandler::handleError() - APP/Lib/cakephp/lib/Cake/Error/ErrorHandler.php, line 230 include - APP/View/Elements/global_menu.ctp, line 1 View::_evaluate() - APP/Lib/cakephp/lib/Cake/View/View.php, line 971 View::_render() - APP/Lib/cakephp/lib/Cake/View/View.php, line 933 View::_renderElement() - APP/Lib/cakephp/lib/Cake/View/View.php, line 1224 View::element() - APP/Lib/cakephp/lib/Cake/View/View.php, line 418 include - APP/View/Layouts/default.ctp, line 46 View::_evaluate() - APP/Lib/cakephp/lib/Cake/View/View.php, line 971 View::_render() - APP/Lib/cakephp/lib/Cake/View/View.php, line 933 View::renderLayout() - APP/Lib/cakephp/lib/Cake/View/View.php, line 546 View::render() - APP/Lib/cakephp/lib/Cake/View/View.php, line 481 Controller::render() - APP/Lib/cakephp/lib/Cake/Controller/Controller.php, line 963 ExceptionRenderer::_outputMessage() - APP/Lib/cakephp/lib/Cake/Error/ExceptionRenderer.php, line 292 ExceptionRenderer::error500() - APP/Lib/cakephp/lib/Cake/Error/ExceptionRenderer.php, line 260 ExceptionRenderer::render() - APP/Lib/cakephp/lib/Cake/Error/ExceptionRenderer.php, line 190 ErrorHandler::handleException() - APP/Lib/cakephp/lib/Cake/Error/ErrorHandler.php, line 127 [main] - [internal], line ??
2017-07-06 10:41:19 Notice: Notice (8): Undefined variable: me in [/var/www/MISP/app/View/Elements/global_menu.ctp, line 10] Trace: ErrorHandler::handleError() - APP/Lib/cakephp/lib/Cake/Error/ErrorHandler.php, line 230 include - APP/View/Elements/global_menu.ctp, line 10 View::_evaluate() - APP/Lib/cakephp/lib/Cake/View/View.php, line 971 View::_render() - APP/Lib/cakephp/lib/Cake/View/View.php, line 933 View::_renderElement() - APP/Lib/cakephp/lib/Cake/View/View.php, line 1224 View::element() - APP/Lib/cakephp/lib/Cake/View/View.php, line 418 include - APP/View/Layouts/default.ctp, line 46 View::_evaluate() - APP/Lib/cakephp/lib/Cake/View/View.php, line 971 View::_render() - APP/Lib/cakephp/lib/Cake/View/View.php, line 933 View::renderLayout() - APP/Lib/cakephp/lib/Cake/View/View.php, line 546 View::render() - APP/Lib/cakephp/lib/Cake/View/View.php, line 481 Controller::render() - APP/Lib/cakephp/lib/Cake/Controller/Controller.php, line 963 ExceptionRenderer::_outputMessage() - APP/Lib/cakephp/lib/Cake/Error/ExceptionRenderer.php, line 292 ExceptionRenderer::error500() - APP/Lib/cakephp/lib/Cake/Error/ExceptionRenderer.php, line 260 ExceptionRenderer::render() - APP/Lib/cakephp/lib/Cake/Error/ExceptionRenderer.php, line 190 ErrorHandler::handleException() - APP/Lib/cakephp/lib/Cake/Error/ErrorHandler.php, line 127 [main] - [internal], line ??
2017-07-06 10:41:19 Notice: Notice (8): Undefined variable: debugMode in [/var/www/MISP/app/View/Layouts/default.ctp, line 48] Trace: ErrorHandler::handleError() - APP/Lib/cakephp/lib/Cake/Error/ErrorHandler.php, line 230 include - APP/View/Layouts/default.ctp, line 48 View::_evaluate() - APP/Lib/cakephp/lib/Cake/View/View.php, line 971 View::_render() - APP/Lib/cakephp/lib/Cake/View/View.php, line 933 View::renderLayout() - APP/Lib/cakephp/lib/Cake/View/View.php, line 546 View::render() - APP/Lib/cakephp/lib/Cake/View/View.php, line 481 Controller::render() - APP/Lib/cakephp/lib/Cake/Controller/Controller.php, line 963 ExceptionRenderer::_outputMessage() - APP/Lib/cakephp/lib/Cake/Error/ExceptionRenderer.php, line 292 ExceptionRenderer::error500() - APP/Lib/cakephp/lib/Cake/Error/ExceptionRenderer.php, line 260 ExceptionRenderer::render() - APP/Lib/cakephp/lib/Cake/Error/ExceptionRenderer.php, line 190 ErrorHandler::handleException() - APP/Lib/cakephp/lib/Cake/Error/ErrorHandler.php, line 127 [main] - [internal], line ??
2017-07-06 10:41:19 Notice: Notice (8): Undefined variable: debugMode in [/var/www/MISP/app/View/Layouts/default.ctp, line 50] Trace: ErrorHandler::handleError() - APP/Lib/cakephp/lib/Cake/Error/ErrorHandler.php, line 230 include - APP/View/Layouts/default.ctp, line 50 View::_evaluate() - APP/Lib/cakephp/lib/Cake/View/View.php, line 971 View::_render() - APP/Lib/cakephp/lib/Cake/View/View.php, line 933 View::renderLayout() - APP/Lib/cakephp/lib/Cake/View/View.php, line 546 View::render() - APP/Lib/cakephp/lib/Cake/View/View.php, line 481 Controller::render() - APP/Lib/cakephp/lib/Cake/Controller/Controller.php, line 963 ExceptionRenderer::_outputMessage() - APP/Lib/cakephp/lib/Cake/Error/ExceptionRenderer.php, line 292 ExceptionRenderer::error500() - APP/Lib/cakephp/lib/Cake/Error/ExceptionRenderer.php, line 260 ExceptionRenderer::render() - APP/Lib/cakephp/lib/Cake/Error/ExceptionRenderer.php, line 190 ErrorHandler::handleException() - APP/Lib/cakephp/lib/Cake/Error/ErrorHandler.php, line 127 [main] - [internal], line ??
2017-07-06 10:41:19 Notice: Notice (8): Undefined variable: debugMode in [/var/www/MISP/app/View/Elements/footer.ctp, line 1] Trace: ErrorHandler::handleError() - APP/Lib/cakephp/lib/Cake/Error/ErrorHandler.php, line 230 include - APP/View/Elements/footer.ctp, line 1 View::_evaluate() - APP/Lib/cakephp/lib/Cake/View/View.php, line 971 View::_render() - APP/Lib/cakephp/lib/Cake/View/View.php, line 933 View::_renderElement() - APP/Lib/cakephp/lib/Cake/View/View.php, line 1224 View::element() - APP/Lib/cakephp/lib/Cake/View/View.php, line 418 include - APP/View/Layouts/default.ctp, line 81 View::_evaluate() - APP/Lib/cakephp/lib/Cake/View/View.php, line 971 View::_render() - APP/Lib/cakephp/lib/Cake/View/View.php, line 933 View::renderLayout() - APP/Lib/cakephp/lib/Cake/View/View.php, line 546 View::render() - APP/Lib/cakephp/lib/Cake/View/View.php, line 481 Controller::render() - APP/Lib/cakephp/lib/Cake/Controller/Controller.php, line 963 ExceptionRenderer::_outputMessage() - APP/Lib/cakephp/lib/Cake/Error/ExceptionRenderer.php, line 292 ExceptionRenderer::error500() - APP/Lib/cakephp/lib/Cake/Error/ExceptionRenderer.php, line 260 ExceptionRenderer::render() - APP/Lib/cakephp/lib/Cake/Error/ExceptionRenderer.php, line 190 ErrorHandler::handleException() - APP/Lib/cakephp/lib/Cake/Error/ErrorHandler.php, line 127 [main] - [internal], line ??
2017-07-06 10:41:19 Notice: Notice (8): Undefined variable: me in [/var/www/MISP/app/View/Layouts/default.ctp, line 87] Trace: ErrorHandler::handleError() - APP/Lib/cakephp/lib/Cake/Error/ErrorHandler.php, line 230 include - APP/View/Layouts/default.ctp, line 87 View::_evaluate() - APP/Lib/cakephp/lib/Cake/View/View.php, line 971 View::_render() - APP/Lib/cakephp/lib/Cake/View/View.php, line 933 View::renderLayout() - APP/Lib/cakephp/lib/Cake/View/View.php, line 546 View::render() - APP/Lib/cakephp/lib/Cake/View/View.php, line 481 Controller::render() - APP/Lib/cakephp/lib/Cake/Controller/Controller.php, line 963 ExceptionRenderer::_outputMessage() - APP/Lib/cakephp/lib/Cake/Error/ExceptionRenderer.php, line 292 ExceptionRenderer::error500() - APP/Lib/cakephp/lib/Cake/Error/ExceptionRenderer.php, line 260 ExceptionRenderer::render() - APP/Lib/cakephp/lib/Cake/Error/ExceptionRenderer.php, line 190 ErrorHandler::handleException() - APP/Lib/cakephp/lib/Cake/Error/ErrorHandler.php, line 127 [main] - [internal], line ??
2017-07-06 10:41:19 Notice: Notice (8): Undefined variable: debugMode in [/var/www/MISP/app/View/Layouts/default.ctp, line 102] Trace: ErrorHandler::handleError() - APP/Lib/cakephp/lib/Cake/Error/ErrorHandler.php, line 230 include - APP/View/Layouts/default.ctp, line 102 View::_evaluate() - APP/Lib/cakephp/lib/Cake/View/View.php, line 971 View::_render() - APP/Lib/cakephp/lib/Cake/View/View.php, line 933 View::renderLayout() - APP/Lib/cakephp/lib/Cake/View/View.php, line 546 View::render() - APP/Lib/cakephp/lib/Cake/View/View.php, line 481 Controller::render() - APP/Lib/cakephp/lib/Cake/Controller/Controller.php, line 963 ExceptionRenderer::_outputMessage() - APP/Lib/cakephp/lib/Cake/Error/ExceptionRenderer.php, line 292 ExceptionRenderer::error500() - APP/Lib/cakephp/lib/Cake/Error/ExceptionRenderer.php, line 260 ExceptionRenderer::render() - APP/Lib/cakephp/lib/Cake/Error/ExceptionRenderer.php, line 190 ErrorHandler::handleException() - APP/Lib/cakephp/lib/Cake/Error/ErrorHandler.php, line 127 [main] - [internal], line ??
more error.log 2017-07-06 10:45:31 Error: [MissingTableException] Table logs for model Log was not found in datasource default. Exception Attributes: array ( 'table' => 'logs', 'class' => 'Log', 'ds' => 'default', ) Request URL: /users/login Stack Trace:
2017-07-06 10:45:36 Error: [MissingTableException] Table logs for model Log was not found in datasource default. Exception Attributes: array ( 'table' => 'logs', 'class' => 'Log', 'ds' => 'default', ) Request URL: / Stack Trace:
I found you comment on the same exact error on this link. https://github.com/MISP/MISP/issues/1796
Could you clean your model cache just in case?
rm /var/www/MISP/app/tmp/cache/models/myapp rm /var/www/MISP/app/tmp/cache/persistent/myapp
The login page is now up. I will try and login and se if it works now
Perfect, was about to suggest that. You only had 5 tables during the incorrect import and they were erroneously cached.
BTW, the reason it couldn't be imported in the first place is that centos is using a pretty old version of mariadb. So even though it should work now, it's a good idea probably to upgrade to a less historic version ;)
On Thu, Jul 6, 2017 at 5:10 PM, krypto29s notifications@github.com wrote:
I found you comment on the same exact error on this link. MISP/MISP#1796 https://github.com/MISP/MISP/issues/1796
Could you clean your model cache just in case?
rm /var/www/MISP/app/tmp/cache/models/myapp rm /var/www/MISP/app/tmp/cache/persistent/myapp
The login page is now up. I will try and login and se if it works now
— You are receiving this because you commented. Reply to this email directly, view it on GitHub https://github.com/MISP/misp-book/issues/54#issuecomment-313425309, or mute the thread https://github.com/notifications/unsubscribe-auth/ADf6wPLuteunMA-4CFL2L44dUTAkfI8Sks5sLPjSgaJpZM4OPDzm .
The default creds do not work. Where are they stored?
Guide says they should be
| # The default user/pass = admin@admin.test/admin
What the hell.
mysql -u misp -p misp
select email from users where id = 1;
exit;
cd /var/www/MISP/app/Console
./cake Password [email returned before] Password1234
I was just showing the user table.. sadly, it is empty. SELECT * FROM users -> ; Empty set (0.00 sec)
The first login should create a user o.O What the hell is going on.
Are MySQL permissions and the settings in /var/www/MISP/app/Config/database.php correct?
Not real sure. -rw-r----- 1 root apache 2608 Jul 5 13:55 database.php
The settings within I mean, if you check the credentials in database.php, can you access mysql with it and create data in the existing tables on the misp database?
public $default = array( 'datasource' => 'Database/Mysql', //'datasource' => 'Database/Postgres', 'persistent' => false, 'host' => 'localhost', 'login' => 'misp', // grant usage on . to misp@localhost, 'port' => 3306, // MySQL & MariaDB //'port' => 5432, // PostgreSQL 'password' => 'sanitized input', //I removed the actual password. 'database' => 'misp', // create database misp; 'prefix' => '', 'encoding' => 'utf8', ); I am able to login to the misp database with the real creds.
I can try to create a user if you like?
Give it a shot!
But I don't get what's up.
Do I need to add the user to the mysql, or the misp DB? what is the syntax for the table? It is currently empty.
looks like the table is empy, so I would need to make columns for the table.
After some crafty ingenuity, I have the table populated. I can't change the password;
./cake Password admin@admin.test Password1234 PHP Fatal error: Can't use function return value in write context in /var/www/MISP/app/Model/User.php on line 761 Fatal Error Error: Can't use function return value in write context in [/var/www/MISP/app/Model/User.php, line 761]
2017-07-06 12:15:41 Error: Can't use function return value in write context in [/var/www/MISP/app/Model/User.php, line 761]
What is the authkey column in the user table? How is the password column salted? i am able to add users, but they won't authenticate because the pasword field is a encoded/encrypted value of the real password.
I used the MYSQL db to load all the columns in the empty users table.
Ok, so here is why the cake command didn't work. It wants to execute system level php. For some reason it keeps wanting to default to php 5.4. PHP 5.4 is not even installed. We fixed it by putting the relative path to php56.
exec /opt/rh/rh-php56/root/usr/bin/php -q "$LIB"cake.php -working "$APP" "$@"
From there I was able to execute ./cake Password admin@admin.test Password1234. This allowed me to login to the webgui, and setup the other accounts, and remove the test user after I was done.
We can call this case closed now.
I followed the install guide according, and when I start the process everything appears to start but I am not able to access http://misp/user/login url. I am getting an error 500. sudo su -s /bin/bash apache -c 'scl enable rh-php56 /var/www/MISP/app/Console/worker/start.sh' [sudo] password for sjohn345: Stopping workers Stopping 12950 ... Done Stopping the Scheduler Worker ... Done Stopping 12968 ... Done Stopping 12986 ... Done Stopping 13004 ... Done
Creating workers Starting worker ... Done
Creating workers Starting worker ... Done
Creating workers Starting worker ... Done
Creating workers Starting worker ... Done
Creating the scheduler workers Starting scheduler worker ... Done ! more misp.local_error.log [Wed Jul 05 21:28:56.478562 2017] [:error] [pid 11684] [client ::1:51188] PHP Fatal error: Can't use function return value in write context in /var/www/MISP/app/Controller/UsersController.php on line 97 [Wed Jul 05 21:28:56.479803 2017] [:error] [pid 11684] [client ::1:51188] PHP Fatal error: Can't use function return value in write context in /var/www/MISP/app/Controller/AppController.php on line 305 [Wed Jul 05 21:29:02.058256 2017] [:error] [pid 2369] [client ::1:51190] PHP Fatal error: Can't use function return value in write context in /var/www/MISP/app/Controller/AppController.php on line 305