[Koha] Can't connect to local MySQL server through socket

[DHIM IT]

Hello !


Koha 22.05.10.000 on debian 11.

Best regards
Eugen Bastron


Von: linuxprosun of WIL <linuxprosun.wil at gmail.com>
Datum: Montag, 17. April 2023 um 11:32
An: DHIM IT <itmanager at dhi-moskau.org>
Cc: "koha at lists.katipo.co.nz" <koha at lists.katipo.co.nz>
Betreff: Re: [Koha] Can't connect to local MySQL server through socket

Hello,
How many users are using it? What are the software versions??

--regards
Prosun Prodhan
+91-8100-234-555


On Mon, Apr 17, 2023 at 12:55 PM DHIM IT <itmanager at dhi-moskau.org<mailto:itmanager at dhi-moskau.org>> wrote:
Dear Collogues,

for two weeks I get an every 2-5 minute error from the cron below. I can run the commands from the cron without a problem. Also, I can connect to my database without a problem. Any ideas?


Best regards,
Eugen Bastron


DBIx::Class::Storage::DBI::catch {...} (): DBI Connection failed: DBI connect('database=koha_koha;host=localhost;port=3306','koha_koha',...) failed: Can't connect to local MySQL server through socket '/run/mysqld/mysqld.sock' (111) at /usr/share/koha/lib/Koha/Database.pm line 91. at /usr/share/koha/lib/Koha/Database.pm line 139
koha: 111 status returned by "/usr/share/koha/bin/cronjobs/process_message_queue.pl<http://process_message_queue.pl>"

/etc/cron.hourly/koha-common:
DBIx::Class::Storage::DBI::catch {...} (): DBI Connection failed: DBI connect('database=koha_koha;host=localhost;port=3306','koha_koha',...) failed: Can't connect to local MySQL server through socket '/run/mysqld/mysqld.sock' (111) at /usr/share/koha/lib/Koha/Database.pm line 91. at /usr/share/koha/lib/Koha/Database.pm line 139
koha: 111 status returned by "/usr/share/koha/bin/cronjobs/holds/build_holds_queue.pl<http://build_holds_queue.pl>"
DBIx::Class::Storage::DBI::catch {...} (): DBI Connection failed: DBI connect('database=koha_koha;host=localhost;port=3306','koha_koha',...) failed: Can't connect to local MySQL server through socket '/run/mysqld/mysqld.sock' (111) at /usr/share/koha/lib/Koha/Database.pm line 91. at /usr/share/koha/lib/Koha/Database.pm line 139
koha: 111 status returned by "/usr/share/koha/bin/cronjobs/automatic_checkin.pl<http://automatic_checkin.pl>"



_______________________________________________

Koha mailing list  http://koha-community.org
Koha at lists.katipo.co.nz<mailto:Koha at lists.katipo.co.nz>
Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha