koha-create --request-db should be able to accept a dbhost option and write that to koha-conf.xml When installing koha via the debian packages with the database on a separate host, as per http://wiki.koha-community.org/wiki/Install_Koha_3.6_on_Debian_squeeze_using_a_separate_MySQL_server, it is suggested that you run .. koha-create --request-db mylibrary This creates a text file with the appropriate details to use to create the mysql database, it also writes the database name, user and password into the /etc/koha/sites/mylibrary/koha-conf.xml file. But this process leaves the <hostname> unpopulated, essentially defaulting to 'localhost'. That config option has to be manually entered for a remote database host. Ideally one should be able to use .. koha-create --request-db mylibrary --dbhost databaseserver koha-create should also return details on where to change the hostname of the database server (whether the --dbhost option is used or not).
./debian/scripts/koha-create is the file that needs to be tweaked
Created attachment 64560 [details] [review] Bug 9409: Add --dbhost parameter and dbhost field This allows setting the remote db host correctly for request-db either with a command-line or passwd file.
Created attachment 64760 [details] [review] Bug 9409: Add --dbhost parameter and dbhost field This allows setting the remote db host correctly for request-db either with a command-line or passwd file. Signed-off-by: Lee Jamison <ldjamison@marywood.edu>
Thanks for the sign off, LeeJ. :)
Created attachment 65166 [details] [review] Bug 9409: Add --dbhost parameter and dbhost field This allows setting the remote db host correctly for request-db either with a command-line or passwd file. Signed-off-by: Lee Jamison <ldjamison@marywood.edu> Signed-off-by: Nick Clemens <nick@bywatersolutions.com>
Created attachment 65922 [details] [review] Bug 9409: (QA followup) Add --dbhost help to koha-create man page Signed-off-by: Tomas Cohen Arazi <tomascohen@theke.io>
Pushed to master for 17.11, thanks to everybody involved!
Pushed to 17.05.x, will be in 17.05.05.
These patches have been pushed to 16.11.x and will be in 16.11.13.
Pushed to 16.05.x, for 16.05.18 release