Re: Persistent MySQL connections to arbitrary databases

2011-02-11 Thread Jonathan Gazeley
Well, I solved my own problem by creating another instance of the sql module... sql myVlanDB { database = "mysql" driver = "rlm_sql_${database}" server = "db.resnet.bris.ac.uk" port = 3306 login = "radiusd" password = "" radius_db = "VLANS" } ...and then qu

Re: Persistent MySQL connections to arbitrary databases

2011-02-09 Thread Alexander Clouter
Jonathan Gazeley wrote: > >> However, why do you need to close the handle? Just when you open it, do >> your work, store it to the side in a hash and mark it available for use >> (remember to add locking as it sounds like your script is threaded). > > Please excuse the ignorance - can you elabor

Re: Persistent MySQL connections to arbitrary databases

2011-02-09 Thread Jonathan Gazeley
On 02/09/2011 10:33 AM, Alexander Clouter wrote: However, why do you need to close the handle? Just when you open it, do your work, store it to the side in a hash and mark it available for use (remember to add locking as it sounds like your script is threaded). Please excuse the ignorance - ca

Re: Persistent MySQL connections to arbitrary databases

2011-02-09 Thread Alexander Clouter
Jonathan Gazeley wrote: > > I am asking about MySQL connections to a database *other than* the usual > radius database. > > For one of my wireless SSIDs, part of the authorization process invokes > a perl script which opens a MySQL handle to a different database, does a > query, destroys the h

Re: Persistent MySQL connections to arbitrary databases

2011-02-09 Thread Alan DeKok
Jonathan Gazeley wrote: > I want radiusd to open the handles at startup, in the same way that it > already opens its own handles. Read the "example.pl" file: # If you are using DBI and do some queries to DB, please be sure to # use the CLONE function to initialize the DBI connection to DB. >

Re: Persistent MySQL connections to arbitrary databases

2011-02-09 Thread Jonathan Gazeley
On 02/09/2011 10:38 AM, Alan DeKok wrote: Jonathan Gazeley wrote: What's the approved method for making radiusd open persistent connections to an arbitrary database, and then using these handles from a perl module? Use static variables in the Perl code. This is really a Perl question. I'

Re: Persistent MySQL connections to arbitrary databases

2011-02-09 Thread Alan DeKok
Jonathan Gazeley wrote: > What's the approved method for making radiusd open persistent > connections to an arbitrary database, and then using these handles from > a perl module? Use static variables in the Perl code. This is really a Perl question. Alan DeKok. - List info/subscribe/unsubscr

Persistent MySQL connections to arbitrary databases

2011-02-09 Thread Jonathan Gazeley
I am asking about MySQL connections to a database *other than* the usual radius database. For one of my wireless SSIDs, part of the authorization process invokes a perl script which opens a MySQL handle to a different database, does a query, destroys the handle, and returns the value to radius