[Xerte] walkthrough for installing toolkits

[jventola at verizon.net]

Not sure if this is what you want...

I don't see a database.php at the root when I use Filezilla.  If I enter the www directory and 
then the toolkits directory, the database.php is as follows:

<?
/**
* 
* 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 = "localhost";

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

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

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

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





-------------- Original message ---------------
Date sent:	Wed, 20 May 2009 20:00:09 +0100
From:	Patrick Lockley <Patrick.Lockley at nottingham.ac.uk>
Subject:	RE: [Xerte] walkthrough for installing toolkits
To:	"Xerte discussion list" <xerte at lists.nottingham.ac.uk>
Send reply to:	Xerte discussion list <xerte at lists.nottingham.ac.uk>

Got to type fast so I beat Ron...... d'oh :)

The first line should be the host - usually local host, or the name of the mysql server you are 
using. If you leave it blank I am not sure what happens.

I am not sure if your siteground login is the same user ID as for the database. From my 
experience of website packages you have to make your own accounts on the mysql server. 
Can you see the user table in the mysql database - that should have your accounts in.


If you create the database you'll need to give your account rights to use it, and then also flush 
priveleges.

The access denied messages are to indicate the installation of the last table has failed. I'll 
need to change that as I figured it was explicit. It might only fail on one or two things (and to 
be fair if it fails it means the system won't work - since we got round the magic quotes thing).

I am guessing that the user you created was for the database as well? Does that account 
have insert rights? To all tables?

If you're not sure something like

Select * from mysql.user 

should work

Could you post up the content of your site_root/database.php - leave out the password 
obviously.


From: xerte-bounces at lists.nottingham.ac.uk on behalf of jventola at verizon.net
Sent: Wed 20/05/2009 18:25
To: Xerte discussion list
Subject: RE: [Xerte] walkthrough for installing toolkits

I actually managed to install it, but when I navigate to the site, all I see is the numeral 1 in
upper left.

What I did was to take the advice to create a database in the cpanel.

On the "MySQL Database Creation page" of setup, I
left first line blank, used my normal login for siteground and entered the new database name
but left the prefix blank.

That seemed to work. I created a user account on the next screen. Then I hit Submit Query
at the bottom and got a lot of text with a lot of access denied for user messages. Still, at the
bottom it says the Installation is complete and provides a link to my toolkits site.

But, as I say, the page is empty except for one digit.



Date sent: Wed, 20 May 2009 08:50:33 +0100
From: Patrick Lockley <Patrick.Lockley at nottingham.ac.uk>
Subject: RE: [Xerte] walkthrough for installing toolkits
To: "Xerte discussion list" <xerte at lists.nottingham.ac.uk>
Send reply to: Xerte discussion list <xerte at lists.nottingham.ac.uk>

> What errors do you get?
>
> -----Original Message-----
> From: xerte-bounces at lists.nottingham.ac.uk
> [mailto:xerte-bounces at lists.nottingham.ac.uk] On Behalf Of
> jventola at verizon.net
> Sent: 20 May 2009 02:13
> To: xerte at lists.nottingham.ac.uk
> Subject: [Xerte] walkthrough for installing toolkits
>
> I have a hosted account (on Siteground) and would like to install
> Xerte toolkit. (I've managed moodle and drupal). I am getting errors
> about setting up the database when I run Setup. I am a tad beyond
> total newbie status when it comes to mysql and php. (Siteground has
> easy installers for the packages it supports.)
>
> Does anyone know of a walkthrough t