[Xerte] Problems installing Xerte

[Cowles T.]

I double checked the file and database_username, database_password were all set correctly, but database_host, database_name and database_prefix were set to their place holder values. 

I renamed the database.php file to old_database.php and ran through in install again so that a new database.php file would be created. The contents of the file is pasted below, with username and password hidden - but they are correct in the file.

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

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

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

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

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

	Tom


-----Original Message-----
From: xerte-bounces at lists.nottingham.ac.uk [mailto:xerte-bounces at lists.nottingham.ac.uk] On Behalf Of Patrick Lockley
Sent: 09 June 2010 11:51
To: Xerte discussion list
Subject: RE: [Xerte] Problems installing Xerte

Hello,

>From the look of the error message, it looks like maybe the setup 
>folder
wasn't set as writable?

'Insert into DATABASE_PREFIXsitedetails(site_id) VALUES ( "1")'

DATABASE_PREFIX - is a place holder in setup/database.txt which should be replaced by the value you set on page 2 of the installer.

Assuming your database prefix isn't DATABASE_PREFIX, I would guess removing this manually from database.php will fix it.

You might find that if the setup folder wasn't set as 777 then the .htaccess file won't have been written to the root folder either - should you have set the system to use the .htaccess file then you might hit problems.

Pat

-----Original Message-----
From: xerte-bounces at lists.nottingham.ac.uk
[mailto:xerte-bounces at lists.nottingham.ac.uk] On Behalf Of Cowles T.
Sent: 09 June 2010 11:34
To: Xerte discussion list
Subject: RE: [Xerte] Problems installing Xerte

Pat,

The root folder is writeable (777) and I have looked at the contents of the database.php file and it contains the correct values for the MySQL username and password.

	Tom


-----Original Message-----
From: xerte-bounces at lists.nottingham.ac.uk
[mailto:xerte-bounces at lists.nottingham.ac.uk] On Behalf Of Patrick Lockley
Sent: 09 June 2010 10:56
To: Xerte discussion list
Subject: RE: [Xerte] Problems installing Xerte

Hello,

It is probably because you didn't set your root folder as writable to.

So when the install program tries to write the database file into the root folder it fails.

So when the system goes looking for the database file it can't find it, and so it uses the default user.

Pat

-----Original Message-----
From: xerte-bounces at lists.nottingham.ac.uk
[mailto:xerte-bounces at lists.nottingham.ac.uk] On Behalf Of Cowles T.
Sent: 09 June 2010 10:53
To: xerte at lists.nottingham.ac.uk
Subject: [Xerte] Problems installing Xerte

I am installing Xerte on the following server:

Ubunutu 8.10
PHP 5.2.10
MySQL 5

After entering the username and password of the MySQL user I created for Xerte the installation then fails as it tries to enter information in to the database. 

An example of the error is:

The sitedetails site ID query insert into
DATABASE_PREFIXsitedetails(site_id) VALUES ( "1") has failed due to Access denied for user 'www-data'@'localhost' (using password: NO)

This looks to me as if it is trying to write to the MySQL database as the user www-data (which is the Apache user), and not as the user I specified in the previous step. 

	Tom


--
Tom Cowles
Systems Support Officer
Swansea University
t.cowles at swansea.ac.uk
01792 602 440 (Internal: 2440)


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