You need to first fix the problems, then add the line. El mar, 28 jun 2022 11:43, Isabel Pineda <isabel.pin...@ds.edu.sv> escribió:
> Hi Jonathan. > > This is the error message in the syslog: > mysqld[20008]: error: Found option without preceding group in config file: > /etc/mysql/my.cnf at line: 24 > mysqld[20008]: Fatal error in defaults handling. Program aborted > mysqld[20016]: error: Found option without preceding group in config file: > /etc/mysql/my.cnf at line: 24 > mysqld[20016]: Fatal error in defaults handling. Program aborted > systemd[1]: mariadb.service: Main process exited, code=exited, > status=1/FAILURE > systemd[1]: mariadb.service: Failed with result 'exit-code'. > systemd[1]: Failed to start MariaDB 10.3.35 database server. > > I followed the instructions in > https://wiki.koha-community.org/wiki/DBMS_auto_increment_fix#Current_Solution > Probably I did something wrong when I added the line > init-file=/var/lib/mysql/init-file_koha_fix.sql > at /etc/mysql/my.cnf. The instruction says to find the [mysqld] section in > the file, but in my my.cnf file there is only one line that says: > !includedir /etc/mysql/conf.d > > For the moment I commented the new line and restarted the database, so > everything is working again, but I still have the warning about the > auto_increment. > > Thank you > Isabel > > > ---Mensaje original----- > De: Jonathan Druart <jonathan.dru...@bugs.koha-community.org> > Enviado el: martes, 28 de junio de 2022 08:06 > Para: Isabel Pineda <isabel.pin...@ds.edu.sv> > CC: koha@lists.katipo.co.nz > Asunto: Re: [Koha] After Koha update and auto_increment_fix database won't > start > > Hi Isabel, > > Search for a more precise error in the mysql/mariadb log files. Maybe you > have an error in the path? > Double check the path you entered in /etc/mysql/my.cnf and the path of the > file you created. > > Regards, > Jonathan > > Le mar. 28 juin 2022 à 15:51, Isabel Pineda <isabel.pin...@ds.edu.sv> a > écrit : > > > > Hi. > > > > I have just updated Koha from 21.11.06 to 21.11.09. After that I got a > > warning on the "About Koha" page that some tables have problems with > > auto_increment, there was a link to this page: > > https://wiki.koha-community.org/wiki/DBMS_auto_increment_fix > > I followed the instructions on this page, but when I tried to restart > > mysql, MariaDB wouldn't start. The error message says: job for > > mariadb.service failed because the control process exited with error > > code > > > > I looked for solutions, but the only ones that I found included to > remove all data from the database directory, and I don't want to do this. > > > > Is there any other solution? > > > > Thank you very much > > Isabel Pineda > > > > _______________________________________________ > > > > Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz > > Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha > _______________________________________________ > > Koha mailing list http://koha-community.org > Koha@lists.katipo.co.nz > Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha > _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha