[Koha-bugs] [Bug 23141] The Debian scripts do not use the myql portnumber

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

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

--- Comment #11 from Andreas Jonsson <andreas.jonsson at kreablo.se> ---
The database connection details have three different purposes: 1. to create the
database and database user 2. to set the connection details in koha-conf.xml
and 3. to load data.

There are five different sources for acquiring the connection details: 1.
command line, 2. password file, 3. /etc/mysql/koha-common.cnf (if
/etc/myslq/debian.cnf exists!?) 4. koha-conf.xml and 5. default values.

So, to add support for port number we could:

1. Add command line parameter for portnumber
2. Add an optional field to the password file
3. Parse port number from /etc/mysql/koha-common.cnf
4. Add command line flag to select which source should have priority when
loading data.

But then there is also the question on how to prioritize which source should be
used in what situation.  For my particular use case I need to use the
connection details of koha-conf.xml when populating the database.

But when using the credentials from the instance configuration it would be
better to call koha-mysql.  I suggest adding the parameter --defaultsql-creds
for this purpose.

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