[Xerte] Re: Xerte Online Toolkits: Installation Guide

[Thomas Rochford]

Hi,

The problem just may be that the mtg*7 username is only configured to work
from the local host rather than the "%" wildcard within mysql. This would
mean that it works fine when installing the software on the actual server,
but it will not work when the same user name is used from anywhere else. You
can check this and reset it in phpmyadmin, as far as I recall. If this
doesn't resolve the problem then it may be a firewall issue. I can't think
of anything else at present.

Kindest Regards,
Thomas
==========================================================
Thomas Rochford, e-Learning Advisor, JISC Regional Support Centre - Eastern
Tel: 07500 669002, 01223 564749 
Eml: thomas.rochford at jiscadvance.ac.uk, 
Skype: cambridge.serendipity
RSCs - Stimulating and Supporting Innovation in Learning
RSC Eastern welcomes feedback on our services via support at rsc-eastern.ac.uk
 Please consider your environmental responsibility before printing this
e-mail





-----Original Message-----
From: xerte-bounces at lists.nottingham.ac.uk
[mailto:xerte-bounces at lists.nottingham.ac.uk] On Behalf Of MTG Judge Course
Sent: 04 January 2012 15:38
To: 'Xerte discussion list'
Subject: [Xerte] Re: Xerte Online Toolkits: Installation Guide

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