[Xerte] Full install failing on page 4: No database selected

Sun Mar 7 18:09:11 GMT 2010

Pat's obviously helping you with this now and may beat me to this point but
just to clarify - have you edited demo.php to work with your LMS
authentication? If you haven't then regardless of your LMS authentication
everyone will be using the same xerte workspace. The demo.txt file just has
a single hard coded account and is not really meant for a live system and
clearly isn't secure. You may also need to make changes to session.php too
but probably best to get it working properly first before customising the
authentication.

Also in your previous reply you said "I added both as
application/octet-streams." I think that should be text/xml for .rlt and
.rlo 

it's .FLV that needs "flv-application/octet-stream"

HTH

Ron

From: xerte-bounces at lists.nottingham.ac.uk
[mailto:xerte-bounces at lists.nottingham.ac.uk] On Behalf Of Steve Ricketts
Sent: 07 March 2010 17:47
To: Xerte discussion list
Subject: RE: [Xerte] Full install failing on page 4: No database selected

From: Patrick.Lockley at nottingham.ac.uk

The reason the database name is blank is almost certainly because either the
setup folder or the root folder are not set to be writable to and so the
process fails.

SR: Actually, I had read in the setup instructions that the directories
needed to be writable so I set the whole xerte directory (and
subdirectories) to full access.

Your later paragraphs may well reflect the fact your sitedetails table is
basically empty, as your setup failed.

SR: Actually, no.  The sitedetails table is full of entries.  It was the
php_library_path field that I thought might have been incorrect... turns
out, it wasn't!.. so I put it back.

Switching from index to demo will not really achieve anything other than
removing the requirement for LDAP.

SR: Yep, that's what I was going for.  The developers will enter through our
LMS and as such will have already been authenticated.

sr

  _____  

From: xerte-bounces at lists.nottingham.ac.uk on behalf of Steve Ricketts
Sent: Sun 07/03/2010 16:35
To: Xerte discussion list
Subject: Re: [Xerte] Full install failing on page 4: No database selected

Amazing!!  Just like magic, thanks!  For some reason the database name was
blank in database.php.  Switched demo.txt to index.php.  Works fine now...
the setup that is.   Sad smile emoticon
<https://owa.nottingham.ac.uk/exchange/cczpl/Drafts/RE:%20%5bXerte%5d%20Full
%20install%20failing%20on%20page%204:%20No%20database%20selected.EML/1_multi
part/Emoticon10.gif> 

Thought I was home free, but tried to create a project.  That went fine.
Tried to edit... that didn't.  Got a 500 error.  Checked properties of that
project.  Got a JS error yelling about properties_ajax_php_path being
undefined.  Tried edit again... no 500 error but display basically locked.
Not "locked" locked, just the buttons didn't to anything.  Exited the
window, go another JS error: on line 30,
window_reference.edit_window_close_path(path)

Figured I had something wrong in the php path, took your #3 suggestion, and
found php_library_path field in sitedetails table set to
website_code/PHP/... thought I missed a config parameter and changed it to
where my PHP install physically resides (c:\program files (x86)\PHP\)... not
a good thing to do!  Nothing worked.  Decided I didn't know what the H I'm
doing and better post before I destroy more. 

sr

PS.  php_library_path returned to normal.

From: RonM <mailto:ronm at mitchellmedia.co.uk>  

Sent: Sunday, March 07, 2010 10:12 AM

To: 'Xerte <mailto:xerte at lists.nottingham.ac.uk>  discussion list' 

Subject: RE: [Xerte] Full install failing on page 4: No database selected

Hi Steve

I've had this kind of problem on windows/IIS installations too. So a couple
of suggestions but from memory...

1.       Try the installation again but before you submit page3 to page 4
check database.php which should be created automatically in the root of your
install but may not have all the correct values. If it doesn't edit that so
that it does and then submit page 3 to page 4.

2.       If that all works remember that if you haven't used ldap you will
need to rename index.php and either use switch.txt or demo.txt renamed to
index.php

3.       If steps 2 & 3 don't work check the site details table for errors
if some of the paths are incorrect try fixing those in the database.

Pat may have other suggestions but try this and post back to the list.

HTH

Ron

From: xerte-bounces at lists.nottingham.ac.uk
[mailto:xerte-bounces at lists.nottingham.ac.uk] On Behalf Of Steve Ricketts
Sent: 07 March 2010 14:41
To: Xerte discussion list
Subject: [Xerte] Full install failing on page 4: No database selected

I'm trying a new full install on Windows Vista with IIS.  It creates the
database fine but when I get to the 4th page there are a ton of errors all
ending with no database selected.  I've changed the setup/database.txt file
to reflect the current installation (found that in post) but there is no
change in the errors.  I basically left the mysql information on page3.php
alone.  Can anyone help me to the next step?

Thanks,

sr

PS. Regarding the discussion of forum vs. e-mail, as a newcomer the response
of the e-mail replies is terrific and very helpful.  However, what I really
would like is a way to easily look back at a threaded discussion on a
specific issue... I have many I need to chase and am reluctant to ask
questions about every silly thing that pops into my head.   Today, I used
the newly reference search function to find some information on the problem
mentioned above, but it was very difficult to follow.  There are multiple
topics in the threads and it's easy to loose your way... I'm not sure I
found all the references.

Is there no way to have your cake and eat it too... (then again what's the
purpose of having the cake in the first place!) where you can e-mail each
post in a forum to the mailing list?   You could have your forum topic areas
and those that wanted to follow that route could deal with a regular forum
(sub topics, search threads, etc.) and the mailing list people still get to
receive each post in their e-mail.

  _____  

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

  _____  

Hotmail: Trusted email with powerful SPAM protection. Sign up
<http://clk.atdmt.com/GBL/go/201469227/direct/01/>  now.

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.nottingham.ac.uk/pipermail/xerte/attachments/20100307/9feee85e/attachment.html