Unable to Authenticate with External Database

Unable to Authenticate with External Database

by Alberto Matus -
Number of replies: 2

I upgraded moodle to the latest which is Moodle 4.1.1+ (Build: 20230120). Prior to that I was running PhP.7.3, so I upgraded to PhP 7.4.33 since this version of moodle required it.

My users were being synced with an external database using mssqlnative and everything was working fine. After this upgrade any user trying to login is presented with "mssqlnative extension not installed"

I have done various searches and nothing is of help. This is on an Ubuntu server 18.04. Any insights would be greatly appreciated. Note, this was working on the previous version of moodle and php.

Average of ratings: -
In reply to Alberto Matus

Re: Unable to Authenticate with External Database

by Visvanath Ratnaweera -
Picture of Particularly helpful Moodlers Picture of Translators
https://learn.microsoft.com/en-us/sql/connect/php/installation-tutorial-linux-mac?view=sql-server-ver16 ?
Average of ratings: -
In reply to Visvanath Ratnaweera

Re: Unable to Authenticate with External Database

by Alberto Matus -
So I finally got some chance and I installed the driver, my users via external authentication now work.

What is strange now is that the Enrolments that were done externally using the same server, same login details now throw the error - " 1.1.1.1\Instance100, 5999: php_network_getaddresses: getaddrinfo failed: Name or service not known"

This is using the myssqlnative database driver, the same as the external enrolment plugin.

Sending emails via the server works btw , have tested it.

Any insights as to why one works but the other doesn't?
Average of ratings: -