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, ldjamison, mtj, mtompset, nick, tomascohen
Version:	Main
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:
Circulation function:
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 (kidclamp) 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 (tcohen) 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