[Koha] Suddenly can't check in items

[Michael Kuhn]

Hi drojup

 > For example I was able to edit the my.cnf file but I don't know where
 > to add the line:
 > nit-file=/var/lib/mysql/init-file_koha_fix.sql

I hope you are on a Debian host, using package installation.

In case you are not using MySQL but MariaDB, the file you are searching 
for is "/etc/mysql/mariadb.conf.d/50-server.cnf".

The line you want to add in section "[mysqld]" reads (note the starting 
"i"):

init-file=/var/lib/mysql/init-file_koha_fix.sql

Hope this helps

Best wishes: Michael
-- 
Geschäftsführer · Diplombibliothekar BBS, Informatiker eidg. Fachausweis
Admin Kuhn GmbH · Pappelstrasse 20 · 4123 Allschwil · Schweiz
T 0041 (0)61 261 55 61 · E mik at adminkuhn.ch · W www.adminkuhn.ch



Am 24.07.19 um 18:14 schrieb Doug Dearden:
> Hey Drojup,
> 
> Look in /etc/mysql/mysql.conf.d
> You should find several files in there that end in .cnf, one of which will be server.cnf .  It might have a number or other characters before the server.cnf.  I am using mariadb instead of mysql, and mine says 50-server.cnf .  Check that file, I believe you will find the mysqld section in there.
> 
> Doug
> 
> -----Original Message-----
> From: Koha [mailto:koha-bounces at lists.katipo.co.nz] On Behalf Of drojup
> Sent: Wednesday, July 24, 2019 3:28 AM
> To: koha at lists.katipo.co.nz
> Subject: Re: [Koha] Suddenly can't check in items
> 
> These are the contentes of the file: /etc/mysql/my.cnf
> 
> # You can copy this to one of:
> # - "/etc/mysql/my.cnf" to set global options,
> # - "~/.my.cnf" to set user-specific options.
> #
> # One can use all long options that the program supports.
> # Run program with --help to get a list of available options and with
> # --print-defaults to see which it would actually understand and use.
> #
> # For explanations see
> # http://dev.mysql.com/doc/mysql/en/server-system-variables.html
> 
> #
> # * IMPORTANT: Additional settings that can override those from this file!
> #   The files must end with '.cnf', otherwise they'll be ignored.
> #
> 
> !includedir /etc/mysql/conf.d/
> !includedir /etc/mysql/mysql.conf.d/
> 
> I can't locate the [mysqld] section
> 
> 
> 
> 
> --
> Sent from: http://koha.1045719.n5.nabble.com/Koha-general-f3047918.html
> _______________________________________________
> Koha mailing list  http://koha-community.org
> Koha at lists.katipo.co.nz
> https://lists.katipo.co.nz/mailman/listinfo/koha
> _______________________________________________
> Koha mailing list  http://koha-community.org
> Koha at lists.katipo.co.nz
> https://lists.katipo.co.nz/mailman/listinfo/koha
>