mysql table partition perl mysql_zbx_part.pl fail

[evanleeee]

Hi there,
I am a new user to zabbix
when I am setting up Partitioning a Zabbix MySQL database with Perl with ubuntu20.04 ,mysql-server 8.0.23

I follow the tutorial (https://blog.zabbix.com/partitioning...cedures/13531/)

perl /usr/share/zabbix/mysql_zbx_part.pl

shows error:
DBI connect('zabbix:mysql_socket=/var/lib/mysql/mysql.sock','zabbix',...) failed: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) at mysql_zbx_part.pl line 38.
Can't call method "prepare" on an undefined value at mysql_zbx_part.pl line 78.

what am I getting wrong?

[evanleeee]

problem solved
thanks for no one share and reply

[metal]

and thank you for not revealing the solution!!!

You are not any better person anyway...

[RafaelBotelho]

evanleeee I was having the same problem, I changed the path

/var/lib/mysql/mysql.sock

to

/var/run/mysqld/mysqld.sock

in MySQL 8.0.25, and it was ok.

But I can't run the Perl script, it even reports that version 8.0 doesn't work. As you can read on the link below:

https://github.com/OpensourceICTSolutions/zabbix-mysql-partitioning-perl

#1 The script is no longer working for MySQL 8. Use MariaDB or check the stored procedures in the guide below.

Did you manage to run Perl script on MySQL 8.0, if yes, how?

Thanks!