SOLVED: Newscoop Installation 4.2.1 on a shared hosting server with Cpanel or Parallels Plesk
  • Vote Up0Vote Down Eugen LeibundgutEugen Leibundgut
    Posts: 4Member
    SOLVED: Installation 4.2.1 on a shared hosting server with Cpanel or Parallels Plesk vServer
    ***********************************************************************************************************

    (A) The solved installation problem:
    *****************************************
    Blank page after accepting sql settings (step 4 of the installation process).

    (B) Reason:
    **************
    The installation process of version 4.2.1 does not really work. We tried everything and lost a lot of time!
    It was not possible to install the version 4.2.1 on a shared hosting server.
    We got always a blank page after installation step 4 (accepting sql settings).


    (C) The solution: Install first version 4.1 an than upgrade to version 4.2.1
    ************************************************************************************


    2) Copy the file per ftp client to your directory on the server (shared hosting server)

    3) Extract the uploaded files in the directory.

    4) Set permission for the following files to 755 (only for the installation process):
       
       a) public_html/newscoop/install/index.php
       b) public_html/newscoop/index.php
       c) public_html/newscoop/admin.php

    5) Now you need the database (my sql): Database user, database name, database password
       Create this with your cPanel or Plesk.

    6) Start the installation file: public_html/newscoop/install/index.php

    7) Follow the installation steps.

    8) Now newscoop version 4.1 should work.

    9) Make a backup:
       Please first make a backup as described in the Manual and by downloading all files from your server's
       site implementation as your local copy of the current files.
       a) Zip file of the installation
       b) Database files



    The next step is to upgrade form 4.1 to 4.2.1
    *********************************************


    10) Extract the downloaded files on your local PC.

    11) Follow the installation steps as mentioned here:


    *******************************************************************************

    Upgrade Via FTP
    ***************

    Preparation:
    1) Please first make a backup as described in the Manual and by downloading all files from your server's
       site implementation as your local copy of the current files.

    2) if your site is online when starting to make this upgrade, please put a temporary index.html on your
       site folder to say that you are on maintenance process for a while. Then your process won't be seen or
       interfered by anyone else in the world.

    Upgrade process:

    1) In your FTP software open the local folder of Newscoop (newscoop/implementation/site) and you should see
       all the folders needed. Select in your ftp's local view all the other folders and files
       except not "conf", "bin", "admin-files", and "templates".

    2) Transfer selected files over your newscoop files in the server (once again only after you are sure you
       did take a backup copy of all of them). If the process is stopped by your ftp software with a complaint
       of permissions in the files index.php and admin.php, start the transferring process again without
       these admin.php and index.php.
       This last about 45-60 Minutes (depending on upload performance)

    3) Open local folder "conf" and transfer its content into the server's folder "conf" (do not replace the
       folder, only add / replace with the selected files from the local folder, leave other files in the server
       inside "conf" intact, meaning keep your "database_conf.php" there)

    4) Open local folder "bin" and transfer its content into the server's folder "bin" (do not replace the folder,
       only add / replace with the selected files from the local folder, leave other files in the server inside "bin" intact).
       Note that the folder "bin" has your backup copy if you have taken it in the beginning like the Newscoop manual guides you to do.

    5) You can check that your folder "templates" still have your personalized template files. No need to add there anything.

    6) Check the permissions of your files index.php and admin.php. You may need to give more permissions for the upgrade
       process than they have (for example 755 or 777). If the ftp software refuses to change the permissions, please remove
       these from your server side and upload there new ones from the upgrade folder open on your local view and then
       check the permissions again.

    7) Open the folder "admin-files" locally and select everything else except the folder "lang". Transfer selected files
       over your newscoop admin-files content in the server.

    8) You should be ready to go on your web browser and access the site. An automatic process of upgrading should
       start quite shortly. If you see only a blank site, you may need to check you followed exactly the guide here or
       check the index.php settings for permissions again as well. Please log in to your admin site and make sure all is
       fine there as well. You should see the new version number (the proof of upgrade) on the bottom of the admin site.

    9) Set permission for the following files to 755 (only for the installation process):
       public_html/newscoop/upgrade.php

    10) Start now the ugrade process with the browser: your-site/upgrade.php

    After the installation process finished, you will get something like this output:


    Upgrading the database from version 4.1.x, roll 2013-01-23...
    * importing database roll 4.1.x / 2013-02-06
    * importing database roll 4.1.x / 2013-04-12
    * importing database roll 4.1.x / 2013-04-22
    * importing database roll 4.2.x / 2013-02-19
    * importing database roll 4.2.x / 2013.03.06
    * importing database roll 4.2.x / 2013.05.06
    * importing database roll 4.2.x / 2013.05.28
    * importing database roll 4.2.x / 2013.05.29
    * importing database roll 4.2.x / 2013.06.13
    * importing database roll 4.2.x / 2013.10.24
    finished
    Administration


    Click to Administration an here we go!
    You can login with your admin password.


    11) Check the upgraded version after login under the menu "help".
    Now you should see version 4.2.1.



    Important hint:
    ****************
    8 files can not be copied with ftp client (see screenschot image).
    Maybe these fiels are corrupt.
    The plugin files are needed in the following directories:

    - plugins/poll/admin-files/lang/cz
    - plugins/poll/admin-files/lang/by
    - plugins/poll/admin-files/lang/ge
    - plugins/poll/admin-files/lang/kr

    - plugins/recaptcha/admin-files/lang/cz
    - plugins/recaptcha/admin-files/lang/by
    - plugins/recaptcha/admin-files/lang/ge
    - plugins/recaptcha/admin-files/lang/kr


    Unfortunately i did not find a solution for this problem.


    If something goes wrong anyway
    ******************************
    1) Take first your local copy of newscoop files that you saved in the preparation step 1 and transfer them back
       to your server. Check if that brought back the site like it was before the upgrade procedure.

    2) Read this upgrade guide again and make notes if anything was made differently than adviced. If so, try to make
       the upgrade again learning from the mistakes in the first attempt.

    3) If something still goes wrong or you do not see what could have been made wrong, check your server error logs
       and permissions once again. Look if any folder or file looks corrupted by the upload process in the server.
    4) If all above is not helping, look the answers in the forum or make your own question there. Please give as much
       as possible information about your steps regarding the upgrade and the error messages you may have got.
  • 1 Comment sorted by
  • Vote Up0Vote Down Andrei S.Andrei S.
    Posts: 117Member
    Start mysite/upgrade.php

    Newscoop has encountered a problem.

    Please take a minute to send us an email.

    Simply copy and paste the error report below and send it to: newscoop-bug@sourcefabric.org.

    Thank you.


    Error Report


    Error ID: 2:Newscoop:4.2.3:cli_script_lib.php:650
    Error String: mysql_select_db() [function.mysql-select-db]: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
    Time: Thu, 05 Jun 2014 17:05:27 +0400
    Backtrace: {closure}() called at [:]
    mysql_select_db() called at [/var/www/vhosts/21/119915/webspace/httpdocs/nc_test/bin/cli_script_lib.php:650]
    camp_detect_database_version() called at [/var/www/vhosts/21/119915/webspace/httpdocs/nc_test/upgrade.php:124]


Add a Comment