+ Post New Thread
Results 1 to 4 of 4
Virtual Learning Platforms Thread, Moodle 2 Ldap error writing to database...! in Technical; I've recently setup a development server for Moodle 2 I have configured the settings for LDAP to work (same as ...
  1. #1
    wesleyw's Avatar
    Join Date
    Dec 2005
    Location
    Kingswinford
    Posts
    2,205
    Thank Post
    223
    Thanked 50 Times in 44 Posts
    Blog Entries
    1
    Rep Power
    30

    Moodle 2 Ldap error writing to database...!

    I've recently setup a development server for Moodle 2 I have configured the settings for LDAP to work (same as my Moodle 1.9 version) "I" try logging in and get an error stating error writing to database however if I log in as a test pupil this doesn't occur? I've created several Moodle 2 servers (all exhibiting this behaviour) so I thought it must be my fault and downloaded an ISO of TurnKey Moodle Appliance and tried this same error? I'll post up the debug error message in a minute.

    Any thoughts?




    Wes

  2. #2
    wesleyw's Avatar
    Join Date
    Dec 2005
    Location
    Kingswinford
    Posts
    2,205
    Thank Post
    223
    Thanked 50 Times in 44 Posts
    Blog Entries
    1
    Rep Power
    30
    Debug info:
    Stack trace:

    * line 394 of /lib/dml/moodle_database.php: dml_write_exception thrown
    * line 843 of /lib/dml/mysqli_native_moodle_database.php: call to moodle_database->query_end()
    * line 885 of /lib/dml/mysqli_native_moodle_database.php: call to mysqli_native_moodle_database->insert_record_raw()
    * line 3468 of /lib/moodlelib.php: call to mysqli_native_moodle_database->insert_record()
    * line 3749 of /lib/moodlelib.php: call to create_user_record()
    * line 133 of /login/index.php: call to authenticate_user_login()



    interestingly if I try and login as myself or a staff member and deliberately enter the wrong password it just states invalid login as it should?


    Wes

  3. #3
    wesleyw's Avatar
    Join Date
    Dec 2005
    Location
    Kingswinford
    Posts
    2,205
    Thank Post
    223
    Thanked 50 Times in 44 Posts
    Blog Entries
    1
    Rep Power
    30
    Think I may have tracked the offending thing down now I had set the ID Number to a special AD field setup by our MIS system if I remove this the issue goes away? I think postgre maybe needed here as it seems to be an issue caused by MySQL and the UTF8_collation?



    Wes

  4. #4
    wesleyw's Avatar
    Join Date
    Dec 2005
    Location
    Kingswinford
    Posts
    2,205
    Thank Post
    223
    Thanked 50 Times in 44 Posts
    Blog Entries
    1
    Rep Power
    30
    Sadly even Postgresql didn't fix it but if I put the entity field in description not ID Number then it works obviously a problem with the ID number field between versions 1.9 and 2.1.2.


    Solved!

    Wes

SHARE:
+ Post New Thread

Similar Threads

  1. moodle ldap default values if not set by AD
    By russdev in forum Virtual Learning Platforms
    Replies: 12
    Last Post: 8th June 2010, 11:46 AM
  2. Joomla : Unable to Connect to Database
    By deano in forum Web Development
    Replies: 0
    Last Post: 28th September 2007, 03:09 PM
  3. Strange win 2k error - failure to logon.
    By Domino in forum Wireless Networks
    Replies: 2
    Last Post: 5th July 2007, 01:36 PM
  4. Moodle LDAP Enrolment
    By Mike_R in forum Virtual Learning Platforms
    Replies: 2
    Last Post: 6th December 2006, 02:33 PM
  5. questionaire linked to database help please!!!!!!!!!!!!!!!!!
    By suesmate in forum Educational Software
    Replies: 8
    Last Post: 3rd May 2006, 06:07 PM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •