(RADIATOR) mysql authorization

[Rogelio Alvarado Anchisi]

Thanks Hugh and Paul, I had to write it all again and finnally got it to
run properly.

-----Original Message-----
From: owner-radiator at open.com.au [mailto:owner-radiator at open.com.au] On
Behalf Of Hugh Irvine
Sent: Domingo, 22 de Agosto de 2004 17:15
To: Rogelio Alvarado Anchisi
Cc: radiator at open.com.au
Subject: Re: (RADIATOR) mysql authorization


Hello Rogelio -

There are no radius requests shown in the debug, so I would guess that 
either the port numbers are incorrect (Radiator defaults to 1645/1646), 
or you you have firewall or filter issues blocking the radius requests 
from reaching Radiator.

regards

Hugh


On 22 Aug 2004, at 02:57, Rogelio Alvarado Anchisi wrote:

> I have a problem when trying to test my users on the mysql database
>
> I’m going to show you my conf file.
>
>  
>
> Foreground
>
> LogStdout
>
> LogDir  /var/log/radius
>
> DbDir   /etc/radiator
>
> Trace           4
>
> <Monitor>
>
>         Username Rush
>
>         Password Monkey
>
> </Monitor>
>
>  
>
> <ClientListSQL>
>
>         DBSource        dbi:mysql:radius
>
>         DBUsername      root
>
>         DBAuth          rastafari
>
> </ClientListSQL>
>
>  
>
> <Realm DEFAULT>
>
>         <AuthBy SQL>
>
>                 DBSource        dbi:mysql:radius
>
>                 DBUsername      radiator
>
>                 DBAuth          rastafari
>
>                 AccountingTable ACCOUNTING
>
>                 AcctColumnDef   USERNAME,User-Name
>
>                 AcctColumnDef   TIME_STAMP,Timestamp,integer
>
>                 AcctColumnDef   ACCTSTATUSTYPE,Acct-Status-Type
>
>                 AcctColumnDef   ACCTDELAYTIME,Acct-Delay-Time,integer
>
>                 AcctColumnDef   
> ACCTINPUTOCTETS,Acct-Input-Octets,integer
>
>                 AcctColumnDef   
> ACCTOUTPUTOCTETS,Acct-Output-Octets,integer
>
>                 AcctColumnDef   ACCTSESSIONID,Acct-Session-Id
>
>                 AcctColumnDef   
> ACCTSESSIONTIME,Acct-Session-Time,integer
>
>                 AcctColumnDef 
 ACCTTERMINATECAUSE,Acct-Terminate-Cause
>
>                 AcctColumnDef   NASIDENTIFIER,NAS-Identifier
>
>                 AcctColumnDef   NASPORT,NAS-Port,integer
>
>                 AcctColumnDef   FRAMEDIPADDRESS,Framed-IP-Address
>
>                 SQLRecoveryFile %D/missedaccounting
>
>         </AuthBy>
>
>  
>
>         ##<AuthBy FILE>
>
>         ##      Filename %D/users
>
>         ##</AuthBy>
>
>         ## Log accounting to a detail file
>
>         ##AcctLogFileName       %L/detail
>
> </Realm>
>
>  
>
> It’s supposed that by default it will seek the users in the 
> SUBSCRIBERS database
>
> And my debug says:
>
>  
>
> Sat Aug 21 11:41:01 2004: DEBUG: Adding Clients from SQL database
>
> Sat Aug 21 11:41:01 2004: DEBUG: Query is: 'select
>
>         NASIDENTIFIER,
>
>         SECRET,
>
>         IGNOREACCTSIGNATURE,
>
>         DUPINTERVAL,
>
>         DEFAULTREALM,
>
>         NASTYPE,
>
>         SNMPCOMMUNITY,
>
>         LIVINGSTONOFFS,
>
>         LIVINGSTONHOLE,
>
>         FRAMEDGROUPBASEADDRESS,
>
>         FRAMEDGROUPMAXPORTSPERCLASSC,
>
>         REWRITEUSERNAME,
>
>         NOIGNOREDUPLICATES,
>
>         PREHANDLERHOOK from RADCLIENTLIST':
>
>  
>
> Sat Aug 21 11:41:01 2004: DEBUG: Finished reading configuration file 
> '/etc/radiator/radius.cfg'
>
> Sat Aug 21 11:41:01 2004: DEBUG: Reading dictionary file 
> '/etc/radiator/dictionary'
>
>  
>
>  
>
> So I guess it is connecting to my mySql server
 but what am I lacking 
> here?
>
> Rogelio Alvarado Anchisi
>
> Galaxy Communications Corp
>
> Tel: +507-2000128
>  Tel: +507-2000100
>
> Cel: +507-6744093
>
> Fax: +507-2000132
>
>  
>
>  
>

NB: 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.


--
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.