How to make Attribute name to be integer64

15 Nov 2018

      Hello,

I have on sqlcounter :

               sqlcounter counterChilliSpotMaxTotalOctetsAll {

        sql_module_instance = sql

        dialect = ${modules.sql.dialect}

            counter_name = ChilliSpot-Max-Total-Octets

                                            check_name = CS-Total-Octets

                                            counter-type = data

                                            reply_name =
ChilliSpot-Max-Total-Octets

                                            key = User-Name

                                            reset = never

                                            query = "SELECT
IFNULL((SUM(AcctInputOctets + AcctOutputOctets)),0) FROM radacct WHERE
UserName='%%{${key}' AND UNIX_TIMESTAMP(AcctStartTime) + AcctSessionTime >
'%%b'"

               }

When I start : Freeradius -X

I have this error :

/etc/freeradius/3.0/mods-enabled/sqlcounter[357]: Counter attribute
ChilliSpot-Max-Total-Octets MUST be integer64

/etc/freeradius/3.0/mods-enabled/sqlcounter[357]: Instantiation failed for
module "counterChilliSpotMaxTotalOctetsAll"

How can I solve this ?

JMLZ

---
L'absence de virus dans ce courrier électronique a été vérifiée par le logiciel antivirus Avast.
https://www.avast.com/antivirus

How to make Attribute name to be integer64

Philemon Jaomalaza