How to make Attribute name to be integer64

[Philemon Jaomalaza]

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
-
List info/subscribe/unsubscribe? See http://www.fre

[Alan DeKok]

Post by Philemon Jaomalaza
When I start : Freeradius -X
/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 ?

Don't re-use an existing attribute. ChilliSpot-Max-Total-Octets already has a meaning. You can't change it.

Instead, use a new attribute name. The module will then create it for you.

Alan DeKok.


-
List info/subscribe/unsubscribe? See http://www.freeradi

[Philemon Jaomalaza]

How to use a new attribute name ? where can I add it ?

-----Message d'origine-----
De : Freeradius-Users [mailto:freeradius-users-bounces+philemon.jaomalaza=***@lists.freeradius.org] De la part de Alan DeKok
Envoyé : vendredi 16 novembre 2018 02:53
À : FreeRadius users mailing list <freeradius-***@lists.freeradius.org>
Objet : Re: How to make Attribute name to be integer64

Post by Philemon Jaomalaza
When I start : Freeradius -X
/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 ?

Don't re-use an existing attribute. ChilliSpot-Max-Total-Octets already has a meaning. You can't change it.

Instead, use a new attribute name. The module will then create it for you.

Alan DeKok.


-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html


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


-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/us

[Alan DeKok]

Post by Philemon Jaomalaza
How to use a new attribute name ? where can I add it ?
Instead, use a new attribute name. The module will then create it for you.

Just use a new name instead of ChilliSpot-Max-Total-Octets. You add it in the module configuration instead of using ChilliSpot-Max-Total-Octets.

Alan DeKok.


-
List info/subscribe/unsubscribe? See http://

[Johnny R]

I am not sure if it's applicable (it has been awhile) but I would check
into the dictionary and define the new attribute there. You might wanna
check :
https://networkradius.com/doc/3.0.10/concepts/dictionary/creating_vsas.html
an example, and https://freeradius.org/radiusd/man/dictionary.html or
https://networkradius.com/doc/3.0.10/concepts/dictionary/introduction.html
for more details :) . that's my two cents.

v4s[at]#unrelated | "sh3ll is just the beginning"




On Sat, Nov 17, 2018 at 2:27 PM Philemon Jaomalaza <

Post by Philemon Jaomalaza
How to use a new attribute name ? where can I add it ?
-----Message d'origine-----
De : Freeradius-Users [mailto:freeradius-users-bounces+philemon.jaomalaza=
Envoyé : vendredi 16 novembre 2018 02:53
Objet : Re: How to make Attribute name to be integer64
On Nov 15, 2018, at 4:45 PM, Philemon Jaomalaza <

Post by Philemon Jaomalaza
When I start : Freeradius -X
/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 ?

Don't re-use an existing attribute. ChilliSpot-Max-Total-Octets already
has a meaning. You can't change it.
Instead, use a new attribute name. The module will then create it for you.
Alan DeKok.
-
List info/subscribe/unsubscribe? See
http://www.freeradius.org/list/users.html
---
L'absence de virus dans ce courrier électronique a été vérifiée par le
logiciel antivirus Avast.
https://www.avast.com/antivirus
-
List info/subscribe/unsubscribe? See
http://www.freeradius.org/list/users.html

-
List info/subscribe/unsubscribe? S