{"action":"created","issue":{"url":"https://api.github.com/repos/Jalle19/xbmc-video-server/issues/225","labels_url":"https://api.github.com/repos/Jalle19/xbmc-video-server/issues/225/labels{/name}","comments_url":"https://api.github.com/repos/Jalle19/xbmc-video-server/issues/225/comments","events_url":"https://api.github.com/repos/Jalle19/xbmc-video-server/issues/225/events","html_url":"https://github.com/Jalle19/xbmc-video-server/issues/225","id":66027450,"number":225,"title":"Cannot create initial database","user":{"login":"godfuture","id":4669278,"avatar_url":"https://avatars.githubusercontent.com/u/4669278?v=3","gravatar_id":"","url":"https://api.github.com/users/godfuture","html_url":"https://github.com/godfuture","followers_url":"https://api.github.com/users/godfuture/followers","following_url":"https://api.github.com/users/godfuture/following{/other_user}","gists_url":"https://api.github.com/users/godfuture/gists{/gist_id}","starred_url":"https://api.github.com/users/godfuture/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/godfuture/subscriptions","organizations_url":"https://api.github.com/users/godfuture/orgs","repos_url":"https://api.github.com/users/godfuture/repos","events_url":"https://api.github.com/users/godfuture/events{/privacy}","received_events_url":"https://api.github.com/users/godfuture/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":null,"milestone":null,"comments":5,"created_at":"2015-04-02T22:59:51Z","updated_at":"2015-04-20T08:10:55Z","closed_at":"2015-04-20T08:10:55Z","body":"I initially tried to setup xbmc-video-server and stuck at creating the schema in mysql. Closely every step in readme seemed to work:\r\n```\r\nsudo su \r\napt-get install libapache2-mod-php5 php5-gd php5-cli php5-sqlite php5-json php5-gd git curl\r\na2enmod rewrite expires\r\nservice apache2 restart\r\ncd /var/www/html\r\ngit clone git://github.com/Jalle19/xbmc-video-server.git\r\ncd xbmc-video-server\r\ncurl -sS https://getcomposer.org/installer | php\r\nphp composer.phar install\r\n```\r\nbut the next one (initial database creation)\r\n```\r\n./src/protected/yiic createinitialdatabase\r\n```\r\nfails in unknown command error\r\n```\r\nmyuser@myserver:/var/www/xbmc-video-server$ sudo ./src/protected/yiic createinitialdatabase\r\n```\r\nI suspected file permissions and changed it from apache user to root. I have used the full path instead of from current dir.\r\n\r\nWhat could be the reason?\r\n\r\nOS: ubuntu server 14.10\r\nxvs: 1.6.11"},"comment":{"url":"https://api.github.com/repos/Jalle19/xbmc-video-server/issues/comments/94388473","html_url":"https://github.com/Jalle19/xbmc-video-server/issues/225#issuecomment-94388473","issue_url":"https://api.github.com/repos/Jalle19/xbmc-video-server/issues/225","id":94388473,"user":{"login":"Jalle19","id":1106133,"avatar_url":"https://avatars.githubusercontent.com/u/1106133?v=3","gravatar_id":"","url":"https://api.github.com/users/Jalle19","html_url":"https://github.com/Jalle19","followers_url":"https://api.github.com/users/Jalle19/followers","following_url":"https://api.github.com/users/Jalle19/following{/other_user}","gists_url":"https://api.github.com/users/Jalle19/gists{/gist_id}","starred_url":"https://api.github.com/users/Jalle19/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Jalle19/subscriptions","organizations_url":"https://api.github.com/users/Jalle19/orgs","repos_url":"https://api.github.com/users/Jalle19/repos","events_url":"https://api.github.com/users/Jalle19/events{/privacy}","received_events_url":"https://api.github.com/users/Jalle19/received_events","type":"User","site_admin":false},"created_at":"2015-04-20T08:10:55Z","updated_at":"2015-04-20T08:10:55Z","body":"The `yiic` script is executable by default, you shouldn't have to make it executable yourself. There is an issue that I encounter from time to time though if you use Samba to share the directory where your files are located. In that case Samba often overwrites the permissions set by the underlying filesystem which may remove the executable bit from the script. I've modified the installation instructions on the wiki to call `php ./src/protected/yiic.php` instead of just `./src/protected/yiic`, that way it doesn't matter if the file is executable or not.\r\n\r\nI should probably add a small guide on how to use MySQL to the wiki, I've never used it myself for this application so I've never bothered."}}