[Loris-dev] Error with Loris

[Christine Rogers]

Hi Iris,
Thanks for your inquiry.  I'm copying the loris-dev community mailing list
in case of any other users who may have encountered this question for
CentOS or with the install script.

Note that for CentOS installations of LORIS, there is a separate CentOS
readme <https://github.com/aces/Loris/blob/16.1-dev/README.CentOS6.md> which
recommends not using the install script, and consulting with an experienced
sysadmin.

In general / for Ubuntu systems, here's what to do if you encounter this
error when running the main Loris install script:

> Attempting to create and grant privileges to MySQL user 'lorisuser'@'$yourdatabase'
...
> Could not connect to database with lorisadmin user provided.

Notice that the install script is attempting to connect to the MySQL
database using the "lorisadmin" user.  This is likely the wrong credential,
since "lorisadmin" is the recommended name for your Unix admin-level user
account.

This probably occurred because at prompt #8 for the install script,
"lorisadmin" was entered.
Prompt 8 asks for:

8) Credentials of an existing MySQL account with root or superuser
privileges,
capable of creating the database, or installing the schema,
or creating users on the given database.
This will only be used to create the database, install the schema,
and/or create and grant privileges to the "lorisuser" MySQL user.


Instead, type "root" or the name of your MySQL account that has privileges
to create a MySQL database and further MySQL users.

Best,
Christine

--
LORIS data systems | loris.ca
McGill Centre for Integrative Neuroscience| MCIN.ca
McConnell Brain Imaging Centre
Montreal Neurological Institute
McGill University | Montreal | Canada



On Tue, Aug 30, 2016 at 4:29 PM, Iris Rodríguez Gil <
iris.rodriguez at cneuro.edu.cu> wrote:
>
> Hi Christine,
>
> I work in the neurosciences center of Cuba and would refuse Loris tool in
my work environment.
>
>
>
> I'm starting with the installation of LORIS 16.0.1 in a local
environment, with the following requirements:
>
> Linux Centos 6.5 VM, I followed the instructions in the installation
guide but when I start to install I get the following error:
>
>
>
> Attempting to create and grant privileges to MySQL user 'lorisuser'@'nodo01'
...
>
> Could not connect to database with lorisadmin user provided.
>
> please take several days trying to solve it, any help is important to me.
>
>
>
> Best regards,
>
> Iris.
>
>
>
>
>
> De: loris-dev-bounces at bic.mni.mcgill.ca [mailto:
loris-dev-bounces at bic.mni.mcgill.ca] En nombre de Christine Rogers
> Enviado el: jueves, 25 de agosto de 2016 13:37
> Para: Tom Beaudry
> CC: loris-dev at bic.mni.mcgill.ca
> Asunto: Re: [Loris-dev] mutliple PSCID per subject?
>
>
>
> Hi Tom,
>
> Thanks for your question.  Loris isn't set up for multiple PSCIDs for a
given individual, as the candidate table in the database schema has one
field for PSCID and one field for CandID (the 6-digit random numerical
DCCID).
>
>
>
> There are a few options for adding extra ID fields that can be used in
addition the PSCID, for a given candidate record.  The candidate table's
ExternalID field can be used for this purpose.  Additional ID fields can
also be added through the Candidate Parameters module/tables.  Study
personnel can then manually enter this ID field through the Candidate
Information page.
>
>
>
> Best,
>
> Christine
>
>
>
>
>
> On Thu, Aug 25, 2016 at 2:19 PM, Tom Beaudry <waveflux at gmail.com> wrote:
>
> Hi guys!
>
>
>
> Can you tell me if LORIS is currently setup to have multiple PSCID per
subject?    I know that you can have multiple projects enabled, I am just
wondering what type of identifiers would you get.
>
>
>
> Thanks,
>
> Tom
>
>
> _______________________________________________
> 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
> LORIS data systems | loris.ca
> McGill Centre for Integrative Neuroscience| MCIN.ca
>
> McConnell Brain Imaging Centre
> Montreal Neurological Institute
>
> McGill University | Montreal | Canada
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.bic.mni.mcgill.ca/pipermail/loris-dev/attachments/20160830/4598e3df/attachment.html>