[Koha-bugs] [Bug 23329] tracklinks.pl accepts any url from a parameter for proxying if not tracking

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

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

--- Comment #86 from Marcel de Rooy <m.de.rooy at rijksmuseum.nl> ---
>From David Cook on koha-devel:

I was looking at
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=23329#c85 where
Jonathan points out under MySQL 8 that we’re now getting this error with
dumping the database:

“mysqldump: Error: 'Access denied; you need (at least one of) the PROCESS
privilege(s) for this operation' when trying to dump tablespaces”

I’ve seen this pop a few times myself on Koha projects, and it looks like it
traces back to the security notes listed here:
https://dev.mysql.com/doc/relnotes/mysql/5.7/en/news-5-7-31.html

“Incompatible Change: Access to the INFORMATION_SCHEMA.FILES table now requires
the PROCESS privilege.”

“This change affects users of the mysqldump command, which accesses tablespace
information in the FILES table, and thus now requires the PROCESS privilege as
well. Users who do not need to dump tablespace information can work around this
requirement by invoking mysqldump with the --no-tablespaces option. (Bug
#30350829)”

I haven’t looked into it too deeply yet, but I imagine adding the
--no-tablespaces option to mysqldump in koha-dump is the way to go.

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