[Xerte] Re: Xerte Online Toolkits: Installation Guide

[Pat Lockley]

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