(RADIATOR) Doesn't write sessiondb

[Hugh Irvine]

Hello Kadir -

I don't see any debug for the AuthBy SQL either, which makes me think 
there is a problem with the SQL connection to the database.

The debug message showing the database connection failure would have 
occurred earlier in the debug.

To see what is happening you should look at all of the debug messages 
including the startup messages, etc.

An easy way to do this is by running radiusd by hand in the foreground:

	perl radiusd -foreground -log_stdout -trace 4 -config_file ......

regards

Hugh


On 7 Feb 2005, at 12:54, Kadir Saruhan wrote:

> Hi,
>
> I have a problem while writing session db. You can see my config and 
> trace 4 debugging at below.
>
> It doesn’t write anything (there is no insert querry in debugging).
>
> Debugging:
>
> Mon Feb  7 00:00:00 2005: DEBUG: Handling request with Handler 
> 'Realm=DEFAULT'
>
> Mon Feb  7 00:00:00 2005: DEBUG: Rewrote user name to selmakozleme
>
> Mon Feb  7 00:00:00 2005: DEBUG: Adding session for selmakozleme, 
> 10.10.20.7, 6313
>
> Mon Feb  7 00:00:00 2005: DEBUG: Handling with Radius::AuthSQL
>
> Mon Feb  7 00:00:00 2005: DEBUG: Handling accounting with 
> Radius::AuthSQL
>
> Mon Feb  7 00:00:00 2005: DEBUG: Accounting accepted
>
> Mon Feb  7 00:00:00 2005: DEBUG: Packet dump:
>
> *** Sending to 10.10.20.7 port 2048 ....
>
> Config:
>
> <Realm DEFAULT>
>
> SessionDatabase SDB1
>
> MaxSessions 1
>
> RewriteUsername s/^([^@]+).*/$1/
>
> AuthByPolicy ContinueAlways
>
>
>
> <AuthBy SQL>
>
> FailureBackoffTime 45
>
>         AccountingStopsOnly
>
>         DBSource dbi:ODBC:DSN=RADIUS
>
>         DBUsername  radiususer
>
>         DBAuth  radiuspass
>
>
>
> AcctSQLStatement EXEC Sp_INS_AccountingLog\
>
> '%n',\
>
> '%m.%d.%Y %H:%M:%S',\
>
> '%{Acct-Status-Type}',\
>
> '%{Acct-Delay-Time}',\
>
> '%{Acct-Input-Octets}',\
>
> '%{Acct-Output-Octets}',\
>
> '%{Acct-Session-Id}',\
>
> '%{Acct-Session-Time}',\
>
> '%{Ascend-Disconnect-Cause}',\
>
> '%{NAS-IP-Address}',\
>
> '%{NAS-Port}',\
>
> '%{Framed-IP-Address}',\
>
> '%{Called-Station-Id}',\
>
> '%{Calling-Station-Id}',\
>
> '213.243.1.36:1646',\
>
> '%{Ascend-Xmit-Rate}'
>
> AcctFailedLogFileName 
> /radiator/logs/missedaccounting_1646_-%Y-%m-%d.log
>
>
>
> </AuthBy>
>
> </Realm>
>
> <SessionDatabase SQL>
>
> Identifier SDB1
>
> FailureBackoffTime 10
>
> DBSource        dbi:mysql:hostname=213.243.1.230:RADIUS
>
>         DBUsername      xxxx
>
>         DBAuth      xxxx
>
> </SessionDatabase>
>
>
>
>
>
>
>
> Kadir Saruhan
>
> DOL System Administrator
>
> ksaruhan at e-kolay.com
>
> Tel: +90 212 498 35 16
>
> Fax:+90 212 677 05 92
>     www.e-kolay.net
>
>
>
>
>
>
>
> <image.tiff>

NB:

Have you read the reference manual ("doc/ref.html")?
Have you searched the mailing list archive 
(www.open.com.au/archives/radiator)?
Have you had a quick look on Google (www.google.com)?
Have you included a copy of your configuration file (no secrets),
together with a trace 4 debug showing what is happening?

-- 
Radiator: the most portable, flexible and configurable RADIUS server
anywhere. Available on *NIX, *BSD, Windows, MacOS X.
-
Nets: internetwork inventory and management - graphical, extensible,
flexible with hardware, software, platform and database independence.
-
CATool: Private Certificate Authority for Unix and Unix-like systems.

--
Archive at http://www.open.com.au/archives/radiator/
Announcements on radiator-announce at open.com.au
To unsubscribe, email 'majordomo at open.com.au' with
'unsubscribe radiator' in the body of the message.