Newscoop install failure
  • Vote Up0Vote Down Bernhard HarrerBernhard Harrer
    Posts: 6Member
    I am absolutely new to Newscoop. Just tried tu install it on a Ubuntu 10.04 server with Plesk 11.0. I uploaded the unzipped files into a subfolder. Installation steps get smooth until the setup of the MySQL database. The datatables get created but then /newscoop/install/index.php just shows a blank page in Firefox. No further setup is possible. I tried to switch on .htaccess and also created a vhost.conf file but without success. Just a blank page ... Any ideas?
    Post edited by Bernhard Harrer at 2013-06-19 09:24:47
  • 7 Comments sorted by
  • Vote Up0Vote Down Andrey PodshivalovAndrey Podshivalov
    Posts: 1,526Member, Administrator, Sourcefabric Team
    check apache error log file
  • Vote Up0Vote Down Bernhard HarrerBernhard Harrer
    Posts: 6Member
    Nothing in Apache error.log of the server but just found an additional error.log of the vhost:
    [Mon Jun 17 19:29:15 2013] [error] [client 213....] PHP Warning:  file_exists(): open_basedir restriction in effect. File(/usr/bin/mysql) is not within the allowed path(s): (/var/www/vhosts/mysite/:/tmp/) in /var/www/vhosts/mysite/httpdocs/newscoop/bin/cli_script_lib.php on line 1403, referer: http://mysite/newscoop/install/index.php
    [Mon Jun 17 19:29:15 2013] [error] [client 213....] PHP Fatal error:  Uncaught exception 'RuntimeException' with message 'The php executable could not be found, add it to your PATH environment variable and try again' in /var/www/vhosts/mysite/httpdocs/newscoop/install/classes/CampInstallationBase.php:820\nStack trace:\n#0 /var/www/vhosts/mysite/httpdocs/newscoop/install/classes/CampInstallationBase.php(93): CampInstallationBase->saveConfiguration()\n#1 /var/www/vhosts/mysite/httpdocs/newscoop/install/classes/CampInstallation.php(96): CampInstallationBase->execute()\n#2 /var/www/vhosts/mysite/httpdocs/newscoop/install/index.php(79): CampInstallation->execute()\n#3 {main}\n  thrown in /var/www/vhosts/mysite/httpdocs/newscoop/install/classes/CampInstallationBase.php on line 820, referer: http://mysite/newscoop/install/index.php
    [Tue Jun 18 10:05:15 2013] [error] [client 213....] PHP Fatal error:  Uncaught exception 'PDOException' with message 'SQLSTATE[28000] [1045] Access denied for user 'www-data'@'localhost' (using password: NO)' in /var/www/vhosts/mysite/httpdocs/newscoop/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:36\nStack trace:\n#0 /var/www/vhosts/mysite/httpdocs/newscoop/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php(36): PDO->__construct('mysql:', NULL, NULL, Array)\n#1 /var/www/vhosts/mysite/httpdocs/newscoop/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOMySql/Driver.php(47): Doctrine\\DBAL\\Driver\\PDOConnection->__construct('mysql:', NULL, NULL, Array)\n#2 /var/www/vhosts/mysite/httpdocs/newscoop/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(348): Doctrine\\DBAL\\Driver\\PDOMySql\\Driver->connect(Array, NULL, NULL, Array)\n#3 /var/www/vhosts/mysite/httpdocs/newscoop/library/Newscoop/Doctrine/AdoDbAdapter.php(51): Doctrine\\DBAL\\Connection->connect()\n#4 /var/www/vhosts/mysite/httpdocs/newscoop/install/ in /var/www/vhosts/mysite/httpdocs/newscoop/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php on line 36, referer: http://mysite/newscoop/install/index.php
    Post edited by Bernhard Harrer at 2013-06-18 07:41:12
  • Vote Up0Vote Down Bernhard HarrerBernhard Harrer
    Posts: 6Member
    Somehow the MySQL connection is not working? But the script was able to create the datatables. Why can't it access them?
  • Vote Up0Vote Down Andrey PodshivalovAndrey Podshivalov
    Posts: 1,526Member, Administrator, Sourcefabric Team
    installation is not completed due to error:
    file_exists():
    open_basedir restriction in effect. File(/usr/bin/mysql) is not within
    the allowed path(s): (/var/www/vhosts/mysite/:/tmp/)
    Post edited by Andrey Podshivalov at 2013-06-19 09:57:38
  • Vote Up0Vote Down Bernhard HarrerBernhard Harrer
    Posts: 6Member
    I had given up on trying to install newscoop on that server and used WordPress instead of Newscoop for this project. In the meantime I got an additional server with CentOS and virtual hosts organised by WHM/CPanel. So I wanted to try installing Newscoop 4.2 again. I created the database first and then ran the installer. It created all tabels (I hope). But came up with blank page. Several errors appear:
    First Newscoop does not seem to like to be installed in a subdirectory - error log says it wants .htaccess in webroot directory - an additional line "RewriteBase /mysubdirectory/" in the rewrite base did not help. Also it looks for some 500.shtml in the webroot directory, that is not there.
    Second Newscoop seems to need to run as Apache user, I changed the "www-data" in /conf/install_conf.php lines 15 and 16 into "nobody" (CentOS Apache user). Now the error message "Forbidden - You don't have permission to access /newscoop/admin.php
    on this server." is gone but still nothing comes up. The error log now says "SoftException in Application.cpp:422: Mismatch between target UID (xxx) and UID (99) of file /home/myvirtualclient/public_html/index.php". Dispite my webroot public_html and all files and folders in it are owned by UID (99) "nobody" Newscoop tries to also somehow access UID (xxx) "myvirtualclient".
  • Vote Up0Vote Down Bernhard HarrerBernhard Harrer
    Posts: 6Member
    Got a few steps closer: First I changed all user setting back to original UID using "chown -R myvirtualclient:myvirtualclient". Second I found out that the file "/cache/prod/applicationProdProjectContainer.php" holds a copy of the database access data which, in my case, where wrong because I had changed database name and pw during my attempts to get the database installed.
    This might be something, Sourcefabric coders need to change: Check this cache file for actuality or do not hold the access data there at all...
    After fixing these to the current access data I now get what seems to be a Newscoop default page: "The website you are trying to view is currently down for maintenance. Normal service will resume shortly."
    At least something... What can I do next?
  • Vote Up0Vote Down Bernhard HarrerBernhard Harrer
    Posts: 6Member
    Forgot to mention: There are no error messages any more in CPanel error log but there is a file "error_log" in the webroot folder that now gives the error message: "PHP Warning:  PHP Startup: Unable to load dynamic library '/usr/local/lib/php/extensions/no-debug-non-zts-20090626/timezonedb.so' - /usr/local/lib/php/extensions/no-debug-non-zts-20090626/timezonedb.so: cannot open shared object file: No such file or directory in Unknown on line 0"
Add a Comment