[Koha-bugs] [Bug 24351] During Installation, connection to remote mysql server fails

[bugzilla-daemon at bugs.koha-community.org]

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=24351

David Nind <david at davidnind.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |david at davidnind.com

--- Comment #3 from David Nind <david at davidnind.com> ---
Hopefully this will point you in the right direction to solve the problem you
are having:
https://wiki.koha-community.org/wiki/Install_Koha_3.6_on_Debian_squeeze_using_a_separate_MySQL_server

While it mentions Koha 3.6 I think it is still mostly correct.

Instead of using the sudo koha-create --create-db <libraryname> command you
need to follow these steps:

1. sudo koha-create --request-db <libraryname>
2. Follow the instructions in the file created: create the database with the
user name and password on your remote database server and set the required
permissions.
3. Test that you can connect to the remote mysql server from your Koha server,
for example: sudo mysql -u <username> -p -h <host-name-or-ip-address>. (Some
database servers may be setup to not allow remote access, you will need to sort
that out. You will need to install the database client packages on your Koha
server.)
4. Populate the database: koha-create --populate-db <libraryname>
5. Carry on with your Koha installation...

If this doesn't work, I would post a message to the Koha mailing list or try
the IRC channel.

If it does work, please post a comment as appropriate.

Notes:

* You may need to revert any changes you may have made, such as changes to
my.cnf or Apache
* You will need to delete the instance you have created: sudo koha-remove
<libraryname>
* I assume you didn't mean you were installing on Debian 4.9 (a very very old
version of Debian)
* I will look at testing these steps properly when I get a chance and
incorporating these instructions or updating them into the main guide available
at https://wiki.koha-community.org/wiki/Koha_on_Debian

-- 
You are receiving this mail because:
You are the assignee for the bug.
You are watching all bug changes.