[Loris-dev] database problem - local installation of LORIS

[Hohenfeld, Christian]

Hi Patrik, 

I am not one of the Loris devs, but my best guess would be that the permissions are not set correctly. Did you make sure that the /var/www/TestProject/project/ directory is accessible and writeable for your loris user *and* the apache2 group (www-data)? The same should be true for the config.xml file. 

Best regards
Christian  



> Am 16.08.2017 um 13:05 schrieb Patrik Andersson <patrik.andersson at ling.su.se>:
> 
> 
> Thank you for the help! 
> I am not sure what was wrong, but after a thorough reinstallation of mysql it seems to work. I had already tried to reinstall it, but it seems I needed to manually delete some files that kept some settings.
> 
> However, after creating the mysql accounts I get stuck again...
> 
> I can not access localhost. I get:
>  
> "localhost is currently unable to handle this request.
> HTTP ERROR 500"
> 
> I have tried to restart Apache which did not help.
> 
> Looking at the PHP log, it says:
> 
> [16-Aug-2017 11:47:11 Europe/Berlin] PHP Warning:  simplexml_load_file(): /var/www/TestProject/php/libraries/../../project/config.xml:1: parser error : Document is empty in /var/www/TestProject/php/libraries/NDB_Config.class.inc on line 108
> [16-Aug-2017 11:47:11 Europe/Berlin] PHP Warning:  simplexml_load_file():  in /var/www/TestProject/php/libraries/NDB_Config.class.inc on line 108
> [16-Aug-2017 11:47:11 Europe/Berlin] PHP Warning:  simplexml_load_file(): ^ in /var/www/TestProject/php/libraries/NDB_Config.class.inc on line 108
> [16-Aug-2017 11:47:11 Europe/Berlin] PHP Fatal error:  Uncaught Exception: Could not load Loris config file /var/www/TestProject/php/libraries/../../project/config.xml in /var/www/TestProject/php/libraries/NDB_Config.class.inc:111
> Stack trace:
> #0 /var/www/TestProject/php/libraries/NDB_Config.class.inc(92): NDB_Config->load('/var/www/TestPr...')
> #1 /var/www/TestProject/php/libraries/NDB_Factory.class.inc(118): NDB_Config::singleton('/var/www/TestPr...')
> #2 /var/www/TestProject/php/libraries/NDB_Client.class.inc(54): NDB_Factory->config(NULL)
> #3 /var/www/TestProject/htdocs/main.php(29): NDB_Client->initialize()
> #4 {main}
>   thrown in /var/www/TestProject/php/libraries/NDB_Config.class.inc on line 111
> 
> The config.xml file is indeed empty. Should it be?
> Any suggestions for what to do?
> Thanks again for your time!!
> 
> Best,
> Patrik
> 
> 
> 
> From: Shen Wang <wangshen.mcin at gmail.com>
> Sent: 14 August 2017 16:21
> Cc: Patrik Andersson; loris-dev at bic.mni.mcgill.ca
> Subject: Re: [Loris-dev] database problem - local installation of LORIS
>  
> Hi Patrik,
> I tested the installation guide last month, It works well.
> Please try this https://github.com/aces/Loris/wiki/Installing-Loris-in-Brief 
> or 
> reset your root password then try it again.
> You can access my new Loris on http://132.206.37.22.
> (https://github.com/aces/Loris/archive/v17.0.5.zip PHP 7.1 Mysql 5.7  Ubuntu 16.04.3 LTS)
> 
> Shen
> 
> 
> 
> On 10 August 2017 at 17:02, Christine Rogers <christine.rogers at mcgill.ca> wrote:
> Hi Patrik,
> Thanks for your question. 
> Could you clarify for context -- 
> Which version of MySQL do you have installed?  Is it locally installed on the Ubuntu partition?  
> Does your root/password credential you provided successfully log you into MySQL (trying from the commandline)?   
> Best, 
> Christine 
> on behalf of the Loris team
> 
> 
> On Wed, Aug 9, 2017 at 7:59 AM, Patrik Andersson <patrik.andersson at ling.su.se> wrote:
> ​Hi all,
> 
> I am trying to install LORIS on my desktop to test things out. I have installed Ubuntu 16.04 (dual boot with Windows 10) for this purpose. For this LORIS test I would like to have all parts on the same computer. 
> I have managed to get as far as trying to install the database, but here I have run into problem. I should point out that I'm normally working with neuroscience and in other words, I am far outside my comfort zone...
> I'm trying to follow the instructions at https://github.com/aces/Loris/wiki/Hosting-the-Database-Myself, but
> when submitting the information on http://localhost/installdb.php I get a message 
> "Could not connect to MySQL server and create database with credentials provided.".
> I used the following details:
> Server Hostname: localhost
> Admin Username: root
> Admin Password: •••••••••••••
> Database name: LORIS
> 
> I have enabled the root user, in case that matters.
> Any ideas or suggestions of where I have screwed things up? With my lack of knowledge on these things I realize it can be something really trivial or obvious. 
> 
> Thanks!
> Patrik
> 
> _______________________________________________
> Loris-dev mailing list
> Loris-dev at bic.mni.mcgill.ca
> http://www.bic.mni.mcgill.ca/mailman/listinfo/loris-dev
> 
> 
> 
> 
> -- 
> 
> christine.rogers at mcgill.ca
> McGill Centre for Integrative Neuroscience | MCIN.ca
> Montreal Neurological Institute
> McGill University | Montreal | Canada
> 
> _______________________________________________
> Loris-dev mailing list
> Loris-dev at bic.mni.mcgill.ca
> http://www.bic.mni.mcgill.ca/mailman/listinfo/loris-dev
> 
> 
> _______________________________________________
> Loris-dev mailing list
> Loris-dev at bic.mni.mcgill.ca
> http://www.bic.mni.mcgill.ca/mailman/listinfo/loris-dev