My real issue is with external database authentication but I have not found anyone that could assist and as the external enrollments plugin calls the same libraries for database connectivity I though I would ask here as well. When selecting ODBC as the database type I would assume based upon looking at the code that I must feed it a DSN somehow. The current forms don't appear to support this although ODBC is a connection type. My example below is an error returned from the authentication plugin debug code but should be similarly applicatable here due to the shared libraries. This is with moodle 1.8x. I have written a short php script that connects to this same DSN directly and accesses the data so I know the basics are setup right. It's just how do I pass the appropriate DSN through the setup screens?
I am attempting to setup authentication to an external database (Informix) using an odbc connection. When I setup the connection and turn on debugging I receive the following error:
For odbc Connect(), dsn=CX is not used. Place dsn in 1st parameter.
172.20.16.66: Connection error to server '172.20.16.66' with user 'bogususer'
Moodle is running on a windows server on which I have defined a System DSN named 'CX'. Where do I tell the external authentication setup to use this DSN. It definately does not like it in the database name field as I receive the error above.
I connect to this external Informix database via odbc through numerous other sources so I know connectiviity is their. I just need to get moodle/php configured properly.
Any and all help is greatly appreciated!
--Ron