Bug 9409

Summary: koha-create --request-db should be able to accept a dbhost option
Product: Koha Reporter: Ian Beardslee <ian>
Component: Installation and upgrade (command-line installer)Assignee: Mark Tompsett <mtompset>
Status: CLOSED FIXED QA Contact:
Severity: normal    
Priority: P5 - low CC: fridolin.somers, katrin.fischer, ldjamison, mtj, mtompset, nick, tomascohen
Version: master   
Hardware: All   
OS: All   
See Also: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=16690
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18564
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=14533
Change sponsored?: --- Patch complexity: ---
Documentation contact: Documentation submission:
Text to go in the release notes:
Version(s) released in:
Bug Depends on:    
Bug Blocks: 18877    
Attachments: Bug 9409: Add --dbhost parameter and dbhost field
Bug 9409: Add --dbhost parameter and dbhost field
Bug 9409: Add --dbhost parameter and dbhost field
Bug 9409: (QA followup) Add --dbhost help to koha-create man page

Description Ian Beardslee 2013-01-16 21:18:59 UTC
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).
Comment 1 Ian Beardslee 2013-01-17 01:06:15 UTC
./debian/scripts/koha-create is the file that needs to be tweaked
Comment 2 Mark Tompsett 2017-06-23 01:49:09 UTC
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.
Comment 3 Lee Jamison 2017-06-30 16:28:35 UTC
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>
Comment 4 Mark Tompsett 2017-07-01 03:25:57 UTC
Thanks for the sign off, LeeJ. :)
Comment 5 Nick Clemens 2017-07-21 10:32:05 UTC
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>
Comment 6 Tomás Cohen Arazi 2017-08-11 18:09:40 UTC
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>
Comment 7 Jonathan Druart 2017-08-15 15:28:38 UTC
Pushed to master for 17.11, thanks to everybody involved!
Comment 8 Fridolin Somers 2017-09-29 10:18:11 UTC
Pushed to 17.05.x, will be in 17.05.05.
Comment 9 Katrin Fischer 2017-10-01 22:14:52 UTC
These patches have been pushed to 16.11.x and will be in 16.11.13.
Comment 10 Mason James 2017-11-23 22:08:14 UTC
Pushed to 16.05.x, for 16.05.18 release