[Xerte] Re: Xerte Online Toolkits: Installation Guide
Pat Lockley
patrick.lockley at googlemail.com
Fri Jan 6 20:31:53 GMT 2012
use this switch.txt instead
On Fri, Jan 6, 2012 at 3:35 PM, Pat Lockley
<patrick.lockley at googlemail.com> wrote:
> i knew / suspected the page wouldn't work.
>
> Will have a look later as to why (php errors)
>
> On Fri, Jan 6, 2012 at 3:17 PM, MTG Judge Course <info at mtgjc.com> wrote:
>> Yeah, I tried that, and was able to get past the login screen, but
>> everything comes up blank. (Once I log in, /xerte/index.php is blank.)
>>
>> Sigh... I'm beginning to think the universe is working against me on this
>> one.
>>
>> -----Original Message-----
>> From: xerte-bounces at lists.nottingham.ac.uk
>> [mailto:xerte-bounces at lists.nottingham.ac.uk] On Behalf Of Pat Lockley
>> Sent: Friday, January 06, 2012 9:56 AM
>> To: Xerte discussion list
>> Subject: [Xerte] Re: Xerte Online Toolkits: Installation Guide
>>
>> In the zip root folder is a file called switch.txt which you can replace
>> index.php with if you've not got LDAP.
>>
>> Edit switch.txt and you'll see the passwords and such like.
>>
>> I'm not sure it works at present, so try renaming switch.txt to index.php.
>>
>> On Fri, Jan 6, 2012 at 2:49 PM, MTG Judge Course <info at mtgjc.com> wrote:
>>> Thanks everyone for your help with this! It actually turned out that
>>> the problem was a permissions setting with the database that GoDaddy
>>> had to fix... I guess that's why all the searching for an issue on my
>>> end turned up nothing! This is a recurring problem, I understand, with
>>> having a shared hosting account.
>>>
>>> I was able after that to complete the install of Xerte, but I do not
>>> have LDAP, and I was wondering if there were instructions somewhere
>>> about how to install without LDAP. This installation of Xerte will
>>> only be used by one or two people, and using the same authentication,
>>> so I'm hoping to be able to bypass LDAP.
>>>
>>> Any help would be gratefully received! :)
>>>
>>> -----Original Message-----
>>> From: xerte-bounces at lists.nottingham.ac.uk
>>> [mailto:xerte-bounces at lists.nottingham.ac.uk] On Behalf Of Pat Lockley
>>> Sent: Wednesday, January 04, 2012 2:12 PM
>>> To: Xerte discussion list
>>> Subject: [Xerte] Re: Xerte Online Toolkits: Installation Guide
>>>
>>> i would suggest something like this
>>>
>>> <?PHP
>>>
>>> include "database.php";
>>>
>>> $response = mysql_connect(settings from database.php);
>>>
>>> print_r($response);
>>>
>>> ?>
>>>
>>> Save that in a php file in the root directory
>>>
>>> On Wed, Jan 4, 2012 at 6:59 PM, MTG Judge Course <info at mtgjc.com> wrote:
>>>> LOL. Too true!! =)
>>>>
>>>> Yes, I'm decent with PHP, but not expert, and I fear I've surpassed
>>>> the limits of my ability to scour the PHP for where the problem might
>> lie.
>>>>
>>>>
>>>> -----Original Message-----
>>>> From: xerte-bounces at lists.nottingham.ac.uk
>>>> [mailto:xerte-bounces at lists.nottingham.ac.uk] On Behalf Of Pat
>>>> Lockley
>>>> Sent: Wednesday, January 04, 2012 11:28 AM
>>>> To: Xerte discussion list
>>>> Subject: [Xerte] Re: Xerte Online Toolkits: Installation Guide
>>>>
>>>> Yep, it should all work, but then if it should all work I can't think
>>>> what to suggest to help.
>>>>
>>>> Are you ok with PHP?
>>>>
>>>> On Wed, Jan 4, 2012 at 3:37 PM, MTG Judge Course <info at mtgjc.com> wrote:
>>>>> I set the host, username, and password in the installation steps.
>>>>> The installer was able to create the database in the proper place
>>>>> using this information. So unless I'm really confused, that should
>>>>> mean that the host, username, and password are all correct, and that
>>>>> the user has the appropriate rights to the database??
>>>>>
>>>>> The host and username are below. I'm omitting certain pieces of
>>>>> information since I believe these list communications are publicly
>>>> accessible.
>>>>>
>>>>> Host: mtg1*7.db.8777228.hostedresource.com
>>>>> Username: mtg1*7
>>>>> Password: ***** [my password that works when accessing the db via
>>>>> PHPMyAdmin or ODBC connection]
>>>>>
>>>>>
>>>>> -----Original Message-----
>>>>> From: xerte-bounces at lists.nottingham.ac.uk
>>>>> [mailto:xerte-bounces at lists.nottingham.ac.uk] On Behalf Of Pat
>>>>> Lockley
>>>>> Sent: Wednesday, January 04, 2012 10:25 AM
>>>>> To: Xerte discussion list
>>>>> Subject: [Xerte] Re: Xerte Online Toolkits: Installation Guide
>>>>>
>>>>> Ok,
>>>>>
>>>>> It might be the host details - what is the host set as?
>>>>>
>>>>> Pat
>>>>>
>>>>> On Wed, Jan 4, 2012 at 3:19 PM, MTG Judge Course <info at mtgjc.com> wrote:
>>>>>> Thanks so much for your response. I've checked the database.php
>>>>>> file, and all appears to be correct. I have a GoDaddy basic
>>>>>> account, so I cannot create more than one user for each database. I
>>>>>> only have one username and password, and that username of course
>>>>>> has full access of every type to the database.
>>>>>>
>>>>>> Note that during setup, this same username/password was used to
>>>>>> *create* the database tables. Everything appeared to be working
>>>>>> perfectly until I tried to use Xerte and it gave me that error message.
>>>>>>
>>>>>> Blargh! :)
>>>>>>
>>>>>> -----Original Message-----
>>>>>> From: xerte-bounces at lists.nottingham.ac.uk
>>>>>> [mailto:xerte-bounces at lists.nottingham.ac.uk] On Behalf Of Pat
>>>>>> Lockley
>>>>>> Sent: Tuesday, January 03, 2012 2:30 PM
>>>>>> To: Xerte discussion list
>>>>>> Subject: [Xerte] Re: Xerte Online Toolkits: Installation Guide
>>>>>>
>>>>>> The username in database.php isn't allowed to access the database
>>>>>> the installer created
>>>>>>
>>>>>> If you have cPanel check to see if the account you're using in
>>>>>> database.php has select,delete,insert and update privileges for
>>>>>> that
>>>>> database.
>>>>>>
>>>>>> On Tue, Jan 3, 2012 at 7:23 PM, MTG Judge Course <info at mtgjc.com>
>> wrote:
>>>>>>> I tried to install Xerte online and ran into a roadblock. I
>>>>>>> followed all the installation directions to the letter, and the
>>>>>>> installation script successfully created all the Xerte tables in
>>>>>>> the database I’d set
>>>>>> up for it.
>>>>>>> However, when I try to access the Xerte installation, it says:
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>> “Sorry, the system cannot connect to the database at present. The
>>>>>>> mysql error is Access denied for user 'mtg5[..]8'@'184.[..].193'
>>>>>>> (using
>>>>>> password:
>>>>>>> YES)”
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>> My website is hosted through GoDaddy.
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>> Thanks!!!
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>> This message and any attachment are intended solely for the
>>>>>>> addressee and may contain confidential information. If you have
>>>>>>> received this message in error, please send it back to me, and
>>>>>>> immediately delete it. Please do not use, copy or disclose the
>>>>>>> information contained in this message or in any attachment. Any
>>>>>>> views or opinions expressed by the author of this email do not
>>>>>>> necessarily reflect the views of the
>>>>>> University of Nottingham.
>>>>>>>
>>>>>>> This message has been checked for viruses but the contents of an
>>>>>>> attachment may still contain software viruses which could damage
>>>>>>> your
>>>>>> computer system:
>>>>>>> you are advised to perform your own checks. Email communications
>>>>>>> with the University of Nottingham may be monitored as permitted by
>>>>>>> UK
>>>>>> legislation.
>>>>>>>
>>>>>>>
>>>>>>> _______________________________________________
>>>>>>> Xerte mailing list
>>>>>>> Xerte at lists.nottingham.ac.uk
>>>>>>> http://lists.nottingham.ac.uk/mailman/listinfo/xerte
>>>>>>>
>>>>>>> This message and any attachment are intended solely for the
>>>>>>> addressee and may contain confidential information. If you have
>>>>>>> received this message in error, please send it back to me, and
>>>>>>> immediately delete it. Please do not use, copy or disclose the
>>>>>>> information contained in this message or in any attachment. Any
>>>>>>> views or opinions expressed by the author of this email do not
>>>>>>> necessarily reflect the views of the
>>>>>> University of Nottingham.
>>>>>>>
>>>>>>> This message has been checked for viruses but the contents of an
>>>>>>> attachment may still contain software viruses which could damage
>>>>>>> your
>>>>>> computer system:
>>>>>>> you are advised to perform your own checks. Email communications
>>>>>>> with the University of Nottingham may be monitored as permitted by
>>>>>>> UK
>>>>>> legislation.
>>>>>>>
>>>>>>>
>>>>>>
>>>>>> _______________________________________________
>>>>>> 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
>>>>
>>>> _______________________________________________
>>>> 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
>>
>> _______________________________________________
>> 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
-------------- next part --------------
<?php
// This file could be used instead of index.php to perform authentication.
// The list of usernames/passwords are hard coded below. (search for 'sarah')
require("config.php");
/**
*
* Login page, self posts to become management page
*
* @author Patrick Lockley
* @version 1.0
* @copyright Copyright (c) 2008,2009 University of Nottingham
* @package
*/
include $xerte_toolkits_site->php_library_path . "login_library.php";
include $xerte_toolkits_site->php_library_path . "display_library.php";
/**
* Check to see if anything has been posted to distinguish between log in attempts
*/
if((!isset($_POST["login"]))&&(!isset($_POST["password"]))){
$buffer = login_page_format_top(file_get_contents($xerte_toolkits_site->root_file_path . $xerte_toolkits_site->website_code_path . "login_top"));
$buffer .= $form_string;
$buffer .= login_page_format_bottom(file_get_contents($xerte_toolkits_site->root_file_path . $xerte_toolkits_site->website_code_path . "login_bottom"));
echo $buffer;
}
/*
* Some data has bee posted, interpret as attempt to login
*/
if ($_SERVER['REQUEST_METHOD'] == 'POST') {
/**
* Username and password left empty
*/
if(($_POST["login"]=="")&&($_POST["password"]=="")){
$buffer = login_page_format_top(file_get_contents($xerte_toolkits_site->root_file_path . $xerte_toolkits_site->website_code_path . "login_top"));
$buffer .= "<p>Please enter your username and password</p>";
$buffer .= login_page_format_bottom(file_get_contents($xerte_toolkits_site->root_file_path . $xerte_toolkits_site->website_code_path . "login_bottom"));
echo $buffer;
/*
* Username left empty
*/
}else if($_POST["login"]==""){
$buffer = login_page_format_top(file_get_contents($xerte_toolkits_site->root_file_path . $xerte_toolkits_site->website_code_path . "login_top"));
$buffer .= "<p>Please enter your username</p>";
$buffer .= login_page_format_bottom(file_get_contents($xerte_toolkits_site->root_file_path . $xerte_toolkits_site->website_code_path . "login_bottom"));
echo $buffer;
/*
* Password left empty
*/
}else if($_POST["password"]==""){
$buffer = login_page_format_top(file_get_contents($xerte_toolkits_site->root_file_path . $xerte_toolkits_site->website_code_path . "login_top"));
$buffer .= "<p>Please enter your password</p>";
$buffer .= login_page_format_bottom(file_get_contents($xerte_toolkits_site->root_file_path . $xerte_toolkits_site->website_code_path . "login_bottom"));
echo $buffer;
/*
* Password and username provided, so try to authenticate
*/
}else if(($_POST["login"]!="")&&($_POST["password"]!="")){
/*
* See if the submitted values are valid logins
*/
$authenticated = false;
function set_user_details($firstname, $surname){
$_SESSION['toolkits_firstname'] = $firstname;
$_SESSION['toolkits_surname'] = $surname;
}
switch($_POST["login"]){
case "pat": if($_POST["password"]=="patpassword"){ $authenticated = true; set_user_details("Pat","Blair");}; break;
case "john": if($_POST["password"]=="johnpassword"){ $authenticated = true; set_user_details("John","Obama"); }; break;
case "bob": if($_POST["password"]=="bobpassword"){ $authenticated = true; set_user_details("Bob","Putin"); }; break;
case "sarah": if($_POST["password"]=="sarahpassword"){ $authenticated = true; set_user_details("Sarah","Sarkozy"); }; break;
default: $authenticated = false; break;
}
if($authenticated){
/*
* Give the session its own session id
*/
$_SESSION['toolkits_sessionid'] = $session_id;
include $xerte_toolkits_site->php_library_path . "user_library.php";
$mysql_id=database_connect("index.php database connect success","index.php database connect fail");
$_SESSION['toolkits_logon_username'] = $_POST["login"];
/*
* Check to see if this is a users' first time on the site
*/
if(check_if_first_time($_SESSION['toolkits_logon_username'])){
/*
* create the user a new id
*/
$_SESSION['toolkits_logon_id'] = create_user_id($_SESSION['toolkits_logon_username'], $_SESSION['toolkits_firstname'], $_SESSION['toolkits_surname']);
/*
* create a virtual root folder for this user
*/
create_a_virtual_root_folder();
}else{
/*
* User exists so update the user settings
*/
$_SESSION['toolkits_logon_id'] = get_user_id();
update_user_logon_time();
}
recycle_bin();
/*
* Output the main page, including the user's and blank templates
*/
echo file_get_contents($xerte_toolkits_site->website_code_path . "management_headers");
echo "<script type=\"text/javascript\"> // JAVASCRIPT library for fixed variables\n // management of javascript is set up here\n // SITE SETTINGS\n";
echo "var site_url = \"" . $xerte_toolkits_site->site_url . "\";\n";
echo "var site_apache = \"" . $xerte_toolkits_site->apache . "\";\n";
echo "var properties_ajax_php_path = \"website_code/php/properties/\";\n var management_ajax_php_path = \"website_code/php/management/\";\n var ajax_php_path = \"website_code/php/\";\n";
echo file_get_contents($xerte_toolkits_site->website_code_path . "management_top");
list_users_projects("data_down");
echo logged_in_page_format_middle(file_get_contents($xerte_toolkits_site->website_code_path . "management_middle"));
list_blank_templates();
echo file_get_contents($xerte_toolkits_site->website_code_path . "management_bottom");
}else{
/*
* login has failed
*/
$buffer = login_page_format_top(file_get_contents($xerte_toolkits_site->root_file_path . $xerte_toolkits_site->website_code_path . "login_top"));
$buffer .= "<p>Sorry that password combination was not correct</p>";
$buffer .= login_page_format_bottom(file_get_contents($xerte_toolkits_site->root_file_path . $xerte_toolkits_site->website_code_path . "login_bottom"));
echo $buffer;
}
}
}
?>
</body>
</html>
More information about the Xerte
mailing list