<div dir="ltr">you don't have to use a prefix - that's mostly if you want to mdl_ it with moodle</div><div class="gmail_extra"><br><br><div class="gmail_quote">On Sat, Nov 23, 2013 at 11:06 AM, <span dir="ltr"><<a href="mailto:thomas.rochford@jiscadvance.ac.uk" target="_blank">thomas.rochford@jiscadvance.ac.uk</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div dir="ltr">
<div dir="ltr" style="font-family:'Calibri','Arial','Segoe UI','Meiryo','Microsoft YaHei UI','Microsoft JhengHei UI','Malgun Gothic';font-size:12pt"><div>Doh!</div>
<div><br></div><div>Thank you so much Tom, I’ld completely forgotten about the DB authentication - too much else on my mind at the moment.</div><div><br></div><div>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?</div>
<div><br></div><div>The relevant sections from config.php are below (the ‘cambrid1_’ is required by the Hosting provider):</div><span lang="EN-GB"><div><br></div><div><p>/*<br>* Host where database is<br>*/<br>$xerte_toolkits_site->database_host = "localhost"; <br>
/*<br>* Username for database<br>*/<br>$xerte_toolkits_site->database_username ="cambrid1_********"; <br>/*<br>* Password for database<br>*/<br>$xerte_toolkits_site->database_password ="********"; <br>
/*<br>* Database name<br>*/<br>$xerte_toolkits_site->database_name ="cambrid1_toolkits"; <br>/*<br>* Database table prefix<br>*/<br>$xerte_toolkits_site->database_table_prefix ="";</p>
<p> </p></div></span><div><br></div><div><div>Kindest Regards,<br>Thomas<br>==========================================================<br>Thomas Rochford | e-Learning Advisor | Jisc RSC Eastern<br>Tel: 01223 564749 | Mobile: 07500 669002 | Skype: cambridge.serendipity<br>
Email: <a href="mailto:thomas.rochford@jiscadvance.ac.uk" target="_blank">thomas.rochford@jiscadvance.ac.uk</a> | Web: <a href="http://www.jiscrsc.ac.uk/eastern" target="_blank">http://www.jiscrsc.ac.uk/eastern</a> <br>
Cambridge Serendipity, 35 Gough Way, Cambridge, CB3 9LN<br>For the full range of RSC UK events, resources and blog, visit <a href="http://www.jiscrsc.ac.uk" target="_blank">http://www.jiscrsc.ac.uk</a></div><div><br></div>
</div><div style="padding-top:5px;border-top-color:rgb(229,229,229);border-top-width:1px;border-top-style:solid"><div><font face=" 'Calibri', 'Arial', 'Segoe UI', 'Meiryo', 'Microsoft YaHei UI', 'Microsoft JhengHei UI', 'Malgun Gothic'" style="line-height:15pt;letter-spacing:0.02em;font-family:"Calibri","Arial","Segoe UI","Meiryo","Microsoft YaHei UI","Microsoft JhengHei UI","Malgun Gothic";font-size:12pt"><b>From:</b> <a href="mailto:reijnders@tor.nl" target="_blank">Tom Reijnders</a><br>
<b>Sent:</b> Saturday, 23 November 2013 00:13<br><b>To:</b> <a href="mailto:xerte-dev@lists.nottingham.ac.uk" target="_blank">For Xerte technical developers</a></font></div></div><div><br></div><div dir="">
Thomas,<br>
<br>
I'll look at the installation.<br>
<br>
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.<br>
<br>
The reference to MariaDB is possible, as mariadb is a plugin
replacement for MySQL, so the provider probably uses MariaDB.<br>
<br>
<br>
Tom<br>
<br>
<div><a href="mailto:thomas.rochford@jiscadvance.ac.uk" target="_blank">thomas.rochford@jiscadvance.ac.uk</a>
schreef op 22-11-2013 23:35:<br>
</div>
<blockquote style="margin-top:0px;margin-bottom:0px">
<div>Hi,</div>
<div><br>
</div>
<div>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)</div>
<div><br>
</div>
<div>It can also run Xerte online toolkits so I though I’ld try
a new installation and have run into couple of problems</div>
<div><br>
</div>
<div>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’</div>
<div><br>
</div>
<div>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</div>
<div><br>
</div>
<div>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.</div>
<div><br>
</div>
<div>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.<br>
</div>
<div>
<div><br>
</div>
<div>Kindest Regards,<br>
Thomas<br>
==========================================================<br>
Thomas Rochford | e-Learning Advisor | Jisc RSC Eastern<br>
Tel: 01223 564749 | Mobile: 07500 669002 | Skype:
cambridge.serendipity<br>
Email: <a href="mailto:thomas.rochford@jiscadvance.ac.uk" target="_blank">thomas.rochford@jiscadvance.ac.uk</a> | Web:
<a href="http://www.jiscrsc.ac.uk/eastern" target="_blank">http://www.jiscrsc.ac.uk/eastern</a> <br>
Cambridge Serendipity, 35 Gough Way, Cambridge, CB3 9LN<br>
For the full range of RSC UK events, resources and blog,
visit <a href="http://www.jiscrsc.ac.uk" target="_blank">http://www.jiscrsc.ac.uk</a></div>
<div><br>
</div>
</div>
<div style="padding-top:5px;border-top-color:rgb(229,229,229);border-top-width:1px;border-top-style:solid">
<div><font face=" 'Calibri', 'Arial', 'Segoe UI', 'Meiryo', 'Microsoft YaHei UI', 'Microsoft JhengHei UI', 'Malgun Gothic'" style="line-height:15pt;letter-spacing:0.02em;font-family:"Calibri","Arial","Segoe UI","Meiryo","Microsoft YaHei UI","Microsoft JhengHei UI","Malgun Gothic";font-size:12pt"><b>From:</b> <a href="mailto:xerte@pgogywebstuff.com" target="_blank">Pat
@ Pgogy</a><br>
<b>Sent:</b> Tuesday, 12 November 2013 18:11<br>
<b>To:</b> <a href="mailto:xerte-dev@lists.nottingham.ac.uk" target="_blank">For Xerte technical developers</a></font></div>
</div>
<div><br>
</div>
<div dir="">
<div dir="ltr">Or just set a mobile CSS that doesn't show any
folders?</div>
<div class="gmail_extra"><br>
<br>
<div class="gmail_quote">On Tue, Nov 12, 2013 at 10:20 AM,
Julian Tenney <span dir="ltr"><<a href="mailto:Julian.Tenney@nottingham.ac.uk" target="_blank">Julian.Tenney@nottingham.ac.uk</a>></span>
wrote:<br>
<blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;padding-left:1ex;border-left-color:rgb(204,204,204);border-left-width:1px;border-left-style:solid">
<div lang="EN-GB">
<div>
<p class="MsoNormal"><span style="color:rgb(31,73,125);font-family:"Calibri","sans-serif";font-size:11pt">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.</span></p>
<p class="MsoNormal"><span style="color:rgb(31,73,125);font-family:"Calibri","sans-serif";font-size:11pt"> </span></p>
<div>
<div style="border-width:1pt medium medium;border-style:solid none none;border-color:rgb(181,196,223) black black;padding:3pt 0cm 0cm">
<p class="MsoNormal"><b><span lang="EN-US" style="font-family:"Tahoma","sans-serif";font-size:10pt">From:</span></b><span lang="EN-US" style="font-family:"Tahoma","sans-serif";font-size:10pt"> <a href="mailto:xerte-dev-bounces@lists.nottingham.ac.uk" target="_blank">xerte-dev-bounces@lists.nottingham.ac.uk</a>
[mailto:<a href="mailto:xerte-dev-bounces@lists.nottingham.ac.uk" target="_blank">xerte-dev-bounces@lists.nottingham.ac.uk</a>]
<b>On Behalf Of </b><a href="mailto:thomas.rochford@jiscadvance.ac.uk" target="_blank">thomas.rochford@jiscadvance.ac.uk</a><br>
<b>Sent:</b> 11 November 2013 21:44<br>
<b>To:</b> For Xerte technical developers<br>
<b>Subject:</b> [Xerte-dev] Food for thought
or wishlist</span></p>
</div>
</div>
<div>
<div>
<p class="MsoNormal"> </p>
<div>
<div>
<p class="MsoNormal"><span style="font-family:"Calibri","sans-serif"">Good
evening,</span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Calibri","sans-serif""> </span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Calibri","sans-serif"">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.</span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Calibri","sans-serif""> </span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Calibri","sans-serif"">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.</span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Calibri","sans-serif""> </span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Calibri","sans-serif"">I
feel this is a problem that will need to
be solved anyway as XoT moves towards an
HTML-compliant editor.</span></p>
</div>
<div>
<div>
<p class="MsoNormal"><span style="font-family:"Calibri","sans-serif""> </span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Calibri","sans-serif"">Kindest
Regards,<br>
Thomas<br>
==========================================================<br>
Thomas Rochford | e-Learning
Advisor | Jisc RSC Eastern<br>
Tel: 01223 564749 | Mobile: 07500
669002 | Skype:
cambridge.serendipity<br>
Email: <a href="mailto:thomas.rochford@jiscadvance.ac.uk" target="_blank">thomas.rochford@jiscadvance.ac.uk</a>
| Web: <a href="http://www.jiscrsc.ac.uk/eastern" target="_blank">http://www.jiscrsc.ac.uk/eastern</a>
<br>
Cambridge Serendipity, 35 Gough Way,
Cambridge, CB3 9LN<br>
For the full range of RSC UK events,
resources and blog, visit <a href="http://www.jiscrsc.ac.uk" target="_blank">http://www.jiscrsc.ac.uk</a></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Calibri","sans-serif""> </span></p>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
<br>
_______________________________________________<br>
Xerte-dev mailing list<br>
<a href="mailto:Xerte-dev@lists.nottingham.ac.uk" target="_blank">Xerte-dev@lists.nottingham.ac.uk</a><br>
<a href="http://lists.nottingham.ac.uk/mailman/listinfo/xerte-dev" target="_blank">http://lists.nottingham.ac.uk/mailman/listinfo/xerte-dev</a><br>
<br>
</blockquote>
</div>
<br>
</div>
</div>
<br>
<fieldset></fieldset>
<br>
<pre>_______________________________________________
Xerte-dev mailing list
<a href="mailto:Xerte-dev@lists.nottingham.ac.uk" target="_blank">Xerte-dev@lists.nottingham.ac.uk</a>
<a href="http://lists.nottingham.ac.uk/mailman/listinfo/xerte-dev" target="_blank">http://lists.nottingham.ac.uk/mailman/listinfo/xerte-dev</a>
</pre>
</blockquote>
<br>
<pre>--
--
Tom Reijnders
TOR Informatica
Chopinlaan 27
5242HM Rosmalen
Tel: 073 5226191
Fax: 073 5226196
</pre>
<br>
<p>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.</p>
<p>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.</p>
<br>
</div></div>
</div>
<br>_______________________________________________<br>
Xerte-dev mailing list<br>
<a href="mailto:Xerte-dev@lists.nottingham.ac.uk">Xerte-dev@lists.nottingham.ac.uk</a><br>
<a href="http://lists.nottingham.ac.uk/mailman/listinfo/xerte-dev" target="_blank">http://lists.nottingham.ac.uk/mailman/listinfo/xerte-dev</a><br>
<br></blockquote></div><br></div>