{"action":"created","issue":{"url":"https://api.github.com/repos/xme/misp-docker/issues/9","repository_url":"https://api.github.com/repos/xme/misp-docker","labels_url":"https://api.github.com/repos/xme/misp-docker/issues/9/labels{/name}","comments_url":"https://api.github.com/repos/xme/misp-docker/issues/9/comments","events_url":"https://api.github.com/repos/xme/misp-docker/issues/9/events","html_url":"https://github.com/xme/misp-docker/issues/9","id":196775987,"number":9,"title":"Docker Image seems to be broken","user":{"login":"phant0m3","id":23175135,"avatar_url":"https://avatars.githubusercontent.com/u/23175135?v=3","gravatar_id":"","url":"https://api.github.com/users/phant0m3","html_url":"https://github.com/phant0m3","followers_url":"https://api.github.com/users/phant0m3/followers","following_url":"https://api.github.com/users/phant0m3/following{/other_user}","gists_url":"https://api.github.com/users/phant0m3/gists{/gist_id}","starred_url":"https://api.github.com/users/phant0m3/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/phant0m3/subscriptions","organizations_url":"https://api.github.com/users/phant0m3/orgs","repos_url":"https://api.github.com/users/phant0m3/repos","events_url":"https://api.github.com/users/phant0m3/events{/privacy}","received_events_url":"https://api.github.com/users/phant0m3/received_events","type":"User","site_admin":false},"labels":[{"id":335770442,"url":"https://api.github.com/repos/xme/misp-docker/labels/bug","name":"bug","color":"fc2929","default":true}],"state":"open","locked":false,"assignee":{"login":"xme","id":480944,"avatar_url":"https://avatars.githubusercontent.com/u/480944?v=3","gravatar_id":"","url":"https://api.github.com/users/xme","html_url":"https://github.com/xme","followers_url":"https://api.github.com/users/xme/followers","following_url":"https://api.github.com/users/xme/following{/other_user}","gists_url":"https://api.github.com/users/xme/gists{/gist_id}","starred_url":"https://api.github.com/users/xme/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/xme/subscriptions","organizations_url":"https://api.github.com/users/xme/orgs","repos_url":"https://api.github.com/users/xme/repos","events_url":"https://api.github.com/users/xme/events{/privacy}","received_events_url":"https://api.github.com/users/xme/received_events","type":"User","site_admin":false},"assignees":[{"login":"xme","id":480944,"avatar_url":"https://avatars.githubusercontent.com/u/480944?v=3","gravatar_id":"","url":"https://api.github.com/users/xme","html_url":"https://github.com/xme","followers_url":"https://api.github.com/users/xme/followers","following_url":"https://api.github.com/users/xme/following{/other_user}","gists_url":"https://api.github.com/users/xme/gists{/gist_id}","starred_url":"https://api.github.com/users/xme/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/xme/subscriptions","organizations_url":"https://api.github.com/users/xme/orgs","repos_url":"https://api.github.com/users/xme/repos","events_url":"https://api.github.com/users/xme/events{/privacy}","received_events_url":"https://api.github.com/users/xme/received_events","type":"User","site_admin":false}],"milestone":null,"comments":1,"created_at":"2016-12-20T20:40:54Z","updated_at":"2016-12-22T18:29:29Z","closed_at":null,"body":"Not sure if this is related to https://github.com/MISP/MISP/issues/1776 but the current docker image does not seem to work.\r\n\r\nI get the following error in the log file:\r\n``\r\n2016-12-20 20:31:51 Error: [MissingControllerException] Controller class LoginController could not be found.\r\nException Attributes: array (\r\n  'class' => 'LoginController',\r\n  'plugin' => NULL,\r\n)\r\nRequest URL: /login\r\nStack Trace:\r\n#0 /var/www/MISP/app/webroot/index.php(92): Dispatcher->dispatch(Object(CakeRequest), Object(CakeResponse))\r\n#1 {main}\r\n2016-12-20 20:31:52 Error: [MissingTableException] Table logs for model Log was not found in datasource default.\r\nException Attributes: array (\r\n  'table' => 'logs',\r\n  'class' => 'Log',\r\n  'ds' => 'default',\r\n)\r\nRequest URL: /\r\nStack Trace:\r\n#0 /var/www/MISP/app/Lib/cakephp/lib/Cake/Model/Model.php(3660): Model->setSource('logs')\r\n#1 /var/www/MISP/app/Lib/cakephp/lib/Cake/Model/Model.php(1394): Model->getDataSource()\r\n#2 /var/www/MISP/app/Plugin/SysLogLogable/Model/Behavior/SysLogLogableBehavior.php(275): Model->schema()\r\n#3 /var/www/MISP/app/Lib/cakephp/lib/Cake/Model/BehaviorCollection.php(145): SysLogLogableBehavior->setup(Object(User), Array)\r\n#4 /var/www/MISP/app/Lib/cakephp/lib/Cake/Model/BehaviorCollection.php(66): BehaviorCollection->load('SysLogLogable.S...', Array)\r\n#5 /var/www/MISP/app/Lib/cakephp/lib/Cake/Model/Model.php(781): BehaviorCollection->init('User', Array)\r\n#6 /var/www/MISP/app/Model/AppModel.php(31): Model->__construct(Array, NULL, NULL)\r\n#7 [internal function]: AppModel->__construct(Array)\r\n#8 /var/www/MISP/app/Lib/cakephp/lib/Cake/Utility/ClassRegistry.php(169): ReflectionClass->newInstance(Array)\r\n#9 /var/www/MISP/app/Lib/cakephp/lib/Cake/Controller/Controller.php(742): ClassRegistry::init(Array)\r\n#10 /var/www/MISP/app/Controller/AppController.php(90): Controller->loadModel('User')\r\n#11 /var/www/MISP/app/Controller/EventsController.php(34): AppController->beforeFilter()\r\n#12 [internal function]: EventsController->beforeFilter(Object(CakeEvent))\r\n#13 /var/www/MISP/app/Lib/cakephp/lib/Cake/Event/CakeEventManager.php(243): call_user_func(Array, Object(CakeEvent))\r\n#14 /var/www/MISP/app/Lib/cakephp/lib/Cake/Controller/Controller.php(677): CakeEventManager->dispatch(Object(CakeEvent))\r\n#15 /var/www/MISP/app/Lib/cakephp/lib/Cake/Routing/Dispatcher.php(189): Controller->startupProcess()\r\n#16 /var/www/MISP/app/Lib/cakephp/lib/Cake/Routing/Dispatcher.php(167): Dispatcher->_invoke(Object(EventsController), Object(CakeRequest))\r\n#17 /var/www/MISP/app/webroot/index.php(92): Dispatcher->dispatch(Object(CakeRequest), Object(CakeResponse))\r\n#18 {main}\r\n\r\nIf I try and import the mysql.sql from the INSTALL dir it tells me that the table does not support full text indexing so it may appear that the database does not get populated correctly.\r\n\r\nI tried setting both complex and simple passwords in the env file but no luck."},"comment":{"url":"https://api.github.com/repos/xme/misp-docker/issues/comments/268860843","html_url":"https://github.com/xme/misp-docker/issues/9#issuecomment-268860843","issue_url":"https://api.github.com/repos/xme/misp-docker/issues/9","id":268860843,"user":{"login":"mallorybowes","id":24720141,"avatar_url":"https://avatars.githubusercontent.com/u/24720141?v=3","gravatar_id":"","url":"https://api.github.com/users/mallorybowes","html_url":"https://github.com/mallorybowes","followers_url":"https://api.github.com/users/mallorybowes/followers","following_url":"https://api.github.com/users/mallorybowes/following{/other_user}","gists_url":"https://api.github.com/users/mallorybowes/gists{/gist_id}","starred_url":"https://api.github.com/users/mallorybowes/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/mallorybowes/subscriptions","organizations_url":"https://api.github.com/users/mallorybowes/orgs","repos_url":"https://api.github.com/users/mallorybowes/repos","events_url":"https://api.github.com/users/mallorybowes/events{/privacy}","received_events_url":"https://api.github.com/users/mallorybowes/received_events","type":"User","site_admin":false},"created_at":"2016-12-22T18:29:29Z","updated_at":"2016-12-22T18:29:29Z","body":"Just wanted to add that I've confirmed the MissingTableException error message on my install but have not seen the MissingControllerException error.  \r\n\r\nI figured out a workaround to get the server working but tbh, I'm not a dba so the subtlety of what I changed may stick out to someone who knows a bit more about MySQL.  From what I can tell, this workaround will still work for FULLTEXT indexing but YMMV.  \r\n\r\nIt looks like the problem is the MYSQL.sql file included in the MISP installation and the version of MySQL installed in the default Ubuntu 14.04 image.  MySQL v5.5 is installed by default during the build process.  That version does not support FULLTEXT indexing for InnoDB tables.  \r\n\r\n1. After the docker build, I got a bash shell from the container (docker exec -it misp bash), changed to /var/www/MISP/INSTALL\r\n2. Changed the type of all the tables in the base MYSQL.sql file from InnoDB to MYISAM (cat MYSQL.sql | sed -e s/InnoDB/MYISAM/g > MYSQL-myisam.sql).  \r\n3. Loaded up the new sql file to the mysql server (mysql -u root -p misp < MYSQL-myisam.sql).  \r\n\r\nDoing that brought up the login page for the MISP server.\r\n\r\nI think the best solution here would be to upgrade the mysql server to v5.7 but I tried the instructions here (https://askubuntu.com/questions/750498/mysql-5-5-update-to-mysql-5-7) but it borked the apt repo files and only partially installed the 5.7 components.  For me, it was easier to rebuild the docker image then to try and track down the repo issues."}}
{"actor":{"display_login":"mallorybowes"}}