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

[DHIM IT]

Hello again,

after I run the command sudo koha-mysql koha , the cron working again without any error. Thank you!


Am 18.04.23, 09:21 schrieb "Koha im Auftrag von DHIM IT" <koha-bounces at lists.katipo.co.nz <mailto:koha-bounces at lists.katipo.co.nz> im Auftrag von itmanager at dhi-moskau.org <mailto:itmanager at dhi-moskau.org>>:


Hello, yes, without any error. 




Am 18.04.23, 07:12 schrieb "Mason James" <mtj at kohaaloha.com <mailto:mtj at kohaaloha.com> <mailto:mtj at kohaaloha.com <mailto:mtj at kohaaloha.com>>>:




hi Eugen




you probably have a config problem with your 'koha' instance








does the following command succeed?




$ sudo koha-mysql koha












On 17/04/23 7:25 pm, DHIM IT 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"
> 
> /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"
> 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"
> 
> 
> 
> _______________________________________________
> 
> Koha mailing list http://koha-community.org <http://koha-community.org> <http://koha-community.org> <http://koha-community.org>>
> Koha at lists.katipo.co.nz <mailto:Koha at lists.katipo.co.nz> <mailto:Koha at lists.katipo.co.nz <mailto:Koha at lists.katipo.co.nz>>
> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha <https://lists.katipo.co.nz/mailman/listinfo/koha> <https://lists.katipo.co.nz/mailman/listinfo/koha> <https://lists.katipo.co.nz/mailman/listinfo/koha>>










_______________________________________________


Koha mailing list http://koha-community.org <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 <https://lists.katipo.co.nz/mailman/listinfo/koha>