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

Wed Aug 16 07:05:59 EDT 2017

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<mailto: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<mailto: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<mailto:Loris-dev at bic.mni.mcgill.ca>
http://www.bic.mni.mcgill.ca/mailman/listinfo/loris-dev

--

christine.rogers at mcgill.ca<mailto: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<mailto:Loris-dev at bic.mni.mcgill.ca>
http://www.bic.mni.mcgill.ca/mailman/listinfo/loris-dev

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.bic.mni.mcgill.ca/pipermail/loris-dev/attachments/20170816/ffce49e7/attachment.html>