[Xerte] Re: MYSQL access denied error

[Pat Lockley]

XOT when setting up goes to the database twice

Once with the account that has create rights
Once with insert rights

The insert rights are the same account as the connect account.

Is there a database.php file in the root folder?

Pat

On Thu, Apr 5, 2012 at 11:40 AM, James Burns
<JBurns at kirkleescollege.ac.uk> wrote:
> Hi, thanks for your help on this…
>
>
>
> I have just tried the following to re-specify the password :-
>
>
>
> --------------------------snip----------------------------------------------
>
> root at lamp ~# mysql -u root -p
>
> Enter password:
>
> Welcome to the MySQL monitor.  Commands end with ; or \g.
>
> Your MySQL connection id is 76
>
> Server version: 5.1.61-0ubuntu0.10.04.1-log (Ubuntu)
>
>
>
> Copyright (c) 2000, 2011, Oracle and/or its affiliates. All rights reserved.
>
>
>
> Oracle is a registered trademark of Oracle Corporation and/or its
>
> affiliates. Other names may be trademarks of their respective
>
> owners.
>
>
>
> Type 'help;' or '\h' for help. Type '\c' to clear the current input
> statement.
>
>
>
> mysql> use mysql;
>
> Reading table information for completion of table and column names
>
> You can turn off this feature to get a quicker startup with -A
>
>
>
> Database changed
>
> mysql> UPDATE user SET Password=PASSWORD(‘########’) WHERE user='root';
> (password blanked out for this…)
>
> Query OK, 0 rows affected (0.00 sec)
>
> Rows matched: 2  Changed: 0  Warnings: 0
>
>
>
> mysql> FLUSH PRIVILEGES;
>
> Query OK, 0 rows affected (0.00 sec)
>
> --------------------------------snip--------------------------------------------------------
>
>
>
> I still get same error (even if I also restart mysql).
>
>
>
> I was wondering if the password itself could be the issue, but changing this
> to a basic test password has made no apparent difference.
>
>
>
> Just to clarify – the installation itself of Xerte was seemingly successful.
> It is only the subsequent access for testing of xerte which is giving the
> error.
>
>
>
> LDAP PHP option is installed, configured for xerte and pointing to LDAP
> source of other server – that is why I am trying to test with demo.php to
> take this out of the equation as the cause of the issue..I can’t access
> “management.php” either with same error.
>
>
>
>
>
>
>
>
>
> This email and any attachments are confidential and should not be used by
> anyone who is not the original intended recipient. If you receive this in
> error, please contact the sender and delete the material from your computer.
> You are not authorised to, and must not, read, copy, distribute, use or
> retain this message or any part of it. Kirklees College cannot accept
> liability for any statements made which are clearly the sender's own and not
> expressly made on behalf of Kirklees College or one of its agents.
>
> KIRKLEES COLLEGE
> YOUR SUCCESS IS OUR FOCUS
>
> Please consider the environment. Don't print this e-mail unless necessary.
>
> 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.
>
>