<div dir="ltr"><div>How do i delete a Study? And everytime do i have to create a new candidate to get DCCID and a PSCID?</div><div><br></div><div><b>First execution:</b></div><div><br></div><div>(loris-mri-python) lorisadmin@loris-VirtualBox:/data/loris/bin/mri$ ./<a href="http://batch_uploads_imageuploader.pl">batch_uploads_imageuploader.pl</a> -profile prod < ~/Desktop/input.txt > log.txt<br>Use of uninitialized value $_ in pattern match (m//) at ./<a href="http://batch_uploads_imageuploader.pl">batch_uploads_imageuploader.pl</a> line 144.<br>DBD::mysql::db do failed: Cannot add or update a child row: a foreign key constraint fails (`LORIS`.`candidate`, CONSTRAINT `FK_candidate_1` FOREIGN KEY (`RegistrationCenterID`) REFERENCES `psc` (`CenterID`)) at /data/loris/bin/mri/uploadNeuroDB/NeuroDB/MRI.pm line 1060.<br>ERROR: Failed to insert record in table mri_scanner:<br>The following database commands failed:<br> PREPARE s FROM 'INSERT INTO mri_scanner (CandID,Model,Software,Serial_number,Manufacturer) VALUES (?,?,?,?,?)';<br> SET @x1='242126',@x2='Achieva',@x3='3.2.2\3.2.2.0',@x4='34037',@x5='Philips Medical Systems';<br> EXECUTE s USING @x1,@x2,@x3,@x4,@x5;<br>Error obtained:Cannot add or update a child row: a foreign key constraint fails (`LORIS`.`mri_scanner`, CONSTRAINT `FK_mri_scanner_1` FOREIGN KEY (`CandID`) REFERENCES `candidate` (`CandID`)) (error code 1452)<br><br> ERROR: The validation has failed. Either re-run the validation again and fix the problem. Or re-run tarchiveLoader.pl using -force to force the execution.<br><br><br>The tarchiveLoader.pl insertion script has failed.<br>Can't exec "mail": No such file or directory at ./<a href="http://batch_uploads_imageuploader.pl">batch_uploads_imageuploader.pl</a> line 249.<br>print() on closed filehandle MAIL at ./<a href="http://batch_uploads_imageuploader.pl">batch_uploads_imageuploader.pl</a> line 250.<br>print() on closed filehandle MAIL at ./<a href="http://batch_uploads_imageuploader.pl">batch_uploads_imageuploader.pl</a> line 251.<br></div><div><br></div><div><b>And second execution:<br></b></div><div><br></div><div>(loris-mri-python) lorisadmin@loris-VirtualBox:/data/loris/bin/mri$ ./<a href="http://batch_uploads_imageuploader.pl">batch_uploads_imageuploader.pl</a> -profile prod < ~/Desktop/input.txt > log.txt</div>Use of uninitialized value $_ in pattern match (m//) at ./<a href="http://batch_uploads_imageuploader.pl">batch_uploads_imageuploader.pl</a> line 144.<br><br>PROBLEM:<br>The user 'lorisadmin' has already inserted this study.<br>The unique study ID is '1.3.51.0.1.1.10.49.10.222.1422753.1420953'.<br>This is the information retained from the first time the study was inserted:<br><br>* Taken from dir : /tmp/ImagingUpload-18-33-Qq7HGy<br>* Archive target location : /data/loris/data/tarchive/DCM_2012-12-05_ImagingUpload-18-33-Qq7HGy.tar<br>* Name of creating host : 127.0.1.1<br>* Name of host OS : Linux<br>* Created by user : lorisadmin<br>* Archived on : 2019-09-04 18:33:05<br>* dicomSummary version : 1<br>* dicomTar version : 1<br>* md5sum for DICOM tarball : 4a301b0318178b09b91e63544282364d ImagingUpload-18-33-Qq7HGy.tar<br>* md5sum for DICOM tarball gzipped : 9d95ea2b9111be236808bfd65d7e65ec ImagingUpload-18-33-Qq7HGy.tar.gz<br>* md5sum for complete archive : ab19a86357f1d4053aa3b81c8a071053 DCM_2012-12-05_ImagingUpload-18-33-Qq7HGy.tar<br><br><br>Last update of record:<br><br><br><br>The dicomTar.pl execution has failed.<br>Can't exec "mail": No such file or directory at ./<a href="http://batch_uploads_imageuploader.pl">batch_uploads_imageuploader.pl</a> line 249.<br>print() on closed filehandle MAIL at ./<a href="http://batch_uploads_imageuploader.pl">batch_uploads_imageuploader.pl</a> line 250.<br>print() on closed filehandle MAIL at ./<a href="http://batch_uploads_imageuploader.pl">batch_uploads_imageuploader.pl</a> line 251.<br></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">Στις Τετ, 4 Σεπ 2019 στις 5:35 μ.μ., ο/η Christine Rogers, Ms. <<a href="mailto:christine.rogers@mcgill.ca">christine.rogers@mcgill.ca</a>> έγραψε:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">
<div>
<div dir="ltr">Hi Sotirios,
<div><br>
</div>
<div>Ok, this sounds like good progress. Let us know when you next encounter issues as you progress through the
<a href="https://github.com/aces/Loris-MRI/blob/minor/docs/02-Install.md" target="_blank">Imaging Install/Setup docs</a>. </div>
<div>I'll look into how we can better handle the incoming/ directory next time.</div>
<div>Best, </div>
<div>Christine</div>
</div>
<br>
<div class="gmail_quote">
<div dir="ltr" class="gmail_attr">On Wed, Sep 4, 2019 at 10:23 AM Sotirios Nikoloutsopoulos <<a href="mailto:sotirisnik@gmail.com" target="_blank">sotirisnik@gmail.com</a>> wrote:<br>
</div>
<blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">
<div dir="ltr">
<div>/data/loris/bin/mri/dicom-archive/.loris_mri/database_config.py is populated correctly except its port is 'port' : ''. Also i have tested that i can connect to MySQL with lorisuser.</div>
<div><br>
</div>
<div>I executed the script again, because the only error i had previously was that the /data/incoming folder didn't exist and there are no errors reported back except of warnings <<mysql: [Warning] Using a password on the command line interface can be insecure>>.<br>
<br>
</div>
</div>
<br>
<div class="gmail_quote">
<div dir="ltr" class="gmail_attr">Στις Τετ, 4 Σεπ 2019 στις 4:53 μ.μ., ο/η Christine Rogers, Ms. <<a href="mailto:christine.rogers@mcgill.ca" target="_blank">christine.rogers@mcgill.ca</a>> έγραψε:<br>
</div>
<blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">
<div>
<div dir="ltr">Hi Sotirios,
<div><br>
</div>
<div>It's possible -- if the script was unable to connect to the database during its execution (e.g. typo in the password), that would explain the underpopulated Image path and Loris-MRI code path you saw in the Config module. </div>
<div>
<div>It's hard to tell without seeing the output from your script run -- Did you see a sign of any such error? </div>
</div>
<div>
<div>The Config fields are populated by the imaging_install.sh script (<a href="https://github.com/aces/Loris-MRI/blob/21.0-dev/imaging_install.sh#L222" target="_blank">starting at line 222</a>)</div>
</div>
<div><br>
</div>
<div>For example, check if the database connection information was populated accurately in <span class="gmail-m_-1465391918538176012gmail-m_-6152858793030714160gmail-m_-8226803066969393218m_-3978559249485041190gmail-pl-smi" style="box-sizing:border-box;color:rgb(36,41,46);font-family:SFMono-Regular,Consolas,"Liberation Mono",Menlo,monospace;font-size:12px;white-space:pre-wrap">$mridir</span><span style="color:rgb(36,41,46);font-family:SFMono-Regular,Consolas,"Liberation Mono",Menlo,monospace;font-size:12px;white-space:pre-wrap">/dicom-archive/.loris_mri/database_config.py</span></div>
<div><br>
</div>
<div>Best, </div>
<div>Christine </div>
<div><br>
</div>
<div><br>
</div>
</div>
<br>
<div class="gmail_quote">
<div dir="ltr" class="gmail_attr">On Wed, Sep 4, 2019 at 9:34 AM Sotirios Nikoloutsopoulos <<a href="mailto:sotirisnik@gmail.com" target="_blank">sotirisnik@gmail.com</a>> wrote:<br>
</div>
<blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">
<div dir="ltr">
<div>Hi Christine,</div>
<div><br>
</div>
<div>If you are referring to the imaging_install.sh here is an image with the configurations i typed. Maybe the problem is somewhere at the last part which asks to configure as much as possible automatically?</div>
<div><br>
</div>
<div>Thanks<br>
</div>
<div><br>
</div>
<div><span style="border:medium none;display:inline-block;overflow:hidden;width:643px;height:345px" id="gmail-m_-1465391918538176012gmail-m_-6152858793030714160gmail-m_-8226803066969393218gmail-m_-3978559249485041190gmail-m_-5564460488188384308gmail-docs-internal-guid-493b8c1f-7fff-ca68-b60f-7d41f0b6dd9b"><img src="https://lh5.googleusercontent.com/j0RRFnBHh5ePMY2WuojLIIsv8HZR46fvQUnNU9K0idwkhx_aEdCOMLKUnxI5lVupyRzSsP0weD2UNfywMc9VXykIOu0wJ1ao6cKNwlmJFrC3sJIXXAWT6aM7xHf-J134kCR0gbOs" style="margin-left: 0px; margin-top: 0px;" width="643" height="345"></span></div>
</div>
<br>
<div class="gmail_quote">
<div dir="ltr" class="gmail_attr">Στις Τετ, 4 Σεπ 2019 στις 4:16 μ.μ., ο/η Christine Rogers, Ms. <<a href="mailto:christine.rogers@mcgill.ca" target="_blank">christine.rogers@mcgill.ca</a>> έγραψε:<br>
</div>
<blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">
<div>
<div dir="ltr">Hi Sotirios,
<div><br>
</div>
<div>Glad to hear your LORIS core install is up and working and all the front-end pages are loading. </div>
<div><br>
</div>
<div>
<div>> lorisadmin@loris-VirtualBox:/var/www/loris$ chmod 775 project</div>
<div>> and the web interface worked.</div>
</div>
<div><br>
</div>
<div>Yes, it's important that project/ have 775 permissions and that lorisadmin be part of the sudoers group, per
<a href="https://github.com/aces/Loris#install-steps" target="_blank">step 1 in the install Readme</a>. </div>
<div><br>
</div>
<div>
<div>> As for the Paths, LORIS-MRI code and Image should change LORIS to loris, right?<br>
</div>
<br class="gmail-m_-1465391918538176012gmail-m_-6152858793030714160gmail-m_-8226803066969393218gmail-m_-3978559249485041190gmail-m_-5564460488188384308gmail-m_-4480004644065686266gmail-Apple-interchange-newline">
</div>
<div>These imaging paths will be updated during <a href="https://github.com/aces/Loris/wiki/Setup" target="_blank">
your imaging installation</a> by an automated script -- you do not need to set them manually via the Config module. </div>
<div>Please continue to follow the <a href="https://github.com/aces/Loris/wiki/Setup" target="_blank">
Setup Guide</a> for detailed steps to follow.</div>
<div><br>
</div>
<div>Best, </div>
<div>Christine </div>
<div><br>
</div>
<div><br>
</div>
<div><br>
</div>
</div>
<br>
<div class="gmail_quote">
<div dir="ltr" class="gmail_attr">On Wed, Sep 4, 2019 at 8:05 AM Sotirios Nikoloutsopoulos <<a href="mailto:sotirisnik@gmail.com" target="_blank">sotirisnik@gmail.com</a>> wrote:<br>
</div>
<blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">
<div dir="ltr">
<div>As for the Paths, LORIS-MRI code and Image should change LORIS to loris, right?<br>
</div>
<div><br>
</div>
<div><img src="cid:16cfcee4f40cb971f161" alt="image.png" width="474" height="332"></div>
<div><br>
</div>
</div>
<br>
<div class="gmail_quote">
<div dir="ltr" class="gmail_attr">Στις Τετ, 4 Σεπ 2019 στις 2:28 μ.μ., ο/η Sotirios Nikoloutsopoulos <<a href="mailto:sotirisnik@gmail.com" target="_blank">sotirisnik@gmail.com</a>> έγραψε:<br>
</div>
<blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">
<div dir="ltr">
<div>Hi,</div>
<div><br>
</div>
<div>i used</div>
<div><br>
</div>
<div>
<pre style="box-sizing:border-box;font-family:SFMono-Regular,Consolas,"Liberation Mono",Menlo,monospace;font-size:11.9px;margin-bottom:16px;margin-top:0px;background-color:rgb(246,248,250);border-radius:3px;line-height:1.45;overflow:auto;padding:16px;color:rgb(36,41,46)"><code style="box-sizing:border-box;font-family:SFMono-Regular,Consolas,"Liberation Mono",Menlo,monospace;font-size:11.9px;background:transparent none repeat scroll 0% 0%;border-radius:3px;margin:0px;padding:0px;border:0px none;word-break:normal;display:inline;line-height:inherit;overflow:visible">curl -sL <a href="https://deb.nodesource.com/setup_8.x" target="_blank">https://deb.nodesource.com/setup_8.x</a> | sudo -E bash -
sudo apt-get install -y <span class="gmail-m_-1465391918538176012gmail-m_-6152858793030714160gmail-m_-8226803066969393218gmail-m_-3978559249485041190gmail-m_-5564460488188384308gmail-m_-4480004644065686266gmail-m_6037970262854185989gmail-m_1088120395401920242gmail-il">nodejs<br><br></span></code></pre>
</div>
<div><br>
</div>
<div>you had suggested in the past, make worked and now i can see all the contents in the web-interface, but i don't need make install?</div>
<div><br>
</div>
<div>Thanks<br>
</div>
</div>
</blockquote>
</div>
_______________________________________________<br>
Loris-dev mailing list<br>
<a href="mailto:Loris-dev@bic.mni.mcgill.ca" target="_blank">Loris-dev@bic.mni.mcgill.ca</a><br>
<a href="https://mailman.bic.mni.mcgill.ca/mailman/listinfo/loris-dev" rel="noreferrer" target="_blank">https://mailman.bic.mni.mcgill.ca/mailman/listinfo/loris-dev</a><br>
</blockquote>
</div>
<br clear="all">
<div><br>
</div>
-- <br>
<div dir="ltr" class="gmail-m_-1465391918538176012gmail-m_-6152858793030714160gmail-m_-8226803066969393218gmail-m_-3978559249485041190gmail-m_-5564460488188384308gmail-m_-4480004644065686266gmail_signature">
<div dir="ltr">
<div>
<div dir="ltr">
<div>
<div dir="ltr">
<div><br>
<a href="mailto:christine.rogers@mcgill.ca" target="_blank">christine.rogers@mcgill.ca</a><br>
McGill Centre for Integrative Neuroscience | MCIN.ca</div>
<div>Montreal Neurological Institute</div>
<div>McGill University | Montreal | Canada</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</blockquote>
</div>
_______________________________________________<br>
Loris-dev mailing list<br>
<a href="mailto:Loris-dev@bic.mni.mcgill.ca" target="_blank">Loris-dev@bic.mni.mcgill.ca</a><br>
<a href="https://mailman.bic.mni.mcgill.ca/mailman/listinfo/loris-dev" rel="noreferrer" target="_blank">https://mailman.bic.mni.mcgill.ca/mailman/listinfo/loris-dev</a><br>
</blockquote>
</div>
<br clear="all">
<div><br>
</div>
-- <br>
<div dir="ltr" class="gmail-m_-1465391918538176012gmail-m_-6152858793030714160gmail-m_-8226803066969393218gmail-m_-3978559249485041190gmail_signature">
<div dir="ltr">
<div>
<div dir="ltr">
<div>
<div dir="ltr">
<div><br>
<a href="mailto:christine.rogers@mcgill.ca" target="_blank">christine.rogers@mcgill.ca</a><br>
McGill Centre for Integrative Neuroscience | MCIN.ca</div>
<div>Montreal Neurological Institute</div>
<div>McGill University | Montreal | Canada</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</blockquote>
</div>
_______________________________________________<br>
Loris-dev mailing list<br>
<a href="mailto:Loris-dev@bic.mni.mcgill.ca" target="_blank">Loris-dev@bic.mni.mcgill.ca</a><br>
<a href="https://mailman.bic.mni.mcgill.ca/mailman/listinfo/loris-dev" rel="noreferrer" target="_blank">https://mailman.bic.mni.mcgill.ca/mailman/listinfo/loris-dev</a><br>
</blockquote>
</div>
<br clear="all">
<div><br>
</div>
-- <br>
<div dir="ltr" class="gmail-m_-1465391918538176012gmail_signature">
<div dir="ltr">
<div>
<div dir="ltr">
<div>
<div dir="ltr">
<div><br>
<a href="mailto:christine.rogers@mcgill.ca" target="_blank">christine.rogers@mcgill.ca</a><br>
McGill Centre for Integrative Neuroscience | MCIN.ca</div>
<div>Montreal Neurological Institute</div>
<div>McGill University | Montreal | Canada</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</blockquote></div>