Re: (RADIATOR) Change to mySQL
Hi, After a few minor hiccups I managed to get Radiator writing Accounting data to a mySQL database. All seemed to be working brilliantly until I discovered that customers connecting via Commindico virtual ports couldn't authenticate whereas customers connecting via our own access servers were getting through. I revereted to my old radius.cfg and all was fine again but of course no mySQL data. Any suggestions? Barry Andersson === Archive at http://www.open.com.au/archives/radiator/ Announcements on [EMAIL PROTECTED] To unsubscribe, email '[EMAIL PROTECTED]' with 'unsubscribe radiator' in the body of the message.
Re: (RADIATOR) Change to mySQL
Hi, Correction to my previous email. I left the "-" out of integer-date > I just noticed that you have not configured your DBSource line in the AuthBy > SQL clause (which I had asumed you had done). I'm now saving accounting records to mySQL except the timestamp is being written as -00-00 00:00:00 for every session (ie a null value) I have the following line in the AuthBy SQL clause: AcctColumnDef DATETIME,Timestamp, integer-date Barry === Archive at http://www.open.com.au/archives/radiator/ Announcements on [EMAIL PROTECTED] To unsubscribe, email '[EMAIL PROTECTED]' with 'unsubscribe radiator' in the body of the message.
Re: (RADIATOR) Change to mySQL
Hi, > I just noticed that you have not configured your DBSource line in the AuthBy > SQL clause (which I had asumed you had done). I'm now saving accounting records to mySQL except the timestamp is being written as -00-00 00:00:00 for every session (ie a null value) I have the following line in the AuthBy SQL clause: AcctColumnDef DATETIME,Timestamp, integer date Barry === Archive at http://www.open.com.au/archives/radiator/ Announcements on [EMAIL PROTECTED] To unsubscribe, email '[EMAIL PROTECTED]' with 'unsubscribe radiator' in the body of the message.
Re: (RADIATOR) Change to mySQL
Hi, OK, I've setup the radius.cfg and mySQL databases. When I start Radiator I get the following error in /var/log/radius/logfile "Can't connect (radius # #), no database driver specified in DBI_DSN env var not set at Radius/SqlDb.pm line 124" Suggestions? Barry Andersson === Archive at http://www.open.com.au/archives/radiator/ Announcements on [EMAIL PROTECTED] To unsubscribe, email '[EMAIL PROTECTED]' with 'unsubscribe radiator' in the body of the message.
Re: (RADIATOR) Change to mySQL
Hello Barry - On Thursday 22 November 2001 11:20, Barry Andersson wrote: > Hi, > > I'm just about ready to start logging accounting requests to a mySQL > database. I've setup the following AuthBy SQL in my radius.cfg. > > My question is I would like to save the timestamp as a datetime format > rather than integer. Do I have my AcctColumnDef set correctly to do that? > > > Identifier SQLAccounting > DBSource radius > DBUsername ### > DBAuth ### > AuthSelect > AccountingTable ACCOUNTING > AccountingStopsOnly > AcctColumnDef USERNAME,UserName > AcctColumnDef DATETIME,timestamp,datetime > AcctColumnDef ACCTINPUTOCTETS,Acct-Input-Octets,integer > AcctColumnDef ACCTOUTPUTOCTETS,Acct-Output-Octets,integer > AcctColumnDef ACCTSESSIONTIME,Acct-Session-Time,integer > AcctColumnDef ACCTTERMINATECAUSE,Acct-Terminate-Cause > AcctColumnDef ACCTTERMINATECAUSE,Ascend-Disconnect-Cause > AcctColumnDef CONNECTSPEED,Acc-Connect-Tx-Speed,integer > > This is how to format the AcctColumnDef: AcctColumnDef DATETIME,Timestamp,integer-date and of course the DATETIME column will have to be correctly set up in the database. Have a look at section 6.28.13 in the Radiator 2.19 reference manual (included in the distribution in the file "doc/ref.html"). regards Hugh -- Radiator: the most portable, flexible and configurable RADIUS server anywhere. Available on *NIX, *BSD, Windows 95/98/2000, NT, MacOS X. - Nets: internetwork inventory and management - graphical, extensible, flexible with hardware, software, platform and database independence. === Archive at http://www.open.com.au/archives/radiator/ Announcements on [EMAIL PROTECTED] To unsubscribe, email '[EMAIL PROTECTED]' with 'unsubscribe radiator' in the body of the message.