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

[Mason James]

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
> Koha at lists.katipo.co.nz
> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha