Hi Klaas,
Do the log provide any hints / error that can put us on the right track?
Should that not help, can you please enable debug on the pmacct side
(that is: -d or "debug: true") to see if anything more helpful pops up
in the logs?
A total personal comment: sql_num_hosts is surely good to optimize stuff
if you are forced into the MySQL / MariaDB world. But if you care about
optimization and getting the right operands over the IP fields, ie.
netmask operations and stuff, look into PostgreSQL.
Paolo
On 31/5/21 14:17, Klaas Tammling wrote:
Hi everyone,
I'm having some trouble using sql_num_hosts with nfacctd. I have
converted all relevant columns (ip_dst, ip_src, net_src, net_dst) to
VARBINARY(16) in my MariaDB.
However when writing into the database nfacctd only writes NULL values
into the database. When setting sql_num_hosts to the default I'm getting
the values back as a string.
Am I missing something additional here?
I was hoping to get a better performance, using sql_num_hosts, when
searching through the database.
Thanks for your help.
Regards,
Klaas
_______________________________________________
pmacct-discussion mailing list
http://www.pmacct.net/#mailinglists
_______________________________________________
pmacct-discussion mailing list
http://www.pmacct.net/#mailinglists
