[Loris-dev] database problem - local installation of LORIS
Patrik Andersson
patrik.andersson at ling.su.se
Wed Aug 16 08:16:07 EDT 2017
Thanks a lot Christian!
The permissions are as follows:
$ sudo ls -la /var/www/TestProject/project/
total 32
drwxrwx--- 8 root www-data 4096 aug 15 15:16 .
drwxr-xr-x 13 lorisadmin lorisadmin 4096 aug 8 14:51 ..
-rw-r--r-- 1 www-data www-data 0 aug 15 15:16 config.xml
drwxr-xr-x 2 root root 4096 aug 8 12:13 data
drwxr-xr-x 2 root root 4096 aug 8 12:13 instruments
drwxr-xr-x 2 root root 4096 aug 8 12:13 libraries
drwxr-xr-x 2 root root 4096 aug 8 12:13 modules
drwxr-xr-x 2 root root 4096 aug 8 12:13 tables_sql
drwxr-xr-x 2 root root 4096 aug 8 12:13 templates
lorisadmin is, as you might guess, the unix user.
Is there a problem here as you see it?
Thanks for taking the time to help a beginner!
Best,
Patrik
________________________________________
From: Hohenfeld, Christian <chohenfeld at ukaachen.de>
Sent: 16 August 2017 13:38
To: Patrik Andersson
Cc: loris-dev at bic.mni.mcgill.ca
Subject: Re: [Loris-dev] database problem - local installation of LORIS
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
More information about the Loris-dev
mailing list