[Loris-dev] Cannot connect to the database

Mon Jan 25 15:53:05 EST 2021

Hi Shen,

Thank you! The server is now running but now there is another error. I will send a separate email for that.

Best,
Alfredo.

On Jan 25, 2021, at 3:05 PM, Shen Wang <wangshen.mcin at gmail.com<mailto:wangshen.mcin at gmail.com>> wrote:

        External Email - Use Caution

Hi Alfredo,
After you upgrade the PHP version, you need to upgrade some libraries to support the new PHP version as well.

  1.  sudo apt-get install -y php7.3 php7.3-mysql php7.3-xml php7.3-json php7.3-mbstring php7.3-gd php-ast
  2.  sudo apt-get install -y libapache2-mod-php7.3
  3.  sudo a2enmod php7.3
  4.  sudo service apache2 restart

I hope these steps will help you.
best
Shen

On Mon, 25 Jan 2021 at 14:52, Morales Pinzon, Alfredo <AMORALESPINZON at bwh.harvard.edu<mailto:AMORALESPINZON at bwh.harvard.edu>> wrote:
Dear LorisDev team,

I upgraded the PHP version for apache from 7.2.28 to 7.3.26 in order to avoid errors with trailing-comma in functions. Now that it's upgraded I am getting the following error:

===
[Sun Jan 24 09:43:47.375992 2021] [php7:notice] [pid 26182] [client 216.15.126.108:50170<http://secure-web.cisco.com/1UjSOsmd8vfrUMJGLGOs1SttJi4Mcw935GCtG3z6xaFSFBQuuq3mlJgdLs5QIzzI41CV3kMqH4e-Lb03o675ZBUnttI8Qnyf_CK4GsvCwpKCfe1ZVDxPMEKMlik2isuTa_UvmQNKEAGT9w_kyPScVOlxq1h581hweyic6-Tl97VbN9NOWyBLDdsEpsmmoPpVbXfYNr_8v2lxtyrxwv9Qia7AAi-RKKkej4xd3VNjd7Jsv-J-qMykQIeE9pXUuI5K8KsAj7sPY7E-4qzvUWmDprA/http%3A%2F%2F216.15.126.108%3A50170>] Could not execute . Stack trace#0 /var/www/loris/php/libraries/Database.class.inc(106): Database->connect('AAA', 'BBB', 'CCC', '111.111.111.11', true)\n#1 /var/www/loris/php/libraries/NDB_Client.class.inc(66): Database::singleton('AAA', 'BBB', 'CCC', '111.111.111.11', true)\n#2 /var/www/loris/htdocs/index.php(27): NDB_Client->initialize()\n#3 {main}

[Sun Jan 24 09:43:47.376142 2021] [php7:error] [pid 26182] [client 216.15.126.108:50170<http://secure-web.cisco.com/1UjSOsmd8vfrUMJGLGOs1SttJi4Mcw935GCtG3z6xaFSFBQuuq3mlJgdLs5QIzzI41CV3kMqH4e-Lb03o675ZBUnttI8Qnyf_CK4GsvCwpKCfe1ZVDxPMEKMlik2isuTa_UvmQNKEAGT9w_kyPScVOlxq1h581hweyic6-Tl97VbN9NOWyBLDdsEpsmmoPpVbXfYNr_8v2lxtyrxwv9Qia7AAi-RKKkej4xd3VNjd7Jsv-J-qMykQIeE9pXUuI5K8KsAj7sPY7E-4qzvUWmDprA/http%3A%2F%2F216.15.126.108%3A50170>] PHP Fatal error:  Uncaught DatabaseException: Could not establish a PDO object using the following values: username: `AAA`, dbname: `BBB`, host: `111.111.111.11` and the supplied password. in /var/www/loris/php/libraries/Database.class.inc:173\nStack trace:\n#0 /var/www/loris/php/libraries/Database.class.inc(106): Database->connect('AAA', 'BBB', 'CCC', '111.111.111.11', true)\n#1 /var/www/loris/php/libraries/NDB_Client.class.inc(66): Database::singleton('AAA', 'BBB', 'CCC', '111.111.111.11', true)\n#2 /var/www/loris/htdocs/index.php(27): NDB_Client->initialize()\n#3 {main}\n  thrown in /var/www/loris/php/libraries/Database.class.inc on line 173
Merge state
===

I manually tested the connection from the LORIS server to the server hosting the database and it works. Do you have ideas on how to solve this issue? Maybe I’m missing some updates?

I am running Ubuntu Xenial 16.04.4 and LORIS is in version 22.0.0.

Best,
Alfredo.
The information in this e-mail is intended only for the person to whom it is addressed. If you believe this e-mail was sent to you in error and the e-mail contains patient information, please contact the Mass General Brigham Compliance HelpLine at http://www.massgeneralbrigham.org/complianceline<http://secure-web.cisco.com/1ShBbs6bQqKtVnNwH3G5kiDiwej3XK8oQlimnNYkHAmHi-ha4VOJc6XXukG63yZT4Exm-bSWzGiDxjJdXOaScDFJJ9cLSHsmYLi-E-DTIE-3ll8lnrrFxXYUoxLQ6FLJAo7Zr9rdsgqSpM9TrpIIezpQeCRnJrw3uOL0kqr0TyQawPsOFzbzO3GK-5klOfLbqakNVmowDM3c9AyeXKWnMPl5ROHBS13MdGQ8QWyhQhjxmFhB8NFOEiUR24Q08_EqXBYyCfR-MVM1smMHU66DglQ/http%3A%2F%2Fwww.massgeneralbrigham.org%2Fcomplianceline> . If the e-mail was sent to you in error but does not contain patient information, please contact the sender and properly dispose of the e-mail.

_______________________________________________
Loris-dev mailing list
Loris-dev at bic.mni.mcgill.ca<mailto:Loris-dev at bic.mni.mcgill.ca>
https://mailman.bic.mni.mcgill.ca/mailman/listinfo/loris-dev<https://secure-web.cisco.com/11QUaUk_5r7wQh2pjLb_kHMXyPf4I5wJiiTFT_XgExPAttkuX5wvV8vy-P0p_85PaziRPG1Oe0VmfSBS2XA1dkRVGU7wha1nVNarSnMr2kWfuqi8Azcco4uFBJ2EVMq1nZJ6MI4iCuKdCspb6iSgnE27bAZ7-deYTRKvWgczFuq8sor8JVwnwyraIUcv7K51s4MsTPzpo8fxN6l9pJFv9pfBAeXqmoCmOy4C7YWYTDOcQzODN-4b6TLY55Kdd6dJJ1w6iL-N0PpsYfxrVqEocsw/https%3A%2F%2Fmailman.bic.mni.mcgill.ca%2Fmailman%2Flistinfo%2Floris-dev>

--
Shen Wang
Loris<https://secure-web.cisco.com/17HmP_xcOrCQjajU81PhFrE-TpN_ZvEny637YcXO5c_o--DPEB522yEoych4O3XG-PSAL8cGNNMRdYBo3L8w_bpxKFrQSRzHZFsZWFvp_qq5BpJ3UJN8pUq_EKedTug5KcdnsEkzneAiNgJ0QIqxbKgDBuVThQ-F9Xu3WeEjgTIs26tUU9kKuhVTMi8h0KTVyZD3yrMz-UO9qPdLWOWs-zICM0Vm21wYBnnFVEfWDgjNfe2315nSgGxNBjFKeEs5D4VF8SB3YFigNP2O_pPNbKg/https%3A%2F%2Fgithub.com%2Faces%2FLoris>  Developer
Montreal Neurological Institute
McGill University

The information in this e-mail is intended only for the person to whom it is addressed. If you believe this e-mail was sent to you in error and the e-mail contains patient information, please contact the Mass General Brigham Compliance HelpLine at http://www.massgeneralbrigham.org/complianceline . If the e-mail was sent to you in error but does not contain patient information, please contact the sender and properly dispose of the e-mail.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mailman.bic.mni.mcgill.ca/pipermail/loris-dev/attachments/20210125/8d283d1d/attachment-0001.html>