Re: [RADIATOR] bulk add users
On 25/05/2018 17.15, Eric W. Bates wrote: Sounds good. You mean something like phpmyadmin? I was thinking of the tools that come with the BD, for example mysqlimport for MySQL. However, if you have more tools you could use that should give you more options. https://dev.mysql.com/doc/refman/8.0/en/mysqlimport.html It looks like searching for CSV and mysqlimport or CSV and phpmyadmin both return useful looking results. Thanks, Heikki -- Heikki Vatiainen Radiator: the most portable, flexible and configurable RADIUS server anywhere. SQL, proxy, DBM, files, LDAP, TACACS+, PAM, Active Directory, EAP, TLS, TTLS, PEAP, WiMAX, RSA, Vasco, Yubikey, HOTP, TOTP, DIAMETER etc. Full source on Unix, Windows, MacOSX, Solaris, VMS, etc. ___ radiator mailing list radiator@lists.open.com.au http://lists.open.com.au/mailman/listinfo/radiator
Re: [RADIATOR] bulk add users
Sounds good. You mean something like phpmyadmin? On 5/25/2018 8:53 AM, Heikki Vatiainen wrote: On 24/05/2018 1.43, Eric W. Bates wrote: Our user support team is presented with a spreadsheet and I want to crunch that into Radiator without the need to enter each one individually. Just an idea: you could consider saving the a spreadsheet as a CSV file and then using DB's tools to import the CSV file directly. With this you may not need a script at all. Thanks, Heikki -- Clark 159a, MS 46 508/289-3112 smime.p7s Description: S/MIME Cryptographic Signature ___ radiator mailing list radiator@lists.open.com.au http://lists.open.com.au/mailman/listinfo/radiator
Re: [RADIATOR] Request for TLS_SubjectAltNameDNS check
Hi, On 02/21/2018 12:42 PM, Tuure Vartiainen wrote: how to configure this? My problem is that I need to initiate RadSec connection by IP adress this way: Identifiervsup_cz Host195.113.xx.x Secret radsec When I use HOST = IPaddress I've no option how to tell Radiator which value compare against SubjectAltName:DNS. SuljectAltName:DNS matches against configured Host, so it only works when using FQDNs. I changed the feature request to target adding TLS_SubjectAltNameDNS configuration option similar to TLS_SubjectAltNameURI. http://www.open.com.au/radiator/ref/TLS_SubjectAltNameURI.html#TLS_SubjectAltNameURI there’s now a new config option TLS_SubjectAltNameDNS in latest patches, which can be used to define expected FQDN for SubjectAltName:DNS. thanks for implementing new config option. I finally upgraded a week ago and it works perfectly. Exactly as I needed. Thank you -- --- Jan Tomasek aka Semik http://www.tomasek.cz/ ___ radiator mailing list radiator@lists.open.com.au http://lists.open.com.au/mailman/listinfo/radiator
Re: [RADIATOR] bulk add users
On 24/05/2018 1.43, Eric W. Bates wrote: Our user support team is presented with a spreadsheet and I want to crunch that into Radiator without the need to enter each one individually. Just an idea: you could consider saving the a spreadsheet as a CSV file and then using DB's tools to import the CSV file directly. With this you may not need a script at all. Thanks, Heikki -- Heikki Vatiainen Radiator: the most portable, flexible and configurable RADIUS server anywhere. SQL, proxy, DBM, files, LDAP, TACACS+, PAM, Active Directory, EAP, TLS, TTLS, PEAP, WiMAX, RSA, Vasco, Yubikey, HOTP, TOTP, DIAMETER etc. Full source on Unix, Windows, MacOSX, Solaris, VMS, etc. ___ radiator mailing list radiator@lists.open.com.au http://lists.open.com.au/mailman/listinfo/radiator