Can't connect to local MySQL server through socket
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"
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@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"
/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@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
Hello ! Koha 22.05.10.000 on debian 11. Best regards Eugen Bastron Von: linuxprosun of WIL <linuxprosun.wil@gmail.com> Datum: Montag, 17. April 2023 um 11:32 An: DHIM IT <itmanager@dhi-moskau.org> Cc: "koha@lists.katipo.co.nz" <koha@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@dhi-moskau.org<mailto:itmanager@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@lists.katipo.co.nz<mailto:Koha@lists.katipo.co.nz> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
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@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
Hello, yes, without any error. Am 18.04.23, 07:12 schrieb "Mason James" <mtj@kohaaloha.com <mailto:mtj@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> Koha@lists.katipo.co.nz <mailto:Koha@lists.katipo.co.nz> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha <https://lists.katipo.co.nz/mailman/listinfo/koha>
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@lists.katipo.co.nz <mailto:koha-bounces@lists.katipo.co.nz> im Auftrag von itmanager@dhi-moskau.org <mailto:itmanager@dhi-moskau.org>>: Hello, yes, without any error. Am 18.04.23, 07:12 schrieb "Mason James" <mtj@kohaaloha.com <mailto:mtj@kohaaloha.com> <mailto:mtj@kohaaloha.com <mailto:mtj@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@lists.katipo.co.nz <mailto:Koha@lists.katipo.co.nz> <mailto:Koha@lists.katipo.co.nz <mailto:Koha@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@lists.katipo.co.nz <mailto:Koha@lists.katipo.co.nz> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha <https://lists.katipo.co.nz/mailman/listinfo/koha>
participants (3)
-
DHIM IT -
linuxprosun of WIL -
Mason James