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

Sun Mar 7 18:20:04 GMT 2010

Getting Xerte working is my primary (and only) goal at this point.  I understand the security/everyone in one pot issues...  But that's ok for now.  I just want to show this to some of our users and we can work out the user access thing later.  

sr

From: ronm at mitchellmedia.co.uk
To: xerte at lists.nottingham.ac.uk
Subject: RE: [Xerte] Full install failing on page 4: No database selected
Date: Sun, 7 Mar 2010 18:09:11 +0000

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.  

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 

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

To: 'Xerte 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 now. 		 	   		  
_________________________________________________________________
Your E-mail and More On-the-Go. Get Windows Live Hotmail Free.
http://clk.atdmt.com/GBL/go/201469229/direct/01/
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.nottingham.ac.uk/pipermail/xerte/attachments/20100307/965e9cc9/attachment.html