[Xerte-dev] Re: A couple of points with regard to V. 2.1

Sat Nov 23 11:06:06 GMT 2013

Doh!

Thank you so much Tom, I’ld completely forgotten about the DB authentication - too much else on my mind at the moment.

I’ve just realised that I can setup a duplicate ‘toolkits’ directory and database and give you ftp access to it if you would find it helpful for testing.  The strange thing is that it only bombed out AFTER creating the tables and populating most of them. the only thing I can think of is that I had elected to have no table prefix, i.e. that was “”. Could that have caused a parsing error?

The relevant sections from config.php are below (the ‘cambrid1_’ is required by the Hosting provider):

/*
* Host where database is
*/
$xerte_toolkits_site->database_host = "localhost";　
/*
* Username for database
*/
$xerte_toolkits_site->database_username ="cambrid1_********";　
/*
* Password for database
*/
$xerte_toolkits_site->database_password ="********";　
/*
* Database name
*/
$xerte_toolkits_site->database_name ="cambrid1_toolkits";　
/*
* Database table prefix
*/
$xerte_toolkits_site->database_table_prefix ="";

Kindest Regards,
Thomas
==========================================================
Thomas Rochford  |  e-Learning Advisor  |  Jisc RSC Eastern
Tel: 01223 564749 |  Mobile: 07500 669002  |  Skype: cambridge.serendipity
Email: thomas.rochford at jiscadvance.ac.uk  |  Web: http://www.jiscrsc.ac.uk/eastern 
Cambridge Serendipity, 35 Gough Way, Cambridge, CB3 9LN
For the full range of RSC UK events, resources and blog, visit http://www.jiscrsc.ac.uk

From: Tom Reijnders
Sent: ‎Saturday‎, ‎23‎ ‎November‎ ‎2013 ‎00‎:‎13
To: For Xerte technical developers

Thomas,

I'll look at the installation.

As for the static, you probably mean Db. As static requires you to edit Stitic.php to insert the users. Choosing Db will provide a measn of doing this in management.php.

The reference to MariaDB is possible, as mariadb is a plugin replacement for MySQL, so the provider probably uses MariaDB.

Tom

thomas.rochford at jiscadvance.ac.uk schreef op 22-11-2013 23:35:

Hi,

I’ve just done a new install of Xerte 2.1 using the web hosting service provided by EZPZ. This is becoming very popular with providers because it includes Moodle 2.6 and can be set up (if you follow the instructions) in less than 15 minutes from ordering and costs £24.00 p.a. for a basic site (~10GB storage)

It can also run Xerte online toolkits so I though I’ld try a new installation and have run into  couple of problems

First: the MySQL databases you create take the form of site-identifier_database-name and the database administrator works the same way. I was unable to get the standard install to work because it failed when trying to populate the site-details table. All the tables other than ‘user’ were correctly setup, and they were all populated with the default values. I cleared out the 2.1 directory, and uploaded all the files from a MAXOS stick with V. 2.0 on. I then used a MySQL insert command to populate the site-details table using an edited version of the MAXOS site-details table and edited database.php to point to the EZPZ server. That worked just fine. So I then uploaded the version 2.1 code over the top and that works fine in ‘Guest Mode’

So: It looks as though a bug that Tom worked on in the installer when I had a similar problem some months ago, which cause the install to fail with a bizarre message about the SQL failing ‘on line 1 around “” ‘ may have crept back. The really strange thing was a reference to a Maria server, or something similar. I can’t reproduce it now without winding the clock back

I’m also unable to switch from ‘Guest’ mode to ‘Static’. I can edit auth_config.php and am then prompted for a username and password, but if I go into management.php, there doesn’t appear to be any way to setup users and the Static.php table doesn’t appear to be read either. Is there something I’m missing here? I thought that uncommenting the static authentication and then going into the Users tab used to create the user table on the fly.

On of my Providers is bidding for a Xerte based funding project and they will need an external server for this as it is a collaborative venture and their own server is locked down to the College, so this is one of the main drivers for investigating this option.

Kindest Regards,
Thomas
==========================================================
Thomas Rochford  |  e-Learning Advisor  |  Jisc RSC Eastern
Tel: 01223 564749 |  Mobile: 07500 669002  |  Skype: cambridge.serendipity
Email: thomas.rochford at jiscadvance.ac.uk  |  Web: http://www.jiscrsc.ac.uk/eastern 
Cambridge Serendipity, 35 Gough Way, Cambridge, CB3 9LN
For the full range of RSC UK events, resources and blog, visit http://www.jiscrsc.ac.uk

From: Pat @ Pgogy
Sent: ‎Tuesday‎, ‎12‎ ‎November‎ ‎2013 ‎18‎:‎11
To: For Xerte technical developers

Or just set a mobile CSS that doesn't show any folders?

On Tue, Nov 12, 2013 at 10:20 AM, Julian Tenney <Julian.Tenney at nottingham.ac.uk> wrote:

Often in a tree there are two icons, the ‘folder’, and the little ‘+’ next to it for opening / closing it, but yes, to be addressed when we try and get the editor all HTML friendly.

From: xerte-dev-bounces at lists.nottingham.ac.uk [mailto:xerte-dev-bounces at lists.nottingham.ac.uk] On Behalf Of thomas.rochford at jiscadvance.ac.uk
Sent: 11 November 2013 21:44
To: For Xerte technical developers
Subject: [Xerte-dev] Food for thought or wishlist

Good evening,

I’ve been thinking about (and dealing with) the problem of double-clicking on Mobile/Handheld devices. The browsers don’t support this and interpret the double-click (especially when opening or collapsing Workspace Folders) as two consecutive clicks which  may zoom the page or have other less desirable effects.

The front page opens up perfectly in Firefox on an Android device. However, if you want to get at a file in a folder, e.g. to preview it or get the URL from the properties, you can’t and the folders appear to be ’collapsed’  by default. The problems of double-clicking on handheld devices are well documented on Google and there are a number of workarounds, including the use of a ‘long press’, but to my mind the simplest way might be to make the icon separately clickable so that tapping it with change the state from closed to open or vice-versa. it might also be worth considering whether the adjust the icon to show the current or potential state. Selecting the title of the folder would then be equivalent to Selecting the Folder.

I feel this is a problem that will need to be solved anyway as XoT moves towards an HTML-compliant editor.

Kindest Regards,
Thomas
==========================================================
Thomas Rochford  |  e-Learning Advisor  |  Jisc RSC Eastern
Tel: 01223 564749 |  Mobile: 07500 669002  |  Skype: cambridge.serendipity
Email: thomas.rochford at jiscadvance.ac.uk  |  Web: http://www.jiscrsc.ac.uk/eastern 
Cambridge Serendipity, 35 Gough Way, Cambridge, CB3 9LN
For the full range of RSC UK events, resources and blog, visit http://www.jiscrsc.ac.uk

_______________________________________________
Xerte-dev mailing list
Xerte-dev at lists.nottingham.ac.uk
http://lists.nottingham.ac.uk/mailman/listinfo/xerte-dev

_______________________________________________
Xerte-dev mailing list
Xerte-dev at lists.nottingham.ac.uk
http://lists.nottingham.ac.uk/mailman/listinfo/xerte-dev

-- 
--

Tom Reijnders
TOR Informatica
Chopinlaan 27
5242HM Rosmalen
Tel: 073 5226191
Fax: 073 5226196

This message and any attachment are intended solely for the addressee and may contain confidential information. If you have received this message in error, please send it back to me, and immediately delete it.   Please do not use, copy or disclose the information contained in this message or in any attachment.  Any views or opinions expressed by the author of this email do not necessarily reflect the views of the University of Nottingham.

This message has been checked for viruses but the contents of an attachment may still contain software viruses which could damage your computer system, you are advised to perform your own checks. Email communications with the University of Nottingham may be monitored as permitted by UK legislation.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.nottingham.ac.uk/pipermail/xerte-dev/attachments/20131123/08388288/attachment-0001.html>