[Xerte] Running toolkits on IIS

Thu May 14 16:53:59 BST 2009

Hi Paul,

The list is fine. It's my preference.

That error messages means the account you entered on page 2 (not the
account for general site use, but the account to make the database)
doesn't have the rights to do so.

Can you find out from your sysadmin what rights that user has to the
database? Ideally the admin account would have all rights. For the site
account (the account PHP uses when running the site) would need select,
insert, update and delete.

Apologies for the hassle.

Thanks

Pat

From: xerte-bounces at lists.nottingham.ac.uk
[mailto:xerte-bounces at lists.nottingham.ac.uk] On Behalf Of Warde, Paul C
Sent: 14 May 2009 16:49
To: Xerte discussion list
Subject: RE: [Xerte] Running toolkits on IIS

Hi Pat

Hope this mailing list is the correct way to go about resolving these
issues.

Working through the setup, all works fine until I reach page 3 with all
the options. I have left these at their defaults and submit. 

Setup then fails on page 4 displaying numerous error messages all along
the line of  -The sitedetails site ID query insert into
sitedetails(site_id) VALUES ( "1") has failed due to Access denied for
user 'ODBC'@'localhost' (using password: NO)-

The sitedetails integration_config_path query update sitedetails set
integration_config_path="" where site_id="1" has failed due to Access
denied for user 'ODBC'@'localhost' (using password: NO)

Paul

________________________________

From: xerte-bounces at lists.nottingham.ac.uk
[mailto:xerte-bounces at lists.nottingham.ac.uk] On Behalf Of Patrick
Lockley
Sent: 14 May 2009 16:01
To: Xerte discussion list
Subject: RE: [Xerte] Running toolkits on IIS

We are waiting on the moodle zip patch.

You can leave elements on page 4 blank.

To test the code, try renaming demo.txt to something (but not demo.php)
and then running it.

From: xerte-bounces at lists.nottingham.ac.uk
[mailto:xerte-bounces at lists.nottingham.ac.uk] On Behalf Of Warde, Paul C
Sent: 14 May 2009 15:30
To: Xerte discussion list
Subject: RE: [Xerte] Running toolkits on IIS

Hi

Making progress, fixed the <? tag which was causing the install to fail.

We have no LDAP so setup is failing on page 4 - we do have a moodle -
how do I set up authentication from there?

Thanks

________________________________

From: xerte-bounces at lists.nottingham.ac.uk
[mailto:xerte-bounces at lists.nottingham.ac.uk] On Behalf Of Patrick
Lockley
Sent: 14 May 2009 14:58
To: Xerte discussion list
Subject: RE: [Xerte] Running toolkits on IIS

Sorry, still eating lunch J

Page 3 and 4 of the web based installer.

So download toolkits (see list archive for a video)

Use a web browser to run the installer

Do the database questions (you need mysql)

Then the last page appears with lots of options on. 

One of these it the apache option

Search for "The HTACCESS setting is (Whether or not you are using a
.htaccess file on the site - the apache config must allow for
overrides)"

Looking at the code, it is set to false by default anyways.

So this should work on IIS 

You might need to sort out authentication from somewhere else, maybe a
moodle or LDAP?

From: xerte-bounces at lists.nottingham.ac.uk
[mailto:xerte-bounces at lists.nottingham.ac.uk] On Behalf Of Warde, Paul C
Sent: 14 May 2009 14:53
To: Xerte discussion list
Subject: RE: [Xerte] Running toolkits on IIS

Thanks Pat

I'm somewhat technically challenged, so when you say - set apache to be
false - where is this done?

Paul

________________________________

From: xerte-bounces at lists.nottingham.ac.uk
[mailto:xerte-bounces at lists.nottingham.ac.uk] On Behalf Of Patrick
Lockley
Sent: 14 May 2009 14:46
To: Xerte discussion list
Subject: RE: [Xerte] Running toolkits on IIS

Yes, we have done so on a system.

It needs PHP and MySQL still

When you install the system - set apache to be false (it's a textfield
so just type it in).

The only requirement it had for apache was mod_rewrite, everything is I
believe, web server independent.

From: xerte-bounces at lists.nottingham.ac.uk
[mailto:xerte-bounces at lists.nottingham.ac.uk] On Behalf Of Warde, Paul C
Sent: 14 May 2009 14:42
To: xerte at lists.nottingham.ac.uk
Subject: [Xerte] Running toolkits on IIS

Hi

Is it possible to run the Online Toolkit on a IIS server?

Paul

Paul Warde 
ILT Technical Support Worker 
Bury Libraries and Adult Learning Service

4* Excellent Council
Bury Council is now rated as a four star 'excellent' council by the
Audit Commission.
This rating recognises the council's commitment to providing first class
services
and providing good value for money.
-----------------------------------------------------------------
Why not visit our website www.bury.gov.uk
-----------------------------------------------------------------
Incoming and outgoing e-mail messages are routinely monitored for
compliance
with our information security policy.
The information contained in this e-mail and any files transmitted
with it is for the intended recipient(s) alone. It may contain
confidential information that is exempt from the disclosure under
English law and may also be covered by legal,professional or other
privilege.
If you are not the intended recipient, you must not copy, distribute or
take any
action in reliance on it. 
If you have received this e-mail in error, please notify us immediately
by using 
the reply facility on your e-mail system.
If this message is being transmitted over the Internet, be aware that it
may be 
intercepted by third parties.
As a public body, the Council may be required to disclose this e-mail or
any 
response to it under the Freedom of Information Act 2000 unless the
information
in it is covered by one of the exemptions in the Act.  
Electronic service accepted only at legalservices at bury.gov.uk and on fax
number 
0161 253 5119 .
*************************************************************

4* Excellent Council
Bury Council is now rated as a four star 'excellent' council by the
Audit Commission.
This rating recognises the council's commitment to providing first class
services
and providing good value for money.
-----------------------------------------------------------------
Why not visit our website www.bury.gov.uk
-----------------------------------------------------------------
Incoming and outgoing e-mail messages are routinely monitored for
compliance
with our information security policy.
The information contained in this e-mail and any files transmitted
with it is for the intended recipient(s) alone. It may contain
confidential information that is exempt from the disclosure under
English law and may also be covered by legal,professional or other
privilege.
If you are not the intended recipient, you must not copy, distribute or
take any
action in reliance on it. 
If you have received this e-mail in error, please notify us immediately
by using 
the reply facility on your e-mail system.
If this message is being transmitted over the Internet, be aware that it
may be 
intercepted by third parties.
As a public body, the Council may be required to disclose this e-mail or
any 
response to it under the Freedom of Information Act 2000 unless the
information
in it is covered by one of the exemptions in the Act.  
Electronic service accepted only at legalservices at bury.gov.uk and on fax
number 
0161 253 5119 .
*************************************************************

4* Excellent Council
Bury Council is now rated as a four star 'excellent' council by the
Audit Commission.
This rating recognises the council's commitment to providing first class
services
and providing good value for money.
-----------------------------------------------------------------
Why not visit our website www.bury.gov.uk
-----------------------------------------------------------------
Incoming and outgoing e-mail messages are routinely monitored for
compliance
with our information security policy.
The information contained in this e-mail and any files transmitted
with it is for the intended recipient(s) alone. It may contain
confidential information that is exempt from the disclosure under
English law and may also be covered by legal,professional or other
privilege.
If you are not the intended recipient, you must not copy, distribute or
take any
action in reliance on it. 
If you have received this e-mail in error, please notify us immediately
by using 
the reply facility on your e-mail system.
If this message is being transmitted over the Internet, be aware that it
may be 
intercepted by third parties.
As a public body, the Council may be required to disclose this e-mail or
any 
response to it under the Freedom of Information Act 2000 unless the
information
in it is covered by one of the exemptions in the Act.  
Electronic service accepted only at legalservices at bury.gov.uk and on fax
number 
0161 253 5119 .
*************************************************************

4* Excellent Council
Bury Council is now rated as a four star 'excellent' council by the
Audit Commission.
This rating recognises the council's commitment to providing first class
services
and providing good value for money.
-----------------------------------------------------------------
Why not visit our website www.bury.gov.uk
-----------------------------------------------------------------
Incoming and outgoing e-mail messages are routinely monitored for
compliance
with our information security policy.
The information contained in this e-mail and any files transmitted
with it is for the intended recipient(s) alone. It may contain
confidential information that is exempt from the disclosure under
English law and may also be covered by legal,professional or other
privilege.
If you are not the intended recipient, you must not copy, distribute or
take any
action in reliance on it. 
If you have received this e-mail in error, please notify us immediately
by using 
the reply facility on your e-mail system.
If this message is being transmitted over the Internet, be aware that it
may be 
intercepted by third parties.
As a public body, the Council may be required to disclose this e-mail or
any 
response to it under the Freedom of Information Act 2000 unless the
information
in it is covered by one of the exemptions in the Act.  
Electronic service accepted only at legalservices at bury.gov.uk and on fax
number 
0161 253 5119 .
*************************************************************

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.nottingham.ac.uk/pipermail/xerte/attachments/20090514/0961dfd7/attachment.html