EPrints Technical Mailing List Archive

See the EPrints wiki for instructions on how to join this mailing list and related information.

Message: #10339

< Previous (by date) | Next (by date) > | < Previous (in thread) | Next (in thread) > | Messages - Most Recent First | Threads - Most Recent First

Re: [EP-tech] Installing EPrints database using different server

CAUTION: This e-mail originated outside the University of Southampton.
Hi,
In addition to Peter's points: 

4. If you are using SELinux, make sure httpd can connect to the database:
    setsebool -P httpd_can_network_connect_db 1

5. It's easier to create the database on the remote server first (as root), grant the eprints db_user appropriate permissions, and then run:
    [EPRINTS_ROOT]/bin/epadmin create_tables [ARCHIVE_ID]
from the application server (unless you're migrating an existing database).

Cheers,
John


From: eprints-tech-request@ecs.soton.ac.uk <eprints-tech-request@ecs.soton.ac.uk> on behalf of Peter Edwards <P.L.Edwards@leeds.ac.uk>
Sent: Monday, March 16, 2026 10:59
To: eprints-tech@ecs.soton.ac.uk <eprints-tech@ecs.soton.ac.uk>
Subject: Re: [EP-tech] Installing EPrints database using different server

CAUTION: External Message. Use caution opening links and attachments.

CAUTION: This e-mail originated outside the University of Southampton.

CAUTION: This e-mail originated outside the University of Southampton.

You will also need to ensure the database is accessible from the EPrints host:

1. make sure mysql has networking enabled and that it is listening on a port
2. make sure the firewall of the database server is configured to allow traffic from the EPrints host to the MySQL port (ideally ONLY from this host)
3. make sure your eprints database users are allowed to connect from the EPrints host


Peter Edwards
Application Support Analyst
University of Leeds


________________________________________
From: eprints-tech-request@ecs.soton.ac.uk <eprints-tech-request@ecs.soton.ac.uk> on behalf of Alan.Stiles [He/Him/They] <alan.stiles@open.ac.uk>
Sent: 16 March 2026 09:33
To: eprints-tech@ecs.soton.ac.uk
Subject: Re: [EP-tech] Installing EPrints database using different server

CAUTION: External Message. Use caution opening links and attachments.

CAUTION: This e-mail originated outside the University of Southampton.
CAUTION: This e-mail originated outside the University of Southampton.
Hi,
It’s very straightforward.  I think you can specify the database connection when you first set up eprints (it’s been a while since I did it) or alternatively you can update the details in <EPRINTS_ROOT>/archives/<ARCHIVE_ID>/cfg/cfg.d/database.pl to specify the db-host.
https://eur03.safelinks.protection.outlook.com/?url="">

Instead of localhost, provide the fully qualified domain name of that server.

Alan


From: eprints-tech-request@ecs.soton.ac.uk <eprints-tech-request@ecs.soton.ac.uk> on behalf of Agung Prasetyo W. <prazetyo@gmail.com>
Date: Monday, 16 March 2026 at 07:26
To: eprints-tech@ecs.soton.ac.uk <eprints-tech@ecs.soton.ac.uk>
Subject: [EP-tech] Installing EPrints database using different server


External email: if the sender or content looks suspicious, please click the Report Message icon, or forward it to report-phishing

CAUTION: This e-mail originated outside the University of Southampton.
CAUTION: This e-mail originated outside the University of Southampton.
Hi,

I'd like to ask if it's possible to install ePrints using a MySQL database on a different server. Has anyone successfully done this? I've never done it before, as I only have one server for both the application and the database.

Thank you.

Regards,
Agung PW