{"action":"created","issue":{"url":"https://api.github.com/repos/photo/frontend/issues/1572","labels_url":"https://api.github.com/repos/photo/frontend/issues/1572/labels{/name}","comments_url":"https://api.github.com/repos/photo/frontend/issues/1572/comments","events_url":"https://api.github.com/repos/photo/frontend/issues/1572/events","html_url":"https://github.com/photo/frontend/issues/1572","id":64668027,"number":1572,"title":"setup-hangs-fails-at-final-step-3","user":{"login":"dkebler","id":1316185,"avatar_url":"https://avatars.githubusercontent.com/u/1316185?v=3","gravatar_id":"","url":"https://api.github.com/users/dkebler","html_url":"https://github.com/dkebler","followers_url":"https://api.github.com/users/dkebler/followers","following_url":"https://api.github.com/users/dkebler/following{/other_user}","gists_url":"https://api.github.com/users/dkebler/gists{/gist_id}","starred_url":"https://api.github.com/users/dkebler/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/dkebler/subscriptions","organizations_url":"https://api.github.com/users/dkebler/orgs","repos_url":"https://api.github.com/users/dkebler/repos","events_url":"https://api.github.com/users/dkebler/events{/privacy}","received_events_url":"https://api.github.com/users/dkebler/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":9,"created_at":"2015-03-27T01:06:53Z","updated_at":"2015-05-09T03:39:14Z","closed_at":null,"body":"Having the same problem as this person\r\nhttp://superuser.com/questions/777811/trovebox-openphoto-setup-hangs-fails-at-final-step-3\r\n\r\nFollowed all the advice.  Yours, the \"good\" answer.\r\n\r\nUsed your 3 minute script on ubuntu 14.04 with latest Apache and Php5.\r\nPhpinfo confirms mcrypt loaded.\r\nownership good on three directories set in script\r\nall good with databse,  recreated it and user to be sure. \r\n(have serveral other mysql/php based installs including recent wordpress)\r\n\r\nFrom apache logs:Doesn't seem to be getting the info from put in to page 2.\r\nNo errors in mysql log because of missing variable values I suppose\r\n```\r\n[Fri Mar 27 00:54:07.111737 2015] [:error] [pid 17430] [client 75.142.157.70:35005] PHP Notice:  Undefined variable: mySqlHost in /var/www/openphoto/src/templates/setup.php on line 99, referer: http://photos.duranguito.org/setup/2\r\n[Fri Mar 27 00:54:07.111770 2015] [:error] [pid 17430] [client 75.142.157.70:35005] PHP Notice:  Undefined variable: mySqlUser in /var/www/openphoto/src/templates/setup.php on line 102, referer: http://photos.duranguito.org/setup/2\r\n[Fri Mar 27 00:54:07.111784 2015] [:error] [pid 17430] [client 75.142.157.70:35005] PHP Notice:  Undefined variable: mySqlPassword in /var/www/openphoto/src/templates/setup.php on line 105, referer: http://photos.duranguito.org/setup/2\r\n[Fri Mar 27 00:54:07.111798 2015] [:error] [pid 17430] [client 75.142.157.70:35005] PHP Notice:  Undefined variable: mySqlDb in /var/www/openphoto/src/templates/setup.php on line 108, referer: http://photos.duranguito.org/setup/2\r\n[Fri Mar 27 00:54:07.111811 2015] [:error] [pid 17430] [client 75.142.157.70:35005] PHP Notice:  Undefined variable: mySqlTablePrefix in /var/www/openphoto/src/templates/setup.php on line 111, referer: http://photos.duranguito.org\r\n```\r\n\r\n"},"comment":{"url":"https://api.github.com/repos/photo/frontend/issues/comments/100420762","html_url":"https://github.com/photo/frontend/issues/1572#issuecomment-100420762","issue_url":"https://api.github.com/repos/photo/frontend/issues/1572","id":100420762,"user":{"login":"russmac","id":5924967,"avatar_url":"https://avatars.githubusercontent.com/u/5924967?v=3","gravatar_id":"","url":"https://api.github.com/users/russmac","html_url":"https://github.com/russmac","followers_url":"https://api.github.com/users/russmac/followers","following_url":"https://api.github.com/users/russmac/following{/other_user}","gists_url":"https://api.github.com/users/russmac/gists{/gist_id}","starred_url":"https://api.github.com/users/russmac/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/russmac/subscriptions","organizations_url":"https://api.github.com/users/russmac/orgs","repos_url":"https://api.github.com/users/russmac/repos","events_url":"https://api.github.com/users/russmac/events{/privacy}","received_events_url":"https://api.github.com/users/russmac/received_events","type":"User","site_admin":false},"created_at":"2015-05-09T03:39:14Z","updated_at":"2015-05-09T03:39:14Z","body":"The setup script does not enable mycrpt.so , (fixed)\r\n\r\nWith the DB user in question having complete access. setup fails.\r\n\r\n\"127.0.0.1           | root             | *0F95AFF51C9ACE907CA57DAEB3404D97675A0117 | Y           | Y           | Y           | Y           | Y           | Y         | Y           | Y             | Y            | Y         | Y          | Y               | Y          | Y          | Y            | Y          | Y                     | Y                | Y            | Y               | Y                | Y                | Y              | Y                   | Y                  | Y                | Y \"\r\n\r\n\r\nThe database setup, appears to fails due to the user table not existing. Before its actually created.\r\n\r\n\"Table 'photos.user' doesn't exist - SELECT * FROM `user` WHERE `id`=:owner '\"\r\n\r\n[Sat May 09 03:32:20.921745 2015] [:error] [pid 26625] [client 10.0.0.7:17986] PHP Fatal error:  Uncaught exception 'EpiDatabaseQueryException' with message 'Query error: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'photos.user' doesn't exist - SELECT * FROM `user` WHERE `id`=:owner ' in /var/www/openphoto/src/libraries/external/epi/EpiException.php:13\\nStack trace:\\n#0 /var/www/openphoto/src/libraries/external/epi/EpiDatabase.php(120): EpiException::raise(Object(EpiDatabaseQueryException))\\n#1 /var/www/openphoto/src/libraries/external/epi/EpiDatabase.php(79): EpiDatabase->prepare('SELECT * FROM `...', Array)\\n#2 /var/www/openphoto/src/libraries/adapters/DatabaseMySql.php(922): EpiDatabase->one('SELECT * FROM `...', Array)\\n#3 /var/www/openphoto/src/libraries/models/User.php(246): DatabaseMySql->getUser('russmac@interno...')\\n#4 /var/www/openphoto/src/libraries/models/User.php(159): User->getUserByEmail('private@interno...')\\n#5 /var/www/openphoto/src/html/assets/themes/fabrizio1.0/templates/partials/titles.php(9): User->getNameFromEmail('russmac@interno...')\\n#6 /var/www/openphoto/src/libraries/ex in /var/www/openphoto/src/libraries/external/epi/EpiException.php on line 13, referer: http://photo.private.net/setup/3\r\n\r\nIve been looking everywhere for some SQL to create it manually."}}