[Xerte-dev] Re: Xerte Installation on a Centos - Blank Databaseerties

Tom Reijnders reijnders at tor.nl
Thu May 9 20:06:37 BST 2013


I cannot reproduce this on Linux (Chrome, IE9 and Firefox 20).

The only thing I noticed and didn't realize before and is different then 
other installations I've seen on Linux web packages is page2.php.

'MySQL Database Account Set up page'

You HAVE to fill in a valid mysql user, and the user HAS to have rights 
for the db created on page1.php. NO user account is created for you.

Is someone prepared to send me a sequence of screenshots displaying the 
issue by PM?

The database.php should have been created  after pressing 'Next' on 
page2.php

There were issues with previous install packages if you didn't finish 
the install and restarted it. That almost never worked correctly. But 
that is fixed in the installer you report as being used. (this 
particular problem was fixed in SVN rev874)

If you still have the setup folder, check the contents of database.txt. 
It should NOT have been modified. It has to be the same as the original 
one from the .zip.

Regards,

Tom





Op 9-5-2013 19:32, Tom Reijnders schreef:
> I'll have a look. I'll do a test install on a Linux box tonight.
>
> Op 9-5-2013 16:20, Smith, John schreef:
>>
>> Hi Tom,
>>
>> Yes the latest version from the community site. I had the exact same 
>> error (yesterday) and after manually adding the details to 
>> database.php and getting page4 to run it appeared to setup properly 
>> however enabling db auth and going to management and trying to add a 
>> user giver the error I posted yesterday so something still isn't right...
>>
>> Regards,
>>
>> John Smith
>>
>> Learning Technologist
>>
>> School of Health & Life Sciences
>>
>> Glasgow Caledonian University
>>
>> *From:*xerte-dev-bounces at lists.nottingham.ac.uk 
>> [mailto:xerte-dev-bounces at lists.nottingham.ac.uk] *On Behalf Of 
>> *Thomas Rochford
>> *Sent:* Thursday, May 09, 2013 3:12 PM
>> *To:* For Xerte technical developers
>> *Subject:* [Xerte-dev] Re: Xerte Installation on a Centos - Blank 
>> Databaseerties
>>
>> Just spoke with Mark (We were both at another meeting today). They're 
>> using the most recent, i.e. 2 days old, version. He's going to edit 
>> database.php manually, restart the install and then go to 
>> setup/page4.php if all else fails.
>>
>> Thomas
>> =======================
>> Sent from my Windows 8 Phone
>> Please excuse brevity & typos
>> eml: thomas.rochford at jiscadvance.ac.uk 
>> <mailto:thomas.rochford at jiscadvance.ac.uk>
>> mob: 07500 669002
>>
>> ------------------------------------------------------------------------
>>
>> *From: *Tom Reijnders <mailto:reijnders at tor.nl>
>> *Sent: *?09/?05/?2013 11:23
>> *To: *For Xerte technical developers 
>> <mailto:xerte-dev at lists.nottingham.ac.uk>
>> *Subject: *[Xerte-dev] Re: Xerte Installation on a Centos - Blank 
>> Databaseerties
>>
>> Do you happen to know what version of the installer you are using? See
>> version.txt
>>
>> Tom
>>
>> Op 8-5-2013 16:19, Smith, John schreef:
>> > Hi Mark,
>> >
>> > I just did an install today as well and the same happened to me so 
>> something is obviously broken in the package... I had to go into the 
>> newly created database.php and manually enter the correct values to 
>> connect to the database. Then refreshed the browser on step 4 and 
>> clicked ok to resubmit the posted data and this time it went through 
>> fine...
>> >
>> > Hope that helps in the meantime until we fix...
>> >
>> > So the steps are (if you are no longer on page 4)
>> >
>> >      Delete database.php
>> >      Go through the process until step 4 bombs
>> >      Manually enter the host/db_Name/User/password into the newly 
>> created database.php file
>> >      Go back to your browser and refresh page 4
>> >
>> > Regards,
>> >
>> > John Smith
>> > Learning Technologist
>> > School of Health & Life Sciences
>> > Glasgow Caledonian University
>> >
>> >
>> > -----Original Message-----
>> > From: xerte-bounces at lists.nottingham.ac.uk 
>> <mailto:xerte-bounces at lists.nottingham.ac.uk> 
>> [mailto:xerte-bounces at lists.nottingham.ac.uk] On Behalf Of Chaney, Mark
>> > Sent: Wednesday, May 08, 2013 3:08 PM
>> > To: Xerte discussion list
>> > Subject: [Xerte] Xerte Installation on a Centos - Blank Database erties
>> >
>> > Hi all,
>> >
>> > I have done a test installation of xerte on a test server and have 
>> some strange behaviour. On the last page of the installation (Page 4) 
>> the database name wasn't inserted into the database php file. Thus it 
>> was giving me an error of database not selected.
>> >
>> > Attempting to get into the management side of the system I found I 
>> couldn't access it. Upon inspection there is no data what so ever in 
>> the sitedetails database table other than (what I assume is an auto 
>> incremental number) the id of 1. There is no site_url, apache, 
>> admin_username, admin_password .... etc etc.
>> >
>> > It looks like somewhere a section of a script failed to run without 
>> throwing an error?
>> >
>> > To try and pre-empt some questions:
>> > Centos 6 server.
>> > Install ran ok up untill page4
>> > Same server as I have 7 fully working moodle installs. Apache and 
>> php are ok. SE linux off.
>> > Mysql installed and working.
>> > Xerte database accessible and can be queries from workbench on 
>> external machine and on server itself.
>> > File/Folder permissions set according to docs/instructions.
>> >
>> > Any help would be much appreciated.
>> >
>> > Thanks
>> >
>> > Mark Chaney
>> > mchaney at bedford.ac.uk <mailto:mchaney at bedford.ac.uk>
>> > Learning Technologies Adviser
>> > Bedford College
>> > Cauldwell Street, Bedford, MK42 9AH
>> > _______________________________________________
>> > Xerte mailing list
>> > Xerte at lists.nottingham.ac.uk <mailto:Xerte at lists.nottingham.ac.uk>
>> > http://lists.nottingham.ac.uk/mailman/listinfo/xerte
>> >
>> > Glasgow Caledonian University is a registered Scottish charity, 
>> number SC021474
>> >
>> > Winner: Times Higher Education's Widening Participation Initiative 
>> of the Year 2009 and Herald Society's Education Initiative of the 
>> Year 2009.
>> > 
>> http://www.gcu.ac.uk/newsevents/news/bycategory/theuniversity/1/name,6219,en.html
>> >
>> > Winner: Times Higher Education's Outstanding Support for Early 
>> Career Researchers of the Year 2010, GCU as a lead with Universities 
>> Scotland partners.
>> > 
>> http://www.gcu.ac.uk/newsevents/news/bycategory/theuniversity/1/name,15691,en.html
>> > _______________________________________________
>> > Xerte-dev mailing list
>> > Xerte-dev at lists.nottingham.ac.uk 
>> <mailto: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
>>
>>
>> _______________________________________________
>> Xerte-dev mailing list
>> Xerte-dev at lists.nottingham.ac.uk 
>> <mailto:Xerte-dev at lists.nottingham.ac.uk>
>> http://lists.nottingham.ac.uk/mailman/listinfo/xerte-dev
>>
>>
>>
>> Glasgow Caledonian University is a registered Scottish charity, 
>> number SC021474
>>
>> Winner: Times Higher Education's Widening Participation Initiative of 
>> the Year 2009 and Herald Society's Education Initiative of the Year 2009.
>> http://www.gcu.ac.uk/newsevents/news/bycategory/theuniversity/1/name,6219,en.html
>>
>> Winner: Times Higher Education's Outstanding Support for Early Career 
>> Researchers of the Year 2010, GCU as a lead with Universities 
>> Scotland partners.
>> http://www.gcu.ac.uk/newsevents/news/bycategory/theuniversity/1/name,15691,en.html
>>
>>
>> _______________________________________________
>> 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
>
>
>
>
>
>
> _______________________________________________
> 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

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.nottingham.ac.uk/pipermail/xerte-dev/attachments/20130509/6457d47e/attachment-0001.html>
-------------- next part --------------
<?php 
/**
 * 
 * database page, has the settings for database connection
 *
 * @author Patrick Lockley
 * @version 1.0
 * @copyright Copyright (c) 2008,2009 University of Nottingham
 * @package
 */

/*
 * Host where database is
 */
$xerte_toolkits_site->database_host = "DATABASE_HOST";

/*
 * Username for database
 */
$xerte_toolkits_site->database_username ="DATABASE_USERNAME";

/*
 * Password for database
 */
$xerte_toolkits_site->database_password ="DATABASE_PASSWORD";

/*
 * Database name
 */
$xerte_toolkits_site->database_name ="DATABASE_NAME";

/*
 * Database table prefix
 */
$xerte_toolkits_site->database_table_prefix ="DATABASE_PREFIX";
   


More information about the Xerte-dev mailing list