[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

[EP-tech] Re: "Failed to connect to database" error after transferring repository to another server

Only fairly obvious ones:
1. Is the password correct?
2. Did you 'flush privileges' in MySQL?


Mark Gregson | Application and Development Team Leader
Library eServices | Queensland University of Technology
Level 2 | I Block | Kelvin Grove Campus | GPO Box 2434 | Brisbane 4001
Phone: +61 7 3138 3782 | Web: http://eprints.qut.edu.au/
ABN: 83 791 724 622
CRICOS No: 00213J

-----Original Message-----
From: eprints-tech-bounces at ecs.soton.ac.uk [mailto:eprints-tech-bounces at ecs.soton.ac.uk] On Behalf Of Alex Birchall
Sent: Friday, 30 March 2012 9:53 PM
To: eprints-tech at ecs.soton.ac.uk
Subject: [EP-tech] "Failed to connect to database" error after transferring repository to another server


I am getting this error after I transferred the repository to another server using a tried and tested procedure:
eprints at veprints:~/bin$ ./epadmin upgrade mdxrep1
DBI connect('database=mdxrep1;host=localhost','eprints',...) failed: Access denied for user 'eprints'@'localhost' (using password: YES) at /usr/share/eprints3/bin/../perl_lib/EPrints/Database.pm line 245

Middlesex University Research
Repository has encountered an error:
Failed to connect to database
Failed to load repository: mdxrep1

There is an eprints user in MySQL and I have granted this user the same rights as root to all databases.

Any suggestion most gratefully received.



Alexander J Birchall
Library Systems Manager
The Shepppard Library
Middlesex University
The Burroughs
London NW4 4BT

Tel +44 (0) 208 411 5235
Mob 07765 237 570

*** Options: http://mailman.ecs.soton.ac.uk/mailman/listinfo/eprints-tech
*** Archive: http://www.eprints.org/tech.php/
*** EPrints community wiki: http://wiki.eprints.org/