[Loris-dev] LORIS installation inquiry -- regarding
Dave MacFarlane
dave.macfarlane at mcin.ca
Wed Aug 14 08:50:17 EDT 2019
Hi Yubu,
The error log says that the account 'root'@'localhost' can't connect. Are
you sure you're providing
valid credentials and not making a typo in the password? Have you tried the
account from the MySQL
command line on the same server that Apache is running on?
I just tried putting in incorrect credentials for myself and got a blank
page with the same seemingly
unrelated error message about "Call to a member function exec() on null",
so I'm fairly sure that the
account access is the root of the problem.
On Tue, Aug 13, 2019 at 8:43 PM Shen Wang <wangshen.mcin at gmail.com> wrote:
> Hi Yubu,
> I saw you error log, it is very helpful. It seems like you didn't create
> the config.xml in you project folder successfully.
> You need to run this [sudo ./install.sh ] in the tools folder. ex. [
> install at install-dev:/var/www/Loris/tools$ sudo ./install.sh]
> Then check if project/confilg.xml file exists. if it can't create the
> project folder and config.xml, it is definitely your ubuntu permission
> issue.
> Please do it manually in your loris folder. sudo chgrp apache project sudo
> chmod 770 project
>
> Then you need to do [sudo ./install.sh ] , then load the installdb.php
> again.
> Please let me know if you have any questions.
> Regards.
> Shen
>
> On Tue, 13 Aug 2019 at 20:16, 이유부 <basilia1123 at gmail.com> wrote:
>
>> Dear Shen,
>>
>>
>> 1 Which version of Loris are you using?
>> We are using Loris-21.0.0
>>
>> 2 Mysql version?
>> The output of mysql -V is
>> mysql Ver 14.14 Distrib 5.7.27, for Linux (x86_64) using EditLine
>> wrapper
>>
>> 3 [sudo tail -f /var/log/apache2/loris-error.log] Please running this
>> in the backend,
>> then try loading the installdb.php again, with a different database
>> name. Please send us the error message.
>>
>> cat loris-error.log does not show any content however loris-error.log.1
>> shows the following:
>>
>> yubu at data:/var/log/apache2$ cat loris-error.log.1
>>
>> [Tue Aug 13 09:12:41.214417 2019] [php7:error] [pid 17930] [client
>> ::1:58960] PHP Fatal error: Uncaught ConfigurationException: Config file
>> config.xml does not exist in the defined locations. in
>> /var/www/loris/php/libraries/NDB_Config.class.inc:139\nStack trace:\n#0
>> /var/www/loris/php/libraries/NDB_Config.class.inc(66):
>> NDB_Config->configFilePath()\n#1
>> /var/www/loris/php/libraries/NDB_Factory.class.inc(118):
>> NDB_Config::singleton(NULL)\n#2
>> /var/www/loris/php/libraries/NDB_Client.class.inc(54):
>> NDB_Factory->config(NULL)\n#3 /var/www/loris/htdocs/index.php(27):
>> NDB_Client->initialize()\n#4 {main}\n thrown in
>> /var/www/loris/php/libraries/NDB_Config.class.inc on line 139, referer:
>> http://localhost/installdb.php
>>
>> [Tue Aug 13 09:14:53.843582 2019] [php7:notice] [pid 17932] [client
>> ::1:58992] SQLSTATE[HY000] [1698] Access denied for user 'root'@'localhost',
>> referer: http://localhost/installdb.php
>> [Tue Aug 13 09:14:53.843708 2019] [php7:error] [pid 17932] [client
>> ::1:58992] PHP Fatal error: Uncaught Error: Call to a member function
>> exec() on null in
>> /var/www/loris/php/installer/Installer.class.inc:374\nStack trace:\n#0
>> /var/www/loris/php/installer/Installer.class.inc(235):
>> LORIS\\Installer\\Installer->_sourceSchemaFile(Object(LORIS\\Installer\\Database),
>> '00-schema.sql')\n#1 /var/www/loris/htdocs/installdb.php(109):
>> LORIS\\Installer\\Installer->sourceSchema(Array)\n#2 {main}\n thrown in
>> /var/www/loris/php/installer/Installer.class.inc on line 374, referer:
>> http://localhost/installdb.php
>>
>> Further, we accidentally deleted the loris-error.log and
>> loris-error.log.1 files. Is there a way to generate them again?
>>
>> Thanks for the prompt reply
>>
>> Yours Sincerely,
>>
>> ======================================================
>>
>> Yubu Lee, Ph.D.
>>
>> Research Professor,
>>
>> Center for Neuroscience Imaging Research, Institute for Basic Science
>>
>>
>> #86332, N Center, SungKyunKwan University
>> 2066, Seobu-Ro, Jangan-gu, Suwon, Gyeonggi-do, 16419, Korea
>>
>> E-mail: basilia1123 at gmail.com
>>
>> Tel: +82-31-299-4411
>>
>> Fax: +82-31-299-4506
>>
>> ======================================================
>>
>>
>> 2019년 8월 13일 (화) 오후 10:21, Shen Wang <wangshen.mcin at gmail.com>님이 작성:
>>
>>> Hi Yubu,
>>> We need more information to debug this issue.
>>> 1 Which version of Loris are you using?
>>> 2 Mysql version?
>>> 3 [sudo tail -f /var/log/apache2/loris-error.log] Please running this
>>> in the backend,
>>> then try loading the installdb.php again, with a different database
>>> name. Please send us the error message.
>>>
>>> Your Sincerely,
>>> Shen
>>>
>>> On Mon, 12 Aug 2019 at 22:27, 이유부 <basilia1123 at gmail.com> wrote:
>>>
>>>> Dear Sir/Madam,
>>>>
>>>> We are currently trying to install LORIS on Ubuntu 18.04 platform
>>>> following the steps from
>>>> https://github.com/aces/Loris/wiki/Installing-Loris-in-Depth
>>>>
>>>> 1. Following the above link, we installed the prerequisites mentioned
>>>> in
>>>> https://github.com/aces/Loris/wiki/Installing-Loris-in-Depth#getting-prerequisites,
>>>> which are all verified to be installed normally.
>>>>
>>>> 2. We ensured that mySQL credentials are set up properly (as pasted
>>>> below)
>>>> mysql> select host, user, authentication_string from user
>>>> -> ;
>>>>
>>>> +-----------+------------------+-------------------------------------------+
>>>> | host | user | authentication_string
>>>> |
>>>>
>>>> +-----------+------------------+-------------------------------------------+
>>>> | localhost | root |
>>>> |
>>>> | localhost | mysql.session |
>>>> *THISISNOTAVALIDPASSWORDTHATCANBEUSEDHERE |
>>>> | localhost | mysql.sys |
>>>> *THISISNOTAVALIDPASSWORDTHATCANBEUSEDHERE |
>>>> | localhost | debian-sys-maint |
>>>> *C9BF7C6E59BFF0FA879E6650D174264C9EE87F25 |
>>>>
>>>> +-----------+------------------+-------------------------------------------+
>>>> 4 rows in set (0.00 sec)
>>>>
>>>> mysql> update user set authentication_string=password('yubu') where
>>>> user='root';
>>>> Query OK, 1 row affected, 1 warning (0.00 sec)
>>>> Rows matched: 1 Changed: 1 Warnings: 1
>>>>
>>>> mysql> flush privileges;
>>>> Query OK, 0 rows affected (0.01 sec)
>>>>
>>>> mysql> select host, user, authentication_string from user
>>>> -> ;
>>>>
>>>> +-----------+------------------+-------------------------------------------+
>>>> | host | user | authentication_string
>>>> |
>>>>
>>>> +-----------+------------------+-------------------------------------------+
>>>> | localhost | root |
>>>> *E311E16EECE7E8900098CFEB4103D5266A343F5F |
>>>> | localhost | mysql.session |
>>>> *THISISNOTAVALIDPASSWORDTHATCANBEUSEDHERE |
>>>> | localhost | mysql.sys |
>>>> *THISISNOTAVALIDPASSWORDTHATCANBEUSEDHERE |
>>>> | localhost | debian-sys-maint |
>>>> *C9BF7C6E59BFF0FA879E6650D174264C9EE87F25 |
>>>>
>>>> +-----------+------------------+-------------------------------------------+
>>>> 4 rows in set (0.00 sec)
>>>>
>>>> 3. We then opened http://localhost/installdb.php and have gotten the
>>>> login page for LORIS installation and typed the credentials as follows:
>>>> [image: Screenshot from 2019-08-13 09-14-51.png]
>>>> 4. Once we submitted the page we obtained error as follows
>>>>
>>>> [image: Screenshot from 2019-08-13 09-14-56.png]
>>>>
>>>>
>>>>
>>>> We really do not know how to proceed further from this point onward.
>>>> Kindly let us know how to proceed further in order to get the LORIS
>>>> installed.
>>>>
>>>> Thank you.
>>>>
>>>> Your Sincerely,
>>>>
>>>> ======================================================
>>>>
>>>> Yubu Lee, Ph.D.
>>>>
>>>> Research Professor,
>>>>
>>>> Center for Neuroscience Imaging Research, Institute for Basic Science
>>>>
>>>>
>>>> #86332, N Center, SungKyunKwan University
>>>> 2066, Seobu-Ro, Jangan-gu, Suwon, Gyeonggi-do, 16419, Korea
>>>>
>>>> E-mail: basilia1123 at gmail.com
>>>>
>>>> Tel: +82-31-299-4411
>>>>
>>>> Fax: +82-31-299-4506
>>>>
>>>> ======================================================
>>>> _______________________________________________
>>>> Loris-dev mailing list
>>>> Loris-dev at bic.mni.mcgill.ca
>>>> https://mailman.bic.mni.mcgill.ca/mailman/listinfo/loris-dev
>>>>
>>>
>>>
>>> --
>>> Shen Wang
>>> Loris <https://github.com/aces/Loris> Developer
>>> Montreal Neurological Institute
>>> McGill University
>>>
>>>
>
> --
> Shen Wang
> Loris <https://github.com/aces/Loris> Developer
> Montreal Neurological Institute
> McGill University
>
> _______________________________________________
> Loris-dev mailing list
> Loris-dev at bic.mni.mcgill.ca
> https://mailman.bic.mni.mcgill.ca/mailman/listinfo/loris-dev
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mailman.bic.mni.mcgill.ca/pipermail/loris-dev/attachments/20190814/30ea0103/attachment-0001.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: Screenshot from 2019-08-13 09-14-51.png
Type: image/png
Size: 283124 bytes
Desc: not available
URL: <http://mailman.bic.mni.mcgill.ca/pipermail/loris-dev/attachments/20190814/30ea0103/attachment-0002.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: Screenshot from 2019-08-13 09-14-56.png
Type: image/png
Size: 124916 bytes
Desc: not available
URL: <http://mailman.bic.mni.mcgill.ca/pipermail/loris-dev/attachments/20190814/30ea0103/attachment-0003.png>
More information about the Loris-dev
mailing list