TOPIC:

Following a new installation of Xerte and the successful configuration to all LDAP authentication on our site, we are getting the issue described below. Our VLE Platform is Blackboard Learn 9.1 April 2015. I wonder if there is an issue related to the LTI Building Block configuration and if there is any documentation available anywhere describing the correct configuration of LTI to allow Xerte to be used with Blackboard Learn 9.

Here are the symptoms of our current issue: -
Just a quick email around the error we are encountering in Xerte,

We can login fine with ldap details. Then we are presented with the setup page. So then I click on Create, add a name and then create again.



This creates a new project under the workspaces folder.

You then select a project and click Edit (as highlighted above)



This should launch the edit page, but it just opens a blank page with no content. This should be the page where you can add pages, content etc.



It appears others have had the issue but can't see a solution in the forums that has been confirmed:
- www.xerte.org.uk/index.php?option=com_ku...6&Itemid=759&lang=en
- www.xerte.org.uk/index.php?option=com_ku...7&Itemid=759&lang=en

Any errors in the webserver or php error log?

On the webserver in the folder of the xerte installation, these objects should have been created in the folder USER-FILES. Are they there? Is that folder writable by the user running the web server?

* Here is the content of /var/www/html/USER-FILES: -
root@xerte-d:/var/www/html/USER-FILES# pwd
/var/www/html/USER-FILES
root@xerte-d:/var/www/html/USER-FILES# ls -al
total 20
drwxr-xr-x 2 www-data www-data 4096 Feb 24 14:52 .
drwxr-xr-x 25 www-data www-data 4096 Mar 29 16:06 ..
-rw-r--r-- 1 www-data www-data 360 Jul 29 2015 .htaccess
-rwxr-xr-x 1 www-data www-data 152 Jul 29 2015 index.html
-rwxr-xr-x 1 www-data www-data 116 Jul 29 2015 readme.txt
root@xerte-d:/var/www/html/USER-FILES#


* apache2 processes are owned by www-data: -
eg
root@xerte-d:/var/www# ps -ef | grep apache
root 352 1 0 Apr22 ? 00:00:25 /usr/sbin/apache2 -k start
. . . etc

* Here are the directory permissions: -
root@xerte-d:/var/www/html/USER-FILES# pwd
/var/www/html/USER-FILES
root@xerte-d:/var/www/html/USER-FILES# ls -ld .
drwxr-xr-x 2 www-data www-data 4096 Feb 24 14:52 .
root@xerte-d:/var/www/html/USER-FILES# cd ..
root@xerte-d:/var/www/html# ls -ld .
drwxr-xr-x 25 www-data www-data 4096 Mar 29 16:06 .
root@xerte-d:/var/www/html# cd ..
root@xerte-d:/var/www# ls -ld .
drwxr-xr-x 4 root root 4096 Mar 29 15:58 .

* The setting in config.php: -
define('XOT_DEBUG_LOGFILE', '/tmp/xerte-debug/xerte-debug.log');
is unchanged.

* Logging in direct to Xerte Toolkit (not via Learn 9.1) produces the following log output in the above file that seems to show issues with username, login_id and folder_name. Here is the relevant output: -
2016-04-28 10:15:11 /var/www/html/website_code/php/database_library.php175Running : select login_id from logindetails where username = ?
2016-04-28 10:15:11 /var/www/html/website_code/php/database_library.php175Running : SELECT login_id FROM logindetails WHERE username = ?
2016-04-28 10:15:11 /var/www/html/website_code/php/user_library.php228Running : UPDATE logindetails SET lastlogin = ? WHERE username = ?
2016-04-28 10:15:11 /var/www/html/website_code/php/user_library.php241Running : UPDATE logindetails SET firstname = ?, surname = ? WHERE username = ?
2016-04-28 10:15:11 /var/www/html/website_code/php/user_library.php132Running : select folder_name from folderdetails where
folder_name = ? AND login_id = ?
2016-04-28 10:15:11 /var/www/html/website_code/php/user_library.php270Running : select folder_id from folderdetails where login_id= ? AND folder_name = ?
2016-04-28 10:15:11 /var/www/html/functions.php175en-GB
2016-04-28 10:15:11 /var/www/html/functions.php176languages/en-GB/website_code/scripts/file_system.js
2016-04-28 10:15:11 /var/www/html/functions.php177languages/en-GB/website_code/scripts/file_system.js
2016-04-28 10:15:11 /var/www/html/functions.php175en-GB
2016-04-28 10:15:11 /var/www/html/functions.php176languages/en-GB/website_code/scripts/screen_display.js
2016-04-28 10:15:11 /var/www/html/functions.php177languages/en-GB/website_code/scripts/screen_display.js
2016-04-28 10:15:11 /var/www/html/functions.php175en-GB
2016-04-28 10:15:11 /var/www/html/functions.php176languages/en-GB/website_code/scripts/ajax_management.js
2016-04-28 10:15:11 /var/www/html/functions.php177languages/en-GB/website_code/scripts/ajax_management.js
2016-04-28 10:15:11 /var/www/html/functions.php175en-GB
2016-04-28 10:15:11 /var/www/html/functions.php176languages/en-GB/website_code/scripts/folders.js
2016-04-28 10:15:11 /var/www/html/functions.php177languages/en-GB/website_code/scripts/folders.js
2016-04-28 10:15:11 /var/www/html/functions.php175en-GB
2016-04-28 10:15:11 /var/www/html/functions.php176languages/en-GB/website_code/scripts/template_management.js
2016-04-28 10:15:11 /var/www/html/functions.php177languages/en-GB/website_code/scripts/template_management.js
2016-04-28 10:15:11 /var/www/html/functions.php175en-GB
2016-04-28 10:15:11 /var/www/html/functions.php176languages/en-GB/website_code/scripts/logout.js
2016-04-28 10:15:11 /var/www/html/functions.php177languages/en-GB/website_code/scripts/logout.js
2016-04-28 10:15:11 /var/www/html/functions.php175en-GB
2016-04-28 10:15:11 /var/www/html/functions.php176languages/en-GB/website_code/scripts/import.js
2016-04-28 10:15:11 /var/www/html/functions.php177languages/en-GB/website_code/scripts/import.js
2016-04-28 10:15:11 /var/www/html/website_code/php/display_library.php640Running : select * from originaltemplatesdetails where access_rights=? and active= ? order by date_uploaded DESC
2016-04-28 10:15:11 /var/www/html/website_code/php/display_library.php738Running : select * from originaltemplatesdetails where access_rights != ? order by date_uploaded DESC
2016-04-28 10:15:11 /var/www/html/website_code/php/database_library.php175Running : SELECT * FROM sitedetails
2016-04-28 10:15:11 /var/www/html/website_code/php/user_library.php270Running : select folder_id from folderdetails where login_id= ? AND folder_name = ?
2016-04-28 10:15:11 /var/www/html/website_code/php/user_library.php270Running : select folder_id from folderdetails where login_id= ? AND folder_name = ?
2016-04-28 10:15:11 /var/www/html/website_code/php/user_library.php270Running : select folder_id from folderdetails where login_id= ? AND folder_name = ?
2016-04-28 10:15:11 /var/www/html/website_code/php/display_library.php401Running : select folder_id, folder_name from folderdetails where login_id = ? AND folder_parent = ? order by date_created DESC
2016-04-28 10:15:11 /var/www/html/website_code/php/display_library.php461Running : select td.template_name as project_name, originaltemplatesdetails.template_name, originaltemplatesdetails.template_framework, td.template_id from templatedetails td, templaterights tr, originaltemplatesdetails where td.template_id = tr.template_id and tr.user_id = ? and tr.folder= ? and originaltemplatesdetails.template_type_id = td.template_type_id order by td.date_created DESC
2016-04-28 10:15:11 /var/www/html/website_code/php/database_library.php175Running : select folder_id from folderdetails where folder_name=? AND login_id = ?
2016-04-28 10:15:11 /var/www/html/website_code/php/display_library.php401Running : select folder_id, folder_name from folderdetails where login_id = ? AND folder_parent = ? order by date_created DESC
2016-04-28 10:15:11 /var/www/html/website_code/php/display_library.php461Running : select td.template_name as project_name, originaltemplatesdetails.template_name, originaltemplatesdetails.template_framework, td.template_id from templatedetails td, templaterights tr, originaltemplatesdetails where td.template_id = tr.template_id and tr.user_id = ? and tr.folder= ? and originaltemplatesdetails.template_type_id = td.template_type_id order by td.date_created DESC
2016-04-28 10:15:11 /var/www/html/website_code/php/display_library.php583Running : select * from originaltemplatesdetails order by date_uploaded DESC

I found /var/www/html/setup/diagnosis.php and attempted to use it to diagnose the issues I have. Everything was good except LDAP which failed. This is surprising to me because the LDAP login to our site works correctly for all users with LDAP credentials.

The output from the LDAP testing utility in diagnosis.php, on clicking "Try logging in" is: -
Attempting to connect
Logging in failed
Getting LDAP record for user - to work with Toolkits - [sn][0] should the surname and [givenname][0] should be the first name

Note that I was prompted by the diagnosis.php utility to provide a username and password. I provided these as recorded in our LDAP. My username is not the same as my given name or my family name. As I said above, my username and password in LDAP appear to work correctly for logging in to the actual, Xerte, login dialog.

Below is what I get in the log file, xerte-debug.log, after logging in (ldap) and then doing "Xerte Online Toolkit" -> Create and providing the name "foo" for the new project.

These values seem to be unknown by the application - see the log file.
login_id= ?
folder_name= ?
template_name = ?
folder_parent = ?

Here is the ldap table: -
mysql> select * from ldap;
+

---

+

---

+

---

+

---

+

---

+

---

+

---

+

---

+

---

+
| ldap_id | ldap_knownname | ldap_host | ldap_port | ldap_username | ldap_password | ldap_basedn | ldap_filter | ldap_filter_attr |
+

---

+

---

+

---

+

---

+

---

+

---

+

---

+

---

+

---

+
| 1 | from_sitedetails | auth.shef.ac.uk | 389 | | | ou=Users,dc=sheffield,dc=ac,dc=uk | uid | uid |
+

---

+

---

+

---

+

---

+

---

+

---

+

---

+

---

+

---

+
1 row in set (0.00 sec)
mysql>

And here is the output in the log file: xerte-debug.log
2016-04-28 16:58:19 /var/www/html/website_code/php/database_library.php175Running : SELECT * FROM sitedetails
2016-04-28 16:58:19 /var/www/html/website_code/php/user_library.php270Running : select folder_id from folderdetails where login_id= ? AND folder_name = ?
2016-04-28 16:58:19 /var/www/html/website_code/php/database_library.php175Running : SELECT max(template_id) as count FROM templatedetails
2016-04-28 16:58:19 /var/www/html/website_code/php/database_library.php175Running : select template_type_id, template_name, template_framework from originaltemplatesdetails where template_name = ?
2016-04-28 16:58:19 /var/www/html/website_code/php/templates/new_template.php81Running : INSERT INTO templatedetails (template_id, creator_id, template_type_id, date_created, date_modified, number_of_uses, access_to_whom, template_name, extra_flags)
VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)
2016-04-28 16:58:19 /var/www/html/website_code/php/templates/new_template.php85Created new template entry in db
2016-04-28 16:58:19 /var/www/html/website_code/php/templates/new_template.php87Running : INSERT INTO templaterights (template_id, user_id, role, folder) VALUES (?,?,?,?)
2016-04-28 16:58:19 /var/www/html/website_code/php/templates/new_template.php91Setup template rights ok
2016-04-28 16:58:19 /var/www/html/website_code/php/database_library.php175Running : SELECT template_framework from originaltemplatesdetails WHERE template_name = ?
2016-04-28 16:58:19 /var/www/html/modules/xerte/new_template.php111Creating new template : 8, Nottingham
2016-04-28 16:58:19 /var/www/html/modules/xerte/new_template.php119Created /home/xerte/v3.1/USER-FILES/8-cs1slb-Nottingham ok
2016-04-28 16:58:19 /var/www/html/modules/xerte/new_template.php45Copying /home/xerte/v3.1/modules/xerte/templates/Nottingham to /home/xerte/v3.1/USER-FILES/8-cs1slb-Nottingham, recursively...
2016-04-28 16:58:19 /var/www/html/modules/xerte/new_template.php45Copying /home/xerte/v3.1/modules/xerte/templates/Nottingham/media to /home/xerte/v3.1/USER-FILES/8-cs1slb-Nottingham/media, recursively...
2016-04-28 16:58:19 /var/www/html/modules/xerte/new_template.php122Copy_r returned 1
2016-04-28 16:58:19 /var/www/html/website_code/php/database_library.php175Running : SELECT * FROM sitedetails
2016-04-28 16:58:19 /var/www/html/website_code/php/user_library.php270Running : select folder_id from folderdetails where login_id= ? AND folder_name = ?
2016-04-28 16:58:19 /var/www/html/website_code/php/user_library.php270Running : select folder_id from folderdetails where login_id= ? AND folder_name = ?
2016-04-28 16:58:19 /var/www/html/website_code/php/display_library.php187Running : select folder_id, folder_name from folderdetails where login_id = ? AND folder_parent = ? order by date_created DESC
2016-04-28 16:58:19 /var/www/html/website_code/php/display_library.php259Running : select td.template_name as project_name, originaltemplatesdetails.template_name, originaltemplatesdetails.template_framework, td.template_id from templatedetails td, templaterights tr, originaltemplatesdetails where td.template_id = tr.template_id and tr.user_id = ? and tr.folder= ? and originaltemplatesdetails.template_type_id = td.template_type_id order by td.date_created DESC
2016-04-28 16:58:19 /var/www/html/website_code/php/database_library.php175Running : select folder_id from folderdetails where folder_name=? AND login_id = ?
2016-04-28 16:58:19 /var/www/html/website_code/php/display_library.php337Running : select template_id from templaterights where folder= ? UNION SELECT folder_id from folderdetails where folder_parent= ?
2016-04-28 16:58:19 /var/www/html/website_code/php/display_library.php187Running : select folder_id, folder_name from folderdetails where login_id = ? AND folder_parent = ? order by date_created DESC
2016-04-28 16:58:19 /var/www/html/website_code/php/display_library.php259Running : select td.template_name as project_name, originaltemplatesdetails.template_name, originaltemplatesdetails.template_framework, td.template_id from templatedetails td, templaterights tr, originaltemplatesdetails where td.template_id = tr.template_id and tr.user_id = ? and tr.folder= ? and originaltemplatesdetails.template_type_id = td.template_type_id order by td.date_created DESC
2016-04-28 16:58:19 /var/www/html/website_code/php/database_library.php175Running : SELECT * FROM sitedetails
2016-04-28 16:58:19 /var/www/html/website_code/php/user_library.php270Running : select folder_id from folderdetails where login_id= ? AND folder_name = ?
2016-04-28 16:58:19 /var/www/html/website_code/php/user_library.php270Running : select folder_id from folderdetails where login_id= ? AND folder_name = ?
2016-04-28 16:58:19 /var/www/html/website_code/php/user_library.php270Running : select folder_id from folderdetails where login_id= ? AND folder_name = ?
2016-04-28 16:58:19 /var/www/html/website_code/php/display_library.php401Running : select folder_id, folder_name from folderdetails where login_id = ? AND folder_parent = ? order by date_created DESC
2016-04-28 16:58:19 /var/www/html/website_code/php/display_library.php461Running : select td.template_name as project_name, originaltemplatesdetails.template_name, originaltemplatesdetails.template_framework, td.template_id from templatedetails td, templaterights tr, originaltemplatesdetails where td.template_id = tr.template_id and tr.user_id = ? and tr.folder= ? and originaltemplatesdetails.template_type_id = td.template_type_id order by td.date_created DESC
2016-04-28 16:58:19 /var/www/html/website_code/php/database_library.php175Running : select folder_id from folderdetails where folder_name=? AND login_id = ?
2016-04-28 16:58:19 /var/www/html/website_code/php/display_library.php401Running : select folder_id, folder_name from folderdetails where login_id = ? AND folder_parent = ? order by date_created DESC
2016-04-28 16:58:19 /var/www/html/website_code/php/display_library.php461Running : select td.template_name as project_name, originaltemplatesdetails.template_name, originaltemplatesdetails.template_framework, td.template_id from templatedetails td, templaterights tr, originaltemplatesdetails where td.template_id = tr.template_id and tr.user_id = ? and tr.folder= ? and originaltemplatesdetails.template_type_id = td.template_type_id order by td.date_created DESC
2016-04-28 16:58:19 /var/www/html/website_code/php/display_library.php583Running : select * from originaltemplatesdetails order by date_uploaded DESC
2016-04-28 16:58:19 /var/www/html/website_code/php/database_library.php175Running : SELECT * FROM sitedetails
2016-04-28 16:58:19 /var/www/html/website_code/php/database_library.php175Running : select originaltemplatesdetails.template_name, logindetails.username, originaltemplatesdetails.template_framework, templaterights.user_id, templaterights.folder, templaterights.template_id, templatedetails.access_to_whom from originaltemplatesdetails, templaterights, templatedetails, logindetails where templatedetails.template_type_id = originaltemplatesdetails.template_type_id and templatedetails.creator_id = logindetails.login_id and templaterights.template_id = templatedetails.template_id and templaterights.template_id="8" and role="creator"
2016-04-28 16:58:19 /var/www/html/website_code/php/database_library.php175Running : select * from templaterights where user_id=? AND template_id = ?
2016-04-28 16:58:19 /var/www/html/website_code/php/database_library.php175Running : select role from templaterights where user_id= ? AND template_id = ?
2016-04-28 16:58:19 /var/www/html/website_code/php/template_status.php139Running : select templaterights.template_id, role, logindetails.username, originaltemplatesdetails.template_name FROM templaterights, logindetails, originaltemplatesdetails, templatedetails where templatedetails.template_type_id = originaltemplatesdetails.template_type_id AND templaterights.template_id = templatedetails.template_id and templatedetails.creator_id = logindetails.login_id and templaterights.template_id= ? AND role = ?
2016-04-28 16:58:19 /var/www/html/website_code/php/template_status.php153Running : select templaterights.template_id, role, logindetails.username, originaltemplatesdetails.template_name from templaterights, logindetails, originaltemplatesdetails, templatedetails where templatedetails.template_type_id = originaltemplatesdetails.template_type_id AND templaterights.template_id = templatedetails.template_id and templatedetails.creator_id = logindetails.login_id and templaterights.template_id = ?
2016-04-28 16:58:19 /var/www/html/edithtml.php48Running : UPDATE templatedetails SET date_accessed=? WHERE template_id = ?
2016-04-28 16:58:19 /var/www/html/website_code/php/database_library.php175Running : select username from logindetails where login_id=?
2016-04-28 16:58:20 /var/www/html/website_code/php/database_library.php175Running : SELECT * FROM sitedetails
2016-04-28 16:58:20 /var/www/html/website_code/php/database_library.php175Running : select templatedetails.template_name, template_framework, date_created, date_modified, extra_flags from templatedetails, originaltemplatesdetails where template_id= ? and originaltemplatesdetails.template_type_id = templatedetails.template_type_id
2016-04-28 16:58:20 /var/www/html/website_code/php/database_library.php175Running : select template_name from templatedetails where template_id= ?
2016-04-28 16:58:20 /var/www/html/website_code/php/database_library.php175Running : SELECT td.extra_flags FROM templatedetails td WHERE td.template_id = ?
2016-04-28 16:58:20 /var/www/html/website_code/php/database_library.php175Running : select templatedetails.access_to_whom from templatedetails where template_id= ?
2016-04-28 16:58:20 /var/www/html/website_code/php/database_library.php175Running : select * from templaterights where user_id=? AND template_id = ?
2016-04-28 16:58:20 /var/www/html/website_code/php/database_library.php175Running : select originaltemplatesdetails.template_name, templaterights.folder, logindetails.username FROM originaltemplatesdetails, templatedetails, templaterights, logindetails WHERE originaltemplatesdetails.template_type_id = templatedetails.template_type_id AND templaterights.template_id = templatedetails.template_id AND templatedetails.creator_id = logindetails.login_id AND templatedetails.template_id = ? AND role = ?
2016-04-28 16:58:20 /var/www/html/website_code/php/database_library.php175Running : select access_to_whom from templatedetails where template_id= ?
2016-04-28 16:58:20 /var/www/html/website_code/php/database_library.php175Running : select templatedetails.access_to_whom from templatedetails where template_id= ?
2016-04-28 16:58:20 /var/www/html/website_code/php/database_library.php175Running : select * from templaterights where user_id=? AND template_id = ?
2016-04-28 16:58:20 /var/www/html/website_code/php/properties/properties_library.php629Running : SELECT template_id, user_id, firstname, surname, username, role FROM templaterights, logindetails WHERE logindetails.login_id = templaterights.user_id and template_id= ?
2016-04-28 16:58:20 /var/www/html/website_code/php/database_library.php175Running : SELECT template_id, user_id, firstname, surname, role FROM templaterights, logindetails WHERE logindetails.login_id = templaterights.user_id and template_id= ? and user_id = ?

As you can login, you can ignore the ldap errors of diagnosis.php

Can you please
1. check the sitedetails table and check the import_path and root_file_path columns
2. set developer=true near line 26 in config.php
3. Check the apache error log for fatal php errors when creating a new LO.